At this point it'll be way easier for you to simply get a brand new VM. Thanks, Roman.
On Fri, Dec 6, 2013 at 10:37 AM, ivo frankov <[email protected]> wrote: > 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 exists > at > 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. >>>>>>>>> >>>>>>>>> >
