praegune kellaaeg 04.11.2025 14:54:32 |
|
Hinnavaatlus
:: Foorum
:: Uudised
:: Ärifoorumid
:: HV F1 ennustusvõistlus
:: Pangalink
:: Telekavad
:: HV toote otsing
|
|
| autor |
|
raitl
HV veteran
liitunud: 20.01.2002
|
29.10.2012 09:34:27
InnoDB tabel corrupted. Help? |
|
|
Andmebaas crashis:
121027 2:14:11 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 356 3002403874
InnoDB: 4 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 12629 row operations to undo
InnoDB: Trx id counter is 0 364104704
121027 2:19:37 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72$
InnoDB: Apply batch completed
InnoDB: Starting in background the rollback of uncommitted transactions
121027 2:20:27 InnoDB: Rolling back trx with id 0 364104203, 1 rows to undo
121027 2:20:32 InnoDB: Started; log sequence number 356 3002403874
121027 2:20:53 [Note] Event Scheduler: Loaded 0 events
121027 2:20:53 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.10' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
InnoDB: Error: trying to load index PRIMARY for table database/table_name
InnoDB: but the index tree has been freed!
|
Peale seda jäi antud tabel tema jaoks kadunuks:
121027 2:21:21 [ERROR] Cannot find or open table database/table_name from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.
|
Järgides juhiseid, eemaldasin .frm faili ning üritasin backupist antud tabelit importida:
121029 9:13:05 InnoDB: Error: table `database`.`table_name` already exists in InnoDB internal
InnoDB: data dictionary. Have you deleted the .frm file
InnoDB: and not used DROP TABLE? Have you used DROP DATABASE
InnoDB: for InnoDB tables in MySQL version <= 3.23.43?
InnoDB: See the Restrictions section of the InnoDB manual.
InnoDB: You can drop the orphaned table inside InnoDB by
InnoDB: creating an InnoDB table with the same name in another
InnoDB: database and copying the .frm file to the current database.
InnoDB: Then MySQL thinks the table exists, and DROP TABLE will
InnoDB: succeed.
InnoDB: You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
|
Katsetasin ka backupist võetud .frm faili asetamist live andmebaasi /var/lib/mysql/database/ folderisse, tulemuseks taaskord esmane error:
[ERROR] Cannot find or open table database/table_name from
the internal data dictionary of InnoDB though the .frm file for the
table exists. |
Ülaltoodu annab lootust, et andmed on tegelikult alles. Küsimus on nüüd selles, kuidas nad uuesti andmebaasile endale nähtavaks ning söödavaks muuta?
|
|
| Kommentaarid: 166 loe/lisa |
Kasutajad arvavad: |
   |
:: |
1 :: |
0 :: |
147 |
|
| tagasi üles |
|
 |
Redikate
HV veteran
liitunud: 30.12.2005
|
|
| Kommentaarid: 34 loe/lisa |
Kasutajad arvavad: |
|
:: |
0 :: |
0 :: |
33 |
|
| tagasi üles |
|
|
muhelin
Kreisi kasutaja
liitunud: 13.02.2006
|
|
13.12.2012 22:32:41
|
|
|
Igaksjuhuks küsiks, kas see probleem tekkis peale serveri uuendust, et uuendati mysql serverit? sest viimastes uuendustega tekkis probleem.
Nimelt vanemates versioonides hoiti innodb andmebaaside infot ühes failis koos, kuid mingist versioonist löödi need lahku ja sealt tekkis ka see sama viga.
küsimus ongi selles kas vahepeal muutus mysql serveri versioon?
_________________
Hooldan ja remondin süle-ja lauaarvuteid:) |
|
| Kommentaarid: 206 loe/lisa |
Kasutajad arvavad: |
|
:: |
2 :: |
1 :: |
173 |
|
| tagasi üles |
|
|
|
| lisa lemmikuks |
|
 |
sa ei või postitada uusi teemasid siia foorumisse
sa ei või vastata selle foorumi teemadele
sa ei või muuta oma postitusi selles foorumis
sa ei või kustutada oma postitusi selles foorumis
sa ei või vastata küsitlustele selles foorumis
sa ei saa lisada manuseid selles foorumis
sa võid manuseid alla laadida selles foorumis
|
|
Hinnavaatlus ei vastuta foorumis tehtud postituste eest.
|
:: KKK
:: otsing 
:: statistika
:: kasutajate nimekiri
:: kasutajate grupid
:: registreeri
teata moderaatorile
