David
Thanks for the quick response. I had to drive 2 hours to the customer site,
so I didn't have the log file for my earlier email.
At any rate, here is the underlying problem:
Message: Unable to esablish a connection with the database. (Unable to
acquire a new connection from the pool)
---- stack
trace ---------------------------------------------------------------
org.ofbiz.entity.GenericDataSourceException: Unable to esablish a connection
with the database. (Unable to acquire a new connection from the pool)
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:265)
...
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConne
ctionFactory.java:38)
org.apache.commons.dbcp.managed.LocalXAConnectionFactory.createConnection(Lo
calXAConnectionFactory.java:62)
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnect
ionFactory.java:294)
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:771)
org.apache.commons.dbcp.managed.ManagedConnection.updateTransactionStatus(Ma
nagedConnection.java:117)
... 57 more
This machine has been running there for 2 months in alpha mode. Two weeks
ago, I set it up for production as per
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide
It has been running for a week with 2 to 4 back office people testing it
(basically replicating what they do on their legacy system).
This is running Postgres 8.3. I never saw a problem like this running
Minerva and am wondering if that is not the issue.
Postgres is running on the same machine as the app server (although I am
about to change that).
It is running a version of Ofbiz from Jan-Feb of this year. The errors
shown above are from using
https://localhost:8443/ordermgr/control/finalizeOrderOne happened when entering a new shipping address and another finalizing the
order. In addition, there are several other similiar errors for JobSandbox
stuff, UserLoginHistory and the like that were background tasks not reported
by a user.
I brought the machine back with me and am experimenting with it as I write
this, but I have little hope of reproducing this.
Thanks in advance, any help or advice is appreciated.
Skip
-----Original Message-----
From: David E Jones [mailto:
[hidden email]]
Sent: Tuesday, May 13, 2008 1:16 PM
To:
[hidden email]
Subject: Re: Failure in getNextSeqId operation for seqName
1. Which version or revision are you using?
2. What is in the log file before and after this (the actual error
will be there)?
-David
On May 13, 2008, at 10:49 AM, skip@thedevers wrote:
> After running a week in a production beta, I am all of a sudden
> getting a
> bunch of these for various entities:
>
> Failure in getNextSeqId operation for seqName [ContactMech]:
> java.lang.IllegalArgumentException: Could not get
>
> Failure in getNextSeqId operation for seqName [OrderStatus]:
> java.lang.IllegalArgumentException: Could not get next sequenced
>
>
> Anyone have any idea why this might be happening now? I am not on
> site and
> have to travel 2 hours to get there, so any help on what to check
> would be
> most appreciated.
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.524 / Virus Database: 269.23.16/1427 - Release Date:
> 5/11/2008
> 1:08 PM
>
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1427 - Release Date: 5/11/2008
1:08 PM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.23.16/1427 - Release Date: 5/11/2008
1:08 PM
Locked
