MySQL Shutdown Unexpectedly Error, This is my log:

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

MySQL Shutdown Unexpectedly Error, This is my log:

Postby sonicavatar » 17. May 2023 05:58

I have been getting similar issues with MySQL not being able to start and becoming corrupt multiple times since upgrading to Windows 11 two months ago. And it's not due to other applications using the 3306 port.
Heads up, there is an issue here between Xampp and WIndows 11, that I can see, this is not user error. I have been using xampp on windows for 10 years.
First time I have encountered these issues during that 10 years and seems to be a regular occurrence now, probably due to something happening against the program's expectations while it is running (e.g. the computer going to sleep, or being shut down)
Have had to reinstall Xampp and do the whole database reinstall thing 3 times now over a period of 2 months due to these start up errors.
i have examined all logs, trawled the internet
Now I am on to my 4th issue, all similar, all not relating to another application using the port. Xampp says:

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

Log says (no errors indicating issue this time that I can see)
2023-05-17 14:41:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-05-17 14:41:27 0 [Note] InnoDB: Uses event mutexes
2023-05-17 14:41:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-05-17 14:41:27 0 [Note] InnoDB: Number of pools: 1
2023-05-17 14:41:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-05-17 14:41:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-05-17 14:41:27 0 [Note] InnoDB: Completed initialization of buffer pool
2023-05-17 14:41:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-05-17 14:41:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-05-17 14:41:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-05-17 14:41:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-05-17 14:41:28 0 [Note] InnoDB: Waiting for purge to start
2023-05-17 14:41:28 0 [Note] InnoDB: 10.4.27 started; log sequence number 2839293936; transaction id 265855
2023-05-17 14:41:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-05-17 14:41:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-05-17 14:41:28 0 [Note] InnoDB: Buffer pool(s) load completed at 230517 14:41:28
2023-05-17 14:41:28 0 [Note] Server socket created on IP: '::'.
sonicavatar
 
Posts: 3
Joined: 17. May 2023 05:43
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby sonicavatar » 23. May 2023 05:48

FYI, solution here: https://buildio.dev/error-mysql-shutdown-unexpectedly/
sonicavatar
 
Posts: 3
Joined: 17. May 2023 05:43
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby Altrea » 26. May 2023 11:23

FYI, please read the Forum Rules:

... If possible don't provide information on third party servers only (image hosters, paste code services, etc). If these services decide to turn of their service these informations are lost and your thread is less helpful for others. ...


Your "solutuion" is just a shot into the blue. Without knowing the true issue,i cannot recommend anybody to follow any fixing instructions.
Better to first try to start MariaDB as console application to get speaking error messages, like so:

  • Open a new XAMPP Shell by clicking the Shell Button in your control panel
  • type in the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
  • copy us the response of the console

After that there are multiple possible solutions (e.g. for the three most occuring errors multi-master, aria, mysql repair).

Best to register the Windows Service for MariaDB. If you set a windows ervice, XAMPP control will use that too to shutdown MariaDB much more clean than the default method.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby sonicavatar » 01. June 2023 23:37

So call it a "work around" if it bugs you.
It is one alternative to repeatedly reinstalling and backing up and resetting-up every database, which if you have xampp and windows 11, you may find yourself having to do, or are you not looking at the posts?
This work around comes inbuilt with a safe roll-back - is a safe experiment to see if you can save yourself 2 hours each day resetting up xampp and apache.
If we are talking "solutions" then maybe someone could focus on the issue that's causing Windows 11 and Xampp to fail repeatedly.
And if: you don't need to get work done, like wasting time, don't need to run databases, then no I wouldn't recommend anyone try this work around.
ps for others who are interested, setting Apache and MySQL to run as servers seems to prevent it from happening less.

"mysqld --defaults-file=mysql\bin\my.ini --standalone --console" .....
c:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-06-02 8:37: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.
2023-06-02 8:37:26 0 [Note] mysqld (mysqld 10.4.27-MariaDB) starting as process 14704 ...
2023-06-02 8:37:26 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-06-02 8:37:26 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-06-02 8:37:26 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-06-02 8:37:26 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-06-02 8:37:26 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-02 8:37:26 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-06-02 8:37:26 0 [ERROR] Aborting
sonicavatar
 
Posts: 3
Joined: 17. May 2023 05:43
XAMPP version: 3.3.0
Operating System: Windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby yusmurf » 02. June 2023 00:20

Your "solutuion" is just a shot into the blue. Without knowing the true issue,i cannot recommend anybody to follow any fixing instructions.
Better to first try to start MariaDB as console application to get speaking error messages, like so:

Open a new XAMPP Shell by clicking the Shell Button in your control panel
type in the following command

Code: Select all
mysqld --defaults-file=mysql\bin\my.ini --standalone --console

copy us the response of the console


After that there are multiple possible solutions (e.g. for the three most occuring errors multi-master, aria, mysql repair).

Best to register the Windows Service for MariaDB. If you set a windows ervice, XAMPP control will use that too to shutdown MariaDB much more clean than the default method.


I'm having the same issue as well. I ran the command in the xampp shell and I got the following response. Any solutions?


Code: Select all
2023-06-01 19:16:09 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.
2023-06-01 19:16:09 0 [Note] mysqld (mysqld 10.4.27-MariaDB) starting as process 9552 ...
2023-06-01 19:16:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-01 19:16:09 0 [Note] InnoDB: Uses event mutexes
2023-06-01 19:16:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-06-01 19:16:09 0 [Note] InnoDB: Number of pools: 1
2023-06-01 19:16:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-06-01 19:16:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-06-01 19:16:09 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-01 19:16:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-06-01 19:16:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-06-01 19:16:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-06-01 19:16:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-06-01 19:16:09 0 [Note] InnoDB: Waiting for purge to start
2023-06-01 19:16:09 0 [Note] InnoDB: 10.4.27 started; log sequence number 15205638; transaction id 7882
2023-06-01 19:16:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-06-01 19:16:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-01 19:16:09 0 [Note] Server socket created on IP: '::'.
2023-06-01 19:16:09 0 [Note] InnoDB: Buffer pool(s) load completed at 230601 19:16:09
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2023-06-01 19:16:09 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2023-06-01 19:16:09 7 [Note] Initialized Master_info from 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2023-06-01 19:16:09 7 [Note] Added new Master_info '2023-05-30 21:32:45 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
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-06-01 19:16:09 7 [Note] Started replication for '2023-05-30 21:32:45 0 [Note] Reading of all Master_info entries su'ceeded
': Slave I/O thread killed while connecting to master:45 0 [Note] Reading of all Master_info entries succeeded
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000008' position: 4
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
': master was :3306 8 [Note] Master '2023-05-30 21:32:45 0 [Note] Reading of all Master_info entries succeeded
2023-06-01 19:16:09 7 [Note] Initialized Master_info from 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table6:09 7 [Note] Added new Master_info '2023-05-30 21:32:45 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
2023-06-01 19:16:09 7 [Note] Started replication for '2023-05-30 21:32:45 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master2:45 0 [Note] Added new Master_info '' to hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000008' position: 4
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
': master was :3306 10 [Note] Master '2023-05-30 21:32:45 0 [Note] Added new Master_info '' to hash table
2023-06-01 19:16:09 7 [Note] Initialized Master_info from 'master-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2023-06-01 19:16:09 7 [Note] Added new Master_info '2023-05-30 21:32:45 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
2023-06-01 19:16:09 12 [ERROR] Master '2023-05-30 21:32:45 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-06-01 19:16:09 7 [Note] Started replication for '2023-05-30 21:32:45 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d05@002d30@002021@003a32@003a45@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000008' position: 4
': Slave I/O thread killed while connecting to master2:45 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e27@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@002e27@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] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306 12 [Note] Master '2023-05-30 21:32:45 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2023-06-01 19:16:09 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e27@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2023-06-01 19:16:09 7 [Note] Added new Master_info 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org bina' to hash table
2023-06-01 19:16:09 14 [Note] Master 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-06-01 19:16:09 14 [ERROR] Master 'Version: '10.4.27-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
2023-06-01 19:16:09 7 [Note] Started replication for 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org bi'ary distribution
2023-06-01 19:16:09 14 [Note] Master 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread killed while connecting to master
2023-06-01 19:16:09 15 [Note] Master 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e27@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000008' position: 4
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cscifi_world@005csearchindex@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'  Relay_info:'relay-log-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cscifi_world@005csearchindex@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2023-06-01 19:16:09 14 [Note] Master 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-06-01 19:16:09 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cscifi_world@005csearchindex@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 38)
2023-06-01 19:16:09 14 [Note] Master 'Version: '10.4.27-MariaDB'  socket: ''  port: 3306  mariadb.org binary distributio': master was :3306
2023-06-01 19:16:09 7 [ERROR] Initialized Master_info from 'master-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cscifi_world@005csearchindex@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2023-06-01 19:16:09 7 [Note] Added new Master_info '2023-05-30 22:44:20 220 [ERROR] mysqld.exe: Table '.\scifi_world\sea' to hash tablerked as crashed and should be repaired
2023-06-01 19:16:09 7 [Note] Reading Master_info: 'master-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cscifi_world@005csearchindex@0027@000d.info'  Relay_info:'relay-log-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cscifi_world@005csearchindex@0027@000d.info'
2023-06-01 19:16:09 7 [Note] Initialized Master_info from 'master-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cscifi_world@005csearchindex@0027@000d.info'
2023-06-01 19:16:09 7 [Note] Added new Master_info '2023-05-30 22:44:20 220 [Warning] Checking table:   '.\scifi_world\s' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4cifi_world\searchindex'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-06-01 19:16:09 7 [Note] Started replication for '2023-05-30 22:44:20 220 [Warning] Checking table:   '.\scifi_world'searchindex'
': Slave I/O thread killed while connecting to master4:20 220 [Warning] Checking table:   '.\scifi_world\searchindex'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d05@002d30@002022@003a44@003a20@0020220@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cscifi_world@005csearchindex@0027@000d.000008' position: 4
2023-06-01 19:16:09 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4Warning] Checking table:   '.\scifi_world\searchindex'
2023-06-01 19:16:09 0 [ERROR] Failed to initialize multi master structures
': master was :3306 16 [Note] Master '2023-05-30 22:44:20 220 [Warning] Checking table:   '.\scifi_world\searchindex'
2023-06-01 19:16:09 0 [ERROR] Aborting
Warning: Memory not freed: 256
yusmurf
 
