Header Ads

Cara Lain Mengatasi Error: MySQL shutdown unexpectedly (2)

 Cara Lain Mengatasi Error: MySQL shutdown unexpectedly (2) 

Jadi seorang programmer itu memang banyak pengalaman pahit yang haru dilewati, tapi tidak menjadi begitu berarti kalau tidak dibagikan juga sudah berhasil diatasi.

Sekarang saya akan berbagi pengalaman lagi tentang bagaimana cara mengatasi Error: MySQL shutdown unexpectedly (2), yang sebelumnya pernah saya bahas pada artikel "Cara Mengatasi Error: MySQL shutdown unexpectedly" yang ternyata tidak serta merta dapat menyelesaikan masalah dengan persan error yang sama.

Coba anda perhatikan pesan error di bawah ini, sama persis dengan pesan error yang ditampilkan pada artikel sebelumnya, tapi ternyata walaupun pesan errornya sama namun penyelesaiannya cukup berbeda.

  • Error: MySQL shutdown unexpectedly.
  • 08:58:49  [mysql]     This may be due to a blocked port, missing dependencies,
  • 08:58:49  [mysql]     improper privileges, a crash, or a shutdown by another method.
  • 08:58:49  [mysql]     Press the Logs button to view error logs and check
  • 08:58:49  [mysql]     the Windows Event Viewer for more clues
  • 08:58:49  [mysql]     If you need more help, copy and post this
  • 08:58:49  [mysql]     entire log window on the forums
Setelah mencoba-coba seharian tidak kunjung terselesaikan, namun dipenghujung rasa putus asa (baca: Niat Instal Ulang Xampp),  pengalaman kali ini saya disadarkan oleh pesan error yang saya beri warna merah, sebenarnya semua pesan error pada xampp control panel berwarna merah tapi disini kita focus pada satu pesan error saya yaitu: "Press the Logs button to view error logs and check" .

Saya mencoba untuk melihat pesan error tersebut, ternyata banyak banget tulisan berbahasa inggris yang membuat saya sedikit jenuh untuk membacanya (karena saya tidak begitu fasih berbahasa inggris), tiba-tiba muncul ide untuk menghapus semua pesan error yang ada pada file mysql_error.log  (bukan menghapus file tapi tulisan yang ada pada file mysql_error.log), kemudian mencoba menekan Start pada mySQL sehingga terbuatlah pesan error baru pada file mysql_error.log. setelah membukaya kembali ternyata ada satu baris yang menarik perhatian yaitu:

Error: could not open single-table tablespace file .\ojs311\access_keys.ibd

Berdasarkan analisa dan asumsi bahwa yang menjadi penyebab error mySQL adalah sebuah tabel dengan nama access_keys pada database oj311

Dan memang benar access_keys.ibd adalah penyebabnya.

Kenapa bisa jadi error ?
Sebelum lanjut pada langkah-langkah mengatasi error ini, perlu saya sampaikan terlebih dahulu kenapa tabel access_keys.ibd pada database ojs311 bermasalah, tujuannya agar anda ada bayangan sebelum mencoba untuk memperbaikinya.

Ceritanya begini: sebelumnya saya menginstal sebuah aplikasi berbasis web yaitu OJS 3.1.1 dan berjalan dengan baik, dan keesokan harinya saya ingin membuat sebuah tutorial tentang bagaimana cara mengistal OJS 3.1.1 dan akhirnya saya memutuskan untuk menghapus sebagian data melalui bagian admin, tapi saat itu waktu sudah jamnya istirahat  akhirnya komputer ikut di hebernasi (hibernate) agar nanti dapat dilanjutkan kembali, namun waktu berkata lain saya harus mengalami hal yang menyebabkan saya harus menulis artikel ini.

Baik, untuk mempersingkat waktu sekarang anda perhatikan tahapan-tahapan di bawah ini, semoga dapat membantu.

Langkah Pertama

Jalankan Xampp Control Panel anda, bisa dari windows menu atau langsung dari folder Xampp.


Langkah Kedua

