[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