mysql error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL stops immediately on starting

Postby Lambeck » 08. July 2021 23:53

I am trying to start MySQL within XAMPP Control Panel. It stops immediately with the following error message

8:45:49 AM [mysql] Attempting to start MySQL app...
8:45:50 AM [mysql] Status change detected: running
8:45:52 AM [mysql] Status change detected: stopped
8:45:52 AM [mysql] Error: MySQL shutdown unexpectedly.
8:45:52 AM [mysql] This may be due to a blocked port, missing dependencies,
8:45:52 AM [mysql] improper privileges, a crash, or a shutdown by another method.
8:45:52 AM [mysql] Press the Logs button to view error logs and check
8:45:52 AM [mysql] the Windows Event Viewer for more clues
8:45:52 AM [mysql] If you need more help, copy and post this
8:45:52 AM [mysql] entire log window on the forums

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

My Windows system did an update this morning. Could this have something to do with it?
Lambeck
 
Posts: 2
Joined: 08. July 2021 23:41
XAMPP version: 3.3.0
Operating System: Windows

mysql error

Postby Lambeck » 09. July 2021 00:26

Having the same problem...

Ran the suggested command through shell and got this.

hile@0020connecting@0020to@0020master@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 8 [Note] Master '2021-07-07 10:18:39 0 [Note] Ad' to hash tableread killed while connecting to master
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@00.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@00.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@00.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@00.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 8 [Note] Master '2021-07-07 10:18:39 0 [Note] Ad' to hash tableread exiting, read up to log 'FIRST', position 4
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00208@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 8 [Note] Master '2021-07-07 10:18:39 0 [Note] Ad' to hash table3306 '' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2021@0040002d07@0040002d07@0040002010@0040003a18@0040003a39@004000200@00400020@0040005bnote@0040005d@00400020c@0040003a@0040005cxampp@0040005cmysql@0040005cbin@0040005cmysqld@0040002eexe@00.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2021@0040002d07@0040002d07@0040002010@0040003a18@0040003a39@004000200@00400020@0040005bnote@0040005d@00400020c@0040003a@0040005cxampp@0040005cmysql@0040005cbin@0040005cmysqld@0040002eexe@00.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2021@0040002d07@0040002d07@0040002010@0040003a18@0040003a39@004000200@00400020@0040005bnote@0040005d@00400020c@0040003a@0040005cxampp@0040005cmysql@0040005cbin@0040005cmysqld@0040002eexe@00.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2021@0040002d07@0040002d07@0040002010@0040003a18@0040003a39@004000200@00400020@0040005bnote@0040005d@00400020c@0040003a@0040005cxampp@0040005cmysql@0040005cbin@0040005cmysqld@0040002eexe@00.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Initialized Master_info from 'master-2021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@0020to@0020hash@0020table@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Added new Master_info '2021-07-07 10:18' to hash table\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@003a@0020start.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 10 [Note] Master '2021-07-07 10:18:39 0 [Note] c': Slave I/O thread: Start asynchronous replication to master '@:3306' ' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Started replication for '2021-07-07 10:' to hash tablec:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002011@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@00.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002011@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@00.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002011@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@00.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002011@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020sql@0020thread@0020initialized@00.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 11 [Note] Master '2021-07-07 10:18:39 0 [Note] c': Slave SQL thread initialized, starting replication in log 'FIRST' at' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005berror@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005berror@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005berror@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005berror@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@003a@0020fatal@0020error.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 10 [ERROR] Master '2021-07-07 10:18:39 0 [Note] ': Slave I/O: Fatal error: Invalid (empty) username when attempting to' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@0.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@0.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@0.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00400020@0.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariad' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connec.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connec.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connec.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020killed@0020while@0020connec.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 10 [Note] Master '2021-07-07 10:18:39 0 [Note] c' to hash tableread killed while connecting to master
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 10 [Note] Master '2021-07-07 10:18:39 0 [Note] c' to hash tableread exiting, read up to log 'FIRST', position 4
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002010@0020@005bnote@005d@0020master@0020@00272021@002d07@002d07@002010@003a18@003a39@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 10 [Note] Master '2021-07-07 10:18:39 0 [Note] c' to hash table3306ysqld.exe: ready for connections.
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002dversion@0040003a@00400020@0040002710@0040002e4@0040002e19@0040002dmariadb@00400027@00400020@00400020socket@0040003a@00400020@00400027@00400027@00400020@00400020port@0040003a@004000203306@00.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@00' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e19@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@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e19@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-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e19@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-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027version@003a@0020@002710@002e4@002e19@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-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Added new Master_info 'Version: '10.4.1' to hash tableket: '' port: 3306 mariadb.org binary distribution
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 12 [Note] Master 'Version: '10.4.19-MariaDB' so': Slave I/O thread: Start asynchronous replication to master '@:3306'' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e19@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@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00207@0020@005bnote@005d@0020started@0020replication@0020for@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 7 [Note] Started replication for 'Version: '10.4' to hash tableocket: '' port: 3306 mariadb.org binary distribution
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002013@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initializ.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002013@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initializ.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002013@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initializ.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002013@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020slave@0020sql@0020thread@0020initializ.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 13 [Note] Master 'Version: '10.4.19-MariaDB' so': Slave SQL thread initialized, starting replication in log 'FIRST' a' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info'
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info', errno 2)
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005berror@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 12 [ERROR] Master 'Version: '10.4.19-MariaDB' s': Slave I/O: Fatal error: Invalid (empty) username when attempting t' to hash table
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2021-07-09 9:26:30 7 [Note] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.info'
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 0 [Warning] Reading of some Master_info entries ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4nfo entries failed
2021-07-09 9:26:30 7 [Note] Started replication for '2021-07-09 8:31:59 0 [Warning] Reading of some Master_info entrie' failed
': 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@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005bwarning@005d@0020reading@0020of@0020some@0020master_info@0020entries@0020failed@000d.000007' position: 4
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info'
': Slave I/O thread killed while connecting to master1:59 0 [Warning] Reading of some Master_info entries failed
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info', errno 2)
': Slave I/O thread exiting, read up to log 'FIRST', position 4rning] Reading of some Master_info entries failed
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@0020.info' failed
': master was :3306 18 [Note] Master '2021-07-09 8:31:59 0 [Warning] Reading of some Master_info entries failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 12 [Note] Master 'Version: '10.4.19-MariaDB' so' to hash tableread killed while connecting to master
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2021-07-09 9:26:30 7 [Note] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.info'
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 0 [ERROR] Failed to initialize multi master stru' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 master structures
': 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-07-09 9:26:30 7 [Note] Started replication for '2021-07-09 8:31:59 0 [ERROR] Failed to initialize multi master st'uctures
': Slave I/O thread killed while connecting to master1:59 0 [ERROR] Failed to initialize multi master structures
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020failed@0020to@0020initialize@0020multi@0020master@0020structures@000d.000007' position: 4
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@002.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@002.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Failed to initialize multi master structures
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@002.info', errno 2)
': master was :3306 20 [Note] Master '2021-07-09 8:31:59 0 [ERROR] Failed to initialize multi master structures
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@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@002.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 12 [Note] Master 'Version: '10.4.19-MariaDB' so' to hash tableread exiting, read up to log 'FIRST', position 4
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020aborting@000d.info'
2021-07-09 9:26:30 7 [Note] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020aborting@000d.info'
' to hash table6:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 0 [ERROR] Aborting
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at 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
'021-07-09 9:26:30 7 [Note] Started replication for '2021-07-09 8:31:59 0 [ERROR] Aborting
': Slave I/O thread killed while connecting to master1:59 0 [ERROR] Aborting
2021-07-09 9:26:30 7 [Note] Reading Master_info: 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d07@002d09@0020@00208@003a31@003a59@00200@0020@005berror@005d@0020aborting@000d.000007' position: 4
': Slave I/O thread exiting, read up to log 'FIRST', position 4ROR] Aborting
2021-07-09 9:26:30 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info', errno 2)
': master was :3306 22 [Note] Master '2021-07-09 8:31:59 0 [ERROR] Aborting
2021-07-09 9:26:30 7 [ERROR] Initialized Master_info from 'master-2021@002d07@002d09@0020@00208@003a31@003a59@002012@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e19@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d@0027@003a@0020master@0020was@0020@003a3306@000d.info' failed
2021-07-09 9:26:30 7 [Note] Added new Master_info '2021-07-09 8:31:59 12 [Note] Master 'Version: '10.4.19-MariaDB' so' to hash table33066 mariadb.org binary distribution
2021-07-09 9:26:30 0 [Warning] Reading of some Master_info entries failed
2021-07-09 9:26:30 0 [ERROR] Failed to initialize multi master structures
2021-07-09 9:26:30 0 [ERROR] Aborting
Warning: Memory not freed: 256
Lambeck
 
Posts: 2
Joined: 08. July 2021 23:41
XAMPP version: 3.3.0
Operating System: Windows

Re: mysql error

Postby Altrea » 09. July 2021 11:09

Hi,

  • Open your folder "\xampp\mysql\data"
  • Delete the file "multi-master.info"
  • Delete all files beginning with "master-"
  • Delete all files beginning with "mysql_relay-bin-"
  • Delete all files beginning with "relay-log-"
  • Delete all files beginning with "ib_logfile"
  • Delete all files beginning with "aria_log."

Now try to start mariadb the normal way again.
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 143 guests