You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hawq.apache.org by "gang.wang" <ga...@sky-data.cn> on 2018/05/08 08:24:48 UTC

error (connection pointer is NULL) when using hawq pxf

Hi，hawq team:


I have met an error using hawq pxf.


Here is myenvironment：
10.0.0.11，10.0.0.12，10.0.0.13 for hdfs
10.0.0.14，10.0.0.15，10.0.0.16 for hawq and pxf.
centos 7.4
hawq version:2.2.0


I followed the example on ‘''https://cwiki.apache.org/confluence/display/HAWQ/PXF+Build+and+Install''’ for
'''CREATE EXTERNAL TABLE pxf_hdfs_textsimple ...’''


But,when I query the external table ,I got the error below:


postgres=# select * from pxf_hdfs_textsimple;
ERROR: Error dispatching to seg0 skyaxe-computing-0.localdomain:40000: connection pointer is NULL
DETAIL:
Master unable to connect to seg0 skyaxe-computing-0.localdomain:40000: could not connect to server: Connection refused
Is the server running on host "10.0.0.14" and accepting
TCP/IP connections on port 40000?


Mail attachments is pg_log.


Thanks!

Re: error (connection pointer is NULL) when using hawq pxf

Posted by Radar Lei <rl...@pivotal.io>.

Hi Gang,

The log is not attached, please provide it again by the email or in jira.
Thanks.

Regards,
Radar

On Tue, May 8, 2018 at 4:24 PM, gang.wang <ga...@sky-data.cn> wrote:

> Hi，hawq team:
>
>
> I have met an error using hawq pxf.
>
>
> Here is my environment：
>
> 10.0.0.11，10.0.0.12，10.0.0.13 for hdfs
>
> 10.0.0.14，10.0.0.15，10.0.0.16 for hawq and pxf.
>
> centos 7.4
>
> hawq version:2.2.0
>
>
> I followed the example on ‘''https://cwiki.apache.org/
> confluence/display/HAWQ/PXF+Build+and+Install''’ for
>
> '''CREATE EXTERNAL TABLE pxf_hdfs_textsimple ...’''
>
>
> But,when I query the external table ,I got the error below:
>
>
> postgres=# select * from pxf_hdfs_textsimple;
>
> ERROR:  Error dispatching to seg0 skyaxe-computing-0.localdomain:40000:
> connection pointer is NULL
>
> DETAIL:
>
> Master unable to connect to seg0 skyaxe-computing-0.localdomain:40000:
> could not connect to server: Connection refused
>
> Is the server running on host "10.0.0.14" and accepting
>
> TCP/IP connections on port 40000?
>
>
> Mail attachments is pg_log.
>
>
> Thanks!
>
>
>
>