Pivotal Knowledge Base

Follow

Query using gpfdist fails with "Suspected intermittent network connectivity issue, cancelling the query"

Environment

GPDB version < 4.2.7.2 / 4.3.1.0

Problem

Queries using gpfdist fails with the error message

"ERROR","XX000","suspected intermittent network connectivity issue, cancelling the query. (url.c:587)"

The Strace trace message on the master log during the time of the issue would look like

Stack trace:
1    0xa7588e postgres errstart (elog.c:468)
2    0xb50165 postgres cdbdisp_finishCommand (cdbdisp.c:1503)
3    0x704cc7 postgres mppExecutorFinishup (execUtils.c:2064)
4    0x6e9988 postgres ExecutorEnd (execMain.c:1011)
5    0x91637b postgres  (pquery.c:378)
6    0x918d36 postgres PortalRun (pquery.c:1615)
7    0x90eb85 postgres  (postgres.c:1729)
8    0x9104a7 postgres PostgresMain (postgres.c:4666)
9    0x8769a5 postgres  (postmaster.c:6974)
10   0x87da10 postgres PostmasterMain (postmaster.c:2495)
11   0x781e8a postgres main (main.c:212)
12   0x3e2341d994 libc.so.6 __libc_start_main (??:0)
13   0x47cd39 postgres  (??:0)

Cause

When using the Greenplum Database gpfdist utility with a named pipe for a readable external table, and there is no data from pipe for more than 10 minutes, gpfdist fails with this error " Suspected intermittent network connectivity issue, cancelling the query " this was tracked using the internal bug MPP-22317

Solution

Upgrade the database where the issue has been fixed 4.3.1.0 / 4.2.7.2 / 4.2.8.0 or to the current version of the greenplum

Comments

Powered by Zendesk