579425 - Users with migrated Live Chat accounts can't connect

Status: RESOLVED FIXED

(mozilla.org Graveyard :: Server Operations, task)

Description

[Matthew Middleton (:zzxc)]

Openfire's access to the support.mozilla.com database is timing out, preventing everyone who has a new or migrated Live Chat account from helping.  (This includes nearly all active accounts, but I can still sign in through one of the remaining native accounts.)

From the server log:

** BEGIN NESTED EXCEPTION **

java.net.ConnectException
MESSAGE: Connection timed out

STACKTRACE:

java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:520)
at java.net.Socket.connect(Socket.java:470)
at java.net.Socket.<init>(Socket.java:367)
at java.net.Socket.<init>(Socket.java:209)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:271)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.mozilla.support.sumologin.SumoGroupProvider.getGroup(SumoGroupProvider.java:96)
at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:278)
at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:257)
at org.jivesoftware.xmpp.workgroup.RequestQueue.getGroupObjects(RequestQueue.java:467)
at org.jivesoftware.xmpp.workgroup.RequestQueue.isMember(RequestQueue.java:480)
at org.jivesoftware.xmpp.workgroup.AgentManager.isInWorkgroup(AgentManager.java:223)
at org.jivesoftware.xmpp.workgroup.WorkgroupPresence.agentToWorkgroup(WorkgroupPresence.java:274)
at org.jivesoftware.xmpp.workgroup.WorkgroupPresence.process(WorkgroupPresence.java:140)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager.handleOutdatePresence(WorkgroupManager.java:965)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager.access$000(WorkgroupManager.java:64)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager$1.run(WorkgroupManager.java:181)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.mozilla.support.sumologin.SumoGroupProvider.getGroup(SumoGroupProvider.java:96)
at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:278)
at org.jivesoftware.openfire.group.GroupManager.getGroup(GroupManager.java:257)
at org.jivesoftware.xmpp.workgroup.RequestQueue.getGroupObjects(RequestQueue.java:467)
at org.jivesoftware.xmpp.workgroup.RequestQueue.isMember(RequestQueue.java:480)
at org.jivesoftware.xmpp.workgroup.AgentManager.isInWorkgroup(AgentManager.java:223)
at org.jivesoftware.xmpp.workgroup.WorkgroupPresence.agentToWorkgroup(WorkgroupPresence.java:274)
at org.jivesoftware.xmpp.workgroup.WorkgroupPresence.process(WorkgroupPresence.java:140)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager.handleOutdatePresence(WorkgroupManager.java:965)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager.access$000(WorkgroupManager.java:64)
at org.jivesoftware.xmpp.workgroup.WorkgroupManager$1.run(WorkgroupManager.java:181)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)

Comment 1

[Dave Miller [:justdave]]

openfire's java process was hung.  Had to kill -9 it and restart.  Folks on irc say it's working now.