Thanks, I can reproduce this now.
It's going to take me a while to work out a fix though.
On 2013-05-09 06:01, Ainimyoung wrote:
> Hi Noel,
>
> We found that the deadlock can be duplicated with MULTI_THREADED=TRUE
> much more easily.
> The following three statements got no response from H2 while we
> reproduced a deadlock, and might be correlated with the three H2 TCP
> Server threads sustaining deadlock listed in jstack log.
>
> INSERT INTO ProcessRelation (ESID, ProcessListImg, Imgsize) VALUES
> (?,?,?) {1: 14, 2:
> X'89504e470d0a1a0a0000000d494844520000011d0000003b080600000046e85ee400000006624b474400ff00ff00ffa0bda793000010c049444154789ced9d7d6c53d5ffc7dff7b1ed9e58c73af6c0781808630b63c01f0c61225f439400c620c69018a326fe898680027f98c81ffa079a181311c418a3ff40fc03198190104104a682326032b6f0309eb675ec79ebb6aebd6ddfbf3ff8f566634f5dd7b5eb38afe49d75ede9b99fcf39f7be7beeb9e7b6124942201008a2841ceb000402c1b385301d8140105584e9080482a8a2c63a0041e8040201747676a2bbbb1b6eb71b2e970b2e970b6eb71bdddddde8e9e981d7eb85cfe783cbe50200b85c2ef87c3e188681eeee6e0040575717fc7ebf59c7d3747575c1308c61e3e8e8e840702a30313111baae0f5b76faf4e9839eb3582c98366d1a00202525058aa240d7752426260200525353214912ac562b6c361b00c06eb79b6552535361b3d960b3d960b7db61b3d960b55a436942c12440984e94300c031d1d1d686f6f477b7bfbb08fdbdbdbd1d2d282d6d656b8dd6eb8dd6e747575c1e3f18c680400a0280a64f9c9e035f8370849d3287c3e1f26cbf5035555214992a9fe046326099fcf37623d9224213131d134a3949414a4a4a4202d2d0dd3a74f476a6a2aec763bec76fb80c7fdff4f484898c85405ff8f24ae5e8587d7eb457373339a9b9bd1d8d8683e6e6a6ac2e3c78fd1d8d888c78f1fc3e974a2b3b3136eb77b501d9224415555d320fc7effa8079760ec288a024551204992696081406050394dd390929282f4f47464656521272707e9e9e970381cc8caca321fcf983103191919484a4a8a4136f18f309d21686e6e464343031e3d7a84baba3a343434e0e1c387a61a1b1bd1d3d333e03db22c9b9fda3e9f0f7ebf3f46d10b2245ff3e1dea0341d7754c9f3e1db9b9b9c8cbcb4376763666cd9a859c9c1cf37166662654559c50f4e799331d92a8afaf476d6dada97bf7eee1f6eddba8afaf47535313bc5eaf595ed334c8b22c8c4430224183029e9c4a070f2b4992307dfa74cc9c391373e6ccc1bc79f390979787bcbc3ccc9d3b1773e6cc81c5628965e851674a9a8e6118b873e70e6eddba651acbeddbb771ebd62dd4d5d59973238aa2405555188631e4705b208824922441d3349034f74149929091918179f3e661e1c285a6213df7dc73c8cfcf477272728ca38e3c716d3a7d7d7da8aeae464d4d0daaaaaa70f3e64d5cbf7e1d0f1e3c304725c12b2bfd472f02c164445555288a32e04330333313050505282a2ac2a2458bb068d1221414140c7955305e881bd379f8f0212a2a2a4c555656a2bebe1e814000b22c43d3343162114c59745d1f30424a4d4d45616121962d5b8665cb9661e9d2a5282c2c8c8bf9a349673a24515b5b8b2b57aee0ead5abb874e9122a2a2ad0d9d9094992a0eb3abc5eefa4b9e42b10c4125dd7e1f7fbe1f7fba1691a0a0a0a505252629a515151d188eba86241cc4dc7e3f1e0df7fffc5850b1770eedc395cbc78113d3d3de6e8c5e3f1c4323c8120ee08ce1bf97c3e288a82a2a222fcef7fffc30b2fbc8055ab56c5fcd42ceaa6e372b9505e5e8e8b172fe2b7df7e434545050cc380c562112318816082d075dd3c359b376f1e5e7ae925ac5ebd1a6bd6ac416e6e6e5463898ae9dcb87103a74e9dc2afbffe8acb972f23100840d775318a11086284a669080402f0fbfd983d7b36366fde8c0d1b36a0b4b474c24fc726c4747a7b7b71eedc399c387102c78e1d83d3e9349d568c640482c94770aed466b3e1e5975fc6c68d1bb161c306646666467e638c103e9f8fa74f9fe6d6ad5b69b158284912755d27002121a13892a228545595922471e5ca953c74e8103b3a3a2265151cb7e954575773d7ae5d74381c04404dd362de6842424291912ccb541485baae73ebd6ad3c79f2247d3e5ff44dc7300c1e3e7c984b972e250031a211127a06a4aa2a01d0e17070efdebd6c6e6e9e78d3f17abd3c78f020b3b3b329cb3265598e794384a241493ff57a7e7e3e77efdecdbffffe9b814060c83223d53752dd63adbfb8b898fbf6ede3952b57d8dddd4d8fc7c33b77ee70fffefdcccdcd0d2bbfb1e630543d65656524c993274f0eaa4b92249e3d7b962479e4c89141afbdfefaeb2c2b2ba3d3e9a4d7eb65777737fffbef3f1e387080252525e38a6b2c39c7ba2dc6ba9dc92c555569b158b86ddb3636363686949b9963a8058f1e3dcad9b3675396654a9214f3a4c7b35385b2d385bb93865a3e9cbadbdada58545434e6fcc6ba9da1ea99356b16bbbbbb49929b376f1ef0da871f7e4892743a9d4c4b4b339f4f4e4ee6a953a7c6b49db1c635969c63d916e16c271ea4691aad562b3ff9e413f6f6f68696e368059c4e27376cd840007133b2196ea71aeef5aaaa2a7efae9a72c2c2c0ca9f3c7ba838ca5fe8a8a0aeed8b183c5c5c54c4848a0d56ae5ba75eb78ebd62d92e4d9b367231257383bf9471f7d44927cf4e811939292083c19c50577b68d1b370e281f1c11b4b5b571c78e1d9c3f7f3e755d67424202172d5ac4f7df7f9fe5e5e5e38a2b9c3c62d116918a75b24a5114ce9933877ffcf1c7689632b2e994979733232323ee2787237d308e67e709f7bd45454524c9dededea8e5f9b454556565652549f2cb2fbfa4aaaabc7cf93249f2871f7e1850f695575e2149767474303f3f7fc2da271207f244b74524639dcc521485b22c73dfbe7d23d9caf0a673e6cc195a2c162a8a12f364c6ab481f8ce3d979c27d6f62622249b2b3b3336a790ea5952b57321008d0300cfefcf3cf24c9fbf7ef3325256540b9c3870f9324f7ecd933a1ed13890379a2db2292b1c6836459e6ce9d3bc7663a77efdea5cd668bdbd3a9f174f6584ca7b2b2928661b0aeae8e870e1d625656564463e9aff7de7b8f2479faf4e9a8e5399c0e1d3a64be3f100870eddab583cadcbf7f9f24c734ca0927ae589a4ea86d11c958e345b22cf3e0c183a19bce8a152be2fe942adcce1e8be93c4d5d5d1db3b3b323164b508b162d627b7b3b038100d7ac5913d13c4762b8f7666565d1eff7931c7c852628b7db4d92b45aad61f555a87185d39ed16e8b486c271e65b158f8e0c183c1393efdc4850b17a6cc08e7e9ce8e54d9b2b232969696d262b1303535956fbcf106ebebeb4992df7fff7dc46201c0c2c24236343490243ffffcf388e719ce01f0c5175f9865dadadacc85a1fdf5ac984e286d1189edc4a32c160b3ff8e083c1393efdc4c71f7f4c8bc512f38023a9b17468b89d5f5a5a4a92acafaf8f58fd2b57ae646b6b2b49f2bbefbe1b75a942b4f2f4fbfdf4f97cbc7efd3a49f2a79f7e1a54ee5938bd0ab52d22196bbc2927276774d379f7dd77cd95875345d13818755d27f964016524eadfb871237b7a7a4892070f1e0c696dd444e7999494c4bb77ef92243ffbec332e58b0807d7d7d2439e8b42f3891bc7bf7ee09ebabf1f45734db2292b1c69b92929246379d7dfbf689914e183bc68b2fbe48927cf8f0e1b8eb7fe79d776818064972fffefd212fc69ce83c8393a6d7ae5d336f7dd9bb772f49b2aaaa6ac03c60f092797b7b3b172c5830217d359efe8a665b4432d678537171f1e8a6535f5f3f252e9387dbd9a3953d73e60cb76cd9c2cccc4c2a8ac2f4f474befdf6db7cfcf83149f2ebafbf1e57fdc14567a1d43591793eadf5ebd793243d1ecf8055d156ab95b76fdf2649eedab56bc07b828b035b5b5bb97dfb76e6e5e551d334da6c36e6e7e7c7ede2c070da2252b1c693745de781030746371d72eacdeb8cd6d9a3116ad9caca4adaedf609ab3f487a7a7a58798e753bc1b2696969e664f650eb6ed6ad5b4792ece9e9e1ecd9b3cde7a3791b4428e5877a7fb4da229cdce2598aa270debc79e629e7801c874adce3f1b0b8b878cadc3d3e5a878e654778fef9e7f9e38f3ff2fefdfb340c832e978bfffcf30f77efde4d9bcd36eefa4321daa673e4c81192e45f7ffd35ec2838388753565636e0794992b865cb161e3f7e9c4ea793866198377c7efbedb711bbe13394f2c3b54fb4da62acb9c5ab6459a6d56a3527d707e5385cf26d6d6d5cb264c99458af33953a54e4293499a5aa2a6d361bcf9f3f3fbcb18ee4ba3d3d3d7cebadb708c4efcd9ec0e014631d8fc84f682a4a55552e58b080d5d5d523d94a685f6df1cb2fbf303d3d3d6e473d53fda09ceaf9094d6e699a464551b86bd7ae90bede22b4134d3eb9f4b967cf1e5aadd6b8351f2121a1c829b89e6fc3860dacaaaa0ad54ac6fe75a54ea7933b77ee64424282f9e5cdb14e5e4848287ad2348d9224f1d5575fe5a54b97c66a21e17f317b676727bffaea2b7399fb54b9d22524243458c10186dd6ee7b66ddb58535313ae758cffd72048f2ead5abdcbe7d3bed763b25499a72b75108093d8b0a1ecb9aa6f1b5d75ee3b163c7e8f57ac7ed1711319d205eaf97274e9ce09b6fbec9e4e4640262042424144fd234cdfcd999d2d2527ef3cd37e64dc79162c27e56d8eff7a3bcbc1ca74e9dc2d1a34771ebd62d689a06bfdf8f402030119b1408046160b158e0f17860b7dbb169d3266cdab409ebd6adc3b469d326647b51f92d730078f0e0014e9d3a85e3c78fe3e2c58b70b95c037e4f5920104c3c922441d775783c1e288a82a54b9762fdfaf5d8b46913962f5f0e5996273e8668994e7f0281006edebc89f3e7cfe3fcf9f3f8fdf7dfd1d4d404455120cb320cc388764802c194449665a8aa6afe4e79494909d6ae5d8bd2d252ac58b102369b2dea31c5c47486e2fefdfbb870e102cacbcbf1e79f7fa2baba1a3e9f0faaaa429224614402c128288a024551e0f57a2149127272725052528255ab5661f5ead5282e2e86aaaab10e73f298ced3188681aaaa2a545454e0ca952bb874e9126edcb8018fc7035996a1691abc5e2f2669f802c184a2eb3a48c2300c489284b973e7a2a4a404cb962dc3f2e5cb515c5c8cd4d4d45887392493d67486c2eff7a3a6a606d7ae5d435555156edebc896bd7aea1aeae0e7ebfdf3c5f350c434c560ba604168b057ebf1f3e9f0f00e0703850505080a2a22214141460f1e2c558b26409929292621c69e8c495e90c87d7ebc59d3b77505d5d8d9a9a1adcb87103959595b87bf72e3c1e0f0098a3239fcf2726ae059386e007657f6351140599999958bc7831162f5e8cfcfc7c141616223f3f7fc2ae28459329613a23d1d8d888dadada01aaa9a9416d6d2d5a5a5accd3334dd320cbb230254144094ee4024fa60c82fb5b52521266cf9e8d850b1762fefcf9c8cbcb33356bd62c689a16cbb02794296f3a23d1d7d7877bf7eea1b6b6168f1e3d424343031e3e7c68aaa1a1016eb7db2caf280a54554520101013db02a8aa0a455106ed0faaaac2e1702037371773e7ce454e4e0e7273733173e64ccc993307797979484b4b8b61e4b1e599369d5070b95c78f4e811eaebebd1d0d080070f1ea0a9a9094ea713f5f5f5686a6a424b4b0b5c2ed780f7053fe124491a3074164c5e82577f86eb338bc582b4b434646565212b2b0b191919c8cece4676763672737391939383ecec6c646666c62883f840984e84300c03cdcdcd686e6e86d3e9341f074da9adad0d2d2d2d686d6d45474707bababad0dddd3d645daaaa429665489204e0c9ba26b1887264645936d77905090402f0f97c435ee1b45aad484e4e466a6a2aec763b1c0e07d2d2d29096960687c381acac2c381c0e381c0e64646460c68c19484c4c8c664a5316613a31a6bdbd1dededede8e8e818f0b7abab0b6eb71b2e97cb7cdcd3d383d6d656747777a3b7b717ededed70bbddf0783ce8e9e9096bfbc3cd1d446265ea705710c3bd1546d775d32c12131391989888949414d8ed76f3ff69d3a6c166b32121210176bb1d292929a6b1f4ffabebfa78d3138489309d2984c7e3416f6f2f80276606006eb71b7d7d7d20898e8e0e00406f6f2f3c1e0ffc7e3fbababa06d56318c6b0a3b0fef500406262e2b007b0aeeb438e0e6c361bac562b244932d792242424c062b1405114a4a4a4007832d9aa691a545545727272a8cd2098e408d31108045165e2efee120804827e08d31108045145988e4020882aff0797c14104f6a2ecac0000000049454e44ae426082',
> 3: 4363}
> SELECT * FROM (SELECT *, ROWNUM AS R FROM Scheduler WHERE
> JobStatus='0' AND ManualMode=? ORDER BY SCID) WHERE R < 2; {1: TRUE}
> SELECT * FROM Scheduler WHERE JobStatus='b' AND ManualMode=?; {1: FALSE}
>
> Structures of tables involved:
>
> CREATE CACHED TABLE PUBLIC.PROCESSRELATION(
> PRID INT DEFAULT (NEXT VALUE FOR
> PUBLIC.SYSTEM_SEQUENCE_C21C6654_58CC_48B0_9F1B_B17DC181745D) NOT NULL
> NULL_TO_DEFAULT SEQUENCE
> PUBLIC.SYSTEM_SEQUENCE_C21C6654_58CC_48B0_9F1B_B17DC181745D,
> PROCESSLISTIMG BLOB,
> IMGSIZE LONG,
> ESID INT
> )
>
> CREATE CACHED TABLE PUBLIC.SCHEDULER(
> SCID INT DEFAULT (NEXT VALUE FOR
> PUBLIC.SYSTEM_SEQUENCE_DB6D0674_7BF2_4315_A03A_2E859F6E9EB7) NOT NULL
> NULL_TO_DEFAULT SEQUENCE
> PUBLIC.SYSTEM_SEQUENCE_DB6D0674_7BF2_4315_A03A_2E859F6E9EB7
> SELECTIVITY 100,
> ESID INT SELECTIVITY 100,
> FINISHTIME TIMESTAMP SELECTIVITY 94,
> JOBSTATUS CHAR(1) SELECTIVITY 1,
> FILEPATH TEXT SELECTIVITY 100,
> ANALYSISSTAGE CHAR(1) SELECTIVITY 1,
> PARSINGSTAGE CHAR(1) SELECTIVITY 1,
> RULECREATESTAGE CHAR(1) SELECTIVITY 1,
> STAGESTARTTIME TIMESTAMP SELECTIVITY 97,
> MANUALMODE BOOL SELECTIVITY 1,
> MRID INT SELECTIVITY 100,
> ASID INT SELECTIVITY 1
> )
>
> Best Regards.
>
>
>
> Noel Grandin於 2013年5月8日星期三UTC+8下午7時23分18秒寫道：
>
> Hi
>
> Ainimyoung, can you tell me what statements are executing on those
> connections, and what the table structure that the statements are
> querying looks like?
>
> Thanks.
>
> On 2013-05-05 04:33, Ainimyoung wrote:
>> Hi Noel,
>>
>> Thanks for replying.
>> The URL is jdbc:h2:tcp://ip:9092/db
>> We've also tried MULTI_THREAD=TRUE but no help.
>>
>> Best Regards
>>
>> Noel Grandin嚙踝蕭 2013嚙羯5嚙踝蕭4嚙踝蕭P嚙踝蕭嚙踝蕭UTC+8嚙磊嚙
>> 踝蕭7嚙踝蕭 25嚙踝蕭59嚙踝蕭g嚙瘩嚙瘦
>>
>> What does your database URL look like?
>>
>> --
>> You received this message because you are subscribed to the
>> Google Groups "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it,
>> send an email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at
>> http://groups.google.com/group/h2-database?hl=en
>> <http://groups.google.com/group/h2-database?hl=en>.
>> For more options, visit https://groups.google.com/groups/opt_out
>> <https://groups.google.com/groups/opt_out>.
>>
>>
>
> --
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at http://groups.google.com/group/h2-database?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
