Mariadb tables crash constantly

Discussion in 'ISPConfig 3 Priority Support' started by Taleman, Feb 3, 2019.

  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    What could be causing mariadb tables crashing constantly?
    Debian GNU/Linux 9.7, ISPConfig 3.1.13. Apache web server.
    Code:
    mariadb-server-10.1:
      Installed: 10.1.37-0+deb9u1
    
    Code:
    2019-02-03 19:33:25 139971540297472 [ERROR] mysqld: Table './npertti_futsal/smf_topics' is marked as crashed and should be repaired
    2019-02-03 19:33:25 139973697038080 [ERROR] mysqld: Table './npertti_futsal/smf_topics' is marked as crashed and should be repaired
    2019-02-03 19:33:25 139971540297472 [Warning] Checking table:   './npertti_futsal/smf_topics'
    2019-02-03 19:34:45 139973614794496 [ERROR] mysqld: Table './npertti_frisbee/smf_topics' is marked as crashed and should be repaired
    2019-02-03 19:34:45 139973614794496 [Warning] Checking table:   './npertti_frisbee/smf_topics'
    2019-02-03 19:34:53 139973614794496 [ERROR] mysqld: Table './npertti_frisbee/smf_members' is marked as crashed and should be repaired
    2019-02-03 19:34:53 139973614794496 [Warning] Checking table:   './npertti_frisbee/smf_members'
    2019-02-03 19:35:45 139972751476480 [ERROR] mysqld: Table './npertti_futsal/smf_log_online' is marked as crashed and should be repaired
    2019-02-03 19:35:45 139971538691840 [ERROR] mysqld: Table './npertti_futsal/smf_log_online' is marked as crashed and should be repaired
    2019-02-03 19:35:45 139971538491136 [ERROR] mysqld: Table './npertti_futsal/smf_log_online' is marked as crashed and should be repaired
    2019-02-03 19:35:53 139972751476480 [Warning] Checking table:   './npertti_futsal/smf_log_online'
    2019-02-03 19:35:55 139971540899584 [ERROR] mysqld: Table './npertti_wwwdeyt/nsuhi_rsseo_visitors' is marked as crashed and should be repaired
    2019-02-03 19:35:55 139971773646592 [ERROR] mysqld: Table './npertti_wwwdeyt/nsuhi_rsseo_visitors' is marked as crashed and should be repaired
    2019-02-03 19:35:55 139971538089728 [ERROR] mysqld: Table './npertti_wwwdeyt/nsuhi_rsseo_visitors' is marked as crashed and should be repaired
    2019-02-03 19:35:55 139971774248704 [ERROR] mysqld: Table './npertti_wwwdeyt/nsuhi_rsseo_visitors' is marked as crashed and should be repaired
    2019-02-03 19:35:55 139971636156160 [ERROR] mysqld: Table './npertti_wwwdeyt/nsuhi_rsseo_visitors' is marked as crashed and should be repaired
    2019-02-03 19:35:55 139971540899584 [Warning] Checking table:   './npertti_wwwdeyt/nsuhi_rsseo_visitors'
    2019-02-03 19:36:00 139971636557568 [ERROR] mysqld: Table './c1NuhviFoo/phpbb_topics' is marked as crashed and should be repaired
    2019-02-03 19:36:00 139971539293952 [ERROR] mysqld: Table './c1NuhviFoo/phpbb_topics' is marked as crashed and should be repaired
    2019-02-03 19:36:00 139971636557568 [Warning] Checking table:   './c1NuhviFoo/phpbb_topics'
    
    Load is very high, maybe because mysql process is constantly repairing those tables.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe harddisk problems? If it's a raid, check raid state. And also check the hd smart state with smartmontools, maybe one of the HD's has a high failure rate.
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    This runs on a virtual host. I see no errors on other virtual hosts running on this same iron host.
    I have now checked disk is not full, there is 6 GB merory free, swap in use is 70 MBytes of 2000 MBytes.
    Now that I read the /var/log/mysql/error.log back, problem started today 16:52. mariadb crashed, and dumped memory map.
    Maybe that crash cause several tables to crash? And now mariadb is just repairing those crashed tables? Can I force a repair of all tables in all databases?
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    The problem might have repaired itself eventually. I suspect the mariadb crash earlier today broke tables. Now it was doing repairs table by table as a broken table was used for something. Load was going down slowly, too.
    I did issue command
    Code:
    mysqlcheck --all-databases -p
    to get all fixed. Looks like that command takes hours to complete.
     
    till likes this.

Share This Page