error while starting the mysql

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

error while starting the mysql

Postby lazyman123 » 28. July 2021 08:12

hello,
I have installed xampp, I start the apache and it works, then I click on mysql , its stops and give me error.
the error message is below, it was working yesterday perfect, I don't change anything, I don't know what happen. If anyone can help me with it, it would be great. Thanks in advance.
error:
[code]10:02:27 AM [main] Initializing Control Panel
10:02:27 AM [main] Windows Version: Home 64-bit
10:02:27 AM [main] XAMPP Version: 7.4.16
10:02:27 AM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
10:02:27 AM [main] Running with Administrator rights - good!
10:02:27 AM [main] XAMPP Installation Directory: "c:\xampp\"
10:02:27 AM [main] Checking for prerequisites
10:02:27 AM [main] All prerequisites found
10:02:27 AM [main] Initializing Modules
10:02:27 AM [main] Starting Check-Timer
10:02:27 AM [main] Control Panel Ready
10:02:29 AM [Apache] Attempting to start Apache app...
10:02:29 AM [Apache] Status change detected: running
10:02:32 AM [mysql] Attempting to start MySQL app...
10:02:32 AM [mysql] Status change detected: running
10:02:34 AM [mysql] Status change detected: stopped
10:02:34 AM [mysql] Error: MySQL shutdown unexpectedly.
10:02:34 AM [mysql] This may be due to a blocked port, missing dependencies,
10:02:34 AM [mysql] improper privileges, a crash, or a shutdown by another method.
10:02:34 AM [mysql] Press the Logs button to view error logs and check
10:02:34 AM [mysql] the Windows Event Viewer for more clues
10:02:34 AM [mysql] If you need more help, copy and post this
10:02:34 AM [mysql] entire log window on the forums
[/code]

and this is the log file:

[code]InnoDB: using atomic writes.
2021-04-23 14:49:47 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-23 14:49:47 0 [Note] InnoDB: Uses event mutexes
2021-04-23 14:49:47 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-23 14:49:47 0 [Note] InnoDB: Number of pools: 1
2021-04-23 14:49:47 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-23 14:49:47 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-23 14:49:47 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-23 14:49:47 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2021-04-23 14:49:47 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-23 14:49:47 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-23 14:49:47 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-23 14:49:47 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-23 14:49:47 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-23 14:49:47 0 [Note] InnoDB: Waiting for purge to start
2021-04-23 14:49:48 0 [Note] InnoDB: 10.4.18 started; log sequence number 300297; transaction id 170
2021-04-23 14:49:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-23 14:49:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-23 14:49:48 0 [Note] InnoDB: Buffer pool(s) load completed at 210423 14:49:48
2021-04-23 14:49:48 0 [Note] Server socket created on IP: '::'.
2021-04-23 18:03:51 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 100% (0.0 seconds); tables to flush: 1 0
(0.0 seconds);
2021-04-23 18:03:51 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2021-04-23 18:03:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-23 18:03:51 0 [Note] InnoDB: Uses event mutexes
2021-04-23 18:03:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-23 18:03:51 0 [Note] InnoDB: Number of pools: 1
2021-04-23 18:03:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-23 18:03:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-23 18:03:51 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-23 18:03:51 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=301618
2021-04-23 18:03:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-23 18:03:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-23 18:03:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-23 18:03:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-04-23 18:03:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-04-23 18:03:51 0 [Note] InnoDB: Waiting for purge to start
2021-04-23 18:03:52 0 [Note] InnoDB: 10.4.18 started; log sequence number 301627; transaction id 199
2021-04-23 18:03:52 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-04-23 18:03:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-04-23 18:03:52 0 [Note] InnoDB: Buffer pool(s) load completed at 210423 18:03:52
2021-04-23 18:03:52 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-04-24 0:05:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-04-24 0:05:37 0 [Note] InnoDB: Uses event mutexes
2021-04-24 0:05:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-04-24 0:05:37 0 [Note] InnoDB: Number of pools: 1
2021-04-24 0:05:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-04-24 0:05:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-04-24 0:05:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-04-24 0:05:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=301636
2021-04-24 0:05:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-04-24 0:05:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-04-24 0:05:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-04-24 0:05:37 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
[/code]
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: error while starting the mysql

Postby Altrea » 28. July 2021 10:14

Hi,

This log does not contain any errors.

Try to start MariaDB as console application in XAMPP Shell with the following command and tell us what it responses.
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: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: error while starting the mysql

Postby lazyman123 » 29. July 2021 22:23

here is the error log I get from xampp.
Code: Select all
https://mega.nz/file/cpcSRBBR#Q47ZsXmWJYg7XSNSpzM_0_mvVokhuZsFiqeD1op5u7U
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: error while starting the mysql

Postby lazyman123 » 01. August 2021 12:46

In xampp I take the log file, and since it's a long file, and I can't paste it here, I upload it in the link above.
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: error while starting the mysql

Postby lazyman123 » 01. August 2021 12:51

Altrea wrote:Hi,

This log does not contain any errors.

Try to start MariaDB as console application in XAMPP Shell with the following command and tell us what it responses.
Code: Select all
mysqld --defaults-file=mysql\bin\my.ini --standalone --console


I do what you say, and here is the result, I upload all the text that it gave me to text file and put it in the link below.

Code: Select all
https://mega.nz/file/JkMRxSxD#5jkbEyWEMGVfmY8R553TqmAJvJQwirxNHg3rVQ56gqk
lazyman123
 
Posts: 12
Joined: 04. April 2021 18:29
XAMPP version: 8.0.3
Operating System: windows 10

Re: error while starting the mysql

Postby Altrea » 06. August 2021 07:15

Hi,

lazyman123 wrote:I do what you say, and here is the result, I upload all the text that it gave me to text file and put it in the link below.

Code: Select all
https://mega.nz/file/JkMRxSxD#5jkbEyWEMGVfmY8R553TqmAJvJQwirxNHg3rVQ56gqk

There are two problems here.

2021-08-01 14:49:47 12 [ERROR] Master '2021-07-28 8:26:29 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@002d07@002d28@0020@00208@003a26@003a29@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000010' position: 4

XAMPP does not configure Master Slave replication, but there is a common bug this Master Slave replication related.
You should solve this first and check if MariaDB is running again:

  • Open your folder "\xampp\mysql\data"
  • Delete the file "multi-master.info"
  • Delete all files beginning with "master-"
  • Delete all files beginning with "mysql_relay-bin-"
  • Delete all files beginning with "relay-log-"
  • Delete all files beginning with "ib_logfile"
  • Delete all files beginning with "aria_log."

2021-08-01 14:49:46 0 [ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 288046 is in the future! Current system log sequence number 47133.
2021-08-01 14:49:46 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to https://mariadb.com/kb/en/library/innod ... ery-modes/ for information about forcing recovery.

The easiest solution for that is to copy the backed up files. But be aware of data loss. It is recommend to do a backup of the current state of your mysql\data folder first

https://stackoverflow.com/a/63503565 wrote:
  • Step 1: Moved(cut/paste) all the files in C:\xampp\mysql\data to desired backup location.
  • Step 2: After that copied all the files from C:\xampp\mysql\backup to C:\xampp\mysql\data
  • Step 3: Restarted mysql and checked the phpmyadmin url, it worked.
  • Step 4: After that stopped mysql that copied ibdata1 file from backup location to C:\xampp\mysql\data
  • Step 5: Restarted mysql
  • Step 6: After that copied all database folders and checked all the tables, It worked.
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 MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 32 guests