innodb

  1. B

    Mysql not starting

    Mysql is not starting generating following error. The system encountered an error while starting the “mysql” service with the command “/etc/init.d/mysql start”: The subprocess reported error number 1 when it ended. at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 1358...
  2. z3d3m0n

    InnoDB database died

    Hello Fellow cPanel gurus, today in the morning i found mysql crashed , could not bring it up to do a check , nor event into recovery mode: would appreciate any advices here is the full story InnoDB: Failing assertion: addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA InnoDB: We...
  3. T

    MySQL crash - log files

    Hi there, I'm trying to figure out why our MySQL server went down last night. I found a lot of errors in our logs. Here is one of the most important errors: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away I did as Bluehost suggested and checked the error file here...
  4. S

    MySQL Crashing Issue

    171114 09:12:16 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended InnoDB: To fix the problem and start mysqld: 171114 09:12:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 171114 09:12:10 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended...
  5. M

    mysql.innodb_index_stats are not present

    Hello The sites are working and the databases are ok. Does anyone have a suggestion of how to fix this problem? I.E. 2017-11-03 13:19:33 7fb4f114c700 InnoDB: Error: Fetch of persistent statistics requested for table "user_25projetos2"."u5xlr_xmap_sitemap" but the required system tables...
  6. M

    Restore all databases ibdata1 corrupted

    Hello, we all know how is terrible have the file ibdata1 corrupted. What am I going to do? A new installation of MYSQL and then restore all databases. This will rebuild ibdata1 This script I found is wonderful but it works with compressed backups only. Does anyone know how to reprogram it to...
  7. M

    Unknown storage engine 'InnoDB' error: Corrupt

    hello when i repair a database, i receive this error: Unknown storage engine 'InnoDB' error: Corrupt screenshot: image.prntscr.com/image/6sF0b0RLSoSsLZ2pUjY5og.png then, i trying fix using this tutorial: InnoDB Corruption Repair Guide and i trying run this command: CREATE TABLE...
  8. M

    MySQL Wont Start

    Hello, Any one can help with this isseu please. Waiting for “mysql” to start ……[2017-09-06 18:19:19 -0500] warn [restartsrv_mysql] The system encountered an error while starting the “mysql” service with the command “/etc/init.d/mysql start”: The subprocess reported error number 1 when it...
  9. D

    MySql Crash - Won't Restart

    Had mysql crash this morning and couldn't get it to restart. From the error log: 2017-08-24 11:22:34 0 [Note] /usr/sbin/mysqld (mysqld 5.6.37) starting as process 29908 ... 2017-08-24 11:22:34 29908 [Note] Plugin 'FEDERATED' is disabled. 2017-08-24 11:22:34 29908 [Note] InnoDB: Using atomics to...
  10. A

    Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/

    Hi, Is it safe to delete: email_log_system_system.ibd in var/lib/mysql/rewllcxy_email/ This file size is 4.7gb and i don't why? Is it safe to delete or clean it!
  11. A

    Unknown storage engine 'InnoDB' error

    Hello everyone, I'm new on the forum. I'm having problems with the INNO DB database, someone might tell me how to solve this problem. Thank you Check_mysql has determined that there are corrupted database tables cPanel & WHM has determined that the following database tables are corrupt...
  12. R

    Correct way fix system after database folder deletion

    Hello! Some time ago we have deleted database folder '/var/lib/mysql/db'. The disk was full and this was fastest solution to make free space on disk. We have no backup for the deleted database. After some time the following error was generated on '/var/log/mqsqlhost.err': After searching with...
  13. T

    MySQL crashed and corrupted database after graceful server reboot

    Hi, Recently there was a kernel upgrade which was advised by Security Advisor, as usual I clicked on Update button and it upgraded the kernel, after that security advisor suggested to restart the server, which I did using Graceful Server Restart option but after restart the mysql service...
  14. U

    Multiple MySQL Processes

    Hi, here is my log hostname.err InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld process InnoDB: using the same InnoDB data or log files. InnoDB: Unable to lock ./ibdata1, error: 11 InnoDB: Check that you do not already have another mysqld...
  15. O

    MySQL Monitoring failed to detect partial outage

    Twice today MySQL crashed, recovered fine the first, but not after the second. No cPanel server monitoring detected the condition, so no automated recovery took place. There are a few log entries that perhaps should be monitored for ... why wouldn't something like 'Fatal error' be detected ...
  16. S

    Restoring Database from Backup Problem

    Hi, I recently had a problem with a database that got corrupted (it has InnoDB tables). I tried restoring a backup, didn't know that on my settings I had the option 'per account only'. By the way, I am getting desperate because I see only one table is being restored, missing the rest of the...
  17. M

    ibdata1 corrupted

    Dear All, Today is my bad day, one of my server having issue with bad sector, when i try to copy everything to new hard disk, seem the only ibdata1 is unavailable to copy with input/output error, that mean the bad sector is seriously on the 8GB ibdata1, trying to fsck but still no luck, then...
  18. T

    InnoDB Corruption

    Dear cPanel, Thank you for your respon, i was upgrade to 10.0.25-MariaDB and using Percona-XtraDB. Today my server has been shut down abruptly because electric power is off. when server is starting, my Mysql can't start in .err file. I got some error like this. 160802 9:42:32 [ERROR]...
  19. M

    Error Unknown storage engine 'InnoDB' |wp_meta in use

    Hi i have problem in table wp_meta it in use if i click on table i try to repair and chek it but it not help how can i fix it ? thanks
  20. carock

    Problem Restoring Database Properly

    I was tasked with restoring a user's MySQL database from backup. The user was not in the normal backups, but their database was backed up in the system backup. The problem I had is their database was InnoDB, so you can't just copy the files and make magic happen. I would like to suggest maybe...