Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1247

Monitoring plugin database script fails

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.1.0
    • Fix Version/s: 4.1.0
    • Component/s: Plugins
    • Labels:
      None

      Description

      On a fresh install of Openfire, building and loading the Monitoring plugin results in this error:

      2016.12.19 16:50:41 ERROR [pool-4-thread-2]: org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
       CREATE TABLE ofRRDs (    id            VARCHAR(100)        NOT NULL,    updatedDate   BIGINT              NOT NULL,    bytes         VARBINARY           NULL,    CONSTRAINT ofRRDs_pk PRIMARY KEY (id) );
      2016.12.19 16:50:41 ERROR [pool-4-thread-2]: org.jivesoftware.database.SchemaManager - length must be specified in type definition: VARBINARY in statement [ CREATE TABLE ofRRDs (    id            VARCHAR(
      java.sql.SQLSyntaxErrorException: length must be specified in type definition: VARBINARY in statement [ CREATE TABLE ofRRDs (    id            VARCHAR(100)        NOT NULL,    updatedDate   BIGINT        
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
              at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
              at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
              at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
              at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:498)
              at org.logicalcobwebs.proxool.WrappedConnection.invoke(WrappedConnection.java:162)
              at org.logicalcobwebs.proxool.WrappedConnection.intercept(WrappedConnection.java:87)
              at $java.sql.Wrapper$$EnhancerByProxool$$6cceff2.prepareStatement(<generated>)
              at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:379)
              at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:237)
              at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:129)
              at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java:381)
              at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:276)
              at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:264)
              at java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at java.lang.Thread.run(Thread.java:745)
      Caused by: org.hsqldb.HsqlException: length must be specified in type definition: VARBINARY
              at org.hsqldb.error.Error.error(Unknown Source)
              at org.hsqldb.error.Error.error(Unknown Source)
              at org.hsqldb.ParserDQL.readTypeDefinition(Unknown Source)
              at org.hsqldb.ParserTable.readColumnDefinitionOrNull(Unknown Source)
              at org.hsqldb.ParserTable.readTableContentsSource(Unknown Source)
              at org.hsqldb.ParserTable.compileCreateTableBody(Unknown Source)
              at org.hsqldb.ParserTable.compileCreateTable(Unknown Source)
              at org.hsqldb.ParserDDL.compileCreate(Unknown Source)
              at org.hsqldb.ParserCommand.compilePart(Unknown Source)
              at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
              at org.hsqldb.Session.compileStatement(Unknown Source)
              at org.hsqldb.StatementManager.compile(Unknown Source)
              at org.hsqldb.Session.execute(Unknown Source)
              ... 18 more
      2016.12.19 16:50:41 ERROR [pool-4-thread-2]: org.jivesoftware.openfire.container.PluginManager - Error while loading plugin 'monitoring': Database update failed. Please manually upgrade your database.
      

        Attachments

          Activity

            People

            Assignee:
            akrherz Daryl Herzmann
            Reporter:
            guus Guus der Kinderen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: