Another sudden MySQL shutdown unexpectedly (MariaDB)

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

Another sudden MySQL shutdown unexpectedly (MariaDB)

Postby cacti » 01. July 2020 06:01

Worked yesterday, PC shutdown normally, next day MySQL error. According to Windows 10 log, no Windows updates had been installed.
Windows 10 Pro 1909, xampp-windows-x64-7.4.1-0-VC15

Nothing is blocking port 3306, deleted C:\xampp\mysql\data\aria_log.00000001 but didn't help.
MySql/MariaDB is installed as service via Xampp Control 3.2.4.

HELP! Hopefully there's a solution without restoring backups or new install.

Error log:
Code: Select all
InnoDB: using atomic writes.
2020-07-01 16:26:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-07-01 16:26:02 0 [Note] InnoDB: Uses event mutexes
2020-07-01 16:26:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-07-01 16:26:02 0 [Note] InnoDB: Number of pools: 1
2020-07-01 16:26:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-07-01 16:26:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-07-01 16:26:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-07-01 16:26:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-07-01 16:26:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-07-01 16:26:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-07-01 16:26:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-07-01 16:26:03 0 [Note] InnoDB: 10.4.11 started; log sequence number 325201554; transaction id 316208
2020-07-01 16:26:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-07-01 16:26:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-07-01 16:26:03 0 [Note] Server socket created on IP: '::'.
2020-07-01 16:26:03 0 [Note] InnoDB: Buffer pool(s) load completed at 200701 16:26:03
2020-07-01 16:26:03 7 [Note] Reading Master_info: 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-07-01 16:26:03 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2020-07-01 16:26:03 7 [ERROR] log 2020-06-30 10:16:51 7 [Note] Initialized Master_info from 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
 listed in the index, but failed to stat
2020-07-01 16:26:03 7 [ERROR] Error counting relay log space
2020-07-01 16:26:03 7 [ERROR] Initialized Master_info from 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2020-07-01 16:26:03 7 [Note] Added new Master_info '2020-06-23  9:25:18 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-07-01 16:26:03 7 [Note] Reading Master_info: 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-07-01 16:26:03 7 [Note] Initialized Master_info from 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-07-01 16:26:03 7 [Note] Added new Master_info '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to hash table
' to hash table
2020-07-01 16:26:03 8 [Note] Master '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-07-01 16:26:03 7 [Note] Started replication for '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to hash table
'
2020-07-01 16:26:03 9 [Note] Master '2020-06-23  9:25:18 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-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000016' position: 4
2020-07-01 16:26:03 8 [ERROR] Master '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to 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
2020-07-01 16:26:03 7 [Note] Reading Master_info: 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-07-01 16:26:03 8 [Note] Master '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
2020-07-01 16:26:03 8 [Note] Master '2020-06-23  9:25:18 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-07-01 16:26:03 7 [Note] Initialized Master_info from 'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-07-01 16:26:03 7 [Note] Added new Master_info '2020-06-23  9:25:18 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2020-07-01 16:26:03 10 [Note] Master '2020-06-23  9:25:18 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-07-01 16:26:03 7 [Note] Started replication for '2020-06-23  9:25:18 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
2020-07-01 16:26:03 11 [Note] Master '2020-06-23  9:25:18 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-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000016' position: 4
2020-07-01 16:26:03 10 [ERROR] Master '2020-06-23  9:25:18 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
2020-07-01 16:26:03 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'  Relay_info:'relay-log-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-07-01 16:26:03 10 [Note] Master '2020-06-23  9:25:18 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
2020-07-01 16:26:03 10 [Note] Master '2020-06-23  9:25:18 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-07-01 16:26:03 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-07-01 16:26:03 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
' to hash table
2020-07-01 16:26:03 12 [Note] Master 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-07-01 16:26:03 7 [Note] Started replication for 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
'
2020-07-01 16:26:03 13 [Note] Master 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000016' position: 4
2020-07-01 16:26:03 12 [ERROR] Master 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-07-01 16:26:03 0 [Warning] Reading of some Master_info entries failed
2020-07-01 16:26:03 12 [Note] Master 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2020-07-01 16:26:03 0 [ERROR] Failed to initialize multi master structures
2020-07-01 16:26:03 12 [Note] Master 'Version: '10.4.11-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-07-01 16:26:03 0 [ERROR] Aborting
cacti
 
Posts: 3
Joined: 01. July 2020 05:23
XAMPP version: 7.4.1
Operating System: Windows 10 Pro 1909

Re: Another sudden MySQL shutdown unexpectedly (MariaDB)

Postby cacti » 03. July 2020 00:58

I found a solution, might help someone in the future. I deleted these all the files that showed up in the error message manually from the /mysql/data/ folder and then it worked again.

E.g. deleted files looking like this:
Code: Select all
'master-2020@002d06@002d23@0020@00209@003a25@003a18@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info


But KEEP the other files like:
Code: Select all
aria_log*
ib_buffer_pool
ib_logfile*
ibdata1
ibtmp1
multi-master.info
mysql.pid
mysql_error.log
cacti
 
Posts: 3
Joined: 01. July 2020 05:23
XAMPP version: 7.4.1
Operating System: Windows 10 Pro 1909

Re: Another sudden MySQL shutdown unexpectedly (MariaDB)

Postby cacti » 03. July 2020 04:06

:? Unfortunately, it's not working properly. When I start mysql via Xampp Controll panel then I get the problems again - also if I install/start it as a service via Xampp Control.
I can get it running from command line with this:
mysqld –-console –-skip-grant-tables –-skip-external-locking


Since this seems to override some default settings which you normally won't do....maybe someone has an idea why mysql is not running anymore when starting via Xampp...
cacti
 
Posts: 3
Joined: 01. July 2020 05:23
XAMPP version: 7.4.1
Operating System: Windows 10 Pro 1909


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 86 guests