MySQL startet + stoppt sofort wieder nach Windows Update

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

MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 22. April 2020 15:18

Es gab zwar schon Beiträge, die so klangen, als hätten auch andere das gleiche Problem, aber leider gab es dort jeweils keine Lösung.

Ich habe das Problem, dass (vermutlich) seit den letzten Windows Updates der mysql-Server von Xampp nicht mehr startet. Bzw. der Dienst startet kurz und stoppt dann sofort.
Vermutlich deshalb, da ansonsten der Server einfach vor sich hinläuft und vorher keine Probleme auftraten.
Es wurden diese Sicherheitsupdates installiert:
KB4540726
KB4550917
KB4550905
KB4540671

Hat hier Jemand einen Tipp? Es klingt ein wenig, als würde irgendeine neue Sicherheitseinstellung den Port blocken bzw. den Prozess "abschießen".

Hier ein Auszug aus dem Log des Control Panels:

16:10:46 [main] Initialisere Control Panel
16:10:46 [main] Windows Version: Windows Server 2012 64-bit
16:10:46 [main] XAMPP Version: 7.2.27
16:10:46 [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
16:10:46 [main] Mit Administratorrechten gestartet - gut!
16:10:46 [main] XAMPP Installationsverzeichnis: "c:\xampp\"
16:10:46 [main] Voraussetzungen werden geprüft
16:10:46 [main] Alle Voraussetzungen sind erfüllt
16:10:46 [main] Initialisiere Module
16:10:46 [mysql] MySQL Dienst mit falschem Pfad erkannt
16:10:46 [mysql] Ändere XAMPP MySQL und Control Panel Einstellungen oder
16:10:46 [mysql] Entferne/Deaktiviere den anderen Windows Dienst vorher
16:10:46 [mysql] Pfad gefunden: C:\xampp\mysql\bin\mysqld --defaults-file=C:\xampp\mysql\bin\my.ini mysql
16:10:46 [mysql] Erwarteter Pfad: c:\xampp\mysql\bin\mysqld.exe --defaults-file=c:\xampp\mysql\bin\my.ini mysql

16:10:50 [mysql] Versuche MySQL Windows Dienst zu starten...
16:10:50 [mysql] Statusänderung erkannt: gestartet
16:10:57 [mysql] Statusänderung erkannt: gestoppt
16:10:57 [mysql] Fehler: MySQL wurde unerwartet beendet
16:10:57 [mysql] Ursache könnte ein geblockter Port, fehlende Abhängigkeiten,
16:10:57 [mysql] fehlende Berechtigungen, ein Absturz oder ein Abbruch einer anderen Methode sein.
16:10:57 [mysql] Drücke den Logs Button um error logs zu sehen und prüfe
16:10:57 [mysql] im Windows Event Viewer für weitere Hinweise
16:10:57 [mysql] Wenn du weitere Hilfe benötigst, kopiere den kompletten Inhalt des Log Fensters
16:10:57 [mysql] und füge ihn als Ergänzung in einem neuen Forum Eintrag hinzu.
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Altrea » 22. April 2020 17:01

Sieht für mich so aus als ob das XAMPP control panel den eigenen Dienst nicht erkennt.
Ich würde den Dienst einmal deregistrieren und neuregistrieren
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10342
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 22. April 2020 17:03

Das Problem tritt aber auch auf, wenn ich versuche, MySQL ohne Xampp Controlpanel zu starten (also über start direkt von Windows oder über mysql_start im xampp-Verzeichnis).
Auch Neuinstallation brachte keine Änderung.
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Altrea » 22. April 2020 17:09

Dann reichen die paar Meldungen definitiv nicht aus um das Problem zu lösen. Wie in den anderen Themen die du ja gelesen hast bitte ich daher darum, mysql mit dem console flag zu starten und uns die Ausgabe davon zu zeigen.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10342
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 23. April 2020 21:05

So spannend liest sich dann das Log:

InnoDB: using atomic writes.
2020-04-22 14:04:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-04-22 14:04:33 0 [Note] InnoDB: Uses event mutexes
2020-04-22 14:04:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-04-22 14:04:33 0 [Note] InnoDB: Number of pools: 1
2020-04-22 14:04:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-04-22 14:04:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-04-22 14:04:33 0 [Note] InnoDB: Completed initialization of buffer pool
2020-04-22 14:04:33 0 [Note] InnoDB: Resizing redo log from 2*5242880 to 2*52428800 bytes; LSN=25226605
2020-04-22 14:04:33 0 [Note] InnoDB: Starting to delete and rewrite log files.
2020-04-22 14:04:33 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 52428800 bytes
2020-04-22 14:04:33 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 52428800 bytes
2020-04-22 14:04:33 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2020-04-22 14:04:33 0 [Note] InnoDB: New log files created, LSN=25226605
2020-04-22 14:04:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-04-22 14:04:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-04-22 14:04:33 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-04-22 14:04:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-04-22 14:04:33 0 [Note] InnoDB: Waiting for purge to start
2020-04-22 14:04:33 0 [Note] InnoDB: 10.4.11 started; log sequence number 25226605; transaction id 11629
2020-04-22 14:04:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-04-22 14:04:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-04-22 14:04:33 0 [Note] Server socket created on IP: '::'.
2020-04-22 14:04:33 7 [Note] Reading Master_info: 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-04-22 14:04:33 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.
2020-04-22 14:04:33 7 [Note] Initialized Master_info from 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2020-04-22 14:04:33 7 [Note] Added new Master_info '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries succeeded
' to hash table
2020-04-22 14:04:33 8 [Note] Master '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 14:04:33 7 [Note] Started replication for '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries succeeded
'
2020-04-22 14:04:33 9 [Note] Master '2020-02-14 12:20:55 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-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000005' position: 4
2020-04-22 14:04:33 8 [ERROR] Master '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries 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
2020-04-22 14:04:33 7 [Note] Reading Master_info: 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-04-22 14:04:33 8 [Note] Master '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread killed while connecting to master
2020-04-22 14:04:33 8 [Note] Master '2020-02-14 12:20:55 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 14:04:33 7 [Note] Initialized Master_info from 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2020-04-22 14:04:33 7 [Note] Added new Master_info '2020-02-14 12:20:55 0 [Note] Added new Master_info '' to hash table
' to hash table
2020-04-22 14:04:33 10 [Note] Master '2020-02-14 12:20:55 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 14:04:33 7 [Note] Started replication for '2020-02-14 12:20:55 0 [Note] Added new Master_info '' to hash table
'
2020-04-22 14:04:33 11 [Note] Master '2020-02-14 12:20:55 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-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000005' position: 4
2020-04-22 14:04:33 10 [ERROR] Master '2020-02-14 12:20:55 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
2020-04-22 14:04:33 7 [Note] Reading Master_info: 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-04-22 14:04:33 10 [Note] Master '2020-02-14 12:20:55 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master
2020-04-22 14:04:33 10 [Note] Master '2020-02-14 12:20:55 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 14:04:33 7 [Note] Initialized Master_info from 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2020-04-22 14:04:33 7 [Note] Added new Master_info '2020-02-14 12:20:55 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
' to hash table
2020-04-22 14:04:33 12 [Note] Master '2020-02-14 12:20:55 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 14:04:33 7 [Note] Started replication for '2020-02-14 12:20:55 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
'
2020-04-22 14:04:33 13 [Note] Master '2020-02-14 12:20:55 0 [Note] c:\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-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000005' position: 4
2020-04-22 14:04:33 12 [ERROR] Master '2020-02-14 12:20:55 0 [Note] c:\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
2020-04-22 14:04:33 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e11@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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-04-22 14:04:33 12 [Note] Master '2020-02-14 12:20:55 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master
2020-04-22 14:04:33 12 [Note] Master '2020-02-14 12:20:55 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 14:04:34 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
2020-04-22 14:04:34 7 [Note] Added new Master_info 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
' to hash table
2020-04-22 14:04:34 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 14:04:34 7 [Note] Started replication for 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
'
2020-04-22 14:04:34 15 [Note] Master 'Version: '10.4.11-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@002e11@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000005' position: 4
2020-04-22 14:04:34 14 [ERROR] Master 'Version: '10.4.11-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
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200214@002012@003a20@003a55@000d.info' Relay_info:'relay-log-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200214@002012@003a20@003a55@000d.info'
2020-04-22 14:04:34 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master
2020-04-22 14:04:34 14 [Note] Master 'Version: '10.4.11-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 14:04:34 7 [Note] Initialized Master_info from 'master-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200214@002012@003a20@003a55@000d.info'
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
' to hash table
2020-04-22 14:04:34 16 [Note] Master '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-04-22 14:04:34 7 [Note] Started replication for '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
'
2020-04-22 14:04:34 17 [Note] Master '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d02@002d14@002012@003a20@003a55@00200@0020@005bnote@005d@0020innodb@003a@0020buffer@0020pool@0028s@0029@0020load@0020completed@0020at@0020200214@002012@003a20@003a55@000d.000005' position: 4
2020-04-22 14:04:34 16 [ERROR] Master '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020ip@0020address@0020@0027192@002e168@002e2@002e142@0027@0020could@0020not@0020be@0020resolved@003a@0020der@0020angegebene@0020host@0020ist@0020unbekannt@002e@0020@000d.info' Relay_info:'relay-log-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020ip@0020address@0020@0027192@002e168@002e2@002e142@0027@0020could@0020not@0020be@0020resolved@003a@0020der@0020angegebene@0020host@0020ist@0020unbekannt@002e@0020@000d.info'
2020-04-22 14:04:34 0 [Note] InnoDB: Buffer pool(s) load completed at 200422 14:04:34
2020-04-22 14:04:34 16 [Note] Master '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
': Slave I/O thread killed while connecting to master
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020ip@0020address@0020@0027192@002e168@002e2@002e142@0027@0020could@0020not@0020be@0020resolved@003a@0020der@0020angegebene@0020host@0020ist@0020unbekannt@002e@0020@000d.info', errno 2)
2020-04-22 14:04:34 16 [Note] Master '2020-02-14 12:20:55 0 [Note] InnoDB: Buffer pool(s) load completed at 200214 12:20:55
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020ip@0020address@0020@0027192@002e168@002e2@002e142@0027@0020could@0020not@0020be@0020resolved@003a@0020der@0020angegebene@0020host@0020ist@0020unbekannt@002e@0020@000d.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-02-17 14:54:06 1372 [Warning] IP address '192.168.2.142' could not be resolved: Der angegebene Host ist unbekannt.
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020aborted@0020connection@00201372@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentic.info' Relay_info:'relay-log-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020aborted@0020connection@00201372@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentic.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020aborted@0020connection@00201372@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentic.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d02@002d17@002014@003a54@003a06@00201372@0020@005bwarning@005d@0020aborted@0020connection@00201372@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentic.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-02-17 14:54:06 1372 [Warning] Aborted connection 1372 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d07@002015@003a40@003a06@00209710@0020@005bwarning@005d@0020aborted@0020connection@00209710@0020to@0020db@003a@0020@0027timas@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-2020@002d03@002d07@002015@003a40@003a06@00209710@0020@005bwarning@005d@0020aborted@0020connection@00209710@0020to@0020db@003a@0020@0027timas@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d07@002015@003a40@003a06@00209710@0020@005bwarning@005d@0020aborted@0020connection@00209710@0020to@0020db@003a@0020@0027timas@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d07@002015@003a40@003a06@00209710@0020@005bwarning@005d@0020aborted@0020connection@00209710@0020to@0020db@003a@0020@0027timas@0027@0020user@003a@0020@0027root@0027@0020host@003a@0020@0027localhost@0027@0020@0028got@0020an@0020error@0020reading@0020communication@0020packets@0029@000d.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-07 15:40:06 9710 [Warning] Aborted connection 9710 to db: 'timas' user: 'root' host: 'localhost' (Got an error reading communication packets)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002011@003a30@003a02@002017427@0020@005bwarning@005d@0020aborted@0020connection@002017427@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002011@003a30@003a02@002017427@0020@005bwarning@005d@0020aborted@0020connection@002017427@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002011@003a30@003a02@002017427@0020@005bwarning@005d@0020aborted@0020connection@002017427@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002011@003a30@003a02@002017427@0020@005bwarning@005d@0020aborted@0020connection@002017427@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 11:30:02 17427 [Warning] Aborted connection 17427 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002012@003a30@003a54@002017448@0020@005bwarning@005d@0020aborted@0020connection@002017448@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002012@003a30@003a54@002017448@0020@005bwarning@005d@0020aborted@0020connection@002017448@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002012@003a30@003a54@002017448@0020@005bwarning@005d@0020aborted@0020connection@002017448@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002012@003a30@003a54@002017448@0020@005bwarning@005d@0020aborted@0020connection@002017448@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 12:30:54 17448 [Warning] Aborted connection 17448 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002012@003a31@003a13@002017449@0020@005bwarning@005d@0020aborted@0020connection@002017449@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002012@003a31@003a13@002017449@0020@005bwarning@005d@0020aborted@0020connection@002017449@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002012@003a31@003a13@002017449@0020@005bwarning@005d@0020aborted@0020connection@002017449@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002012@003a31@003a13@002017449@0020@005bwarning@005d@0020aborted@0020connection@002017449@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 12:31:13 17449 [Warning] Aborted connection 17449 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002012@003a33@003a07@002017450@0020@005bwarning@005d@0020aborted@0020connection@002017450@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002012@003a33@003a07@002017450@0020@005bwarning@005d@0020aborted@0020connection@002017450@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002012@003a33@003a07@002017450@0020@005bwarning@005d@0020aborted@0020connection@002017450@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002012@003a33@003a07@002017450@0020@005bwarning@005d@0020aborted@0020connection@002017450@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 12:33:07 17450 [Warning] Aborted connection 17450 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002012@003a33@003a09@002017451@0020@005bwarning@005d@0020aborted@0020connection@002017451@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002012@003a33@003a09@002017451@0020@005bwarning@005d@0020aborted@0020connection@002017451@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002012@003a33@003a09@002017451@0020@005bwarning@005d@0020aborted@0020connection@002017451@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002012@003a33@003a09@002017451@0020@005bwarning@005d@0020aborted@0020connection@002017451@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 12:33:09 17451 [Warning] Aborted connection 17451 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d03@002d25@002012@003a33@003a09@002017452@0020@005bwarning@005d@0020aborted@0020connection@002017452@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d03@002d25@002012@003a33@003a09@002017452@0020@005bwarning@005d@0020aborted@0020connection@002017452@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d03@002d25@002012@003a33@003a09@002017452@0020@005bwarning@005d@0020aborted@0020connection@002017452@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d03@002d25@002012@003a33@003a09@002017452@0020@005bwarning@005d@0020aborted@0020connection@002017452@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-03-25 12:33:09 17452 [Warning] Aborted connection 17452 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d04@002d16@002016@003a17@003a37@002027132@0020@005bwarning@005d@0020aborted@0020connection@002027132@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d04@002d16@002016@003a17@003a37@002027132@0020@005bwarning@005d@0020aborted@0020connection@002027132@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d16@002016@003a17@003a37@002027132@0020@005bwarning@005d@0020aborted@0020connection@002027132@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d16@002016@003a17@003a37@002027132@0020@005bwarning@005d@0020aborted@0020connection@002027132@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-04-16 16:17:37 27132 [Warning] Aborted connection 27132 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d04@002d16@002016@003a22@003a32@002027133@0020@005bwarning@005d@0020aborted@0020connection@002027133@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d04@002d16@002016@003a22@003a32@002027133@0020@005bwarning@005d@0020aborted@0020connection@002027133@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d16@002016@003a22@003a32@002027133@0020@005bwarning@005d@0020aborted@0020connection@002027133@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d16@002016@003a22@003a32@002027133@0020@005bwarning@005d@0020aborted@0020connection@002027133@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-04-16 16:22:32 27133 [Warning] Aborted connection 27133 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d04@002d16@002016@003a22@003a34@002027134@0020@005bwarning@005d@0020aborted@0020connection@002027134@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d04@002d16@002016@003a22@003a34@002027134@0020@005bwarning@005d@0020aborted@0020connection@002027134@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d16@002016@003a22@003a34@002027134@0020@005bwarning@005d@0020aborted@0020connection@002027134@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d16@002016@003a22@003a34@002027134@0020@005bwarning@005d@0020aborted@0020connection@002027134@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-04-16 16:22:34 27134 [Warning] Aborted connection 27134 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 7 [Note] Reading Master_info: 'master-2020@002d04@002d16@002016@003a22@003a38@002027135@0020@005bwarning@005d@0020aborted@0020connection@002027135@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' Relay_info:'relay-log-2020@002d04@002d16@002016@003a22@003a38@002027135@0020@005bwarning@005d@0020aborted@0020connection@002027135@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info'
2020-04-22 14:04:34 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d04@002d16@002016@003a22@003a38@002027135@0020@005bwarning@005d@0020aborted@0020connection@002027135@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info', errno 2)
2020-04-22 14:04:34 7 [ERROR] Initialized Master_info from 'master-2020@002d04@002d16@002016@003a22@003a38@002027135@0020@005bwarning@005d@0020aborted@0020connection@002027135@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027192@002e168@002e2@002e142@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authe.info' failed
2020-04-22 14:04:34 7 [Note] Added new Master_info '2020-04-16 16:22:38 27135 [Warning] Aborted connection 27135 to db: 'unconnected' user: 'unauthenticated' host: '192.168.2.142' (This connection closed normally without authentication)
' to hash table
2020-04-22 14:04:34 0 [Warning] Reading of some Master_info entries failed
2020-04-22 14:04:34 0 [ERROR] Failed to initialize multi master structures
2020-04-22 14:04:34 0 [ERROR] Aborting
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 23. April 2020 21:10

Und der Vollständigkeit halber noch die Infos aus dem Windows Server-Manager:

Microsoft-Windows-Service Control Manager:
Dienst "mysql" wurde unerwartet beendet. Dies ist bereits 19 Mal passiert.

MariaDB
Can't start server: Bind on TCP/IP port. Got error: 10048: Normalerweise darf jede Socketadresse (Protokoll, Netzwerkadresse oder Anschluss) nur jeweils einmal verwendet werden.
Do you already have another mysqld server running on port: 3306 ?
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 23. April 2020 21:21

Achso und Netstat sagt:
Adresse Port PID Name
0.0.0.0 3306 6868 mysqld.exe
127.0.0.1 3306 6868 mysqld.exe (als "Alter Socket" markiert)
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Altrea » 24. April 2020 19:42

Mein Fehler, der Konsolenbefehl muss etwas mehr input bekommen.

Probiere bitte mal folgendes in der XAMPP shell und teile uns wieder mit, was da zurückkommt:
Code: Select all
mysqld --defaults-file=mysql\bin\my.ini --standalone --console
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10342
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 26. April 2020 20:59

Puh da kommt ziemlich viel, leider kann ich nicht an den Anfang zurückscrollen. Hier die letzten zwei Seiten.

Image
Image
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby plh4 » 04. May 2020 08:37

Leider haben wir den Server immer noch nicht ans Laufen bekommen :/
plh4
 
Posts: 7
Joined: 22. April 2020 15:12
XAMPP version: 3.2.4
Operating System: Windows Server

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Altrea » 04. May 2020 11:03

Es ist leider nicht leicht eine Lösung für dein Problem zu finden. Die einzig bekannte Lösung die nachweislich funktioniert wäre eine komplette Neuinstallation von XAMPP.

Auffällig ist, dass die Unicode Zeichen in den Log-Meldungen nicht aufgelöst werden (Diese @0020, @0024, etc.).
Diese Fehlzeichen starten immer im Zusammenhang mit master_info, was für sich genommen schon ungewöhnlich ist, da XAMPP normalerweise keine Master/Slave Replikation konfigiruert hat.

Inwiefern man die Replikation irgendwie umkonfigurieren kann oder man bestimmte Dateien einfach löschen kann, so dass dein Server wieder starten kann, weiß ich nicht.
Ebensowenig weiß ich, ob das Problem durch ein Windows Update hervorgerufen werden kann, oder ob der zeitliche Zusammenhang einfach nur Zufall ist.
Auch ausschließen kann ich nicht, dass die MariaDB Konfiguration hierfür Verantwortlich ist (Beispielsweise ein Bufferoverflow).

Es gibt mitlerweile mehrere dieser Problemschilderungen hier im Forum, die sich aber allesamt auf die Windows Releases zu beschränken scheinen.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10342
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Altrea » 08. May 2020 10:24

Mögliche Lösung:

Gehe in den Ordner "\xampp\mysql\data"
Lösche alle Dateien die mit "master-" beginnen
Lösche alle Dateien die mit "mysql_relay-bin-" beginnen
Lösche alle Dateien die mit "relay-log-" beginnen
Lösche alle Dateien die mit "ib_logfile" beginnen
Lösche alle Dateien die mit "aria_log." beginnen

Anschließend sollte MariaDB wieder starten.

Das Problem kann aber periodisch wiederkehrend, da die wirkliche Ursache noch nicht gefunden wurde.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 10342
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby helmut03 » 02. August 2020 11:30

hatte genau dasselbe Problem unmittelbar nach einem Windows-Update.
Log-Datei, nachdem ich den Empfehlungen der Löschung von Dateien wie im direkten POST davor nachgekommen bin.
2020-08-02 12:28:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-08-02 12:28:59 0 [Note] InnoDB: Uses event mutexes
2020-08-02 12:28:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-02 12:28:59 0 [Note] InnoDB: Number of pools: 1
2020-08-02 12:28:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-08-02 12:28:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-08-02 12:28:59 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-02 12:28:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-08-02 12:28:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-02 12:28:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-02 12:28:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-08-02 12:28:59 0 [Note] InnoDB: Waiting for purge to start
2020-08-02 12:28:59 0 [Note] InnoDB: 10.4.13 started; log sequence number 64308757; transaction id 5735
2020-08-02 12:28:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-08-02 12:28:59 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-08-02 12:28:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200802 12:28:59
2020-08-02 12:28:59 0 [Note] Server socket created on IP: '::'.

Sollte ich wirklich nochmals alles installieren müssen ???
Der Fehler ist doch - zumindest bei mir - reproduzierbar !!!
helmut03
 
Posts: 1
Joined: 02. August 2020 11:20
XAMPP version: 7.4.8
Operating System: Windows 10

Re: MySQL startet + stoppt sofort wieder nach Windows Update

Postby Eisvogel 2020 » 03. August 2020 11:45

Hallo zusammen,

Wenn ich wie angesprochen xam$p deinstalliere und neu aufspiele geht auch die Datenbank für meine joomla Seite verloren. Kann ich sie vorher irgendwie sichern?

Lieben Gruß
Eisvogel 2020
Eisvogel 2020
 
Posts: 4
Joined: 03. August 2020 11:37
XAMPP version: 3.2.4
Operating System: Windows 10


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 25 guests