Apache Friends Support Forum

by **Mimo25** » 30. August 2021 12:30

Hey Com,

ich habe das Problem, dass wenn ich mit XAMPP MySQL starte es direkt wieder gestoppt wird. Der Port ist eigentlich frei, daran sollte es nicht liegen.

LOG:

Code: Select all: 2021-07-25 19:46:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-25 19:46:52 0 [Note] InnoDB: Uses event mutexes 2021-07-25 19:46:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-25 19:46:52 0 [Note] InnoDB: Number of pools: 1 2021-07-25 19:46:52 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-25 19:46:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-25 19:46:52 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-25 19:46:53 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288 2021-07-25 19:46:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-25 19:46:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-25 19:46:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-25 19:46:53 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-25 19:46:54 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-25 19:46:54 0 [Note] InnoDB: Waiting for purge to start 2021-07-25 19:46:54 0 [Note] InnoDB: 10.4.20 started; log sequence number 300297; transaction id 170 2021-07-25 19:46:54 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-25 19:46:54 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-25 19:46:54 0 [Note] InnoDB: Buffer pool(s) load completed at 210725 19:46:54 2021-07-25 19:46:54 0 [Note] Server socket created on IP: '::'. 2021-07-25 19:46:54 0x4174 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6169 InnoDB: Failing assertion: slot InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 2021-07-25 19:46:54 0x41ac InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6169 InnoDB: Failing assertion: slot InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to https://jira.mariadb.org/ InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/ InnoDB: about forcing recovery. 2021-07-25 19:46:54 0x1328 InnoDB: Assertion2021-07-25 19:48:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-25 19:48:50 0 [Note] InnoDB: Uses event mutexes 2021-07-25 19:48:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-25 19:48:50 0 [Note] InnoDB: Number of pools: 1 2021-07-25 19:48:50 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-25 19:48:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-25 19:48:50 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-25 19:48:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288 2021-07-25 19:48:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-25 19:48:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-25 19:48:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-25 19:48:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-25 19:48:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-25 19:48:50 0 [Note] InnoDB: Waiting for purge to start 2021-07-25 19:48:50 0 [Note] InnoDB: 10.4.20 started; log sequence number 300297; transaction id 170 2021-07-25 19:48:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-25 19:48:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-25 19:48:50 0 [Note] Server socket created on IP: '::'. 2021-07-26 12:39:22 0 [Note] mysqld.exe: Aria engine: starting recovery recovered pages: 0% 11% 45% 66% 87% 100% (0.2 seconds); tables to flush: 2 1 0 (0.2 seconds); 2021-07-26 12:39:22 0 [Note] mysqld.exe: Aria engine: recovery done 2021-07-26 12:39:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-26 12:39:22 0 [Note] InnoDB: Uses event mutexes 2021-07-26 12:39:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-26 12:39:22 0 [Note] InnoDB: Number of pools: 1 2021-07-26 12:39:22 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-26 12:39:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-26 12:39:22 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-26 12:39:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361648 2021-07-26 12:39:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-26 12:39:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-26 12:39:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-26 12:39:25 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-26 12:39:25 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-26 12:39:25 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:39:25 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:39:25 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:39:25 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:39:25 0 [Note] InnoDB: 10.4.20 started; log sequence number 361657; transaction id 414 2021-07-26 12:39:25 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-26 12:39:25 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-26 12:39:25 0 [Note] InnoDB: Buffer pool(s) load completed at 210726 12:39:25 2021-07-26 12:39:26 0 [Note] Server socket created on IP: '::'. 2021-07-26 12:45:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-26 12:45:50 0 [Note] InnoDB: Uses event mutexes 2021-07-26 12:45:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-26 12:45:50 0 [Note] InnoDB: Number of pools: 1 2021-07-26 12:45:50 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-26 12:45:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-26 12:45:50 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-26 12:45:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361666 2021-07-26 12:45:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-26 12:45:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-26 12:45:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-26 12:45:50 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-26 12:45:50 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-26 12:45:50 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:45:50 0 [Note] InnoDB: 10.4.20 started; log sequence number 361675; transaction id 414 2021-07-26 12:45:50 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-26 12:45:50 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-26 12:45:50 0 [Note] Server socket created on IP: '::'. 2021-07-26 12:46:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-26 12:46:09 0 [Note] InnoDB: Uses event mutexes 2021-07-26 12:46:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-26 12:46:09 0 [Note] InnoDB: Number of pools: 1 2021-07-26 12:46:09 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-26 12:46:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-26 12:46:09 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-26 12:46:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361684 2021-07-26 12:46:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-26 12:46:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-26 12:46:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-26 12:46:09 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-26 12:46:10 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-26 12:46:10 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:46:10 0 [Note] InnoDB: 10.4.20 started; log sequence number 361693; transaction id 414 2021-07-26 12:46:10 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-26 12:46:10 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-26 12:46:10 0 [Note] Server socket created on IP: '::'. 2021-07-26 12:48:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-26 12:48:02 0 [Note] InnoDB: Uses event mutexes 2021-07-26 12:48:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-26 12:48:02 0 [Note] InnoDB: Number of pools: 1 2021-07-26 12:48:02 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-26 12:48:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-26 12:48:02 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-26 12:48:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361702 2021-07-26 12:48:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-26 12:48:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-26 12:48:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-26 12:48:02 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-26 12:48:02 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-26 12:48:02 0 [Note] InnoDB: Waiting for purge to start 2021-07-26 12:48:03 0 [Note] InnoDB: 10.4.20 started; log sequence number 361711; transaction id 414 2021-07-26 12:48:03 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-26 12:48:03 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-26 12:48:03 0 [Note] Server socket created on IP: '::'. 2021-07-26 12:48:03 0 [Note] InnoDB: Buffer pool(s) load completed at 210726 12:48:03 2021-07-26 12:48:03 0 [Note] Reading of all Master_info entries succeeded 2021-07-26 12:48:03 0 [Note] Added new Master_info '' to hash table 2021-07-26 12:48:03 0 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.4.20-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2021-07-26 13:59:40 8 [Warning] Host name 'zg-0706b-372.stretchoid.com' could not be resolved: Der angegebene Host ist unbekannt. 2021-07-26 13:59:40 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '192.241.223.158' (Got an error reading communication packets) 2021-07-26 13:59:40 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '192.241.223.158' (This connection closed normally without authentication) 2021-07-27 17:52:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-27 17:52:54 0 [Note] InnoDB: Uses event mutexes 2021-07-27 17:52:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-27 17:52:54 0 [Note] InnoDB: Number of pools: 1 2021-07-27 17:52:54 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-27 17:52:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-27 17:52:54 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-27 22:20:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-27 22:20:41 0 [Note] InnoDB: Uses event mutexes 2021-07-27 22:20:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-27 22:20:41 0 [Note] InnoDB: Number of pools: 1 2021-07-27 22:20:41 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-27 22:20:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-27 22:20:41 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-27 22:20:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=361720 2021-07-27 22:20:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-27 22:20:43 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-27 22:20:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-27 22:20:43 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-27 22:20:43 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-27 22:20:43 0 [Note] InnoDB: Waiting for purge to start 2021-07-27 22:20:43 0 [Note] InnoDB: 10.4.20 started; log sequence number 361729; transaction id 414 2021-07-27 22:20:43 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-27 22:20:43 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-27 22:20:43 0 [Note] InnoDB: Buffer pool(s) load completed at 210727 22:20:43 2021-07-27 22:20:43 0 [Note] Server socket created on IP: '::'. 2021-07-28 11:33:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-28 11:33:23 0 [Note] InnoDB: Uses event mutexes 2021-07-28 11:33:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-28 11:33:23 0 [Note] InnoDB: Number of pools: 1 2021-07-28 11:33:23 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-28 11:33:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-28 11:33:24 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-28 11:33:24 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=429887 2021-07-28 11:33:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-28 11:33:26 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-28 11:33:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-28 11:33:26 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-28 11:33:26 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-28 11:33:26 0 [Note] InnoDB: Waiting for purge to start 2021-07-28 11:33:26 0 [Note] InnoDB: Waiting for purge to start 2021-07-28 11:33:26 0 [Note] InnoDB: Waiting for purge to start 2021-07-28 11:33:26 0 [Note] InnoDB: Waiting for purge to start 2021-07-28 11:33:27 0 [Note] InnoDB: 10.4.20 started; log sequence number 429896; transaction id 713 2021-07-28 11:33:27 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-28 11:33:27 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-28 11:33:27 0 [Note] InnoDB: Buffer pool(s) load completed at 210728 11:33:27 2021-07-28 11:33:28 0 [Note] Server socket created on IP: '::'. 2021-07-28 12:26:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-07-28 12:26:44 0 [Note] InnoDB: Uses event mutexes 2021-07-28 12:26:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-07-28 12:26:44 0 [Note] InnoDB: Number of pools: 1 2021-07-28 12:26:44 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-07-28 12:26:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-07-28 12:26:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-07-28 12:26:45 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=429905 2021-07-28 12:26:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-07-28 12:26:45 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-07-28 12:26:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-07-28 12:26:45 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-07-28 12:26:45 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-07-28 12:26:45 0 [Note] InnoDB: Waiting for purge to start 2021-07-28 12:26:45 0 [Note] InnoDB: 10.4.20 started; log sequence number 429914; transaction id 713 2021-07-28 12:26:45 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-07-28 12:26:45 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-07-28 12:26:45 0 [Note] Server socket created on IP: '::'. 2021-08-27 17:26:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-27 17:26:00 0 [Note] InnoDB: Uses event mutexes 2021-08-27 17:26:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-27 17:26:00 0 [Note] InnoDB: Number of pools: 1 2021-08-27 17:26:00 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-27 17:26:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-27 17:26:00 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-27 17:26:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=440343 2021-08-27 17:26:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-27 17:26:06 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-08-27 17:26:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-27 17:26:06 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-27 17:26:06 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-27 17:26:06 0 [Note] InnoDB: Waiting for purge to start 2021-08-27 17:26:06 0 [Note] InnoDB: Waiting for purge to start 2021-08-27 17:26:06 0 [Note] InnoDB: Waiting for purge to start 2021-08-27 17:26:06 0 [Note] InnoDB: 10.4.20 started; log sequence number 440352; transaction id 811 2021-08-27 17:26:06 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-27 17:26:06 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-27 17:26:06 0 [Note] InnoDB: Buffer pool(s) load completed at 210827 17:26:06 2021-08-27 17:26:07 0 [Note] Server socket created on IP: '::'. 2021-08-29 19:59:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-29 19:59:07 0 [Note] InnoDB: Uses event mutexes 2021-08-29 19:59:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-29 19:59:07 0 [Note] InnoDB: Number of pools: 1 2021-08-29 19:59:07 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-29 19:59:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-29 19:59:07 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-29 19:59:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=441095 2021-08-29 19:59:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-29 19:59:36 0 [Note] InnoDB: Uses event mutexes 2021-08-29 19:59:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-29 19:59:36 0 [Note] InnoDB: Number of pools: 1 2021-08-29 19:59:36 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-29 19:59:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-29 19:59:36 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-29 19:59:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=441095 2021-08-29 19:59:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-29 19:59:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-08-29 19:59:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-29 19:59:37 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-29 19:59:37 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-29 19:59:37 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 19:59:38 0 [Note] InnoDB: 10.4.20 started; log sequence number 441104; transaction id 836 2021-08-29 19:59:38 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-29 19:59:39 0 [Note] InnoDB: Buffer pool(s) load completed at 210829 19:59:39 2021-08-29 19:59:39 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-29 19:59:40 0 [Note] Server socket created on IP: '::'. 2021-08-29 19:59:40 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and should be repaired 2021-08-29 19:59:40 0 [Warning] Checking table: '.\mysql\db' 2021-08-29 19:59:40 0 [Warning] mysql.db: 1 client is using or hasn't closed the table properly 2021-08-29 19:59:40 0 [Warning] mysql.db: Size of datafile is: 32768 Expected: 16384 2021-08-29 19:59:40 0 [Note] mysql.db: Table is fixed 2021-08-29 19:59:41 0 [ERROR] mysqld.exe: Table '.\mysql\global_priv' is marked as crashed and should be repaired 2021-08-29 19:59:41 0 [Warning] Checking table: '.\mysql\global_priv' 2021-08-29 19:59:41 0 [Warning] mysql.global_priv: 1 client is using or hasn't closed the table properly 2021-08-29 19:59:41 0 [Note] mysql.global_priv: Table is fixed 2021-08-29 19:59:42 0 [Note] Reading of all Master_info entries succeeded 2021-08-29 19:59:42 0 [Note] Added new Master_info '' to hash table 2021-08-29 19:59:42 0 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '10.4.20-MariaDB' socket: '' port: 3306 mariadb.org binary distribution 2021-08-29 22:07:30 77 [Warning] Access denied for user 'FFM'@'localhost' (using password: YES) 2021-08-29 22:09:21 124 [Warning] Access denied for user 'FFM'@'%' to database 'ffm' 2021-08-29 22:52:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-29 22:52:13 0 [Note] InnoDB: Uses event mutexes 2021-08-29 22:52:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-29 22:52:13 0 [Note] InnoDB: Number of pools: 1 2021-08-29 22:52:13 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-29 22:52:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-29 22:52:13 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-29 22:52:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=447397 2021-08-29 22:52:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-29 22:52:15 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-08-29 22:52:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-29 22:52:15 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-29 22:52:15 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-29 22:52:15 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 22:52:15 0 [Note] InnoDB: Waiting for purge to start 2021-08-29 22:52:15 0 [Note] InnoDB: 10.4.20 started; log sequence number 447406; transaction id 868 2021-08-29 22:52:15 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-29 22:52:15 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-29 22:52:15 0 [Note] InnoDB: Buffer pool(s) load completed at 210829 22:52:15 2021-08-29 22:52:15 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:32:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:32:10 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:32:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:32:10 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:32:10 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:32:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:32:10 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:32:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:32:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:32:11 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:32:11 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:32:11 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:32:11 0 [Note] InnoDB: 10.4.20 started; log sequence number 447424; transaction id 868 2021-08-30 12:32:11 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:32:11 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:32:11 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:33:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:33:02 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:33:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:33:02 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:33:02 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:33:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:33:02 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:33:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:33:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:33:02 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:33:02 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:33:02 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:33:02 0 [Note] InnoDB: 10.4.20 started; log sequence number 447433; transaction id 868 2021-08-30 12:33:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:33:02 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:33:03 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:34:18 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:34:18 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:34:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:34:18 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:34:18 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:34:18 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:34:18 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:34:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:34:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:34:18 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:34:18 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:34:18 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:34:19 0 [Note] InnoDB: 10.4.20 started; log sequence number 447442; transaction id 868 2021-08-30 12:34:19 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:34:19 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:34:19 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:34:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:34:24 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:34:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:34:24 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:34:24 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:34:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:34:24 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:34:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:34:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-08-30 12:34:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:34:25 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:34:25 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:34:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:34:25 0 [Note] InnoDB: 10.4.20 started; log sequence number 447442; transaction id 868 2021-08-30 12:34:25 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:34:25 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:34:25 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:34:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:34:40 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:34:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:34:40 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:34:40 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:34:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:34:40 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:34:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:34:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:34:40 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:34:40 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:34:40 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:34:40 0 [Note] InnoDB: 10.4.20 started; log sequence number 447451; transaction id 868 2021-08-30 12:34:40 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:34:40 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:34:40 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:35:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:35:44 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:35:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:35:44 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:35:44 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:35:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:35:44 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:35:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:35:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:35:44 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:35:44 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:35:44 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:35:44 0 [Note] InnoDB: 10.4.20 started; log sequence number 447460; transaction id 868 2021-08-30 12:35:44 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:35:44 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:35:44 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:36:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:36:05 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:36:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:36:05 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:36:05 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:36:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:36:05 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:36:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:36:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:36:05 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:36:05 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:36:05 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:36:05 0 [Note] InnoDB: 10.4.20 started; log sequence number 447469; transaction id 868 2021-08-30 12:36:05 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:36:05 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:36:05 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:36:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:36:56 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:36:56 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:36:56 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:36:56 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:36:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:36:56 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:36:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:36:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:36:56 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:36:56 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:36:56 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:36:56 0 [Note] InnoDB: 10.4.20 started; log sequence number 447478; transaction id 868 2021-08-30 12:36:56 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:36:56 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:36:56 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:38:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:38:43 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:38:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:38:43 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:38:43 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:38:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:38:43 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:38:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:38:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:38:44 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:38:44 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:38:44 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:38:44 0 [Note] InnoDB: 10.4.20 started; log sequence number 447503; transaction id 868 2021-08-30 12:38:44 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:38:44 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:38:44 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:42:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:42:17 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:42:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:42:17 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:42:17 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:42:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:42:17 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:42:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:42:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:42:25 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:42:25 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:42:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:25 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:42:26 0 [Note] InnoDB: 10.4.20 started; log sequence number 447512; transaction id 868 2021-08-30 12:42:27 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:42:28 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:42:28 0 [Note] InnoDB: Buffer pool(s) load completed at 210830 12:42:28 2021-08-30 12:42:29 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:52:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:52:50 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:52:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:52:50 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:52:50 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:52:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:52:50 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:52:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:52:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:52:51 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:52:51 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:52:51 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:52:51 0 [Note] InnoDB: 10.4.20 started; log sequence number 447521; transaction id 868 2021-08-30 12:52:51 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:52:51 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:52:51 0 [Note] Server socket created on IP: '::'. 2021-08-30 12:55:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 12:55:08 0 [Note] InnoDB: Uses event mutexes 2021-08-30 12:55:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 12:55:08 0 [Note] InnoDB: Number of pools: 1 2021-08-30 12:55:08 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 12:55:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 12:55:08 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 12:55:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 12:55:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 12:55:09 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 12:55:09 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 12:55:09 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 12:55:09 0 [Note] InnoDB: 10.4.20 started; log sequence number 447530; transaction id 868 2021-08-30 12:55:09 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 12:55:09 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 12:55:09 0 [Note] Server socket created on IP: '::'.

