MySQL issues when updating Confluence 4.3 to 5.6

Dear community,

While trying to upgrade one of our largest Confluence instances from 4.3.7 to 5.6.6, we are running into major issues with MySQL. We have tried almost any approach we could find and know of, but are unable to get the upgrade done. I've detailed out our situation below and I'm hoping that someone would be willing to think along with us. Any help is highly appreciated.

Our main questions are: is there anything in this process that may cause the issues as described below and what can we do to regain a functioning database / successful update to Confluence 5.6

Thanks in advance for any hints or ideas that may help us to get this update done.

--- Jurriaan

 

Here is the approach that we used to perform the update:

OS: Windows server 2008 R2

  1. Update confluence 4.3.7 to confluence 5.1.5
  2. Update Mysql 5.0.96 to Mysql 5.1.73
  3. Copy the data folder from Mysql 5.0.96 to  data folder of Mysql 5.1.73.
    1. Remove log files
  4. Start Mysql 5.1.73
  5. Run Mysql_upgrade.exe -uUSERNAME - PPASSWORD
  6. This is giving some errors, some tables cannot be fix automatically:
The storage engine for the table
doesn't support repair instance11db.content_perm_set

The storage engine for the table
doesn't support repair instance11db.contentproperties

The storage engine for the table
doesn't support repair instance11db.cwd_app_dir_group_mapping

The storage engine for the table
doesn't support repair instance11db.cwd_app_dir_operation

Then:

  1. Start Mysql 5.1.73 and confluence 5.1.5
  2. The site and MYSQL are working fine.
  3. Now we shutdown Confluence
  4.  Altering the Database because of the collation error of Confluence with newer versions.
    1. See: https://confluence.atlassian.com/x/UAL_Jw
    2. Alter statements are ones like:
ALTER TABLE `ao_9412a1_aonotification`
MODIFY `ACTION_ICON_URL` longtext CHARACTER SET UTF8 COLLATE utf8_bin;

ALTER TABLE
`ao_9412a1_aonotification` MODIFY `DESCRIPTION` longtext CHARACTER SET UTF8
COLLATE utf8_bin;


ALTER TABLE
`ao_9412a1_aonotification` MODIFY `ICON_URL` longtext CHARACTER SET UTF8
COLLATE utf8_bin;

