Advertisement
filpano

postgresql log file 2013-10-25

Oct 25th, 2013
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.14 KB | None | 0 0
  1. root@dbserver:~# more /var/lib/postgresql/9.2/main/pg_log/postgresql-2013-10-25_121410.log
  2. 2013-10-25 12:14:10 EDT LOG: database system was shut down at 2013-10-25 12:06:16 EDT
  3. 2013-10-25 12:14:11 EDT LOG: database system is ready to accept connections
  4. 2013-10-25 12:14:11 EDT LOG: incomplete startup packet
  5. 2013-10-25 12:28:01 EDT LOG: duration: 27156.359 ms execute S_207: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinvento
  6. ry t0 where t0.ci_customerid = $1 for update
  7. 2013-10-25 12:28:01 EDT DETAIL: parameters: $1 = '1'
  8. 2013-10-25 12:28:08 EDT LOG: duration: 6332.763 ms execute S_213: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventor
  9. y t0 where t0.ci_customerid = $1 for update
  10. 2013-10-25 12:28:08 EDT DETAIL: parameters: $1 = '1'
  11. 2013-10-25 12:28:13 EDT LOG: duration: 5142.883 ms execute S_218: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventor
  12. y t0 where t0.ci_customerid = $1 for update
  13. 2013-10-25 12:28:13 EDT DETAIL: parameters: $1 = '1'
  14. 2013-10-25 12:28:19 EDT LOG: duration: 5088.835 ms execute S_227: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventor
  15. y t0 where t0.ci_customerid = $1 for update
  16. 2013-10-25 12:28:19 EDT DETAIL: parameters: $1 = '1'
  17. 2013-10-25 12:28:24 EDT LOG: duration: 5101.886 ms execute S_232: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventor
  18. y t0 where t0.ci_customerid = $1 for update
  19. 2013-10-25 12:28:24 EDT DETAIL: parameters: $1 = '1'
  20. 2013-10-25 12:28:25 EDT ERROR: type "blob" does not exist at character 109
  21. 2013-10-25 12:28:25 EDT STATEMENT: create table txn_log_table (localtid varchar(20), servername varchar(150), instancename varchar(150), gtrid blob)
  22. 2013-10-25 12:28:30 EDT LOG: duration: 5197.646 ms execute S_240: select t0.ci_id, t0.ci_customerid, t0.ci_value, t0.ci_itemid, t0.ci_quantity from c_customerinventor
  23. y t0 where t0.ci_customerid = $1 for update
  24. 2013-10-25 12:28:30 EDT DETAIL: parameters: $1 = '1'
  25. root@dbserver:~#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement