Skip navigation links

MySQL Forums :: Merge Storage Engine :: Tables not merged properly.


Advanced Search

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. 5488 Nadine Song 02/15/2007 03:04PM
Re: Tables not merged properly. 4253 Ingo Strüwing 02/16/2007 03:05AM
Re: Tables not merged properly. 4078 Nadine Song 02/16/2007 09:38AM
Re: Tables not merged properly. 4165 Nadine Song 02/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.