Search found 2128 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

Re: Error starting MySQL

It looks like I have data corruption in the few InnoDB tables. So this looks like an issue local to my install.
by g2ktcf
14. April 2024 19:20
 
Forum: XAMPP for Windows
Topic: Error starting MySQL
Replies: 7
Views: 1315

Problem detected! Port 3306 in use. MySQL WILL NOT start.

I just ran a fresh install of the application for a college course, but am having issues with my machine running the program. Please see the log from the Control Panel below and then the actual log for MySQL below that.

Problem detected! Port 3306 in use by "Unable to open process"! MySQL WILL NOT start without the configured ports free!You need to uninstall/disable/reconfigure the blocking application or reconfigure MySQL and the Control Panel to listen on a different port

15:56:22 [main] Initializing Control Panel
15:56:22 [main] Windows Version: Enterprise 64-bit
15:56:22 [main] XAMPP Version: 8.2.12
15:56:22 [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
15:56:22 [main] You are not running with administrator rights! This will work for
15:56:22 [main] most application stuff but whenever you do something with services
15:56:22 [main] there will be a security dialogue or things will break! So think
15:56:22 [main] about running this application with administrator rights!
15:56:22 [main] XAMPP Installation Directory: "c:\xampp\"
15:56:22 [main] Checking for prerequisites
15:56:23 [main] All prerequisites found
15:56:23 [main] Initializing Modules
15:56:23 [mysql] Problem detected!
15:56:23 [mysql] Port 3306 in use by "Unable to open process"!
15:56:23 [mysql] MySQL WILL NOT start without the configured ports free!
15:56:23 [mysql] You need to uninstall/disable/reconfigure the blocking application
15:56:23 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
15:56:23 [main] Starting Check-Timer
15:56:23 [main] Control Panel Ready
15:58:02 [mysql] Problem detected!
15:58:02 [mysql] Port 3306 in use by "Unable to open process"!
15:58:02 [mysql] MySQL WILL NOT start without the configured ports free!
15:58:02 [mysql] You need to uninstall/disable/reconfigure the blocking application
15:58:02 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
15:58:02 [mysql] Attempting to start MySQL app...
15:58:03 [mysql] Status change detected: running
15:58:05 [mysql] Status change detected: stopped
15:58:05 [mysql] Error: MySQL shutdown unexpectedly.
15:58:05 [mysql] This may be due to a blocked port, missing dependencies,
15:58:05 [mysql] improper privileges, a crash, or a shutdown by another method.
15:58:05 [mysql] Press the Logs button to view error logs and check
15:58:05 [mysql] the Windows Event Viewer for more clues
15:58:05 [mysql] If you need more help, copy and post this
15:58:05 [mysql] entire log window on the forums

This is the log report...

2024-04-10 15:58:03 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 3352
2024-04-10 15:58:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 15:58:03 0 [Note] InnoDB: Uses event mutexes
2024-04-10 15:58:03 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 15:58:03 0 [Note] InnoDB: Number of pools: 1
2024-04-10 15:58:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 15:58:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 15:58:03 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 15:58:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-04-10 15:58:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-10 15:58:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-10 15:58:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-10 15:58:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-10 15:58:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-10 15:58:03 0 [Note] InnoDB: Waiting for purge to start
2024-04-10 15:58:03 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-04-10 15:58:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-10 15:58:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-10 15:58:03 0 [Note] Server socket created on IP: '::'.
2024-04-10 15:58:03 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-10 15:58:03 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-10 15:58:03 0 [ERROR] Aborting
2024-04-10 16:02:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 6772
2024-04-10 16:02:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 16:02:19 0 [Note] InnoDB: Uses event mutexes
2024-04-10 16:02:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 16:02:19 0 [Note] InnoDB: Number of pools: 1
2024-04-10 16:02:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 16:02:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 16:02:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 16:02:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-10 16:02:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-10 16:02:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-10 16:02:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-10 16:02:20 0 [Note] InnoDB: Waiting for purge to start
2024-04-10 16:02:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 300306; transaction id 170
2024-04-10 16:02:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-10 16:02:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-10 16:02:20 0 [Note] Server socket created on IP: '::'.
2024-04-10 16:02:20 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-10 16:02:20 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-10 16:02:20 0 [Note] InnoDB: Buffer pool(s) load completed at 240410 16:02:20
2024-04-10 16:02:20 0 [ERROR] Aborting


PLEASE advise. Thank you sincerely!

Rob K



Update - I made a change to properties.ini for the port used by MySQL to 9080 and it runs now.
https://www.wikihow.com/Install-XAMPP-for-Windows
by rkontominas
10. April 2024 22:22
 
Forum: XAMPP for Windows
Topic: Problem detected! Port 3306 in use. MySQL WILL NOT start.
Replies: 0
Views: 197

Mysql startet nicht

Problem beim Starten MySQL
Also ich mittlerweile alles was ich im SForum gelesen habe - ausprobiert und vermute nun, dass ich mir die Datenbank ganz zerschossen habe. Aber vielleicht kann mir auch nochjemand von Euch helfen?

Das Control Panel sagt : Fehler: MySQL wurde unerwartet beendet
Mittlerweile habe ich schon das backup als data in mein Verzeichnis kopiert und auch die ibdata1 Datei aus der data old übernommen. -> erhalte aber immer noch die alte Fehlermeldung.
Bei den logs habe ich mittlerweile etwas Neues (ich glaube das hängt mit dem kopieren zusammen) :


2024-04-09 21:16:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-09 21:16:05 0 [Note] InnoDB: Waiting for purge to start
2024-04-09 21:16:05 0 [Note] InnoDB: 10.4.32 started; log sequence number 300369; transaction id 170
2024-04-09 21:16:05 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-09 21:16:05 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-09 21:16:05 0 [Note] Server socket created on IP: '::'.
2024-04-10 16:44:20 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 15704
2024-04-10 16:44:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 16:44:20 0 [Note] InnoDB: Uses event mutexes
2024-04-10 16:44:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 16:44:20 0 [Note] InnoDB: Number of pools: 1
2024-04-10 16:44:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 16:44:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 16:44:20 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 16:44:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300378
2024-04-10 16:44:20 0 [Warning] InnoDB: Are you sure you are using the right ib_logfiles to start up the database? Log sequence number in the ib_logfiles is 300378, less than the log sequence number in the first system tablespace file header, 55852598.
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=326] with future log sequence number 33379527
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=301] with future log sequence number 55509468
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=285] with future log sequence number 55509197
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=366] with future log sequence number 55509197
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring a doublewrite copy of page [page id: space=0, page number=284] with future log sequence number 55508977

