MYSQL via XAMPP startet nicht mehr

[Scolex]

Hallo,
ich habe seit heute das Problem dass MYSQL über das XAMPP Kontrollcenter plötzlich nicht mehr startet und ich etliche Fehlermeldungen erhalte.

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

Log:
InnoDB: using atomic writes.
2021-08-18 11:17:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-18 11:17:50 0 [Note] InnoDB: Uses event mutexes
2021-08-18 11:17:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-18 11:17:50 0 [Note] InnoDB: Number of pools: 1
2021-08-18 11:17:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-18 11:17:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-18 11:17:50 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-18 11:17:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-18 11:17:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-18 11:17:50 0 [Note] InnoDB: Setting file 'H:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-18 11:17:50 0 [Note] InnoDB: File 'H:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-18 11:17:50 0 [Note] InnoDB: Waiting for purge to start
2021-08-18 11:17:50 0 [Note] InnoDB: 10.4.17 started; log sequence number 1346850992; transaction id 842879
2021-08-18 11:17:50 0 [Note] InnoDB: Loading buffer pool(s) from H:\xampp\mysql\data\ib_buffer_pool
2021-08-18 11:17:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-18 11:17:50 0 [Note] Server socket created on IP: '::'.

EventViewer:


Beim Schliueßen von Xampp:


Firewall:



Habe nichts an den Ports geändert o.ä.
Antivirussoftware habe ich mal deaktiviert.

Wäre über Hilfe sehr dankbar!
Cheers

[Scolex]

Ich habe im Forum einen ähnlichen Beitrag dazu gefunden, bekomme aber in der Shell eine riesige Fehlermeldung und weiß nicht ob der Fehler der gleiche ist:
https://community.apachefriends.org/f/viewtopic.php?f=7&t=80265

[Altrea]

Da die Shell (bzw. genauer gesagt die MariaDB Konsolenanwendung) unterschiedliche Fehlermeldungen schmeißen kann, ist es unmöglich für uns zu sagen, ob der Fehler der gleiche ist, ohne die Fehlermeldung von dir zu kennen.

[Scolex]

Okay danke erst mal für die Hilfe. Die Fehlermeldung lautet wie unten stehend.
Ich musste mittendrin einen teil der Fehlermeldung löschen, da zu viel Zeichen.... (Dein Beitrag enthält 81285 Zeichen. Es sind maximal 60000 Zeichen erlaubt.)

Setting environment for using XAMPP for Windows.
User@MEDIEN-PC h:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-08-18 15:29:54 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-08-18 15:29:54 0 [Note] mysqld (mysqld 10.4.17-MariaDB) starting as process 5960 ...
InnoDB: using atomic writes.
2021-08-18 15:29:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-18 15:29:54 0 [Note] InnoDB: Uses event mutexes
2021-08-18 15:29:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-18 15:29:54 0 [Note] InnoDB: Number of pools: 1
2021-08-18 15:29:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-18 15:29:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-18 15:29:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-18 15:29:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-18 15:29:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-18 15:29:54 0 [Note] InnoDB: Setting file 'H:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-18 15:29:54 0 [Note] InnoDB: File 'H:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-18 15:29:54 0 [Note] InnoDB: Waiting for purge to start
2021-08-18 15:29:55 0 [Note] InnoDB: 10.4.17 started; log sequence number 1346851046; transaction id 842879
2021-08-18 15:29:55 0 [Note] InnoDB: Loading buffer pool(s) from H:\xampp\mysql\data\ib_buffer_pool
2021-08-18 15:29:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-18 15:29:55 0 [Note] Server socket created on IP: '::'.
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 15:29:55 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-08-18 15:29:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210818 15:29:55
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-01-22 16:40:10 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
2021-08-18 15:29:55 7 [Note] Started replication for '2021-01-22 16:40:10 0 [Note] Reading of all Master_info entries su'ceeded
': 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@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000001' position: 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d01@002d22@002016@003a40@003a10@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:10 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
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table9:55 7 [Note] Added new Master_info '2021-01-22 16:40:10 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 hash table
2021-08-18 15:29:55 7 [Note] Started replication for '2021-01-22 16:40:10 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-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' position: 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master0:10 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-01-22 16:40:10 0 [Note] h:\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.2021-08-18 15:29:55 12 [ERROR] Master '2021-01-22 16:40:10 0 [Note] h:\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
2021-08-18 15:29:55 7 [Note] Started replication for '2021-01-22 16:40:10 0 [Note] h:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave I/O thread killed while connecting to master0:10 0 [Note] h:\xampp\mysql\bin\mysqld.exe: ready for connections.': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e17@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@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] h:\xampp\mysql\bin\mysqld.exe: ready for connections.2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-08-18 15:29:55 7 [Note] Added new Master_info 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-08-18 15:29:55 14 [Note] Master 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-18 15:29:55 7 [Note] Started replication for 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2021-08-18 15:29:55 14 [ERROR] Master 'Version: '10.4.17-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-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a55@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2021@0040002d01@0040002d22@0040002016@0040003a40@0040003a10@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a55@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2021@0040002d01@0040002d22@0040002016@0040003a40@0040003a10@004000200@00400020@0040005bnote@0040005d@00400020reading@00400020of@00400020all@00400020master_info@00400020entries@00400020succeeded@0040.info'


