Hi guys, An update: Mike is right! The connector doesn't get along with child processes... For a quick setup and since I'm using uWSGI and Nginx, I just created a cluster o uwsgi connections and ran 3 independent process of my application. All my tests passed nicely.
@Warwick I'm using mysql-python (MySQLdb). And try to follow what Mike said and test it and see if you still get the errors. Tomorrow I'll run more tests at work but I think it is solved. Thanks Mike! Regards Alan On 9 nov, 20:10, Warwick Prince <warwi...@mushroomsys.com> wrote: > Hi Alan > > We're also doing battle with this one.. One thing I did find was if I had > large(ish) BLOB values, MySQL would go away. I found that I had to tweak > some settings on MySQL to allow for larger sizes. (The default settings > appear to be ridiculously small). Let me know what else you find, as it is > a very annoying issue for us as well. BTW: What connector are you using? > > Cheers > Warwick > > Warwick Prince > Managing Director > mobile: +61 411 026 992 > skype: warwickprince > > phone: +61 7 3102 3730 > fax: +61 7 3319 6734 > web: www.mushroomsys.com > > On 10/11/2010, at 7:56 AM, Alan Castro wrote: > > > Hello, > > > Latelly I've been running into this issue: > > > OperationalError: (OperationalError) (2013, 'Lost connection to MySQL > > server during query') SELECT... > > > To contextualize, I developed a Pylons application using > > scoped_session (default in pylons). And it was working until I created > > some extra processes of my application. > > > Thanks > > > Alan > > > -- > > You received this message because you are subscribed to the Google Groups > > "sqlalchemy" group. > > To post to this group, send email to sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
