Carlos,
when filing bug reports for any software, not just MySQL, you should provide the full information. You should not try to pick the relevant material yourself.
What do you have in your my.cnf file? What does the '/data' directory contain?
The errors below look like you would have at least two ibdata files, with conflicting lsn stamps in them. InnoDB refuses to init the log files because the data files do not match.
Regards,
Heikki
----- Alkuperäinen viesti ----- Lähettäjä: "Carlos Augusto" <[EMAIL PROTECTED]>
Vastaanottaja: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Lähetetty: Thursday, November 25, 2004 8:01 PM
Aihe: Innodb Corruption with error logs now.
Well, let me begin again..
I´m new in a corporation and my jobs is deal with mysql.
We had, running mysqld 4.1.7 and using Innodb for a database of 4.7GB~. But some time inserting data into it, the server crashed.
So i get the server do analyze it.
When i get to the server the mysqld(config-file,errorfile)was ready removed and only ibdata1 file was in hd. I installed mysqld now and I tryed to put ibdata1 into /data files. When i did this i started the daemon and i get some errors( Ill paste all errors at the end of the post) . Then i tryed to add into my.ini the following parameter: innodb_force_recovery =1. And i get new errors. I tryed change the value for 2, and 3 respectively. The only thing i´ve changed at my.ini was this one above.
Now i´m pasting the FULL content of errorlog.
I aprecciate your help and thanks for attention,
==========Begin Error log===============
----> I pasted the ibdata1 at /data directory
041125 15:22:18 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
041125 15:22:18 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Cannot initialize created log files because
InnoDB: data files are corrupt, or new data files were
InnoDB: created when the database was started previous
InnoDB: time but the database was not shut down
InnoDB: normally after that.
041125 15:22:18 [ERROR] Can't init databases
041125 15:22:18 [ERROR] Aborting
041125 15:22:18 [Note] mysqld: Shutdown complete
----> the part bellow i tryed to use innodb_force_recovery = 1 InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html 041125 15:27:14 [ERROR] Can't init databases 041125 15:27:14 [ERROR] Aborting
041125 15:27:14 [Note] mysqld: Shutdown complete
----> the part bellow i tryed to use innodb_force_recovery = 2 InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html 041125 15:28:54 [ERROR] Can't init databases 041125 15:28:54 [ERROR] Aborting
041125 15:28:54 [Note] mysqld: Shutdown complete
----> the part bellow i tryed to use innodb_force_recovery = 3
InnoDB: No valid checkpoint found. InnoDB: If this error appears when you are creating an InnoDB database, InnoDB: the problem may be that during an earlier attempt you managed InnoDB: to create the InnoDB data files, but log file creation failed. InnoDB: If that is the case, please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Error_creating_InnoDB.html 041125 15:41:04 [ERROR] Can't init databases 041125 15:41:04 [ERROR] Aborting
041125 15:41:04 [Note] mysqld: Shutdown complete
==========End Error log===============
Thanks
Carlos
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
