Mysql shut down unexpectedly

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

Mysql shut down unexpectedly

Postby Torq » 18. September 2019 20:38

Hi, same problem, running XAMPP 3.2.4 (new virgin install on this system, though it did work without any problems for several hours of writing and testing new PHP code):

Windows 8.1 Application Event Log:
Error: The description for Event ID 100 from source MariaDB cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

MySQL Log:

20:15:13 [mysql] Error: MySQL shutdown unexpectedly.
20:15:13 [mysql] This may be due to a blocked port, missing dependencies,
20:15:13 [mysql] improper privileges, a crash, or a shutdown by another method.
20:15:13 [mysql] Press the Logs button to view error logs and check
20:15:13 [mysql] the Windows Event Viewer for more clues
20:15:13 [mysql] If you need more help, copy and post this
20:15:13 [mysql] entire log window on the forums

When starting MySQL as a console app, this is what's reported:

2019-09-18 21:30:22 14 [ERROR] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buff
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect t
o the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2019-09-18 21:30:22 0 [Warning] Reading of some Master_info entries failed
2019-09-18 21:30:22 14 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave I/O thread killed while connecting to master
2019-09-18 21:30:22 0 [ERROR] Failed to initialize multi master structures
2019-09-18 21:30:22 14 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-09-18 21:30:22 0 [ERROR] Aborting

I hope this will provide enough in the way of clues to suggest what's gone wrong and where I should be looking to fix it?

Thanks.

[EDIT by Altrea: Splitted from original thread: one thread per unique user and issue rule]
Torq
 
Posts: 2
Joined: 18. September 2019 19:33
XAMPP version: 3.2.4
Operating System: Win8.1

Re: Mysql shut down unexpectedly

Postby Torq » 18. September 2019 21:24

The full console output (the previous post only had the last portion of it):

