Pivotal Knowledge Base

Follow

JDBC Query Error: "Connection Pointer is NULL"

Environment

 Product  Version
 Pivotal HDB  2.0.0, 2.0.1
 HDP  2.4

Symptom

When running a query via a JDBC connection, the query may fail with the error "connection pointer is NULL."

Error Message:

$ java -jar JDBCStatementSelectExample1.jar
PostgreSQL JDBC Driver Registered!
DB Connection successful!
org.postgresql.jdbc4.Jdbc4Connection@35710768
Executing SQL...select the_string, min(the_number) as tn from ftpdb_test.the_table group by the_string limit 50;
ERROR: Error dispatching to seg0 sdw1.example.com:40000: connection pointer is NULL
Detail:
Master unable to connect to seg0 sdw1.example.com:40000: FATAL: invalid command-line arguments for server process
HINT: Try "postgres --help" for more information.

The Master log will show:

2017-02-17 21:57:38.534508 HKT,"user1","jdbctest",p326792,th1723709728,"192.0.2.45","44001",2017-02-17 21:57:38 HKT,910348,con37,cmd7,seg-1,,,x910348,sx1,"ERROR","58M01","Error dispatching to seg0 sdw1.example.com:40000: connection pointer is NULL","
Master unable to connect to seg0 sdw1.example.com:40000: FATAL:  invalid command-line arguments for server process 

Cause

This is due to a software defect  HAWQ-1117 where the argument list may become corrupt in memory.

Resolution

This is a software defect, upgrade to HDB 2.1.0 or higher to resolve this issue. 

Comments

Powered by Zendesk