[Openfire-br] Help Urgente

Marcelo Terres mhterres at gmail.com
Wed Sep 11 10:43:54 BRT 2013 

Pela info:

java.sql.SQLException: Couldn't get connection because we are at maximum
connection count (25/25) and there are none available


Você esgotou a quantidade de conexões simultâneas ao DB. Nunca vi isso
acontecer. :-/

Você pode editar o arquivo openfire.xml e alterar o parâmetro na tag:

      <maxConnections>25</maxConnections>


Tente colocar 50 e veja como fica.

No console admin do Openfire, na opção Banco de dados tu pode ativar as
estatísticas de uso do banco e ver informações sobre o mesmo.

[]s


Marcelo H. Terres
mhterres at gmail.com
http://mundoopensource.blogspot.com
http://biertasters.blogspot.com
http://twitter.com/mhterres


On Wed, Sep 11, 2013 at 10:33 AM, Rui Ornellas Junior <ruiornellas at gmail.com
> wrote:

> Pessoal bom dia,
>
> Ja um tempo estou procurando uma solução para o meu problema no meu
> servidor de OpenFire, eu estou com o seguinte problema.... eu possuo meu
> OpenFire integrado ao meu Active Directory, e chega uma hora do dia e quem
> esta conectado ao serviço do openfire permanece e quem não esta não
> consegue conexão e depois de uns 10 min todos param de enviar mensagens. Eu
> estou descabelando aqui e revirei os logs do OpenFire e encontrei essas
> mensagens no log do OpenFire ....
> Banco de dados do openfire é interno mesmo, não criei instancia em mysql.
>
> Dados coletados do info.log
>
> 2013.09.10 11:07:28 org.jivesoftware.database.DbConnectionManager -
> Unable to get a connection from the database pool (attempt 0 out of 10).
> java.sql.SQLException: Couldn't get connection because we are at maximum
> connection count (25/25) and there are none available
>         at
> org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
>         at
> org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152)
>         at
> org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
>         at java.sql.DriverManager.getConnection(Unknown Source)
>         at java.sql.DriverManager.getConnection(Unknown Source)
>         at
> org.jivesoftware.database.EmbeddedConnectionProvider.getConnection(EmbeddedConnectionProvider.java:61)
>         at
> org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:124)
>         at
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackend.<init>(RrdSqlBackend.java:110)
>         at
> org.jivesoftware.openfire.reporting.stats.RrdSqlBackendFactory.open(RrdSqlBackendFactory.java:36)
>         at org.jrobin.core.RrdDb.<init>(Unknown Source)
>         at org.jrobin.core.RrdDb.<init>(Unknown Source)
>         at
> org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:361)
>         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)
>
>
> Dados coletados do error.log
>
> 2013.09.11 09:54:31 org.jivesoftware.openfire.handler.IQHandler - Erro
> interno do servidor
> java.lang.NullPointerException
>         at java.util.regex.Matcher.quoteReplacement(Unknown Source)
>         at
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:540)
>         at
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.treeWalk(LdapVCardProvider.java:544)
>         at
> org.jivesoftware.openfire.ldap.LdapVCardProvider$VCard.getVCard(LdapVCardProvider.java:521)
>         at
> org.jivesoftware.openfire.ldap.LdapVCardProvider.loadVCard(LdapVCardProvider.java:234)
>         at
> org.jivesoftware.openfire.vcard.VCardManager.getOrLoadVCard(VCardManager.java:239)
>         at
> org.jivesoftware.openfire.vcard.VCardManager.getVCard(VCardManager.java:232)
>         at
> org.jivesoftware.openfire.handler.IQvCardHandler.handleIQ(IQvCardHandler.java:120)
>         at
> org.jivesoftware.openfire.handler.IQHandler.process(IQHandler.java:65)
>         at org.jivesoftware.openfire.IQRouter.handle(IQRouter.java:372)
>         at org.jivesoftware.openfire.IQRouter.route(IQRouter.java:121)
>         at
> org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
>         at
> org.jivesoftware.openfire.net.StanzaHandler.processIQ(StanzaHandler.java:337)
>         at
> org.jivesoftware.openfire.net.ClientStanzaHandler.processIQ(ClientStanzaHandler.java:93)
>         at
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:302)
>         at
> org.jivesoftware.openfire.net.StanzaHandler.process(StanzaHandler.java:194)
>         at
> org.jivesoftware.openfire.nio.ConnectionHandler.messageReceived(ConnectionHandler.java:169)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain$TailFilter.messageReceived(AbstractIoFilterChain.java:570)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
>         at
> org.apache.mina.common.IoFilterAdapter.messageReceived(IoFilterAdapter.java:80)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
>         at
> org.apache.mina.filter.codec.support.SimpleProtocolDecoderOutput.flush(SimpleProtocolDecoderOutput.java:58)
>         at
> org.apache.mina.filter.codec.ProtocolCodecFilter.messageReceived(ProtocolCodecFilter.java:185)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.callNextMessageReceived(AbstractIoFilterChain.java:299)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain.access$1100(AbstractIoFilterChain.java:53)
>         at
> org.apache.mina.common.support.AbstractIoFilterChain$EntryImpl$1.messageReceived(AbstractIoFilterChain.java:648)
>         at
> org.apache.mina.filter.executor.ExecutorFilter.processEvent(ExecutorFilter.java:239)
>         at
> org.apache.mina.filter.executor.ExecutorFilter$ProcessEventsRunnable.run(ExecutorFilter.java:283)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>         at
> org.apache.mina.util.NamePreservingRunnable.run(NamePreservingRunnable.java:51)
>         at java.lang.Thread.run(Unknown Source)
>
> Tipo de implementação do OPENFIRE
>
>
> http://andreysmith.wordpress.com/2010/04/05/openfire-integrando-com-o-active-directory/
>
>
> Ambiente
>
> Versão e Fabricante da JVM: 1.6.0_24 Sun Microsystems Inc. -- Java
> HotSpot(TM) Server VM Servidor de Aplicação:jetty/7.0.2-SNAPSHOT Host
> Name:servidor SO / Hardware:Linux / i386 Idioma / Fuso Horário:pt_BR /
> Fuso horário de Brasília (-3 GMT) Memória do Java
>  791.59 MB of 910.25 MB (87.0%) used
>
>
> _______________________________________________
> Openfire-br mailing list
> Openfire-br at listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/openfire-br
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listas.softwarelivre.org/pipermail/openfire-br/attachments/20130911/4975b2e2/attachment-0001.html>

More information about the Openfire-br mailing list