Apache Friends Support Forum

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 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.

Hi,

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

best wishes,
Altrea