Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Segmentation Errors...

Feb 5, 2004, 11:31 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Feb 5, 2004, 11:31 AM
Post #1 of 6
Views: 1704
Shortcut
Quote Reply
Segmentation Errors...
Hi. Does anyone have any way / command that I could run via SSH, to check what part of a database is corrupt?

I basically have a LinksSQL database (using MySQL), and I am getting 'segmentation error' faults all over the place. None of the user side stuff works, but the admin side seems to find all links/categories fine?

This is doing my head in.. .as I've been working on it a couple of days now :(

TIA

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Feb 5, 2004, 11:45 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Feb 5, 2004, 11:45 AM
Post #2 of 6
Views: 1672
Shortcut
Quote Reply
Re: [Andy] Segmentation Errors... In reply to
BTW, this is the outcomes of some REPAIR's I run via SSH;

Quote:
mysql> REPAIR TABLE lsql_CatLinks;
+----------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+----------+
| links.lsql_CatLinks | repair | status | OK |
+----------------------------+--------+----------+----------+
1 row in set (1 min 58.33 sec)

mysql> REPAIR TABLE lsql_Category;
+----------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+----------+
| links.lsql_Category | repair | status | OK |
+----------------------------+--------+----------+----------+
1 row in set (2 min 24.24 sec)

mysql> REPAIR TABLE lsql_Links;
+-------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| links.lsql_Links | repair | status | OK |
+-------------------------+--------+----------+----------+
1 row in set (9 min 17.34 sec)

... yet when I run page.cgi via SSH, I get;

Quote:
[root@ns1 linkssql]# perl page.cgi
Content-type: text/html

Segmentation fault

[root@ns1 linkssql]#

Any help/advice is much appreciated :)

TIA

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Feb 5, 2004, 12:11 PM
Alex
Administrator (9386 posts)
Feb 5, 2004, 12:11 PM
Post #3 of 6
Views: 1675
Shortcut
Quote Reply
Re: [Andy] Segmentation Errors... In reply to
This sounds like the global problem in Links SQL. Remove globals.txt and see if it still fails, if it doesn't check your globals for one that has:

use SomeModule;

and I bet SomeModule doesn't exist. Perl has a bug where it seg faults with tied hash methods if you use a module that doesn't exist. See:

http://guest:guest@rt.perl.org/...isplay.html?id=23810

for more info.

Cheers,

Alex
--
Gossamer Threads Inc.
Feb 5, 2004, 3:12 PM
Wil
Veteran / Moderator (4108 posts)
Feb 5, 2004, 3:12 PM
Post #4 of 6
Views: 1662
Shortcut
Quote Reply
Re: [Alex] Segmentation Errors... In reply to
Too bad Andy is running Windows. That link won't work after the most recent security patch. :-)

- wil
Feb 5, 2004, 3:14 PM
Alex
Administrator (9386 posts)
Feb 5, 2004, 3:14 PM
Post #5 of 6
Views: 1660
Shortcut
Quote Reply
Re: [Wil] Segmentation Errors... In reply to
It will with Firebird. Wink

Cheers,

Alex
--
Gossamer Threads Inc.
Feb 6, 2004, 1:32 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Feb 6, 2004, 1:32 AM
Post #6 of 6
Views: 1651
Shortcut
Quote Reply
Re: [Alex] Segmentation Errors... In reply to
Thanks for the reply Alex. I did as you suggested (in fact, I simply renamed the 'local' folder to 'old_local'), and that got it working in SSH. I then tried it in the browser, and got a 500 IS Error. I had a thought about the 'debug' bug, which causes 500 IS errors when you have it set to 2 (not sure why though). I then set it to 0, and everything seems to be working fine now :)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates