Hi

We have an installation at http://www.sissify.com/juice/discussion/

I was getting these types of server loads:

4:09pm up 75 days, 9:54, 2 users, load average: 9.56, 4.60, 2.123
9 processes: 2 sleeping, 7 running, 0 zombie, 0 stopped3
CPU states: 134.7% user, 11.1% system, 0.0% nice, 0.0% idle3
Mem: 1036080K av, 626384K used, 409696K free, 258620K shrd, 77340K buff3
Swap: 130748K av, 348K used, 130400K free 43896K cached3
3
PID USER PRI NI SIZE RES SHRD STAT %CPU %MEM TIME COMMAND3
28856 enigma 17 0 7232 6604 912 R 22.6 0.6 0:18 perl gforum.cgi3
28822 enigma 17 0 7232 6604 912 R 21.9 0.6 0:20 perl gforum.cgi3
28863 enigma 17 0 7232 6604 912 R 20.9 0.6 0:17 perl gforum.cgi3
28870 enigma 17 0 7232 6604 912 R 20.3 0.6 0:17 perl gforum.cgi3
28762 enigma 17 0 7232 6604 912 R 19.3 0.6 0:24 perl gforum.cgi3
28826 enigma 17 0 7232 6604 912 R 19.3 0.6 0:20 perl gforum.cgi3
28833 enigma 17 0 7232 6604 912 S 19.3 0.6 0:19 perl gforum.cgi3
29104 enigma 2 0 884 428 304 R 1.9 0.0 0:00 top3505

I often get error reports from users saying the page times out when waiting for a load occasionally. I caught it today with this "Top".

I logged into the system fine with a cookie saved/logged in. But if I am not logged in , the server load goes bezerk and this is the error placed to the apache error logs (Thousands of guest_id_fk's until the server kills it with procmurder):

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126532' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126531' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126530' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126529' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126528' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126527' at /home/enigma/public_html/juice/discussion/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (19112): Preparing query: DELETE FROM gforum_Online WHERE guest_id_fk = '126526'



The forum has been up for 6 months? The problem seems to have happened within the last week or so. No new software was added/changed. The machine is a dual PIII 600mhz with a gig of ram. It's dedicated, and runs about 2 gigs a day in transfer, about 10,000 uniques a day. It normally runs in the 1's without the gforum. Once the machine hits the 10's, it's on it's knees.

I have disabled it until I can find out what's up!

Thanks!

Diversity by Design