>Description:
We have a master server which replicates to a slave. Both
are Solaris 2.7 machines running mysql-3.23.33 (Official MySQL binary).
The appropriate Master's my.cnf file looks like this:
server-id=221
binlog-do-db=Shopping
and the slave's looks like this:
server-id=200
master-host=autonomy.widearea.co.uk
master-user=<snip>
master-password=<snip>
replicate-do-db=Shopping
On the master, we run a set of updates which look like this:
USE Shopping ;
TRUNCATE TABLE WatfordProductTable ;
LOAD DATA INFILE
'/usr/local/src/dennis/sql/shopping/watfordelectronics/watford.tbd.new'
INTO TABLE WatfordProductTable
FIELDS
OPTIONALLY ENCLOSED BY '"'
(Quicklinx, Description, Inc_VAT, Manufacturer, Man_Code, URL) ;
The file is not deleted from the master. On the master we get messages in the
error log of the form:
010227 8:22:34 failed in send_file() : Failed reading file name
and on the slave we see:
010227 08:19:04 mysqld restarted
/opt/local/mysql-3.23.33-sun-solaris2.7-sparc/bin/mysqld: ready for connections
010227 8:19:04 Slave: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'autonomy-bin.001' at position 0
010227 8:20:29 Slave: load data infile at position 0 in log 'mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Also, on the slave the table gets bigger and bigger each time the server restarts.
This does not affect another similar query that looks like this:
USE Shopping ;
TRUNCATE TABLE DabsProductTable ;
LOAD DATA INFILE '/usr/local/src/dennis/sql/shopping/dabs/dabs.csv.new'
INTO TABLE DabsProductTable
FIELDS
TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
(QuickLinx, Man_Code, Manufacturer, Description, ProdGroup, Inc_VAT,
URL);
SELECT 'Record count: ', COUNT(*) FROM DabsProductTable ;
We have tried fetching a new table copy and dumping it.
>How-To-Repeat:
Doing the above.
>Fix:
We are going to try excluding the table from replication but that is not a fix.
>Submitter-Id: <submitter ID>
>Originator: Login name: shb
>Organization:
Wide Area Communications Ltd
>MySQL support: none
>Synopsis: Replication breaks a slave with LOAD DATA INFILE
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.33 (Official MySQL binary)
>Environment:
System: SunOS autonomy 5.7 Generic_106541-12 sun4u sparc SUNW,Ultra-4
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/local/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3
-felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1732880 Dec 26 06:04 /lib/libc.a
lrwxrwxrwx 1 root root 11 May 15 2000 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1147500 Dec 26 06:04 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1732880 Dec 26 06:04 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 May 15 2000 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1147500 Dec 26 06:04 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
