[opencms-dev] Error switching to Offline mode

[Claus Priisholm]

Very much looks like a MySQL problem (probably why there's nothing 
about it in the mailing archive).
I was just about to say that you'd run out of file descriptors after a 
long days work :-), but then I noticed the errno was not 23 or 24, so I 
looked errno 145 up:

%perror 145
Error code 145:  Unknown error: 145
145 = Table was marked as crashed and should be repaired

Kind of strange result as it both says it is unknown and then that it 
knows it anyway. But it should indicate a crashed table, so you'll have 
to run various MySQL tools on the table 
(http://www.mysql.com/doc/en/Repair.html).

Claus

On fredag, sep 26, 2003, at 05:51 Europe/Copenhagen, Laurent Gauthier 
wrote:

> I seem to have a corrupt OpenCMS database (MySQL).
>
> I have been working (developing) all day with OpenCMS and now, I
> suddenly get this error whenever I try to switch to Offline mode after 
> a
> login:
>
> [25.09.2003 22:57:49] <opencms_critical> [CmsXmlWpTemplateFile] Error
> while building workplace element "button":
> com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> [com.opencms.file.mySql.CmsDbAccess] General error: Can't open file:
> 'cms_resources.MYD'. (errno: 145).
> root cause was java.sql.SQLException: General error: Can't open file:
> 'cms_resources.MYD'. (errno: 145)
>
> If I try accessing the cms_resources table using any database tool, I
> get the same error message which leads me to think that the MySQL table
> IS indeed corrupt.
>
> Somebody else reported pretty uch the same behavior on the list archive
> (http://mail.opencms.org/pipermail/opencms-dev/2003q3/006922.html) but 
> I
> did not see any follow-up.
>
> Did I really loose my work that was not backed up?
>
> Do I need to completely reinitialize the MySQL OpenCMS database ?
>
> Not a very pleasing perspective...
>
> I could not find anything relating to this in the bug archive.
>
>
> Laurent
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please 
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>
>
--
Claus Priisholm
+45 48 22 46 46, fax: +45 48 22 46 43
cpr at codedroids.com
http://www.codedroids.com