MySQL stoppt direkt nach Start

[rij_83]

Sehe leider nicht wo das Problem liegt, bzw. wie ich dies lösen kann. Bin froh um Hilfe. Danke.

2021-09-21 18:16:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-21 18:16:35 0 [Note] InnoDB: Uses event mutexes
2021-09-21 18:16:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-21 18:16:35 0 [Note] InnoDB: Number of pools: 1
2021-09-21 18:16:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-21 18:16:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-21 18:16:35 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-21 18:16:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-21 18:16:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-21 18:16:35 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-21 18:16:35 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-09-21 18:16:35 0 [Note] InnoDB: Waiting for purge to start
2021-09-21 18:16:35 0 [Note] InnoDB: 10.4.19 started; log sequence number 4040492; transaction id 4436
2021-09-21 18:16:35 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-09-21 18:16:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-21 18:16:35 0 [Note] Server socket created on IP: '::'.

[witschi87]

Ich habe das gleiche Problem. Gibts dazu schon eine Lösung.
Gestern ging noch alles. Heute nicht mehr. Mein Log sieht genauso aus.

[wobaM]

Auch bei mir gibt es das gleiche Problem mit dem selben Log.

[SuperMarioTM]

Habe das selbe plötzlich gestern morgen erlebt.
Habe Xampp dann gestern komplett gelöscht und neu Installiert. Anschließend hats wieder perfekt funktioniert.
HEUTE MORGEN: Wieder das selbe Problem!
Das ist das erste mal das ich mich nach einer Alternative zu Xampp umschaue.

Win 11/ Als Admin installiert, als Admin ausgeführt

2021-11-17 11:37:08 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-17 11:37:08 0 [Note] InnoDB: Uses event mutexes
2021-11-17 11:37:08 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-17 11:37:08 0 [Note] InnoDB: Number of pools: 1
2021-11-17 11:37:08 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-17 11:37:08 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-17 11:37:08 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-17 11:37:08 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-17 11:37:08 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-17 11:37:08 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-17 11:37:08 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-17 11:37:08 0 [Note] InnoDB: Waiting for purge to start
2021-11-17 11:37:08 0 [Note] InnoDB: 10.4.21 started; log sequence number 308103; transaction id 511
2021-11-17 11:37:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-17 11:37:08 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-17 11:37:08 0 [Note] Server socket created on IP: '::'.

[Altrea]

Hi,

Das log enthält leider keine Fehlermeldungen.

Versuche mit folgendem Kommand MariaDB in der XAMPP Shell als Konsolenanwendung zu starten und berichte uns, was für Rückmeldungen es dort gibt:

Code: Select all

mysqld --defaults-file=mysql\bin\my.ini --standalone --console

[SuperMarioTM]

Kannst du mir auch schnell einen Tipp geben wie ich da hin komme und die Shell öffne?
danke

[SuperMarioTM]

Danke, das wird doch nicht etwa über die Datei: "xampp_shell.bat" funktionieren!!?
Wieder was gelernt

Ich erhalte darin folgende Einträge zurück:

Code: Select all

Mario@XPS C:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-11-17 12:01:39 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-11-17 12:01:39 0 [Note] mysqld (mysqld 10.4.21-MariaDB) starting as process 4624 ...
2021-11-17 12:01:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-17 12:01:39 0 [Note] InnoDB: Uses event mutexes
2021-11-17 12:01:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-17 12:01:39 0 [Note] InnoDB: Number of pools: 1
2021-11-17 12:01:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-17 12:01:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-17 12:01:39 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-17 12:01:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-17 12:01:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-17 12:01:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-17 12:01:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-17 12:01:39 0 [Note] InnoDB: Waiting for purge to start
2021-11-17 12:01:39 0 [Note] InnoDB: 10.4.21 started; log sequence number 308121; transaction id 511
2021-11-17 12:01:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-17 12:01:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-17 12:01:39 0 [Note] Server socket created on IP: '::'.
2021-11-17 12:01:39 0 [Note] InnoDB: Buffer pool(s) load completed at 211117 12:01:39
2021-11-17 12:01:39 7 [Note] Reading Master_info: 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'  Relay_info:'relay-log-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-11-17 12:01:39 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-11-17 12:01:39 7 [Note] Initialized Master_info from 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2021-11-17 12:01:39 7 [Note] Added new Master_info '2021-11-16 10:39:36 0 [Note] Reading of all Master_info entries succ' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4ntries succeeded
2021-11-17 12:01:39 7 [Note] Started replication for '2021-11-16 10:39:36 0 [Note] Reading of all Master_info entries su'ceeded
': 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@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.000006' position: 4
2021-11-17 12:01:39 7 [Note] Reading Master_info: 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'  Relay_info:'relay-log-2021@002d11@002d16@002010@003a39@003a36@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:36 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-11-16 10:39:36 0 [Note] Reading of all Master_info entries succeeded
2021-11-17 12:01:39 7 [Note] Initialized Master_info from 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table1:39 7 [Note] Added new Master_info '2021-11-16 10:39:36 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
2021-11-17 12:01:39 7 [Note] Started replication for '2021-11-16 10:39:36 0 [Note] Added new Master_info '' to hash tabl'
': 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@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000006' position: 4
2021-11-17 12:01:39 7 [Note] Reading Master_info: 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'  Relay_info:'relay-log-2021@002d11@002d16@002010@003a39@003a36@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 master9:36 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-11-16 10:39:36 0 [Note] Added new Master_info '' to hash table
2021-11-17 12:01:39 7 [Note] Initialized Master_info from 'master-2021@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
2021-11-17 12:01:39 7 [Note] Added new Master_info '2021-11-16 10:39:36 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready fo' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
2021-11-17 12:01:39 7 [Note] Started replication for '2021-11-16 10:39:36 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready 'or connections.
2021-11-17 12:01:39 12 [ERROR] Master '2021-11-16 10:39:36 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@002d11@002d16@002010@003a39@003a36@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000006' position: 4
2021-11-17 12:01:39 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 master9:36 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-11-16 10:39:36 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2021-11-17 12:01:39 7 [ERROR] log 2021-11-16 10:47:31 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@002e listed in the index, but failed to stato'
2021-11-17 12:01:39 7 [ERROR] Error counting relay log space
2021-11-17 12:01:39 7 [ERROR] 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' failed
2021-11-17 12:01:39 7 [Note] Added new Master_info 'Version: '10.4.21-MariaDB'  socket: ''  port: 3306  mariadb.org bina' to hash table
2021-11-17 12:01:39 0 [Warning] Reading of some Master_info entries failed
2021-11-17 12:01:39 0 [ERROR] Failed to initialize multi master structures
2021-11-17 12:01:39 0 [ERROR] Aborting
Warning: Memory not freed: 16864

