jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Guggisberg <stefan.guggisb...@gmail.com>
Subject Re: Performance of workspace copy
Date Wed, 07 Oct 2009 07:56:22 GMT
hi anonymous,

On Wed, Oct 7, 2009 at 1:49 AM, sxm <sxm20@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.
>
>

Mime
View raw message