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

Segmentation Errors...

Feb 5, 2004, 11:31 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Feb 5, 2004, 11:31 AM
Post #1 of 6
Views: 8779
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Feb 5, 2004, 11:45 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Feb 5, 2004, 11:45 AM
Post #2 of 6
Views: 8557
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Feb 5, 2004, 12:11 PM
Alex
Administrator (9387 posts)
Feb 5, 2004, 12:11 PM
Post #3 of 6
Views: 8514
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: 8472
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 (9387 posts)
Feb 5, 2004, 3:14 PM
Post #5 of 6
Views: 8397
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 (18441 posts)
Andy's avatar
Feb 6, 2004, 1:32 AM
Post #6 of 6
Views: 8376
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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!