API tools faq
paste
Advertisement
filpano

Postgresql log file 2013-10-23 12:17:43

filpano
Oct 23rd, 2013
71
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.51 KB | None | 0 0
raw download clone embed print report
  1. 2013-10-23 12:17:43 EDT LOG: database system was shut down at 2013-10-23 12:17:41 EDT
  2. 2013-10-23 12:17:43 EDT LOG: database system is ready to accept connections
  3. 2013-10-23 12:17:43 EDT LOG: incomplete startup packet
  4. 2013-10-23 14:03:38 EDT LOG: duration: 27316.111 ms execute S_207: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  5. 2013-10-23 14:03:38 EDT DETAIL: parameters: $1 = '1'
  6. 2013-10-23 14:03:38 EDT LOG: duration: 16667.450 ms execute S_2: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  7. 2013-10-23 14:03:38 EDT DETAIL: parameters: $1 = '1'
  8. 2013-10-23 14:04:05 EDT LOG: duration: 26908.629 ms execute S_6: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  9. 2013-10-23 14:04:05 EDT DETAIL: parameters: $1 = '1'
  10. 2013-10-23 14:04:05 EDT LOG: duration: 26887.003 ms execute S_212: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  11. 2013-10-23 14:04:05 EDT DETAIL: parameters: $1 = '1'
  12. 2013-10-23 14:04:54 EDT LOG: duration: 48679.090 ms execute S_213: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  13. 2013-10-23 14:04:54 EDT DETAIL: parameters: $1 = '1'
  14. 2013-10-23 14:04:54 EDT LOG: duration: 48687.257 ms execute S_7: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  15. 2013-10-23 14:04:54 EDT DETAIL: parameters: $1 = '1'
  16. 2013-10-23 14:05:22 EDT LOG: duration: 27783.482 ms execute S_217: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  17. 2013-10-23 14:05:22 EDT DETAIL: parameters: $1 = '1'
  18. 2013-10-23 14:05:22 EDT LOG: duration: 27752.658 ms execute S_11: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  19. 2013-10-23 14:05:22 EDT DETAIL: parameters: $1 = '1'
  20. 2013-10-23 14:05:49 EDT LOG: duration: 26719.688 ms execute S_12: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  21. 2013-10-23 14:05:49 EDT DETAIL: parameters: $1 = '1'
  22. 2013-10-23 14:05:49 EDT LOG: duration: 26719.833 ms execute S_218: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  23. 2013-10-23 14:05:49 EDT DETAIL: parameters: $1 = '1'
  24. 2013-10-23 14:06:16 EDT LOG: duration: 26840.506 ms execute S_222: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  25. 2013-10-23 14:06:16 EDT DETAIL: parameters: $1 = '1'
  26. 2013-10-23 14:06:16 EDT LOG: duration: 26838.698 ms execute S_20: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  27. 2013-10-23 14:06:16 EDT DETAIL: parameters: $1 = '1'
  28. 2013-10-23 14:06:43 EDT LOG: duration: 26662.599 ms execute S_21: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  29. 2013-10-23 14:06:43 EDT DETAIL: parameters: $1 = '1'
  30. 2013-10-23 14:06:43 EDT LOG: duration: 26676.625 ms execute S_223: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  31. 2013-10-23 14:06:43 EDT DETAIL: parameters: $1 = '1'
  32. 2013-10-23 14:07:09 EDT LOG: duration: 26674.120 ms execute S_231: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  33. 2013-10-23 14:07:09 EDT DETAIL: parameters: $1 = '1'
  34. 2013-10-23 14:07:09 EDT LOG: duration: 26642.655 ms execute S_25: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  35. 2013-10-23 14:07:09 EDT DETAIL: parameters: $1 = '1'
  36. 2013-10-23 14:07:36 EDT LOG: duration: 26680.697 ms execute S_26: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  37. 2013-10-23 14:07:36 EDT DETAIL: parameters: $1 = '1'
  38. 2013-10-23 14:07:36 EDT LOG: duration: 26693.824 ms execute S_232: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  39. 2013-10-23 14:07:36 EDT DETAIL: parameters: $1 = '1'
  40. 2013-10-23 14:08:03 EDT LOG: duration: 26746.836 ms execute S_236: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  41. 2013-10-23 14:08:03 EDT DETAIL: parameters: $1 = '1'
  42. 2013-10-23 14:08:03 EDT LOG: duration: 26680.852 ms execute S_29: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  43. 2013-10-23 14:08:03 EDT DETAIL: parameters: $1 = '1'
  44. 2013-10-23 14:08:04 EDT ERROR: type "blob" does not exist at character 109
  45. 2013-10-23 14:08:04 EDT STATEMENT: create table txn_log_table (localtid varchar(20), servername varchar(150), instancename varchar(150), gtrid blob)
  46. 2013-10-23 14:08:04 EDT LOG: duration: 1259.046 ms execute S_237: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  47. 2013-10-23 14:08:04 EDT DETAIL: parameters: $1 = '1'
  48. 2013-10-23 14:08:31 EDT LOG: duration: 26843.186 ms execute S_35: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  49. 2013-10-23 14:08:31 EDT DETAIL: parameters: $1 = '1'
  50. 2013-10-23 14:08:31 EDT LOG: duration: 26842.861 ms execute S_242: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  51. 2013-10-23 14:08:31 EDT DETAIL: parameters: $1 = '1'
  52. 2013-10-23 14:08:58 EDT LOG: duration: 27004.131 ms execute S_243: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  53. 2013-10-23 14:08:58 EDT DETAIL: parameters: $1 = '1'
  54. 2013-10-23 14:08:58 EDT LOG: duration: 27011.483 ms execute S_36: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  55. 2013-10-23 14:08:58 EDT DETAIL: parameters: $1 = '1'
  56. 2013-10-23 14:46:50 EDT LOG: duration: 26858.381 ms execute S_207: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  57. 2013-10-23 14:46:50 EDT DETAIL: parameters: $1 = '1'
  58. 2013-10-23 14:47:17 EDT LOG: duration: 27055.618 ms execute S_213: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  59. 2013-10-23 14:47:17 EDT DETAIL: parameters: $1 = '1'
  60. 2013-10-23 14:47:44 EDT LOG: duration: 26717.403 ms execute S_218: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  61. 2013-10-23 14:47:44 EDT DETAIL: parameters: $1 = '1'
  62. 2013-10-23 14:47:44 EDT LOG: duration: 19440.446 ms execute S_9: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  63. 2013-10-23 14:47:44 EDT DETAIL: parameters: $1 = '1'
  64. 2013-10-23 14:47:44 EDT LOG: duration: 14123.059 ms execute S_2: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  65. 2013-10-23 14:47:44 EDT DETAIL: parameters: $1 = '1'
  66. 2013-10-23 14:48:11 EDT LOG: duration: 26700.468 ms execute S_12: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  67. 2013-10-23 14:48:11 EDT DETAIL: parameters: $1 = '1'
  68. 2013-10-23 14:48:11 EDT LOG: duration: 26693.302 ms execute S_226: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  69. 2013-10-23 14:48:11 EDT DETAIL: parameters: $1 = '1'
  70. 2013-10-23 14:48:37 EDT LOG: duration: 26635.785 ms execute S_227: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  71. 2013-10-23 14:48:37 EDT DETAIL: parameters: $1 = '1'
  72. 2013-10-23 14:48:38 EDT LOG: duration: 53337.504 ms execute S_5: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  73. 2013-10-23 14:48:38 EDT DETAIL: parameters: $1 = '1'
  74. 2013-10-23 14:49:04 EDT LOG: duration: 26749.476 ms execute S_6: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  75. 2013-10-23 14:49:04 EDT DETAIL: parameters: $1 = '1'
  76. 2013-10-23 14:49:04 EDT LOG: duration: 53408.153 ms execute S_13: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  77. 2013-10-23 14:49:04 EDT DETAIL: parameters: $1 = '1'
  78. 2013-10-23 14:49:04 EDT LOG: duration: 26762.443 ms execute S_228: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  79. 2013-10-23 14:49:04 EDT DETAIL: parameters: $1 = '1'
  80. 2013-10-23 14:49:31 EDT LOG: duration: 26697.790 ms execute S_232: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  81. 2013-10-23 14:49:31 EDT DETAIL: parameters: $1 = '1'
  82. 2013-10-23 14:49:31 EDT LOG: duration: 26695.387 ms execute S_16: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  83. 2013-10-23 14:49:31 EDT DETAIL: parameters: $1 = '1'
  84. 2013-10-23 14:49:58 EDT LOG: duration: 26622.581 ms execute S_17: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  85. 2013-10-23 14:49:58 EDT DETAIL: parameters: $1 = '1'
  86. 2013-10-23 14:49:58 EDT LOG: duration: 53327.350 ms execute S_11: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  87. 2013-10-23 14:49:58 EDT DETAIL: parameters: $1 = '1'
  88. 2013-10-23 14:50:25 EDT LOG: duration: 27234.230 ms execute S_12: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  89. 2013-10-23 14:50:25 EDT DETAIL: parameters: $1 = '1'
  90. 2013-10-23 14:50:25 EDT LOG: duration: 62507.886 ms execute S_2: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  91. 2013-10-23 14:50:25 EDT DETAIL: parameters: $1 = '1'
  92. 2013-10-23 14:50:25 EDT LOG: duration: 53890.118 ms execute S_233: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  93. 2013-10-23 14:50:25 EDT DETAIL: parameters: $1 = '1'
  94. 2013-10-23 14:50:25 EDT LOG: duration: 27262.616 ms execute S_18: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  95. 2013-10-23 14:50:25 EDT DETAIL: parameters: $1 = '1'
  96. 2013-10-23 14:50:52 EDT LOG: duration: 26763.373 ms execute S_237: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  97. 2013-10-23 14:50:52 EDT DETAIL: parameters: $1 = '1'
  98. 2013-10-23 14:50:52 EDT LOG: duration: 26771.085 ms execute S_21: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  99. 2013-10-23 14:50:52 EDT DETAIL: parameters: $1 = '1'
  100. 2013-10-23 14:51:18 EDT LOG: duration: 26661.669 ms execute S_22: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  101. 2013-10-23 14:51:18 EDT DETAIL: parameters: $1 = '1'
  102. 2013-10-23 14:51:18 EDT LOG: duration: 53425.474 ms execute S_15: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  103. 2013-10-23 14:51:18 EDT DETAIL: parameters: $1 = '1'
  104. 2013-10-23 14:51:45 EDT LOG: duration: 26688.019 ms execute S_16: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  105. 2013-10-23 14:51:45 EDT DETAIL: parameters: $1 = '1'
  106. 2013-10-23 14:51:45 EDT LOG: duration: 80089.323 ms execute S_5: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  107. 2013-10-23 14:51:45 EDT DETAIL: parameters: $1 = '1'
  108. 2013-10-23 14:51:46 EDT ERROR: type "blob" does not exist at character 109
  109. 2013-10-23 14:51:46 EDT STATEMENT: create table txn_log_table (localtid varchar(20), servername varchar(150), instancename varchar(150), gtrid blob)
  110. 2013-10-23 14:51:46 EDT LOG: duration: 54462.269 ms execute S_238: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  111. 2013-10-23 14:51:46 EDT DETAIL: parameters: $1 = '1'
  112. 2013-10-23 14:51:46 EDT LOG: duration: 27778.469 ms execute S_23: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  113. 2013-10-23 14:51:46 EDT DETAIL: parameters: $1 = '1'
  114. 2013-10-23 14:51:46 EDT LOG: duration: 1087.260 ms execute S_17: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  115. 2013-10-23 14:51:46 EDT DETAIL: parameters: $1 = '1'
  116. 2013-10-23 14:52:13 EDT LOG: duration: 26731.404 ms execute S_242: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  117. 2013-10-23 14:52:13 EDT DETAIL: parameters: $1 = '1'
  118. 2013-10-23 14:52:13 EDT LOG: duration: 26771.934 ms execute S_18: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  119. 2013-10-23 14:52:13 EDT DETAIL: parameters: $1 = '1'
  120. 2013-10-23 14:52:13 EDT LOG: duration: 26752.645 ms execute S_10: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  121. 2013-10-23 14:52:13 EDT DETAIL: parameters: $1 = '1'
  122. 2013-10-23 14:52:40 EDT LOG: duration: 26737.842 ms execute S_11: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  123. 2013-10-23 14:52:40 EDT DETAIL: parameters: $1 = '1'
  124. 2013-10-23 14:52:40 EDT LOG: duration: 53507.465 ms execute S_30: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  125. 2013-10-23 14:52:40 EDT DETAIL: parameters: $1 = '1'
  126. 2013-10-23 14:53:06 EDT LOG: duration: 26658.645 ms execute S_31: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  127. 2013-10-23 14:53:06 EDT DETAIL: parameters: $1 = '1'
  128. 2013-10-23 14:53:06 EDT LOG: duration: 53446.492 ms execute S_243: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  129. 2013-10-23 14:53:06 EDT DETAIL: parameters: $1 = '1'
  130. 2013-10-23 14:53:06 EDT LOG: duration: 53416.452 ms execute S_24: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  131. 2013-10-23 14:53:06 EDT DETAIL: parameters: $1 = '1'
  132. 2013-10-23 14:53:33 EDT LOG: duration: 26614.555 ms execute S_25: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  133. 2013-10-23 14:53:33 EDT DETAIL: parameters: $1 = '1'
  134. 2013-10-23 14:53:33 EDT LOG: duration: 53299.702 ms execute S_12: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  135. 2013-10-23 14:53:33 EDT DETAIL: parameters: $1 = '1'
  136. 2013-10-23 14:53:33 EDT LOG: duration: 26637.594 ms execute S_32: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  137. 2013-10-23 14:53:33 EDT DETAIL: parameters: $1 = '1'
  138. 2013-10-23 14:53:33 EDT LOG: duration: 26639.499 ms execute S_244: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  139. 2013-10-23 14:53:33 EDT DETAIL: parameters: $1 = '1'
  140. 2013-10-23 14:54:00 EDT LOG: duration: 26676.356 ms execute S_29: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  141. 2013-10-23 14:54:00 EDT DETAIL: parameters: $1 = '1'
  142. 2013-10-23 14:54:00 EDT LOG: duration: 26687.105 ms execute S_247: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  143. 2013-10-23 14:54:00 EDT DETAIL: parameters: $1 = '1'
  144. 2013-10-23 14:54:27 EDT LOG: duration: 26683.175 ms execute S_248: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  145. 2013-10-23 14:54:27 EDT DETAIL: parameters: $1 = '1'
  146. 2013-10-23 14:54:27 EDT LOG: duration: 53364.110 ms execute S_35: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  147. 2013-10-23 14:54:27 EDT DETAIL: parameters: $1 = '1'
  148. 2013-10-23 14:54:53 EDT LOG: duration: 26595.410 ms execute S_36: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  149. 2013-10-23 14:54:53 EDT DETAIL: parameters: $1 = '1'
  150. 2013-10-23 14:54:53 EDT LOG: duration: 53286.669 ms execute S_30: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  151. 2013-10-23 14:54:53 EDT DETAIL: parameters: $1 = '1'
  152. 2013-10-23 14:54:53 EDT LOG: duration: 26594.729 ms execute S_249: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  153. 2013-10-23 14:54:53 EDT DETAIL: parameters: $1 = '1'
  154. 2013-10-23 14:55:20 EDT LOG: duration: 26651.563 ms execute S_38: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  155. 2013-10-23 14:55:20 EDT DETAIL: parameters: $1 = '1'
  156. 2013-10-23 14:55:20 EDT LOG: duration: 26633.015 ms execute S_254: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  157. 2013-10-23 14:55:20 EDT DETAIL: parameters: $1 = '1'
  158. 2013-10-23 14:55:47 EDT LOG: duration: 26643.983 ms execute S_255: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  159. 2013-10-23 14:55:47 EDT DETAIL: parameters: $1 = '1'
  160. 2013-10-23 14:55:47 EDT LOG: duration: 53280.440 ms execute S_43: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  161. 2013-10-23 14:55:47 EDT DETAIL: parameters: $1 = '1'
  162. 2013-10-23 14:56:13 EDT LOG: duration: 26601.230 ms execute S_44: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  163. 2013-10-23 14:56:13 EDT DETAIL: parameters: $1 = '1'
  164. 2013-10-23 14:56:13 EDT LOG: duration: 53258.528 ms execute S_39: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  165. 2013-10-23 14:56:13 EDT DETAIL: parameters: $1 = '1'
  166. 2013-10-23 14:56:13 EDT LOG: duration: 26611.283 ms execute S_256: select t0.c_id, t0.c_contact, t0.c_credit_limit, t0.c_state, t0.c_zip, t0.c_phone, t0.c_credit, t0.c_since, t0.c_ytd_payment, t0.c_street1, t0.c_balance, t0.c_first, t0.c_last, t0.c_street2, t0.c_country, t0.c_city from c_customer t0 where t0.c_id = $1 for update
  167. 2013-10-23 14:56:13 EDT DETAIL: parameters: $1 = '1'
  168. 2013-10-23 14:56:40 EDT LOG: duration: 26658.613 ms execute S_260: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  169. 2013-10-23 14:56:40 EDT DETAIL: parameters: $1 = '1'
  170. 2013-10-23 14:57:06 EDT LOG: duration: 26567.536 ms execute S_267: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  171. 2013-10-23 14:57:06 EDT DETAIL: parameters: $1 = '1'
  172. 2013-10-23 15:34:22 EDT LOG: duration: 26717.694 ms execute S_207: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  173. 2013-10-23 15:34:22 EDT DETAIL: parameters: $1 = '1'
  174. 2013-10-23 15:34:49 EDT LOG: duration: 26762.498 ms execute S_213: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  175. 2013-10-23 15:34:49 EDT DETAIL: parameters: $1 = '1'
  176. 2013-10-23 15:35:16 EDT LOG: duration: 26600.157 ms execute S_218: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  177. 2013-10-23 15:35:16 EDT DETAIL: parameters: $1 = '1'
  178. 2013-10-23 15:35:43 EDT LOG: duration: 26611.423 ms execute S_227: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  179. 2013-10-23 15:35:43 EDT DETAIL: parameters: $1 = '1'
  180. 2013-10-23 15:36:09 EDT LOG: duration: 26615.864 ms execute S_232: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  181. 2013-10-23 15:36:09 EDT DETAIL: parameters: $1 = '1'
  182. 2013-10-23 15:36:10 EDT ERROR: type "blob" does not exist at character 109
  183. 2013-10-23 15:36:10 EDT STATEMENT: create table txn_log_table (localtid varchar(20), servername varchar(150), instancename varchar(150), gtrid blob)
  184. 2013-10-23 15:36:37 EDT LOG: duration: 26634.607 ms execute S_240: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventory t0 where t0.ci_customerid = $1 for update
  185. 2013-10-23 15:36:37 EDT DETAIL: parameters: $1 = '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!