Announcement

Collapse
No announcement yet.

DB Error after restore Unknown storage engine 'InnoDB'

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • spring
    replied
    This all seems resolved now. The upgrade from pl2 tp pl3 eventually completed - had alot of hanging, but i think that was due to local net congestion, so i had to refresh the upgrade process a bit. Everything is working again. yay etc.

    Leave a comment:


  • spring
    replied
    OK, DateCentre has converted the tables to MyISAM. They are offering to move me to a box that has InnoDB, i think i'll decline this as i see no reason to use InnoDB, given i have a small forum with a low overhead.

    Going to proceed as normal now and see what transpires..
    Last edited by spring; Sun 21st Dec '14, 6:16am.

    Leave a comment:


  • spring
    replied
    OK, let's try this - Here is the content of one of the allegedly corrupt tables, straight copy & paste from the .SQL file - does this look corrupt to you?:

    Code:
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `activitystream`
    --
    
    CREATE TABLE IF NOT EXISTS `activitystream` (
      `activitystreamid` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `userid` int(10) unsigned NOT NULL DEFAULT '0',
      `dateline` int(10) unsigned NOT NULL DEFAULT '0',
      `data` mediumtext NOT NULL,
      `contentid` int(10) unsigned NOT NULL DEFAULT '0',
      `typeid` int(10) unsigned NOT NULL DEFAULT '0',
      `action` enum('create','edit','delete') NOT NULL DEFAULT 'create',
      `score` decimal(13,3) NOT NULL DEFAULT '0.000',
      PRIMARY KEY (`activitystreamid`),
      KEY `score` (`score`,`dateline`),
      KEY `dateline` (`dateline`),
      KEY `typeid` (`typeid`,`dateline`),
      KEY `typeid_2` (`typeid`,`score`,`dateline`),
      KEY `contentid` (`contentid`,`typeid`),
      KEY `userid` (`userid`,`dateline`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    --
    -- Dumping data for table `activitystream`
    --
    
    INSERT INTO `activitystream` (`activitystreamid`, `userid`, `dateline`, `data`, `contentid`, `typeid`, `action`, `score`) VALUES
    (461, 21, 1409918217, '', 10203, 5, 'create', '0.000'),
    (462, 21, 1409918366, '', 10204, 5, 'create', '0.000'),
    (463, 21, 1409924679, '', 10205, 5, 'create', '0.000'),
    (464, 21, 1409924720, '', 10206, 5, 'create', '0.000'),
    (465, 21, 1409930939, '', 2849, 6, 'create', '1.210'),
    (466, 21, 1409934577, '', 2850, 6, 'create', '2.431'),
    (467, 21, 1410354725, '', 2851, 6, 'create', '1.212'),
    (468, 21, 1410512862, '', 10210, 5, 'create', '0.000'),
    (469, 21, 1410522549, '', 2852, 6, 'create', '1.354'),
    (470, 21, 1410522620, '', 2853, 6, 'create', '1.373'),
    (471, 21, 1410613534, '', 10213, 5, 'create', '0.000'),
    (472, 21, 1410613828, '', 10214, 5, 'create', '0.000'),
    (473, 21, 1410613883, '', 10215, 5, 'create', '0.000'),
    (474, 21, 1410957185, '', 2854, 6, 'create', '1.213'),
    (475, 8, 1411028078, '', 10217, 5, 'create', '0.000'),
    (476, 21, 1411127272, '', 2855, 6, 'create', '1.439'),
    (477, 21, 1411127346, '', 10219, 5, 'create', '0.000'),
    (478, 21, 1411217133, '', 10220, 5, 'create', '0.000'),
    (479, 21, 1411221964, '', 10221, 5, 'create', '0.000'),
    (480, 21, 1411222013, '', 10222, 5, 'create', '0.000'),
    (481, 21, 1411563515, '', 2856, 6, 'create', '1.107'),
    (482, 21, 1411924694, '', 10224, 5, 'create', '0.000'),
    (483, 21, 1411924758, '', 2857, 6, 'create', '1.409'),
    (484, 21, 1411925245, '', 10226, 5, 'create', '0.000'),
    (485, 21, 1411925312, '', 10227, 5, 'create', '0.000'),
    (486, 21, 1412169027, '', 2858, 6, 'create', '1.211'),
    (487, 21, 1412334603, '', 2859, 6, 'create', '1.362'),
    (488, 21, 1412437133, '', 10230, 5, 'create', '0.000'),
    (489, 21, 1412438033, '', 10231, 5, 'create', '0.000'),
    (490, 21, 1412438091, '', 2860, 6, 'create', '2.174'),
    (491, 21, 1412455247, '', 2861, 6, 'create', '1.205'),
    (492, 21, 1412455334, '', 10234, 5, 'create', '0.000'),
    (493, 21, 1412775914, '', 2862, 6, 'create', '1.211'),
    (494, 21, 1412942546, '', 2863, 6, 'create', '1.340'),
    (495, 21, 1413036312, '', 10237, 5, 'create', '0.000'),
    (496, 21, 1413036501, '', 10238, 5, 'create', '0.000'),
    (497, 21, 1413036647, '', 10239, 5, 'create', '0.000'),
    (498, 21, 1413202055, '', 2864, 6, 'create', '1.458'),
    (499, 21, 1413202565, '', 10241, 5, 'create', '0.000'),
    (500, 21, 1413366353, '', 10242, 5, 'create', '0.000'),
    (501, 21, 1413373993, '', 2865, 6, 'create', '1.212'),
    (502, 21, 1413547958, '', 2866, 6, 'create', '1.398'),
    (503, 21, 1413643743, '', 10245, 5, 'create', '0.000'),
    (504, 21, 1413643820, '', 10246, 5, 'create', '0.000'),
    (505, 8, 1413966006, '', 2867, 6, 'create', '1.132'),
    (507, 21, 1413981309, '', 2868, 6, 'create', '1.209'),
    (508, 21, 1413991210, '', 10250, 5, 'create', '0.000'),
    (509, 2073, 1414009463, '', 10251, 5, 'create', '0.000'),
    (510, 21, 1414159507, '', 2869, 6, 'create', '1.337'),
    (511, 21, 1414595371, '', 2870, 6, 'create', '1.212'),
    (512, 21, 1414667985, '', 10254, 5, 'create', '0.000'),
    (513, 30, 1414760016, '', 2871, 6, 'create', '1.640'),
    (514, 30, 1414760397, '', 2872, 6, 'create', '1.308'),
    (515, 21, 1414768695, '', 2873, 6, 'create', '1.342'),
    (516, 21, 1414847187, '', 10258, 5, 'create', '0.000'),
    (517, 21, 1414847530, '', 10259, 5, 'create', '0.000'),
    (518, 21, 1414847571, '', 10260, 5, 'create', '0.000'),
    (519, 21, 1414847630, '', 10261, 5, 'create', '0.000'),
    (520, 21, 1414847682, '', 2874, 6, 'create', '2.235'),
    (521, 2073, 1415160938, '', 10263, 5, 'create', '0.000'),
    (522, 21, 1415196999, '', 2875, 6, 'create', '1.209'),
    (523, 638, 1415352604, '', 10265, 5, 'create', '0.000'),
    (524, 21, 1415365172, '', 2876, 6, 'create', '1.206'),
    (525, 21, 1415468149, '', 10267, 5, 'create', '0.000'),
    (526, 21, 1415468900, '', 10268, 5, 'create', '0.000'),
    (527, 21, 1415468988, '', 10269, 5, 'create', '0.000'),
    (528, 21, 1415799837, '', 2877, 6, 'create', '1.211'),
    (529, 21, 1415890775, '', 2878, 6, 'create', '1.212'),
    (530, 21, 1416071875, '', 10272, 5, 'create', '0.000'),
    (531, 21, 1416071985, '', 10273, 5, 'create', '0.000'),
    (532, 21, 1416072052, '', 10274, 5, 'create', '0.000'),
    (533, 33, 1416133955, '', 2879, 6, 'create', '1.149'),
    (534, 21, 1416143080, '', 10276, 5, 'create', '0.000'),
    (535, 21, 1416145781, '', 10277, 5, 'create', '0.000'),
    (536, 21, 1416146784, '', 10278, 5, 'create', '0.000'),
    (537, 21, 1416147574, '', 10279, 5, 'create', '0.000'),
    (538, 30, 1416194523, '', 10280, 5, 'create', '0.000'),
    (539, 2073, 1416197709, '', 10281, 5, 'create', '0.000'),
    (540, 21, 1416244244, '', 10282, 5, 'create', '0.000'),
    (541, 21, 1416245758, '', 10283, 5, 'create', '0.000'),
    (542, 2073, 1416270221, '', 10284, 5, 'create', '0.000'),
    (543, 21, 1416300752, '', 10285, 5, 'create', '0.000'),
    (544, 2073, 1416360171, '', 10286, 5, 'create', '0.000'),
    (545, 21, 1416407895, '', 2880, 6, 'create', '1.209'),
    (546, 21, 1416676933, '', 10288, 5, 'create', '0.000'),
    (547, 21, 1416677035, '', 10289, 5, 'create', '0.000'),
    (548, 21, 1416677103, '', 10290, 5, 'create', '0.000'),
    (549, 21, 1417011369, '', 2881, 6, 'create', '1.209'),
    (550, 21, 1417199027, '', 2882, 6, 'create', '1.116'),
    (551, 21, 1417199079, '', 2883, 6, 'create', '1.120'),
    (552, 21, 1417265241, '', 10294, 5, 'create', '0.000'),
    (554, 1, 1417265768, '', 2884, 6, 'create', '1.101'),
    (555, 1, 1417266109, '', 10297, 5, 'create', '0.000'),
    (556, 1, 1417266189, '', 10298, 5, 'create', '0.000'),
    (557, 21, 1417609040, '', 2885, 6, 'create', '1.101');
    
    -- --------------------------------------------------------

    Leave a comment:


  • spring
    replied
    It's a shared hosting platform, so i doubt i'll be allowed play with the WHM or SSH as root. I'm just trying to establish right now if the DB is corrupt, or SQL is running without, or has disabled InnoDB, hence the question about _all_ tables showing: Error: Unknown storage engine 'InnoDB'

    I can patch the DB - i can just drop the corrupt/error'd tables from the latest backup, then import them from a much older backup. Almost all of them are tables i have no use for, like blog & CMS and so on, but i don't want to waste my time over this if i'm just going to end up in the same jam.

    Edit: i can clearly see now looking at the raw .SQL that all the 'corrupt' tables use InnoDB, the working ones use 'MyISAM', and the corrupt ones are 99% related to functions we have never used - like CMS and BLOG. I should just drop all the corrupt tables - right?
    Last edited by spring; Sun 21st Dec '14, 4:58am.

    Leave a comment:


  • Zachery
    replied
    Could be a fair number of issues, and unless you have ROOT access to the server, you won't be able to solve many if any of them.

    Leave a comment:


  • spring
    replied
    Hi Zach..

    I have asked this, no clear answer yet. Seems kinda obviously the issue here.

    I notice that the majority of the tables giving trouble are ones i do not use, like ones related to blog etc., plenty of others are fine though - so i'm wondering (also) should not ALL tables give errors if innoDB was missing/not enabled?

    Leave a comment:


  • Zachery
    replied
    Are they sure that they have innodb enabled/configured in your MySQL installation?

    Leave a comment:


  • spring
    started a topic [Forum] DB Error after restore Unknown storage engine 'InnoDB'

    DB Error after restore Unknown storage engine 'InnoDB'

    I'm having issues after a crash at my datacentre forced them to rebuild the box i had my forum on.

    I can't begin an upgrade from 4.2.2pl2 to 4.2.2pl3 because of errors - example:

    Code:
    <?xml version="1.0" encoding="windows-1252"?>
    <?xml version="1.0" encoding="windows-1252"?>
    <errors>
        <error><![CDATA[<p>Database Error</p>
    
    Invalid SQL:
    
            SELECT stylevar.*,
                INSTR(',-1,', CONCAT(',', stylevar.styleid, ',') ) AS ordercontrol
            FROM stylevar AS stylevar
            INNER JOIN stylevardfn AS stylevardfn ON (stylevardfn.stylevarid = stylevar.stylevarid AND product ='vbblog')
            WHERE stylevar.styleid IN (-1)
            ORDER BY ordercontrol DESC;
    
    Unknown storage engine 'InnoDB']]></error>
        <error_html><![CDATA[<p>Database error in vBulletin 4.2.2</p>
    <p>Invalid SQL:
    
            SELECT stylevar.*,
                INSTR(',-1,', CONCAT(',', stylevar.styleid, ',') ) AS ordercontrol
            FROM stylevar AS stylevar
            INNER JOIN stylevardfn AS stylevardfn ON (stylevardfn.stylevarid = stylevar.stylevarid AND product ='vbblog')
            WHERE stylevar.styleid IN (-1)
            ORDER BY ordercontrol DESC;<p>
    <p>
    <strong>MySQL Error</strong>   : Unknown storage engine 'InnoDB'<br />
    <strong>Error Number</strong>  : 1286<br />
    <strong>Request Date</strong>  : Saturday, December 20th 2014 @ 02:11:01 PM<br />
    <strong>Error Date</strong>    : Saturday, December 20th 2014 @ 02:11:01 PM<br />
    <strong>Script</strong>        : http://***/vbulletin/install/upgrade.php<br />
    <strong>Referrer</strong>      : http://***/vbulletin/install/upgrade.php<br />
    <strong>Classname</strong>     : vB_Database<br />
    <strong>MySQL Version</strong> : 5.5.40-cll<br />
    </p>]]></error_html>
    </errors>
    ..nor does the board function anymore, beyone some of the Admin CP.

    We have restored the last .sql dump i had, after all the tables in the DB mysteriously clearing, but checking the DB in cpanel gives plenty of this:

    Code:
     
     [***_vb3forum.action] Error: Unknown storage engine 'InnoDB' [***_vb3forum.action] error: Corrupt
    if i try to EMPTY that table (truncate it) in phpMYadmin i'm told it does not exist.

    the datacentre has been playing with things for over a week now, and not alot has changed for us, same 'innoDB' nonsense at every turn.

    OK, so, my question - let's assume for a moment here that InnoDB is present, that SQL was compiled with it in mind, could a simple corruption of my DB cause SQL to complain like this all the time?

    The reason i ask is because i have been pointing out the InnoDB missing stuff for 7 days, and nothing is changing, and i remember about 10 days BEFORE the datacentre had their hardware issue that killed the box seeing some random DB errors on the board that i had never seen before. these were sporadic and uncommon, and i could not repeat them - but they all smacked heavily of damaged storage - i'm thinking my database could have been progressivley corrupting over a period of 14+ days before the box itself finally died.

    TIA..

    Springer.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X