BUG #14618: pg_repack - waiting for 1 transactions to finish

Started by Nonameabout 9 years ago2 messagesbugs
Jump to latest
#1Noname
julien.vacassoulis@gmail.com

The following bug has been logged on the website:

Bug reference: 14618
Logged by: Julien Vacassoulis
Email address: julien.vacassoulis@gmail.com
PostgreSQL version: 9.2.18
Operating system: Linux redhat 6.5
Description:

Hi everybody,

I use pg_repack version 1.3.4.
I had the following message nearly 80000 times (until the PID 3254
transaction is manually killed)

NOTICE: Waiting for 1 transactions to finish. First PID: 3254

When I perfom the command pg_repack I use the option "-T 450" and I wonder
why the process wasn't killed after 450 secs ?

How can I fix it ?

Thank you and sorry for my grammatical errors ! :-)

Julien.

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

#2Michael Paquier
michael@paquier.xyz
In reply to: Noname (#1)
Re: BUG #14618: pg_repack - waiting for 1 transactions to finish

On Tue, Apr 11, 2017 at 12:42 AM, <julien.vacassoulis@gmail.com> wrote:

I use pg_repack version 1.3.4.
I had the following message nearly 80000 times (until the PID 3254
transaction is manually killed)

NOTICE: Waiting for 1 transactions to finish. First PID: 3254

When I perfom the command pg_repack I use the option "-T 450" and I wonder
why the process wasn't killed after 450 secs ?

How can I fix it ?

Thank you and sorry for my grammatical errors ! :-)

I think that you had better contact the project maintainers here:
https://github.com/reorg/pg_repack
This is out of scope of the PostgreSQL core project.
--
Michael

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