MySQL shutdown unexpectedly.

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

MySQL shutdown unexpectedly.

Postby prathameshc » 30. August 2020 09:04

2020-08-30 13:26:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-30 13:26:17 0 [Note] InnoDB: Uses event mutexes
2020-08-30 13:26:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-30 13:26:17 0 [Note] InnoDB: Number of pools: 1
2020-08-30 13:26:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-30 13:26:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-30 13:26:17 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-30 13:26:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-30 13:26:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-30 13:26:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-30 13:26:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-30 13:26:17 0 [Note] InnoDB: Waiting for purge to start
2020-08-30 13:26:17 0 [Note] InnoDB: 10.4.11 started; log sequence number 47170; transaction id 9
2020-08-30 13:26:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-30 13:26:17 0 [Note] InnoDB: Buffer pool(s) load completed at 200830 13:26:17
2020-08-30 13:26:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-30 13:26:17 0 [Note] Server socket created on IP: '::'.
2020-08-30 13:26:17 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1932: Table 'mysql.gtid_slave_pos' doesn't exist in engine
2020-08-30 13:26:17 7 [Note] Reading Master_info: 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-08-30 13:26:17 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-08-30 13:26:17 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000037' (relay_log_pos 4)
2020-08-30 13:26:17 7 [ERROR] Could not find target log during relay log initialization
2020-08-30 13:26:17 7 [ERROR] Initialized Master_info from 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2020-08-30 13:26:17 7 [Note] Added new Master_info '2020-07-15 19:57:47 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-08-30 13:26:17 7 [Note] Reading Master_info: 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-08-30 13:26:17 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000037' (relay_log_pos 4)
2020-08-30 13:26:17 7 [ERROR] Could not find target log during relay log initialization
2020-08-30 13:26:17 7 [ERROR] Initialized Master_info from 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
2020-08-30 13:26:17 7 [Note] Added new Master_info '2020-07-15 19:57:47 0 [Note] Added new Master_info '' to hash table
' to hash table
2020-08-30 13:26:17 7 [Note] Reading Master_info: 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-08-30 13:26:17 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000037' (relay_log_pos 4)
2020-08-30 13:26:17 7 [ERROR] Could not find target log during relay log initialization
2020-08-30 13:26:17 7 [ERROR] Initialized Master_info from 'master-2020@002d07@002d15@002019@003a57@003a47@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2020-08-30 13:26:17 7 [Note] Added new Master_info '2020-07-15 19:57:47 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2020-08-30 13:26:17 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-08-30 13:26:17 7 [ERROR] Failed to open the 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.000037' (relay_log_pos 4)
2020-08-30 13:26:17 7 [ERROR] Could not find target log during relay log initialization
2020-08-30 13:26:17 7 [ERROR] 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' failed
2020-08-30 13:26:17 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
' to hash table
2020-08-30 13:26:17 0 [Warning] Reading of some Master_info entries failed
2020-08-30 13:26:17 0 [ERROR] Failed to initialize multi master structures
2020-08-30 13:26:17 0 [ERROR] Aborting
prathameshc
 
Posts: 1
Joined: 30. August 2020 09:01
XAMPP version: 3.2.4
Operating System: Windows 10 Pro

Re: MySQL shutdown unexpectedly.

Postby stinnet » 01. September 2020 13:10

Try to delete all the master files in data directory
stinnet
 
Posts: 2
Joined: 01. September 2020 13:03
XAMPP version: v7.1.1-0
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 81 guests