# mysqld --console
2019-09-18 22:21:11 0 [Note] Using unique option prefix 'key_buffer' is error-pr
one and can break in the future. Please use the full name 'key_buffer_size' inst
ead.
2019-09-18 22:21:11 0 [Note] mysqld (mysqld 10.4.6-MariaDB) starting as process
5920 ...
InnoDB: using atomic writes.
2019-09-18 22:21:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocke
d functions
2019-09-18 22:21:11 0 [Note] InnoDB: Uses event mutexes
2019-09-18 22:21:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-09-18 22:21:11 0 [Note] InnoDB: Number of pools: 1
2019-09-18 22:21:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-09-18 22:21:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M,
instances = 1, chunk size = 16M
2019-09-18 22:21:11 0 [Note] InnoDB: Completed initialization of buffer pool
2019-09-18 22:21:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active
.
2019-09-18 22:21:11 0 [Note] InnoDB: Creating shared tablespace for temporary ta
bles
2019-09-18 22:21:11 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' s
ize to 12 MB. Physically writing the file full; Please wait ...
2019-09-18 22:21:11 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is n
ow 12 MB.
2019-09-18 22:21:11 0 [Note] InnoDB: Waiting for purge to start
2019-09-18 22:21:11 0 [Note] InnoDB: 10.4.6 started; log sequence number 943036;
transaction id 1118
2019-09-18 22:21:11 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\
data\ib_buffer_pool
2019-09-18 22:21:11 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-18 22:21:11 0 [Note] Server socket created on IP: '::'.
2019-09-18 22:21:11 7 [Note] Reading Master_info: 'master-2019@002d09@002d16@002
021@003a27@003a08@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master
_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2019@002d09@00
2d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020reading@0020of@0020all@00
20master_info@0020entries@0020succeeded@000d.info'
2019-09-18 22:21:11 0 [Note] InnoDB: Buffer pool(s) load completed at 190918 22:
21:11
2019-09-18 22:21:11 7 [Warning] Neither --relay-log nor --relay-log-index were u
sed; 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-bi
n' to avoid this problem.
2019-09-18 22:21:11 7 [Note] Initialized Master_info from 'master-2019@002d09@00
2d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020reading@0020of@0020all@00
20master_info@0020entries@0020succeeded@000d.info'
2019-09-18 22:21:11 7 [Note] Added new Master_info '2019-09-16 21:27:08 0 [Note]
' to hash table Master_info entries succeeded
2019-09-18 22:21:11 8 [Note] Master '2019-09-16 21:27:08 0 [Note] Reading of all
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log ''
at position 4
2019-09-18 22:21:11 7 [Note] Started replication for '2019-09-16 21:27:08 0 [Not
'] Reading of all Master_info entries succeeded
2019-09-18 22:21:11 9 [Note] Master '2019-09-16 21:27:08 0 [Note] Reading of all
': Slave SQL thread initialized, starting replication in log 'FIRST' at position
0, relay log '.\mysql-relay-bin-2019@002d09@002d16@002021@003a27@003a08@00200@0
020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020suc
ceeded@000d.000015' position: 4
2019-09-18 22:21:11 8 [ERROR] Master '2019-09-16 21:27:08 0 [Note] Reading of al
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect t
o the master server. Connection attempt terminated. Internal MariaDB error code:
1593
2019-09-18 22:21:11 7 [Note] Reading Master_info: 'master-2019@002d09@002d16@002
021@003a27@003a08@00200@0020@005bnote@005d@0020added@0020new@0020master_info@002
0@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2019@002
d09@002d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020added@0020new@0020m
aster_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2019-09-18 22:21:12 8 [Note] Master '2019-09-16 21:27:08 0 [Note] Reading of all
': Slave I/O thread killed while connecting to master
2019-09-18 22:21:12 8 [Note] Master '2019-09-16 21:27:08 0 [Note] Reading of all
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-09-18 22:21:12 7 [ERROR] log 2019-09-18 13:39:52 7 [Note] Initialized Maste
r_info from 'master-2019@002d09@002d16@002021@003a27@003a08@00200@0020@005bnote@
005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@
listed in the index, but failed to stat
2019-09-18 22:21:12 7 [ERROR] Error counting relay log space
2019-09-18 22:21:12 7 [ERROR] Initialized Master_info from 'master-2019@002d09@0
02d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020added@0020new@0020master
_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' failed
2019-09-18 22:21:12 7 [Note] Added new Master_info '2019-09-16 21:27:08 0 [Note]
' to hash tableer_info '' to hash table
2019-09-18 22:21:12 7 [Note] Reading Master_info: 'master-2019@002d09@002d16@002
021@003a27@003a08@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbi
n@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Rel
ay_info:'relay-log-2019@002d09@002d16@002021@003a27@003a08@00200@0020@005bnote@0
05d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@002
0for@0020connections@002e@000d.info'
2019-09-18 22:21:12 7 [Note] Initialized Master_info from 'master-2019@002d09@00
2d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysq
l@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.in
fo'
2019-09-18 22:21:12 7 [Note] Added new Master_info '2019-09-16 21:27:08 0 [Note]
' to hash table\bin\mysqld.exe: ready for connections.
2019-09-18 22:21:12 10 [Note] Master '2019-09-16 21:27:08 0 [Note] c:\xampp\mysq
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log ''
at position 4
2019-09-18 22:21:12 7 [Note] Started replication for '2019-09-16 21:27:08 0 [Not
'] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2019-09-18 22:21:12 11 [Note] Master '2019-09-16 21:27:08 0 [Note] c:\xampp\mysq
': Slave SQL thread initialized, starting replication in log 'FIRST' at position
0, relay log '.\mysql-relay-bin-2019@002d09@002d16@002021@003a27@003a08@00200@0
020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a
@0020ready@0020for@0020connections@002e@000d.000015' position: 4
2019-09-18 22:21:12 10 [ERROR] Master '2019-09-16 21:27:08 0 [Note] c:\xampp\mys
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect t
o the master server. Connection attempt terminated. Internal MariaDB error code:
1593
2019-09-18 22:21:12 7 [Note] Reading Master_info: 'master-version@003a@0020@0027
10@002e4@002e6@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020por
t@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
Relay_info:'relay-log-version@003a@0020@002710@002e4@002e6@002dmariadb@0027@002
0@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@00
2eorg@0020binary@0020distribution@000d.info'
2019-09-18 22:21:12 10 [Note] Master '2019-09-16 21:27:08 0 [Note] c:\xampp\mysq
': Slave I/O thread killed while connecting to master
2019-09-18 22:21:12 10 [Note] Master '2019-09-16 21:27:08 0 [Note] c:\xampp\mysq
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-09-18 22:21:12 7 [Note] Initialized Master_info from 'master-version@003a@0
020@002710@002e4@002e6@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020
@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000
d.info'
2019-09-18 22:21:12 7 [Note] Added new Master_info 'Version: '10.4.6-MariaDB' s
' to hash table: 3306 mariadb.org binary distribution
2019-09-18 22:21:12 12 [Note] Master 'Version: '10.4.6-MariaDB' socket: '' por
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log ''
at position 4
2019-09-18 22:21:12 7 [Note] Started replication for 'Version: '10.4.6-MariaDB'
'socket: '' port: 3306 mariadb.org binary distribution
2019-09-18 22:21:12 13 [Note] Master 'Version: '10.4.6-MariaDB' socket: '' por
': Slave SQL thread initialized, starting replication in log 'FIRST' at position
0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e6@002dmariad
b@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020
mariadb@002eorg@0020binary@0020distribution@000d.000015' position: 4
2019-09-18 22:21:12 12 [ERROR] Master 'Version: '10.4.6-MariaDB' socket: '' po
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect t
o the master server. Connection attempt terminated. Internal MariaDB error code:
1593
2019-09-18 22:21:12 7 [Note] Reading Master_info: 'master-2019@002d09@002d16@002
021@003a27@003a08@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0
028s@0029@0020load@0020completed@0020at@0020190916@002021@003a27@003a08@000d.inf
o' Relay_info:'relay-log-2019@002d09@002d16@002021@003a27@003a08@00200@0020@005
bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed
@0020at@0020190916@002021@003a27@003a08@000d.info'
2019-09-18 22:21:12 12 [Note] Master 'Version: '10.4.6-MariaDB' socket: '' por
': Slave I/O thread killed while connecting to master
2019-09-18 22:21:12 12 [Note] Master 'Version: '10.4.6-MariaDB' socket: '' por
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-09-18 22:21:12 7 [Note] Initialized Master_info from 'master-2019@002d09@00
2d16@002021@003a27@003a08@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@00
20pool@0028s@0029@0020load@0020completed@0020at@0020190916@002021@003a27@003a08@
000d.info'
2019-09-18 22:21:12 7 [Note] Added new Master_info '2019-09-16 21:27:08 0 [Note]
' to hash table pool(s) load completed at 190916 21:27:08
2019-09-18 22:21:12 14 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log ''
at position 4
2019-09-18 22:21:12 7 [Note] Started replication for '2019-09-16 21:27:08 0 [Not
'] InnoDB: Buffer pool(s) load completed at 190916 21:27:08
2019-09-18 22:21:12 15 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave SQL thread initialized, starting replication in log 'FIRST' at position
0, relay log '.\mysql-relay-bin-2019@002d09@002d16@002021@003a27@003a08@00200@0
020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020co
mpleted@0020at@0020190916@002021@003a27@003a08@000d.000015' position: 4
2019-09-18 22:21:12 14 [ERROR] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buff
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect t
o the master server. Connection attempt terminated. Internal MariaDB error code:
1593
2019-09-18 22:21:12 0 [Warning] Reading of some Master_info entries failed
2019-09-18 22:21:12 14 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave I/O thread killed while connecting to master
2019-09-18 22:21:12 0 [ERROR] Failed to initialize multi master structures
2019-09-18 22:21:12 14 [Note] Master '2019-09-16 21:27:08 0 [Note] InnoDB: Buffe
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2019-09-18 22:21:12 0 [ERROR] Aborting
Torq
 
Posts: 2
Joined: 18. September 2019 19:33
XAMPP version: 3.2.4
Operating System: Win8.1

Re: Mysql shut down unexpectedly

Postby bhaskarbhagowati » 28. September 2019 12:57

I got the solution by deleting aria_log.00000001 under C:\xampp\mysql\data. But don't delete the ibdata1 file under the same directory.
bhaskarbhagowati
 
Posts: 3
Joined: 25. September 2019 12:46
XAMPP version: 3.2.2
Operating System: Windows Server 2008 R2 Std


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests