Unexpected Database Errors

ting.mike · Dec 25, 2012

So after a few months of smooth sailing with XenForo, this few days I've seen the forum went down a few times with the error message "An unexpected database error occurred. Please try again later."

I would reboot the server and it would go back up, only to have the same problem reoccurring after a few hours. Also during this period when the forum is online, sometimes trying to open certain threads return the same "An unexpected database error occurred. Please try again later."

Any clue what to look for?

ting.mike · Dec 25, 2012

It seems that the database has been corrupted. I'm attempting to do forced recovery as explained in:
http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html

ting.mike · Dec 25, 2012

I installed phpmyadmin, did a repair on all the tables, but the repair doesn't work. Still showing errors on pretty much all tables.

TableOpMsg_typeMsg_text
cycling.da_ssx repair Error Unknown table engine 'InnoDB'
cycling.da_ssx repair error Corrupt
cycling.xf_addon repair Error Unknown table engine 'InnoDB'
cycling.xf_addon repair error Corrupt
cycling.xf_admin repair Error Unknown table engine 'InnoDB'
cycling.xf_admin repair error Corrupt
cycling.xf_admin_log repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_log repair error Corrupt
cycling.xf_admin_navigation repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_navigation repair error Corrupt
cycling.xf_admin_permission repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_permission repair error Corrupt
cycling.xf_admin_permission_entry repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_permission_entry repair error Corrupt
cycling.xf_admin_search_type repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_search_type repair error Corrupt
cycling.xf_admin_template repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_template repair error Corrupt
cycling.xf_admin_template_compiled repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_template_compiled repair error Corrupt
cycling.xf_admin_template_include repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_template_include repair error Corrupt
cycling.xf_admin_template_phrase repair Error Unknown table engine 'InnoDB'
cycling.xf_admin_template_phrase repair error Corrupt
cycling.xf_attachment repair Error Unknown table engine 'InnoDB'
cycling.xf_attachment repair error Corrupt
cycling.xf_attachment_data repair Error Unknown table engine 'InnoDB'
cycling.xf_attachment_data repair error Corrupt
cycling.xf_attachment_view repair note The storage engine for the table doesn't support r...
cycling.xf_ban_email repair Error Unknown table engine 'InnoDB'
cycling.xf_ban_email repair error Corrupt
cycling.xf_bb_code_media_site repair Error Unknown table engine 'InnoDB'

There are still more entries on the error log..

ting.mike · Dec 25, 2012

Something is seriously wrong... all tables are empty except for these two:

xf_search_index

6,630

MyISAM utf8_general_ci

6.3 MiB

-

xf_session

61

MyISAM utf8_general_ci

22.8 KiB

-

xf_session_activity

0

MEMORY utf8_general_ci

0 B

-

xf_session_admin

ting.mike · Dec 25, 2012

Exported the tables and a lot of them seem to be unreadable:

-- phpMyAdmin SQL Dump
-- version 3.3.7deb7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 25, 2012 at 10:34 AM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cycling`
--

-- --------------------------------------------------------

--
-- Table structure for table `da_ssx`
--
-- in use(#1286 - Unknown table engine 'InnoDB')

--
-- Dumping data for table `da_ssx`
--
-- in use (#1286 - Unknown table engine 'InnoDB')

-- --------------------------------------------------------

--
-- Table structure for table `xf_addon`
--
-- in use(#1286 - Unknown table engine 'InnoDB')

--
-- Dumping data for table `xf_addon`
--
-- in use (#1286 - Unknown table engine 'InnoDB')

-- --------------------------------------------------------

--
-- Table structure for table `xf_admin`
--
-- in use(#1286 - Unknown table engine 'InnoDB')

--
-- Dumping data for table `xf_admin`
--
-- in use (#1286 - Unknown table engine 'InnoDB')

-- --------------------------------------------------------

--
-- Table structure for table `xf_admin_log`
--
-- in use(#1286 - Unknown table engine 'InnoDB')

--
-- Dumping data for table `xf_admin_log`
--
-- in use (#1286 - Unknown table engine 'InnoDB')

-- --------------------------------------------------------

--
-- Table structure for table `xf_admin_navigation`
--
-- in use(#1286 - Unknown table engine 'InnoDB')

--
-- Dumping data for table `xf_admin_navigation`
--
-- in use (#1286 - Unknown table engine 'InnoDB')

ting.mike · Dec 25, 2012

Looks like I'm having some very deep problems with mysql.

MattW · Dec 25, 2012

ting.mike said:
I installed phpmyadmin, did a repair on all the tables, but the repair doesn't work. Still showing errors on pretty much all tables.

Error Unknown table engine 'InnoDB'

There are still more entries on the error log..

You need to make sure InnoDB is enabled in your my.cnf file.

ting.mike · Dec 25, 2012

MattW said:
You need to make sure InnoDB is enabled in your my.cnf file.

Hi Matt,
I tried googling about this, and it seems that innodb is enabled by default, unless the my.cnf file has a skip-innodb line?

Here is the guide that I'm referring:
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#option_mysqld_innodb

MattW · Dec 26, 2012

Hmm, i'd say something more is corrupt then, as it's probably not starting innodb due to errors with the database.

ting.mike · Dec 26, 2012

Thanks, Matt

ting.mike · Dec 26, 2012

So I guess we've hit a wall?

MattW · Dec 26, 2012

These errors look suspect as to why it's not starting innodb

Code:

Dec 25 06:25:14 www mysqld: 121225 6:25:14 InnoDB: ERROR: We were only able to scan the log up to
Dec 25 06:25:14 www mysqld: InnoDB: 0 620322816, but a checkpoint was at 0 620322958.
Dec 25 06:25:14 www mysqld: InnoDB: It is possible that the database is now corrupt!
Dec 25 06:25:14 www mysqld: 121225 6:25:14 InnoDB: Error: page 2837 log sequence number 0 620379562
Dec 25 06:25:14 www mysqld: InnoDB: is in the future! Current system log sequence number 0 620322958.
Dec 25 06:25:14 www mysqld: InnoDB: Your database may be corrupt or you may have copied the InnoDB
Dec 25 06:25:14 www mysqld: InnoDB: tablespace but not the InnoDB log files. See
Dec 25 06:25:14 www mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html
Dec 25 06:25:14 www mysqld: InnoDB: for more information.

Is your VPS managed or unmanaged? Do you have any recent backups of your database?

ting.mike · Dec 26, 2012

I've finally been able to get the forum back up with a help from an expert... it seems that the InnoDB file was corrupted.

MattW · Dec 26, 2012

Glad it's sorted for you, and sorry we couldn't help getting it back online

ting.mike · Dec 28, 2012

MattW said:
Glad it's sorted for you, and sorry we couldn't help getting it back online

No, Matt. I really appreciate you and Jake helping me out.. it's just that some things are too complicated to be sorted out through forum messages.

The support by XenForo has been exceptional and I know I can count on people like Jake and you to provide help.

Thanks, guys!

Unexpected Database Errors

ting.mike

Member

ting.mike

Member

ting.mike

Member

ting.mike

Member

ting.mike

Member

ting.mike

Member

MattW

Well-known member

ting.mike

Member

MattW

Well-known member

ting.mike

Member

ting.mike

Member

MattW

Well-known member

ting.mike

Member

MattW

Well-known member

ting.mike

Member

Similar threads

We value your privacy