Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- root@dbserver:~# more /var/lib/postgresql/9.2/main/pg_log/postgresql-2013-10-25_121410.log
- 2013-10-25 12:14:10 EDT LOG: database system was shut down at 2013-10-25 12:06:16 EDT
- 2013-10-25 12:14:11 EDT LOG: database system is ready to accept connections
- 2013-10-25 12:14:11 EDT LOG: incomplete startup packet
- 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
- ry t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:01 EDT DETAIL: parameters: $1 = '1'
- 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
- y t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:08 EDT DETAIL: parameters: $1 = '1'
- 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
- y t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:13 EDT DETAIL: parameters: $1 = '1'
- 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
- y t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:19 EDT DETAIL: parameters: $1 = '1'
- 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
- y t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:24 EDT DETAIL: parameters: $1 = '1'
- 2013-10-25 12:28:25 EDT ERROR: type "blob" does not exist at character 109
- 2013-10-25 12:28:25 EDT STATEMENT: create table txn_log_table (localtid varchar(20), servername varchar(150), instancename varchar(150), gtrid blob)
- 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
- y t0 where t0.ci_customerid = $1 for update
- 2013-10-25 12:28:30 EDT DETAIL: parameters: $1 = '1'
- root@dbserver:~#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement