any suggestions?
On Friday, November 6, 2020, 12:22:44 PM PST, Nagaraj Raj
<nagaraj...@yahoo.com> wrote:
I'm not able to start pgadmin4 server mode after after upgrade, it throwing
the error "qlalchemy.exc.OperationalError: (sqlite3.OperationalError) duplicate
column name: hostaddr"
[root@dev-e2 ~]# systemctl status pgadmin4
● pgadmin4.service - pgAdmin4 Server Mode
Loaded: loaded (/usr/lib/systemd/system/pgadmin4.service; disabled; vendor
preset: disabled)
Active: failed (Result: exit-code) since Fri 2020-11-06 15:17:32 EST; 5s ago
Docs: https://www.pgadmin.org/docs/
Process: 9941 ExecStart=/usr/bin/python3
/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py (code=exited,
status=1/FAILURE)
Main PID: 9941 (code=exited, status=1/FAILURE)
Nov 06 15:17:32 dev-din-pgs-w2a-e2 python3[9941]: File
"/usr/lib/python3.6/site-packages/pgadmin4-web/sqlalchemy/engine/base.py", line
1246, in _execute_context
Nov 06 15:17:32 python3[9941]: cursor, statement, parameters, context
Nov 06 15:17:32 python3[9941]: File
"/usr/lib/python3.6/site-packages/pgadmin4-web/sqlalchemy/engine/default.py",
line 588, in do_execute
Nov 06 15:17:32 python3[9941]: cursor.execute(statement, parameters)
Nov 06 15:17:32 python3[9941]: sqlalchemy.exc.OperationalError:
(sqlite3.OperationalError) duplicate column name: hostaddr
Nov 06 15:17:32 python3[9941]: [SQL: ALTER TABLE server ADD COLUMN hostaddr
TEXT(1024)]
Nov 06 15:17:32 python3[9941]: (Background on this error at:
http://sqlalche.me/e/e3q8)
Nov 06 15:17:32 systemd[1]: pgadmin4.service: main process exited,
code=exited, status=1/FAILURE
Nov 06 15:17:32 systemd[1]: Unit pgadmin4.service entered failed state.
Nov 06 15:17:32 systemd[1]: pgadmin4.service failed.
Thanks
