Hi, I'm having problems with a process that uses an sqlAlchemy session, and after that it forks. From that moment I have 2 processes (can be more) that uses alchemy sessions.
Both processes fails with "ProgrammingError: (ProgrammingError) SET TRANSACTION ISOLATION LEVEL must be called before any query". What happens when I fork (I'm in linux)? My guess is that both process share the same socket. (but nowadays I'm not really sure of anything...). If that's the case, my fist solution was to close all file descriptors on fork, hoping that alchemy would recreate connections. But it failed, I had a "Bad Descriptor" error. My second approach, was to reconfigure the session with a newly created engine with the same configuration options as before. That didn't work either, and it gave me the same error of "SET TRANSACTION ISOLATION LEVEL". This outcome puzzles me :S Any ideas? What can I do to fork a process and continue using sessions?? Thanks in advance!! Mariano Cortesi Zauber - Popego --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
