From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
---|---|
To: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: londiste3: removing a node that does not exist |
Date: | 2017-08-25 19:57:34 |
Message-ID: | CAHnozTi1aTwvve4NyOv_JBc4tLWsJtHTkZVLrCBTYJuTVdAODw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jun 22, 2017 at 6:03 PM, Victor Yegorov <vyegorov(at)gmail(dot)com> wrote:
> 2017-06-22 18:21 GMT+03:00 Willy-Bas Loos <willybas(at)gmail(dot)com>:
>
>> Does anyone know of a method to get rid of the bad node and the data that
>> it is gathering?
>
>
> I also do not know the correct way to achieve this.
>
>
> But once I needed to rename one of the queues to follow the internal
> naming standard.
> And I used the following queries on the provider node to prune _old_ queue:
>
> SET search_path TO pgq_node;
> DELETE FROM local_state WHERE queue_name='q-2rm';
> DELETE FROM subscriber_info WHERE queue_name='q-2rm';
> DELETE FROM node_info WHERE queue_name='q-2rm';
> DELETE FROM node_location WHERE queue_name='q-2rm';
>
> And restarted worker after that.
>
>
> --
> Victor Yegorov
>
Hi thanks for the answer. I've left this alone for a while and i've been
looking into it in more detail today.
All the data is in the schema pgq. The other schema's are super small.
Also, the non-functional node is not in any of the tables in pgq_node.
But it is mentioned in pgq.consumer and linked with pgq.subscription.
When i remove the subscription records, nothing happens (worker and pgqd
are running)
I was hoping hat some maintenance routine would remove the surplus data,
but it doesn't.
I would delete the data myself but i can't figure out how to link that data
to a consumer.
The event tables that contain all the data have no foreign keys. And i've
tried to find mutual id's in those and other tables like pgq.tick but i
haven't found anything of substance.
There are transaction id's in the event tables, i just hope that that is
not the link because that would probably get seriously complicated to
handle.
Can anyone give me some advice?
--
Willy-Bas Loos
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-08-25 20:01:20 | Re: Invalid magic number 0000 in log file |
Previous Message | Adam Brusselback | 2017-08-25 19:39:12 | Re: Porting libpq to QNX 4.25 |