Bug #27242 | Cannot write to InnoDB tables. | ||
---|---|---|---|
Submitted: | 17 Mar 2007 22:49 | Modified: | 4 Oct 2012 7:02 |
Reporter: | Kyle Gato | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S1 (Critical) |
Version: | 5.0.33 | OS: | Linux (centOS 4.4 (64 Bit)) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[17 Mar 2007 22:49]
Kyle Gato
[18 Mar 2007 8:44]
Valeriy Kravchuk
Thank you for a problem report. Have you changed the size of InnoDB log files and then restarted server (note the first error message in your report)?
[18 Mar 2007 8:54]
Kyle Gato
You mean in the my.cnf file correct? I did try changing that to a larger number. (was 10M)
[18 Mar 2007 9:13]
Mou Chan
From the error log: Actual size = 5242880 Specified size = 52428800 One more zero at the end
[18 Mar 2007 9:16]
Kyle Gato
What is your recommended fix?
[18 Mar 2007 10:10]
Kyle Gato
I would also like to add this: 070317 11:55:28 InnoDB: Error: Write to file /opt/lampp/var/mysql/ib_logfile0 failed at offset 0 5005824. InnoDB: 4096 bytes should have been written, only 3584 were written. InnoDB: Operating system error number 22. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 22 means 'Invalid argument'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html 070317 11:55:28InnoDB: Assertion failure in thread 3647617968 in file fil0fil.c line 4023 InnoDB: Failing assertion: ret InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be
[18 Mar 2007 12:00]
Kyle Gato
Update: Fixed, i deleted the log files and made new ones.
[4 Oct 2012 7:02]
Marko Mäkelä
Duplicate of Bug#13494