RE: reproducible error 17 - Guilhem Bichot - com.mysql.lists.bugs

8 messages in com.mysql.lists.bugsRE: reproducible error 17

From	Sent On	Attachments
Dathan Vance Pattishall	24 Oct 2003 11:26
Dathan Vance Pattishall	24 Oct 2003 12:20
Guilhem Bichot	27 Oct 2003 10:54
Dathan Vance Pattishall	27 Oct 2003 13:01
Guilhem Bichot	27 Oct 2003 15:14
Guilhem Bichot	28 Oct 2003 03:07
Guilhem Bichot	28 Oct 2003 03:31
Dathan Vance Pattishall	28 Oct 2003 15:50

Subject:	RE: reproducible error 17
From:	Guilhem Bichot (guil...@mysql.com)
Date:	10/27/2003 10:54:56 AM
List:	com.mysql.lists.bugs

Hi,

*************************** 1. row *************************** Master_Host: 10.2.12.224 Master_User: rep Master_Port: 3306 Connect_retry: 60 Master_Log_File: ef224-bin.020 Read_Master_Log_Pos: 409223612 Relay_Log_File: ef242-relay-bin.016 Relay_Log_Pos: 330063332 Relay_Master_Log_File: ef224-bin.020 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: Replicate_ignore_db: Last_errno: 25 Last_error: Error 'Can't create symlink './ff_recent/#sql-17f7_c.MYI' pointing at '/var/lib/mysql/ff_recent/#sql-17f7_c.MYI' (Error 17)' on query 'ALTER TABLE recentmembers_20 add have_children tinyint unsigned not NULL default 0'. Default database: 'ff_recent' Skip_counter: 0 Exec_master_log_pos: 348632736 Relay_log_space: 390689457

Are the master and slave located on two different machines, or on one single machine? Are you using symlinks to place tables or databases at other locations than the datadir? If yes: * How did you do it (with manual Unix 'ln -s', with CREATE TABLE ... DATA DIRECTORY= INDEX DIRECTORY=, another way?). * Did you do it the same way on master and slave?

Do master and slave have the same tree structure (i.e. do the directories ./ff_recent/ and /var/lib/mysql/ff_recent all exist on the 2 machines?).

If you could provide a simple complete testcase like: "create a symlinked table on the master by following these steps, then do this ALTER, then do that ALTER", this could surely help us.

Thank you.