[opencms-dev] Error going into Offline mode

Fri Aug 29 21:11:01 CEST 2003

Greetings, 

I have been using opencms successfully for several days now.  Recently,
after saving a change to a .inc (text) file for my JSP in the source
code editor (no plugin, just the text editor) I received the error at
bottom.  This error continues to appear when ever I attempt to switch to
the Offline project and also appears if I attempt to create or switch to
another project.  Only the Online project appears to load correctly. I
have not found anything similar to this issue in the archives. I am
using JDK 1.4.1_01 on Win2k, Tomcat 4.1 standalone, MySQL and opencms
5.0.

The error states that cms_files.MYI is not available, but it is in the
mysql directory. It could be that the file is corrupt - any ideas on how
to see if it is and repair it?

Also, here are the entries from the cms log from the time I saved the
inc file which first caused this error:

[29.08.2003 11:23:23] <opencms_critical> [CmsEditor] Error while reading
file /thesource/content.inc: com.opencms.core.CmsException: 4 Sql
exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] General
error: Got error 127 from table handler. 

root cause was java.sql.SQLException: General error: Got error 127 from
table handler

[29.08.2003 11:23:23] <opencms_info> [CmsElementXml
(CmsEditor/edit_frameset)] Error in getContent for template class
com.opencms.workplace.CmsEditor

[29.08.2003 11:23:30] <opencms_critical> [CmsEditor] Error while reading
file /thesource/content.inc: com.opencms.core.CmsException: 4 Sql
exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] General
error: Got error 127 from table handler. 

root cause was java.sql.SQLException: General error: Got error 127 from
table handler

[29.08.2003 11:23:30] <opencms_info> [CmsElementXml
(CmsEditor/edit_frameset)] Error in getContent for template class
com.opencms.workplace.CmsEditor

[29.08.2003 11:23:36] <opencms_critical> [CmsEditor] Error while reading
file /thesource/content.inc: com.opencms.core.CmsException: 4 Sql
exception. Detailed error: [com.opencms.file.mySql.CmsDbAccess] General
error: Got error 127 from table handler. 

root cause was java.sql.SQLException: General error: Got error 127 from
table handler

[29.08.2003 11:23:36] <opencms_info> [CmsElementXml
(CmsEditor/edit_frameset)] Error in getContent for template class
com.opencms.workplace.CmsEditor

Thanks in advance for any help on this issue.  While I can re-install
oencms and my project from a backup, I like to find the cause of this
issue.

Mike W.

Error:

com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mySql.CmsDbAccess] General error: Can't open file:
'cms_files.MYI'. (errno: 145). 

root cause was java.sql.SQLException: General error: Can't open file:
'cms_files.MYI'. (errno: 145)

            at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:706)

            at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker
java:5203)

            at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)

            at
com.opencms.template.A_CmsXmlContent.init(A_CmsXmlContent.java:1011)

            at
com.opencms.workplace.CmsXmlWpButtonsDefFile.<init>(CmsXmlWpButtonsDefFi
le.java:79)

            at
com.opencms.workplace.A_CmsWpElement.getButtonDefinitions(A_CmsWpElement
java:192)

            at
com.opencms.workplace.CmsButton.handleSpecialWorkplaceTag(CmsButton.java
:130)

            at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplate
File.java:234)

            at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:15
15)

            at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.ja
va:510)

            at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:574)

            at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:507)

            at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:536)

            at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:471)

            at
com.opencms.workplace.CmsWpMain.getContent(CmsWpMain.java:118)

            at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:1
71)

            at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)

            at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementC
ache.java:149)

            at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:2
85)

            at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)

            at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)

            at com.opencms.core.OpenCms.showResource(OpenCms.java:956)

            at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)

            at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

            at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

            at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)

            at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)

            at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:256)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
6)

            at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:171)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

            at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

            at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:60
1)

            at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:392)

            at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56
5)

            at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
java:619)

            at java.lang.Thread.run(Thread.java:536)

>-----------

>Root cause:

>java.sql.SQLException: General error: Can't open file: 'cms_files.MYI'.
(errno: 145)

>          at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)

>          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)

>          at com.mysql.jdbc.Connection.execSQL(Unknown Source)

>          at com.mysql.jdbc.PreparedStatement.executeQuery(Unknown
Source)

>          at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatemen
t.java:173)

