MySQL wurde unerwartet beendet...

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

MySQL wurde unerwartet beendet...

Postby allroad » 21. October 2019 11:15

Hi,

ich habe das Problem, das die Datenbank nicht mehr startet. Win 10 System, XAMPP v3.2.4
Hier das errorlog:

writing the file full; Please wait ...
2019-09-09 13:22:21 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-09-09 13:22:21 0 [Note] InnoDB: Waiting for purge to start
2019-09-09 13:22:21 0 [Note] InnoDB: 10.3.15 started; log sequence number 305178918; transaction id 153037
2019-09-09 13:22:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-09-09 13:22:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-09 13:22:21 0 [Note] Server socket created on IP: '::'.
2019-10-21 11:05:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-21 11:05:55 0 [Note] InnoDB: Uses event mutexes
2019-10-21 11:05:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-21 11:05:55 0 [Note] InnoDB: Number of pools: 1
2019-10-21 11:05:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-21 11:05:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-21 11:05:55 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-21 11:05:57 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=305178909
2019-10-21 11:06:02 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-21 11:06:02 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-21 11:06:02 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-21 11:06:02 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-21 11:06:02 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-21 11:06:02 0 [Note] InnoDB: Waiting for purge to start
2019-10-21 11:06:02 0 [Note] InnoDB: 10.3.15 started; log sequence number 305178918; transaction id 153037
2019-10-21 11:06:02 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-21 11:06:02 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-21 11:06:02 0 [Note] Server socket created on IP: '::'.
2019-10-21 12:14:39 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-21 12:14:39 0 [Note] InnoDB: Uses event mutexes
2019-10-21 12:14:39 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-21 12:14:39 0 [Note] InnoDB: Number of pools: 1
2019-10-21 12:14:39 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-21 12:14:39 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-21 12:14:39 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-21 12:14:39 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=305178909
2019-10-21 12:14:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-21 12:14:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-10-21 12:14:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-21 12:14:39 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-21 12:14:39 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-21 12:14:39 0 [Note] InnoDB: Waiting for purge to start
2019-10-21 12:14:39 0 [Note] InnoDB: 10.3.15 started; log sequence number 305178918; transaction id 153037
2019-10-21 12:14:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-21 12:14:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-21 12:14:39 0 [Note] Server socket created on IP: '::'.
allroad
 
Posts: 1
Joined: 21. October 2019 11:10
XAMPP version: v3.2.4
Operating System: Win 10

Re: MySQL wurde unerwartet beendet...

Postby schwebbe » 04. December 2019 11:14

Moin,

das LOG enthält keinen Hinweis, dass die Datenbank nicht startet, eher im Gegenteil (4. letzte Zeile u.a.):

2019-10-21 12:14:39 0 [Note] InnoDB: 10.3.15 started; log sequence number 305178918; transaction id 153037

Mein LOG sieht ganz ähnlich aus:

2019-12-04 10:52:42 26548 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-12-04 10:52:42 26548 [Note] InnoDB: The InnoDB memory heap is disabled
2019-12-04 10:52:42 26548 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-04 10:52:42 26548 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-12-04 10:52:42 26548 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-04 10:52:42 26548 [Note] InnoDB: Using generic crc32 instructions
2019-12-04 10:52:42 26548 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-12-04 10:52:42 26548 [Note] InnoDB: Completed initialization of buffer pool
2019-12-04 10:52:42 26548 [Note] InnoDB: Highest supported file format is Barracuda.
2019-12-04 10:52:42 26548 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 20316647 in the ib_logfiles!
2019-12-04 10:52:43 26548 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-12-04 10:52:44 26548 [Note] InnoDB: 128 rollback segment(s) are active.
2019-12-04 10:52:44 26548 [Note] InnoDB: Waiting for purge to start
2019-12-04 10:52:44 26548 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.41-84.1 started; log sequence number 20316647
2019-12-04 10:52:44 26108 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-12-04 10:52:44 26548 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-04 10:52:44 26548 [Note] Server socket created on IP: '::'.
2019-12-04 10:52:44 26548 [Note] d:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.37-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

Der letzte Teil fehlt bei dir, ist der Port evtl. anderweitig belegt? Die Infos sind etwas mager... Ich nehme aber an, wenn du sagst startet nicht, dass du nicht per phpMyAdmin drauf kommst?

LG
schwebbe
schwebbe
 
Posts: 10
Joined: 03. December 2019 16:12
XAMPP version: 7.3.0-0
Operating System: Windows 10 Home


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 3 guests