ALTER TABLE
`ao_9412a1_aonotification` MODIFY `ITEM_ICON_URL` longtext CHARACTER SET UTF8
COLLATE utf8_bin;ALTER TABLE `ao_9412a1_aonotification` MODIFY `ITE

Then:

  1. The altering of the collation of the database, tables and collums succeeds, but:
  2. After restarting the mysql server, The server wont start anymore, The following errors are found in the error.err file in the data folder:
Version:
'5.1.73-community'  socket: ''  port: 7306  MySQL Community
Server (GPL)

InnoDB: Error: trying to access
page number 3054769112 in space 0,

InnoDB: space name .\ibdata1,

InnoDB: which is outside the
tablespace bounds.

InnoDB: Byte offset 0, len
16384, i/o type 10.

InnoDB: If you get this error at
mysqld startup, please check that

InnoDB: your my.cnf matches the
ibdata files that you have in the

InnoDB: MySQL server.

150320 16:34:40  InnoDB:
Assertion failure in thread 7548 in file .\fil\fil0fil.c line 4135

InnoDB: We intentionally
generate a memory trap.

InnoDB: Submit a detailed bug
report to http://bugs.mysql.com.

InnoDB: If you get repeated
assertion failures or crashes, even

InnoDB: immediately after the
mysqld startup, there may be

InnoDB: corruption in the InnoDB
tablespace. Please refer to

InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-innodb-recovery.html

InnoDB: about forcing recovery.

InnoDB: Thread 5884 stopped in
file
G:\mysql-5.1.73-winbuild\mysql-community-nt-5.1.73-build\storage\innobase\include\sync0sync.ic
line 115

InnoDB: Thread 4464 stopped in file
G:\mysql-5.1.73-winbuild\mysql-community-nt-5.1.73-build\storage\innobase\include\sync0sync.ic
line 115

The server starts when we put InnoDB in recoverymode 2, but then we cannot use the database anymore.

3 answers

1 vote

Point 6 and the resultant error is where you need to start - you should have fixed them before starting Confluence (and it would have been better to have altered the collation before starting it as well).

I'd be tempted to take a different approach though - take a mysql dump of the old system, set up a new MySQL database on the right version and with the collation set correctly, and import the dump.  That bypasses the need for mysql upgrades which seem to be breaking things for you.

Thanks Nic, that helped us to get some steps further in the process. We now have successfully upgraded Confluence to 5.1, being on MySQL 5.1 as well and collation correctly set. However, the upgrade to Confluence 5.6.6 (from 5.1) will still fail right at the end of the upgrade process. Could you distill what may cause this based on the below error log? It's a long log, but the error is at the bottom of it. Thanks in advance for any thoughts that you may have.

2015-03-21 19:54:59,278 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.6.6 [build 5639 based on commit hash a252d7f5e75d7a8bf7047b4b2c92f71a56a8f048]
2015-03-21 19:55:01,946 WARN [main] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move C:\sites\TI-23\data\confluence.cfg.xml1727947062981627477tmp to C:\sites\TI-23\data\confluence.cfg.xml. Falling back to non-atomic overwrite.
2015-03-21 19:55:01,972 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2015-03-21 19:55:06,621 INFO [main] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2015-03-21 19:55:12,398 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!
2015-03-21 19:55:24,917 INFO [main] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 22944 ms
2015-03-21 19:55:25,665 INFO [main] [confluence.upgrade.impl.DefaultUpgradeManager] beforeUpgrade Generating pre-upgrade recovery file...
2015-03-21 19:55:27,987 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin []
2015-03-21 19:55:27,992 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin DATABASE_INFORMATION: []
2015-03-21 19:55:27,996 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end DATABASE_INFORMATION: []
2015-03-21 19:55:27,996 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DEFINITION: []
2015-03-21 19:55:28,833 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DEFINITION: []
2015-03-21 19:55:28,834 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] totalNumberOfTables Total number of tables: 62
2015-03-21 19:55:28,834 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLES_DATA: []
2015-03-21 19:55:28,841 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_6384ab_feature_metadata_ao]
2015-03-21 19:55:29,244 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_6384ab_feature_metadata_ao]
2015-03-21 19:55:29,245 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_9412a1_aonotification]
2015-03-21 19:55:29,245 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_9412a1_aonotification]
2015-03-21 19:55:29,246 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_9412a1_aoregistration]
2015-03-21 19:55:29,258 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_9412a1_aoregistration]
2015-03-21 19:55:29,259 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_9412a1_aotask]
2015-03-21 19:55:29,260 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_9412a1_aotask]
2015-03-21 19:55:29,261 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_9412a1_aouser]
2015-03-21 19:55:29,262 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_9412a1_aouser]
2015-03-21 19:55:29,263 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [ao_9412a1_user_app_link]
2015-03-21 19:55:29,264 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [ao_9412a1_user_app_link]
2015-03-21 19:55:29,265 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [attachments]
2015-03-21 19:55:29,853 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [attachments]
2015-03-21 19:55:29,854 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [bandana]
2015-03-21 19:55:29,901 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [bandana]
2015-03-21 19:55:29,903 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [bodycontent]
2015-03-21 19:56:24,264 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [bodycontent]
2015-03-21 19:56:24,266 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [clustersafety]
2015-03-21 19:56:24,266 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [clustersafety]
2015-03-21 19:56:24,267 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [confancestors]
2015-03-21 19:56:24,282 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [confancestors]
2015-03-21 19:56:24,283 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [confversion]
2015-03-21 19:56:24,284 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [confversion]
2015-03-21 19:56:24,285 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [content]
2015-03-21 19:59:40,519 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [content]
2015-03-21 19:59:40,520 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [content_label]
2015-03-21 19:59:40,593 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [content_label]
2015-03-21 19:59:40,594 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [content_perm]
2015-03-21 19:59:40,604 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [content_perm]
2015-03-21 19:59:40,605 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [content_perm_set]
2015-03-21 19:59:40,608 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [content_perm_set]
2015-03-21 19:59:40,609 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [contentproperties]
2015-03-21 19:59:40,610 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [contentproperties]
2015-03-21 19:59:40,610 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_app_dir_group_mapping]
2015-03-21 19:59:40,611 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_app_dir_group_mapping]
2015-03-21 19:59:40,611 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_app_dir_mapping]
2015-03-21 19:59:40,612 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_app_dir_mapping]
2015-03-21 19:59:40,612 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_app_dir_operation]
2015-03-21 19:59:40,613 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_app_dir_operation]
2015-03-21 19:59:40,614 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_application]
2015-03-21 19:59:40,614 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_application]
2015-03-21 19:59:40,615 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_application_address]
2015-03-21 19:59:40,615 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_application_address]
2015-03-21 19:59:40,616 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_application_attribute]
2015-03-21 19:59:40,616 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_application_attribute]
2015-03-21 19:59:40,616 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_directory]
2015-03-21 19:59:40,617 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_directory]
2015-03-21 19:59:40,618 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_directory_attribute]
2015-03-21 19:59:40,618 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_directory_attribute]
2015-03-21 19:59:40,619 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_directory_operation]
2015-03-21 19:59:40,619 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_directory_operation]
2015-03-21 19:59:40,620 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_group]
2015-03-21 19:59:40,628 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_group]
2015-03-21 19:59:40,629 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_group_attribute]
2015-03-21 19:59:40,630 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_group_attribute]
2015-03-21 19:59:40,630 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_membership]
2015-03-21 19:59:41,323 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_membership]
2015-03-21 19:59:41,323 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_user]
2015-03-21 19:59:41,917 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_user]
2015-03-21 19:59:41,918 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_user_attribute]
2015-03-21 19:59:42,228 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_user_attribute]
2015-03-21 19:59:42,228 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [cwd_user_credential_record]
2015-03-21 19:59:42,229 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [cwd_user_credential_record]
2015-03-21 19:59:42,230 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [decorator]
2015-03-21 19:59:42,230 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [decorator]
2015-03-21 19:59:42,231 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [external_entities]
2015-03-21 19:59:42,231 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [external_entities]
2015-03-21 19:59:42,232 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [external_members]
2015-03-21 19:59:42,232 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [external_members]
2015-03-21 19:59:42,233 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [extrnlnks]
2015-03-21 19:59:42,258 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [extrnlnks]
2015-03-21 19:59:42,259 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [follow_connections]
2015-03-21 19:59:42,264 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [follow_connections]
2015-03-21 19:59:42,264 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [groups]
2015-03-21 19:59:42,265 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [groups]
2015-03-21 19:59:42,266 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [hibernate_unique_key]
2015-03-21 19:59:42,266 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [hibernate_unique_key]
2015-03-21 19:59:42,266 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [imagedetails]
2015-03-21 19:59:42,282 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [imagedetails]
2015-03-21 19:59:42,283 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [indexqueueentries]
2015-03-21 19:59:43,812 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [indexqueueentries]
2015-03-21 19:59:43,813 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [keystore]
2015-03-21 19:59:43,814 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [keystore]
2015-03-21 19:59:43,814 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [label]
2015-03-21 19:59:43,828 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [label]
2015-03-21 19:59:43,829 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [likes]
2015-03-21 19:59:43,837 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [likes]
2015-03-21 19:59:43,837 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [links]
2015-03-21 19:59:43,880 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [links]
2015-03-21 19:59:43,880 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [local_members]
2015-03-21 19:59:43,881 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [local_members]
2015-03-21 19:59:43,882 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [logininfo]
2015-03-21 19:59:43,882 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [logininfo]
2015-03-21 19:59:43,883 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [notifications]
2015-03-21 19:59:43,929 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [notifications]
2015-03-21 19:59:43,929 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [os_group]
2015-03-21 19:59:43,930 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [os_group]
2015-03-21 19:59:43,931 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [os_propertyentry]
2015-03-21 19:59:45,639 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [os_propertyentry]
2015-03-21 19:59:45,640 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [os_user]
2015-03-21 19:59:45,640 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [os_user]
2015-03-21 19:59:45,641 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [os_user_group]
2015-03-21 19:59:45,642 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [os_user_group]
2015-03-21 19:59:45,642 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [pagetemplates]
2015-03-21 19:59:45,645 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [pagetemplates]
2015-03-21 19:59:45,645 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [remembermetoken]
2015-03-21 19:59:45,646 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [remembermetoken]
2015-03-21 19:59:45,646 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [spacegrouppermissions]
2015-03-21 19:59:45,647 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [spacegrouppermissions]
2015-03-21 19:59:45,647 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [spacegroups]
2015-03-21 19:59:45,648 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [spacegroups]
2015-03-21 19:59:45,648 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [spacepermissions]
2015-03-21 19:59:46,170 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [spacepermissions]
2015-03-21 19:59:46,171 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [spaces]
2015-03-21 19:59:46,190 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [spaces]
2015-03-21 19:59:46,191 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [trackbacklinks]
2015-03-21 19:59:46,192 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [trackbacklinks]
2015-03-21 19:59:46,193 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [trustedapp]
2015-03-21 19:59:46,193 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [trustedapp]
2015-03-21 19:59:46,194 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [trustedapprestriction]
2015-03-21 19:59:46,194 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [trustedapprestriction]
2015-03-21 19:59:46,195 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] begin TABLE_DATA: [users]
2015-03-21 19:59:46,195 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLE_DATA: [users]
2015-03-21 19:59:46,195 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end TABLES_DATA: []
2015-03-21 19:59:46,196 INFO [main] [confluence.upgrade.recovery.ConfluenceProgressMonitor] end []
2015-03-21 19:59:46,204 INFO [main] [confluence.upgrade.impl.DefaultUpgradeManager] beforeUpgrade Finished generating pre-upgrade recovery file.
2015-03-21 19:59:47,044 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FKD8C8D8A5F25E5D5F] are present on table 'external_members' for columns [extentityid]. New index 'c_extentityid_idx' will be a duplicate.
2015-03-21 19:59:47,045 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK984C5E4C8DD41734] are present on table 'contentproperties' for columns [contentid]. New index 'c_contentproperties_idx' will be a duplicate.
2015-03-21 19:59:47,046 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK932472461E2E76DB] are present on table 'os_user_group' for columns [group_id]. New index 'c_groupdid_idx' will be a duplicate.
2015-03-21 19:59:47,046 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK6B8FB445CE2B3226] are present on table 'local_members' for columns [userid]. New index 'c_userid_idx' will be a duplicate.
2015-03-21 19:59:47,046 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK9494E23C37E35A2E] are present on table 'confancestors' for columns [ancestorid]. New index 'c_ancestorid_idx' will be a duplicate.
2015-03-21 19:59:47,047 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FKE8496BA235D1D865] are present on table 'trustedapprestriction' for columns [trustedappid]. New index 'c_trustedappid_idx' will be a duplicate.
2015-03-21 19:59:47,227 INFO [main] [confluence.upgrade.upgradetask.LoginInfoDuplicateEntryRemovalUpgradeTask] doUpgrade No duplicate logininfo rows found. No action necessary.
2015-03-21 19:59:47,242 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Checking table CONTENT_PERM for redundant duplicate usernames
2015-03-21 19:59:47,252 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade No redundant duplicate usernames found in CONTENT_PERM 
2015-03-21 19:59:47,488 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LINKS table
2015-03-21 19:59:47,611 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 873 rows out of 873 in LINKS table
2015-03-21 19:59:47,613 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in TRACKBACKLINKS table
2015-03-21 19:59:47,616 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in FOLLOW_CONNECTIONS table
2015-03-21 19:59:47,631 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 58 rows out of 58 in FOLLOW_CONNECTIONS table
2015-03-21 19:59:47,635 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LABEL table
2015-03-21 19:59:47,646 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 43 rows out of 43 in LABEL table
2015-03-21 19:59:47,656 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACES table
2015-03-21 19:59:47,668 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 57 rows out of 57 in SPACES table
2015-03-21 19:59:47,671 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in NOTIFICATIONS table
2015-03-21 19:59:47,805 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 991 rows out of 991 in NOTIFICATIONS table
2015-03-21 19:59:47,810 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT_PERM table
2015-03-21 19:59:47,863 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 246 rows out of 246 in CONTENT_PERM table
2015-03-21 19:59:47,870 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT_LABEL table
2015-03-21 19:59:47,985 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 942 rows out of 942 in CONTENT_LABEL table
2015-03-21 19:59:47,997 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEPERMISSIONS table
2015-03-21 19:59:48,189 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 3491 in SPACEPERMISSIONS table
2015-03-21 19:59:48,383 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 3491 in SPACEPERMISSIONS table
2015-03-21 19:59:48,526 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 3491 in SPACEPERMISSIONS table
2015-03-21 19:59:48,594 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 491 rows out of 3491 in SPACEPERMISSIONS table
2015-03-21 19:59:48,596 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEGROUPS table
2015-03-21 19:59:48,598 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACEGROUPPERMISSIONS table
2015-03-21 19:59:48,642 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT table
2015-03-21 20:00:03,829 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 4654 in CONTENT table
2015-03-21 20:00:03,991 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 4654 in CONTENT table
2015-03-21 20:00:04,103 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 4654 in CONTENT table
2015-03-21 20:00:04,222 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 4654 in CONTENT table
2015-03-21 20:00:04,296 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 654 rows out of 4654 in CONTENT table
2015-03-21 20:00:04,298 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in EXTRNLNKS table
2015-03-21 20:00:04,303 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in ATTACHMENTS table
2015-03-21 20:00:04,402 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 2727 in ATTACHMENTS table
2015-03-21 20:00:04,507 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 1000 rows out of 2727 in ATTACHMENTS table
2015-03-21 20:00:04,573 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 727 rows out of 2727 in ATTACHMENTS table
2015-03-21 20:00:04,575 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in logininfo table
2015-03-21 20:00:04,577 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LIKES table
2015-03-21 20:00:04,586 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] updateRows Lower-cased 80 rows out of 80 in LIKES table
2015-03-21 20:00:04,588 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in PAGETEMPLATES table
2015-03-21 20:00:04,616 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Checking whether user mapping table exists.
2015-03-21 20:00:04,618 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Creating the user mapping table.
2015-03-21 20:00:04,643 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Beginning user mapping creation.
2015-03-21 20:00:04,643 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Retrieving usernames from the database.
2015-03-21 20:00:48,762 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Found 19453 unique usernames that need mapping created.
2015-03-21 20:00:55,589 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finished user mapping creation.
2015-03-21 20:00:55,606 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Beginning user mapping creation.
2015-03-21 20:00:55,606 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Retrieving usernames from the database.
2015-03-21 20:00:55,697 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Found 0 unique usernames that need mapping created.
2015-03-21 20:00:55,698 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finished user mapping creation.
2015-03-21 20:00:55,702 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] doUpgrade Beginning update of username references to user key references.
2015-03-21 20:00:55,935 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LINKS table
2015-03-21 20:00:56,012 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 2194 rows in LINKS table
2015-03-21 20:00:56,013 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating TRACKBACKLINKS table
2015-03-21 20:00:56,013 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in TRACKBACKLINKS table
2015-03-21 20:00:56,014 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating FOLLOW_CONNECTIONS table
2015-03-21 20:00:56,064 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 753 rows in FOLLOW_CONNECTIONS table
2015-03-21 20:00:56,064 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LABEL table
2015-03-21 20:00:56,116 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 928 rows in LABEL table
2015-03-21 20:00:56,116 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACES table
2015-03-21 20:00:56,139 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 710 rows in SPACES table
2015-03-21 20:00:56,139 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating NOTIFICATIONS table
2015-03-21 20:00:56,206 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 2084 rows in NOTIFICATIONS table
2015-03-21 20:00:56,206 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT_PERM table
2015-03-21 20:00:56,259 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 489 rows in CONTENT_PERM table
2015-03-21 20:00:56,259 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT_LABEL table
2015-03-21 20:00:56,385 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 3721 rows in CONTENT_LABEL table
2015-03-21 20:00:56,386 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEPERMISSIONS table
2015-03-21 20:00:57,734 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 29355 rows in SPACEPERMISSIONS table
2015-03-21 20:00:57,735 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEGROUPS table
2015-03-21 20:00:57,735 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in SPACEGROUPS table
2015-03-21 20:00:57,736 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating SPACEGROUPPERMISSIONS table
2015-03-21 20:00:57,736 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 0 rows in SPACEGROUPPERMISSIONS table
2015-03-21 20:00:57,736 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT table
2015-03-21 20:16:46,164 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 7573416 rows in CONTENT table
2015-03-21 20:16:46,164 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating EXTRNLNKS table
2015-03-21 20:16:46,233 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 937 rows in EXTRNLNKS table
2015-03-21 20:16:46,233 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating ATTACHMENTS table
2015-03-21 20:16:46,620 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 7366 rows in ATTACHMENTS table
2015-03-21 20:16:46,620 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating logininfo table
2015-03-21 20:16:47,001 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 18 rows in logininfo table
2015-03-21 20:16:47,001 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating LIKES table
2015-03-21 20:16:47,029 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 491 rows in LIKES table
2015-03-21 20:16:47,030 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating PAGETEMPLATES table
2015-03-21 20:16:47,041 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updated 10 rows in PAGETEMPLATES table
2015-03-21 20:16:47,042 INFO [main] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] doUpgrade Completed update of username references.
2015-03-21 20:16:47,133 INFO [main] [confluence.upgrade.upgradetask.RenameEhcachePropertiesUpgradeTask] doUpgrade Upgrade task complete.
2015-03-21 20:16:49,298 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FKD8C8D8A5F25E5D5F] are present on table 'external_members' for columns [extentityid]. New index 'c_extentityid_idx' will be a duplicate.
2015-03-21 20:16:49,299 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK984C5E4C8DD41734] are present on table 'contentproperties' for columns [contentid]. New index 'c_contentproperties_idx' will be a duplicate.
2015-03-21 20:16:49,299 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK932472461E2E76DB] are present on table 'os_user_group' for columns [group_id]. New index 'c_groupdid_idx' will be a duplicate.
2015-03-21 20:16:49,299 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK6B8FB445CE2B3226] are present on table 'local_members' for columns [userid]. New index 'c_userid_idx' will be a duplicate.
2015-03-21 20:16:49,300 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FK9494E23C37E35A2E] are present on table 'confancestors' for columns [ancestorid]. New index 'c_ancestorid_idx' will be a duplicate.
2015-03-21 20:16:49,300 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FKE8496BA235D1D865] are present on table 'trustedapprestriction' for columns [trustedappid]. New index 'c_trustedappid_idx' will be a duplicate.
2015-03-21 20:44:13,748 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add constraint FK_CONTENT_USERNAME foreign key (USERNAME) references user_mapping (user_key)
2015-03-21 20:44:13,748 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Cannot add or update a child row: a foreign key constraint fails (`instance11db`.<result 2 when explaining filename '#sql-1ac0_b'>, CONSTRAINT `FK_CONTENT_USERNAME` FOREIGN KEY (`USERNAME`) REFERENCES `user_mapping` (`user_key`))
2015-03-21 20:44:13,750 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`instance11db`.<result 2 when explaining filename '#sql-1ac0_b'>, CONSTRAINT `FK_CONTENT_USERNAME` FOREIGN KEY (`USERNAME`) REFERENCES `user_mapping` (`user_key`))
                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
                at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
                at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                at com.mysql.jdbc.Util.getInstance(Util.java:381)
                at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
                at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
                at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
                at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)
                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:203)
                at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:178)
                at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:168)
                at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:51)
                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)
2015-03-21 20:44:13,778 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:188)
                at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:51)
                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:207)
                at bucket.core.persistence.hibernate.schema.SchemaHelper.updateSchemaIfNeeded(SchemaHelper.java:178)
                at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:168)
                ... 16 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`instance11db`.<result 2 when explaining filename '#sql-1ac0_b'>, CONSTRAINT `FK_CONTENT_USERNAME` FOREIGN KEY (`USERNAME`) REFERENCES `user_mapping` (`user_key`))
                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
                at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
                at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
                at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
                at com.mysql.jdbc.Util.getInstance(Util.java:381)
                at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
                at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
                at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
                at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
                at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2687)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)
                at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)
                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:203)
                ... 18 more
2015-03-21 20:44:13,785 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:
2015-03-21 20:44:13,785 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: Cannot update schema
2015-03-21 20:44:13,785 WARN [main] [atlassian.confluence.plugin.PluginFrameworkContextListener] contextInitialized Not starting full plugin system due to upgrade or licensing errors
2015-03-21 20:44:14,832 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2015-03-21 20:44:14,879 ERROR [main] [apache.catalina.core.StandardContext] log Error starting static Resources
java.lang.IllegalArgumentException: Document base C:\sites\TI-23\application\webapps\host-manager does not exist or is not a readable directory
                at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:142)
                at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:4320)
                at org.apache.catalina.core.StandardContext.start(StandardContext.java:4489)
                at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
                at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
                at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
                at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675)
                at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
                at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
                at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
                at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
                at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
                at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
                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)
2015-03-21 20:44:14,880 ERROR [main] [apache.catalina.core.StandardContext] log Error in resourceStart()
2015-03-21 20:44:14,882 ERROR [main] [apache.catalina.core.StandardContext] log Error getConfigured
2015-03-21 20:44:14,883 ERROR [main] [apache.catalina.core.StandardContext] log Context [/host-manager] startup failed due to previous errors
2015-03-21 20:44:14,891 ERROR [main] [apache.catalina.core.StandardContext] log Error starting static Resources

 

 

0 vote

Hi Jurrian,

the last error states this part:

2015-03-21 20:16:49,300 WARN [main] [hibernate.tool.hbm2ddl.PreExistingIndexChecker] warnIfExistingMatchingIndexesPresent Pre-existing indexes [FKE8496BA235D1D865] are present on table 'trustedapprestriction' for columns [trustedappid]. New index 'c_trustedappid_idx' will be a duplicate.
2015-03-21 20:44:13,748 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Unsuccessful: alter table CONTENT add constraint FK_CONTENT_USERNAME foreign key (USERNAME) references user_mapping (user_key)
2015-03-21 20:44:13,748 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute Cannot add or update a child row: a foreign key constraint fails (`instance11db`.<result 2 when explaining filename '#sql-1ac0_b'>, CONSTRAINT `FK_CONTENT_USERNAME` FOREIGN KEY (`USERNAME`) REFERENCES `user_mapping` (`user_key`))
2015-03-21 20:44:13,750 ERROR [main] [hibernate.tool.hbm2ddl.SchemaUpdate] execute could not complete schema update
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`instance11db`.<result 2 when explaining filename '#sql-1ac0_b'>, CONSTRAINT `FK_CONTENT_USERNAME` FOREIGN KEY (`USERNAME`) REFERENCES `user_mapping` (`user_key`))
                at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

This KB contains a similar error although it's for a Confluence 3.4 or below. https://confluence.atlassian.com/display/CONFKB/Upgrade+Fails+due+to+Foreign+Key+Constraint+Violation+on+Local+Members+Table

The messages above seems to point to a incorrect rolled back database. It sound like the indexes already exists, so I recommend to roll back Confluence database to 4.x version and upgrade to 5.1 and then confirm that all went well and proceed to 5.6 ou 5.7.1.

Cheers,

Rodrigo

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 ...

613 views 21 11
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