My SQL Absturz nach Win Update

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

My SQL Absturz nach Win Update

Postby Rubthecat » 16. August 2023 14:35

Hallo zusammen seit gestern starten mein MySQl nicht mehr.
Ich hatte nichts daran geändert der Server hat wohl Windows updates gemacht.

Ich hänge mal die Logs an und den text der localhost Seite:

MySQL meldet: Dokumentation

Die Verbindung konnte aufgrund von ungültigen Einstellungen nicht hergestellt werden.
mysqli::real_connect(): (HY000/2002): Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte
Verbindung für den controluser, wie er in Ihrer Konfiguration angegeben ist, ist fehlgeschlagen.
mysqli::real_connect(): (HY000/2002): Es konnte keine Verbindung hergestellt werden, da der Zielcomputer die Verbindung verweigerte
phpMyAdmin hat versucht eine Verbindung zum MySQL-Server aufzubauen und die Verbindung wurde zurückgewiesen. Sie sollten Ihre Einstellungen für Host, Benutzername und Passwort in Ihrer config.inc.php überprüfen und sich vergewissern, dass diese den Informationen, die Sie vom Administrator erhalten haben, entsprechen.


15:33:51 [mysql] Fehler: MySQL wurde unerwartet beendet
15:33:51 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
15:33:51 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
15:33:51 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
15:33:51 [mysql] im Windows Event Viewer für weitere Hinweise
15:33:51 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
15:33:51 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.

