Page 1 of 1

ERROR: MySQL shutdown unexpectedly

PostPosted: 17. August 2021 23:56
by Mikee058
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.

Re: ERROR: MySQL shutdown unexpectedly

PostPosted: 18. August 2021 08:23
by Altrea
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.