Posts: 1
Joined: 02. June 2023 00:10
XAMPP version: 3.3.0
Operating System: Windows 10

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby stardustvega » 04. June 2023 12:48

Like the OP, this has happened to me repeatedly on Windows 11. It seems to most commonly happen if I forget to fully stop services and exit XAMPP before putting my PC into hibernation mode. I have not found a solution besides the workaround.
stardustvega
 
Posts: 1
Joined: 04. June 2023 12:41
XAMPP version: v3.3.0
Operating System: Windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby subrata » 08. June 2023 14:08

My first post in this group.

I had exactly the same error (in Windows 10). The fix:

1. Navigate to your XAMPP MySQL directory (C:\xampp\mysql). 2. Create a new folder called DATA_BROKEN and copy C:\xampp\mysql\backup and C:\xampp\mysql\data into this folder. 3. Paste the contents of C:\xampp\mysql\backup into C:\xampp\mysql\data, overwriting all the files. Note the dates may be older that your most recent activity. 4. Copy the ibdata1 file from C:\xampp\mysql\DATA_BROKEN \data into C:\xampp\mysql\data overwriting the file. 5. Then start MySQL (after starting xampp).

worked flawlessly. Thank you! :P :P
subrata
 
Posts: 1
Joined: 08. June 2023 13:29
XAMPP version: 3.3.0
Operating System: Windows 10

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby avaalbertreo » 22. June 2023 10:38

Based on the information you provided, it seems that you are experiencing issues with MySQL not starting properly on Windows 11 after upgrading and using XAMPP. While it's difficult to pinpoint the exact cause without more information, I can offer some general troubleshooting steps you can try:

Check for conflicting applications: Even though you mentioned that it's not due to other applications using the 3306 port, it's worth double-checking if any other programs are conflicting with MySQL. You can use the following command in Command Prompt to check for port usage: netstat -ano | findstr :3306. It will display the process ID (PID) of the application using the port. You can then check the Task Manager to see which application corresponds to that PID.

Run XAMPP as an administrator: Sometimes, permission issues can prevent MySQL from starting properly. Right-click on the XAMPP shortcut/icon and choose "Run as administrator" to ensure it has the necessary privileges.

Verify file and folder permissions: Make sure the XAMPP and MySQL files and folders have the correct permissions. Ensure that the user account you're using has appropriate read/write permissions for the XAMPP installation directory and the MySQL data directory.

Disable Windows sleep/hibernation settings: Windows sleep or hibernation modes can interfere with running applications. Try disabling these features temporarily and see if it resolves the issue. You can adjust these settings in the Power Options section of the Windows Control Panel.

