[JBoss Portal] - SQL Exception using PostgreSQL
by xevi
When I start jboss server JBoss Portal 2.7.0 + JBoss AS 4.2.3 (only one zip) configured with PostgreSQL, I allways get the same PSQLException:
11:20:18,153 WARN [ServiceController] Problem starting service jboss.mq:service=PersistenceManager
org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (org.postgresql.util.PSQLException: ERROR: syntax error at or near "TXID")
at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:489)
at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1842)
I think "TXID" must be a reserved word in Postgresql.
Describe your environment:
JBoss Portal Version 2.7.0 (jboss-portal-2.7.0.GA-bundled.zip)
Did you get Portal from Subversion? or download it? I download it
JBoss AS Version 4.2.3
Database Vendor and Version Postgresql 8.3.5
JDBC Connector and Version JDBC4 Postgresql Driver, Version 8.3-604
OS Platform Ubuntu Linux
JVM:
- xevi@chaos:~/apps/jboss-portal-2.7.0.GA/bin$ java -version
- java version "1.6.0_11"
- Java(TM) SE Runtime Environment (build 1.6.0_11-b03)
- Java HotSpot(TM) Client VM (build 11.0-b16, mixed mode, sharing)
I test it using a 1.5 JVM and I the problem was the same. The problem may be in the database lebel, not in java virtual machine.
Whem I log in PostgreSQL, I can see the following tables:
xevi-# \dt
List of relations
Schema | Name | Type | Owner
--------+-------------------+-------+-------
public | hilosequences | table | xevi
public | jms_roles | table | xevi
public | jms_subscriptions | table | xevi
public | jms_users | table | xevi
public | timers | table | xevi
I am evaluating JBossPortal with hsqldb (default database) and I want use PostgreSQL in production. Everything is perfect except this problem with my favourite database.
Regards,
Xevi.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4199710#4199710
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4199710
17 years, 3 months
[JBoss Messaging] - Re: Timeout for Disconnected JBM Client
by rtm333
One further thought on this issue. It might have not been evident from the stack trace above, that the publishing thread is running within the JBoss AS (and hence the JMS server) process itself.
It seems this publishing thread is directly writing through to the subscribers and blocking with a timeout of 15 mins in some cases when a subscribing client has suddenly died. This also locks out all further publishing threads for the whole timeout period as these are synchronized on the JMS session and waiting for the ongoing call to publish to terminate.
Does this ring any bells on how to avoid the long timeout? Do "normal" timeouts not take effect due to the in-process publishing?
Or, do you think it to be promising to route the generated messages to an external process first, that in turn publishes them to the JMS server? This approach would avoid the in-process publishing.
Thanks a lot, again, for your support.
Ralf Torsten
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4199703#4199703
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4199703
17 years, 3 months