Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

Looks like incoming stopped

Quote Reply
Looks like incoming stopped
While sending a message to self (seeing that no incoming message was being delivered) i get this error:


A fatal error has occured:
DBD::mysql::st execute failed: Duplicate entry '147177' for key 1 at /home/webmail/gcom/lib/GT/SQL/Driver/MYSQL.pm line 121.

Please enable debugging in setup for more details.

What does this mean? and how to fix this?

HyTC


Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] Looks like incoming stopped In reply to
Trying to understand:

Could not send mail.
Incoming Mails did not land in account. While sending mail, the error was as reported above.

Then repaired webmail db
got follwoing as warning:

webmail_msgtrack
warning : Number of rows changed from 14132 to 14133
status : OK
Therafter things work fine.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================

Last edited by:

HyperTherm: Mar 15, 2005, 6:03 PM
Quote Reply
Re: [HyperTherm] Looks like incoming stopped In reply to
perror 126
MySQL error: 126 = Index file is crashed

That was the reason. But what caused that is not known :/

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] Looks like incoming stopped In reply to
Hi,

Most common reasons for MySQL index/table corruption are:

a. MySQL not shut down properly - either mysqld hard killed, or server hard rebooted, or power loss.
b. Disk i/o errors.
c. Filesystem errors.
d. Bug in mysql.

Hope that helps,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Looks like incoming stopped In reply to
Hi.

It looks like it was case (a) as during an upgrade, the server froze while rebuilding the rpm providers list and had to be hard rebooted.

Thanks

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Quote Reply
Re: [HyperTherm] Looks like incoming stopped In reply to
You should do a:

mysqlcheck -r -A

which will run a repair on all tables in all databases to ensure nothing else is corrupted (may not show up until you hit a certain row in a table).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Looks like incoming stopped In reply to
Hi

Thanks Alex.
I had already finished up repairing all databses after i fixed the webmail db in morning (my time). There was one more db which was having that issue so it's all fixed and running now.

Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================