Fehler: MySQL wurde unerwartet beendet

[Koner]

Liebe Community,
wenn ich MySQL starte kommt nur eine Fehlermeldung und im Log steht folgendes drinnen:

Code: Select all

2022-05-06 20:35:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-05-06 20:35:23 0 [Note] InnoDB: Uses event mutexes
2022-05-06 20:35:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-06 20:35:23 0 [Note] InnoDB: Number of pools: 1
2022-05-06 20:35:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-06 20:35:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-05-06 20:35:23 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-06 20:35:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-05-06 20:35:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-06 20:35:23 0 [Note] InnoDB: Setting file 'C:\Koner\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-06 20:35:23 0 [Note] InnoDB: File 'C:\Koner\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-05-06 20:35:23 0 [Note] InnoDB: Waiting for purge to start
2022-05-06 20:35:23 0 [Note] InnoDB: 10.4.24 started; log sequence number 301488; transaction id 218
2022-05-06 20:35:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\Koner\xampp\mysql\data\ib_buffer_pool
2022-05-06 20:35:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-06 20:35:23 0 [Note] Server socket created on IP: '::'.


Ich habe gesehen das jemand anderes anscheinend ein ähnliches Problem hatte und er sollte

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console


eingeben. Das hab ich auch mal gemacht und bei mir standen folgende Informationen:

Code: Select all

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2022-05-06 20:40:21 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.
2022-05-06 20:40:21 0 [Note] mysqld (mysqld 10.4.24-MariaDB) starting as process 8572 ...
2022-05-06 20:40:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-05-06 20:40:21 0 [Note] InnoDB: Uses event mutexes
2022-05-06 20:40:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-06 20:40:21 0 [Note] InnoDB: Number of pools: 1
2022-05-06 20:40:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-06 20:40:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-05-06 20:40:21 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-06 20:40:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-05-06 20:40:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-06 20:40:21 0 [Note] InnoDB: Setting file 'C:\Koner\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-06 20:40:21 0 [Note] InnoDB: File 'C:\Koner\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-05-06 20:40:21 0 [Note] InnoDB: Waiting for purge to start
2022-05-06 20:40:21 0 [Note] InnoDB: 10.4.24 started; log sequence number 301497; transaction id 218
2022-05-06 20:40:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\Koner\xampp\mysql\data\ib_buffer_pool
2022-05-06 20:40:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-06 20:40:21 0 [Note] Server socket created on IP: '::'.
2022-05-06 20:40:21 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-05-06 20:40:21 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-05-06 20:40:21 0 [ERROR] Aborting

Ich hoffe ihr könnt mir weiterhelfen
Viele Grüße Koner

[Altrea]

Hallo,

2022-05-06 20:40:21 0 [ERROR] mysqld: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-05-06 20:40:21 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2022-05-06 20:40:21 0 [ERROR] Aborting[/code]

Deine mysql Datenbank muss repariert werden

Dazu öffne bitte nochmal eine neue XAMPP Shell und führe folgendes Command aus:

Code: Select all

mysqld --console --skip-grant-tables --skip-external-locking

Lasse dieses Shellfenster bitte offen und öffne eine zweite Shell, in welcher du folgendes Command absetzt:

Code: Select all

mysqlcheck -r --databases mysql --use-frm

Nun kannst du beide Shell Fenster wieder schließen und versuchen MariaDB normal über das control Panel zu starten

[Koner]

Hi, wenn ich das mache funktioniert es erstmal, wenn ich allerdings den Computer neustarte funktioniert es wieder nicht
LG Koner

[Altrea]

Die Frage ist, ob der Fehler wieder genau derselbe ist.

Was du ändern könntest wäre für mysql/MariaDB den Windows Dienst registrieren, dann benutzt das control Panel den Windows Dienst zum Starten und Stoppen.
Das ist eine viel sauberere Art MariaDB zu stoppen als es XAMPP tut.

[Phoca-Benno]

Hallo,
ich hänge mich hier an, weil die Fehlermeldung die ich erhalte die gleiche ist (ich hoffe das ist ok, sonst mache ich halt einen neuen Threadauf):

Code: Select all

Fehler: MySQL wurde unerwartet beendet
Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
Drücke den Logs Button um error logs zu sehen und prüfe
im Windows Event Viewer für weitere Hinweise
Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

msql_error.log:

Code: Select all

2022-07-06 20:40:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-07-06 20:40:37 0 [Note] InnoDB: Uses event mutexes
2022-07-06 20:40:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-07-06 20:40:37 0 [Note] InnoDB: Number of pools: 1
2022-07-06 20:40:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-07-06 20:40:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-07-06 20:40:37 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-06 20:40:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-07-06 20:40:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-06 20:40:37 0 [Note] InnoDB: Setting file 'C:\Users\info\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-06 20:40:37 0 [Note] InnoDB: File 'C:\Users\info\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-07-06 20:40:37 0 [Note] InnoDB: Waiting for purge to start
2022-07-06 20:40:37 0 [Note] InnoDB: 10.4.24 started; log sequence number 84375908; transaction id 60628
2022-07-06 20:40:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\info\xampp\mysql\data\ib_buffer_pool
2022-07-06 20:40:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-06 20:40:37 0 [Note] Server socket created on IP: '::'.

