Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #3940: 'unrecognized node type: 1718580065'

BUG #3940: 'unrecognized node type: 1718580065'

From
"Vladimir Kokovic"
Date:
The following bug has been logged online:

Bug reference:      3940
Logged by:          Vladimir Kokovic
Email address:      vladimir.kokovic@a-asoft.com
PostgreSQL version: 8.3.0
Operating system:   Linux vladakk-kuci 2.6.22-14-generic #1 SMP Fri Feb 1
04:59:50 UTC 2008 i686 GNU/Linux
Description:        'unrecognized node type: 1718580065'
Details:

I don't know if this is known bug, but look in my PostgreSQL log file:

2008-02-07 17:05:18 CET asoft vlada LOG:  00000: execute <unnamed>: CREATE
SCHEMA asoft
2008-02-07 17:05:18 CET asoft vlada LOCATION:  exec_execute_message,
postgres.c:1820
2008-02-07 17:05:18 CET asoft vlada LOG:  00000: duration: 0.806 ms
2008-02-07 17:05:18 CET asoft vlada LOCATION:  exec_execute_message,
postgres.c:1890
2008-02-07 17:05:18 CET asoft vlada ERROR:  XX000: unrecognized node type:
1718580065
2008-02-07 17:05:18 CET asoft vlada LOCATION:  copyObject, copyfuncs.c:3573
2008-02-07 17:05:18 CET asoft vlada STATEMENT:  ALTER SCHEMA asoft OWNER TO
postgres
2008-02-07 17:05:18 CET asoft vlada LOG:  08P01: unexpected EOF on client
connection
2008-02-07 17:05:18 CET asoft vlada LOCATION:  SocketBackend,
postgres.c:323
2008-02-07 17:05:18 CET asoft vlada LOG:  00000: disconnection: session
time: 0:00:05.515 user=vlada database=asoft host=localhost port=55602
2008-02-07 17:05:18 CET asoft vlada LOCATION:  log_disconnections,
postgres.c:3940

Best regards,
Vladimir Kokovic, DP senior, Belgrade, Serbia

Re: BUG #3940: 'unrecognized node type: 1718580065'

From
Tom Lane
Date:
"Vladimir Kokovic" <vladimir.kokovic@a-asoft.com> writes:
> I don't know if this is known bug, but look in my PostgreSQL log file:

> 2008-02-07 17:05:18 CET asoft vlada LOG:  00000: execute <unnamed>: CREATE
> SCHEMA asoft

I suppose you're submitting these commands via PQexecParams or something
else that uses new-style protocol?

> 2008-02-07 17:05:18 CET asoft vlada ERROR:  XX000: unrecognized node type:
> 1718580065
> 2008-02-07 17:05:18 CET asoft vlada LOCATION:  copyObject, copyfuncs.c:3573
> 2008-02-07 17:05:18 CET asoft vlada STATEMENT:  ALTER SCHEMA asoft OWNER TO
> postgres

Good catch ... this has actually been broken since 8.0, but it was
harder to trigger before.  Patch applied.

            regards, tom lane