Openfire keeps erroring out following upgrade from 3.2.2

Steve_Davis · April 24, 2007, 8:18am

Openfire keeps getting to the state where it won’‘t let my users log in (using AD authentication), it just complains of invalid username or password. Last time it happened, I just restarted the service an I was OK (this was Thursday). Today, that doesn’'t seem to be happening.

There are lots of errors in the event log (already reported in the enterprise discussion forums last week).

I now have a dead server. Can anyone help please!

OF 3.3, Win 2003, SQL server, spark 2.5 clients, AD auth.

2007.04.23 11:20:04 [org.jivesoftware.database.SequenceManager.getNextBlock(SequenceManager.java:22 3)

]

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Can’'t start manual transaction mode because there are cloned connections.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.setAutoCommit(Unknown Source)

at org.jivesoftware.database.AbstractConnection.setAutoCommit(AbstractConnection.j ava:48)

at org.jivesoftware.database.DbConnectionManager.getTransactionConnection(DbConnec tionManager.java:118)

at org.jivesoftware.database.SequenceManager.getNextBlock(SequenceManager.java:185 )

at org.jivesoftware.database.SequenceManager.nextUniqueID(SequenceManager.java:156 )

at org.jivesoftware.database.SequenceManager.nextID(SequenceManager.java:74)

at org.jivesoftware.database.SequenceManager.nextID(SequenceManager.java:110)

at com.jivesoftware.openfire.enterprise.archive.Conversation.insertIntoDb(Conversa tion.java:448)

at com.jivesoftware.openfire.enterprise.archive.Conversation.(Conversation.java:12 1)

at com.jivesoftware.openfire.enterprise.archive.ConversationManager.processMessage (ConversationManager.java:528)

at com.jivesoftware.openfire.enterprise.archive.ArchiveInterceptor.interceptPacket (ArchiveInterceptor.java:60)

at org.jivesoftware.openfire.interceptor.InterceptorManager.invokeInterceptors(Int erceptorManager.java:227)

at org.jivesoftware.openfire.MessageRouter.route(MessageRouter.java:124)

at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:71)

at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:53)

at org.jivesoftware.openfire.component.InternalComponentManager.sendPacket(Interna lComponentManager.java:186)

at org.jivesoftware.openfire.gateway.BaseTransport.sendPacket(BaseTransport.java:1 495)

at org.jivesoftware.openfire.gateway.BaseTransport.sendMessage(BaseTransport.java: 1522)

at org.jivesoftware.openfire.gateway.BaseTransport.sendMessage(BaseTransport.java: 1533)

at org.jivesoftware.openfire.gateway.protocols.msn.MSNListener.instantMessageRecei ved(MSNListener.java:80)

at net.sf.jml.impl.AbstractMessenger.fireInstantMessageReceived(AbstractMessenger. java:165)

at net.sf.jml.message.MsnInstantMessage.messageReceived(MsnInstantMessage.java:251 )

at net.sf.jml.message.IncomingMimeMessage.messageReceived(IncomingMimeMessage.java :55)

at net.sf.jml.protocol.MsnSession$1.messageReceived(MsnSession.java:105)

at net.sf.cindy.impl.AbstractSession$6.doRun(AbstractSession.java:341)

at net.sf.cindy.impl.AbstractSession$DispatchObject.run(AbstractSession.java:395)

at net.sf.cindy.impl.SimpleDispatcher.dispatch(SimpleDispatcher.java:35)

at net.sf.cindy.impl.AbstractSession.dispatch(AbstractSession.java:249)

at net.sf.cindy.impl.AbstractSession.dispatchMessageReceived(AbstractSession.java: 335)

at net.sf.cindy.impl.StreamChannelSession.recognizeMessageAndDispatch(StreamChanne lSession.java:77)

at net.sf.cindy.impl.StreamChannelSession.readFromChannel(StreamChannelSession.jav a:53)

at net.sf.cindy.impl.ChannelSession.onReadable(ChannelSession.java:212)

at net.sf.cindy.impl.ChannelSession.onEvent(ChannelSession.java:134)

at net.sf.cindy.impl.SocketSession.onEvent(SocketSession.java:119)

at net.sf.cindy.impl.SimpleEventGenerator.processKey(SimpleEventGenerator.java:212 )

at net.sf.cindy.impl.SimpleEventGenerator.run(SimpleEventGenerator.java:192)

at net.sf.cindy.impl.SimpleEventGenerator.access$000(SimpleEventGenerator.java:54)

at net.sf.cindy.impl.SimpleEventGenerator$1.run(SimpleEventGenerator.java:115)

2007.04.23 11:20:04 [org.jivesoftware.database.SequenceManager.getNextBlock(SequenceManager.java:23 9)

] WARNING: failed to obtain next ID block due to thread contention. Trying again…

2007.04.23 11:25:46 [com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations (ArchiveIndexer.java:510)

]

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]ResultSet can not re-read row data for column 2.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown Source)

at com.microsoft.jdbc.base.BaseResultSet.getLong(Unknown Source)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations( ArchiveIndexer.java:486)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.updateIndex(Archive Indexer.java:276)

at com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer$2.run(ArchiveIndexe r.java:153)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2007.04.23 11:40:46 [com.jivesoftware.openfire.enterprise.archive.ArchiveIndexer.indexConversations (ArchiveIndexer.java:510)