Temporarily disable antivirus/firewall software: Antivirus or firewall software may block MySQL from running or accessing necessary files. Temporarily disable any such software and check if MySQL starts correctly. If it does, you may need to configure your security software to allow MySQL.

Check the Windows Event Viewer: The Windows Event Viewer can provide more detailed information about the error. Open the Event Viewer, navigate to the "Windows Logs" section, and look for any entries related to MySQL or XAMPP. These entries may provide additional clues about the cause of the issue.

Reinstall XAMPP: If none of the above steps resolve the problem, you might consider reinstalling XAMPP. Before doing so, ensure you have backups of your MySQL databases and configuration files. Uninstall XAMPP completely, delete any remaining XAMPP-related folders, and then reinstall the latest version from the official website.
avaalbertreo
 
Posts: 1
Joined: 22. June 2023 10:34
XAMPP version: 8.2.4, 8.1.17
Operating System: window 10 pro

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby bimaroym » 12. October 2023 01:53

I have followed this command and a message appears like this
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-10-12 7:50:07 0 [Note] mysqld (mysqld 10.4.20-MariaDB) starting as process 6928 ...
2023-10-12 7:50:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-12 7:50:07 0 [Note] InnoDB: Uses event mutexes
2023-10-12 7:50:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-12 7:50:07 0 [Note] InnoDB: Number of pools: 1
2023-10-12 7:50:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-10-12 7:50:07 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2023-10-12 7:50:07 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-12 7:50:07 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56252567
2023-10-12 7:50:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-10-12 7:50:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-10-12 7:50:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-12 7:50:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-12 7:50:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-10-12 7:50:07 0 [Note] InnoDB: Waiting for purge to start
2023-10-12 7:50:07 0 [Note] InnoDB: 10.4.20 started; log sequence number 56252576; transaction id 29884
2023-10-12 7:50:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-10-12 7:50:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-12 7:50:07 0 [Note] Server socket created on IP: '::'.
2023-10-12 7:50:07 0 [Note] InnoDB: Buffer pool(s) load completed at 231012 7:50:07
2023-10-12 7:50:07 0 [Note] Reading of all Master_info entries succeeded
2023-10-12 7:50:07 0 [Note] Added new Master_info '' to hash table
2023-10-12 7:50:07 0 [Note] mysqld: ready for connections.
Version: '10.4.20-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2023-10-12 7:50:12 8 [Warning] IP address '192.168.0.83' has been resolved to the host name '83.0.168.192.in-addr.arpa', which resembles IPv4-address itself.
bimaroym
 
Posts: 3
Joined: 12. October 2023 01:31
XAMPP version: V3.3.0
Operating System: Window 10 Home Edition

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby bimaroym » 12. October 2023 01:59

... If possible don't provide information on third party servers only (image hosters, paste code services, etc). If these services decide to turn of their service these informations are lost and your thread is less helpful for others. ...


Your "solutuion" is just a shot into the blue. Without knowing the true issue,i cannot recommend anybody to follow any fixing instructions.
Better to first try to start MariaDB as console application to get speaking error messages, like so:

  • Open a new XAMPP Shell by clicking the Shell Button in your control panel
  • type in the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
  • copy us the response of the console

After that there are multiple possible solutions (e.g. for the three most occuring errors multi-master, aria, mysql repair).

Best to register the Windows Service for MariaDB. If you set a windows ervice, XAMPP control will use that too to shutdown MariaDB much more clean than the default method.[/quote]

I get message Error :
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-10-12 7:58:36 0 [Note] mysqld (mysqld 10.4.20-MariaDB) starting as process 2204 ...
2023-10-12 7:58:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-12 7:58:36 0 [Note] InnoDB: Uses event mutexes
2023-10-12 7:58:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-12 7:58:36 0 [Note] InnoDB: Number of pools: 1
2023-10-12 7:58:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-10-12 7:58:36 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2023-10-12 7:58:36 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-12 7:58:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56252621
2023-10-12 7:58:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-10-12 7:58:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-10-12 7:58:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-12 7:58:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-12 7:58:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-10-12 7:58:37 0 [Note] InnoDB: Waiting for purge to start
2023-10-12 7:58:37 0 [Note] InnoDB: 10.4.20 started; log sequence number 56252630; transaction id 29884
2023-10-12 7:58:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-10-12 7:58:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-12 7:58:37 0 [Note] Server socket created on IP: '::'.
2023-10-12 7:58:37 0 [Note] InnoDB: Buffer pool(s) load completed at 231012 7:58:37
2023-10-12 7:58:37 0 [Note] Reading of all Master_info entries succeeded
2023-10-12 7:58:37 0 [Note] Added new Master_info '' to hash table
2023-10-12 7:58:37 0 [Note] mysqld: ready for connections.
Version: '10.4.20-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
bimaroym
 
