XAMPP mysql database stops working suddenly

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

XAMPP mysql database stops working suddenly

Postby romankubiv101 » 04. August 2019 22:10

xampp works totaly fine for about 2 weeeks and then this issue occurs

when i try to start mysql database , it "starts" for about 7 seconds and then crashes, see logs below

reinstalling usualy fixes the issue but this time i had to save the data on the database so i coppied the files in this tutorial https://stackoverflow.com/questions/9860118/how-to-transfer-my-mysql-database-to-another-computer
and the issue persists
i think this is as issue that i have seen in another post about a version of xampp corrupting databses



9:48:49 PM [main] Initializing Control Panel
9:48:49 PM [main] Windows Version: Enterprise 64-bit
9:48:49 PM [main] XAMPP Version: 7.3.6
9:48:49 PM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
9:48:49 PM [main] You are not running with administrator rights! This will work for
9:48:49 PM [main] most application stuff but whenever you do something with services
9:48:49 PM [main] there will be a security dialogue or things will break! So think
9:48:49 PM [main] about running this application with administrator rights!
9:48:49 PM [main] XAMPP Installation Directory: "c:\xampp\phpmyadmin\"
9:48:49 PM [main] Checking for prerequisites
9:48:49 PM [main] All prerequisites found
9:48:49 PM [main] Initializing Modules
9:48:49 PM [main] Starting Check-Timer
9:48:49 PM [main] Control Panel Ready
9:48:51 PM [mysql] Attempting to start MySQL app...
9:48:52 PM [mysql] Status change detected: running
9:49:01 PM [Apache] Attempting to start Apache app...
9:49:01 PM [Apache] Status change detected: running
9:49:03 PM [mysql] Status change detected: stopped
9:49:03 PM [mysql] Error: MySQL shutdown unexpectedly.
9:49:03 PM [mysql] This may be due to a blocked port, missing dependencies,
9:49:03 PM [mysql] improper privileges, a crash, or a shutdown by another method.
9:49:03 PM [mysql] Press the Logs button to view error logs and check
9:49:03 PM [mysql] the Windows Event Viewer for more clues
9:49:03 PM [mysql] If you need more help, copy and post this
9:49:03 PM [mysql] entire log window on the forums
9:50:42 PM [Apache] Attempting to stop Apache (PID: 4024)
9:50:42 PM [Apache] Attempting to stop Apache (PID: 14152)
9:50:42 PM [Apache] Status change detected: stopped



