RE: reproducible error 17

*************************** 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:dathan@xxxxxxxxxxxxxxxxxxx]
-->Sent: Friday, October 24, 2003 11:27 AM
-->To: mysql@xxxxxxxxxxxxxxx
-->Cc: bugs@xxxxxxxxxxxxxxx
-->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 Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/bugs?unsub=gcdmb-bugs@xxxxxxxxxxx