Confluence upgrade leaves me with missing tables


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

And so on...

I would like some advice on how to solve this.



6 answers


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.

Septa Cahyadiputra

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

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 did the trick!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

276 views 2 10
Read article

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