sqlite locks the entire database for every read and write operation. On Monday, September 1, 2014 11:14:28 AM UTC+2, [email protected] wrote: > > Hello, > > Ok let's start with some info. > > -i use cross-domain request( my project is a local application but can > interact with a database ) > -https > -apache2 > -ubuntu server 14.04 > -sqlLite > > and the controller is simple as f*** > > if request.env.http_origin: > response.headers['Access-Control-Allow-Origin'] = > request.env.http_origin > response.headers['Access-Control-Allow-Credentials'] = 'true' > response.headers['Access-Control-Max-Age'] = 86400 > > def upload(): > session.forget(response) > mes = "file " + request.vars['id'] + " : " > if request.vars.file != None : > f = request.vars.file > db.sequence_file[request.vars["id"]] = dict(data_file = > db.sequence_file.data_file.store(f.file, f.filename)) > mes += "file saved, " > else : > mes += "file missing" > > res = {"message": mes} > return gluon.contrib.simplejson.dumps(res, separators=(',',':')) > > > Everything work well but web2py froze when i upload a file, it works, the > file is correctly uploaded but during this time every others request fail, > i'm forced to wait. > > I've tried to use session.forget(response) but it doesn't seem to be a > session lock, and this happens even if i remove all database access, so > it's not a database lock either. > > The only way to solve this problem is by using the build-in web2py server > instead of apache2, maybe i have a bad conf but i use the default one > suggested in setup-web2py-ubuntu.sh . > > I will continue to look for a solution but if you have any hints for me ... > > Thanks > > > Marc D >
-- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
