Pivotal Knowledge Base

Follow

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

Environment

Pivotal Greenplum Database 4.2.7.2 and 4.3.1.0

Symptom

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

Resolution

Upgrade the database where the issue has been fixed in 4.3.1.0, 4.2.7.2, 4.2.8.0 or in the current version of the Greenplum.

Comments

Powered by Zendesk