Seite 1 von 1

MYSQL Problem

Verfasst: Fr 23. Sep 2022, 09:23
von Michael
Hallo leider komme ich mit dem Forum nicht zurecht, bin absolut kein it Fachmann.
Mochte das System installieren und hänge an dem punkt das "mysql " nicht starten will.
habe alle beschriebenen Einstellungen vorgenommen.
Hier die Logfiles:

2022-09-22 19:09:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:09:54 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:09:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:09:54 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:09:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:09:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-22 19:09:54 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:09:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2022-09-22 19:09:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:09:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-22 19:09:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:09:55 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:09:55 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:09:55 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:09:55 0 [Note] InnoDB: 10.4.24 started; log sequence number 300297; transaction id 170
2022-09-22 19:09:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:09:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:09:55 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 19:09:55
2022-09-22 19:09:55 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:09:55 0 [Note] Reading of all Master_info entries succeeded
2022-09-22 19:09:55 0 [Note] Added new Master_info '' to hash table
2022-09-22 19:09:55 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.24-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2022-09-22 19:13:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:13:01 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:13:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:13:01 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:13:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:13:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-22 19:13:01 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:13:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2022-09-22 19:13:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:13:01 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-22 19:13:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:13:01 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:13:01 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:13:01 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:13:01 0 [Note] InnoDB: 10.4.24 started; log sequence number 300315; transaction id 170
2022-09-22 19:13:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:13:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:13:01 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:13:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:13:20 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:13:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:13:20 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:13:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:13:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-22 19:13:20 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:13:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:13:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:13:20 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:13:20 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:13:20 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:13:20 0 [Note] InnoDB: 10.4.24 started; log sequence number 300324; transaction id 170
2022-09-22 19:13:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:13:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:13:20 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:14:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:14:19 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:14:19 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:14:19 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:14:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:14:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-09-22 19:14:19 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:14:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:14:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:14:19 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:14:19 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:14:19 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:14:19 0 [Note] InnoDB: 10.4.24 started; log sequence number 300333; transaction id 170
2022-09-22 19:14:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:14:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:14:19 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:54:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:54:35 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:54:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:54:35 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:54:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:54:35 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 19:54:35 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:54:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:54:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:54:35 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:54:35 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:54:35 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:54:35 0 [Note] InnoDB: 10.4.24 started; log sequence number 300342; transaction id 170
2022-09-22 19:54:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:54:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:54:35 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:54:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:54:47 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:54:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:54:47 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:54:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:54:47 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 19:54:47 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:54:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:54:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:54:48 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:54:48 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:54:48 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:54:48 0 [Note] InnoDB: 10.4.24 started; log sequence number 300351; transaction id 170
2022-09-22 19:54:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:54:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:54:48 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:57:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 19:57:11 0 [Note] InnoDB: Uses event mutexes
2022-09-22 19:57:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 19:57:11 0 [Note] InnoDB: Number of pools: 1
2022-09-22 19:57:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 19:57:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 19:57:11 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 19:57:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 19:57:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 19:57:11 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 19:57:11 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 19:57:11 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 19:57:11 0 [Note] InnoDB: 10.4.24 started; log sequence number 300360; transaction id 170
2022-09-22 19:57:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 19:57:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 19:57:11 0 [Note] Server socket created on IP: '::'.
2022-09-22 19:57:11 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 19:57:11 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 19:57:11 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 19:57:11
2022-09-22 19:57:11 0 [ERROR] Aborting
2022-09-22 20:16:49 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:16:49 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:16:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:16:49 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:16:49 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:16:49 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:16:49 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:16:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:16:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:16:50 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:16:50 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:16:50 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 20:16:50 0 [Note] InnoDB: 10.4.24 started; log sequence number 300369; transaction id 170
2022-09-22 20:16:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:16:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:16:50 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:16:50 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:16:50 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:16:50 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 20:16:50
2022-09-22 20:16:50 0 [ERROR] Aborting
2022-09-22 20:22:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:22:23 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:22:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:22:23 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:22:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:22:23 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:22:23 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:22:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:22:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:22:23 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:22:23 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:22:23 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 20:22:23 0 [Note] InnoDB: 10.4.24 started; log sequence number 300378; transaction id 170
2022-09-22 20:22:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:22:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:22:23 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:22:23 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:22:23 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:22:23 0 [ERROR] Aborting
2022-09-22 20:26:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:26:38 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:26:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:26:38 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:26:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:26:38 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:26:38 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:26:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:26:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:26:38 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:26:38 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:26:38 0 [Note] InnoDB: 10.4.24 started; log sequence number 300387; transaction id 170
2022-09-22 20:26:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:26:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:26:38 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:26:38 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:26:38 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:26:38 0 [ERROR] Aborting
2022-09-22 20:28:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:28:02 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:28:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:28:02 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:28:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:28:02 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:28:02 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:28:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:28:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:28:02 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:28:02 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:28:02 0 [Note] InnoDB: 10.4.24 started; log sequence number 300396; transaction id 170
2022-09-22 20:28:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:28:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:28:02 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:28:02 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:28:02 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:28:02 0 [ERROR] Aborting
2022-09-22 20:28:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:28:34 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:28:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:28:34 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:28:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:28:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:28:34 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:28:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:28:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:28:34 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:28:34 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:28:34 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 20:28:34 0 [Note] InnoDB: 10.4.24 started; log sequence number 300405; transaction id 170
2022-09-22 20:28:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:28:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:28:34 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:28:34 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:28:34 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:28:34 0 [ERROR] Aborting
2022-09-22 20:31:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-22 20:31:25 0 [Note] InnoDB: Uses event mutexes
2022-09-22 20:31:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-22 20:31:25 0 [Note] InnoDB: Number of pools: 1
2022-09-22 20:31:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-22 20:31:25 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-22 20:31:25 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-22 20:31:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-22 20:31:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-22 20:31:25 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-22 20:31:25 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-22 20:31:25 0 [Note] InnoDB: Waiting for purge to start
2022-09-22 20:31:25 0 [Note] InnoDB: 10.4.24 started; log sequence number 300414; transaction id 170
2022-09-22 20:31:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-22 20:31:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-22 20:31:25 0 [Note] Server socket created on IP: '::'.
2022-09-22 20:31:25 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:31:25 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-22 20:31:25 0 [Note] InnoDB: Buffer pool(s) load completed at 220922 20:31:25
2022-09-22 20:31:25 0 [ERROR] Aborting
2022-09-23 8:44:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 8:44:58 0 [Note] InnoDB: Uses event mutexes
2022-09-23 8:44:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 8:44:58 0 [Note] InnoDB: Number of pools: 1
2022-09-23 8:44:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 8:44:58 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-23 8:44:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 8:44:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 8:44:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 8:44:58 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 8:44:58 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 8:44:58 0 [Note] InnoDB: Waiting for purge to start
2022-09-23 8:44:58 0 [Note] InnoDB: 10.4.24 started; log sequence number 300423; transaction id 170
2022-09-23 8:44:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 8:44:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 8:44:58 0 [Note] InnoDB: Buffer pool(s) load completed at 220923 8:44:58
2022-09-23 8:44:58 0 [Note] Server socket created on IP: '::'.
2022-09-23 8:44:58 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 8:44:58 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 8:44:58 0 [ERROR] Aborting
2022-09-23 8:46:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 8:46:28 0 [Note] InnoDB: Uses event mutexes
2022-09-23 8:46:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 8:46:28 0 [Note] InnoDB: Number of pools: 1
2022-09-23 8:46:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 8:46:28 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-23 8:46:28 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 8:46:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 8:46:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 8:46:28 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 8:46:28 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 8:46:28 0 [Note] InnoDB: Waiting for purge to start
2022-09-23 8:46:28 0 [Note] InnoDB: 10.4.24 started; log sequence number 300432; transaction id 170
2022-09-23 8:46:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 8:46:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 8:46:28 0 [Note] InnoDB: Buffer pool(s) load completed at 220923 8:46:28
2022-09-23 8:46:29 0 [Note] Server socket created on IP: '::'.
2022-09-23 8:46:29 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 8:46:29 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 8:46:29 0 [ERROR] Aborting
2022-09-23 9:00:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:00:11 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:00:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:00:11 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:00:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:00:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-23 9:00:11 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:00:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:00:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:00:12 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:00:12 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:00:12 0 [Note] InnoDB: Waiting for purge to start
2022-09-23 9:00:12 0 [Note] InnoDB: 10.4.24 started; log sequence number 300441; transaction id 170
2022-09-23 9:00:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:00:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:00:12 0 [Note] InnoDB: Buffer pool(s) load completed at 220923 9:00:12
2022-09-23 9:00:12 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:00:12 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:00:12 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:00:12 0 [ERROR] Aborting
2022-09-23 9:02:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:02:45 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:02:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:02:45 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:02:45 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:02:45 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-23 9:02:45 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:02:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:02:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:02:45 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:02:45 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:02:45 0 [Note] InnoDB: Waiting for purge to start
2022-09-23 9:02:46 0 [Note] InnoDB: 10.4.24 started; log sequence number 300450; transaction id 170
2022-09-23 9:02:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:02:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:02:46 0 [Note] InnoDB: Buffer pool(s) load completed at 220923 9:02:46
2022-09-23 9:02:46 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:02:46 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:02:46 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:02:46 0 [ERROR] Aborting
2022-09-23 9:06:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:06:58 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:06:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:06:58 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:06:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:06:58 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-23 9:06:58 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:06:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:06:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:06:58 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:06:58 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:06:58 0 [Note] InnoDB: 10.4.24 started; log sequence number 300459; transaction id 170
2022-09-23 9:06:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:06:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:06:58 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:06:58 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:06:58 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:06:58 0 [ERROR] Aborting
2022-09-23 9:08:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:08:33 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:08:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:08:33 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:08:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:08:33 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-09-23 9:08:33 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:08:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:08:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:08:33 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:08:33 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:08:33 0 [Note] InnoDB: 10.4.24 started; log sequence number 300468; transaction id 170
2022-09-23 9:08:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:08:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:08:33 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:08:33 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:08:33 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:08:33 0 [ERROR] Aborting
2022-09-23 9:10:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:10:43 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:10:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:10:43 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:10:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:10:43 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-09-23 9:10:43 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:10:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:10:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:10:43 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:10:43 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:10:43 0 [Note] InnoDB: Waiting for purge to start
2022-09-23 9:10:43 0 [Note] InnoDB: 10.4.24 started; log sequence number 300477; transaction id 170
2022-09-23 9:10:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:10:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:10:43 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:10:43 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:10:43 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:10:43 0 [ERROR] Aborting
2022-09-23 9:11:14 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-09-23 9:11:14 0 [Note] InnoDB: Uses event mutexes
2022-09-23 9:11:14 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-09-23 9:11:14 0 [Note] InnoDB: Number of pools: 1
2022-09-23 9:11:14 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-09-23 9:11:14 0 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
2022-09-23 9:11:14 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-23 9:11:14 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-09-23 9:11:14 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-23 9:11:14 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-23 9:11:14 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-09-23 9:11:14 0 [Note] InnoDB: 10.4.24 started; log sequence number 300486; transaction id 170
2022-09-23 9:11:14 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2022-09-23 9:11:14 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-09-23 9:11:14 0 [Note] Server socket created on IP: '::'.
2022-09-23 9:11:14 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:11:14 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-09-23 9:11:14 0 [ERROR] Aborting

Re: MYSQL Problem

Verfasst: Sa 24. Sep 2022, 17:08
von maxmichels
Hallo Michael,

ich versuche mal die zu helfen. Wie genau betreibst du denn MariaDB? Hast du Windows oder Linux im Einsatz? Es sieht mir nach Windows aus. Zudem scheint der Dienst immer wieder abzustürzen und am Ende scheint die Master-DB korrupt zu sein, sodass keine Verbindungen mehr möglich sind. Nach welcher Anleitung hast du MariaDB installiert?


Max

Re: MYSQL Problem

Verfasst: Sa 24. Sep 2022, 19:05
von pichel
Hallo Max,

vielen Dank, dass du helfen möchtest. In der Zwischenzeit hatte ich eine Teamviewer-Session mit Michael.

Die Situation war die, dass xampp irgendwie nicht richtig installiert war, sich aber auch nicht mehr so einfach deinstallieren ließ. Keine Ahnung, wie die Situation zustande gekommen war. Jedenfalls habe ich alle Dienste manuell deinstalliert und xampp von vorne neu installiert. Und jetzt geht alles.

Gruß,

Stefan