by **Altrea** » 30. August 2021 13:15

Hi,

Diese logs enthalten leider keinen Hinweis auf die Fehlerursache.

versuche MariaDB bitte mal als Konsolenanwendung zu starten

Öffne hierzu die XAMPP Shell (Shell Schaltfläche im XAMPP control panel) und führe folgendes Command aus

Code: Select all: mysqld --defaults-file=mysql\bin\my.ini --standalone --console

by **Mimo25** » 30. August 2021 18:33

Altrea wrote:Hi,

Diese logs enthalten leider keinen Hinweis auf die Fehlerursache.

versuche MariaDB bitte mal als Konsolenanwendung zu starten

Öffne hierzu die XAMPP Shell (Shell Schaltfläche im XAMPP control panel) und führe folgendes Command aus

Code: Select all
mysqld --defaults-file=mysql\bin\my.ini --standalone --console

Hat leider auch nicht funktioniert:

Console:

Code: Select all: # mysqld --defaults-file=mysql\bin\my.ini --standalone --console 2021-08-30 19:32:19 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead. 2021-08-30 19:32:19 0 [Note] mysqld (mysqld 10.4.20-MariaDB) starting as process 9164 ... 2021-08-30 19:32:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-08-30 19:32:19 0 [Note] InnoDB: Uses event mutexes 2021-08-30 19:32:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-08-30 19:32:19 0 [Note] InnoDB: Number of pools: 1 2021-08-30 19:32:19 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-08-30 19:32:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-08-30 19:32:19 0 [Note] InnoDB: Completed initialization of buffer pool 2021-08-30 19:32:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-08-30 19:32:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-08-30 19:32:20 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-08-30 19:32:20 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-08-30 19:32:20 0 [Note] InnoDB: Waiting for purge to start 2021-08-30 19:32:20 0 [Note] InnoDB: 10.4.20 started; log sequence number 447539; transaction id 868 2021-08-30 19:32:20 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool 2021-08-30 19:32:20 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-08-30 19:32:20 0 [Note] Server socket created on IP: '::'. 2021-08-30 19:32:20 0 [ERROR] mysqld: Index for table '.\mysql\global_priv' is corrupt; try to repair it 2021-08-30 19:32:20 0 [ERROR] Couldn't repair table: mysql.global_priv 2021-08-30 19:32:20 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'global_priv' is corrupt; try to repair it 2021-08-30 19:32:20 0 [ERROR] Aborting 2021-08-30 19:32:20 0 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace mysql/transaction_registry page [page id: space=3, page number=0]. You may have to recover from a backup. len 16384; hex ecefa36b00000000000000000000000000000000000203bc000800000000000000000000000300000003000000000000000900000040000000210000000700000000ffffffff0000ffffffff00000000000100000000009e00000000009e00000000ffffffff0000ffffffff0000000000000000000900000000ffffffff0000ffffffff0000000000010000000200260000000200260000000000000000ffffffff0000ffffffff000000000002aaeaffffffffffffffffffffffffffff000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000192000000000006d433000000000004b83300000000008000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006d4330000000035c1bbf200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ecefa36b000203bc; asc k @ ! & & 3 3 3 5 k ; InnoDB: End of page dump InnoDB: Page may be a file space header page 2021-08-30 19:32:21 0 [ERROR] InnoDB: Background Page read failed to read or decrypt [page id: space=3, page number=0]

