From: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> |
Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427 |
Date: | 2020-11-09 02:33:38 |
Message-ID: | CAFOhELfrot=8=xANwVt6zP1i0EuwziTU_OiY0Bm1cCg_yuY4fA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)sf(at)yahoo(dot)com> wrote:
> any suggestions?
>
> On Friday, November 6, 2020, 12:22:44 PM PST, Nagaraj Raj <
> nagaraj(dot)sf(at)yahoo(dot)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(at)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Khushboo Vashi | 2020-11-09 02:44:40 | Re: display bigint precision problem in pgAdmin4 ? |
Previous Message | Nagaraj Raj | 2020-11-07 07:42:27 | Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427 |