......



2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2021@0040002d01@0040002d22@0040002016@0040003a40@0040003a10@004000200@00400020@0040005bnote@0040005d@00400020h@0040003a@0040005cxampp@0040005cmysql@0040005cbin@0040005cmysqld@0040002eexe@004000.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Initialized Master_info from 'master-2021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Added new Master_info '2021-01-22 16:40' to hash table\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start@002.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start@002.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start@002.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start@002.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 12 [Note] Master '2021-01-22 16:40:10 0 [Note] h': Slave I/O thread: Start asynchronous replication to master '@:3306' ' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Started replication for '2021-01-22 16:' to hash tableh:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002013@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@002c@0.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002013@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@002c@0.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002013@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@002c@0.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002013@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@002c@0.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 13 [Note] Master '2021-01-22 16:40:10 0 [Note] h': Slave SQL thread initialized, starting replication in log 'FIRST' at' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005berror@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error@003.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005berror@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error@003.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005berror@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error@003.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005berror@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error@003.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 12 [ERROR] Master '2021-01-22 16:40:10 0 [Note] ': Slave I/O: Fatal error: Invalid (empty) username when attempting to' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@00400.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@00400.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@00400.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@00400.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariad' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connecting.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connecting.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connecting.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connecting.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 12 [Note] Master '2021-01-22 16:40:10 0 [Note] h' to hash tableread killed while connecting to master
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002012@0020@005bnote@005d@0020master@0020@00272021@002d01@002d22@002016@003a40@003a10@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 12 [Note] Master '2021-01-22 16:40:10 0 [Note] h' to hash tableread exiting, read up to log 'FIRST', position 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@004000.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@004000.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@004000.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e17@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@004000.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@00' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@0020to@0020hash@0020table@000d.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@0020to@0020hash@0020table@000d.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@0020to@0020hash@0020table@000d.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Added new Master_info 'Version: '10.4.1' to hash tableket: '' port: 3306 mariadb.org binary distribution
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020star.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020star.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020star.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020star.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 14 [Note] Master 'Version: '10.4.17-MariaDB' so': Slave I/O thread: Start asynchronous replication to master '@:3306'' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 7 [Note] Started replication for 'Version: '10.4' to hash tableocket: '' port: 3306 mariadb.org binary distribution
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002015@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@0.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002015@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@0.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002015@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@0.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002015@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@0.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 15 [Note] Master 'Version: '10.4.17-MariaDB' so': Slave SQL thread initialized, starting replication in log 'FIRST' a' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020erro.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020erro.info'
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020erro.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020erro.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 14 [ERROR] Master 'Version: '10.4.17-MariaDB' s': Slave I/O: Fatal error: Invalid (empty) username when attempting t' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 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 4entries succeeded
': 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-08-18 15:29:55 7 [Note] Started replication for '2021-08-11 10:04:56 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-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000018' position: 4
': Slave I/O thread killed while connecting to master4:56 0 [Note] Reading of all Master_info entries succeeded
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020conn.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020conn.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Reading of all Master_info entries succeeded
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020conn.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020conn.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 14 [Note] Master 'Version: '10.4.17-MariaDB' so' to hash tableread killed while connecting to master
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table9:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 hash table
': 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-08-18 15:29:55 7 [Note] Started replication for '2021-08-11 10:04:56 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master4:56 0 [Note] Added new Master_info '' to hash table
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@00.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@00.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000018' position: 4
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2021-08-18 15:29:55 7 [ERROR] Failed to create a new master info file (file 'H:\xampp\mysql\data\master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@00.info', errno 2)
2021-08-18 15:29:55 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@00.info' failed
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 14 [Note] Master 'Version: '10.4.17-MariaDB' so' to hash tableread exiting, read up to log 'FIRST', position 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-18 15:29:55 7 [Note] Added new Master_info '2021-08-11 10:04:56 0 [Note] h:\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.2021-08-18 15:29:55 7 [Note] Started replication for '2021-08-11 10:04:56 0 [Note] h:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
2021-08-18 15:29:55 20 [ERROR] Master '2021-08-11 10:04:56 0 [Note] h:\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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d11@002010@003a04@003a56@00200@0020@005bnote@005d@0020h@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000018' position: 4
2021-08-18 15:29:55 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e17@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@002e17@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 master4:56 0 [Note] h:\xampp\mysql\bin\mysqld.exe: ready for connections.': Slave I/O thread exiting, read up to log 'FIRST', position 4te] h:\xampp\mysql\bin\mysqld.exe: ready for connections.2021-08-18 15:29:55 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e17@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-08-18 15:29:55 7 [ERROR] Connection 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distrib' conflicts with existing connection 'Version: '10.4.17-MariaDB' socket: '' port: 3306 mariadb.org binary distributio'
2021-08-18 15:29:55 0 [Warning] Reading of some Master_info entries failed
2021-08-18 15:29:55 0 [ERROR] Failed to initialize multi master structures
2021-08-18 15:29:55 0 [ERROR] Aborting
Warning: Memory not freed: 33712

