API tools faq
paste
Advertisement
Guest User

PGJDBC Error Log

a guest
Oct 14th, 2016
148
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.16 KB | None | 0 0
raw download clone embed print report
  1. ==========================================================================================================================================
  2. POSTGRES 9.5 logs
  3. ==========================================================================================================================================
  4. DriverManager.getConnection("jdbc:postgresql://localhost:9432/app5?charSet=UTF-8&user=xxxx&password=xxx&logLevel=2&loglevel=2")
  5. trying org.postgresql.Driver
  6. 13:56:08.389 (1) PostgreSQL 9.4 JDBC4.1 (build 1201)
  7. 13:56:08.398 (1) Trying to establish a protocol version 3 connection to localhost:9432
  8. 13:56:08.427 (1) Receive Buffer Size is 8192
  9. 13:56:08.427 (1) Send Buffer Size is 8192
  10. 13:56:08.429 (1) FE=> StartupPacket(user=, database=app, client_encoding=UTF8, DateStyle=ISO, TimeZone=Europe/Berlin, extra_float_digits=2)
  11. 13:56:08.534 (1) <=BE AuthenticationReqMD5(salt=f9d204ba)
  12. 13:56:08.541 (1) FE=> Password(md5digest=md50d3fabec1f2d6d281c23820d1fa25c8e)
  13. 13:56:08.546 (1) <=BE AuthenticationOk
  14. 13:56:08.556 (1) <=BE NoticeResponse(DEBUG: CommitTransaction)
  15. SQLWarning:
  16. 13:56:08.556 (1) <=BE NoticeResponse(DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: )
  17. SQLWarning:
  18. 13:56:08.556 (1) <=BE ParameterStatus(application_name = )
  19. 13:56:08.556 (1) <=BE ParameterStatus(client_encoding = UTF8)
  20. 13:56:08.556 (1) <=BE ParameterStatus(DateStyle = ISO, DMY)
  21. 13:56:08.556 (1) <=BE ParameterStatus(integer_datetimes = on)
  22. 13:56:08.556 (1) <=BE ParameterStatus(IntervalStyle = postgres)
  23. 13:56:08.556 (1) <=BE ParameterStatus(is_superuser = on)
  24. 13:56:08.556 (1) <=BE ParameterStatus(server_encoding = UTF8)
  25. 13:56:08.556 (1) <=BE ParameterStatus(server_version = 9.5.0)
  26. 13:56:08.557 (1) <=BE ParameterStatus(session_authorization = xxxx)
  27. 13:56:08.557 (1) <=BE ParameterStatus(standard_conforming_strings = on)
  28. 13:56:08.557 (1) <=BE ParameterStatus(TimeZone = Europe/Berlin)
  29. 13:56:08.557 (1) <=BE BackendKeyData(pid=14144,ckey=2078122563)
  30. 13:56:08.557 (1) <=BE ReadyForQuery(I)
  31. 13:56:08.560 (1) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@36aa7bc2, maxRows=0, fetchSize=0, flags=23
  32. 13:56:08.561 (1) FE=> Parse(stmt=null,query="SET extra_float_digits = 3",oids={})
  33. 13:56:08.562 (1) FE=> Bind(stmt=null,portal=null)
  34. 13:56:08.562 (1) FE=> Execute(portal=null,limit=1)
  35. 13:56:08.562 (1) FE=> Sync
  36. 13:56:08.562 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: SET extra_float_digits = 3)
  37. SQLWarning:
  38. 13:56:08.562 (1) <=BE NoticeResponse(DEBUG: StartTransactionCommand)
  39. SQLWarning:
  40. 13:56:08.562 (1) <=BE NoticeResponse(DEBUG: StartTransaction)
  41. SQLWarning:
  42. 13:56:08.562 (1) <=BE NoticeResponse(DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: )
  43. SQLWarning:
  44. 13:56:08.563 (1) <=BE ParseComplete [null]
  45. 13:56:08.563 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  46. SQLWarning:
  47. 13:56:08.563 (1) <=BE BindComplete [null]
  48. 13:56:08.563 (1) <=BE NoticeResponse(DEBUG: ProcessUtility)
  49. SQLWarning:
  50. 13:56:08.563 (1) <=BE CommandStatus(SET)
  51. 13:56:08.563 (1) <=BE NoticeResponse(DEBUG: CommitTransactionCommand)
  52. SQLWarning:
  53. 13:56:08.564 (1) <=BE NoticeResponse(DEBUG: CommitTransaction)
  54. SQLWarning:
  55. 13:56:08.564 (1) <=BE NoticeResponse(DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: )
  56. SQLWarning:
  57. 13:56:08.564 (1) <=BE ReadyForQuery(I)
  58. 13:56:08.565 (1) compatible = 90400
  59. 13:56:08.565 (1) loglevel = 2
  60. 13:56:08.565 (1) prepare threshold = 5
  61. 13:56:08.567 (1) types using binary send = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
  62. 13:56:08.568 (1) types using binary receive = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,DATE,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
  63. 13:56:08.568 (1) integer date/time = true
  64. getConnection returning org.postgresql.Driver
  65. 13:56:08.587 (1) batch execute 10 queries, handler=org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler@2a33fae0, maxRows=0, fetchSize=0, flags=5
  66. 13:56:08.587 (1) FE=> Parse(stmt=null,query="BEGIN",oids={})
  67. 13:56:08.587 (1) FE=> Bind(stmt=null,portal=null)
  68. 13:56:08.587 (1) FE=> Execute(portal=null,limit=0)
  69. 13:56:08.588 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('0')",oids={})
  70. 13:56:08.588 (1) FE=> Bind(stmt=null,portal=null)
  71. 13:56:08.588 (1) FE=> Describe(portal=null)
  72. 13:56:08.588 (1) FE=> Execute(portal=null,limit=1)
  73. 13:56:08.588 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('1')",oids={})
  74. 13:56:08.588 (1) FE=> Bind(stmt=null,portal=null)
  75. 13:56:08.588 (1) FE=> Describe(portal=null)
  76. 13:56:08.588 (1) FE=> Execute(portal=null,limit=1)
  77. 13:56:08.588 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('2')",oids={})
  78. 13:56:08.588 (1) FE=> Bind(stmt=null,portal=null)
  79. 13:56:08.588 (1) FE=> Describe(portal=null)
  80. 13:56:08.588 (1) FE=> Execute(portal=null,limit=1)
  81. 13:56:08.589 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('3')",oids={})
  82. 13:56:08.589 (1) FE=> Bind(stmt=null,portal=null)
  83. 13:56:08.589 (1) FE=> Describe(portal=null)
  84. 13:56:08.589 (1) FE=> Execute(portal=null,limit=1)
  85. 13:56:08.589 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('4')",oids={})
  86. 13:56:08.589 (1) FE=> Bind(stmt=null,portal=null)
  87. 13:56:08.589 (1) FE=> Describe(portal=null)
  88. 13:56:08.589 (1) FE=> Execute(portal=null,limit=1)
  89. 13:56:08.589 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('5')",oids={})
  90. 13:56:08.589 (1) FE=> Bind(stmt=null,portal=null)
  91. 13:56:08.589 (1) FE=> Describe(portal=null)
  92. 13:56:08.589 (1) FE=> Execute(portal=null,limit=1)
  93. 13:56:08.589 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('6')",oids={})
  94. 13:56:08.589 (1) FE=> Bind(stmt=null,portal=null)
  95. 13:56:08.589 (1) FE=> Describe(portal=null)
  96. 13:56:08.589 (1) FE=> Execute(portal=null,limit=1)
  97. 13:56:08.589 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('7')",oids={})
  98. 13:56:08.589 (1) FE=> Bind(stmt=null,portal=null)
  99. 13:56:08.590 (1) FE=> Describe(portal=null)
  100. 13:56:08.590 (1) FE=> Execute(portal=null,limit=1)
  101. 13:56:08.590 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('8')",oids={})
  102. 13:56:08.590 (1) FE=> Bind(stmt=null,portal=null)
  103. 13:56:08.590 (1) FE=> Describe(portal=null)
  104. 13:56:08.590 (1) FE=> Execute(portal=null,limit=1)
  105. 13:56:08.590 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('9')",oids={})
  106. 13:56:08.590 (1) FE=> Bind(stmt=null,portal=null)
  107. 13:56:08.590 (1) FE=> Describe(portal=null)
  108. 13:56:08.590 (1) FE=> Execute(portal=null,limit=1)
  109. 13:56:08.590 (1) FE=> Sync
  110. 13:56:08.591 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: BEGIN)
  111. SQLWarning:
  112. 13:56:08.591 (1) <=BE NoticeResponse(DEBUG: StartTransactionCommand)
  113. SQLWarning:
  114. 13:56:08.591 (1) <=BE NoticeResponse(DEBUG: StartTransaction)
  115. SQLWarning:
  116. 13:56:08.591 (1) <=BE NoticeResponse(DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: )
  117. SQLWarning:
  118. 13:56:08.593 (1) <=BE ParseComplete [null]
  119. 13:56:08.593 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  120. SQLWarning:
  121. 13:56:08.594 (1) <=BE BindComplete [null]
  122. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: ProcessUtility)
  123. SQLWarning:
  124. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: CommitTransactionCommand)
  125. SQLWarning:
  126. 13:56:08.594 (1) <=BE CommandStatus(BEGIN)
  127. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('0'))
  128. SQLWarning:
  129. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: StartTransactionCommand)
  130. SQLWarning:
  131. 13:56:08.594 (1) <=BE ParseComplete [null]
  132. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  133. SQLWarning:
  134. 13:56:08.594 (1) <=BE BindComplete [null]
  135. 13:56:08.594 (1) <=BE NoData
  136. 13:56:08.594 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  137. SQLWarning:
  138. 13:56:08.596 (1) <=BE NoticeResponse(DEBUG: mapped win32 error code 2 to 2)
  139. SQLWarning:
  140. 13:56:08.600 (1) <=BE CommandStatus(INSERT 0 1)
  141. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('1'))
  142. SQLWarning:
  143. 13:56:08.601 (1) <=BE ParseComplete [null]
  144. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  145. SQLWarning:
  146. 13:56:08.601 (1) <=BE BindComplete [null]
  147. 13:56:08.601 (1) <=BE NoData
  148. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  149. SQLWarning:
  150. 13:56:08.601 (1) <=BE CommandStatus(INSERT 0 1)
  151. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('2'))
  152. SQLWarning:
  153. 13:56:08.601 (1) <=BE ParseComplete [null]
  154. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  155. SQLWarning:
  156. 13:56:08.601 (1) <=BE BindComplete [null]
  157. 13:56:08.601 (1) <=BE NoData
  158. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  159. SQLWarning:
  160. 13:56:08.601 (1) <=BE CommandStatus(INSERT 0 1)
  161. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('3'))
  162. SQLWarning:
  163. 13:56:08.601 (1) <=BE ParseComplete [null]
  164. 13:56:08.601 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  165. SQLWarning:
  166. 13:56:08.602 (1) <=BE BindComplete [null]
  167. 13:56:08.602 (1) <=BE NoData
  168. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  169. SQLWarning:
  170. 13:56:08.602 (1) <=BE CommandStatus(INSERT 0 1)
  171. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('4'))
  172. SQLWarning:
  173. 13:56:08.602 (1) <=BE ParseComplete [null]
  174. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  175. SQLWarning:
  176. 13:56:08.602 (1) <=BE BindComplete [null]
  177. 13:56:08.602 (1) <=BE NoData
  178. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  179. SQLWarning:
  180. 13:56:08.602 (1) <=BE CommandStatus(INSERT 0 1)
  181. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: Parsen <unnamed>: INSERT INTO TESTTABLE VALUES('5'))
  182. SQLWarning:
  183. 13:56:08.602 (1) <=BE ParseComplete [null]
  184. 13:56:08.602 (1) <=BE NoticeResponse(DEBUG: Binden <unnamed> an <unnamed>)
  185. SQLWarning:
  186. 13:56:08.602 (1) <=BE BindComplete [null]
  187. 13:56:08.603 (1) <=BE NoData
  188. 13:56:08.603 (1) <=BE NoticeResponse(DEBUG: ProcessQuery)
  189. SQLWarning:
  190. 13:56:08.608 (1) <=BE ErrorMessage(FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint „testtable_pkey“
  191. Detail: Schlüssel „(id)=(5)“ existiert bereits.)
  192. org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint „testtable_pkey“
  193. Detail: Schlüssel „(id)=(5)“ existiert bereits.
  194. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2270)
  195. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1998)
  196. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421)
  197. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
  198.  
  199.  
  200.  
  201. ==========================================================================================================================================
  202. POSTGRES 9.6 logs
  203. ==========================================================================================================================================
  204.  
  205. DriverManager.getConnection("jdbc:postgresql://localhost:10433/app?charSet=UTF-8&user=xxxx&password=xxxx&logLevel=2&loglevel=2")
  206. trying org.postgresql.Driver
  207. 13:52:38.914 (1) PostgreSQL 9.4.1211
  208. 13:52:38.920 (1) Trying to establish a protocol version 3 connection to localhost:10433
  209. 13:52:38.934 (1) Receive Buffer Size is 8192
  210. 13:52:38.934 (1) Send Buffer Size is 8192
  211. 13:52:38.936 (1) FE=> StartupPacket(user=xxxx, database=app, client_encoding=UTF8, DateStyle=ISO, TimeZone=Europe/Berlin, extra_float_digits=2)
  212. 13:52:38.978 (1) <=BE AuthenticationReqMD5(salt=1b61dbea)
  213. 13:52:38.985 (1) FE=> Password(md5digest=md557d9e4eaa7fd9cedc1141ad09145b449)
  214. 13:52:38.986 (1) <=BE AuthenticationOk
  215. 13:52:39.003 (1) <=BE ParameterStatus(application_name = )
  216. 13:52:39.003 (1) <=BE ParameterStatus(client_encoding = UTF8)
  217. 13:52:39.004 (1) <=BE ParameterStatus(DateStyle = ISO, DMY)
  218. 13:52:39.004 (1) <=BE ParameterStatus(integer_datetimes = on)
  219. 13:52:39.004 (1) <=BE ParameterStatus(IntervalStyle = postgres)
  220. 13:52:39.004 (1) <=BE ParameterStatus(is_superuser = on)
  221. 13:52:39.004 (1) <=BE ParameterStatus(server_encoding = UTF8)
  222. 13:52:39.004 (1) <=BE ParameterStatus(server_version = 9.6.0)
  223. 13:52:39.004 (1) <=BE ParameterStatus(session_authorization = xxxx)
  224. 13:52:39.004 (1) <=BE ParameterStatus(standard_conforming_strings = on)
  225. 13:52:39.004 (1) <=BE ParameterStatus(TimeZone = Europe/Berlin)
  226. 13:52:39.004 (1) <=BE BackendKeyData(pid=9324,ckey=2044033931)
  227. 13:52:39.004 (1) <=BE ReadyForQuery(I)
  228. 13:52:39.006 (1) simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@4aa8f0b4, maxRows=0, fetchSize=0, flags=1047
  229. 13:52:39.007 (1) FE=> Parse(stmt=null,query="SET extra_float_digits = 3",oids={})
  230. 13:52:39.007 (1) FE=> Bind(stmt=null,portal=null)
  231. 13:52:39.007 (1) FE=> Execute(portal=null,limit=1)
  232. 13:52:39.007 (1) FE=> Sync
  233. 13:52:39.009 (1) <=BE ParseComplete [null]
  234. 13:52:39.009 (1) <=BE BindComplete [unnamed]
  235. 13:52:39.009 (1) <=BE CommandStatus(SET)
  236. 13:52:39.010 (1) <=BE ReadyForQuery(I)
  237. 13:52:39.010 (1) compatible = 90400
  238. 13:52:39.010 (1) loglevel = 2
  239. 13:52:39.010 (1) prepare threshold = 5
  240. 13:52:39.012 (1) types using binary send = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
  241. 13:52:39.013 (1) types using binary receive = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,DATE,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
  242. 13:52:39.013 (1) integer date/time = true
  243. getConnection returning org.postgresql.Driver
  244. 13:52:39.023 (1) batch execute 10 queries, handler=org.postgresql.jdbc.BatchResultHandler@6d86b085, maxRows=0, fetchSize=0, flags=5
  245. 13:52:39.023 (1) FE=> Parse(stmt=null,query="BEGIN",oids={})
  246. 13:52:39.023 (1) FE=> Bind(stmt=null,portal=null)
  247. 13:52:39.024 (1) FE=> Execute(portal=null,limit=0)
  248. 13:52:39.024 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('0')",oids={})
  249. 13:52:39.024 (1) FE=> Bind(stmt=null,portal=null)
  250. 13:52:39.024 (1) FE=> Describe(portal=null)
  251. 13:52:39.024 (1) FE=> Execute(portal=null,limit=1)
  252. 13:52:39.024 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('1')",oids={})
  253. 13:52:39.025 (1) FE=> Bind(stmt=null,portal=null)
  254. 13:52:39.025 (1) FE=> Describe(portal=null)
  255. 13:52:39.025 (1) FE=> Execute(portal=null,limit=1)
  256. 13:52:39.025 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('2')",oids={})
  257. 13:52:39.025 (1) FE=> Bind(stmt=null,portal=null)
  258. 13:52:39.025 (1) FE=> Describe(portal=null)
  259. 13:52:39.025 (1) FE=> Execute(portal=null,limit=1)
  260. 13:52:39.025 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('3')",oids={})
  261. 13:52:39.025 (1) FE=> Bind(stmt=null,portal=null)
  262. 13:52:39.025 (1) FE=> Describe(portal=null)
  263. 13:52:39.025 (1) FE=> Execute(portal=null,limit=1)
  264. 13:52:39.025 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('4')",oids={})
  265. 13:52:39.025 (1) FE=> Bind(stmt=null,portal=null)
  266. 13:52:39.025 (1) FE=> Describe(portal=null)
  267. 13:52:39.025 (1) FE=> Execute(portal=null,limit=1)
  268. 13:52:39.025 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('5')",oids={})
  269. 13:52:39.025 (1) FE=> Bind(stmt=null,portal=null)
  270. 13:52:39.025 (1) FE=> Describe(portal=null)
  271. 13:52:39.025 (1) FE=> Execute(portal=null,limit=1)
  272. 13:52:39.026 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('6')",oids={})
  273. 13:52:39.026 (1) FE=> Bind(stmt=null,portal=null)
  274. 13:52:39.026 (1) FE=> Describe(portal=null)
  275. 13:52:39.026 (1) FE=> Execute(portal=null,limit=1)
  276. 13:52:39.026 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('7')",oids={})
  277. 13:52:39.026 (1) FE=> Bind(stmt=null,portal=null)
  278. 13:52:39.026 (1) FE=> Describe(portal=null)
  279. 13:52:39.026 (1) FE=> Execute(portal=null,limit=1)
  280. 13:52:39.026 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('8')",oids={})
  281. 13:52:39.026 (1) FE=> Bind(stmt=null,portal=null)
  282. 13:52:39.026 (1) FE=> Describe(portal=null)
  283. 13:52:39.026 (1) FE=> Execute(portal=null,limit=1)
  284. 13:52:39.026 (1) FE=> Parse(stmt=null,query="INSERT INTO TESTTABLE VALUES('9')",oids={})
  285. 13:52:39.026 (1) FE=> Bind(stmt=null,portal=null)
  286. 13:52:39.026 (1) FE=> Describe(portal=null)
  287. 13:52:39.026 (1) FE=> Execute(portal=null,limit=1)
  288. 13:52:39.026 (1) FE=> Sync
  289. 13:52:39.030 (1) <=BE ParseComplete [null]
  290. 13:52:39.030 (1) <=BE BindComplete [unnamed]
  291. 13:52:39.030 (1) <=BE CommandStatus(BEGIN)
  292. 13:52:39.030 (1) <=BE ParseComplete [null]
  293. 13:52:39.030 (1) <=BE BindComplete [unnamed]
  294. 13:52:39.030 (1) <=BE NoData
  295. 13:52:39.030 (1) <=BE CommandStatus(INSERT 0 1)
  296. 13:52:39.030 (1) <=BE ParseComplete [null]
  297. 13:52:39.030 (1) <=BE BindComplete [unnamed]
  298. 13:52:39.030 (1) <=BE NoData
  299. 13:52:39.030 (1) <=BE CommandStatus(INSERT 0 1)
  300. 13:52:39.031 (1) <=BE ParseComplete [null]
  301. 13:52:39.031 (1) <=BE BindComplete [unnamed]
  302. 13:52:39.031 (1) <=BE NoData
  303. 13:52:39.031 (1) <=BE CommandStatus(INSERT 0 1)
  304. 13:52:39.031 (1) <=BE ParseComplete [null]
  305. 13:52:39.031 (1) <=BE BindComplete [unnamed]
  306. 13:52:39.031 (1) <=BE NoData
  307. 13:52:39.031 (1) <=BE CommandStatus(INSERT 0 1)
  308. 13:52:39.031 (1) <=BE ParseComplete [null]
  309. 13:52:39.031 (1) <=BE BindComplete [unnamed]
  310. 13:52:39.031 (1) <=BE NoData
  311. 13:52:39.031 (1) <=BE CommandStatus(INSERT 0 1)
  312. 13:52:39.031 (1) <=BE ParseComplete [null]
  313. 13:52:39.031 (1) <=BE BindComplete [unnamed]
  314. 13:52:39.031 (1) <=BE NoData
  315. 13:52:39.034 (1) <=BE ErrorMessage(FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »testtable_pkey«
  316. Detail: Schlüssel »(id)=(5)« existiert bereits.)
  317. org.postgresql.util.PSQLException: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »testtable_pkey«
  318. Detail: Schlüssel »(id)=(5)« existiert bereits.
  319. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2458)
  320. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2158)
  321. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:463)
  322. at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:794)
  323. at com.app.generator.TestDataGenerator.generateRecipients(TestDataGenerator.java:31)
  324. at com.app.generator.TestReturnCodes.main(TestReturnCodes.java:66)
  325. SQLException: SQLState(23505)
  326. SQLState(23505) vendor code(0)
  327. java.sql.BatchUpdateException: Batch entry 5 INSERT INTO TESTTABLE VALUES('5') was aborted: FEHLER: doppelter Schlüsselwert verletzt Unique-Constraint »testtable_pkey«
  328. Detail: Schlüssel »(id)=(5)« existiert bereits. Call getNextException to see other errors in the batch.
  329. at org.postgresql.jdbc.BatchResultHandler.handleError(BatchResultHandler.java:151)
  330. at org.postgresql.core.ResultHandlerDelegate.handleError(ResultHandlerDelegate.java:45)
  331. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2159)
  332. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:463)
  333. at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:794)
  334. at com.inxmail.generator.TestDataGenerator.generateRecipients(TestDataGenerator.java:31)
  335. at com.inxmail.generator.TestReturnCodes.main(TestReturnCodes.java:66)
  336. 13:52:39.044 (1) <=BE ReadyForQuery(E)
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!