MySQL startet und wird wieder sofort beendet

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL startet und wird wieder sofort beendet

Postby tennstar » 21. April 2020 16:37

Hallo,
Xampp lief seit Monaten und auch noch heute Vormittag einwandfrei!
Jetzt startet MySQL und wird sofort wieder beendet! Eine Neuinstallation war zunächst erfolgreich, aber als ich die Sicherungen htdogs und data wieder zurück kopiert habe war es plötzlich wieder aus und der gleiche Fehler wieder.
MySQL startet und wird beendet!
Hier mal die Log Datei:
InnoDB: using atomic writes.
2020-04-20 20:22:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-20 20:22:30 0 [Note] InnoDB: Uses event mutexes
2020-04-20 20:22:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-20 20:22:30 0 [Note] InnoDB: Number of pools: 1
2020-04-20 20:22:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-20 20:22:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-20 20:22:30 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-20 20:22:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=53288752
2020-04-20 20:22:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-20 20:22:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-20 20:22:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-20 20:22:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-20 20:22:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-20 20:22:31 0 [Note] InnoDB: Waiting for purge to start
2020-04-20 20:22:31 0 [Note] InnoDB: 10.4.11 started; log sequence number 53288761; transaction id 20647
2020-04-20 20:22:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-20 20:22:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-20 20:22:31 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 9:43:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 9:43:11 0 [Note] InnoDB: Uses event mutexes
2020-04-21 9:43:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 9:43:11 0 [Note] InnoDB: Number of pools: 1
2020-04-21 9:43:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 9:43:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 9:43:11 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 9:43:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=62558400
2020-04-21 9:43:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 9:43:11 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-21 9:43:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 9:43:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 9:43:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 9:43:11 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 9:43:12 0 [Note] InnoDB: 10.4.11 started; log sequence number 62558409; transaction id 22643
2020-04-21 9:43:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 9:43:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 9:43:12 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 11:19:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 11:19:31 0 [Note] InnoDB: Uses event mutexes
2020-04-21 11:19:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 11:19:31 0 [Note] InnoDB: Number of pools: 1
2020-04-21 11:19:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 11:19:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 11:19:31 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 11:19:31 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=62951647
2020-04-21 11:19:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 11:19:31 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-21 11:19:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 11:19:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 11:19:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 11:19:31 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 11:19:32 0 [Note] InnoDB: 10.4.11 started; log sequence number 62951656; transaction id 22909
2020-04-21 11:19:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 11:19:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 11:19:32 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 16:38:42 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 16:38:42 0 [Note] InnoDB: Uses event mutexes
2020-04-21 16:38:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 16:38:42 0 [Note] InnoDB: Number of pools: 1
2020-04-21 16:38:42 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 16:38:42 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 16:38:42 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 16:38:42 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=71249824
2020-04-21 16:38:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 16:38:42 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-04-21 16:38:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 16:38:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 16:38:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 16:38:42 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 16:38:42 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249833; transaction id 24779
2020-04-21 16:38:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 16:38:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 16:38:42 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 16:39:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 16:39:11 0 [Note] InnoDB: Uses event mutexes
2020-04-21 16:39:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 16:39:11 0 [Note] InnoDB: Number of pools: 1
2020-04-21 16:39:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 16:39:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 16:39:11 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 16:39:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 16:39:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 16:39:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 16:39:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 16:39:11 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 16:39:11 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249842; transaction id 24779
2020-04-21 16:39:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 16:39:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 16:39:11 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 16:39:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 16:39:33 0 [Note] InnoDB: Uses event mutexes
2020-04-21 16:39:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 16:39:33 0 [Note] InnoDB: Number of pools: 1
2020-04-21 16:39:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 16:39:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 16:39:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 16:39:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 16:39:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 16:39:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 16:39:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 16:39:33 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 16:39:33 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249851; transaction id 24779
2020-04-21 16:39:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 16:39:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 16:39:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 16:41:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 16:41:15 0 [Note] InnoDB: Uses event mutexes
2020-04-21 16:41:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 16:41:15 0 [Note] InnoDB: Number of pools: 1
2020-04-21 16:41:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 16:41:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 16:41:15 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 16:41:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 16:41:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 16:41:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 16:41:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 16:41:15 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 16:41:15 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249860; transaction id 24779
2020-04-21 16:41:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 16:41:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 16:41:15 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 16:44:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 16:44:58 0 [Note] InnoDB: Uses event mutexes
2020-04-21 16:44:58 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 16:44:58 0 [Note] InnoDB: Number of pools: 1
2020-04-21 16:44:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 16:44:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 16:44:58 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 16:44:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 16:44:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 16:44:58 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 16:44:58 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 16:44:58 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 16:44:58 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249869; transaction id 24779
2020-04-21 16:44:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 16:44:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 16:44:58 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 17:00:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 17:00:32 0 [Note] InnoDB: Uses event mutexes
2020-04-21 17:00:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 17:00:32 0 [Note] InnoDB: Number of pools: 1
2020-04-21 17:00:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 17:00:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 17:00:32 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 17:00:32 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 17:00:32 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 17:00:32 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 17:00:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 17:00:32 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 17:00:32 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249878; transaction id 24779
2020-04-21 17:00:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 17:00:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 17:00:32 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 17:01:15 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 17:01:15 0 [Note] InnoDB: Uses event mutexes
2020-04-21 17:01:15 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 17:01:15 0 [Note] InnoDB: Number of pools: 1
2020-04-21 17:01:15 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 17:01:15 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 17:01:15 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 17:01:15 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 17:01:15 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 17:01:15 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 17:01:15 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 17:01:15 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 17:01:15 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249887; transaction id 24779
2020-04-21 17:01:15 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 17:01:15 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 17:01:15 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-04-21 17:27:24 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-21 17:27:24 0 [Note] InnoDB: Uses event mutexes
2020-04-21 17:27:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-21 17:27:24 0 [Note] InnoDB: Number of pools: 1
2020-04-21 17:27:24 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-21 17:27:24 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-21 17:27:24 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-21 17:27:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-21 17:27:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-21 17:27:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-21 17:27:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-21 17:27:24 0 [Note] InnoDB: Waiting for purge to start
2020-04-21 17:27:24 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249896; transaction id 24779
2020-04-21 17:27:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-21 17:27:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-21 17:27:24 0 [Note] Server socket created on IP: '::'.

