by 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