Обсуждение: [pgadmin-support] Bug: Error generating backup

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

[pgadmin-support] Bug: Error generating backup

От
"Lazaro Garcia"
Дата:

Hello everyone, This error happens when a backup is generated: pgAdmin4-1.4

 

The window for showing the state of backup generation shows the text "Status Running..." all the time, never change to complet state, however the backup is generated correctly.

 

Steps for reproduce:

 

1. Generate backups

2. Click here for details when popups is "running…"

 

 

 

That trace is logged on the apache error log file:

 

[Mon Apr 17 10:08:47.397442 2017] [wsgi:warn] [pid 38847] mod_wsgi (pid=38847): Callback registration for signal 2 ignored.

[Mon Apr 17 10:08:47.439101 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1997, in __call__

[Mon Apr 17 10:08:47.439126 2017] [wsgi:warn] [pid 38847]     return self.wsgi_app(environ, start_response)

[Mon Apr 17 10:08:47.439134 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1982, in wsgi_app

[Mon Apr 17 10:08:47.439140 2017] [wsgi:warn] [pid 38847]     response = self.full_dispatch_request()

[Mon Apr 17 10:08:47.439147 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1612, in full_dispatch_request

[Mon Apr 17 10:08:47.439153 2017] [wsgi:warn] [pid 38847]     rv = self.dispatch_request()

[Mon Apr 17 10:08:47.439159 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1598, in dispatch_request

[Mon Apr 17 10:08:47.439165 2017] [wsgi:warn] [pid 38847]     return self.view_functions[rule.endpoint](**req.view_args)

[Mon Apr 17 10:08:47.439171 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask_login.py", line 792, in decorated_view

[Mon Apr 17 10:08:47.439177 2017] [wsgi:warn] [pid 38847]     return func(*args, **kwargs)

[Mon Apr 17 10:08:47.439183 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/tools/backup/__init__.py", line 452, in create_backup_objects_job

[Mon Apr 17 10:08:47.439189 2017] [wsgi:warn] [pid 38847]     p.start()

[Mon Apr 17 10:08:47.439195 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 335, in start

[Mon Apr 17 10:08:47.439201 2017] [wsgi:warn] [pid 38847]     preexec_fn=preexec_function, env=env

[Mon Apr 17 10:08:47.439207 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 711, in __init__

[Mon Apr 17 10:08:47.439215 2017] [wsgi:warn] [pid 38847]     errread, errwrite)

[Mon Apr 17 10:08:47.439222 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 1286, in _execute_child

[Mon Apr 17 10:08:47.439227 2017] [wsgi:warn] [pid 38847]     preexec_fn()

[Mon Apr 17 10:08:47.439233 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 331, in preexec_function

[Mon Apr 17 10:08:47.439239 2017] [wsgi:warn] [pid 38847]     signal.signal(signal.SIGINT, signal.SIG_IGN)

 

Regards.

Re: [pgadmin-support] Bug: Error generating backup

От
Murtuza Zabuawala
Дата:
I am not able to re-produce this issue on my side, I tested on Ubuntu 16.04 with Apache.

Could you provide more information like OS version, Postgres version, what exactly trigger this behaviour?

For now you can follow this step (Link) to remove process watcher window. 

--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


On Mon, Apr 17, 2017 at 8:03 PM, Lazaro Garcia <lazaro3487@gmail.com> wrote:

Hello everyone, This error happens when a backup is generated: pgAdmin4-1.4

 

The window for showing the state of backup generation shows the text "Status Running..." all the time, never change to complet state, however the backup is generated correctly.

 

Steps for reproduce:

 

1. Generate backups

2. Click here for details when popups is "running…"

 

 

 

That trace is logged on the apache error log file:

 

[Mon Apr 17 10:08:47.397442 2017] [wsgi:warn] [pid 38847] mod_wsgi (pid=38847): Callback registration for signal 2 ignored.

[Mon Apr 17 10:08:47.439101 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1997, in __call__

[Mon Apr 17 10:08:47.439126 2017] [wsgi:warn] [pid 38847]     return self.wsgi_app(environ, start_response)

[Mon Apr 17 10:08:47.439134 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1982, in wsgi_app

[Mon Apr 17 10:08:47.439140 2017] [wsgi:warn] [pid 38847]     response = self.full_dispatch_request()

[Mon Apr 17 10:08:47.439147 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1612, in full_dispatch_request

[Mon Apr 17 10:08:47.439153 2017] [wsgi:warn] [pid 38847]     rv = self.dispatch_request()

[Mon Apr 17 10:08:47.439159 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1598, in dispatch_request

[Mon Apr 17 10:08:47.439165 2017] [wsgi:warn] [pid 38847]     return self.view_functions[rule.endpoint](**req.view_args)

[Mon Apr 17 10:08:47.439171 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask_login.py", line 792, in decorated_view

[Mon Apr 17 10:08:47.439177 2017] [wsgi:warn] [pid 38847]     return func(*args, **kwargs)

[Mon Apr 17 10:08:47.439183 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/tools/backup/__init__.py", line 452, in create_backup_objects_job

[Mon Apr 17 10:08:47.439189 2017] [wsgi:warn] [pid 38847]     p.start()

[Mon Apr 17 10:08:47.439195 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 335, in start

[Mon Apr 17 10:08:47.439201 2017] [wsgi:warn] [pid 38847]     preexec_fn=preexec_function, env=env

[Mon Apr 17 10:08:47.439207 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 711, in __init__

[Mon Apr 17 10:08:47.439215 2017] [wsgi:warn] [pid 38847]     errread, errwrite)

[Mon Apr 17 10:08:47.439222 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 1286, in _execute_child

[Mon Apr 17 10:08:47.439227 2017] [wsgi:warn] [pid 38847]     preexec_fn()

[Mon Apr 17 10:08:47.439233 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 331, in preexec_function

[Mon Apr 17 10:08:47.439239 2017] [wsgi:warn] [pid 38847]     signal.signal(signal.SIGINT, signal.SIG_IGN)

 

Regards.


Re: [pgadmin-support] Bug: Error generating backup

От
"Lazaro Garcia"
Дата:

Ubuntu server 16.04

PostgreSQL 9.6.2

PgAdmin4-1.4 with apache

In the popup click on the link “Click here for details”, when the backup process is Running…. In the modal I can’t see the output of backups generation  and the footer has the text “Status: Running…”, however the backups is generated correctly.

 

The modal is not refreshed.

 

Can you try with a big database, to give time?

 

Regards.

 

De: Murtuza Zabuawala [mailto:murtuza.zabuawala@enterprisedb.com]
Enviado el: martes, 18 de abril de 2017 02:16 a. m.
Para: Lazaro Garcia
CC: pgAdmin Support
Asunto: Re: [pgadmin-support] Bug: Error generating backup

 

I am not able to re-produce this issue on my side, I tested on Ubuntu 16.04 with Apache.

 

Could you provide more information like OS version, Postgres version, what exactly trigger this behaviour?

 

For now you can follow this step (Link) to remove process watcher window. 


--

Regards,

Murtuza Zabuawala
EnterpriseDB: 
http://www.enterprisedb.com
The Enterprise PostgreSQL Company

 

On Mon, Apr 17, 2017 at 8:03 PM, Lazaro Garcia <lazaro3487@gmail.com> wrote:

Hello everyone, This error happens when a backup is generated: pgAdmin4-1.4

 

The window for showing the state of backup generation shows the text "Status Running..." all the time, never change to complet state, however the backup is generated correctly.

 

Steps for reproduce:

 

1. Generate backups

2. Click here for details when popups is "running…"

 

 

 

That trace is logged on the apache error log file:

 

[Mon Apr 17 10:08:47.397442 2017] [wsgi:warn] [pid 38847] mod_wsgi (pid=38847): Callback registration for signal 2 ignored.

[Mon Apr 17 10:08:47.439101 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1997, in __call__

[Mon Apr 17 10:08:47.439126 2017] [wsgi:warn] [pid 38847]     return self.wsgi_app(environ, start_response)

[Mon Apr 17 10:08:47.439134 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1982, in wsgi_app

[Mon Apr 17 10:08:47.439140 2017] [wsgi:warn] [pid 38847]     response = self.full_dispatch_request()

[Mon Apr 17 10:08:47.439147 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1612, in full_dispatch_request

[Mon Apr 17 10:08:47.439153 2017] [wsgi:warn] [pid 38847]     rv = self.dispatch_request()

[Mon Apr 17 10:08:47.439159 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask/app.py", line 1598, in dispatch_request

[Mon Apr 17 10:08:47.439165 2017] [wsgi:warn] [pid 38847]     return self.view_functions[rule.endpoint](**req.view_args)

[Mon Apr 17 10:08:47.439171 2017] [wsgi:warn] [pid 38847]   File "/usr/local/lib/python2.7/dist-packages/flask_login.py", line 792, in decorated_view

[Mon Apr 17 10:08:47.439177 2017] [wsgi:warn] [pid 38847]     return func(*args, **kwargs)

[Mon Apr 17 10:08:47.439183 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/tools/backup/__init__.py", line 452, in create_backup_objects_job

[Mon Apr 17 10:08:47.439189 2017] [wsgi:warn] [pid 38847]     p.start()

[Mon Apr 17 10:08:47.439195 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 335, in start

[Mon Apr 17 10:08:47.439201 2017] [wsgi:warn] [pid 38847]     preexec_fn=preexec_function, env=env

[Mon Apr 17 10:08:47.439207 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 711, in __init__

[Mon Apr 17 10:08:47.439215 2017] [wsgi:warn] [pid 38847]     errread, errwrite)

[Mon Apr 17 10:08:47.439222 2017] [wsgi:warn] [pid 38847]   File "/usr/lib/python2.7/subprocess.py", line 1286, in _execute_child

[Mon Apr 17 10:08:47.439227 2017] [wsgi:warn] [pid 38847]     preexec_fn()

[Mon Apr 17 10:08:47.439233 2017] [wsgi:warn] [pid 38847]   File "/var/www/vhost/pgadmin4/web/pgadmin/misc/bgprocess/processes.py", line 331, in preexec_function

[Mon Apr 17 10:08:47.439239 2017] [wsgi:warn] [pid 38847]     signal.signal(signal.SIGINT, signal.SIG_IGN)

 

Regards.