API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 9th, 2016
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.88 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE public.tt_test_fav
  2. (
  3. status_id bigint NOT NULL,
  4. id bigint NOT NULL,
  5. tp smallint NOT NULL DEFAULT 0,
  6. user_id bigint,
  7. user_rank smallint NOT NULL DEFAULT 0,
  8. CONSTRAINT tt_test_fav_pkey PRIMARY KEY (status_id, id, tp)
  9. );
  10.  
  11. CREATE TABLE public.tt_test_fav
  12. (
  13. status_id bigint NOT NULL,
  14. id bigint NOT NULL,
  15. tp smallint NOT NULL DEFAULT 0,
  16. user_id bigint,
  17. CONSTRAINT tt_test_fav_pkey PRIMARY KEY (status_id, id, tp)
  18. );
  19.  
  20. in:
  21. type: postgresql
  22. host: hoge.rds.amazonaws.com
  23. port: 5432
  24. user: hoge
  25. password: hoge
  26. database: hoge
  27. table: tt_test_fav
  28. select: status_id, id, tp, user_id
  29. column_options:
  30. status_id: {value_type: long}
  31. id: {value_type: long}
  32. tp: {value_type: long}
  33. user_id: {value_type: long}
  34.  
  35. out:
  36. type: postgresql
  37. host: localhost
  38. port: 5432
  39. user: hoge
  40. password: hoge
  41. database: hoge
  42. table: tt_test_fav
  43. mode: merge
  44. merge_keys: status_id, id, tp
  45. column_options:
  46. status_id: {value_type: long}
  47. id: {value_type: long}
  48. tp: {value_type: long}
  49. user_id: {value_type: long}
  50.  
  51. 2016-07-09 21:19:35.222 +0900: Embulk v0.8.9
  52. 2016-07-09 21:19:36.750 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-postgresql (0.7.2)
  53. 2016-07-09 21:19:36.963 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-postgresql (0.6.1)
  54. 2016-07-09 21:19:38.043 +0900 [INFO] (0001:transaction): SQL: SET search_path TO "public"
  55. 2016-07-09 21:19:38.447 +0900 [INFO] (0001:transaction): SQL: SELECT status_id, id, tp, user_id FROM "tt_test_fav"
  56. 2016-07-09 21:19:38.861 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=40 / output tasks 20 = input tasks 1 * 20
  57. org.embulk.exec.PartialExecutionException: org.embulk.config.ConfigException: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of VALUE_STRING token
  58. at [Source: N/A; line: -1, column: -1]
  59. at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(org/embulk/exec/BulkLoader.java:363)
  60. at org.embulk.exec.BulkLoader.doRun(org/embulk/exec/BulkLoader.java:572)
  61. at org.embulk.exec.BulkLoader.access$000(org/embulk/exec/BulkLoader.java:33)
  62. at org.embulk.exec.BulkLoader$1.run(org/embulk/exec/BulkLoader.java:374)
  63. at org.embulk.exec.BulkLoader$1.run(org/embulk/exec/BulkLoader.java:370)
  64. at org.embulk.spi.Exec.doWith(org/embulk/spi/Exec.java:25)
  65. at org.embulk.exec.BulkLoader.run(org/embulk/exec/BulkLoader.java:370)
  66. at org.embulk.EmbulkEmbed.run(org/embulk/EmbulkEmbed.java:180)
  67. at java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)
  68. at RUBY.run(/home/osa/.embulk/bin/embulk!/embulk/runner.rb:84)
  69. at RUBY.run(/home/osa/.embulk/bin/embulk!/embulk/command/embulk_run.rb:306)
  70. at RUBY.<top>(/home/osa/.embulk/bin/embulk!/embulk/command/embulk_main.rb:2)
  71. at org.jruby.RubyKernel.require(org/jruby/RubyKernel.java:937)
  72. at RUBY.(root)(uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/rubygems/core_ext/kernel_require.rb:1)
  73. at home.osa.$_dot_embulk.bin.embulk.embulk.command.embulk_bundle.<top>(file:/home/osa/.embulk/bin/embulk!/embulk/command/embulk_bundle.rb:51)
  74. at java.lang.invoke.MethodHandle.invokeWithArguments(java/lang/invoke/MethodHandle.java:627)
  75. at org.embulk.cli.Main.main(org/embulk/cli/Main.java:23)
  76. Suppressed: java.lang.NullPointerException
  77. at org.embulk.exec.BulkLoader.doCleanup(BulkLoader.java:479)
  78. at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:410)
  79. at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:406)
  80. at org.embulk.spi.Exec.doWith(Exec.java:25)
  81. at org.embulk.exec.BulkLoader.cleanup(BulkLoader.java:406)
  82. at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:184)
  83. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  84. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  85. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  86. at java.lang.reflect.Method.invoke(Method.java:498)
  87. at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:452)
  88. at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:313)
  89. at org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:45)
  90. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  91. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  92. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  93. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  94. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:140)
  95. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:126)
  96. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:273)
  97. at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:79)
  98. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:83)
  99. at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:414)
  100. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:348)
  101. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  102. at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:86)
  103. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:210)
  104. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:196)
  105. at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:197)
  106. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  107. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  108. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  109. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  110. at org.jruby.ir.interpreter.Interpreter.INTERPRET_ROOT(Interpreter.java:112)
  111. at org.jruby.ir.interpreter.Interpreter.execute(Interpreter.java:99)
  112. at org.jruby.ir.interpreter.Interpreter.execute(Interpreter.java:35)
  113. at org.jruby.ir.IRTranslator.execute(IRTranslator.java:42)
  114. at org.jruby.Ruby.runInterpreter(Ruby.java:833)
  115. at org.jruby.Ruby.loadFile(Ruby.java:2905)
  116. at org.jruby.runtime.load.LibrarySearcher$ResourceLibrary.load(LibrarySearcher.java:235)
  117. at org.jruby.runtime.load.LibrarySearcher$FoundLibrary.load(LibrarySearcher.java:34)
  118. at org.jruby.runtime.load.LoadService.tryLoadingLibraryOrScript(LoadService.java:900)
  119. at org.jruby.runtime.load.LoadService.smartLoadInternal(LoadService.java:541)
  120. at org.jruby.runtime.load.LoadService.requireCommon(LoadService.java:426)
  121. at org.jruby.runtime.load.LoadService.require(LoadService.java:392)
  122. at org.jruby.RubyKernel.requireCommon(RubyKernel.java:944)
  123. at org.jruby.RubyKernel.require19(RubyKernel.java:937)
  124. at org.jruby.RubyKernel$INVOKER$s$1$0$require19.call(RubyKernel$INVOKER$s$1$0$require19.gen)
  125. at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodOneOrNBlock.call(JavaMethod.java:380)
  126. at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:61)
  127. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  128. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  129. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  130. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  131. at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:86)
  132. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:210)
  133. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:196)
  134. at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:197)
  135. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  136. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  137. at home.osa.$_dot_embulk.bin.embulk.embulk.command.embulk_bundle.invokeOther66:require(file:/home/osa/.embulk/bin/embulk!/embulk/command/embulk_bundle.rb)
  138. at home.osa.$_dot_embulk.bin.embulk.embulk.command.embulk_bundle.RUBY$script(file:/home/osa/.embulk/bin/embulk!/embulk/command/embulk_bundle.rb:51)
  139. at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
  140. at org.jruby.ir.Compiler$1.load(Compiler.java:111)
  141. at org.jruby.Ruby.runScript(Ruby.java:817)
  142. at org.jruby.Ruby.runScript(Ruby.java:809)
  143. at org.jruby.Ruby.runNormally(Ruby.java:747)
  144. at org.jruby.Ruby.runFromMain(Ruby.java:569)
  145. at org.jruby.Main.doRunFromMain(Main.java:415)
  146. at org.jruby.Main.internalRun(Main.java:310)
  147. at org.jruby.Main.run(Main.java:239)
  148. at org.jruby.Main.main(Main.java:201)
  149. at org.embulk.cli.Main.main(Main.java:23)
  150. Caused by: org.embulk.config.ConfigException: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of VALUE_STRING token
  151. at [Source: N/A; line: -1, column: -1]
  152. at org.embulk.config.ModelManager.readObjectWithConfigSerDe(ModelManager.java:75)
  153. at org.embulk.config.DataSourceImpl.loadConfig(DataSourceImpl.java:220)
  154. at org.embulk.output.jdbc.AbstractJdbcOutputPlugin.transaction(AbstractJdbcOutputPlugin.java:321)
  155. at org.embulk.exec.BulkLoader$4$1$1.transaction(BulkLoader.java:529)
  156. at org.embulk.exec.LocalExecutorPlugin.transaction(LocalExecutorPlugin.java:54)
  157. at org.embulk.exec.BulkLoader$4$1.run(BulkLoader.java:524)
  158. at org.embulk.spi.util.Filters$RecursiveControl.transaction(Filters.java:96)
  159. at org.embulk.spi.util.Filters.transaction(Filters.java:49)
  160. at org.embulk.exec.BulkLoader$4.run(BulkLoader.java:518)
  161. at org.embulk.input.jdbc.AbstractJdbcInputPlugin.transaction(AbstractJdbcInputPlugin.java:163)
  162. at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:513)
  163. at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:33)
  164. at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:374)
  165. at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:370)
  166. at org.embulk.spi.Exec.doWith(Exec.java:25)
  167. at org.embulk.exec.BulkLoader.run(BulkLoader.java:370)
  168. at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:180)
  169. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  170. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  171. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  172. at java.lang.reflect.Method.invoke(Method.java:498)
  173. at org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(JavaMethod.java:452)
  174. at org.jruby.javasupport.JavaMethod.invokeDirect(JavaMethod.java:313)
  175. at org.jruby.java.invokers.InstanceMethodInvoker.call(InstanceMethodInvoker.java:45)
  176. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  177. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  178. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  179. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  180. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:140)
  181. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:126)
  182. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:273)
  183. at org.jruby.runtime.callsite.CachingCallSite.callBlock(CachingCallSite.java:79)
  184. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:83)
  185. at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:414)
  186. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:348)
  187. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  188. at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:86)
  189. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:210)
  190. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:196)
  191. at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:197)
  192. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  193. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  194. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  195. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  196. at org.jruby.ir.interpreter.Interpreter.INTERPRET_ROOT(Interpreter.java:112)
  197. at org.jruby.ir.interpreter.Interpreter.execute(Interpreter.java:99)
  198. at org.jruby.ir.interpreter.Interpreter.execute(Interpreter.java:35)
  199. at org.jruby.ir.IRTranslator.execute(IRTranslator.java:42)
  200. at org.jruby.Ruby.runInterpreter(Ruby.java:833)
  201. at org.jruby.Ruby.loadFile(Ruby.java:2905)
  202. at org.jruby.runtime.load.LibrarySearcher$ResourceLibrary.load(LibrarySearcher.java:235)
  203. at org.jruby.runtime.load.LibrarySearcher$FoundLibrary.load(LibrarySearcher.java:34)
  204. at org.jruby.runtime.load.LoadService.tryLoadingLibraryOrScript(LoadService.java:900)
  205. at org.jruby.runtime.load.LoadService.smartLoadInternal(LoadService.java:541)
  206. at org.jruby.runtime.load.LoadService.requireCommon(LoadService.java:426)
  207. at org.jruby.runtime.load.LoadService.require(LoadService.java:392)
  208. at org.jruby.RubyKernel.requireCommon(RubyKernel.java:944)
  209. at org.jruby.RubyKernel.require19(RubyKernel.java:937)
  210. at org.jruby.RubyKernel$INVOKER$s$1$0$require19.call(RubyKernel$INVOKER$s$1$0$require19.gen)
  211. at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodOneOrNBlock.call(JavaMethod.java:380)
  212. at org.jruby.internal.runtime.methods.AliasMethod.call(AliasMethod.java:61)
  213. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  214. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  215. at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:316)
  216. at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:77)
  217. at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:86)
  218. at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:210)
  219. at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:196)
  220. at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:197)
  221. at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:313)
  222. at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:163)
  223. at home.osa.$_dot_embulk.bin.embulk.embulk.command.embulk_bundle.invokeOther66:require(file:/home/osa/.embulk/bin/embulk!/embulk/command/embulk_bundle.rb)
  224. at home.osa.$_dot_embulk.bin.embulk.embulk.command.embulk_bundle.RUBY$script(file:/home/osa/.embulk/bin/embulk!/embulk/command/embulk_bundle.rb:51)
  225. at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
  226. at org.jruby.ir.Compiler$1.load(Compiler.java:111)
  227. at org.jruby.Ruby.runScript(Ruby.java:817)
  228. at org.jruby.Ruby.runScript(Ruby.java:809)
  229. at org.jruby.Ruby.runNormally(Ruby.java:747)
  230. at org.jruby.Ruby.runFromMain(Ruby.java:569)
  231. at org.jruby.Main.doRunFromMain(Main.java:415)
  232. at org.jruby.Main.internalRun(Main.java:310)
  233. at org.jruby.Main.run(Main.java:239)
  234. at org.jruby.Main.main(Main.java:201)
  235. at org.embulk.cli.Main.main(Main.java:23)
  236. Caused by: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of VALUE_STRING token
  237. at [Source: N/A; line: -1, column: -1]
  238. at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:148)
  239. at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:835)
  240. at com.fasterxml.jackson.databind.DeserializationContext.mappingException(DeserializationContext.java:831)
  241. at com.fasterxml.jackson.databind.deser.std.StringCollectionDeserializer.handleNonArray(StringCollectionDeserializer.java:240)
  242. at com.fasterxml.jackson.databind.deser.std.StringCollectionDeserializer.deserialize(StringCollectionDeserializer.java:171)
  243. at com.fasterxml.jackson.databind.deser.std.StringCollectionDeserializer.deserialize(StringCollectionDeserializer.java:161)
  244. at com.fasterxml.jackson.databind.deser.std.StringCollectionDeserializer.deserialize(StringCollectionDeserializer.java:19)
  245. at com.fasterxml.jackson.datatype.guava.deser.GuavaOptionalDeserializer.deserialize(GuavaOptionalDeserializer.java:98)
  246. at com.fasterxml.jackson.datatype.guava.deser.GuavaOptionalDeserializer.deserialize(GuavaOptionalDeserializer.java:18)
  247. at com.fasterxml.jackson.databind.ObjectMapper._readValue(ObjectMapper.java:3534)
  248. at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:1894)
  249. at org.embulk.config.TaskSerDe$TaskDeserializer.deserialize(TaskSerDe.java:161)
  250. at com.fasterxml.jackson.databind.ObjectMapper._readValue(ObjectMapper.java:3534)
  251. at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:1870)
  252. at org.embulk.config.ModelManager.readObjectWithConfigSerDe(ModelManager.java:72)
  253. ... 83 more
  254.  
  255. Error: org.embulk.config.ConfigException: com.fasterxml.jackson.databind.JsonMappingException: Can not deserialize instance of java.util.ArrayList out of VALUE_STRING token
  256. at [Source: N/A; line: -1, column: -1]
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!