MySQL Forums
Forum List  »  Merge Storage Engine

Tables not merged properly.
Posted by: Nadine Song
Date: February 15, 2007 03:04PM

I have two myisam table barlog_2005 and barlog_2006.

I'm trying to create a merge table out of barlog_2005 and barlog_2006. The merge table create is successful, but I'm not able to do any operation it says 'Can't open file: 'usrmerge.MRG' (errorno: 143). By the way, both tables barlog_2005 and barlog_2006 are identical.

Any help is appreciated in advance.

mysql> desc barlog_2006;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| prefix | varchar(6) | YES | | NULL | |
| dbase | varchar(35) | YES | | NULL | |
| access_time | datetime | YES | | NULL | |
| log_id | int(10) | | PRI | 0 | |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> desc barlog_2005;
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| prefix | varchar(6) | YES | | NULL | |
| dbase | varchar(35) | YES | | NULL | |
| access_time | datetime | YES | | NULL | |
| log_id | int(10) | | PRI | 0 | |
+-------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> create table barlog_merged (prefix varchar(5), dbase varchar(35), access_time datetime, log_id int(10) PRIMARY KEY) type=merge union=(barlog_2005,barlog_2006);
Query OK, 0 rows affected (0.00 sec)

mysql> check table barlog_merged;
+--------------------+-------+----------+----------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+--------------------+-------+----------+----------------------------------------------------+
| MLAD.barlog_merged | check | error | Can't open file: 'barlog_merged.MRG'. (errno: 143) |
+--------------------+-------+----------+----------------------------------------------------+
1 row in set (0.00 sec)

mysql> select * from barlog_merged;
ERROR 1016: Can't open file: 'barlog_merged.MRG'. (errno: 143)

Options: ReplyQuote


Subject
Views
Written By
Posted
Tables not merged properly.
6846
February 15, 2007 03:04PM
5004
February 16, 2007 03:05AM
4809
February 16, 2007 09:38AM
4732
February 27, 2007 11:23AM


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.