database SQL error while restoring backup

Torbjörn Richter December 11, 2017

Hi

I get the following warning while the import is running. Im not sure if will affect the import or not.

 

 WARN [Long running task: Importing data] [atlassian.confluence.setup.DefaultHibernateConfigurator] executeAdditionalSql Error executing SQL during schema changes: alter table SPACES alter column LOWERSPACEKEY varchar(255) not null, StatementCallback; SQL [alter table SPACES alter column LOWERSPACEKEY varchar(255) not null]; The index 's_lspacekey_idx' is dependent on column 'LOWERSPACEKEY'.; nested exception is java.sql.SQLException: The index 's_lspacekey_idx' is dependent on column 'LOWERSPACEKEY'.

1 answer

0 votes
Filip Heyns (Eneco) September 17, 2019

Hi Torbjörn,

We get the same error importing an xml file created on a instance with a Oracle database into an instance with a MS SQL database.

I know this is from 2017, but did this turn out to be an issue?  Import result seems fine.

I just created a Atlassian ticket, but I already wanted to check with you.

Regards,

Filip

Torbjörn Richter September 19, 2019

Hi Filip

Yes this was long time ago and i have no memory of it :)

But I dont think it caused any problems with the import

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events