MySQL stürzt immer ab.

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

MySQL stürzt immer ab.

Postby medastumpn » 03. May 2016 16:09

Hallo zusammen,

konnte gestern Nachmittag noch ganz normal arbeiten.
Nach einem PC-Neustart lies sich dann MySQL nicht mehr starten bzw. stürzte immer ab.

Code: Select all
16:58:34  [mysql]    Error: MySQL shutdown unexpectedly.
16:58:34  [mysql]    This may be due to a blocked port, missing dependencies,
16:58:34  [mysql]    improper privileges, a crash, or a shutdown by another method.
16:58:34  [mysql]    Press the Logs button to view error logs and check
16:58:34  [mysql]    the Windows Event Viewer for more clues
16:58:34  [mysql]    If you need more help, copy and post this
16:58:34  [mysql]    entire log window on the forums


Folgendes steht in der Log:
Code: Select all
160503 16:58:20 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160503 16:58:20 [Note] InnoDB: The InnoDB memory heap is disabled
160503 16:58:20 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160503 16:58:20 [Note] InnoDB: Memory barrier is not used
160503 16:58:20 [Note] InnoDB: Compressed tables use zlib 1.2.3
160503 16:58:20 [Note] InnoDB: Not using CPU crc32 instructions
160503 16:58:20 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160503 16:58:20 [Note] InnoDB: Completed initialization of buffer pool
160503 16:58:20 [Note] InnoDB: Highest supported file format is Barracuda.
160503 16:58:20 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 36138561 in the ib_logfiles!
160503 16:58:20 [Note] InnoDB: Database was not shutdown normally!
160503 16:58:20 [Note] InnoDB: Starting crash recovery.
160503 16:58:20 [Note] InnoDB: Reading tablespace information from the .ibd files...
160503 16:58:20 [Note] InnoDB: Restoring possible half-written data pages
160503 16:58:20 [Note] InnoDB: from the doublewrite buffer...
160503 16:58:21 [Note] InnoDB: 128 rollback segment(s) are active.
160503 16:58:21 [Note] InnoDB: Waiting for purge to start
160503 16:58:21 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 36138561
160503 16:58:21 [Note] Plugin 'FEEDBACK' is disabled.
160503 16:58:21 [Note] Server socket created on IP: '::'.


Kann mir jemand sagen wie ich jetzt weiter vorgehen muss?

Vielen Dank,
medastumpn
 
Posts: 1
Joined: 03. May 2016 16:05
XAMPP version: 3.2.1
Operating System: Win 7

Re: MySQL stürzt immer ab.

Postby Kusi89 » 16. May 2016 12:27

Ich kann dir leider nicht sagen was es ist, aber ich hab seite ca. 30 Min das selbe Problem

Code: Select all
2016-05-16 13:18:18 2b30 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160516 13:18:18 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160516 13:18:18 [Note] InnoDB: The InnoDB memory heap is disabled
160516 13:18:18 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160516 13:18:18 [Note] InnoDB: Memory barrier is not used
160516 13:18:18 [Note] InnoDB: Compressed tables use zlib 1.2.3
160516 13:18:18 [Note] InnoDB: Not using CPU crc32 instructions
160516 13:18:18 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160516 13:18:18 [Note] InnoDB: Completed initialization of buffer pool
160516 13:18:18 [Note] InnoDB: Highest supported file format is Barracuda.
160516 13:18:18 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 2476138 in the ib_logfiles!
160516 13:18:18 [Note] InnoDB: Database was not shutdown normally!
160516 13:18:18 [Note] InnoDB: Starting crash recovery.
160516 13:18:18 [Note] InnoDB: Reading tablespace information from the .ibd files...
160516 13:18:18 [Note] InnoDB: Restoring possible half-written data pages
160516 13:18:18 [Note] InnoDB: from the doublewrite buffer...
160516 13:18:19 [Note] InnoDB: 128 rollback segment(s) are active.
160516 13:18:19 [Note] InnoDB: Waiting for purge to start
160516 13:18:19 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 2476138
160516 13:18:19 [Note] Plugin 'FEEDBACK' is disabled.
160516 13:18:19 [Note] Server socket created on IP: '::'.
Kusi89
 
Posts: 2
Joined: 16. May 2016 12:24
XAMPP version: 3.2.1
Operating System: Windows 10

Re: MySQL stürzt immer ab.

Postby kurt peter » 18. May 2016 21:18

Benutzt Du eine Datenbank bei percona.com?
kurt peter
 
Posts: 2
Joined: 18. May 2016 20:46
XAMPP version: aktuell
Operating System: windows 10

Re: MySQL stürzt immer ab.

Postby Kusi89 » 19. May 2016 01:42

Bei mir hat die Neuinstallation geholfen, allerdings hatte ich auch keine unersetzlichen Datenbanken die es zu sichern galt.
Kusi89
 
Posts: 2
Joined: 16. May 2016 12:24
XAMPP version: 3.2.1
Operating System: Windows 10


Return to XAMPP für Windows

Who is online

Users browsing this forum: No registered users and 37 guests