20 messages in com.mysql.lists.bugsRe: error 127 from table handler with...| From | Sent On | Attachments |
|---|---|---|
| Fournier Jocelyn [Presence-PC] | 19 Aug 2001 08:16 | |
| Sinisa Milivojevic | 20 Aug 2001 03:15 | |
| Sinisa Milivojevic | 20 Aug 2001 03:20 | |
| Michael Widenius | 20 Aug 2001 05:27 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 09:01 | |
| Sinisa Milivojevic | 20 Aug 2001 11:31 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 11:42 | |
| Sinisa Milivojevic | 20 Aug 2001 11:50 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 11:58 | |
| Sasha Pachev | 20 Aug 2001 12:10 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 13:39 | |
| Sasha Pachev | 20 Aug 2001 13:47 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 13:57 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 17:35 | |
| Sasha Pachev | 20 Aug 2001 17:48 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 18:07 | |
| Fournier Jocelyn [Presence-PC] | 20 Aug 2001 18:11 | |
| Michael Widenius | 21 Aug 2001 02:21 | |
| Michael Widenius | 21 Aug 2001 03:09 | |
| Michael Widenius | 21 Aug 2001 04:13 |
| Subject: | Re: error 127 from table handler with latest mysql 4.0.0 sources. |
|---|---|
| From: | Fournier Jocelyn [Presence-PC] (jo...@presence-pc.com) |
| Date: | 08/20/2001 11:42:42 AM |
| List: | com.mysql.lists.bugs |
I think I have more clues about the problem. It seems the error occurs only if the table is read at the same time by another thread :
mysql> insert into presence.inscrit select * from forum.inscrit; Query OK, 0 rows affected (0.56 sec) Records: 13666 Duplicates: 13666 Warnings: 0
mysql> insert into presence.inscrit select * from forum.inscrit; Query OK, 0 rows affected (0.55 sec) Records: 13666 Duplicates: 13666 Warnings: 0
mysql> insert into presence.inscrit select * from forum.inscrit; Query OK, 0 rows affected (0.56 sec) Records: 13666 Duplicates: 13666 Warnings: 0
mysql> insert into presence.inscrit select * from forum.inscrit; ERROR 1030: Got error 127 from table handler
mysql> insert into presence.inscrit select * from forum.inscrit; Query OK, 0 rows affected (0.56 sec) Records: 13666 Duplicates: 13666 Warnings: 0
mysql> insert into presence.inscrit select * from forum.inscrit; Query OK, 0 rows affected (0.56 sec) Records: 13666 Duplicates: 13666 Warnings: 0
mysql> insert into presence.inscrit select * from forum.inscrit; ERROR 1030: Got error 127 from table handler
The forum.inscrit is a 'in use' table which can be read by other thread, and I got sometime error 127 from table handler. I copy table inscrit in an other database "presence" to inscrit and inscrit2 :
mysql> SELECT COUNT(*) FROM forum.inscrit; +----------+ | COUNT(*) | +----------+ | 13666 | +----------+ 1 row in set (0.00 sec)
mysql> SELECT COUNT(*) FROM presence.inscrit; +----------+ | COUNT(*) | +----------+ | 13666 | +----------+ 1 row in set (0.00 sec)
mysql> SELECT COUNT(*) FROM presence.inscrit2; +----------+ | COUNT(*) | +----------+ | 13665 | +----------+ 1 row in set (0.00 sec)
inscrit2 table is not read by any thread. I can run "insert into presence.inscrit select * from presence.inscrit2" any time, he won't fail :
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.56 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.57 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.55 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.55 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.55 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.56 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.55 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.57 sec) Records: 13665 Duplicates: 13665 Warnings: 0
mysql> insert into presence.inscrit select * from presence.inscrit2; Query OK, 0 rows affected (0.56 sec) Records: 13665 Duplicates: 13665 Warnings: 0
I have this behaviour on my two server.
Hope this could help.
Jocelyn Fournier Presence-PC
----- Original Message ----- From: "Sinisa Milivojevic" <sin...@mysql.com> To: <jo...@presence-pc.com> Cc: <mon...@mysql.com>; <bu...@lists.mysql.com> Sent: Monday, August 20, 2001 8:31 PM Subject: Re: error 127 from table handler with latest mysql 4.0.0 sources.
Fournier Jocelyn [Presence-PC] writes:
I can reproduce the bug quite easily :
ALTER TABLE inscrit DROP flag => Got error 127 from table handler
With 3.23.39, no problem !
I just tested this with latest 4.0.0 and no problem.
Check out your TMPDIR free space.
-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com