Es wäre schön wenn jemand eine Lösung hätte!
Vielen Dank im voraus für Eure Mühe!
Gruß tennstar
tennstar
 
Posts: 3
Joined: 21. April 2020 15:49
XAMPP version: 3.2.4
Operating System: WIN 10

Re: MySQL startet und wird wieder sofort beendet

Postby Altrea » 22. April 2020 09:01

Dann hier weiter.
Der MariaDB Log enthält keinen Hinweis auf das Problem.

Daher versuche MariaDB mal in der Konsole über die XAMPP Shell zu starten:
Code: Select all
mysqld --console


[EDIT von Altrea am 2020-04-24]
Benutzt nicht den Kommandozeilenbefehl den ich oben erwähnt habe! Das führt zu seltsamen Fehlerausgaben, weil die Konfigurationsdatei nicht geladen wurde.
Benutzt stattdessen folgenden Befehl in der XAMPP shell:
Code: Select all
mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[/EDIT]
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Re: MySQL startet und wird wieder sofort beendet

Postby tennstar » 22. April 2020 10:39

Hallo Altrea,
hab ich gemacht mit dem gleichen Ergebnis wie vorher, startet und stoppt wieder.
Hab mal den Code aus der Konsole kopiert, vielleicht kannst Du damit etwas anfangen, meine Wissenskenntnisse sind leider zu gering!
# mysqld --console
2020-04-22 11:34:56 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.
2020-04-22 11:34:56 0 [Note] mysqld (mysqld 10.4.11-MariaDB) starting as process 14052 ...
InnoDB: using atomic writes.
2020-04-22 11:34:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-22 11:34:57 0 [Note] InnoDB: Uses event mutexes
2020-04-22 11:34:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-22 11:34:57 0 [Note] InnoDB: Number of pools: 1
2020-04-22 11:34:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-22 11:34:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-22 11:34:57 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-22 11:34:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-22 11:34:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-22 11:34:57 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-22 11:34:57 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-22 11:34:57 0 [Note] InnoDB: Waiting for purge to start
2020-04-22 11:34:57 0 [Note] InnoDB: 10.4.11 started; log sequence number 71249966; transaction id 24779
2020-04-22 11:34:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-22 11:34:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-22 11:34:57 0 [Note] Server socket created on IP: '::'.
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-04-22 11:34:57 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:19:32 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:19:32 0 [Note] Reading of all Master_info entries su'ceeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000011' position: 4
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 0 [Note] InnoDB: Buffer pool(s) load completed at 200422 11:34:57
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread killed while connecting to master:32 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2020-04-22 11:34:57 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000009' (relay_log_pos 4)
2020-04-22 11:34:57 7 [ERROR] Could not find target log during relay log initialization
2020-04-22 11:34:57 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
' to hash table4:57 7 [Note] Added new Master_info '2020-04-21 11:19:32 0 [Note] Added new Master_info '' to hash table
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:19:32 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:19:32 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000013' position: 4
2020-04-22 11:34:57 10 [ERROR] Master '2020-04-21 11:19:32 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread killed while connecting to master9:32 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2020-04-22 11:34:57 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 11:34:57 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2020-04-22 11:34:57 13 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013' position: 4
2020-04-22 11:34:57 12 [ERROR] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributi': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200421@002011@003a19@003a32@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200421@002011@003a19@003a32@000d.info'
2020-04-22 11:34:57 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2020-04-22 11:34:57 12 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200421@002011@003a19@003a32@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed a' to hash table32
': Error in Log_event::read_log_event(): 'Event truncated', data_len: 959520817, event_type: 45ntries succeeded
2020-04-22 11:34:57 14 [Note] Master '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 11:19': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed'at 200421 11:19:32
2020-04-22 11:34:57 15 [Note] Master '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 11:19': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a19@003a32@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200421@002011@003a19@003a32@000d.000013' position: 4
2020-04-22 11:34:57 14 [ERROR] Master '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 11:1': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
': Error reading relay log event: slave SQL thread aborted because of I/O errorll Master_info entries succeeded
2020-04-22 11:34:57 14 [Note] Master '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 11:19': Slave I/O thread killed while connecting to master
2020-04-22 11:34:57 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)
': Slave SQL: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave. Internal MariaDB error code: 1594
2020-04-22 11:34:57 14 [Note] Master '2020-04-21 11:19:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200421 11:19': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 11:34:57 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
': Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'FIRST' position 0
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:21:18 21 [ERROR] mysqld.exe: Table '.\camping\wbce_mod' to hash tablerked as crashed and should be repaired
': Slave SQL thread exiting, replication stopped in log 'FIRST' at position 0all Master_info entries succeeded
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@000d.info'
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:21:18 21 [Warning] Checking table: '.\camping\wbce_m' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4mping\wbce_mod_jsadmin'
2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:21:18 21 [Warning] Checking table: '.\camping\wbce'mod_jsadmin'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a21@003a18@002021@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_jsadmin@0027@000d.000013' position: 4
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
': Slave I/O thread killed while connecting to master1:18 21 [Warning] Checking table: '.\camping\wbce_mod_jsadmin'
2020-04-22 11:34:57 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)
': Slave I/O thread exiting, read up to log 'FIRST', position 4arning] Checking table: '.\camping\wbce_mod_jsadmin'
2020-04-22 11:34:57 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:22:46 30 [ERROR] mysqld.exe: Table '.\camping\wbce_mod' to hash tablearked as crashed and should be repaired
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@000d.info'
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@000d.info'
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:22:46 30 [Warning] Checking table: '.\camping\wbce_m' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4mping\wbce_mod_droplets'
2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:22:46 30 [Warning] Checking table: '.\camping\wbce'mod_droplets'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a22@003a46@002030@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping@005cwbce_mod_droplets@0027@000d.000013' position: 4
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
': Slave I/O thread killed while connecting to master2:46 30 [Warning] Checking table: '.\camping\wbce_mod_droplets'
2020-04-22 11:34:57 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)
': Slave I/O thread exiting, read up to log 'FIRST', position 4arning] Checking table: '.\camping\wbce_mod_droplets'
2020-04-22 11:34:57 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:35:06 108 [ERROR] mysqld.exe: Table '.\camping_en\wbce' to hash tables marked as crashed and should be repaired
2020-04-22 11:34:57 7 [Note] Reading Master_info: 'master-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@000d.info' Relay_info:'relay-log-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@000d.info'
2020-04-22 11:34:57 7 [Note] Initialized Master_info from 'master-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@000d.info'2020-04-22 11:34:57 7 [Note] Added new Master_info '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wb' to hash table
2020-04-22 11:34:57 20 [Note] Master '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wbce_mod_wrapper': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 11:34:57 7 [Note] Started replication for '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\'bce_mod_wrapper'
2020-04-22 11:34:57 21 [Note] Master '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wbce_mod_wrapper': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d04@002d21@002011@003a35@003a06@0020108@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005ccamping_en@005cwbce_mod_wrapper@0027@000d.000013' position: 4
2020-04-22 11:34:57 20 [ERROR] Master '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wbce_mod_wrappe': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 11:34:57 0 [Warning] Reading of some Master_info entries failed
2020-04-22 11:34:57 20 [Note] Master '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wbce_mod_wrapper': Slave I/O thread killed while connecting to master
2020-04-22 11:34:57 0 [ERROR] Failed to initialize multi master structures
2020-04-22 11:34:57 20 [Note] Master '2020-04-21 11:35:06 108 [Warning] Checking table: '.\camping_en\wbce_mod_wrapper': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 11:34:57 0 [ERROR] Aborting

