Re: PHP5 and disappearing DB connections
| From: | Justin Patrin | Date: | Tue, 11 Oct 2005 18:32:45 +0000 |
| Subject: | Re: PHP5 and disappearing DB connections | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40140@lists.php.net to get a copy of this message | ||
On 10/11/05, Joe Stump <joe@joestump.net> wrote:
> Anybody have a problem where their database connections magically
> disappear? I'm connecting to the database just fine and it works for
> a while and then in DB_mysql::simpleQuery() I get the following:
>
> Warning: mysql_select_db(): 275 is not a valid MySQL-Link resource
> in /usr/local/lib/php/DB/mysql.php on line 306
>
> Warning: mysql_errno(): 275 is not a valid MySQL-Link resource in /
> usr/local/lib/php/DB/mysql.php on line 895
>
> Warning: mysql_error(): 275 is not a valid MySQL-Link resource in /
> usr/local/lib/php/DB/mysql.php on line 896
>
> Keep in mind that I've done > 10 queries before this happens. Here's
> the really odd part:
>
> resource(275) of type (mysql link) jax
> resource(275) of type (mysql link) jax
> resource(275) of type (mysql link) jax
> resource(275) of type (mysql link) enotes_com
> resource(275) of type (Unknown) jax
>
> Notice how the resource type changes to Unknown. What the heck?
>
You're not, perhaps, using mysql_* functions which are called in
between those are you?
--
Justin Patrin