>          at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:674)

>          at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker
java:5203)

>          at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)

>          at
com.opencms.template.A_CmsXmlContent.init(A_CmsXmlContent.java:1011)

>          at
com.opencms.workplace.CmsXmlWpButtonsDefFile.<init>(CmsXmlWpButtonsDefFi
le.java:79)

>          at
com.opencms.workplace.A_CmsWpElement.getButtonDefinitions(A_CmsWpElement
java:192)

>          at
com.opencms.workplace.CmsButton.handleSpecialWorkplaceTag(CmsButton.java
:130)

>          at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplate
File.java:234)

>          at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown
Source)

>          at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

>          at java.lang.reflect.Method.invoke(Method.java:324)

>          at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:15
15)

>          at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.ja
va:510)

>          at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:574)

>          at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:507)

>          at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:536)

>          at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:471)

>          at
com.opencms.workplace.CmsWpMain.getContent(CmsWpMain.java:118)

>          at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:1
71)

>          at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)

>          at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementC
ache.java:149)

>          at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:2
85)

>          at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)

>          at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)

>          at com.opencms.core.OpenCms.showResource(OpenCms.java:956)

>          at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)

>          at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

>          at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

>          at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)

>          at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)

>          at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:256)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

>          at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

>          at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>          at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

>          at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

>          at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>          at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
6)

>          at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

>          at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:171)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

>          at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

>          at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

>          at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>          at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)

>          at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

>          at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

>          at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

>          at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

>          at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:60
1)

>          at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:392)

>          at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56
5)

>          at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
java:619)

>          at java.lang.Thread.run(Thread.java:536)

java.sql.SQLException: General error: Can't open file: 'cms_files.MYI'.
(errno: 145)

            at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)

            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source)

            at com.mysql.jdbc.Connection.execSQL(Unknown Source)

            at com.mysql.jdbc.PreparedStatement.executeQuery(Unknown
Source)

            at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatemen
t.java:173)

            at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:674)

            at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker
java:5203)

            at com.opencms.file.CmsObject.readFile(CmsObject.java:2883)

            at
com.opencms.template.A_CmsXmlContent.init(A_CmsXmlContent.java:1011)

            at
com.opencms.workplace.CmsXmlWpButtonsDefFile.<init>(CmsXmlWpButtonsDefFi
le.java:79)

            at
com.opencms.workplace.A_CmsWpElement.getButtonDefinitions(A_CmsWpElement
java:192)

            at
com.opencms.workplace.CmsButton.handleSpecialWorkplaceTag(CmsButton.java
:130)

            at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplate
File.java:234)

            at sun.reflect.GeneratedMethodAccessor83.invoke(Unknown
Source)

            at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)

            at java.lang.reflect.Method.invoke(Method.java:324)

            at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:15
15)

            at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.ja
va:510)

            at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:574)

            at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:507)

            at
com.opencms.template.A_CmsXmlContent.getProcessedDataValue(A_CmsXmlConte
nt.java:536)

            at
com.opencms.template.CmsXmlTemplateFile.getProcessedDataValue(CmsXmlTemp
lateFile.java:471)

            at
com.opencms.workplace.CmsWpMain.getContent(CmsWpMain.java:118)

            at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:1
71)

            at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)

            at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementC
ache.java:149)

            at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:2
85)

            at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)

            at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)

            at com.opencms.core.OpenCms.showResource(OpenCms.java:956)

            at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)

            at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)

            at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

            at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:247)

            at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:193)

            at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:256)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:191)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:241
6)

            at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:180)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherVa
lve.java:171)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

            at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:172)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:641)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:174)

            at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.i
nvokeNext(StandardPipeline.java:643)

            at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:4
80)

            at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)

            at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)

            at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:60
1)

            at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:392)

            at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:56
5)

            at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
java:619)

            at java.lang.Thread.run(Thread.java:536)

IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not an intended recipient (or the individual responsible for the delivery of this e-mail message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received the message in error and then delete it. This e-mail and all other electronic (including voice) communications from CapitalSource and its representatives are for informational purposes only. No such communication is intended by the sender to constitute either an electronic record or an electronic signature, or to constitute any agreement by the sender to conduct a transaction by electronic means. Any such intention or agreement is hereby expressly disclaimed unless otherwise explicitly indicated. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030829/df6aa24d/attachment.htm>