Message-ID: <a4dbbc0d-51d3-7db0-cd7a-fb7e32746ac6@jakobs.com>
Date: Mon, 5 Jun 2023 16:33:06 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Subject: Re: Fatal Error KeyError: 'ck_port_range' after upgrade
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAGk0fxhm-HiDAy13fm9AqMZoopYp_3aRwcojXcW_SJX1jWui7w@mail.gmail.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: 
 <CAGk0fxhm-HiDAy13fm9AqMZoopYp_3aRwcojXcW_SJX1jWui7w@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------vdjVgy4MNhEoVIMTOWSHFTUe"
Archived-At: 
 <https://www.postgresql.org/message-id/a4dbbc0d-51d3-7db0-cd7a-fb7e32746ac6%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------vdjVgy4MNhEoVIMTOWSHFTUe
Content-Type: multipart/mixed; boundary="------------cL3ZIkh540039Pygatk2wcuz";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <a4dbbc0d-51d3-7db0-cd7a-fb7e32746ac6@jakobs.com>
Subject: Re: Fatal Error KeyError: 'ck_port_range' after upgrade
References: <CAGk0fxhm-HiDAy13fm9AqMZoopYp_3aRwcojXcW_SJX1jWui7w@mail.gmail.com>
In-Reply-To: <CAGk0fxhm-HiDAy13fm9AqMZoopYp_3aRwcojXcW_SJX1jWui7w@mail.gmail.com>

--------------cL3ZIkh540039Pygatk2wcuz
Content-Type: multipart/alternative;
 boundary="------------mZwz9Cyff9Xr3Y6NczKQkgEz"

--------------mZwz9Cyff9Xr3Y6NczKQkgEz
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMDUuMDYuMjMgdW0gMTY6MTEgc2NocmllYiBNYXJrIE1jTWlsbGFuOg0KPiBIZWxsbywg
SSB1cGdyYWRlZCB0byBwZ0FkbWluIDQgdjcgKGZyb20gdjMgSSB0aGluaykgb24gV2luZG93
cyBhbmQgSSANCj4gY2Fubm90IHN0YXJ0IHBnQWRtaW4gYW55IG1vcmUsIHRoZSBmYXRhbCBl
cnJvciBzYXlzOg0KPg0KPiAyMDIzLTA2LTA1IDA5OjUxOjU4LDE5MDogRVJST1IgcGdhZG1p
bjogRGF0YWJhc2UgbWlncmF0aW9uIGZhaWxlZA0KPg0KPiAyMDIzLTA2LTA1IDA5OjUxOjU4
LDE5NDogRVJST1IgcGdhZG1pbjogVHJhY2ViYWNrIChtb3N0IHJlY2VudCBjYWxsIGxhc3Qp
Og0KPiDCoCBGaWxlICJDOlxVc2Vyc1xNYXJrXEFwcERhdGFcTG9jYWxcUHJvZ3JhbXNccGdB
ZG1pbiANCj4gNFx2N1xweXRob25cbGliXHNpdGUtcGFja2FnZXNcYWxlbWJpY1xvcGVyYXRp
b25zXGJhdGNoLnB5IiwgbGluZSA2OTIsIA0KPiBpbiBkcm9wX2NvbnN0cmFpbnQNCj4gwqAg
wqAgY29uc3QgPSBzZWxmLm5hbWVkX2NvbnN0cmFpbnRzLnBvcChjb25zdC5uYW1lIDxodHRw
Oi8vY29uc3QubmFtZT4pDQo+IEtleUVycm9yOiAnY2tfcG9ydF9yYW5nZScNCj4NCj4gSSBj
YW5ub3QgZmluZCBhbnkgcmVmZXJlbmNlIHRvIHRoaXMgZXJyb3IgaW4gdGhlIG1haWwgbGlz
dCBhcmNoaXZlcyBvciANCj4gb25saW5lLiBBbnkgaGVscCB3b3VsZCBiZSBhcHByZWNpYXRl
ZC4uLi4NCg0KDQpJIHdvdWxkIGJlIGEgZ29vZCBpZGVhIHRvIGFzayBvbiB0aGUgYXBwcm9w
cmlhdGUgbWFpbGluZyBsaXN0IG9mIA0KcGdhZG1pbi4gVGhpcyBsaXN0IGlzIGFib3V0IHRo
ZSBwb3N0Z3Jlc3FsIHNlcnZlci4NCg0KDQotLSANCkhvbGdlciBKYWtvYnMsIEJlcmdpc2No
IEdsYWRiYWNoLCBUZWwuICs0OS0xNzgtOTc1OTAxMg0KDQo=
--------------mZwz9Cyff9Xr3Y6NczKQkgEz
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
  <head>
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF=
-8">
  </head>
  <body>
    <div class=3D"moz-cite-prefix">Am 05.06.23 um 16:11 schrieb Mark
      McMillan:<br>
    </div>
    <blockquote type=3D"cite"
cite=3D"mid:CAGk0fxhm-HiDAy13fm9AqMZoopYp_3aRwcojXcW_SJX1jWui7w@mail.gmai=
l.com">
      <meta http-equiv=3D"content-type" content=3D"text/html; charset=3DU=
TF-8">
      <div dir=3D"ltr">Hello, I upgraded to pgAdmin 4 v7 (from v3 I think=
)
        on Windows and I cannot start pgAdmin any more, the fatal error
        says:<br>
        <br>
        2023-06-05 09:51:58,190: ERROR pgadmin: Database migration
        failed<br>
        <br>
        2023-06-05 09:51:58,194: ERROR pgadmin: Traceback (most recent
        call last):<br>
        =C2=A0 File "C:\Users\Mark\AppData\Local\Programs\pgAdmin
        4\v7\python\lib\site-packages\alembic\operations\batch.py", line
        692, in drop_constraint<br>
        =C2=A0 =C2=A0 const =3D self.named_constraints.pop(<a
          href=3D"http://const.name" moz-do-not-send=3D"true">const.name<=
/a>)<br>
        KeyError: 'ck_port_range'<br>
        <div><br>
        </div>
        <div>I cannot find any reference to this error in the mail list
          archives or online. Any help would be appreciated....</div>
      </div>
    </blockquote>
    <p><br>
    </p>
    <p>I would be a good idea to ask on the appropriate mailing list of
      pgadmin. This list is about the postgresql server.<br>
    </p>
    <p><br>
    </p>
    <pre class=3D"moz-signature" cols=3D"72">--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
  </body>
</html>

--------------mZwz9Cyff9Xr3Y6NczKQkgEz--

--------------cL3ZIkh540039Pygatk2wcuz--

--------------vdjVgy4MNhEoVIMTOWSHFTUe
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZH3yIgUDAAAAAAAKCRCKV5yTsxlhutx3
AJ9EvzKC5WCsqG4tDWJAvwse2BCVIgCgnxone1JeQCcH51SfrvWl6QT3pVE=
=IwZR
-----END PGP SIGNATURE-----

--------------vdjVgy4MNhEoVIMTOWSHFTUe--