2022-10-17 04:44:49 (321633) INFO : successfully loaded job file /var/log/mariadb/columnstore/data/bulk/tmpjob/28485_D20221017_T044448_S849599_Job_28485.xml
2022-10-17 04:44:49 (321633) INFO2 : Command line options: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s  -E  -R /tmp/columnstore_tmp_files/BrmRpt0917044448463063.rpt -m 1 -P pm1-463063 -T SYSTEM -u0bc041fd-e4b8-4cf9-8b0e-20bbb8f24a99 test tab2
2022-10-17 04:44:49 (321633) INFO : Job file loaded, run time for this step : 0.489074 seconds
2022-10-17 04:44:49 (321633) INFO2 : XMLJobFile: Delim(|); EnclosedBy(n/a); EscapeChar(\); ReadBufs(5); ReadBufSize(1048576); setvbufSize(10485760)
2022-10-17 04:44:49 (321633) INFO2 :   Table(test.tab2); OID(28485); MaxErrNum(10)
2022-10-17 04:44:49 (321633) INFO2 :     Column(measure_id); OID(28486); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(year_id); OID(28487); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(location_id); OID(28488); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(sex_id); OID(28489); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(age_group_id); OID(28490); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(cause_id); OID(28491); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(rei_id); OID(28492); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(metric_id); OID(28493); Type(integer); Width(4); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(val); OID(28494); Type(double); Width(8); Comp(2); NotNull
2022-10-17 04:44:49 (321633) INFO2 :     Column(upper); OID(28495); Type(double); Width(8); Comp(2)
2022-10-17 04:44:49 (321633) INFO2 :     Column(lower); OID(28496); Type(double); Width(8); Comp(2)
2022-10-17 04:44:49 (321633) INFO : PreProcessing check starts
2022-10-17 04:44:49 (321633) INFO2 : Using STDIN for input data
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28486
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28486; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28487
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28487; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28488
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28488; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28489
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28489; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28490
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28490; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28491
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28491; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28492
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28492; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28493
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28493; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28494
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28494; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28495
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28495; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Starting DBRoot info for OID 28496
  DBRoot-2, part/seg/hwm/LBID/totBlks/state: 0/0/0/0/0/EmptyDbRoot
2022-10-17 04:44:49 (321633) INFO2 : No active extents; will add partition to start adding rows for oid-28496; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2...
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28486; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28487; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28488; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28489; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28490; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28491; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28492; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28493; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28494; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28495; will create starting extent
2022-10-17 04:44:49 (321633) INFO2 : Currently no extents on dbroot2 for column OID 28496; will create starting extent
2022-10-17 04:44:49 (321633) INFO : PreProcessing check completed
2022-10-17 04:44:49 (321633) INFO : preProcess completed, run time for this step : 0.0176589 seconds
2022-10-17 04:44:49 (321633) INFO : No of Read Threads Spawned = 1
2022-10-17 04:44:49 (321633) INFO : No of Parse Threads Spawned = 3
2022-10-17 04:44:49 (321633) INFO : Reading input from STDIN to import into table test.tab2...
2022-10-17 04:44:49 (321633) INFO2 : Start reading and loading table test.tab2
2022-10-17 04:44:49 (321633) INFO2 : Allocating next stripe(1) of column extents for table 28485; DBRoot-2
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28486; DBRoot-2; Part#-0; Seg#-2; lbid-12245829632; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28487; DBRoot-2; Part#-0; Seg#-2; lbid-12245833728; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28488; DBRoot-2; Part#-0; Seg#-2; lbid-12245837824; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28489; DBRoot-2; Part#-0; Seg#-2; lbid-12245841920; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28490; DBRoot-2; Part#-0; Seg#-2; lbid-12245846016; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28491; DBRoot-2; Part#-0; Seg#-2; lbid-12245850112; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28492; DBRoot-2; Part#-0; Seg#-2; lbid-12245854208; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28493; DBRoot-2; Part#-0; Seg#-2; lbid-12245858304; fbo-0; nblks-4096
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28494; DBRoot-2; Part#-0; Seg#-2; lbid-12245862400; fbo-0; nblks-8192
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28495; DBRoot-2; Part#-0; Seg#-2; lbid-12245870592; fbo-0; nblks-8192
2022-10-17 04:44:49 (321633) INFO2 : Stripe Allocation: OID-28496; DBRoot-2; Part#-0; Seg#-2; lbid-12245878784; fbo-0; nblks-8192
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28496; part-0; seg-2; hwm-0; LBID-12245878784; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/080.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-lower (compressed); OID-28496; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/080.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28495; part-0; seg-2; hwm-0; LBID-12245870592; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/079.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28494; part-0; seg-2; hwm-0; LBID-12245862400; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/078.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-upper (compressed); OID-28495; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/079.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-val (compressed); OID-28494; hwm-2; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/078.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28493; part-0; seg-2; hwm-0; LBID-12245858304; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/077.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28492; part-0; seg-2; hwm-0; LBID-12245854208; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/076.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28491; part-0; seg-2; hwm-0; LBID-12245850112; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/075.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-rei_id (compressed); OID-28492; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/076.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-metric_id (compressed); OID-28493; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/077.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-cause_id (compressed); OID-28491; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/075.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28488; part-0; seg-2; hwm-0; LBID-12245837824; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/072.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28489; part-0; seg-2; hwm-0; LBID-12245841920; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/073.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-location_id (compressed); OID-28488; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/072.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-sex_id (compressed); OID-28489; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/073.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28490; part-0; seg-2; hwm-0; LBID-12245846016; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/074.dir/000.dir/FILE002.cdf
2022-10-17 04:44:49 (321633) INFO2 : Initializing import: Table-test.tab2; Col-age_group_id (compressed); OID-28490; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/074.dir/000.dir/FILE002.cdf
2022-10-17 04:44:50 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28487; part-0; seg-2; hwm-0; LBID-12245833728; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/071.dir/000.dir/FILE002.cdf
2022-10-17 04:44:50 (321633) INFO2 : PM empty; Creating starting column extent on DBRoot-2 for OID-28486; part-0; seg-2; hwm-0; LBID-12245829632; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/070.dir/000.dir/FILE002.cdf
2022-10-17 04:44:50 (321633) INFO2 : Initializing import: Table-test.tab2; Col-year_id (compressed); OID-28487; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/071.dir/000.dir/FILE002.cdf
2022-10-17 04:44:50 (321633) INFO2 : Initializing import: Table-test.tab2; Col-measure_id (compressed); OID-28486; hwm-1; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/070.dir/000.dir/FILE002.cdf
2022-10-17 04:47:02 (321633) INFO2 : Truncating column file: OID-28488; DBRoot-2; part-0; seg-2; size-1712128
2022-10-17 04:47:02 (321633) INFO2 : Allocating next stripe(2) of column extents for table 28485; DBRoot-2
2022-10-17 04:47:02 (321633) INFO2 : Truncating column file: OID-28487; DBRoot-2; part-0; seg-2; size-2768896
2022-10-17 04:47:02 (321633) INFO2 : Truncating column file: OID-28496; DBRoot-2; part-0; seg-2; size-32636928
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28486; DBRoot-2; Part#-0; Seg#-2; lbid-12245944320; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28487; DBRoot-2; Part#-0; Seg#-2; lbid-12245948416; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28488; DBRoot-2; Part#-0; Seg#-2; lbid-12245952512; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28489; DBRoot-2; Part#-0; Seg#-2; lbid-12245956608; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28490; DBRoot-2; Part#-0; Seg#-2; lbid-12245960704; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28491; DBRoot-2; Part#-0; Seg#-2; lbid-12245964800; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28492; DBRoot-2; Part#-0; Seg#-2; lbid-12245968896; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28493; DBRoot-2; Part#-0; Seg#-2; lbid-12245972992; fbo-4096; nblks-4096
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28494; DBRoot-2; Part#-0; Seg#-2; lbid-12245977088; fbo-8192; nblks-8192
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28495; DBRoot-2; Part#-0; Seg#-2; lbid-12245985280; fbo-8192; nblks-8192
2022-10-17 04:47:03 (321633) INFO2 : Stripe Allocation: OID-28496; DBRoot-2; Part#-0; Seg#-2; lbid-12245993472; fbo-8192; nblks-8192
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28496; DBRoot-2; part-0; seg-2; hwm-8192; LBID-12245993472; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/080.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28487; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245948416; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/071.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28488; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245952512; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/072.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28490; DBRoot-2; part-0; seg-2; size-1777664
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28489; DBRoot-2; part-0; seg-2; size-1712128
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28491; DBRoot-2; part-0; seg-2; size-1712128
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28489; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245956608; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/073.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28490; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245960704; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/074.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28491; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245964800; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/075.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28492; DBRoot-2; part-0; seg-2; size-1712128
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28492; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245968896; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/076.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28493; DBRoot-2; part-0; seg-2; size-5013504
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28494; DBRoot-2; part-0; seg-2; size-32669696
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28494; DBRoot-2; part-0; seg-2; hwm-8192; LBID-12245977088; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/078.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28493; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245972992; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/077.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28486; DBRoot-2; part-0; seg-2; size-1712128
2022-10-17 04:47:03 (321633) INFO2 : Truncating column file: OID-28495; DBRoot-2; part-0; seg-2; size-32669696
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28495; DBRoot-2; part-0; seg-2; hwm-8192; LBID-12245985280; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/079.dir/000.dir/FILE002.cdf
2022-10-17 04:47:03 (321633) INFO2 : Add column extent OID-28486; DBRoot-2; part-0; seg-2; hwm-4096; LBID-12245944320; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/070.dir/000.dir/FILE002.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28495; DBRoot-2; part-0; seg-2; size-59719680
2022-10-17 04:49:10 (321633) INFO2 : Allocating next stripe(3) of column extents for table 28485; DBRoot-2
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28494; DBRoot-2; part-0; seg-2; size-59719680
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28496; DBRoot-2; part-0; seg-2; size-59662336
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28486; DBRoot-2; Part#-1; Seg#-3; lbid-12246345728; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28487; DBRoot-2; Part#-1; Seg#-3; lbid-12246349824; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28488; DBRoot-2; Part#-1; Seg#-3; lbid-12246353920; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28489; DBRoot-2; Part#-1; Seg#-3; lbid-12246358016; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28490; DBRoot-2; Part#-1; Seg#-3; lbid-12246362112; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28491; DBRoot-2; Part#-1; Seg#-3; lbid-12246366208; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28492; DBRoot-2; Part#-1; Seg#-3; lbid-12246370304; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28493; DBRoot-2; Part#-1; Seg#-3; lbid-12246374400; fbo-0; nblks-4096
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28494; DBRoot-2; Part#-1; Seg#-3; lbid-12246378496; fbo-0; nblks-8192
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28495; DBRoot-2; Part#-1; Seg#-3; lbid-12246386688; fbo-0; nblks-8192
2022-10-17 04:49:10 (321633) INFO2 : Stripe Allocation: OID-28496; DBRoot-2; Part#-1; Seg#-3; lbid-12246394880; fbo-0; nblks-8192
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28495; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246386688; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/079.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28494; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246378496; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/078.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28496; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246394880; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/080.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28488; DBRoot-2; part-0; seg-2; size-3416064
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28490; DBRoot-2; part-0; seg-2; size-3547136
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28488; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246353920; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/072.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28490; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246362112; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/074.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28487; DBRoot-2; part-0; seg-2; size-5423104
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28487; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246349824; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/071.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28492; DBRoot-2; part-0; seg-2; size-3416064
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28491; DBRoot-2; part-0; seg-2; size-3416064
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28492; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246370304; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/076.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28491; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246366208; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/075.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28489; DBRoot-2; part-0; seg-2; size-3416064
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28489; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246358016; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/073.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28486; DBRoot-2; part-0; seg-2; size-3416064
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28486; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246345728; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/070.dir/001.dir/FILE003.cdf
2022-10-17 04:49:10 (321633) INFO2 : Truncating column file: OID-28493; DBRoot-2; part-0; seg-2; size-9814016
2022-10-17 04:49:10 (321633) INFO2 : Add column extent OID-28493; DBRoot-2; part-1; seg-3; hwm-0; LBID-12246374400; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/077.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28494; DBRoot-2; part-1; seg-3; size-25362432
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28496; DBRoot-2; part-1; seg-3; size-25321472
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28495; DBRoot-2; part-1; seg-3; size-25354240
2022-10-17 04:51:14 (321633) INFO2 : Allocating next stripe(4) of column extents for table 28485; DBRoot-2
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28486; DBRoot-2; Part#-1; Seg#-3; lbid-12246403072; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28487; DBRoot-2; Part#-1; Seg#-3; lbid-12246407168; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28488; DBRoot-2; Part#-1; Seg#-3; lbid-12246411264; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28489; DBRoot-2; Part#-1; Seg#-3; lbid-12246415360; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28490; DBRoot-2; Part#-1; Seg#-3; lbid-12246419456; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28491; DBRoot-2; Part#-1; Seg#-3; lbid-12246423552; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28492; DBRoot-2; Part#-1; Seg#-3; lbid-12246427648; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28493; DBRoot-2; Part#-1; Seg#-3; lbid-12246431744; fbo-4096; nblks-4096
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28494; DBRoot-2; Part#-1; Seg#-3; lbid-12246435840; fbo-8192; nblks-8192
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28495; DBRoot-2; Part#-1; Seg#-3; lbid-12246444032; fbo-8192; nblks-8192
2022-10-17 04:51:14 (321633) INFO2 : Stripe Allocation: OID-28496; DBRoot-2; Part#-1; Seg#-3; lbid-12246452224; fbo-8192; nblks-8192
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28495; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12246444032; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/079.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28496; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12246452224; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/080.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28494; DBRoot-2; part-1; seg-3; hwm-8192; LBID-12246435840; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/078.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28489; DBRoot-2; part-1; seg-3; size-1712128
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28488; DBRoot-2; part-1; seg-3; size-1712128
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28487; DBRoot-2; part-1; seg-3; size-2605056
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28487; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246407168; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/071.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28489; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246415360; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/073.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28488; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246411264; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/072.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28491; DBRoot-2; part-1; seg-3; size-1712128
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28491; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246423552; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/075.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28492; DBRoot-2; part-1; seg-3; size-1712128
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28490; DBRoot-2; part-1; seg-3; size-1777664
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28490; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246419456; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/074.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28492; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246427648; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/076.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28486; DBRoot-2; part-1; seg-3; size-1712128
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28486; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246403072; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/070.dir/001.dir/FILE003.cdf
2022-10-17 04:51:14 (321633) INFO2 : Truncating column file: OID-28493; DBRoot-2; part-1; seg-3; size-4587520
2022-10-17 04:51:14 (321633) INFO2 : Add column extent OID-28493; DBRoot-2; part-1; seg-3; hwm-4096; LBID-12246431744; file-/var/lib/columnstore/data2/000.dir/000.dir/111.dir/077.dir/001.dir/FILE003.cdf
2022-10-17 04:51:46 (321633) INFO2 : Finished loading test.tab2 from STDIN, Time taken = 417 seconds
2022-10-17 04:51:46 (321633) INFO2 : BulkLoad::ReadOperation No more tables available for processing. Read thread 0 exiting...
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28486; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28486; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28486; lbid-12245944320; type-0; isNew-1; min: 3; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28486; lbid-12245829632; type-0; isNew-1; min: 3; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28486; lbid-12246403072; type-0; isNew-1; min: 3; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28486; lbid-12246345728; type-0; isNew-1; min: 3; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28487; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28487; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28487; lbid-12245948416; type-0; isNew-1; min: 1990; max: 2022
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28487; lbid-12245833728; type-0; isNew-1; min: 1990; max: 2022
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28487; lbid-12246407168; type-0; isNew-1; min: 1990; max: 2022
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28487; lbid-12246349824; type-0; isNew-1; min: 1990; max: 2022
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28488; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28488; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28488; lbid-12245952512; type-0; isNew-1; min: 1; max: 570
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28488; lbid-12245837824; type-0; isNew-1; min: 1; max: 570
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28488; lbid-12246411264; type-0; isNew-1; min: 1; max: 548
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28488; lbid-12246353920; type-0; isNew-1; min: 1; max: 548
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28489; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28489; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28489; lbid-12245956608; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28489; lbid-12245841920; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28489; lbid-12246415360; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28489; lbid-12246358016; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28490; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28490; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28490; lbid-12245960704; type-0; isNew-1; min: 1; max: 389
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28490; lbid-12245846016; type-0; isNew-1; min: 1; max: 389
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28490; lbid-12246419456; type-0; isNew-1; min: 1; max: 389
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28490; lbid-12246362112; type-0; isNew-1; min: 1; max: 389
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28491; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28491; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28491; lbid-12245964800; type-0; isNew-1; min: 294; max: 1048
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28491; lbid-12245850112; type-0; isNew-1; min: 294; max: 1048
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28491; lbid-12246423552; type-0; isNew-1; min: 294; max: 1048
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28491; lbid-12246366208; type-0; isNew-1; min: 294; max: 1048
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28492; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28492; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28492; lbid-12245968896; type-0; isNew-1; min: 191; max: 379
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28492; lbid-12245854208; type-0; isNew-1; min: 191; max: 379
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28492; lbid-12246427648; type-0; isNew-1; min: 191; max: 379
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28492; lbid-12246370304; type-0; isNew-1; min: 191; max: 379
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28493; hwm-8191; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28493; hwm-5187; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28493; lbid-12245972992; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28493; lbid-12245858304; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28493; lbid-12246431744; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving CP  update for OID-28493; lbid-12246374400; type-0; isNew-1; min: 1; max: 3
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28494; hwm-16383; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28494; hwm-10375; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28495; hwm-16383; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28495; hwm-10375; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28496; hwm-16383; DBRoot-2; partition-0; segment-2
2022-10-17 04:51:46 (321633) INFO2 : Saving HWM update for OID-28496; hwm-10375; DBRoot-2; partition-1; segment-3
2022-10-17 04:51:46 (321633) INFO2 : Writing 32 CP updates for table test.tab2 to report file /tmp/columnstore_tmp_files/BrmRpt0917044448463063.rpt
2022-10-17 04:51:46 (321633) INFO2 : Writing 22 HWM update(s) for table test.tab2 to report file /tmp/columnstore_tmp_files/BrmRpt0917044448463063.rpt
2022-10-17 04:51:46 (321633) INFO : For table test.tab2: 27400000 rows processed and 27400000 rows inserted.
2022-10-17 04:51:46 (321633) INFO2 : For table test.tab2: Elapsed time to load this table: 417.381 secs
2022-10-17 04:51:46 (321633) INFO : Bulk load completed, total run time : 417.899 seconds