Openfire 3.9.3 Takes 2 hours to start

Openfire Openfire Support
1

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?

2

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?

3

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.