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.