Hello MySQL 4.0.1 Solaris 2.7 official binary reproducibly crashes with sig 11 when run in a slave mode and when its master (4.0.1 official Linux binary) is populated via "mysqlimport" tool from a remote machine.
Here are some interesting log files [edited]: ,---- $ mysqld --user=mysql | 020612 11:44:04 Slave: connected to master 'foo@bar:3306', replication started in |log 'foo-bin.004' at position 276991 | mysqld got signal 11; | This could be because you hit a bug. It is also possible that this binary [...] `---- No stack is dumped. The crash is reproducible. The OS trace says: ,---- $ truss mysqld --user=mysql | close(14) = 0 | Incurred fault #6, FLTBOUNDS %pc = 0x00106564 | siginfo: SIGSEGV SEGV_MAPERR addr=0x00000200 | Received signal #11, SIGSEGV [caught] | siginfo: SIGSEGV SEGV_MAPERR addr=0x00000200 | sysconfig(_CONFIG_SIGRT_MIN) = 38 | sigprocmask(SIG_SETMASK, 0xFF33D9A8, 0x00000000) = 0 | sigaction(SIGSEGV, 0xFE780EB8, 0x00000000) = 0 | mysqld got signal write(2, " m y s q l d g o t s".., 18) = 18 `---- The slave bin log says: ,---- $ mysqlbinlog data/baz-bin.004 | #020612 2:56:21 server id 456 Query thread_id=1 exec_time=29835 error_code=0 | use a; | SET TIMESTAMP=1023843381; | DELETE FROM a; | # at 268641 | LOAD DATA INFILE '/var/tmp/SQL_LOAD-123-456-1.data' REPLACE INTO TABLE a FIELDS |TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' |LINES STARTING BY '' (a,b,c,d,e,f,g,h); | file_id=1, block_len=8191 `---- The manual says that all forms of LOAD DATA INFILE should be properly replicated in MySQL 4.0. There might be a problem with remote mysqlimport, then. It was started on a remove machine with the "-h" option, but without the "-L" option. (Note that slave works perfectly fine after "replicate-ignore-db=a", as I do not need "a" to be replicated. I just wanted to let you know of the problem...) Tibor --------------------------------------------------------------------- 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