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

sphinxse UPDATEs to rt indexes are incompatible with BINLOG settings

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 5.5.37
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      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

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.