Advertisement
kenzobenzo

sqlite stacktrace error

Apr 24th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.14 KB | None | 0 0
  1. Traceback (most recent call last):
  2. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 1573, in __call__
  3. rv = self.handle_exception(request, response, e)
  4. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 1567, in __call__
  5. rv = self.router.dispatch(request, response)
  6. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 1314, in default_dispatcher
  7. return route.handler_adapter(request, response)
  8. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 1138, in __call__
  9. return handler.dispatch()
  10. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 606, in dispatch
  11. return self.handle_exception(e, self.app.debug)
  12. File "C:\Python27\lib\site-packages\webapp2-3.0.0b1-py2.7.egg\webapp2.py", line 604, in dispatch
  13. return method(*args, **kwargs)
  14. File "webserver.py", line 47, in get
  15. res_list = db_methods.getAllRestaurants()
  16. File "D:\FSND-Virtual-Machine\vagrant\menu-database\db_methods.py", line 22, in getAllRestaurants
  17. restaurants = session.query(Restaurant.name).order_by(Restaurant.name.asc()).all()
  18. File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 2703, in all
  19. return list(self)
  20. File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 2855, in __iter__
  21. return self._execute_and_instances(context)
  22. File "build\bdist.win32\egg\sqlalchemy\orm\query.py", line 2878, in _execute_and_instances
  23. result = conn.execute(querycontext.statement, self._params)
  24. File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 945, in execute
  25. return meth(self, multiparams, params)
  26. File "build\bdist.win32\egg\sqlalchemy\sql\elements.py", line 263, in _execute_on_connection
  27. return connection._execute_clauseelement(self, multiparams, params)
  28. File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1053, in _execute_clauseelement
  29. compiled_sql, distilled_params
  30. File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1121, in _execute_context
  31. None, None)
  32. File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1402, in _handle_dbapi_exception
  33. exc_info
  34. File "build\bdist.win32\egg\sqlalchemy\util\compat.py", line 203, in raise_from_cause
  35. reraise(type(exception), exception, tb=exc_tb, cause=cause)
  36. File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1116, in _execute_context
  37. context = constructor(dialect, self, conn, *args)
  38. File "build\bdist.win32\egg\sqlalchemy\engine\default.py", line 598, in _init_compiled
  39. self.cursor = self.create_cursor()
  40. File "build\bdist.win32\egg\sqlalchemy\engine\default.py", line 821, in create_cursor
  41. return self._dbapi_connection.cursor()
  42. File "build\bdist.win32\egg\sqlalchemy\pool.py", line 926, in cursor
  43. return self.connection.cursor(*args, **kwargs)
  44. ProgrammingError: (sqlite3.ProgrammingError) SQLite objects created in a thread can only be used in that same thread.The object was created in thread id 7332 and this is thread id 5860 [SQL: u'SELECT restaurant.name AS restaurant_name \nFROM restaurant ORDER BY restaurant.name ASC'] [parameters: [{}]]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement