Guten Abend Herr Keppler,
ich möchte Sie bitten, sich dem Problem einmal anzunehmen. Ich habe das Problem auf einer SQLite und MySQL Installation. Verwendet wird jeweils Ubuntu 12.04 und das Release r2488.
Anbei mal ein Auszug aus dem Log seit dem letzten Start des LiveConfig Prozess vom Upgrade auf r2488.
113216 [2013/07/17 16:11:19.023392] [24227|24227] LiveConfig 1.6.4-2488 starting...
113217 [2013/07/17 16:11:19.024153] [24227|24227] Database driver loaded: MySQL (5.5.31)
113218 [2013/07/17 16:11:19.026550] [24227|24227] License is valid.
113219 [2013/07/17 16:11:19.028594] [24232|24232] Client child started...
113220 [2013/07/17 16:11:19.028806] [24230|24230] Server child started...
113221 [2013/07/17 16:11:19.031490] [24232|24232] Connected to LiveConfig 1.6.4
113222 [2013/07/17 16:11:19.127966] [24232|24235] [LUA] Detected 'Ubuntu 12.04.2 LTS'
113223 [2013/07/17 16:11:19.461360] [24232|24234] Can't get system informations: open(/dev/mem) failed: Operation not permitted
113224 [2013/07/17 16:11:34.794008] [24230|24306] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113225 [2013/07/17 16:14:05.555533] [24230|24230] Connection closed by peer
113226 [2013/07/17 16:37:48.627666] [24230|24238] (last message repeated 1 times)
113227 [2013/07/18 10:26:55.631652] [24230|24242] ERROR: Releasing db connection, but still have open statements
113228 [2013/07/18 10:26:55.632925] [24230|24242] aborting SQL: 'UPDATE RRD_MEM SET RRD_VALUE1= ?, RRD_VALUE2= ?, RRD_VALUE3= ?, RRD_VALUE4= ?, RRD_TIMESTAMP= ? WHERE ( ( RRD_ARCHIVEID = ? ) AND ( RRD_SLOTID = ? ) )'
113229 [2013/07/18 10:26:55.633014] [24230|24242] 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, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_MEM LEFT JOIN RRD_MEM ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_SERVERID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
113230 [2013/07/18 10:26:55.633064] [24230|24242] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
113231 [2013/07/18 10:26:55.633488] [24230|24242] Database exception: mysql_stmt_execute: (1213) Deadlock found when trying to get lock; try restarting transaction (SQL: UPDATE RRD_MEM SET RRD_VALUE1= ?, RRD_VALUE2= ?, RRD_VALUE3= ?, RRD_VALUE4= ?, RRD_TIMESTAMP= ? WHERE ( ( RRD_ARCHIVEID = ? ) AND ( RRD_SLOTID = ? ) ))
113232 [2013/07/18 16:11:34.432130] [24230|9323] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113233 [2013/07/19 00:29:43.930559] [24230|24238] Login failed - invalid password for user='admin'. Service='Web login', IP='31.xxx.75.230'
113234 [2013/07/19 09:29:44.296650] [24230|24237] Login failed - invalid password for user='admin'. Service='Web login', IP='31.xxx.75.230'
113235 [2013/07/19 09:35:09.048388] [24232|24234] [LUA] Adding system account 'web80201-347'
113236 [2013/07/19 09:38:46.490854] [24232|24235] [LUA] Adding system account 'web80201-348'
113237 [2013/07/19 12:31:17.858882] [24230|24237] Login failed - invalid/unknown user '80201'. Service='Web login', IP='178.xxx.xxx.3'
113238 [2013/07/19 12:33:28.038149] [24230|24238] (last message repeated 5 times)
113239 [2013/07/19 12:33:28.038149] [24230|24238] Login failed - invalid/unknown user '80201'. Service='Password recovery request', IP='178.200.120.3'
113240 [2013/07/19 16:11:34.984819] [24230|28889] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113241 [2013/07/20 14:26:47.952277] [24230|24242] ERROR: Releasing db connection, but still have open statements
113242 [2013/07/20 14:26:47.953455] [24230|24242] aborting SQL: 'UPDATE RRD_NET SET RRD_VALUE1= ?, RRD_VALUE2= ?, RRD_VALUE3= ?, RRD_VALUE4= ?, RRD_TIMESTAMP= ? WHERE ( ( RRD_ARCHIVEID = ? ) AND ( RRD_SLOTID = ? ) )'
113243 [2013/07/20 14:26:47.953554] [24230|24242] 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, RRD_SLOTID, RRD_TIMESTAMP FROM RRA_NET LEFT JOIN RRD_NET ON ( ( RRA_ID = RRD_ARCHIVEID ) AND ( RRA_SLOTPOS = RRD_SLOTID ) ) WHERE ( ( RRA_INTERFACEID = ? ) AND ( RRA_LEVEL = 0 ) ) ORDER BY RRA_ID ASC'
113244 [2013/07/20 14:26:47.953601] [24230|24242] ERROR: Releasing db connection, but still have running transaction (-> forcing ROLLBACK)
113245 [2013/07/20 14:26:47.953747] [24230|24242] Database exception: mysql_stmt_execute: (1213) Deadlock found when trying to get lock; try restarting transaction (SQL: UPDATE RRD_NET SET RRD_VALUE1= ?, RRD_VALUE2= ?, RRD_VALUE3= ?, RRD_VALUE4= ?, RRD_TIMESTAMP= ? WHERE ( ( RRD_ARCHIVEID = ? ) AND ( RRD_SLOTID = ? ) ))
113246 [2013/07/20 15:58:22.579726] [24230|24237] Login failed - invalid/unknown user '80201'. Service='Web login', IP='178.xxx.xxx.3'
113247 [2013/07/20 16:11:34.137927] [24230|14927] (last message repeated 3 times)
113248 [2013/07/20 16:11:34.137927] [24230|14927] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113249 [2013/07/21 16:11:34.296530] [24230|1215] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113250 [2013/07/22 16:11:34.753928] [24230|19786] Connecting to update.liveconfig.com ([2a01:138:a005::2:3]:443)...
113251 [2013/07/22 22:13:17.794260] [24232|24235] [LUA] Deleting mailbox webmaster@nady.plesk02.isp-kundenserver.de from dovecot config file: /etc/dovecot/passwd
113252 [2013/07/22 22:13:17.799480] [24230|24241] Deleting subscription 'web80201-347' (all objects deleted successfully)
113253 [2013/07/22 22:13:17.837616] [24232|24233] [LUA] Deleting system account 'web80201-347'
113254 [2013/07/22 22:14:35.480905] [24232|24235] [LUA] Deleting mailbox webmaster@stagingdomain.plesk01.isp-serverfarm.de from dovecot config file: /etc/dovecot/passwd
Alles anzeigen
Gelöscht wurde der subscription "web80201-348" diesmal über die LiveConfig API.
Request:
Array
(
[auth] => Array
(
[login] => admin
[timestamp] => 2013-07-22T20:14:35.000Z
[token] => 3iuTrfk=
)
[subscriptionname] => web80201-348
)
Alles anzeigen
Antwort von der API:
Aber im LiveConfig Log ist dies aber nicht zusehen. Hier taucht nur der vorherige Löschvorgang vom subscripion "web80201-347" welcher ebenfalls mit "ok" bestätigt wurde.
Array
(
[auth] => Array
(
[login] => admin
[timestamp] => 2013-07-22T20:13:17.000Z
[token] => +t47OSZFI=
)
[subscriptionname] => web80201-347
)
Alles anzeigen
Unter ACCOUNTSund HOSTINGCONTRACTS ist der subscription aber noch zu sehen.
http://imtp.me/5uno01y62.p
Erst nachdem ich diese beiden Einträge aus der MySQL DB gelöscht habe, war auch das Löschen des Kunden möglich gewesen.
Ich muss dazu extra sagen, ich habe vorher noch NIE in der Datenbank direkt etwas geändert bzw. gelöscht.