Hi Roman, I reastarted my computer and I received :
Validate DB Connection DONE Check DB schema does not exist Error: DB schema exists Stack trace for the error was (for debug purposes): -------------------------------------- java.lang.Exception: DB schema existsat org.apache.oozie.tools.OozieDBCLI.validateDBSchema(OozieDBCLI.java:384)
at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:169)
at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:112)
at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:63)
--------------------------------------
Btw how can I deinstall bigtop ?
Best regards,
Ivo
On 12/06/2013 07:22 PM, Roman Shaposhnik wrote:
you seem to have a messed up installation at this point I'd suggest starting from scratch (perhaps in a VM). Thanks, Roman. On Fri, Dec 6, 2013 at 10:14 AM, ivo frankov <[email protected]> wrote:Hi Roman, oozie.log was from yesterday. That ś what happend when I made what you wrote me: thank you very much! Best regards, Ivo ivo@ivo-Aspire-3830T:/var/log/oozie$ sudo rm -rf /var/lib/oozie/* [sudo] password for ivo: ivo@ivo-Aspire-3830T:/var/log/oozie$ sudo /etc/init.d/oozie init Error: Oozie is running. Stop it first. ivo@ivo-Aspire-3830T:/var/log/oozie$ sudo /etc/init.d/oozie stop Setting OOZIE_HOME: /usr/lib/oozie Sourcing: /usr/lib/oozie/bin/oozie-env.sh setting OOZIE_CONFIG=/etc/oozie/conf setting OOZIE_DATA=/var/lib/oozie setting OOZIE_LOG=/var/log/oozie setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat setting CATALINA_TMPDIR=/var/lib/oozie setting CATALINA_PID=/var/run/oozie/oozie.pid setting CATALINA_BASE=/var/lib/oozie/tomcat-deployment Using OOZIE_CONFIG: /etc/oozie/conf Sourcing: /etc/oozie/conf/oozie-env.sh setting OOZIE_CONFIG=/etc/oozie/conf setting OOZIE_DATA=/var/lib/oozie setting OOZIE_LOG=/var/log/oozie setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat setting CATALINA_TMPDIR=/var/lib/oozie setting CATALINA_PID=/var/run/oozie/oozie.pid setting CATALINA_BASE=/var/lib/oozie/tomcat-deployment Setting OOZIE_CONFIG_FILE: oozie-site.xml Using OOZIE_DATA: /var/lib/oozie Using OOZIE_LOG: /var/log/oozie Setting OOZIE_LOG4J_FILE: oozie-log4j.properties Setting OOZIE_LOG4J_RELOAD: 10 Setting OOZIE_HTTP_HOSTNAME: ivo-Aspire-3830T Setting OOZIE_HTTP_PORT: 11000 Setting OOZIE_ADMIN_PORT: 11001 Setting OOZIE_HTTPS_PORT: 11443 Setting OOZIE_BASE_URL: http://ivo-Aspire-3830T:11000/oozie Using CATALINA_BASE: /var/lib/oozie/tomcat-deployment Setting OOZIE_HTTPS_KEYSTORE_FILE: /var/lib/oozie/.keystore Setting OOZIE_HTTPS_KEYSTORE_PASS: password Setting CATALINA_OUT: /var/log/oozie/catalina.out Using CATALINA_PID: /var/run/oozie/oozie.pid Using CATALINA_OPTS: -Dderby.stream.error.file=/var/log/oozie/derby.log Adding to CATALINA_OPTS: -Doozie.home.dir=/usr/lib/oozie -Doozie.config.dir=/etc/oozie/conf -Doozie.log.dir=/var/log/oozie -Doozie.data.dir=/var/lib/oozie -Doozie.config.file=oozie-site.xml -Doozie.log4j.file=oozie-log4j.properties -Doozie.log4j.reload=10 -Doozie.http.hostname=ivo-Aspire-3830T -Doozie.admin.port=11001 -Doozie.http.port=11000 -Doozie.https.port=11443 -Doozie.base.url=http://ivo-Aspire-3830T:11000/oozie -Doozie.https.keystore.file=/var/lib/oozie/.keystore -Doozie.https.keystore.pass=password -Djava.library.path= Using CATALINA_BASE: /var/lib/oozie/tomcat-deployment Using CATALINA_HOME: /usr/lib/bigtop-tomcat Using CATALINA_TMPDIR: /var/lib/oozie Using JRE_HOME: /usr/lib/jvm/java-7-oracle Using CLASSPATH: /usr/lib/bigtop-tomcat/bin/bootstrap.jar Using CATALINA_PID: /var/run/oozie/oozie.pid Dec 06, 2013 7:12:04 PM org.apache.catalina.startup.Catalina stopServer SEVERE: Catalina.stop: java.io.FileNotFoundException: /var/lib/oozie/tomcat-deployment/conf/server.xml (No such file or directory) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(FileInputStream.java:146) at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:395) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.stopServer(Bootstrap.java:338) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:416) Killing Tomcat with the PID: 4728 ivo@ivo-Aspire-3830T:/var/log/oozie$ sudo /etc/init.d/oozie init setting OOZIE_CONFIG=/etc/oozie/conf setting OOZIE_DATA=/var/lib/oozie setting OOZIE_LOG=/var/log/oozie setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat setting CATALINA_TMPDIR=/var/lib/oozie setting CATALINA_PID=/var/run/oozie/oozie.pid setting CATALINA_BASE=/var/lib/oozie/tomcat-deployment setting OOZIE_CONFIG=/etc/oozie/conf setting OOZIE_DATA=/var/lib/oozie setting OOZIE_LOG=/var/log/oozie setting OOZIE_CATALINA_HOME=/usr/lib/bigtop-tomcat setting CATALINA_TMPDIR=/var/lib/oozie setting CATALINA_PID=/var/run/oozie/oozie.pid setting CATALINA_BASE=/var/lib/oozie/tomcat-deployment Validate DB Connection log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /var/log/oozie/oozie-jpa.log (Permission denied) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:221) at java.io.FileOutputStream.<init>(FileOutputStream.java:142) at org.apache.log4j.FileAppender.setFile(FileAppender.java:294) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165) at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:223) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:172) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:104) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:809) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:639) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:504) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:395) at org.apache.log4j.PropertyWatchdog.doOnChange(PropertyConfigurator.java:922) at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:89) at org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:58) at org.apache.log4j.PropertyWatchdog.<init>(PropertyConfigurator.java:914) at org.apache.log4j.PropertyConfigurator.configureAndWatch(PropertyConfigurator.java:461) at org.apache.oozie.service.XLogService.init(XLogService.java:157) at org.apache.oozie.service.Services.setServiceInternal(Services.java:368) at org.apache.oozie.service.Services.<init>(Services.java:108) at org.apache.oozie.tools.OozieDBCLI.getJdbcConf(OozieDBCLI.java:150) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:346) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:354) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:168) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:112) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:63) log4j:ERROR Either File or DatePattern options are not set for appender [openjpa]. log4j:ERROR setFile(null,true) call failed. java.io.FileNotFoundException: /var/log/oozie/oozie-ops.log (Permission denied) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.<init>(FileOutputStream.java:221) at java.io.FileOutputStream.<init>(FileOutputStream.java:142) at org.apache.log4j.FileAppender.setFile(FileAppender.java:294) at org.apache.log4j.FileAppender.activateOptions(FileAppender.java:165) at org.apache.log4j.DailyRollingFileAppender.activateOptions(DailyRollingFileAppender.java:223) at org.apache.log4j.config.PropertySetter.activate(PropertySetter.java:307) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:172) at org.apache.log4j.config.PropertySetter.setProperties(PropertySetter.java:104) at org.apache.log4j.PropertyConfigurator.parseAppender(PropertyConfigurator.java:809) at org.apache.log4j.PropertyConfigurator.parseCategory(PropertyConfigurator.java:735) at org.apache.log4j.PropertyConfigurator.parseCatsAndRenderers(PropertyConfigurator.java:639) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:504) at org.apache.log4j.PropertyConfigurator.doConfigure(PropertyConfigurator.java:395) at org.apache.log4j.PropertyWatchdog.doOnChange(PropertyConfigurator.java:922) at org.apache.log4j.helpers.FileWatchdog.checkAndConfigure(FileWatchdog.java:89) at org.apache.log4j.helpers.FileWatchdog.<init>(FileWatchdog.java:58) at org.apache.log4j.PropertyWatchdog.<init>(PropertyConfigurator.java:914) at org.apache.log4j.PropertyConfigurator.configureAndWatch(PropertyConfigurator.java:461) at org.apache.oozie.service.XLogService.init(XLogService.java:157) at org.apache.oozie.service.Services.setServiceInternal(Services.java:368) at org.apache.oozie.service.Services.<init>(Services.java:108) at org.apache.oozie.tools.OozieDBCLI.getJdbcConf(OozieDBCLI.java:150) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:346) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:354) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:168) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:112) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:63) log4j:ERROR Either File or DatePattern options are not set for appender [oozieops]. Error: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver Stack trace for the error was (for debug purposes): -------------------------------------- java.lang.Exception: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:358) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:168) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:112) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:63) Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(URLClassLoader.java:366) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:190) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:347) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:354) ... 3 more -------------------------------------- ivo@ivo-Aspire-3830T:/var/log/oozie$ On 12/06/2013 06:52 PM, Roman Shaposhnik wrote:Looking at your oozie.log (why did you say it wasn't there?) I see the following exception (bellow). This means that you haven't initialized Oozie database. Make sure do the following: $ sudo rm -rf /var/lib/oozie/* $ sudo /etc/init.d/oozie init Thanks, Roman. 2013-11-05 18:58:16,072 FATAL Services:533 - USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Schema 'SA' does not exist {SELECT t0.bean_type, t0.conf, t0.console_url, t0.cred, t0.data, t0.error_code, t0.error_message, t0.external_child_ids, t0.external_id, t0.external_status, t0.name, t0.retries, t0.stats, t0.tracker_uri, t0.transition, t0.type, t0.user_retry_count, t0.user_retry_interval, t0.user_retry_max, t0.end_time, t0.execution_path, t0.last_check_time, t0.log_token, t0.pending, t0.pending_age, t0.signal_value, t0.sla_xml, t0.start_time, t0.status, t0.wf_id FROM WF_ACTIONS t0 WHERE t0.bean_type = ? AND t0.id = ?} [code=30000, state=42Y07] org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Schema 'SA' does not exist {SELECT t0.bean_type, t0.conf, t0.console_url, t0.cred, t0.data, t0.error_code, t0.error_message, t0.external_child_ids, t0.external_id, t0.external_status, t0.name, t0.retries, t0.stats, t0.tracker_uri, t0.transition, t0.type, t0.user_retry_count, t0.user_retry_interval, t0.user_retry_max, t0.end_time, t0.execution_path, t0.last_check_time, t0.log_token, t0.pending, t0.pending_age, t0.signal_value, t0.sla_xml, t0.start_time, t0.status, t0.wf_id FROM WF_ACTIONS t0 WHERE t0.bean_type = ? AND t0.id = ?} [code=30000, state=42Y07] at org.apache.oozie.service.Services.loadServices(Services.java:291) at org.apache.oozie.service.Services.init(Services.java:208) at org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:39) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) On Fri, Dec 6, 2013 at 9:36 AM, ivo frankov <[email protected]> wrote:that are files from last two days On 12/06/2013 06:31 PM, Roman Shaposhnik wrote:what other files do you have in /var/log/oozie ? On Fri, Dec 6, 2013 at 9:28 AM, ivo frankov <[email protected]> wrote:it is strange today I have no oozie log On 12/06/2013 06:23 PM, Roman Shaposhnik wrote:you need oozie.log On Fri, Dec 6, 2013 at 9:20 AM, ivo frankov <[email protected]> wrote:this is my log On 12/06/2013 06:13 PM, Roman Shaposhnik wrote:On Fri, Dec 6, 2013 at 9:06 AM, ivo frankov <[email protected]> wrote:Hi Roman, My purpose is to start pig editor in hue. I received that I have to start oozie web console first. I think that server is running. I receive following: Oozie web console is disabled. To enable Oozie web console install the Ext JS library.You need to install Ext JS in /var/lib/oozie.Refer to Oozie Quick Start documentation for details. Where I can find oozie log?/var/log/oozie Thanks, Roman.
