Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL)
-
None
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
- relates to
-
MDEV-10179 connect.tbl fails sporadically in buildbot with result mismatch
- Closed
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.