Update: When I put together a minimal app I couldn't reproduce the problem. I've had to set aside working on the issue, but it does seem to be limited to working with one specific table in my app's db. When I get back to debugging this I'll post any solutions for the sake of posterity.
On Friday, February 6, 2015 at 12:10:58 PM UTC-5, Ian W. Scott wrote: > > Thanks for your response Massimo. I'll try to put together a minimal > version today and post it. > > Ian > > On Thursday, February 5, 2015 at 4:46:46 PM UTC-5, Massimo Di Pierro wrote: >> >> Does it hang if you use sqlite? Can you provide a minimalist app that we >> can try. There is nothing wrong with your code except you do not need >> db.commit() but it should not hurt. >> >> On Thursday, 5 February 2015 14:46:58 UTC-6, Ian W. Scott wrote: >>> >>> Hi folks. I still don't really know how to debug this problem beyond >>> what I've done (identify the point in the gluon code where the hang >>> happens). Can anyone at least suggest another strategy for debugging it? >>> >>> Thanks again, >>> >>> Ian >>> >>> On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wrote: >>>> >>>> I have a create form (SQLFORM) that works (a new record is actually >>>> created) but immediately after inserting the new record the web2py process >>>> hangs. The form remains greyed out and no other functions will work (e.g., >>>> can't refresh the page or navigate away). But there's no error raised. Can >>>> anyone help me figure out what is causing the hang? >>>> >>>> I've pinpointed the point where the hang occurs: the call to >>>> gluon.DAL.Table.insert in gluon.SQLFORM.accepts (around line 1671 in the >>>> current stable version). What's strange is that the Table.insert method >>>> does finish without any errors. But when it returns to SQLFORM.accepts the >>>> execution hangs. A print statement immediately following the call to >>>> Table.insert is not executed. >>>> >>>> If it helps to know, I'm using postgresql running on apache. >>>> >>>> Here is an example of the data being sent by SQLFORM.accepts to >>>> Table.insert: >>>> >>>> {'hints': [], >>>> 'instructions': [13L, 14L], >>>> 'lemmas': [], >>>> 'locations': [11L], >>>> 'modified_on': datetime.datetime(2014, 12, 19, 18, 15, 32), >>>> 'npcs': [32L], >>>> 'outcome1': '1.0', >>>> 'outcome2': '', >>>> 'outcome3': '', >>>> 'prompt': 'Repetition can serve to emphasize certain words in the >>>> sentence, especially when the repeated words are close together. Which >>>> words are emphasized in this way in \xce\x9a\xce\xb1\xcf\x84\xce\xb1 >>>> \xe1\xbc\xb8\xcf\x89\xce\xb1\xce\xbd\xce\xbd\xce\xb7\xcf\x82 >>>> 1:4?\r\n\r\n"\xe1\xbc\x98\xce\xbd \xce\xb1\xe1\xbd\x90\xcf\x84\xe1\xbf\xb3 >>>> \xce\xb6\xcf\x89\xce\xb7 \xe1\xbc\xa0\xce\xbd, \xce\xba\xce\xb1\xce\xb9 >>>> \xe1\xbc\xa1 \xce\xb6\xcf\x89\xce\xb7 \xe1\xbc\xa0\xce\xbd >>>> \xcf\x84\xce\xbf >>>> \xcf\x86\xcf\x89\xcf\x82 \xcf\x84\xcf\x89\xce\xbd >>>> \xe1\xbc\x80\xce\xbd\xce\xb8\xcf\x81\xcf\x89\xcf\x80\xcf\x89\xce\xbd."', >>>> 'prompt_audio': 1, >>>> 'readable_response': '\xce\xb6\xcf\x89\xce\xb7 \xe1\xbc\xa0\xce\xbd', >>>> 'response1': '^(\xe1\xbc\xa1 )?\xce\xb6\xcf\x89\xce\xb7( >>>> \xe1\xbc\xa0\xce\xbd)?$', >>>> 'response2': '', >>>> 'response3': '', >>>> 'status': 1, >>>> 'step_options': [], >>>> 'tags': [202L], >>>> 'tags_ahead': [], >>>> 'tags_secondary': [], >>>> 'uuid': '51a9c0c0-18e5-4a9b-9b89-85eee6668170', >>>> 'widget_image': 9, >>>> 'widget_type': 1} >>>> >>>> Again, the db record is actually created. The operation just stops any >>>> further execution. >>>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.