You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by sxm <sx...@yahoo.com> on 2009/10/07 01:49:52 UTC
Performance of workspace copy
We have a requirement where we need to copy thousands of child nodes from one
node to another. This becomes really slow and unusable when no. of nodes
grow from 400 to 2000.
I tried to caputre mysql query log for one node copy operation. This looks
awfully big. Does this indicate anything wrong we have in our setup?
438 Connect root@localhost on
438 Init DB dversion
438 Query SET NAMES utf8
438 Query SET character_set_results = NULL
438 Query SHOW VARIABLES
438 Query SHOW COLLATION
438 Query SET autocommit=1
438 Query SET sql_mode='STRICT_TRANS_TABLES'
438 Query SET autocommit=0
438 Query SHOW FULL TABLES FROM `dversion` LIKE
'jackrabbit_version_node'
438 Prepare [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values (?, ?)
438 Prepare [2] update JACKRABBIT_VERSION_NODE set NODE_DATA = ?
where NODE_ID = ?
438 Prepare [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
where NODE_ID = ?
438 Prepare [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = ?
438 Prepare [5] delete from JACKRABBIT_VERSION_NODE where NODE_ID
= ?
438 Prepare [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values (?, ?)
438 Prepare [7] update JACKRABBIT_VERSION_PROP set PROP_DATA = ?
where PROP_ID = ?
438 Prepare [8] select PROP_DATA from JACKRABBIT_VERSION_PROP
where PROP_ID = ?
438 Prepare [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = ?
438 Prepare [10] delete from JACKRABBIT_VERSION_PROP where PROP_ID
= ?
438 Prepare [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
NODE_ID) values (?, ?)
438 Prepare [12] update JACKRABBIT_VERSION_REFS set REFS_DATA = ?
where NODE_ID = ?
438 Prepare [13] select REFS_DATA from JACKRABBIT_VERSION_REFS
where NODE_ID = ?
438 Prepare [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = ?
438 Prepare [15] delete from JACKRABBIT_VERSION_REFS where NODE_ID
= ?
438 Prepare [16] insert into JACKRABBIT_VERSION_BINVAL
(BINVAL_DATA, BINVAL_ID) values (?, ?)
438 Prepare [17] update JACKRABBIT_VERSION_BINVAL set BINVAL_DATA
= ? where BINVAL_ID = ?
438 Prepare [18] select BINVAL_DATA from JACKRABBIT_VERSION_BINVAL
where BINVAL_ID = ?
438 Prepare [19] select 1 from JACKRABBIT_VERSION_BINVAL where
BINVAL_ID = ?
438 Prepare [20] delete from JACKRABBIT_VERSION_BINVAL where
BINVAL_ID = ?
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
438 Execute [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
where NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
439 Connect root@localhost on
439 Init DB dversion
439 Query SET NAMES utf8
439 Query SET character_set_results = NULL
439 Query SHOW VARIABLES
439 Query SHOW COLLATION
439 Query SET autocommit=1
439 Query SET sql_mode='STRICT_TRANS_TABLES'
439 Query SET autocommit=0
439 Query SHOW FULL TABLES FROM `dversion` LIKE
'jackrabbit_thed_node'
439 Prepare [1] insert into JACKRABBIT_THED_NODE (NODE_DATA,
NODE_ID) values (?, ?)
439 Prepare [2] update JACKRABBIT_THED_NODE set NODE_DATA = ?
where NODE_ID = ?
439 Prepare [3] select NODE_DATA from JACKRABBIT_THED_NODE where
NODE_ID = ?
439 Prepare [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
?
439 Prepare [5] delete from JACKRABBIT_THED_NODE where NODE_ID = ?
439 Prepare [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values (?, ?)
439 Prepare [7] update JACKRABBIT_THED_PROP set PROP_DATA = ?
where PROP_ID = ?
439 Prepare [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = ?
439 Prepare [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
?
439 Prepare [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
?
439 Prepare [11] insert into JACKRABBIT_THED_REFS (REFS_DATA,
NODE_ID) values (?, ?)
439 Prepare [12] update JACKRABBIT_THED_REFS set REFS_DATA = ?
where NODE_ID = ?
439 Prepare [13] select REFS_DATA from JACKRABBIT_THED_REFS where
NODE_ID = ?
439 Prepare [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
= ?
439 Prepare [15] delete from JACKRABBIT_THED_REFS where NODE_ID =
?
439 Prepare [16] insert into JACKRABBIT_THED_BINVAL (BINVAL_DATA,
BINVAL_ID) values (?, ?)
439 Prepare [17] update JACKRABBIT_THED_BINVAL set BINVAL_DATA = ?
where BINVAL_ID = ?
439 Prepare [18] select BINVAL_DATA from JACKRABBIT_THED_BINVAL
where BINVAL_ID = ?
439 Prepare [19] select 1 from JACKRABBIT_THED_BINVAL where
BINVAL_ID = ?
439 Prepare [20] delete from JACKRABBIT_THED_BINVAL where
BINVAL_ID = ?
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'cafebabe-cafe-babe-cafe-babecafebabe'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'deadbeef-cafe-babe-cafe-babecafebabe'
439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
NODE_ID = 'deadbeef-cafe-babe-cafe-babecafebabe'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'cafebabe-cafe-babe-cafe-babecafebabe'
439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
NODE_ID = 'cafebabe-cafe-babe-cafe-babecafebabe'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
NODE_ID = 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'567b14d7-3673-47af-9d99-f12861bd717f'
439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
NODE_ID = '567b14d7-3673-47af-9d99-f12861bd717f'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}isCheckedOut'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}isCheckedOut'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}versionHistory'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}versionHistory'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'deadbeef-face-babe-cafe-babecafebabe/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [8] select PROP_DATA from JACKRABBIT_VERSION_PROP
where PROP_ID =
'deadbeef-face-babe-cafe-babecafebabe/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = 'a8697be4-2d7e-40ed-82f7-bcd11ea3f190'
438 Execute [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
where NODE_ID = 'a8697be4-2d7e-40ed-82f7-bcd11ea3f190'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values ('\0{internal}versionStoragefi≠æÔ˙Œ∫æ ˛∫æ
˛∫æ\0\n-457304826\0\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0{}cf¡xØJ5KEØπ°´¥‘÷Qò',
'f41fd434-dbe8-4e36-b331-b4fbec092c67')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0{internal}versionStorage',
'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values ('\0{internal}versionStorageÙ ‘4€ËN6≥1¥˚Ï
,g\0\n-457304826\0\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0{}07ú‘J\'xAØÜüt‚Ê\"íq',
'c178af4a-354b-45af-b9a1-abb4d4d65198')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0{internal}versionStorage',
'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values
('\0{internal}versionStorage¡xØJ5KEØπ°´¥‘÷Qò\0\n-457304826\0\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0&{}47cf07c7-38b9-4ab7-b47e-47f3105dc7bc»‰C≈;ÈIQäN∞8Dy∏…',
'9cd4194a-2778-41af-869f-74e2e6229271')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0{internal}versionStorage',
'9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values
('\0-{http://www.jcp.org/jcr/nt/1.0}versionHistoryú‘J\'xAØÜüt‚Ê\"íq\0
453704611\0\0\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/1.0}versionableUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0\0\0\0){http://www.jcp.org/jcr/1.0}versionLabelsŸ
Ã|¿FéºØ‚å\'z\'4\0\'{http://www.jcp.org/jcr/1.0}rootVersion°EW‰G†<¿º¯?
‡', 'c8e443c5-3be9-4951-8a4e-b0384479b8c9')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0-{http://www.jcp.org/jcr/nt/1.0}versionHistory',
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0
217130042\0\0\0\0\0\0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values
('\0,{http://www.jcp.org/jcr/nt/1.0}versionLabels»‰C≈;ÈIQäN∞8Dy∏…\0\n-740395034\0\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0',
'd91c06cc-7cc0-468e-bcaf-e28c277a2734')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0,{http://www.jcp.org/jcr/nt/1.0}versionLabels',
'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values
('\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-529143834\0\0\0\0\0\0\0\0\0\0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0\0&{http://www.jcp.org/jcr/1.0}frozenNodeäéÓµ,¿F>≠G˛©åYë',
'a1455712-e404-4710-a03c-c0bcf83f1fe0')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0&{http://www.jcp.org/jcr/nt/1.0}version',
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n1168274971\0\0\0\0\0\0\0\0
2009-10-02T00:22:35.517-07:00',
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0 \0\n1273143658\0\0\0\0\0\0',
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0 \0-6226323\0\0\0\0\0\0',
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values ('\0){http://www.jcp.org/jcr/nt/1.0}frozenNode°EW‰G†<¿º¯?
‡\0\n-486997456\0\0\0\0\0\0\0\0\0\0,{http://www.jcp.org/jcr/1.0}frozenMixinTypes\0&{http://www.jcp.org/jcr/1.0}frozenUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0-{http://www.jcp.org/jcr/1.0}frozenPrimaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0\0\0\0',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0){http://www.jcp.org/jcr/nt/1.0}frozenNode',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$8a8eeeb5-2cc0-463e-ad47-fea98c591891',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1745170734\0\0\0\0\0\0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1931306613\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0
-1734300174\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes')
438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
'\0{internal}versionStoragefi≠æÔ ˛∫æ ˛∫æ
˛∫æ\0\n1994195451\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0{}56®i{‰-~@Ìǘº—
£Òê\0{}47Ù ‘4€ËN6≥1¥˚Ï ,g' where NODE_ID =
'deadbeef-face-babe-cafe-babecafebabe'
438 Query commit
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd91c06cc-7cc0-468e-bcaf-e28c277a2734'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'd91c06cc-7cc0-468e-bcaf-e28c277a2734'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'9cd4194a-2778-41af-869f-74e2e6229271'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'9cd4194a-2778-41af-869f-74e2e6229271'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c178af4a-354b-45af-b9a1-abb4d4d65198'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c178af4a-354b-45af-b9a1-abb4d4d65198'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'f41fd434-dbe8-4e36-b331-b4fbec092c67'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'f41fd434-dbe8-4e36-b331-b4fbec092c67'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}mixinTypes'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}mixinTypes'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}steps'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}steps'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}author'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}author'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}baseVersion'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}baseVersion'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}documentlink'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}documentlink'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}title'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}title'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}creationdate'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}creationdate'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'567b14d7-3673-47af-9d99-f12861bd717f/{}comments'
439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}comments'
439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
= 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
= 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [1] insert into JACKRABBIT_THED_NODE (NODE_DATA,
NODE_ID) values
('\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØÆHü6fl¬\0
-1603354723\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0\0\0\0\0\r\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0*{http://www.jcp.org/jcr/1.0}versionHistory\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0{}steps\0{}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0{}documentlink\0{}title\0{}creationdate\0\n{}comments\0\0\0\0',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n1284956073\0\0\0\0\0\0\0\0true',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}isCheckedOut')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0
\0\0\n-299049193\0\0\0\0\0\0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}versionHistory')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0
-1755740157\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}mixinTypes')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0
\0\n1928532486\0\0\0\0\0\0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\0b<steps
maxId=\"1\">\n <step id=\"1\" orderId=\"1\" detail=\"afd\" data=\"asdfwe\"
result=\"adqwer\"/>\n</steps>',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}steps')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\02',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}author')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0 \0\0
-1600436894\0\0\0\0\0\0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}primaryType')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}uuid')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\0none',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}documentlink')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\0Untitled',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}title')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\0
2009-10-02T00:21:52.936-07:00',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}creationdate')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 806470580\0\0\0\0\0\0\0\0\0',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}comments')
439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
'\0+{http://www.jcp.org/jcr/nt/1.0}unstructured ˛∫æ ˛∫æ ˛∫æ ˛∫æ\0
-1603354723\0\0\0\0\0\0\0\0\0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0{}3V{◊6sGØùôÒ(aΩq\0{}36Gœ«8πJ∑¥~GÛ]«º'
where NODE_ID = 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
439 Query commit
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
NODE_ID) values
('\0\0\0\0O47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}versionHistory',
'c8e443c5-3be9-4951-8a4e-b0384479b8c9')
438 Query commit
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
NODE_ID) values
('\0\0\0\0M47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors\0L47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion',
'a1455712-e404-4710-a03c-c0bcf83f1fe0')
438 Query commit
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 -1920423584\0\0\0\0\0\0\0\0true',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep')
439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0 514073364\0\0\0\0\0\0\0\0root',
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner')
439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
'\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØÆHü6fl¬\0
-1603354723\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0\0\0\0\0*{http://www.jcp.org/jcr/1.0}versionHistory\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0&{http://www.jcp.org/jcr/1.0}lockIsDeep\0%{http://www.jcp.org/jcr/1.0}lockOwner\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0{}steps\0{}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0{}documentlink\0
{http://www.jcp.org/jcr/1.0}uuid\0{}title\0{}creationdate\0\n{}comments\0\0\0\0'
where NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
439 Query commit
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\0none' where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}documentlink'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\02' where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}author'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\0 2009-10-02T00:21:52.936-07:00' where
PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}creationdate'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\0b<steps maxId=\"1\">\n <step id=\"1\"
orderId=\"1\" detail=\"afd\" data=\"asdfwe\" result=\"adqwer\"/>\n</steps>'
where PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}steps'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\0Untitled' where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}title'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0 806470580\0\0\0\0\0\0\0#Copied from release 1, test case: 3'
where PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}comments'
439 Query commit
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values
('\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-763947774\0\0\0\0\0\0\0\0\0\0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0\0&{http://www.jcp.org/jcr/1.0}frozenNodeÑÿnæiVE4ΩêØ2ì≤”',
'ea5109cc-6bda-4602-aa34-507bd32c7572')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0&{http://www.jcp.org/jcr/nt/1.0}version',
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572',
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n1168274971\0\0\0\0\0\0\0\0
2009-10-02T00:22:35.673-07:00',
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0
\0\n1273143658\0\0\0\0\0\0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0 \0-6226323\0\0\0\0\0\0',
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors')
438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
NODE_ID) values ('\0){http://www.jcp.org/jcr/nt/1.0}frozenNodeÍQ
Ãk⁄F™4P{”,ur\0\n-486997456\0\0\0\0\0\0\0\0\0\r\0*{http://www.jcp.org/jcr/1.0}versionHistory\0,{http://www.jcp.org/jcr/1.0}frozenMixinTypes\0&{http://www.jcp.org/jcr/1.0}frozenUuid\0({http://www.jcp.org/jcr/1.0}predecessors\0{}steps\0{}author\0\'{http://www.jcp.org/jcr/1.0}primaryType\0-{http://www.jcp.org/jcr/1.0}frozenPrimaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0{}documentlink\0{}title\0{}creationdate\0\n{}comments\0\0\0\0',
'84d86ebe-6956-4534-bd90-af329301b2d3')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1266667140\0\0\0\0\0\0\0\0){http://www.jcp.org/jcr/nt/1.0}frozenNode',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1377012443\0\0\0\0\0\0\0\0$84d86ebe-6956-4534-bd90-af329301b2d3',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1745170734\0\0\0\0\0\0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values
('\0\0\0\0\0\n1931306613\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0
-1734300174\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0
\0\0\n-539289332\0\0\0\0\0\0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0
\0\n-539289331\0\0\0\0\0\0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\0b<steps
maxId=\"1\">\n <step id=\"1\" orderId=\"1\" detail=\"afd\" data=\"asdfwe\"
result=\"adqwer\"/>\n</steps>',
'84d86ebe-6956-4534-bd90-af329301b2d3/{}steps')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\02',
'84d86ebe-6956-4534-bd90-af329301b2d3/{}author')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\0none',
'84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\0Untitled',
'84d86ebe-6956-4534-bd90-af329301b2d3/{}title')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\0
2009-10-02T00:21:52.936-07:00',
'84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate')
438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
PROP_ID) values ('\0\0\0\0\0\n-539289332\0\0\0\0\0\0\0\0#Copied from
release 1, test case: 3', '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments')
438 Execute [7] update JACKRABBIT_VERSION_PROP set PROP_DATA =
'\0\0\0 \0-6226323\0\0\0\0\0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572'
where PROP_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
'\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-529143834\0\0\0\0\0\0\0\0\0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0\0&{http://www.jcp.org/jcr/1.0}frozenNodeäéÓµ,¿F>≠G˛©åYë'
where NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
'\0-{http://www.jcp.org/jcr/nt/1.0}versionHistoryú‘J\'xAØÜüt‚Ê\"íq\0
453704611\0\0\0\0\0\0\0\0\0+{http://www.jcp.org/jcr/1.0}versionableUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0\0\0\0){http://www.jcp.org/jcr/1.0}versionLabelsŸ
Ã|¿FéºØ‚å\'z\'4\0\'{http://www.jcp.org/jcr/1.0}rootVersion°EW‰G†<¿º¯?
‡\0{}1.0ÍQ Ãk⁄F™4P{”,ur' where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
438 Query commit
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
'84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
438 Execute [13] select REFS_DATA from JACKRABBIT_VERSION_REFS
where NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [13] select REFS_DATA from JACKRABBIT_THED_REFS where
NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
= 'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0 \0\0
-1600436894\0\0\0\0\0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572' where
PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0\0\0\n1284956073\0\0\0\0\0\0\0false' where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}isCheckedOut'
439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
'\0\0\0 \0\n1928532486\0\0\0\0\0' where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors'
439 Query commit
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Execute [15] delete from JACKRABBIT_VERSION_REFS where NODE_ID
= 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
438 Query commit
438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
NODE_ID = 'ea5109cc-6bda-4602-aa34-507bd32c7572'
438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
NODE_ID) values
('\0\0\0\0L47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion',
'ea5109cc-6bda-4602-aa34-507bd32c7572')
438 Query commit
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
439 Execute [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
'47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
'\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØÆHü6fl¬\0
-1603354723\0\0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0\0\0\0\r\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0*{http://www.jcp.org/jcr/1.0}versionHistory\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0{}steps\0{}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
{http://www.jcp.org/jcr/1.0}uuid\0{}documentlink\0\n{}comments\0{}creationdate\0{}title\0\0\0\0'
where NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
439 Query commit
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'ea5109cc-6bda-4602-aa34-507bd32c7572'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'a1455712-e404-4710-a03c-c0bcf83f1fe0'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
439 Query rollback
439 Quit
438 Query rollback
438 Quit
I have also tried it indexing disabled without any visible improvements. We
are currently using 1.4.9.
--
View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25778413.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Performance of workspace copy
Posted by Guo Du <mr...@gmail.com>.
On Thu, Oct 8, 2009 at 12:12 AM, sxm <sx...@yahoo.com> wrote:
>
> Guo,
>
> Avg time for copy is 250 msec per node which increases as total number of
> nodes copied increases. We use workspace.copy(fromNodePath, toNodePath) for
> each node that need to be copied.
The avg time spend on copy one node looks bad. I didn't use
workspace.copy and not sure it's performance.
As Stefan suggested, try derby db, remove versionability, use small
number of node to establish the base line. And then increase the node
number to see how the avg was affected.
Good luck!
-Guo
Re: Performance of workspace copy
Posted by sxm <sx...@yahoo.com>.
Guo,
Avg time for copy is 250 msec per node which increases as total number of
nodes copied increases. We use workspace.copy(fromNodePath, toNodePath) for
each node that need to be copied.
-Shailesh
Guo Du wrote:
>
> On Wed, Oct 7, 2009 at 2:19 PM, sxm <sx...@yahoo.com> wrote:
>>
>> thanks Stefan, great suggestions. Could you please comment on [2]
>>
>> 1. I tried
>> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager, no
>> visible performance improvement.
>> 2. Binary data: We dont have any binary data. How can we be sure and
>> disable
>> the binary properties.
>> 3. We will try dataStore. Although, performance gains may not be
>> significant
>> as it appears to be using only two connections for the entire
>> transaction.
>> 4. Versionability is the basic requirement.
>> 5. Switching db also is not an option in short term, we certainly
>> consider
>> it for long term solution.
>>
>> -Shailesh
>
> Copy a big number of node into memory without commit to db, it may
> have big performance impact.
>
> If you copy 400 node taken 4 seconds, then copy 2000 node may taken
> little longer than 20 seconds. If it's much longer, you may review the
> way how it was copied.
>
> -Guo
>
>
--
View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25796027.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Performance of workspace copy
Posted by Guo Du <mr...@gmail.com>.
On Wed, Oct 7, 2009 at 2:19 PM, sxm <sx...@yahoo.com> wrote:
>
> thanks Stefan, great suggestions. Could you please comment on [2]
>
> 1. I tried
> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager, no
> visible performance improvement.
> 2. Binary data: We dont have any binary data. How can we be sure and disable
> the binary properties.
> 3. We will try dataStore. Although, performance gains may not be significant
> as it appears to be using only two connections for the entire transaction.
> 4. Versionability is the basic requirement.
> 5. Switching db also is not an option in short term, we certainly consider
> it for long term solution.
>
> -Shailesh
Copy a big number of node into memory without commit to db, it may
have big performance impact.
If you copy 400 node taken 4 seconds, then copy 2000 node may taken
little longer than 20 seconds. If it's much longer, you may review the
way how it was copied.
-Guo
Re: Performance of workspace copy
Posted by sxm <sx...@yahoo.com>.
You were right about 1, (something must have been wrong when I previously
tried)
Significant improvement with MySqlPersistenceManager (almost 10 fold gain) ,
Here are two new issues with this approach.
1. Performance deteriorates (6-8 times) as the no. of child nodes increase
beyond 4K (our typical use case is around 10K child nodes under a parent
node and in some cases may go up to 50 k)
2. How to migrate existing data from SimpleDB to MySqlPersistenceManager. We
need to bring versions along. Any commercial or open source options
available?
-Shailesh
Stefan Guggisberg wrote:
>
> On Wed, Oct 7, 2009 at 3:19 PM, sxm <sx...@yahoo.com> wrote:
>>
>> thanks Stefan, great suggestions. Could you please comment on [2]
>>
>> 1. I tried
>> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager, no
>> visible performance improvement.
>
> that's hard to believe. can you provide a mysql query log (20-40 lines
> would be enough)?
>
>> 2. Binary data: We dont have any binary data. How can we be sure and
>> disable
>> the binary properties.
>
> create your own, domain-specific node types.
>
>> 3. We will try dataStore. Although, performance gains may not be
>> significant
>> as it appears to be using only two connections for the entire
>> transaction.
>
> if you don't store binary properties, you don't need the DataStore.
>
>
> cheers
> stefan
>
>> 4. Versionability is the basic requirement.
>> 5. Switching db also is not an option in short term, we certainly
>> consider
>> it for long term solution.
>>
>> -Shailesh
>>
>>
>> Stefan Guggisberg wrote:
>>>
>>> hi anonymous,
>>>
>>> On Wed, Oct 7, 2009 at 1:49 AM, sxm <sx...@yahoo.com> wrote:
>>>>
>>>> We have a requirement where we need to copy thousands of child nodes
>>>> from
>>>> one
>>>> node to another. This becomes really slow and unusable when no. of
>>>> nodes
>>>> grow from 400 to 2000.
>>>>
>>>> I tried to caputre mysql query log for one node copy operation. This
>>>> looks
>>>> awfully big. Does this indicate anything wrong we have in our setup?
>>>
>>> yes. some suggestions/remarks:
>>>
>>> - use
>>> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager
>>> instead of
>>> org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager;
>>> the former provides a significantly better performance [0].
>>> - seems like you store a lot of binary data in your repository. using
>>> the DataStore [1]
>>> should help to improve the performance.
>>> - all your content seems to be versionable. make sure you do require
>>> versionability
>>> of your content as this feature doesn't come for free
>>> performance-wise. remove
>>> mix:versionable where you don't need it.
>>> - unless you have a strict requirement to use mysql try using an
>>> embedded
>>> db
>>> such as derby (jackrabbit's default) or e.g. H2. performance with an
>>> embedded
>>> db should be much better.
>>>
>>> cheers
>>> stefan
>>>
>>>
>>> [0] http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ
>>> [1] http://wiki.apache.org/jackrabbit/DataStore
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25785431.html
>> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25803247.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Performance of workspace copy
Posted by Stefan Guggisberg <st...@gmail.com>.
On Wed, Oct 7, 2009 at 3:19 PM, sxm <sx...@yahoo.com> wrote:
>
> thanks Stefan, great suggestions. Could you please comment on [2]
>
> 1. I tried
> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager, no
> visible performance improvement.
that's hard to believe. can you provide a mysql query log (20-40 lines
would be enough)?
> 2. Binary data: We dont have any binary data. How can we be sure and disable
> the binary properties.
create your own, domain-specific node types.
> 3. We will try dataStore. Although, performance gains may not be significant
> as it appears to be using only two connections for the entire transaction.
if you don't store binary properties, you don't need the DataStore.
cheers
stefan
> 4. Versionability is the basic requirement.
> 5. Switching db also is not an option in short term, we certainly consider
> it for long term solution.
>
> -Shailesh
>
>
> Stefan Guggisberg wrote:
>>
>> hi anonymous,
>>
>> On Wed, Oct 7, 2009 at 1:49 AM, sxm <sx...@yahoo.com> wrote:
>>>
>>> We have a requirement where we need to copy thousands of child nodes from
>>> one
>>> node to another. This becomes really slow and unusable when no. of nodes
>>> grow from 400 to 2000.
>>>
>>> I tried to caputre mysql query log for one node copy operation. This
>>> looks
>>> awfully big. Does this indicate anything wrong we have in our setup?
>>
>> yes. some suggestions/remarks:
>>
>> - use
>> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager
>> instead of
>> org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager;
>> the former provides a significantly better performance [0].
>> - seems like you store a lot of binary data in your repository. using
>> the DataStore [1]
>> should help to improve the performance.
>> - all your content seems to be versionable. make sure you do require
>> versionability
>> of your content as this feature doesn't come for free
>> performance-wise. remove
>> mix:versionable where you don't need it.
>> - unless you have a strict requirement to use mysql try using an embedded
>> db
>> such as derby (jackrabbit's default) or e.g. H2. performance with an
>> embedded
>> db should be much better.
>>
>> cheers
>> stefan
>>
>>
>> [0] http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ
>> [1] http://wiki.apache.org/jackrabbit/DataStore
>>
>>
>
> --
> View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25785431.html
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>
Re: Performance of workspace copy
Posted by sxm <sx...@yahoo.com>.
thanks Stefan, great suggestions. Could you please comment on [2]
1. I tried
org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager, no
visible performance improvement.
2. Binary data: We dont have any binary data. How can we be sure and disable
the binary properties.
3. We will try dataStore. Although, performance gains may not be significant
as it appears to be using only two connections for the entire transaction.
4. Versionability is the basic requirement.
5. Switching db also is not an option in short term, we certainly consider
it for long term solution.
-Shailesh
Stefan Guggisberg wrote:
>
> hi anonymous,
>
> On Wed, Oct 7, 2009 at 1:49 AM, sxm <sx...@yahoo.com> wrote:
>>
>> We have a requirement where we need to copy thousands of child nodes from
>> one
>> node to another. This becomes really slow and unusable when no. of nodes
>> grow from 400 to 2000.
>>
>> I tried to caputre mysql query log for one node copy operation. This
>> looks
>> awfully big. Does this indicate anything wrong we have in our setup?
>
> yes. some suggestions/remarks:
>
> - use
> org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager
> instead of
> org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager;
> the former provides a significantly better performance [0].
> - seems like you store a lot of binary data in your repository. using
> the DataStore [1]
> should help to improve the performance.
> - all your content seems to be versionable. make sure you do require
> versionability
> of your content as this feature doesn't come for free
> performance-wise. remove
> mix:versionable where you don't need it.
> - unless you have a strict requirement to use mysql try using an embedded
> db
> such as derby (jackrabbit's default) or e.g. H2. performance with an
> embedded
> db should be much better.
>
> cheers
> stefan
>
>
> [0] http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ
> [1] http://wiki.apache.org/jackrabbit/DataStore
>
>
--
View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25785431.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
Re: Performance of workspace copy
Posted by Stefan Guggisberg <st...@gmail.com>.
hi anonymous,
On Wed, Oct 7, 2009 at 1:49 AM, sxm <sx...@yahoo.com> wrote:
>
> We have a requirement where we need to copy thousands of child nodes from one
> node to another. This becomes really slow and unusable when no. of nodes
> grow from 400 to 2000.
>
> I tried to caputre mysql query log for one node copy operation. This looks
> awfully big. Does this indicate anything wrong we have in our setup?
yes. some suggestions/remarks:
- use org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager
instead of org.apache.jackrabbit.core.persistence.db.SimpleDbPersistenceManager;
the former provides a significantly better performance [0].
- seems like you store a lot of binary data in your repository. using
the DataStore [1]
should help to improve the performance.
- all your content seems to be versionable. make sure you do require
versionability
of your content as this feature doesn't come for free
performance-wise. remove
mix:versionable where you don't need it.
- unless you have a strict requirement to use mysql try using an embedded db
such as derby (jackrabbit's default) or e.g. H2. performance with an embedded
db should be much better.
cheers
stefan
[0] http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ
[1] http://wiki.apache.org/jackrabbit/DataStore
>
> 438 Connect root@localhost on
> 438 Init DB dversion
> 438 Query SET NAMES utf8
> 438 Query SET character_set_results = NULL
> 438 Query SHOW VARIABLES
> 438 Query SHOW COLLATION
> 438 Query SET autocommit=1
> 438 Query SET sql_mode='STRICT_TRANS_TABLES'
> 438 Query SET autocommit=0
> 438 Query SHOW FULL TABLES FROM `dversion` LIKE
> 'jackrabbit_version_node'
> 438 Prepare [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values (?, ?)
> 438 Prepare [2] update JACKRABBIT_VERSION_NODE set NODE_DATA = ?
> where NODE_ID = ?
> 438 Prepare [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
> where NODE_ID = ?
> 438 Prepare [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = ?
> 438 Prepare [5] delete from JACKRABBIT_VERSION_NODE where NODE_ID
> = ?
> 438 Prepare [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values (?, ?)
> 438 Prepare [7] update JACKRABBIT_VERSION_PROP set PROP_DATA = ?
> where PROP_ID = ?
> 438 Prepare [8] select PROP_DATA from JACKRABBIT_VERSION_PROP
> where PROP_ID = ?
> 438 Prepare [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = ?
> 438 Prepare [10] delete from JACKRABBIT_VERSION_PROP where PROP_ID
> = ?
> 438 Prepare [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
> NODE_ID) values (?, ?)
> 438 Prepare [12] update JACKRABBIT_VERSION_REFS set REFS_DATA = ?
> where NODE_ID = ?
> 438 Prepare [13] select REFS_DATA from JACKRABBIT_VERSION_REFS
> where NODE_ID = ?
> 438 Prepare [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = ?
> 438 Prepare [15] delete from JACKRABBIT_VERSION_REFS where NODE_ID
> = ?
> 438 Prepare [16] insert into JACKRABBIT_VERSION_BINVAL
> (BINVAL_DATA, BINVAL_ID) values (?, ?)
> 438 Prepare [17] update JACKRABBIT_VERSION_BINVAL set BINVAL_DATA
> = ? where BINVAL_ID = ?
> 438 Prepare [18] select BINVAL_DATA from JACKRABBIT_VERSION_BINVAL
> where BINVAL_ID = ?
> 438 Prepare [19] select 1 from JACKRABBIT_VERSION_BINVAL where
> BINVAL_ID = ?
> 438 Prepare [20] delete from JACKRABBIT_VERSION_BINVAL where
> BINVAL_ID = ?
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
> 438 Execute [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
> where NODE_ID = 'deadbeef-face-babe-cafe-babecafebabe'
> 439 Connect root@localhost on
> 439 Init DB dversion
> 439 Query SET NAMES utf8
> 439 Query SET character_set_results = NULL
> 439 Query SHOW VARIABLES
> 439 Query SHOW COLLATION
> 439 Query SET autocommit=1
> 439 Query SET sql_mode='STRICT_TRANS_TABLES'
> 439 Query SET autocommit=0
> 439 Query SHOW FULL TABLES FROM `dversion` LIKE
> 'jackrabbit_thed_node'
> 439 Prepare [1] insert into JACKRABBIT_THED_NODE (NODE_DATA,
> NODE_ID) values (?, ?)
> 439 Prepare [2] update JACKRABBIT_THED_NODE set NODE_DATA = ?
> where NODE_ID = ?
> 439 Prepare [3] select NODE_DATA from JACKRABBIT_THED_NODE where
> NODE_ID = ?
> 439 Prepare [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> ?
> 439 Prepare [5] delete from JACKRABBIT_THED_NODE where NODE_ID = ?
> 439 Prepare [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values (?, ?)
> 439 Prepare [7] update JACKRABBIT_THED_PROP set PROP_DATA = ?
> where PROP_ID = ?
> 439 Prepare [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = ?
> 439 Prepare [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> ?
> 439 Prepare [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
> ?
> 439 Prepare [11] insert into JACKRABBIT_THED_REFS (REFS_DATA,
> NODE_ID) values (?, ?)
> 439 Prepare [12] update JACKRABBIT_THED_REFS set REFS_DATA = ?
> where NODE_ID = ?
> 439 Prepare [13] select REFS_DATA from JACKRABBIT_THED_REFS where
> NODE_ID = ?
> 439 Prepare [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
> = ?
> 439 Prepare [15] delete from JACKRABBIT_THED_REFS where NODE_ID =
> ?
> 439 Prepare [16] insert into JACKRABBIT_THED_BINVAL (BINVAL_DATA,
> BINVAL_ID) values (?, ?)
> 439 Prepare [17] update JACKRABBIT_THED_BINVAL set BINVAL_DATA = ?
> where BINVAL_ID = ?
> 439 Prepare [18] select BINVAL_DATA from JACKRABBIT_THED_BINVAL
> where BINVAL_ID = ?
> 439 Prepare [19] select 1 from JACKRABBIT_THED_BINVAL where
> BINVAL_ID = ?
> 439 Prepare [20] delete from JACKRABBIT_THED_BINVAL where
> BINVAL_ID = ?
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'cafebabe-cafe-babe-cafe-babecafebabe'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'deadbeef-cafe-babe-cafe-babecafebabe'
> 439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
> NODE_ID = 'deadbeef-cafe-babe-cafe-babecafebabe'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'cafebabe-cafe-babe-cafe-babecafebabe'
> 439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
> NODE_ID = 'cafebabe-cafe-babe-cafe-babecafebabe'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
> NODE_ID = 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f'
> 439 Execute [3] select NODE_DATA from JACKRABBIT_THED_NODE where
> NODE_ID = '567b14d7-3673-47af-9d99-f12861bd717f'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}isCheckedOut'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}isCheckedOut'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}versionHistory'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}versionHistory'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'deadbeef-face-babe-cafe-babecafebabe/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [8] select PROP_DATA from JACKRABBIT_VERSION_PROP
> where PROP_ID =
> 'deadbeef-face-babe-cafe-babecafebabe/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = 'a8697be4-2d7e-40ed-82f7-bcd11ea3f190'
> 438 Execute [3] select NODE_DATA from JACKRABBIT_VERSION_NODE
> where NODE_ID = 'a8697be4-2d7e-40ed-82f7-bcd11ea3f190'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values ('\0 {internal}versionStoragefi≠æÔ˙Œ∫æ ˛∫æ
> ˛∫æ\0\n-457304826\0\0\0\0\0\0\0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0 \0 {}cf¡xØJ5KEØπ°´¥‘÷Qò',
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0 {internal}versionStorage',
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values ('\0 {internal}versionStorageÙ ‘4€ËN6≥1¥˚Ï
> ,g\0\n-457304826\0\0\0\0\0\0\0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0 \0 {}07ú‘ J\'xAØÜüt‚Ê\"íq',
> 'c178af4a-354b-45af-b9a1-abb4d4d65198')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0 {internal}versionStorage',
> 'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values
> ('\0 {internal}versionStorage¡xØJ5KEØπ°´¥‘÷Qò\0\n-457304826\0\0\0\0\0\0\0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0 \0&{}47cf07c7-38b9-4ab7-b47e-47f3105dc7bc»‰C≈;ÈIQäN∞8Dy∏…',
> '9cd4194a-2778-41af-869f-74e2e6229271')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0 {internal}versionStorage',
> '9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values
> ('\0-{http://www.jcp.org/jcr/nt/1.0}versionHistoryú‘ J\'xAØÜüt‚Ê\"íq\0
> 453704611\0\0\0\0\0\0\0\0\0 \0+{http://www.jcp.org/jcr/1.0}versionableUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0\0\0 \0){http://www.jcp.org/jcr/1.0}versionLabelsŸ
> Ã|¿FéºØ‚å\'z\'4\0\'{http://www.jcp.org/jcr/1.0}rootVersion°EW ‰ G †<¿º¯?
> ‡', 'c8e443c5-3be9-4951-8a4e-b0384479b8c9')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0-{http://www.jcp.org/jcr/nt/1.0}versionHistory',
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0
> 217130042\0\0\0\0\0 \0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values
> ('\0,{http://www.jcp.org/jcr/nt/1.0}versionLabels»‰C≈;ÈIQäN∞8Dy∏…\0\n-740395034\0\0\0\0\0\0\0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0\0',
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0,{http://www.jcp.org/jcr/nt/1.0}versionLabels',
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values
> ('\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-529143834\0\0\0\0\0\0\0\0\0 \0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0 \0&{http://www.jcp.org/jcr/1.0}frozenNodeäéÓµ,¿F>≠G˛©åY ë',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0&{http://www.jcp.org/jcr/nt/1.0}version',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n1168274971\0\0\0\0\0 \0\0\0
> 2009-10-02T00:22:35.517-07:00',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\n1273143658\0\0\0\0\0\0',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0 -6226323\0\0\0\0\0\0',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values ('\0){http://www.jcp.org/jcr/nt/1.0}frozenNode°EW ‰ G †<¿º¯?
> ‡\0\n-486997456\0\0\0\0\0\0\0\0\0 \0,{http://www.jcp.org/jcr/1.0}frozenMixinTypes\0&{http://www.jcp.org/jcr/1.0}frozenUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0-{http://www.jcp.org/jcr/1.0}frozenPrimaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0\0\0\0',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0){http://www.jcp.org/jcr/nt/1.0}frozenNode',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$8a8eeeb5-2cc0-463e-ad47-fea98c591891',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1745170734\0\0\0\0\0 \0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1931306613\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0
> -1734300174\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes')
> 438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
> '\0 {internal}versionStoragefi≠æÔ ˛∫æ ˛∫æ
> ˛∫æ\0\n1994195451\0\0\0\0\0 \0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0 \0 {}56®i{‰-~@Ìǘº—
> £Òê\0 {}47Ù ‘4€ËN6≥1¥˚Ï ,g' where NODE_ID =
> 'deadbeef-face-babe-cafe-babecafebabe'
> 438 Query commit
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '8a8eeeb5-2cc0-463e-ad47-fea98c591891/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'd91c06cc-7cc0-468e-bcaf-e28c277a2734/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '9cd4194a-2778-41af-869f-74e2e6229271'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '9cd4194a-2778-41af-869f-74e2e6229271'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}versionableUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}created'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c178af4a-354b-45af-b9a1-abb4d4d65198'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c178af4a-354b-45af-b9a1-abb4d4d65198'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'c178af4a-354b-45af-b9a1-abb4d4d65198/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '9cd4194a-2778-41af-869f-74e2e6229271/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'f41fd434-dbe8-4e36-b331-b4fbec092c67/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}mixinTypes'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}mixinTypes'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}steps'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}steps'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}author'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}author'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}baseVersion'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}baseVersion'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}documentlink'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}documentlink'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}title'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}title'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}creationdate'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}creationdate'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '567b14d7-3673-47af-9d99-f12861bd717f/{}comments'
> 439 Execute [8] select PROP_DATA from JACKRABBIT_THED_PROP where
> PROP_ID = '567b14d7-3673-47af-9d99-f12861bd717f/{}comments'
> 439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
> = 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
> = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [1] insert into JACKRABBIT_THED_NODE (NODE_DATA,
> NODE_ID) values
> ('\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØ ÆHü6fl¬\0
> -1603354723\0\0\0 \0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0\0\0\0\0\r\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0*{http://www.jcp.org/jcr/1.0}versionHistory\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0 {}steps\0 {}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0 {}documentlink\0 {}title\0 {}creationdate\0\n{}comments\0\0\0\0',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n1284956073\0\0\0\0\0 \0\0\0 true',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}isCheckedOut')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0
> \0\0\n-299049193\0\0\0\0\0 \0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}versionHistory')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0
> -1755740157\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}mixinTypes')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0
> \0\n1928532486\0\0\0\0\0 \0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0b<steps
> maxId=\"1\">\n <step id=\"1\" orderId=\"1\" detail=\"afd\" data=\"asdfwe\"
> result=\"adqwer\"/>\n</steps>',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}steps')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0 2',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}author')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0
> -1600436894\0\0\0\0\0 \0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}primaryType')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}uuid')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0 none',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}documentlink')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0 Untitled',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}title')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0
> 2009-10-02T00:21:52.936-07:00',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}creationdate')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 806470580\0\0\0\0\0 \0\0\0\0',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}comments')
> 439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
> '\0+{http://www.jcp.org/jcr/nt/1.0}unstructured ˛∫æ ˛∫æ ˛∫æ ˛∫æ\0
> -1603354723\0\0\0\0\0 \0\0\0 \0\'{http://www.jcp.org/jcr/1.0}primaryType\0\0\0 \0 {}3V{ ◊6sGØùôÒ(aΩq \0 {}36Gœ «8πJ∑¥~GÛ ]«º'
> where NODE_ID = 'd44abf2e-b763-4b0a-af17-ae489f36dfc2'
> 439 Query commit
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
> NODE_ID) values
> ('\0\0\0 \0O47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}versionHistory',
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9')
> 438 Query commit
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
> NODE_ID) values
> ('\0\0\0 \0M47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors\0L47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion',
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0')
> 438 Query commit
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 -1920423584\0\0\0\0\0 \0\0\0 true',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep')
> 439 Execute [6] insert into JACKRABBIT_THED_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0 514073364\0\0\0\0\0 \0\0\0 root',
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner')
> 439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
> '\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØ ÆHü6fl¬\0
> -1603354723\0\0\0 \0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0 \0\0\0 \0*{http://www.jcp.org/jcr/1.0}versionHistory\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0&{http://www.jcp.org/jcr/1.0}lockIsDeep\0%{http://www.jcp.org/jcr/1.0}lockOwner\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0 {}steps\0 {}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0 {}documentlink\0
> {http://www.jcp.org/jcr/1.0}uuid\0 {}title\0 {}creationdate\0\n{}comments\0\0\0\0'
> where NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 439 Query commit
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0 none' where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}documentlink'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0 2' where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}author'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0 2009-10-02T00:21:52.936-07:00' where
> PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}creationdate'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0b<steps maxId=\"1\">\n <step id=\"1\"
> orderId=\"1\" detail=\"afd\" data=\"asdfwe\" result=\"adqwer\"/>\n</steps>'
> where PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}steps'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0 Untitled' where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}title'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0 806470580\0 \0\0\0 \0\0\0#Copied from release 1, test case: 3'
> where PROP_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{}comments'
> 439 Query commit
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
> 438 Execute [9] select 1 from JACKRABBIT_VERSION_PROP where
> PROP_ID = '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values
> ('\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-763947774\0\0\0\0\0\0\0\0\0 \0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0 \0&{http://www.jcp.org/jcr/1.0}frozenNodeÑÿnæiVE4ΩêØ2ì ≤”',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0&{http://www.jcp.org/jcr/nt/1.0}version',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n1168274971\0\0\0\0\0 \0\0\0
> 2009-10-02T00:22:35.673-07:00',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0
> \0\n1273143658\0\0\0\0\0 \0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0 -6226323\0\0\0\0\0\0',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors')
> 438 Execute [1] insert into JACKRABBIT_VERSION_NODE (NODE_DATA,
> NODE_ID) values ('\0){http://www.jcp.org/jcr/nt/1.0}frozenNodeÍQ
> Ãk⁄F ™4P{”,ur\0\n-486997456\0\0\0\0\0\0\0\0\0\r\0*{http://www.jcp.org/jcr/1.0}versionHistory\0,{http://www.jcp.org/jcr/1.0}frozenMixinTypes\0&{http://www.jcp.org/jcr/1.0}frozenUuid\0({http://www.jcp.org/jcr/1.0}predecessors\0 {}steps\0 {}author\0\'{http://www.jcp.org/jcr/1.0}primaryType\0-{http://www.jcp.org/jcr/1.0}frozenPrimaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0 {}documentlink\0 {}title\0 {}creationdate\0\n{}comments\0\0\0\0',
> '84d86ebe-6956-4534-bd90-af329301b2d3')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1266667140\0\0\0\0\0 \0\0\0){http://www.jcp.org/jcr/nt/1.0}frozenNode',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1377012443\0\0\0\0\0 \0\0\0$84d86ebe-6956-4534-bd90-af329301b2d3',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1745170734\0\0\0\0\0 \0\0\0$47cf07c7-38b9-4ab7-b47e-47f3105dc7bc',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values
> ('\0\0\0 \0\0\n1931306613\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/nt/1.0}unstructured',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0
> -1734300174\0\0\0\0\0 \0\0\0+{http://www.jcp.org/jcr/mix/1.0}versionable\0\0\0({http://www.jcp.org/jcr/mix/1.0}lockable',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0
> \0\0\n-539289332\0\0\0\0\0 \0\0\0$c8e443c5-3be9-4951-8a4e-b0384479b8c9',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0
> \0\n-539289331\0\0\0\0\0 \0\0\0$a1455712-e404-4710-a03c-c0bcf83f1fe0',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0b<steps
> maxId=\"1\">\n <step id=\"1\" orderId=\"1\" detail=\"afd\" data=\"asdfwe\"
> result=\"adqwer\"/>\n</steps>',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}steps')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0 2',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}author')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0 none',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0 Untitled',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}title')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0
> 2009-10-02T00:21:52.936-07:00',
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate')
> 438 Execute [6] insert into JACKRABBIT_VERSION_PROP (PROP_DATA,
> PROP_ID) values ('\0\0\0 \0\0\n-539289332\0\0\0\0\0 \0\0\0#Copied from
> release 1, test case: 3', '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments')
> 438 Execute [7] update JACKRABBIT_VERSION_PROP set PROP_DATA =
> '\0\0\0 \0 -6226323\0 \0\0\0 \0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572'
> where PROP_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0/{http://www.jcp.org/jcr/1.0}successors'
> 438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
> '\0&{http://www.jcp.org/jcr/nt/1.0}version»‰C≈;ÈIQäN∞8Dy∏…\0\n-529143834\0\0\0\0\0 \0\0\0 \0&{http://www.jcp.org/jcr/1.0}successors\0#{http://www.jcp.org/jcr/1.0}created\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0({http://www.jcp.org/jcr/1.0}predecessors\0\0\0 \0&{http://www.jcp.org/jcr/1.0}frozenNodeäéÓµ,¿F>≠G˛©åY ë'
> where NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Execute [2] update JACKRABBIT_VERSION_NODE set NODE_DATA =
> '\0-{http://www.jcp.org/jcr/nt/1.0}versionHistoryú‘ J\'xAØÜüt‚Ê\"íq\0
> 453704611\0\0\0\0\0 \0\0\0 \0+{http://www.jcp.org/jcr/1.0}versionableUuid\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0\0\0 \0){http://www.jcp.org/jcr/1.0}versionLabelsŸ
> Ã|¿FéºØ‚å\'z\'4\0\'{http://www.jcp.org/jcr/1.0}rootVersion°EW ‰ G †<¿º¯?
> ‡\0 {}1.0ÍQ Ãk⁄F ™4P{”,ur' where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 438 Query commit
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}successors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}created'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}versionHistory'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenMixinTypes'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenUuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}steps'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}author'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}primaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}frozenPrimaryType'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{http://www.jcp.org/jcr/1.0}uuid'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}documentlink'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}title'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}creationdate'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
> 439 Execute [9] select 1 from JACKRABBIT_THED_PROP where PROP_ID =
> '84d86ebe-6956-4534-bd90-af329301b2d3/{}comments'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 438 Execute [13] select REFS_DATA from JACKRABBIT_VERSION_REFS
> where NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [13] select REFS_DATA from JACKRABBIT_THED_REFS where
> NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [14] select 1 from JACKRABBIT_THED_REFS where NODE_ID
> = 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0
> -1600436894\0 \0\0\0 \0\0\0$ea5109cc-6bda-4602-aa34-507bd32c7572' where
> PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\0\n1284956073\0 \0\0\0 \0\0\0 false' where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}isCheckedOut'
> 439 Execute [7] update JACKRABBIT_THED_PROP set PROP_DATA =
> '\0\0\0 \0\n1928532486\0 \0\0\0\0' where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}predecessors'
> 439 Query commit
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Execute [15] delete from JACKRABBIT_VERSION_REFS where NODE_ID
> = 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 438 Query commit
> 438 Execute [4] select 1 from JACKRABBIT_VERSION_NODE where
> NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 438 Execute [14] select 1 from JACKRABBIT_VERSION_REFS where
> NODE_ID = 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 438 Execute [11] insert into JACKRABBIT_VERSION_REFS (REFS_DATA,
> NODE_ID) values
> ('\0\0\0 \0L47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}baseVersion',
> 'ea5109cc-6bda-4602-aa34-507bd32c7572')
> 438 Query commit
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockIsDeep'
> 439 Execute [10] delete from JACKRABBIT_THED_PROP where PROP_ID =
> '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc/{http://www.jcp.org/jcr/1.0}lockOwner'
> 439 Execute [2] update JACKRABBIT_THED_NODE set NODE_DATA =
> '\0+{http://www.jcp.org/jcr/nt/1.0}unstructured‘Jø.∑cK\nØ ÆHü6fl¬\0
> -1603354723\0\0\0 \0+{http://www.jcp.org/jcr/mix/1.0}versionable\0({http://www.jcp.org/jcr/mix/1.0}lockable\0 \0\0\0\r\0({http://www.jcp.org/jcr/1.0}isCheckedOut\0*{http://www.jcp.org/jcr/1.0}versionHistory\0&{http://www.jcp.org/jcr/1.0}mixinTypes\0({http://www.jcp.org/jcr/1.0}predecessors\0 {}steps\0 {}author\0\'{http://www.jcp.org/jcr/1.0}baseVersion\0\'{http://www.jcp.org/jcr/1.0}primaryType\0
> {http://www.jcp.org/jcr/1.0}uuid\0 {}documentlink\0\n{}comments\0 {}creationdate\0 {}title\0\0\0\0'
> where NODE_ID = '47cf07c7-38b9-4ab7-b47e-47f3105dc7bc'
> 439 Query commit
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'ea5109cc-6bda-4602-aa34-507bd32c7572'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'a1455712-e404-4710-a03c-c0bcf83f1fe0'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Execute [4] select 1 from JACKRABBIT_THED_NODE where NODE_ID =
> 'c8e443c5-3be9-4951-8a4e-b0384479b8c9'
> 439 Query rollback
> 439 Quit
> 438 Query rollback
> 438 Quit
>
> I have also tried it indexing disabled without any visible improvements. We
> are currently using 1.4.9.
> --
> View this message in context: http://www.nabble.com/Performance-of-workspace-copy-tp25778413p25778413.html
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>