Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.2.14, 5.3.12, 5.5.33a
-
None
-
Centos OS 5.6
Description
Restoring a dump for a SphinxSE failed with error message
822 – Dumping data for table `iv3article`
9823 –
9824
9825 LOCK TABLES `iv3article` WRITE;
9826 /*!40000 ALTER TABLE `iv3article` DISABLE KEYS */;
9827 /*!40000 ALTER TABLE `iv3article` ENABLE KEYS */;
9828 UNLOCK TABLES;
9829
9830
ERROR 1661 (HY000) at line 9825: Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involve
|
in ha_sphinx.cc
|
|
|
|
|
#if MYSQL_VERSION_ID<50100
|
handlerton sphinx_hton =
|
{
|
#ifdef MYSQL_HANDLERTON_INTERFACE_VERSION
|
MYSQL_HANDLERTON_INTERFACE_VERSION,
|
#endif
|
sphinx_hton_name,
|
SHOW_OPTION_YES,
|
sphinx_hton_comment,
|
DB_TYPE_SPHINX_DB,
|
sphinx_init_func_for_handlerton,
|
0, // slot
|
0, // savepoint size
|
sphinx_close_connection, // close_connection
|
NULL, // savepoint
|
NULL, // rollback to savepoint
|
NULL, // release savepoint
|
NULL, // commit
|
NULL, // rollback
|
NULL, // prepare
|
NULL, // recover
|
NULL, // commit_by_xid
|
NULL, // rollback_by_xid
|
NULL, // create_cursor_read_view
|
NULL, // set_cursor_read_view
|
NULL, // close_cursor_read_view
|
HTON_CAN_RECREATE
|
};
|
#else
|
static handlerton * sphinx_hton_ptr = NULL;
|
#endif
|
|
|
|
-- --------------------------------------------------------
|
-- Host: alpinix5.sdv.fr
|
-- Server version: 5.2.8-MariaDB-log - (MariaDB - http://mariadb.com/)
|
-- Server OS: Linux
|
-- HeidiSQL version: 7.0.0.4053
|
-- Date/time: 2013-11-08 10:15:30
|
-- --------------------------------------------------------
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
/*!40101 SET NAMES utf8 */;
|
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;
|
|
|
-- Dumping structure for table iv3.iv3article_rt
|
DROP TABLE IF EXISTS `iv3article_rt`;
|
CREATE TABLE IF NOT EXISTS `iv3article_rt` (
|
`id` int(10) unsigned NOT NULL,
|
`weight` int(11) NOT NULL,
|
`query` blob NOT NULL,
|
`group_id` int(11) DEFAULT NULL,
|
KEY `query` (`query`(3072))
|
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://alpinix6.sdv.fr:8101/rtIv3Article';
|
|
|
-- Data exporting was unselected.
|
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
|
|
|
Engine Support Comment Transactions XA Savepoints
|
SPHINX YES Sphinx storage engine 0.9.9 NO NO NO
|
Attachments
Issue Links
- relates to
-
-
- Closed
-