Forums
Home Product Q&A Discussion groups Articles Ask a question Search
Learning
Events
Champions

Forums

Articles
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Confluence upgrade from 5.1.5 to 5.2.3 fails

starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Hi there

I'm trying to upgrade my Confluence installation from 5.1.5 to 5.2.3 but this fails with the following output on the log:

2013-09-02 23:23:58,707 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.2.3 [build 4394 based on commit hash a32f094df7825f58c6a417309475c6c954804a27]
2013-09-02 23:24:06,708 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2013-09-02 23:24:18,431 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2013-09-02 23:24:42,341 ERROR [main] [atlassian.confluence.plugin.PluginLoadersFactory] get Unable to load extra plugins from  specified in -Dconfluence.plugins.extra.bundled.locations. file not found or unreadable
2013-09-02 23:24:58,090 WARN [main] [org.springframework.beans.TypeConverterDelegate] findDefaultEditor PropertyEditor [com.sun.beans.editors.EnumEditor] found through deprecated global PropertyEditorManager fallback - consider using a more isolated form of registration, e.g. on the BeanWrapper/BeanFactory!
2013-09-02 23:25:31,077 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 84368 ms
2013-09-02 23:25:36,782 INFO [main] [confluence.upgrade.upgradetask.LoginInfoDuplicateEntryRemovalUpgradeTask] doUpgrade No duplicate logininfo rows found. No action necessary.
2013-09-02 23:25:37,129 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LINKS table
2013-09-02 23:25:37,607 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 128 rows out of 128 in LINKS table
2013-09-02 23:25:37,616 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in TRACKBACKLINKS table
2013-09-02 23:25:37,626 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in FOLLOW_CONNECTIONS table
2013-09-02 23:25:37,634 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1 rows out of 1 in FOLLOW_CONNECTIONS table
2013-09-02 23:25:37,642 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LABEL table
2013-09-02 23:25:37,653 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACES table
2013-09-02 23:25:37,661 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in NOTIFICATIONS table
2013-09-02 23:25:37,671 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 6 rows out of 6 in NOTIFICATIONS table
2013-09-02 23:25:37,677 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT_PERM table
2013-09-02 23:25:37,685 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT_LABEL table
2013-09-02 23:25:37,695 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEPERMISSIONS table
2013-09-02 23:25:37,707 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEGROUPS table
2013-09-02 23:25:37,714 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEGROUPPERMISSIONS table
2013-09-02 23:25:37,726 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT table
2013-09-02 23:25:37,798 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 32 rows out of 32 in CONTENT table
2013-09-02 23:25:37,809 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in EXTRNLNKS table
2013-09-02 23:25:37,825 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in ATTACHMENTS table
2013-09-02 23:25:37,837 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 3 rows out of 3 in ATTACHMENTS table
2013-09-02 23:25:37,850 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in logininfo table
2013-09-02 23:25:37,868 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LIKES table
2013-09-02 23:25:37,886 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in PAGETEMPLATES table
2013-09-02 23:25:38,005 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Checking whether user mapping table exists.
2013-09-02 23:25:38,079 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Beginning user mapping creation.
2013-09-02 23:25:38,082 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Retrieving usernames from the database.
2013-09-02 23:25:39,259 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Found 0 unique usernames that need mapping created.
2013-09-02 23:25:39,267 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finished user mapping creation.
2013-09-02 23:25:39,328 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Beginning user mapping creation.
2013-09-02 23:25:39,334 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Retrieving usernames from the database.
2013-09-02 23:25:39,344 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Found 0 unique usernames that need mapping created.
2013-09-02 23:25:39,347 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finished user mapping creation.
2013-09-02 23:25:39,492 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] doUpgrade Beginning update of username references to user key references.
2013-09-02 23:25:40,017 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LINKS table
2013-09-02 23:25:41,167 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 10878 rows in LINKS table
2013-09-02 23:25:41,169 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating TRACKBACKLINKS table
2013-09-02 23:25:41,182 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in TRACKBACKLINKS table
2013-09-02 23:25:41,191 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating FOLLOW_CONNECTIONS table
2013-09-02 23:25:41,203 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 12 rows in FOLLOW_CONNECTIONS table
2013-09-02 23:25:41,217 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LABEL table
2013-09-02 23:25:41,258 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 24 rows in LABEL table
2013-09-02 23:25:41,262 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACES table
2013-09-02 23:25:41,280 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 19 rows in SPACES table
2013-09-02 23:25:41,286 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating NOTIFICATIONS table
2013-09-02 23:25:41,345 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 403 rows in NOTIFICATIONS table
2013-09-02 23:25:41,347 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT_PERM table
2013-09-02 23:25:41,372 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 64 rows in CONTENT_PERM table
2013-09-02 23:25:41,374 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT_LABEL table
2013-09-02 23:25:41,392 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 53 rows in CONTENT_LABEL table
2013-09-02 23:25:41,394 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEPERMISSIONS table
2013-09-02 23:25:41,433 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 801 rows in SPACEPERMISSIONS table
2013-09-02 23:25:41,448 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEGROUPS table
2013-09-02 23:25:41,465 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in SPACEGROUPS table
2013-09-02 23:25:41,467 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEGROUPPERMISSIONS table
2013-09-02 23:25:41,479 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in SPACEGROUPPERMISSIONS table
2013-09-02 23:25:41,481 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT table
2013-09-02 23:25:42,435 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 2408 rows in CONTENT table
2013-09-02 23:25:42,438 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating EXTRNLNKS table
2013-09-02 23:25:42,446 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 258 rows in EXTRNLNKS table
2013-09-02 23:25:42,448 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating ATTACHMENTS table
2013-09-02 23:25:42,475 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 239 rows in ATTACHMENTS table
2013-09-02 23:25:42,477 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating logininfo table
2013-09-02 23:25:42,484 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 70 rows in logininfo table
2013-09-02 23:25:42,486 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LIKES table
2013-09-02 23:25:42,531 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in LIKES table
2013-09-02 23:25:42,533 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating PAGETEMPLATES table
2013-09-02 23:25:42,540 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 13 rows in PAGETEMPLATES table
2013-09-02 23:25:42,543 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] doUpgrade Completed update of username references.
2013-09-02 23:25:46,195 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table FOLLOW_CONNECTIONS add constraint FK_FOLLOW_CONNECTIONS_FOLLOWER foreign key (FOLLOWER) references user_mapping (user_key)
2013-09-02 23:25:46,200 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Can't create table 'confluence.#sql-21e3_6555a' (errno: 150)
2013-09-02 23:25:46,210 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update
java.sql.SQLException: Can't create table 'confluence.#sql-21e3_6555a' (errno: 150)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
        at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167)
        at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161)
        at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134)
        at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:144)
        at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:50)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
        at org.apache.catalina.core.StandardService.start(StandardService.java:525)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