Posts: 3
Joined: 12. October 2023 01:31
XAMPP version: V3.3.0
Operating System: Window 10 Home Edition

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby trejder » 23. October 2023 14:06

In "mysql\bin" folder I have found a file called "[username].err" where "[username]" is Windows username. Its contents showed what was the true nature of the problem in my case:

Code: Select all
Cannot find checkpoint record at LSN (1,0x5dd7)
[ERROR] Plugin 'Aria' init function returned error.
[ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.

And also has suggested the possible solution:

Code: Select all
[ERROR] mysqld: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files

I did not tried neither this solution nor the one described above. Instead, I simply updated my MariaDB database version to the newest one.

This solution seems to be working (at least for now). I only had to do some magic on my MariaDB users because newest MariaDB server is using different authentication method (GSSAPI plugin) instead of the old version (native MySQL authentication).

More information here: https://serverfault.com/a/1146397/127070 and here: https://onezeronull.com/2023/10/23/auth ... he-client/
trejder
 
Posts: 68
Joined: 13. April 2008 06:45

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby Jellysem » 01. November 2023 10:15

bimaroym wrote:
... If possible don't provide information on third party servers only (image hosters, paste code services, etc). If these services decide to turn of their service these informations are lost and your thread is less helpful for others. ...


Your "solutuion" is just a shot into the blue. Without knowing the true issue,i cannot recommend anybody to follow any fixing instructions.
Better to first try to start MariaDB as console application to get speaking error messages, like so:

  • Open a new XAMPP Shell by clicking the Shell Button in your control panel
  • type in the following command
    Code: Select all
    mysqld --defaults-file=mysql\bin\my.ini --standalone --console
  • copy us the response of the console

After that there are multiple possible solutions (e.g. for the three most occuring errors multi-master, aria, mysql repair).

Best to register the Windows Service for MariaDB. If you set a windows ervice, XAMPP control will use that too to shutdown MariaDB much more clean than the default method.


I get message Error :
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-10-12 7:58:36 0 [Note] mysqld (mysqld 10.4.20-MariaDB) starting as process 2204 ...
2023-10-12 7:58:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-10-12 7:58:36 0 [Note] InnoDB: Uses event mutexes
2023-10-12 7:58:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-10-12 7:58:36 0 [Note] InnoDB: Number of pools: 1
2023-10-12 7:58:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-10-12 7:58:36 0 [Note] InnoDB: Initializing buffer pool, total size = 2G, instances = 8, chunk size = 128M
2023-10-12 7:58:36 0 [Note] InnoDB: Completed initialization of buffer pool
2023-10-12 7:58:36 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=56252621
2023-10-12 7:58:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-10-12 7:58:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-10-12 7:58:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-10-12 7:58:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-10-12 7:58:37 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-10-12 7:58:37 0 [Note] InnoDB: Waiting for purge to start
2023-10-12 7:58:37 0 [Note] InnoDB: 10.4.20 started; log sequence number 56252630; transaction id 29884
2023-10-12 7:58:37 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-10-12 7:58:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-10-12 7:58:37 0 [Note] Server socket created on IP: '::'.
2023-10-12 7:58:37 0 [Note] InnoDB: Buffer pool(s) load completed at 231012 7:58:37
2023-10-12 7:58:37 0 [Note] Reading of all Master_info entries succeeded
2023-10-12 7:58:37 0 [Note] Added new Master_info '' to hash table
2023-10-12 7:58:37 0 [Note] mysqld: ready for connections.
Version: '10.4.20-MariaDB' socket: '' port: 3306 mariadb.org binary distribution[/quote]





I do recommend the solution. I am at school learning stuff about mysql and this saved my work. for the guy that came up with this solution, thank you very much :D
Jellysem
 
Posts: 1
Joined: 01. November 2023 09:52
XAMPP version: 8.2.4
Operating System: Windows

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby oge » 01. November 2023 21:21

mysqld --defaults-file=mysql\bin\my.ini --standalone --console
Setting environment for using XAMPP for Windows.
Emperor@EMPEROR-PC c:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-11-01 21:16:53 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.
2023-11-01 21:16:53 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 2852
2023-11-01 21:16:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-01 21:16:53 0 [Note] InnoDB: Uses event mutexes
2023-11-01 21:16:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-01 21:16:53 0 [Note] InnoDB: Number of pools: 1
2023-11-01 21:16:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-01 21:16:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-01 21:16:53 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-01 21:16:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-01 21:16:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-01 21:16:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-01 21:16:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-01 21:16:54 0 [Note] InnoDB: 10.4.28 started; log sequence number 300396; transaction id 170
2023-11-01 21:16:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-01 21:16:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-01 21:16:54 0 [Note] Server socket created on IP: '::'.
2023-11-01 21:16:54 0 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'
2023-11-01 21:16:54 0 [ERROR] Aborting

how can i solve this please
oge
 
Posts: 1
Joined: 01. November 2023 18:56
XAMPP version: 3.3
Operating System: windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby edmundotrc » 06. November 2023 22:36

Hello everybody

I been creating a website using Wordpress Elementor Pro during the last two months, and I been using XAMPP Control Panel v3.3.0 (Apache & mysql) since the beginning)
only had couple issues that I don't consider that important, except for one two days ago.