2023-08-16 15:19:35 7 [Note] Reading Master_info: 'master-2023@002d08@002d16@0020@00200@003a08@003a16@00204115@0020@005bwarning@005d@0020aborted@0020connection@00204115@0020to@0020db@003a@0020@0027esxlegacy_65157b@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' Relay_info:'relay-log-2023@002d08@002d16@0020@00200@003a08@003a16@00204115@0020@005bwarning@005d@0020aborted@0020connection@00204115@0020to@0020db@003a@0020@0027esxlegacy_65157b@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2023-08-16 15:19:35 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2023@002d08@002d16@0020@00200@003a08@003a16@00204115@0020@005bwarning@005d@0020aborted@0020connection@00204115@0020to@0020db@003a@0020@0027esxlegacy_65157b@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 38)
2023-08-16 15:19:35 7 [ERROR] Initialized Master_info from 'master-2023@002d08@002d16@0020@00200@003a08@003a16@00204115@0020@005bwarning@005d@0020aborted@0020connection@00204115@0020to@0020db@003a@0020@0027esxlegacy_65157b@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2023-08-16 15:19:35 7 [Note] Added new Master_info '2023-08-16 0:08:16 4115 [Warning] Aborted connection 4115 to db: 'esxlegacy_65157b' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2023-08-16 15:19:35 7 [Note] Reading Master_info: 'master-2023@002d08@002d16@0020@00200@003a16@003a04@00204181@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info' Relay_info:'relay-log-2023@002d08@002d16@0020@00200@003a16@003a04@00204181@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info'
2023-08-16 15:19:35 7 [Note] Initialized Master_info from 'master-2023@002d08@002d16@0020@00200@003a16@003a04@00204181@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info'
2023-08-16 15:19:35 7 [Note] Added new Master_info '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
' to hash table
2023-08-16 15:19:35 16 [Note] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-08-16 15:19:35 7 [Note] Started replication for '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
'
2023-08-16 15:19:35 17 [Note] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d08@002d16@0020@00200@003a16@003a04@00204181@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.000010' position: 4
2023-08-16 15:19:35 16 [ERROR] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': 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-08-16 15:19:35 7 [Note] Reading Master_info: 'master-2023@002d08@002d16@0020@00200@003a16@003a19@00204183@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info' Relay_info:'relay-log-2023@002d08@002d16@0020@00200@003a16@003a19@00204183@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info'
2023-08-16 15:19:35 16 [Note] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread killed while connecting to master
2023-08-16 15:19:35 16 [Note] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-08-16 15:19:35 16 [Note] Master '2023-08-16 0:16:04 4181 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': master was :3306
2023-08-16 15:19:35 7 [Note] Initialized Master_info from 'master-2023@002d08@002d16@0020@00200@003a16@003a19@00204183@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.info'
2023-08-16 15:19:35 7 [Note] Added new Master_info '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
' to hash table
2023-08-16 15:19:35 18 [Note] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2023-08-16 15:19:35 7 [Note] Started replication for '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
'
2023-08-16 15:19:35 19 [Note] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d08@002d16@0020@00200@003a16@003a19@00204183@0020@005berror@005d@0020got@0020error@0020176@0020when@0020reading@0020table@0020@0027@002e@005cmysql@005ctables_priv@0027@000d.000010' position: 4
2023-08-16 15:19:35 18 [ERROR] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': 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-08-16 15:19:35 0 [Warning] Reading of some Master_info entries failed
2023-08-16 15:19:35 18 [Note] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread killed while connecting to master
2023-08-16 15:19:35 0 [ERROR] Failed to initialize multi master structures
2023-08-16 15:19:35 18 [Note] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2023-08-16 15:19:35 0 [ERROR] Aborting
2023-08-16 15:19:35 18 [Note] Master '2023-08-16 0:16:19 4183 [ERROR] Got error 176 when reading table '.\mysql\tables_priv'
': master was :3306
2023-08-16 15:20:25 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 12556
2023-08-16 15:20:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-16 15:20:25 0 [Note] InnoDB: Uses event mutexes
2023-08-16 15:20:25 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-16 15:20:25 0 [Note] InnoDB: Number of pools: 1
2023-08-16 15:20:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-16 15:20:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-16 15:20:25 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-16 15:20:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-16 15:20:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-16 15:20:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-16 15:20:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-16 15:20:25 0 [Note] InnoDB: 10.4.28 started; log sequence number 50010513; transaction id 49956
2023-08-16 15:20:25 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-16 15:20:25 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-16 15:20:25 0 [Note] Server socket created on IP: '::'.
2023-08-16 15:26:00 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 11120
2023-08-16 15:26:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-16 15:26:00 0 [Note] InnoDB: Uses event mutexes
2023-08-16 15:26:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-16 15:26:00 0 [Note] InnoDB: Number of pools: 1
2023-08-16 15:26:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-16 15:26:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-16 15:26:00 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-16 15:26:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-16 15:26:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-16 15:26:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-16 15:26:00 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-16 15:26:00 0 [Note] InnoDB: 10.4.28 started; log sequence number 50010522; transaction id 49956
2023-08-16 15:26:00 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-16 15:26:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-16 15:26:00 0 [Note] Server socket created on IP: '::'.
2023-08-16 15:26:00 0x2640 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154
InnoDB: Failing assertion: slot
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
230816 15:26:00 [ERROR] mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.4.28-MariaDB source revision: c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=65537
thread_count=6
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 20302 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
2023-08-16 15:26:00 0x2ea4 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154
2023-08-16 15:26:00 0 [Note] InnoDB: Buffer pool(s) load completed at 230816 15:26:00
2023-08-16 15:26:00 0x2de8 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154
InnoDB: Failing assertion: slot
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
InnoDB: about forcing recovery.
Inno2023-08-16 15:27:44 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 9944
2023-08-16 15:27:44 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-16 15:27:44 0 [Note] InnoDB: Uses event mutexes
2023-08-16 15:27:44 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-16 15:27:44 0 [Note] InnoDB: Number of pools: 1
2023-08-16 15:27:44 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-16 15:27:44 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-16 15:27:44 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-16 15:27:44 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-16 15:27:44 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-08-16 15:27:44 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-16 15:27:44 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-16 15:27:44 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-16 15:27:45 0 [Note] InnoDB: 10.4.28 started; log sequence number 50010522; transaction id 49956
2023-08-16 15:27:45 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-16 15:27:45 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-16 15:27:45 0 [Note] Server socket created on IP: '::'.
2023-08-16 15:33:31 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 11308
2023-08-16 15:33:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-08-16 15:33:31 0 [Note] InnoDB: Uses event mutexes
2023-08-16 15:33:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-08-16 15:33:31 0 [Note] InnoDB: Number of pools: 1
2023-08-16 15:33:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-08-16 15:33:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-08-16 15:33:31 0 [Note] InnoDB: Completed initialization of buffer pool
2023-08-16 15:33:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-08-16 15:33:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-08-16 15:33:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-08-16 15:33:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-08-16 15:33:31 0 [Note] InnoDB: Waiting for purge to start
2023-08-16 15:33:31 0 [Note] InnoDB: 10.4.28 started; log sequence number 50010531; transaction id 49956
2023-08-16 15:33:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-08-16 15:33:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-08-16 15:33:31 0 [Note] Server socket created on IP: '::'.
Rubthecat
 
Posts: 1
Joined: 16. August 2023 14:30
XAMPP version: 3.3.0
Operating System: Windows Server 2022 Standard

Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 136 guests