There is a Database as “LOG_MONTH” and I was going to filter monthly wise data from this database and inserted to databases “LOG_SEP”,“LOG_OCT”,“LOG_NOV” by the use of a script. Unfortunately, space of /data mount reached 100% when inserting data to “LOG_NOV” database and now MYSQL DB is down.
Find the bellow error of the MySQL error log.
InnoDB: End of page dump
InnoDB: Page may be a freshly allocated page
2024-12-18T17:30:06.082884Z 0 [ERROR] [MY-011904] [InnoDB] Space id and page no stored in the page, read in are [page id: space=4278124286, page number=42 78124286], should be [page id: space=143991, page number=1]
/usr/sbin/mysqld() [0x243980f]
/lib64/libpthread.so.0(+0x7e65) [0x7ff4a5cdce65]
/lib64/libc.so.6(clone+0x6d) [0x7ff4a3a6188d]
You may download the Percona Server operations manual by visiting
MySQL Software - Best Enterprise MySQL Database Software | Percona. You may find information
in the manual which will help you identify the cause of the crash.