Thread: ojb_hl_seq table access denied

ojb_hl_seq table access denied

From
Raja Sekhar Paidi
Date:
WHEN I CONNECT THROUGH PGSQL AND RUN ANT CLEAN TEST-MAIN

ex
---
sudo -u postgres /software/arch/bin/pg_ctl -D /var/lib/pgsql/data -l /var/log/pgsql restart

ulimit -d 500000
ant clean test-main



   3.12) I get /``Sorry, too many clients''/ when trying to connect. Why?
 and says permission is denied for ojb_hl_seq table...but the table has public access...this is on alpha server...
could anybody help me out
testSimpleStoreErrororg.apache.ojb.broker.PersistenceBrokerException: ERROR: ojb_hl_seq: permission denied

org.flymine.objectstore.ObjectStoreException: org.apache.ojb.broker.PersistenceBrokerException: ERROR: ojb_hl_seq: permission denied

at org.flymine.objectstore.ojb.ObjectStoreWriterOjbImpl.delete(Unknown Source)
at org.flymine.dataloader.DataLoaderTest.tearDown(Unknown Source)
Caused by: org.apache.ojb.broker.PersistenceBrokerException: ERROR: ojb_hl_seq: permission denied

at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.getObjectByQuery(Unknown Source)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getSequence(Unknown Source)
at org.apache.ojb.broker.util.sequence.SequenceManagerHighLowImpl.getUniqueLong(Unknown Source)
at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueId(Unknown Source)
at org.apache.ojb.broker.util.sequence.AbstractSequenceManager.getUniqueValue(Unknown Source)
at org.apache.ojb.broker.util.BrokerHelper.getAutoIncrementValue(Unknown Source)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source)
at org.apache.ojb.broker.util.BrokerHelper.getKeyValues(Unknown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.getKeyValues(Unknown Source)
at org.apache.ojb.broker.accesslayer.StatementManager.bindDelete(Unknown Source)
at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeDelete(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.delete(Unknown Source)
at org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.delete(Unknown Source)
... 21 more
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: ERROR: ojb_hl_seq: permission denied

at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source)
at org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(Unknown Source)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(Unknown Source)
... 38 more
Caused by: java.sql.SQLException: ERROR: ojb_hl_seq: permission denied

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
... 44 more
2.228
testStoreWithObjectRefError