SQLException: error in script file

Danny_Welch · February 8, 2010, 4:43pm

Let me start by saying thanks SO much for this fantastic product. We have thoroughly enjoyed using it and normally it just does its thing and gives us no trouble at all; however, just last Friday we starting getting the following error and Openfire fails to start.

2010.02.07 20:49:47 [org.jivesoftware.util.log.util.CommonsLogFactory$1.error(CommonsLogFactory.jav a:92)

] Prototype

java.sql.SQLException: error in script file line: 16005 java.io.IOException: org.hsqldb.HsqlException: invalid character encoding

at org.hsqldb.jdbc.Util.sqlException(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)

at org.hsqldb.jdbcDriver.getConnection(Unknown Source)

at org.hsqldb.jdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(DefaultConn ectionBuilder.java:39)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:159)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:102)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:44)

Here is line 16005 from the embedded-db\openfire.script file (hopefully this is the file it is referring to):

INSERT INTO OFRRDS VALUES(‘muc_traffic’,1265384189322,'004a0052006f00620069006e002c002000760065007 200730069006f006e00200030002e00310020000000000000003c0000000200000005000000004b6 c3ae0006d00750063005f006f007500740067006f0069006e0067002000200020002000200020002 00020004700410055004700450020002000200020002000200020002000200020002000200020002 00020000000000000012c00000000000000007ff8000000000000000000000000000000000000000 000000000000000000000006d00750063005f0069006e0063006f006d0069006e006700200020002 00020002000200020002000470041005500470045002000200020002000200020002000200020002 000200020002000200020000000000000012c00000000000000007ff800000000000000000000000 00000000000000000000000000000000000000041005600450052004100470045002000200020002 00020002000200020002000200020002000203fe0000000000000000000010000003c7ff80000000 0000000000000000000000000002c000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 000000000000000000000000000007ff800000000000000000000000000000000002c00000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000410056004 5005200410047004500200020002000200020002000200020002000200020002000203fe00000000 000000000001e0000003000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000041005600450052004100470045002000200020002 00020002000200020002000200020002000203fe0000000000000000005a00000072100000000000 0000000000000000000000000008e7ff800000000000000000000000000003f46c16c16c16c17000 00000000000000000000000000000000000000000000000000000000000003f81111111111111000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000003fb9c71c71c71c72000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000000000000000000000000 00000000000000000000000000000000000000000000000000000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000000000007ff80000000000007ff80000000000007ff 80000000000007ff80000000000007ff80000

LG1 · February 8, 2010, 5:24pm

Hi,

you may want to try to append ') to the line or delete it completely. You’ll lose some MUC history information.

Did you server crash or did you have a full filesystem?

LG

Danny_Welch · February 8, 2010, 6:35pm

LG, thanks for the response. I went to add the ') to the line and it is already there. It appears that the line was too long for the copy buffer?

To answer your question, the server did crash (power issue).

Is the data in this line for some type of historical message tracking? If so, would it hurt to clear it out to just INSERT INTO OFRRDS VALUES(‘muc_traffic’,1265384189322,’’) or will that blow something else up?

Danny_Welch · February 9, 2010, 2:05pm

I decided to go ahead and try it and the server is up and running again. I’m not sure what I lost exactly, but it obviously was something that we weren’t using anyway… ; )

LG1 · February 10, 2010, 5:52pm

Hi,

a graph on https://example.com/plugins/monitoring/stats-dashboard.jsp should be affected or setted to zero.

LG