powered by Jive Software

After upgrade to 4.3.2 Rest api not working


#1

Hi Experts,

Recently I have upgraded openfire from 4.2.2 to 4.3.2, after that rest api for chat room creation not working.
logs

2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: sessions. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: server_bytes. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: muc_occupants. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: proxyTransferRate. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: conversations. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: muc_traffic. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:02 DEBUG [pool-monitoring99]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Stat: packet_count. Last sample: 1556779560. New sample: 1556779620
2019.05.02 10:47:33 INFO [Jetty-QTP-AdminConsole-4682]: org.jivesoftware.openfire.plugin.rest.controller.MUCRoomController - createChatRoom, global77
2019.05.02 10:47:33 INFO [Jetty-QTP-AdminConsole-4682]: org.jivesoftware.openfire.plugin.rest.controller.MUCRoomController - createRoom entry, global77
2019.05.02 10:47:33 ERROR [Jetty-QTP-AdminConsole-4682]: org.jivesoftware.openfire.plugin.rest.exceptions.RESTExceptionMapper - NotAllowedException: Could not create the channel with resource global77
2019.05.02 10:47:43 ERROR [TaskEngine-pool-78]: org.jivesoftware.openfire.pubsub.PubSubPersistenceManager - ORA-00933: SQL command not properly ended

java.sql.BatchUpdateException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10500) ~[ojdbc6.jar:11.2.0.4.0]
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:230) ~[ojdbc6.jar:11.2.0.4.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223) ~[commons-dbcp2-2.5.0.jar:2.5.0]
at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.purgeItems(PubSubPersistenceManager.java:1893) [xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.access$000(PubSubPersistenceManager.java:57) [xmppserver-4.3.2.jar:4.3.2]
at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager$2.run(PubSubPersistenceManager.java:283) [xmppserver-4.3.2.jar:4.3.2]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]

2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic sessions is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic sessions
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic server_bytes_out is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic server_bytes_out
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic muc_occupants is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic muc_occupants
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic proxyTransferRate is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic proxyTransferRate
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic conversations is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic conversations
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic muc_outgoing is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic muc_outgoing
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]
2019.05.02 10:47:46 WARN [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Sample time of 1556779620 for statistic packet_count is invalid.
2019.05.02 10:47:46 ERROR [pool-monitoring19]: org.jivesoftware.openfire.reporting.stats.StatsEngine - Error sampling for statistic packet_count
org.jrobin.core.RrdException: Bad sample timestamp 1556779620. Last update time was 1556779620, at least one second step is required
at org.jrobin.core.RrdDb.store(Unknown Source) ~[jrobin.jar!/:?]
at org.jrobin.core.Sample.update(Unknown Source) ~[jrobin.jar!/:?]
at org.jivesoftware.openfire.reporting.stats.StatsEngine$SampleTask.run(StatsEngine.java:392) [monitoring-lib.jar!/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.FutureTask.run(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_202]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_202]
at java.lang.Thread.run(Unknown Source) [?:1.8.0_202]


#2

Out of all logs only this seems to be related:

2019.05.02 10:47:33 ERROR [Jetty-QTP-AdminConsole-4682]: org.jivesoftware.openfire.plugin.rest.exceptions.RESTExceptionMapper - NotAllowedException: Could not create the channel with resource global77