Danke schon mal!
Gruß tennstar
tennstar
 
Posts: 3
Joined: 21. April 2020 15:49
XAMPP version: 3.2.4
Operating System: WIN 10

Re: MySQL startet und wird wieder sofort beendet

Postby tennstar » 22. April 2020 14:13

Hat sich erledigt!
Habe mich schweren Herzens entschlossen alles zu löschen und neu aufzusetzen, komme sonst nicht weiter!
Hab leider 5 Entwürfe meiner Webseiten verloren.
Danke nochmals!
tennstar
Thread kann geschlossen werden..
tennstar
 
Posts: 3
Joined: 21. April 2020 15:49
XAMPP version: 3.2.4
Operating System: WIN 10

Re: MySQL startet und wird wieder sofort beendet

Postby Altrea » 22. April 2020 14:27

Auch wenn es eine schmerzhafte Erfahrung zu sein scheint, so sollte man immer schauen, dass man regelmäßige Backups machen kann und dies auch tut. Und diese Backups sollten nach Möglichkeit dezentral und unzugreifbar für irgendwelche Schadsoftware liegen. Es kann immer mal passieren, dass eine Anwendung kaputt geht, eine Festplatte kaputt geht oder man sich einen Virus fängt. Niemand verliert gerne Stunden/Tage/Wochen seiner Arbeit.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Re: MySQL startet und wird wieder sofort beendet

