Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427

Поиск
Список
Период
Сортировка
От Khushboo Vashi
Тема Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427
Дата
Msg-id CAFOhELfrot=8=xANwVt6zP1i0EuwziTU_OiY0Bm1cCg_yuY4fA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427  (Nagaraj Raj <nagaraj.sf@yahoo.com>)
Ответы Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427  (Nagaraj Raj <nagaraj.sf@yahoo.com>)
Список 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.sf@yahoo.com> wrote:
any suggestions?

On Friday, November 6, 2020, 12:22:44 PM PST, Nagaraj Raj <nagaraj.sf@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

В списке pgadmin-support по дате отправления:

Предыдущее
От: Nagaraj Raj
Дата:
Сообщение: Re: qlalchemy.exc.OperationalError: pgadmin4 startup error after upgrade version to v427
Следующее
От: Khushboo Vashi
Дата:
Сообщение: Re: display bigint precision problem in pgAdmin4 ?