[opencms-dev] OpenCms internal access clogging DB

Pere Torrodellas ptorrodellas at fihoca.com
Thu Mar 5 13:03:25 CET 2009


Hello,

Our hosting site claims that there is an OpenCms DB select that is clogging the Oracle server because it is executing cotinuously:

SELECT
CMS_ONLINE_STRUCTURE.STRUCTURE_ID,
CMS_ONLINE_STRUCTURE.RESOURCE_ID,
CMS_ONLINE_STRUCTURE.RESOURCE_PATH,
CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,
.....................
CMS_ONLINE_RESOURCES.USER_CREATED,
CMS_ONLINE_RESOURCES.USER_LASTMODIFIED,
....................
CMS_ONLINE_RESOURCES.SIBLING_COUNT,
CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED 

FROM MS_ONLINE_STRUCTURE,CMS_ONLINE_RESOURCES 

WHERE CMS_ONLINE_STRUCTURE.RESOURCE_PATH=:1 AND
CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID 
ORDER BY CMS_ONLINE_STRUCTURE.STRUCTURE_STATE ASC

It seems to be something related to administration resouces listings because it retrieves info like date last modified or user created, except that nobody is accessing the ONLINE project in the administration, much less with such frequency (they claim hundreds of times).

Can anyone suggest what function is issuing that statement, and a reason for it being invoked in what seems a loop?

Thank for any hint,

Pere
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20090305/1a463312/attachment.html>


More information about the opencms-dev mailing list