News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

repeating DB errors

Started by qtime, June 16, 2008, 06:50:16 PM

Previous topic - Next topic

Ben_S

Any apache log files over 2GB?
Liverpool FC Forum with 14 million+ posts.

qtime

btmp 2,5 gig, but don't know if that is a log file?

qtime

[Thu Jun 19 22:57:57 2008] [notice] child pid 31326 exit signal Segmentation fault (11), possible coredump in /tmp/apache2-gdb-dump

but no output in the CoreDumpDirectory /tmp/apache2-gdb-dump

chown that directory user and group apache:apache, don't know if that is correct?

Ben_S

Quote from: qtime on June 19, 2008, 05:07:06 PM
btmp 2,5 gig, but don't know if that is a log file?

No idea what it is, look at it with a text editor?
Liverpool FC Forum with 14 million+ posts.

qtime

http://www.informatik.uni-frankfurt.de/doc/man/hpux/btmp.4.html, but what is the problem if it's over 2,5 gig?
could that give signal 11 errors?

qtime

moved the smf to the database server and all is running on one now, no more signal 11 errors, so it should be in the server OS or lib.
Will instal CentOS

qtime

the original problem, corrupt tables are still there again... so nothing to do with the signal 11 errors, if someone has more ideas to check...?

qtime

myisamchk: error: Found duplicated key at page 33667072
could that be this in repair and find errors?:
Message #1438194 is in non-existent topic #0.
Message #1438194 is in non-existent topic #0.

Rumbaar

When you Repair and Find errors, do you have the option to fix the error and do you try and repair it?
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

qtime

yes repair it with -r or -o does not make a difference the error will come back later again

Rumbaar

I was
Quote from: qtime on June 20, 2008, 06:28:13 AM
could that be this in repair and find errors?:
Message #1438194 is in non-existent topic #0.
Message #1438194 is in non-existent topic #0.
I was referring to this, I assume you got this error in your forum maintenance  routine?
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

qtime

Yes, after Find and repair any errors.

Rumbaar

So when you do this and it gives you the option to repair the errors it doesn't?  Do you get any errors when you attempt to fix these errors?
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

qtime

it will repair the errors, and after that they are gone, but after several minutes, the message table and others give:
[root@server]# myisamchk -s *.MYI
myisamchk: MyISAM file smf_board_permissions.MYI
myisamchk: error: Key in wrong position at page 115712
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'smf_board_permissions.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_log_karma.MYI
myisamchk: error: Key in wrong position at page 4071424
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'smf_log_karma.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_log_notify.MYI
myisamchk: error: Found 39402 keys of 39403
MyISAM-table 'smf_log_notify.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_log_search_words.MYI
myisamchk: error: Key in wrong position at page 851968
MyISAM-table 'smf_log_search_words.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_log_subscribed.MYI
myisamchk: error: Found 4362 keys of 4363
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'smf_log_subscribed.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_messages.MYI
myisamchk: warning: Table is marked as crashed
myisamchk: error: Found duplicated key at page 33959936
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'smf_messages.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_personal_messages.MYI
myisamchk: error: Found 65382 keys of 65463
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'smf_personal_messages.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: MyISAM file form_pm_recipients.MYI
myisamchk: error: Found 82056 keys of 82089
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table 'form_pm_recipients.MYI' is corrupted
Fix it using switch "-r" or "-o"

Rumbaar

This is a serious indication of a misconfigured or failing mySQL server.  The support needed to correctly configured a web server and/or mySQL database is beyond the general support for SMF software.

You might want to consult a professional in this area.
"An important reward for a job well done is a personal sense of worthwhile achievement."

[ Themes ]

qtime

Thanks for information, I will move within a few days to a new server (and I can rent support overthere).

Advertisement: