Watchers do not receive mail notification of a specific page changes
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
Say that we have page A and page B. For page A, watchers received mail notification when that page is edited or commented. For page B, no mail notification is sent out/received.
Confluence is configured to use MS SQL
Diagnosis
Enable mail debug logging by including -Dmail.debug=true parameter to JAVA_OPTS. See Configuring System Properties. This parameter will print out logging email protocol details in catalina.log. Check if there is any email triggered when making changes to the affected page. If no email is triggered, run these queries against the database:
1
2
3
4
SELECT is_read_committed_snapshot_on FROM
sys.databases WHERE name= 'CONFLUENCE';
SELECT DATABASEPROPERTYEX('CONFLUENCE', 'Collation') SQLCollation;Cause
MS SQL server is not configured as Read Committed and the database collation is not set to case sensitive.
Solution
Resolution
As per the Database Setup for SQL Server, Confluence requires MS SQL server database to be:
Read committed
Case sensitive collation
To fix this:
Shut down Confluence
Create a backup of your Confluence database
Execute the following query against the database:
1
2
3
4
5
ALTER DATABASE <database_name>
SET READ_COMMITTED_SNAPSHOT ON
WITH ROLLBACK IMMEDIATE;
ALTER DATABASE <database_name> COLLATE SQL_Latin1_General_CP1_CS_AS;4. Start Confluence.
Was this helpful?