Buka mysql_error.log dengan dua cara:

  • Buka melalui Xampp Control Panel: klik logs pada MySQL lalu pilih dan klik mysql_error.log
    Cara Lain Mengatasi Error: MySQL shutdown unexpectedly (2)
  • Buka melalui direktori dimana Xampp anda terinstal misal pada anda isntal Xampp pada drive C maka direktori mysql_error.log ada pada : C:\xampp\mysql\data

Langkah Ketiga

Hapus/pindahkan semua pesan error yang ada pada mysql_error.log, kemudian simpan dalam keadaan kosong.

Langkah Keempat

Kembali ke Xampp Control Panel, klik Start pada baris MySQL maka pesan error akan tertulis kembali bada mysql_error.log.
kemudian periksa pesan error tersebut apakah ada yang mirip dengan error berikut:

Error: could not open single-table tablespace file .\ojs311\access_keys.ibd

Ini pesan error selengakapnya pada mysql_error.log:
[ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace ojs3/access_keys uses space ID: 4992 at filepath: .\ojs3\access_keys.ibd. Cannot open tablespace ojs311/access_keys which uses space ID: 4992 at filepath: .\ojs311\access_keys.ibd
InnoDB: Error: could not open single-table tablespace file .\ojs311\access_keys.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.
1274 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.
4724 [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.


Langkah Kelima

Setelah menemukan ciri-ciri di atas (langkah keempat), kemudian masuk ke direktori C:\xampp\mysql\data dan temukan folder database yang bermasalah pada kasus ini nama databasenya adalah ojs311

Jika database yang bermasalah dianggap penting, pindahkan ke folder lain siapa tahu nantu ada metode untuk recovery  atau jika tidak telalu berguna hapus saja

Anda harus bersedia kehilangan satu database untuk kasus ini, kecuali bisa memperbaikinya.


Langkah Keenam

Coba kembali jalankan kembali MySQL Service dengan cara klik Start, jika seluruh tahapan ini dilakasakan dengan benar maka MySQL module akan berwarna hijau dan pada port(s) akan tampil angka 3306.


Langkah ketujuh

Buka web browser lalu ketik localhost/phpmyadmin untuk memastikan bahwa database anda sudah bekerja dengan baik dan dapat diakses kembali.


Demikian pengalaman yang dapat saya bagikan pada kesempatan kali ini tentang Cara Lain Mengatasi Error: MySQL shutdown unexpectedly (2), semoga dapat bermanfaat.

Saya sangat berharap dapat berbagi pengalaman jika telah berhasil mengatasi masalah seperti yang saya alami sebagaimana artikel ini, atau kritik dan saran jika anda belum berhasil mengatasinya melalui kolom komentar di bawah ini.

Dapat update artikel Gratis:

24 komentar:

  1. pesan pada mysql_error.log saya begini:

    InnoDB: using atomic writes.
    2019-11-01 18:08:53 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2019-11-01 18:08:53 0 [Note] InnoDB: Uses event mutexes
    2019-11-01 18:08:53 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2019-11-01 18:08:53 0 [Note] InnoDB: Number of pools: 1
    2019-11-01 18:08:53 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2019-11-01 18:08:53 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2019-11-01 18:08:53 0 [Note] InnoDB: Completed initialization of buffer pool
    2019-11-01 18:08:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2019-11-01 18:08:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2019-11-01 18:08:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2019-11-01 18:08:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2019-11-01 18:08:53 0 [Note] InnoDB: Waiting for purge to start
    2019-11-01 18:08:53 0 [Note] InnoDB: 10.4.6 started; log sequence number 113854; transaction id 9
    2019-11-01 18:08:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2019-11-01 18:08:53 0 [Note] Plugin 'FEEDBACK' is disabled.
    2019-11-01 18:08:53 0 [Note] InnoDB: Buffer pool(s) load completed at 191101 18:08:53
    2019-11-01 18:08:53 0 [Note] Server socket created on IP: '::'.

    saya ga nemu error nya dimana. Mohon bantuan nya bang.

    BalasHapus
    Balasan
    1. Terimakasih udah mampir gan, coba agan matikan service yg berkaitan dengan server. kemudian pidahkan sementara ibtmp1 dan ib_buffer_pool dari folder C:\xampp\mysql\data dan jalankan kembali service (apache & MySql). semoga terbantu.

      Hapus
  2. Pesan pada mysql_error log saya seperti ini

    Error: MySQL shutdonwn unexpectedly
    This may be due to a blocked port. missing dependencies.

    BalasHapus
    Balasan
    1. kemungkinan portnya udah kepakai gan. port default 3306. agan bisa mematikan service dan biarkan dijalankan secara manual atau ganti port lewat my.ini semoga terbantu

      Hapus
  3. erroe saya seperti ini min gimana ? mohon bantuannya
    InnoDB: using atomic writes.
    2020-05-09 12:39:51 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-05-09 12:39:51 0 [Note] InnoDB: Uses event mutexes
    2020-05-09 12:39:51 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-05-09 12:39:51 0 [Note] InnoDB: Number of pools: 1
    2020-05-09 12:39:51 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-05-09 12:39:51 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-05-09 12:39:51 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-05-09 12:39:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-05-09 12:39:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-05-09 12:39:51 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-05-09 12:39:51 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-05-09 12:39:51 0 [Note] InnoDB: Waiting for purge to start
    2020-05-09 12:39:51 0 [Note] InnoDB: 10.4.10 started; log sequence number 113872; transaction id 9
    2020-05-09 12:39:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-05-09 12:39:51 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-05-09 12:39:51 0 [Note] InnoDB: Buffer pool(s) load completed at 200509 12:39:51
    2020-05-09 12:39:51 0 [Note] Server socket created on IP: '::'.
    InnoDB: using atomic writes.
    2020-05-09 12:42:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-05-09 12:42:31 0 [Note] InnoDB: Uses event mutexes
    2020-05-09 12:42:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-05-09 12:42:31 0 [Note] InnoDB: Number of pools: 1
    2020-05-09 12:42:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-05-09 12:42:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-05-09 12:42:31 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-05-09 12:42:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-05-09 12:42:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-05-09 12:42:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-05-09 12:42:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-05-09 12:42:31 0 [Note] InnoDB: 10.4.10 started; log sequence number 113881; transaction id 9
    2020-05-09 12:42:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-05-09 12:42:31 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-05-09 12:42:32 0 [Note] InnoDB: Buffer pool(s) load completed at 200509 12:42:32
    2020-05-09 12:42:32 0 [Note] Server socket created on IP: '::'.

    BalasHapus
  4. Pesan error pada mysql saya seperti ini

    InnoDB: using atomic writes.
    2020-05-26 17:26:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-05-26 17:26:50 0 [Note] InnoDB: Uses event mutexes
    2020-05-26 17:26:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-05-26 17:26:50 0 [Note] InnoDB: Number of pools: 1
    2020-05-26 17:26:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-05-26 17:26:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-05-26 17:26:50 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-05-26 17:26:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-05-26 17:26:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-05-26 17:26:50 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-05-26 17:26:50 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-05-26 17:26:50 0 [Note] InnoDB: Waiting for purge to start
    2020-05-26 17:26:50 0 [Note] InnoDB: 10.4.11 started; log sequence number 47055; transaction id 9
    2020-05-26 17:26:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-05-26 17:26:50 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-05-26 17:26:50 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    2020-05-26 17:26:50 0 [Note] InnoDB: Buffer pool(s) load completed at 200526 17:26:50
    2020-05-26 17:26:50 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    2020-05-26 17:26:50 0 [Note] Server socket created on IP: '::'.

    BalasHapus
    Balasan
    1. gan, coba matikan service MySql-nya, kemudian pindahkan sementara file ibtmp1 dan ib_buffer_pool yg ada difolder C:\xampp\mysql\data\ kemudian jalan kan lagi service. semoga terbantu

      Hapus
    2. 2020-08-27 18:08:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2020-08-27 18:08:06 0 [Note] InnoDB: Uses event mutexes
      2020-08-27 18:08:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-08-27 18:08:06 0 [Note] InnoDB: Number of pools: 1
      2020-08-27 18:08:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2020-08-27 18:08:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2020-08-27 18:08:06 0 [Note] InnoDB: Completed initialization of buffer pool
      2020-08-27 18:08:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
      2020-08-27 18:08:06 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
      2020-08-27 18:08:07 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
      2020-08-27 18:08:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2020-08-27 18:08:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2020-08-27 18:08:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2020-08-27 18:08:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-08-27 18:08:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2020-08-27 18:08:07 0 [Note] InnoDB: Waiting for purge to start
      2020-08-27 18:08:08 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
      2020-08-27 18:08:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
      2020-08-27 18:08:08 0 [Note] InnoDB: Buffer pool(s) load completed at 200827 18:08:08
      2020-08-27 18:08:08 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-08-27 18:08:08 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
      2020-08-27 18:08:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      2020-08-27 18:08:08 0 [Note] Server socket created on IP: '::'.
      2020-08-27 18:08:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2020-08-27 18:08:11 0 [Note] InnoDB: Uses event mutexes
      2020-08-27 18:08:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
      2020-08-27 18:08:11 0 [Note] InnoDB: Number of pools: 1
      2020-08-27 18:08:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2020-08-27 18:08:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2020-08-27 18:08:11 0 [Note] InnoDB: Completed initialization of buffer pool
      2020-08-27 18:08:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
      2020-08-27 18:08:11 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
      2020-08-27 18:08:12 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
      2020-08-27 18:08:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2020-08-27 18:08:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2020-08-27 18:08:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2020-08-27 18:08:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2020-08-27 18:08:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2020-08-27 18:08:12 0 [Note] InnoDB: Waiting for purge to start
      2020-08-27 18:08:12 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
      2020-08-27 18:08:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
      2020-08-27 18:08:12 0 [Note] InnoDB: Buffer pool(s) load completed at 200827 18:08:12
      2020-08-27 18:08:12 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-08-27 18:08:12 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
      2020-08-27 18:08:12 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      2020-08-27 18:08:12 0 [Note] Server socket created on IP: '::'.

      Hapus
    3. error saya sama dengan yang diatas gan, tetapi service MySQL saya tidak ada gan, mohon pencerahannya gan, lagi buat tugas akhir sekarang gan,terima kasih gan

      Hapus
    4. kak, apa masih error?punya saya sama kayak punya kakak

      Hapus
    5. coba cek di services.msc lewat Flag(logo window) + R untuk memastikan MySQL servicenya

      Hapus
  5. Pesan Error saya seperti ini:

    InnoDB: using atomic writes.
    2020-06-05 14:06:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-06-05 14:06:59 0 [Note] InnoDB: Uses event mutexes
    2020-06-05 14:06:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-06-05 14:06:59 0 [Note] InnoDB: Number of pools: 1
    2020-06-05 14:06:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-06-05 14:06:59 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-06-05 14:06:59 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-06-05 14:06:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-06-05 14:06:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-06-05 14:06:59 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-06-05 14:06:59 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-06-05 14:06:59 0 [Note] InnoDB: Waiting for purge to start
    2020-06-05 14:06:59 0 [Note] InnoDB: 10.4.11 started; log sequence number 47091; transaction id 9
    2020-06-05 14:06:59 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-06-05 14:06:59 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-06-05 14:06:59 0 [Note] InnoDB: Buffer pool(s) load completed at 200605 14:06:59
    2020-06-05 14:06:59 0 [Note] Server socket created on IP: '::'.

    BalasHapus
    Balasan
    1. coba agan matikan service mysql, kemudian pindahkan/rename file ibtmp1,ib_buffer_pool (jangan dihapus ya), kemudian jalankan lagi service mysqlnya.

      Hapus
  6. Bang saya erorr seperti ini

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

    -Di mysql error log:
    InnoDB: using atomic writes.
    2020-06-17 13:40:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-06-17 13:40:21 0 [Note] InnoDB: Uses event mutexes
    2020-06-17 13:40:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-06-17 13:40:21 0 [Note] InnoDB: Number of pools: 1
    2020-06-17 13:40:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-06-17 13:40:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-06-17 13:40:21 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-06-17 13:40:21 0 [Note] InnoDB: The log sequence number 47073 in the system tablespace does not match the log sequence number 47082 in the ib_logfiles!
    2020-06-17 13:40:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-06-17 13:40:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-06-17 13:40:23 0 [Note] InnoDB: Setting file 'C:\XAMPP\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-06-17 13:40:23 0 [Note] InnoDB: File 'C:\XAMPP\mysql\data\ibtmp1' size is now 12 MB.
    2020-06-17 13:40:23 0 [Note] InnoDB: Waiting for purge to start
    2020-06-17 13:40:23 0 [Note] InnoDB: 10.4.11 started; log sequence number 47082; transaction id 9
    2020-06-17 13:40:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\XAMPP\mysql\data\ib_buffer_pool
    2020-06-17 13:40:23 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-06-17 13:40:23 0 [Note] InnoDB: Buffer pool(s) load completed at 200617 13:40:23
    2020-06-17 13:40:23 0 [Note] Server socket created on IP: '::'.

    Tolong ya bang


    BalasHapus
    Balasan
    1. pindahin dulu C:\XAMPP\mysql\data\ibtmp1 dan C:\XAMPP\mysql\data\ib_buffer_pool dan db yang kira2 bermasalah

      Hapus
  7. pesan error saya kayak gini bang

    2020-08-27 18:08:06 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-08-27 18:08:06 0 [Note] InnoDB: Uses event mutexes
    2020-08-27 18:08:06 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-08-27 18:08:06 0 [Note] InnoDB: Number of pools: 1
    2020-08-27 18:08:06 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-08-27 18:08:06 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-08-27 18:08:06 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-08-27 18:08:06 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
    2020-08-27 18:08:06 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
    2020-08-27 18:08:07 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
    2020-08-27 18:08:07 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-08-27 18:08:07 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-08-27 18:08:07 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-08-27 18:08:07 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-08-27 18:08:07 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-08-27 18:08:07 0 [Note] InnoDB: Waiting for purge to start
    2020-08-27 18:08:08 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
    2020-08-27 18:08:08 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-08-27 18:08:08 0 [Note] InnoDB: Buffer pool(s) load completed at 200827 18:08:08
    2020-08-27 18:08:08 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-08-27 18:08:08 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    2020-08-27 18:08:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    2020-08-27 18:08:08 0 [Note] Server socket created on IP: '::'.
    2020-08-27 18:08:11 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-08-27 18:08:11 0 [Note] InnoDB: Uses event mutexes
    2020-08-27 18:08:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-08-27 18:08:11 0 [Note] InnoDB: Number of pools: 1
    2020-08-27 18:08:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-08-27 18:08:11 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-08-27 18:08:11 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-08-27 18:08:11 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=49468
    2020-08-27 18:08:11 0 [Note] InnoDB: Starting a batch to recover 112 pages from redo log.
    2020-08-27 18:08:12 0 [Note] InnoDB: Starting final batch to recover 14 pages from redo log.
    2020-08-27 18:08:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-08-27 18:08:12 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
    2020-08-27 18:08:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-08-27 18:08:12 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-08-27 18:08:12 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-08-27 18:08:12 0 [Note] InnoDB: Waiting for purge to start
    2020-08-27 18:08:12 0 [Note] InnoDB: 10.3.16 started; log sequence number 1603190; transaction id 9
    2020-08-27 18:08:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-08-27 18:08:12 0 [Note] InnoDB: Buffer pool(s) load completed at 200827 18:08:12
    2020-08-27 18:08:12 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-08-27 18:08:12 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
    2020-08-27 18:08:12 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    2020-08-27 18:08:12 0 [Note] Server socket created on IP: '::'.

    BalasHapus
    Balasan
    1. masalahnya disini:
      2020-08-27 18:08:08 0 [Note] Plugin 'FEEDBACK' is disabled.
      2020-08-27 18:08:08 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
      2020-08-27 18:08:08 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
      2020-08-27 18:08:08 0 [Note] Server socket created on IP: '::'.
      ada table pada DB agan bermasalah bisa karena lock privilege tables atau Table 'mysql.servers' doesn't exist cek lagi DB yang berisi table 'mysql.servers' stop semua service kemudian pindahin sementara jalankan lagi service. kl udah OK tinggal remove aja table yang bermasalah pada folder DBnya baru kembalikan lagi ke tempat semula C:\xampp\mysql\data semoga membantu.

      Hapus
  8. pesan error saya seperti ini bang

    2020-10-07 10:54:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-10-07 10:54:30 0 [Note] InnoDB: Uses event mutexes
    2020-10-07 10:54:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-10-07 10:54:30 0 [Note] InnoDB: Number of pools: 1
    2020-10-07 10:54:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-10-07 10:54:30 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-10-07 10:54:30 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-10-07 10:54:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2020-10-07 10:54:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-10-07 10:54:31 0 [Note] InnoDB: Setting file 'D:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-10-07 10:54:31 0 [Note] InnoDB: File 'D:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-10-07 10:54:31 0 [Note] InnoDB: Waiting for purge to start
    2020-10-07 10:54:31 0 [Note] InnoDB: 10.4.11 started; log sequence number 47082; transaction id 9
    2020-10-07 10:54:31 0 [Note] InnoDB: Loading buffer pool(s) from D:\xampp\mysql\data\ib_buffer_pool
    2020-10-07 10:54:31 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-10-07 10:54:31 0 [Note] InnoDB: Buffer pool(s) load completed at 201007 10:54:31
    2020-10-07 10:54:31 0 [Note] Server socket created on IP: '::'.

    BalasHapus
    Balasan
    1. pindahin/rename ibtmp1 kemudian jalankan lagi service. kl juga belum berhasil pindahin ke folder lain(jangan di delete ya) semua yang ada difolder data. kemudian jalanin lagi service. semoga berhasil

      Hapus
  9. saya mau tanya min, kalau mysql_error.log dah di hapus isinya tapi masih tetep aja pesannya kayak gini
    Error: MySQL shutdown unexpectedly.
    08:21:43 [mysql] This may be due to a blocked port, missing dependencies,
    08:21:43 [mysql] improper privileges, a crash, or a shutdown by another method.
    08:21:43 [mysql] Press the Logs button to view error logs and check
    08:21:43 [mysql] the Windows Event Viewer for more clues
    08:21:43 [mysql] If you need more help, copy and post this
    08:21:43 [mysql] entire log window on the forums
    itu begimana ya min? Trims..

    BalasHapus
  10. InnoDB: using atomic writes.
    2020-11-26 9:10:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2020-11-26 9:10:28 0 [Note] InnoDB: Uses event mutexes
    2020-11-26 9:10:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2020-11-26 9:10:28 0 [Note] InnoDB: Number of pools: 1
    2020-11-26 9:10:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2020-11-26 9:10:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2020-11-26 9:10:28 0 [Note] InnoDB: Completed initialization of buffer pool
    2020-11-26 9:10:28 0 [Note] InnoDB: 1 out of 1 rollback segments are active.
    2020-11-26 9:10:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2020-11-26 9:10:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2020-11-26 9:10:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2020-11-26 9:10:28 0 [Note] InnoDB: Waiting for purge to start
    2020-11-26 9:10:28 0 [Note] InnoDB: 10.4.6 started; log sequence number 34773; transaction id 9
    2020-11-26 9:10:28 0 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
    2020-11-26 9:10:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2020-11-26 9:10:28 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
    2020-11-26 9:10:28 0 [Note] Plugin 'FEEDBACK' is disabled.
    2020-11-26 9:10:28 0 [Note] Server socket created on IP: '::'.

    error saya seperti ini tapi untuk file ibtmp1 tidak ada dalam folder itu. Jadi saya harus bagaimana?

    BalasHapus
  11. InnoDB: using atomic writes.
    2021-02-03 15:47:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2021-02-03 15:47:40 0 [Note] InnoDB: Uses event mutexes
    2021-02-03 15:47:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-02-03 15:47:40 0 [Note] InnoDB: Number of pools: 1
    2021-02-03 15:47:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2021-02-03 15:47:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2021-02-03 15:47:40 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-02-03 15:47:40 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2021-02-03 15:47:40 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2021-02-03 15:47:40 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2021-02-03 15:47:40 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2021-02-03 15:47:40 0 [Note] InnoDB: Waiting for purge to start
    2021-02-03 15:47:40 0 [Note] InnoDB: 10.4.17 started; log sequence number 47063; transaction id 8
    2021-02-03 15:47:40 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
    2021-02-03 15:47:40 0 [Note] Plugin 'FEEDBACK' is disabled.
    2021-02-03 15:47:40 0 [Note] InnoDB: Buffer pool(s) load completed at 210203 15:47:40
    2021-02-03 15:47:41 0 [Note] Server socket created on IP: '::'.
    2021-02-03 15:47:41 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


    2021-02-03 15:47:41 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2021-02-03 15:47:41 0 [ERROR] Aborting
    gan kalau ini errornya kenapa ya?

    BalasHapus
  12. InnoDB: using atomic writes.
    2021-05-27 22:44:05 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
    2021-05-27 22:44:05 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
    2021-05-27 22:44:05 0 [Note] InnoDB: Uses event mutexes
    2021-05-27 22:44:05 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2021-05-27 22:44:05 0 [Note] InnoDB: Number of pools: 1
    2021-05-27 22:44:05 0 [Note] InnoDB: Using SSE2 crc32 instructions
    2021-05-27 22:44:05 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
    2021-05-27 22:44:05 0 [Note] InnoDB: Completed initialization of buffer pool
    2021-05-27 22:44:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
    2021-05-27 22:44:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
    2021-05-27 22:44:05 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
    2021-05-27 22:44:05 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
    2021-05-27 22:44:05 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
    2021-05-27 22:44:05 0 [Note] InnoDB: New log files created, LSN=11451
    2021-05-27 22:44:05 0 [Note] InnoDB: Doublewrite buffer not found: creating new
    2021-05-27 22:44:05 0 [Note] InnoDB: Doublewrite buffer created
    2021-05-27 22:44:05 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
    2021-05-27 22:44:05 0 [Note] InnoDB: Creating foreign key constraint system tables.
    2021-05-27 22:44:05 0 [Note] InnoDB: Creating tablespace and datafile system tables.
    2021-05-27 22:44:05 0 [Note] InnoDB: Creating sys_virtual system tables.
    2021-05-27 22:44:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
    2021-05-27 22:44:05 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
    2021-05-27 22:44:05 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
    2021-05-27 22:44:05 0 [Note] InnoDB: Waiting for purge to start
    2021-05-27 22:44:05 0 [Note] InnoDB: 10.4.18 started; log sequence number 0; transaction id 7
    2021-05-27 22:44:05 0 [Note] Plugin 'FEEDBACK' is disabled.
    2021-05-27 22:44:05 0 [Note] Zerofilling moved table: '.\mysql\plugin'
    2021-05-27 22:44:05 0 [Note] Zerofilling moved table: '.\mysql\servers'
    2021-05-27 22:44:05 0 [Note] Server socket created on IP: '::'.


    error seperti begini, gimana ya gan? mohon dibantu..

    BalasHapus
  13. 2021-07-05 11:01:59 0 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.

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

    2021-07-05 11:01:59 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
    2021-07-05 11:01:59 0 [ERROR] Aborting

    Punya saya errornya begitu bang, minta tolong bagaimana solusinya

    BalasHapus

Saya pasti senang jika anda dapat memberi komentar sebagai jejak anda dan masukan atau pendapat anda, bahkan mungkin dapat menjadi referensi bagi teman yang lain juga bermanfaat bagi perkembangan blogon.id dalam menulis artikelnya, tetapi ingat tidak berbau p*rno, sara, tidak memasang link aktif dan tentunya tidak melanggar hak cipta orang lain ya...