12:12:00,342 DEBUG [SessionImpl] Creating root
12:12:00,384 DEBUG [PersistenceContext] Queued documents for asynchronous fulltext extraction: 1
12:12:00,389 DEBUG [PersistenceContext] Saving persistence context
12:12:00,390 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', NULL, NULL, '', false, 'Root', NULL, NULL, NULL, NULL)
12:12:00,393 TRACE [Mapper] (1) SQL: INSERT INTO "ACLS" ("ID", "POS", "NAME", "GRANT", "PERMISSION", "USER", "GROUP") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', 0, 'local', true, 'Everything', 'administrators', NULL)
12:12:00,395 TRACE [Mapper] (1) SQL: INSERT INTO "ACLS" ("ID", "POS", "NAME", "GRANT", "PERMISSION", "USER", "GROUP") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', 1, 'local', true, 'Everything', 'Administrator', NULL)
12:12:00,396 TRACE [Mapper] (1) SQL: INSERT INTO "ACLS" ("ID", "POS", "NAME", "GRANT", "PERMISSION", "USER", "GROUP") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', 2, 'local', true, 'Read', 'members', NULL)
12:12:00,396 TRACE [Mapper] (1) SQL: INSERT INTO "ACLS" ("ID", "POS", "NAME", "GRANT", "PERMISSION", "USER", "GROUP") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', 3, 'local', true, 'Version', 'members', NULL)
12:12:00,397 TRACE [Mapper] (1) SQL: INSERT INTO "FULLTEXT" ("ID", "SIMPLETEXT", "BINARYTEXT", "SIMPLETEXT_TITLE", "BINARYTEXT_TITLE") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', '', NULL, '', NULL)
12:12:00,462 DEBUG [PersistenceContext] End of save
12:12:00,463 TRACE [Mapper] (1) SQL: INSERT INTO "REPOSITORIES" ("ID", "NAME") VALUES ('55ea93e5-946f-4c7d-af55-03c90d2b3f3a', 'default')
12:12:00,626 DEBUG [PersistenceContext] Queued documents for asynchronous fulltext extraction: 1
12:12:00,626 DEBUG [PersistenceContext] Saving persistence context
12:12:00,627 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', '55ea93e5-946f-4c7d-af55-03c90d2b3f3a', NULL, 'doc', false, 'TestDocument', NULL, NULL, NULL, NULL)
12:12:00,628 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('946857a6-be44-4cfd-b340-d70a88feae64', 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', NULL, 'tp:externalcontent', true, 'externalcontent', NULL, NULL, NULL, NULL)
12:12:00,629 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('bea72dc0-4fbf-41f3-ac1c-e8a95b82b5d2', 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', NULL, 'tp:complex', true, 'complexType', NULL, NULL, NULL, NULL)
12:12:00,630 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('322a961c-2d95-4ca1-8ae1-5670a7c66116', 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', NULL, 'tp:complexChain', true, 'complexChain', NULL, NULL, NULL, NULL)
12:12:00,631 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('518a3afc-c8b4-4ca8-a17d-5b24829a9827', '322a961c-2d95-4ca1-8ae1-5670a7c66116', NULL, 'complex', true, 'complexType', NULL, NULL, NULL, NULL)
12:12:00,632 TRACE [Mapper] (1) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('98a8a0bb-4021-48c7-b09c-4ca4214b1f6a', 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, 'tp:complexList', true, 'complexType', NULL, NULL, NULL, NULL)
12:12:00,633 TRACE [Mapper] (1) SQL: INSERT INTO "COMPLEXCHAIN" ("ID", "STRING") VALUES ('322a961c-2d95-4ca1-8ae1-5670a7c66116', NULL)
12:12:00,634 TRACE [Mapper] (1) SQL: INSERT INTO "EXTERNALCONTENT" ("ID", "ENCODING", "URI", "LENGTH", "DIGEST", "NAME", "MIME-TYPE") VALUES ('946857a6-be44-4cfd-b340-d70a88feae64', NULL, NULL, NULL, NULL, NULL, NULL)
12:12:00,635 TRACE [Mapper] (1) SQL: INSERT INTO "FULLTEXT" ("ID", "SIMPLETEXT", "BINARYTEXT", "SIMPLETEXT_TITLE", "BINARYTEXT_TITLE") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 'foo bar foo', NULL, '', NULL)
12:12:00,640 TRACE [Mapper] (1) SQL: INSERT INTO "TP_DATEARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, TIMESTAMP '2008-07-10T12:12:00+02:00')
12:12:00,642 TRACE [Mapper] (1) SQL: INSERT INTO "COMPLEXTYPE" ("ID", "STRING", "INT", "DATE") VALUES ('98a8a0bb-4021-48c7-b09c-4ca4214b1f6a', 'foo', 3, TIMESTAMP '2008-07-10T12:12:00+02:00')
12:12:00,642 TRACE [Mapper] (1) SQL: INSERT INTO "COMPLEXTYPE" ("ID", "STRING", "INT", "DATE") VALUES ('518a3afc-c8b4-4ca8-a17d-5b24829a9827', NULL, NULL, NULL)
12:12:00,643 TRACE [Mapper] (1) SQL: INSERT INTO "COMPLEXTYPE" ("ID", "STRING", "INT", "DATE") VALUES ('bea72dc0-4fbf-41f3-ac1c-e8a95b82b5d2', NULL, NULL, NULL)
12:12:00,644 TRACE [Mapper] (1) SQL: INSERT INTO "MISC" ("ID", "LIFECYCLEPOLICY", "LIFECYCLESTATE", "DIRTY", "WFINPROGRESS", "WFINCOPTION") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 'undefined', 'undefined', true, NULL, NULL)
12:12:00,645 TRACE [Mapper] (1) SQL: INSERT INTO "TP_STRINGARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, 'foo')
12:12:00,645 TRACE [Mapper] (1) SQL: INSERT INTO "TP_STRINGARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 1, 'bar')
12:12:00,646 DEBUG [PersistenceContext] End of save
12:12:00,652 DEBUG [EventBundleTransactionHandler] No TransactionManager
12:12:00,653 DEBUG [AsyncEventExecutor$Job] Async listener executed, commited tx
12:12:27,860 DEBUG [AbstractSession] Destroying core session ...
12:12:30,842 TRACE [ServiceManager] Known services[]
12:12:30,845 TRACE [RepositoryManager] Entering getRepository : test
12:12:31,173 TRACE [Mapper] (2) SQL: SELECT "ID" FROM "REPOSITORIES" WHERE "NAME" = 'default'
12:12:31,206 TRACE [Mapper] (2) SQL:   -> id=55ea93e5-946f-4c7d-af55-03c90d2b3f3a
12:12:31,210 TRACE [Mapper] (2) SQL: SELECT "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION" FROM "HIERARCHY" WHERE "ID" = '55ea93e5-946f-4c7d-af55-03c90d2b3f3a'
12:12:31,213 TRACE [Mapper] (2) SQL:   -> parentid=NULL, pos=NULL, name='', isproperty=false, primarytype='Root', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:31,217 TRACE [Mapper] (2) SQL: SELECT "VALID", "ISSUED", "COVERAGE", "TITLE", "MODIFIED", "CREATOR", "RIGHTS", "LANGUAGE", "EXPIRED", "CREATED", "SOURCE", "DESCRIPTION", "FORMAT" FROM "DUBLINCORE" WHERE "ID" = '55ea93e5-946f-4c7d-af55-03c90d2b3f3a'
12:12:31,221 TRACE [Mapper] (2) SQL: SELECT "LIFECYCLEPOLICY", "LIFECYCLESTATE", "DIRTY", "WFINPROGRESS", "WFINCOPTION" FROM "MISC" WHERE "ID" = '55ea93e5-946f-4c7d-af55-03c90d2b3f3a'
12:12:31,225 TRACE [Mapper] (2) SQL: SELECT "ICON", "ICON-EXPANDED", "SIZE" FROM "COMMON" WHERE "ID" = '55ea93e5-946f-4c7d-af55-03c90d2b3f3a'
12:12:31,920 TRACE [Mapper] (2) SQL: SELECT "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION" FROM "HIERARCHY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:31,925 TRACE [Mapper] (2) SQL:   -> parentid='55ea93e5-946f-4c7d-af55-03c90d2b3f3a', pos=NULL, name='doc', isproperty=false, primarytype='TestDocument', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:31,930 TRACE [Mapper] (2) SQL: SELECT "LIFECYCLEPOLICY", "LIFECYCLESTATE", "DIRTY", "WFINPROGRESS", "WFINCOPTION" FROM "MISC" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:31,933 TRACE [Mapper] (2) SQL:   -> lifecyclepolicy='undefined', lifecyclestate='undefined', dirty=true, wfinprogress=NULL, wfincoption=NULL
12:12:31,936 TRACE [Mapper] (2) SQL: SELECT "LOCK" FROM "LOCKS" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:31,940 TRACE [Mapper] (2) SQL: SELECT "POS", "ITEM" FROM "TP_DATEARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c' ORDER BY "POS"
12:12:31,945 TRACE [Mapper] (2) SQL:   -> [java.util.GregorianCalendar[time=1215684720585,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="Europe/Paris",offset=3600000,dstSavings=3600000,useDaylight=true,transitions=184,lastRule=java.util.SimpleTimeZone[id=Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0,startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=3600000,startTimeMode=2,endMode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=3600000,endTimeMode=2]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2008,MONTH=6,WEEK_OF_YEAR=28,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=192,DAY_OF_WEEK=5,DAY_OF_WEEK_IN_MONTH=2,AM_PM=1,HOUR=0,HOUR_OF_DAY=12,MINUTE=12,SECOND=0,MILLISECOND=585,ZONE_OFFSET=3600000,DST_OFFSET=3600000]]
12:12:31,970 TRACE [Mapper] (2) SQL: SELECT "POS", "ITEM" FROM "TP_STRINGARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c' ORDER BY "POS"
12:12:31,975 TRACE [Mapper] (2) SQL:   -> [foo, bar]
12:12:31,978 TRACE [Mapper] (2) SQL: SELECT "ID", "POS", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION" FROM "HIERARCHY" WHERE "PARENTID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c' AND "NAME" = 'tp:externalcontent' AND "ISPROPERTY" = 1
12:12:31,982 TRACE [Mapper] (2) SQL:   -> id='946857a6-be44-4cfd-b340-d70a88feae64', pos=NULL, primarytype='externalcontent', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:31,986 TRACE [Mapper] (2) SQL: SELECT "ENCODING", "URI", "LENGTH", "DIGEST", "NAME", "MIME-TYPE" FROM "EXTERNALCONTENT" WHERE "ID" = '946857a6-be44-4cfd-b340-d70a88feae64'
12:12:31,989 TRACE [Mapper] (2) SQL:   -> encoding=NULL, uri=NULL, length=NULL, digest=NULL, name=NULL, mime-type=NULL
12:12:31,993 TRACE [Mapper] (2) SQL: SELECT "ID", "POS", "NAME", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION" FROM "HIERARCHY" WHERE "PARENTID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c' AND "ISPROPERTY" = true
12:12:32,000 TRACE [Mapper] (2) SQL:   -> id='946857a6-be44-4cfd-b340-d70a88feae64', pos=NULL, name='tp:externalcontent', primarytype='externalcontent', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:32,003 TRACE [Mapper] (2) SQL:   -> id='bea72dc0-4fbf-41f3-ac1c-e8a95b82b5d2', pos=NULL, name='tp:complex', primarytype='complexType', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:32,007 TRACE [Mapper] (2) SQL:   -> id='322a961c-2d95-4ca1-8ae1-5670a7c66116', pos=NULL, name='tp:complexChain', primarytype='complexChain', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:32,010 TRACE [Mapper] (2) SQL:   -> id='98a8a0bb-4021-48c7-b09c-4ca4214b1f6a', pos=0, name='tp:complexList', primarytype='complexType', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:32,013 TRACE [Mapper] (2) SQL: SELECT "POS", "ITEM" FROM "TP_INTARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c' ORDER BY "POS"
12:12:32,017 TRACE [Mapper] (2) SQL:   -> []
12:12:32,021 TRACE [Mapper] (2) SQL: SELECT "STRING", "INT", "DATE" FROM "COMPLEXTYPE" WHERE "ID" = 'bea72dc0-4fbf-41f3-ac1c-e8a95b82b5d2'
12:12:32,024 TRACE [Mapper] (2) SQL:   -> string=NULL, int=NULL, date=NULL
12:12:32,028 TRACE [Mapper] (2) SQL: SELECT "STRING", "INT", "DATE" FROM "COMPLEXTYPE" WHERE "ID" = '98a8a0bb-4021-48c7-b09c-4ca4214b1f6a'
12:12:32,032 TRACE [Mapper] (2) SQL:   -> string='foo', int=3, date=TIMESTAMP '2008-07-10T12:12:00+02:00'
12:12:32,036 TRACE [Mapper] (2) SQL: SELECT "STRING" FROM "COMPLEXCHAIN" WHERE "ID" = '322a961c-2d95-4ca1-8ae1-5670a7c66116'
12:12:32,039 TRACE [Mapper] (2) SQL:   -> string=NULL
12:12:32,043 TRACE [Mapper] (2) SQL: SELECT "ID", "POS", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION" FROM "HIERARCHY" WHERE "PARENTID" = '322a961c-2d95-4ca1-8ae1-5670a7c66116' AND "NAME" = 'complex' AND "ISPROPERTY" = 1
12:12:32,050 TRACE [Mapper] (2) SQL:   -> id='518a3afc-c8b4-4ca8-a17d-5b24829a9827', pos=NULL, primarytype='complexType', ischeckedin=NULL, baseversionid=NULL, majorversion=NULL, minorversion=NULL
12:12:32,053 TRACE [Mapper] (2) SQL: SELECT "STRING", "INT", "DATE" FROM "COMPLEXTYPE" WHERE "ID" = '518a3afc-c8b4-4ca8-a17d-5b24829a9827'
12:12:32,057 TRACE [Mapper] (2) SQL:   -> string=NULL, int=NULL, date=NULL
12:12:33,084 DEBUG [PersistenceContext] Queued documents for asynchronous fulltext extraction: 1
12:12:33,089 DEBUG [PersistenceContext] Saving persistence context
12:12:33,092 TRACE [Mapper] (2) SQL: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION") VALUES ('558c8607-a50e-47a3-8c4c-4d170a04c145', 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, 'tp:complexList', true, 'complexType', NULL, NULL, NULL, NULL)
12:12:33,102 TRACE [Mapper] (2) SQL: UPDATE "FULLTEXT" SET "SIMPLETEXT_TITLE" = '', "SIMPLETEXT" = 'foo bar foo' WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:33,130 TRACE [Mapper] (2) SQL:   -> 1 row
12:12:33,132 TRACE [Mapper] (2) SQL: DELETE FROM "HIERARCHY" WHERE "ID" = '98a8a0bb-4021-48c7-b09c-4ca4214b1f6a'
12:12:33,162 TRACE [Mapper] (2) SQL:   -> 1 row
12:12:33,164 TRACE [Mapper] (2) SQL: DELETE FROM "TP_DATEARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:33,169 TRACE [Mapper] (2) SQL:   -> 1 row
12:12:33,172 TRACE [Mapper] (2) SQL: INSERT INTO "TP_DATEARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, TIMESTAMP '2008-07-10T12:12:00+02:00')
12:12:33,175 TRACE [Mapper] (2) SQL: DELETE FROM "COMPLEXTYPE" WHERE "ID" = '98a8a0bb-4021-48c7-b09c-4ca4214b1f6a'
12:12:33,178 TRACE [Mapper] (2) SQL: INSERT INTO "COMPLEXTYPE" ("ID", "STRING", "INT", "DATE") VALUES ('558c8607-a50e-47a3-8c4c-4d170a04c145', 'foo', 3, TIMESTAMP '2008-07-10T12:12:00+02:00')
12:12:33,181 TRACE [Mapper] (2) SQL: DELETE FROM "TP_INTARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:33,184 TRACE [Mapper] (2) SQL: DELETE FROM "TP_STRINGARRAY" WHERE "ID" = 'e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c'
12:12:33,187 TRACE [Mapper] (2) SQL:   -> 2 rows
12:12:33,190 TRACE [Mapper] (2) SQL: INSERT INTO "TP_STRINGARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 0, 'foo')
12:12:33,192 TRACE [Mapper] (2) SQL: INSERT INTO "TP_STRINGARRAY" ("ID", "POS", "ITEM") VALUES ('e7edf8c2-686f-4b77-8fb4-6cbeabf2c80c', 1, 'bar')
12:12:33,195 DEBUG [PersistenceContext] End of save
12:12:33,198 DEBUG [EventBundleTransactionHandler] No TransactionManager
12:12:33,198 DEBUG [AsyncEventExecutor$Job] Async listener executed, commited tx