MySQL Forums
Forum List  »  Merge Storage Engine

ERROR 1168 when adding a table
Posted by: Ricky Smart
Date: June 01, 2009 01:26PM

I have 8 tables sized between 10-30GB and with around 0.5*10^9 rows. I am trying to search all of themvia a merge table. When I go up to 7 tables things are fine but when I add the eighth I get a ERROR 1168. The total number of rows is around 4.5*10^9 for all 8 tables.

Below is an example of what happens if I merge with DBS2, then DBS3, then both, I show just the error from count but it is the same error for all commands:

mysql> alter table DB2 union=(DBN0,DBN1,DBN2,DBN3,DBS0,DBS1,DBS2) ; select count(*) from DB2 ;
Query OK, 0 rows affected (0.32 sec)
Records: 0 Duplicates: 0 Warnings: 0

+------------+
| count(*) |
+------------+
| 3747089710 |
+------------+
1 row in set (0.00 sec)

mysql> alter table DB2 union=(DBN0,DBN1,DBN2,DBN3,DBS0,DBS1,DBS3) ; select count(*) from DB2 ;
Query OK, 0 rows affected (0.22 sec)
Records: 0 Duplicates: 0 Warnings: 0

+------------+
| count(*) |
+------------+
| 3520529145 |
+------------+
1 row in set (0.00 sec)

mysql> alter table DB2 union=(DBN0,DBN1,DBN2,DBN3,DBS0,DBS1,DBS2,DBS3) ; select count(*) from DB2 ;
Query OK, 0 rows affected (0.23 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
mysql>

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1168 when adding a table
14651
June 01, 2009 01:26PM
5688
June 02, 2009 12:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.