Problem seems to be related how I moved the database (pg_dump + pg_restore). After moving the database files directory I can no longer reproduce this error.
-aj On Friday, April 19, 2013 8:36:58 AM UTC+2, Andreas Jung wrote: > > Hi there, > > I receive the following weird UnicodeDecodeError after copying our > production database into a > testing environment. On the production server everything is working fine, > on the testing server > I get this error. Both installation including OS are basically identically > (except SA 0.8.0b2 vs 0.8.0 - > but this does not make a different). > > Any clue? > > Andreas > > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/tweens.py", line > 21, in excview_tween > response = handler(request) > File > "/home/ajung/.buildout/eggs/pyramid_tm-0.7-py2.7.egg/pyramid_tm/__init__.py", > line 82, in tm_tween > reraise(*exc_info) > File > "/home/ajung/.buildout/eggs/pyramid_tm-0.7-py2.7.egg/pyramid_tm/__init__.py", > line 63, in tm_tween > response = handler(request) > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/router.py", line > 161, in handle_request > response = view_callable(context, request) > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/config/views.py", > line 375, in viewresult_to_response > result = view(context, request) > File > "/home/ajung/.buildout/eggs/Kotti-0.8b1-py2.7.egg/kotti/views/view.py", > line 24, in view_content_default > response = render_view_to_response(context, request, name=view_name) > File "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/view.py", > line 83, in render_view_to_response > return view(context, request) > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/config/views.py", > line 237, in _secured_view > return view(context, request) > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/config/views.py", > line 345, in rendered_view > result = view(context, request) > File > "/home/ajung/.buildout/eggs/pyramid-1.4-py2.7.egg/pyramid/config/views.py", > line 491, in _requestonly_view > response = view(request) > File > "/home/ajung/sandboxes/mib.pyramid_zopyx/src/mib/pyramid/food_folder_views.py", > > line 47, in recipes_view > if query: > File > "/home/ajung/.buildout/eggs/SQLAlchemy-0.8.0-py2.7-linux-x86_64.egg/sqlalchemy/orm/query.py", > > line 2140, in all > return list(self) > File > "/home/ajung/.buildout/eggs/SQLAlchemy-0.8.0-py2.7-linux-x86_64.egg/sqlalchemy/orm/loading.py", > > line 65, in instances > fetch = cursor.fetchall() > File > "/home/ajung/.buildout/eggs/SQLAlchemy-0.8.0-py2.7-linux-x86_64.egg/sqlalchemy/engine/result.py", > > line 748, in fetchall > l = self.process_rows(self._fetchall_impl()) > File > "/home/ajung/.buildout/eggs/SQLAlchemy-0.8.0-py2.7-linux-x86_64.egg/sqlalchemy/engine/result.py", > > line 715, in _fetchall_impl > return self.cursor.fetchall() > UnicodeDecodeError: 'ascii' codec can't decode byte 0xc2 in position 18: > ordinal not in range(128) > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
