MYSQL crash

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MYSQL crash

Postby courcoa » 02. June 2015 13:04

Hello,

i'm really novice and since today MYSQL crash and I have this message in mysql_error.log :

2015-06-02 13:47:07 8044 [Note] Plugin 'FEDERATED' is disabled.
2015-06-02 13:47:07 1fb0 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.
2015-06-02 13:47:07 8044 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-06-02 13:47:07 8044 [Note] InnoDB: The InnoDB memory heap is disabled
2015-06-02 13:47:07 8044 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-06-02 13:47:07 8044 [Note] InnoDB: Memory barrier is not used
2015-06-02 13:47:07 8044 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-06-02 13:47:07 8044 [Note] InnoDB: Not using CPU crc32 instructions
2015-06-02 13:47:07 8044 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-06-02 13:47:07 8044 [Note] InnoDB: Completed initialization of buffer pool
2015-06-02 13:47:08 8044 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-02 13:47:08 8044 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 3353125 in the ib_logfiles!
2015-06-02 13:47:08 8044 [Note] InnoDB: Database was not shutdown normally!
2015-06-02 13:47:08 8044 [Note] InnoDB: Starting crash recovery.
2015-06-02 13:47:08 8044 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-06-02 13:47:08 8044 [Note] InnoDB: Restoring possible half-written data pages
2015-06-02 13:47:08 8044 [Note] InnoDB: from the doublewrite buffer...
2015-06-02 13:47:08 8044 [Note] InnoDB: 128 rollback segment(s) are active.
2015-06-02 13:47:08 8044 [Note] InnoDB: Waiting for purge to start
2015-06-02 13:47:10 8044 [Note] InnoDB: 5.6.24 started; log sequence number 3353125
2015-06-02 13:47:11 8044 [Note] Server hostname (bind-address): '*'; port: 3306
2015-06-02 13:47:11 8044 [Note] IPv6 is available.
2015-06-02 13:47:11 8044 [Note] - '::' resolves to '::';
2015-06-02 13:47:11 8044 [Note] Server socket created on IP: '::'.

Is there somebody to help me, because I don't understand what is the problem and how can I solve it ?
Thanks for all

PS : I'm french so excuse my poor english
courcoa
 
Posts: 1
Joined: 02. June 2015 12:55
Operating System: windows 8.1

Re: MYSQL crash

Postby mark.mcdonald » 02. June 2015 14:53

courcoa wrote:2015-06-02 13:47:08 8044 [Note] InnoDB: Highest supported file format is Barracuda.
2015-06-02 13:47:08 8044 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 3353125 in the ib_logfiles!
2015-06-02 13:47:08 8044 [Note] InnoDB: Database was not shutdown normally!
2015-06-02 13:47:08 8044 [Note] InnoDB: Starting crash recovery.

1. Go to xampp\mysql\data\mysql

2. Create a "Backup" folder under data

3. Move those files to your Backup folder
innodb_index_stats.frm
innodb_index_stats.ibd
innodb_table_stats.frm
innodb_table_stats.ibd
slave_master_info.ibd
slave_relay_log_info.frm
slave_relay_log_info.ibd
slave_worker_info.frm
slave_worker_info.ibd
4. now open control panel and click on start under mysql

5. reply back

You can try this method also:

1. Open Xampp -> MySQL -> Configuration.

2. In [mysqld] section, add the following line:
innodb_force_recovery = 1

3. Save the file and try starting MySQL

4. Remove that line which you just added and Save.
mark.mcdonald
 
Posts: 160
Joined: 13. March 2015 15:48
Location: Edmonton
Operating System: Windows Server 2012 R2

Re: MYSQL crash

Postby Altrea » 02. June 2015 15:53

Hi,

I don't see any errors just notes. What is the problem?

best wishes,
Altrea
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: 8291
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 44 guests