*************************** 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]
