James,
That's a bug in your app or something with the OS that holds the mysql
server.
I have that problem once, first i was reading and writing data to the
database in a way that... well, in a crazy way inside a loop, my bug.
Other thing was the server, not the mysql server but the OS that holds it,
it does not have nothing to do if the hosting OS is unix or windows, it runs
just fine on both, but it was a problem with that instalation.
I must say that you don't have the best distribution ever... "Red Hat" as
also called "Red Crap". (my personal and profesional opinion about Red Hat)
Jorge Bastos
----- Original Message -----
From: "James Moore" <banshee@stripped>
To: <dotnet@stripped>
Sent: Sunday, February 13, 2005 6:43 PM
Subject: Chasing a problem with an exception "Unable to write data to the
transport connection"
> Been chasing this for a while with no success, so I thought I'd see if
> anyone has any thoughts. Next thing on my list is to try it using an ODBC
> connector.
>
> Connector 1.0.4 talking to 4.1.9 server; server is running on a redhat 7.3
> box. Haven't installed 4.1.X server on the windows side, but was seeing
the
> same issue when talking to a 4.0.21 server running on the same machine as
> the .Net app.
>
> My application runs fine for an hour or so, happily reading and writing to
> the database, until I finally get a System.IO.IOException. I don't see
> anything unusual in the server logs; nothing shows up in the mysql server
> error log; the last entry is
>
> /usr/local/mysql/bin/mysqld: ready for connections.
> Version: '4.1.9-max-log' socket: '/tmp/mysql.sock' port: 3306 Official
> MySQL-
> max binary
>
> The one consistent thing is that the exception comes from this loop:
>
> public static int [] QueryToInts (IDbCommand cmd)
> {
> // Debug.WriteLine ("Qeyrry is \n" +
> cmd.CommandText);
> IntCollection result = new IntCollection ();
> using (IDataReader reader = cmd.ExecuteReader
> (CommandBehavior.Default))
> {
> while (reader.Read ())
> {
> int i = reader.GetInt32 (0);
> result.Add (i);
> }
> }
> return result;
> }
>
> Or a very similar one that calls GetString instead of getInt32. I don't
see
> the problem if I'm reading or writing via a dataset/adapter.
>
> Here's the stack trace for the exception:
>
> Unhandled Exception: System.IO.IOException: Unable to write data to the
> transport connection. ---> System.Net.Sockets.SocketException: An existing
> connection was forcibly closed by the remote host
> at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32
> size, SocketFlags socketFlags)
> at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset,
> Int32 size)
> --- End of inner exception stack trace ---
> at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset,
> Int32 size)
> at System.IO.BufferedStream.FlushWrite()
> at System.IO.BufferedStream.Flush()
> at MySql.Data.MySqlClient.PacketWriter.WriteChunk(Byte[] buf, Int32
> offset, Int32 length) in
> C:\Projects\salmon\mysqlconnector\MySqlClient\PacketWriter.cs:line 170
> at MySql.Data.MySqlClient.PacketWriter.Write(Byte[] buffer, Int32
offset,
> Int32 count) in
> C:\Projects\salmon\mysqlconnector\MySqlClient\PacketWriter.cs:line 183
> at MySql.Data.MySqlClient.NativeDriver.ExecuteCommand(DBCmd cmd, Byte[]
> bytes, Int32 length) in
> C:\Projects\salmon\mysqlconnector\MySqlClient\NativeDriver.cs:line 114
> at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32
> length, Boolean consume) in
> C:\Projects\salmon\mysqlconnector\MySqlClient\NativeDriver.cs:line 345
> at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader
> reader) in C:\Projects\salmon\mysqlconnector\MySqlClient\command.cs:line
299
> at MySql.Data.MySqlClient.MySqlDataReader.NextResult() in
> C:\Projects\salmon\mysqlconnector\MySqlClient\datareader.cs:line 624
> at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
> behavior) in C:\Projects\salmon\mysqlconnector\MySqlClient\command.cs:line
> 402
> at
>
MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader(Com
> mandBehavior behavior) in
> C:\Projects\salmon\mysqlconnector\MySqlClient\command.cs:line 369
> at Com.Banshee.Utilities.DataSetUtils.QueryToStrings(IDbCommand cmd) in
> C:\Projects\salmon\ComBansheeUtilities\MiscUtilities\BansheeUtils.cs:line
> 884
> at Com.Banshee.NntpServerLink.ArticleDecoder.PartialFiles() in
> C:\Projects\salmon\grunion\Articles\ArticleDecoder.cs:line 222
> at Com.Banshee.NntpServerLink.ArticleDecoder.watcher_Created(Object
> sender, FileSystemEventArgs e) in
> C:\Projects\salmon\grunion\Articles\ArticleDecoder.cs:line 258
> at System.IO.FileSystemWatcher.OnCreated(FileSystemEventArgs e)
> at System.IO.FileSystemWatcher.NotifyFileSystemEventArgs(Int32 action,
> String name)
> at System.IO.FileSystemWatcher.CompletionStatusChanged(UInt32
errorCode,
> UInt32 numBytes, NativeOverlapped* overlappedPointer)caught exception for
> sendCommandVerbose: Unable to read data from the transport connection.
> An unhandled exception of type 'System.IO.IOException' occurred in
> system.dll
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
http://lists.mysql.com/dotnet?unsub=1
>
>