The thing is that I was getting some messages while login into Wordpress (https://localhost/wordpress-6.3/wordpress/wp-login) saying that the URL was NOT secure, then
I had the idea of getting a CSR for SSL, etc. but before doing that I said to myself, maybe I should partially change (modify) the "site URL" (NOT Wordpress URL) and I went to
the Wordpress ... panel/settings and modified the URL this way ... form: "https://localhost/wordpress-6.3/wordpress" ... to: "https://localhost/wordpress-63/wordpress"
saved and logout from Wordpress and restarted XAMPP ... and since that moment mysql is NOT coming-up ... always generating the following in XAMPP console ...
==========================================================================
3:39:05 PM [mysql] Status change detected: running
3:39:07 PM [mysql] Status change detected: stopped
3:39:07 PM [mysql] Error: MySQL shutdown unexpectedly.
3:39:07 PM [mysql] This may be due to a blocked port, missing dependencies,
3:39:07 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:39:07 PM [mysql] Press the Logs button to view error logs and check
3:39:07 PM [mysql] the Windows Event Viewer for more clues
3:39:07 PM [mysql] If you need more help, copy and post this
3:39:07 PM [mysql] entire log window on the forums
==========================================================================

I tried multiple things after reading different opinion even in Wordpress library, like possible problems with ... the port, firewall, etc. and any of those seems the root problem.

After coming to this site, I found the following recommendation in order to obtain more information about the problem ... and I did run from XAMPP shell

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

I obtained a really long result (a bunch of information), which I believe that an expert in your side could understand, decipher and recommend a solution.

==============================================================================================================================================================================
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2023-11-06 15:16:07 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.
2023-11-06 15:16:07 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 24252
2023-11-06 15:16:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-11-06 15:16:07 0 [Note] InnoDB: Uses event mutexes
2023-11-06 15:16:07 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-11-06 15:16:07 0 [Note] InnoDB: Number of pools: 1
2023-11-06 15:16:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-11-06 15:16:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-11-06 15:16:07 0 [Note] InnoDB: Completed initialization of buffer pool
2023-11-06 15:16:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-11-06 15:16:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-11-06 15:16:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-11-06 15:16:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-11-06 15:16:07 0 [Note] InnoDB: Waiting for purge to start
2023-11-06 15:16:07 0 [Note] InnoDB: 10.4.28 started; log sequence number 725568084; transaction id 617731
2023-11-06 15:16:07 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-11-06 15:16:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-11-06 15:16:07 0 [Note] Server socket created on IP: '::'.
2023-11-06 15:16:07 0 [Note] InnoDB: Buffer pool(s) load completed at 231106 15:16:07
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay-log.info'
2023-11-06 15:16:07 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '' to hash table
2023-11-06 15:16:07 8 [Note] Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 42023-11-06 15:16:07 8 [ERROR] Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-11-06 15:16:07 7 [Note] Started replication for ''
2023-11-06 15:16:07 8 [Note] Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 9 [Note] Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin.000013' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2023-11-06 15:16:07 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 8 [Note] master was :3306
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 0:13:11 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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 0:13:11 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-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000003' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master3:11 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
': master was :3306 10 [Note] Master '2023-11-05 0:13:11 0 [Note] Added new Master_info '' to hash table
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.2023-11-06 15:16:07 12 [ERROR] Master '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
': Slave I/O thread killed while connecting to master3:11 0 [Note] c:\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-2023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000013' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e28@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@002e28@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] c:\xampp\mysql\bin\mysqld.exe: ready for connections.': master was :3306 12 [Note] Master '2023-11-05 0:13:11 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2023-11-06 15:16:07 14 [Note] Master 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-11-06 15:16:07 14 [ERROR] Master 'Version: '10.4.28-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
2023-11-06 15:16:07 7 [Note] Started replication for 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org bi'ary distribution
2023-11-06 15:16:07 15 [Note] Master 'Version: '10.4.28-MariaDB' socket: '' port: 3306 mariadb.org binary distributio': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e28@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013' position: 4

