Details
-
Bug
-
Resolution: Won't Fix
-
High
-
None
-
4.3.1, 5.4.3
-
None
Description
If your Confluence is being upgraded while using a Microsoft SQL Server database configured with the wrong collation, all the page watchers will no longer appear in the UI.
Steps to reproduce:
- Setup a Confluence under version 5.2.3.
- Make sure to use the "SQL_Latin1_General_CP1_CI_AS" collation instead of "SQL_Latin1_General_CP1_CS_AS".
- Once this Confluence is up and running, add a few pages and create a few users.
- Watch the pages with those new users.
At this point everything will work fine.
- Upgrade Confluence to Confluence 5.4.3 (or latest).
- Log on with one of the created users in step 3.
- If you go to a page you watched you will see that your user is no longer watching that page.
Diagnostic
Run the below query against your Confluence MS SQL server database:
SELECT object_name(object_id) as TableName, name as ColumnName, collation_name FROM sys.columns WHERE collation_name <> 'SQL_Latin1_General_CP1_CS_AS' AND object_name(object_id) NOT LIKE 'sys%' AND object_name(object_id) NOT LIKE 'queue%' AND object_name(object_id) NOT LIKE 'file%'
If the above return any results means your database is using the wrong collation.
Notes
If the users re add themselves as watchers the function will work normally.
In the UI the user is no longer watching a page after the upgrade, however we are still able to see data in the notifications table:
Before Upgrading:
After Upgrading:
Workaround
- Restore your pre-upgrade backups
- Fix the collation in the database by following the steps here
- While you're there, ensure everything else in this document is set correctly
- Try the upgrade again
NB: Once the upgrade is done the watches will be lost and there is no way to retrieve them. You must restore your backups from before the upgrade and start the process again.
Attachments
Issue Links
- is related to
-
CONFSERVER-33003 Confluence is not blocking the Upgrade if MS SQL has the wrong collation.
- Closed
- relates to
-
CONFSERVER-31879 Unable to Purge Trash, Unable to Successfully Delete Space, Page Watchers Are Not Visible After Upgrade to 5.3.x Because CONTENTID Column Is NULL (PAGEID Data Were Not Migrated To CONTENTID In NOTIFICATIONS Table)
- Closed