ERROR 1168 when adding a table
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>