Re: BUG #12749: WARNING: unrecognized node type: 701 - Mailing list pgsql-bugs

From Mark Kirkwood
Subject Re: BUG #12749: WARNING: unrecognized node type: 701
Date
Msg-id 54D9C1F8.90204@catalyst.net.nz
Whole thread Raw
In response to BUG #12749: WARNING: unrecognized node type: 701  (deanelliotdeloach@hotmail.com)
Responses Re: BUG #12749: WARNING: unrecognized node type: 701
Re: BUG #12749: WARNING: unrecognized node type: 701
Re: BUG #12749: WARNING: unrecognized node type: 701
List pgsql-bugs
On 10/02/15 16:54, dean deloach wrote:
> Thanks for the response guys, really appreciate it.  Turns out, it has
> something to do with the log_statement config parameter on the DB.  The
> DBA changed and no one knew...these are the results we get when we
> attempt to pull data from the GP instance via Datadirect drivers, for
> different log_statement config values:
>
>
> log_statement=all  - returns n records, no errors logged in Greenplum
> log file
>
> log_statement=none  - returns n records, no errors logged in Greenplum
> log file
>
> log_statement=mod  - returns n-1 records, "unknown node: 701" error
> logged in Greenplum log file
>
> log_statement=ddl  - returns n-1 records, "unknown node: 701" error
> logged in Greenplum log file
>

That is pretty scary - I'd still recommend raising it with Pivotal -
logging options changing the results of queries is ...*unexpected*...to
put it mildly!

Cheers

Mark

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #12749: WARNING: unrecognized node type: 701
Next
From: toni.helenius@syncrontech.com
Date:
Subject: BUG #12755: pg_upgrage creates potentially dangerous delete_old_cluster.bat