Incorrect key file for table './egroupware/egw_access_log.MYI'

View: New views
2 Messages — Rating Filter:   Alert me  

Incorrect key file for table './egroupware/egw_access_log.MYI'

by LukeZ :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

We use Postfix, Cyrus, MySQL, eGroupware 1.6 on our mail server.
Today we had an electrical problem and our mail server abruptly went down.

After the restart (and the elimination of some "quota" and "seen" user
files that were corrupted) all went well.

After 10 hours without problems we were logged into the egrouwpare web
interface and we all have been kicked out. We had to reboot the server
because we all get this message:

Invalid SQL: INSERT INTO egw_access_log
(sessionid,loginid,ip,li,lo,account_id) VALUES
('g2rtcperp3hp2httdgb4t5r464','<user>@default','<IP>',1257872006,0,24):
Incorrect key file for table './egroupware/egw_access_log.MYI'; try to repair it

What could it be?

Thank you
Luca

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
eGroupWare-users mailing list
eGroupWare-users@...
https://lists.sourceforge.net/lists/listinfo/egroupware-users

Re: Incorrect key file for table './egroupware/egw_access_log.MYI'

by LukeZ :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Ok, it must be the MySQL DB that is slightly corrupted...

On Tue, Nov 10, 2009 at 18:47, Luca Tolomelli <tolomelli.luca@...> wrote:

> We use Postfix, Cyrus, MySQL, eGroupware 1.6 on our mail server.
> Today we had an electrical problem and our mail server abruptly went down.
>
> After the restart (and the elimination of some "quota" and "seen" user
> files that were corrupted) all went well.
>
> After 10 hours without problems we were logged into the egrouwpare web
> interface and we all have been kicked out. We had to reboot the server
> because we all get this message:
>
> Invalid SQL: INSERT INTO egw_access_log
> (sessionid,loginid,ip,li,lo,account_id) VALUES
> ('g2rtcperp3hp2httdgb4t5r464','<user>@default','<IP>',1257872006,0,24):
> Incorrect key file for table './egroupware/egw_access_log.MYI'; try to repair it
>
> What could it be?
>
> Thank you
> Luca
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
eGroupWare-users mailing list
eGroupWare-users@...
https://lists.sourceforge.net/lists/listinfo/egroupware-users