2013-09-02 23:25:46,351 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: com.atlassian.config.ConfigurationException: Cannot update schema
com.atlassian.confluence.upgrade.UpgradeException: com.atlassian.config.ConfigurationException: Cannot update schema
        at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:164)
        at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:50)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
        at org.apache.catalina.core.StandardService.start(StandardService.java:525)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: com.atlassian.config.ConfigurationException: Cannot update schema
        at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:165)
        at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:134)
        at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:144)
        ... 16 more
Caused by: java.sql.SQLException: Can't create table 'confluence.#sql-21e3_6555a' (errno: 150)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2809)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1811)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1725)
        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
        at net.sf.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:167)
        at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:161)
        ... 18 more
2013-09-02 23:25:46,370 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:
2013-09-02 23:25:46,372 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema
2013-09-02 23:25:46,373 WARN [main] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade or licensing errors
2013-09-02 23:25:50,062 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve

Even reverting database and home directory and start again results in the same. Any ideas what's wrong and how to fix it?

Answer
Watch
Like Artem likes this
919 views

4 answers

1 accepted

0 votes
Answer accepted
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 18, 2013

Switched over to a support ticket as the problem seems to be more complex.

Reply
1 vote
hsuhailah
hsuhailah
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Most likely you are hitting this known bug of upgrade failure affecting MySQL database: https://jira.atlassian.com/browse/CONF-30380

Follow through the diagnosis section to determine which workaround would be applicable to your case and execute it accordingly. That should help to remedy the problem.

View More Comments
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 3, 2013

Hi Hanis,

thx for your hint which brings me a big step ahead. The storage engine was correct but I had to convert the collation of nearly all tables to utf8_bin.

