ALT Linux Bugzilla – Full Text Bug Listing
| Summary: | MySQL не хочет работать с InnoDB | ||
|---|---|---|---|
| Product: | Sisyphus | Reporter: | Kulik Dmitriy <lnkvisitor.ts> |
| Component: | MySQL-server | Assignee: | Vitaly Kuznetsov <vitty> |
| Status: | CLOSED WORKSFORME | QA Contact: | qa-sisyphus |
| Severity: | critical | ||
| Priority: | P3 | CC: | evg, mike, nickel, rider, shaba, stalker |
| Version: | unstable | ||
| Hardware: | all | ||
| OS: | Linux | ||
|
Description
Kulik Dmitriy
2010-09-26 08:29:37 MSD
на мантейнера Расскажите пожалуйста, как воспроизвести ошибку. Я попробовал: 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 service mysqld restart не помогло. После перезагрузки системы все штатно заработало. (In reply to comment #3) > service mysqld restart не помогло. > После перезагрузки системы все штатно заработало. Т.е. проблема больше не проявляется? Именно так и есть. ну, тогда WORKSFORME |
