LiveConfig: ERROR: Releasing db connection, but still have open statements

ap24 · 15. März 2013

Hallo,

ich erhalte seit kurzem die folgende Fehlermeldung:

Code

[2013/03/15 10:34:58.369305] [2153|2166] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:34:58.369333] [2153|2166]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:34:58.369394] [2153|2166]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:34:58.369450] [2153|2166] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:34:58.610038] [2153|2166] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:35:58.430681] [2153|2168] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:35:58.430715] [2153|2168]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:35:58.430860] [2153|2168]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:35:58.431021] [2153|2168] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:35:58.612030] [2153|2168] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:36:58.489875] [2153|2167] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:36:58.489909] [2153|2167]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:36:58.490053] [2153|2167]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:36:58.490213] [2153|2167] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:36:58.685057] [2153|2167] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:37:58.549342] [2153|2166] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:37:58.549369] [2153|2166]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:37:58.549430] [2153|2166]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:37:58.549550] [2153|2166] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:37:58.653363] [2153|2166] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:38:58.611015] [2153|2168] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:38:58.611049] [2153|2168]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:38:58.611192] [2153|2168]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:38:58.611351] [2153|2168] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:38:58.835905] [2153|2168] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:39:58.672029] [2153|2167] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:39:58.672068] [2153|2167]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:39:58.672213] [2153|2167]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
[2013/03/15 10:39:58.672374] [2153|2167] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
[2013/03/15 10:39:58.891145] [2153|2167] Database exception: mysql_stmt_execute: (1062) Duplicate entry '1-1118' for key 'PRIMARY' (SQL: INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))
[2013/03/15 10:40:58.733067] [2153|2166] ERROR: Releasing db connection, but still have open statements
[2013/03/15 10:40:58.733095] [2153|2166]        aborting SQL: 'INSERT INTO RRD_CPU  ( RRD_ARCHIVEID, RRD_SLOTID, RRD_TIMESTAMP, RRD_VALUE1, RRD_VALUE2, RRD_VALUE3, RRD_VALUE4, RRD_VALUE5, RRD_VALUE6, RRD_VALUE7, RRD_VALUE8, RRD_VALUE9) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
[2013/03/15 10:40:58.733145] [2153|2166]        aborting SQL: 'SELECT RRA_ID, RRA_STEP, RRA_SIZE, RRA_SLOTPOS, RRA_LASTTS, RRA_VALUE1, RRD_VALUE1, RRA_VALUE2, RRD_VALUE2, RRA_VALUE3, RRD_VALUE3, RRA_VALUE4, RRD_VALUE4, RRA_VALUE5, RRD_VALUE5, RRA_VALUE6, RRD_VALUE6, RRA_VALUE7, RRD_VALUE7, RRA_VALUE8, RRD_VALUE8, RRA_VALUE9, RRD_VALUE9, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_CPU LEFT JOIN RRD_CPU ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'

Alles anzeigen

Vielen Dank

Alex

kk · 15. März 2013

Diese Meldungen sind im Grunde unkritisch (tritt dann auf, wenn sich in den eigentlichen RRD-Daten nichts geändert hat - durch einen Programmfehler wird dann der UPDATE-Befehl als "nicht erfolgreich" gewertet, dann ein INSERT versucht, und das schlägt natürlich fehl...).

Seit r2151 ist dieses Problem beseitigt; mit dem nächsten LiveConfig-Update sollte das also verschwinden.

Viele Grüße

-Klaus Keppler

Jetzt mitmachen!