by **Nobbie** » 30. August 2021 19:20

Mimo25 wrote:Hat leider auch nicht funktioniert:

Das wäre auch ein Wunder und war auch nicht die Erwartung. Aber hier steht zumindest eine klare Fehlermeldung drin:

Code: Select all: 2021-08-30 19:32:20 0 [ERROR] mysqld: Index for table '.\mysql\global_priv' is corrupt; try to repair it 2021-08-30 19:32:20 0 [ERROR] Couldn't repair table: mysql.global_priv 2021-08-30 19:32:20 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'global_priv' is corrupt; try to repair it 2021-08-30 19:32:20 0 [ERROR] Aborting 2021-08-30 19:32:20 0 [ERROR] InnoDB: Database page corruption on disk or a failed file read of tablespace mysql/transaction_registry page [page id: space=3, page number=0]. You may have to recover from a backup. len 16384; hex

Die Tabelle mit den "privilege" der Anwender ist zerstört. Typischerweise läßt sich die auch nicht mehr herstellen, Altrea kennt sich da aber besser aus als ich, vielleicht hat er einen funktionierenden Rat, der die Tabelle rettet. Aber im Zweifel hilft nur ein Restore eines funktionierenden Stands (wenn Du Backups haben solltest) oder die Neuinstallation. Unter Windows kommt es extrem häufig vor, dass die Benutzerdatenbanken kaputt sind, typischerweise ist das ein Resultat von unsauberem Herunterfahren. Also bitte nicht einfach den PC ausschalten oder einfach Xampp beenden. Unbedingt im Xampp Dialog die MySQL Datenbank gezielt herunterfahren. Alles andere kann zur Zerstörung der Daten führen.

