python /home/admin/mtr/script_for_cron.py -j default -m 30 -a 'python3 ~/workarea/git/Velours/python/mtr/sql_queries.py -j status ' -s monitor_queries -M 0 -S 0 -U 120,120,120 import MySQLdb succeeded Now: 25/09/2025, 07:00:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-09-25 07:00:25', 300) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-09-25 07:00:25', 504857) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-09-25 07:02:19', 46820) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-09-25 07:02:19', 6716) Reste a faire par datou id ('date', 'datou_id', 'total_a_traiter', 'total_traite', 'restant_a_traite', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids') ('2025-09-25 07:02:28', 4311, 1970, 100, 1870, 'sts_dechet_valcor_matching_v2_2022Q3', 1.0, '27163646:dechet_val:991:1', 1) ('2025-09-25 07:02:28', 4220, 1916, 100, 1816, 'split_time_score_plaque_Valcor', 0.0, '27161795:plaque_val:1064:1', 1) ('2025-09-25 07:02:28', 4302, 2038, 1031, 1007, 'RUBBIA_JRM_consolidate', 8.0625, '27194813:JRM_diff_b:979:0,27185669:JRM_diff_b:979:0,27215298:JRM_diff_b:979:0,27214767:JRM_diff_b:979:0,27214162:JRM_diff_b:979:0,27213754:JRM_diff_b:979:0,27213611:JRM_diff_b:979:0,27212811:JRM_diff_b:979:0,27210979:JRM_diff_b:979:0,27210176:JRM_diff_b:979:0,27208185:JRM_diff_b:979:0,27187666:JRM_diff_b:979:0,27207086:JRM_diff_b:979:0,27206819:JRM_diff_b:979:0,27205881:JRM_diff_b:979:0,27188185:JRM_diff_b:979:0,27203364:JRM_diff_b:979:0,27195938:JRM_diff_b:979:0,27194049:JRM_diff_b:979:0,27195747:JRM_diff_b:979:0,27197291:JRM_diff_b:979:0,27197935:JRM_diff_b:979:0,27198603:JRM_diff_b:979:0,27192367:JRM_diff_b:979:0,27189052:JRM_diff_b:979:0,27200240:JRM_diff_b:979:0,27200738:JRM_diff_b:979:0,27201820:JRM_diff_b:979:0,27188920:JRM_diff_b:979:0,27202245:JRM_diff_b:979:0,27194252:JRM_diff_b:979:0,27203250:JRM_diff_b:979:0', 32) ('2025-09-25 07:02:28', 4219, 1931, 1111, 820, 'detection_plaque_valcor_010622', 16.0, '27208264:plaque_val:1064:1,27161795:plaque_val:1064:0', 2) ('2025-09-25 07:02:28', 3993, 1149, 592, 557, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 15.764705882352942, '27207529:pcnc_diff_:1042:0,27194367:gros_carto:979:0,27196328:emr_diff_b:979:0,27193334:emr_diff_b:979:0,27193187:pcnc_diff_:1042:0,27193185:pcnc_diff_:1042:0,27198821:emr_diff_b:979:0,27191034:pcnc_diff_:1042:0,27189672:emr_diff_b:979:0,27199569:emr_diff_b:1017:0,27202044:emr_diff_b:979:0,27188874:emr_diff_b:979:0,27187466:emr_diff_b:979:0,27176477:pcnc_diff_:1042:0,27170772:pcnc_diff_:1042:0,27148876:pcnc_diff_:1042:0,27144382:pcnc_diff_:1042:0', 17) ('2025-09-25 07:02:28', 533, 4648, 4369, 279, 'multi_classification_tapis_dechet', 1195.0, '24113525:jetson_tes:979:0,27205437:jetson_tes:979:0', 2) ('2025-09-25 07:02:28', 4892, 4463, 4278, 185, 'multi_classification_tapis_dechet', 7.0, '27205487:angers_mon:1017:1,27205485:Sevran_302:1042:1', 2) ('2025-09-25 07:02:28', 4433, 162, 45, 117, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 21.0, '27177985:JRM_diff_b:1053:0,27172550:JRM_diff_b:1053:0', 2) ('2025-09-25 07:02:28', 4310, 609, 559, 50, 'classifieur_2camions_valcor_021122_v1', 3.0, '27211885:dechet_val:991:1', 1) ('2025-09-25 07:02:28', 4877, 42, 27, 15, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '27214553:JRM_diff_b:979:0,27214716:JRM_diff_b:979:0,27214416:JRM_diff_b:979:0,27214934:JRM_diff_b:979:0,27215056:JRM_diff_b:979:0,27215203:JRM_diff_b:979:1,27214098:JRM_diff_b:979:0', 7) ('2025-09-25 07:02:28', 4871, 1359, 1348, 11, 'blur_rubbia_live', 7.0, '27205436:arc_en_cie:979:0', 1) ('2025-09-25 07:02:28', 4234, 7, 7, 0, 'refus_rym_velours_valcor', 0.0, '27215461:incinerati:1103:1,27215459:incinerati:1103:1,27215460:incinerati:1103:1', 3) Reste a faire par datou id non traite ('date', 'datou_id', 'total_a_traiter', 'datou_nom', 'temps moyens passe des datous a traiter (heures)', 'list_port_ids_mtr_user_ids', 'nb_port') ('2025-09-25 07:02:33', 3318, 155, 'RUBBIA_Refus_mask_simple_non_aussi_rle', Decimal('12.6194'), '27188052:refus_diff:1017:0,27193183:refus_diff:1042:0,27193184:refus_diff:1042:0,27193186:refus_diff:1042:0,27195478:refus_diff:1042:0,27198551:refus_diff:1017:0', 6) ('2025-09-25 07:02:33', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('4251.0000'), '4453926:jrm_diff_b:739:0,4652336:jrm_diff_b:739:0,4756245:jrm_diff_b:739:0,4938484:jrm_diff_b:739:0,4938485:jrm_diff_b:739:0,4938486:jrm_diff_b:739:0,4938487:jrm_diff_b:739:0,4938488:jrm_diff_b:739:0', 8) ('2025-09-25 07:02:33', 3991, 54, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('12.8889'), '27188073:ela_diff_b:1017:0,27188389:ela_diff_b:979:0,27199570:ela_diff_b:1017:0', 3) ('2025-09-25 07:02:33', 3992, 13, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('14.6923'), '27185119:aluminium_:1017:0,27193937:aluminium_:979:0', 2) ('2025-09-25 07:02:33', 3993, 1079, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('12.3272'), '27187442:gros_carto:979:0,27187974:pcnc_diff_:1042:0,27188050:emr_diff_b:1017:0,27191007:pcnc_diff_:1042:0,27191021:pcnc_diff_:1042:0,27191994:emr_diff_b:1017:0,27195433:emr_diff_b:1017:0,27195475:pcnc_diff_:1042:0,27195479:pcnc_diff_:1042:0,27195483:pcnc_diff_:1042:0,27195485:pcnc_diff_:1042:0,27196846:gros_carto:979:0,27198548:emr_diff_b:1017:0,27199453:gros_carto:979:0,27201083:emr_diff_b:979:0,27202125:emr_diff_b:1017:0,27203148:emr_diff_b:979:0,27207528:pcnc_diff_:1042:0', 18) ('2025-09-25 07:02:33', 4220, 1931, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '27161795:plaque_val:1064:1,27208264:plaque_val:1064:0', 2) ('2025-09-25 07:02:33', 4249, 15, 'pcm_prod_consolidate', Decimal('16.0000'), '25196475:gros_carto:879:0', 1) ('2025-09-25 07:02:33', 4250, 38, 'pcnc_prod_consolidate', Decimal('15.4737'), '25197463:emr_diff_b:879:0,25206525:emr_diff_b:879:0,25277268:emr_diff_b:879:0,25312500:emr_diff_b:879:0', 4) ('2025-09-25 07:02:33', 4253, 4, 'alu_prod_consolidate', Decimal('16.0000'), '24882020:aluminium_:879:0', 1) ('2025-09-25 07:02:33', 4254, 4, 'pet_fonce_prod_consolidate', Decimal('15.0000'), '25322415:flux_dev_r:879:0', 1) ('2025-09-25 07:02:33', 4255, 20, 'pet_clair_prod_consolidate', Decimal('15.0000'), '25182954:pet_clair_:879:0', 1) ('2025-09-25 07:02:33', 4302, 8014, 'RUBBIA_JRM_consolidate', Decimal('2.8030'), '27157934:JRM_diff_b:979:0,27158394:JRM_diff_b:979:0,27159432:JRM_diff_b:979:0,27159737:JRM_diff_b:979:0,27159952:JRM_diff_b:979:0,27160497:JRM_diff_b:979:0,27161026:JRM_diff_b:979:0,27161258:JRM_diff_b:979:0,27161452:JRM_diff_b:979:0,27162018:JRM_diff_b:979:0,27162727:JRM_diff_b:979:0,27163295:JRM_diff_b:979:0,27163672:JRM_diff_b:979:0,27164996:JRM_diff_b:979:0,27165112:JRM_diff_b:979:0,27165465:JRM_diff_b:979:0,27165875:JRM_diff_b:979:0,27166222:JRM_diff_b:979:0,27166853:JRM_diff_b:979:0,27167244:JRM_diff_b:979:0,27167611:JRM_diff_b:979:0,27168053:JRM_diff_b:979:0,27168812:JRM_diff_b:979:0,27169483:JRM_diff_b:979:0,27170152:JRM_diff_b:979:0,27170879:JRM_diff_b:979:0,27171511:JRM_diff_b:979:0,27172142:JRM_diff_b:979:0,27172832:JRM_diff_b:979:0,27174974:JRM_diff_b:979:0,27175470:JRM_diff_b:979:0,27176581:JRM_diff_b:979:0,27177326:JRM_diff_b:979:0,27178081:JRM_diff_b:979:0,27178770:JRM_diff_b:979:0,27179868:JRM_diff_b:979:0,27180659:JRM_diff_b:979:0,27181251:JRM_diff_b:979:0,27181921:JRM_diff_b:979:0,27182639:J', 104) ('2025-09-25 07:02:33', 4311, 2579, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('0.7639'), '27163646:dechet_val:991:1,27211885:dechet_val:991:0', 2) ('2025-09-25 07:02:33', 4323, 740, 'split_time_score_arc_en_ciel_mm', Decimal('0.0000'), '27205437:jetson_tes:979:1', 1) ('2025-09-25 07:02:33', 4433, 197, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('13.0000'), '27193431:JRM_diff_b:1053:0,27193432:JRM_diff_b:1053:0,27193433:JRM_diff_b:1053:0,27193435:JRM_diff_b:1053:0', 4) ('2025-09-25 07:02:33', 4748, 16, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('12.6250'), '27189272:flux_dev_r:979:0,27194597:flux_dev_r:979:0,27198460:flux_dev_r:979:0', 3) ('2025-09-25 07:02:33', 4876, 4892, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('7.0000'), '27157133:arc_en_cie:979:0', 1) ('2025-09-25 07:02:33', 4877, 117, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '27214098:JRM_diff_b:979:0,27214416:JRM_diff_b:979:0,27214553:JRM_diff_b:979:0,27214716:JRM_diff_b:979:0,27214934:JRM_diff_b:979:0,27215056:JRM_diff_b:979:0,27215392:JRM_diff_b:979:0,27215394:JRM_diff_b:979:0,27215396:JRM_diff_b:979:0,27215397:JRM_diff_b:979:0,27215398:JRM_diff_b:979:0,27215399:JRM_diff_b:979:0,27215400:JRM_diff_b:979:0,27215401:JRM_diff_b:979:0,27215403:JRM_diff_b:979:0,27215404:JRM_diff_b:979:0,27215417:JRM_diff_b:979:0,27215430:JRM_diff_b:979:0,27215443:JRM_diff_b:979:0,27215456:JRM_diff_b:979:0,27215457:JRM_diff_b:979:0,27215458:JRM_diff_b:979:0,27215462:JRM_diff_b:979:0,27215463:JRM_diff_b:979:0,27215464:JRM_diff_b:979:0,27215465:JRM_diff_b:979:0', 26) ('2025-09-25 07:02:33', 4878, 4892, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '27157133:arc_en_cie:979:0', 1) ('2025-09-25 07:02:33', 4883, 1359, 'split_time_score_JRM_Arc_En_Ciel', Decimal('0.0000'), '27205436:arc_en_cie:979:0', 1) ('2025-09-25 07:02:33', 4887, 2119, 'split_time_score_Sevran_test', Decimal('0.0000'), '27205485:Sevran_302:1042:0', 1) ('2025-09-25 07:02:33', 4891, 10402, 'split_time_score_angers_montee_convoyeur', Decimal('0.0000'), '27157146:angers_mon:1017:0,27205487:angers_mon:1017:0', 2) ('2025-09-25 07:02:33', 4935, 6251, 'split_time_score_JRM_Arc_En_Ciel_merge', Decimal('5.4782'), '27157133:arc_en_cie:979:0,27205436:arc_en_cie:979:0', 2) ('2025-09-25 07:02:33', 4949, 525, 'blur_detection_test_ken', Decimal('2150.0000'), '24359416:jetson_tes:1110:0', 1) Nombre de photos d'entrees traites par datou dans les dernieres 24 heures pour les traitement (datou_current) en cours ('date', 'datou_id', 'Nombre de photos traitees', 'datou_nom') ('2025-09-25 07:02:33', 3993, 2288, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-09-25 07:02:33', 4219, 2212, 'detection_plaque_valcor_010622') ('2025-09-25 07:02:33', 4220, 100, 'split_time_score_plaque_Valcor') ('2025-09-25 07:02:33', 4311, 100, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-09-25 07:02:33', 4433, 405, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-25 07:02:33', 4302, 4124, 'RUBBIA_JRM_consolidate') ('2025-09-25 07:02:33', 4871, 1348, 'blur_rubbia_live') ('2025-09-25 07:02:33', 533, 2199, 'multi_classification_tapis_dechet') ('2025-09-25 07:02:33', 4892, 11680, 'multi_classification_tapis_dechet') ('2025-09-25 07:02:33', 4310, 1376, 'classifieur_2camions_valcor_021122_v1') ('2025-09-25 07:02:33', 4877, 188, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-09-25 07:02:33', 4234, 7, 'refus_rym_velours_valcor') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 13) (0, 287) (-5, 10) Nombre de resultats de type photos par datou dans les dernieres 24 heures (plusieurs photos de sorties par photos d'entree) ('date', 'datou_id', 'Nombre de photos traitees', 'datou_nom') ('2025-09-25 07:02:34', 4234, 172811, 'refus_rym_velours_valcor') ('2025-09-25 07:02:34', 4892, 43183, 'multi_classification_tapis_dechet') ('2025-09-25 07:02:34', 4876, 40555, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-09-25 07:02:34', 4935, 37058, 'split_time_score_JRM_Arc_En_Ciel_merge') ('2025-09-25 07:02:34', 4883, 37005, 'split_time_score_JRM_Arc_En_Ciel') ('2025-09-25 07:02:34', 4877, 35938, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-09-25 07:02:34', 4323, 19860, 'split_time_score_arc_en_ciel_mm') ('2025-09-25 07:02:34', 3804, 15419, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-09-25 07:02:34', 4302, 15416, 'RUBBIA_JRM_consolidate') ('2025-09-25 07:02:34', 3995, 12312, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-09-25 07:02:34', 4219, 10765, 'detection_plaque_valcor_010622') ('2025-09-25 07:02:34', 3993, 10189, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-09-25 07:02:34', 533, 9851, 'multi_classification_tapis_dechet') ('2025-09-25 07:02:34', 4322, 8970, 'RUBBIA_filmPE_151122') ('2025-09-25 07:02:34', 4310, 5320, 'classifieur_2camions_valcor_021122_v1') ('2025-09-25 07:02:34', 4871, 4842, 'blur_rubbia_live') ('2025-09-25 07:02:34', 3459, 3006, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-25 07:02:34', 4748, 2460, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-09-25 07:02:34', 4934, 2400, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour') ('2025-09-25 07:02:34', 4887, 2320, 'split_time_score_Sevran_test') ('2025-09-25 07:02:34', 4891, 2300, 'split_time_score_angers_montee_convoyeur') ('2025-09-25 07:02:34', 4153, 1883, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-09-25 07:02:34', 3994, 1650, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-09-25 07:02:34', 4311, 1420, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-09-25 07:02:34', 4433, 1315, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-25 07:02:34', 3991, 1089, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-09-25 07:02:34', 4851, 961, 'split_time_score_SCCU_8') ('2025-09-25 07:02:34', 4849, 787, 'split_time_score_SCCU_6') ('2025-09-25 07:02:34', 4850, 656, 'split_time_score_SCCU_7') ('2025-09-25 07:02:34', 4189, 629, 'split_time_score_JRM_Perlen_convoyeur') ('2025-09-25 07:02:34', 4878, 400, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-09-25 07:02:34', 4220, 300, 'split_time_score_plaque_Valcor') ('2025-09-25 07:02:34', 4254, 203, 'pet_fonce_prod_consolidate') ('2025-09-25 07:02:34', 3992, 203, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-09-25 07:02:34', 4252, 168, 'pehd_prod_consolidate') ('2025-09-25 07:02:34', 3318, 119, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-09-25 07:02:34', 4742, 112, 'entrant_consolidate') ('2025-09-25 07:02:34', 4250, 105, 'pcnc_prod_consolidate') ('2025-09-25 07:02:34', 4249, 105, 'pcm_prod_consolidate') ('2025-09-25 07:02:34', 4932, 41, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1') ('2025-09-25 07:02:34', 243, 26, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-09-25 07:02:34', 4212, 20, 'ACP_from_port_5709050_type_5619_size_9') ('2025-09-25 07:02:34', 4208, 20, 'test_acp_fit_transform_20') ('2025-09-25 07:02:34', 230, 16, 'datou_test_rotate') ('2025-09-25 07:02:34', 4567, 15, 'tfhub_19_06_2023') ('2025-09-25 07:02:34', 4621, 15, 'tfhub_18_7_2023') ('2025-09-25 07:02:34', 4573, 12, 'test_sam_h') ('2025-09-25 07:02:34', 40, 9, 'mask_coco_origin') ('2025-09-25 07:02:34', 4184, 8, 'detection_plaque_valcor_010622') ('2025-09-25 07:02:34', 1026, 4, 'mask_coco_for_test') ('2025-09-25 07:02:34', 2, 4, 'classification_model') ('2025-09-25 07:02:34', 233, 2, 'datou_test_rotate_conditionnel') Nombre de lignes inserees dans la table crop segments depuis une semaine, par hashtag type ('hashtag type id', 'Nombre de ligne dans crop_segments depuis 7 jours') Catched exception ! Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 103, in select cursor.execute(query, args) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 331, in _query self._do_get_result(db) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 136, in _do_get_result self._result = result = self._get_result() File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 363, in _get_result return self._get_db().store_result() MySQLdb.OperationalError: (1317, 'Query execution was interrupted') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/sql_queries.py", line 304, in result = gq.select(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 114, in select cursor.execute(query, args) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 331, in _query self._do_get_result(db) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 136, in _do_get_result self._result = result = self._get_result() File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 363, in _get_result return self._get_db().store_result() MySQLdb.OperationalError: (1317, 'Query execution was interrupted') Command exited with non-zero status 1 0.16user 0.03system 2:00:15elapsed 0%CPU (0avgtext+0avgdata 37048maxresident)k 6856inputs+48outputs (36major+5785minor)pagefaults 0swaps