gestern arbeite ich noch mit meinem lokalen Xampp und heute morgen startet MySQL nicht mehr.
In den Logs steht nichts was mich weiterbringen würde.
Am Windows oder am Xampp wurde nicht gemacht. Auch keine Updates sind eingespielt worden.
Ich habe auch schon mal diesen Tipp hier befolgt: https://community.apachefriends.org/f/viewtopic.php?f=4&t=78422
Dabei kamen folgende Fehler:
- Code: Select all
2021-12-03 10:17:12 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-12-03 10:17:12 0 [Note] mysqld (mysqld 10.4.14-MariaDB) starting as process 5964 ...
InnoDB: using atomic writes.
2021-12-03 10:17:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-12-03 10:17:12 0 [Note] InnoDB: Uses event mutexes
2021-12-03 10:17:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-12-03 10:17:12 0 [Note] InnoDB: Number of pools: 1
2021-12-03 10:17:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-12-03 10:17:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-12-03 10:17:12 0 [Note] InnoDB: Completed initialization of buffer pool
2021-12-03 10:17:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-12-03 10:17:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-12-03 10:17:12 0 [Note] InnoDB: Setting file 'C:\webserver7.4\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-12-03 10:17:12 0 [Note] InnoDB: File 'C:\webserver7.4\mysql\data\ibtmp1' size is now 12 MB.
2021-12-03 10:17:12 0 [Note] InnoDB: Waiting for purge to start
2021-12-03 10:17:12 0 [Note] InnoDB: 10.4.14 started; log sequence number 391052948; transaction id 36827
2021-12-03 10:17:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\webserver7.4\mysql\data\ib_buffer_pool
2021-12-03 10:17:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-12-03 10:17:12 0 [Note] Server socket created on IP: '::'.
2021-12-03 10:17:12 0 [Note] InnoDB: Buffer pool(s) load completed at 211203 10:17:12
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-12-03 10:17:12 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-12-03 10:17:12 7 [Note] Initialized Master_info from 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-12-03 10:17:12 7 [Note] Added new Master_info '2021-12-02 9:16:21 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries 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-12-03 10:17:12 7 [Note] Started replication for '2021-12-02 9:16:21 0 [Note] Reading of all Master_info entries su'ceeded
': Slave I/O thread killed while connecting to master:21 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@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000017' position: 4
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
2021-12-03 10:17:12 7 [Note] Initialized Master_info from 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table7:12 7 [Note] Added new Master_info '2021-12-02 9:16:21 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4 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-12-03 10:17:12 7 [Note] Started replication for '2021-12-02 9:16:21 0 [Note] Added new Master_info '' to hash tabl'
': Slave I/O thread killed while connecting to master6:21 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@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000017' position: 4
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020c@003a@005cwebserver7@002e4@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020c@003a@005cwebserver7@002e4@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
2021-12-03 10:17:12 7 [Note] Initialized Master_info from 'master-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020c@003a@005cwebserver7@002e4@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-12-03 10:17:12 7 [Note] Added new Master_info '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: r' to hash tabletions.
2021-12-03 10:17:12 12 [Note] Master '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: ready for conne': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2021-12-03 10:17:12 12 [ERROR] Master '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: ready for conn': 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-12-03 10:17:12 7 [Note] Started replication for '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe:'ready for connections.
2021-12-03 10:17:12 13 [Note] Master '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: ready for conne': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d12@002d02@0020@00209@003a16@003a21@00200@0020@005bnote@005d@0020c@003a@005cwebserver7@002e4@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000017' position: 4
2021-12-03 10:17:12 12 [Note] Master '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: ready for conne': Slave I/O thread killed while connecting to master
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e14@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@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2021-12-03 10:17:12 12 [Note] Master '2021-12-02 9:16:21 0 [Note] c:\webserver7.4\mysql\bin\mysqld.exe: ready for conne': Slave I/O thread exiting, read up to log 'FIRST', position 4
2021-12-03 10:17:12 7 [ERROR] Failed to open the relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000005' (relay_log_pos 4)
2021-12-03 10:17:12 7 [ERROR] Could not find target log during relay log initialization
2021-12-03 10:17:12 7 [ERROR] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e14@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' failed
2021-12-03 10:17:12 7 [Note] Added new Master_info 'Version: '10.4.14-MariaDB' socket: '' port: 3306 mariadb.org bina' to hash table
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@002011@003a16@003a36@0020698@0020@005bwarning@005d@0020aborted@0020connection@0020698@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d12@002d02@002011@003a16@003a36@0020698@0020@005bwarning@005d@0020aborted@0020connection@0020698@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-12-03 10:17:12 7 [ERROR] Failed to create a new master info file (file 'C:\webserver7.4\mysql\data\master-2021@002d12@002d02@002011@003a16@003a36@0020698@0020@005bwarning@005d@0020aborted@0020connection@0020698@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-12-03 10:17:12 7 [ERROR] Initialized Master_info from 'master-2021@002d12@002d02@002011@003a16@003a36@0020698@0020@005bwarning@005d@0020aborted@0020connection@0020698@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-12-03 10:17:12 7 [Note] Added new Master_info '2021-12-02 11:16:36 698 [Warning] Aborted connection 698 to db: 'usr' to hash table178ebf' host: 'localhost' (Got an error reading communication packets)
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@002011@003a17@003a11@0020701@0020@005bwarning@005d@0020aborted@0020connection@0020701@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d12@002d02@002011@003a17@003a11@0020701@0020@005bwarning@005d@0020aborted@0020connection@0020701@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-12-03 10:17:12 7 [ERROR] Failed to create a new master info file (file 'C:\webserver7.4\mysql\data\master-2021@002d12@002d02@002011@003a17@003a11@0020701@0020@005bwarning@005d@0020aborted@0020connection@0020701@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-12-03 10:17:12 7 [ERROR] Initialized Master_info from 'master-2021@002d12@002d02@002011@003a17@003a11@0020701@0020@005bwarning@005d@0020aborted@0020connection@0020701@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-12-03 10:17:12 7 [Note] Added new Master_info '2021-12-02 11:17:11 701 [Warning] Aborted connection 701 to db: 'usr' to hash table178ebf' host: 'localhost' (Got an error reading communication packets)
2021-12-03 10:17:12 7 [Note] Reading Master_info: 'master-2021@002d12@002d02@002011@003a17@003a32@0020702@0020@005bwarning@005d@0020aborted@0020connection@0020702@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2021@002d12@002d02@002011@003a17@003a32@0020702@0020@005bwarning@005d@0020aborted@0020connection@0020702@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2021-12-03 10:17:12 7 [ERROR] Failed to create a new master info file (file 'C:\webserver7.4\mysql\data\master-2021@002d12@002d02@002011@003a17@003a32@0020702@0020@005bwarning@005d@0020aborted@0020connection@0020702@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2021-12-03 10:17:12 7 [ERROR] Initialized Master_info from 'master-2021@002d12@002d02@002011@003a17@003a32@0020702@0020@005bwarning@005d@0020aborted@0020connection@0020702@0020to@0020db@003a@0020@0027usrdb_2@0027@0020user@003a@0020@0027d0178ebf@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2021-12-03 10:17:12 7 [Note] Added new Master_info '2021-12-02 11:17:32 702 [Warning] Aborted connection 702 to db: 'usr' to hash table178ebf' host: 'localhost' (Got an error reading communication packets)
2021-12-03 10:17:12 0 [Warning] Reading of some Master_info entries failed
2021-12-03 10:17:12 0 [ERROR] Failed to initialize multi master structures
2021-12-03 10:17:12 0 [ERROR] Aborting
Habe ich noch irgendeine Chance an die DB-Daten zu gelangen?
Oder gibt es noch etwas, was ich versuchen kann, damit MySQL wieder läuft?
