Hi,
we are experiencing some strange behaviour of a derby 10.8.2.2 database.
>From time to time the network server is restarting itself. It is restarting
in a very short time. Below you'll find a log showing the last statements
before and afer restart. Did you experience anything similar? What could be
done to track the problem down?
Thank you,
Stefan
Feb 01 11:28:58 CET 2013 Thread[DRDAConnThread_3,5,main] (XID = 932355723),
(SESSIONID = 1), (DATABASE = bd), (DRDAID =
��������.��-436003379210429777{2}), Executing prepared
statement:MMAND, t0.COMMANDPARAMETERS, t0.COMMANDPERIODTYPE,
t0.COMMANDPERIODVALUE, t0.DISABLED, t0.EXECUTEAFTER, t0.LASTEXECUTIONTIME,
t0.PERIODIC, t0.TARGETS, t0.USERNAME, t0.UU
ID, t0.VERSION, t0.TERMINAL_ID FROM ChargingTerminalCommands t0,
ChargingTerminals t1 WHERE (((t1.GSMMODULEIMEI = ?) AND
(t0.LASTEXECUTIONTIME IS NULL)) AND (t1.ID = t0.TERMINAL_ID)) ORDER
BY t0.EXECUTEAFTER ASC :End prepared statement with 1 parameters begin
parameter #1: 353234028287223 :end parameter
Fri Feb 01 11:28:58 CET 2013 Thread[DRDAConnThread_3,5,main] (XID =
932355723), (SESSIONID = 1), (DATABASE = bd), (DRDAID =
��������.��-436003379210429777{2}), Committingri Feb 01
11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID = 932355724),
(SESSIONID = 94), (DATABASE = bd), (DRDAID = {52}), Committing
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355724), (SESSIONID = 94), (DATABASE = bd), (DRDAID = {52}), Rolling back
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355725), (SESSIONID = 95), (DATABASE = bd), (DRDAID = {52}), Committing
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355725), (SESSIONID = 95), (DATABASE = bd), (DRDAID = {52}), Committing
ameter begin parameter #2: srv-bdrive-test-0011359714384082 :end parameter
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355726), (SESSIONID = 95), (DATABASE = bd), (DRDAID =
��������.���-954480286311289203{52}), Committing
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355726), (SESSIONID = 95), (DATABASE = bd), (DRDAID =
��������.���-954480286311289203{52}), Committing
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355726), (SESSIONID = 95), (DATABASE = bd), (DRDAID =
��������.���-954480286311289203{52}), Rolling back
Fri Feb 01 11:29:05 CET 2013 Thread[DRDAConnThread_10,5,main] (XID =
932355726), (SESSIONID = 95), (DATABASE = bd), (DRDAID =
��������.���-954480286311289203{52}), Rolling back
Fri Feb 01 11:29:17 CET 2013 Thread[DRDAConnThread_8,5,main] (XID =
932355727), (SESSIONID = 96), (DATABASE = bd), (DRDAID = {53}), Committing
Fri Feb 01 11:29:17 CET 2013 Thread[DRDAConnThread_8,5,main] (XID =
932355727), (SESSIONID = 96), (DATABASE = bd), (DRDAID = {53}), Rolling back
Fri Feb 01 11:29:17 CET 2013 Thread[DRDAConnThread_8,5,main] (XID =
932355728), (SESSIONID = 97), (DATABASE = bd), (DRDAID = {53}), Committing
----------------------------------------------------------------
Fri Feb 01 11:29:17 CET 2013:
Instanz a816c00e-013c-954a-979b-ffffa65a1dba im Datenbankverzeichnis
/opt/bdapps/data/bd mit Klassenlader
sun.misc.Launcher$AppClassLoader@7d772ewird heruntergefahren
Fri Feb 01 11:29:17 CET 2013 Thread[DRDAConnThread_8,5,main] (DATABASE =
bd), (DRDAID = {53}), Die Datenbank 'bd' wird heruntergefahren.
----------------------------------------------------------------
Fri Feb 01 11:29:18 CET 2013:
Booting Derby version The Apache Software Foundation - Apache Derby -
10.8.2.2 - (1181258): instance 778b540a-013c-954a-979b-ffffa65a1dba
on database directory /opt/bdapps/data/bd with class loader
sun.misc.Launcher$AppClassLoader@7d772e
Loaded from file:/opt/db-derby/lib/derby.jar
java.vendor=Sun Microsystems Inc.
java.runtime.version=1.6.0_22-b04
user.dir=/opt/db-derby
derby.system.home=/opt/bdapps/data
Database Class Loader started - derby.database.classpath=''
Fri Feb 01 11:29:18 CET 2013 Thread[DRDAConnThread_9,5,main] (XID =
932355825), (SESSIONID = 0), (DATABASE = bd), (DRDAID = {54}), Committing
Fri Feb 01 11:29:18 CET 2013 Thread[DRDAConnThread_9,5,main] (XID =
932355825), (SESSIONID = 0), (DATABASE = bd), (DRDAID = {54}), Rolling back
Fri Feb 01 11:29:18 CET 2013 Thread[DRDAConnThread_9,5,main] (XID =
932355826), (SESSIONID = 1), (DATABASE = bd), (DRDAID = {54}), Committing
Fri Feb 01 11:29:18 CET 2013 Thread[DRDAConnThread_9,5,main] (XID =
932355826), (SESSIONID = 1), (DATABASE = bd), (DRDAID = {54}), Committing
Fri Feb 01 11:29:18 CET 2013 Thread[DRDAConnThread_9,5,main] (XID =
932355827), (SESSIONID = 1), (DATABASE = bd), (DRDAID =
��������.���-954198811334565251{54}), Begin compiling
prepared statement: SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME,
PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = ? AND NEXT_FIRE_TIME < ?
AND (NEXT_FIRE_TIME >= ?) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC :End
prepared statement
