RE: Insert error

Miquel,

Using version 3.23.53. Don't know what version the db I'm trying to =
access
was created on, but the tables are MYISAM. Example below. I also get =
the
same error using LOAD DATA and through .NET using MySQLDriverCS.

--------------
mysql> describe main_categories;
+----------------------+-------------+------+-----+--------- +-------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+-------------+------+-----+--------- +-------+
| category_id | int(3) | | PRI | 0 | |
| category_description | varchar(40) | | | | |
| category_label | varchar(50) | YES | | NULL | |
+----------------------+-------------+------+-----+--------- +-------+
3 rows in set (0.03 sec)

mysql> insert into main_categories values (1, 'Test Catagory', 'Test
Label');
ERROR 2013: Lost connection to MySQL server during query
mysql>
---------------

Thanks

Mark

-----Original Message-----
From: miguel sol=F3rzano [mailto:miguel@mysql.com]
Sent: 27 November 2002 09:17
To: MarkH@ActiveIS.net; mysql@lists.mysql.com
Cc: bugs@lists.mysql.com
Subject: Re: Insert error


At 16:50 26/11/2002 +0000, MarkH@ActiveIS.net wrote:
Hi,

>I'm running MySQL as a service on win2k and trying to insert data into =
a
>database. Each time I try to do this I receive the following error:
>
>"ERROR 2013: Lost connection to MySQL server during query"
>
>The following error was shown when I opted to debug:
>
>"Unhandled exception at 0x004803c9 in mysqld-nt.exe: 0xC0000005: =
Access
>violation reading location 0x00ed3000."
>
>I then have to exit mysql and restart the service.
>
>I know my SQL's correct, and I can insert into other databases no =
problem.

Certainly you found a bug even the SQL statement is or not correct,
however we need more information from you for to begin the fix
process, please send us the version are you using and a test case.

For to report bugs you find more information at:

http://www.mysql.com/doc/en/Bug_reports.html

Thanks you for to report.



--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano =

/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ S=E3o Paulo - Brazil
<___/ www.mysql.com=20

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Insert error

At 09:43 27/11/2002 +0000, MarkH@ActiveIS.net wrote:
Hi,

Sorry I wasn't be able for to repeat the behavior reported:

Microsoft Windows 2000 [Vers=E3o 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

D:\>c:\mysql\bin\mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.53-max-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use test;
Database changed
mysql>
mysql> create table main_categories (
-> category_id int(3) not null primary key,
-> category_description varchar(40) not null,
-> category_label varchar(50) );
Query OK, 0 rows affected (0.05 sec)

mysql> insert into main_categories values (1, 'Test Catagory', 'Test
'> Label');
Query OK, 1 row affected (0.03 sec)

The question here is: what is the cause for you got the server down.
So please do:

- make a backup copy of the tables main_categories
- do a check table:

mysql> check table main_categories;
+----------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+----------+
| test.main_categories | check | status | OK |
+----------------------+-------+----------+----------+
1 row in set (0.00 sec)

verify if is reported something wrong with the table.

Even you have a corruption table for example, is important
for us to have this test case, so for you help me in the debug
process I will need your tables (the backup ones) in that state
and I ask you if is possible for you send me these tables into
a zipped file to:

ftp://support.mysql.com/pub/mysql=
/secret/=20


Also I am assuming you are using our compiled binaries, not a
binary built for yourself.

If the tables are you using was built with a client built with
..NET then here I am in troubles because I can't to test this
case (I don't have the .NET stuff) :(.


>Miquel,
>
>Using version 3.23.53. Don't know what version the db I'm trying to access
>was created on, but the tables are MYISAM. Example below. I also get the
>same error using LOAD DATA and through .NET using MySQLDriverCS.
>
>--------------
>mysql> describe main_categories;
>+----------------------+-------------+------+-----+-------- -+-------+
>| Field | Type | Null | Key | Default | Extra |
>+----------------------+-------------+------+-----+-------- -+-------+
>| category_id | int(3) | | PRI | 0 | |
>| category_description | varchar(40) | | | | |
>| category_label | varchar(50) | YES | | NULL | |
>+----------------------+-------------+------+-----+-------- -+-------+
>3 rows in set (0.03 sec)
>
>mysql> insert into main_categories values (1, 'Test Catagory', 'Test
>Label');
>ERROR 2013: Lost connection to MySQL server during query
>mysql>
>---------------
>
>Thanks
>
>Mark
>
>-----Original Message-----
>From: miguel sol=F3rzano [mailto:miguel@mysql.com]
>Sent: 27 November 2002 09:17
>To: MarkH@ActiveIS.net; mysql@lists.mysql.com
>Cc: bugs@lists.mysql.com
>Subject: Re: Insert error
>
>
>At 16:50 26/11/2002 +0000, MarkH@ActiveIS.net wrote:
>Hi,
>
> >I'm running MySQL as a service on win2k and trying to insert data into a
> >database. Each time I try to do this I receive the following error:
> >
> >"ERROR 2013: Lost connection to MySQL server during query"
> >
> >The following error was shown when I opted to debug:
> >
> >"Unhandled exception at 0x004803c9 in mysqld-nt.exe: 0xC0000005: Access
> >violation reading location 0x00ed3000."
> >
> >I then have to exit mysql and restart the service.
> >
> >I know my SQL's correct, and I can insert into other databases no=
problem.
>
>Certainly you found a bug even the SQL statement is or not correct,
>however we need more information from you for to begin the fix
>process, please send us the version are you using and a test case.
>
>For to report bugs you find more information at:
>
>http://www.mysql.com/doc/en/Bug_reports.html
>
>Thanks you for to report.
>
>
>
>--
>Regards,
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano=

> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
>/_/ /_/\_, /___/\___\_\___/ S=E3o Paulo - Brazil
> <___/ www.mysql.com

--=20
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Miguel Angel Sol=F3rzano
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ S=E3o Paulo - Brazil
<___/ www.mysql.com=20


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13127@lists.mysql.com
To unsubscribe, e-mail