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

connect.tbl_thread fails sporadically, error in your SQL syntax

Details

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/10781/steps/test_3/logs/stdio

      connect.tbl_thread                       w1 [ fail ]
              Test ended at 2017-10-29 23:45:52
       
      CURRENT_TEST: connect.tbl_thread
      mysqltest: At line 89: query 'SELECT * FROM total order by v desc' failed: 1296: Got error 174 '(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ЏѴ' at line 1 [ЏѴ]' from CONNECT
       
      The result from queries just before the failure was:
      < snip >
      connection master;
      DROP TABLE rt2;
      connection slave;
      DROP TABLE rt3,rt4,rt5;
      connection default;
      DROP TABLE t1,t2,t3,t4,t5,total;
      #
      # Old thread TBL tables test modified
      #
      CREATE TABLE t1 ENGINE=CONNECT TABLE_TYPE=MYSQL SRCDEF='select 11 as v' OPTION_LIST='port=MASTER_PORT';
      SELECT * FROM t1;
      v
      11
      CREATE TABLE t2 ENGINE=CONNECT TABLE_TYPE=MYSQL SRCDEF='select 22 as v' OPTION_LIST='port=SLAVE_PORT';
      SELECT * FROM t2;
      v
      22
      CREATE TABLE total (v BIGINT(20) UNSIGNED NOT NULL) ENGINE=CONNECT TABLE_TYPE=TBL TABLE_LIST='t1,t2' OPTION_LIST='thread=yes,port=PORT';;
      set connect_xtrace=1;
      SELECT * FROM total order by v desc;
       
      More results from queries before failure can be found in /mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/tbl_thread.log
       
      Warnings from just before the error:
      Error 1296 Got error 174 '(1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ЏѴ' at line 1 [ЏѴ]' from CONNECT
       
       - saving '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/1/log/connect.tbl_thread/' to '/mnt/buildbot/build/mariadb-10.2.10/mysql-test/var/log/connect.tbl_thread/
      

      Attachments

        Issue Links

          Activity

            This THREAD option of the TBL table type was struck by multiple bugs, wrong results, syntax error, memory problems... all this happening only sporadically that made debugging them a real nightmare.
            On another hand, its only use was to try having better performances when using the TBL type for sharding, tables belonging to different remote servers.
            However, since CONNECT does support table partitioning on table names, this can be advantageously replaced by using partitioning.
            Therefore, this pseudo "fix" is actually made by removing the THREAD option that is no more supported by CONNECT.

            bertrandop Olivier Bertrand added a comment - This THREAD option of the TBL table type was struck by multiple bugs, wrong results, syntax error, memory problems... all this happening only sporadically that made debugging them a real nightmare. On another hand, its only use was to try having better performances when using the TBL type for sharding, tables belonging to different remote servers. However, since CONNECT does support table partitioning on table names, this can be advantageously replaced by using partitioning. Therefore, this pseudo "fix" is actually made by removing the THREAD option that is no more supported by CONNECT.

            People

              bertrandop Olivier Bertrand
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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