I used 1.99.4 for two projects using apache, mod_wsgi, postgresql 8.4, 
psycopg2 on RHEL 6.

But I never use Rocket or pg8000 driver and I didn't use temporary tables 
with these... Did use auth quite a bit, though. Anyway, this just goes 
towards how many different combinations need to be tested.

Richard, Johann, any chance of doing basic sample apps that reliably 
recreate these migration issues...? That, combined with a bug ticket, would 
be the best approach to let more people look into this quickly. I think 
postgresql is quite popular in web2py world.

Regards,
Ales


On Thursday, November 15, 2012 7:49:47 AM UTC+1, Johann Spies wrote:
>
> I am using the trunk code updated daily on my development computer and 
> recently have had to kill web2py processes manually because of migration 
> issues. I am also using postgresql and this happened regularly while 
> experimenting with  temporary tables.
>
> Example:  I use 'create table x as select ... from ...' for some queries 
> in postgresql to create temporary tables. 
>
> When an error occurs in communicating with postgesql usually related to 
> some migration issue, I have to kill the web2py process on operating system 
> level using the -9 switch because of no response from web2py.  Ctrl-C will 
> do nothing and a normal kill also has no effect.
>
> Now I use migrate=False with fake-migrate to manage those tables.
>
> Regards
> Johann
>

-- 



Reply via email to