I have a small server-side script that is wroking fine when a single user is logged in, but when multiple users access the system I m getting exceptions from the MySQL connection as shown below:
Exception in thread Thread-1:
Traceback (most recent call last):
File "/usr/lib/python2.6/[login to view URL]", line 532, in __bootstrap_inner
[login to view URL]()
File "[login to view URL]", line 73, in run
process_message([login to view URL], [login to view URL], [login to view URL], [login to view URL], data_in)
File "[login to view URL]", line 149, in process_message
rc = process_decrypted(node, skts, cfg, enc, message)
File "[login to view URL]", line 279, in process_decrypted
return reply
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 354, in __exit__
if exc_type is None: commit() # exc_value can be None in Python 2.6 even if exc_type is not None
File "<string>", line 2, in commit
File "/usr/local/lib/python2.6/dist-packages/pony/[login to view URL]", line 96, in cut_traceback
return func(*args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 269, in commit
reraise(CommitException, exceptions)
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 263, in commit
try: [login to view URL]()
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 3657, in commit
[login to view URL]()
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 3720, in save
obj._save_()
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 3591, in _save_
elif status == 'updated': obj._save_updated_()
File "/usr/local/lib/python2.6/dist-packages/pony/orm/[login to view URL]", line 3522, in _save_updated_
throw(UnrepeatableReadError, 'Object %s was updated outside of current transaction' % safe_repr(obj))
File "/usr/local/lib/python2.6/dist-packages/pony/[login to view URL]", line 123, in throw
raise exc
CommitException: Object node[2] was updated outside of current transaction
I am looking for someone who can help debug this. Debugging would need to occur "in-situ" and login details to the server will be provided.
I understand what the problem is and have a good idea how it can be fixed.
Only concern is how will my fix affect the existing code and how much of it will/might need to be rewritten.
Updated my bid for debugging and fixing a 350 lines script that works independently.
I have no intention to change pony unless I found its not thread safe.
either case my bid is final
Greetings,
I am pretty experienced with Python programming, especially in a data-intensive and web-oriented setting. The error message looks like a data inconsistency problem caused by concurrent write. I think I should be able to fix it in a matter of hours. To accommodate unforeseeable uncertainties, I set the bidding time frame to 3 days. That's more than enough to solve this problem.
By the way, according to the error message, the effective Python version is 2.6, not 2.7
Feel free to send me private messages to discuss.
The probles is that you leave an open conection during the register procces, then, when another user tries to login, it finds an existing connection in the same instance, and that's what generates that error. Btw, I'd like to see the code.
I'd like to help you debugging your script. I have a lot of experience in Python and a lot of time in hand.
Give me a knock and we can start right away.
Thanks.
Could you share your script ?
Would you like to use Django as ORM ?
I am a python / django experient developer and I think that I can do this job for you.
Hi,
I would like to help you to change your ORM to Django.
Please, give me more details about the project.
Hi there, I'm an experienced programmer with more than 3 years Python programming experience and system architecture experience. I'm good at debug and process MySQL multiple access issues. Just contact me and I can help you. Thanks and best regards.
Hi,
I'm a experienced Python programmer.
Generally I will code my project in Django.
I can take a look at your current code and provide few idea how I will do in Django.
Thanks.