Professional Web Applications Themes

MySQL Connector .NET 1.0.6 and "Connection unexpectedly terminated" exception - MySQL

Dear newsgroup, I'm having a critical problem with the MySQL Connector .NET 1.0.6. I'm developing a .NET (Version 1.1 SP1) application on a Windows 2000 Professional machine with MySQL Server 4.1.14. A huge SQL query does run for about 40 minutes but then aborts with the exception "Connection unexpectedly terminated". If I comment out some time and memory consuming calculations the query does run a bit further but then also terminates. It seems like there is a relation between the memory used by my application (which constantly grows while it's running) and this problem. I am using a MySqlReader to ...

  1. #1

    Default MySQL Connector .NET 1.0.6 and "Connection unexpectedly terminated" exception

    Dear newsgroup,

    I'm having a critical problem with the MySQL Connector .NET 1.0.6. I'm
    developing a .NET (Version 1.1 SP1) application on a Windows 2000
    Professional machine with MySQL Server 4.1.14.

    A huge SQL query does run for about 40 minutes but then aborts with the
    exception "Connection unexpectedly terminated". If I comment out some time
    and memory consuming calculations the query does run a bit further but then
    also terminates. It seems like there is a relation between the memory used
    by my application (which constantly grows while it's running) and this
    problem. I am using a MySqlReader to fetch the results row by row. I found
    out that if I am using a "classical" MySqlQuery, apply a LIMIT on the SQL
    and call it several times (with different LIMITs of course), the problem
    does not occur BUT this is certainly not as high-performance as using a
    MySqlReader.

    The bug is registered in the MySQL bug tracking system
    ([url]http://bugs.mysql.com/bug.php?id=6688[/url]) since 17th November of last year
    (!) and there has been no fix.

    I also tried MySQL Server 4.1.15 and 5.0.15 -> same problem.

    I wonder if anyone came across this problem and found a resolution?

    --
    Sincerely
    Sven Jacobs
    Sven Jacobs Guest

  2. Moderated Post

    Default Re: MySQL Connector .NET 1.0.6 and "Connection unexpectedly terminated" exception

    Removed by Administrator
    Sven Jacobs Guest
    Moderated Post

Similar Threads

  1. How to find out if mysql connection is "healthy"?
    By Ignoramus12615 in forum MySQL
    Replies: 1
    Last Post: April 12th, 10:52 PM
  2. Distiller PDF gives "pstopdffilter" terminated on signal 11
    By Jim_Boydston@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: July 20th, 11:52 PM
  3. php mysql connection "unidentified error"
    By dizmarkie in forum Dreamweaver AppDev
    Replies: 8
    Last Post: April 16th, 02:51 PM
  4. #25620 [WFx]: Crash / "String is not zero-terminated"
    By xris at farcaster dot net in forum PHP Development
    Replies: 0
    Last Post: September 28th, 08:23 PM
  5. #25620 [Opn->WFx]: Crash / "String is not zero-terminated"
    By sniper@php.net in forum PHP Development
    Replies: 0
    Last Post: September 28th, 08:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139