It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
We are performing an Confluence upgrade and on the first startup there was an issue with the database. We are using Oracle 10g with ojdbc 1.4 driver. The following error occured in the logs and the upgrade did not complete.
2012-06-07 11:34:12,840 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table IMAGEDETAILS add constraint FKA768048734A4917E foreign key (ATTACHMENTID) references ATTACHMENTS
2012-06-07 11:34:12,841 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute ORA-02298: cannot validate (CONFLUENCE_ADM.FKA768048734A4917E) - parent keys not found
2012-06-07 11:34:12,843 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update
java.sql.SQLException: ORA-02298: cannot validate (CONFLUENCE_ADM.FKA768048734A4917E) - parent keys not found
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
Found solution:
select * from IMAGEDETAILS LEFT JOIN (SELECT * FROM ATTACHMENTS) ats on ats.ATTACHMENTID = IMAGEDETAILS.ATTACHMENTID WHERE CONTENTTYPE is null delete from IMAGEDETAILS where ATTACHMENTID = <id>;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
the ATTACHMENTID from the select, it will return all imagedetails with no corresponding attachments.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Miroslav.
An easier way to do that in a single query is:
delete from IMAGEDETAILS where ATTACHMENTID not in (select ATTACHMENTID from ATTACHMENTS);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm late to this game. We had the some problem upgrading from Confluence 4.3 to 5.0.3.
What are these missing rows used for? What is the consequence of deleting them? Why were they missing in the first place?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.