python - Flask SQL-Alchemy OperationalError -

-

i'm getting error message causing 500 error sporadically on site:

operationalerror: (_mysql_exceptions.operationalerror) (2006, 'mysql server has gone away')

i using flask sql-alchemy. after doing googling came across this:

https://rapd.wordpress.com/2008/03/02/sqlalchemy-sqlerror-operationalerror-2006-mysql-server-has-gone-away/

i added these fixes:

app.config['sqlalchemy_database_uri'] = 'myserverstuff' app.config['sqlalchemy_pool_size'] = 100 app.config['sqlalchemy_pool_recycle'] = 3600 db = sqlalchemy(app)

sadly haven't had success this. suggestions?

edit:

newest_vendors = accounts.query.filter(accounts.acc_type=='vendor').order_by(accounts.created_at.desc()).limit(4).all()

this happens through out functions sporadically there isn't specific spot :/

edit edit:

this apache saying:

root@server [~]# tail -f /usr/local/apache/logs/error_log app 4986 stderr:   file "/home/admin/venv/lib/python2.6/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context app 4986 stderr:     context) app 4986 stderr:   file "/home/admin/venv/lib/python2.6/site-packages/sqlalchemy/engine/default.py", line 442, in do_execute app 4986 stderr:     cursor.execute(statement, parameters) app 4986 stderr:   file "/home/admin/venv/lib/python2.6/site-packages/mysqldb/cursors.py", line 205, in execute app 4986 stderr:     self.errorhandler(self, exc, value) app 4986 stderr:   file "/home/admin/venv/lib/python2.6/site-packages/mysqldb/connections.py", line 36, in defaulterrorhandler app 4986 stderr:     raise errorclass, errorvalue app 4986 stderr: operationalerror: (_mysql_exceptions.operationalerror) (2006, 'mysql server has gone away') [sql: u'select taxonomies.taxonomy_id taxonomies_taxonomy_id, taxonomies.taxonomy taxonomies_taxonomy, taxonomies.slug taxonomies_slug, taxonomies.parent taxonomies_parent, taxonomies.description taxonomies_description, taxonomies.taxonomy_picture taxonomies_taxonomy_picture \nfrom taxonomies'] app 24080 stdout:


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more

c# - ErrorThe type or namespace name 'AxWMPLib' could not be found (are you missing a using directive or an assembly reference?) -

-
what possible reference handler axwmplib._wmpocxevents_playstatechangeeventhandler ? when pass event in method, private void axwindowsmediaplayer1_playstatechange(object sender,axwmplib._wmpocxevents_playstatechangeevent e) compiling throws following error: the type or namespace name 'axwmplib' not found (are missing using directive or assembly reference?) if using visual studio make sure have axwmplib listed under references in solution explorer. if have embedded windows media player control in form, should have been added automatically along wmplib . an easy way add these libraries if missing add windows media player control form (an existing 1 do). right-click on toolbox , pick "choose items..." context menu, tick "windows media player" control on "com components" tab , click ok. should have little windows media player icon attached cursor; click on form add it. add axwmplib , wmplib references solution. can delete w...
Read more