2015-08-21 22:52:53 EDT [3540]: [1-1] user=,db=,app=,client= LOG: database system was shut down at 2015-08-21 22:52:34 EDT 2015-08-21 22:52:53 EDT [3540]: [2-1] user=,db=,app=,client= LOG: MultiXact member wraparound protections are now enabled 2015-08-21 22:52:53 EDT [3539]: [1-1] user=,db=,app=,client= LOG: database system is ready to accept connections 2015-08-21 22:52:53 EDT [3545]: [1-1] user=,db=,app=,client= LOG: autovacuum launcher started 2015-08-21 22:53:01 EDT [3548]: [1-1] user=mark,db=postgres,app=pgxc,client=10.93.131.148 LOG: PGXC node coordinator: Applying default port value: 5432 2015-08-21 22:53:01 EDT [3548]: [2-1] user=mark,db=postgres,app=pgxc,client=10.93.131.148 STATEMENT: CREATE NODE coordinator WITH (TYPE = 'coordinator', HOST = 'pgxl') 2015-08-21 22:53:01 EDT [3548]: [3-1] user=mark,db=postgres,app=pgxc,client=10.93.131.148 WARNING: Expected to see a snapshot sent by the coordinator - now taking a direct snapshot from GTM 2015-08-21 22:53:02 EDT [3542]: [1-1] user=,db=,app=,client= LOG: checkpoint starting: immediate force wait flush-all 2015-08-21 22:53:02 EDT [3542]: [2-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 9 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.024 s, sync=0.009 s, total=0.039 s; sync files=9, longest=0.001 s, average=0.001 s; distance=5 kB, estimate=5 kB 2015-08-21 22:53:02 EDT [3542]: [3-1] user=,db=,app=,client= LOG: checkpoint starting: immediate force wait 2015-08-21 22:53:02 EDT [3542]: [4-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.000 s, total=0.013 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=5 kB 2015-08-21 22:54:47 EDT [3584]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 WARNING: Expected to see a snapshot sent by the coordinator - now taking a direct snapshot from GTM 2015-08-21 22:56:54 EDT [3619]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 WARNING: Expected to see a snapshot sent by the coordinator - now taking a direct snapshot from GTM 2015-08-21 22:58:02 EDT [3542]: [5-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 22:59:03 EDT [3603]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3634 2015-08-21 22:59:03 EDT [3603]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3603 waits for ShareLock on relation 16393 of database 16392. 2015-08-21 22:59:03 EDT [3603]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_nationkey_s_suppkey_idx ON supplier (s_nationkey, s_suppkey); 2015-08-21 22:59:03 EDT [3603]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3603 still waiting for ShareLock on relation 16393 of database 16392 after 1000.187 ms 2015-08-21 22:59:03 EDT [3603]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3634. Wait queue: 3603, 3614. 2015-08-21 22:59:03 EDT [3603]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_nationkey_s_suppkey_idx ON supplier (s_nationkey, s_suppkey); 2015-08-21 22:59:03 EDT [3614]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3634 2015-08-21 22:59:03 EDT [3614]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3614 waits for ShareLock on relation 16393 of database 16392. 2015-08-21 22:59:03 EDT [3614]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_suppkey_idx_like ON supplier (s_suppkey) WHERE s_comment LIKE '%Customer%Complaints%'; 2015-08-21 22:59:03 EDT [3614]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3614 still waiting for ShareLock on relation 16393 of database 16392 after 1000.360 ms 2015-08-21 22:59:03 EDT [3614]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3634. Wait queue: 3603, 3614. 2015-08-21 22:59:03 EDT [3614]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_suppkey_idx_like ON supplier (s_suppkey) WHERE s_comment LIKE '%Customer%Complaints%'; 2015-08-21 22:59:09 EDT [3634]: [1-1] user=,db=,app=,client= ERROR: canceling autovacuum task 2015-08-21 22:59:09 EDT [3634]: [2-1] user=,db=,app=,client= CONTEXT: automatic analyze of table "dbt3.public.supplier" 2015-08-21 22:59:09 EDT [3603]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3603 acquired ShareLock on relation 16393 of database 16392 after 7430.669 ms 2015-08-21 22:59:09 EDT [3603]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_nationkey_s_suppkey_idx ON supplier (s_nationkey, s_suppkey); 2015-08-21 22:59:09 EDT [3614]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3614 acquired ShareLock on relation 16393 of database 16392 after 7121.234 ms 2015-08-21 22:59:09 EDT [3614]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX supplier_s_suppkey_idx_like ON supplier (s_suppkey) WHERE s_comment LIKE '%Customer%Complaints%'; 2015-08-21 22:59:17 EDT [3542]: [6-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 44670 buffers (4.3%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=67.100 s, sync=6.749 s, total=74.109 s; sync files=60, longest=1.572 s, average=0.112 s; distance=3176794 kB, estimate=3176794 kB 2015-08-21 23:03:02 EDT [3542]: [7-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:04:25 EDT [3542]: [8-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 44703 buffers (4.3%); 0 transaction log file(s) added, 0 removed, 194 recycled; write=76.990 s, sync=4.987 s, total=82.597 s; sync files=44, longest=2.520 s, average=0.113 s; distance=3041366 kB, estimate=3163251 kB 2015-08-21 23:04:49 EDT [3612]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3674 2015-08-21 23:04:49 EDT [3612]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3612 waits for ShareLock on relation 16399 of database 16392. 2015-08-21 23:04:49 EDT [3612]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX partsupp_ps_suppkey_idx ON partsupp (ps_suppkey) ; 2015-08-21 23:04:49 EDT [3612]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3612 still waiting for ShareLock on relation 16399 of database 16392 after 1000.157 ms 2015-08-21 23:04:49 EDT [3612]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3674. Wait queue: 3612. 2015-08-21 23:04:49 EDT [3612]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX partsupp_ps_suppkey_idx ON partsupp (ps_suppkey) ; 2015-08-21 23:04:49 EDT [3674]: [1-1] user=,db=,app=,client= ERROR: canceling autovacuum task 2015-08-21 23:04:49 EDT [3674]: [2-1] user=,db=,app=,client= CONTEXT: automatic analyze of table "dbt3.public.partsupp" 2015-08-21 23:04:49 EDT [3612]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3612 acquired ShareLock on relation 16399 of database 16392 after 1000.279 ms 2015-08-21 23:04:49 EDT [3612]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX partsupp_ps_suppkey_idx ON partsupp (ps_suppkey) ; 2015-08-21 23:06:02 EDT [3584]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3724 2015-08-21 23:06:02 EDT [3584]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3584 waits for ShareLock on relation 16402 of database 16392. 2015-08-21 23:06:02 EDT [3584]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX customer_c_phone_idx ON customer (substr(c_phone::text, 1, 2), c_acctbal); 2015-08-21 23:06:02 EDT [3584]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3584 still waiting for ShareLock on relation 16402 of database 16392 after 1000.155 ms 2015-08-21 23:06:02 EDT [3584]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3724. Wait queue: 3584. 2015-08-21 23:06:02 EDT [3584]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX customer_c_phone_idx ON customer (substr(c_phone::text, 1, 2), c_acctbal); 2015-08-21 23:06:02 EDT [3724]: [1-1] user=,db=,app=,client= ERROR: canceling autovacuum task 2015-08-21 23:06:02 EDT [3724]: [2-1] user=,db=,app=,client= CONTEXT: automatic analyze of table "dbt3.public.customer" 2015-08-21 23:06:02 EDT [3584]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3584 acquired ShareLock on relation 16402 of database 16392 after 1000.282 ms 2015-08-21 23:06:02 EDT [3584]: [9-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX customer_c_phone_idx ON customer (substr(c_phone::text, 1, 2), c_acctbal); 2015-08-21 23:07:41 EDT [3617]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3739 2015-08-21 23:07:41 EDT [3617]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3617 waits for ShareLock on relation 16405 of database 16392. 2015-08-21 23:07:41 EDT [3617]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX orders_o_orderkey_o_orderdate_idx ON orders (o_orderkey, o_orderdate); 2015-08-21 23:07:41 EDT [3617]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3617 still waiting for ShareLock on relation 16405 of database 16392 after 1000.199 ms 2015-08-21 23:07:41 EDT [3617]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3739. Wait queue: 3617, 3550. 2015-08-21 23:07:41 EDT [3617]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX orders_o_orderkey_o_orderdate_idx ON orders (o_orderkey, o_orderdate); 2015-08-21 23:07:41 EDT [3739]: [1-1] user=,db=,app=,client= ERROR: canceling autovacuum task 2015-08-21 23:07:41 EDT [3739]: [2-1] user=,db=,app=,client= CONTEXT: automatic analyze of table "dbt3.public.orders" 2015-08-21 23:07:41 EDT [3617]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3617 acquired ShareLock on relation 16405 of database 16392 after 1010.822 ms 2015-08-21 23:07:41 EDT [3617]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX orders_o_orderkey_o_orderdate_idx ON orders (o_orderkey, o_orderdate); 2015-08-21 23:08:02 EDT [3542]: [9-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:10:27 EDT [3542]: [10-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 206213 buffers (19.7%); 0 transaction log file(s) added, 0 removed, 186 recycled; write=142.694 s, sync=2.213 s, total=145.096 s; sync files=42, longest=1.761 s, average=0.052 s; distance=2674607 kB, estimate=3114387 kB 2015-08-21 23:13:02 EDT [3542]: [11-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:13:22 EDT [3542]: [12-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 2240 buffers (0.2%); 0 transaction log file(s) added, 0 removed, 163 recycled; write=19.675 s, sync=0.724 s, total=20.442 s; sync files=30, longest=0.359 s, average=0.024 s; distance=2077975 kB, estimate=3010745 kB 2015-08-21 23:18:02 EDT [3542]: [13-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:18:20 EDT [3542]: [14-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 1925 buffers (0.2%); 0 transaction log file(s) added, 0 removed, 127 recycled; write=17.466 s, sync=0.986 s, total=18.510 s; sync files=5, longest=0.980 s, average=0.197 s; distance=2112336 kB, estimate=2920904 kB 2015-08-21 23:23:02 EDT [3542]: [15-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:23:31 EDT [3542]: [16-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 3085 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 129 recycled; write=27.597 s, sync=0.871 s, total=28.522 s; sync files=5, longest=0.841 s, average=0.174 s; distance=2090238 kB, estimate=2837838 kB 2015-08-21 23:24:01 EDT [3601]: [1-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: sending cancel to blocking autovacuum PID 3885 2015-08-21 23:24:01 EDT [3601]: [2-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process 3601 waits for ShareLock on relation 16408 of database 16392. 2015-08-21 23:24:01 EDT [3601]: [3-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX lineitem_l_orderkey_idx_l_returnflag ON lineitem (l_orderkey) WHERE l_returnflag = 'R'; 2015-08-21 23:24:01 EDT [3601]: [4-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3601 still waiting for ShareLock on relation 16408 of database 16392 after 1000.169 ms 2015-08-21 23:24:01 EDT [3601]: [5-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 DETAIL: Process holding the lock: 3885. Wait queue: 3601. 2015-08-21 23:24:01 EDT [3601]: [6-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX lineitem_l_orderkey_idx_l_returnflag ON lineitem (l_orderkey) WHERE l_returnflag = 'R'; 2015-08-21 23:24:01 EDT [3885]: [1-1] user=,db=,app=,client= ERROR: canceling autovacuum task 2015-08-21 23:24:01 EDT [3885]: [2-1] user=,db=,app=,client= CONTEXT: automatic analyze of table "dbt3.public.lineitem" 2015-08-21 23:24:01 EDT [3601]: [7-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 LOG: process 3601 acquired ShareLock on relation 16408 of database 16392 after 1000.298 ms 2015-08-21 23:24:01 EDT [3601]: [8-1] user=mark,db=dbt3,app=pgxc,client=10.93.131.148 STATEMENT: CREATE INDEX lineitem_l_orderkey_idx_l_returnflag ON lineitem (l_orderkey) WHERE l_returnflag = 'R'; 2015-08-21 23:25:34 EDT [3545]: [2-1] user=,db=,app=,client= LOG: using stale statistics instead of current ones because stats collector is not responding 2015-08-21 23:28:02 EDT [3542]: [17-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:29:35 EDT [3545]: [3-1] user=,db=,app=,client= LOG: using stale statistics instead of current ones because stats collector is not responding 2015-08-21 23:30:41 EDT [3542]: [18-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 17270 buffers (1.6%); 0 transaction log file(s) added, 0 removed, 127 recycled; write=149.037 s, sync=8.897 s, total=158.063 s; sync files=39, longest=8.753 s, average=0.228 s; distance=404337 kB, estimate=2594488 kB 2015-08-21 23:33:03 EDT [3542]: [19-1] user=,db=,app=,client= LOG: checkpoint starting: time 2015-08-21 23:35:33 EDT [3542]: [20-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 17898 buffers (1.7%); 0 transaction log file(s) added, 25 removed, 0 recycled; write=149.570 s, sync=0.053 s, total=150.118 s; sync files=16, longest=0.036 s, average=0.003 s; distance=83696 kB, estimate=2343408 kB 2015-08-21 23:36:18 EDT [3539]: [2-1] user=,db=,app=,client= LOG: received fast shutdown request 2015-08-21 23:36:18 EDT [3539]: [3-1] user=,db=,app=,client= LOG: aborting any active transactions 2015-08-21 23:36:18 EDT [3545]: [4-1] user=,db=,app=,client= LOG: autovacuum launcher shutting down 2015-08-21 23:36:18 EDT [3542]: [21-1] user=,db=,app=,client= LOG: shutting down 2015-08-21 23:36:18 EDT [3542]: [22-1] user=,db=,app=,client= LOG: checkpoint starting: shutdown immediate 2015-08-21 23:36:18 EDT [3542]: [23-1] user=,db=,app=,client= LOG: checkpoint complete: wrote 79 buffers (0.0%); 0 transaction log file(s) added, 5 removed, 0 recycled; write=0.013 s, sync=0.010 s, total=0.032 s; sync files=9, longest=0.004 s, average=0.001 s; distance=573 kB, estimate=2109125 kB 2015-08-21 23:36:18 EDT [3542]: [24-1] user=,db=,app=,client= LOG: database system is shut down