... CUT SOMETHING HERE

2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info'
2023-11-06 15:16:07 16 [Note] Master '2023-11-05 1:15:33 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info', errno 38)
2023-11-06 15:16:07 16 [Note] Master '2023-11-05 1:15:33 7 [Note] Reading Master_info: 'master.info' Relay_info:'relay': master was :3306
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bwarning@005d@0020neither@0020@002d@002drelay@002dlog@0020nor@0020@002d@002drelay@002dlog@002dindex@0020were@0020used@003b@0020so@0020replication@0020may@0020break@0020when@0020this@0020mariadb@0020server@0020acts@0020as@0020a@0020replica@0020and@0020has@0020it.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please us' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.in' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4m 'master.info'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.'nfo'
': Slave I/O thread killed while connecting to master5:33 7 [Note] Initialized Master_info from 'master.info'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002einfo@0027@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Initialized Master_info from 'master.info'
': master was :3306 18 [Note] Master '2023-11-05 1:15:33 7 [Note] Initialized Master_info from 'master.info'
': Error in Log_event::read_log_event(): 'Event truncated', data_len: 824188981, event_type: 45 hash table
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 7 [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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 7 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master5:33 7 [Note] Added new Master_info '' to hash table
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@003a@0020start@0020asynchronous@0020replication@0020to@0020master@0020@0027@0040@003a3306@0027@0020in@0020log@0020@0027@0027@0020at@0020position@00204@000d.info', errno 38)
'
... CUT SOMETHING HERE ...

': Slave I/O thread killed while connecting to master5:33 7 [Note] Started replication for ''
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Started replication for ''
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info', errno 38)
': master was :3306 22 [Note] Master '2023-11-05 1:15:33 7 [Note] Started replication for ''
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00209@0020@005bnote@005d@0020slave@0020sql@0020thread@0020initialized@002c@0020starting@0020replication@0020in@0020log@0020@0027first@0027@0020at@0020position@00200@002c@0020relay@0020log@0020@0027@002e@005cmysql@002drelay@002dbin@002e000003@0027@0020position@003a@00204@000d.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 9 [Note] Slave SQL thread initialized, starting ' to hash tablelog 'FIRST' at position 0, relay log '.\mysql-relay-bin.000003' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005berror@005d@0020slave@0020i@002fo@003a@0020fatal@0020error@003a@0020invalid@0020@0028empty@0029@0020username@0020when@0020attempting@0020to@0020connect@0020to@0020the@0020master@0020server@002e@0020connection@0020attempt@0020terminated@002e@0020internal@0020mar.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [ERROR] Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00207@0020@005bnote@005d@0020reading@0020master_info@003a@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@00400020to@0040.info' R

... CUT SOMETHING HERE ...

': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Slave I/O thread killed while connecting to master
': master was :3306 24 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@0027@002c@0020position@00204@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to lo' to hash tabletion 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-11-06 15:16:07 26 [ERROR] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', po': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to 'og 'FIRST', position 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread killed while connecting to master
2023-11-06 15:16:07 27 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020slave@0020i@002fo@0020thread@0020exiting@002c@0020read@0020up@0020to@0020log@0020@0027first@0027@002c@0020position@00204@000d.000009' position: 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info'
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 26 [Note] Master '2023-11-05 1:15:33 8 [Note] Slave I/O thread exiting, read up to log 'FIRST', pos': master was :3306
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:33 8 [Note] master was :3306
': 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
'023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:33 8 [Note] master was :3306
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a33@00208@0020@005bnote@005d@0020master@0020was@0020@003a3306@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:33 8 [Note] master was :3306
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] master was :3306
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@00207@0020@005bnote@005d@0020initialized@0020master_info@0020from@0020@0027master@002d2023@0040002d11@0040002d05@00400020@004000200@0040003a13@0040003a11@004000200@00400020@0040005bnote@0040005d@00400020added@00400020new@00400020master_info@00400020@00400027@00400027@0040002.info', errno 38)

