Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
5.5.37
-
None
-
None
-
debian squeeze
Description
CREATE TABLE `sphinx_auctions_2` (
|
`id` bigint(20) unsigned NOT NULL DEFAULT '0',
|
`weight` int(11) NOT NULL,
|
`query` varchar(100) NOT NULL,
|
`title` varchar(75) NOT NULL,
|
PRIMARY KEY (`id`)
|
) ENGINE=SPHINX DEFAULT CHARSET=latin1 CONNECTION='sphinxql://192.168.179.103:9312/idx_oa_auctions'
|
sphinx-2.1.7 configuration /etc/sphinx/sphinxse
index idx_oa_auctions
|
{
|
type = rt
|
|
|
path = /var/lib/sphinxsearch/data/mf_auctions
|
morphology = stem_en, soundex
|
|
|
dict = keywords
|
|
|
# should relate to index size
|
# http://sphinxsearch.com/docs/2.1.7/rt-caveats.html
|
|
|
# RAM chunk size limit
|
# RT index will keep at most this much data in RAM, then flush to disk
|
# optional, default is 32M
|
#
|
# rt_mem_limit = 512M
|
|
|
rt_field = title
|
}
|
MariaDB [opalauctions_com]> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;
|
ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.
|
MariaDB [opalauctions_com]> SELECT @@binlog_format;
|
+-----------------+
|
| @@binlog_format |
|
+-----------------+
|
| MIXED |
|
+-----------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [opalauctions_com]> set binlog_format = 'ROW';
|
Query OK, 0 rows affected (0.00 sec)
|
|
> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;
|
ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.
|
> set binlog_format = 'STATEMENT';
|
Query OK, 0 rows affected (0.00 sec)
|
|
> UPDATE sphinx_auctions_2 SET title='bananas' WHERE id=3;
|
ERROR 1661 (HY000): Cannot execute statement: impossible to write to binary log since both row-incapable engines and statement-incapable engines are involved.
|
Attachments
Issue Links
- relates to
-
-
- Closed
-