cannot send data to nodes

Hi,

I am

Hi ,

I am getting this exception when I gave select count(*) on a table.

SQLException: ERROR: Failed To Get Results For ( SQL , NodeURL) : ( SELECT count( 1) AS "XCOL1" FROM "captor_tdr_msc_b" ) eQS Node 8 has aborted execution, cause is: com.edb.gridsql.exception.XDBServerException : Can not send data to Nodes

I have checked all the configuration and connection to nodes from other nodes .Everything is fine

In the node log file it is showing
Caused by: java.io.IOException: loader failed to load data: com.edb.util.PSQLException: SERRORC42P01Mrelation "tmptt8_1" does not existFnamespace.cL273RRangeVarGetRelid
at com.edb.gridsql.engine.loader.EDBWriter.stopEDBCopyThread(Unknown Source)
at com.edb.gridsql.engine.loader.EDBWriter.finish(Unknown Source)
at com.edb.gridsql.engine.loader.DataProcessorThread.finishLoad(Unknown Source)
at com.edb.gridsql.engine.loader.Loader.finishLoad(Unknown Source)
... 4 more
2751764 [Thread-99] ERROR com.edb.gridsql.engine.NodeProducerThread - Throwing throwable:
com.edb.gridsql.exception.XDBWrappedException: com.edb.gridsql.exception.XDBServerException : Can not send data to Nodes
at com.edb.gridsql.engine.NodeProducerThread.processStep(Unknown Source)
at com.edb.gridsql.engine.NodeProducerThread.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

Please help in resolving this issue.

No error is thtown while loading data.While fetching only this error is thrown.

Thanks in advance.

Thanks
Sreelatha

Hi Sri,

When this happens, it is nearly always a configuration issue, where one node does not have permission to send to another.

Please check your pg_hba.conf files. Also, I believe another thread or two on the forums here discusses this and it is mentioned in the troubleshooting section in the manual.

Regards,

Mason