Обсуждение: browser disconnects from pgAdmin4 server

Поиск
Список
Период
Сортировка

browser disconnects from pgAdmin4 server

От
Gabriel Sánchez
Дата:
Hi all,

I have pgAdmin4 server running on Ubuntu 18.04 server with Apache, and I connect to it from my laptop using Firefox, which works well.  One inconvenience is that my browser's session disconnects from the pgAdmin4 server after a long time, so usually if I leave work pending at night to be continued the next day, when I resume work in the morning pgAdmin can't be used because it is not connected (and it won't reconnect).  My work-around is to copy any open queries to a text editor, refresh the page, sign in to pgAdmin, and open new tabs and copy the queries back from my text editor.  Of course, any temporary tables are lost and I must also recreate them.  Does anyone in the community know how to make sessions last longer?  Perhaps there is a setting in one of the pgAdmin config files or Apache?

Thanks,
Gabriel

Re: browser disconnects from pgAdmin4 server

От
"Strauch, Sheldon"
Дата:
Hello Gabriel!

Are you using an Apple Mac as your laptop per chance? We encountered this issue at my workplace as well. it turns out that our infrastructure team needed to update our Ubuntu kernel to correct issues with the network stack. This didn't seem to bother our Windows users but regularly caused MacBook Pro running Mojave to drop network connections to the database server with great frequency:
  [ Ubuntu: 4.15.0-66.75 ]
   - tcp: fix tcp_ecn_withdraw_cwr() to clear TCP_ECN_QUEUE_CWR
   - tcp: Reset send_head when removing skb from write-queue  <<<<<
   - tcp: Don't dequeue SYN/FIN-segments from write-queue    <<<<<

HTH!

On Wed, Oct 30, 2019 at 8:14 AM Gabriel Sánchez <gabrielesanchez@gmail.com> wrote:
Hi all,

I have pgAdmin4 server running on Ubuntu 18.04 server with Apache, and I connect to it from my laptop using Firefox, which works well.  One inconvenience is that my browser's session disconnects from the pgAdmin4 server after a long time, so usually if I leave work pending at night to be continued the next day, when I resume work in the morning pgAdmin can't be used because it is not connected (and it won't reconnect).  My work-around is to copy any open queries to a text editor, refresh the page, sign in to pgAdmin, and open new tabs and copy the queries back from my text editor.  Of course, any temporary tables are lost and I must also recreate them.  Does anyone in the community know how to make sessions last longer?  Perhaps there is a setting in one of the pgAdmin config files or Apache?

Thanks,
Gabriel



--

Look after your data, and your database will look after you. -- Simon Riggs

Sheldon E. Strauch
Data Architect, Data Services 
O 312-676-1556
M 224-723-3878

Enova International, Inc.
This transmission is confidential and may be privileged or proprietary. If you are not the intended recipient, you are not authorized to use the information in this transmission in any way. Please inform the sender immediately if you have received this transmission in error and permanently delete and destroy the original and any copies of the information.    

Re: browser disconnects from pgAdmin4 server

От
Gabriel Sánchez
Дата:

On Wed, Oct 30, 2019 at 11:58 AM Strauch, Sheldon <sstrauch@enova.com> wrote:
Hello Gabriel!

Are you using an Apple Mac as your laptop per chance? We encountered this issue at my workplace as well. it turns out that our infrastructure team needed to update our Ubuntu kernel to correct issues with the network stack. This didn't seem to bother our Windows users but regularly caused MacBook Pro running Mojave to drop network connections to the database server with great frequency:
  [ Ubuntu: 4.15.0-66.75 ]
   - tcp: fix tcp_ecn_withdraw_cwr() to clear TCP_ECN_QUEUE_CWR
   - tcp: Reset send_head when removing skb from write-queue  <<<<<
   - tcp: Don't dequeue SYN/FIN-segments from write-queue    <<<<<


I run Ubuntu 18.04 desktop on a Lenovo laptop, and it's up to date, but perhaps it has the same issue.  Still, this doesn't happen with other websites, as far as I can tell.
 
HTH!

On Wed, Oct 30, 2019 at 8:14 AM Gabriel Sánchez <gabrielesanchez@gmail.com> wrote:
Hi all,

I have pgAdmin4 server running on Ubuntu 18.04 server with Apache, and I connect to it from my laptop using Firefox, which works well.  One inconvenience is that my browser's session disconnects from the pgAdmin4 server after a long time, so usually if I leave work pending at night to be continued the next day, when I resume work in the morning pgAdmin can't be used because it is not connected (and it won't reconnect).  My work-around is to copy any open queries to a text editor, refresh the page, sign in to pgAdmin, and open new tabs and copy the queries back from my text editor.  Of course, any temporary tables are lost and I must also recreate them.  Does anyone in the community know how to make sessions last longer?  Perhaps there is a setting in one of the pgAdmin config files or Apache?

Thanks,
Gabriel



--

Look after your data, and your database will look after you. -- Simon Riggs

Sheldon E. Strauch
Data Architect, Data Services 
O 312-676-1556
M 224-723-3878

Enova International, Inc.
This transmission is confidential and may be privileged or proprietary. If you are not the intended recipient, you are not authorized to use the information in this transmission in any way. Please inform the sender immediately if you have received this transmission in error and permanently delete and destroy the original and any copies of the information.