MySQL Forums
Forum List  »  InnoDB

[mysql] Error: MySQL shutdown unexpectedly.
Posted by: Akifcan Kara
Date: December 11, 2019 04:22AM

Hello, firstly i use xampp phpmyadmin this morning i start the server but i got a this error.

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

Log messsage:
InnoDB: using atomic writes.
2019-12-11 13:06:01 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-11 13:06:01 0 [Note] InnoDB: Uses event mutexes
2019-12-11 13:06:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-11 13:06:01 0 [Note] InnoDB: Number of pools: 1
2019-12-11 13:06:01 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-11 13:06:01 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-12-11 13:06:01 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-11 13:06:01 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-11 13:06:01 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-11 13:06:01 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-11 13:06:01 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-12-11 13:06:01 0 [Note] InnoDB: Waiting for purge to start
2019-12-11 13:06:01 2 [Warning] InnoDB: Load table `gelir-gider`.`expenses` failed, the table has missing foreign key indexes. Turn off 'foreign_key_checks' and try again.
2019-12-11 13:06:01 0 [Note] InnoDB: 10.4.6 started; log sequence number 13709854; transaction id 35038
2019-12-11 13:06:01 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-12-11 13:06:01 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-11 13:06:01 0 [Note] Server socket created on IP: '::'.


Last day i dont get any error and close my computer but today i cant start phpmyadmin.

Note: from expenses table i was remove foreing key and i see this error from log 2019-12-11 13:06:01 2 [Warning] InnoDB: Load table `gelir-gider`.`expenses` failed, the table has missing foreign key indexes. Turn off

Options: ReplyQuote


Subject
Views
Written By
Posted
[mysql] Error: MySQL shutdown unexpectedly.
1003
December 11, 2019 04:22AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.