Stable MySQL Connector/NET for Mono on Linux

View: New views
1 Messages — Rating Filter:   Alert me  

Stable MySQL Connector/NET for Mono on Linux

by ebbtepi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I have using MySQL Connector/NET (MySql.Data.Dll) to connect to MySQL from my Mono app which runs on Fedora Core 7.

My program has about 150 simultaneous users (it's a chat server) and queries the database a fair bit.

It crashes anywhere from 10 minutes to 2 hours running with this error:

Stacktrace:

  at (wrapper managed-to-native) System.Buffer.BlockCopyInternal (System.Array,int,System.Array,int,int) <0x00004>
  at (wrapper managed-to-native) System.Buffer.BlockCopyInternal (System.Array,int,System.Array,int,int) <0xffffffff>
recvd cmd: 6 (252191)
  at System.IO.BufferedStream.Read (byte[],int,int) [0x00175] in /root/mono-1.9.1/mono-1.9.1/mcs/class/corlib/System.IO/BufferedStream.cs:244
  at System.IO.BufferedStream.ReadByte () [0x0000d] in /root/mono-1.9.1/mono-1.9.1/mcs/class/corlib/System.IO/BufferedStream.cs:181
  at MySql.Data.MySqlClient.MySqlStream.LoadPacket () <0x0001e>
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket () <0x00041>
  at MySql.Data.MySqlClient.NativeDriver.ReadResult (ulong&,long&) <0x0003f>
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () <0x0003e>
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () <0x00072>
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior) <0x0057d>
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () <0x0000c>
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () <0x0002f>
  at webtunnel.Database.Query (string,System.Collections.ArrayList,bool,bool,int,string,string) [0x00156] in /www/CMS/servers/webtunnel/Database.cs:117
  at webtunnel.Database.ExecuteNonQuery (string,System.Collections.ArrayList) [0x00000] in /www/CMS/servers/webtunnel/Database.cs:139
  at webtunnel.Channel.RemoveUser (webtunnel.User) [0x00065] in /www/CMS/servers/webtunnel/Channel.cs:578
  at webtunnel.Channel.UserPart (webtunnel.User,int,string,string) [0x00000] in /www/CMS/servers/webtunnel/Channel.cs:96
  at webtunnel.Server.DisconnectUser (webtunnel.User,int,System.Collections.ArrayList) [0x000cc] in /www/CMS/servers/webtunnel/Server.cs:200
  at webtunnel.UserWrite.HandleWrite () [0x00137] in /www/CMS/servers/webtunnel/UserWrite.cs:56
  at (wrapper runtime-invoke) System.Object.runtime_invoke_void (object,intptr,intptr,intptr) <0xffffffff>

Native stacktrace:

        /usr/local/bin/mono [0x816a5af]
        /usr/local/bin/mono [0x807dcf1]
        [0x110440]
        [0x412313]
        [0x3ec87f2]
        [0x3ecae02]
        [0x3ecac97]
        [0x3ecaac2]
        [0x652e278]
        [0x652e117]
        [0x652d99b]
        [0x652b266]
        [0x652acd5]
        [0x6532ef8]
        [0x65356ff]
        [0x65352db]
        [0x35c4e86]
        [0x35c4bf1]
        [0x73a53d6]
        [0x3179aa1]
        [0x46e8a9]
        /usr/local/bin/mono(mono_runtime_delegate_invoke+0x36) [0x80c6d26]
        /usr/local/bin/mono [0x80d282d]
        /usr/local/bin/mono [0x8109ef2]
        /usr/local/bin/mono [0x8120a55]
        /lib/libpthread.so.0 [0x32144b]
        /lib/libc.so.6(clone+0x5e) [0x26480e]


I've tried using connector/net 1.0.7, 1.0.9, 5.0.3... still same problem

Any ideas? I've been stumped for months.