das geht so weiter bis space 57 page number 5

2024-04-10 16:44:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 55044502 is in the future! Current system log sequence number 300396.
2024-04-10 16:44:20 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=2] log sequence number 53315304 is in the future! Current system log sequence number 300396.
2024-04-10 16:44:20 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=4] log sequence number 48821877 is in the future! Current system log sequence number 300396.
2024-04-10 16:44:20 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Page [page id: space=0, page number=11] log sequence number 55694219 is in the future! Current system log sequence number 300396.

auch das geht so weiter .....

2024-04-10 16:44:20 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2024-04-10 16:44:20 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2024-04-10 16:44:20 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\gtid_slave_pos.ibd' OS error: 203
2024-04-10 16:44:20 0 [ERROR] InnoDB: Operating system error number 203 in a file operation.
2024-04-10 16:44:20 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2024-04-10 16:44:20 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`gtid_slave_pos``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`gtid_slave_pos` because it could not be opened.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2024-04-10 16:44:20 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2024-04-10 16:44:20 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\mysql\innodb_index_stats.ibd' OS error: 203
2024-04-10 16:44:20 0 [ERROR] InnoDB: Operating system error number 203 in a file operation.
2024-04-10 16:44:20 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2024-04-10 16:44:20 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``mysql`.`innodb_index_stats``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2024-04-10 16:44:20 0 [Warning] InnoDB: Ignoring tablespace for `mysql`.`innodb_index_stats` because it could not be opened.
2024-04-10 16:44:20 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2024-04-10 16:44:20 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2024-04-10 16:44:20 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

......

2024-04-10 16:44:20 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-04-10 16:44:20 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:44:20 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2024-04-10 16:44:20 0 [Note] InnoDB: Buffer pool(s) load completed at 240410 16:44:20
2024-04-10 16:44:20 0 [Note] Server socket created on IP: '::'.
2024-04-10 16:50:33 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 10180
2024-04-10 16:50:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-10 16:50:33 0 [Note] InnoDB: Uses event mutexes
2024-04-10 16:50:33 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-10 16:50:33 0 [Note] InnoDB: Number of pools: 1
2024-04-10 16:50:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-10 16:50:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-10 16:50:33 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-10 16:50:33 0 [ERROR] InnoDB: Page [page id: space=0, page number=7] log sequence number 55044502 is in the future! Current system log sequence number 300405.
2024-04-10 16:50:33 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/innodb-recovery-modes/ for information about forcing recovery.
2024-04-10 16:50:33 0 [ERROR] InnoDB: Page [page id: space=0, page number=2] log sequence number 53315304 is in the future! Current system log sequence number 300405.

.......
Ich will jetzt nicht den ganzen Text hier kopieren...... (kann ich bei Bedarf gerne machen....)

Mir ist nur aufgefallen, dass ich immer lese, dass ein plugin 'feedback' disabeled ist. Ich hatte gestren noch neue plugins installiert - ob es daran liegt?
Ich würde mich echt freuen, wenn mir jemand hefen könnte .....
by katinka65
10. April 2024 16:04
 
Forum: MariaDB - MySQL
Topic: Mysql startet nicht
Replies: 0
Views: 147

my mysql refuse to start due to a blocked port

2024-03-06 1:04:25 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 7812
2024-03-06 1:04:25 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-06 1:04:25 0 [Note] InnoDB: Uses event mutexes
2024-03-06 1:04:25 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-06 1:04:25 0 [Note] InnoDB: Number of pools: 1
2024-03-06 1:04:25 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-06 1:04:25 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-06 1:04:25 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-06 1:04:25 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-03-06 1:04:25 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-06 1:04:25 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-06 1:04:25 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-06 1:04:25 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-06 1:04:25 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-06 1:04:25 0 [Note] InnoDB: Waiting for purge to start
by bamba
05. April 2024 22:50
 
Forum: XAMPP for Windows
Topic: my mysql refuse to start due to a blocked port
Replies: 1
Views: 513

MySQL won't start

I'm getting an error when I attempt to start the MySQL module within XAMPP Control Panel v3.3.0. Below is the log file for MySQL. This problem has been on going and restarting the computer does not fix this problem. Any assistance would be most welcomed and thank you!
-----
2024-03-20 14:56:21 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23176
2024-03-20 14:56:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-20 14:56:21 0 [Note] InnoDB: Uses event mutexes
2024-03-20 14:56:21 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-20 14:56:21 0 [Note] InnoDB: Number of pools: 1
2024-03-20 14:56:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-20 14:56:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-20 14:56:21 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-20 14:56:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-03-20 14:56:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-20 14:56:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-20 14:56:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-20 14:56:21 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-20 14:56:21 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-20 14:56:21 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-03-20 14:56:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-20 14:56:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-20 14:56:21 0 [Note] InnoDB: Buffer pool(s) load completed at 240320 14:56:21
2024-03-20 14:56:21 0 [Note] Server socket created on IP: '::'.
2024-04-02 11:26:09 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 19796
2024-04-02 11:26:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 11:26:09 0 [Note] InnoDB: Uses event mutexes
2024-04-02 11:26:09 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 11:26:09 0 [Note] InnoDB: Number of pools: 1
2024-04-02 11:26:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 11:26:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 11:26:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 11:26:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=393096781
2024-04-02 11:26:10 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 11:26:10 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-02 11:26:10 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 11:26:10 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 11:26:10 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 11:26:10 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 11:26:10 0 [Note] InnoDB: 10.4.32 started; log sequence number 393096790; transaction id 48612
2024-04-02 11:26:10 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-02 11:26:10 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 11:26:10 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 11:26:10
2024-04-02 11:26:10 0 [Note] Server socket created on IP: '::'.
2024-04-05 11:22:52 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1612
Cannot find checkpoint record at LSN (1,0x5c8e)
2024-04-05 11:22:52 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-04-05 11:22:52 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-04-05 11:22:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-05 11:22:52 0 [Note] InnoDB: Uses event mutexes
2024-04-05 11:22:52 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-05 11:22:52 0 [Note] InnoDB: Number of pools: 1
2024-04-05 11:22:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-05 11:22:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-05 11:22:52 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-05 11:22:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=404114739
2024-04-05 11:22:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-05 11:22:54 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-05 11:22:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-05 11:22:54 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-05 11:22:54 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-05 11:22:54 0 [Note] InnoDB: 10.4.32 started; log sequence number 404114748; transaction id 56402
2024-04-05 11:22:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-05 11:22:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-05 11:22:54 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-04-05 11:22:54 0 [ERROR] Failed to initialize plugins.
2024-04-05 11:22:54 0 [ERROR] Aborting
2024-04-05 11:23:40 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 3720
Cannot find checkpoint record at LSN (1,0x5c8e)
2024-04-05 11:23:40 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-04-05 11:23:40 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-04-05 11:23:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-05 11:23:40 0 [Note] InnoDB: Uses event mutexes
2024-04-05 11:23:40 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-05 11:23:40 0 [Note] InnoDB: Number of pools: 1
2024-04-05 11:23:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-05 11:23:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-05 11:23:40 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-05 11:23:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-05 11:23:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-05 11:23:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-05 11:23:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-05 11:23:40 0 [Note] InnoDB: 10.4.32 started; log sequence number 404114757; transaction id 56402
2024-04-05 11:23:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-05 11:23:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-05 11:23:40 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-04-05 11:23:40 0 [Note] InnoDB: Buffer pool(s) load completed at 240405 11:23:40
2024-04-05 11:23:40 0 [ERROR] Failed to initialize plugins.
2024-04-05 11:23:40 0 [ERROR] Aborting
2024-04-05 11:38:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8356
Cannot find checkpoint record at LSN (1,0x5c8e)
2024-04-05 11:38:19 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-04-05 11:38:19 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-04-05 11:38:19 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-05 11:38:19 0 [Note] InnoDB: Uses event mutexes
2024-04-05 11:38:19 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-05 11:38:19 0 [Note] InnoDB: Number of pools: 1
2024-04-05 11:38:19 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-05 11:38:19 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-05 11:38:19 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-05 11:38:19 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-05 11:38:19 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-05 11:38:19 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-05 11:38:19 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-05 11:38:19 0 [Note] InnoDB: 10.4.32 started; log sequence number 404114766; transaction id 56402
2024-04-05 11:38:19 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-05 11:38:19 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-05 11:38:19 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-04-05 11:38:19 0 [Note] InnoDB: Buffer pool(s) load completed at 240405 11:38:19
2024-04-05 11:38:19 0 [ERROR] Failed to initialize plugins.
2024-04-05 11:38:19 0 [ERROR] Aborting
2024-04-05 11:46:39 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18192
Cannot find checkpoint record at LSN (1,0x5c8e)
2024-04-05 11:46:39 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-04-05 11:46:39 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-04-05 11:46:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-05 11:46:39 0 [Note] InnoDB: Uses event mutexes
2024-04-05 11:46:39 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-05 11:46:39 0 [Note] InnoDB: Number of pools: 1
2024-04-05 11:46:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-05 11:46:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-05 11:46:39 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-05 11:46:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-05 11:46:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-05 11:46:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-05 11:46:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-05 11:46:39 0 [Note] InnoDB: 10.4.32 started; log sequence number 404114775; transaction id 56402
2024-04-05 11:46:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-04-05 11:46:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-05 11:46:39 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-04-05 11:46:39 0 [Note] InnoDB: Buffer pool(s) load completed at 240405 11:46:39
2024-04-05 11:46:39 0 [ERROR] Failed to initialize plugins.
2024-04-05 11:46:39 0 [ERROR] Aborting
by kalasoft
05. April 2024 17:08
 
Forum: XAMPP for Windows
Topic: MySQL won't start
Replies: 0
Views: 400

Re: MySQL keeps shutting down

I'm experiencing a similar issue with MySQL through XAMPP constantly crashing, and I'm struggling to figure out the root cause. Thanks in advance for any assistance.

Here's the error log I'm encountering:
2024-03-20 14:50:50 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1564
2024-03-20 14:50:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-20 14:50:50 0 [Note] InnoDB: Uses event mutexes
2024-03-20 14:50:50 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-20 14:50:50 0 [Note] InnoDB: Number of pools: 1
2024-03-20 14:50:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-20 14:50:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-20 14:50:50 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-20 14:50:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-03-20 14:50:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-20 14:50:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-20 14:50:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-20 14:50:51 0 [Note] InnoDB: Setting file 'C:https://capcutproapk.org/\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-20 14:50:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-20 14:50:51 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-03-20 14:50:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-20 14:50:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-20 14:50:51 0 [Note] InnoDB: Buffer pool(s) load completed at 240320 14:50:51
2024-03-20 14:50:51 0 [Note] Server socket created on IP: '::'.

If anyone has insights or suggestions on how to resolve this, it would be greatly appreciated.
by joeroot6543
04. April 2024 15:45
 
Forum: XAMPP for Windows
Topic: MySQL keeps shutting down
Replies: 2
Views: 1502

MySQL server doesn't launch on XAMPP after installation

2024-04-02 13:27:52 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 3136
2024-04-02 13:27:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:27:52 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:27:52 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:27:52 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:27:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:27:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:27:52 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:27:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-04-02 13:27:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:27:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-04-02 13:27:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:27:52 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:27:52 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:27:52 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:27:52 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-04-02 13:27:52 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:27:52 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:27:52 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:27:52 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:27:52 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:27:52 0 [ERROR] Aborting
2024-04-02 13:29:53 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22204
2024-04-02 13:29:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:29:54 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:29:54 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:29:54 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:29:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:29:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:29:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:29:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:29:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:29:54 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:29:54 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:29:54 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:29:54 0 [Note] InnoDB: 10.4.32 started; log sequence number 300306; transaction id 170
2024-04-02 13:29:54 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:29:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:29:54 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:29:54 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:29:54 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:29:54 0 [ERROR] Aborting
2024-04-02 13:32:11 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 16856
2024-04-02 13:32:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:32:11 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:32:11 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:32:11 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:32:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:32:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:32:11 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:32:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:32:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:32:13 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:32:13 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:32:13 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:32:13 0 [Note] InnoDB: 10.4.32 started; log sequence number 300315; transaction id 170
2024-04-02 13:32:13 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:32:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:32:13 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 13:32:13
2024-04-02 13:32:13 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:32:13 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:32:13 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:32:13 0 [ERROR] Aborting
2024-04-02 13:38:01 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 13676
2024-04-02 13:38:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:38:02 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:38:02 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:38:02 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:38:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:38:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:38:02 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:38:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:38:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:38:02 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:38:02 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:38:02 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:38:02 0 [Note] InnoDB: 10.4.32 started; log sequence number 300324; transaction id 170
2024-04-02 13:38:02 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:38:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:38:02 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 13:38:02
2024-04-02 13:38:02 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:38:02 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:38:02 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:38:02 0 [ERROR] Aborting
2024-04-02 13:38:07 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18840
2024-04-02 13:38:07 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:38:07 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:38:07 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:38:07 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:38:07 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:38:07 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:38:07 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:38:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:38:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:38:07 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:38:07 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:38:07 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:38:07 0 [Note] InnoDB: 10.4.32 started; log sequence number 300333; transaction id 170
2024-04-02 13:38:07 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:38:07 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:38:07 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:38:07 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:38:07 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:38:07 0 [ERROR] Aborting
2024-04-02 13:40:06 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8284
2024-04-02 13:40:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:40:06 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:40:06 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:40:06 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:40:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:40:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:40:06 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:40:06 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:40:06 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:40:06 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:40:06 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:40:06 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:40:06 0 [Note] InnoDB: 10.4.32 started; log sequence number 300342; transaction id 170
2024-04-02 13:40:06 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:40:06 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:40:06 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:40:06 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:40:06 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:40:06 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 13:40:06
2024-04-02 13:40:06 0 [ERROR] Aborting
2024-04-02 13:46:53 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 7104
2024-04-02 13:46:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:46:54 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:46:54 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:46:54 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:46:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:46:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:46:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:46:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:46:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:46:54 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:46:54 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:46:54 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:46:54 0 [Note] InnoDB: 10.4.32 started; log sequence number 300351; transaction id 170
2024-04-02 13:46:54 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:46:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:46:54 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:46:54 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:46:54 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:46:54 0 [ERROR] Aborting
2024-04-02 13:47:54 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 3388
2024-04-02 13:47:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 13:47:54 0 [Note] InnoDB: Uses event mutexes
2024-04-02 13:47:54 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 13:47:54 0 [Note] InnoDB: Number of pools: 1
2024-04-02 13:47:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 13:47:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 13:47:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 13:47:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 13:47:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 13:47:54 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 13:47:54 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 13:47:54 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 13:47:55 0 [Note] InnoDB: 10.4.32 started; log sequence number 300360; transaction id 170
2024-04-02 13:47:55 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 13:47:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 13:47:55 0 [Note] Server socket created on IP: '::'.
2024-04-02 13:47:55 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 13:47:55 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 13:47:55 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 13:47:55
2024-04-02 13:47:55 0 [ERROR] Aborting
2024-04-02 15:54:34 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 4776
2024-04-02 15:54:34 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 15:54:34 0 [Note] InnoDB: Uses event mutexes
2024-04-02 15:54:34 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 15:54:34 0 [Note] InnoDB: Number of pools: 1
2024-04-02 15:54:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 15:54:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 15:54:34 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 15:54:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 15:54:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 15:54:34 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 15:54:34 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 15:54:34 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 15:54:35 0 [Note] InnoDB: 10.4.32 started; log sequence number 300369; transaction id 170
2024-04-02 15:54:35 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 15:54:35 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 15:54:35 0 [Note] Server socket created on IP: '::'.
2024-04-02 15:54:35 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 15:54:35 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 15:54:35 0 [ERROR] Aborting
2024-04-02 16:03:57 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18836
2024-04-02 16:03:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-04-02 16:03:58 0 [Note] InnoDB: Uses event mutexes
2024-04-02 16:03:58 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-04-02 16:03:58 0 [Note] InnoDB: Number of pools: 1
2024-04-02 16:03:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-04-02 16:03:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-04-02 16:03:58 0 [Note] InnoDB: Completed initialization of buffer pool
2024-04-02 16:03:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-04-02 16:03:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-04-02 16:03:58 0 [Note] InnoDB: Setting file 'D:\Program Files\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-04-02 16:03:58 0 [Note] InnoDB: File 'D:\Program Files\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-04-02 16:03:58 0 [Note] InnoDB: Waiting for purge to start
2024-04-02 16:03:58 0 [Note] InnoDB: 10.4.32 started; log sequence number 300378; transaction id 170
2024-04-02 16:03:58 0 [Note] InnoDB: Loading buffer pool(s) from D:\Program Files\xampp\mysql\data\ib_buffer_pool
2024-04-02 16:03:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-04-02 16:03:58 0 [Note] Server socket created on IP: '::'.
2024-04-02 16:03:58 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

2024-04-02 16:03:58 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2024-04-02 16:03:58 0 [Note] InnoDB: Buffer pool(s) load completed at 240402 16:03:58
2024-04-02 16:03:58 0 [ERROR] Aborting
by devenderbutani
02. April 2024 21:09
 
Forum: XAMPP for Windows
Topic: MySQL server doesn't launch on XAMPP after installation
Replies: 0
Views: 368

Re: Error starting MySQL

The same thing happened to me this morning. This is what the error log said:

2024-03-28 8:40:19 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 7552
Cannot find checkpoint record at LSN (1,0x5bb7)
2024-03-28 8:40:20 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-28 8:40:20 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-28 8:40:20 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-28 8:40:20 0 [Note] InnoDB: Uses event mutexes
2024-03-28 8:40:20 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-28 8:40:20 0 [Note] InnoDB: Number of pools: 1
2024-03-28 8:40:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-28 8:40:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-28 8:40:20 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-28 8:40:20 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=366372
2024-03-28 8:40:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-28 8:40:20 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-28 8:40:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-28 8:40:20 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-28 8:40:20 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-28 8:40:20 0 [Note] InnoDB: Waiting for purge to start
2024-03-28 8:40:20 0 [Note] InnoDB: 10.4.32 started; log sequence number 366381; transaction id 433
2024-03-28 8:40:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-28 8:40:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-28 8:40:20 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-28 8:40:20 0 [ERROR] Failed to initialize plugins.
2024-03-28 8:40:20 0 [ERROR] Aborting
2024-03-28 8:40:27 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 5304
Cannot find checkpoint record at LSN (1,0x5bb7)
2024-03-28 8:40:27 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-28 8:40:27 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-28 8:40:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-28 8:40:27 0 [Note] InnoDB: Uses event mutexes
2024-03-28 8:40:27 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-28 8:40:27 0 [Note] InnoDB: Number of pools: 1
2024-03-28 8:40:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-28 8:40:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-28 8:40:27 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-28 8:40:27 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-28 8:40:27 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-28 8:40:27 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-28 8:40:27 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-28 8:40:27 0 [Note] InnoDB: Waiting for purge to start
2024-03-28 8:40:28 0 [Note] InnoDB: 10.4.32 started; log sequence number 366390; transaction id 433
2024-03-28 8:40:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-28 8:40:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-28 8:40:28 0 [Note] InnoDB: Buffer pool(s) load completed at 240328 8:40:28
2024-03-28 8:40:28 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-28 8:40:28 0 [ERROR] Failed to initialize plugins.
2024-03-28 8:40:28 0 [ERROR] Aborting
by jeanneotts
28. March 2024 14:51
 
Forum: XAMPP for Windows
Topic: Error starting MySQL
Replies: 7
Views: 1315

Re: MySQL startet nicht mehr!!

Ina1805 wrote:Hallo,
gestern ging noch alles und heute kann ich "MySQL" nicht mehr starten.
Kann mir jemand helfen was passiert ist?

Folgende Meldung steht im Log:
2024-03-10 16:30:01 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23656
Cannot find checkpoint record at LSN (1,0x55ae)
2024-03-10 16:30:01 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-10 16:30:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-10 16:30:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-10 16:30:01 0 [Note] InnoDB: Uses event mutexes
2024-03-10 16:30:01 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-10 16:30:01 0 [Note] InnoDB: Number of pools: 1
2024-03-10 16:30:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-10 16:30:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-10 16:30:01 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-10 16:30:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-10 16:30:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-10 16:30:01 0 [Note] InnoDB: Setting file 'C:\xampp2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-10 16:30:01 0 [Note] InnoDB: File 'C:\xampp2\mysql\data\ibtmp1' size is now 12 MB.
2024-03-10 16:30:01 0 [Note] InnoDB: 10.4.32 started; log sequence number 93233172; transaction id 33679
2024-03-10 16:30:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp2\mysql\data\ib_buffer_pool
2024-03-10 16:30:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-10 16:30:01 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-10 16:30:01 0 [ERROR] Failed to initialize plugins.
2024-03-10 16:30:01 0 [ERROR] Aborting

Danke schonmal :)
by Hamilton
27. March 2024 13:06
 
Forum: XAMPP für Windows
Topic: MySQL startet nicht mehr!!
Replies: 2
Views: 1003

MySQL keeps shutting down

MySQL through xampp keeps crashing and I just can't make heads or tails of this. Thanks for any help in advance.

Here is the error log:
2024-03-20 14:50:50 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 1564
2024-03-20 14:50:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-20 14:50:50 0 [Note] InnoDB: Uses event mutexes
2024-03-20 14:50:50 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-20 14:50:50 0 [Note] InnoDB: Number of pools: 1
2024-03-20 14:50:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-20 14:50:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-20 14:50:50 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-20 14:50:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2024-03-20 14:50:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-20 14:50:50 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-03-20 14:50:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-20 14:50:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-20 14:50:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-20 14:50:51 0 [Note] InnoDB: 10.4.32 started; log sequence number 300297; transaction id 170
2024-03-20 14:50:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-20 14:50:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-20 14:50:51 0 [Note] InnoDB: Buffer pool(s) load completed at 240320 14:50:51
2024-03-20 14:50:51 0 [Note] Server socket created on IP: '::'.
by hunt1127
20. March 2024 21:01
 
Forum: XAMPP for Windows
Topic: MySQL keeps shutting down
Replies: 2
Views: 1502

MySQL startet nicht mehr!!

Hallo,
gestern ging noch alles und heute kann ich "MySQL" nicht mehr starten.
Kann mir jemand helfen was passiert ist?

Folgende Meldung steht im Log:
2024-03-10 16:30:01 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23656
Cannot find checkpoint record at LSN (1,0x55ae)
2024-03-10 16:30:01 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-03-10 16:30:01 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-03-10 16:30:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-10 16:30:01 0 [Note] InnoDB: Uses event mutexes
2024-03-10 16:30:01 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-03-10 16:30:01 0 [Note] InnoDB: Number of pools: 1
2024-03-10 16:30:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-10 16:30:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-10 16:30:01 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-10 16:30:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-10 16:30:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-10 16:30:01 0 [Note] InnoDB: Setting file 'C:\xampp2\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-10 16:30:01 0 [Note] InnoDB: File 'C:\xampp2\mysql\data\ibtmp1' size is now 12 MB.
2024-03-10 16:30:01 0 [Note] InnoDB: 10.4.32 started; log sequence number 93233172; transaction id 33679
2024-03-10 16:30:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp2\mysql\data\ib_buffer_pool
2024-03-10 16:30:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-10 16:30:01 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-03-10 16:30:01 0 [ERROR] Failed to initialize plugins.
2024-03-10 16:30:01 0 [ERROR] Aborting

Danke schonmal :)
by Ina1805
10. March 2024 16:37
 
Forum: XAMPP für Windows
Topic: MySQL startet nicht mehr!!
Replies: 2
Views: 1003

Don't start MYSQL

2024-03-06 9:52:33 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-06 9:52:33 0 [Note] InnoDB: Waiting for purge to start
2024-03-06 9:52:34 0 [Note] InnoDB: 10.4.32 started; log sequence number 1416364; transaction id 4546
2024-03-06 9:52:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-06 9:52:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-06 9:52:34 0 [Note] Server socket created on IP: '::'.

Hi i have a problem and i dont know how to start mySQL. Can someone help me ? It's for HeidiSQL
by KiraZuto
06. March 2024 09:55
 
Forum: XAMPP for Windows
Topic: Don't start MYSQL
Replies: 0
Views: 794

Re: SQL cannot be started

Hi,
I got the exact same issue, could you solve it?
My Error Log:
2024-03-06 8:29:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-06 8:29:09 0 [Note] InnoDB: Uses event mutexes
2024-03-06 8:29:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-03-06 8:29:09 0 [Note] InnoDB: Number of pools: 1
2024-03-06 8:29:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-06 8:29:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-06 8:29:09 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-06 8:29:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-06 8:29:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-06 8:29:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-06 8:29:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-06 8:29:09 0 [Note] InnoDB: 10.4.22 started; log sequence number 199162386978; transaction id 316886
2024-03-06 8:29:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-06 8:29:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-06 8:29:09 0 [Note] Server socket created on IP: '::'.
by Ismail23
06. March 2024 08:40
 
Forum: XAMPP for Windows
Topic: SQL cannot be started
Replies: 4
Views: 2568

can't start mysql

More often than not, I start XAMPP and can't start mySQL. Usually I figure it out, but today I'm stumped. The control panel tells me to copy the log window into the forum.

8:59:40 PM [mysql] Attempting to start MySQL app...
8:59:40 PM [mysql] Status change detected: running
8:59:42 PM [mysql] Status change detected: stopped
8:59:42 PM [mysql] Error: MySQL shutdown unexpectedly.
8:59:42 PM [mysql] This may be due to a blocked port, missing dependencies,
8:59:42 PM [mysql] improper privileges, a crash, or a shutdown by another method.
8:59:42 PM [mysql] Press the Logs button to view error logs and check
8:59:42 PM [mysql] the Windows Event Viewer for more clues
8:59:42 PM [mysql] If you need more help, copy and post this
8:59:42 PM [mysql] entire log window on the forums

Also here's the log file, from the same time stamp

2024-03-02 20:59:40 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 23120
2024-03-02 20:59:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-03-02 20:59:40 0 [Note] InnoDB: Uses event mutexes
2024-03-02 20:59:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2024-03-02 20:59:40 0 [Note] InnoDB: Number of pools: 1
2024-03-02 20:59:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-03-02 20:59:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-03-02 20:59:40 0 [Note] InnoDB: Completed initialization of buffer pool
2024-03-02 20:59:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-03-02 20:59:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-03-02 20:59:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-03-02 20:59:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-03-02 20:59:40 0 [Note] InnoDB: Waiting for purge to start
2024-03-02 20:59:40 0 [Note] InnoDB: 10.4.28 started; log sequence number 5911726; transaction id 1023
2024-03-02 20:59:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-03-02 20:59:40 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-03-02 20:59:40 0 [Note] InnoDB: Buffer pool(s) load completed at 240302 20:59:40
2024-03-02 20:59:40 0 [Note] Server socket created on IP: '::'.

Thank you for any help.
by kcslabaugh
03. March 2024 03:14
 
Forum: XAMPP for Windows
Topic: can't start mysql
Replies: 0
Views: 790
Next

Return to advanced search