-->-----Original Message----- -->From: Guilhem Bichot [mailto:[EMAIL PROTECTED] -->Sent: Monday, October 27, 2003 10:55 AM -->To: [EMAIL PROTECTED] -->Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] -->Subject: RE: reproducible error 17 --> -->Hi, --> -->Are the master and slave located on two different machines, or on one -->single machine?
The master and slave are located on 2 different machines. -->Are you using symlinks to place tables or databases at other locations -->than the datadir? Yes, in the db directory under the datadir. I have tables which are one name symlinked to the tables which where altered. These fake tables or tables which are synonyms to the src tables did not have any actions performed on them at this moment in time. For example recent_members.frm -> /var/lib/mysql/ffadult_recent/recentmembers.frm recent_members.MYI -> /var/lib/mysql/ffadult_recent/recentmembers.MYI recent_members.MYD -> /var/lib/mysql/ffadult_recent/recentmembers.MYD The tables altered where recentmembers(_*) -->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? Used ln -s --> -->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?). Yes --> -->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. --> I wish I could but all my servers (> 56) are in production. I will try late at night, so our users are not affected. Anything for the mysql team, thanks for your hard work. --> -->-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]