search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
192 stars 37 forks source link

Error: The session ID returned by provider "PGSQL" for connection xxx is invalid. #423

Closed dtieppo closed 11 months ago

dtieppo commented 1 year ago

It is the second time that I update the app and have posterior issues with the connections using PostgresSQL. Tried to install extension from vsix, got connected although getting the following error: The session ID returned by provider "PGSQL" for connection xx is invalid. Already reviewed connections and re-installed ADS. What else can be done? Thanks!

tlunsfordCXP commented 1 year ago

Same problem here. Would love to go back to a previous version, but only the current version is available in the extension.

DaeunYim commented 1 year ago

Can you provide the desktop platform and PG version please?

You can download the previous version here.

dtieppo commented 1 year ago

Windows 10 64bit, PG 0.4.2

dtieppo commented 1 year ago

Version 0.3.1 worked. Let´s see how much it lasts.

DaeunYim commented 1 year ago

Same problem here. Would love to go back to a previous version, but only the current version is available in the extension.

We will work on the fix. Did restating ADS not fix the issue at all?

liamhollohan commented 1 year ago

Restarting ADS fixed for me. Would still appreciate a longer term solution. v0.4.2

DaeunYim commented 1 year ago

Closing after stable release

nasc17 commented 1 year ago

Hello, issue has been addressed in our unstable release of PostgreSQL extension v0.4.3-insiders. We would appreciate your verification that it has been handled appropriately.

nasc17 commented 12 months ago

Bug has been addressed in latest stable release of PostgreSQL extension v0.5.0. Please reopen if issue is still present, thank you.

dtieppo commented 12 months ago

Once updated both ADS and extension, failed, same message. I would need to install an older version like I did before but this new extension installed by itself.

On Thu, Aug 3, 2023 at 9:15 AM nasc17 @.***> wrote:

Bug has been addressed in latest stable release of PostgreSQL extension v0.5.0. Please reopen if issue is still present, thank you.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio-postgresql/issues/423#issuecomment-1664067958, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARC5AMIMUHYD4BM5LTYHJ3LXTOW7BANCNFSM6AAAAAAZ7DFH7I . You are receiving this because you authored the thread.Message ID: @.***>

nasc17 commented 12 months ago

@dtieppo Could you please try the following steps?

Navigate to C:\Users.azuredatastudio\extensions and clear out any existing PostgreSQL extensions. (Don't worry about losing your connection info, they will appear once you re-install the extension)

Open your file explorer, go to the %temp% location, and remove any folders named _MEI<6digit number> if they exist.

Once you've completed these steps, please try downloading and installing the new version of the PostgreSQL extension again.

Please let us know if this resolves the issue or if you need further assistance.

dtieppo commented 11 months ago

Resolved! Thank you very much!

On Thu, Aug 3, 2023 at 10:07 AM nasc17 @.***> wrote:

@dtieppo https://github.com/dtieppo Could you please try the following steps?

Navigate to C:\Users.azuredatastudio\extensions and clear out any existing PostgreSQL extensions. (Don't worry about losing your connection info, they will appear once you re-install the extension)

Open your file explorer, go to the %temp% location, and remove any folders named _MEI<6digit number> if they exist.

Once you've completed these steps, please try downloading and installing the new version of the PostgreSQL extension again.

Please let us know if this resolves the issue or if you need further assistance.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio-postgresql/issues/423#issuecomment-1664161756, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARC5AMMI6P4L66Y3TEGN3YLXTO5CRANCNFSM6AAAAAAZ7DFH7I . You are receiving this because you were mentioned.Message ID: @.***>