Velocity Reviews

Velocity Reviews (http://www.velocityreviews.com/forums/index.php)
-   Python (http://www.velocityreviews.com/forums/f43-python.html)
-   -   MySQL - "create table" creates malfunctioning tables (http://www.velocityreviews.com/forums/t956924-mysql-create-table-creates-malfunctioning-tables.html)

F.R. 01-25-2013 06:55 AM

MySQL - "create table" creates malfunctioning tables
 
The other day, for unfathomable reasons, I lost control over tables
which I create. There was no concurrent change of anything on the
machine, such as an update. So I have no suspect. Does the following
action log suggest any recommendation to experienced SQL programmers?


1. A table:

mysql> select * from expenses;
+----+------------+-------+----------+--------+-------------+-------+
| id | date | place | stuff | amount | category | flags |
+----+------------+-------+----------+--------+-------------+-------+
| 38 | 2013-01-15 | ATT | Sim card | 25.00 | Visa credit | |
+----+------------+-------+----------+--------+-------------+-------+
1 row in set (0.00 sec)

2. I want to delete everything:

mysql> delete from expenses;

3. Nothing happens for about one minute. Then this:

ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
mysql>

4. I want to delete the table:

mysql> drop table expenses;

5. Nothing happens indefinitely. I have to hit Ctrl-C

^CCtrl-C -- sending "KILL QUERY 167" to server ...
Ctrl-C -- query aborted.
ERROR 1317 (70100): Query execution was interrupted
mysql>

6. I expect to find "expenses.frm", "expenses.MYD" and "expenses.MYI".

I find only the format file:

root@hatchbox-one:/home/fr# find / -name 'expenses.*' -ls
1055950 12 -rw-rw---- 1 mysql mysql 8783 Jan 25 01:51
/var/lib/mysql/fr/expenses.frm
root@hatchbox-one:/home/fr#

7. All the tables I regularly work with have a "frm", a "MYD" and a
"MYI" file in the directory "/var/lib/mysql/fr/".

8. I'd like to drop the table "expenses", plus a number of other tables
I created, hoping to hit it right by chance. I didn't and now I have a
bunch of unusable tables which I can't drop and I don't know where their
files are hiding. If I did, I could remove them.



Grateful for any hint, comment, suggestion

Frederic



Dell E6500
Ubuntu 10.04 LTS
Python 2.7.3 (default, Aug 1 2012, 05:16:07) \n[GCC 4.6.3
MySQL (Can't find a version number)
Server version: 5.5.28-0ubuntu0.12.04.3 (Ubuntu)



All times are GMT. The time now is 04:57 AM.

Powered by vBulletin®. Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.