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

This widget could not be displayed.

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.

This widget could not be displayed.

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

This widget could not be displayed.

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!

This widget could not be displayed.

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.

This widget could not be displayed.

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.

This widget could not be displayed.

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
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

547 views 7 6
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