Table 'xxx' doesn't exist
Posted by: Juergen Gnoss
Date: April 07, 2013 02:05AM

strange thing happens.

have a look:

login onto console

database and table new created

then
==================================================================
mysql> insert into `miguel.errortext` (`name`) values ('machine stopped');
Query OK, 1 row affected (0.03 sec)

mysql> select * from `miguel.errortext`
-> ;
+----+-----------------+
| id | name |
+----+-----------------+
| 1 | machine stopped |
| 2 | machine error 0 |
| 3 | machine error 1 |
| 4 | machine error 2 |
| 5 | machine error 3 |
| 6 | machine error 4 |
| 7 | machine error 5 |
| 8 | machine error 6 |
| 9 | machine error 7 |
| 10 | machine error 8 |
| 11 | machine error 9 |
+----+-----------------+
11 rows in set (0.00 sec)

mysql> SELECT * FROM miguel.errortext;
ERROR 1146 (42S02): Table 'miguel.errortext' doesn't exist

mysql> show tables;
+------------------+
| Tables_in_miguel |
+------------------+
| miguel.errorlog |
| miguel.errortext |
| miguel.operators |
+------------------+
3 rows in set (0.00 sec)

===============================================================

after the first insert I run a simple c-programm
it has a select on that table

shows:

07.03.2013 02:13:17, mysql connected
SELECT * FROM miguel.errortext
rows found : 1

and it inserts the 10 records

the first select on console

select * from `miguel.errortext`

shows the correct result:

after that I run the c program again and it failed

07.03.2013 02:13:19, mysql connected
07.03.2013 02:13:19, error in SELECT * FROM miguel.errortext

running a select again on the console and surprise:

ERROR 1146 (42S02): Table 'miguel.errortext' doesn't exist

but tables are there.
what's happening there?

I searched the forum and internet for that problem.
mostly that seems to happen after some table copy, dump or so,
but that's not in my case.
I work on a ubuntu box

mysql -?
mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (x86_64) using readline 6.2
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

snip

Variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
auto-rehash TRUE
auto-vertical-output FALSE
character-sets-dir (No default value)
column-type-info FALSE
comments FALSE
compress FALSE
debug-check FALSE
debug-info FALSE
database (No default value)
default-character-set auto
delimiter ;
enable-cleartext-plugin FALSE
vertical FALSE
force FALSE
named-commands FALSE
ignore-spaces FALSE
init-command (No default value)
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
sigint-ignore FALSE
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket /var/run/mysqld/mysqld.sock
ssl FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-verify-server-cert FALSE
table FALSE
user (No default value)
safe-updates FALSE
i-am-a-dummy FALSE
connect-timeout 0
max-allowed-packet 16777216
net-buffer-length 16384
select-limit 1000
max-join-size 1000000
secure-auth FALSE
show-warnings FALSE
plugin-dir (No default value)
default-auth (No default value)

Options: ReplyQuote


Subject
Views
Written By
Posted
Table 'xxx' doesn't exist
7312
April 07, 2013 02:05AM


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.