2022-10-17 04:43:09 (321499) INFO : successfully loaded job file /var/log/mariadb/columnstore/data/bulk/tmpjob/28461_D20221017_T044307_S869316_Job_28461.xml 2022-10-17 04:43:09 (321499) INFO2 : Command line options: -L /var/log/mariadb/columnstore/cpimport/ -s , -E " -R /tmp/columnstore_tmp_files/BrmRpt0917044307462877.rpt -m 1 -P pm1-462877 -T SYSTEM -u326e867e-f107-4eb1-b61f-785ed0a5ab4b test tab1 2022-10-17 04:43:09 (321499) INFO : Job file loaded, run time for this step : 1.84628 seconds 2022-10-17 04:43:09 (321499) INFO2 : XMLJobFile: Delim(|); EnclosedBy(n/a); EscapeChar(\); ReadBufs(5); ReadBufSize(1048576); setvbufSize(10485760) 2022-10-17 04:43:09 (321499) INFO2 : Table(test.tab1); OID(28461); MaxErrNum(10) 2022-10-17 04:43:09 (321499) INFO2 : Column(measure_id); OID(28462); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(year_id); OID(28463); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(location_id); OID(28464); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(sex_id); OID(28465); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(age_group_id); OID(28466); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(cause_id); OID(28467); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(rei_id); OID(28468); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(metric_id); OID(28469); Type(integer); Width(4); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(val); OID(28470); Type(double); Width(8); Comp(2); NotNull 2022-10-17 04:43:09 (321499) INFO2 : Column(upper); OID(28471); Type(double); Width(8); Comp(2) 2022-10-17 04:43:09 (321499) INFO2 : Column(lower); OID(28472); Type(double); Width(8); Comp(2) 2022-10-17 04:43:09 (321499) INFO : PreProcessing check starts 2022-10-17 04:43:09 (321499) INFO2 : Using STDIN for input data 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28462 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28462; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28463 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28463; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28464 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28464; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28465 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28465; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28466 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28466; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28467 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28467; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28468 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28468; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28469 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28469; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28470 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28470; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28471 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28471; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Starting DBRoot info for OID 28472 DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot 2022-10-17 04:43:09 (321499) INFO2 : No active extents; will add partition to start adding rows for oid-28472; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1... 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28462; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28463; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28464; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28465; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28466; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28467; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28468; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28469; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28470; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28471; will create starting extent 2022-10-17 04:43:09 (321499) INFO2 : Currently no extents on dbroot2 for column OID 28472; will create starting extent 2022-10-17 04:43:09 (321499) INFO : PreProcessing check completed 2022-10-17 04:43:09 (321499) INFO : preProcess completed, run time for this step : 0.0234399 seconds 2022-10-17 04:43:09 (321499) INFO : No of Read Threads Spawned = 1 2022-10-17 04:43:09 (321499) INFO : No of Parse Threads Spawned = 3 2022-10-17 04:43:09 (321499) INFO : Reading input from STDIN to import into table test.tab1... 2022-10-17 04:43:09 (321499) INFO2 : Start reading and loading table test.tab1 2022-10-17 04:43:09 (321499) INFO2 : Allocating next stripe(1) of column extents for table 28461; DBRoot-2 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28462; DBRoot-2; Part#-0; Seg#-3; lbid-12245026816; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28463; DBRoot-2; Part#-0; Seg#-3; lbid-12245030912; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28464; DBRoot-2; Part#-0; Seg#-3; lbid-12245035008; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28465; DBRoot-2; Part#-0; Seg#-3; lbid-12245039104; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28466; DBRoot-2; Part#-0; Seg#-3; lbid-12245043200; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28467; DBRoot-2; Part#-0; Seg#-3; lbid-12245047296; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28468; DBRoot-2; Part#-0; Seg#-3; lbid-12245051392; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28469; DBRoot-2; Part#-0; Seg#-3; lbid-12245055488; fbo-0; nblks-4096 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28470; DBRoot-2; Part#-0; Seg#-3; lbid-12245059584; fbo-0; nblks-8192 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28471; DBRoot-2; Part#-0; Seg#-3; lbid-12245067776; fbo-0; nblks-8192 2022-10-17 04:43:09 (321499) INFO2 : Stripe Allocation: OID-28472; DBRoot-2; Part#-0; Seg#-3; lbid-12245075968; fbo-0; nblks-8192 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28470; part-0; seg-3; hwm-0; LBID-12245059584; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/054.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28471; part-0; seg-3; hwm-0; LBID-12245067776; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/055.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28472; part-0; seg-3; hwm-0; LBID-12245075968; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/056.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-val (compressed); OID-28470; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/054.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-upper (compressed); OID-28471; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/055.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-lower (compressed); OID-28472; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/056.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28468; part-0; seg-3; hwm-0; LBID-12245051392; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/052.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28467; part-0; seg-3; hwm-0; LBID-12245047296; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/051.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-rei_id (compressed); OID-28468; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/052.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-cause_id (compressed); OID-28467; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/051.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28469; part-0; seg-3; hwm-0; LBID-12245055488; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/053.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-metric_id (compressed); OID-28469; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/053.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28466; part-0; seg-3; hwm-0; LBID-12245043200; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/050.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28465; part-0; seg-3; hwm-0; LBID-12245039104; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/049.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-age_group_id (compressed); OID-28466; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/050.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-sex_id (compressed); OID-28465; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/049.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28464; part-0; seg-3; hwm-0; LBID-12245035008; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/048.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-location_id (compressed); OID-28464; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/048.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28463; part-0; seg-3; hwm-0; LBID-12245030912; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/047.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28462; part-0; seg-3; hwm-0; LBID-12245026816; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/046.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-year_id (compressed); OID-28463; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/047.dir/000.dir/FILE003.cdf 2022-10-17 04:43:09 (321499) INFO2 : Initializing import: Table-test.tab1; Col-measure_id (compressed); OID-28462; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/046.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28472; DBRoot-2; part-0; seg-3; size-32669696 2022-10-17 04:43:30 (321499) INFO2 : Allocating next stripe(2) of column extents for table 28461; DBRoot-2 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28471; DBRoot-2; part-0; seg-3; size-32686080 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28470; DBRoot-2; part-0; seg-3; size-32677888 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28462; DBRoot-2; Part#-0; Seg#-3; lbid-12245141504; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28463; DBRoot-2; Part#-0; Seg#-3; lbid-12245145600; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28464; DBRoot-2; Part#-0; Seg#-3; lbid-12245149696; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28465; DBRoot-2; Part#-0; Seg#-3; lbid-12245153792; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28466; DBRoot-2; Part#-0; Seg#-3; lbid-12245157888; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28467; DBRoot-2; Part#-0; Seg#-3; lbid-12245161984; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28468; DBRoot-2; Part#-0; Seg#-3; lbid-12245166080; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28469; DBRoot-2; Part#-0; Seg#-3; lbid-12245170176; fbo-4096; nblks-4096 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28470; DBRoot-2; Part#-0; Seg#-3; lbid-12245174272; fbo-8192; nblks-8192 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28471; DBRoot-2; Part#-0; Seg#-3; lbid-12245182464; fbo-8192; nblks-8192 2022-10-17 04:43:30 (321499) INFO2 : Stripe Allocation: OID-28472; DBRoot-2; Part#-0; Seg#-3; lbid-12245190656; fbo-8192; nblks-8192 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28471; DBRoot-2; part-0; seg-3; hwm-8192; LBID-12245182464; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/055.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28472; DBRoot-2; part-0; seg-3; hwm-8192; LBID-12245190656; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/056.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28470; DBRoot-2; part-0; seg-3; hwm-8192; LBID-12245174272; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/054.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28467; DBRoot-2; part-0; seg-3; size-1712128 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28468; DBRoot-2; part-0; seg-3; size-1712128 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28467; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245161984; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/051.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28468; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245166080; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/052.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28463; DBRoot-2; part-0; seg-3; size-2768896 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28463; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245145600; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/047.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28464; DBRoot-2; part-0; seg-3; size-1712128 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28465; DBRoot-2; part-0; seg-3; size-1712128 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28464; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245149696; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/048.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28465; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245153792; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/049.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28466; DBRoot-2; part-0; seg-3; size-1777664 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28466; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245157888; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/050.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28462; DBRoot-2; part-0; seg-3; size-1712128 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28462; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245141504; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/046.dir/000.dir/FILE003.cdf 2022-10-17 04:43:30 (321499) INFO2 : Truncating column file: OID-28469; DBRoot-2; part-0; seg-3; size-5013504 2022-10-17 04:43:30 (321499) INFO2 : Add column extent OID-28469; DBRoot-2; part-0; seg-3; hwm-4096; LBID-12245170176; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/053.dir/000.dir/FILE003.cdf 2022-10-17 04:43:50 (321499) INFO2 : Truncating column file: OID-28471; DBRoot-2; part-0; seg-3; size-59744256 2022-10-17 04:43:50 (321499) INFO2 : Allocating next stripe(3) of column extents for table 28461; DBRoot-2 2022-10-17 04:43:50 (321499) INFO2 : Truncating column file: OID-28470; DBRoot-2; part-0; seg-3; size-59744256 2022-10-17 04:43:50 (321499) INFO2 : Truncating column file: OID-28472; DBRoot-2; part-0; seg-3; size-59719680 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28462; DBRoot-2; Part#-1; Seg#-3; lbid-12245485568; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28463; DBRoot-2; Part#-1; Seg#-3; lbid-12245489664; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28464; DBRoot-2; Part#-1; Seg#-3; lbid-12245493760; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28465; DBRoot-2; Part#-1; Seg#-3; lbid-12245497856; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28466; DBRoot-2; Part#-1; Seg#-3; lbid-12245501952; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28467; DBRoot-2; Part#-1; Seg#-3; lbid-12245506048; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28468; DBRoot-2; Part#-1; Seg#-3; lbid-12245510144; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28469; DBRoot-2; Part#-1; Seg#-3; lbid-12245514240; fbo-0; nblks-4096 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28470; DBRoot-2; Part#-1; Seg#-3; lbid-12245518336; fbo-0; nblks-8192 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28471; DBRoot-2; Part#-1; Seg#-3; lbid-12245526528; fbo-0; nblks-8192 2022-10-17 04:43:51 (321499) INFO2 : Stripe Allocation: OID-28472; DBRoot-2; Part#-1; Seg#-3; lbid-12245534720; fbo-0; nblks-8192 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28471; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245526528; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/055.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28470; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245518336; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/054.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28472; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245534720; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/056.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28468; DBRoot-2; part-0; seg-3; size-3416064 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28464; DBRoot-2; part-0; seg-3; size-3416064 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28464; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245493760; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/048.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28468; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245510144; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/052.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28463; DBRoot-2; part-0; seg-3; size-5423104 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28463; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245489664; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/047.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28466; DBRoot-2; part-0; seg-3; size-3547136 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28466; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245501952; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/050.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28467; DBRoot-2; part-0; seg-3; size-3416064 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28467; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245506048; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/051.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28465; DBRoot-2; part-0; seg-3; size-3416064 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28465; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245497856; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/049.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28462; DBRoot-2; part-0; seg-3; size-3416064 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28462; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245485568; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/046.dir/001.dir/FILE003.cdf 2022-10-17 04:43:51 (321499) INFO2 : Truncating column file: OID-28469; DBRoot-2; part-0; seg-3; size-9814016 2022-10-17 04:43:51 (321499) INFO2 : Add column extent OID-28469; DBRoot-2; part-1; seg-3; hwm-0; LBID-12245514240; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/053.dir/001.dir/FILE003.cdf 2022-10-17 04:44:10 (321499) INFO2 : Truncating column file: OID-28470; DBRoot-2; part-1; seg-3; size-25370624 2022-10-17 04:44:10 (321499) INFO2 : Allocating next stripe(4) of column extents for table 28461; DBRoot-2 2022-10-17 04:44:10 (321499) INFO2 : Truncating column file: OID-28472; DBRoot-2; part-1; seg-3; size-25346048 2022-10-17 04:44:10 (321499) INFO2 : Truncating column file: OID-28471; DBRoot-2; part-1; seg-3; size-25370624 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28462; DBRoot-2; Part#-1; Seg#-3; lbid-12245714944; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28463; DBRoot-2; Part#-1; Seg#-3; lbid-12245719040; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28464; DBRoot-2; Part#-1; Seg#-3; lbid-12245723136; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28465; DBRoot-2; Part#-1; Seg#-3; lbid-12245727232; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28466; DBRoot-2; Part#-1; Seg#-3; lbid-12245731328; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28467; DBRoot-2; Part#-1; Seg#-3; lbid-12245735424; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28468; DBRoot-2; Part#-1; Seg#-3; lbid-12245739520; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28469; DBRoot-2; Part#-1; Seg#-3; lbid-12245743616; fbo-4096; nblks-4096 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28470; DBRoot-2; Part#-1; Seg#-3; lbid-12245747712; fbo-8192; nblks-8192 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28471; DBRoot-2; Part#-1; Seg#-3; lbid-12245755904; fbo-8192; nblks-8192 2022-10-17 04:44:11 (321499) INFO2 : Stripe Allocation: OID-28472; DBRoot-2; Part#-1; Seg#-3; lbid-12245764096; fbo-8192; nblks-8192 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28471; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12245755904; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/055.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28470; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12245747712; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/054.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28472; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12245764096; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/056.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28468; DBRoot-2; part-1; seg-3; size-1712128 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28468; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245739520; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/052.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28464; DBRoot-2; part-1; seg-3; size-1712128 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28464; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245723136; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/048.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28463; DBRoot-2; part-1; seg-3; size-2605056 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28463; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245719040; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/047.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28465; DBRoot-2; part-1; seg-3; size-1712128 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28465; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245727232; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/049.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28466; DBRoot-2; part-1; seg-3; size-1777664 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28466; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245731328; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/050.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28467; DBRoot-2; part-1; seg-3; size-1712128 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28467; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245735424; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/051.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28469; DBRoot-2; part-1; seg-3; size-4587520 2022-10-17 04:44:11 (321499) INFO2 : Truncating column file: OID-28462; DBRoot-2; part-1; seg-3; size-1712128 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28469; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245743616; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/053.dir/001.dir/FILE003.cdf 2022-10-17 04:44:11 (321499) INFO2 : Add column extent OID-28462; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12245714944; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/046.dir/001.dir/FILE003.cdf 2022-10-17 04:44:16 (321499) INFO2 : Finished loading test.tab1 from STDIN, Time taken = 67 seconds 2022-10-17 04:44:16 (321499) INFO2 : BulkLoad::ReadOperation No more tables available for processing. Read thread 0 exiting... 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28462; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28462; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28462; lbid-12245141504; type-0; isNew-1; min: 3; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28462; lbid-12245026816; type-0; isNew-1; min: 3; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28462; lbid-12245714944; type-0; isNew-1; min: 3; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28462; lbid-12245485568; type-0; isNew-1; min: 3; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28463; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28463; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28463; lbid-12245145600; type-0; isNew-1; min: 1990; max: 2022 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28463; lbid-12245030912; type-0; isNew-1; min: 1990; max: 2022 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28463; lbid-12245719040; type-0; isNew-1; min: 1990; max: 2022 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28463; lbid-12245489664; type-0; isNew-1; min: 1990; max: 2022 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28464; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28464; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28464; lbid-12245149696; type-0; isNew-1; min: 1; max: 570 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28464; lbid-12245035008; type-0; isNew-1; min: 1; max: 570 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28464; lbid-12245723136; type-0; isNew-1; min: 1; max: 548 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28464; lbid-12245493760; type-0; isNew-1; min: 1; max: 548 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28465; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28465; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28465; lbid-12245153792; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28465; lbid-12245039104; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28465; lbid-12245727232; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28465; lbid-12245497856; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28466; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28466; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28466; lbid-12245157888; type-0; isNew-1; min: 1; max: 389 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28466; lbid-12245043200; type-0; isNew-1; min: 1; max: 389 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28466; lbid-12245731328; type-0; isNew-1; min: 1; max: 389 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28466; lbid-12245501952; type-0; isNew-1; min: 1; max: 389 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28467; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28467; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28467; lbid-12245161984; type-0; isNew-1; min: 294; max: 1048 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28467; lbid-12245047296; type-0; isNew-1; min: 294; max: 1048 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28467; lbid-12245735424; type-0; isNew-1; min: 294; max: 1048 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28467; lbid-12245506048; type-0; isNew-1; min: 294; max: 1048 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28468; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28468; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28468; lbid-12245166080; type-0; isNew-1; min: 191; max: 379 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28468; lbid-12245051392; type-0; isNew-1; min: 191; max: 379 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28468; lbid-12245739520; type-0; isNew-1; min: 191; max: 379 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28468; lbid-12245510144; type-0; isNew-1; min: 191; max: 379 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28469; hwm-8191; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28469; hwm-5187; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28469; lbid-12245170176; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28469; lbid-12245055488; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28469; lbid-12245743616; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving CP update for OID-28469; lbid-12245514240; type-0; isNew-1; min: 1; max: 3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28470; hwm-16383; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28470; hwm-10375; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28471; hwm-16383; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28471; hwm-10375; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28472; hwm-16383; DBRoot-2; partition-0; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Saving HWM update for OID-28472; hwm-10375; DBRoot-2; partition-1; segment-3 2022-10-17 04:44:16 (321499) INFO2 : Writing 32 CP updates for table test.tab1 to report file /tmp/columnstore_tmp_files/BrmRpt0917044307462877.rpt 2022-10-17 04:44:16 (321499) INFO2 : Writing 22 HWM update(s) for table test.tab1 to report file /tmp/columnstore_tmp_files/BrmRpt0917044307462877.rpt 2022-10-17 04:44:16 (321499) INFO : For table test.tab1: 27400000 rows processed and 27400000 rows inserted. 2022-10-17 04:44:16 (321499) INFO2 : For table test.tab1: Elapsed time to load this table: 66.863 secs 2022-10-17 04:44:16 (321499) INFO : Bulk load completed, total run time : 68.7456 seconds