Search found 1254 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

can't import my database to the xampp

I can;t import my database. It is 27 MB but the maximum is 1 GB. I have changed the timeout the max filesize in php.ini, but i get the following error:
SQL query:


CREATE TABLE `wp_commentmeta` (
`meta_id` bigint(20) UNSIGNED NOT NULL,
`comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
`meta_key` varchar(255) DEFAULT NULL,
`meta_value` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8
by pomeking
29. June 2016 07:34
 
Forum: XAMPP for Windows
Topic: can't import my database to the xampp
Replies: 1
Views: 148

MySQL not starting

I have installed LimeSurvey on XAMPP on Windows 10. The installation was successful, and I was able to log into LimeSurvey and import a survey created beforehand on another computer. However, after rebooting my computer, I cannot access LimeSurvey on localhost in my browser. The reason is that something is preventing MySQL from starting. My XAMP control panel tells me:

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

I cannot post my entire log file as it exceeds the maximum character limit. But I am copying below the last part. Any help appreciated.

Code: Select all
160622 13:10:38  InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
160622 17:47:07 [Note] Plugin 'FEDERATED' is disabled.
160622 17:47:07 InnoDB: The InnoDB memory heap is disabled
160622 17:47:07 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160622 17:47:07 InnoDB: Compressed tables use zlib 1.2.3
160622 17:47:07 InnoDB: Initializing buffer pool, size = 16.0M
160622 17:47:07 InnoDB: Completed initialization of buffer pool
160622 17:47:07 InnoDB: highest supported file format is Barracuda.
160622 17:47:07  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name \xampp\mysql\data\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
160622 17:47:28 [Note] Plugin 'FEDERATED' is disabled.
160622 17:47:28 InnoDB: The InnoDB memory heap is disabled
160622 17:47:28 InnoDB: Mutexes and rw_locks use Windows interlocked functions
160622 17:47:28 InnoDB: Compressed tables use zlib 1.2.3
160622 17:47:28 InnoDB: Initializing buffer pool, size = 16.0M
160622 17:47:28 InnoDB: Completed initialization of buffer pool
160622 17:47:28 InnoDB: highest supported file format is Barracuda.
160622 17:47:29  InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-codes.html
InnoDB: File name \xampp\mysql\data\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.
by rdh61
23. June 2016 11:36
 
Forum: XAMPP for Windows
Topic: MySQL not starting
Replies: 1
Views: 358

[Win 7] Mysql shutdown unexpectedly (O.S. error 238)

Hello, im having this issue with mysql:

this is what control panel says when i try to start mysql

1:47:12 [mysql] Checking default ports...
1:47:12 [mysql] Attempting to start MySQL app...
1:47:12 [mysql] Executing ""c:\xampp\mysql\bin\mysqld.exe" --defaults-file="c:\xampp\mysql\bin\my.ini" --standalone --console"
1:47:12 [mysql] Return code: 0
1:47:13 [mysql] Status change detected: running
1:47:13 [mysql] Status change detected: stopped
1:47:13 [mysql] Error: MySQL shutdown unexpectedly.
1:47:13 [mysql] This may be due to a blocked port, missing dependencies,
1:47:13 [mysql] improper privileges, a crash, or a shutdown by another method.
1:47:13 [mysql] Press the Logs button to view error logs and check
1:47:13 [mysql] the Windows Event Viewer for more clues
1:47:13 [mysql] If you need more help, copy and post this
1:47:13 [mysql] entire log window on the forums


and this is the error log:

2016-06-21 01:47:13 a3c 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.
2016-06-21 1:47:13 2620 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-06-21 1:47:13 2620 [Note] InnoDB: The InnoDB memory heap is disabled
2016-06-21 1:47:13 2620 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-06-21 1:47:13 2620 [Note] InnoDB: Memory barrier is not used
2016-06-21 1:47:13 2620 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-06-21 1:47:13 2620 [Note] InnoDB: Using generic crc32 instructions
2016-06-21 1:47:13 2620 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-06-21 1:47:13 2620 [Note] InnoDB: Completed initialization of buffer pool
2016-06-21 1:47:13 2620 [Note] InnoDB: Highest supported file format is Barracuda.
2016-06-21 01:47:13 a3c InnoDB: Operating system error number 38 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
InnoDB: Operation read to file os\os0file.cc and at line 3158
2016-06-21 1:47:13 2620 [ERROR] InnoDB: File (unknown): 'read' returned OS error 238. Cannot continue operation


I think this can easily be fixed, but i don't know how to.
This is the story: i backed up my old "xampp" folder and installed xampp again, so i have all the files from my old databases, and all the information that i need to work with, so i tried deleting the default xampp "mysql/data/" folder and i replaced it with my old "data" folder.

Im not an expert with databases, so i dont think this is the correct way to "backup", but i couldn't find the way to do it. i guess someone here can help me.
by keea
21. June 2016 07:01
 
Forum: XAMPP for Windows
Topic: [Win 7] Mysql shutdown unexpectedly (O.S. error 238)
Replies: 2
Views: 480

MySQL closes after a few seconds of running.

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Not really sure how to fix it, so any help would be helpful.
by edgycommunist
27. May 2016 18:35
 
Forum: MariaDB - MySQL
Topic: MySQL closes after a few seconds of running.
Replies: 3
Views: 622

Xampp not Working for MySQL

When I click the start button it just says "Attempting to start MySQL app..." and stays there indefinitely. When I spam click. The MySQL goes green for a few seconds and then shuts down unexpectedly. I will copy the log file in here. Please help

Log:
2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete




Thank you,
E
by Vigillis-exe
27. May 2016 00:38
 
Forum: XAMPP for Windows
Topic: Xampp not Working for MySQL
Replies: 0
Views: 645

Problem with MySQL

When i start MySql, it doesn't start while the Apache runs properly and mysql_error.log says this:


2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

PLEASE HELP ASAP!!!!!
THANKS
by nikitaahuja
25. May 2016 13:34
 
Forum: XAMPP for Windows
Topic: Problem with MySQL
Replies: 0
Views: 745

Re: MySQL stürzt immer ab.

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: '::'.
by Kusi89
16. May 2016 12:27
 
Forum: XAMPP für Windows
Topic: MySQL stürzt immer ab.
Replies: 3
Views: 2470

my sql not starting

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by ashmail
16. May 2016 07:37
 
Forum: XAMPP for Windows
Topic: my sql not starting
Replies: 0
Views: 377

Apache und MySQL funktionieren nicht trotz freier Ports

2015-11-10 15:26:56 10fc 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-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Apache started but mysql is creating problem what should i do??

[EDIT by Altrea: splitted from original topic, moved from german to english section]
by Aparajit
14. May 2016 10:23
 
Forum: XAMPP for Windows
Topic: Apache und MySQL funktionieren nicht trotz freier Ports
Replies: 0
Views: 216

Re: Error: MySQL shutdown unexpectedly.

Sorry for inconvenience Altrea.

Below are the log:-
2016-05-11 18:09:46 7108 [Note] Plugin 'FEDERATED' is disabled.
2016-05-11 18:09:46 3dc 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.
2016-05-11 18:09:46 7108 [Note] InnoDB: Started in read only mode
2016-05-11 18:09:46 7108 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-11 18:09:46 7108 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-11 18:09:46 7108 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-11 18:09:46 7108 [Note] InnoDB: Memory barrier is not used
2016-05-11 18:09:46 7108 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-11 18:09:46 7108 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-11 18:09:46 7108 [Note] InnoDB: Disabling background IO write threads.
2016-05-11 18:09:46 7108 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-11 18:09:46 7108 [Note] InnoDB: Completed initialization of buffer pool
2016-05-11 18:09:46 7108 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-11 18:09:46 7108 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665548 in the ib_logfiles!
2016-05-11 18:09:46 7108 [ERROR] InnoDB: Can't initiate database recovery, running in read-only-mode.
2016-05-11 18:09:46 7108 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-11 18:09:46 7108 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-11 18:09:46 7108 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-11 18:09:46 7108 [ERROR] Aborting

2016-05-11 18:09:46 7108 [Note] Binlog end
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'partition'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'ARCHIVE'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MyISAM'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'MEMORY'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'CSV'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'sha256_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'mysql_old_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'mysql_native_password'
2016-05-11 18:09:46 7108 [Note] Shutting down plugin 'binlog'
2016-05-11 18:09:46 7108 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by vishalp@lexcis.com
11. May 2016 13:42
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344

Re: Error: MySQL shutdown unexpectedly.

Below are the fresh logs:-

2016-05-10 19:55:31 3476 [Note] Plugin 'FEDERATED' is disabled.
2016-05-10 19:55:31 13b4 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.
2016-05-10 19:55:31 3476 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-10 19:55:31 3476 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-10 19:55:31 3476 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-10 19:55:31 3476 [Note] InnoDB: Memory barrier is not used
2016-05-10 19:55:31 3476 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-10 19:55:31 3476 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-10 19:55:31 3476 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-10 19:55:31 3476 [Note] InnoDB: Completed initialization of buffer pool
2016-05-10 19:55:31 3476 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-10 19:55:31 3476 [Note] InnoDB: The log sequence numbers 1665234 and 1665234 in ibdata files do not match the log sequence number 1665548 in the ib_logfiles!
2016-05-10 19:55:31 3476 [Note] InnoDB: Database was not shutdown normally!
2016-05-10 19:55:31 3476 [Note] InnoDB: Starting crash recovery.
2016-05-10 19:55:31 3476 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-05-10 19:55:31 3476 [ERROR] InnoDB: checksum mismatch in tablespace .\wp2\wp_comments.ibd (table wp2/wp_comments)
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size:1024 Pages to analyze:64
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size: 1024, Possible space_id count:0
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size:2048 Pages to analyze:64
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size: 2048, Possible space_id count:0
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size:4096 Pages to analyze:44
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size: 4096, Possible space_id count:0
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size:8192 Pages to analyze:22
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size: 8192, Possible space_id count:0
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size:16384 Pages to analyze:11
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:1 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:2 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:3 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:4 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:5 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:6 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:7 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: VALID: space:766 page_no:8 page_size:16384
2016-05-10 19:55:31 3476 [Note] InnoDB: Page size: 16384, Possible space_id count:1
2016-05-10 19:55:31 3476 [Note] InnoDB: space_id:766, Number of pages matched: 8/8 (16384)
2016-05-10 19:55:31 3476 [Note] InnoDB: Chosen space:766

2016-05-10 19:55:31 3476 [Note] InnoDB: Restoring page 0 of tablespace 766
2016-05-10 19:55:31 3476 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 766
InnoDB: Error: could not open single-table tablespace file .\wp2\wp_comments.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.
by vishalp@lexcis.com
10. May 2016 15:28
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344

Re: Error: MySQL shutdown unexpectedly.

dDesign wrote:[mysqld]
innodb_force_recovery = 4

THIS forces InnoDB to start in read-only mode, not any file/folder permission.
by Altrea
10. May 2016 10:15
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344

Re: Error: MySQL shutdown unexpectedly.

How about the permissions? Folder permission etc.

edit:

2016-05-10 13:09:21 4744 [ERROR] InnoDB: Cannot create log files in read-only mode

Right click on the XAMPP folder and uncheck the Readonly, if this not works. Try to uncheck the read only in folder settings from folder mysql
by dDesign
10. May 2016 10:04
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344

Re: Error: MySQL shutdown unexpectedly.

Thanks for your reply; I appreciate your help.

I tried with administrator rights as well:

1:09:18 PM [main] Initializing Control Panel
1:09:18 PM [main] Windows Version: Windows 8 Pro 64-bit
1:09:18 PM [main] XAMPP Version: 1.8.3
1:09:18 PM [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
1:09:18 PM [main] Running with Administrator rights - good!
1:09:18 PM [main] XAMPP Installation Directory: "c:\xampp\"
1:09:18 PM [main] Checking for prerequisites
1:09:18 PM [main] All prerequisites found
1:09:18 PM [main] Initializing Modules
1:09:18 PM [main] Starting Check-Timer
1:09:18 PM [main] Control Panel Ready
1:09:20 PM [mysql] Attempting to start MySQL app...
1:09:20 PM [mysql] Status change detected: running
1:09:21 PM [mysql] Status change detected: stopped
1:09:21 PM [mysql] Error: MySQL shutdown unexpectedly.
1:09:21 PM [mysql] This may be due to a blocked port, missing dependencies,
1:09:21 PM [mysql] improper privileges, a crash, or a shutdown by another method.
1:09:21 PM [mysql] Press the Logs button to view error logs and check
1:09:21 PM [mysql] the Windows Event Viewer for more clues
1:09:21 PM [mysql] If you need more help, copy and post this
1:09:21 PM [mysql] entire log window on the forums


Following is the error log:

2016-05-10 13:09:21 4744 [Note] Plugin 'FEDERATED' is disabled.
2016-05-10 13:09:21 914 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.
2016-05-10 13:09:21 4744 [Note] InnoDB: Started in read only mode
2016-05-10 13:09:21 4744 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-05-10 13:09:21 4744 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-10 13:09:21 4744 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-10 13:09:21 4744 [Note] InnoDB: Memory barrier is not used
2016-05-10 13:09:21 4744 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-10 13:09:21 4744 [Note] InnoDB: Not using CPU crc32 instructions
2016-05-10 13:09:21 4744 [Note] InnoDB: Disabling background IO write threads.
2016-05-10 13:09:21 4744 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-10 13:09:21 4744 [Note] InnoDB: Completed initialization of buffer pool
2016-05-10 13:09:21 4744 [ERROR] InnoDB: Cannot create log files in read-only mode
2016-05-10 13:09:21 4744 [ERROR] Plugin 'InnoDB' init function returned error.
2016-05-10 13:09:21 4744 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-05-10 13:09:21 4744 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-05-10 13:09:21 4744 [ERROR] Aborting

2016-05-10 13:09:21 4744 [Note] Binlog end
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'partition'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_METRICS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_CMP'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'INNODB_TRX'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'BLACKHOLE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'ARCHIVE'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MRG_MYISAM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MyISAM'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'MEMORY'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'CSV'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'sha256_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'mysql_old_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'mysql_native_password'
2016-05-10 13:09:21 4744 [Note] Shutting down plugin 'binlog'
2016-05-10 13:09:21 4744 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
by vishalp@lexcis.com
10. May 2016 08:43
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344

Re: Error: MySQL shutdown unexpectedly.

Did you try to run it as Administrator? I further have no clue. The reason i think u have to start it as administrator is of the first line:

2016-05-10 12:38:43 1208 [Note] InnoDB: Started in read only mode

"ready only mode"
by dDesign
10. May 2016 08:21
 
Forum: XAMPP for Windows
Topic: Error: MySQL shutdown unexpectedly.
Replies: 18
Views: 2344
PreviousNext

Return to advanced search