Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-24561

Startup fails with VIEWS in MySQL database

    XMLWordPrintable

Details

    Description

      Confluence startup fails with error messages in catalina.out similar to:

      2012-02-02 08:00:18,672 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 4.1.3 (build #3129)
      02.02.2012 08:02:17 org.apache.catalina.core.StandardContext start
      SCHWERWIEGEND: Error listenerStart
      02.02.2012 08:02:17 org.apache.catalina.core.StandardContext start
      SCHWERWIEGEND: Context [] startup failed due to previous errors
      
      [...]
      
      log4j:ERROR Error occured while converting date.
      java.lang.NullPointerException
      

      This seems to be caused by additional VIEWs created by us for customized features. During startup Confluence 4.x - different to previous versions - runs the statement

      mysql> SELECT distinct ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = "confluence";
      +--------+
      | ENGINE |
      +--------+
      | InnoDB |
      | NULL   |
      +--------+
      

      against the database and their seems to be no suitable error handling for the NULL value in the result set (VIEWs have this in the ENGINE and some more other fields in that table).

      Attachments

        Activity

          People

            akazatchkov Anatoli
            0038f8321e0c Stefan Kahlhöfer (Novatec)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: