powered by Jive Software

Dynamic SQL Error PubSubPersistenceManager ofPubsubItem:FreeBSD 9.1 + DB FireBird 2.5.2 + jdbc Jaybird-2.2.2 + OpenFire 3.8.1

There are errors, describe them more low.

Would like to receive recommendations about their correction.

The additional information (a configuration, scripts and other) - I will give.

My native language - Russian.

I will use therefore electronic transfer.

In advance I apologise for inconveniences.

===================================

Has established OpenFire.

FreeBSD 9.1-RELEASE i386

DB FireBird 2.5.2

java openjdk-7.17.02_2

jdbc driver Jaybird-2.2.2

OpenFire 3.8.1

Has created a DB.

Has edited openfire.xml

Started.

Has disconnected not the plug-ins necessary to me.

Has left the following:


Broadcast

Client Control

Content Filter

DB Access

Hazelcast Clustering Plugin

Just married

Load Statistic

Monitoring Service

Packet Filter

Presence Service

Search

Subscription

User Import Export


Has created two users.

Has got them in one group.

Has cleared broad gulls.

In the specified configuration has faced not clear problem.

For 12 hours per a file error.log has got 107.5 K messages

About problems with the table ofPubsubItem.


ofPubsubItem

at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.readStatusVector (AbstractJavaGDSImpl.java:2214)

at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.receiveResponse (AbstractJavaGDSImpl.java:2164)

at org.firebirdsql.gds.impl.wire. AbstractJavaGDSImpl.iscDsqlPrepare (AbstractJavaGDSImpl.java:1551)

at org.firebirdsql.gds.impl. GDSHelper.prepareStatement (GDSHelper.java:190)

at org.firebirdsql.jdbc. AbstractStatement.prepareFixedStatement (AbstractStatement.java:1440)

at org.firebirdsql.jdbc. AbstractPreparedStatement.prepareFixedStatement (AbstractPreparedStatement.java:1281)

at org.firebirdsql.jdbc. AbstractPreparedStatement. (AbstractPreparedStatement.java:137)

… 20 more

2013.04.09 20:45:56 org.jivesoftware.openfire.pubsub. PubSubPersistenceManager - GDS Exception. 335544569. Dynamic SQL Error

SQL error code =-104

Token unknown - line 1, column 8

ofPubsubItem

org.firebirdsql.jdbc. FBSQLException: GDS Exception. 335544569. Dynamic SQL Error

SQL error code =-104

Token unknown - line 1, column 8


I am incidentally connected by the client.

It “Miranda IM” or “Miranda NG”.

Last “stable”.

Other errors I do not observe.