Обсуждение: Backup database runs forever

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

Backup database runs forever

От
Yury Ramanousky
Дата:
Hello, 

I'm using pgAdmin 4.1 on Windows 10, PostgreSQL ver 9.6.1. 

I've started backup database process from the GUI. It was running for about 6 minutes than pgAdmin has unexpectedly stopped working. 
I've reopen pgAdmin. In the right bottom corner it is shown that backup is still running (http://prntscr.com/dcnxvm) . When I'm trying to connect to my databse via pgAdmin, pgAdmin crashes and stopes responding (http://prntscr.com/dcny1i). 

After reboot the problem is still here: 
Backup process shows as running in right bottom corner (272603.01 seconds running for now) and when I try to connect to my DB pgAdmin is stopping. Killing processes from task manager also have no effect. 

If needed I can provide additional information.

Will appreciate for any feedback.  

--
з павагай,
Раманоўскі Юрый

Re: Backup database runs forever

От
Ashesh Vashi
Дата:

On Mon, Nov 28, 2016 at 1:18 PM, Yury Ramanousky <udaff4eg@gmail.com> wrote:

Hello, 

I'm using pgAdmin 4.1 on Windows 10, PostgreSQL ver 9.6.1. 

I've started backup database process from the GUI. It was running for about 6 minutes than pgAdmin has unexpectedly stopped working. 
I've reopen pgAdmin. In the right bottom corner it is shown that backup is still running (http://prntscr.com/dcnxvm) .
Hi,

We've seen these reports, and a bug has been logged.
I am currently working on it.
 
When I'm trying to connect to my databse via pgAdmin, pgAdmin crashes and stopes responding (http://prntscr.com/dcny1i).  
Hmm..
I suspect - It should not be related to it.

Can you please check the pgAdmin logs for the same?

After reboot the problem is still here: 
Backup process shows as running in right bottom corner (272603.01 seconds running for now) and when I try to connect to my DB pgAdmin is stopping. Killing processes from task manager also have no effect. 
It fetches the information from the configuration file, which does not have information of the background process finished/cancelled/did not start at all.
 

If needed I can provide additional information.
Thanks.
I may contact you later for the same.

Will appreciate for any feedback.  

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



--
з павагай,
Раманоўскі Юрый

Re: Backup database runs forever

От
Ashesh Vashi
Дата:
Hi Yury,

To remove those messages, you can follow the below instructions:
* Download the "DB Browser for SQLite" from  http://sqlitebrowser.org/ and install it.
* Start it.
* Stop pgAdmin 4 (if running).
* Open the file "%APPDATA%\pgAdmin\pgAdmin4.db"
* Go to "Execute SQL" tab, and run the query "DELETE FROM process".
* Commit changes by "File -> Write Changes"
* Exit


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Mon, Nov 28, 2016 at 1:23 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Mon, Nov 28, 2016 at 1:18 PM, Yury Ramanousky <udaff4eg@gmail.com> wrote:

Hello, 

I'm using pgAdmin 4.1 on Windows 10, PostgreSQL ver 9.6.1. 

I've started backup database process from the GUI. It was running for about 6 minutes than pgAdmin has unexpectedly stopped working. 
I've reopen pgAdmin. In the right bottom corner it is shown that backup is still running (http://prntscr.com/dcnxvm) .
Hi,

We've seen these reports, and a bug has been logged.
I am currently working on it.
 
When I'm trying to connect to my databse via pgAdmin, pgAdmin crashes and stopes responding (http://prntscr.com/dcny1i).  
Hmm..
I suspect - It should not be related to it.

Can you please check the pgAdmin logs for the same?

After reboot the problem is still here: 
Backup process shows as running in right bottom corner (272603.01 seconds running for now) and when I try to connect to my DB pgAdmin is stopping. Killing processes from task manager also have no effect. 
It fetches the information from the configuration file, which does not have information of the background process finished/cancelled/did not start at all.
 

If needed I can provide additional information.
Thanks.
I may contact you later for the same.

Will appreciate for any feedback.  

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



--
з павагай,
Раманоўскі Юрый


Re: [pgadmin-support] Backup database runs forever

От
Sibylle Koczian
Дата:
Am 28.11.2016 um 08:48 schrieb Yury Ramanousky:
> Hello,
>
> I'm using pgAdmin 4.1 on Windows 10, PostgreSQL ver 9.6.1.
>
> I've started backup database process from the GUI. It was running for
> about 6 minutes than pgAdmin has unexpectedly stopped working.
> I've reopen pgAdmin. In the right bottom corner it is shown that backup
> is still running (http://prntscr.com/dcnxvm) . When I'm trying to
> connect to my databse via pgAdmin, pgAdmin crashes and stopes responding
> (http://prntscr.com/dcny1i).
>
> After reboot the problem is still here:
> Backup process shows as running in right bottom corner (272603.01
> seconds running for now) and when I try to connect to my DB pgAdmin is
> stopping. Killing processes from task manager also have no effect.
>

After updating to PostgreSQL 9.6.2 and pgAdmin 4.1.2 this hasn't 
changed. Windows 10, 64 bit. Very annoying!

Thank you for looking into this,
Sibylle

Re: [pgadmin-support] Backup database runs forever

От
Ashesh Vashi
Дата:

On Wed, Feb 22, 2017 at 4:01 PM, Sibylle Koczian <nulla.epistola@web.de> wrote:
Am 28.11.2016 um 08:48 schrieb Yury Ramanousky:
Hello,

I'm using pgAdmin 4.1 on Windows 10, PostgreSQL ver 9.6.1.

I've started backup database process from the GUI. It was running for
about 6 minutes than pgAdmin has unexpectedly stopped working.
I've reopen pgAdmin. In the right bottom corner it is shown that backup
is still running (http://prntscr.com/dcnxvm) . When I'm trying to
connect to my databse via pgAdmin, pgAdmin crashes and stopes responding
(http://prntscr.com/dcny1i).

After reboot the problem is still here:
Backup process shows as running in right bottom corner (272603.01
seconds running for now) and when I try to connect to my DB pgAdmin is
stopping. Killing processes from task manager also have no effect.


 After updating to PostgreSQL 9.6.2 and pgAdmin 4.1.2 this hasn't changed. Windows 10, 64 bit. Very annoying!
Unfortunately - we couldn't do much about the previous execution.
We've changed to hide them, when you click on the cross button for those notifications.
Those should not be visible anymore on refresh/on reloading the application.

Can you please check, if backup works now, not?

Thank you for looking into this,
Sibylle



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: [pgadmin-support] Backup database runs forever

От
Sibylle Koczian
Дата:
Am 22.02.2017 um 11:59 schrieb Ashesh Vashi:
>
> On Wed, Feb 22, 2017 at 4:01 PM, Sibylle Koczian <nulla.epistola@web.de
> <mailto:nulla.epistola@web.de>> wrote:
>     After updating to PostgreSQL 9.6.2 and pgAdmin 4.1.2 this hasn't
>     changed. Windows 10, 64 bit. Very annoying!
>
> Unfortunately - we couldn't do much about the previous execution.
> We've changed to hide them, when you click on the cross button for those
> notifications.
> Those should not be visible anymore on refresh/on reloading the application.
>
> Can you please check, if backup works now, not?
>

No, it doesn't. Again the backup (of a very small database) runs 
forever. If I stop it via task manager the file is much bigger than 
another backup made with pg_dump on the command line, and trying to 
restore it with pgAdmin equally runs forever.

Looking at the "details" window during the backup seems to show an 
endless loop.

Sibylle