Postby gretarsson » 25. May 2020 16:03

Hallo, ich poste das mal hier. Auch wenn unterschiedliche Ursachen vorliegen mögen, so hab ich das gleiche Problem wie der TO: MySQL/MariaDB lässt sich nach wochenlangem täglichem Betrieb weitgehend frei von ernsthaften Problemen plötzlich nicht mehr starten, und das Startlog gibt keinen Hinweis auf die Ursache. Ich habe zunächst, wie oben empfohlen, versucht, das Modul via Shell zu starten. Leider vergebens. Im Gegensatz zum Startversuch via Control Panel bekomme ich in der Shell aber die Meldung:

Code: Select all
...
2020-05-25 16:36:39 0 [Note] Server socket created on IP: '::'.
2020-05-25 16:36:39 0 [ERROR] mysqld: Index for table '.\mysql\db' is corrupt; try to repair it
2020-05-25 16:36:39 0 [ERROR] Couldn't repair table: mysql.db
2020-05-25 16:36:39 0 [ERROR] Fatal error: Can't open and lock privilege tables: Index for table 'db' is corrupt; try to repair it
2020-05-25 16:36:39 0 [ERROR] Aborting


Das Problem mit der beschädigten Systemtabelle 'mysql.db' ist kein neues und trat regelmäßig auf. Allerdings bewirkte es bislang nie einen Startabbruch, und die Tabelle ließ sich auch immer reparieren (hatte sogar ein PHP-Skript dafür geschrieben, um mich nicht immer in phpMyAdmin durchklicken zu müssen). Wie bekomme ich die Tabelle 'mysql.db' gefixt, ohne dass ich direkt mit MySQL/MariaDB darauf zugreifen kann? Anschlussfrage, wo ich grad da bin: Gibt es einen Workaround, das Problem mit der beschädigten 'mysql.db' dauerhaft zu lösen, so, dass es in Zukunft gar nicht erst wieder auftritt?
gretarsson
 
Posts: 2
Joined: 25. May 2020 15:41
XAMPP version: 7.3.14
Operating System: Windows 10 Home x64

Re: MySQL startet und wird wieder sofort beendet

Postby gretarsson » 29. May 2020 18:48

OK. Ich hab nach wiederholter Recherche bei Stack Overflow eine Lösung gefunden. Sie steht hier (https://stackoverflow.com/questions/58386240/mysqld-exe-table-mysql-db-is-marked-as-crashed-and-should-be-repaired) und lautet wie folgt:

XAMPP-Shell via Control Panel öffnen und MySQL mit folgendem Kommando, d.h. ohne Zugriff auf die Benutzertabelle, starten:

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


Im Control Panel sollte jetzt ersichtlich sein, dass MySQL läuft.

Dann ein zweites Shell-Fenster öffen und darin die Systemtabellen, 'db' eingeschlossen, mit der Eingabe des folgenden Kommandos reparieren lassen:

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


Jetzt MySQL via Control Panel stoppen und die beiden Shell-Fenster schließen. Wenn jetzt der MySQL-Server wieder normal via Control Panel gestartet wird, sollte kein Abbruch mehr erfolgen. Bei mir hat's jedenfalls so funktioniert. 8)
gretarsson
 
Posts: 2
Joined: 25. May 2020 15:41
XAMPP version: 7.3.14
Operating System: Windows 10 Home x64

Re: MySQL startet und wird wieder sofort beendet

Postby Altrea » 29. May 2020 18:57

Vielen Dank, dass du die Lösung mit der Community teilst :)
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 8 guests