MySQL Bugs: #15830: connection unexpectedly terminated

Bug #15830	connection unexpectedly terminated
Submitted:	17 Dec 2005 20:21	Modified:	3 May 2006 19:39
Reporter:	Juergen Otto	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	1.07/1.06	OS:	Microsoft Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
The following insert-command produces the exception:

---------------------------------
'23000 Column 'id' cannot be null
---------------------------------

command.CommandText = "create table demo (id int, primary key (id))";
command.ExecuteNonQuery();

command.Parameters.Add("id", MySqlDbType.Int32);
command.Parameters["id"].Value = 1;
command.CommandText = "insert into demo (id) values (@id)";
command.ExecuteNonQuery();

The error does _not_ occur:
- if I don't use parameters, for example: insert into demo (id) values (1)
- if I dont' use primary key: create table demo (id int)

I use C# in Visual Studio 2003, Framework 1.1, Connector 1.07/1.04 with MySQL 5.0.16

Additional info: using 'not null' produces the same error: "create table demo (id int not null, primary key (id))"

Juergen Otto

How to repeat:
Use the above C# code in a Visual Studio 2003 (Framework 1.1) environment. The connection and command object must be created before.

Please correct the following line:

cancel: command.Parameters.Add("id", MySqlDbType.Int32);
instead: command.Parameters.Add("@id", MySqlDbType.Int32);

This is the way I use with Microsoft SQL Server and it also worked properly with the ByteFX-Driver for a long time. So I can write the same code for both DBMS using the IDbConnection-Interface.

Sorry...maybe I misuderstood you, but I was not able to reproduce the bug. Could you please create and attach your test case ?

C# project to reproduce the exception

Attachment: MySQL15830.zip (application/x-zip-compressed, text), 24.46 KiB.

Attached MySQL15830.zip is the C# project which should result in the exception described.

By the way. If I use Connector/Net 1.07 the statement connection.Open() in this project ends with an exception in german: "An existing connection was cancelled by the host computer."

Sorry...but you are not avaible to use @ in parameters, please replace @ on ? and try to test your code:

command.Parameters.Add("?id", MySqlDbType.Int32);
command.Parameters["?id"].Value = 1;
command.CommandText = "insert into demo (id) values (?id)";
command.ExecuteNonQuery();

Hello,

yes, it works using the ? Parameter.

But up to Version 1.04 the @ Parameter worked also,
so you could write the same code for different database systems
using the IDbConnection Interface:

--------------------
IDbDataParameter parameter;
parameter = command.CreateParameter();

parameter.ParameterName = "@x";
parameter.DbType = DbType.Int32;
parameter.Value = 1;
command.Parameters.Add(parameter);

command.CommandText = "insert into demo2 (id) values (@x)";
command.ExecuteNonQuery();
--------------------

Something must have changed.

I found the @ Parameter in several books and articles.

Sorry,

there is a small mistake in my comment.

1) The problem is not especially Version 1.04. It was the ByteFX-Driver which worked fine with the @ Parameter.

2) The @ Parameter works fine using Access and MS SQL Server

Hi,

thank you an sorry. I found the small sentence in the documentation now.

Could you please please help me about this exception on a simple con.Open(): "Connection unexpectedly terminated".

What did you change since Version 1.06?

The 1.05 dll makes no problems with a simple con.Open()

Many thanks in advance.

Juergen

Could you please provide more info about the bug. I mean some test case.

Test case to reproduce 'connection unexpectedly terminated'

Attachment: MySQL15830.exe (application/octet-stream, text), 72.87 KiB.

Try the button "Simple connect" in my test case, wait for the error and try the button again. The second time it works fine.

I use .Net Framework 1.1 and Visual Studio 2003 7.1.3088 (German).

connection.Open() produces the error 'connection unexpectedly terminated.

The error only occurs in the Visual Studio environment. No problems running the exe directly.

It happens only with Connector 1.06 and 1.07. Older versions work fine.

I tried it on server 4.1.2 and 5.0.16. Both the same result.

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Juergen,

If you want to use the @ for your parameters, you can add "old syntax=yes" to your connection string.  You should read the documentation about the issues with doing this.

Hello,

I think there is a small misunderstanding, because I changed in this thread to another problem.

1) The issue using the ? Parameter is cleared. Thank you.

2) But the heavy problem about "connection unexpectedly terminated" is still present. Please see my test case from 13 January. It happens only with Version 1.06 and 1.07.

Thank you

Jürgen Otto

Hi. I've done testing on:
  Win XP SP2
  VS2005
  Connector 1.0.7.30072
  Several MySQL server versions on windows and linux
  and 
  Net 2.0
and I could not repeat the error you get. 

Since the only difference is in Microsoft software (newer VS and Net) I think it could be something they fixed in new releases.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".