[opencms-dev] random problem accessing resources in the database

[Vroonen Julien]

Hi List,

 

I have a random problem accessing resources in the database

Randomly (and frequently), I get errors accessing resources (when “editing”, “creating new page”, or “publishing”).

I think the problem is here :

org.opencms.db.oracle.CmsVfsDriver.internalWriteContent(CmsVfsDriver.java:216)

            res = ((DelegatingResultSet)stmt.executeQuery()).getInnermostDelegate();

            if (!res.next()) {

                throw new CmsDbEntryNotFoundException(Messages.get().container(

                    Messages.LOG_READING_RESOURCE_1,

                    resourceId));

            }

=> I suspect “res.next()” to return null.

 

But I do NOT understand why because the resource with id “ccf73759-0713-11de-ba39-15825d542b41” exists in the database!

 

And if I retry the operation, after some times (2, 3.. up to 10), it finishes with success!

*      Database problem (configuration option)?

*      JDBC driver problem ?

*      Webapp problem (webserver settings)?

*      How to avoid it? Export site, reinstall a clean opencms and import?

 

Maybe you had the same problem or you have an idea of what it could be or where I could search? 

 

 

NB (For information, if it can help) : I installed OpenCMS on another server to develop the site (on a local server from my company), where I had absolutely no problems.

Then, I exported/imported the database and I moved the webapp on the client infrastructure (yes, I have emptied cache, delete compiled pages, etc…)

I was always doing it like this with OpenCMS 6.0.4 without problem.

And since I also have the problem when I create new resources on the client, I don’t see how it could be linked to this “installation method”…

 

Below, my environment and an example of the exception (on publish here)…

 

 

Thanks for any help,

  Julien.

 

 

Environment :

- OpenCMS 7.0.5

- Oracle 10.1.0.5

- JBoss 4.2.2.GA

- JDK 1.5.0

- Linux (Suse 9 – not sure of this version but I think we should not care of this)

- Running under VMWare virtualized Server

14:54:47,667 INFO  [Server] Starting JBoss (MX MicroKernel)...

14:54:47,668 INFO  [Server] Release ID: JBoss [Trinity] 4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)

14:54:48,031 INFO  [ServerInfo] Java version: 1.5.0_15,Sun Microsystems Inc.

14:54:48,031 INFO  [ServerInfo] Java VM: Java HotSpot(TM) Server VM 1.5.0_15-b04,Sun Microsystems Inc.

14:54:48,031 INFO  [ServerInfo] OS-System: Linux 2.6.5-7.244-bigsmp,i386

 

Exception :

( 1 / 1 ) Publishing file /fr/nsi_test/index.html ... Error publishing file "/sites/sipp_intra/fr/nsi_test/index.html". 
Exception org.opencms.file.CmsDataAccessException: Error reading resource "ccf73759-0713-11de-ba39-15825d542b41".
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:980)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1393)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5254)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.db.CmsDbEntryNotFoundException: Error reading resource "ccf73759-0713-11de-ba39-15825d542b41".
at org.opencms.db.oracle.CmsVfsDriver.internalWriteContent(CmsVfsDriver.java:216)
at org.opencms.db.oracle.CmsVfsDriver.createOnlineContent(CmsVfsDriver.java:129)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1055)
at org.opencms.db.generic.CmsProjectDriver.publishChangedFile(CmsProjectDriver.java:2646)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:902)
... 3 more
Statistics: published files: 1, published folders: 0, deleted folders: 0, duration: 00:00:00
Exception org.opencms.file.CmsDataAccessException: Error publishing file "/sites/sipp_intra/fr/nsi_test/index.html". 
at org.opencms.file.CmsDataAccessException.createException(CmsDataAccessException.java:77)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1413)
at org.opencms.db.CmsDriverManager.publishJob(CmsDriverManager.java:5254)
at org.opencms.publish.CmsPublishThread.run(CmsPublishThread.java:141)
Caused by: org.opencms.file.CmsDataAccessException: Error reading resource "ccf73759-0713-11de-ba39-15825d542b41".
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:980)
at org.opencms.db.generic.CmsProjectDriver.publishProject(CmsProjectDriver.java:1393)
... 2 more
Caused by: org.opencms.db.CmsDbEntryNotFoundException: Error reading resource "ccf73759-0713-11de-ba39-15825d542b41".
at org.opencms.db.oracle.CmsVfsDriver.internalWriteContent(CmsVfsDriver.java:216)
at org.opencms.db.oracle.CmsVfsDriver.createOnlineContent(CmsVfsDriver.java:129)
at org.opencms.db.generic.CmsProjectDriver.publishFileContent(CmsProjectDriver.java:1055)
at org.opencms.db.generic.CmsProjectDriver.publishChangedFile(CmsProjectDriver.java:2646)
at org.opencms.db.generic.CmsProjectDriver.publishFile(CmsProjectDriver.java:902)
... 3 more

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090309/6af403bb/attachment.htm>