In Progress

Debug Python 2.7 script

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/[url removed, login to view]", line 532, in __bootstrap_inner

[url removed, login to view]()

File "[url removed, login to view]", line 73, in run

process_message([url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], data_in)

File "[url removed, login to view]", line 149, in process_message

rc = process_decrypted(node, skts, cfg, enc, message)

File "[url removed, login to view]", line 279, in process_decrypted

return reply

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", 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/[url removed, login to view]", line 96, in cut_traceback

return func(*args, **kwargs)

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", line 269, in commit

reraise(CommitException, exceptions)

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", line 263, in commit

try: [url removed, login to view]()

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", line 3657, in commit

[url removed, login to view]()

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", line 3720, in save

obj._save_()

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", line 3591, in _save_

elif status == 'updated': obj._save_updated_()

File "/usr/local/lib/python2.6/dist-packages/pony/orm/[url removed, login to view]", 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/[url removed, login to view]", 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.

The MySQL connections are handled by PonyORM but I am happy for this to change to a pure MySQL connection if desired.

The code is currently less than 350 lines so should be considered an easy project by any Python professionals.

I am happy to move the Django if this is helpful in ensuring a reliable solution.

Skills: Django, MySQL, Python

See more: node mysql, situ, debug, connection string access, python login, multiple node, mysql object, help python, object mysql, python message, connection python, python small, cache mysql, run local script, single user login, call python, enc file, login script message, python multiple, run script python, Mysql python, 263, transaction python file, server side script, last login script

About the Employer:
( 0 reviews ) Gamlingay, United Kingdom

Project ID: #5518630

Awarded to:

malashkevich

Hi, author of Pony ORM here. Ready to help you with your project. Can you send me the source code so I can fix it?

£20 GBP in 1 day
(0 Reviews)
0.0

20 freelancers are bidding on average £127 for this job

maysam

I will work with you until the bug is resolved even if it takes longer than what I anticipate it to, btw what does the script do and can you share it?

£170 GBP in 1 day
(51 Reviews)
6.3
ebson

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 a More

£178 GBP in 3 days
(34 Reviews)
6.1
NTechcorporate

Hi, Hope you are doing well! We have gone through your requirement and we understand that you are looking for highly skilled, qualified, and experience Python development team for your project. Our developer ha More

£309 GBP in 5 days
(7 Reviews)
5.1
grgizem

Hi, I am very well experienced on Django web framework. I would love to do this project on Django. You can see my previous projects from my github account: [url removed, login to view] And I also linked my linked More

£250 GBP in 4 days
(1 Review)
5.0
liuyu81

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 s More

£100 GBP in 3 days
(7 Reviews)
3.8
denep

What version of Pony ORM are you using? A simple web search reveals this is a bug in older versions of Pony and a new version was released 3 weeks ago. Updating to the latest version may do the trick. The problem is al More

£40 GBP in 3 days
(12 Reviews)
3.8
GeorgeKazi

Hi! I'm an expert Python scripts developer. Your project seems interesting abd I'd love to solve your problem for you. Thanks George

£150 GBP in 3 days
(10 Reviews)
3.5
brucevdkooij

I still have a couple of questions but I'd be more than willing to look at this to see if I can help you out. No cure, no pay.

£35 GBP in 0 days
(3 Reviews)
3.4
Venky117

A proposal has not yet been provided

£100 GBP in 3 days
(8 Reviews)
3.0
fabiosantiago

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 Djan More

£150 GBP in 5 days
(3 Reviews)
2.6
smellyfinger

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.

£150 GBP in 3 days
(2 Reviews)
2.4
wildpointer

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 hel More

£100 GBP in 3 days
(3 Reviews)
2.4
chrismit7

Hi, I have been developing in python for approximately 10 years. I am a computational biologist and have worked extensively with MySQL databases that have heavy demands (concurrency, many users, etc.). Some of my pa More

£166 GBP in 3 days
(1 Review)
1.8
ibaydan

A proposal has not yet been provided

£44 GBP in 3 days
(2 Reviews)
1.7
aakbar81

A proposal has not yet been provided

£150 GBP in 3 days
(1 Review)
1.2
vxflores

From reading your error I believe it's related to a known issue, and the PonyORM developer himself recommends updating PonyORM to the latest version. I'm good with python, django and databases and also a good bug hunte More

£100 GBP in 5 days
(1 Review)
0.6
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

£250 GBP in 3 days
(1 Review)
0.0
ajayraman2

I am working on python since 3 years. I have handled many python projects. I am very good in debugging.

£150 GBP in 3 days
(0 Reviews)
0.0
LeoBareto

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 More

£40 GBP in 3 days
(0 Reviews)
0.0
codymills

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.

£133 GBP in 3 days
(0 Reviews)
0.0