*************************** 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
- Dathan Vance Pattishall - Sr. Programmer and mySQL DBA for FriendFinder Inc. - http://friendfinder.com/go/p40688 -->-----Original Message----- -->From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] -->Sent: Friday, October 24, 2003 11:27 AM -->To: [EMAIL PROTECTED] -->Cc: [EMAIL PROTECTED] -->Subject: reproducible error 17 --> -->Error 'Can't create symlink './ffadult_recent/#sql-44b_e87.MYI' pointing -->at '/var/lib/mysql/ff_recent/#sql-44b_e87.MYI' (Error 17)' on query -->'ALTER TABLE recentmembers_8 add have_children tinyint unsigned not NULL -->default 0'. Default database: 'ff_recent' | 0 | 346296822 -->| 369493795 --> --> -->Perror says -->Error code 17: File exists --> -->I have 2 alters submitted on the master in sequential order. On the -->slave it executes in the same order but produces error 17. Somehow the -->tempfile already exists, but when I go to the datadir this temp file is -->not displayed in the directory. --> -->Performing a slave stop slave start does not work. -->Restarting the mysql server on the slave is the only method I found to -->recover from the error. --> --> -->Version of mySQL: 4.0.15 -->Kernel: Linux ef242.friendfinderinc.com 2.4.18-4smp #1 SMP Sun Apr 14 -->13:50:35 PDT 2002 i686 unknown -->*PATCHED* --> --> -->- Dathan Vance Pattishall --> - Sr. Programmer and mySQL DBA for FriendFinder Inc. --> - http://friendfinder.com/go/p40688 --> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]