Confluence upgrade leaves me with missing tables

Hi!

I just made an attempt at updating Confluence (5.1.1 -> 5.2.3). The installation went OK and Confluence starts up. However, it doesn't work. Heres the error:

org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.user_mapping' doesn't exist
	org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

And so on...

I would like some advice on how to solve this.

Sincerely,

Benjamin

6 answers

Benjamin,

I had the same exception as you when I attempted to upgrade from 5.1.1 to 5.2.5. Following Septa's link(CONF-30380), and using workaround 2, while none of my tables returned any non-utf8 tables, I still performed the "utf8-bin" collate change. That seemed to do the trick, oddly enough. I hope you have the same success as I did.

Thanks for the tip Alex, I really appreciate it. Yeah, I had the same "issue" where none of the querys returned any result. I guess that fooled me to not go any further. I'll definately give it a another shot.

Hi Benjamin,

By default, the latest release of Confluence should have the mentioned database. In total it should have 65 tables. You might want to access Confluence database and execute this query:

SHOW Tables;

If the above table is indeed not existed, I highly recommend you to roll back your database to pre-upgrade state and try to upgrade again. If it is created using a different case, you might want to change your database to be table name case insensitive to resolve the issue.

If the issue keep on occurring after several upgrade try, please contact our support channel and attach your atlassian-confluence.log which is located in <CONF_HOME_DIR>/logs/ that recorded the upgrade process.

Hope it helps.

Cheers,
Septa Cahyadiputra

Try to review this bug report as well as it could be related to your issue:

https://jira.atlassian.com/browse/CONF-30380

I appreciate the effort, it didn't solve anything for me though. I dont have time to work on an upgrade now so I'm reverting back to 5.1.5 and leaving it at that for a while. Thanks!

Any further information here? confluence.user_mapping doesn't exist. Our system is dead in the water.

The steps in CONF-30380 don't seem to apply as all the tables in the system are InnoDB and have proper collation on them.

I was not able to update the system, though I was successful in recovering back to an older version. I did that by uninstalling v5.3.2 and copying the backup folders to the correct place, and then install the version I had previously.

Yup. The workaround 2 in the https://jira.atlassian.com/browse/CONF-30380 did the trick!

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

751 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you