Re: [sqlalchemy] Error - class 'sqlalchemy.exc.OperationalError': (OperationalError) (2006, 'MySQL server has gone away')

2010-10-14 Thread Warwick Prince
HiTimmy

What OS are you running under for each?

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 15/10/2010, at 7:48 AM, Timmy Chan wrote:

 sorry if this is addressed, but i'm running
 
 apache2
 SQLAlchemy 0.5.8
 Pylons 1.0
 Python 2.5.2
 
 and on a simple page (just retrieve data from DB), I get:
 
 Error - class 'sqlalchemy.exc.OperationalError': (OperationalError) (2006, 
 'MySQL server has gone away')
 
 every few other requests, not after a long time as other posts I've searched 
 for.  I still added
 
 sqlalchemy.pool_recycle = 1800
 
 but that did not fix the issue.  After a fresh apache restart, every 5th or 
 6th requests gets a 500 from the above error.
 
 thanks
 
 -- 
 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.

-- 
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.



[sqlalchemy] Error - class 'sqlalchemy.exc.OperationalError': (OperationalError) (2006, 'MySQL server has gone away')

2010-10-14 Thread Timmy Chan
sorry if this is addressed, but i'm running

apache2
SQLAlchemy 0.5.8
Pylons 1.0
Python 2.5.2

and on a simple page (just retrieve data from DB), I get:

Error - class 'sqlalchemy.exc.OperationalError': (OperationalError) (2006,
'MySQL server has gone away')

every few other requests, not after a long time as other posts I've searched
for.  I still added

sqlalchemy.pool_recycle = 1800

but that did not fix the issue.  After a fresh apache restart, every 5th or
6th requests gets a 500 from the above error.

thanks

-- 
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.



Re: [sqlalchemy] Error - class 'sqlalchemy.exc.OperationalError': (OperationalError) (2006, 'MySQL server has gone away')

2010-10-14 Thread Timmy Chan
hey,

Linux ded-230-114 2.6.30-bpo.1-686 #1 SMP Mon Aug 17 14:57:26 UTC 2009 i686
GNU/Linux

thanks!


On Thu, Oct 14, 2010 at 5:56 PM, Warwick Prince warwi...@mushroomsys.comwrote:

 HiTimmy

 What OS are you running under for each?

 Cheers
 Warwick

 *Warwick Prince*
 Managing Director
  mobile: +61 411 026 992
 skype: warwickprince [image: If you have Skype installed, click here to
 call me now!]
  [image: Mushroom Systems]
  phone: +61 7 3102 3730
 fax:  +61 7 3319 6734
 web: www.mushroomsys.com
  [image: I'm Green with Little Green 
 Genie]http://littlegreengenie.com/index.html?referer=WARWICKP

 On 15/10/2010, at 7:48 AM, Timmy Chan wrote:

 sorry if this is addressed, but i'm running

 apache2
 SQLAlchemy 0.5.8
 Pylons 1.0
 Python 2.5.2

 and on a simple page (just retrieve data from DB), I get:

 Error - class 'sqlalchemy.exc.OperationalError': (OperationalError)
 (2006, 'MySQL server has gone away')

 every few other requests, not after a long time as other posts I've
 searched for.  I still added

 sqlalchemy.pool_recycle = 1800

 but that did not fix the issue.  After a fresh apache restart, every 5th or
 6th requests gets a 500 from the above error.

 thanks

 --
 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.


  --
 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.comsqlalchemy%2bunsubscr...@googlegroups.com
 .
 For more options, visit this group at
 http://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.