MERGE tables error
I've created several merge tables from the command prompt. All seems well, the .frm and .MRG files are created. The contents of the .MRG files are accurate. I flushed the tables (even restarted MySQL). I can see the newly created merge tables, but when I try to run a DESCRIBE or a SELECT COUNT(*) to verify the records counts, I get the following error message: ERROR 1016: Can't open file: 'new_master.MRG'. (errno: 143) All table structures are identical. Am I missing a basic error numbers page in the online docs? I've found a few, but nothing comprehensive, like a page where I can enter an error number and find the detailed message, probable cause, recommdned action, etc. The only thing that I have been able to find is: http://www.mysql.com/doc/en/Error-returns.html which essentially confirms that an error 1016 is a problem opening a file. I am using MySQL version 3.23.56-nt on Windows2000. Any help, links or guidance would be greatly appreciated. /Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MERGE tables error
Error 143 suggests that you have conflicting table definitions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 24, 2003 7:08 AM To: [EMAIL PROTECTED] Subject: MERGE tables error I've created several merge tables from the command prompt. All seems well, the .frm and .MRG files are created. The contents of the .MRG files are accurate. I flushed the tables (even restarted MySQL). I can see the newly created merge tables, but when I try to run a DESCRIBE or a SELECT COUNT(*) to verify the records counts, I get the following error message: ERROR 1016: Can't open file: 'new_master.MRG'. (errno: 143) All table structures are identical. Am I missing a basic error numbers page in the online docs? I've found a few, but nothing comprehensive, like a page where I can enter an error number and find the detailed message, probable cause, recommdned action, etc. The only thing that I have been able to find is: http://www.mysql.com/doc/en/Error-returns.html which essentially confirms that an error 1016 is a problem opening a file. I am using MySQL version 3.23.56-nt on Windows2000. Any help, links or guidance would be greatly appreciated. /Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MERGE tables error
* [EMAIL PROTECTED] [...] ERROR 1016: Can't open file: 'new_master.MRG'. (errno: 143) All table structures are identical. Maybe not..? :) Am I missing a basic error numbers page in the online docs? I've found a few, but nothing comprehensive, like a page where I can enter an error number and find the detailed message, probable cause, recommdned action, etc. The only thing that I have been able to find is: http://www.mysql.com/doc/en/Error-returns.html which essentially confirms that an error 1016 is a problem opening a file. I am using MySQL version 3.23.56-nt on Windows2000. Run the perror utility, located in the mysql\bin directory: C:\mysql\binperror 143 Error code 143: Unknown error 143 = Conflicting table definition between MERGE and mapped table -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
