You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Bassel Kh <ba...@sphere.ae> on 2008/03/22 00:03:43 UTC
Derby crash (urgent)
Hi,
We have a critical issue with derby (version: 10.3.2) which we use in
embedded mode in our application. Several times (not to say most of the
times), a restart of the application, especially when some transactions are
going on, the database gets corrupted (invalid checksum exception). After
reading many posts about eventual problems in derby, we found problems that
look like ours (for instance:
<http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html>
http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html), but no
clear-cut that the problem has been solved. It is to be noted that we do a
graceful shutdown when closing the application and the logs show successful
executions.
It also looks like only some tables in the database have the problem since
some modules keep running correctly, but there are no conditions or symptoms
prior to the error, it happens at random (we carried on several tests with
different modules on different databases).
Do you have any solution or suggestions to this problem? We have a customer
release going on and we would appreciate if you could reply as soon as
possible.
Please find below the exception we are getting:
Caused by: java.sql.SQLException: Invalid checksum on Page
Page(0,Container(0, 1568)), expected=2,264,079,051, on-disk
version=6,651,942,472,428,708,205, page dump follows: Hex dump:
00000000: 0076 0000 0001 0000 0000 0000 0002 0000 .v..............
00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................
00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
000000c0: 0000 0010 0000 0000 0000 0000 2a73 7973 .............sys
000000d0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
000000e0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
000000f0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
00000100: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
00000110: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
00000120: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
00000130: 7068 6572 652e 6172 656e 612e 6e65 7477 phere.arena.netw
00000140: 6f72 6b4d 616e 6167 6572 2e63 6f6d 6d6f orkManager.commo
00000150: 6e5f 322e 322e 315c 636f 6d6d 6f6e 2e6a n.2.2.1.common.j
00000160: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
00000170: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
00000180: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
00000190: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
000001a0: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
000001b0: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
000001c0: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
000001d0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
000001e0: 744d 616e 6167 6572 5f32 2e32 2e31 5c65 tManager.2.2.1.e
000001f0: 7665 6e74 4d61 6e61 6765 722e 6a61 7227 ventManager.jar.
00000200: 0d0a 2a73 7973 2d70 6163 6b61 6765 2d6d ...sys.package.m
00000210: 6772 2a3a 2070 726f 6365 7373 696e 6720 gr...processing.
00000220: 6e65 7720 6a61 722c 2027 433a 5c50 726f new.jar...C..Pro
00000230: 6772 616d 2046 696c 6573 5c53 7068 6572 gram.Files.Spher
00000240: 6520 4e65 7477 6f72 6b73 5c41 7265 6e61 e.Networks.Arena
00000250: 2050 6c61 7466 6f72 6d5c 706c 7567 696e .Platform.plugin
00000260: 735c 6165 2e73 7068 6572 652e 6172 656e s.ae.sphere.aren
00000270: 612e 7365 7276 6572 2e65 7665 6e74 4d61 a.server.eventMa
00000280: 6e61 6765 725f 322e 322e 315c 6c69 625c nager.2.2.1.lib.
00000290: 6163 7469 7661 7469 6f6e 2e6a 6172 270d activation.jar..
000002a0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
000002b0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
000002c0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
000002d0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
000002e0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
000002f0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
00000300: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
00000310: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
00000320: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
00000330: 616b 6172 7461 2d72 6567 6578 702d 312e akarta.regexp.1.
00000340: 322e 6a61 7227 0d0a 2a73 7973 2d70 6163 2.jar....sys.pac
00000350: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
00000360: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
00000370: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
00000380: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
00000390: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
000003a0: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
000003b0: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
000003c0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
000003d0: 315c 6c69 625c 4a43 7570 2e6a 6172 270d 1.lib.JCup.jar..
000003e0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
000003f0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
00000400: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
00000410: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
00000420: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
00000430: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
00000440: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
00000450: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
00000460: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
00000470: 6772 6f75 7073 2d61 6c6c 2e6a 6172 270d groups.all.jar..
00000480: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
00000490: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
000004a0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
000004b0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
000004c0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
000004d0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
000004e0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
000004f0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
00000500: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
00000510: 6d73 2e6a 6172 270d 0a2a 7379 732d 7061 ms.jar....sys.pa
00000520: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
00000530: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
00000540: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
00000550: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
00000560: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
00000570: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
00000580: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
00000590: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
000005a0: 2e31 5c6c 6962 5c6a 6d78 7269 2e6a 6172 .1.lib.jmxri.jar
000005b0: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
000005c0: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
000005d0: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
000005e0: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
000005f0: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
00000600: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
00000610: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
00000620: 6e61 2e73 6572 7665 722e 6576 656e 744d na.server.eventM
00000630: 616e 6167 6572 5f32 2e32 2e31 5c6c 6962 anager.2.2.1.lib
00000640: 5c6a 6d78 746f 6f6c 732e 6a61 7227 0d0a .jmxtools.jar...
00000650: 2a73 7973 2d70 6163 6b61 6765 2d6d 6772 .sys.package.mgr
00000660: 2a3a 2070 726f 6365 7373 696e 6720 6e65 ...processing.ne
00000670: 7720 6a61 722c 2027 433a 5c50 726f 6772 w.jar...C..Progr
00000680: 616d 2046 696c 6573 5c53 7068 6572 6520 am.Files.Sphere.
00000690: 4e65 7477 6f72 6b73 5c41 7265 6e61 2050 Networks.Arena.P
000006a0: 6c61 7466 6f72 6d5c 706c 7567 696e 735c latform.plugins.
000006b0: 6165 2e73 7068 6572 652e 6172 656e 612e ae.sphere.arena.
000006c0: 7365 7276 6572 2e65 7665 6e74 4d61 6e61 server.eventMana
000006d0: 6765 725f 322e 322e 315c 6c69 625c 6a6e ger.2.2.1.lib.jn
000006e0: 6469 2e6a 6172 270d 0a2a 7379 732d 7061 di.jar....sys.pa
000006f0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
00000700: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
00000710: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
00000720: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
00000730: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
00000740: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
00000750: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
00000760: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
00000770: 2e31 5c6c 6962 5c6a 6f72 616d 2d63 6c69 .1.lib.joram.cli
00000780: 656e 742e 6a61 7227 0d0a 2a73 7973 2d70 ent.jar....sys.p
00000790: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
000007a0: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
000007b0: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
000007c0: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
000007d0: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
000007e0: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
000007f0: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
00000800: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
00000810: 322e 315c 6c69 625c 6a6f 7261 6d2d 6d6f 2.1.lib.joram.mo
00000820: 6d2e 6a61 7227 0d0a 2a73 7973 2d70 6163 m.jar....sys.pac
00000830: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
00000840: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
00000850: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
00000860: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
00000870: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
00000880: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
00000890: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
000008a0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
000008b0: 315c 6c69 625c 6a6f 7261 6d2d 7368 6172 1.lib.joram.shar
000008c0: 6564 2e6a 6172 270d 0a2a 7379 732d 7061 ed.jar....sys.pa
000008d0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
000008e0: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
000008f0: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
00000900: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
00000910: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
00000920: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
00000930: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
00000940: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
00000950: 2e31 5c6c 6962 5c6a 7461 2e6a 6172 270d .1.lib.jta.jar..
00000960: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
00000970: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
00000980: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
00000990: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
000009a0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
000009b0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
000009c0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
000009d0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
000009e0: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6b ager.2.2.1.lib.k
000009f0: 786d 6c2e 6a61 7227 0d0a 2a73 7973 2d70 xml.jar....sys.p
00000a00: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
00000a10: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
00000a20: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
00000a30: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
00000a40: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
00000a50: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
00000a60: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
00000a70: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
00000a80: 322e 315c 6c69 625c 6d69 6470 6170 692e 2.1.lib.midpapi.
00000a90: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
00000aa0: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
00000ab0: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
00000ac0: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
00000ad0: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
00000ae0: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
00000af0: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
00000b00: 6172 656e 612e 7365 7276 6572 2e65 7665 arena.server.eve
00000b10: 6e74 4d61 6e61 6765 725f 322e 322e 315c ntManager.2.2.1.
00000b20: 6c69 625c 6f77 5f6d 6f6e 6f6c 6f67 2e6a lib.ow.monolog.j
00000b30: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
00000b40: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
00000b50: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
00000b60: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
00000b70: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
00000b80: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
00000b90: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
00000ba0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
00000bb0: 744d 616e 6167 6572 5f32 2e32 2e31 5c6c tManager.2.2.1.l
00000bc0: 6962 5c73 6f61 702e 6a61 7227 0d0a 2a73 ib.soap.jar....s
00000bd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
00000be0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
00000bf0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
00000c00: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
00000c10: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
00000c20: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
00000c30: 2e73 7068 6572 652e 6172 656e 612e 6c6f .sphere.arena.lo
00000c40: 675f 322e 322e 315c 736c 6f67 2e6a 6172 g.2.2.1.slog.jar
00000c50: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
00000c60: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
00000c70: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
00000c80: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
00000c90: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
00000ca0: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
00000cb0: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
00000cc0: 6e61 2e6c 6f67 5f32 2e32 2e31 5c6c 6962 na.log.2.2.1.lib
00000cd0: 5c63 6f6d 6d6f 6e73 2d6c 6f67 6769 6e67 .commons.logging
00000ce0: 2d31 2e30 2e34 2e6a 6172 270d 0a2a 7379 .1.0.4.jar....sy
00000cf0: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
00000d00: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
00000d10: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
00000d20: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
00000d30: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
00000d40: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
00000d50: 7370 6865 7265 2e61 7265 6e61 2e6c 6f67 sphere.arena.log
00000d60: 5f32 2e32 2e31 5c6c 6962 5c6c 6f67 346a .2.2.1.lib.log4j
00000d70: 2d31 2e32 2e31 322e 6a61 7227 0d0a 2a73 .1.2.12.jar....s
00000d80: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
00000d90: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
00000da0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
00000db0: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
00000dc0: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
00000dd0: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
00000de0: 2e73 7068 6572 652e 6172 656e 612e 6e65 .sphere.arena.ne
00000df0: 7477 6f72 6b4d 616e 6167 6572 2e64 6973 tworkManager.dis
00000e00: 636f 7665 7279 5f32 2e33 2e30 5c64 6973 covery.2.3.0.dis
00000e10: 636f 7665 7279 2e6a 6172 270d 0a2a 7379 covery.jar....sy
00000e20: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
00000e30: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
00000e40: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
00000e50: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
00000e60: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
00000e70: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
00000e80: 7370 6865 7265 2e61 7265 6e61 2e73 6572 sphere.arena.ser
00000e90: 7665 725f 322e 322e 315c 6172 656e 6153 ver.2.2.1.arenaS
00000ea0: 6572 7665 722e 6a61 7227 0d0a 2a73 7973 erver.jar....sys
00000eb0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
00000ec0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
00000ed0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
00000ee0: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
00000ef0: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
00000f00: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
00000f10: 7068 6572 652e 6172 656e 612e 636f 6d6d phere.arena.comm
00000f20: 6f6e 5f32 2e32 2e31 5c63 6f6d 6d6f 6e2e on.2.2.1.common.
00000f30: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
00000f40: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
00000f50: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
00000f60: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
00000f70: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
00000f80: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
00000f90: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
00000fa0: 6172 656e 612e 636f 6d6d 6f6e 5f32 2e32 arena.common.2.2
00000fb0: 2e31 5c6c 6962 5c63 6f6d 6d6f 6e73 2d6c .1.lib.commons.l
00000fc0: 616e 672d 322e 332e 6a61 7227 0d0a 2a73 ang.2.3.jar....s
00000fd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
00000fe0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
00000ff0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknow
n Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooSta
tementCache.java:525)
at
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolA
synchronousRunner.java:547)
Thanks,
Bassel
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Guys,
I also found this bug mentioned here:
https://issues.apache.org/jira/browse/DERBY-2475
They say that the bug is resolved but as I see; it is not yet closed.
What do you say?
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16539600.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Hi,
I found that the corruption is happening when I startup the server not
shutdown,
I checked how hibernate creates a connections, for connection pooling; I’m
using (C3P0)
I disabled that one, and now the derby is working fine without any
corruption.
I disabled C3P0 (connection pool), and now the problem is not happening
again,
I’ll try to do more investigation about this issue, and I’ll share the
result ASAP
Thanks
Bassel Kh-2 wrote:
>
> Hi,
>
>
>
> We have a critical issue with derby (version: 10.3.2) which we use in
> embedded mode in our application. Several times (not to say most of the
> times), a restart of the application, especially when some transactions
> are
> going on, the database gets corrupted (invalid checksum exception). After
> reading many posts about eventual problems in derby, we found problems
> that
> look like ours (for instance:
> <http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html>
> http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html), but no
> clear-cut that the problem has been solved. It is to be noted that we do a
> graceful shutdown when closing the application and the logs show
> successful
> executions.
>
> It also looks like only some tables in the database have the problem since
> some modules keep running correctly, but there are no conditions or
> symptoms
> prior to the error, it happens at random (we carried on several tests with
> different modules on different databases).
>
> Do you have any solution or suggestions to this problem? We have a
> customer
> release going on and we would appreciate if you could reply as soon as
> possible.
>
>
>
> Please find below the exception we are getting:
>
>
>
> Caused by: java.sql.SQLException: Invalid checksum on Page
> Page(0,Container(0, 1568)), expected=2,264,079,051, on-disk
> version=6,651,942,472,428,708,205, page dump follows: Hex dump:
> 00000000: 0076 0000 0001 0000 0000 0000 0002 0000 .v..............
> 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
> 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................
> 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
> 00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
> 00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000c0: 0000 0010 0000 0000 0000 0000 2a73 7973 .............sys
> 000000d0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
> 000000e0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
> 000000f0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
> 00000100: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
> 00000110: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
> 00000120: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
> 00000130: 7068 6572 652e 6172 656e 612e 6e65 7477 phere.arena.netw
> 00000140: 6f72 6b4d 616e 6167 6572 2e63 6f6d 6d6f orkManager.commo
> 00000150: 6e5f 322e 322e 315c 636f 6d6d 6f6e 2e6a n.2.2.1.common.j
> 00000160: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
> 00000170: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
> 00000180: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
> 00000190: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
> 000001a0: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
> 000001b0: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
> 000001c0: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
> 000001d0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
> 000001e0: 744d 616e 6167 6572 5f32 2e32 2e31 5c65 tManager.2.2.1.e
> 000001f0: 7665 6e74 4d61 6e61 6765 722e 6a61 7227 ventManager.jar.
> 00000200: 0d0a 2a73 7973 2d70 6163 6b61 6765 2d6d ...sys.package.m
> 00000210: 6772 2a3a 2070 726f 6365 7373 696e 6720 gr...processing.
> 00000220: 6e65 7720 6a61 722c 2027 433a 5c50 726f new.jar...C..Pro
> 00000230: 6772 616d 2046 696c 6573 5c53 7068 6572 gram.Files.Spher
> 00000240: 6520 4e65 7477 6f72 6b73 5c41 7265 6e61 e.Networks.Arena
> 00000250: 2050 6c61 7466 6f72 6d5c 706c 7567 696e .Platform.plugin
> 00000260: 735c 6165 2e73 7068 6572 652e 6172 656e s.ae.sphere.aren
> 00000270: 612e 7365 7276 6572 2e65 7665 6e74 4d61 a.server.eventMa
> 00000280: 6e61 6765 725f 322e 322e 315c 6c69 625c nager.2.2.1.lib.
> 00000290: 6163 7469 7661 7469 6f6e 2e6a 6172 270d activation.jar..
> 000002a0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 000002b0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 000002c0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 000002d0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000002e0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000002f0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 00000300: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 00000310: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000320: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000330: 616b 6172 7461 2d72 6567 6578 702d 312e akarta.regexp.1.
> 00000340: 322e 6a61 7227 0d0a 2a73 7973 2d70 6163 2.jar....sys.pac
> 00000350: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
> 00000360: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
> 00000370: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
> 00000380: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
> 00000390: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
> 000003a0: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
> 000003b0: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
> 000003c0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
> 000003d0: 315c 6c69 625c 4a43 7570 2e6a 6172 270d 1.lib.JCup.jar..
> 000003e0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 000003f0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 00000400: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 00000410: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 00000420: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 00000430: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 00000440: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 00000450: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000460: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000470: 6772 6f75 7073 2d61 6c6c 2e6a 6172 270d groups.all.jar..
> 00000480: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 00000490: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 000004a0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 000004b0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000004c0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000004d0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 000004e0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 000004f0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000500: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000510: 6d73 2e6a 6172 270d 0a2a 7379 732d 7061 ms.jar....sys.pa
> 00000520: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 00000530: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 00000540: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000550: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000560: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000570: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000580: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000590: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 000005a0: 2e31 5c6c 6962 5c6a 6d78 7269 2e6a 6172 .1.lib.jmxri.jar
> 000005b0: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
> 000005c0: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
> 000005d0: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
> 000005e0: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
> 000005f0: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
> 00000600: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
> 00000610: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
> 00000620: 6e61 2e73 6572 7665 722e 6576 656e 744d na.server.eventM
> 00000630: 616e 6167 6572 5f32 2e32 2e31 5c6c 6962 anager.2.2.1.lib
> 00000640: 5c6a 6d78 746f 6f6c 732e 6a61 7227 0d0a .jmxtools.jar...
> 00000650: 2a73 7973 2d70 6163 6b61 6765 2d6d 6772 .sys.package.mgr
> 00000660: 2a3a 2070 726f 6365 7373 696e 6720 6e65 ...processing.ne
> 00000670: 7720 6a61 722c 2027 433a 5c50 726f 6772 w.jar...C..Progr
> 00000680: 616d 2046 696c 6573 5c53 7068 6572 6520 am.Files.Sphere.
> 00000690: 4e65 7477 6f72 6b73 5c41 7265 6e61 2050 Networks.Arena.P
> 000006a0: 6c61 7466 6f72 6d5c 706c 7567 696e 735c latform.plugins.
> 000006b0: 6165 2e73 7068 6572 652e 6172 656e 612e ae.sphere.arena.
> 000006c0: 7365 7276 6572 2e65 7665 6e74 4d61 6e61 server.eventMana
> 000006d0: 6765 725f 322e 322e 315c 6c69 625c 6a6e ger.2.2.1.lib.jn
> 000006e0: 6469 2e6a 6172 270d 0a2a 7379 732d 7061 di.jar....sys.pa
> 000006f0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 00000700: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 00000710: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000720: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000730: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000740: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000750: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000760: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 00000770: 2e31 5c6c 6962 5c6a 6f72 616d 2d63 6c69 .1.lib.joram.cli
> 00000780: 656e 742e 6a61 7227 0d0a 2a73 7973 2d70 ent.jar....sys.p
> 00000790: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
> 000007a0: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
> 000007b0: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
> 000007c0: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
> 000007d0: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
> 000007e0: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
> 000007f0: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
> 00000800: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
> 00000810: 322e 315c 6c69 625c 6a6f 7261 6d2d 6d6f 2.1.lib.joram.mo
> 00000820: 6d2e 6a61 7227 0d0a 2a73 7973 2d70 6163 m.jar....sys.pac
> 00000830: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
> 00000840: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
> 00000850: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
> 00000860: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
> 00000870: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
> 00000880: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
> 00000890: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
> 000008a0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
> 000008b0: 315c 6c69 625c 6a6f 7261 6d2d 7368 6172 1.lib.joram.shar
> 000008c0: 6564 2e6a 6172 270d 0a2a 7379 732d 7061 ed.jar....sys.pa
> 000008d0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 000008e0: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 000008f0: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000900: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000910: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000920: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000930: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000940: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 00000950: 2e31 5c6c 6962 5c6a 7461 2e6a 6172 270d .1.lib.jta.jar..
> 00000960: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 00000970: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 00000980: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 00000990: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000009a0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000009b0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 000009c0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 000009d0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 000009e0: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6b ager.2.2.1.lib.k
> 000009f0: 786d 6c2e 6a61 7227 0d0a 2a73 7973 2d70 xml.jar....sys.p
> 00000a00: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
> 00000a10: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
> 00000a20: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
> 00000a30: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
> 00000a40: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
> 00000a50: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
> 00000a60: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
> 00000a70: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
> 00000a80: 322e 315c 6c69 625c 6d69 6470 6170 692e 2.1.lib.midpapi.
> 00000a90: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
> 00000aa0: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
> 00000ab0: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
> 00000ac0: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
> 00000ad0: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
> 00000ae0: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
> 00000af0: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
> 00000b00: 6172 656e 612e 7365 7276 6572 2e65 7665 arena.server.eve
> 00000b10: 6e74 4d61 6e61 6765 725f 322e 322e 315c ntManager.2.2.1.
> 00000b20: 6c69 625c 6f77 5f6d 6f6e 6f6c 6f67 2e6a lib.ow.monolog.j
> 00000b30: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
> 00000b40: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
> 00000b50: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
> 00000b60: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
> 00000b70: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
> 00000b80: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
> 00000b90: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
> 00000ba0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
> 00000bb0: 744d 616e 6167 6572 5f32 2e32 2e31 5c6c tManager.2.2.1.l
> 00000bc0: 6962 5c73 6f61 702e 6a61 7227 0d0a 2a73 ib.soap.jar....s
> 00000bd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000be0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000bf0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
> 00000c00: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
> 00000c10: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
> 00000c20: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
> 00000c30: 2e73 7068 6572 652e 6172 656e 612e 6c6f .sphere.arena.lo
> 00000c40: 675f 322e 322e 315c 736c 6f67 2e6a 6172 g.2.2.1.slog.jar
> 00000c50: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
> 00000c60: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
> 00000c70: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
> 00000c80: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
> 00000c90: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
> 00000ca0: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
> 00000cb0: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
> 00000cc0: 6e61 2e6c 6f67 5f32 2e32 2e31 5c6c 6962 na.log.2.2.1.lib
> 00000cd0: 5c63 6f6d 6d6f 6e73 2d6c 6f67 6769 6e67 .commons.logging
> 00000ce0: 2d31 2e30 2e34 2e6a 6172 270d 0a2a 7379 .1.0.4.jar....sy
> 00000cf0: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
> 00000d00: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
> 00000d10: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
> 00000d20: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
> 00000d30: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
> 00000d40: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
> 00000d50: 7370 6865 7265 2e61 7265 6e61 2e6c 6f67 sphere.arena.log
> 00000d60: 5f32 2e32 2e31 5c6c 6962 5c6c 6f67 346a .2.2.1.lib.log4j
> 00000d70: 2d31 2e32 2e31 322e 6a61 7227 0d0a 2a73 .1.2.12.jar....s
> 00000d80: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000d90: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000da0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
> 00000db0: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
> 00000dc0: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
> 00000dd0: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
> 00000de0: 2e73 7068 6572 652e 6172 656e 612e 6e65 .sphere.arena.ne
> 00000df0: 7477 6f72 6b4d 616e 6167 6572 2e64 6973 tworkManager.dis
> 00000e00: 636f 7665 7279 5f32 2e33 2e30 5c64 6973 covery.2.3.0.dis
> 00000e10: 636f 7665 7279 2e6a 6172 270d 0a2a 7379 covery.jar....sy
> 00000e20: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
> 00000e30: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
> 00000e40: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
> 00000e50: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
> 00000e60: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
> 00000e70: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
> 00000e80: 7370 6865 7265 2e61 7265 6e61 2e73 6572 sphere.arena.ser
> 00000e90: 7665 725f 322e 322e 315c 6172 656e 6153 ver.2.2.1.arenaS
> 00000ea0: 6572 7665 722e 6a61 7227 0d0a 2a73 7973 erver.jar....sys
> 00000eb0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
> 00000ec0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
> 00000ed0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
> 00000ee0: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
> 00000ef0: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
> 00000f00: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
> 00000f10: 7068 6572 652e 6172 656e 612e 636f 6d6d phere.arena.comm
> 00000f20: 6f6e 5f32 2e32 2e31 5c63 6f6d 6d6f 6e2e on.2.2.1.common.
> 00000f30: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
> 00000f40: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
> 00000f50: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
> 00000f60: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
> 00000f70: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
> 00000f80: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
> 00000f90: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
> 00000fa0: 6172 656e 612e 636f 6d6d 6f6e 5f32 2e32 arena.common.2.2
> 00000fb0: 2e31 5c6c 6962 5c63 6f6d 6d6f 6e73 2d6c .1.lib.commons.l
> 00000fc0: 616e 672d 322e 332e 6a61 7227 0d0a 2a73 ang.2.3.jar....s
> 00000fd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000fe0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000ff0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
>
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknow
> n Source)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
> at
> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
> Source)
> at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown
> Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooSta
> tementCache.java:525)
> at
> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolA
> synchronousRunner.java:547)
>
>
>
>
>
> Thanks,
>
>
>
> Bassel
>
>
>
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16585357.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by shabz <sh...@sphere.ae>.
Its old DB generated with 10.3
Knut Anders Hatlen wrote:
>
> Bassel_kh <bk...@hotmail.com> writes:
>
>> Actually, I removed C3P0 totally, and upgraded derby to 10.4, the new
>> Exception occured:
>
> Hi,
>
> Did you create a new database after upgrading to Derby 10.4, or did you
> continue with an old database created with an earlier version of Derby?
> I'm asking this to find out if this is a new bug or a know bug that was
> fixed in Derby 10.4. If the database has become corrupted (as we know
> could happen with some of the 10.2 and 10.3 releases), upgrading Derby
> won't help you accessing that database.
>
>> I got tired of using Derby, It is not that professional, and still not
>> stable!!
>
> If it is possible, it would be great if you could post some code to
> reproduce the problem. That would be very helpful for those who would
> like to track it down and make Derby more stable.
>
>> Also new bug came today: Inconsistent index!!
>
> My guess is that it is probably not a new bug, just a different
> manifestation of the same one. Since it seems like your database has
> become corrupted, all sorts of errors may happen, and the exact error
> message may vary depending on which operation is performed when the
> damaged data is accessed.
>
> --
> Knut Anders
>
>
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p17794274.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Knut Anders Hatlen wrote:
>
> Bassel_kh <bk...@hotmail.com> writes:
>
>> Actually, I removed C3P0 totally, and upgraded derby to 10.4, the new
>> Exception occured:
>
> Hi,
>
> Did you create a new database after upgrading to Derby 10.4, or did you
> continue with an old database created with an earlier version of Derby?
> I'm asking this to find out if this is a new bug or a know bug that was
> fixed in Derby 10.4. If the database has become corrupted (as we know
> could happen with some of the 10.2 and 10.3 releases), upgrading Derby
> won't help you accessing that database.
>
>
I got this problem earlier, so I created a new database using derby 10.4,
and then migrated the data from the old one, the same exception thrown:
Database Class Loader started - derby.database.classpath=''
2008-06-12 11:42:47.937 GMT Thread[WrapperSimpleAppMain,5,main] (XID =
14975), (SESSIONID = 0), (DATABASE = db/Arena), (DRDAID = null), Cleanup
action starting
2008-06-12 11:42:47.937 GMT Thread[WrapperSimpleAppMain,5,main] (XID =
14975), (SESSIONID = 0), (DATABASE = db/Arena), (DRDAID = null), Failed
Statement is: select user0_.ID as ID6_, user0_.USERNAME as USERNAME6_,
user0_.PASSWORD as PASSWORD6_, user0_.ROLE_ID as ROLE4_6_ from Arena.USERS
user0_
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at org.apache.derby.impl.store.raw.data.AllocPage.ReadContainerInfo(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.readHeader(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
at org.hibernate.loader.Loader.list(Loader.java:2021)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:137)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1014)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at ae.sphere.arena.db.dao.UserDAO.getAllUsers(UserDAO.java:52)
at
ae.sphere.arena.server.eventManager.EventManagerPlugin.createUsers(EventManagerPlugin.java:384)
at
ae.sphere.arena.server.eventManager.EventManagerPlugin.startJmsServer(EventManagerPlugin.java:277)
at
ae.sphere.arena.server.eventManager.EventServerStartup.start(EventServerStartup.java:9)
at
ae.sphere.arena.server.ArenaServerPlugin.startArenaStartupMembers(ArenaServerPlugin.java:201)
at
ae.sphere.arena.server.ArenaServerPlugin.start(ArenaServerPlugin.java:185)
at
ae.sphere.arena.server.ArenaServerApplication.run(ArenaServerApplication.java:29)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:237)
at java.lang.Thread.run(Unknown Source)
Cleanup action completed
2008-06-12 11:42:57.664 GMT Thread[WrapperSimpleAppMain,5,main] (XID =
14983), (SESSIONID = 1), (DATABASE = db/Arena), (DRDAID = null), Cleanup
action starting
2008-06-12 11:42:57.664 GMT Thread[WrapperSimpleAppMain,5,main] (XID =
14983), (SESSIONID = 1), (DATABASE = db/Arena), (DRDAID = null), Failed
Statement is: insert into Arena.NOTIFICATION_SCHEDULER (NAME, MATCH_TYPE,
ENABLED, STATUS, LAST_RUN_TIME, IS_NOTIFIER, SYSTEM_NOTIFIER_ID,
COMPOSITECATEGORY, ACCESSRIGHTS, USER_ID, ID) values (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) with 11 parameters begin parameter #1: Fault Notification :end
parameter begin parameter #2: 1 :end parameter begin parameter #3: 1 :end
parameter begin parameter #4: null :end parameter begin parameter #5: null
:end parameter begin parameter #6: 1 :end parameter begin parameter #7: NULL
:end parameter begin parameter #8:
ae.sphere.arena.networkmanager.faultManager.notifications :end parameter
begin parameter #9: M#MA :end parameter begin parameter #10: null :end
parameter begin parameter #11: 87870 :end parameter
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at org.apache.derby.impl.store.raw.data.AllocPage.ReadContainerInfo(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.readHeader(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.getDynamicCompiledConglomInfo(Unknown
Source)
at org.apache.derby.impl.sql.execute.GenericRIChecker.<init>(Unknown
Source)
at org.apache.derby.impl.sql.execute.ForeignKeyRIChecker.<init>(Unknown
Source)
at org.apache.derby.impl.sql.execute.RISetChecker.<init>(Unknown Source)
at
org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown
Source)
at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:23)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2061)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2426)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:908)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:344)
at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at
ae.sphere.arena.db.dao.base._BaseRootDAO.commitTransaction(_BaseRootDAO.java:226)
at ae.sphere.arena.db.dao.base._BaseRootDAO.run(_BaseRootDAO.java:790)
at ae.sphere.arena.db.dao.base._BaseRootDAO.save(_BaseRootDAO.java:649)
at
ae.sphere.arena.db.dao.base.BaseNotificationSchedulerDAO.save(BaseNotificationSchedulerDAO.java:103)
at
ae.sphere.arena.server.notifications.NotificationsManager.setSystemNotification(NotificationsManager.java:327)
at
ae.sphere.arena.server.notifications.NotificationsManager.handleServerEvent(NotificationsManager.java:814)
at
ae.sphere.arena.server.eventManager.EventManager.sendServerEvent(EventManager.java:164)
at
ae.sphere.arena.networkManager.server.faultManager.ServerFaultManagerPlugin.<init>(ServerFaultManagerPlugin.java:90)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown
Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.loadBundleActivator(AbstractBundle.java:136)
at
org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:966)
at
org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:317)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:256)
at
org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.preFindLocalClass(EclipseLazyStarter.java:86)
at
org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:409)
at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:188)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:339)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:391)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:352)
at
org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:83)
at java.lang.ClassLoader.loadClass(Unknown Source)
at
org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:276)
at
org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at
org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1245)
at
org.eclipse.core.internal.registry.osgi.RegistryStrategyOSGI.createExecutableExtension(RegistryStrategyOSGI.java:147)
at
org.eclipse.core.internal.registry.ExtensionRegistry.createExecutableExtension(ExtensionRegistry.java:759)
at
org.eclipse.core.internal.registry.ConfigurationElement.createExecutableExtension(ConfigurationElement.java:243)
at
org.eclipse.core.internal.registry.ConfigurationElementHandle.createExecutableExtension(ConfigurationElementHandle.java:51)
at
ae.sphere.arena.server.eventManager.EventManagerPlugin.computeServerManagers(EventManagerPlugin.java:124)
at
ae.sphere.arena.server.eventManager.EventManagerPlugin.getServerManagers(EventManagerPlugin.java:242)
at
ae.sphere.arena.server.eventManager.EventServerStartup.start(EventServerStartup.java:10)
at
ae.sphere.arena.server.ArenaServerPlugin.startArenaStartupMembers(ArenaServerPlugin.java:201)
at
ae.sphere.arena.server.ArenaServerPlugin.start(ArenaServerPlugin.java:185)
at
ae.sphere.arena.server.ArenaServerApplication.run(ArenaServerApplication.java:29)
at
org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.core.launcher.Main.invokeFramework(Main.java:334)
at org.eclipse.core.launcher.Main.basicRun(Main.java:278)
at org.eclipse.core.launcher.Main.run(Main.java:973)
at org.eclipse.core.launcher.Main.main(Main.java:948)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:237)
at java.lang.Thread.run(Unknown Source)
>
>> I got tired of using Derby, It is not that professional, and still not
>> stable!!
>
> If it is possible, it would be great if you could post some code to
> reproduce the problem. That would be very helpful for those who would
> like to track it down and make Derby more stable.
>
I'll try to create a sample in order to reproduce this exception again ASAP,
but the thing is we are in a very critical situation, and we have a
presentation after 2 days
>> Also new bug came today: Inconsistent index!!
>
> My guess is that it is probably not a new bug, just a different
> manifestation of the same one. Since it seems like your database has
> become corrupted, all sorts of errors may happen, and the exact error
> message may vary depending on which operation is performed when the
> damaged data is accessed.
>
>
I hope so
Thanks
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p17798347.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Knut Anders Hatlen <Kn...@Sun.COM>.
Bassel_kh <bk...@hotmail.com> writes:
> Actually, I removed C3P0 totally, and upgraded derby to 10.4, the new
> Exception occured:
Hi,
Did you create a new database after upgrading to Derby 10.4, or did you
continue with an old database created with an earlier version of Derby?
I'm asking this to find out if this is a new bug or a know bug that was
fixed in Derby 10.4. If the database has become corrupted (as we know
could happen with some of the 10.2 and 10.3 releases), upgrading Derby
won't help you accessing that database.
> I got tired of using Derby, It is not that professional, and still not
> stable!!
If it is possible, it would be great if you could post some code to
reproduce the problem. That would be very helpful for those who would
like to track it down and make Derby more stable.
> Also new bug came today: Inconsistent index!!
My guess is that it is probably not a new bug, just a different
manifestation of the same one. Since it seems like your database has
become corrupted, all sorts of errors may happen, and the exact error
message may vary depending on which operation is performed when the
damaged data is accessed.
--
Knut Anders
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Actually, I removed C3P0 totally, and upgraded derby to 10.4, the new
Exception occured:
2008-06-11 10:50:37.997 GMT Thread[Worker-60,5,main] (XID = 825230855),
(SESSIONID = 29), (DATABASE = db/networkManager), (DRDAID = null), Cleanup
action starting
2008-06-11 10:50:37.997 GMT Thread[Worker-60,5,main] (XID = 825230855),
(SESSIONID = 29), (DATABASE = db/networkManager), (DRDAID = null), Failed
Statement is: select monitor.status as status , count(monitor.status) as
statusCount , sum (monitor.metthresholdtimes) as thresholdTimes from
NetworkManager.ACTIVE_MONITOR as monitor where monitor.col1 <> 'Yes' group
by monitor.status
java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method)
at org.apache.derby.impl.store.raw.data.AllocPage.ReadContainerInfo(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.readHeader(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(Unknown
Source)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(Unknown
Source)
at org.apache.derby.impl.services.cache.ConcurrentCache.find(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
at
org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
Source)
at
org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
Source)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
Source)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
Source)
at
org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
Source)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
Source)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown
Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:368)
at
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
at org.hibernate.loader.Loader.list(Loader.java:2021)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:109)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1475)
at
org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:121)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:168)
I got tired of using Derby, It is not that professional, and still not
stable!!
I don’t know how they included it in Java 6!!!
Also new bug came today: Inconsistent index!!
I think Derby 100.100 will be stable, isn’t it?
Kristian Waagan-4 wrote:
>
> Bassel_kh skrev:
>> Guys,
>> I'm still waiting for any reply..
>>
>
> You wrote that removing c3p0 reduced the frequency of the corruption. Is
> it just reduced, or has it gone away completely?
> If it still happens, are you getting the same stack trace?
> Is the corruption still on page 0?
>
> If you have have possibility to try out the latest release candidate for
> 10.4, I would suggest doing that. A fix went in for a possibly related
> bug, where page 0 was corrupted.
>
>
> --
> Kristian
>
>> kindly help me :(
>>
>
>
>
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p17778534.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Kristian Waagan <Kr...@Sun.COM>.
Bassel_kh skrev:
> Guys,
> I'm still waiting for any reply..
>
You wrote that removing c3p0 reduced the frequency of the corruption. Is
it just reduced, or has it gone away completely?
If it still happens, are you getting the same stack trace?
Is the corruption still on page 0?
If you have have possibility to try out the latest release candidate for
10.4, I would suggest doing that. A fix went in for a possibly related
bug, where page 0 was corrupted.
--
Kristian
> kindly help me :(
>
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Guys,
I'm still waiting for any reply..
kindly help me :(
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16751000.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
Dear Matrigali,
The problem is not happening for a specific table, it is random.
And I’m using Hard disk neither a network nor flash.
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16537514.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Mike Matrigali <mi...@sbcglobal.net>.
If you can narrow down to a specific table, then giving the ddl of that
table may help. Also if you are familar with the data that is supposed
to be in that table could you comment on if the hex dump looks sort of
valid? If you look at the right hand side of the hex dump it just
prints the ascii of whatever characters are there - at the level it is
dumping it does not really know the datatype. But that dump looks
really bad as the end of the page should have a backward growing list of
basically pointers into the data portion of the page which grows
forward, but it looks like there is ascii all the way to the end of the
page.
Is the target device of the database something normal like and ide or
scsi disk, or something else like network, flash, ...
As stan mentions any info you can provide about version, jvm, os, and
hardware may lend clues.
Stanley Bradbury wrote:
> -- top posting --
> Hi Bassel -
> It would help to have the information from SYSINFO (version, platform
> and JVM). Are you able to recover from this or is the database lost?
>
> It sounds like you understand what is going on - database pages are either
> 1) not being written to disk properly - OR -
> 2) are being corrupted / deleted once they are written to disk
> Hence the files on disk are not in sync as evidenced by the checksums
> are not matching what is expected.
>
> The JVM, OS and underlying hardware handle the writes so I would start
> by looking at your JVM, your I/O and storage systems. Check the logs
> for errors, etc.
> I am aware of an intermittent 'Invalid Checksum' failure that stopped
> happening after upgrading from an initial release of a JVM to the
> current release/update of the JVM. If possible, test with an alternate
> JVM to see if the problem happens when using JVMs from multiple vendors.
>
> Once these possibilities are eliminated look at the application and
> runtime environment. Could you be double booting the database? In most
> cases Derby prevents double booting but on some OSs and older JVMs it
> could still be a problem. It is possible to double boot Derby within a
> single JVM by loading the Derby driver TWICE in different classloaders.
> If you are using multiple classloaders be sure to check for this.
>
> Lastly be sure you are using regular (not-buffered) I/O to a disk that
> is physically connected to the machine. I/O to network mounted disks is
> not reliable.
>
> This is all I can think of at the moment. Good luck with chasing this
> down. Please post what you find so others can benefit from your findings.
>
> Bassel Kh wrote:
>>
>> Hi,
>>
>>
>>
>> We have a critical issue with derby (version: *10.3.2*) which we use
>> in embedded mode in our application. Several times (not to say most of
>> the times), a restart of the application, especially when some
>> transactions are going on, the database gets corrupted (invalid
>> checksum exception). After reading many posts about eventual problems
>> in derby, we found problems that look like ours (for instance:
>> http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html),
>> but no clear-cut that the problem has been solved. It is to be noted
>> that we do a graceful shutdown when closing the application and the
>> logs show successful executions.
>>
>> It also looks like only some tables in the database have the problem
>> since some modules keep running correctly, but there are no conditions
>> or symptoms prior to the error, it happens at random (we carried on
>> several tests with different modules on different databases).
>>
>> Do you have any solution or suggestions to this problem? We have a
>> customer release going on and we would appreciate if you could reply
>> as soon as possible.
>>
>>
>>
>> Please find below the exception we are getting:
>>
>>
>>
>> Caused by: java.sql.SQLException: Invalid checksum on Page
>> Page(0,Container(0, 1568)), expected=2,264,079,051, on-disk
>> version=6,651,942,472,428,708,205, page dump follows: Hex dump:
>> 00000000: 0076 0000 0001 0000 0000 0000 0002 0000 .v..............
>> 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
>> 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................
>> 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
>> 00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
>> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
>> 00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
>> 000000c0: 0000 0010 0000 0000 0000 0000 2a73 7973 .............sys
>> 000000d0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
>> 000000e0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
>> 000000f0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
>> 00000100: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
>> 00000110: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
>> 00000120: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
>> 00000130: 7068 6572 652e 6172 656e 612e 6e65 7477 phere.arena.netw
>> 00000140: 6f72 6b4d 616e 6167 6572 2e63 6f6d 6d6f orkManager.commo
>> 00000150: 6e5f 322e 322e 315c 636f 6d6d 6f6e 2e6a n.2.2.1.common.j
>> 00000160: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
>> 00000170: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
>> 00000180: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
>> 00000190: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
>> 000001a0: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
>> 000001b0: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
>> 000001c0: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
>> 000001d0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
>> 000001e0: 744d 616e 6167 6572 5f32 2e32 2e31 5c65 tManager.2.2.1.e
>> 000001f0: 7665 6e74 4d61 6e61 6765 722e 6a61 7227 ventManager.jar.
>> 00000200: 0d0a 2a73 7973 2d70 6163 6b61 6765 2d6d ...sys.package.m
>> 00000210: 6772 2a3a 2070 726f 6365 7373 696e 6720 gr...processing.
>> 00000220: 6e65 7720 6a61 722c 2027 433a 5c50 726f new.jar...C..Pro
>> 00000230: 6772 616d 2046 696c 6573 5c53 7068 6572 gram.Files.Spher
>> 00000240: 6520 4e65 7477 6f72 6b73 5c41 7265 6e61 e.Networks.Arena
>> 00000250: 2050 6c61 7466 6f72 6d5c 706c 7567 696e .Platform.plugin
>> 00000260: 735c 6165 2e73 7068 6572 652e 6172 656e s.ae.sphere.aren
>> 00000270: 612e 7365 7276 6572 2e65 7665 6e74 4d61 a.server.eventMa
>> 00000280: 6e61 6765 725f 322e 322e 315c 6c69 625c nager.2.2.1.lib.
>> 00000290: 6163 7469 7661 7469 6f6e 2e6a 6172 270d activation.jar..
>> 000002a0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
>> 000002b0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
>> 000002c0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
>> 000002d0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
>> 000002e0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
>> 000002f0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
>> 00000300: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
>> 00000310: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
>> 00000320: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
>> 00000330: 616b 6172 7461 2d72 6567 6578 702d 312e akarta.regexp.1.
>> 00000340: 322e 6a61 7227 0d0a 2a73 7973 2d70 6163 2.jar....sys.pac
>> 00000350: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
>> 00000360: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
>> 00000370: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
>> 00000380: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
>> 00000390: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
>> 000003a0: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
>> 000003b0: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
>> 000003c0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
>> 000003d0: 315c 6c69 625c 4a43 7570 2e6a 6172 270d 1.lib.JCup.jar..
>> 000003e0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
>> 000003f0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
>> 00000400: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
>> 00000410: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
>> 00000420: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
>> 00000430: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
>> 00000440: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
>> 00000450: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
>> 00000460: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
>> 00000470: 6772 6f75 7073 2d61 6c6c 2e6a 6172 270d groups.all.jar..
>> 00000480: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
>> 00000490: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
>> 000004a0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
>> 000004b0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
>> 000004c0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
>> 000004d0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
>> 000004e0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
>> 000004f0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
>> 00000500: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
>> 00000510: 6d73 2e6a 6172 270d 0a2a 7379 732d 7061 ms.jar....sys.pa
>> 00000520: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
>> 00000530: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
>> 00000540: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
>> 00000550: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
>> 00000560: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
>> 00000570: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
>> 00000580: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
>> 00000590: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
>> 000005a0: 2e31 5c6c 6962 5c6a 6d78 7269 2e6a 6172 .1.lib.jmxri.jar
>> 000005b0: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
>> 000005c0: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
>> 000005d0: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
>> 000005e0: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
>> 000005f0: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
>> 00000600: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
>> 00000610: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
>> 00000620: 6e61 2e73 6572 7665 722e 6576 656e 744d na.server.eventM
>> 00000630: 616e 6167 6572 5f32 2e32 2e31 5c6c 6962 anager.2.2.1.lib
>> 00000640: 5c6a 6d78 746f 6f6c 732e 6a61 7227 0d0a .jmxtools.jar...
>> 00000650: 2a73 7973 2d70 6163 6b61 6765 2d6d 6772 .sys.package.mgr
>> 00000660: 2a3a 2070 726f 6365 7373 696e 6720 6e65 ...processing.ne
>> 00000670: 7720 6a61 722c 2027 433a 5c50 726f 6772 w.jar...C..Progr
>> 00000680: 616d 2046 696c 6573 5c53 7068 6572 6520 am.Files.Sphere.
>> 00000690: 4e65 7477 6f72 6b73 5c41 7265 6e61 2050 Networks.Arena.P
>> 000006a0: 6c61 7466 6f72 6d5c 706c 7567 696e 735c latform.plugins.
>> 000006b0: 6165 2e73 7068 6572 652e 6172 656e 612e ae.sphere.arena.
>> 000006c0: 7365 7276 6572 2e65 7665 6e74 4d61 6e61 server.eventMana
>> 000006d0: 6765 725f 322e 322e 315c 6c69 625c 6a6e ger.2.2.1.lib.jn
>> 000006e0: 6469 2e6a 6172 270d 0a2a 7379 732d 7061 di.jar....sys.pa
>> 000006f0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
>> 00000700: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
>> 00000710: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
>> 00000720: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
>> 00000730: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
>> 00000740: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
>> 00000750: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
>> 00000760: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
>> 00000770: 2e31 5c6c 6962 5c6a 6f72 616d 2d63 6c69 .1.lib.joram.cli
>> 00000780: 656e 742e 6a61 7227 0d0a 2a73 7973 2d70 ent.jar....sys.p
>> 00000790: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
>> 000007a0: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
>> 000007b0: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
>> 000007c0: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
>> 000007d0: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
>> 000007e0: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
>> 000007f0: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
>> 00000800: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
>> 00000810: 322e 315c 6c69 625c 6a6f 7261 6d2d 6d6f 2.1.lib.joram.mo
>> 00000820: 6d2e 6a61 7227 0d0a 2a73 7973 2d70 6163 m.jar....sys.pac
>> 00000830: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
>> 00000840: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
>> 00000850: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
>> 00000860: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
>> 00000870: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
>> 00000880: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
>> 00000890: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
>> 000008a0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
>> 000008b0: 315c 6c69 625c 6a6f 7261 6d2d 7368 6172 1.lib.joram.shar
>> 000008c0: 6564 2e6a 6172 270d 0a2a 7379 732d 7061 ed.jar....sys.pa
>> 000008d0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
>> 000008e0: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
>> 000008f0: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
>> 00000900: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
>> 00000910: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
>> 00000920: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
>> 00000930: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
>> 00000940: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
>> 00000950: 2e31 5c6c 6962 5c6a 7461 2e6a 6172 270d .1.lib.jta.jar..
>> 00000960: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
>> 00000970: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
>> 00000980: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
>> 00000990: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
>> 000009a0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
>> 000009b0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
>> 000009c0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
>> 000009d0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
>> 000009e0: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6b ager.2.2.1.lib.k
>> 000009f0: 786d 6c2e 6a61 7227 0d0a 2a73 7973 2d70 xml.jar....sys.p
>> 00000a00: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
>> 00000a10: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
>> 00000a20: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
>> 00000a30: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
>> 00000a40: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
>> 00000a50: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
>> 00000a60: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
>> 00000a70: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
>> 00000a80: 322e 315c 6c69 625c 6d69 6470 6170 692e 2.1.lib.midpapi.
>> 00000a90: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
>> 00000aa0: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
>> 00000ab0: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
>> 00000ac0: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
>> 00000ad0: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
>> 00000ae0: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
>> 00000af0: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
>> 00000b00: 6172 656e 612e 7365 7276 6572 2e65 7665 arena.server.eve
>> 00000b10: 6e74 4d61 6e61 6765 725f 322e 322e 315c ntManager.2.2.1.
>> 00000b20: 6c69 625c 6f77 5f6d 6f6e 6f6c 6f67 2e6a lib.ow.monolog.j
>> 00000b30: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
>> 00000b40: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
>> 00000b50: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
>> 00000b60: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
>> 00000b70: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
>> 00000b80: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
>> 00000b90: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
>> 00000ba0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
>> 00000bb0: 744d 616e 6167 6572 5f32 2e32 2e31 5c6c tManager.2.2.1.l
>> 00000bc0: 6962 5c73 6f61 702e 6a61 7227 0d0a 2a73 ib.soap.jar....s
>> 00000bd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
>> 00000be0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
>> 00000bf0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
>> 00000c00: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
>> 00000c10: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
>> 00000c20: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
>> 00000c30: 2e73 7068 6572 652e 6172 656e 612e 6c6f .sphere.arena.lo
>> 00000c40: 675f 322e 322e 315c 736c 6f67 2e6a 6172 g.2.2.1.slog.jar
>> 00000c50: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
>> 00000c60: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
>> 00000c70: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
>> 00000c80: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
>> 00000c90: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
>> 00000ca0: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
>> 00000cb0: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
>> 00000cc0: 6e61 2e6c 6f67 5f32 2e32 2e31 5c6c 6962 na.log.2.2.1.lib
>> 00000cd0: 5c63 6f6d 6d6f 6e73 2d6c 6f67 6769 6e67 .commons.logging
>> 00000ce0: 2d31 2e30 2e34 2e6a 6172 270d 0a2a 7379 .1.0.4.jar....sy
>> 00000cf0: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
>> 00000d00: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
>> 00000d10: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
>> 00000d20: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
>> 00000d30: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
>> 00000d40: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
>> 00000d50: 7370 6865 7265 2e61 7265 6e61 2e6c 6f67 sphere.arena.log
>> 00000d60: 5f32 2e32 2e31 5c6c 6962 5c6c 6f67 346a .2.2.1.lib.log4j
>> 00000d70: 2d31 2e32 2e31 322e 6a61 7227 0d0a 2a73 .1.2.12.jar....s
>> 00000d80: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
>> 00000d90: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
>> 00000da0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
>> 00000db0: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
>> 00000dc0: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
>> 00000dd0: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
>> 00000de0: 2e73 7068 6572 652e 6172 656e 612e 6e65 .sphere.arena.ne
>> 00000df0: 7477 6f72 6b4d 616e 6167 6572 2e64 6973 tworkManager.dis
>> 00000e00: 636f 7665 7279 5f32 2e33 2e30 5c64 6973 covery.2.3.0.dis
>> 00000e10: 636f 7665 7279 2e6a 6172 270d 0a2a 7379 covery.jar....sy
>> 00000e20: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
>> 00000e30: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
>> 00000e40: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
>> 00000e50: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
>> 00000e60: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
>> 00000e70: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
>> 00000e80: 7370 6865 7265 2e61 7265 6e61 2e73 6572 sphere.arena.ser
>> 00000e90: 7665 725f 322e 322e 315c 6172 656e 6153 ver.2.2.1.arenaS
>> 00000ea0: 6572 7665 722e 6a61 7227 0d0a 2a73 7973 erver.jar....sys
>> 00000eb0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
>> 00000ec0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
>> 00000ed0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
>> 00000ee0: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
>> 00000ef0: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
>> 00000f00: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
>> 00000f10: 7068 6572 652e 6172 656e 612e 636f 6d6d phere.arena.comm
>> 00000f20: 6f6e 5f32 2e32 2e31 5c63 6f6d 6d6f 6e2e on.2.2.1.common.
>> 00000f30: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
>> 00000f40: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
>> 00000f50: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
>> 00000f60: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
>> 00000f70: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
>> 00000f80: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
>> 00000f90: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
>> 00000fa0: 6172 656e 612e 636f 6d6d 6f6e 5f32 2e32 arena.common.2.2
>> 00000fb0: 2e31 5c6c 6962 5c63 6f6d 6d6f 6e73 2d6c .1.lib.commons.l
>> 00000fc0: 616e 672d 322e 332e 6a61 7227 0d0a 2a73 ang.2.3.jar....s
>> 00000fd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
>> 00000fe0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
>> 00000ff0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
>>
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown
>> Source)
>> at
>> org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
>> Source)
>> at
>> org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
>> Source)
>> at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown
>> Source)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
>> Source)
>> at java.lang.reflect.Method.invoke(Unknown Source)
>> at
>> com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:525)
>>
>> at
>> com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
>>
>>
>>
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Bassel
>>
>
>
>
Re: Derby crash (urgent)
Posted by shabz <sh...@sphere.ae>.
I removed c3p0, now its working good.
shabz wrote:
>
> Hi,
>
> I am also facing same issue. I tried disabling the disk cache also, but
> still the same problem.
>
>
>
> Bassel_kh wrote:
>>
>> 1- SYSINFO :
>> Java Version : 1.5.0_11-b03
>> os version : 5.1 Windows XP
>> For derby, I'm using *10.3.2*
>> 2- I'm not be able to restore from the corrupted database, the full trace
>> is:
>>
>> ---------------------------------------------------------------
>> 2008-04-07 14:41:59.109 GMT:
>> Booting Derby version The Apache Software Foundation - Apache Derby -
>> 10.3.2.1 - (599110): instance c013800d-0119-2956-0e45-000000162900
>> on database directory
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena
>>
>>
>> 2008-04-07 14:41:59.297 GMT:
>> Shutting down instance c013800d-0119-2956-0e45-000000162900
>> ----------------------------------------------------------------
>> 2008-04-07 14:41:59.484 GMT Thread[ModalContext,6,main] Cleanup action
>> starting
>> java.sql.SQLException: Failed to start database
>> 'C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena',
>> see the next exception for details.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
>> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
>> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
>> at
>> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
>> at
>> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
>> Caused by: java.sql.SQLException: Error copying file (during backup) from
>> C:\Documents and Settings\bassel\Desktop\Rafi
>> test\db\Arena\BACKUP.HISTORY to
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
>> Source)
>> ... 10 more
>> Caused by: ERROR XSRS5: Error copying file (during backup) from
>> C:\Documents and Settings\bassel\Desktop\Rafi
>> test\db\Arena\BACKUP.HISTORY to
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
>> at org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
>> Source)
>> ... 10 more
>> ============= begin nested exception, level (1) ===========
>> java.sql.SQLException: Error copying file (during backup) from
>> C:\Documents and Settings\bassel\Desktop\Rafi
>> test\db\Arena\BACKUP.HISTORY to
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
>> at
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
>> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
>> at
>> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
>> at
>> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
>> Caused by: ERROR XSRS5: Error copying file (during backup) from
>> C:\Documents and Settings\bassel\Desktop\Rafi
>> test\db\Arena\BACKUP.HISTORY to
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
>> at org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
>> Source)
>> ... 10 more
>> ============= end nested exception, level (1) ===========
>> ============= begin nested exception, level (2) ===========
>> ERROR XSRS5: Error copying file (during backup) from C:\Documents and
>> Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
>> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
>> at org.apache.derby.iapi.error.StandardException.newException(Unknown
>> Source)
>> at
>> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
>> Source)
>> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
>> Source)
>> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
>> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
>> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
>> Source)
>> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
>> Source)
>> at
>> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
>> Source)
>> at
>> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
>> Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
>> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
>> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
>> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
>> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
>> at
>> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
>> at
>> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
>> at
>> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
>> ============= end nested exception, level (2) ===========
>> Cleanup action completed
>>
>>
>> I'll tell you what also did:
>>
>> - As I know, as soon as the all the database connections got closed,
>> derby is automatically shutdown, but even though, I created a shutdown
>> Hook in order to regularly shutdown the database to avoid any alive
>> transaction or resource, and now derby is regularly shutdown.
>>
>> - I also read about durability and IO flushing problem, so because of
>> that, I’m doing check point before closing the database, by calling
>> SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE(), to make sure that all cached data
>> are already flushed to the disk, I can't do more!!
>>
>> - I’m using Hibernate 3.1.rc3 as an entity library, I’m not talking to
>> derby directly, I thought that Hibernate is keeping some derby resources
>> alive, so before shutdown derby, I’m cleaning up the hibernate sessions &
>> connections
>> I did debugging on that and I could open the database using cloudscape
>> after a regular shutdown, means I’m 100% sure that the database has a
>> quite regular shutdown and there is no resources still there.
>>
>>
>> - The problem is not happing al the times, it happens in two different
>> cases:
>> A. When I’m trying to do online backup (the db size is only 3 MB !!)
>> B. When I restart my Application’s service (I’m using java service
>> wrapper for doing this), you can check it out:
>> http://wrapper.tanukisoftware.org/doc/english/introduction.html
>>
>>
>> - OS & hardware:
>> I checked it on:
>> • Windows XP professional edition SP 2 , with 2 GB RAM, HP dx6120
>> , Pentium 4, CPU 3.2 GHz
>> • I also checked it on a server, HP ML370, Windows Server 2003.
>>
>> Note:
>> I've created another build with (H2) database, it is working fine for me,
>> but I don’t want to replace such a good database like Derby at any
>> reason, but our deployment is stooping till we sort this problem out,
>>
>> So Kindly advice,
>>
>>
>> Best regards
>>
>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16585356.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by shabz <sh...@sphere.ae>.
Hi,
I am also facing same issue. I tried disabling the disk cache also, but
still the same problem.
Bassel_kh wrote:
>
> 1- SYSINFO :
> Java Version : 1.5.0_11-b03
> os version : 5.1 Windows XP
> For derby, I'm using *10.3.2*
> 2- I'm not be able to restore from the corrupted database, the full trace
> is:
>
> ---------------------------------------------------------------
> 2008-04-07 14:41:59.109 GMT:
> Booting Derby version The Apache Software Foundation - Apache Derby -
> 10.3.2.1 - (599110): instance c013800d-0119-2956-0e45-000000162900
> on database directory
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena
>
>
> 2008-04-07 14:41:59.297 GMT:
> Shutting down instance c013800d-0119-2956-0e45-000000162900
> ----------------------------------------------------------------
> 2008-04-07 14:41:59.484 GMT Thread[ModalContext,6,main] Cleanup action
> starting
> java.sql.SQLException: Failed to start database
> 'C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena',
> see the next exception for details.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
> at
> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
> at
> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
> Caused by: java.sql.SQLException: Error copying file (during backup) from
> C:\Documents and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY
> to
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> ... 10 more
> Caused by: ERROR XSRS5: Error copying file (during backup) from
> C:\Documents and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY
> to
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
> Source)
> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> Source)
> ... 10 more
> ============= begin nested exception, level (1) ===========
> java.sql.SQLException: Error copying file (during backup) from
> C:\Documents and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY
> to
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
> Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
> at
> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
> at
> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
> Caused by: ERROR XSRS5: Error copying file (during backup) from
> C:\Documents and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY
> to
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
> Source)
> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> Source)
> ... 10 more
> ============= end nested exception, level (1) ===========
> ============= begin nested exception, level (2) ===========
> ERROR XSRS5: Error copying file (during backup) from C:\Documents and
> Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
> C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
> Source)
> at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
> Source)
> at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
> at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
> Source)
> at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
> Source)
> at
> org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
> Source)
> at
> org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
> at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
> at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
> at
> org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
> at
> org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
> at
> org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
> ============= end nested exception, level (2) ===========
> Cleanup action completed
>
>
> I'll tell you what also did:
>
> - As I know, as soon as the all the database connections got closed, derby
> is automatically shutdown, but even though, I created a shutdown Hook in
> order to regularly shutdown the database to avoid any alive transaction or
> resource, and now derby is regularly shutdown.
>
> - I also read about durability and IO flushing problem, so because of
> that, I’m doing check point before closing the database, by calling
> SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE(), to make sure that all cached data
> are already flushed to the disk, I can't do more!!
>
> - I’m using Hibernate 3.1.rc3 as an entity library, I’m not talking to
> derby directly, I thought that Hibernate is keeping some derby resources
> alive, so before shutdown derby, I’m cleaning up the hibernate sessions &
> connections
> I did debugging on that and I could open the database using cloudscape
> after a regular shutdown, means I’m 100% sure that the database has a
> quite regular shutdown and there is no resources still there.
>
>
> - The problem is not happing al the times, it happens in two different
> cases:
> A. When I’m trying to do online backup (the db size is only 3 MB !!)
> B. When I restart my Application’s service (I’m using java service
> wrapper for doing this), you can check it out:
> http://wrapper.tanukisoftware.org/doc/english/introduction.html
>
>
> - OS & hardware:
> I checked it on:
> • Windows XP professional edition SP 2 , with 2 GB RAM, HP dx6120 ,
> Pentium 4, CPU 3.2 GHz
> • I also checked it on a server, HP ML370, Windows Server 2003.
>
> Note:
> I've created another build with (H2) database, it is working fine for me,
> but I don’t want to replace such a good database like Derby at any reason,
> but our deployment is stooping till we sort this problem out,
>
> So Kindly advice,
>
>
> Best regards
>
>
>
>
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16557276.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Bassel_kh <bk...@hotmail.com>.
1- SYSINFO :
Java Version : 1.5.0_11-b03
os version : 5.1 Windows XP
For derby, I'm using *10.3.2*
2- I'm not be able to restore from the corrupted database, the full trace
is:
---------------------------------------------------------------
2008-04-07 14:41:59.109 GMT:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.3.2.1 - (599110): instance c013800d-0119-2956-0e45-000000162900
on database directory
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena
2008-04-07 14:41:59.297 GMT:
Shutting down instance c013800d-0119-2956-0e45-000000162900
----------------------------------------------------------------
2008-04-07 14:41:59.484 GMT Thread[ModalContext,6,main] Cleanup action
starting
java.sql.SQLException: Failed to start database
'C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena',
see the next exception for details.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
at
org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: java.sql.SQLException: Error copying file (during backup) from
C:\Documents and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY
to
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
... 10 more
Caused by: ERROR XSRS5: Error copying file (during backup) from C:\Documents
and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
Source)
at
org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
Source)
... 10 more
============= begin nested exception, level (1) ===========
java.sql.SQLException: Error copying file (during backup) from C:\Documents
and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
at
org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
Caused by: ERROR XSRS5: Error copying file (during backup) from C:\Documents
and Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
Source)
at
org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
Source)
... 10 more
============= end nested exception, level (1) ===========
============= begin nested exception, level (2) ===========
ERROR XSRS5: Error copying file (during backup) from C:\Documents and
Settings\bassel\Desktop\Rafi test\db\Arena\BACKUP.HISTORY to
C:\eclipse3.2\workspace\ANM2.3_MBR_DERBY\automatedbuild\build\tmp\Arena\db\Arena\BACKUP.HISTORY.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.store.raw.RawStore.restoreRemainingFromBackup(Unknown
Source)
at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown
Source)
at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown
Source)
at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown
Source)
at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown
Source)
at
org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown
Source)
at
org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionManagerImpl.connect(ConnectionManagerImpl.java:185)
at
org.eclipse.wst.rdb.internal.core.connection.ConnectionInfoImpl.connect(ConnectionInfoImpl.java:127)
at
org.eclipse.wst.rdb.connection.internal.ui.wizards.shared.NewCWJDBCPage$2.run(NewCWJDBCPage.java:897)
at
org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:113)
============= end nested exception, level (2) ===========
Cleanup action completed
I'll tell you what also did:
- As I know, as soon as the all the database connections got closed, derby
is automatically shutdown, but even though, I created a shutdown Hook in
order to regularly shutdown the database to avoid any alive transaction or
resource, and now derby is regularly shutdown.
- I also read about durability and IO flushing problem, so because of that,
I’m doing check point before closing the database, by calling
SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE(), to make sure that all cached data
are already flushed to the disk, I can't do more!!
- I’m using Hibernate 3.1.rc3 as an entity library, I’m not talking to derby
directly, I thought that Hibernate is keeping some derby resources alive, so
before shutdown derby, I’m cleaning up the hibernate sessions & connections
I did debugging on that and I could open the database using cloudscape
after a regular shutdown, means I’m 100% sure that the database has a quite
regular shutdown and there is no resources still there.
- The problem is not happing al the times, it happens in two different
cases:
A. When I’m trying to do online backup (the db size is only 3 MB !!)
B. When I restart my Application’s service (I’m using java service wrapper
for doing this), you can check it out:
http://wrapper.tanukisoftware.org/doc/english/introduction.html
- OS & hardware:
I checked it on:
• Windows XP professional edition SP 2 , with 2 GB RAM, HP dx6120 ,
Pentium 4, CPU 3.2 GHz
• I also checked it on a server, HP ML370, Windows Server 2003.
Note:
I've created another build with (H2) database, it is working fine for me,
but I don’t want to replace such a good database like Derby at any reason,
but our deployment is stooping till we sort this problem out,
So Kindly advice,
Best regards
--
View this message in context: http://www.nabble.com/Derby-crash-%28urgent%29-tp16217446p16537506.html
Sent from the Apache Derby Developers mailing list archive at Nabble.com.
Re: Derby crash (urgent)
Posted by Stanley Bradbury <St...@gmail.com>.
-- top posting --
Hi Bassel -
It would help to have the information from SYSINFO (version, platform
and JVM). Are you able to recover from this or is the database lost?
It sounds like you understand what is going on - database pages are either
1) not being written to disk properly - OR -
2) are being corrupted / deleted once they are written to disk
Hence the files on disk are not in sync as evidenced by the checksums
are not matching what is expected.
The JVM, OS and underlying hardware handle the writes so I would start
by looking at your JVM, your I/O and storage systems. Check the logs
for errors, etc.
I am aware of an intermittent 'Invalid Checksum' failure that stopped
happening after upgrading from an initial release of a JVM to the
current release/update of the JVM. If possible, test with an alternate
JVM to see if the problem happens when using JVMs from multiple vendors.
Once these possibilities are eliminated look at the application and
runtime environment. Could you be double booting the database? In most
cases Derby prevents double booting but on some OSs and older JVMs it
could still be a problem. It is possible to double boot Derby within a
single JVM by loading the Derby driver TWICE in different classloaders.
If you are using multiple classloaders be sure to check for this.
Lastly be sure you are using regular (not-buffered) I/O to a disk that
is physically connected to the machine. I/O to network mounted disks is
not reliable.
This is all I can think of at the moment. Good luck with chasing this
down. Please post what you find so others can benefit from your findings.
Bassel Kh wrote:
>
> Hi,
>
>
>
> We have a critical issue with derby (version: *10.3.2*) which we use
> in embedded mode in our application. Several times (not to say most of
> the times), a restart of the application, especially when some
> transactions are going on, the database gets corrupted (invalid
> checksum exception). After reading many posts about eventual problems
> in derby, we found problems that look like ours (for instance:
> http://www.mail-archive.com/derby-dev@db.apache.org/msg46177.html),
> but no clear-cut that the problem has been solved. It is to be noted
> that we do a graceful shutdown when closing the application and the
> logs show successful executions.
>
> It also looks like only some tables in the database have the problem
> since some modules keep running correctly, but there are no conditions
> or symptoms prior to the error, it happens at random (we carried on
> several tests with different modules on different databases).
>
> Do you have any solution or suggestions to this problem? We have a
> customer release going on and we would appreciate if you could reply
> as soon as possible.
>
>
>
> Please find below the exception we are getting:
>
>
>
> Caused by: java.sql.SQLException: Invalid checksum on Page Page(0,Container(0, 1568)), expected=2,264,079,051, on-disk version=6,651,942,472,428,708,205, page dump follows: Hex dump:
> 00000000: 0076 0000 0001 0000 0000 0000 0002 0000 .v..............
> 00000010: 0000 0006 0000 0000 0000 0000 0000 0000 ................
> 00000020: 0000 0000 0001 0000 0000 0000 0000 0000 ................
> 00000030: 0000 0000 0000 0000 0000 0000 ffff ffff ................
> 00000040: ffff ffff 0000 0000 0000 0000 0000 0000 ................
> 00000050: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000060: 0000 0000 0000 0000 0000 0000 5000 0000 ............P...
> 00000070: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000080: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 00000090: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000a0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000b0: 0000 0000 0000 0000 0000 0000 0000 0000 ................
> 000000c0: 0000 0010 0000 0000 0000 0000 2a73 7973 .............sys
> 000000d0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
> 000000e0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
> 000000f0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
> 00000100: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
> 00000110: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
> 00000120: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
> 00000130: 7068 6572 652e 6172 656e 612e 6e65 7477 phere.arena.netw
> 00000140: 6f72 6b4d 616e 6167 6572 2e63 6f6d 6d6f orkManager.commo
> 00000150: 6e5f 322e 322e 315c 636f 6d6d 6f6e 2e6a n.2.2.1.common.j
> 00000160: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
> 00000170: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
> 00000180: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
> 00000190: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
> 000001a0: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
> 000001b0: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
> 000001c0: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
> 000001d0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
> 000001e0: 744d 616e 6167 6572 5f32 2e32 2e31 5c65 tManager.2.2.1.e
> 000001f0: 7665 6e74 4d61 6e61 6765 722e 6a61 7227 ventManager.jar.
> 00000200: 0d0a 2a73 7973 2d70 6163 6b61 6765 2d6d ...sys.package.m
> 00000210: 6772 2a3a 2070 726f 6365 7373 696e 6720 gr...processing.
> 00000220: 6e65 7720 6a61 722c 2027 433a 5c50 726f new.jar...C..Pro
> 00000230: 6772 616d 2046 696c 6573 5c53 7068 6572 gram.Files.Spher
> 00000240: 6520 4e65 7477 6f72 6b73 5c41 7265 6e61 e.Networks.Arena
> 00000250: 2050 6c61 7466 6f72 6d5c 706c 7567 696e .Platform.plugin
> 00000260: 735c 6165 2e73 7068 6572 652e 6172 656e s.ae.sphere.aren
> 00000270: 612e 7365 7276 6572 2e65 7665 6e74 4d61 a.server.eventMa
> 00000280: 6e61 6765 725f 322e 322e 315c 6c69 625c nager.2.2.1.lib.
> 00000290: 6163 7469 7661 7469 6f6e 2e6a 6172 270d activation.jar..
> 000002a0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 000002b0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 000002c0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 000002d0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000002e0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000002f0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 00000300: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 00000310: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000320: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000330: 616b 6172 7461 2d72 6567 6578 702d 312e akarta.regexp.1.
> 00000340: 322e 6a61 7227 0d0a 2a73 7973 2d70 6163 2.jar....sys.pac
> 00000350: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
> 00000360: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
> 00000370: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
> 00000380: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
> 00000390: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
> 000003a0: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
> 000003b0: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
> 000003c0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
> 000003d0: 315c 6c69 625c 4a43 7570 2e6a 6172 270d 1.lib.JCup.jar..
> 000003e0: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 000003f0: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 00000400: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 00000410: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 00000420: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 00000430: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 00000440: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 00000450: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000460: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000470: 6772 6f75 7073 2d61 6c6c 2e6a 6172 270d groups.all.jar..
> 00000480: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 00000490: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 000004a0: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 000004b0: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000004c0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000004d0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 000004e0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 000004f0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 00000500: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6a ager.2.2.1.lib.j
> 00000510: 6d73 2e6a 6172 270d 0a2a 7379 732d 7061 ms.jar....sys.pa
> 00000520: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 00000530: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 00000540: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000550: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000560: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000570: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000580: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000590: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 000005a0: 2e31 5c6c 6962 5c6a 6d78 7269 2e6a 6172 .1.lib.jmxri.jar
> 000005b0: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
> 000005c0: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
> 000005d0: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
> 000005e0: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
> 000005f0: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
> 00000600: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
> 00000610: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
> 00000620: 6e61 2e73 6572 7665 722e 6576 656e 744d na.server.eventM
> 00000630: 616e 6167 6572 5f32 2e32 2e31 5c6c 6962 anager.2.2.1.lib
> 00000640: 5c6a 6d78 746f 6f6c 732e 6a61 7227 0d0a .jmxtools.jar...
> 00000650: 2a73 7973 2d70 6163 6b61 6765 2d6d 6772 .sys.package.mgr
> 00000660: 2a3a 2070 726f 6365 7373 696e 6720 6e65 ...processing.ne
> 00000670: 7720 6a61 722c 2027 433a 5c50 726f 6772 w.jar...C..Progr
> 00000680: 616d 2046 696c 6573 5c53 7068 6572 6520 am.Files.Sphere.
> 00000690: 4e65 7477 6f72 6b73 5c41 7265 6e61 2050 Networks.Arena.P
> 000006a0: 6c61 7466 6f72 6d5c 706c 7567 696e 735c latform.plugins.
> 000006b0: 6165 2e73 7068 6572 652e 6172 656e 612e ae.sphere.arena.
> 000006c0: 7365 7276 6572 2e65 7665 6e74 4d61 6e61 server.eventMana
> 000006d0: 6765 725f 322e 322e 315c 6c69 625c 6a6e ger.2.2.1.lib.jn
> 000006e0: 6469 2e6a 6172 270d 0a2a 7379 732d 7061 di.jar....sys.pa
> 000006f0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 00000700: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 00000710: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000720: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000730: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000740: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000750: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000760: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 00000770: 2e31 5c6c 6962 5c6a 6f72 616d 2d63 6c69 .1.lib.joram.cli
> 00000780: 656e 742e 6a61 7227 0d0a 2a73 7973 2d70 ent.jar....sys.p
> 00000790: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
> 000007a0: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
> 000007b0: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
> 000007c0: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
> 000007d0: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
> 000007e0: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
> 000007f0: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
> 00000800: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
> 00000810: 322e 315c 6c69 625c 6a6f 7261 6d2d 6d6f 2.1.lib.joram.mo
> 00000820: 6d2e 6a61 7227 0d0a 2a73 7973 2d70 6163 m.jar....sys.pac
> 00000830: 6b61 6765 2d6d 6772 2a3a 2070 726f 6365 kage.mgr...proce
> 00000840: 7373 696e 6720 6e65 7720 6a61 722c 2027 ssing.new.jar...
> 00000850: 433a 5c50 726f 6772 616d 2046 696c 6573 C..Program.Files
> 00000860: 5c53 7068 6572 6520 4e65 7477 6f72 6b73 .Sphere.Networks
> 00000870: 5c41 7265 6e61 2050 6c61 7466 6f72 6d5c .Arena.Platform.
> 00000880: 706c 7567 696e 735c 6165 2e73 7068 6572 plugins.ae.spher
> 00000890: 652e 6172 656e 612e 7365 7276 6572 2e65 e.arena.server.e
> 000008a0: 7665 6e74 4d61 6e61 6765 725f 322e 322e ventManager.2.2.
> 000008b0: 315c 6c69 625c 6a6f 7261 6d2d 7368 6172 1.lib.joram.shar
> 000008c0: 6564 2e6a 6172 270d 0a2a 7379 732d 7061 ed.jar....sys.pa
> 000008d0: 636b 6167 652d 6d67 722a 3a20 7072 6f63 ckage.mgr...proc
> 000008e0: 6573 7369 6e67 206e 6577 206a 6172 2c20 essing.new.jar..
> 000008f0: 2743 3a5c 5072 6f67 7261 6d20 4669 6c65 .C..Program.File
> 00000900: 735c 5370 6865 7265 204e 6574 776f 726b s.Sphere.Network
> 00000910: 735c 4172 656e 6120 506c 6174 666f 726d s.Arena.Platform
> 00000920: 5c70 6c75 6769 6e73 5c61 652e 7370 6865 .plugins.ae.sphe
> 00000930: 7265 2e61 7265 6e61 2e73 6572 7665 722e re.arena.server.
> 00000940: 6576 656e 744d 616e 6167 6572 5f32 2e32 eventManager.2.2
> 00000950: 2e31 5c6c 6962 5c6a 7461 2e6a 6172 270d .1.lib.jta.jar..
> 00000960: 0a2a 7379 732d 7061 636b 6167 652d 6d67 ..sys.package.mg
> 00000970: 722a 3a20 7072 6f63 6573 7369 6e67 206e r...processing.n
> 00000980: 6577 206a 6172 2c20 2743 3a5c 5072 6f67 ew.jar...C..Prog
> 00000990: 7261 6d20 4669 6c65 735c 5370 6865 7265 ram.Files.Sphere
> 000009a0: 204e 6574 776f 726b 735c 4172 656e 6120 .Networks.Arena.
> 000009b0: 506c 6174 666f 726d 5c70 6c75 6769 6e73 Platform.plugins
> 000009c0: 5c61 652e 7370 6865 7265 2e61 7265 6e61 .ae.sphere.arena
> 000009d0: 2e73 6572 7665 722e 6576 656e 744d 616e .server.eventMan
> 000009e0: 6167 6572 5f32 2e32 2e31 5c6c 6962 5c6b ager.2.2.1.lib.k
> 000009f0: 786d 6c2e 6a61 7227 0d0a 2a73 7973 2d70 xml.jar....sys.p
> 00000a00: 6163 6b61 6765 2d6d 6772 2a3a 2070 726f ackage.mgr...pro
> 00000a10: 6365 7373 696e 6720 6e65 7720 6a61 722c cessing.new.jar.
> 00000a20: 2027 433a 5c50 726f 6772 616d 2046 696c ..C..Program.Fil
> 00000a30: 6573 5c53 7068 6572 6520 4e65 7477 6f72 es.Sphere.Networ
> 00000a40: 6b73 5c41 7265 6e61 2050 6c61 7466 6f72 ks.Arena.Platfor
> 00000a50: 6d5c 706c 7567 696e 735c 6165 2e73 7068 m.plugins.ae.sph
> 00000a60: 6572 652e 6172 656e 612e 7365 7276 6572 ere.arena.server
> 00000a70: 2e65 7665 6e74 4d61 6e61 6765 725f 322e .eventManager.2.
> 00000a80: 322e 315c 6c69 625c 6d69 6470 6170 692e 2.1.lib.midpapi.
> 00000a90: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
> 00000aa0: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
> 00000ab0: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
> 00000ac0: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
> 00000ad0: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
> 00000ae0: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
> 00000af0: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
> 00000b00: 6172 656e 612e 7365 7276 6572 2e65 7665 arena.server.eve
> 00000b10: 6e74 4d61 6e61 6765 725f 322e 322e 315c ntManager.2.2.1.
> 00000b20: 6c69 625c 6f77 5f6d 6f6e 6f6c 6f67 2e6a lib.ow.monolog.j
> 00000b30: 6172 270d 0a2a 7379 732d 7061 636b 6167 ar....sys.packag
> 00000b40: 652d 6d67 722a 3a20 7072 6f63 6573 7369 e.mgr...processi
> 00000b50: 6e67 206e 6577 206a 6172 2c20 2743 3a5c ng.new.jar...C..
> 00000b60: 5072 6f67 7261 6d20 4669 6c65 735c 5370 Program.Files.Sp
> 00000b70: 6865 7265 204e 6574 776f 726b 735c 4172 here.Networks.Ar
> 00000b80: 656e 6120 506c 6174 666f 726d 5c70 6c75 ena.Platform.plu
> 00000b90: 6769 6e73 5c61 652e 7370 6865 7265 2e61 gins.ae.sphere.a
> 00000ba0: 7265 6e61 2e73 6572 7665 722e 6576 656e rena.server.even
> 00000bb0: 744d 616e 6167 6572 5f32 2e32 2e31 5c6c tManager.2.2.1.l
> 00000bc0: 6962 5c73 6f61 702e 6a61 7227 0d0a 2a73 ib.soap.jar....s
> 00000bd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000be0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000bf0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
> 00000c00: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
> 00000c10: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
> 00000c20: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
> 00000c30: 2e73 7068 6572 652e 6172 656e 612e 6c6f .sphere.arena.lo
> 00000c40: 675f 322e 322e 315c 736c 6f67 2e6a 6172 g.2.2.1.slog.jar
> 00000c50: 270d 0a2a 7379 732d 7061 636b 6167 652d ....sys.package.
> 00000c60: 6d67 722a 3a20 7072 6f63 6573 7369 6e67 mgr...processing
> 00000c70: 206e 6577 206a 6172 2c20 2743 3a5c 5072 .new.jar...C..Pr
> 00000c80: 6f67 7261 6d20 4669 6c65 735c 5370 6865 ogram.Files.Sphe
> 00000c90: 7265 204e 6574 776f 726b 735c 4172 656e re.Networks.Aren
> 00000ca0: 6120 506c 6174 666f 726d 5c70 6c75 6769 a.Platform.plugi
> 00000cb0: 6e73 5c61 652e 7370 6865 7265 2e61 7265 ns.ae.sphere.are
> 00000cc0: 6e61 2e6c 6f67 5f32 2e32 2e31 5c6c 6962 na.log.2.2.1.lib
> 00000cd0: 5c63 6f6d 6d6f 6e73 2d6c 6f67 6769 6e67 .commons.logging
> 00000ce0: 2d31 2e30 2e34 2e6a 6172 270d 0a2a 7379 .1.0.4.jar....sy
> 00000cf0: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
> 00000d00: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
> 00000d10: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
> 00000d20: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
> 00000d30: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
> 00000d40: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
> 00000d50: 7370 6865 7265 2e61 7265 6e61 2e6c 6f67 sphere.arena.log
> 00000d60: 5f32 2e32 2e31 5c6c 6962 5c6c 6f67 346a .2.2.1.lib.log4j
> 00000d70: 2d31 2e32 2e31 322e 6a61 7227 0d0a 2a73 .1.2.12.jar....s
> 00000d80: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000d90: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000da0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
> 00000db0: 2046 696c 6573 5c53 7068 6572 6520 4e65 .Files.Sphere.Ne
> 00000dc0: 7477 6f72 6b73 5c41 7265 6e61 2050 6c61 tworks.Arena.Pla
> 00000dd0: 7466 6f72 6d5c 706c 7567 696e 735c 6165 tform.plugins.ae
> 00000de0: 2e73 7068 6572 652e 6172 656e 612e 6e65 .sphere.arena.ne
> 00000df0: 7477 6f72 6b4d 616e 6167 6572 2e64 6973 tworkManager.dis
> 00000e00: 636f 7665 7279 5f32 2e33 2e30 5c64 6973 covery.2.3.0.dis
> 00000e10: 636f 7665 7279 2e6a 6172 270d 0a2a 7379 covery.jar....sy
> 00000e20: 732d 7061 636b 6167 652d 6d67 722a 3a20 s.package.mgr...
> 00000e30: 7072 6f63 6573 7369 6e67 206e 6577 206a processing.new.j
> 00000e40: 6172 2c20 2743 3a5c 5072 6f67 7261 6d20 ar...C..Program.
> 00000e50: 4669 6c65 735c 5370 6865 7265 204e 6574 Files.Sphere.Net
> 00000e60: 776f 726b 735c 4172 656e 6120 506c 6174 works.Arena.Plat
> 00000e70: 666f 726d 5c70 6c75 6769 6e73 5c61 652e form.plugins.ae.
> 00000e80: 7370 6865 7265 2e61 7265 6e61 2e73 6572 sphere.arena.ser
> 00000e90: 7665 725f 322e 322e 315c 6172 656e 6153 ver.2.2.1.arenaS
> 00000ea0: 6572 7665 722e 6a61 7227 0d0a 2a73 7973 erver.jar....sys
> 00000eb0: 2d70 6163 6b61 6765 2d6d 6772 2a3a 2070 .package.mgr...p
> 00000ec0: 726f 6365 7373 696e 6720 6e65 7720 6a61 rocessing.new.ja
> 00000ed0: 722c 2027 433a 5c50 726f 6772 616d 2046 r...C..Program.F
> 00000ee0: 696c 6573 5c53 7068 6572 6520 4e65 7477 iles.Sphere.Netw
> 00000ef0: 6f72 6b73 5c41 7265 6e61 2050 6c61 7466 orks.Arena.Platf
> 00000f00: 6f72 6d5c 706c 7567 696e 735c 6165 2e73 orm.plugins.ae.s
> 00000f10: 7068 6572 652e 6172 656e 612e 636f 6d6d phere.arena.comm
> 00000f20: 6f6e 5f32 2e32 2e31 5c63 6f6d 6d6f 6e2e on.2.2.1.common.
> 00000f30: 6a61 7227 0d0a 2a73 7973 2d70 6163 6b61 jar....sys.packa
> 00000f40: 6765 2d6d 6772 2a3a 2070 726f 6365 7373 ge.mgr...process
> 00000f50: 696e 6720 6e65 7720 6a61 722c 2027 433a ing.new.jar...C.
> 00000f60: 5c50 726f 6772 616d 2046 696c 6573 5c53 .Program.Files.S
> 00000f70: 7068 6572 6520 4e65 7477 6f72 6b73 5c41 phere.Networks.A
> 00000f80: 7265 6e61 2050 6c61 7466 6f72 6d5c 706c rena.Platform.pl
> 00000f90: 7567 696e 735c 6165 2e73 7068 6572 652e ugins.ae.sphere.
> 00000fa0: 6172 656e 612e 636f 6d6d 6f6e 5f32 2e32 arena.common.2.2
> 00000fb0: 2e31 5c6c 6962 5c63 6f6d 6d6f 6e73 2d6c .1.lib.commons.l
> 00000fc0: 616e 672d 322e 332e 6a61 7227 0d0a 2a73 ang.2.3.jar....s
> 00000fd0: 7973 2d70 6163 6b61 6765 2d6d 6772 2a3a ys.package.mgr..
> 00000fe0: 2070 726f 6365 7373 696e 6720 6e65 7720 .processing.new.
> 00000ff0: 6a61 722c 2027 433a 5c50 726f 6772 616d jar...C..Program
>
> at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
> at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:525)
> at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
>
>
>
>
>
> Thanks,
>
>
>
> Bassel
>