Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Links SQL Crashing Server

Jul 25, 2002, 1:25 AM
fabio
User (315 posts)
Jul 25, 2002, 1:25 AM
Post #1 of 11
Views: 2853
Shortcut
Quote Reply
Links SQL Crashing Server
I have 42.000 links on my site,
and linkssql Crashing Server !!!!1
every script goes on loop, on my server I have also installed mod_perl: http://www.cercaziende.it/cgi-bin/perldiver.cgi

This is the situation on Top:

-----------------------------------------------------------
10:22am up 14:13, 1 user, load average: 1.62, 1.11, 1.05
360 processes: 352 sleeping, 3 running, 5 zombie, 0 stopped
CPU states: 81.1% user, 16.4% system, 0.0% nice, 2.3% idle
Mem: 251124K av, 241512K used, 9612K free, 24K shrd, 1788K buff
Swap: 1052216K av, 175532K used, 876684K free 18572K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
2478 admin56 11 0 0 0 0 Z 13.0 0.0 0:00 frame.cgi <defunct>
2480 admin56 9 0 0 0 0 Z 13.0 0.0 0:00 frame.cgi <defunct>
2482 admin56 9 0 14752 14M 1468 S 9.7 5.8 0:00 modify.cgi
4 root 9 0 0 0 0 SW 7.4 0.0 1:43 kswapd
2494 admin56 9 0 6360 6360 1460 S 5.9 2.5 0:00 rate.cgi
2503 admin56 9 0 6356 6356 1460 S 5.4 2.5 0:00 rate.cgi
2489 admin56 9 0 6356 6356 1460 S 5.2 2.5 0:00 rate.cgi
2493 admin56 9 0 6356 6356 1460 S 5.2 2.5 0:00 rate.cgi
2515 admin56 9 0 6360 6360 1460 S 5.2 2.5 0:00 rate.cgi
2499 admin56 9 0 6356 6356 1460 S 5.0 2.5 0:00 rate.cgi
2486 admin56 9 0 6364 6364 1460 S 4.7 2.5 0:00 rate.cgi
2485 admin56 9 0 6364 6364 1460 S 2.7 2.5 0:00 rate.cgi
----------------------------------------------------------
Someone can help me???

Thanks in Advance
Bye From Italy

Last edited by:

fabio: Jul 25, 2002, 1:37 AM
Jul 25, 2002, 2:50 AM
Paul
Veteran (19537 posts)
Jul 25, 2002, 2:50 AM
Post #2 of 11
Views: 2750
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
You don't have mod_perl installed or running, certainly in your cgi-bin as your gateway interface is wrong.

Does mod_perl (1) show in your admin panel?

I recently experienced a situation where links sql would crash but it turned out to be a problem with mod_perl and nothing to do with Links SQL
Jul 25, 2002, 3:23 AM
fabio
User (315 posts)
Jul 25, 2002, 3:23 AM
Post #3 of 11
Views: 2742
Shortcut
Quote Reply
Re: [Paul] Links SQL Crashing Server In reply to
I have mod_perl installed, but I don't know I can test if it running, can U explain me how??
were I can check in admin panel ???

Thanks in Advance
Bye From Italy
Jul 25, 2002, 3:24 AM
Paul
Veteran (19537 posts)
Jul 25, 2002, 3:24 AM
Post #4 of 11
Views: 2729
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
>>
were I can check in admin panel ???
<<

Setup > Environment
Jul 25, 2002, 3:29 AM
fabio
User (315 posts)
Jul 25, 2002, 3:29 AM
Post #5 of 11
Views: 2740
Shortcut
Quote Reply
Re: [Paul] Links SQL Crashing Server In reply to
OK
This is my Environment.
System Information

Stack Trace
======================================
Links (30611): Links::environment called at /home/virtual/site56/fst/var/www/cgi-bin/admin/GT/Template.pm line 688 with arguments
(0).
Links (30611): GT::Template::_call_func called at /home/virtual/site56/fst/var/www/cgi-bin/admin/templates/admin/compiled/setup_env.html.compiled line 48 with arguments
(GT::Template=HASH(0x826938c), Links::environment, 0).
Links (30611): GT::Template::__ANON__ called at /home/virtual/site56/fst/var/www/cgi-bin/admin/GT/Template.pm line 539 with arguments
(GT::Template=HASH(0x826938c)).
Links (30611): GT::Template::_parse called at /home/virtual/site56/fst/var/www/cgi-bin/admin/GT/Template.pm line 89 with arguments
(GT::Template=HASH(0x826938c), setup_env.html, HASH(0x8269518)).
Links (30611): GT::Template::parse called at /home/virtual/site56/fst/var/www/cgi-bin/admin/Links.pm line 250 with arguments
(GT::Template, setup_env.html, ARRAY(0x8269524), HASH(0x8269518)).
Links (30611): Links::admin_page called at admin.cgi line 50 with no arguments.
Links (30611): main::main called at admin.cgi line 24 with no arguments.


System Information
======================================
Perl Version: 5.006
Links SQL Version: 2.1.0
Persistant Env: mod_perl (0) SpeedyCGI (0)
@INC =
/home/virtual/site56/fst/var/www/cgi-bin/admin
/usr/lib/perl5/5.6.0/i386-linux
/usr/lib/perl5/5.6.0
/usr/lib/perl5/site_perl/5.6.0/i386-linux
/usr/lib/perl5/site_perl/5.6.0
/usr/lib/perl5/site_perl
.

CGI INPUT
======================================
do => page
page => setup_env.html

Tell me something please

Thanks in Advance
Bye From Italy
Jul 25, 2002, 3:31 AM
Paul
Veteran (19537 posts)
Jul 25, 2002, 3:31 AM
Post #6 of 11
Views: 2737
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
Links SQL isn't using mod_perl:

Persistant Env: mod_perl (0) SpeedyCGI (0)
Jul 25, 2002, 3:38 AM
fabio
User (315 posts)
Jul 25, 2002, 3:38 AM
Post #7 of 11
Views: 2738
Shortcut
Quote Reply
Re: [Paul] Links SQL Crashing Server In reply to
How I can set it to on ????

Thanks in Advance
Bye From Italy
Jul 25, 2002, 3:45 AM
Paul
Veteran (19537 posts)
Jul 25, 2002, 3:45 AM
Post #8 of 11
Views: 2734
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
Follow the instructions in the mod_perl readme or email your host.
Jul 25, 2002, 3:55 AM
fabio
User (315 posts)
Jul 25, 2002, 3:55 AM
Post #9 of 11
Views: 2721
Shortcut
Quote Reply
Re: [Paul] Links SQL Crashing Server In reply to
Can U setup on for me ???
I send U U/P for my server ???

Thanks in Advance
Bye From Italy
Jul 29, 2002, 1:08 AM
fabio
User (315 posts)
Jul 29, 2002, 1:08 AM
Post #10 of 11
Views: 2691
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
I have enabled mod_perl, but linksSQL CRASHING MY SERVER AGAIN !!!!!!!!!
SOMEONE CAN HELP ME ??????

Thanks in Advance
Bye From Italy
Jul 30, 2002, 1:56 AM
fabio
User (315 posts)
Jul 30, 2002, 1:56 AM
Post #11 of 11
Views: 2686
Shortcut
Quote Reply
Re: [fabio] Links SQL Crashing Server In reply to
Alex ????
have U readed my messages ???

Thanks in Advance
Bye From Italy