[web2py] Re: MySQL server has gone away - py4web
It's 20191227.1 On Friday, February 21, 2020 at 12:48:32 AM UTC-3, Massimo Di Pierro wrote: > > Can you check which version of pydal you are using? > Need to decide whether to make this the default behavior > > On Tuesday, 18 February 2020 03:35:47 UTC-8, Marcello wrote: >> >> Hi Massimo, >> >> Great ! >> Now worked fine... >> >> Thanks >> >> >> On Tuesday, February 18, 2020 at 12:22:04 AM UTC-3, Massimo Di Pierro >> wrote: >>> >>> sorry. My bad. try: >>> >>> +self._adapter.reconnect() >>> >>> On Sunday, 16 February 2020 19:17:25 UTC-8, Marcello wrote: I got this error: File "/home/parra/py4web/py4web/core.py", line 239, in on_request db._adapter.reconnect() NameError: name 'db' is not defined On Sunday, February 16, 2020 at 10:22:48 PM UTC-3, Massimo Di Pierro wrote: > > The db fixture should automatiically try reconnect. > > To help me debug can you edit py4web/core.py and add the line below: > > class DAL(pydal.DAL, Fixture): > def on_request(self): > threadsafevariable.ThreadSafeVariable.restore(ICECUBE) > + db._adapter.reconnect() > > Does it solve the problem? > > > On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: >> >> I'm with lastest version... >> >> Shouldn't reconnect to db every page load ??? >> If the server stays 1 hour without serving pages, a reconnection is >> needed... or not ? >> >> >> >> >> On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro >> wrote: >>> >>> My guess is that there is some timeout in the mysql config example. >>> Can you repro with latest py4web? >>> >>> On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: Hi, Any informatiion about this ? Nobody using py4web with mysql ?? On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: > > Hello, > > I'm trying py4web and found something stragne. > Don't know if I'm making something wrong. > > I'm having "MySQL server has gone away" error if I wait some time > (about 10 minutes) betweeen page reloads... > > I tested same thing with web2py and this problem did not happen... > > Is it a bug or a problem here ? > > > Thanks > Marcello > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/4207ac23-ee5a-46d3-869b-700a0f5377a9%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
Can you check which version of pydal you are using? Need to decide whether to make this the default behavior On Tuesday, 18 February 2020 03:35:47 UTC-8, Marcello wrote: > > Hi Massimo, > > Great ! > Now worked fine... > > Thanks > > > On Tuesday, February 18, 2020 at 12:22:04 AM UTC-3, Massimo Di Pierro > wrote: >> >> sorry. My bad. try: >> >> +self._adapter.reconnect() >> >> On Sunday, 16 February 2020 19:17:25 UTC-8, Marcello wrote: >>> >>> I got this error: >>> >>> File "/home/parra/py4web/py4web/core.py", line 239, in on_request >>> db._adapter.reconnect() >>> NameError: name 'db' is not defined >>> >>> >>> >>> >>> On Sunday, February 16, 2020 at 10:22:48 PM UTC-3, Massimo Di Pierro >>> wrote: The db fixture should automatiically try reconnect. To help me debug can you edit py4web/core.py and add the line below: class DAL(pydal.DAL, Fixture): def on_request(self): threadsafevariable.ThreadSafeVariable.restore(ICECUBE) + db._adapter.reconnect() Does it solve the problem? On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: > > I'm with lastest version... > > Shouldn't reconnect to db every page load ??? > If the server stays 1 hour without serving pages, a reconnection is > needed... or not ? > > > > > On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro > wrote: >> >> My guess is that there is some timeout in the mysql config example. >> Can you repro with latest py4web? >> >> On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: >>> >>> Hi, >>> >>> Any informatiion about this ? >>> Nobody using py4web with mysql ?? >>> >>> >>> >>> On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: Hello, I'm trying py4web and found something stragne. Don't know if I'm making something wrong. I'm having "MySQL server has gone away" error if I wait some time (about 10 minutes) betweeen page reloads... I tested same thing with web2py and this problem did not happen... Is it a bug or a problem here ? Thanks Marcello >>> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/0039ff48-b72b-48b3-a36b-9866d0e4666d%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
Hi Massimo, Great ! Now worked fine... Thanks On Tuesday, February 18, 2020 at 12:22:04 AM UTC-3, Massimo Di Pierro wrote: > > sorry. My bad. try: > > +self._adapter.reconnect() > > On Sunday, 16 February 2020 19:17:25 UTC-8, Marcello wrote: >> >> I got this error: >> >> File "/home/parra/py4web/py4web/core.py", line 239, in on_request >> db._adapter.reconnect() >> NameError: name 'db' is not defined >> >> >> >> >> On Sunday, February 16, 2020 at 10:22:48 PM UTC-3, Massimo Di Pierro >> wrote: >>> >>> The db fixture should automatiically try reconnect. >>> >>> To help me debug can you edit py4web/core.py and add the line below: >>> >>> class DAL(pydal.DAL, Fixture): >>> def on_request(self): >>> threadsafevariable.ThreadSafeVariable.restore(ICECUBE) >>> + db._adapter.reconnect() >>> >>> Does it solve the problem? >>> >>> >>> On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: I'm with lastest version... Shouldn't reconnect to db every page load ??? If the server stays 1 hour without serving pages, a reconnection is needed... or not ? On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro wrote: > > My guess is that there is some timeout in the mysql config example. > Can you repro with latest py4web? > > On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: >> >> Hi, >> >> Any informatiion about this ? >> Nobody using py4web with mysql ?? >> >> >> >> On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: >>> >>> Hello, >>> >>> I'm trying py4web and found something stragne. >>> Don't know if I'm making something wrong. >>> >>> I'm having "MySQL server has gone away" error if I wait some time >>> (about 10 minutes) betweeen page reloads... >>> >>> I tested same thing with web2py and this problem did not happen... >>> >>> Is it a bug or a problem here ? >>> >>> >>> Thanks >>> Marcello >>> >> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/d753d8fc-5ec0-4d02-b7e9-b70332a4a509%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
sorry. My bad. try: +self._adapter.reconnect() On Sunday, 16 February 2020 19:17:25 UTC-8, Marcello wrote: > > I got this error: > > File "/home/parra/py4web/py4web/core.py", line 239, in on_request > db._adapter.reconnect() > NameError: name 'db' is not defined > > > > > On Sunday, February 16, 2020 at 10:22:48 PM UTC-3, Massimo Di Pierro wrote: >> >> The db fixture should automatiically try reconnect. >> >> To help me debug can you edit py4web/core.py and add the line below: >> >> class DAL(pydal.DAL, Fixture): >> def on_request(self): >> threadsafevariable.ThreadSafeVariable.restore(ICECUBE) >> + db._adapter.reconnect() >> >> Does it solve the problem? >> >> >> On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: >>> >>> I'm with lastest version... >>> >>> Shouldn't reconnect to db every page load ??? >>> If the server stays 1 hour without serving pages, a reconnection is >>> needed... or not ? >>> >>> >>> >>> >>> On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro >>> wrote: My guess is that there is some timeout in the mysql config example. Can you repro with latest py4web? On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: > > Hi, > > Any informatiion about this ? > Nobody using py4web with mysql ?? > > > > On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: >> >> Hello, >> >> I'm trying py4web and found something stragne. >> Don't know if I'm making something wrong. >> >> I'm having "MySQL server has gone away" error if I wait some time >> (about 10 minutes) betweeen page reloads... >> >> I tested same thing with web2py and this problem did not happen... >> >> Is it a bug or a problem here ? >> >> >> Thanks >> Marcello >> > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/765e49a2-b819-4d1c-8356-a7827d4b8f96%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
I got this error: File "/home/parra/py4web/py4web/core.py", line 239, in on_request db._adapter.reconnect() NameError: name 'db' is not defined On Sunday, February 16, 2020 at 10:22:48 PM UTC-3, Massimo Di Pierro wrote: > > The db fixture should automatiically try reconnect. > > To help me debug can you edit py4web/core.py and add the line below: > > class DAL(pydal.DAL, Fixture): > def on_request(self): > threadsafevariable.ThreadSafeVariable.restore(ICECUBE) > + db._adapter.reconnect() > > Does it solve the problem? > > > On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: >> >> I'm with lastest version... >> >> Shouldn't reconnect to db every page load ??? >> If the server stays 1 hour without serving pages, a reconnection is >> needed... or not ? >> >> >> >> >> On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro >> wrote: >>> >>> My guess is that there is some timeout in the mysql config example. >>> Can you repro with latest py4web? >>> >>> On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: Hi, Any informatiion about this ? Nobody using py4web with mysql ?? On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: > > Hello, > > I'm trying py4web and found something stragne. > Don't know if I'm making something wrong. > > I'm having "MySQL server has gone away" error if I wait some time > (about 10 minutes) betweeen page reloads... > > I tested same thing with web2py and this problem did not happen... > > Is it a bug or a problem here ? > > > Thanks > Marcello > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/d81bc58e-87e8-423e-a38b-13c1a9056573%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
The db fixture should automatiically try reconnect. To help me debug can you edit py4web/core.py and add the line below: class DAL(pydal.DAL, Fixture): def on_request(self): threadsafevariable.ThreadSafeVariable.restore(ICECUBE) + db._adapter.reconnect() Does it solve the problem? On Saturday, 15 February 2020 04:15:38 UTC-8, Marcello wrote: > > I'm with lastest version... > > Shouldn't reconnect to db every page load ??? > If the server stays 1 hour without serving pages, a reconnection is > needed... or not ? > > > > > On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro > wrote: >> >> My guess is that there is some timeout in the mysql config example. >> Can you repro with latest py4web? >> >> On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: >>> >>> Hi, >>> >>> Any informatiion about this ? >>> Nobody using py4web with mysql ?? >>> >>> >>> >>> On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: Hello, I'm trying py4web and found something stragne. Don't know if I'm making something wrong. I'm having "MySQL server has gone away" error if I wait some time (about 10 minutes) betweeen page reloads... I tested same thing with web2py and this problem did not happen... Is it a bug or a problem here ? Thanks Marcello >>> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/42399f97-cb0d-4810-b668-5ec8453fbdba%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
I'm with lastest version... Shouldn't reconnect to db every page load ??? If the server stays 1 hour without serving pages, a reconnection is needed... or not ? On Saturday, February 15, 2020 at 8:30:58 AM UTC-3, Massimo Di Pierro wrote: > > My guess is that there is some timeout in the mysql config example. > Can you repro with latest py4web? > > On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: >> >> Hi, >> >> Any informatiion about this ? >> Nobody using py4web with mysql ?? >> >> >> >> On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: >>> >>> Hello, >>> >>> I'm trying py4web and found something stragne. >>> Don't know if I'm making something wrong. >>> >>> I'm having "MySQL server has gone away" error if I wait some time (about >>> 10 minutes) betweeen page reloads... >>> >>> I tested same thing with web2py and this problem did not happen... >>> >>> Is it a bug or a problem here ? >>> >>> >>> Thanks >>> Marcello >>> >> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/302f29ad-20b7-4e78-a36a-a49dacdf4680%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
My guess is that there is some timeout in the mysql config example. Can you repro with latest py4web? On Friday, 14 February 2020 14:31:58 UTC-8, Marcello wrote: > > Hi, > > Any informatiion about this ? > Nobody using py4web with mysql ?? > > > > On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: >> >> Hello, >> >> I'm trying py4web and found something stragne. >> Don't know if I'm making something wrong. >> >> I'm having "MySQL server has gone away" error if I wait some time (about >> 10 minutes) betweeen page reloads... >> >> I tested same thing with web2py and this problem did not happen... >> >> Is it a bug or a problem here ? >> >> >> Thanks >> Marcello >> > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3f9c20c8-1b19-4fa8-bc6e-5f83f8ee8fc8%40googlegroups.com.
[web2py] Re: MySQL server has gone away - py4web
Hi, Any informatiion about this ? Nobody using py4web with mysql ?? On Tuesday, February 11, 2020 at 6:58:11 PM UTC-3, Marcello wrote: > > Hello, > > I'm trying py4web and found something stragne. > Don't know if I'm making something wrong. > > I'm having "MySQL server has gone away" error if I wait some time (about > 10 minutes) betweeen page reloads... > > I tested same thing with web2py and this problem did not happen... > > Is it a bug or a problem here ? > > > Thanks > Marcello > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/397107e0-747c-4099-80d5-cd84f7075e89%40googlegroups.com.