Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5259

Can not restore SphinxSE table using binlog_format row or mixed

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.2.14, 5.3.12, 5.5.33a
    • Fix Version/s: 10.0.4
    • Component/s: None
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: