MySQL startet nicht mehr

Irgendwelche Probleme mit XAMPP für Windows? Dann ist hier genau der richtige Ort um nachzufragen.

MySQL startet nicht mehr

Postby t/s » 02. September 2023 18:18

Nach einem Windows Update startet MySQL nicht mehr. hier der Log-Auszug:
Code: Select all
2023-09-02 18:58:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-09-02 18:58:37 0 [Note] InnoDB: Uses event mutexes
2023-09-02 18:58:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-09-02 18:58:37 0 [Note] InnoDB: Number of pools: 1
2023-09-02 18:58:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-09-02 18:58:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-09-02 18:58:37 0 [Note] InnoDB: Completed initialization of buffer pool
2023-09-02 18:58:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-09-02 18:58:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-09-02 18:58:37 0 [Note] InnoDB: Setting file 'E:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-09-02 18:58:37 0 [Note] InnoDB: File 'E:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-09-02 18:58:37 0 [Note] InnoDB: 10.4.22 started; log sequence number 648262579; transaction id 498313
2023-09-02 18:58:37 0 [Note] InnoDB: Loading buffer pool(s) from E:\xampp\mysql\data\ib_buffer_pool
2023-09-02 18:58:37 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-09-02 18:58:37 0 [Note] Server socket created on IP: '::'.
2023-09-02 18:58:37 0 [Note] InnoDB: Buffer pool(s) load completed at 230902 18:58:37
2023-09-02 18:58:37 7 [Note] Reading Master_info: 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2023-09-02 18:58:37 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2023-09-02 18:58:37 7 [ERROR] Failed to open the relay log ':46 0 [Note] Reading of all Master_info entries succeeded
': 5' (relay_log_pos 0)
2023-09-02 18:58:37 7 [ERROR] Could not find target log during relay log initialization
2023-09-02 18:58:37 7 [ERROR] Initialized Master_info from 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
2023-09-02 18:58:37 7 [Note] Added new Master_info '2022-03-04 11:56:46 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2023-09-02 18:58:37 7 [Note] Reading Master_info: 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2023-09-02 18:58:38 7 [Note] Initialized Master_info from 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2023-09-02 18:58:38 7 [Note] Added new Master_info '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
' to hash table
2023-09-02 18:58:38 8 [Note] Master '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-02 18:58:38 7 [Note] Started replication for '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
'
2023-09-02 18:58:38 9 [Note] Master '2022-03-04 11:56:46 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-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' position: 4
2023-09-02 18:58:38 8 [ERROR] Master '2022-03-04 11:56:46 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
2023-09-02 18:58:38 7 [Note] Reading Master_info: 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020e@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020e@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2023-09-02 18:58:38 8 [Note] Master '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
2023-09-02 18:58:38 8 [Note] Master '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-02 18:58:38 8 [Note] Master '2022-03-04 11:56:46 0 [Note] Added new Master_info '' to hash table
': master was :3306
2023-09-02 18:58:38 7 [Note] Initialized Master_info from 'master-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020e@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2023-09-02 18:58:38 7 [Note] Added new Master_info '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2023-09-02 18:58:38 10 [Note] Master '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-02 18:58:38 7 [Note] Started replication for '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
2023-09-02 18:58:38 11 [Note] Master '2022-03-04 11:56:46 0 [Note] e:\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-2022@002d03@002d04@002011@003a56@003a46@00200@0020@005bnote@005d@0020e@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000001' position: 4
2023-09-02 18:58:38 10 [ERROR] Master '2022-03-04 11:56:46 0 [Note] e:\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
2023-09-02 18:58:38 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e22@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@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2023-09-02 18:58:38 10 [Note] Master '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
2023-09-02 18:58:38 10 [Note] Master '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-02 18:58:38 10 [Note] Master '2022-03-04 11:56:46 0 [Note] e:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306
2023-09-02 18:58:38 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2023-09-02 18:58:38 7 [Note] Added new Master_info 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
' to hash table
2023-09-02 18:58:38 12 [Note] Master 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-02 18:58:38 7 [Note] Started replication for 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
'
2023-09-02 18:58:38 13 [Note] Master 'Version: '10.4.22-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@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000001' position: 4
2023-09-02 18:58:38 12 [ERROR] Master 'Version: '10.4.22-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
2023-09-02 18:58:38 7 [Note] Reading Master_info: 'master-2022@002d03@002d04@002012@003a16@003a14@002068@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'  Relay_info:'relay-log-2022@002d03@002d04@002012@003a16@003a14@002068@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'
2023-09-02 18:58:38 12 [Note] Master 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2023-09-02 18:58:38 12 [Note] Master 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-02 18:58:38 12 [Note] Master 'Version: '10.4.22-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': master was :3306
2023-09-02 18:58:38 7 [Note] Initialized Master_info from 'master-2022@002d03@002d04@002012@003a16@003a14@002068@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'
2023-09-02 18:58:38 7 [Note] Added new Master_info '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
' to hash table
2023-09-02 18:58:38 14 [Note] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-02 18:58:38 7 [Note] Started replication for '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
'
2023-09-02 18:58:38 15 [Note] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d03@002d04@002012@003a16@003a14@002068@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.000001' position: 4
2023-09-02 18:58:38 14 [ERROR] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-02 18:58:38 7 [Note] Reading Master_info: 'master-2022@002d03@002d04@002012@003a16@003a14@002070@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'  Relay_info:'relay-log-2022@002d03@002d04@002012@003a16@003a14@002070@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'
2023-09-02 18:58:38 14 [Note] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread killed while connecting to master
2023-09-02 18:58:38 14 [Note] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-02 18:58:38 14 [Note] Master '2022-03-04 12:16:14 68 [Warning] Access denied for user ''@'localhost' (using password: NO)
': master was :3306
2023-09-02 18:58:38 7 [Note] Initialized Master_info from 'master-2022@002d03@002d04@002012@003a16@003a14@002070@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.info'
2023-09-02 18:58:38 7 [Note] Added new Master_info '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
' to hash table
2023-09-02 18:58:38 16 [Note] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-09-02 18:58:38 7 [Note] Started replication for '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
'
2023-09-02 18:58:38 17 [Note] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2022@002d03@002d04@002012@003a16@003a14@002070@0020@005bwarning@005d@0020access@0020denied@0020for@0020user@0020@0027@0027@0040@0027localhost@0027@0020@0028using@0020password@003a@0020no@0029@000d.000001' position: 4
2023-09-02 18:58:38 16 [ERROR] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2023-09-02 18:58:38 0 [Warning] Reading of some Master_info entries failed
2023-09-02 18:58:38 16 [Note] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread killed while connecting to master
2023-09-02 18:58:38 0 [ERROR] Failed to initialize multi master structures
2023-09-02 18:58:38 16 [Note] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-09-02 18:58:38 0 [ERROR] Aborting
2023-09-02 18:58:38 16 [Note] Master '2022-03-04 12:16:14 70 [Warning] Access denied for user ''@'localhost' (using password: NO)
': master was :3306
Warning: Memory not freed: 256



Hat jemand eine Idee, was ich da machen kann?
t/s
 
Posts: 1
Joined: 02. September 2023 18:11
XAMPP version: ?
Operating System: win 10

Error: MySQL shutdown unexpectedly.

Postby laslolosla » 14. April 2024 16:50

Error: MySQL shutdown unexpectedly.10:26:31 a. m.
[mysql] This may be due to a blocked port, missing dependencies,
10:26:31 a. m. [mysql] improper privileges, a crash, or a shutdown by another method.
10:26:31 a. m. [mysql] Press the Logs button to view error logs and check
10:26:31 a. m. [mysql] the Windows Event Viewer for more clues
10:26:31 a. m. [mysql] If you need more help, copy and post this
10:26:31 a. m. [mysql] entire log window on the forums
laslolosla
 
Posts: 1
Joined: 14. April 2024 16:43
XAMPP version: 3.3.0
Operating System: Sistema operativo de 64 bits,


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 141 guests