But now I got another error during start, see Confluence_5.1.5_5.2.3_error.txt. What to do now with the duplicate entry?

Kind regards,

Yves

Like
hsuhailah
hsuhailah
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 3, 2013 
Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [UPDATE logininfo SET USERNAME = COALESCE((SELECT um.user_key FROM user_mapping um WHERE logininfo.USERNAME = um.lower_username), logininfo.USERNAME)]; Duplicate entry '0b94489740e078d60140e07a07cc001b' for key 'USERNAME'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '0b94489740e078d60140e07a07cc001b' for key 'USERNAME'

Bsed on the error, there are duplicate rows in your LOGININFO table that are preventing the upgrade task.

Run the following query:

select username from logininfo group by username having count(username)>1;

If it returns any rows, you are affected by this issue and the resolution is:

  1. Stop Confluence.
  2. Take a backup of your database.

  3. Run the following queries against your database:

    create temporary table deleteset as select username from logininfo group by username having count(username)>1;
 
 
delete from logininfo where username in (select username from deleteset);

    (warning) We highly recommend that you run the queries against a test instance/database before attempting to do so on your production data.

Like
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 4, 2013

Hi

Hm, seems to me that this is not the case. There are no duplicates on this table, see ConfluenceLoginInfoTable.txt. Strange. Should I try the update again?

Kind regards,

Yves

Like
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 8, 2013

Hi

Tried again because the mentioned query shows this:

mysql> select username from logininfo group by username having count(username)>1;
Empty set (0.00 sec)

Unfortunately the error is still the same, see Confluence_5.1.5_5.2.3_error2.txt. So what should I do now?

Kind regards,

Yves

Like
Reply
0 votes
Septa Cahyadiputra
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Hi Yves,

It seems that you are encountering a known issue which is describe on our published knowledge base article here:

https://confluence.atlassian.com/pages/viewpage.action?pageId=393904718

Hope it helps.

Cheers,
Septa Cahyadiputra

View More Comments
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Hi Septa,

thx for the link. On my confluence.cfg.xml I have a complete different value:

<property name="hibernate.dialect">com.atlassian.hibernate.dialect.MySQLDialect</property>

The kb article references SQLServer but we use MySQL. How to go ahead?

Kind regards,

Yves

Like
Septa Cahyadiputra
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Hi Yves,

Seems like this is due to the previously mentioned KB although the cause is a bit different. You might want to check the following configuration:

  • my.ini/cnf contain default-character-set=utf8
  • Ensure that the MySQL driver used is correct

Checked each tables using 

SELECT TABLE_SCHEMA,
       TABLE_NAME,
       CCSA.CHARACTER_SET_NAME AS DEFAULT_CHAR_SET,
       COLUMN_NAME,
       COLUMN_TYPE,
       C.CHARACTER_SET_NAME,
       ENGINE
  FROM information_schema.TABLES AS T
  JOIN information_schema.COLUMNS AS C USING (TABLE_SCHEMA, TABLE_NAME)
  JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS CCSA
       ON (T.TABLE_COLLATION = CCSA.COLLATION_NAME)
 WHERE TABLE_SCHEMA=SCHEMA()
   AND C.DATA_TYPE IN ('enum', 'varchar', 'char', 'text', 'mediumtext', 'longtext')
 ORDER BY TABLE_SCHEMA,
          TABLE_NAME,
          COLUMN_NAME;

All things fails, better consult with our support team so we could investigate the issue thoroughly.

Like
Reply
0 votes
stuartu
stuartu
Contributor
September 2, 2013

Looks like your using MyISAM rather than InnoDB.

https://confluence.atlassian.com/display/CONFKB/Database+Errors+when+Using+MySQL+and+MyISAM+Tables

View More Comments
starwarsfan
starwarsfan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
September 2, 2013

Thx for the idea but that's not the case. Checked it on the DB dump and there are only entries like ENGINE=InnoDB. Other ideas?

Like
Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events
    Community
    Forums
    FAQs Forums guidelines
    Learning
    About learning Resources
    Events
    Champions
    Copyright © 2025 Atlassian
    Privacy Policy Terms Security
    Welcome illustration

    Welcome to the new Atlassian Community

    Online forums and learning are now in one easy-to-use experience.

    By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.