MySQL startet nicht mehr

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

MySQL startet nicht mehr

Postby Fiesi » 01. January 2021 10:08

Moin,

Erstmal ein Gesundes neues euch ;)

Ich hab so ein ähnliches Problem.
Ich habe den aber nirgens als Slave "angemeldet".
Oder verstehe ich den Error da falsch ? ^^

Wenn ich es über Xampp startet hab ich den Fehler:

Code: Select all
InnoDB: using atomic writes.
2021-01-01 10:00:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-01 10:00:09 0 [Note] InnoDB: Uses event mutexes
2021-01-01 10:00:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-01 10:00:09 0 [Note] InnoDB: Number of pools: 1
2021-01-01 10:00:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-01 10:00:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-01 10:00:09 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-01 10:00:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-01 10:00:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-01 10:00:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-01 10:00:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-01 10:00:09 0 [Note] InnoDB: Waiting for purge to start
2021-01-01 10:00:10 0 [Note] InnoDB: 10.4.13 started; log sequence number 138648378; transaction id 201133
2021-01-01 10:00:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-01 10:00:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-01 10:00:10 0 [Note] Server socket created on IP: '::'.
2021-01-01 10:00:10 0 [Note] InnoDB: Buffer pool(s) load completed at 210101 10:0InnoDB: using atomic writes.
2021-01-01 10:01:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-01 10:01:53 0 [Note] InnoDB: Uses event mutexes
2021-01-01 10:01:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-01 10:01:53 0 [Note] InnoDB: Number of pools: 1
2021-01-01 10:01:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-01 10:01:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-01 10:01:53 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-01 10:01:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-01 10:01:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-01 10:01:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-01 10:01:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-01 10:01:53 0 [Note] InnoDB: Waiting for purge to start
2021-01-01 10:01:53 0 [Note] InnoDB: 10.4.13 started; log sequence number 138648387; transaction id 201133
2021-01-01 10:01:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-01 10:01:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-01 10:01:53 0 [Note] Server socket created on IP: '127.0.0.1'.


direkt über die Console kommen ja mehr Infos:

