PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : mysql: inno db corrupt / startet nicht



SirSydom
10.01.07, 16:39
Nachdem mein grottenschlecht, unzuverlässiger, nicht auf Support-Ticket-Antwortender und Dauerend-Ausfallender vServer ISP (ispone-business.de) den ganzen Tag (über 24h) rumgepfuscht hat ist der vServer nun endlich wieder erreichbar.
Nun startet mysql mit folgender Meldung nicht mehr:



root@comefrom:~# mysqld
070110 16:36:52 InnoDB: ERROR: We were only able to scan the log up to
InnoDB: 0 7023616, but a checkpoint was at 0 7023743.
InnoDB: It is possible that the database is now corrupt!
070110 16:36:52 InnoDB: Started; log sequence number 0 7023743
mysqld: File '/var/log/mysql/mysql-bin.000046' not found (Errcode: 2)
070110 16:36:52 [ERROR] Failed to open log (file '/var/log/mysql/mysql-bin.000046', errno 2)
070110 16:36:52 [ERROR] Could not open log file
070110 16:36:52 [ERROR] Can't init tc log
070110 16:36:52 [ERROR] Aborting

070110 16:36:52 InnoDB: Starting shutdown...
070110 16:36:54 InnoDB: Shutdown completed; log sequence number 0 7023743
070110 16:36:54 [Note] mysqld: Shutdown complete


Ich bin mit fast sicher das alle DBs und Tables myisam waren und nicht innodb.

Was kann ich tun? Ich brauche den Server so schnell als möglich wieder up.

marce
10.01.07, 17:01
eine saubere Möglichkeit wäre, die DB komplett zu löschen und dann die Backups wieder einspielen...

SirSydom
10.01.07, 17:24
Es scheint nicht mysql zu betreffen, subversion mit einer berkleydb macht auch Probleme.

Das letzte Backup ist vom 13.12, ich krieg die Krätze..

himbeere
10.01.07, 17:27
Wenn Du sicher bist, das die DBs Myisam waren, kannste ja mal versuchen in die my.cnf "skip-innodb" zu schreiben.

SirSydom
10.01.07, 19:19
ich hab mysql zum laufen gebracht, indem ich der ordner /var/log/mysql/ geleert habe.

Nun startet der mysqld wieder beim ersten mal noch mit meckerei nun ohne.
Lediglich eine Mail geht an root.
Beim ersten mal:



dosp_blogfelix._comments
warning : 1 client is using or hasn't closed the table properly
dosp_blogfelix._entries
warning : 1 client is using or hasn't closed the table properly
dosp_blogfelix._entrycat
warning : 1 client is using or hasn't closed the table properly
error : Found 290 keys of 291
error : Corrupt
dosp_blogfelix._images
warning : 1 client is using or hasn't closed the table properly
dosp_blogfelix._permalinks
warning : 1 client is using or hasn't closed the table properly
warning : Size of datafile is: 23376 Should be: 23240
error : Found 483 keys of 480
error : Corrupt
dosp_blogfelix._references
warning : 1 client is using or hasn't closed the table properly
dosp_blogfelix._referrers
warning : 1 client is using or hasn't closed the table properly
dosp_blogfelix._suppress
warning : 1 client is using or hasn't closed the table properly
sys_mail.domains
warning : 1 client is using or hasn't closed the table properly
sys_mail.forwardings
warning : 1 client is using or hasn't closed the table properly

Improperly closed tables are also reported if clients are accessing
the tables *now*. A list of current connections is below.

+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 6 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 3 Threads: 1 Questions: 309 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 103.000


Beim zweiten mal:



dosp_blogfelix._entrycat
error : Table './dosp_blogfelix/_entrycat' is marked as crashed and should be repaired
dosp_blogfelix._permalinks
error : Table './dosp_blogfelix/_permalinks' is marked as crashed and should be repaired

Improperly closed tables are also reported if clients are accessing
the tables *now*. A list of current connections is below.

+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 6 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 2 Threads: 1 Questions: 309 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 64 Queries per second avg: 154.500


Gott sei Dank hab ich genau für diese DB ein aktuelles Backup !
Die anderen kann ich als "repariert" betrachten, oder?

Jetzt brauche ich nur noch eine Möglichkeit das SVN-Repo zu fixen..



