Server raised fault: 'Database concurrency condition detected'

Friday, May 16, 2014
Avatar

I am using the Web service to trying to update the TestSet, When I call TestSet_Update(testset), I got the error  "suds.WebFault: Server raised fault: 'Database concurrency condition detected' .  Any idea?

all I did is:

Call set=TestSet_RetrieveById(10), to get the RemoteTestSet record. And then I change the set.TestSetStatusName="Completed",  After updating the value, I call client.service.TestSet_Update(set). I got the error message.

4 Replies
Friday, May 16, 2014
Avatar
re: ygan Friday, May 16, 2014
That means that the ConcurrencyDate you are passing back does not match the one you received (or your SOAP library is changing its timezone).
Friday, May 16, 2014
Avatar
re: inflectra.adam Friday, May 16, 2014
Thank for your answer. But Could you give me more clues? What I can do to solve this issue?
Thursday, June 26, 2014
Avatar
re: ygan Friday, May 16, 2014

Hi

Most likely the issue is either the timezone or rounding issues on the milliseconds, is there a way to set the timezone on the Python date object?

Here's some pointers - http://reverb.findawayworld.com/development/easy-python-soap-with-suds-with-a-few-datetime-gotchas/

Try force-setting it to UTC?

Regards

Adam

Wednesday, July 9, 2014
Avatar
re: inflectra.adam Thursday, June 26, 2014
Hi,

we struggled with this suds issue for months. There is a bug in suds that cannot handle the milliseconds correctly. You cannot predict what value will be returned, even if the timestamp was only stored in a variable and later on read out.

our solution is https://pypi.python.org/pypi/suds-jurko. There the issue is solved.

this is what we used as installation for it (we are linux users):

perform:

wget http://bitbucket.org/jurko/suds/downloads/suds-jurko-0.6.tar.bz2

tar -xvf suds-jurko-0.6.tar.bz2

cd /usr/local/lib/python2.7/suds-jurko-0.6

python2.7 setup.py install


hope that helps :-)
Filip
Statistics
  • Started: Friday, May 16, 2014
  • Last Reply: Wednesday, July 9, 2014
  • Replies: 4
  • Views: 1977