[Postgres-xl-general] Cannot drop or alter table
Felix Ng
felix.ng at sopwr.com
Thu Oct 29 19:32:36 PDT 2015
I tried to connect to 2 others coordinators. but got the same error.
ERROR: node "coord5_29673" does not exist
STATEMENT: SET global_session TO coord5_29673;
Actually, the log keep showing the log below, all the time...
ERROR: node "coord1_21476" does not exist
On Fri, Oct 30, 2015 at 9:54 AM, Krzysztof Nienartowicz
<krzysztof.nienartowicz at unige.ch> wrote:
> have you tried from a different coordinator? this looks like one of
> coordinators system catalog got out of sync.
>
> On Fri, Oct 30, 2015 at 2:47 AM, Felix Ng <felix.ng at sopwr.com> wrote:
>> select * from pgxc_node
>>
>> node_name | node_type | node_port | node_host | nodeis_primary |
>> nodeis_preferred | node_id
>> ------------+-----------+-----------+-----------+----------------+------------------+-------------
>> coord1 | C | 5432 | localhost | f | f
>> | 1885696643
>> coord2 | C | 5432 | 10.0.0.2 | f | f
>> | -1197102633
>> datanode2 | D | 5433 | 10.0.0.2 | f | f
>> | -905831925
>> coord3 | C | 5432 | 10.0.0.3 | f | f
>> | 1638403545
>> datanode3 | D | 5433 | 10.0.0.3 | f | f
>> | -1894792127
>> coord4 | C | 5432 | 10.0.0.4 | f | f
>> | -890157977
>> datanode4 | D | 5433 | 10.0.0.4 | f | f
>> | -1307323892
>> coord5 | C | 5432 | 10.0.0.5 | f | f
>> | -1869430451
>> datanode5 | D | 5433 | 10.0.0.5 | f | f
>> | 1797586929
>> coord6 | C | 5432 | 10.0.0.6 | f | f
>> | -543030629
>> datanode6 | D | 5433 | 10.0.0.6 | f | f
>> | 587455710
>> coord7 | C | 5432 | 10.0.0.7 | f | f
>> | 181236111
>> datanode7 | D | 5433 | 10.0.0.7 | f | f
>> | -1685037427
>> coord8 | C | 5432 | 10.0.0.8 | f | f
>> | 231449693
>> datanode8 | D | 5433 | 10.0.0.8 | f | f
>> | -993847320
>> datanode11 | D | 5433 | 10.0.0.11 | f | f
>> | -1561356182
>> datanode12 | D | 5433 | 10.0.0.12 | f | f
>> | 1637895547
>> (17 rows)
>>
>>
>> In general, the system works well, select/update/insert/copy all works
>>
>>
>>
>> ~felix
>>
>>
>>
>> On Fri, Oct 30, 2015 at 8:20 AM, Krzysztof Nienartowicz
>> <krzysztof.nienartowicz at unige.ch> wrote:
>>> and what
>>> select * from pgxc_node
>>> shows?
>>>
>>> On Thu, Oct 29, 2015 at 11:58 PM, Felix Ng <felix.ng at sopwr.com> wrote:
>>>> I got huge problem with drop or alter many tables, but not all. I had
>>>> restart the whole cluster, execute pgxc_clean, tried "clean connection
>>>> to all for database xxx", still no luck. Our development was
>>>> completely halted because of these problem :<
>>>>
>>>> Below are some log from the datanode's pg_log
>>>>
>>>>
>>>>
>>>>
>>>> STATEMENT: SET global_session TO coord1_19136;SET datestyle TO
>>>> iso;SET client_min_messages TO notice;SET client_encoding TO
>>>> UNICODE;SET bytea_output TO escape;
>>>> ERROR: node "coord1_19136" does not exist
>>>> STATEMENT: SET global_session TO coord1_19136;SET datestyle TO
>>>> iso;SET client_min_messages TO notice;SET client_encoding TO
>>>> UNICODE;SET bytea_output TO escape;
>>>> LOG: Will fall back to local snapshot for XID = 26064389, source = 0,
>>>> gxmin = 0, autovac launch = 0, autovac = 0, normProcMode = 0, postEnv
>>>> = 1
>>>> ERROR: node "coord1_21100" does not exist
>>>> STATEMENT: SET global_session TO coord1_21100;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21100" does not exist
>>>> STATEMENT: SET global_session TO coord1_21100;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21183" does not exist
>>>> STATEMENT: SET global_session TO coord1_21183;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21183" does not exist
>>>> STATEMENT: SET global_session TO coord1_21183;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21207" does not exist
>>>> STATEMENT: SET global_session TO coord1_21207;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21207" does not exist
>>>> STATEMENT: SET global_session TO coord1_21207;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21476" does not exist
>>>> STATEMENT: SET global_session TO coord1_21476;SET extra_float_digits TO 3;
>>>> ERROR: node "coord1_21476" does not exist
>>>> STATEMENT: SET global_session TO coord1_21476;SET extra_float_digits TO 3;
>>>>
>>>>
>>>>
>>>> Thanks in advance.
>>>>
>>>> ------------------------------------------------------------------------------
>>>> _______________________________________________
>>>> Postgres-xl-general mailing list
>>>> Postgres-xl-general at lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
More information about the postgres-xl-general
mailing list