Good day!
Debian 9+Java:1.8.0_312 Oracle Corporation – OpenJDK 64-Bit Server VM + MySQL + OpenFire + Spark + MirandaIM
once a few days clients are falling off. Access to OpenFire works. Checked ports work.
message error с spark
org.jivesoftware.smack.SmackException$NoResponseException: No response received within reply timeout. Timeout was 10000ms (~10s). While waiting for establishing TLS
at org.jivesoftware.smack.SmackException$NoResponseException.newWith(SmackException.java:93)
at org.jivesoftware.smack.SynchronizationPoint.checkForResponse(SynchronizationPoint.java:317)
at org.jivesoftware.smack.SynchronizationPoint.checkIfSuccessOrWait(SynchronizationPoint.java:160)
at org.jivesoftware.smack.SynchronizationPoint.checkIfSuccessOrWaitOrThrow(SynchronizationPoint.java:131)
at org.jivesoftware.smack.tcp.XMPPTCPConnection.connectInternal(XMPPTCPConnection.java:977)
at org.jivesoftware.smack.AbstractXMPPConnection.connect(AbstractXMPPConnection.java:435)
at org.jivesoftware.LoginDialog$LoginPanel.login(LoginDialog.java:1108)
at org.jivesoftware.LoginDialog$LoginPanel.access$900(LoginDialog.java:370)
at org.jivesoftware.LoginDialog$LoginPanel$3.construct(LoginDialog.java:910)
at org.jivesoftware.spark.util.SwingWorker.lambda$new$1(SwingWorker.java:139)
at java.lang.Thread.run(Unknown Source)
openfire restart good
var\log\openfire\all.log
2022.01.18 12:05:04 WARN [socket_c2s-thread-4]: org.jivesoftware.util.cache.DefaultCache - Cache Roster was full, shrunk to 90% in 0ms.
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.tcp.XMPPTCPConnection.access$1000(XMPPTCPConnection.java:130)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.tcp.XMPPTCPConnection$PacketReader.parsePackets(XMPPTCPConnection.java:969)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.tcp.XMPPTCPConnection$PacketReader.access$700(XMPPTCPConnection.java:913)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.tcp.XMPPTCPConnection$PacketReader$1.run(XMPPTCPConnection.java:936)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at java.lang.Thread.run(Thread.java:748)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - WARNING: [35] org.jivesoftware.smack.util.PacketParserUtils.parsePresence: Failed to parse extension element in Presence stanza: PresenceBuilder(from='suhorukovmv@pmprnd-openfire.pmprnd.com/Miranda' to='jvb@pmprnd-openfire.pmprnd.com' language='ru-RU' type='available' priority='0')
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - java.io.IOException: Caps element with missing attributes. Attributes: hash=null version=0.9.17.2 node=http://miranda-im.org/caps
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smackx.caps.provider.CapsExtensionProvider.parse(CapsExtensionProvider.java:56)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smackx.caps.provider.CapsExtensionProvider.parse(CapsExtensionProvider.java:29)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.provider.Provider.parse(Provider.java:53)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.util.PacketParserUtils.parseExtensionElement(PacketParserUtils.java:834)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.util.PacketParserUtils.parsePresence(PacketParserUtils.java:477)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.util.PacketParserUtils.parseStanza(PacketParserUtils.java:115)
2022.01.18 12:05:04 INFO [Thread-19]: org.jivesoftware.openfire.plugin.ofmeet.JitsiJvbWrapper - at org.jivesoftware.smack.AbstractXMPPConnection.parseAndProcessStanza(AbstractXMPPConnection.java:1457)
Installed
Avatar Resizer VER 1.0.1
Broadcast VER 1.9.2
Certificate Manager VER 1.1.0
Client Control VER 2.1.7
Draw-IO 0.01
External Service Discovery 1.0.1
JSXC VER 4.3.1 Release 1
Monitoring Service VER 2.2.1
MUC Service Discovery Extensions VER 1.0.0
Pade VER 1.5.2
Search VER 1.7.3
XML Debugger Plugin VER 1.7.5
For the second time per day, connected to customers. Restarted service openfire
After restarting the service in the ERROR log, messages appeared
|line||
6146|at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) ~[jetty-server-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) [jetty-server-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) [jetty-server-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) [jetty-server-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-io-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) [jetty-util-9.4.35.v20201120.jar:9.4.35.v20201120]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022.01.18 15:27:25 org.jivesoftware.database.SchemaManager - SchemaManager: Failed to execute SQL:
ALTER TABLE ofMessageArchive ADD COLUMN isPMforJID VARCHAR(255) NULL;
2022.01.18 15:27:25 org.jivesoftware.database.SchemaManager - Duplicate column name ‘isPMforJID’
java.sql.SQLSyntaxErrorException: Duplicate column name ‘isPMforJID’
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.21.jar:8.0.21]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175) ~[commons-dbcp2-2.6.0.jar:2.6.0]
at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175) ~[commons-dbcp2-2.6.0.jar:2.6.0]
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:388) ~[xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:285) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.database.SchemaManager.checkPluginSchema(SchemaManager.java:129) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java:657) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:375) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:363) [xmppserver-4.6.7.jar:4.6.7]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]
2022.01.18 15:27:25 org.jivesoftware.openfire.container.PluginManager - Error while loading plugin ‘monitoring’: Ошибка обновления базы данных. Обновите свою базу данных вручную.
2022.01.18 15:27:29 org.jivesoftware.openfire.plugin.ofmeet.JitsiJicofoWrapper - Cannot create MUC room
org.jivesoftware.openfire.muc.NotAllowedException: null
at org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl.getChatRoom(MultiUserChatServiceImpl.java:790) ~[xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.plugin.ofmeet.JitsiJicofoWrapper.initialize(JitsiJicofoWrapper.java:170) [pade-1.5.2.jar!/:?]
at org.jivesoftware.openfire.plugin.ofmeet.OfMeetPlugin.initializePlugin(OfMeetPlugin.java:207) [pade-1.5.2.jar!/:?]
at uk.ifsoft.openfire.plugins.pade.PadePlugin.initializePlugin(PadePlugin.java:183) [pade-1.5.2.jar!/:?]
at org.jivesoftware.openfire.container.PluginManager.loadPlugin(PluginManager.java:683) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:375) [xmppserver-4.6.7.jar:4.6.7]
at org.jivesoftware.openfire.container.PluginMonitor$MonitorTask$4.call(PluginMonitor.java:363) [xmppserver-4.6.7.jar:4.6.7]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_312]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_312]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_312]|