FAQ
It seems that you are having a long list or a big Hadoop properties?

Caused by: org.apache.openjpa.lib.jdbc.
ReportingSQLException: Data truncation: Data too long for column
'proto_action_conf' at row 1 {prepstmnt 283670632 INSERT INTO WF_JOBS (id,
app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type,
auth_token, created_time, end_time, external_id, last_modified_time,
log_token, proto_action_conf, sla_xml, start_time, status, wf_instance)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?]}
[code=1406, state=22001]
Can you share your 'Properties' information?

A workaround could be to use 'SET' in the script for setting them:
http://pig.apache.org/docs/r0.10.0/cmds.html#set

Romain


On Wed, Sep 4, 2013 at 4:02 AM, wrote:

Hello.

When I try to push "Run" nothing happens. In "Current Logs" section: "No
available logs."

Server logs:

{TIME} middleware INFO Processing exception: Error submitting workflow pig-app-hue-script - hduser: Traceback (most recent call last):
File "/home/hduser/hue/build/env/lib/python2.6/site-packages/Django-1.2.3-py2.6.egg/django/core/handlers/base.py", line 100, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/home/hduser/hue/apps/oozie/src/oozie/views/dashboard.py", line 86, in decorate
return view_func(request, *args, **kwargs)
File "/home/hduser/hue/apps/pig/src/pig/views.py", line 126, in run
oozie_id = api.get(request.fs, request.user).submit(pig_script, params)
File "/home/hduser/hue/apps/pig/src/pig/api.py", line 67, in submit
oozie_wf = _submit_workflow(self.user, self.fs, workflow, mapping)
File "/home/hduser/hue/apps/oozie/src/oozie/views/editor.py", line 338, in _submit_workflow
raise PopupException(_("Error submitting workflow %s") % (workflow,), detail=detail)
PopupException: Error submitting workflow pig-app-hue-script - hduser


{TIME} http_client DEBUG POST http://localhost:11000/oozie/v1/jobs?timezone={TIMEZONE}&user.name=hue&doAs=hduser
Oozie log:

{TIME} WARN V1JobsServlet:542 - USER[hduser] GROUP[-] TOKEN[]
APP[pig-app-hue-script] JOB[0000000-130904143654580-oozie-oozi-W] ACTION[-]
URL[POST
http://localhost:11000/oozie/v1/jobs?timezone={TIMEZONE}&user.name=hue&doAs=hduser]
error[E0803], E0803: IO error, The transaction has been rolled back. See
the nested exceptions for details on the errors that occurred.
org.apache.oozie.servlet.XServletException: E0803: IO error, The
transaction has been rolled back. See the nested exceptions for details on
the errors that occurred.
at
org.apache.oozie.servlet.V1JobsServlet.submitWorkflowJob(V1JobsServlet.java:185)
at
org.apache.oozie.servlet.V1JobsServlet.submitJob(V1JobsServlet.java:80)
at
org.apache.oozie.servlet.BaseJobsServlet.doPost(BaseJobsServlet.java:100)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at
org.apache.oozie.servlet.JsonRestServlet.service(JsonRestServlet.java:286)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.oozie.servlet.AuthFilter$2.doFilter(AuthFilter.java:126)
at
org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:384)
at
org.apache.oozie.servlet.AuthFilter.doFilter(AuthFilter.java:131)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.oozie.servlet.HostnameFilter.doFilter(HostnameFilter.java:84)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:724)
Caused by: org.apache.oozie.DagEngineException: E0803: IO error, The
transaction has been rolled back. See the nested exceptions for details on
the errors that occurred.
at org.apache.oozie.DagEngine.submitJob(DagEngine.java:116)
at
org.apache.oozie.servlet.V1JobsServlet.submitWorkflowJob(V1JobsServlet.java:180)
... 25 more
Caused by: org.apache.oozie.command.CommandException: E0803: IO error,
The transaction has been rolled back. See the nested exceptions for
details on the errors that occurred.
at
org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:233)
at
org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:71)
at org.apache.oozie.command.XCommand.call(XCommand.java:277)
at org.apache.oozie.DagEngine.submitJob(DagEngine.java:109)
... 26 more
Caused by: <openjpa-2.1.0-r422266:1071316 fatal store error>
org.apache.openjpa.persistence.RollbackException: The transaction has been
rolled back. See the nested exceptions for details on the errors that
occurred.
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:585)
at
org.apache.oozie.service.JPAService.execute(JPAService.java:217)
at
org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:209)
... 29 more
Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.openjpa.persistence.PersistenceException: The transaction has
been rolled back. See the nested exceptions for details on the errors that
occurred.
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316)
at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153)
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051)
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1969)
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1493)
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:561)
... 31 more
Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Data truncation: Data
too long for column 'proto_action_conf' at row 1 {prepstmnt 283670632
INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id,
run, user_name, bean_type, auth_token, created_time, end_time, external_id,
last_modified_time, log_token, proto_action_conf, sla_xml, start_time,
status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?]} [code=1406, state=22001]
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushBatch(BatchingPreparedStatementManagerImpl.java:217)
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:63)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
... 38 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data
truncation: Data too long for column 'proto_action_conf' at row 1
{prepstmnt 283670632 INSERT INTO WF_JOBS (id, app_name, app_path, conf,
group_name, parent_id, run, user_name, bean_type, auth_token, created_time,
end_time, external_id, last_modified_time, log_token, proto_action_conf,
sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?]} [code=1406, state=22001]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)
Caused by: <openjpa-2.1.0-r422266:1071316 fatal store error>
org.apache.openjpa.persistence.RollbackException: The transaction has been
rolled back. See the nested exceptions for details on the errors that
occurred.
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:585)
at
org.apache.oozie.service.JPAService.execute(JPAService.java:217)
at
org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:209)
... 29 more
Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.openjpa.persistence.PersistenceException: The transaction has
been rolled back. See the nested exceptions for details on the errors that
occurred.
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2316)
at
org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2153)
at
org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2051)
at
org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1969)
at
org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
at
org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1493)
at
org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925)
at
org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:561)
... 31 more
Caused by: <openjpa-2.1.0-r422266:1071316 fatal general error>
org.apache.openjpa.persistence.PersistenceException: Data truncation: Data
too long for column 'proto_action_conf' at row 1 {prepstmnt 283670632
INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id,
run, user_name, bean_type, auth_token, created_time, end_time, external_id,
last_modified_time, log_token, proto_action_conf, sla_xml, start_time,
status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?]} [code=1406, state=22001]
FailedObject: org.apache.oozie.WorkflowJobBean@edd402f
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4869)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4829)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushBatch(BatchingPreparedStatementManagerImpl.java:217)
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:63)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:103)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:76)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:742)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
... 38 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Data
truncation: Data too long for column 'proto_action_conf' at row 1
{prepstmnt 283670632 INSERT INTO WF_JOBS (id, app_name, app_path, conf,
group_name, parent_id, run, user_name, bean_type, auth_token, created_time,
end_time, external_id, last_modified_time, log_token, proto_action_conf,
sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?]} [code=1406, state=22001]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:257)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:72)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1199)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:291)

oozie-site.xml:

oozie.service.ProxyUserService.proxyuser.hue.hosts=*
oozie.service.ProxyUserService.proxyuser.hduser.hosts=*
oozie.service.ProxyUserService.proxyuser.hue.groups=*
oozie.service.ProxyUserService.proxyuser.hduser.groups=*

core-site.xml:

hadoop.proxyuser.hue.groups=*
hadoop.proxyuser.hue.hosts=*
hadoop.proxyuser.oozie.groups=*
hadoop.proxyuser.oozie.hosts=*

Thank you.

To unsubscribe from this group and stop receiving emails from it, send an
email to hue-user+unsubscribe@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+unsubscribe@cloudera.org.

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouphue-user @
categorieshadoop
postedSep 4, '13 at 11:02a
activeSep 4, '13 at 3:16p
posts2
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Vivalalabor: 1 post Romain Rigaux: 1 post

People

Translate

site design / logo © 2022 Grokbase