0000484: SphinxSE throws error on ALTER TABLE ... DISABLE KEYS when binary loggin is disabled

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000484

Sphinx

sphinxse

public

2010-03-02 23:36

2012-10-31 08:05

Reporter

crishoj

Assigned To

kevg

Priority

normal

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

0.9.9-rc2

Target Version

Fixed in Version

Summary

0000484: SphinxSE throws error on ALTER TABLE ... DISABLE KEYS when binary loggin is disabled

Description

I have disabled the binary log on my box with "log_bin = OFF" in my.cnf.

This causes trouble when doing a restore of a database dump. The statements which trigger the error follow:

mysql> /*!40000 ALTER TABLE `itemsI` DISABLE KEYS */;
ERROR 1598 (HY000): Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based nor statement-based format

mysql> /*!40000 ALTER TABLE `itemsI` ENABLE KEYS */;
ERROR 1598 (HY000): Binary logging not possible. Message: Statement cannot be logged to the binary log in row-based nor statement-based format

Note that itemsI is a Sphinx table.

Also note that these statements do not cause trouble with other table types, e.g. InnoDB:

mysql> /*!40000 ALTER TABLE `items` DISABLE KEYS */;
Query OK, 0 rows affected, 1 warning (0.06 sec)

mysql> /*!40000 ALTER TABLE `items` ENABLE KEYS */;
Query OK, 0 rows affected, 1 warning (0.04 sec)

Tags

No tags attached.

Attached Files

Relationships

Notes
(0002630) patcannonsc (reporter) 2012-03-01 18:26	Same issue, 0.9.9 with MySQL 5.1.48. Can work around with turning the binlog off for just the restore session by sending 'set sql_log_bin=0;' at beginning of restore, 'set sql_log_bin=1;' when you're done.

(0003434) kevg (manager) 2012-10-31 08:05	ALTER TABLE ... DISABLE KEYS doesn't work with Sphinx.

Issue History
Date Modified	Username	Field	Change
2010-03-02 23:36	crishoj	New Issue
2010-06-01 11:52	Tomat	Issue Monitored: Tomat
2012-03-01 17:58	patcannonsc	Issue Monitored: patcannonsc
2012-03-01 18:26	patcannonsc	Note Added: 0002630
2012-10-31 08:05	kevg	Note Added: 0003434
2012-10-31 08:05	kevg	Status	new => closed
2012-10-31 08:05	kevg	Assigned To	=> kevg
2012-10-31 08:05	kevg	Resolution	open => no change required