You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@oozie.apache.org by Prashant Kommireddi <pr...@gmail.com> on 2012/10/25 00:48:15 UTC
Startup issue
I am seeing the following issue with on trying to start Oozie. Is it
anything to do with the permissions on "data" directory?
2012-10-24 15:44:12,419 FATAL Services:533 - USER[-] GROUP[-] TOKEN[-]
APP[-] JOB[-] ACTION[-] DDL is not permitted for a read-only connection, use
r or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS --
BundleActionBean
(bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
last_modifie
d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
<openjpa-2.1.0-r422266:1071316 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: DDL is not permitted
for a read-only co
nnection, user or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS
-- BundleActionBean
(bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
last_modifie
d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:558)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
at
org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
at
org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:210)
at
org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
at
org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
at
org.apache.oozie.service.JPAService.getEntityManager(JPAService.java:255)
at org.apache.oozie.service.JPAService.init(JPAService.java:158)
at
org.apache.oozie.service.Services.setServiceInternal(Services.java:310)
at org.apache.oozie.service.Services.setService(Services.java:296)
at org.apache.oozie.service.Services.init(Services.java:206)
at
org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:40)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
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.deployDescriptor(HostConfig.java:675)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
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:1061)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
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:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: DDL is not
permitted for a read-only connection, user or database. {stmnt 1227346270
CREATE TABLE BUNDLE_ACTIONS -- BundleActionBean
(bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
last_modified_time TIMESTAMP, pending INTEGER, status VARCHAR(255),
bean_type VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000,
state=25503]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:975)
at
org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:136)
at
org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1221)
at
org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:972)
at
org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:548)
at
org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:363)
at
org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:340)
at
org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)
... 39 more
2012-10-24 15:44:12,422 INFO Services:539 - Shutdown
Thanks,
Prashant
Re: Startup issue
Posted by Prashant Kommireddi <pr...@gmail.com>.
Thanks Alejandro.
I was actually running setup and start with the same userid. However, I
think the failure had something to do with oozie being checked-in to
revision control and the permissions thereafter.
Changing the OOZIE_DATA directory solved the issue.
- Prashant
On Wed, Oct 24, 2012 at 3:57 PM, Alejandro Abdelnur <tu...@cloudera.com>wrote:
> Prashant,
>
> It seems you run the oozie-setup or ooziedb as ROOT and now you are
> trying to start Oozie with another user.
>
> Thx
>
> On Wed, Oct 24, 2012 at 3:48 PM, Prashant Kommireddi
> <pr...@gmail.com> wrote:
> > I am seeing the following issue with on trying to start Oozie. Is it
> > anything to do with the permissions on "data" directory?
> >
> >
> >
> > 2012-10-24 15:44:12,419 FATAL Services:533 - USER[-] GROUP[-] TOKEN[-]
> > APP[-] JOB[-] ACTION[-] DDL is not permitted for a read-only connection,
> use
> > r or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS --
> > BundleActionBean
> > (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> > coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> > last_modifie
> > d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
> > VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
> > <openjpa-2.1.0-r422266:1071316 nonfatal general error>
> > org.apache.openjpa.persistence.PersistenceException: DDL is not permitted
> > for a read-only co
> > nnection, user or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS
> > -- BundleActionBean
> > (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> > coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> > last_modifie
> > d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
> > VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
> > at
> > org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:558)
> > at
> > org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)
> > at
> >
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
> > at
> >
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
> > at
> >
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
> > at
> >
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:210)
> > at
> >
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> > at
> >
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> > at
> >
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
> > at
> >
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> > at
> > org.apache.oozie.service.JPAService.getEntityManager(JPAService.java:255)
> > at org.apache.oozie.service.JPAService.init(JPAService.java:158)
> > at
> > org.apache.oozie.service.Services.setServiceInternal(Services.java:310)
> > at
> org.apache.oozie.service.Services.setService(Services.java:296)
> > at org.apache.oozie.service.Services.init(Services.java:206)
> > at
> >
> org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:40)
> > at
> >
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
> > at
> > org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
> > 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.deployDescriptor(HostConfig.java:675)
> > at
> >
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
> > at
> > org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
> > at
> > org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
> > 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:1061)
> > at
> > org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
> > at
> > org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> > 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:39)
> > at
> >
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> > at java.lang.reflect.Method.invoke(Method.java:597)
> > at
> org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> > at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> > Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: DDL is not
> > permitted for a read-only connection, user or database. {stmnt 1227346270
> > CREATE TABLE BUNDLE_ACTIONS -- BundleActionBean
> > (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> > coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> > last_modified_time TIMESTAMP, pending INTEGER, status VARCHAR(255),
> > bean_type VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000,
> > state=25503]
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
> > at
> >
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:975)
> > at
> >
> org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:136)
> > at
> >
> org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1221)
> > at
> >
> org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:972)
> > at
> > org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:548)
> > at
> > org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:363)
> > at
> > org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:340)
> > at
> > org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)
> > ... 39 more
> > 2012-10-24 15:44:12,422 INFO Services:539 - Shutdown
> >
> >
> > Thanks,
> > Prashant
>
>
>
> --
> Alejandro
>
Re: Startup issue
Posted by Alejandro Abdelnur <tu...@cloudera.com>.
Prashant,
It seems you run the oozie-setup or ooziedb as ROOT and now you are
trying to start Oozie with another user.
Thx
On Wed, Oct 24, 2012 at 3:48 PM, Prashant Kommireddi
<pr...@gmail.com> wrote:
> I am seeing the following issue with on trying to start Oozie. Is it
> anything to do with the permissions on "data" directory?
>
>
>
> 2012-10-24 15:44:12,419 FATAL Services:533 - USER[-] GROUP[-] TOKEN[-]
> APP[-] JOB[-] ACTION[-] DDL is not permitted for a read-only connection, use
> r or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS --
> BundleActionBean
> (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> last_modifie
> d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
> VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
> <openjpa-2.1.0-r422266:1071316 nonfatal general error>
> org.apache.openjpa.persistence.PersistenceException: DDL is not permitted
> for a read-only co
> nnection, user or database. {stmnt 1227346270 CREATE TABLE BUNDLE_ACTIONS
> -- BundleActionBean
> (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> last_modifie
> d_time TIMESTAMP, pending INTEGER, status VARCHAR(255), bean_type
> VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000, state=25503]
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:558)
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:210)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.apache.oozie.service.JPAService.getEntityManager(JPAService.java:255)
> at org.apache.oozie.service.JPAService.init(JPAService.java:158)
> at
> org.apache.oozie.service.Services.setServiceInternal(Services.java:310)
> at org.apache.oozie.service.Services.setService(Services.java:296)
> at org.apache.oozie.service.Services.init(Services.java:206)
> at
> org.apache.oozie.servlet.ServicesLoader.contextInitialized(ServicesLoader.java:40)
> at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
> 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.deployDescriptor(HostConfig.java:675)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
> at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
> 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:1061)
> at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
> at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> 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:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: DDL is not
> permitted for a read-only connection, user or database. {stmnt 1227346270
> CREATE TABLE BUNDLE_ACTIONS -- BundleActionBean
> (bundle_action_id VARCHAR(255) NOT NULL, bundle_id VARCHAR(255),
> coord_id VARCHAR(255), coord_name VARCHAR(255), critical INTEGER,
> last_modified_time TIMESTAMP, pending INTEGER, status VARCHAR(255),
> bean_type VARCHAR(31), PRIMARY KEY (bundle_action_id))} [code=30000,
> state=25503]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:975)
> at
> org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:136)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1221)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.createTable(SchemaTool.java:972)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:548)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:363)
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:340)
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)
> ... 39 more
> 2012-10-24 15:44:12,422 INFO Services:539 - Shutdown
>
>
> Thanks,
> Prashant
--
Alejandro