by **Altrea** » 30. August 2021 19:32

Deine mysql Datenbank muss repariert werden. Das kannst du folgendermaßen tun:

Klicke den Shell Button im XAMPP control Panel um die XAMPP Shell zu öffnen
tippe folgenden Befehl ein, um MariaDB ohne Benutzertabellen zu starten

Code: Select all: mysqld --console --skip-grant-tables --skip-external-locking

Lasse dieses Fenster geöffnet (wichtig!) und öffne eine weitere XAMPP Shell über den Shell Button
Tippe hier folgenden Befehl ein

Code: Select all: mysqlcheck -r --databases mysql --use-frm

Danach kannst du beide XAMPP Shell Fenster wieder schließen und versuchen MariaDB über den normalen Weg zu starten.

Bei Wiederherstellungen von korrupten Berechtigungstabellen (wie in deinem Fall) kann es passieren, dass globale Berechtigungen von Benutzern verlorengehen. Solltest du anschließend also Probleme mit Zugriffen haben, muss man sich die Berechtigungen im Einzelfall nochmal ansehen.

Apache Friends Support Forum

MYSQL stoppt nach start

MYSQL stoppt nach start

Re: MYSQL stoppt nach start

Re: MYSQL stoppt nach start

Re: MYSQL stoppt nach start

Re: MYSQL stoppt nach start

Who is online