not able to create merge table properly
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.