Broke a 5.x 6.x confluence upgrade

Question

I stupidly opted out of backing up my files before updating for the sake of disk space and didn't spot that my license had expired a few months back when doing the upgrade due to being in a rush.
Now (having updated my license) I have missing columns from the database and Confluence wont start. Has anyone experienced the same and recovered from it?

This is the final "Caused by":

Caused by: org.postgresql.util.PSQLException: ERROR: column spacepermi0_.permalluserssubject does not exist
  Position: 211
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2476)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:71)
	... 334 more

Kurt Klinner · Answer

@Ben Moorhouse

I'll keep my fingers crossed, let me know how it goes

BR

Kurt

Ben Moorhouse · Answer

Yeah, sadly I can't get back to a running version. Even tried a fresh install and restoring the automatic backups, but they come back with
Import failed. Check your server logs for more information. java.lang.RuntimeException: Could not get unique fields for table 'AO_187CCC_SIDEBAR_LINK'

argh :P
I'm going to revert back to the point just after failure (my earliest backup) and see what I can grab from the database fix. Cheers Kurt.

Kurt Klinner · Answer

@Ben Moorhouse

There is an KB article referring to your mentioned error

https://confluence.atlassian.com/confkb/unknown-column-error-when-upgrading-from-confluence-5-x-to-newer-versions-915476193.html

that points either to an outdated license or an incorrect collation setting.