Database Trouble Since Upgrade to 3

[msjulian]

It seems like I am having all kinds of database connection errors since I upgraded. I have made sure that the $usepconnect =0; is correct as some have said here but still having trouble. I can not seem to keep the board up. What are some options to look at?

Mike Julian
http://www.4m.net

[Steve Machol]

What are the errors you are getting?

[msjulian]

What are the errors you are getting?

1040 database connection error. It is like the database is not clearing inactive users and it builds up to the point that it will not allow new connections.

[Scott MacVicar]

did you remove $cronimage from the footer?

[msjulian]

did you remove $cronimage from the footer?

No.
I have 1,036 records in the session table right now and I know there are only about 250 users on right now.

[Scott MacVicar]

whats your cookie timeout set at?

[msjulian]

whats your cookie timeout set at?

300

[Scott MacVicar]

SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300;

what does that return?

[msjulian]

SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300;

what does that return?

SELECT * FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 300 LIMIT 0, 30

[Scott MacVicar]

how many rows does it return?

PHP is responsible for closing all connections. It may in fact be another script running on your site / server that is causing the problems.

[msjulian]

how many rows does it return?

PHP is responsible for closing all connections. It may in fact be another script running on your site / server that is causing the problems.

(844 total)
With a whole bunce of user ID 0

[Scott MacVicar]

how many rows are there in total?

just do a SELECT COUNT(*) AS total FROM session

[msjulian]

how many rows are there in total?

just do a SELECT COUNT(*) AS total FROM session

1144

[Scott MacVicar]

whats the exact mysql error?

The onyl error you'd be getting is that the HEAP table size is being exceeded if it was sessions not being cleared out.

If its max connections then its most likely another script with pconnect on.