MySQL startet plötzlich nicht mehr

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

MySQL startet plötzlich nicht mehr

Postby RetoPizza » 05. May 2021 10:52

Ich habe genau das selbe Problem seit heute (Mysql lässt sich nicht mehr starten und gibt die selbe rote ausgabe wie oben. Log ist auch identisch.)

Die Shell-Eingabe gibt einen sehr langen Text zurück. Ich hoffe es ist ok wenn ich ihn dennoch hier poste (Habe den Mittelteil gekürzt, weil nur 60000 Zeichen erlaubt sind). Wäre wirklich froh um jede Hilfe!

Hier die Ausgabe der Shell:

# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-05-05 11:47:28 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-05-05 11:47:28 0 [Note] mysqld (mysqld 10.4.18-MariaDB) starting as process 5124 ...
InnoDB: using atomic writes.
2021-05-05 11:47:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-05-05 11:47:28 0 [Note] InnoDB: Uses event mutexes
2021-05-05 11:47:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-05-05 11:47:28 0 [Note] InnoDB: Number of pools: 1
2021-05-05 11:47:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-05-05 11:47:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-05-05 11:47:28 0 [Note] InnoDB: Completed initialization of buffer pool
2021-05-05 11:47:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-05-05 11:47:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-05-05 11:47:28 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-05-05 11:47:28 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-05-05 11:47:28 0 [Note] InnoDB: Waiting for purge to start
2021-05-05 11:47:28 0 [Note] InnoDB: 10.4.18 started; log sequence number 52351195; transaction id 23417
2021-05-05 11:47:28 0 [Note] InnoDB: Loading buffer pool(s) from c:\xampp\mysql\data\ib_buffer_pool
2021-05-05 11:47:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-05-05 11:47:28 0 [Note] Server socket created on IP: '::'.
2021-05-05 11:47:28 0 [Note] InnoDB: Buffer pool(s) load completed at 210505 11:47:28
2021-05-05 11:47:28 7 [Note] Reading Master_info: 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-05-05 11:47:28 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.
2021-05-05 11:47:28 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000007' (relay_log_pos 4)
2021-05-05 11:47:28 7 [ERROR] Could not find target log during relay log initialization
2021-05-05 11:47:28 7 [ERROR] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2021-05-05 11:47:28 7 [Note] Added new Master_info '2021-05-04 8:50:21 0 [Note] Reading of all Master_info entries succ' to hash table
2021-05-05 11:47:28 7 [Note] Reading Master_info: 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-05-05 11:47:28 7 [ERROR] log 2021-05-05 10:24:45 7 [Note] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020ta listed in the index, but failed to stat
2021-05-05 11:47:28 7 [ERROR] Error counting relay log space
2021-05-05 11:47:28 7 [ERROR] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
' to hash table7:28 7 [Note] Added new Master_info '2021-05-04 8:50:21 0 [Note] Added new Master_info '' to hash table
2021-05-05 11:47:28 7 [Note] Reading Master_info: 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-05-05 11:47:28 7 [Note] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-05-05 11:47:28 7 [Note] Added new Master_info '2021-05-04 8:50:21 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 4e: ready for connections.
2021-05-05 11:47:28 7 [Note] Started replication for '2021-05-04 8:50:21 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or 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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d05@002d04@0020@00208@003a50@003a21@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000031' position: 4
2021-05-05 11:47:28 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 master:21 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306 8 [Note] Master '2021-05-04 8:50:21 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-05-05 11:47:28 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'
2021-05-05 11:47:28 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-05-05 11:47:28 10 [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
2021-05-05 11:47:28 10 [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
2021-05-05 11:47:28 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution

... hier gekürzt ...

2021-05-05 11:47:28 38 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-05-05 11:47:28 7 [ERROR] Failed to create a new master info file (file '\xampp\mysql\data\master-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)
2021-05-05 11:47:28 38 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': master was :3306
2021-05-05 11:47:28 7 [ERROR] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2021-05-05 11:47:28 7 [Note] Added new Master_info '2021-05-04 8:53:49 11 [ERROR] mysqld.exe: Table '.\wireriehen\field' to hash tableeedback' is marked as crashed and should be repaired
2021-05-05 11:47:28 7 [Note] Reading Master_info: 'master-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@000d.info' Relay_info:'relay-log-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@000d.info'
2021-05-05 11:47:28 7 [Note] Initialized Master_info from 'master-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@000d.info'
2021-05-05 11:47:28 7 [Note] Added new Master_info '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\fie' to hash table_feedback'
2021-05-05 11:47:28 40 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-05-05 11:47:28 40 [ERROR] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschri': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-05-05 11:47:28 7 [Note] Started replication for '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\f'eld_ueberschrift_feedback'
2021-05-05 11:47:28 40 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': Slave I/O thread killed while connecting to master
2021-05-05 11:47:28 41 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d05@002d04@0020@00208@003a53@003a49@002011@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cwireriehen@005cfield_ueberschrift_feedback@0027@000d.000031' position: 4
2021-05-05 11:47:28 0 [Warning] Reading of some Master_info entries failed
2021-05-05 11:47:28 40 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-05-05 11:47:28 0 [ERROR] Failed to initialize multi master structures
2021-05-05 11:47:28 40 [Note] Master '2021-05-04 8:53:49 11 [Warning] Checking table: '.\wireriehen\field_ueberschrif': master was :3306
2021-05-05 11:47:28 0 [ERROR] Aborting
Warning: Memory not freed: 16832
RetoPizza
 
Posts: 1
Joined: 05. May 2021 10:43
XAMPP version: 8.0.5-0-VS16
Operating System: Win10

Re: MySQL startet plötzlich nicht mehr

Postby Altrea » 05. May 2021 18:10

Hi,

Probiere bitte mal folgendes, das hat bei anderen schon zum Erfolg geführt :

Öffne den Ordner "\xampp\mysql\data\"
Lösche die Datei "multi-master.info"
Lösche alle Dateien deren Dateiname beginnt mit: "master-"
Lösche alle Dateien deren Dateiname beginnt mit: "mysql_relay-bin-"
Lösche alle Dateien deren Dateiname beginnt mit: "relay-log-"
Lösche alle Dateien deren Dateiname beginnt mit: "ib_logfile"
Lösche alle Dateien deren Dateiname beginnt mit: "aria_log."

Versuche nun MariaDB zu starten.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 32 guests