Latest pgAdmin4 builds w/o errors, and you may add PostgreSQL servers in the web gui. As soon as you want to connect to a database, you get an internal server error from pgAdmin: 'psycopg2.extensions.Column' object has no attribute '_asdict' The web gui then cannot collapse any database object in the tree view. # equery u pgadmin4 [ Legend : U - final flag setting for installation] [ : I - package is installed with flag ] [ Colors : set, unset ] * Found these USE flags for dev-db/pgadmin4-4.30-r2: U I - - doc : Add extra documentation (API, Javadoc, etc). It is recommended to enable per package instead of globally - - python_single_target_python3_8 : Build for Python 3.8 only + + python_single_target_python3_9 : Build for Python 3.9 only # equery u psycopg [ Legend : U - final flag setting for installation] [ : I - package is installed with flag ] [ Colors : set, unset ] * Found these USE flags for dev-python/psycopg-2.9.1: U I - - debug : Enable extra debug codepaths, like asserts and extra output. If you want to get meaningful backtraces see https://wiki.gentoo.org/wiki/Project:Quality_Assurance/Backtraces - - python_targets_python3_10 : Build with Python 3.10 - - python_targets_python3_8 : Build with Python 3.8 + + python_targets_python3_9 : Build with Python 3.9 - - test : Enable dependencies and/or preparations necessary to run tests (usually controlled by FEATURES=test but can be toggled independently)
Got the same error with the stable version dev-db/pgadmin4-4.29-r2. Downgrading dev-python/psycopg from version 2.9.1 to 2.8.6-r1 fixed it. (Had to fetch the ebuild from https://github.com/gentoo/gentoo/raw/bd416ab339944869da9c8dd68c3f1b56c14d0c91/dev-python/psycopg/psycopg-2.8.6-r1.ebuild as it's not in the tree anymore.)
(In reply to Horst Prote from comment #1) > Got the same error with the stable version dev-db/pgadmin4-4.29-r2. > > Downgrading dev-python/psycopg from version 2.9.1 to 2.8.6-r1 fixed it. > (Had to fetch the ebuild from > https://github.com/gentoo/gentoo/raw/ > bd416ab339944869da9c8dd68c3f1b56c14d0c91/dev-python/psycopg/psycopg-2.8.6-r1. > ebuild as it's not in the tree anymore.) Same, canNOT use pgAdmin4 anymore. What's the procedure to downgrade?
The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=75636d2c85c8ea622e57847bd011bedbad5bb597 commit 75636d2c85c8ea622e57847bd011bedbad5bb597 Author: Sam James <sam@gentoo.org> AuthorDate: 2021-10-24 07:33:12 +0000 Commit: Sam James <sam@gentoo.org> CommitDate: 2021-10-24 07:33:38 +0000 dev-python/psycopg: restore 2.8.6-r1 Still needed by users for pgadmin4. Bug: https://bugs.gentoo.org/817350 Reverts: 349546c832a79c9e8c978c3fa2eaa5c48d5eca35~1 Signed-off-by: Sam James <sam@gentoo.org> dev-python/psycopg/Manifest | 1 + dev-python/psycopg/psycopg-2.8.6-r1.ebuild | 55 ++++++++++++++++++++++++++++++ 2 files changed, 56 insertions(+)
The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=f774f5b707ca3ac73680cc21478c97db4da0e281 commit f774f5b707ca3ac73680cc21478c97db4da0e281 Author: Sam James <sam@gentoo.org> AuthorDate: 2021-10-24 07:34:56 +0000 Commit: Sam James <sam@gentoo.org> CommitDate: 2021-10-24 07:34:56 +0000 dev-db/pgadmin4: add upper bound on psycopg version Runtime failures with newer versions. Bug: https://bugs.gentoo.org/817350 Signed-off-by: Sam James <sam@gentoo.org> dev-db/pgadmin4/{pgadmin4-4.29-r2.ebuild => pgadmin4-4.29-r3.ebuild} | 2 +- dev-db/pgadmin4/{pgadmin4-4.30-r2.ebuild => pgadmin4-4.30-r3.ebuild} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-)
(In reply to sevilla.larry from comment #2) > (In reply to Horst Prote from comment #1) > > Got the same error with the stable version dev-db/pgadmin4-4.29-r2. > > > > Downgrading dev-python/psycopg from version 2.9.1 to 2.8.6-r1 fixed it. > > (Had to fetch the ebuild from > > https://github.com/gentoo/gentoo/raw/ > > bd416ab339944869da9c8dd68c3f1b56c14d0c91/dev-python/psycopg/psycopg-2.8.6-r1. > > ebuild as it's not in the tree anymore.) > > Same, canNOT use pgAdmin4 anymore. > > What's the procedure to downgrade? The old versions should be back in tree now. https://forums.gentoo.org/viewtopic-t-1122788-start-0.html / https://wiki.gentoo.org/wiki/Handbook:AMD64/Portage/CustomTree#Defining_a_custom_ebuild_repository
Downgrading dev-python/psycopg or rebuilding pgAdmin4 from latest portage tree fixed it. Thanks, Felix
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=8b0fa104cddcbb9dd7bca9351c2de58703939fcf commit 8b0fa104cddcbb9dd7bca9351c2de58703939fcf Author: Jakov Smolić <jsmolic@gentoo.org> AuthorDate: 2022-06-19 08:51:37 +0000 Commit: Jakov Smolić <jsmolic@gentoo.org> CommitDate: 2022-06-19 08:51:53 +0000 dev-db/pgadmin4: treeclean Closes: https://bugs.gentoo.org/794460 Closes: https://bugs.gentoo.org/836282 Closes: https://bugs.gentoo.org/774348 Closes: https://bugs.gentoo.org/766378 Closes: https://bugs.gentoo.org/817350 Signed-off-by: Jakov Smolić <jsmolic@gentoo.org> dev-db/pgadmin4/Manifest | 2 - dev-db/pgadmin4/files/pgadmin4.desktop | 11 --- dev-db/pgadmin4/metadata.xml | 8 -- dev-db/pgadmin4/pgadmin4-4.29-r3.ebuild | 130 ------------------------------- dev-db/pgadmin4/pgadmin4-4.30-r3.ebuild | 132 -------------------------------- profiles/package.mask | 6 -- 6 files changed, 289 deletions(-)