Code: Select all
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-01-01 10:07:00 0 [Note] Using unique option prefix 'key_buf...' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2021-01-01 10:07:00 0 [Note] mysqld (mysqld 10.4.13-MariaDB) starting as process 5404 ...
InnoDB: using atomic writes.
2021-01-01 10:07:00 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-01 10:07:00 0 [Note] InnoDB: Uses event mutexes
2021-01-01 10:07:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-01 10:07:00 0 [Note] InnoDB: Number of pools: 1
2021-01-01 10:07:00 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-01 10:07:00 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-01 10:07:00 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-01 10:07:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-01 10:07:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-01 10:07:00 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-01 10:07:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-01 10:07:01 0 [Note] InnoDB: Waiting for purge to start
2021-01-01 10:07:01 0 [Note] InnoDB: 10.4.13 started; log sequence number 138648396; transaction id 201133
2021-01-01 10:07:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-01 10:07:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-01 10:07:01 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-01-01 10:07:01 0 [Note] InnoDB: Buffer pool(s) load completed at 210101 10:07:01
2021-01-01 10:07:01 7 [Note] Reading Master_info: 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-01-01 10:07:01 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-01-01 10:07:01 7 [Note] Initialized Master_info from 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
' to hash table7:01 7 [Note] Added new Master_info '2020-12-27 18:31:19 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
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'021-01-01 10:07:01 7 [Note] Started replication for '2020-12-27 18:31:19 0 [Note] Reading of all Master_info entries succeeded
': Slave I/O thread killed while connecting to master:19 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@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000002' position: 4
2021-01-01 10:07:01 7 [Note] Reading Master_info: 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2020@002d12@002d27@002018@003a31@003a19@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-01-01 10:07:01 7 [Note] Initialized Master_info from 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table7:01 7 [Note] Added new Master_info '2020-12-27 18:31:19 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
'021-01-01 10:07:01 7 [Note] Started replication for '2020-12-27 18:31:19 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread killed while connecting to master1:19 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@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000002' position: 4
2021-01-01 10:07:01 7 [Note] Reading Master_info: 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020c@003a@005cxampp@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-01-01 10:07:01 7 [Note] Initialized Master_info from 'master-2020@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
' to hash table7:01 7 [Note] Added new Master_info '2020-12-27 18:31:19 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.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'021-01-01 10:07:01 7 [Note] Started replication for '2020-12-27 18:31:19 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread killed while connecting to master1:19 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@002d12@002d27@002018@003a31@003a19@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000002' position: 4
2021-01-01 10:07:01 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e13@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@002e13@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-01-01 10:07:01 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e13@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
' to hash table7:01 7 [Note] Added new Master_info 'Version: '10.4.13-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
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'021-01-01 10:07:01 7 [Note] Started replication for 'Version: '10.4.13-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
': Slave I/O thread killed while connecting to master13-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@002e13@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000002' position: 4
2021-01-01 10:07:01 7 [Note] Reading Master_info: 'master-2020@002d12@002d27@002018@003a40@003a20@002054@0020@005bwarning@005d@0020aborted@0020connection@002054@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027michael@002dkipp@002ecom@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@.info'  Relay_info:'relay-log-2020@002d12@002d27@002018@003a40@003a20@002054@0020@005bwarning@005d@0020aborted@0020connection@002054@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027michael@002dkipp@002ecom@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4'  socket: ''  port: 3306  mariadb.org binary distribution
2021-01-01 10:07:01 7 [ERROR] Failed to create a new master info file (file 'C:\xampp\mysql\data\master-2020@002d12@002d27@002018@003a40@003a20@002054@0020@005bwarning@005d@0020aborted@0020connection@002054@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027michael@002dkipp@002ecom@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@.info', errno 2)
2021-01-01 10:07:01 7 [ERROR] Initialized Master_info from 'master-2020@002d12@002d27@002018@003a40@003a20@002054@0020@005bwarning@005d@0020aborted@0020connection@002054@0020to@0020db@003a@0020@0027unconnected@0027@0020user@003a@0020@0027unauthenticated@0027@0020host@003a@0020@0027michael@002dkipp@002ecom@0027@0020@0028this@0020connection@0020closed@0020normally@0020without@0020authentication@.info' failed
2021-01-01 10:07:01 7 [Note] Added new Master_info '2020-12-27 18:40:20 54 [Warning] Aborted connection 54 to db: 'unconnected' user: 'unauthenticated' host: 'michael-kipp.com' (This connection clos' to hash tablehout authentication)
2021-01-01 10:07:01 0 [Warning] Reading of some Master_info entries failed
2021-01-01 10:07:01 0 [ERROR] Failed to initialize multi master structures
2021-01-01 10:07:01 0 [ERROR] Aborting
Warning: Memory not freed: 256


Evtl hat ja jemand nen Tip an was es liegen könnte - Ich blick da gerade gar net durch.
Fiesi
 
Posts: 2
Joined: 01. January 2021 10:01
XAMPP version: 3.2.4
Operating System: Win10 / Debian10

Re: MySQL startet nicht mehr

Postby Altrea » 01. January 2021 10:17

Hallo und frohes neues Jahr :D ,

Versuche bitte mal folgendes:

Ö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: 10727
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL startet nicht mehr

Postby Fiesi » 01. January 2021 15:30

Danke, hat Funktioniert.
Er startet wieder.

Woher kam dieser Fehler jetzt ?
Fiesi
 
Posts: 2
Joined: 01. January 2021 10:01
XAMPP version: 3.2.4
Operating System: Win10 / Debian10

Re: MySQL startet nicht mehr

Postby Altrea » 01. January 2021 15:43

Das ist nicht abschließend geklärt. Das Problem scheint aber nur bei Windows und nicht bei Linux aufzutreten, obwohl die MariaDB Konfiguration beider Betriebssysteme sich sehr ähneln.

Ich vermute, dass das Problem entweder mit der Art und Weise zusammenhängt, wie XAMPP MariaDB beendet (das ist nicht ganz sauber gelöst) oder mit der MariaDB Konfiguration an sich (die schon ziemlich alt ist und über neue MariaDB Versionen einfach immer wieder übertragen 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: 10727
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 18 guests