[Altrea]

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.

[Scolex]

Hat leider nicht geklappt. Bekomme wieder die gleiche Meldung in XAMPP.

Im Ordner "\xampp\mysql\data\" werden nach Start der MariaDB folgende Dateien neu erstellt:
aria_log.00000001
aria_log_control
ib_logfile0
ib_logfile1

Die Fehlermeldung bzw. diese Absturmeldung bekomme ich auch ständig und lässt sich kaum wegklicken.

[Altrea]

Dann versuche nochmal MariaDB als Konsolenanwendung zu starten und versorge uns mit neuen Logmeldungen daraus.
Und teile uns mit, welche Dateien sich nach dem Löschen noch im Ordner \mysql\data\ befinden.

[Scolex]

Hallo,

"aus der Konsole statren" bedeutet über die Shell, oder?! Habe in der Shell "mysqld.exe --console" eingegeben, dann kam folgende Meldung:

User@MEDIEN-PC h:\xampp
# mysqld.exe --console
2021-08-19 8:59:26 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-08-19 8:59:26 0 [Note] mysqld.exe (mysqld 10.4.17-MariaDB) starting as process 9808 ...
InnoDB: using atomic writes.
2021-08-19 8:59:26 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-19 8:59:26 0 [Note] InnoDB: Uses event mutexes
2021-08-19 8:59:26 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-19 8:59:26 0 [Note] InnoDB: Number of pools: 1
2021-08-19 8:59:26 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-19 8:59:26 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-19 8:59:26 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-19 8:59:26 0 [Note] InnoDB: Setting log file H:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2021-08-19 8:59:26 0 [Note] InnoDB: Setting log file H:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2021-08-19 8:59:26 0 [Note] InnoDB: Renaming log file H:\xampp\mysql\data\ib_logfile101 to H:\xampp\mysql\data\ib_logfile0
2021-08-19 8:59:26 0 [Note] InnoDB: New log files created, LSN=1346851861
2021-08-19 8:59:26 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-19 8:59:26 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-19 8:59:26 0 [Note] InnoDB: Setting file 'H:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-19 8:59:26 0 [Note] InnoDB: File 'H:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-19 8:59:26 0 [Note] InnoDB: Waiting for purge to start
2021-08-19 8:59:26 0 [Note] InnoDB: 10.4.17 started; log sequence number 1346852364; transaction id 842879
2021-08-19 8:59:26 0 [Note] InnoDB: Loading buffer pool(s) from H:\xampp\mysql\data\ib_buffer_pool
2021-08-19 8:59:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-19 8:59:26 0 [Note] Zerofilling moved table: '.\mysql\plugin'
2021-08-19 8:59:26 0 [Note] Zerofilling moved table: '.\mysql\servers'
2021-08-19 8:59:26 0 [Note] Server socket created on IP: '::'.
2021-08-19 8:59:26 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-08-19 8:59:26 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-08-19 8:59:26 0 [ERROR] Aborting

Im besagten Ordner befinden sich dann folgende Dateien:




Sind das die notwenigen Daten/Logs?

THX

[Altrea]

Hallo,

"aus der Konsole statren" bedeutet über die Shell, oder?! Habe in der Shell "mysqld.exe --console" eingegeben

Wie in dem von dir oben gefundenen Beitrag beschrieben

Code: Select all

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

dann kam folgende Meldung:

2021-08-19 8:59:26 0 [ERROR] mysqld.exe: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-08-19 8:59:26 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed
2021-08-19 8:59:26 0 [ERROR] Aborting

Deshalb ist es so wichtig, Fehler systematisch zu analysieren, Analysewerkzeuge unter Umständen mehrfach anzuwenden. Die Fehlermeldung ist nun nämlich eine ganz Andere und bedarf daher auch einer anderen Lösungsstrategie.

Deine mysql Datenbank ist nichtmehr funktionsfähig und muss repariert werden.

Um diese Datenbank zu reparieren, öffne bitte eine XAMPP Shell und führe folgendes Command aus:

Code: Select all

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

Lasse die Shell offen und öffne bitte eine zweite XAMPP Shell und führe dort folgendes Command aus:

Code: Select all

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

Anschließend kannst du beide Shell Fenster schließen und versuchen die Datenbank auf normalem Wege zu starten

[Scolex]

Vielen vielen Dank!!!!

Hat funktioniert.

Gibt es eine Theorie wie der fehler entstanden ist?

Cheers