Error: Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Forum to discuss topics related to accessing and using Vertica via the vSQL command line tool

Moderator: NorbertKrupa

Post Reply
User avatar
usli06
Intermediate
Intermediate
Posts: 93
Joined: Wed Jan 25, 2012 4:53 am

Error: Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Post by usli06 » Wed May 27, 2015 12:43 pm

Good morning,

Sometime when I try to cancel a running query in vsql, I get the following message:

Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Note, the query does cancel, but what does this error mean?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1707
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Error: Could not send cancel request: PQcancel() -- connect() failed: No buffer space available

Post by JimKnicely » Sun Jun 28, 2015 2:26 pm

I suspect your workload may be far exceeding your available hardware's capability! Did you configure 2 GB of TEMP space for Vertica?
Jim Knicely

Image

Note: I work for HPE. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “vSQL”

Who is online

Users browsing this forum: No registered users and 1 guest