API tools faq
paste
Advertisement
rherrick

Full psql log of cachingtest

rherrick
Sep 3rd, 2013
99
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Logtalk 10.75 KB | None | 0 0
raw download clone embed print report
  1. 2013-09-03 17:00:02 CDT ERROR:  syntax error at or near "if" at character 24
  2. 2013-09-03 17:00:02 CDT STATEMENT:  drop table cache_thing if exists
  3. 2013-09-03 17:00:02 CDT ERROR:  syntax error at or near "if" at character 32
  4. 2013-09-03 17:00:02 CDT STATEMENT:  drop table hibernate_sequences if exists
  5. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: create table cache_thing (id bigint not null, attr1 varchar(255), attr2 varchar(255), attr3 varchar(255), created timestamp, timestamp timestamp, primary key (id))
  6. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: create table cache_thing (id bigint not null, attr1 varchar(255), attr2 varchar(255), attr3 varchar(255), created timestamp, timestamp timestamp, primary key (id))
  7. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: create table cache_thing (id bigint not null, attr1 varchar(255), attr2 varchar(255), attr3 varchar(255), created timestamp, timestamp timestamp, primary key (id))
  8. 2013-09-03 17:00:02 CDT LOG:  duration: 7.000 ms
  9. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  parse <unnamed>: create table hibernate_sequences ( sequence_name varchar(255),  sequence_next_hi_value integer )
  10. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: create table hibernate_sequences ( sequence_name varchar(255),  sequence_next_hi_value integer )
  11. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: create table hibernate_sequences ( sequence_name varchar(255),  sequence_next_hi_value integer )
  12. 2013-09-03 17:00:02 CDT ERROR:  relation "hibernate_sequences" already exists
  13. 2013-09-03 17:00:02 CDT STATEMENT:  create table hibernate_sequences ( sequence_name varchar(255),  sequence_next_hi_value integer )
  14. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  15. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  16. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  17. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  18. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  parse <unnamed>: select sequence_next_hi_value from hibernate_sequences where sequence_name = 'cache_thing' for update
  19. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: select sequence_next_hi_value from hibernate_sequences where sequence_name = 'cache_thing' for update
  20. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: select sequence_next_hi_value from hibernate_sequences where sequence_name = 'cache_thing' for update
  21. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms
  22. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: insert into hibernate_sequences(sequence_name, sequence_next_hi_value) values('cache_thing', $1)
  23. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: insert into hibernate_sequences(sequence_name, sequence_next_hi_value) values('cache_thing', $1)
  24. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = '0'
  25. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into hibernate_sequences(sequence_name, sequence_next_hi_value) values('cache_thing', $1)
  26. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = '0'
  27. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  28. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  parse <unnamed>: update hibernate_sequences set sequence_next_hi_value = $1 where sequence_next_hi_value = $2 and sequence_name = 'cache_thing'
  29. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: update hibernate_sequences set sequence_next_hi_value = $1 where sequence_next_hi_value = $2 and sequence_name = 'cache_thing'
  30. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = '1', $2 = '0'
  31. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: update hibernate_sequences set sequence_next_hi_value = $1 where sequence_next_hi_value = $2 and sequence_name = 'cache_thing'
  32. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = '1', $2 = '0'
  33. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  34. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  35. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  36. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  37. 2013-09-03 17:00:02 CDT LOG:  duration: 2.000 ms
  38. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  39. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  40. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  41. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms
  42. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  43. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  44. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newOneAttr1', $2 = 'newOneAttr2', $3 = 'newOneAttr3', $4 = '2013-09-03 17:00:02.409', $5 = '2013-09-03 17:00:02.409', $6 = '1'
  45. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  46. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newOneAttr1', $2 = 'newOneAttr2', $3 = 'newOneAttr3', $4 = '2013-09-03 17:00:02.409', $5 = '2013-09-03 17:00:02.409', $6 = '1'
  47. 2013-09-03 17:00:02 CDT LOG:  duration: 2.000 ms
  48. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  49. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  50. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  51. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  52. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  53. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  54. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  55. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  56. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  57. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  58. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newTwoAttr1', $2 = 'newTwoAttr2', $3 = 'newTwoAttr3', $4 = '2013-09-03 17:00:02.505', $5 = '2013-09-03 17:00:02.505', $6 = '2'
  59. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  60. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newTwoAttr1', $2 = 'newTwoAttr2', $3 = 'newTwoAttr3', $4 = '2013-09-03 17:00:02.505', $5 = '2013-09-03 17:00:02.505', $6 = '2'
  61. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms
  62. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  63. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  64. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  65. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  66. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  67. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  68. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  69. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  70. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  parse <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  71. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  72. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newThreeAttr1', $2 = 'newThreeAttr2', $3 = 'newThreeAttr3', $4 = '2013-09-03 17:00:02.533', $5 = '2013-09-03 17:00:02.533', $6 = '3'
  73. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  74. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newThreeAttr1', $2 = 'newThreeAttr2', $3 = 'newThreeAttr3', $4 = '2013-09-03 17:00:02.533', $5 = '2013-09-03 17:00:02.533', $6 = '3'
  75. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  76. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  77. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  78. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  79. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms
  80. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  81. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  82. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  83. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  84. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  85. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  bind <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  86. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newFourAttr1', $2 = 'newFourAttr2', $3 = 'newFourAttr3', $4 = '2013-09-03 17:00:02.558', $5 = '2013-09-03 17:00:02.558', $6 = '4'
  87. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  88. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newFourAttr1', $2 = 'newFourAttr2', $3 = 'newFourAttr3', $4 = '2013-09-03 17:00:02.558', $5 = '2013-09-03 17:00:02.558', $6 = '4'
  89. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  90. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  91. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  92. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  93. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  94. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_1: BEGIN
  95. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_1: BEGIN
  96. 2013-09-03 17:00:02 CDT LOG:  execute S_1: BEGIN
  97. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  98. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  99. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms  bind <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  100. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newFiveAttr1', $2 = 'newFiveAttr2', $3 = 'newFiveAttr3', $4 = '2013-09-03 17:00:02.582', $5 = '2013-09-03 17:00:02.582', $6 = '5'
  101. 2013-09-03 17:00:02 CDT LOG:  execute <unnamed>: insert into cache_thing (attr1, attr2, attr3, created, timestamp, id) values ($1, $2, $3, $4, $5, $6)
  102. 2013-09-03 17:00:02 CDT DETAIL:  parameters: $1 = 'newFiveAttr1', $2 = 'newFiveAttr2', $3 = 'newFiveAttr3', $4 = '2013-09-03 17:00:02.582', $5 = '2013-09-03 17:00:02.582', $6 = '5'
  103. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms
  104. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  parse S_2: COMMIT
  105. 2013-09-03 17:00:02 CDT LOG:  duration: 0.000 ms  bind S_2: COMMIT
  106. 2013-09-03 17:00:02 CDT LOG:  execute S_2: COMMIT
  107. 2013-09-03 17:00:02 CDT LOG:  duration: 1.000 ms
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!