in sql.py can you try replace

            tfile = open(self._dbt, 'r')
            portalocker.lock(tfile, portalocker.LOCK_SH)
            sql_fields_old = cPickle.load(tfile)
            tfile.close()

with

            portalocker.lock(tfile, portalocker.LOCK_EX)
            sql_fields_old = cPickle.load(open(self._dbt, 'r'))

and see what happens? Please email me personally to let me know

On Mar 23, 9:28 am, AchipA <attila.cs...@gmail.com> wrote:
> I have an interesting situation, where while in a Apache/WSGI 1
> process environment, running under high load (which makes this a
> likely race condition/lock issue) web2py just explodes:
>
> [Mon Mar 23 14:19:44 2009] [error] Traceback (most recent call last):
> [Mon Mar 23 14:19:44 2009] [error]   File "/var/www/web2py/gluon/
> sql.py", line 859, in define_table
> [Mon Mar 23 14:19:44 2009] [error]     query = t._create(migrate=args
> ['migrate'])
> [Mon Mar 23 14:19:44 2009] [error]   File "/var/www/web2py/gluon/
> sql.py", line 1183, in _create
> [Mon Mar 23 14:19:44 2009] [error]     sql_fields_old = cPickle.load
> (tfile)
> [Mon Mar 23 14:19:44 2009] [error] EOFError
>
> If I moderate myself and lower the load on the particular instance,
> everything works nice. Anybody encounter anything similar ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to