powered by Jive Software

Openfire 4.6.7 build 348185c

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)

I wonder if this is related to OF-2367. When the problem occurs, does that mean that no-one can connect anymore, until you restart the server?

If that’s the case, then disable or update the Pade plugin to a version later than 1.5.2. This problem should also be fixed in Openfire 4.7.0.

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

Update (or remove) Pade.

I tried to delete and install

And where is PADE, if this plugin is needed for audio and video conferencing

If you enable debug log How strong it will strain the server

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]|

Tell me how to manually update the MYSQL database