Solution for Invalid SQL: DELETE FROM active_sessions....

[Mark Robson]

We're using MySQL version 3.22.25 on our RedHat 6.0 webmail server with Imp 
2.2.1. We see this error about once every 2-3 months but we've found out what 
was causing it on our system. The tables in the horde database 
(active_sessions, imp_pref, etc..) are created as ISAM files. On an active 
system where thousands of records are regularly being added and deleted the 
index file somehow gets corrupted.

There are MySQL utilities that can repair the index file, but since 
active_sessions contains "temporary" data anyway, we've found it simpler and 
faster to create a script that drops the table and recreates it.

I guess that if I upgraded to a newer version of MySQL I probably wouldn't have 
this problem (I think MySQL uses a new file structure now).

I hope this helps some.

Mark Robson
Salve Regina University
Newport, RI

Quoting Lynn Schaper <schaper@Colorado.EDU>:

> We occasionally see this error in the top frame on the login page, or
> in
> the top frame once logged in, or (less often) in the frame listing the
> mail once logged in:
> 
>   Database error (HordeDB): Invalid SQL: DELETE FROM active_sessions
> WHERE
>   changed < '20001109092758' AND name = 'HordeSession'
> 
> 

----- End forwarded message -----