database SQL error while restoring backup

Question

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'.

Torbjörn Richter · Answer

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

Filip Heyns · Answer

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