Bug 24156 - MySQL не хочет работать с InnoDB
: MySQL не хочет работать с InnoDB
Status: CLOSED WORKSFORME
: Sisyphus
(All bugs in Sisyphus/MySQL-server)
: unstable
: all Linux
: P3 critical
Assigned To:
:
:
:
:
:
  Show dependency tree
 
Reported: 2010-09-26 08:29 by
Modified: 2010-09-27 14:35 (History)


Attachments


Note

You need to log in before you can comment on or make changes to this bug.


Description From 2010-09-26 08:29:37
MySQL 5.1 отказывается работать с InnoDB:
mysqldump: Got error: 1286: Unknown table engine 'InnoDB' when using

Замечено на всех стоящих клиентах: mysql php5-mysql
------- Comment #1 From 2010-09-26 21:51:36 -------
на мантейнера
------- Comment #2 From 2010-09-27 13:54:49 -------
Расскажите пожалуйста, как воспроизвести ошибку.

Я попробовал:
mysql> create database tdata;
Query OK, 1 row affected (0.00 sec)

mysql> use tdata
mysql> CREATE table t1 ( c1 INT, c2 CHAR(250) ) ENGINE InnoDB;
Query OK, 0 rows affected (0.02 sec)

mysql> insert into t1 VALUES(1,'test');
Query OK, 1 row affected (0.01 sec)

mysql> insert into t1 VALUES(2,'test2');
Query OK, 1 row affected (0.01 sec)

mysql> insert into t1 VALUES(3,'test3');
Query OK, 1 row affected (0.01 sec)


# mysqldump tdata
-- MySQL dump 10.13  Distrib 5.1.50, for alt-linux-gnu (x86_64)
--
-- Host: localhost    Database: tdata
-- ------------------------------------------------------
-- Server version    5.1.50

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `t1`
--

DROP TABLE IF EXISTS `t1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t1` (
  `c1` int(11) DEFAULT NULL,
  `c2` char(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t1`
--

LOCK TABLES `t1` WRITE;
/*!40000 ALTER TABLE `t1` DISABLE KEYS */;
INSERT INTO `t1` VALUES (1,'test'),(2,'test2'),(3,'test3');
/*!40000 ALTER TABLE `t1` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-09-27 13:48:46
------- Comment #3 From 2010-09-27 14:19:52 -------
service mysqld restart не помогло.
После перезагрузки системы все штатно заработало.
------- Comment #4 From 2010-09-27 14:26:28 -------
(In reply to comment #3)
> service mysqld restart не помогло.
> После перезагрузки системы все штатно заработало.

Т.е. проблема больше не проявляется?
------- Comment #5 From 2010-09-27 14:29:52 -------
Именно так и есть.
------- Comment #6 From 2010-09-27 14:35:02 -------
ну, тогда WORKSFORME