So it seems that Tomcat server is up, but the pxf servlet has not started. To confirm this, you can run "pxf-service status" to double check that pxf service is running.
One guess on what the problem is that the Java libraries were not loaded correctly. I am looking at this line Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.Log Can you double check that you can find all the jar files at the locations in this file? https://github.com/apache/incubator-hawq/blob/master/pxf/pxf-service/src/main/resources/pxf-privatehdp.classpath Jimmy Da That’s what people do, they leap, and hoping to God they can fly. On Wed, Oct 28, 2015 at 12:03 PM, Ting(Goden) Yao <[email protected]> wrote: > Hi sequoiadb, > > which hawq/pxf version are you using (did you just compile the open source > version or it's former pivotal released hawq versions)? > > Can you also attach pxf logs for investigation? > it's at var/log/gphd/ > > -Goden > > On Wed, Oct 28, 2015 at 1:51 AM sequoiadb <[email protected]> > wrote: > >> Hi guys, >> >> I’m trying to setup PXF for HBase and got the following error: >> tpch=# create external table hbase_member ( recordkey bytea, >> "address:city" varchar, "address:contry" varchar, "address:province" >> varchar, "info:age" int, "info:birthday" varchar, "info:company" varchar ) >> location ( 'pxf://cent61:50070/member?PROFILE=HBase') FORMAT 'CUSTOM'( >> FORMATTER='pxfwritable_import'); >> CREATE EXTERNAL TABLE >> tpch=# select * from hbase_member; >> ERROR: remote component error (0) from '192.168.31.205:51200': couldn't >> connect to host (libchurl.c:852) >> >> I could successfully create regular tables and perform queries, but when >> I try to create pxf tables I’m keep getting error on connecting to port >> 51200. >> >> So I tried to start pxf-service and got >> [root@cent61 profile.d]# service pxf-service init >> Creating instance 'pxf-service' ... >> Using separate layout >> Creating bin/setenv.sh >> Applying template 'base' >> Copying template's contents >> Applying fragment 'context-fragment.xml' to 'conf/context.xml' >> Applying fragment 'server-fragment.xml' to 'conf/server.xml' >> Applying fragment 'web-fragment.xml' to 'conf/web.xml' >> Applying fragment 'tomcat-users-fragment.xml' >> to 'conf/tomcat-users.xml' >> Applying fragment 'catalina-fragment.properties' >> to 'conf/catalina.properties' >> Applying template 'base-tomcat-7' >> Copying template's contents >> Applying fragment 'server-fragment.xml' to 'conf/server.xml' >> Applying fragment 'web-fragment.xml' to 'conf/web.xml' >> Applying fragment 'catalina-fragment.properties' >> to 'conf/catalina.properties' >> Applying template 'bio' >> Copying template's contents >> Applying fragment 'server-fragment.xml' to 'conf/server.xml' >> Configuring instance 'pxf-service' to use Tomcat version >> 7.0.55.A.RELEASE >> Setting permissions >> Instance created >> Connector summary >> Port: 51200 Type: Blocking IO Secure: false >> [root@cent61 profile.d]# service pxf-service start >> /var/gphd/pxf / >> Creating home directory for pxf. >> Using CATALINA_BASE: /var/gphd/pxf/pxf-service >> Using >> CATALINA_HOME: >> /opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE >> Using CATALINA_TMPDIR: /var/gphd/pxf/pxf-service/temp >> Using JRE_HOME: /usr/jdk64/jdk1.7.0_67 >> Using CLASSPATH: >> >> /opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE/bin/bootstrap.jar:/opt/vmware/vfabric-tc-server-standard/tomcat-7.0.55.A.RELEASE/bin/tomcat-juli.jar >> Using CATALINA_PID: /var/gphd/pxf/pxf-service/logs/tcserver.pid >> Tomcat started. >> Status: RUNNING as PID=8385 >> / >> Checking if tcServer is up and running... >> tcServer not responding, re-trying after 1 second (attempt number 1) >> tcServer not responding, re-trying after 1 second (attempt number 2) >> Checking if PXF webapp is up and running... >> ERROR: PXF webapp is inaccessible but tcServer is up. Check logs for more >> information >> >> Now the select statement showing another error: >> tpch=# select * from base_member; >> ERROR: GPHD component not found (libchurl.c:1058) >> >> Looks like hit this error: >> bool handle_special_error(long response) >> { >> switch (response) >> { >> case 404: >> elog(ERROR, "GPHD component not found"); >> break; >> default: >> return false; >> } >> return true; >> } >> >> Now do I need some sort of web service running, in order to make it work? >> Is it caused by PXF web app was not able to run? Which log do I supposed >> to look? >> catalina log showing this and I’m not sure if it’s the right one to look: >> 29-Oct-2015 16:37:34.923 SEVERE >> [localhost-startStop-1] >> org.apache.catalina.core.ContainerBase.addChildInternal >> ContainerBase.addChild: >> start: >> org.apache.catalina.LifecycleException: Failed to >> start component >> [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/pxf]] >> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:154) >> >> at >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901) >> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) >> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) >> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083) >> >> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880) >> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >> >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:745) >> Caused by: >> java.lang.NoClassDefFoundError: Lorg/apache/commons/logging/Log; >> at java.lang.Class.getDeclaredFields0(Native Method) >> at java.lang.Class.privateGetDeclaredFields(Class.java:2436) >> at java.lang.Class.getDeclaredFields(Class.java:1806) >> >> at >> org.apache.catalina.util.Introspection.getDeclaredFields(Introspection.java:106) >> >> at >> org.apache.catalina.startup.WebAnnotationSet.loadFieldsAnnotation(WebAnnotationSet.java:270) >> >> at >> org.apache.catalina.startup.WebAnnotationSet.loadApplicationListenerAnnotations(WebAnnotationSet.java:89) >> >> at >> org.apache.catalina.startup.WebAnnotationSet.loadApplicationAnnotations(WebAnnotationSet.java:63) >> >> at >> org.apache.catalina.startup.ContextConfig.applicationAnnotationsConfig(ContextConfig.java:403) >> >> at >> org.apache.catalina.startup.ContextConfig.configureStart(ContextConfig.java:879) >> >> at >> org.apache.catalina.startup.ContextConfig.lifecycleEvent(ContextConfig.java:374) >> >> at >> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117) >> >> at >> org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90) >> >> at >> org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5378) >> at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) >> ... 10 more >> Caused by: >> java.lang.ClassNotFoundException: org.apache.commons.logging.Log >> >> at >> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720) >> >> at >> org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1571) >> ... 24 more >> >> 29-Oct-2015 16:37:34.924 SEVERE >> [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployWAR >> Error deploying web application archive >> /var/gphd/pxf/pxf-service/webapps/pxf.war >> java.lang.IllegalStateException: ContainerBase.addChild: >> start: org.apache.catalina.LifecycleException: Failed to >> start component >> [StandardEngine[Catalina].StandardHost[localhost].StandardContext[/pxf]] >> >> at >> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:904) >> at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877) >> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:649) >> at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1083) >> >> at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1880) >> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) >> at java.util.concurrent.FutureTask.run(FutureTask.java:262) >> >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:745) >> >> I’m running on a previously built HDP 2.2.8 and performed manual HAWQ >> installation. I got most parts done but stuck at PXF component, any help >> would be appreciate. >> >> Thanks >> >> >> >
