JobSandbox: A lock could not be obtained within the time requested

[Scott Gray]

I got a whole pile of these while trying to run the
createTestSalesOrders service from webtools, anything worth worrying
about?

Exception occured in updateByCondition (SQL Exception while executing
the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
STATUS_ID = ? WHERE ((RUN_TIME <= '2007-10-27 00:44:51.468' AND
START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
(A lock could not be obtained within the time requested))]. Rolling
back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition

Thanks
Scott

[David E Jones]

Actually, that's a little scary... we've seen this with certain  
clients recently

What is your setup like where this is happening? (ofbiz revision, os/
database/etc)

Also, is anyone else seeing this? Other stories might be helpful to  
track it down (if there is anything we can do about it in OFBiz, I  
have my suspicions about possible causes, but I don't want to bias  
the discussion yet).

-David


On Oct 26, 2007, at 6:30 AM, Scott Gray wrote:

> I got a whole pile of these while trying to run the
> createTestSalesOrders service from webtools, anything worth worrying
> about?
>
> Exception occured in updateByCondition (SQL Exception while executing
> the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> STATUS_ID = ? WHERE ((RUN_TIME <= '2007-10-27 00:44:51.468' AND
> START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
> RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
> (A lock could not be obtained within the time requested))]. Rolling
> back transaction.
> Exception: org.ofbiz.entity.GenericDataSourceException
> Message: Generic Entity Exception occured in updateByCondition
>
> Thanks
> Scott

[Scott Gray]

Hi David

Revision is 588538 about 20 hours old, os is windows XP sp2, db is
derby.  It's all just a normal checkout, ant run-install and
startofbiz.

I just used Run Service from the service reference for
createTestSalesOrders
(https://localhost:8443/webtools/control/setSyncServiceParameters?SERVICE_NAME=createTestSalesOrders&POOL_NAME=pool&_RUN_SYNC_=Y)
parameters were:
currencyUomId -> USD
numberOfOrders -> 10
numberOfProductsPerOrder -> 5
partyId -> DemoCustomer
productCategoryId -> 100
productStoreId -> 9000
salesChannel -> left blank

Hope that helps

Scott

On 27/10/2007, David E Jones <[hidden email]> wrote:

>
> Actually, that's a little scary... we've seen this with certain
> clients recently
>
> What is your setup like where this is happening? (ofbiz revision, os/
> database/etc)
>
> Also, is anyone else seeing this? Other stories might be helpful to
> track it down (if there is anything we can do about it in OFBiz, I
> have my suspicions about possible causes, but I don't want to bias
> the discussion yet).
>
> -David
>
>
> On Oct 26, 2007, at 6:30 AM, Scott Gray wrote:
>
> > I got a whole pile of these while trying to run the
> > createTestSalesOrders service from webtools, anything worth worrying
> > about?
> >
> > Exception occured in updateByCondition (SQL Exception while executing
> > the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> > STATUS_ID = ? WHERE ((RUN_TIME <= '2007-10-27 00:44:51.468' AND
> > START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
> > RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
> > (A lock could not be obtained within the time requested))]. Rolling
> > back transaction.
> > Exception: org.ofbiz.entity.GenericDataSourceException
> > Message: Generic Entity Exception occured in updateByCondition
> >
> > Thanks
> > Scott
>
>
>

[Scott Gray]

oops, jdk is 1.5.0_11

On 27/10/2007, Scott Gray <[hidden email]> wrote:

> Hi David
>
> Revision is 588538 about 20 hours old, os is windows XP sp2, db is
> derby.  It's all just a normal checkout, ant run-install and
> startofbiz.
>
> I just used Run Service from the service reference for
> createTestSalesOrders
> (https://localhost:8443/webtools/control/setSyncServiceParameters?SERVICE_NAME=createTestSalesOrders&POOL_NAME=pool&_RUN_SYNC_=Y)
> parameters were:
> currencyUomId -> USD
> numberOfOrders -> 10
> numberOfProductsPerOrder -> 5
> partyId -> DemoCustomer
> productCategoryId -> 100
> productStoreId -> 9000
> salesChannel -> left blank
>
> Hope that helps
>
> Scott
>
> On 27/10/2007, David E Jones <[hidden email]> wrote:
> >
> > Actually, that's a little scary... we've seen this with certain
> > clients recently
> >
> > What is your setup like where this is happening? (ofbiz revision, os/
> > database/etc)
> >
> > Also, is anyone else seeing this? Other stories might be helpful to
> > track it down (if there is anything we can do about it in OFBiz, I
> > have my suspicions about possible causes, but I don't want to bias
> > the discussion yet).
> >
> > -David
> >
> >
> > On Oct 26, 2007, at 6:30 AM, Scott Gray wrote:
> >
> > > I got a whole pile of these while trying to run the
> > > createTestSalesOrders service from webtools, anything worth worrying
> > > about?
> > >
> > > Exception occured in updateByCondition (SQL Exception while executing
> > > the following:UPDATE OFBIZ.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?,
> > > STATUS_ID = ? WHERE ((RUN_TIME <= '2007-10-27 00:44:51.468' AND
> > > START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND
> > > RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
> > > (A lock could not be obtained within the time requested))]. Rolling
> > > back transaction.
> > > Exception: org.ofbiz.entity.GenericDataSourceException
> > > Message: Generic Entity Exception occured in updateByCondition
> > >
> > > Thanks
> > > Scott
> >
> >
> >
>