mysql errors
2019-07-05 14:03:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-05 14:03:42 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:03:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:03:42 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:03:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:03:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-05 14:03:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:03:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1791378
2019-07-05 14:03:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-05 14:03:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-05 14:03:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-05 14:03:43 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-05 14:03:43 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-05 14:03:43 0 [Note] InnoDB: Waiting for purge to start
2019-07-05 14:03:43 0 [Note] InnoDB: 10.3.16 started; log sequence number 1791387; transaction id 163
2019-07-05 14:03:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-05 14:03:43 0 [Note] InnoDB: Buffer pool(s) load completed at 190705 14:03:43
2019-07-05 14:03:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:03:43 0 [Note] Server socket created on IP: '::'.
2019-07-05 14:33:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-05 14:33:22 0 [Note] InnoDB: Uses event mutexes
2019-07-05 14:33:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 14:33:22 0 [Note] InnoDB: Number of pools: 1
2019-07-05 14:33:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 14:33:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-05 14:33:22 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 14:33:22 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1802696
2019-07-05 14:33:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-05 14:33:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-05 14:33:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-05 14:33:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-05 14:33:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-05 14:33:23 0 [Note] InnoDB: 10.3.16 started; log sequence number 1802705; transaction id 219
2019-07-05 14:33:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-05 14:33:23 0 [Note] InnoDB: Buffer pool(s) load completed at 190705 14:33:23
2019-07-05 14:33:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 14:33:23 0 [Note] Server socket created on IP: '::'.
2019-07-05 15:14:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-05 15:14:53 0 [Note] InnoDB: Uses event mutexes
2019-07-05 15:14:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-05 15:14:53 0 [Note] InnoDB: Number of pools: 1
2019-07-05 15:14:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-05 15:14:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-05 15:14:53 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-05 15:14:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1802714
2019-07-05 15:14:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-05 15:14:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-05 15:14:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-05 15:14:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-05 15:14:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-05 15:14:54 0 [Note] InnoDB: Waiting for purge to start
2019-07-05 15:14:54 0 [Note] InnoDB: 10.3.16 started; log sequence number 1802723; transaction id 219
2019-07-05 15:14:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-05 15:14:54 0 [Note] InnoDB: Buffer pool(s) load completed at 190705 15:14:54
2019-07-05 15:14:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-05 15:14:54 0 [Note] Server socket created on IP: '::'.
2019-07-28 22:00:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-28 22:00:05 0 [Note] InnoDB: Uses event mutexes
2019-07-28 22:00:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-28 22:00:05 0 [Note] InnoDB: Number of pools: 1
2019-07-28 22:00:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-28 22:00:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-28 22:00:05 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-28 22:00:05 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=1944209
2019-07-28 22:00:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-28 22:00:05 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-28 22:00:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-28 22:00:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-28 22:00:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-28 22:00:05 0 [Note] InnoDB: Waiting for purge to start
2019-07-28 22:00:05 0 [Note] InnoDB: 10.3.16 started; log sequence number 1944218; transaction id 406
2019-07-28 22:00:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-28 22:00:05 0 [Note] InnoDB: Buffer pool(s) load completed at 190728 22:00:05
2019-07-28 22:00:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-28 22:00:05 0 [Note] Server socket created on IP: '::'.
2019-07-29 16:36:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-29 16:36:58 0 [Note] InnoDB: Uses event mutexes
2019-07-29 16:36:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-29 16:36:58 0 [Note] InnoDB: Number of pools: 1
2019-07-29 16:36:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-29 16:36:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-29 16:36:58 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-29 16:36:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=2710962
2019-07-29 16:36:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-29 16:36:59 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-29 16:36:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-29 16:36:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-29 16:36:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-29 16:36:59 0 [Note] InnoDB: Waiting for purge to start
2019-07-29 16:36:59 0 [Note] InnoDB: 10.3.16 started; log sequence number 2710971; transaction id 970
2019-07-29 16:36:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-29 16:36:59 0 [Note] InnoDB: Buffer pool(s) load completed at 190729 16:36:59
2019-07-29 16:36:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-29 16:36:59 0 [Note] Server socket created on IP: '::'.
2019-07-30 12:32:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-07-30 12:32:05 0 [Note] InnoDB: Uses event mutexes
2019-07-30 12:32:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-07-30 12:32:05 0 [Note] InnoDB: Number of pools: 1
2019-07-30 12:32:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-07-30 12:32:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-07-30 12:32:05 0 [Note] InnoDB: Completed initialization of buffer pool
2019-07-30 12:32:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3083886
2019-07-30 12:32:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-07-30 12:32:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-07-30 12:32:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-07-30 12:32:06 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-07-30 12:32:06 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-07-30 12:32:06 0 [Note] InnoDB: Waiting for purge to start
2019-07-30 12:32:06 0 [Note] InnoDB: 10.3.16 started; log sequence number 3083895; transaction id 1163
2019-07-30 12:32:06 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-07-30 12:32:06 0 [Note] InnoDB: Buffer pool(s) load completed at 190730 12:32:06
2019-07-30 12:32:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-07-30 12:32:06 0 [Note] Server socket created on IP: '::'.
2019-08-01 12:16:16 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-01 12:16:16 0 [Note] InnoDB: Uses event mutexes
2019-08-01 12:16:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-01 12:16:16 0 [Note] InnoDB: Number of pools: 1
2019-08-01 12:16:16 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-01 12:16:16 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-01 12:16:16 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-01 12:16:16 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3307180
2019-08-01 12:16:16 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-01 12:16:16 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-01 12:16:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-01 12:16:16 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-01 12:16:16 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-01 12:16:16 0 [Note] InnoDB: Waiting for purge to start
2019-08-01 12:16:16 0 [Note] InnoDB: 10.3.16 started; log sequence number 3307189; transaction id 1214
2019-08-01 12:16:16 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-01 12:16:16 0 [Note] InnoDB: Buffer pool(s) load completed at 190801 12:16:16
2019-08-01 12:16:16 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-01 12:16:16 0 [Note] Server socket created on IP: '::'.
2019-08-03 12:23:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-03 12:23:57 0 [Note] InnoDB: Uses event mutexes
2019-08-03 12:23:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-03 12:23:57 0 [Note] InnoDB: Number of pools: 1
2019-08-03 12:23:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-03 12:23:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-03 12:23:57 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-03 12:23:58 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3542655
2019-08-03 12:23:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-03 12:23:58 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-03 12:23:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-03 12:23:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-03 12:23:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-03 12:23:58 0 [Note] InnoDB: Waiting for purge to start
2019-08-03 12:23:58 0 [Note] InnoDB: 10.3.16 started; log sequence number 3542664; transaction id 1316
2019-08-03 12:23:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-03 12:23:58 0 [Note] InnoDB: Buffer pool(s) load completed at 190803 12:23:58
2019-08-03 12:23:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-03 12:23:58 0 [Note] Server socket created on IP: '::'.
2019-08-03 14:39:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-03 14:39:45 0 [Note] InnoDB: Uses event mutexes
2019-08-03 14:39:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-03 14:39:45 0 [Note] InnoDB: Number of pools: 1
2019-08-03 14:39:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-03 14:39:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-03 14:39:45 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-03 14:39:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3553141
2019-08-03 14:39:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-03 14:39:46 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-03 14:39:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-03 14:39:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-03 14:39:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-03 14:39:46 0 [Note] InnoDB: Waiting for purge to start
2019-08-03 14:39:46 0 [Note] InnoDB: 10.3.16 started; log sequence number 3553150; transaction id 1336
2019-08-03 14:39:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-03 14:39:46 0 [Note] InnoDB: Buffer pool(s) load completed at 190803 14:39:46
2019-08-03 14:39:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-03 14:39:46 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:02:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:02:27 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:02:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:02:27 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:02:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:02:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:02:27 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:02:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=3980176
2019-08-04 21:02:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:02:27 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-04 21:02:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:02:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:02:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:02:27 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:02:27 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980185; transaction id 1775
2019-08-04 21:02:27 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:02:27 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:02:27
2019-08-04 21:02:27 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:02:27 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:03:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:03:11 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:03:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:03:11 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:03:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:03:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:03:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:03:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:03:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:03:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:03:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:03:11 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:03:12 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980194; transaction id 1775
2019-08-04 21:03:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:03:12 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:03:12
2019-08-04 21:03:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:03:12 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:03:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:03:59 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:03:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:03:59 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:04:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:04:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:04:00 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:04:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:04:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:04:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:04:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:04:00 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:04:00 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980203; transaction id 1775
2019-08-04 21:04:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:04:00 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:04:00
2019-08-04 21:04:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:04:00 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:04:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:04:37 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:04:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:04:37 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:04:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:04:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:04:37 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:04:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:04:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:04:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:04:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:04:37 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:04:37 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980212; transaction id 1775
2019-08-04 21:04:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:04:37 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:04:37
2019-08-04 21:04:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:04:37 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:05:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:05:42 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:05:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:05:42 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:05:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:05:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:05:42 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:05:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:05:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:05:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:05:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:05:42 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:05:42 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980221; transaction id 1775
2019-08-04 21:05:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:05:42 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:05:42
2019-08-04 21:05:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:05:42 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:21:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:21:11 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:21:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:21:11 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:21:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:21:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:21:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:21:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:21:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:21:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:21:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:21:11 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:21:11 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980230; transaction id 1775
2019-08-04 21:21:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:21:11 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:21:11
2019-08-04 21:21:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:21:11 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:21:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:21:38 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:21:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:21:38 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:21:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:21:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:21:38 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:21:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:21:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:21:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:21:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:21:38 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:21:38 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980239; transaction id 1775
2019-08-04 21:21:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:21:38 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:21:38
2019-08-04 21:21:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:21:38 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:27:29 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:27:29 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:27:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:27:29 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:27:29 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:27:29 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:27:29 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:27:29 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:27:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:27:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:27:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:27:29 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:27:29 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980248; transaction id 1775
2019-08-04 21:27:29 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-08-04 21:27:29 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:27:29
2019-08-04 21:27:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:27:29 0 [Note] Server socket created on IP: '::'.
2019-08-04 21:48:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-04 21:48:52 0 [Note] InnoDB: Uses event mutexes
2019-08-04 21:48:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-04 21:48:52 0 [Note] InnoDB: Number of pools: 1
2019-08-04 21:48:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-04 21:48:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-04 21:48:52 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-04 21:48:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-04 21:48:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-08-04 21:48:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-04 21:48:52 0 [Note] InnoDB: Setting file 'C:\xampp\phpMyAdmin\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-04 21:48:52 0 [Note] InnoDB: File 'C:\xampp\phpMyAdmin\mysql\data\ibtmp1' size is now 12 MB.
2019-08-04 21:48:52 0 [Note] InnoDB: Waiting for purge to start
2019-08-04 21:48:52 0 [Note] InnoDB: 10.3.16 started; log sequence number 3980257; transaction id 1775
2019-08-04 21:48:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\phpMyAdmin\mysql\data\ib_buffer_pool
2019-08-04 21:48:52 0 [Note] InnoDB: Buffer pool(s) load completed at 190804 21:48:52
2019-08-04 21:48:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-04 21:48:52 0 [Note] Server socket created on IP: '::'.
romankubiv101
 
Posts: 2
Joined: 04. August 2019 22:00
XAMPP version: 3.2.4
Operating System: Windows 10 pro

Re: XAMPP mysql database stops working suddenly

Postby Altrea » 05. August 2019 04:17

Hi,

All XAMPP versions released since June have an known issue related to the way XAMPP Stopps the Mariadb server. MariaDB 10.3 seems to don't like this any more, Mariadb 10.1 versions are fine.

So my recommendation for you is simply use an XAMPP version released earlier then June 2019 (for example XAMPP 7.3.5).
You can find old XAMPP versions here: https://sourceforge.net/projects/xampp/ ... 20Windows/

Best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: XAMPP mysql database stops working suddenly

Postby romankubiv101 » 05. August 2019 16:38

Oki Doke
Tank you verry much :)
romankubiv101
 
Posts: 2
Joined: 04. August 2019 22:00
XAMPP version: 3.2.4
Operating System: Windows 10 pro


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 58 guests