Try to uninstall psycopg2-* and reinstall only psycopg2-binary On Wed, Jan 23, 2019 at 11:52 AM Massimiliano <mbelle...@gmail.com> wrote:
> Could be. > > When you strart web2py it show database driver available: > Mine: > Database drivers available: psycopg2, pymysql, imaplib, sqlite3, pg8000, > pyodbc, pymongo > > > > > On Wed, Jan 23, 2019 at 10:59 AM Lisandro <rostagnolisan...@gmail.com> > wrote: > >> Thanks Massimiliano. >> >> Apparently psycopg2 is already installed (of course it was already >> installed, maybe something broke during the packages upgrade). >> Something weird is that I see psycopg2 installed twice, is this correct? >> >> ~$ pip freeze | grep psycopg2 >> psycopg2==2.7.5 >> psycopg2-binary==2.7.5 >> >> Could this be the source of the problem? >> I don't see how. For what I understand, using or not using pgBouncer in >> the middle is transparent to the web2py application: it always connects in >> the same way, the application doesn't know if its connecting to PostgreSQL >> or pgBouncer. I think that's the whole idea of pgBouncer, to act as a >> middle man, pooling connections, behaving as if the application was >> connected directly to PostgreSQL. >> >> Any comment or suggestion will be much appreciated. >> >> El miércoles, 23 de enero de 2019, 6:51:06 (UTC-3), Massimiliano escribió: >>> >>> Have you tried to install psycopg2? Is the standard de facto postgresql >>> driver. >>> The pip package should be psycopg2-binary >>> >>> On Wed, Jan 23, 2019 at 10:39 AM Lisandro <rostagno...@gmail.com> wrote: >>> >>>> Hi there! Yesterday I had a MAJOR downtime and I would need your help >>>> to understand what happened. >>>> >>>> The team that is in charge of upgrading security packages at my server >>>> (CentOS 7 at Linode) did an update that involved an upgrade to pgBouncer. >>>> Accordingly to what they said, they noticed pgBouncer was throwing errors >>>> after the upgrade, so they downgraded to the previous version that was >>>> installed. But sadly the problem remained. After this upgrade/downgrade of >>>> pgBouncer, all the attempts of connecting from my web2py app to pgBouncer >>>> fail. >>>> >>>> Inside of postgresql.log I can see lot of this: >>>> 2019-01-22 14:39:37 -03 ERROR: prepared statement «pg8000_statement_0» >>>> already exists >>>> 2019-01-22 14:39:37 -03 SENTENCIA: begin transaction >>>> 2019-01-22 14:39:38 -03 ERROR: prepared statement «pg8000_statement_0» >>>> already exists >>>> 2019-01-22 14:39:38 -03 SENTENCIA: begin transaction >>>> >>>> I've noticed that "pg8000_statement_0" is referenced at line 1894 in >>>> gluon/contrib/pg8000/core.py, but I can't realise if there is something I >>>> could do to avoid the error. >>>> I'm using web2py Version 2.16.1-stable+timestamp.2017.11.14.05.54.25, >>>> and I've noticed that gluon/contrib/pg8000/core.py isn't anymore in version >>>> 2.17.1. >>>> >>>> Of course I've tried restarting al the involved services, but nothing >>>> worked. Every time my web2py application tries to connect to the database, >>>> if pgBouncer is at the middle, the 5 attempts fail and those lines are >>>> printed to the postgresql.log. Right now I've bypassed pgbouncer and my >>>> application is connecting directly to postgresql. >>>> >>>> Could you put some lights into this? What can I do to avoid that error >>>> and still connect to pgBouncer with web2py 2.16.1? >>>> >>>> Thank you very much in advance. >>>> Regards, Lisandro. >>>> >>>> -- >>>> 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 web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> -- >>> Massimiliano >>> >> -- >> 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 web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > > -- > Massimiliano > -- Massimiliano -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
