Bug #18869 federated storage engine: error message missing
Description:
The federated engine may deadlock, if creating a federated table which references an open table on the same server. In that case, it currently gives an error which is evidently missing some part of the text. The error says:
ERROR 1434 (HY000): Can't create federated table. Foreign data src error: error: 1159 ''
Note the empty string in "error: 1159 ''".
How to repeat:
drop table if exists test, test1;
create table test(i int not null , j int not null, c varchar(30), primary key (i,j)) engine = myisam;
-- The following command causes a deadlock, which is OK.
-- But the error message is not OK.
create table test1(i int not null , j int not null, c varchar(30), primary key (i,j)) engine = federated connection='mysql://tim@127.0.0.1:33000/test/test';
mysql> drop table if exists test, test1;
Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> create table test(i int not null , j int not null, c varchar(30), primary key (i,j)) engine = myisam;
Query OK, 0 rows affected (0.00 sec)
mysql> create table test1(i int not null , j int not null, c varchar(30), primary key (i,j)) engine = federated connection='mysql://tim@127.0.0.1:33000/test/test';
*** NOTE: It pauses here for ~30 seconds before the error shows up. ***
ERROR 1434 (HY000): Can't create federated table. Foreign data src error: error: 1159 ''
mysql> show variables like 'version%';
+-------------------------+---------------------------------------------------+
| Variable_name | Value |
+-------------------------+---------------------------------------------------+
| version | 5.1.9-beta-debug-log |
| version_comment | Latest delta: 2006/04/06 1.2298 svoj@april.(none) |
| version_compile_machine | i386 |
| version_compile_os | unknown-freebsd6.1 |
+-------------------------+---------------------------------------------------+
4 rows in set (0.00 sec)
Note the empty string in "error: 1159 ''".
Suggested fix:
Perhaps a printf doesn't have enough arguments?
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.