[Altrea]

Danke, das wird doch nicht etwa über die Datei: "xampp_shell.bat" funktionieren!!?

Genau, aber falls die Datei nicht existiert gibt es im XAMPP control Panel einen Button "Shell", dadurch wird die xampp_shell.bat erstellt.

Code: Select all

2021-11-17 12:01:39 7 [ERROR] log 2021-11-16 10:47:31 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@002e listed in the index, but failed to stato'
2021-11-17 12:01:39 7 [ERROR] Error counting relay log space
2021-11-17 12:01:39 7 [ERROR] 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' failed
2021-11-17 12:01:39 7 [Note] Added new Master_info 'Version: '10.4.21-MariaDB'  socket: ''  port: 3306  mariadb.org bina' to hash table
2021-11-17 12:01:39 0 [Warning] Reading of some Master_info entries failed
2021-11-17 12:01:39 0 [ERROR] Failed to initialize multi master structures
2021-11-17 12:01:39 0 [ERROR] Aborting
Warning: Memory not freed: 16864

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.

[SuperMarioTM]

Vielen Dank!!!
Das hat das Problem vorerst gefixt.

Kannst Du daraus erkennen was schief gelaufen ist?
Ich frag das weil das das erste mal in 15 Jahren der Fall ist das mich XAMPP im Stich lässt und ich mich darauf verlassen können muss.
Ist das ein Bekanntes Problem das gefixt wird oder so?

Als Alternative habe ich mal wamp installiert über welches ich seit gestern arbeite.

Danke

Code: Select all

Setting environment for using XAMPP for Windows.
Mario@XPS C:\xampp
# mysqld --defaults-file=mysql\bin\my.ini --standalone --console
2021-11-18 15:43:30 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-11-18 15:43:30 0 [Note] mysqld (mysqld 10.4.21-MariaDB) starting as process 16736 ...
2021-11-18 15:43:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-11-18 15:43:30 0 [Note] InnoDB: Uses event mutexes
2021-11-18 15:43:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-11-18 15:43:30 0 [Note] InnoDB: Number of pools: 1
2021-11-18 15:43:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-11-18 15:43:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-11-18 15:43:30 0 [Note] InnoDB: Completed initialization of buffer pool
2021-11-18 15:43:30 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2021-11-18 15:43:30 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2021-11-18 15:43:30 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2021-11-18 15:43:30 0 [Note] InnoDB: New log files created, LSN=308130
2021-11-18 15:43:30 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-11-18 15:43:30 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-11-18 15:43:30 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-11-18 15:43:30 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-11-18 15:43:30 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-11-18 15:43:30 0 [Note] InnoDB: Waiting for purge to start
2021-11-18 15:43:30 0 [Note] InnoDB: 10.4.21 started; log sequence number 308236; transaction id 511
2021-11-18 15:43:30 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-11-18 15:43:30 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\plugin'
2021-11-18 15:43:30 0 [Note] InnoDB: Buffer pool(s) load completed at 211118 15:43:30
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\servers'
2021-11-18 15:43:30 0 [Note] Server socket created on IP: '::'.
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\db'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\proxies_priv'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\roles_mapping'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\global_priv'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\time_zone_leap_second'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\time_zone_name'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\time_zone'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\time_zone_transition_type'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\time_zone_transition'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\tables_priv'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\columns_priv'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\procs_priv'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\func'
2021-11-18 15:43:30 0 [Note] Zerofilling moved table:  '.\mysql\event'
2021-11-18 15:43:30 0 [Note] Reading of all Master_info entries succeeded
2021-11-18 15:43:30 0 [Note] Added new Master_info '' to hash table
2021-11-18 15:43:30 0 [Note] mysqld: ready for connections.
Version: '10.4.21-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution