0 Replies Latest reply on Jan 16, 2017 2:41 AM by Eduardo Steffen

    Error database after Update 4.0.4 to 4.1.1

    Eduardo Steffen

      Hi,

       

      After update version 4.0.4 to 4.1.1 can`t start openfire.

       

      See the error below. Can someone help?

       

       

      Database setup or configuration error: Please verrrEfoy  iynoiucri adnadtoaa ios es eberstviindgost. raPnodr  cf eahc kvorvte ehi flirqouseg/oe s rrqaruivos de ool rpga.lra mais infomoarç õgfes

      i.

      le for detailed error messages.

      java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]

        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:734)

        at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:448)

        at org.jivesoftware.openfire.XMPPServer.<init>(XMPPServer.java:169)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

        at java.lang.reflect.Constructor.newInstance(Unknown Source)

        at java.lang.Class.newInstance(Unknown Source)

        at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:105)

        at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:65)

        at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:101)

        at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:26)

      Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: error in script file line: 1 Unexpected token UNIQUE, requires COLLATION in statement [SET DATABASE UNIQUE]

        at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:156)

        at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:724)

        ... 16 more

      Server halted