search

treasure-data / prestogres

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

Connected, but can't query: no module named prestogres #40

Open gretchiemoran opened 9 years ago

gretchiemoran commented 9 years ago

Just attempting to set up Prestogres with Presto using the TPCH: tiny catalog/schema. I used the following steps:

  1. Create database cluster (initdb)
  2. Start cluster (pg_ctl)
  3. create prestogres user: createuser -h 127.0.0.1 -p 5433 -s -r -e -d prestogres
  4. migrate scripts to postgresql: psql -h 127.0.0.1 -p 5433 -U prestogres postgres < '/usr/local/share/prestogres/setup.sql'
  5. Startup pgpool
  6. Connect via psql 
bash-3.2$ psql -h 127.0.0.1 -p 5439 -U prestogres tiny
psql (9.4.4)
Type "help" for help.

tiny=# select count(*) from customer;
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
tiny=# SELECT * FROM sys.node;
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.

I can connect to Prestogres, but as soon as I attempt to issue a query through psql, I get the following error in pgpool, with a similar statement in the backend Postgresql database's log. Any idea what I could have missed? I'm no Postgresql pro, so this could be something simple - 

2015-08-14 08:31:23: pid 3705: DETAIL:  backend:0 of 1 kind = 'Z'
2015-08-14 08:31:23: pid 3705: DEBUG:  processing backend response
2015-08-14 08:31:23: pid 3705: DETAIL:  received kind 'Z'(5a) from backend
2015-08-14 08:31:23: pid 3705: DEBUG:  processing backend response
2015-08-14 08:31:23: pid 3705: DETAIL:  Ready For Query received
2015-08-14 08:31:23: pid 3705: DEBUG:  reading message length
2015-08-14 08:31:23: pid 3705: DETAIL:  slot: 0 length: 5
2015-08-14 08:31:23: pid 3705: DEBUG:  processing ReadyForQuery
2015-08-14 08:31:23: pid 3705: DETAIL:  transaction state '
2015-08-14 08:34:21: pid 3696: DEBUG:  I am 3696 accept fd 7
2015-08-14 08:34:21: pid 3696: DEBUG:  reading startup packet
2015-08-14 08:34:21: pid 3696: DETAIL:  Protocol Major: 2 Minor: 0 database: tpch user: admin
2015-08-14 08:34:21: pid 3696: DEBUG:  prestogres_init_hba: presto_server: 127.0.0.1:8185
2015-08-14 08:34:21: pid 3696: DEBUG:  prestogres_init_hba: presto_user: admin
2015-08-14 08:34:21: pid 3696: DEBUG:  prestogres_init_hba: presto_catalog: tpch
2015-08-14 08:34:21: pid 3696: DEBUG:  prestogres_init_hba: presto_schema: tiny
2015-08-14 08:34:22: pid 3696: DEBUG:  creating new connection to backend
2015-08-14 08:34:22: pid 3696: DETAIL:  connecting 0 backend
2015-08-14 08:34:22: pid 3696: DEBUG:  SSL is requested but SSL support is not available
2015-08-14 08:34:22: pid 3696: DEBUG:  authentication backend
2015-08-14 08:34:22: pid 3696: DETAIL:  auth kind:0
2015-08-14 08:34:22: pid 3696: DEBUG:  authentication backend
2015-08-14 08:34:22: pid 3696: DETAIL:  cp->info[i]:0x10d587000 pid:3968
2015-08-14 08:34:22: pid 3696: DEBUG:  sending backend key data
2015-08-14 08:34:22: pid 3696: DETAIL:  send pid 3968 to frontend
2015-08-14 08:34:22: pid 3696: DEBUG:  selecting load balance node
2015-08-14 08:34:22: pid 3696: DETAIL:  selected backend id is 0
2015-08-14 08:34:22: pid 3696: DEBUG:  initializing session context
2015-08-14 08:34:22: pid 3696: DETAIL:  selected load balancing node: 0
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing transaction isolation. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing writing transaction. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing failed transaction. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing failed transaction. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing skip reading from backends. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing ignore till sync. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  reading backend data packet kind
2015-08-14 08:34:22: pid 3696: DETAIL:  backend:0 of 1 kind = 'Z'
2015-08-14 08:34:22: pid 3696: DEBUG:  processing backend response
2015-08-14 08:34:22: pid 3696: DETAIL:  received kind 'Z'(5a) from backend
2015-08-14 08:34:22: pid 3696: DEBUG:  processing frontend response
2015-08-14 08:34:22: pid 3696: DETAIL:  received kind 'Q'(51) from frontend
2015-08-14 08:34:22: pid 3696: DEBUG:  reading string data
2015-08-14 08:34:22: pid 3696: DETAIL:  read all from pending data. po:0 len:0
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: clearing doing extended query messaging. DONE
2015-08-14 08:34:22: pid 3696: LOG:  statement: set datestyle = 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end
2015-08-14 08:34:22: pid 3696: DEBUG:  session context: setting query in progress. DONE
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: extended:0 query:"select 1 from (select prestogres_catalog.setup_system_catalog(E'127.0.0.1:8185', E'admin', E'tpch', E'tiny', E'admin')) s;"
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: kind: 'P'
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  reading string data
2015-08-14 08:34:22: pid 3696: DETAIL:  read all from pending data. po:6 len:73
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: kind: 'T'
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: received ROW DESCRIPTION ('T')
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: row description: num_fileds: 1
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  reading string data
2015-08-14 08:34:22: pid 3696: DETAIL:  read all from pending data. po:18 len:61
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  do_query: kind: 'E'
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: DEBUG:  reading string data
2015-08-14 08:34:22: pid 3696: DETAIL:  read all from pending data. po:78 len:1
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3696: FATAL:  Backend throw an error message
2015-08-14 08:34:22: pid 3696: DETAIL:  Exiting current session because of an error from backend
*2015-08-14 08:34:22: pid 3696: HINT:  BACKEND Error: "ERROR:  ImportError: No module named prestogres
    "*
2015-08-14 08:34:22: pid 3696: CONTEXT:  while searching system catalog, When relcache is missed
2015-08-14 08:34:22: pid 3695: DEBUG:  reaper handler
2015-08-14 08:34:22: pid 3695: DEBUG:  reaper handler: child with PID:3696 exits with status 256
2015-08-14 08:34:22: pid 3695: DEBUG:  reaper handler: forked a new child with PID:3969
2015-08-14 08:34:22: pid 3695: DEBUG:  reaper handler: exiting normally
2015-08-14 08:34:22: pid 3969: DEBUG:  initializing backend status
2015-08-14 08:34:22: pid 3969: DEBUG:  SSL is requested but SSL support is not available
2015-08-14 08:34:22: pid 3969: DEBUG:  authenticate kind = 0
2015-08-14 08:34:22: pid 3969: DEBUG:  authenticate backend: key data received
2015-08-14 08:34:22: pid 3969: DEBUG:  authenticate backend: transaction state: I
tejaspattabhi commented 7 years ago

Did you get a solution for this?

AlexandraLouise commented 7 years ago

Also need a solution for this please!