[opencms-dev] FW: Unable to reinstall opencms

[Latha.Kamaraj at cognizant.com]

I removed an opencms installation and tried installing again. The
following errors occurred during setup:

 

!!! Error publishing file
"/system/modules/org.opencms.frontend.templateone/dialogs/property.jsp".


272:  !!! Exception An SQL error occurred when executing the following
query: com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend
.templateone/dialogs/property.jsp' AND
CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION
(SELECT DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID,
CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID
AND CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER
BY VERSION_ID, RESOURCE_PATH ASC. 

273:  org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query:
com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend
.templateone/dialogs/property.jsp' AND
CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION
(SELECT DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID,
CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID
AND CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER
BY VERSION_ID, RESOURCE_PATH ASC. 

274:        at
org.opencms.db.generic.CmsBackupDriver.readBackupFileHeaders(CmsBackupDr
iver.java:492)

 

295:  Caused by: java.sql.SQLException: Can't create/write to file
'c:\windows\temp\#sql_900_1.MYI' (Errcode: 17)

296:        at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

 

347:  Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred
when executing the following query:
com.mysql.jdbc.ServerPreparedStatement[10] - (SELECT DISTINCT
CMS_BACKUP_STRUCTURE.BACKUP_ID, CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_STRUCTURE.RESOURCE_PATH='/system/modules/org.opencms.frontend
.templateone/dialogs/property.jsp' AND
CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID AND
CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) UNION
(SELECT DISTINCT CMS_BACKUP_STRUCTURE.BACKUP_ID,
CMS_BACKUP_STRUCTURE.PUBLISH_TAG,
CMS_BACKUP_STRUCTURE.VERSION_ID,CMS_BACKUP_STRUCTURE.STRUCTURE_ID,CMS_BA
CKUP_STRUCTURE.RESOURCE_PATH,CMS_BACKUP_STRUCTURE.STRUCTURE_STATE,CMS_BA
CKUP_STRUCTURE.DATE_RELEASED,CMS_BACKUP_STRUCTURE.DATE_EXPIRED,CMS_BACKU
P_RESOURCES.RESOURCE_ID,CMS_BACKUP_RESOURCES.RESOURCE_TYPE,CMS_BACKUP_RE
SOURCES.RESOURCE_FLAGS,CMS_BACKUP_RESOURCES.RESOURCE_STATE,CMS_BACKUP_RE
SOURCES.DATE_CREATED,CMS_BACKUP_RESOURCES.DATE_LASTMODIFIED,CMS_BACKUP_R
ESOURCES.USER_CREATED,CMS_BACKUP_RESOURCES.USER_LASTMODIFIED,CMS_BACKUP_
RESOURCES.PROJECT_LASTMODIFIED,CMS_BACKUP_RESOURCES.RESOURCE_SIZE,CMS_BA
CKUP_RESOURCES.SIBLING_COUNT,CMS_BACKUP_RESOURCES.USER_CREATED_NAME,CMS_
BACKUP_RESOURCES.USER_LASTMODIFIED_NAME,CMS_BACKUP_RESOURCES.PROJECT_LAS
TMODIFIED LOCKED_IN_PROJECT FROM
CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES WHERE
CMS_BACKUP_RESOURCES.RESOURCE_ID='3c40a339-bcd0-11db-b66f-f14389d13252'
AND CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE_ID
AND CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID) ORDER
BY VERSION_ID, RESOURCE_PATH ASC. 

 

353:  Caused by: java.sql.SQLException: Can't create/write to file
'c:\windows\temp\#sql_900_1.MYI' (Errcode: 17)

 

659:  Caused by: java.sql.SQLException: Can't create/write to file
'c:\windows\temp\#sql_900_0.MYD' (Errcode: 17)

 

I encountered many such errors. It looks like some problem with the
MySQL database I'm using, but I'm not able to figure out what.

Help me out if you have any ideas.

 

Thanks and Regards,

Latha

 



This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. 
Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly 
prohibited and may be unlawful.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20070215/a4be6f49/attachment.htm>