Thread: [BUGS] BUG #14618: pg_repack - waiting for 1 transactions to finish

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

From
julien.vacassoulis@gmail.com
Date:
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

Re: [BUGS] BUG #14618: pg_repack - waiting for 1 transactions to finish

From
Michael Paquier
Date:
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