Hi, It's a SQLite database problem, so you can do following:
- Take the backup of the '*pgadmin4.db*' file and then delete it. - Restart the pgAdmin4 Thanks, Khushboo On Sat, Nov 7, 2020 at 1:12 PM Nagaraj Raj <nagaraj...@yahoo.com> wrote: > 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 >
