powered by Jive Software

Openfire 3.9.3 Takes 2 hours to start

Windows 2012

Oracle DB

Openfire 3.9.3

When restarting the server, or just the Openfire Windows service, it take 2 hours before the service fully starts. In the info log I see the following:

2017.07.16 01:03:04 org.jivesoftware.openfire.pubsub.PubSubModule - Publish-Subscribe domain: pubsub.server

2017.07.16 01:03:05 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain1

2017.07.16 01:03:21 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain2

2017.07.16 01:10:56 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain3

2017.07.16 01:19:00 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain4

2017.07.16 01:19:20 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain5

2017.07.16 01:19:36 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain6

2017.07.16 01:19:44 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain7

2017.07.16 01:20:35 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain8

2017.07.16 01:31:16 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain9

2017.07.16 01:32:52 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain10

2017.07.16 01:38:52 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain11

2017.07.16 01:40:08 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain12

2017.07.16 01:54:30 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain13

2017.07.16 03:14:45 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain14

2017.07.16 03:21:26 org.jivesoftware.openfire.muc.spi.MultiUserChatServiceImpl - Multi User Chat domain: domain15

2017.07.16 03:22:41 org.jivesoftware.openfire.XMPPServer - Openfire 3.9.3 [Jul 16, 2017 3:22:41 AM]

2017.07.16 03:22:42 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Favicon Misses

2017.07.16 03:22:42 org.jivesoftware.util.cache.CacheFactory - Created cache [org.jivesoftware.util.cache.DefaultLocalCacheStrategy] for Favicon Hits

2017.07.16 03:22:43 org.jivesoftware.openfire.container.AdminConsolePlugin - Admin console listening at:

http://server:9090

https://server:9091

When restarting is there a reload of Chat Room messages cache setting that might be causing the delay?

Likely epic slowness loading information from the database regarding the MUC. Are you able to monitor the database to see what SQL statements it is running during Openfire startup?

I think you need to upgrade the Openfire server to the latest version.

You might want to test it first on a spare PC/Server.