ERROR: MySQL shutdown unexpectedly

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

ERROR: MySQL shutdown unexpectedly

Postby Mikee058 » 17. August 2021 23:56

For some reason I get this error all of a sudden, here's the logs:

2021-08-18 0:49:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-08-18 0:49:41 0 [Note] InnoDB: Uses event mutexes
2021-08-18 0:49:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-08-18 0:49:41 0 [Note] InnoDB: Number of pools: 1
2021-08-18 0:49:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-08-18 0:49:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-08-18 0:49:41 0 [Note] InnoDB: Completed initialization of buffer pool
2021-08-18 0:49:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-08-18 0:49:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-08-18 0:49:41 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-08-18 0:49:41 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-08-18 0:49:41 0 [Note] InnoDB: Waiting for purge to start
2021-08-18 0:49:41 0 [Note] InnoDB: 10.4.18 started; log sequence number 384070; transaction id 310
2021-08-18 0:49:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-08-18 0:49:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-08-18 0:49:41 0 [Note] Server socket created on IP: '::'.
2021-08-18 0:49:41 0 [Note] InnoDB: Buffer pool(s) load completed at 210818 0:49:41
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 0:49:41 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2021-08-18 0:49:41 7 [Note] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2021-08-18 0:49:41 8 [Note] Master '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-18 0:49:41 7 [Note] Started replication for '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
'
2021-08-18 0:49:41 9 [Note] Master '2021-08-14 17:29:50 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-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000013' position: 4
2021-08-18 0:49:41 8 [ERROR] Master '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-08-18 0:49:41 8 [Note] Master '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread killed while connecting to master
2021-08-18 0:49:41 8 [Note] Master '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-18 0:49:41 8 [Note] Master '2021-08-14 17:29:50 0 [Note] Reading of all Master_info entries succeeded
': master was :3306
2021-08-18 0:49:41 7 [Note] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
' to hash table
2021-08-18 0:49:41 10 [Note] Master '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-18 0:49:41 7 [Note] Started replication for '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
'
2021-08-18 0:49:41 11 [Note] Master '2021-08-14 17:29:50 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-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000013' position: 4
2021-08-18 0:49:41 10 [ERROR] Master '2021-08-14 17:29:50 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
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-18 0:49:41 10 [Note] Master '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
2021-08-18 0:49:41 10 [Note] Master '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-18 0:49:41 10 [Note] Master '2021-08-14 17:29:50 0 [Note] Added new Master_info '' to hash table
': master was :3306
2021-08-18 0:49:41 7 [Note] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:29:50 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2021-08-18 0:49:41 12 [Note] Master '2021-08-14 17:29:50 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
2021-08-18 0:49:41 7 [Note] Started replication for '2021-08-14 17:29:50 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
2021-08-18 0:49:41 13 [Note] Master '2021-08-14 17:29:50 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-2021@002d08@002d14@002017@003a29@003a50@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000013' position: 4
2021-08-18 0:49:41 12 [ERROR] Master '2021-08-14 17:29:50 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
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e18@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@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-08-18 0:49:41 12 [Note] Master '2021-08-14 17:29:50 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
2021-08-18 0:49:41 12 [Note] Master '2021-08-14 17:29:50 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-18 0:49:41 12 [Note] Master '2021-08-14 17:29:50 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306
2021-08-18 0:49:41 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-08-18 0:49:41 7 [Note] Added new Master_info 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
' to hash table
2021-08-18 0:49:41 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-18 0:49:41 7 [Note] Started replication for 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
2021-08-18 0:49:41 15 [Note] Master 'Version: '10.4.18-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@002e18@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013' position: 4
2021-08-18 0:49:41 14 [ERROR] Master 'Version: '10.4.18-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
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2021-08-18 0:49:41 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info', errno 2)
2021-08-18 0:49:41 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2021-08-18 0:49:41 14 [Note] Master 'Version: '10.4.18-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': master was :3306
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:21 8 [ERROR] mysqld.exe: Table '.\fivem@002dframework\characters_house_plants' is marked as crashed and should be repaired
' to hash table
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@000d.info'
2021-08-18 0:49:41 7 [Note] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@000d.info'
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
' to hash table
2021-08-18 0:49:41 16 [Note] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-08-18 0:49:41 7 [Note] Started replication for '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
'
2021-08-18 0:49:41 17 [Note] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d08@002d14@002017@003a32@003a21@00208@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005cfivem@0040002dframework@005ccharacters_house_plants@0027@000d.000013' position: 4
2021-08-18 0:49:41 16 [ERROR] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a34@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a34@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-08-18 0:49:41 16 [Note] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': Slave I/O thread killed while connecting to master
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a34@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-08-18 0:49:41 16 [Note] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a34@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-08-18 0:49:41 16 [Note] Master '2021-08-14 17:32:21 8 [Warning] Checking table: '.\fivem@002dframework\characters_house_plants'
': master was :3306
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:34 8 [Warning] Aborted connection 8 to db: 'fivem-framework' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a34@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a34@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a34@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a34@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:34 9 [Warning] Aborted connection 9 to db: 'fivem-framework' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a34@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a34@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a34@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a34@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:34 10 [Warning] Aborted connection 10 to db: 'fivem-framework' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a34@002012@0020@005bwarning@005d@0020aborted@0020connection@002012@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a34@002012@0020@005bwarning@005d@0020aborted@0020connection@002012@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a34@002012@0020@005bwarning@005d@0020aborted@0020connection@002012@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a34@002012@0020@005bwarning@005d@0020aborted@0020connection@002012@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:34 12 [Warning] Aborted connection 12 to db: 'fivem-framework' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2021-08-18 0:49:41 7 [Note] Reading Master_info: 'master-2021@002d08@002d14@002017@003a32@003a34@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d08@002d14@002017@003a32@003a34@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-08-18 0:49:41 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d08@002d14@002017@003a32@003a34@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-08-18 0:49:41 7 [ERROR] Initialized Master_info from 'master-2021@002d08@002d14@002017@003a32@003a34@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027fivem@002dframework@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-08-18 0:49:41 7 [Note] Added new Master_info '2021-08-14 17:32:34 11 [Warning] Aborted connection 11 to db: 'fivem-framework' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2021-08-18 0:49:41 0 [Warning] Reading of some Master_info entries failed
2021-08-18 0:49:41 0 [ERROR] Failed to initialize multi master structures
2021-08-18 0:49:41 0 [ERROR] Aborting
Warning: Memory not freed: 256

Would really appreciate some help! Since im working on a server I am already paying for.
Thanks in advance.
Mikee058
 
Posts: 1
Joined: 17. August 2021 23:53
XAMPP version: v3.3.0
Operating System: Windows 10

Re: ERROR: MySQL shutdown unexpectedly

Postby Altrea » 18. August 2021 08:23

Hi,

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

Now try to start mariadb the normal way again.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

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


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 181 guests