Bug #14399 LOAD DATA FROM MASTER fails
| Submitted: | 27 Oct 2005 15:56 | Modified: | 30 Aug 2006 18:29 |
|---|---|---|---|
| Reporter: | Christian Meisinger | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: Replication | Severity: | S2 (Serious) |
| Version: | 5.0.15/5.0.16 BK source | OS: | Linux (linux suse 9.3) |
| Assigned to: | Andrei Elkin | CPU Architecture: | Any |
[27 Oct 2005 15:56]
Christian Meisinger
[29 Oct 2005 1:00]
MySQL Verification Team
051028 22:51:55 [Note] Slave I/O thread: connected to master 'userslave@localhost:3306', replication started in log 'hegel-bin.000003' at position 179 051028 22:51:55 [Note] next log './hegel-relay-bin.000002' is currently active 051028 22:55:26 [ERROR] Key 1 - Found wrong stored record at 0 051028 22:55:26 [Note] Retrying repair of: './test/blabla' with keycache 051028 22:55:26 [ERROR] Key 1 - Found wrong stored record at 0
[30 Aug 2006 18:29]
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. Due to the deprecated status of the statements, this bug will not be fixed. For 5.1 and earlier, the recommended alternative solution to usign 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. A deprecation warning will be added for these statements in 4.1, 5.0 and 5.1 shortly.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 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.