SQLException happens in 'Publish Daily Statistics' job when using Mysql

XMLWordPrintable

    • 7
    • Severity 3 - Minor
    • 1

      Issue Summary

      'getNumberOfDarkThemeUsers Error' happen in 'Publish Daily Statistics' job when using Mysql.
      This problem is reported in confluence 9.2.1.

      Steps to Reproduce

      1. Create a DB in mysql (8.0.40), following this document
      2. Install  confluence 9.2.1 using above DB
      3. Tail the log
      4. Move to 'Scheduled Jobs'
      5. Click 'Run' in 'Publish Daily Statistics '

      Expected Results

      No error happens in running job of 'Publish Daily Statistics '

      Actual Results

      The below exception is thrown in the atlassian-confluence.log file:

      2025-04-08 08:23:09,601 WARN [pool-8-thread-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions SQL Error: 0, SQLState: S1000
 -- url: /setup/finishsetup.action | userName: anonymous | action: finishsetup | referer: http://xxx:18190/setup/setupadministrator-start.action | traceId: 41d3af64ab0c00d2
2025-04-08 08:23:09,601 ERROR [pool-8-thread-1] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Operation not allowed after ResultSet closed
 -- url: /setup/finishsetup.action | userName: anonymous | action: finishsetup | referer: http://xxx:18190/setup/setupadministrator-start.action | traceId: 41d3af64ab0c00d2

2025-04-08 08:23:09,601 ERROR [pool-8-thread-1] [plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier] getNumberOfDarkThemeUsers Error getting number of dark theme users
 -- url: /setup/finishsetup.action | userName: anonymous | action: finishsetup | referer: http://xxx:18190/setup/setupadministrator-start.action | traceId: 41d3af64ab0c00d2
org.hibernate.exception.GenericJDBCException: could not get next iterator result
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
	at org.hibernate.internal.IteratorImpl.next(IteratorImpl.java:131)
	at com.atlassian.confluence.plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier.colorModeandThemeUserCount(ConfluenceDailyStatisticsAnalyticsEventSupplier.java:108)
	at com.atlassian.confluence.plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier.getNumberOfDarkThemeUsers(ConfluenceDailyStatisticsAnalyticsEventSupplier.java:113)
	at com.atlassian.confluence.plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier.call(ConfluenceDailyStatisticsAnalyticsEventSupplier.java:267)
	at com.atlassian.confluence.plugins.periodic.event.ConfluenceDailyStatisticsAnalyticsEventSupplier.call(ConfluenceDailyStatisticsAnalyticsEventSupplier.java:40)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.sql.SQLException: Operation not allowed after ResultSet closed

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Unassigned
            Reporter:
            Rick Li
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Created:
              Updated: