【问题描述】 2013.12.26 15:57:03 org.jivesoftware.openfire.xmppserver - java.sql.sqlexception: connectionmanager.getconnection() failed to obtain a connection after 11 retries. the exception from the last attempt is as follows: com.mysql.j
【问题描述】
2013.12.26 15:57:03 org.jivesoftware.openfire.xmppserver - java.sql.sqlexception: connectionmanager.getconnection() failed to obtain a connection after 11 retries. the exception from the last attempt is as follows: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown database 'openfire'
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: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown database 'openfire'
at org.jivesoftware.openfire.xmppserver.verifydatasource(xmppserver.java:770)
at org.jivesoftware.openfire.xmppserver.start(xmppserver.java:486)
at org.jivesoftware.openfire.xmppserver.(xmppserver.java:216)
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.newinstance0(unknown source)
at java.lang.class.newinstance(unknown source)
at org.jivesoftware.openfire.starter.serverstarter.start(serverstarter.java:113)
at org.jivesoftware.openfire.starter.serverstarter.main(serverstarter.java:58)
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(unknown source)
at com.exe4j.runtime.winlauncher.main(unknown source)
caused by: java.sql.sqlexception: connectionmanager.getconnection() failed to obtain a connection after 11 retries. the exception from the last attempt is as follows: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: unknown database 'openfire'
at org.jivesoftware.database.dbconnectionmanager.getconnection(dbconnectionmanager.java:151)
at org.jivesoftware.openfire.xmppserver.verifydatasource(xmppserver.java:760)
... 16 more
【解决方案】 mysql中的openfire对应数据库丢了，丢失原因未知