MYSQL stoppt nach start

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

MYSQL stoppt nach start

Postby jbaben » 24. September 2021 14:24

Hallo,
ich habe das gleiche Problem, allerdings direkt nach der Installation (XAMPP 3.3.0)
Meine Ausgabe von: mysqld --defaults-file=mysql\bin\my.ini --standalone --console
Code: Select all
I2021-09-24 15:22:46 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-09-24 15:22:46 0 [Note] mysqld (mysqld 10.4.21-MariaDB) starting as process 7368 ...
2021-09-24 15:22:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-24 15:22:46 0 [Note] InnoDB: Uses event mutexes
2021-09-24 15:22:46 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-24 15:22:46 0 [Note] InnoDB: Number of pools: 1
2021-09-24 15:22:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-24 15:22:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-24 15:22:46 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-24 15:22:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-24 15:22:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-24 15:22:46 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-24 15:22:46 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-09-24 15:22:46 0 [Note] InnoDB: Waiting for purge to start
2021-09-24 15:22:46 0 [Note] InnoDB: 10.4.21 started; log sequence number 300396; transaction id 170
2021-09-24 15:22:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-09-24 15:22:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-24 15:22:46 0 [Note] Server socket created on IP: '::'.
2021-09-24 15:22:46 0 [Note] InnoDB: Buffer pool(s) load completed at 210924 15:22:46
2021-09-24 15:22:46 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-09-24 15:22:46 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.
2021-09-24 15:22:46 7 [Note] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
' to hash table2:46 7 [Note] Added new Master_info '2021-09-23 17:05:06 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
'021-09-24 15:22:46 7 [Note] Started replication for '2021-09-23 17:05:06 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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000008' position: 4
2021-09-24 15:22:46 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
': Slave I/O thread killed while connecting to master:06 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Reading of all Master_info entries succeeded
': master was :3306 8 [Note] Master '2021-09-23 17:05:06 0 [Note] Reading of all Master_info entries succeeded
2021-09-24 15:22:46 7 [Note] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table2:46 7 [Note] Added new Master_info '2021-09-23 17:05:06 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
'021-09-24 15:22:46 7 [Note] Started replication for '2021-09-23 17:05:06 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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000008' position: 4
2021-09-24 15:22:46 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master5:06 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] Added new Master_info '' to hash table
': master was :3306 10 [Note] Master '2021-09-23 17:05:06 0 [Note] Added new Master_info '' to hash table
2021-09-24 15:22:46 7 [Note] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
' to hash table2:46 7 [Note] Added new Master_info '2021-09-23 17:05:06 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 4xe: ready for connections.
'021-09-24 15:22:46 7 [Note] Started replication for '2021-09-23 17:05:06 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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2021@002d09@002d23@002017@003a05@003a06@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000008' position: 4
2021-09-24 15:22:46 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e21@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@002e21@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread killed while connecting to master5:06 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306 12 [Note] Master '2021-09-23 17:05:06 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-09-24 15:22:47 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e21@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
' to hash table2:47 7 [Note] Added new Master_info 'Version: '10.4.21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4adb.org binary distribution
'021-09-24 15:22:47 7 [Note] Started replication for 'Version: '10.4.21-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
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e21@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000008' position: 4
2021-09-24 15:22:47 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a24@003a24@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a24@003a24@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'
': Slave I/O thread killed while connecting to master21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2021-09-24 15:22:47 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d09@002d23@002017@003a24@003a24@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info', errno 2)
': Slave I/O thread exiting, read up to log 'FIRST', position 4'  socket: ''  port: 3306  mariadb.org binary distribution
2021-09-24 15:22:47 7 [ERROR] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a24@003a24@00208@0020@005bwarning@005d@0020aborted@0020connection@00208@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info' failed
': master was :3306 14 [Note] Master 'Version: '10.4.21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
2021-09-24 15:22:47 7 [Note] Added new Master_info '2021-09-23 17:24:24 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: 'ARBEITS' to hash tableonnection closed normally without authentication)
2021-09-24 15:22:47 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a24@003a24@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a24@003a24@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'
2021-09-24 15:22:47 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d09@002d23@002017@003a24@003a24@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info', errno 2)
2021-09-24 15:22:47 7 [ERROR] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a24@003a24@00209@0020@005bwarning@005d@0020aborted@0020connection@00209@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info' failed
2021-09-24 15:22:47 7 [Note] Added new Master_info '2021-09-23 17:24:24 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: 'ARBEITS' to hash tableonnection closed normally without authentication)
2021-09-24 15:22:47 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a24@003a38@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a24@003a38@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'
2021-09-24 15:22:47 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d09@002d23@002017@003a24@003a38@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info', errno 2)
2021-09-24 15:22:47 7 [ERROR] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a24@003a38@002010@0020@005bwarning@005d@0020aborted@0020connection@002010@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info' failed
2021-09-24 15:22:47 7 [Note] Added new Master_info '2021-09-23 17:24:38 10 [Warning] Aborted connection 10 to db: 'unconnected' user: 'unauthenticated' host: 'ARBEI' to hash table connection closed normally without authentication)
2021-09-24 15:22:47 7 [Note] Reading Master_info: 'master-2021@002d09@002d23@002017@003a24@003a38@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'  Relay_info:'relay-log-2021@002d09@002d23@002017@003a24@003a38@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info'
2021-09-24 15:22:47 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2021@002d09@002d23@002017@003a24@003a38@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info', errno 2)
2021-09-24 15:22:47 7 [ERROR] Initialized Master_info from 'master-2021@002d09@002d23@002017@003a24@003a38@002011@0020@005bwarning@005d@0020aborted@0020connection@002011@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027arbeitszimmer@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@0029@000d.info' failed
2021-09-24 15:22:47 7 [Note] Added new Master_info '2021-09-23 17:24:38 11 [Warning] Aborted connection 11 to db: 'unconnected' user: 'unauthenticated' host: 'ARBEI' to hash table connection closed normally without authentication)
2021-09-24 15:22:47 0 [Warning] Reading of some Master_info entries failed
2021-09-24 15:22:47 0 [ERROR] Failed to initialize multi master structures
2021-09-24 15:22:47 0 [ERROR] Aborting
Warning: Memory not freed: 256

Kann mir jemand dazu einen Tipp geben ?

MfG

Juergen B.
jbaben
 
Posts: 1
Joined: 24. September 2021 14:05
XAMPP version: 3.3.0
Operating System: WINDOWS 10 PRO

Re: MYSQL stoppt nach start

Postby Altrea » 25. September 2021 07:39

Hi,

Probiere bitte mal folgendes, das hat bei anderen schon zum Erfolg geführt :

Öffne den Ordner "\xampp\mysql\data\"
Lösche die Datei "multi-master.info"
Lösche alle Dateien deren Dateiname beginnt mit: "master-"
Lösche alle Dateien deren Dateiname beginnt mit: "mysql_relay-bin-"
Lösche alle Dateien deren Dateiname beginnt mit: "relay-log-"
Lösche alle Dateien deren Dateiname beginnt mit: "ib_logfile"
Lösche alle Dateien deren Dateiname beginnt mit: "aria_log."

Versuche nun MariaDB zu starten.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 53 guests