/usr/sbin/mariadbd, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument # Time: 210618 0:06:40 # User@Host: observium[observium] @ rantanplan-ng.lan.zetescards.be [192.168.1.5] # Thread_id: 7792234 Schema: observium QC_hit: No # Query_time: 38.760562 Lock_time: 0.000144 Rows_sent: 0 Rows_examined: 40 # Rows_affected: 40 Bytes_sent: 11 use observium; SET timestamp=1623967600; DELETE FROM `vlans_fdb` WHERE `fdb_id` IN ('321653398','321655519','321655543','321655546','321655549','321655552','321655555','321655558','321655561','321655564','321655567','321655570','321655573','321655576','321655579','321650875','321653431','321651889','321653389','321655489','321655498','321655504','321655507','321650896','321651940','321655585','321655588','321655591','321655594','321655597','321655600','321655606','321653422','321655522','321655525','321655528','321655531','321655537','321655615','321651916'); # User@Host: bus-bi[bus-bi] @ [192.168.5.22] # Thread_id: 7770110 Schema: bus-bi QC_hit: No # Query_time: 38.704625 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 # Rows_affected: 0 Bytes_sent: 11 use bus-bi; SET timestamp=1623967600; commit; # User@Host: observium[observium] @ rantanplan-ng.lan.zetescards.be [192.168.1.5] # Thread_id: 7792254 Schema: observium QC_hit: No # Query_time: 38.587153 Lock_time: 0.000036 Rows_sent: 0 Rows_examined: 1 # Rows_affected: 1 Bytes_sent: 52 use observium; SET timestamp=1623967600; UPDATE `snmp_errors` set `error_count` ='254645',`updated` ='1623967562' WHERE `error_id` = '347'; # Time: 210618 0:06:41 # User@Host: observium[observium] @ rantanplan-ng.lan.zetescards.be [192.168.1.5] # Thread_id: 7792237 Schema: observium QC_hit: No # Query_time: 38.903134 Lock_time: 0.000087 Rows_sent: 0 Rows_examined: 25 # Rows_affected: 25 Bytes_sent: 11 SET timestamp=1623967601; DELETE FROM `vlans_fdb` WHERE `fdb_id` IN ('321653638','321653578','321653581','321655264','321652414','321653587','321655270','321653620','321653623','321655309','321655312','321653629','321655315','321655321','321653641','321653644','321651016','321653653','321655363','321655369','321652495','321653665','321653668','321653599','321653602'); # User@Host: observium[observium] @ rantanplan-ng.lan.zetescards.be [192.168.1.5] # Thread_id: 7791266 Schema: observium QC_hit: No # Query_time: 37.966236 Lock_time: 0.000101 Rows_sent: 0 Rows_examined: 1 # Rows_affected: 1 Bytes_sent: 52 SET timestamp=1623967601; UPDATE `vlans_fdb` set `port_id` ='2183' WHERE `fdb_id` = '321653932'; # Time: 210618 0:06:46 # User@Host: sentry[sentry] @ sentry.lan.zetescards.be [192.168.1.11] # Thread_id: 7792340 Schema: sentry QC_hit: No # Query_time: 13.052916 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0 # Rows_affected: 0 Bytes_sent: 11 use sentry; SET timestamp=1623967606; commit; # Time: 210618 7:02:00 # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7855252 Schema: bi_mart QC_hit: No # Query_time: 113.756500 Lock_time: 0.000956 Rows_sent: 12297876294969152853 Rows_examined: 87202 # Rows_affected: 4114 Bytes_sent: 532694 use bi_mart; SET timestamp=1623992520; SELECT H_Request_ID, CustomerRequestID, ifnull(ContainerReception,CustomerRequestCreation) as ContainerReception, -- lastState, -- CASE WHEN lastState in ('EID.mailingPrep','EID.mailing','EID.qaMailing','EID.depositRequest','EID.rn.puks','EID.preshippingPinpuk','EID.shippingPinpuk') then 'EID.finished' -- ELSE lastState -- END as card_lastState, ifnull(Card_LastState,if(lastState in ('PROCESSING_IMAGE','RNREPLY'),'EID.imageprocessing',lastState)) as card_lastState, -- CASE WHEN lastState in ('EID.mailingPrep','EID.mailing','EID.qaMailing','EID.depositRequest','EID.rn.puks','EID.preshippingPinpuk','EID.shippingPinpuk') then lastState -- WHEN lastState='EID.finished' then 'EID.finished' -- ELSE 'N/A' -- END as pinpuk_lastState, ifnull(PinPuk_LastState,'N/A') as pinpuk_lastState, emissionNis, emissionMunicipality, CASE WHEN deliveryMode='CentralisedDelivery' THEN 'ZetesExpress' WHEN deliveryMode='CivilOfficer' THEN 'Municipality' ELSE deliveryMode END as deliveryMode, -- if(pinpukPreship is null, 'N/A',bi_mart.days_between_statuses(ContainerReception,ifnull(Delivered,now()))) as elapsed_wdays, if(Preshipping is null, 'N/A',if(bi_mart.days_between_statuses(ContainerReception,Preshipping)<1,1,bi_mart.days_between_statuses(ContainerReception,Preshipping))) as elapsed_wdays, SUBSTR(NationalNumber,2) as NationalNumber, if(ProductRequested='KIDS','Kid','EID') as ProductRequested, isUrgent, case when isUrgent='urgent' then bi_mart.deliveryDeadLine(ContainerReception_SLA,2) when isUrgent='very urgent' and deliveryMode='CentralisedDelivery' and weekday(ContainerReception_SLA)=4 then DATE_ADD(ContainerReception_SLA,INTERVAL 1 DAY) when isUrgent='very urgent' then bi_mart.deliveryDeadLine(ContainerReception_SLA,1) when isUrgent='normal' then bi_mart.deliveryDeadLine(ContainerReception_SLA,5) end as due_delivery_date, case when ProductUrgency='U' and RequestType='DOCE' and DeliveryMode='CentralisedDelivery' then 'UEZR' when ProductUrgency='U' and RequestType='DOCE' and DeliveryMode='CivilOfficer' then 'UEC' when ProductUrgency='U' and RequestType='DOCE' and DeliveryMode='ZetesExpress' then 'UEZN' when ProductUrgency='V' and RequestType='DOCE' and DeliveryMode='CentralisedDelivery' then 'VEZR' -- when ProductUrgency='V' and RequestType='DOCE' and DeliveryMode='CivilOfficer' then 'VECR' when ProductUrgency='V' and RequestType='DOCE' and DeliveryMode='CivilOfficer' then 'VEC' when ProductUrgency='V' and RequestType='DOCE' and DeliveryMode='ZetesExpress' then 'VEZN' end as invoice_category, ifnull(Card_Container_Out,'N/A') as Card_Container_Out, Card_ContainerOutType, ifnull(PinPuk_Container_Out,'N/A') as PinPuk_Container_Out, PinPuk_ContainerOutType, Delivered, Preshipping, replace(Container_In,'.ok','.xml') as Container_In, if(ContainerInType='DOCE','DocE',ContainerInType) as ContainerInType FROM bi_mart.fact_eid_request_snapshot where isUrgent in ('urgent','very urgent') and ContainerReception between concat('2021-06-04 00:00:00',' 00:00:00') and concat(date('2021-06-17 23:59:59'),' 15:45:00') and DeliveryMode in ('ZetesExpress','CentralisedDelivery','CivilOfficer') and RequestRejected!='True' order by ContainerReception desc; # Time: 210618 7:09:08 # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7855748 Schema: bi_mart QC_hit: No # Query_time: 342.823490 Lock_time: 0.003720 Rows_sent: 2 Rows_examined: 9290 # Rows_affected: 17060 Bytes_sent: 186 SET timestamp=1623992948; SELECT if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState , min(days_between_statuses(snap.ContainerReception,now())) as days_status , count(*) as amount FROM fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState != 'CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState -- group by lastState,LastStatus order by days_status,new_lastState; # Time: 210618 7:09:16 # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7855752 Schema: bi_mart QC_hit: No # Query_time: 350.574689 Lock_time: 0.034299 Rows_sent: 5 Rows_examined: 9296 # Rows_affected: 17070 Bytes_sent: 268 SET timestamp=1623992956; SELECT bi_mart.days_between_statuses(snap.ContainerReception,now()) as days_status, if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState, count(*) FROM bi_mart.fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState!='CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState,days_status -- group by lastState,LastStatus,days_status order by days_status,lastStatus asc; # Time: 210618 7:39:36 # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7861108 Schema: bi_mart QC_hit: No # Query_time: 70.399003 Lock_time: 0.001330 Rows_sent: 2 Rows_examined: 9290 # Rows_affected: 17060 Bytes_sent: 186 SET timestamp=1623994776; SELECT if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState , min(days_between_statuses(snap.ContainerReception,now())) as days_status , count(*) as amount FROM fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState != 'CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState -- group by lastState,LastStatus order by days_status,new_lastState; # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7861112 Schema: bi_mart QC_hit: No # Query_time: 69.368783 Lock_time: 0.045388 Rows_sent: 5 Rows_examined: 9296 # Rows_affected: 17070 Bytes_sent: 268 SET timestamp=1623994776; SELECT bi_mart.days_between_statuses(snap.ContainerReception,now()) as days_status, if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState, count(*) FROM bi_mart.fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState!='CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState,days_status -- group by lastState,LastStatus,days_status order by days_status,lastStatus asc; # Time: 210618 7:46:57 # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7862395 Schema: bi_mart QC_hit: No # Query_time: 11.050517 Lock_time: 0.001743 Rows_sent: 2 Rows_examined: 9290 # Rows_affected: 17060 Bytes_sent: 186 SET timestamp=1623995217; SELECT if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState , min(days_between_statuses(snap.ContainerReception,now())) as days_status , count(*) as amount FROM fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState != 'CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState -- group by lastState,LastStatus order by days_status,new_lastState; # User@Host: bi-data[bi-data] @ ru-zsc-001-049.lan.zetescards.be [192.168.1.49] # Thread_id: 7862400 Schema: bi_mart QC_hit: No # Query_time: 10.035156 Lock_time: 0.029664 Rows_sent: 5 Rows_examined: 9296 # Rows_affected: 17070 Bytes_sent: 268 SET timestamp=1623995217; SELECT bi_mart.days_between_statuses(snap.ContainerReception,now()) as days_status, if(lastState='PROCESSING_IMAGE',concat('Rendering','-', lastStatus) ,if(lastState='RNREPLY' and RNREPLY is not null,concat(lastState,'-', 'RECEIVED') ,concat(lastState,'-', lastStatus)))as new_LastState, count(*) FROM bi_mart.fact_eid_request_snapshot snap where CardCreation is null and Finished is null and (RequestRejected= 'False' or RequestRejected is null) and lastState!='CardCreation' and lastState!='EID.cancel' and isUrgent in ('normal','urgent','very urgent') and ProductRequested in ('EID','NEU','EU','KIDS') group by new_lastState,days_status -- group by lastState,LastStatus,days_status order by days_status,lastStatus asc; /usr/sbin/mysqld, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mariadbd, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mysqld, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument /usr/sbin/mariadbd, Version: 10.5.10-MariaDB-1:10.5.10+maria~buster-log (mariadb.org binary distribution). started with: Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock Time Id Command Argument