Oct 18 03:23:42 mariadb-x6-pm1 writeenginesplit[13530]: 42.983418 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 03:23:43 mariadb-x6-pm1 writeengineserver[29341]: 43.000148 |0|0|0| D 32 CAL0000: 9981 : onReceiveEOD : child ID = 13563 Oct 18 03:23:43 mariadb-x6-pm1 writeengineserver[29341]: 43.000271 |0|0|0| D 32 CAL0000: 9981 : Message Queue is empty; Stopping CF Thread Oct 18 03:23:48 mariadb-x6-pm1 cpimport.bin[13563]: 48.569222 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 25165971 rows inserted Oct 18 03:23:48 mariadb-x6-pm1 writeengine[13563]: 48.569279 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T030753_S173751_Job_12772.xml |For table reax6.bigsumplus: 25165971 rows processed and 25165971 rows inserted. Oct 18 03:23:48 mariadb-x6-pm1 cpimport.bin[13563]: 48.581578 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 03:23:48 mariadb-x6-pm1 writeengineserver[29341]: 48.590011 |0|0|0| I 32 CAL0000: 9981 : cpimport exit on success Oct 18 03:23:48 mariadb-x6-pm1 writeengineserver[29341]: 48.590229 |0|0|0| D 32 CAL0000: 9981 : onCpimportSuccess BrmReport Send Oct 18 03:23:48 mariadb-x6-pm1 writeengineserver[29341]: 48.590264 |0|0|0| D 32 CAL0000: 9981 : onReceiveEOD : child ID = 0 Oct 18 03:23:48 mariadb-x6-pm1 writeengineserver[29341]: 48.590300 |0|0|0| D 32 CAL0000: 9981 : onReceiveEOD : child ID = 0 Oct 18 03:23:48 mariadb-x6-pm1 writeenginesplit[13530]: 48.593397 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 03:23:50 mariadb-x6-pm1 writeenginesplit[13530]: 50.594511 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 03:23:54 mariadb-x6-pm1 writeenginesplit[13530]: 54.944225 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 03:23:54 mariadb-x6-pm1 writeengineserver[29341]: 54.944270 |0|0|0| D 32 CAL0000: 9981 : OnReceiveCleanup arrived Oct 18 03:23:56 mariadb-x6-pm1 writeenginesplit[13530]: 56.014768 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 03:23:57 mariadb-x6-pm1 dbcon[19032]: 57.100341 |100422|0|0| D 24 CAL0001: End SQL statement Oct 18 03:25:53 mariadb-x6-pm1 ExeMgr[29321]: 53.794769 |2147584145|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 03:25:53 mariadb-x6-pm1 ExeMgr[29321]: 53.811247 |2147584145|0|0| D 16 CAL0042: End SQL statement Oct 18 03:25:53 mariadb-x6-pm1 dbcon[19032]: 53.814619 |100497|0|0| D 24 CAL0001: Start SQL statement: LOAD DATA LOCAL INFILE '/db_storage/dumps/reax6/rea_bigsumplus_20200705000000.txt' into table bigsumplus FIELDS TERMINATED BY ',' (served,clicked,acted,viewed,date,flight_id,flight_creative_id,site,area,geo_country,geo_region,geo_city,sub,state,proptype,price,pos,platform,segment,posttags,region,language,dev_type,dev_os,dev_browser_name,pcode,bedmax,bedmin,beds,clientsite,adtype,cat,hb_pb,hb,creative_id,size_id,campaign_id,product_id,tier_id,flight_type_id,advertiser_id,agency_id,trafficker_id,salesperson_id,exposure_policy_id,region_id,industry_id,team_id); |reax6| Oct 18 03:25:53 mariadb-x6-pm1 ExeMgr[29321]: 53.825375 |2147584145|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='reax6' and tablename='bigsumplus' --tableRID/; || Oct 18 03:25:53 mariadb-x6-pm1 ExeMgr[29321]: 53.834391 |2147584145|0|0| D 16 CAL0042: End SQL statement Oct 18 03:25:54 mariadb-x6-pm1 writeengineserver[29341]: 54.355610 |0|0|0| D 32 CAL0000: 2953 : onReceiveMode() Setting fMode = 1 Oct 18 03:25:54 mariadb-x6-pm1 writeengineserver[29341]: 54.355727 |0|0|0| D 32 CAL0000: 2953 : onReceiveMode() DbRoot Count = 1 Oct 18 03:25:54 mariadb-x6-pm1 writeengineserver[29341]: 54.355779 |0|0|0| D 32 CAL0000: 2953 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091803255417628.rpt -m 1 -P pm1-17628 -T SYSTEM -u1fb05631-21f6-46bc-92a0-755c732949dc reax6 bigsumplus Oct 18 03:25:54 mariadb-x6-pm1 writeengineserver[29341]: 54.355828 |0|0|0| D 32 CAL0000: 2953 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt091803255417628.rpt Oct 18 03:25:54 mariadb-x6-pm1 writeengineserver[29341]: 54.355914 |0|0|0| D 32 CAL0000: 2953 : Start Cpimport command reached!! Oct 18 03:25:54 mariadb-x6-pm1 cpimport.bin[17659]: 54.382023 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091803255417628.rpt -m 1 -P pm1-17628 -T SYSTEM -u1fb05631-21f6-46bc-92a0-755c732949dc reax6 bigsumplus Oct 18 03:25:54 mariadb-x6-pm1 IDBFile[17659]: 54.384114 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so Oct 18 03:25:54 mariadb-x6-pm1 cpimport.bin[17659]: 54.452180 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-12772; db-reax6 Oct 18 03:38:50 mariadb-x6-pm1 StorageManager[29081]: S3Storage::deleteObject(): failed to DELETE, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/b551b82c-20ed-45f4-9d10-c86b83567ef0_0_860160_data1~000.dir~000.dir~049.dir~233.dir~144.dir~FILE001.cdf. Retrying... Oct 18 03:38:50 mariadb-x6-pm1 StorageManager[29081]: S3Storage::deleteObject(): failed to DELETE, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/28328e07-9631-42b0-8c94-187823c9c8b2_0_1318912_data1~000.dir~000.dir~049.dir~232.dir~144.dir~FILE001.cdf. Retrying... Oct 18 03:38:50 mariadb-x6-pm1 StorageManager[29081]: S3Storage::deleteObject(): failed to DELETE, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/9b84e011-a33f-4678-8b34-57c1b43dd475_0_2187264_data1~000.dir~000.dir~049.dir~229.dir~144.dir~FILE001.cdf. Retrying... Oct 18 03:41:52 mariadb-x6-pm1 writeenginesplit[17628]: 52.729623 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 03:41:52 mariadb-x6-pm1 writeengineserver[29341]: 52.734808 |0|0|0| D 32 CAL0000: 2953 : onReceiveEOD : child ID = 17659 Oct 18 03:41:52 mariadb-x6-pm1 writeengineserver[29341]: 52.734920 |0|0|0| D 32 CAL0000: 2953 : Message Queue is empty; Stopping CF Thread Oct 18 03:41:57 mariadb-x6-pm1 cpimport.bin[17659]: 57.224555 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 24680000 rows inserted Oct 18 03:41:57 mariadb-x6-pm1 writeengine[17659]: 57.224610 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T032554_S426018_Job_12772.xml |For table reax6.bigsumplus: 24680000 rows processed and 24680000 rows inserted. Oct 18 03:41:57 mariadb-x6-pm1 cpimport.bin[17659]: 57.237165 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 03:41:57 mariadb-x6-pm1 writeengineserver[29341]: 57.245912 |0|0|0| I 32 CAL0000: 2953 : cpimport exit on success Oct 18 03:41:57 mariadb-x6-pm1 writeengineserver[29341]: 57.246122 |0|0|0| D 32 CAL0000: 2953 : onCpimportSuccess BrmReport Send Oct 18 03:41:57 mariadb-x6-pm1 writeengineserver[29341]: 57.246160 |0|0|0| D 32 CAL0000: 2953 : onReceiveEOD : child ID = 0 Oct 18 03:41:57 mariadb-x6-pm1 writeengineserver[29341]: 57.246216 |0|0|0| D 32 CAL0000: 2953 : onReceiveEOD : child ID = 0 Oct 18 03:41:57 mariadb-x6-pm1 writeenginesplit[17628]: 57.249094 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 03:41:57 mariadb-x6-pm1 writeenginesplit[17628]: 57.321067 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 03:41:58 mariadb-x6-pm1 writeenginesplit[17628]: 58.316856 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 03:41:58 mariadb-x6-pm1 writeengineserver[29341]: 58.316901 |0|0|0| D 32 CAL0000: 2953 : OnReceiveCleanup arrived Oct 18 03:42:04 mariadb-x6-pm1 writeenginesplit[17628]: 04.689074 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 03:42:05 mariadb-x6-pm1 dbcon[19032]: 05.835945 |100497|0|0| D 24 CAL0001: End SQL statement Oct 18 03:44:24 mariadb-x6-pm1 ExeMgr[29321]: 24.844792 |2147584222|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 03:44:24 mariadb-x6-pm1 ExeMgr[29321]: 24.859252 |2147584222|0|0| D 16 CAL0042: End SQL statement Oct 18 03:44:24 mariadb-x6-pm1 dbcon[19032]: 24.862580 |100574|0|0| D 24 CAL0001: Start SQL statement: LOAD DATA LOCAL INFILE '/db_storage/dumps/reax6/rea_bigsumplus_20200706000000.txt' into table bigsumplus FIELDS TERMINATED BY ',' (served,clicked,acted,viewed,date,flight_id,flight_creative_id,site,area,geo_country,geo_region,geo_city,sub,state,proptype,price,pos,platform,segment,posttags,region,language,dev_type,dev_os,dev_browser_name,pcode,bedmax,bedmin,beds,clientsite,adtype,cat,hb_pb,hb,creative_id,size_id,campaign_id,product_id,tier_id,flight_type_id,advertiser_id,agency_id,trafficker_id,salesperson_id,exposure_policy_id,region_id,industry_id,team_id); |reax6| Oct 18 03:44:24 mariadb-x6-pm1 ExeMgr[29321]: 24.873560 |2147584222|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='reax6' and tablename='bigsumplus' --tableRID/; || Oct 18 03:44:24 mariadb-x6-pm1 ExeMgr[29321]: 24.880262 |2147584222|0|0| D 16 CAL0042: End SQL statement Oct 18 03:44:25 mariadb-x6-pm1 writeengineserver[29341]: 25.406524 |0|0|0| D 32 CAL0000: 6806 : onReceiveMode() Setting fMode = 1 Oct 18 03:44:25 mariadb-x6-pm1 writeengineserver[29341]: 25.406651 |0|0|0| D 32 CAL0000: 6806 : onReceiveMode() DbRoot Count = 1 Oct 18 03:44:25 mariadb-x6-pm1 writeengineserver[29341]: 25.406712 |0|0|0| D 32 CAL0000: 6806 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091803442521779.rpt -m 1 -P pm1-21779 -T SYSTEM -u3e2678e9-c80a-4349-90ad-717e6855bfa3 reax6 bigsumplus Oct 18 03:44:25 mariadb-x6-pm1 writeengineserver[29341]: 25.406753 |0|0|0| D 32 CAL0000: 6806 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt091803442521779.rpt Oct 18 03:44:25 mariadb-x6-pm1 writeengineserver[29341]: 25.406859 |0|0|0| D 32 CAL0000: 6806 : Start Cpimport command reached!! Oct 18 03:44:25 mariadb-x6-pm1 cpimport.bin[21812]: 25.433906 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091803442521779.rpt -m 1 -P pm1-21779 -T SYSTEM -u3e2678e9-c80a-4349-90ad-717e6855bfa3 reax6 bigsumplus Oct 18 03:44:25 mariadb-x6-pm1 IDBFile[21812]: 25.436108 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so Oct 18 03:44:25 mariadb-x6-pm1 cpimport.bin[21812]: 25.502270 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-12772; db-reax6 Oct 18 04:14:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/a295d85e-ca19-4633-876d-712f0fbfe075_10485760_3606487_data1~systemFiles~dbrm~BRM_saves_journal Oct 18 04:14:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/a295d85e-ca19-4633-876d-712f0fbfe075_10485760_3606487_data1~systemFiles~dbrm~BRM_saves_journal has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 04:23:54 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/e34ad4da-7708-4395-9bfe-3f0de11a3e9f_0_1908736_data1~000.dir~000.dir~049.dir~237.dir~145.dir~FILE000.cdf Oct 18 04:23:54 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/e34ad4da-7708-4395-9bfe-3f0de11a3e9f_0_1908736_data1~000.dir~000.dir~049.dir~237.dir~145.dir~FILE000.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 04:34:31 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/a900391b-4b03-4976-b412-012fba9d1356_5242880_5038080_data1~000.dir~000.dir~049.dir~229.dir~145.dir~FILE000.cdf Oct 18 04:34:31 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/a900391b-4b03-4976-b412-012fba9d1356_5242880_5038080_data1~000.dir~000.dir~049.dir~229.dir~145.dir~FILE000.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 04:49:29 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/6045a971-74d3-44c8-9dfc-924d4d532d7d_10485760_2498560_data1~000.dir~000.dir~049.dir~229.dir~145.dir~FILE000.cdf Oct 18 04:49:29 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/6045a971-74d3-44c8-9dfc-924d4d532d7d_10485760_2498560_data1~000.dir~000.dir~049.dir~229.dir~145.dir~FILE000.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 04:56:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/94816d4e-e55d-4db6-9a5b-96749ccb53d1_5242880_3457024_data1~000.dir~000.dir~049.dir~232.dir~145.dir~FILE000.cdf Oct 18 04:56:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/94816d4e-e55d-4db6-9a5b-96749ccb53d1_5242880_3457024_data1~000.dir~000.dir~049.dir~232.dir~145.dir~FILE000.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 05:31:56 mariadb-x6-pm1 writeenginesplit[21779]: 56.209051 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 05:31:56 mariadb-x6-pm1 writeengineserver[29341]: 56.223037 |0|0|0| D 32 CAL0000: 6806 : onReceiveEOD : child ID = 21812 Oct 18 05:32:02 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/37f71ac9-a92e-45fb-a98f-ff4e19058420_0_1089536_data1~000.dir~000.dir~049.dir~229.dir~146.dir~FILE002.cdf Oct 18 05:32:02 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/37f71ac9-a92e-45fb-a98f-ff4e19058420_0_1089536_data1~000.dir~000.dir~049.dir~229.dir~146.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 05:32:04 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/c7500bfa-6b0e-4f9d-afb3-b561f8928faf_0_671744_data1~000.dir~000.dir~049.dir~232.dir~146.dir~FILE002.cdf Oct 18 05:32:04 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/c7500bfa-6b0e-4f9d-afb3-b561f8928faf_0_671744_data1~000.dir~000.dir~049.dir~232.dir~146.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 05:38:55 mariadb-x6-pm1 writeenginesplit[21779]: 55.836297 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 05:40:28 mariadb-x6-pm1 writeengineserver[29341]: 28.249241 |0|0|0| D 32 CAL0000: 6806 : Message Queue is empty; Stopping CF Thread Oct 18 05:45:53 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/4ccd1fe4-7c13-431c-b41f-2140be7e2673_0_2891776_data1~000.dir~000.dir~050.dir~004.dir~146.dir~FILE002.cdf Oct 18 05:45:53 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/4ccd1fe4-7c13-431c-b41f-2140be7e2673_0_2891776_data1~000.dir~000.dir~050.dir~004.dir~146.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 05:47:05 mariadb-x6-pm1 cpimport.bin[21812]: 05.297760 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 29040000 rows inserted Oct 18 05:47:05 mariadb-x6-pm1 writeengine[21812]: 05.297812 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T034425_S478586_Job_12772.xml |For table reax6.bigsumplus: 29040000 rows processed and 29040000 rows inserted. Oct 18 05:47:05 mariadb-x6-pm1 cpimport.bin[21812]: 05.310217 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 05:47:05 mariadb-x6-pm1 writeengineserver[29341]: 05.319117 |0|0|0| I 32 CAL0000: 6806 : cpimport exit on success Oct 18 05:47:05 mariadb-x6-pm1 writeengineserver[29341]: 05.319392 |0|0|0| D 32 CAL0000: 6806 : onCpimportSuccess BrmReport Send Oct 18 05:47:05 mariadb-x6-pm1 writeenginesplit[21779]: 05.321745 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 05:47:39 mariadb-x6-pm1 writeenginesplit[21779]: 39.637381 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 05:47:39 mariadb-x6-pm1 writeengineserver[29341]: 39.637407 |0|0|0| D 32 CAL0000: 6806 : OnReceiveCleanup arrived Oct 18 05:47:40 mariadb-x6-pm1 writeenginesplit[21779]: 40.512494 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 05:47:40 mariadb-x6-pm1 dbcon[19032]: 40.770552 |100574|0|0| D 24 CAL0001: End SQL statement Oct 18 13:06:36 mariadb-x6-pm1 ExeMgr[29321]: 36.599981 |2147586473|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 13:06:36 mariadb-x6-pm1 ExeMgr[29321]: 36.616379 |2147586473|0|0| D 16 CAL0042: End SQL statement Oct 18 13:06:36 mariadb-x6-pm1 ExeMgr[29321]: 36.639818 |102825|0|0| D 16 CAL0041: Start SQL statement: select max(date) from bigsumplus; |reax6| Oct 18 13:06:37 mariadb-x6-pm1 StorageManager[29081]: S3Storage::getObject(): failed to GET, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/5908e9d7-cadf-44ab-b64f-7a8ec53df0af_0_3416064_data1~000.dir~000.dir~049.dir~234.dir~007.dir~FILE000.cdf. Retrying... Oct 18 13:07:44 mariadb-x6-pm1 ExeMgr[29321]: 44.475970 |102825|0|0| D 16 CAL0042: End SQL statement Oct 18 13:08:58 mariadb-x6-pm1 ExeMgr[29321]: 58.314155 |102825|0|0| D 16 CAL0041: Start SQL statement: select date,sum(served) from bigsumplus where date > '2021-07-03' group by 1 order by 1; |reax6| Oct 18 13:08:58 mariadb-x6-pm1 ExeMgr[29321]: 58.326984 |102825|0|0| D 16 CAL0042: End SQL statement Oct 18 13:09:12 mariadb-x6-pm1 ExeMgr[29321]: 12.007859 |102825|0|0| D 16 CAL0041: Start SQL statement: select date,sum(served) from bigsumplus where date > '2020-07-03' group by 1 order by 1; |reax6| Oct 18 13:09:13 mariadb-x6-pm1 ExeMgr[29321]: 13.561372 |102825|0|0| D 16 CAL0042: End SQL statement Oct 18 13:16:01 mariadb-x6-pm1 ExeMgr[29321]: 01.599945 |2147586514|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 13:16:01 mariadb-x6-pm1 ExeMgr[29321]: 01.615183 |2147586514|0|0| D 16 CAL0042: End SQL statement Oct 18 13:16:01 mariadb-x6-pm1 dbcon[19032]: 01.618335 |102866|0|0| D 24 CAL0001: Start SQL statement: LOAD DATA LOCAL INFILE '/db_storage/dumps/reax6/rea_bigsumplus_20200707000000.txt' into table bigsumplus FIELDS TERMINATED BY ',' (served,clicked,acted,viewed,date,flight_id,flight_creative_id,site,area,geo_country,geo_region,geo_city,sub,state,proptype,price,pos,platform,segment,posttags,region,language,dev_type,dev_os,dev_browser_name,pcode,bedmax,bedmin,beds,clientsite,adtype,cat,hb_pb,hb,creative_id,size_id,campaign_id,product_id,tier_id,flight_type_id,advertiser_id,agency_id,trafficker_id,salesperson_id,exposure_policy_id,region_id,industry_id,team_id); |reax6| Oct 18 13:16:01 mariadb-x6-pm1 ExeMgr[29321]: 01.629314 |2147586514|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='reax6' and tablename='bigsumplus' --tableRID/; || Oct 18 13:16:01 mariadb-x6-pm1 ExeMgr[29321]: 01.638142 |2147586514|0|0| D 16 CAL0042: End SQL statement Oct 18 13:16:02 mariadb-x6-pm1 writeengineserver[29341]: 02.178720 |0|0|0| D 32 CAL0000: 7789 : onReceiveMode() Setting fMode = 1 Oct 18 13:16:02 mariadb-x6-pm1 writeengineserver[29341]: 02.178842 |0|0|0| D 32 CAL0000: 7789 : onReceiveMode() DbRoot Count = 1 Oct 18 13:16:02 mariadb-x6-pm1 writeengineserver[29341]: 02.178884 |0|0|0| D 32 CAL0000: 7789 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt09181316027676.rpt -m 1 -P pm1-7676 -T SYSTEM -udcba5a41-6bbe-4f2e-a426-8d413321c673 reax6 bigsumplus Oct 18 13:16:02 mariadb-x6-pm1 writeengineserver[29341]: 02.179209 |0|0|0| D 32 CAL0000: 7789 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt09181316027676.rpt Oct 18 13:16:02 mariadb-x6-pm1 writeengineserver[29341]: 02.179239 |0|0|0| D 32 CAL0000: 7789 : Start Cpimport command reached!! Oct 18 13:16:02 mariadb-x6-pm1 cpimport.bin[7709]: 02.205412 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt09181316027676.rpt -m 1 -P pm1-7676 -T SYSTEM -udcba5a41-6bbe-4f2e-a426-8d413321c673 reax6 bigsumplus Oct 18 13:16:02 mariadb-x6-pm1 IDBFile[7709]: 02.207513 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so Oct 18 13:16:02 mariadb-x6-pm1 cpimport.bin[7709]: 02.275129 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-12772; db-reax6 Oct 18 13:33:05 mariadb-x6-pm1 writeenginesplit[7676]: 05.805133 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 13:33:05 mariadb-x6-pm1 writeengineserver[29341]: 05.810322 |0|0|0| D 32 CAL0000: 7789 : onReceiveEOD : child ID = 7709 Oct 18 13:33:05 mariadb-x6-pm1 writeengineserver[29341]: 05.810443 |0|0|0| D 32 CAL0000: 7789 : Message Queue is empty; Stopping CF Thread Oct 18 13:33:10 mariadb-x6-pm1 writeenginesplit[7676]: 10.714653 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 13:33:11 mariadb-x6-pm1 writeenginesplit[7676]: 11.373331 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 13:33:14 mariadb-x6-pm1 cpimport.bin[7709]: 14.736354 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 27280000 rows inserted Oct 18 13:33:14 mariadb-x6-pm1 writeengine[7709]: 14.736406 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T131602_S249056_Job_12772.xml |For table reax6.bigsumplus: 27280000 rows processed and 27280000 rows inserted. Oct 18 13:33:14 mariadb-x6-pm1 cpimport.bin[7709]: 14.745306 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 13:33:14 mariadb-x6-pm1 writeengineserver[29341]: 14.752858 |0|0|0| I 32 CAL0000: 7789 : cpimport exit on success Oct 18 13:33:14 mariadb-x6-pm1 writeengineserver[29341]: 14.753077 |0|0|0| D 32 CAL0000: 7789 : onCpimportSuccess BrmReport Send Oct 18 13:33:14 mariadb-x6-pm1 writeengineserver[29341]: 14.753128 |0|0|0| D 32 CAL0000: 7789 : onReceiveEOD : child ID = 0 Oct 18 13:33:14 mariadb-x6-pm1 writeengineserver[29341]: 14.753160 |0|0|0| D 32 CAL0000: 7789 : onReceiveEOD : child ID = 0 Oct 18 13:33:15 mariadb-x6-pm1 writeengineserver[29341]: 15.125709 |0|0|0| D 32 CAL0000: 7789 : OnReceiveCleanup arrived Oct 18 13:33:15 mariadb-x6-pm1 writeenginesplit[7676]: 15.125795 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 13:33:16 mariadb-x6-pm1 writeenginesplit[7676]: 16.217325 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 13:33:16 mariadb-x6-pm1 dbcon[19032]: 16.554890 |102866|0|0| D 24 CAL0001: End SQL statement Oct 18 13:35:25 mariadb-x6-pm1 ExeMgr[29321]: 25.634242 |2147586596|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 13:35:25 mariadb-x6-pm1 ExeMgr[29321]: 25.650544 |2147586596|0|0| D 16 CAL0042: End SQL statement Oct 18 13:35:25 mariadb-x6-pm1 dbcon[19032]: 25.654138 |102948|0|0| D 24 CAL0001: Start SQL statement: LOAD DATA LOCAL INFILE '/db_storage/dumps/reax6/rea_bigsumplus_20200708000000.txt' into table bigsumplus FIELDS TERMINATED BY ',' (served,clicked,acted,viewed,date,flight_id,flight_creative_id,site,area,geo_country,geo_region,geo_city,sub,state,proptype,price,pos,platform,segment,posttags,region,language,dev_type,dev_os,dev_browser_name,pcode,bedmax,bedmin,beds,clientsite,adtype,cat,hb_pb,hb,creative_id,size_id,campaign_id,product_id,tier_id,flight_type_id,advertiser_id,agency_id,trafficker_id,salesperson_id,exposure_policy_id,region_id,industry_id,team_id); |reax6| Oct 18 13:35:25 mariadb-x6-pm1 ExeMgr[29321]: 25.664855 |2147586596|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='reax6' and tablename='bigsumplus' --tableRID/; || Oct 18 13:35:25 mariadb-x6-pm1 ExeMgr[29321]: 25.673641 |2147586596|0|0| D 16 CAL0042: End SQL statement Oct 18 13:35:26 mariadb-x6-pm1 writeengineserver[29341]: 26.216885 |0|0|0| D 32 CAL0000: 1240 : onReceiveMode() Setting fMode = 1 Oct 18 13:35:26 mariadb-x6-pm1 writeengineserver[29341]: 26.217003 |0|0|0| D 32 CAL0000: 1240 : onReceiveMode() DbRoot Count = 1 Oct 18 13:35:26 mariadb-x6-pm1 writeengineserver[29341]: 26.217053 |0|0|0| D 32 CAL0000: 1240 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091813352612194.rpt -m 1 -P pm1-12194 -T SYSTEM -u21c3313c-a3c2-4dc5-a27e-42860f9f517a reax6 bigsumplus Oct 18 13:35:26 mariadb-x6-pm1 writeengineserver[29341]: 26.217098 |0|0|0| D 32 CAL0000: 1240 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt091813352612194.rpt Oct 18 13:35:26 mariadb-x6-pm1 writeengineserver[29341]: 26.217122 |0|0|0| D 32 CAL0000: 1240 : Start Cpimport command reached!! Oct 18 13:35:26 mariadb-x6-pm1 cpimport.bin[12229]: 26.245107 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091813352612194.rpt -m 1 -P pm1-12194 -T SYSTEM -u21c3313c-a3c2-4dc5-a27e-42860f9f517a reax6 bigsumplus Oct 18 13:35:26 mariadb-x6-pm1 IDBFile[12229]: 26.247212 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so Oct 18 13:35:26 mariadb-x6-pm1 cpimport.bin[12229]: 26.313177 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-12772; db-reax6 Oct 18 13:35:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no metadata found for data1/bulkRollback/12772_data/12816.p147.s0.tmp. It must have been deleted. Oct 18 13:47:09 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/81bfaa41-a078-492c-b836-527099f7f0dd_0_4325376_data1~000.dir~000.dir~049.dir~229.dir~148.dir~FILE001.cdf Oct 18 13:47:09 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/81bfaa41-a078-492c-b836-527099f7f0dd_0_4325376_data1~000.dir~000.dir~049.dir~229.dir~148.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 14:07:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/378bf7f7-6daa-46fe-9b71-d2469d74cb2f_0_4857856_data1~000.dir~000.dir~049.dir~232.dir~148.dir~FILE001.cdf Oct 18 14:07:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/378bf7f7-6daa-46fe-9b71-d2469d74cb2f_0_4857856_data1~000.dir~000.dir~049.dir~232.dir~148.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 14:07:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/2730d582-c027-4102-b202-3be1fc712b10_0_2990080_data1~000.dir~000.dir~049.dir~233.dir~148.dir~FILE001.cdf Oct 18 14:07:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/2730d582-c027-4102-b202-3be1fc712b10_0_2990080_data1~000.dir~000.dir~049.dir~233.dir~148.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 14:12:55 mariadb-x6-pm1 ExeMgr[29321]: 55.192420 |2147586744|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='tiers' --columnRIDs/FE; || Oct 18 14:13:04 mariadb-x6-pm1 ExeMgr[29321]: 04.989166 |2147586744|0|0| D 16 CAL0042: End SQL statement Oct 18 14:13:05 mariadb-x6-pm1 ExeMgr[29321]: 05.014692 |103096|0|0| D 16 CAL0028: DbProf: Start Statement: Statement-0 Ver-1994 SQL-select count(*) from tiers Oct 18 14:13:05 mariadb-x6-pm1 ExeMgr[29321]: 05.014771 |103096|0|0| D 16 CAL0041: Start SQL statement: select count(*) from tiers; |reax6| Oct 18 14:13:05 mariadb-x6-pm1 joblist[29321]: 05.017057 |103096|0|0| D 05 CAL0036: SQL trace: #012#012job parms: #012maxBuckets = 128, maxElems = 131072, flushInterval = 16384, fifoSize = 16, ScanLimit/Threshold = 10000/5000#012UUID: 3fcd95c8-500d-42a9-97a4-b7ab581eafb2#012#012job filter steps: #012TupleBPS ses:103096 txn:0 ver: SCN: 1994#012 Txns: st:0 tb/col:13700/13703 alias:tiers not del (0x7fee60229640[19]) nf:0 in:#012 UUID: b10d4e12-31e2-4f41-afe2-916d661bb15d#012 Query UUID: 3fcd95c8-500d-42a9-97a4-b7ab581eafb2#012 BatchPrimitiveProcessorJL:#012 -- scan driven#012 1 filter steps:#012 ColumnCommandJL: 0 filters colwidth=1 oid=13703 name=active (scan)#012 1 projection steps:#012 PassThruCommandJL: colwidth=1 oid=13703 colName=active#012#012#012AggregateStep ses:103096 txn:0 st:1 in:(0x7fee60229640[19]) out:(0x7fee6022b5c0[19])#012AnnexStep ses:103096 txn:0 st:2 in:(0x7fee6022b5c0[19]) out:(0x7fee60229480[19])#012#012#012job project steps: #012#012job delivery steps: #012AnnexStep ses:103096 txn:0 st:2 in:(0x7fee6022b5c0[19]) out:(0x7fee60229480[19])#012#012#012runtime updates: start at Mon Oct 18 14:13:05 2021 Oct 18 14:13:05 mariadb-x6-pm1 ExeMgr[29321]: 05.017146 |103096|0|0| D 16 CAL0030: DbProf: Start Step: Statement-0 StepId-0 StepName-TupleBPS Oct 18 14:13:21 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/cfc20273-65ef-4f00-aa58-3a4544ad6076_10485760_3734472_data1~systemFiles~dbrm~BRM_saves_journal Oct 18 14:13:21 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/cfc20273-65ef-4f00-aa58-3a4544ad6076_10485760_3734472_data1~systemFiles~dbrm~BRM_saves_journal has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.259596 |103096|0|0| D 16 CAL0032: DbProf: I/O: Statement-0 StepId-0 ObjectId-13703 PhysRead-2 CacheRead-3 CPBlks-0 Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.259663 |103096|0|0| D 16 CAL0046: DbProf: Processing Times: Statement-0 StepId-0 FirstRead-2021-10-18 14:13:05.017340 LastRead-1970-01-01 00:00:00.000000 FirstWrite-2021-10-18 14:13:25.259481 LastWrite-2021-10-18 14:13:25.259482 Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.259688 |103096|0|0| D 16 CAL0031: DbProf: End Step: Statement-0 StepId-0 BlockedFifoIn-0 BlockedFifoOut-0 MsgBytesIn-250 MsgBytesOut-1631 Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.262970 |103096|0|0| D 16 CAL0047: DbProf: Summary: Statement-0 MaxMemPct-1 TempFileCnt-0 TempFileSpace-0 PhysRead-2 CacheRead-3 MsgsRcvd-2 MsgBytesIn-250 MsgBytesOut-1631 CPBlks-0 Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.263061 |103096|0|0| D 16 CAL0042: End SQL statement Oct 18 14:13:25 mariadb-x6-pm1 ExeMgr[29321]: 25.263271 |103096|0|0| D 16 CAL0029: DbProf: End Statement: Statement-0 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.806339 |2147586744|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='campaigns' --columnRIDs/FE; || Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.820584 |2147586744|0|0| D 16 CAL0042: End SQL statement Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.827482 |103096|0|0| D 16 CAL0028: DbProf: Start Statement: Statement-0 Ver-1994 SQL-select * from campaigns where id=20541 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.827543 |103096|0|0| D 16 CAL0041: Start SQL statement: select * from campaigns where id=20541; |reax6| Oct 18 14:13:59 mariadb-x6-pm1 joblist[29321]: 59.841853 |103096|0|0| D 05 CAL0036: SQL trace: #012#012job parms: #012maxBuckets = 128, maxElems = 131072, flushInterval = 16384, fifoSize = 16, ScanLimit/Threshold = 10000/5000#012UUID: 8221c9db-f608-4921-80fd-4c8452f0125f#012#012job filter steps: #012TupleBPS ses:103096 txn:0 ver: SCN: 1994#012 Txns: st:0 tb/col:13063/13064 alias:campaigns not del (0x7fee6014e840[19]) nf:1 in:#012 UUID: ce1f218b-6092-4ea5-8e98-d6e043e8b9c5#012 Query UUID: 8221c9db-f608-4921-80fd-4c8452f0125f#012 BatchPrimitiveProcessorJL:#012 -- scan driven#012 1 filter steps:#012 ColumnCommandJL: 1 filters colwidth=4 oid=13064 name=id (scan)#012 22 projection steps:#012 PassThruCommandJL: colwidth=4 oid=13064 colName=id#012 RTSCommandJL: oid=13086 colName=name#012 ColumnCommandJL: 0 filters colwidth=8 oid=13065 name=name (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13086 name=name#012#012 RTSCommandJL: oid=13087 colName=description#012 ColumnCommandJL: 0 filters colwidth=8 oid=13066 name=description (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13087 name=description#012#012 ColumnCommandJL: 0 filters colwidth=4 oid=13067 name=advertiser_id#012 RTSCommandJL: oid=13088 colName=notes#012 ColumnCommandJL: 0 filters colwidth=8 oid=13068 name=notes (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13088 name=notes#012#012 RTSCommandJL: oid=13089 colName=campaign_type#012 ColumnCommandJL: 0 filters colwidth=8 oid=13069 name=campaign_type (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13089 name=campaign_type#012#012 ColumnCommandJL: 0 filters colwidth=8 oid=13070 name=created_at#012 ColumnCommandJL: 0 filters colwidth=8 oid=13071 name=updated_at#012 RTSCommandJL: oid=13090 colName=external_id#012 ColumnCommandJL: 0 filters colwidth=8 oid=13072 name=external_id (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13090 name=external_id#012#012 ColumnCommandJL: 0 filters colwidth=8 oid=13073 name=deleted_at#012 ColumnCommandJL: 0 filters colwidth=4 oid=13074 name=start_date#012 ColumnCommandJL: 0 filters colwidth=4 oid=13075 name=end_date#012 ColumnCommandJL: 0 filters colwidth=4 oid=13076 name=agency_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13077 name=trafficker_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13078 name=salesperson_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13079 name=lock_version#012 ColumnCommandJL: 0 filters colwidth=4 oid=13080 name=exposure_policy_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13081 name=proposal_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13082 name=flags#012 RTSCommandJL: oid=13091 colName=status#012 ColumnCommandJL: 0 filters colwidth=8 oid=13083 name=status (tokens)#012 DictStepJL: 0 filters, BOP=0, oid=13091 name=status#012#012 ColumnCommandJL: 0 filters colwidth=4 oid=13084 name=team_id#012 ColumnCommandJL: 0 filters colwidth=4 oid=13085 name=trafficker_2_id#012#012#012AnnexStep ses:103096 txn:0 st:1 in:(0x7fee6014e840[19]) out:(0x7fee6014ebc0[19])#012#012#012job project steps: #012#012job delivery steps: #012AnnexStep ses:103096 txn:0 st:1 in:(0x7fee6014e840[19]) out:(0x7fee6014ebc0[19])#012#012#012runtime updates: start at Mon Oct 18 14:13:59 2021 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.842005 |103096|0|0| D 16 CAL0030: DbProf: Start Step: Statement-0 StepId-0 StepName-TupleBPS Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.846517 |103096|0|0| D 16 CAL0032: DbProf: I/O: Statement-0 StepId-0 ObjectId-13064 PhysRead-0 CacheRead-68 CPBlks-0 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.846568 |103096|0|0| D 16 CAL0046: DbProf: Processing Times: Statement-0 StepId-0 FirstRead-2021-10-18 14:13:59.842216 LastRead-1970-01-01 00:00:00.000000 FirstWrite-2021-10-18 14:13:59.846430 LastWrite-2021-10-18 14:13:59.846441 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.846593 |103096|0|0| D 16 CAL0031: DbProf: End Step: Statement-0 StepId-0 BlockedFifoIn-0 BlockedFifoOut-0 MsgBytesIn-1652 MsgBytesOut-10227 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.851265 |103096|0|0| D 16 CAL0047: DbProf: Summary: Statement-0 MaxMemPct-0 TempFileCnt-0 TempFileSpace-0 PhysRead-0 CacheRead-68 MsgsRcvd-68 MsgBytesIn-1652 MsgBytesOut-10227 CPBlks-0 Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.851330 |103096|0|0| D 16 CAL0042: End SQL statement Oct 18 14:13:59 mariadb-x6-pm1 ExeMgr[29321]: 59.851458 |103096|0|0| D 16 CAL0029: DbProf: End Statement: Statement-0 Oct 18 14:14:46 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/8ab1ce79-5ed8-4dd8-b0a0-c492a461c114_5242880_3407872_data1~000.dir~000.dir~049.dir~229.dir~148.dir~FILE001.cdf Oct 18 14:14:46 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/8ab1ce79-5ed8-4dd8-b0a0-c492a461c114_5242880_3407872_data1~000.dir~000.dir~049.dir~229.dir~148.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:20:12 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/e5124a19-db8e-4bef-9fef-9343b49b8228_10485760_3737507_data1~systemFiles~dbrm~BRM_saves_journal Oct 18 15:20:12 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/e5124a19-db8e-4bef-9fef-9343b49b8228_10485760_3737507_data1~systemFiles~dbrm~BRM_saves_journal has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:41:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/4438c812-2db8-4a83-a597-e053c74c0d31_0_1286144_data1~000.dir~000.dir~049.dir~233.dir~149.dir~FILE001.cdf Oct 18 15:41:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/4438c812-2db8-4a83-a597-e053c74c0d31_0_1286144_data1~000.dir~000.dir~049.dir~233.dir~149.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:41:51 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/07816ad5-4a58-4e8f-af17-526adc9d8877_0_4489216_data1~000.dir~000.dir~050.dir~021.dir~149.dir~FILE001.cdf Oct 18 15:41:51 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/07816ad5-4a58-4e8f-af17-526adc9d8877_0_4489216_data1~000.dir~000.dir~050.dir~021.dir~149.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:48:45 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/3334bb72-a146-4813-9706-c0165ed487d0_0_2760704_data1~000.dir~000.dir~049.dir~232.dir~149.dir~FILE001.cdf Oct 18 15:48:45 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/3334bb72-a146-4813-9706-c0165ed487d0_0_2760704_data1~000.dir~000.dir~049.dir~232.dir~149.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:48:45 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/43411692-efec-4f21-b9d8-e97508bb995a_0_1712128_data1~000.dir~000.dir~049.dir~233.dir~149.dir~FILE001.cdf Oct 18 15:48:45 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/43411692-efec-4f21-b9d8-e97508bb995a_0_1712128_data1~000.dir~000.dir~049.dir~233.dir~149.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 15:49:04 mariadb-x6-pm1 writeenginesplit[12194]: 04.353345 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 15:54:10 mariadb-x6-pm1 writeengineserver[29341]: 10.887279 |0|0|0| D 32 CAL0000: 1240 : onReceiveEOD : child ID = 12229 Oct 18 15:54:48 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/8e71ebc1-37db-430e-a8b7-a6c4ae4606b1_0_4874240_data1~000.dir~000.dir~049.dir~229.dir~149.dir~FILE001.cdf Oct 18 15:54:48 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/8e71ebc1-37db-430e-a8b7-a6c4ae4606b1_0_4874240_data1~000.dir~000.dir~049.dir~229.dir~149.dir~FILE001.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 16:06:51 mariadb-x6-pm1 writeenginesplit[12194]: 51.964503 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 16:07:34 mariadb-x6-pm1 writeengineserver[29341]: 34.936353 |0|0|0| D 32 CAL0000: 1240 : Message Queue is empty; Stopping CF Thread Oct 18 16:17:33 mariadb-x6-pm1 cpimport.bin[12229]: 33.761390 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 26857196 rows inserted Oct 18 16:17:33 mariadb-x6-pm1 writeengine[12229]: 33.761438 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T133526_S288987_Job_12772.xml |For table reax6.bigsumplus: 26857196 rows processed and 26857196 rows inserted. Oct 18 16:17:33 mariadb-x6-pm1 cpimport.bin[12229]: 33.773091 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 16:17:33 mariadb-x6-pm1 writeengineserver[29341]: 33.781258 |0|0|0| I 32 CAL0000: 1240 : cpimport exit on success Oct 18 16:17:33 mariadb-x6-pm1 writeengineserver[29341]: 33.781486 |0|0|0| D 32 CAL0000: 1240 : onCpimportSuccess BrmReport Send Oct 18 16:17:33 mariadb-x6-pm1 writeenginesplit[12194]: 33.784070 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 16:18:01 mariadb-x6-pm1 writeengineserver[29341]: 01.128758 |0|0|0| D 32 CAL0000: 1240 : OnReceiveCleanup arrived Oct 18 16:18:01 mariadb-x6-pm1 writeenginesplit[12194]: 01.128761 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 16:18:02 mariadb-x6-pm1 writeenginesplit[12194]: 02.013884 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 16:18:02 mariadb-x6-pm1 dbcon[19032]: 02.274260 |102948|0|0| D 24 CAL0001: End SQL statement Oct 18 17:39:47 mariadb-x6-pm1 ExeMgr[29321]: 47.105620 |2147587581|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 17:39:47 mariadb-x6-pm1 ExeMgr[29321]: 47.121399 |2147587581|0|0| D 16 CAL0042: End SQL statement Oct 18 17:39:47 mariadb-x6-pm1 ExeMgr[29321]: 47.145123 |103933|0|0| D 16 CAL0041: Start SQL statement: select max(date) from bigsumplus; |reax6| Oct 18 17:40:03 mariadb-x6-pm1 ExeMgr[29321]: 03.762783 |103933|0|0| D 16 CAL0042: End SQL statement Oct 18 17:40:26 mariadb-x6-pm1 ExeMgr[29321]: 26.099330 |103933|0|0| D 16 CAL0041: Start SQL statement: select sum(served) from bigsumplus where date='2020-07-08'; |reax6| Oct 18 17:40:26 mariadb-x6-pm1 ExeMgr[29321]: 26.632618 |103933|0|0| D 16 CAL0042: End SQL statement Oct 18 17:47:22 mariadb-x6-pm1 ExeMgr[29321]: 22.862499 |2147587615|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 17:47:22 mariadb-x6-pm1 ExeMgr[29321]: 22.876880 |2147587615|0|0| D 16 CAL0042: End SQL statement Oct 18 17:47:22 mariadb-x6-pm1 dbcon[19032]: 22.879618 |103967|0|0| D 24 CAL0001: Start SQL statement: LOAD DATA LOCAL INFILE '/db_storage/dumps/reax6/rea_bigsumplus_20200709000000.txt' into table bigsumplus FIELDS TERMINATED BY ',' (served,clicked,acted,viewed,date,flight_id,flight_creative_id,site,area,geo_country,geo_region,geo_city,sub,state,proptype,price,pos,platform,segment,posttags,region,language,dev_type,dev_os,dev_browser_name,pcode,bedmax,bedmin,beds,clientsite,adtype,cat,hb_pb,hb,creative_id,size_id,campaign_id,product_id,tier_id,flight_type_id,advertiser_id,agency_id,trafficker_id,salesperson_id,exposure_policy_id,region_id,industry_id,team_id); |reax6| Oct 18 17:47:22 mariadb-x6-pm1 ExeMgr[29321]: 22.890583 |2147587615|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='reax6' and tablename='bigsumplus' --tableRID/; || Oct 18 17:47:22 mariadb-x6-pm1 ExeMgr[29321]: 22.897691 |2147587615|0|0| D 16 CAL0042: End SQL statement Oct 18 17:47:23 mariadb-x6-pm1 writeengineserver[29341]: 23.445381 |0|0|0| D 32 CAL0000: 2259 : onReceiveMode() Setting fMode = 1 Oct 18 17:47:23 mariadb-x6-pm1 writeengineserver[29341]: 23.445496 |0|0|0| D 32 CAL0000: 2259 : onReceiveMode() DbRoot Count = 1 Oct 18 17:47:23 mariadb-x6-pm1 writeengineserver[29341]: 23.445558 |0|0|0| D 32 CAL0000: 2259 : CMD LINE ARGS came in /usr/bin/cpimport.bin -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091817472330102.rpt -m 1 -P pm1-30102 -T SYSTEM -u06875367-963f-4e2b-920c-b478eca191a6 reax6 bigsumplus Oct 18 17:47:23 mariadb-x6-pm1 writeengineserver[29341]: 23.445607 |0|0|0| D 32 CAL0000: 2259 : Brm Rpt Filename Arrived /tmp/columnstore_tmp_files/BrmRpt091817472330102.rpt Oct 18 17:47:23 mariadb-x6-pm1 writeengineserver[29341]: 23.445738 |0|0|0| D 32 CAL0000: 2259 : Start Cpimport command reached!! Oct 18 17:47:23 mariadb-x6-pm1 cpimport.bin[30138]: 23.473794 |0|0|0| I 34 CAL0086: Initiating BulkLoad: -L /var/log/mariadb/columnstore/cpimport/ -e 0 -s #007 -E #021 -R /tmp/columnstore_tmp_files/BrmRpt091817472330102.rpt -m 1 -P pm1-30102 -T SYSTEM -u06875367-963f-4e2b-920c-b478eca191a6 reax6 bigsumplus Oct 18 17:47:23 mariadb-x6-pm1 IDBFile[30138]: 23.475725 |0|0|0| D 35 CAL0002: IDBFactory::installPlugin: installed filesystem plugin libcloudio.so Oct 18 17:47:23 mariadb-x6-pm1 cpimport.bin[30138]: 23.541994 |0|0|0| I 34 CAL0081: Start BulkLoad: JobId-12772; db-reax6 Oct 18 18:27:30 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/559a05c5-d34e-4d08-9552-d71179904486_0_1105920_data1~000.dir~000.dir~049.dir~229.dir~150.dir~FILE002.cdf Oct 18 18:27:30 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/559a05c5-d34e-4d08-9552-d71179904486_0_1105920_data1~000.dir~000.dir~049.dir~229.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 18:27:30 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/8b918a56-5dfb-48be-8594-2402ed6726da_0_696320_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf Oct 18 18:27:30 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/8b918a56-5dfb-48be-8594-2402ed6726da_0_696320_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 18:50:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/30d4591e-743d-4b35-a089-17c4ea6d3d4c_0_3432448_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf Oct 18 18:50:39 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/30d4591e-743d-4b35-a089-17c4ea6d3d4c_0_3432448_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 18:50:47 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/69ecacc9-e970-43d5-a2a9-60ba44914228_0_2138112_data1~000.dir~000.dir~049.dir~233.dir~150.dir~FILE002.cdf Oct 18 18:50:47 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/69ecacc9-e970-43d5-a2a9-60ba44914228_0_2138112_data1~000.dir~000.dir~049.dir~233.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 18:51:24 mariadb-x6-pm1 StorageManager[29081]: S3Storage::deleteObject(): failed to DELETE, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/7e01870c-8850-4957-b872-a454596d6d1b_0_4284416_data1~000.dir~000.dir~050.dir~013.dir~150.dir~FILE002.cdf. Retrying... Oct 18 18:51:24 mariadb-x6-pm1 StorageManager[29081]: S3Storage::putObject(): failed to PUT, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/e5a651cf-d012-492e-b018-f918d63a458d_0_5242880_data1~000.dir~000.dir~050.dir~011.dir~150.dir~FILE002.cdf. Retrying... Oct 18 18:51:24 mariadb-x6-pm1 StorageManager[29081]: S3Storage::putObject(): failed to PUT, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/c6efd755-2dfa-4159-b5f6-2710221ca97c_5242880_3743744_data1~000.dir~000.dir~050.dir~009.dir~150.dir~FILE002.cdf. Retrying... Oct 18 18:51:24 mariadb-x6-pm1 StorageManager[29081]: S3Storage::deleteObject(): failed to DELETE, server says 'The provided token has expired.'. bucket = mariadb-prod-140646907601-us-west-2, key = x6/80eeee0f-e3a2-42a9-966a-e309ff83ce53_5242880_2662400_data1~000.dir~000.dir~050.dir~010.dir~150.dir~FILE002.cdf. Retrying... Oct 18 19:10:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/de29c4f2-3257-484b-b684-c3b452a4bde3_10485760_3796492_data1~systemFiles~dbrm~BRM_saves_journal Oct 18 19:10:32 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/de29c4f2-3257-484b-b684-c3b452a4bde3_10485760_3796492_data1~systemFiles~dbrm~BRM_saves_journal has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 19:11:05 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/a9af7629-9a82-4841-93b4-d06c961268e3_0_5242880_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf Oct 18 19:11:05 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/a9af7629-9a82-4841-93b4-d06c961268e3_0_5242880_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 19:37:51 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/b05daa83-f679-493b-9c13-6f0122ddd30b_5242880_2310144_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf Oct 18 19:37:51 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/b05daa83-f679-493b-9c13-6f0122ddd30b_5242880_2310144_data1~000.dir~000.dir~049.dir~232.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 19:38:09 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/20361600-5515-4c2f-bbad-89f9c1373dfa_10485760_1572864_data1~000.dir~000.dir~049.dir~229.dir~150.dir~FILE002.cdf Oct 18 19:38:09 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/20361600-5515-4c2f-bbad-89f9c1373dfa_10485760_1572864_data1~000.dir~000.dir~049.dir~229.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 20:05:32 mariadb-x6-pm1 writeenginesplit[30102]: 32.359197 |0|0|0| I 33 CAL0000: Send EOD message to All PMs Oct 18 20:05:32 mariadb-x6-pm1 writeengineserver[29341]: 32.362490 |0|0|0| D 32 CAL0000: 2259 : onReceiveEOD : child ID = 30138 Oct 18 20:17:16 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): no journal file found for data1/335dd7cb-4b49-4f87-b4fd-7e06e4312e14_0_3809280_data1~000.dir~000.dir~050.dir~005.dir~150.dir~FILE002.cdf Oct 18 20:17:16 mariadb-x6-pm1 StorageManager[29081]: synchronizeWithJournal(): data1/335dd7cb-4b49-4f87-b4fd-7e06e4312e14_0_3809280_data1~000.dir~000.dir~050.dir~005.dir~150.dir~FILE002.cdf has no journal, but it does exist in the cloud. This indicates that an overlapping syncWithJournal() call handled it properly. Oct 18 20:18:53 mariadb-x6-pm1 writeenginesplit[30102]: 53.648298 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM2. Oct 18 20:26:12 mariadb-x6-pm1 writeengineserver[29341]: 12.428500 |0|0|0| D 32 CAL0000: 2259 : Message Queue is empty; Stopping CF Thread Oct 18 20:28:05 mariadb-x6-pm1 writeenginesplit[30102]: 05.898216 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM3. Oct 18 20:28:50 mariadb-x6-pm1 cpimport.bin[30138]: 50.779944 |0|0|0| I 34 CAL0083: BulkLoad: JobId-12772; finished loading table reax6.bigsumplus; 27560000 rows inserted Oct 18 20:28:50 mariadb-x6-pm1 writeengine[30138]: 50.779993 |0|0|0| I 19 CAL0008: Bulkload |Job: /var/log/mariadb/columnstore/data/bulk/tmpjob/12772_D20211018_T174723_S517491_Job_12772.xml |For table reax6.bigsumplus: 27560000 rows processed and 27560000 rows inserted. Oct 18 20:28:50 mariadb-x6-pm1 cpimport.bin[30138]: 50.789853 |0|0|0| I 34 CAL0082: End BulkLoad: JobId-12772; status-SUCCESS Oct 18 20:28:50 mariadb-x6-pm1 writeengineserver[29341]: 50.798301 |0|0|0| I 32 CAL0000: 2259 : cpimport exit on success Oct 18 20:28:50 mariadb-x6-pm1 writeengineserver[29341]: 50.798545 |0|0|0| D 32 CAL0000: 2259 : onCpimportSuccess BrmReport Send Oct 18 20:28:51 mariadb-x6-pm1 writeenginesplit[30102]: 51.460960 |0|0|0| I 33 CAL0098: Received a Cpimport Pass from PM1. Oct 18 20:28:51 mariadb-x6-pm1 writeengineserver[29341]: 51.460987 |0|0|0| D 32 CAL0000: 2259 : OnReceiveCleanup arrived Oct 18 20:28:52 mariadb-x6-pm1 writeenginesplit[30102]: 52.467636 |0|0|0| I 33 CAL0000: Released Table Lock Oct 18 20:28:53 mariadb-x6-pm1 dbcon[19032]: 53.617388 |103967|0|0| D 24 CAL0001: End SQL statement Oct 18 21:44:01 mariadb-x6-pm1 ExeMgr[29321]: 01.839736 |2147588670|0|0| D 16 CAL0041: Start SQL statement: select objectid,columnname from syscolumn where schema='reax6' and tablename='bigsumplus' --columnRIDs/FE; || Oct 18 21:44:01 mariadb-x6-pm1 ExeMgr[29321]: 01.853726 |2147588670|0|0| D 16 CAL0042: End SQL statement Oct 18 21:44:01 mariadb-x6-pm1 ExeMgr[29321]: 01.875448 |105022|0|0| D 16 CAL0041: Start SQL statement: select max(date) from bigsumplus; |reax6| Oct 18 21:44:18 mariadb-x6-pm1 ExeMgr[29321]: 18.655975 |105022|0|0| D 16 CAL0042: End SQL statement Oct 18 21:44:32 mariadb-x6-pm1 ExeMgr[29321]: 32.142344 |105022|0|0| D 16 CAL0041: Start SQL statement: select sum(served) from bigsumplus where date='2020-07-09'; |reax6| Oct 18 21:44:32 mariadb-x6-pm1 ExeMgr[29321]: 32.685224 |105022|0|0| D 16 CAL0042: End SQL statement