Professional Web Applications Themes

timeout expired error - MySQL

I am using visual web developer and the odbc driver to connect to a mysql database. It seems like every four or five connections to the database cause an error. For instance, in the logs I get the following information: [5/2/2006 4:34:08 PM] SELECT * FROM tAuthUsers WHERE Username = 'featurecreep' AND Password = '$$$$' [5/2/2006 4:34:08 PM] Setting Company Id Var: $$$$ [5/2/2006 4:34:08 PM] INSERT INTO Keys (Company, Security, Created) VALUES('$$$', '$$$', NOW()) [5/2/2006 4:34:08 PM] SELECT * FROM Keys WHERE Security = '$$$' AND Company = '$$$' AND Created < '2006-05-03T04:34:08' AND Created > '2006-05-02T04:34:08' [5/2/2006 4:34:23 ...

  1. #1

    Default timeout expired error

    I am using visual web developer and the odbc driver to connect to a
    mysql database. It seems like every four or five connections to the
    database cause an error. For instance, in the logs I get the following
    information:
    [5/2/2006 4:34:08 PM] SELECT * FROM tAuthUsers WHERE Username =
    'featurecreep' AND Password = '$$$$'
    [5/2/2006 4:34:08 PM] Setting Company Id Var: $$$$
    [5/2/2006 4:34:08 PM] INSERT INTO Keys (Company, Security, Created)
    VALUES('$$$', '$$$', NOW())
    [5/2/2006 4:34:08 PM] SELECT * FROM Keys WHERE Security = '$$$' AND
    Company = '$$$' AND Created < '2006-05-03T04:34:08' AND Created >
    '2006-05-02T04:34:08'
    [5/2/2006 4:34:23 PM] MySql.Data.MySqlClient.MySqlException: error
    connecting: Timeout expired. The timeout period elapsed prior to
    obtaining a connection from the pool. This may have occurred because
    all pooled connections were in use and max pool size was reached.
    at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    at
    MySql.Data.MySqlClient.MySqlPoolManager.GetConnect ion(MySqlConnectionString
    settings)
    at MySql.Data.MySqlClient.MySqlConnection.Open()
    at cms._InsertMessageIntoSystem(String MobileNo, String MessageText,
    Int32 CompanyId, Int32 CampaignId)

    Can anybody point me to any information regarding the cause of this
    error or perhaps suggest a solution to it? I am not sure what is
    causing it, nor am I at all sure how to solve the error.

    lambelly@gmail.com Guest

  2. #2

    Default Re: timeout expired error

    Can you please make sure you are closing the connection properly?

    This may help you to solve this issue.

    Regards,
    Vinu.P.K

    [email]lambelly[/email] wrote:
    > I am using visual web developer and the odbc driver to connect to a
    > mysql database. It seems like every four or five connections to the
    > database cause an error. For instance, in the logs I get the following
    > information:
    > [5/2/2006 4:34:08 PM] SELECT * FROM tAuthUsers WHERE Username =
    > 'featurecreep' AND Password = '$$$$'
    > [5/2/2006 4:34:08 PM] Setting Company Id Var: $$$$
    > [5/2/2006 4:34:08 PM] INSERT INTO Keys (Company, Security, Created)
    > VALUES('$$$', '$$$', NOW())
    > [5/2/2006 4:34:08 PM] SELECT * FROM Keys WHERE Security = '$$$' AND
    > Company = '$$$' AND Created < '2006-05-03T04:34:08' AND Created >
    > '2006-05-02T04:34:08'
    > [5/2/2006 4:34:23 PM] MySql.Data.MySqlClient.MySqlException: error
    > connecting: Timeout expired. The timeout period elapsed prior to
    > obtaining a connection from the pool. This may have occurred because
    > all pooled connections were in use and max pool size was reached.
    > at MySql.Data.MySqlClient.MySqlPool.GetConnection()
    > at
    > MySql.Data.MySqlClient.MySqlPoolManager.GetConnect ion(MySqlConnectionString
    > settings)
    > at MySql.Data.MySqlClient.MySqlConnection.Open()
    > at cms._InsertMessageIntoSystem(String MobileNo, String MessageText,
    > Int32 CompanyId, Int32 CampaignId)
    >
    > Can anybody point me to any information regarding the cause of this
    > error or perhaps suggest a solution to it? I am not sure what is
    > causing it, nor am I at all sure how to solve the error.
    Vinu.P.K Guest

  3. #3

    Default Re: timeout expired error

    Vinu.P.K wrote:
    > Can you please make sure you are closing the connection properly?
    >
    > This may help you to solve this issue.
    >
    > Regards,
    > Vinu.P.K
    >
    I believe it is. The code for each query follows this format:
    con = new MySql.Data.MySqlClient.MySqlConnection();
    myConnectionString = "server=????;uid=????;" +
    "pwd=????;database=Interface;";
    con.ConnectionString = myConnectionString;
    con.Open();

    string Sql = null;
    Sql = "INSERT INTO Keys (Company, Key, Created) VALUES('" +
    Company + "', '" + m_SecKey + "', NOW())";
    _Debug(Sql);
    cmd = new MySql.Data.MySqlClient.MySqlCommand();
    cmd.Connection = con;
    cmd.CommandText = Sql;
    cmd.ExecuteNonQuery();
    //MySQLCommand cmd = new MySQLCommand(Sql, conn);
    //_DestroyDatabase();
    con.Close();

    Each query I mentioned opens a connection to the database and closes it.

    lambelly@gmail.com Guest

Similar Threads

  1. ASP + SQL Server - Timeout Expired
    By David Morgan in forum ASP
    Replies: 2
    Last Post: October 1st, 09:21 PM
  2. Replies: 0
    Last Post: August 7th, 12:52 PM
  3. Timeout expired
    By Phil Grimpo in forum ASP Components
    Replies: 3
    Last Post: July 31st, 07:33 PM
  4. ado.net Timeout expired
    By Shahab Gerami in forum ASP.NET General
    Replies: 0
    Last Post: July 3rd, 02:35 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