{"id":8525,"date":"2014-10-27T18:27:35","date_gmt":"2014-10-27T16:27:35","guid":{"rendered":"https:\/\/eltallerdelbit.com\/?p=8525"},"modified":"2019-03-10T18:47:16","modified_gmt":"2019-03-10T17:47:16","slug":"mysql-error-innodb-ibdata1-cant-be-opened-in-read-write-mode","status":"publish","type":"post","link":"https:\/\/eltallerdelbit.com\/mysql-error-innodb-ibdata1-cant-be-opened-in-read-write-mode\/","title":{"rendered":"MySQL – [ERROR] InnoDB: ibdata1 can’t be opened in read-write mode"},"content":{"rendered":"

En ocasiones recibiremos errores en nuestro log del servidor MySql de Xampp<\/strong>.<\/p>\n

En este caso os traemos la respuesta para el caso: [ERROR] InnoDB: C:\\xampp\\mysql\\data\\ibdata1 can’t be opened in read-write mode<\/strong>.<\/h2>\n

 
\nEn principio observamos un error en el servicio de MySQL:<\/p>\n

\"Error<\/p>\n

 
\nY tal y como reza el mensaje en color rojo, nos dedicamos a investigar en el archivo de log de MySQL.<\/p>\n

\"ibdata1<\/p>\n

 <\/p>\n

 
\nEn un caso como este nos podemos encontrar con un log parecido al siguiente:<\/p>\n

22:21:30 25172 [Note] Plugin 'FEDERATED' is disabled. \r\n22:21:30 3bbc 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.\r\n22:21:30 25172 [Note] InnoDB: Using atomics to ref count buffer pool pages\r\n22:21:30 25172 [Note] InnoDB: The InnoDB memory heap is disabled\r\n22:21:30 25172 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions\r\n22:21:30 25172 [Note] InnoDB: Memory barrier is not used\r\n22:21:30 25172 [Note] InnoDB: Compressed tables use zlib 1.2.3\r\n22:21:30 25172 [Note] InnoDB: Not using CPU crc32 instructions\r\n22:21:30 25172 [Note] InnoDB: Initializing buffer pool, size = 16.0M\r\n22:21:30 25172 [Note] InnoDB: Completed initialization of buffer pool\r\n22:21:30 25172 [ERROR] InnoDB: C:\\xampp\\mysql\\data\\ibdata1 can't be opened in read-write mode\r\n22:21:30 25172 [ERROR] InnoDB: The system tablespace must be writable!\r\n22:21:30 25172 [ERROR] Plugin 'InnoDB' init function returned error.22:21:30 25172 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.\r\n22:21:30 25172 [ERROR] Unknown\/unsupported storage engine: InnoDB\r\n22:21:30 25172 [ERROR] Aborting\r\n22:21:30 25172 [Note] Binlog end\r\n22:21:30 25172 [Note] Shutting down plugin 'partition'\r\n22:21:30 25172 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_SYS_TABLES'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_CONFIG'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_DELETED'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_METRICS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMPMEM'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMP_RESET'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_CMP'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_LOCKS'\r\n22:21:30 25172 [Note] Shutting down plugin 'INNODB_TRX'\r\n22:21:30 25172 [Note] Shutting down plugin 'BLACKHOLE'\r\n22:21:30 25172 [Note] Shutting down plugin 'ARCHIVE'\r\n22:21:30 25172 [Note] Shutting down plugin 'MRG_MYISAM'\r\n22:21:30 25172 [Note] Shutting down plugin 'MyISAM'\r\n22:21:30 25172 [Note] Shutting down plugin 'MEMORY'\r\n22:21:30 25172 [Note] Shutting down plugin 'CSV'\r\n22:21:30 25172 [Note] Shutting down plugin 'sha256_password'\r\n22:21:30 25172 [Note] Shutting down plugin 'mysql_old_password'\r\n22:21:30 25172 [Note] Shutting down plugin 'mysql_native_password'\r\n22:21:30 25172 [Note] Shutting down plugin 'binlog'\r\n22:21:30 25172 [Note] C:\\xampp\\mysql\\bin\\mysqld.exe: Shutdown complete\r\n<\/pre>\n
Lo que hemos de hacer es buscar la primera linea de error, tras la cual se desencadenan los dem\u00e1s eventos de error.<\/p>\n
Ese primer error, presumiblemente ser\u00e1 el problema que debemos solucionar (puede ser que a posteriori encontremos m\u00e1s errores, pero ese ya es otro cantar…).
\n <\/p>\n
 
\nEn este caso la linea desencadenante de la malfunci\u00f3n de MySQL es :<\/p>\n
[ERROR] InnoDB: C:\\xampp\\mysql\\data\\ibdata1 can't be opened in read-write mode<\/pre>\n
 <\/p>\n
 
\n
<\/p>\n
La soluci\u00f3n de [ERROR] InnoDB: ibdata1 can’t be opened in read-write mode<\/strong> es:<\/h3>\n
 <\/p>\n
    \n
      \n
    • Parar los servicios Mysql y Apache.<\/li>\n
    • Apagar Xampp.<\/li>\n
    • Acceder al directorio Xampp\/mysql\/data<\/strong> y borrar el archivo ibdata<\/strong><\/em> y los archivos de ib_logfile<\/em>.<\/li>\n<\/ul>\n<\/ul>\n
      \"ibdata<\/p>\n
        \n
      • Abrir el archivo mysql_error.log<\/em>, vaciarlo, y guardarlo.<\/li>\n
      • Reiniciar Xampp<\/li>\n
      • Reiniciar los servicios MySQL y Apache.<\/li>\n<\/ul>\n
        <\/center>
        \n 
        \n
        Hecho esto, ya podremos acceder a PhpMyadmin sin problema.
        \nSi a\u00fan as\u00ed no podemos acceder, debemos seguir el rastro de los errores del log de mysql y apache, hasta acabar de solucionar todos los errores.<\/center>
        \n <\/p>\n\n
        <\/div>","protected":false},"excerpt":{"rendered":"
        En ocasiones recibiremos errores MySql En este caso os traemos la respuesta para: [ERROR] InnoDB: C:
        \nmppmysqldataibdata1 can’t be opened in read-write mode.<\/p>\n","protected":false},"author":1,"featured_media":8527,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false},"categories":[85],"tags":[486,169],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts\/8525"}],"collection":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/comments?post=8525"}],"version-history":[{"count":0,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/posts\/8525\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/media\/8527"}],"wp:attachment":[{"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/media?parent=8525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/categories?post=8525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eltallerdelbit.com\/wp-json\/wp\/v2\/tags?post=8525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}