For production, a better option psycopg2 postgresql connector. pg8000 is more oriented to development and special situations (i.e. when you cannot install compiled c extensions) There is a new official pg8000 version with some improvements, please see:
https://github.com/mfenniak/pg8000 Let me know if you test the new version and it works in your case, so we can evaluate to update the one shipped with web2py. Best regards, Mariano Reingart http://www.sistemasagiles.com.ar http://reingart.blogspot.com On Sat, Feb 8, 2014 at 8:03 PM, puercoespin <[email protected] > wrote: > Yes, may be its a little strange, but when google bot try to spider my > web, my web downs, with a three differents pg8000 errors: > > > InternalError: Unexpected response msg > <gluon.contrib.pg8000.protocol.CloseComplete object at 0x1553ed90> > > ... > > InternalError: Unexpected response msg <gluon.contrib.pg8000.protocol.NoData > object at 0x1465dd50> > > ... > > > InternalError: Unexpected response msg > <gluon.contrib.pg8000.protocol.BindComplete object at 0xd8d8190> > > An exemple of the errors: > > > Traceback (most recent call last): > File "/home/egasolin/public_html/web2py/gluon/main.py", line 543, in > wsgibase > > BaseAdapter.close_all_instances('rollback') > File "/home/egasolin/public_html/web2py/gluon/dal.py", line 558, in > close_all_instances > > db._adapter.close(action) > File "/home/egasolin/public_html/web2py/gluon/dal.py", line 538, in close > > getattr(self, action)() > File "/home/egasolin/public_html/web2py/gluon/dal.py", line 1792, in > rollback > > return self.connection.rollback() > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/dbapi.py", > line 455, in _fn > > return fn(self, *args, **kwargs) > > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/dbapi.py", > line 551, in rollback > > self.conn.rollback() > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/interface.py", > line 622, in rollback > > self._rollback.execute() > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/interface.py", > line 166, in execute > > self.c.close_portal(self._portal_name) > > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/protocol.py", > line 1326, in close_portal > > reader.handle_messages() > File "/home/egasolin/public_html/web2py/gluon/contrib/pg8000/protocol.py", > line 937, in handle_messages > > raise InternalError("Unexpected response msg %r" % (msg)) > InternalError: Unexpected response msg > <gluon.contrib.pg8000.protocol.BindComplete object at 0xd03ddd0> > > And the request of this error > > request > ajax:False > application:egasolinerasargs:AlmeriaCarbonerasBiodiesel7cid > :Noneclient:66.249.73.180controller > :defaultcookies:env: > DOCUMENT_ROOT:/home/egasolin/public_htmlHTTP_ACCEPT:*/*HTTP_ACCEPT_ENCODING:gzip,deflateHTTP_CONNECTION > :Keep-aliveHTTP_FROM:googlebot(at)googlebot.comHTTP_HOST:www.egasolineras.com > HTTP_IF_MODIFIED_SINCE:Sun, 19 Jan 2014 10:38:02 > GMTHTTP_USER_AGENT:Mozilla/5.0 (iPhone; CPU iPhone OS 6_0 like Mac OS X) > AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5376e > Safari/8536.25 (compatible; Googlebot-Mobile/2.1; > +http://www.google.com/bot.html)PASSENGER_CONNECT_PASSWORD:D5uxRfOeOstOZBc2S0ljydHmPPZDK0kvgdO3Fdhefd3 > PATH_INFO:/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7QUERY_STRING: > REMOTE_ADDR:66.249.73.180REMOTE_PORT:53321REQUEST_METHOD:GET > REQUEST_URI:/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7SCRIPT_NAME > : > SERVER_ADDR:199.195.119.66SERVER_ADMIN: > SERVER_NAME:www.egasolineras.comSERVER_PORT:80SERVER_PROTOCOL > :HTTP/1.1SERVER_SOFTWARE:ApacheUNIQUE_ID:UvYC0MfDd0IAD7aIbNEAAAAIapp_folders:set(['/home/egasolin/public_html/web2py/applications/egasolineras/', > '/home/egasolin/public_html/web2py/applications/egasolinerasdev/', > '/home/egasolin/public_html/web2py/applications/admin/'])applications_parent:/home/egasolin/public_html/web2pydb_sessions:set([])debugging:False > document_root:/home/egasolin/public_htmlgluon_parent:/home/egasolin/public_html/web2pyhttp_accept:*/*http_accept_encoding > :gzip,deflatehttp_connection:Keep-alivehttp_from:googlebot(at)googlebot.comhttp_host > :www.egasolineras.comhttp_if_modified_since:Sun, 19 Jan 2014 10:38:02 > GMThttp_user_agent:Mozilla/5.0 (iPhone; CPU iPhone OS 6_0 like Mac OS X) > AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10A5376e > Safari/8536.25 (compatible; Googlebot-Mobile/2.1; > +http://www.google.com/bot.html)is_jython:Falseis_pypy > :Falseis_source:Truelocal_hosts > :a2s79.a2hosting.com::ffff:127.0.0.1::1199.195.119.66www.egasolineras.com127.0.0.1 > passenger_connect_password:D5uxRfOeOstOZBc2S0ljydHmPPZDK0kvgdO3Fdhefd3path_info > :/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7query_string: > > remote_addr:66.249.73.180remote_port:53321 > request_method:GETrequest_uri:/egasolineras/default/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7script_name: > server_addr > :199.195.119.66server_admin: > server_name:www.egasolineras.comserver_port > :80server_protocol:HTTP/1.1server_software:Apacheunique_id:UvYC0MfDd0IAD7aIbNEAAAAI > web2py_original_uri:/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7web2py_path > :/home/egasolin/public_html/web2pyweb2py_version:2.7.4-stable+timestamp.2013.10.14.15.16.29wsgi.errors:<open > file '<stderr>', mode 'w' at 0x7f5605a4b1e0> > wsgi.input:<socket._fileobject object at > 0xd48c750>wsgi.multiprocess:Truewsgi.multithread:Falsewsgi.run_once > :Truewsgi.url_scheme:httpwsgi.version > :10wsgi_errors:<open file '<stderr>', mode 'w' at 0x7f5605a4b1e0>wsgi_input > :<socket._fileobject object at 0xd48c750>wsgi_multiprocess:True > wsgi_multithread:Falsewsgi_run_once:True > wsgi_url_scheme:httpwsgi_version:10extension:htmlfolder:/home/egasolin/public_html/web2py/applications/egasolineras/ > function:gasolineras_mas_baratasglobal_settings:app_folders:set(['/home/egasolin/public_html/web2py/applications/egasolineras/', > '/home/egasolin/public_html/web2py/applications/egasolinerasdev/', > '/home/egasolin/public_html/web2py/applications/admin/'])applications_parent:/home/egasolin/public_html/web2pydb_sessions:set([])debugging:False > gluon_parent:/home/egasolin/public_html/web2pyis_jython:Falseis_pypy:Falseis_source:Truelocal_hosts:a2s79.a2hosting.com::ffff:127.0.0.1::1199.195.119.66www.egasolineras.com127.0.0.1web2py_version:2.7.4-stable+timestamp.2013.10.14.15.16.29is_https:Falseis_local > :Falseis_restful:Falsenow > :datetime.datetime(2014, 2, 8, 5, 11, 28, > 201380)url:/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7utcnow:datetime.datetime(2014, > 2, 8, 10, 11, 28, > 201397)uuid:egasolineras/66.249.73.180.2014-02-08.05-11-28.9e2bf71f-3004-44e3-8f18-18f251bfbad7wsgi > :<gluon.main.LazyWSGI object at 0xd48f310> > > My PostgreSQL is 9.1.11 version, with Postgis installed > > When the bot is spidering, the web is raising this errors, but when the bot > leaves, all back to normallity. > > And all the address that the bot is scanning, works perfectly, for exemple, > the above is > www.egasolineras.com/gasolineras-mas-baratas/Almeria/Carboneras/Biodiesel/7 > > Any ideas? Thanks > > > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
