MySql not starting

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

MySql not starting

Postby poojashingala » 21. September 2016 14:05

I am attaching the logs. Please tell me how to resolve the error

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

2016-09-21 17:19:17 c64 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-09-21 17:19:17 3172 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 17:19:17 3172 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:17 3172 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:17 3172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:17 3172 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:17 3172 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:17 3172 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:17 3172 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ib5478.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:17 c64 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:17 3172 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:17 3172 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:17 3172 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:17 3172 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:17 3172 [ERROR] Aborting

2016-09-21 17:19:38 a30 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-09-21 17:19:38 2608 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 17:19:38 2608 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:38 2608 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:38 2608 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:38 2608 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:38 2608 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:38 2608 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:38 2608 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibA4EA.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:38 a30 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:38 2608 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:38 2608 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:38 2608 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:38 2608 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:38 2608 [ERROR] Aborting

2016-09-21 17:19:49 a24 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-09-21 17:19:49 2596 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 17:19:49 2596 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:49 2596 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:49 2596 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:49 2596 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:49 2596 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:49 2596 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:49 2596 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibCFA3.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:49 a24 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:49 2596 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:49 2596 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:49 2596 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:49 2596 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:49 2596 [ERROR] Aborting

2016-09-21 17:19:50 1598 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-09-21 17:19:50 5528 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 17:19:50 5528 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:50 5528 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:50 5528 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:50 5528 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:50 5528 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:50 5528 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:50 5528 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibD59E.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:50 1598 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:50 5528 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:50 5528 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:50 5528 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:50 5528 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:50 5528 [ERROR] Aborting

2016-09-21 17:19:55 a8c 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-09-21 17:19:55 2700 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 17:19:55 2700 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 17:19:55 2700 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 17:19:55 2700 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 17:19:55 2700 [Note] InnoDB: Memory barrier is not used
2016-09-21 17:19:55 2700 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 17:19:55 2700 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 17:19:55 2700 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ibE8A9.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 17:19:55 a8c InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 17:19:55 2700 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 17:19:55 2700 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 17:19:55 2700 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 17:19:55 2700 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 17:19:55 2700 [ERROR] Aborting

2016-09-21 18:17:20 1294 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-09-21 18:17:20 4756 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2016-09-21 18:17:20 4756 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-09-21 18:17:20 4756 [Note] InnoDB: The InnoDB memory heap is disabled
2016-09-21 18:17:20 4756 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-09-21 18:17:20 4756 [Note] InnoDB: Memory barrier is not used
2016-09-21 18:17:20 4756 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-09-21 18:17:20 4756 [Note] InnoDB: Using generic crc32 instructions
2016-09-21 18:17:20 4756 [ERROR] mysqld.exe: File 'C:\xamppp\tmp\ib78D7.tmp' not found (Errcode: 13 "Permission denied")
2016-09-21 18:17:20 1294 InnoDB: Error: unable to create temporary file; errno: 13
2016-09-21 18:17:20 4756 [ERROR] Plugin 'InnoDB' init function returned error.
2016-09-21 18:17:20 4756 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-09-21 18:17:20 4756 [Note] Plugin 'FEEDBACK' is disabled.
2016-09-21 18:17:20 4756 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-09-21 18:17:20 4756 [ERROR] Aborting
poojashingala
 
Posts: 1
Joined: 21. September 2016 13:55
XAMPP version: v3.2.2
Operating System: windows 8

Re: MySql not starting

Postby Nobbie » 21. September 2016 21:22

Did you read these error messages? You should do so. There is one very important error message (its a repeating error), did you see that? It contains a huge hint, what might go wrong, open your eyes and your mind! Help yourself, analyze that message and find out, what is going wrong there.

Tell us, what you found out.
Nobbie
 
Posts: 8768
Joined: 09. March 2008 13:04

Re: MySql not starting

Postby Ghafoer86 » 24. September 2016 15:10

MAYBE IT'S CAN SOLVED THE PROBLEM. CHANGE THE SOCKET/PORT FOR MYSQL.
Never Stop Learning. Make Different's Style. Leading The Innovation.
User avatar
Ghafoer86
 
Posts: 20
Joined: 12. August 2013 17:39
Location: Indonesia - southeast ASIA (City : Palu Province : Central Sulawesi)
XAMPP version: 1.8.3-2
Operating System: Android Marshmallow

Re: MySql not starting

Postby Altrea » 24. September 2016 15:33

Ghafoer86 wrote:MAYBE IT'S CAN SOLVED THE PROBLEM. CHANGE THE SOCKET/PORT FOR MYSQL.

definitively not. The logs already mentioned the real problem.

btw: You can also use small type. Read more about this wth help of your favorite search engine: "all caps netiquette"
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: 8290
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 4 guests