Well, I followed the advise of Dr. Massimo, thank's a lot.
I updated all about my applications in web2faction, but a I did all
manually, because when I used the script for install I can't used
admin well. (install applications and local_import).
I am using in my applications mod_wgsi 2.5 and python 2.5
I configured the httpd.conf with this
ServerRoot "/home/username/webapps/appname/apache2"
LoadModule dir_module modules/mod_dir.so
LoadModule env_module modules/mod_env.so
LoadModule setenvif_module modules/mod_setenvif.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule mime_module modules/mod_mime.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule wsgi_module modules/mod_wsgi.so
DirectoryIndex index.py
DocumentRoot /home/username/webapps/appname/htdocs
KeepAlive Off
Listen PORTNUMBER
LogFormat "%{X-Forwarded-For}i %l %u %t \"%r\" %>s %b \"%{Referer}i\"
\"%{User-Agent}i\"" combined
CustomLog /home/username/logs/user/access_appname.log combined
ErrorLog /home/username/logs/user/error_appname.log
ServerLimit 2
SetEnvIf X-Forwarded-SSL on HTTPS=1
WSGIScriptAlias / /home/username/webapps/appname/web2py/wsgihandler.py
I ran web2py manually one time, and them I ran apache, at this moment,
everything is done with web2py version 1.78.3 even admin with https.
On Jun 3, 1:48 am, drayco <[email protected]> wrote:
> Very probability, because i very new in web applications and python
>
> In the past,1 week ago, before we updated version of web2py, we
> created 10589 registers with the same application. And now, the only
> idea that i have, it is this, the new version of web2py.
>
> This are the controllers involved when we created one register
>
> #Beneficiarios
> @auth.requires_login()
> def update_benef(form):
> import datetime
> now = datetime.datetime.today()
> beneficiario = db.benefs2[form.vars.id]
>
> keybenef=db(db.keys2benefs.keybenef==beneficiario.key_Registro).select()
>
> db(db.keys2benefs.id==keybenef[0].id).update(benefid=beneficiario.id)
> coordinador = db.coordinadores[keybenef[0].coordid]
> fechas =
> db((db.fechas.fechaTramite>now)&(db.fechas.regional==coordinador.regional)&(db.fechas.full<db.fechas.cargaMax)).select(db.fechas.ALL,orderby=db.fechas.fechaTramite)
>
> db(db.benefs2.id==beneficiario.id).update(coordid=keybenef[0].coordid)
> db(db.benefs2.id==beneficiario.id).update(fechasid=fechas[0].id)
> db(db.fechas.id==fechas[0].id).update(full=fechas[0].full+1)
>
> #Beneficiarios
> @auth.requires_login()
> def update_benef2(form):
> now = request.now
> benef = db.benefs2[form.vars.id]
> keybenef=db(db.keys2benefs.keybenef==benef.key_Registro).select()
> [0]
> db(db.keys2benefs.id==keybenef.id).update(benefs2_id=benef.id)
> coord = db.coordinadores[keybenef.coordinador_id]
> dates2 =
> db((db.dates2.start>now)&(db.dates2.regional_id==coord.regional_id)&(db.dates2.xdia>db.dates2.cargados)).
> \
> select(db.dates2.ALL,orderby=db.dates2.start)[0]
> benefs =
> db(db.benefs2.dates2_id==dates2.id).select(db.benefs2.id,db.benefs2.tramite,db.benefs2.entrega,db.benefs2.tramite.count(),
> \
> orderby=db.benefs2.tramite,groupby=db.benefs2.tramite)
> if len(benefs)>0:
> if
> benefs[len(benefs)-1]._extra[db.benefs2.tramite.count()]<dates2.xhora:
> tramite=benefs[len(benefs)-1].benefs2.tramite
> entrega=benefs[len(benefs)-1].benefs2.entrega
> else:
> from datetime import timedelta
> HOUR = timedelta(hours=1)
> tramite=benefs[len(benefs)-1].benefs2.tramite+HOUR
> entrega=benefs[len(benefs)-1].benefs2.entrega+HOUR
> else:
> tramite=dates2.start
> entrega=dates2.inicio
>
> db(db.benefs2.id==benef.id).update(dates2_id=dates2.id,tramite=tramite,entrega=entrega,coordnador_id=keybenef.coordinador_id)
> db(db.dates2.id==dates2.id).update(cargados=dates2.cargados
> +1,xcargar=dates2.xdia-(dates2.cargados+1))
>
> @auth.requires_login()
> def crea_benef():
> return dict(form=crud.create(db.benefs2, next=URL(r=request,
> f='benefs2_regist'),onaccept=update_benef2))
>
> And this when we try to show as a list
>
> @auth.requires_login()
> def benefs2_regist():
> if len(request.args): page=int(request.args[0])
> else: page=0
> items_per_page=25
> limitby=(page*items_per_page,(page+1)*items_per_page+1)
> benefs=db(db.benefs2.creadoPor==auth.user.id).\
>
> select(db.benefs2.id,db.benefs2.names,db.benefs2.apelPater,db.benefs2.apelMater,
> \
> db.benefs2.tramite,orderby=~db.benefs2.id,limitby=limitby)
> nobenefs=db(db.benefs2.creadoPor==auth.user.id).count()
> return
> dict(beneficiarios=benefs,page=page,items_per_page=items_per_page,nobenefs=nobenefs)
>
> This are the views involved when we created one register
>
> {{extend 'layout.html'}}
> <h3>Registre los datos del Beneficiario y el Trabajador
> correspondiente</h3>
> {{=form}}
>
> {{extend 'layout.html'}}
> <h3>Usted registro a {{=nobenefs}} Beneficiarios, organizados en
> bloques de {{=items_per_page}}</h3>
> <h3>De clic sobre el nombre del beneficiario para ver el lugar, los
> requisitos, etc. y ver el folio completo para imprimir</h3>
> <ul>{{for i,benef in enumerate(beneficiarios):}}
> {{if i==items_per_page: break}}
> {{=LI(A('Folio ',benef.id,' ',benef.names,'
> ',benef.apelPater,' ',benef.apelMater,' fecha de
> tramite:',benef.tramite, _href=URL(r=request, f='show_benef',
> args=benef.id)))}}
> {{pass}}</ul>
> {{if page:}}
> <a href="{{=URL(r=request,args=[page-1])}}">anteriores</a>
> {{pass}}
> {{if len(beneficiarios)>items_per_page:}}
> <a href="{{=URL(r=request,args=[page+1])}}">siguientes</a>
> {{pass}}
>
> On Jun 2, 9:01 pm, mdipierro <[email protected]> wrote:
>
> > why is counting records "select count(*) ...." crashing your mysql
> > database? It seems to me the problem is not the web2py version.
>
> > On Jun 2, 7:03 pm, drayco <[email protected]> wrote:
>
> > > Thank's a lot Dr. Massimo
>
> > > do you use apache? Yes
> > > mod_wsgi? Yes
> > > do you use the built-in web server? No
> > > do you see memory leaks? No
> > > do you have web2py cron or on off? No
>
> > > This is the firts error:
>
> > > Traceback (most recent call last):
> > > File "gluon/restricted.py", line 178, in restricted
> > > exec ccode in environment
> > > File "/home/drayco/webapps/seccion36/web2py/applications/init/
> > > controllers/default.py", line 134, in <module>
> > > File "gluon/globals.py", line 96, in <lambda>
> > > self._caller = lambda f: f()
> > > File "gluon/tools.py", line 2036, in f
> > > return action(*a, **b)
> > > File "/home/drayco/webapps/seccion36/web2py/applications/init/
> > > controllers/default.py", line 101, in crea_benef
> > > return dict(form=crud.create(db.benefs2, next=URL(r=request,
> > > f='benefs2_regist'),onaccept=update_benef2))
> > > File "gluon/tools.py", line 2623, in create
> > > deletable=False,
> > > File "gluon/tools.py", line 2567, in update
> > > onvalidation=onvalidation, keepvalues=keepvalues):
> > > File "gluon/sqlhtml.py", line 870, in accepts
> > > onvalidation,
> > > File "gluon/html.py", line 1328, in accepts
> > > status = self._traverse(status)
> > > File "gluon/html.py", line 456, in _traverse
> > > newstatus = c._traverse(status) and newstatus
> > > File "gluon/html.py", line 456, in _traverse
> > > newstatus = c._traverse(status) and newstatus
> > > File "gluon/html.py", line 456, in _traverse
> > > newstatus = c._traverse(status) and newstatus
> > > File "gluon/html.py", line 456, in _traverse
> > > newstatus = c._traverse(status) and newstatus
> > > File "gluon/html.py", line 463, in _traverse
> > > newstatus = self._validate()
> > > File "gluon/html.py", line 1120, in _validate
> > > (value, errors) = validator(value)
> > > File "gluon/validators.py", line 413, in __call__
> > > if self.dbset(field == value).count():
> > > File "gluon/sql.py", line 3224, in count
> > > return self.select('count(*)')[0]._extra['count(*)']
> > > File "gluon/sql.py", line 3096, in select
> > > rows = response(query)
> > > File "gluon/sql.py", line 3091, in response
> > > db._execute(query)
> > > File "gluon/sql.py", line 932, in <lambda>
> > > self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
> > > File "build/bdist.linux-i686/egg/MySQLdb/cursors.py", line 166, in
> > > execute
> > > self.errorhandler(self, exc, value)
> > > File "build/bdist.linux-i686/egg/MySQLdb/connections.py", line 35,
> > > in defaulterrorhandler
> > > raise errorclass, errorvalue
> > > OperationalError: (1053, 'Server shutdown in progress')
>
> > > And 1 second after:
>
> > > Traceback (most recent call last):
> > > File "gluon/main.py", line 435, in wsgibase
> > > BaseAdapter.close_all_instances(BaseAdapter.rollback)
> > > File "gluon/sql.py", line 754, in close_all_instances
> > > action(instance)
> > > File "gluon/sql.py", line 1350, in rollback
> > > self._connection.rollback()
> > > OperationalError: (2006, 'MySQL server has gone away')
>
> > > On Jun 2, 6:47 pm, mdipierro <[email protected]> wrote:
>
> > > > Try
>
> > > >http://web2py.com/examples/static/1.77.3/web2py_src.zip
>
> > > > some version are there and some not. Those obviously buggy have been
> > > > deleted.
>
> > > > Anyway, I'd like to understand the problem.
> > > > do you use apache? mod_wsgi?
> > > > do you use the built-in web server?
> > > > do you see memory leaks?
> > > > do you have web2py cron or on off?
>
> > > > Massimo
>
> > > > On Jun 2, 6:06 pm, drayco <[email protected]> wrote:
>
> > > > > Where can I download web2py 1.77.3?
>
> > > > > Because my application that's run in webfaction, with MySQL and web2py
> > > > > 1.78.3 needs to restart 4 times at day?
>
> > > > > And MySql rollback today, and I obtained a error that's say "server in
> > > > > process to shutdown"
>
> > > > > With web2py 1.77.3 and 1.66.5 I didn't need to do that action.
>
>