[Tue Jan 02 12:56:20 2007] [notice] SIGHUP received. Attempting to restart
[Tue Jan 02 12:56:20 2007] [notice] Apache/2.0.55 (Ubuntu) DAV/2 SVN/1.3.1 PHP/5.1.2 mod_ssl/2.0.55 OpenSSL/0.9.8a mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
[Tue Jan 02 14:15:06 2007] [error] [client 84.56.101.194] Could not CHECKOUT resource /svn/!svn/ver/43/SE-Projekt/Code/solarsim/SolarEnergyDll/SolarEnergyDll.vcproj. [409, #0]
[Tue Jan 02 14:15:06 2007] [error] [client 84.56.101.194] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 14:15:34 2007] [error] [client 84.56.101.194] Could not CHECKOUT resource /svn/!svn/ver/43/SE-Projekt/Code/solarsim/SolarEnergyDll/SolarEnergyDll.vcproj. [409, #0]
[Tue Jan 02 14:15:34 2007] [error] [client 84.56.101.194] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 14:16:12 2007] [error] [client 84.56.101.194] Could not CHECKOUT resource /svn/!svn/ver/51/SE-Projekt/Code/solarsim/SolarEnergyDll.suo. [409, #0]
[Tue Jan 02 14:16:12 2007] [error] [client 84.56.101.194] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 14:22:31 2007] [error] [client 89.51.176.134] Failed to create new lock. [500, #160042]
[Tue Jan 02 14:22:31 2007] [error] [client 89.51.176.134] Lock failed: newer version of '/SE-Projekt/Code/solarsim/Test_SolarDll/SolarEnergyDll.lib' exists [500, #160042]
[Tue Jan 02 14:26:27 2007] [error] [client 89.51.176.134] Failed to create new lock. [500, #160042]
[Tue Jan 02 14:26:27 2007] [error] [client 89.51.176.134] Lock failed: newer version of '/SE-Projekt/Code/solarsim/Test_SolarDll/SolarEnergyDll.dll' exists [500, #160042]
[Tue Jan 02 15:01:19 2007] [error] [client 89.51.176.108] Provider encountered an error while streaming a REPORT response. [500, #0]
[Tue Jan 02 15:01:19 2007] [error] [client 89.51.176.108] A failure occurred while driving the update report editor [500, #104]
[Tue Jan 02 15:01:51 2007] [error] [client 89.51.176.108] Could not CHECKOUT resource /svn/!svn/ver/54/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Tue Jan 02 15:01:51 2007] [error] [client 89.51.176.108] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 15:04:32 2007] [error] [client 89.51.176.108] Could not CHECKOUT resource /svn/!svn/ver/54/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Tue Jan 02 15:04:32 2007] [error] [client 89.51.176.108] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 15:05:30 2007] [error] [client 89.51.176.108] Could not CHECKOUT resource /svn/!svn/ver/54/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Tue Jan 02 15:05:30 2007] [error] [client 89.51.176.108] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 15:12:11 2007] [error] [client 89.51.176.108] Could not CHECKOUT resource /svn/!svn/ver/55/SE-Projekt/Code/solarsim/SolarEnergyDll/Sonnensuche.h. [409, #0]
[Tue Jan 02 15:12:11 2007] [error] [client 89.51.176.108] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Tue Jan 02 15:13:29 2007] [error] [client 89.51.176.108] Provider encountered an error while streaming a REPORT response. [500, #0]
[Tue Jan 02 15:13:29 2007] [error] [client 89.51.176.108] A failure occurred while driving the update report editor [500, #104]
[Tue Jan 02 15:13:29 2007] [error] [client 89.51.176.108] Error writing base64 data: Connection reset by peer [500, #104]
[Tue Jan 02 15:13:46 2007] [error] [client 89.51.176.108] Could not CHECKOUT resource /svn/!svn/ver/55/SE-Projekt/Code/solarsim/SolarEnergyDll.suo. [409, #0]
[Tue Jan 02 15:13:46 2007] [error] [client 89.51.176.108] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Thu Jan 04 17:57:39 2007] [error] [client 84.56.122.127] Could not CHECKOUT resource /svn/!svn/ver/70/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp. [409, #0]
[Thu Jan 04 17:57:39 2007] [error] [client 84.56.122.127] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Thu Jan 04 19:31:32 2007] [error] [client 84.57.126.172] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Fri Jan 05 13:03:35 2007] [error] [client 84.146.123.141] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h due to a failed precondition (e.g. other locks). [423, #0]
[Fri Jan 05 13:03:35 2007] [error] [client 84.146.123.141] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Fri Jan 05 16:18:30 2007] [error] [client 84.146.72.162] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 11:20:27 2007] [error] [client 89.51.179.214] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 11:20:27 2007] [error] [client 89.51.179.214] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 11:21:30 2007] [error] [client 89.51.179.214] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 11:21:30 2007] [error] [client 89.51.179.214] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 13:45:59 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/105/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp. [409, #0]
[Sat Jan 06 13:45:59 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 15:34:03 2007] [error] [client 84.56.124.41] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarSimGUI/SolarEnergyDll.dll due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 15:34:03 2007] [error] [client 84.56.124.41] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 17:14:43 2007] [error] [client 89.51.175.114] Could not CHECKOUT resource /svn/!svn/ver/107/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Sat Jan 06 17:14:43 2007] [error] [client 89.51.175.114] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 17:15:11 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/103/SE-Projekt/Code/solarsim/SolarEnergyDll/Settings.cpp. [409, #0]
[Sat Jan 06 17:15:11 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 17:17:20 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/109/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Sat Jan 06 17:17:20 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 17:17:50 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/109/SE-Projekt/Code/solarsim/SolarEnergyDll/SettingsAndConfig.h. [409, #0]
[Sat Jan 06 17:17:50 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 18:26:34 2007] [error] [client 84.146.92.134] Failed to create new lock. [500, #160042]
[Sat Jan 06 18:26:34 2007] [error] [client 84.146.92.134] Lock failed: newer version of '/SE-Projekt/Code/solarsim/SolarSimGUI/SolarEnergyDll.lib' exists [500, #160042]
[Sat Jan 06 18:26:35 2007] [error] [client 84.146.92.134] Failed to create new lock. [500, #160042]
[Sat Jan 06 18:26:35 2007] [error] [client 84.146.92.134] Lock failed: newer version of '/SE-Projekt/Code/solarsim/SolarSimGUI/SolarEnergyDll.dll' exists [500, #160042]
[Sat Jan 06 19:28:22 2007] [error] [client 84.146.92.134] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 19:32:22 2007] [error] [client 84.146.92.134] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 19:45:34 2007] [error] [client 84.56.124.41] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarSimGUI/res/SolarSimGUI.ico due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 19:45:34 2007] [error] [client 84.56.124.41] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 19:46:12 2007] [error] [client 84.56.124.41] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarSimGUI/stdafx.h due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 19:46:12 2007] [error] [client 84.56.124.41] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 19:47:05 2007] [error] [client 84.56.124.41] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarSimGUI/res/SolarSimGUI.ico due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 19:47:05 2007] [error] [client 84.56.124.41] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 19:48:28 2007] [error] [client 84.56.124.41] Could not LOCK /svn/SE-Projekt/Code/solarsim/SolarSimGUI/res/SolarSimGUI.ico due to a failed precondition (e.g. other locks). [423, #0]
[Sat Jan 06 19:48:28 2007] [error] [client 84.56.124.41] Existing lock(s) on the requested resource prevent an exclusive lock. [423, #0]
[Sat Jan 06 21:07:39 2007] [error] [client 84.56.83.192] File does not exist: /var/www/favicon.ico
[Sat Jan 06 22:31:46 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/117/SE-Projekt/Code/solarsim/SolarSimGUI/SolarSimGUIDlg.cpp. [409, #0]
[Sat Jan 06 22:31:46 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 22:32:26 2007] [error] [client 84.56.127.90] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 22:33:25 2007] [error] [client 84.56.127.90] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 22:41:00 2007] [error] [client 84.56.127.90] This resource is locked and an "If:" header was not supplied to allow access to the resource. [423, #0]
[Sat Jan 06 22:59:35 2007] [error] [client 84.56.127.90] Could not CHECKOUT resource /svn/!svn/ver/113/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp. [409, #0]
[Sat Jan 06 22:59:35 2007] [error] [client 84.56.127.90] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sat Jan 06 23:36:53 2007] [error] [client 84.146.92.134] Could not CHECKOUT resource /svn/!svn/ver/119/SE-Projekt/Code/solarsim/SolarEnergyDll/Dispatcher.cpp. [409, #0]
[Sat Jan 06 23:36:53 2007] [error] [client 84.146.92.134] The version resource does not correspond to the resource within the transaction. Either the requested version resource is out of date (needs to be updated), or the requested version resource is newer than the transaction root (restart the commit). [409, #160024]
[Sun Jan 07 06:26:00 2007] [notice] caught SIGTERM, shutting down
[Wed Jan 10 15:30:32 2007] [notice] Apache/2.0.55 (Ubuntu) DAV/2 SVN/1.3.1 PHP/5.1.2 mod_ssl/2.0.55 OpenSSL/0.9.8a mod_perl/2.0.2 Perl/v5.8.7 configured -- resuming normal operations
[Wed Jan 10 16:55:37 2007] [error] [client 84.146.96.117] A failure occurred while driving the update report editor [500, #160004]
[Wed Jan 10 16:55:37 2007] [error] [client 84.146.96.117] Revision file lacks trailing newline [500, #160004]
[Wed Jan 10 16:55:49 2007] [error] [client 84.146.96.117] A failure occurred while driving the update report editor [500, #160004]
[Wed Jan 10 16:55:49 2007] [error] [client 84.146.96.117] Revision file lacks trailing newline [500, #160004]
[Wed Jan 10 16:56:18 2007] [error] [client 84.146.96.117] Could not fetch resource information. [500, #0]
[Wed Jan 10 16:56:18 2007] [error] [client 84.146.96.117] Error checking kind of path '/SE-Projekt/Abgabe_20070108' in repository [500, #160014]
[Wed Jan 10 16:56:18 2007] [error] [client 84.146.96.117] Reference to non-existent node '9z.0.r164/65399' in filesystem '/var/svn/db' [500, #160014]
[Wed Jan 10 16:57:16 2007] [error] [client 84.146.96.117] A failure occurred while driving the update report editor [500, #160004]
[Wed Jan 10 16:57:16 2007] [error] [client 84.146.96.117] Revision file lacks trailing newline [500, #160004]
[Wed Jan 10 17:01:45 2007] [error] [client 84.56.75.242] Provider encountered an error while streaming a REPORT response. [500, #0]
[Wed Jan 10 17:01:45 2007] [error] [client 84.56.75.242] A failure occurred while driving the update report editor [500, #185003]
[Wed Jan 10 17:01:45 2007] [error] [client 84.56.75.242] Invalid diff stream: insn 1286 has non-positive length [500, #185003]
[Wed Jan 10 17:02:22 2007] [error] [client 84.56.75.242] Provider encountered an error while streaming a REPORT response. [500, #0]
[Wed Jan 10 17:02:22 2007] [error] [client 84.56.75.242] A failure occurred while driving the update report editor [500, #185003]
[Wed Jan 10 17:02:22 2007] [error] [client 84.56.75.242] Invalid diff stream: insn 1286 has non-positive length [500, #185003]
[Wed Jan 10 17:50:38 2007] [error] [client 84.146.96.117] Could not fetch resource information. [500, #0]
[Wed Jan 10 17:50:38 2007] [error] [client 84.146.96.117] Error checking kind of path '/SE-Projekt/Abgabe_20070108' in repository [500, #160014]
[Wed Jan 10 17:50:38 2007] [error] [client 84.146.96.117] Reference to non-existent node '9z.0.r164/65399' in filesystem '/var/svn/db' [500, #160014]
[Wed Jan 10 17:50:49 2007] [error] [client 84.146.96.117] A failure occurred while driving the update report editor [500, #160004]
[Wed Jan 10 17:50:49 2007] [error] [client 84.146.96.117] Revision file lacks trailing newline [500, #160004]
[Wed Jan 10 17:52:29 2007] [error] [client 84.146.96.117] Could not fetch resource information. [500, #0]
[Wed Jan 10 17:52:29 2007] [error] [client 84.146.96.117] Error checking kind of path '/SE-Projekt/Abgabe_20070108' in repository [500, #160014]
[Wed Jan 10 17:52:29 2007] [error] [client 84.146.96.117] Reference to non-existent node '9z.0.r164/65399' in filesystem '/var/svn/db' [500, #160014]