my database keeps crashing - i dont understand the log file

Problems with the Windows version of XAMPP, questions, comments, and anything related.

my database keeps crashing - i dont understand the log file

Postby mbenic » 07. August 2022 12:40

hi
my database crashed
i had lots of errors in the log file
i tried the following fix.

Open your folder "\xampp\mysql\data"
Delete the file "multi-master.info"
Delete all files beginning with "master-"
Delete all files beginning with "mysql_relay-bin-"
Delete all files beginning with "relay-log-"
Delete all files beginning with "ib_logfile"
Delete all files beginning with "aria_log."

and this helped get the database back up again

but id like to solve this as this is a recurring problem
what do you think is causing my database to crash

why do you think my database is corrupt??

this is some of the errors in the log file

mysqld.exe!?mysqld_main@@YAHHPEAPEAD@Z()
mysqld.exe!strxnmov()
KERNEL32.DLL!BaseThreadInitThunk()
ntdll.dll!RtlUserThreadStart()
The manual page at https://mariadb.com/kb/en/how-to-produc ... or-mysqld/ contains
information that should help you find out what is causing the crash.
Writing a core file at C:\xampp\mysql\data\
Minidump written to C:\xampp\mysql\data\mysqld.dmp
2022-08-07 19:17:10 0 [ERROR] mysqld.exe: File 'C:\xampp\mysql\data\aria_log.00000002' not found (Errcode: 2 "No such file or directory")
2022-08-07 19:17:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-08-07 19:17:10 0 [Note] InnoDB: Uses event mutexes
2022-08-07 19:17:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-08-07 19:17:10 0 [Note] InnoDB: Number of pools: 1
2022-08-07 19:17:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-08-07 19:17:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-08-07 19:17:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-08-07 19:17:10 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2022-08-07 19:17:10 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2022-08-07 19:17:10 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2022-08-07 19:17:10 0 [Note] InnoDB: New log files created, LSN=1692379396
2022-08-07 19:17:10 0 [ERROR] InnoDB: Page [page id: space=0, page number=4] log sequence number 1692619755 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/libra

etc





2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Page [page id: space=0, page number=392] log sequence number 1693284030 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Page [page id: space=0, page number=300] log sequence number 1693284074 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Page [page id: space=0, page number=480] log sequence number 1693284074 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Page [page id: space=0, page number=0] log sequence number 1693279335 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:10 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.
2022-08-07 19:17:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-08-07 19:17:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-08-07 19:17:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-08-07 19:17:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-08-07 19:17:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-08-07 19:17:10 0 [Note] InnoDB: Waiting for purge to start
2022-08-07 19:17:11 0 [Note] InnoDB: 10.4.20 started; log sequence number 1692379660; transaction id 548795
2022-08-07 19:17:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-08-07 19:17:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-08-07 19:17:11 0 [ERROR] InnoDB: Page [page id: space=0, page number=322] log sequence number 1693279335 is in the future! Current system log sequence number 1692379669.
2022-08-07 19:17:11 0 [Note] Server socket created on IP: '::'.
2022-08-07 19:17:11 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied


some help would be appreciated
thanks
mbenic
 
Posts: 47
Joined: 05. July 2021 13:16
XAMPP version: 8.07
Operating System: windows 10

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 96 guests