Thread: Fatal Error KeyError: 'ck_port_range' after upgrade
Hello, I upgraded to pgAdmin 4 v7 (from v3 I think) on Windows and I cannot start pgAdmin any more, the fatal error says:
2023-06-05 09:51:58,190: ERROR pgadmin: Database migration failed
2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Mark\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 692, in drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
2023-06-05 09:51:58,190: ERROR pgadmin: Database migration failed
2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Mark\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 692, in drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
I cannot find any reference to this error in the mail list archives or online. Any help would be appreciated....
Hello Mark,
Although I cannot help with this particular error, I would like to take this opportunity to compliment you on your surname!
Have a Wonderful Day,
Katie
From: Mark McMillan <mark@nc-mcmillans.com>
Sent: 05 June 2023 10:11
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Fatal Error KeyError: 'ck_port_range' after upgrade
Sent: 05 June 2023 10:11
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Fatal Error KeyError: 'ck_port_range' after upgrade
Attention : courriel externe | external email
Hello, I upgraded to pgAdmin 4 v7 (from v3 I think) on Windows and I cannot start pgAdmin any more, the fatal error says:
2023-06-05 09:51:58,190: ERROR pgadmin: Database migration failed
2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Mark\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 692, in drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
2023-06-05 09:51:58,190: ERROR pgadmin: Database migration failed
2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Mark\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 692, in drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'
I cannot find any reference to this error in the mail list archives or online. Any help would be appreciated....
Am 05.06.23 um 16:11 schrieb Mark McMillan:
Hello, I upgraded to pgAdmin 4 v7 (from v3 I think) on Windows and I cannot start pgAdmin any more, the fatal error says:
2023-06-05 09:51:58,190: ERROR pgadmin: Database migration failed
2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent call last):
File "C:\Users\Mark\AppData\Local\Programs\pgAdmin 4\v7\python\lib\site-packages\alembic\operations\batch.py", line 692, in drop_constraint
const = self.named_constraints.pop(const.name)
KeyError: 'ck_port_range'I cannot find any reference to this error in the mail list archives or online. Any help would be appreciated....
I would be a good idea to ask on the appropriate mailing list of pgadmin. This list is about the postgresql server.
-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012