API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 1st, 2016
1,633
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.07 KB | None | 0 0
raw download clone embed print report
  1. Package failed to execute.
  2.  
  3.  
  4. ======== job_201609011308_0013 attempt_201609011308_0013_m_000000_0 stderr.summary ========
  5.  
  6.  
  7. 16/09/01 13:13:17 WARN tool.EvalSqlTool: SQL exception executing statement: org.postgresql.util.PSQLException: ERROR: Load into table 'xplenty_staging_3681' failed. Check 'stl_load_errors' system table for details.
  8. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
  9. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
  10. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  11. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:570)
  12. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)
  13. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:413)
  14. at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:68)
  15. at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
  16. at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
  17. at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
  18. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
  19. at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
  20. at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
  21.  
  22.  
  23. Pig logfile dump:
  24.  
  25. Pig Stack Trace
  26. ---------------
  27. ERROR 2997: Encountered IOException. java.io.IOException: sh command 'HADOOP_USER_NAME=u_1848 sqoop eval --connect "jdbc:postgresql://localhost:62854/bigcartel?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" --username * --password * --query "START TRANSACTION;CREATE TEMPORARY TABLE \"xplenty_staging_3681\" AS SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"bigcartel\".\"product_images\" WHERE 0=1;COPY \"xplenty_staging_3681\" (\"id\", \"account_id\", \"product_id\", \"position\", \"imgsize\", \"width\", \"height\", \"filename\", \"content_type\", \"uploaded\", \"created_at\", \"updated_at\", \"disabled_at\") FROM 's3://us-west-2.xplenty.redshift/accounts/1848/tmp/job-2917099-redshift_product_images-0G4l2D6d93xOdQ' CREDENTIALS 'aws_access_key_id=*;aws_secret_access_key=*' DELIMITER '|' ESCAPE MAXERROR AS 1 ACCEPTANYDATE DATEFORMAT AS 'auto' TIMEFORMAT AS 'auto' NULL AS '\\\\N' COMPROWS 100000;DELETE FROM \"bigcartel\".\"product_images\" USING \"xplenty_staging_3681\" WHERE \"bigcartel\".\"product_images\".\"id\" = \"xplenty_staging_3681\".\"id\";INSERT INTO \"bigcartel\".\"product_images\"(\"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\") SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"xplenty_staging_3681\";COMMIT;"' failed. Please check output logs for details
  28.  
  29. java.io.IOException: java.io.IOException: sh command 'HADOOP_USER_NAME=u_1848 sqoop eval --connect "jdbc:postgresql://localhost:62854/bigcartel?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" --username * --password * --query "START TRANSACTION;CREATE TEMPORARY TABLE \"xplenty_staging_3681\" AS SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"bigcartel\".\"product_images\" WHERE 0=1;COPY \"xplenty_staging_3681\" (\"id\", \"account_id\", \"product_id\", \"position\", \"imgsize\", \"width\", \"height\", \"filename\", \"content_type\", \"uploaded\", \"created_at\", \"updated_at\", \"disabled_at\") FROM 's3://us-west-2.xplenty.redshift/accounts/1848/tmp/job-2917099-redshift_product_images-0G4l2D6d93xOdQ' CREDENTIALS 'aws_access_key_id=*;aws_secret_access_key=*' DELIMITER '|' ESCAPE MAXERROR AS 1 ACCEPTANYDATE DATEFORMAT AS 'auto' TIMEFORMAT AS 'auto' NULL AS '\\\\N' COMPROWS 100000;DELETE FROM \"bigcartel\".\"product_images\" USING \"xplenty_staging_3681\" WHERE \"bigcartel\".\"product_images\".\"id\" = \"xplenty_staging_3681\".\"id\";INSERT INTO \"bigcartel\".\"product_images\"(\"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\") SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"xplenty_staging_3681\";COMMIT;"' failed. Please check output logs for details
  30. at org.apache.pig.tools.grunt.GruntParser.processShCommand(GruntParser.java:1189)
  31. at org.apache.pig.tools.pigscript.parser.PigScriptParser.parse(PigScriptParser.java:183)
  32. at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:230)
  33. at org.apache.pig.tools.grunt.GruntParser.parseStopOnError(GruntParser.java:205)
  34. at org.apache.pig.tools.grunt.Grunt.exec(Grunt.java:81)
  35. at org.apache.pig.Main.run(Main.java:495)
  36. at org.apache.pig.PigRunner.run(PigRunner.java:49)
  37. at org.apache.oozie.action.hadoop.PigMain.runPigJob(PigMain.java:283)
  38. at org.apache.oozie.action.hadoop.PigMain.run(PigMain.java:223)
  39. at org.apache.oozie.action.hadoop.LauncherMain.run(LauncherMain.java:37)
  40. at org.apache.oozie.action.hadoop.PigMain.main(PigMain.java:76)
  41. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  42. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  43. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  44. at java.lang.reflect.Method.invoke(Method.java:606)
  45. at org.apache.oozie.action.hadoop.LauncherMapper.map(LauncherMapper.java:491)
  46. at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50)
  47. at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:429)
  48. at org.apache.hadoop.mapred.MapTask.run(MapTask.java:365)
  49. at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
  50. at java.security.AccessController.doPrivileged(Native Method)
  51. at javax.security.auth.Subject.doAs(Subject.java:415)
  52. at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1232)
  53. at org.apache.hadoop.mapred.Child.main(Child.java:249)
  54. Caused by: java.io.IOException: sh command 'HADOOP_USER_NAME=u_1848 sqoop eval --connect "jdbc:postgresql://localhost:62854/bigcartel?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory" --username * --password * --query "START TRANSACTION;CREATE TEMPORARY TABLE \"xplenty_staging_3681\" AS SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"bigcartel\".\"product_images\" WHERE 0=1;COPY \"xplenty_staging_3681\" (\"id\", \"account_id\", \"product_id\", \"position\", \"imgsize\", \"width\", \"height\", \"filename\", \"content_type\", \"uploaded\", \"created_at\", \"updated_at\", \"disabled_at\") FROM 's3://us-west-2.xplenty.redshift/accounts/1848/tmp/job-2917099-redshift_product_images-0G4l2D6d93xOdQ' CREDENTIALS 'aws_access_key_id=*;aws_secret_access_key=*' DELIMITER '|' ESCAPE MAXERROR AS 1 ACCEPTANYDATE DATEFORMAT AS 'auto' TIMEFORMAT AS 'auto' NULL AS '\\\\N' COMPROWS 100000;DELETE FROM \"bigcartel\".\"product_images\" USING \"xplenty_staging_3681\" WHERE \"bigcartel\".\"product_images\".\"id\" = \"xplenty_staging_3681\".\"id\";INSERT INTO \"bigcartel\".\"product_images\"(\"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\") SELECT \"id\",\"account_id\",\"product_id\",\"position\",\"imgsize\",\"width\",\"height\",\"filename\",\"content_type\",\"uploaded\",\"created_at\",\"updated_at\",\"disabled_at\" FROM \"xplenty_staging_3681\";COMMIT;"' failed. Please check output logs for details
  55. at org.apache.pig.tools.grunt.GruntParser.processShCommand(GruntParser.java:1185)
  56. ... 23 more
  57. ================================================================================
  58. Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.PigMain], exit code [2]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!