treasure-data / prestogres

PostgreSQL protocol gateway for Presto distributed SQL query engine
Other
292 stars 61 forks source link

pgpool error - after using JDBC client to access the database #44

Open tomz opened 8 years ago

tomz commented 8 years ago

Hi Sadayuki,

I am getting the following error, this can be reproduced easily with a JDBC client such Aqua Data Studio. Any idea what could causing it?

2016-01-17 23:22:39: pid 10030: LOG: child exiting, 1 connections reached 2016-01-17 23:22:39: pid 10030: LOCATION: child.c:291 2016-01-17 23:23:25: pid 10022: ERROR: error while initializing database pg_database = "hive" for pg_user = "prestogres": "ERROR: function prestogres_init_database(unknown, unknown, unknown) does not exist LINE 1: select prestogres_init_database('prestogres', 'hive', E'host... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. " 2016-01-17 23:23:25: pid 10022: LOCATION: pool_system.c:702 2016-01-17 23:23:25: pid 10022: LOG: child exiting, 1 connections reached 2016-01-17 23:23:25: pid 10022: LOCATION: child.c:291

Thanks, Tom