... CUT SOMETHING HERE ...

2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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 exiting, read up to log 'FIRST', position 4te] Reading of all Master_info entries succeeded
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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 38)
': master was :3306 30 [Note] Master '2023-11-05 1:15:34 0 [Note] Reading of all Master_info entries succeeded
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash tableread killed while connecting to master
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.info'
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info fai' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ter_info 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
2023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info f'iled
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020adding@0020new@0020entry@0020@0027@0027@0020to@0020master_info@0020failed@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:34 0 [ERROR] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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 38)
': master was :3306 32 [Note] Master '2023-11-05 1:15:34 0 [ERROR] Adding new entry '' to master_info failed
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash tableread exiting, read up to log 'FIRST', position 4
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info'
2023-11-06 15:16:07 7 [Note] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.info'
' to hash table6:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 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
'023-11-06 15:16:07 7 [Note] Started replication for '2023-11-05 1:15:34 0 [ERROR] Aborting
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d11@002d05@0020@00201@003a15@003a34@00200@0020@005berror@005d@0020aborting@000d.000009' position: 4
': Slave I/O thread killed while connecting to master5:34 0 [ERROR] Aborting
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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 I/O thread exiting, read up to log 'FIRST', position 4ROR] Aborting
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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 38)
': master was :3306 34 [Note] Master '2023-11-05 1:15:34 0 [ERROR] Aborting
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002014@0020@005bnote@005d@0020master@0020@0027version@003a@0020@002710@002e4@002e28@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
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 14 [Note] Master 'Version: '10.4.28-MariaDB' so' to hash table33066 mariadb.org binary distribution
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020in@0020log_event@003a@003aread_log_event@0028@0029@003a.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 11 [ERROR] Master '2023-11-05 0:13:11 0 [Note] ': Error in Log_event::read_log_event(): 'Event truncated', data_len: 824188981, even' to hash table
2023-11-06 15:16:07 7 [Note] Reading Master_info: 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info' Relay_info:'relay-log-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info'
2023-11-06 15:16:07 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info', errno 38)
2023-11-06 15:16:07 7 [ERROR] Initialized Master_info from 'master-2023@002d11@002d05@0020@00201@003a15@003a34@002011@0020@005berror@005d@0020master@0020@00272023@002d11@002d05@0020@00200@003a13@003a11@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d@0027@003a@0020error@0020reading@0020relay@0020log@0020event@003a@0020slave@0020sql@0.info' failed
2023-11-06 15:16:07 7 [Note] Added new Master_info '2023-11-05 1:15:34 11 [ERROR] Master '2023-11-05 0:13:11 0 [Note] ' to hash tableg relay log event: slave SQL thread aborted because of I/O error
2023-11-06 15:16:07 0 [Warning] Reading of some Master_info entries failed
2023-11-06 15:16:07 0 [ERROR] Failed to initialize multi master structures
2023-11-06 15:16:07 0 [ERROR] Aborting
=============================================================================================================================================================================
Sorry for lengthy log. (Your system only allows 60,000 and this log is over 85,000) NOT sure I cut (eliminated) part of the vital info.

Please, let me know if there a way to obtain more precise information for a solution.
I am really behind in finishing this website project, and I am stuck now!

I read that seems like that none of you use remote services to help, but I do have the Zoom utility where I can create a session and opened (share) to someone who my able to help.

Thank you in advance!
edmundotrc
 
Posts: 1
Joined: 06. November 2023 21:50
XAMPP version: v3.3.0
Operating System: Windows 11

Re: MySQL Shutdown Unexpectedly Error, This is my log:

Postby Altrea » 06. November 2023 23:09

Hi edmundotrc,

Thanks for providing detailed debug information.
I call this the multi-master error. Your MariaDB thinks it is running in master replicant setting.

Please try the following fix. It already helped lots of users solving the multi-master Problem:

  • 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-"

Now try to start mariadb the normal way again.

best wishes,
Altrea
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 101 guests