MySQL 10.4.6-MariaDB crashes after few seconds / XAMPP

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySQL 10.4.6-MariaDB crashes after few seconds / XAMPP

Postby ligh_bennet » 27. August 2019 18:29

Hi there,

I am using XAMPP to build a WordPress-Page. I installed XAMPP 7.3.8 on Windows 10. Installation of XAMPP and WordPress worked fine, but today, after 2 weeks, the MariaDB keeps crashing. The Error-Log spills out this:

Code: Select all
InnoDB: using atomic writes.
2019-08-27 19:28:36 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-08-27 19:28:36 0 [Note] InnoDB: Uses event mutexes
2019-08-27 19:28:36 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-27 19:28:36 0 [Note] InnoDB: Number of pools: 1
2019-08-27 19:28:36 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-08-27 19:28:36 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-08-27 19:28:36 0 [Note] InnoDB: Completed initialization of buffer pool
2019-08-27 19:28:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-08-27 19:28:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-08-27 19:28:36 0 [Note] InnoDB: Setting file '***\Documents\XAMPP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-08-27 19:28:36 0 [Note] InnoDB: File '***\Documents\XAMPP\mysql\data\ibtmp1' size is now 12 MB.
2019-08-27 19:28:36 0 [Note] InnoDB: Waiting for purge to start
2019-08-27 19:28:36 0 [Note] InnoDB: 10.4.6 started; log sequence number 49407119; transaction id 11742
2019-08-27 19:28:36 0 [Note] InnoDB: Loading buffer pool(s) from ***\Documents\XAMPP\mysql\data\ib_buffer_pool
2019-08-27 19:28:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-27 19:28:36 0 [Note] Server socket created on IP: '::'.
2019-08-27 19:28:36 7 [Note] Reading Master_info: 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2019-08-27 19:28:36 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.
2019-08-27 19:28:36 7 [ERROR] log 2019-08-27 19:00:52 7 [Note] Initialized Master_info from 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
 listed in the index, but failed to stat
2019-08-27 19:28:36 7 [ERROR] Error counting relay log space
2019-08-27 19:28:36 7 [ERROR] Initialized Master_info from 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2019-08-27 19:28:36 7 [Note] Added new Master_info '2019-08-23  9:09:48 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2019-08-27 19:28:36 7 [Note] Reading Master_info: 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2019-08-27 19:28:36 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000003' (relay_log_pos 4)
2019-08-27 19:28:36 7 [ERROR] Could not find target log during relay log initialization
2019-08-27 19:28:36 7 [ERROR] Initialized Master_info from 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
2019-08-27 19:28:36 7 [Note] Added new Master_info '2019-08-23  9:09:48 0 [Note] Added new Master_info '' to hash table
' to hash table
2019-08-27 19:28:36 7 [Note] Reading Master_info: 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020c@003a@005cusers@005cuser@005cdocuments@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020c@003a@005cusers@005cuser@005cdocuments@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2019-08-27 19:28:36 7 [ERROR] Failed to create a new master info file (file '***\Documents\XAMPP\mysql\data\master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020c@003a@005cusers@005cuser@005cdocuments@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info', errno 2)
2019-08-27 19:28:36 7 [ERROR] Initialized Master_info from 'master-2019@002d08@002d23@0020@00209@003a09@003a48@00200@0020@005bnote@005d@0020c@003a@005cusers@005cuser@005cdocuments@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' failed
2019-08-27 19:28:36 7 [Note] Added new Master_info '2019-08-23  9:09:48 0 [Note] ***\documents\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2019-08-27 19:28:36 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e6@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@002e6@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2019-08-27 19:28:36 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e6@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2019-08-27 19:28:36 7 [Note] Added new Master_info 'Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
' to hash table
2019-08-27 19:28:36 8 [Note] Master 'Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2019-08-27 19:28:36 0 [Note] InnoDB: Buffer pool(s) load completed at 190827 19:28:36
2019-08-27 19:28:36 7 [Note] Started replication for 'Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
'
2019-08-27 19:28:36 9 [Note] Master 'Version: '10.4.6-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@002e6@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000013' position: 4
2019-08-27 19:28:36 8 [ERROR] Master 'Version: '10.4.6-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
2019-08-27 19:28:36 0 [Warning] Reading of some Master_info entries failed
2019-08-27 19:28:36 8 [Note] Master 'Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2019-08-27 19:28:36 0 [ERROR] Failed to initialize multi master structures
2019-08-27 19:28:36 8 [Note] Master 'Version: '10.4.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-08-27 19:28:36 0 [ERROR] Aborting


I did not actively or consciously change anything on that XAMPP installation. Last time I used it, everything worked fine.

I started XAMPP Control Center with admin rights and I also installed the MySQL service.

Anyone there who can give me a hint what to do about it? What kind of information do you need else?
ligh_bennet
 
Posts: 1
Joined: 27. August 2019 18:16
XAMPP version: 7.3.8
Operating System: Windows 10

Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 4 guests