Обсуждение: Connection error after upgrading to v4.4
Hi
I upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before:
SSL SYSCALL error: Software caused connection abort (0x00002745/10053)
Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3?
Regards
Calle
HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle@hisp.org
E-mail2: calle.hedberg@gmail.com
Skype: calle_hedberg
On Fri, Apr 5, 2019 at 4:59 AM Calle Hedberg <calle.hedberg@gmail.com> wrote:
HiI upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before:SSL SYSCALL error: Software caused connection abort (0x00002745/10053)Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3?
Please check your psycopg2 version. Make sure it should be 2.7.7.
RegardsCalleHISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle@hisp.org
E-mail2: calle.hedberg@gmail.com
Skype: calle_hedberg
On Fri, Apr 5, 2019 at 12:29 AM Calle Hedberg <calle.hedberg@gmail.com> wrote:
HiI upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before:SSL SYSCALL error: Software caused connection abort (0x00002745/10053)Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3?
What scripts (and what platform etc)? Are you using the pgAdmin virtual environment for your own code? If so, that's really not something we support or test in any way.
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Dave,
The scripts are just normal select, update and delete queries, running in the script window against a remote server (logged in using pgremote).
In any case - I rebooted everything and haven't seen the error again, so it might have been caused by some intermittent problem.
Best regards
Calle
On Fri, 5 Apr 2019 at 10:12, Dave Page <dpage@pgadmin.org> wrote:
On Fri, Apr 5, 2019 at 12:29 AM Calle Hedberg <calle.hedberg@gmail.com> wrote:HiI upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before:SSL SYSCALL error: Software caused connection abort (0x00002745/10053)Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3?What scripts (and what platform etc)? Are you using the pgAdmin virtual environment for your own code? If so, that's really not something we support or test in any way.--Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle@hisp.org
E-mail2: calle.hedberg@gmail.com
Skype: calle_hedberg
Hi
On Fri, Apr 5, 2019 at 12:41 PM Calle Hedberg <calle.hedberg@gmail.com> wrote:
Dave,The scripts are just normal select, update and delete queries, running in the script window against a remote server (logged in using pgremote).
I'm not sure what pgremote is, and Google isn't being helpful
In any case - I rebooted everything and haven't seen the error again, so it might have been caused by some intermittent problem.
That's good :-)
Best regardsCalleOn Fri, 5 Apr 2019 at 10:12, Dave Page <dpage@pgadmin.org> wrote:On Fri, Apr 5, 2019 at 12:29 AM Calle Hedberg <calle.hedberg@gmail.com> wrote:HiI upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before:SSL SYSCALL error: Software caused connection abort (0x00002745/10053)Would any of the 4.4 fixes or changes cause this issue? If yes, anything I can do or should I revert back to 4.3?What scripts (and what platform etc)? Are you using the pgAdmin virtual environment for your own code? If so, that's really not something we support or test in any way.--Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company--HISP
Researcher & Technical Specialist
Health Information Systems Programme – South Africa
Cell: +47 41461011 (Norway)
Iridium SatPhone: +8816-315-19119 (usually OFF)
E-mail1: calle@hisp.org
E-mail2: calle.hedberg@gmail.com
Skype: calle_hedberg
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company