MySQL Forums
Forum List  »  Merge Storage Engine

not able to create merge table properly
Posted by: Ilavajuthy Palanisamy
Date: January 24, 2006 04:58PM

Hi,

I have two myisam table usr1 and usr2.

I'm trying to create a merge table out of usr1 and usr2. 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).

Any help will be greatly appreciated.





mysql> create table usrmerge (

-> ID BIGINT NOT NULL,

-> AUTHROLE VARCHAR(32),

-> AUTHSERVERIPADDRESS VARCHAR(15),

-> AUTHTYPE INTEGER,

-> COMPUTERNAME VARCHAR(32),

-> ENTRYSTATUS INTEGER,

-> IPADDRESS VARCHAR(15),

-> AUTHSTATE INTEGER,

-> LOGINTIME BIGINT,

-> LOGOUTTIME BIGINT,

-> MACADDRESS VARCHAR(17),

-> NAME VARCHAR(32),

-> NETWORKACCESSPOINT VARCHAR(32),

-> TIDALDEVICEIPADDRESS VARCHAR(15),

-> TIDALDEVICEPHYSICALPORT INTEGER,

-> DEVICESPECIFICID BIGINT,

-> TIDALDEVICEPHYSICALSLOT INTEGER,

-> VLANID INTEGER,

-> TIDALDEVICEID BIGINT)

-> engine=merge union(usr1, usr2);

Query OK, 0 rows affected (0.02 sec)



mysql> desc usrmerge;

ERROR 1016 (HY000): Can't open file: 'usrmerge.MRG' (errno: 143)

mysql> show table status like 'usr%';

+----------+--------+---------+------------+------+----------------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+------------+-
------------------+----------+----------------+-----------

-----------------------------------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Au

to_increment | Create_time | Update_time | Check_time |
Collation | Checksum | Create_options | Comment

|

+----------+--------+---------+------------+------+----------------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+------------+-
------------------+----------+----------------+-----------

-----------------------------------+

| usr | InnoDB | 9 | Dynamic | 494 | 331 |
163840 | NULL | 16384 | 0 |

NULL | 2006-01-03 11:29:23 | NULL | NULL |
latin1_swedish_ci | NULL | | InnoDB fre

e: 2247680 kB |

| usr1 | MyISAM | 9 | Dynamic | 620 | 144 |
89280 | 4294967295 | 1024 | 0 |

NULL | 2006-01-24 13:55:41 | 2006-01-24 13:55:42 | NULL |
latin1_swedish_ci | NULL | |

|

| usr2 | MyISAM | 9 | Dynamic | 620 | 144 |
89280 | 4294967295 | 1024 | 0 |

NULL | 2006-01-24 13:55:57 | 2006-01-24 13:55:57 | NULL |
latin1_swedish_ci | NULL | |

|

| usrmerge | NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL |

NULL | NULL | NULL | NULL |
NULL | NULL | NULL | Can't open

file: 'usrmerge.MRG' (errno: 143) |

+----------+--------+---------+------------+------+----------------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+------------+-
------------------+----------+----------------+-----------

-----------------------------------+

4 rows in set (0.00 sec)



Ila.

Options: ReplyQuote


Subject
Views
Written By
Posted
not able to create merge table properly
6736
January 24, 2006 04:58PM


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.