MySql database won't start

54 views
Skip to first unread message

Michael Harapiak

unread,
Mar 1, 2024, 12:37:57 PM3/1/24
to NodeChef
My MySQL database shut down today and will not restart.
It is giving an out of space complaint. The database itself is only using 36% of it space allocation, so it is something else. Any ideas?

The log shows:
2024-03-01T17:22:22.416329Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-01T17:22:22.416456Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-01T17:22:22.416663Z 0 [Warning] InnoDB: Retry attempts for writing partial data failed.
2024-03-01T17:22:22.416685Z 0 [ERROR] InnoDB: Write to file ./ibtmp1failed at offset 0, 1048576 bytes should have been written, only 0 were written. Operating system error number 28. Check that your OS and file system support files of this size. Check also that the disk is not full or a disk quota exceeded.
2024-03-01T17:22:22.416701Z 0 [ERROR] InnoDB: Error number 28 means 'No space left on device'
2024-03-01T17:22:22.416707Z 0 [Note] InnoDB: Some operating system error numbers are described at http://dev.mysql.com/doc/refman/5.7/en/operating-system-error-codes.html
2024-03-01T17:22:22.416712Z 0 [ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk spac

Michael Harapiak

unread,
Mar 5, 2024, 9:56:21 AM3/5/24
to NodeChef
Still having this issue. Can't use the database:
2024-03-05 14:54:39 MSDB1_Primary_im2023 2024-03-05T14:54:39.490222Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-05T14:54:39.490251Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-03-05T14:54:39.490256Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-03-05T14:54:39.490263Z 0 [ERROR] Failed to initialize plugins.
2024-03-05T14:54:39.490266Z 0 [ERROR] Aborting

Reply all
Reply to author
Forward
0 new messages