Re: To exist, or not to exist ...

I had a similar or the same problem some time ago. Try to go to the data directory of the MySQL server (datadir parameter for mysqld), then cd to MSG (the name of your database). Then look if you have any files named 'q_network_cold.*' (such as q_network_cold.frm). If you have such files then removing them should fix the problem.

Anatoly.
> Hi !
>
> I am trying to solve a problem on our Cluster environment (MySQL
> 5.1.17 with NDB DD databases)
>
> mysql> show tables;
> +---------------------------+
> | Tables_in_MSG |
> +---------------------------+
> | q_client |
> | q_client_cold |
> | q_client_drippersettings |
> | q_network |
> | q_network_cold_new |
> | q_network_drippersettings |
> \+---------------------------+
>
> mysql> create table q_network_cold (qnc_id int not null);
> ERROR 1050 (42S01): Table 'q_network_cold' already exists
> mysql>
>
> This is a table that previously did exist .. but was dropped.
>
> I have restarted the whole cluster + API node's just to be sure.
>
> Is there some table I can alter by hand to tell MySQL the table
> doesn't exist anymore?
>
> bye,
> Chri
>
>

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com