Bug #16578 load table from master need better err msg whe not supported

• Submitted: 17 Jan 2006 19:02
• Modified: 31 Aug 2006 19:00
• Reporter: Jonathan Miller
• Status: Won't fix
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.6-alpha
• OS: Linux (Linux)
• CPU Architecture: Any

[17 Jan 2006 19:02] Jonathan Miller

Description:
rpl000004                      [ fail ]

Errors are (from /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 10: query 'load table t1 from master' failed: 1189: Net error reading from master
(the last lines may be the most important ones)

Slave Error:
060117 21:55:28 [ERROR] create_table_from_dump: failed in handler::net_read_dump()

rpl000006                      [ fail ]

Errors are (from /home/ndbdev/jmiller/clones/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: In included file "./extra/rpl_tests/rpl000006.test": At line 12: query 'load table t1 from master' failed: 1189: Net error reading from master
(the last lines may be the most important ones)

Slave Error:
060117 21:57:29 [ERROR] create_table_from_dump: failed in handler::net_read_dump()

How to repeat:
./mysql-test-run  --mysqld=--binlog-format=row  --with-ndbcluster-all --mysqld=--default-storage-engine=ndb --force --with-ndbcluster-slave --do-test=rpl000004 --ndb-extra-test

/mysql-test-run  --mysqld=--binlog-format=row  --with-ndbcluster-all --mysqld=--default-storage-engine=ndb --force --with-ndbcluster-slave --do-test=rpl000006 --ndb-extra-test

[6 Feb 2006 13:57] Tomas Ulin

load table from master is only supported for myisam, maybe better error message should be implemented in the server when trying to load a non myisam table

[18 Apr 2006 6:47] Jon Stephens

Already documented in Cluster Limitations.

[18 Apr 2006 10:46] Jonathan Miller

A better error message is needed for this issue.

[31 Aug 2006 19:00] Trudy Pelzer

Since the current implementation of LOAD DATA FROM MASTER
and LOAD TABLE FROM MASTER is very limited, these statements
are deprecated in versions 4.1, 5.0 and 5.1 of MySQL. We will
introduce a more advanced technique (online backup) in a 
future (>5.1) version, that will have the added advantage of
working with more storage engines.

For 5.1 and earlier, the recommended alternative solution to
using LOAD DATA|TABLE FROM MASTER is mysqldump on the master 
piped (or output copied) to the mysql client on the slave. 
This also has the advantage of working for all storage engines.
Another alternative is mysqlhotcopy, which is faster because
it does a binary copy, but works only for MyISAM tables.

A deprecation warning has been added for these statements in
4.1, 5.0 and 5.1.