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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: