{"action":"opened","issue":{"url":"https://api.github.com/repos/treasure-data/prestogres/issues/42","labels_url":"https://api.github.com/repos/treasure-data/prestogres/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/treasure-data/prestogres/issues/42/comments","events_url":"https://api.github.com/repos/treasure-data/prestogres/issues/42/events","html_url":"https://github.com/treasure-data/prestogres/issues/42","id":113937319,"number":42,"title":"Cannot query PrestoDB 0.107","user":{"login":"wayoutmind","id":309689,"avatar_url":"https://avatars.githubusercontent.com/u/309689?v=3","gravatar_id":"","url":"https://api.github.com/users/wayoutmind","html_url":"https://github.com/wayoutmind","followers_url":"https://api.github.com/users/wayoutmind/followers","following_url":"https://api.github.com/users/wayoutmind/following{/other_user}","gists_url":"https://api.github.com/users/wayoutmind/gists{/gist_id}","starred_url":"https://api.github.com/users/wayoutmind/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wayoutmind/subscriptions","organizations_url":"https://api.github.com/users/wayoutmind/orgs","repos_url":"https://api.github.com/users/wayoutmind/repos","events_url":"https://api.github.com/users/wayoutmind/events{/privacy}","received_events_url":"https://api.github.com/users/wayoutmind/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-10-28T22:14:53Z","updated_at":"2015-10-28T22:14:53Z","closed_at":null,"body":"I am unable to query a Presto 0.107 cluster. For testing, I am attempting to query Presto's [JMX](https://prestodb.io/docs/current/connector/jmx.html) data source.\r\n\r\nPrestogres (master), ca0fa82be692582f728e34a4a96b8d01e373836f\r\nPostgreSQL 9.4\r\nPresto 0.107\r\n\r\n```\r\npsql -h 127.0.0.1 -p 5439 -U presto jmx   \r\npsql (9.4.5)\r\nType \"help\" for help.\r\n\r\njmx=> SELECT * FROM sys.node;\r\nserver closed the connection unexpectedly\r\n\tThis probably means the server terminated abnormally\r\n\tbefore or while processing the request.\r\nThe connection to the server was lost. Attempting reset: Succeeded.\r\n```\r\n\r\nPrestogres logs:\r\n\r\n```\r\nLOG:  statement: select 1 from (select prestogres_catalog.setup_system_catalog(E'presto:8080', E'presto', E'jmx', E'jmx', E'presto')) s;\r\nWARNING:  Table jmx.\"com.facebook.presto.execution:type=queryqueue,name=global,expansion=global\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"com.facebook.presto.execution:type=queryqueue,name=global,expansion=global\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=abstractconnector$acceptor,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletholder,name=org.eclipse.jetty.servlet.servlethandler$default404servlet-62d1dc3c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconnectionfactory,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconnectionfactory,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconnectionfactory,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.timingfilter-4a901445,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.util.thread:context=http/1.1@63d5874f,type=scheduledexecutorscheduler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.util.thread:context=http/1.1@63d5874f,type=scheduledexecutorscheduler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.util.thread:context=http/1.1@63d5874f,type=scheduledexecutorscheduler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletmapping,name=org.glassfish.jersey.servlet.servletcontainer-6e3ecf5c,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector$serverconnectormanager,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector$serverconnectormanager,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector$serverconnectormanager,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.io:context=http/1.1@63d5874f,type=arraybytebufferpool,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"sun.nio.ch:context=http/1.1@63d5874f,type=serversocketchannelimpl,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=httpconfiguration,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.server:context=http/1.1@63d5874f,type=serverconnector,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filtermapping,name=io.airlift.http.server.tracetokenfilter-6dc9da2d,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servlethandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=filterholder,name=org.eclipse.jetty.servlets.gzipfilter-6fbc1bb,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"org.eclipse.jetty.servlet:context=\"\"root@@http\"\",type=servletcontexthandler,id=0\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"com.facebook.presto.failuredetector:name=heartbeatfailuredetector\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"com.facebook.presto.failuredetector:name=heartbeatfailuredetector\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"com.facebook.presto.failuredetector:name=heartbeatfailuredetector\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nWARNING:  Table jmx.\"com.facebook.presto.failuredetector:name=heartbeatfailuredetector\" is skipped because its name is longer than 63 characters\r\nCONTEXT:  PL/Python function \"setup_system_catalog\"\r\nLOG:  statement: SELECT count(*) FROM pg_catalog.pg_class AS c WHERE c.relname = 'pg_namespace'\r\nLOG:  statement: SELECT count(*) from (SELECT has_function_privilege('presto', 'to_regclass(cstring)', 'execute') WHERE EXISTS(SELECT * FROM pg_catalog.pg_proc AS p WHERE p.proname = 'to_regclass')) AS s\r\nLOG:  statement: SELECT count(*) FROM pg_class AS c, pg_namespace AS n WHERE c.oid = to_regclass('columns') AND c.relnamespace = n.oid AND n.nspname = 'pg_catalog'\r\nLOG:  statement: create database \"jmx\"\r\nERROR:  database \"jmx\" already exists\r\nSTATEMENT:  create database \"jmx\"\r\nLOG:  statement: create role \"presto\" with login\r\nERROR:  role \"presto\" already exists\r\nSTATEMENT:  create role \"presto\" with login\r\nLOG:  statement: select prestogres_init_database('presto', 'jmx', E'host=\\'127.0.0.1\\' port=5432 dbname=\\'jmx\\' user=\\'prestogres\\' password=\\'\\'')\r\n2015-10-27 15:23:10: pid 24: WARNING:  child process with pid: 44 was terminated by segmentation fault\r\nLOG:  statement: do $INIT$ begin\r\n\t        perform pg_advisory_lock(3235398540741723243);  -- prevent \"tuple concurrently updated\" error\r\n\t\r\n\t        if not exists (select * from pg_language where lanname = 'plpythonu') then\r\n\t            create language plpythonu;\r\n\t        end if;\r\n\t\r\n\t        if not exists (select * from pg_namespace where nspname = 'prestogres_catalog') then\r\n\t            create schema prestogres_catalog;\r\n\t        end if;\r\n\t\r\n\t        create or replace function prestogres_catalog.start_presto_query(\r\n\t            presto_server text, presto_user text, presto_catalog text, presto_schema text,\r\n\t            function_name text, query text)\r\n\t        returns void as $$\r\n\t            import prestogres\r\n\t            prestogres.start_presto_query(\r\n\t                presto_server, presto_user, presto_catalog, presto_schema, function_name, query)\r\n\t        $$ language plpythonu\r\n\t        security definer;\r\n\t\r\n\t        create or replace function prestogres_catalog.setup_system_catalog(\r\n\t            presto_server text, presto_user text, presto_catalog text, presto_schema text,\r\n\t            access_role text)\r\n\t        returns void as $$\r\n\t            import prestogres\r\n\t            prestogres.setup_system_catalog(\r\n\t                presto_server, presto_user, presto_catalog, presto_schema, access_role)\r\n\t        $$ language plpythonu\r\n\t        security definer;\r\n\t\r\n\t        revoke temporary on database \"jmx\" from public;  -- reject CREATE TEMPORARY TABLE\r\n\t        grant usage on schema prestogres_catalog to \"presto\";\r\n\t        grant execute on all functions in schema prestogres_catalog to \"presto\";\r\n\t\r\n\t    end $INIT$ language plpgsql\r\n2015-10-27 15:30:15: pid 164: LOG:  Frontend terminated\r\n```"}}