powered by Jive Software

Dirty shutdown, errors upon restarting

So, I can’t make much out of the error I’m getting back as I try and start the server, but the only unique/memorable/intelligable bit is:

“java.sql.SQLException: error in script file line: 218 org.hsqldb.HsqlException: error in script file: ( 1 . 2 . 8 4 0 . 1 1 3 5 5 6 . 1 . 5 . 3 6 N A M E ’ v o l u m e ’ A U X ( m a i l R e c i p i e n t $ m s R T C S I P - E n t e r p r i s e S e r v e r S e t t i n g s $ p o s i x G r o u p $ m s R T C S I P - E n t e r p r i s e M e d i a t i o n S e r v e r S e t t i n g s $ i p H o s t $ m s R T C S I P - S e a r c h $ m s R T C S I P - U n i f i e d C o m m u n i c a t i o n s $ m s R T C S I P - E n t e r p r i s e M C U S e t t i n g s $ s a m D o m a i n $ m s R T C S I P - M e e t i n g $ m s R T C S I P - A r c h i v e $ d y n a m i c O b j e c t $ s h a d o w A c c o u n t $ d o m a i n R e l a t e d O b j e c t $ i e e e 8 0 2 D e v i c e $ m s R T C S I P - F e d e r a t i o n $ m s R T C S I P - W e b C o m p o n e n t S e t t i n g s $ p o s i x A c c o u n t $ b o o t a b l e D e v i c e $ m s R T C S I P - R e g i s t r a r $ s i m p l e S e c u r i t y O b j e c t $ s e c u r i t y P r i n c i p a l $ m s D S - C l o u d E x t e n s i o n s $ s a m D o m a i n B a s e ) )
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:156)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:689)
… 16 more”

Later on down the line it just says “server halted”.

This follows what I’ll call a “dirty shutdown” of the server. What if anything should be my next move?

it sounds like your HSQLDB data files have been corrupted. There are some tips at http://www.hsqldb.org/doc/1.8/guide/apc.html but you may be better off simply starting from scratch.

If not, simply restore from your most recent backup.

Greg

So, if I may ask a pedestrian question, where is that DB located by default?

I’ll have backups going back before the event which caused the shutdown.

C:\Program Files (x86)\Openfire\embedded-db\ ?

seems to contain “openfire.properties” and “openfire.script”

Nevermind. figured it out. Pulled a backup from an hour before the event. Seems to have solved the problem.