Openfire 4.6.7 build 348185c

Aleksej_Opryshko · January 18, 2022, 9:24am

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)

guus · January 18, 2022, 9:46am

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.

Aleksej_Opryshko · January 18, 2022, 9:58am

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

guus · January 18, 2022, 10:00am

Update (or remove) Pade.

Aleksej_Opryshko · January 18, 2022, 10:01am

I tried to delete and install

Aleksej_Opryshko · January 18, 2022, 10:15am

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

Aleksej_Opryshko · January 18, 2022, 11:26am

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

Aleksej_Opryshko · January 18, 2022, 1:14pm

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