Dieser Befehl:

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console

ergibt:

Code: Select all

Setting environment for using XAMPP for Windows.
info@LAPTOP-JP0R5DRG c:\users\info\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2022-07-06 20:48:10 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.
2022-07-06 20:48:10 0 [Note] mysqld (mysqld 10.4.24-MariaDB) starting as process 20780 ...
2022-07-06 20:48:10 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2022-07-06 20:48:10 0 [Note] InnoDB: Uses event mutexes
2022-07-06 20:48:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-07-06 20:48:10 0 [Note] InnoDB: Number of pools: 1
2022-07-06 20:48:10 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-07-06 20:48:10 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-07-06 20:48:10 0 [Note] InnoDB: Completed initialization of buffer pool
2022-07-06 20:48:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-07-06 20:48:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-07-06 20:48:10 0 [Note] InnoDB: Setting file 'C:\Users\info\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-07-06 20:48:10 0 [Note] InnoDB: File 'C:\Users\info\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-07-06 20:48:10 0 [Note] InnoDB: Waiting for purge to start
2022-07-06 20:48:10 0 [Note] InnoDB: 10.4.24 started; log sequence number 84375917; transaction id 60628
2022-07-06 20:48:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\Users\info\xampp\mysql\data\ib_buffer_pool
2022-07-06 20:48:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-07-06 20:48:10 0 [Note] Server socket created on IP: '::'.
2022-07-06 20:48:10 0 [Note] InnoDB: Buffer pool(s) load completed at 220706 20:48:10
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2022-07-06 20:48:10 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2022-07-06 20:48:10 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' (relay_log_pos 4)
2022-07-06 20:48:10 7 [ERROR] Could not find target log during relay log initialization
2022-07-06 20:48:10 7 [ERROR] Initialized Master_info from 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2022-07-06 20:48:10 7 [Note] Added new Master_info '2022-06-18 19:35:34 0 [Note] Reading of all Master_info entries succ' to hash table
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2022-07-06 20:48:10 7 [Note] Initialized Master_info from 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table8:10 7 [Note] Added new Master_info '2022-06-18 19:35:34 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4hash table
2022-07-06 20:48:10 7 [Note] Started replication for '2022-06-18 19:35:34 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000026' position: 4
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020c@003a@005cusers@005cinfo@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020c@003a@005cusers@005cinfo@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master:34 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Added new Master_info '' to hash table
': master was :3306 8 [Note] Master '2022-06-18 19:35:34 0 [Note] Added new Master_info '' to hash table
2022-07-06 20:48:10 7 [Note] Initialized Master_info from 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020c@003a@005cusers@005cinfo@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2022-07-06 20:48:10 7 [Note] Added new Master_info '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.ex' to hash tablennections.
2022-07-06 20:48:10 10 [Note] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for c': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2022-07-06 20:48:10 10 [ERROR] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for ': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2022-07-06 20:48:10 7 [Note] Started replication for '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.'xe: ready for connections.
2022-07-06 20:48:10 10 [Note] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for c': Slave I/O thread killed while connecting to master
2022-07-06 20:48:10 11 [Note] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for c': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020c@003a@005cusers@005cinfo@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000026' position: 4
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e24@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@002e24@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2022-07-06 20:48:10 10 [Note] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for c': Slave I/O thread exiting, read up to log 'FIRST', position 4
2022-07-06 20:48:10 10 [Note] Master '2022-06-18 19:35:34 0 [Note] c:\users\info\xampp\mysql\bin\mysqld.exe: ready for c': master was :3306
2022-07-06 20:48:10 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e24@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2022-07-06 20:48:10 7 [Note] Added new Master_info 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org bina' to hash table
2022-07-06 20:48:10 12 [Note] Master 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2022-07-06 20:48:10 12 [ERROR] Master 'Version: '10.4.24-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
2022-07-06 20:48:10 7 [Note] Started replication for 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org bi'ary distribution
2022-07-06 20:48:10 13 [Note] Master 'Version: '10.4.24-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@002e24@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000026' position: 4
2022-07-06 20:48:10 12 [Note] Master 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d06@0040002d18@0040002019@0040003a35@0040003a34@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info'  Relay_info:'relay-log-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d06@0040002d18@0040002019@0040003a35@0040003a34@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info'
2022-07-06 20:48:10 12 [Note] Master 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2022-07-06 20:48:10 7 [ERROR] Failed to create a new master info file (file 'C:\Users\info\xampp\mysql\data\master-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d06@0040002d18@0040002019@0040003a35@0040003a34@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info', errno 2)
2022-07-06 20:48:10 12 [Note] Master 'Version: '10.4.24-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': master was :3306
2022-07-06 20:48:10 7 [ERROR] Initialized Master_info from 'master-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2022@0040002d06@0040002d18@0040002019@0040003a35@0040003a34@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info' failed
2022-07-06 20:48:10 7 [Note] Added new Master_info '2022-07-06 18:07:19 7 [Note] Reading Master_info: 'master-2022@002d06@002d18@002019@003a35@003a34@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@' to hash table
2022-07-06 20:48:10 7 [Note] Reading Master_info: 'master-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020its@00.info'  Relay_info:'relay-log-2022@002d07@002d06@002018@003a07@003a19@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020its@00.info'