search

treasure-data / prestogres

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

Scheme_Workbench hangs up #17

Closed wyukawa closed 10 years ago

wyukawa commented 10 years ago

I try to connect Prestogres by using Scheme_Workbench 3.7.0.0-752 with PostgreSQL JDBC Driver.

Scheme_Workbench is used to create OLAP cube schemas.

But, Scheme_Workbench hangs up when I open schema.

Honestly, I think that this is the problem of Scheme_Workbench, not Prestogres. So, you don't hesitate to close this issue.

< 2014-09-30 14:59:22.096 JST >WARNING:  column "table_cat" has type "unknown"
< 2014-09-30 14:59:22.096 JST >DETAIL:  Proceeding with relation creation anyway.
< 2014-09-30 14:59:22.096 JST >CONTEXT:  SQL statement "create temporary table presto_result (
          table_cat unknown,
          table_schem name,
          table_name name,
          column_name name,
          key_seq int4,
          pk_name name
        )"
        PL/Python function "run_system_catalog_as_temp_table"
frsyuki commented 10 years ago

Thank you for your report! I think this commit fixes this issue: https://github.com/treasure-data/prestogres/commit/8634759afb869a02c9673a7af00109b670cc3ec3 Could you try to apply the change to prestogres.py on your machine? Thanks.

wyukawa commented 10 years ago

Thank you for quick response!

But, Scheme_Workbench hangs up...

< 2014-09-30 15:26:21.212 JST >LOG:  checkpoints are occurring too frequently (8 seconds apart)
< 2014-09-30 15:26:21.212 JST >HINT:  Consider increasing the configuration parameter "checkpoint_segments".
frsyuki commented 10 years ago

oh. Those logs are LOG and HINT. It means PostgreSQL is running well and doing nothing. But the client (Scheme_Workbench) hangs....it's difficult to investigate without client-side thread dumps or logs.