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: 11/09/2025, 07:00:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-09-11 07:00:25', 99) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-09-11 07:00:25', 793583) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-09-11 07:02:30', 13931) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-09-11 07:02:30', 9317) 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-11 07:02:44', 4219, 23586, 17342, 6244, 'detection_plaque_valcor_010622', 1028.0, '26464569:plaque_val:1064:0,26420453:plaque_val:1064:0,26381191:plaque_val:1064:0,25386830:plaque_val:1064:0,24979422:plaque_val:1064:0,23315443:plaque_val:1064:0,25155783:plaque_val:1064:0,25116808:plaque_val:1064:0', 8) ('2025-09-11 07:02:44', 4878, 1566, 100, 1466, 'split_time_score_JRM_Arc_En_Ciel_test_load', 0.0, '26704195:arc_en_cie:979:1', 1) ('2025-09-11 07:02:44', 3993, 1655, 708, 947, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 25.714285714285715, '26722884:pcnc_diff_:1042:0,26729065:pcnc_diff_:1042:0,26716824:pcnc_diff_:1042:0,26704713:pcnc_diff_:1042:0,26697946:pcnc_diff_:1042:1,26691893:pcnc_diff_:1042:0,26690781:pcnc_diff_:1042:0', 7) ('2025-09-11 07:02:44', 533, 6142, 5826, 316, 'multi_classification_tapis_dechet', 686.6666666666666, '24113525:jetson_tes:979:0,26734809:aec_metal_:979:1,26734748:jetson_tes:979:0', 3) ('2025-09-11 07:02:44', 4892, 10856, 10678, 178, 'multi_classification_tapis_dechet', 23.0, '26734754:angers_mon:1017:1,26734745:Sevran_302:1042:1,26665673:angers_mon:1017:0', 3) ('2025-09-11 07:02:44', 4433, 542, 405, 137, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 31.571428571428573, '26681308:JRM_diff_b:1053:0,26719932:JRM_diff_b:1053:0,26719931:JRM_diff_b:1053:0,26713187:JRM_diff_b:1053:0,26680253:JRM_diff_b:1053:0,26687228:JRM_diff_b:1053:0,26686352:JRM_diff_b:1053:0', 7) ('2025-09-11 07:02:44', 4871, 1610, 1592, 18, 'blur_rubbia_live', 7.0, '26734743:arc_en_cie:979:1', 1) ('2025-09-11 07:02:44', 4877, 50, 36, 14, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '26746436:JRM_diff_b:979:0,26746423:JRM_diff_b:979:0,26746289:JRM_diff_b:979:0,26746449:JRM_diff_b:979:0,26746064:JRM_diff_b:979:0,26745683:JRM_diff_b:979:0,26745509:JRM_diff_b:979:0,26745355:JRM_diff_b:979:0,26745207:JRM_diff_b:979:0,26744890:JRM_diff_b:979:0', 10) ('2025-09-11 07:02:44', 4302, 84, 72, 12, 'RUBBIA_JRM_consolidate', 0.0, '26746203:JRM_diff_b:979:0', 1) ('2025-09-11 07:02:44', 4310, 2596, 2591, 5, 'classifieur_2camions_valcor_021122_v1', 15.0, '26711112:dechet_val:991:0,26741824:dechet_val:991:0', 2) ('2025-09-11 07:02:44', 4234, 14, 14, 0, 'refus_rym_velours_valcor', 0.25, '26746418:incinerati:1103:1,26746419:incinerati:1103:1,26744548:incinerati:1103:1,26746420:incinerati:1103:1', 4) 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-11 07:02:48', 370, 2, 'proportion_papier_qualite_dechets_tri', Decimal('1.0000'), '13545783:papier_dif:739:0', 1) ('2025-09-11 07:02:48', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('3915.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-11 07:02:48', 4220, 1367, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '26704850:plaque_val:1064:0,26741375:plaque_val:1064:0', 2) ('2025-09-11 07:02:48', 4234, 4, 'refus_rym_velours_valcor', Decimal('1.0000'), '26744548:incinerati:1103:1', 1) ('2025-09-11 07:02:48', 4302, 90, 'RUBBIA_JRM_consolidate', Decimal('0.0000'), '26746203:JRM_diff_b:979:0,26746606:JRM_diff_b:979:0', 2) ('2025-09-11 07:02:48', 4323, 835, 'split_time_score_arc_en_ciel_mm', Decimal('0.0000'), '26734748:jetson_tes:979:1', 1) ('2025-09-11 07:02:48', 4877, 104, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '26744890:JRM_diff_b:979:0,26745207:JRM_diff_b:979:0,26745355:JRM_diff_b:979:0,26745509:JRM_diff_b:979:0,26745683:JRM_diff_b:979:0,26746064:JRM_diff_b:979:0,26746289:JRM_diff_b:979:0,26746423:JRM_diff_b:979:0,26746436:JRM_diff_b:979:0,26746449:JRM_diff_b:979:0,26746536:JRM_diff_b:979:0,26746538:JRM_diff_b:979:0,26746539:JRM_diff_b:979:0,26746540:JRM_diff_b:979:0,26746543:JRM_diff_b:979:0,26746546:JRM_diff_b:979:0,26746549:JRM_diff_b:979:0,26746552:JRM_diff_b:979:0,26746555:JRM_diff_b:979:0,26746558:JRM_diff_b:979:0', 20) ('2025-09-11 07:02:48', 4878, 1566, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '26704195:arc_en_cie:979:1', 1) ('2025-09-11 07:02:48', 4887, 2406, 'split_time_score_Sevran_test', Decimal('0.0000'), '26734745:Sevran_302:1042:0', 1) ('2025-09-11 07:02:48', 4891, 2188, 'split_time_score_angers_montee_convoyeur', Decimal('0.0000'), '26734754:angers_mon:1017:0', 1) ('2025-09-11 07:02:48', 4916, 4821, 'split_time_score_Acier_Arc_En_Ciel', Decimal('1.0000'), '26704193:aec_metal_:979:0', 1) ('2025-09-11 07:02:48', 4949, 525, 'blur_detection_test_ken', Decimal('1814.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-11 07:02:48', 4219, 440, 'detection_plaque_valcor_010622') ('2025-09-11 07:02:48', 4892, 22561, 'multi_classification_tapis_dechet') ('2025-09-11 07:02:48', 4433, 3240, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-11 07:02:48', 3993, 5364, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-09-11 07:02:48', 4878, 100, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-09-11 07:02:48', 4310, 5671, 'classifieur_2camions_valcor_021122_v1') ('2025-09-11 07:02:48', 533, 6563, 'multi_classification_tapis_dechet') ('2025-09-11 07:02:48', 4234, 21, 'refus_rym_velours_valcor') ('2025-09-11 07:02:48', 4877, 288, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-09-11 07:02:48', 4302, 288, 'RUBBIA_JRM_consolidate') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 14) (0, 84) (-5, 7) 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-11 07:03:21', 4234, 252859, 'refus_rym_velours_valcor') ('2025-09-11 07:03:21', 4935, 71476, 'split_time_score_JRM_Arc_En_Ciel_merge') ('2025-09-11 07:03:21', 4876, 71393, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-09-11 07:03:21', 4883, 68279, 'split_time_score_JRM_Arc_En_Ciel') ('2025-09-11 07:03:21', 4892, 58201, 'multi_classification_tapis_dechet') ('2025-09-11 07:03:21', 4323, 41080, 'split_time_score_arc_en_ciel_mm') ('2025-09-11 07:03:21', 533, 40565, 'multi_classification_tapis_dechet') ('2025-09-11 07:03:21', 3993, 38185, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-09-11 07:03:21', 3804, 19097, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-09-11 07:03:21', 4302, 19052, 'RUBBIA_JRM_consolidate') ('2025-09-11 07:03:21', 4877, 18754, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-09-11 07:03:21', 3995, 13445, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4954, 9720, 'learn_MM_generique_090925') ('2025-09-11 07:03:21', 4322, 9094, 'RUBBIA_filmPE_151122') ('2025-09-11 07:03:21', 4433, 8045, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-11 07:03:21', 4310, 5671, 'classifieur_2camions_valcor_021122_v1') ('2025-09-11 07:03:21', 3994, 4965, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4219, 4350, 'detection_plaque_valcor_010622') ('2025-09-11 07:03:21', 4891, 4100, 'split_time_score_angers_montee_convoyeur') ('2025-09-11 07:03:21', 4311, 4020, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-09-11 07:03:21', 3459, 2909, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-09-11 07:03:21', 4916, 2900, 'split_time_score_Acier_Arc_En_Ciel') ('2025-09-11 07:03:21', 3318, 2844, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-09-11 07:03:21', 4153, 2775, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4887, 2600, 'split_time_score_Sevran_test') ('2025-09-11 07:03:21', 4934, 2400, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour') ('2025-09-11 07:03:21', 3991, 2293, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4871, 2207, 'blur_rubbia_live') ('2025-09-11 07:03:21', 4748, 2067, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4189, 1300, 'split_time_score_JRM_Perlen_convoyeur') ('2025-09-11 07:03:21', 4220, 937, 'split_time_score_plaque_Valcor') ('2025-09-11 07:03:21', 4851, 773, 'split_time_score_SCCU_8') ('2025-09-11 07:03:21', 4849, 771, 'split_time_score_SCCU_6') ('2025-09-11 07:03:21', 4850, 762, 'split_time_score_SCCU_7') ('2025-09-11 07:03:21', 4741, 628, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-09-11 07:03:21', 3789, 464, 'split_time_score_test_multi_matiere') ('2025-09-11 07:03:21', 3992, 456, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-09-11 07:03:21', 4254, 434, 'pet_fonce_prod_consolidate') ('2025-09-11 07:03:21', 4255, 420, 'pet_clair_prod_consolidate') ('2025-09-11 07:03:21', 4878, 400, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-09-11 07:03:21', 4250, 357, 'pcnc_prod_consolidate') ('2025-09-11 07:03:21', 4241, 175, 'jrm_prod_consolidate') ('2025-09-11 07:03:21', 3787, 128, 'split_time_score_urban_fest') ('2025-09-11 07:03:21', 4249, 119, 'pcm_prod_consolidate') ('2025-09-11 07:03:21', 4742, 105, 'entrant_consolidate') ('2025-09-11 07:03:21', 3181, 66, 'split_time_score_JRM_Arc_En_Ciel') ('2025-09-11 07:03:21', 243, 52, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-09-11 07:03:21', 370, 48, 'proportion_papier_qualite_dechets_tri') ('2025-09-11 07:03:21', 3164, 28, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-09-11 07:03:21', 4746, 24, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1') ('2025-09-11 07:03:21', 4208, 20, 'test_acp_fit_transform_20') ('2025-09-11 07:03:21', 4212, 20, 'ACP_from_port_5709050_type_5619_size_9') ('2025-09-11 07:03:21', 4209, 20, 'test_acp') ('2025-09-11 07:03:21', 686, 18, 'copy_argmax_crop') ('2025-09-11 07:03:21', 3781, 14, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-09-11 07:03:21', 4148, 12, 'test_paddle_ocr') ('2025-09-11 07:03:21', 4567, 12, 'tfhub_19_06_2023') ('2025-09-11 07:03:21', 4621, 12, 'tfhub_18_7_2023') ('2025-09-11 07:03:21', 1848, 10, 'Pipeline_upm_photos_blanches') ('2025-09-11 07:03:21', 3990, 10, 'test_crop_condition_blur') ('2025-09-11 07:03:21', 3070, 10, 'test_ventilate_hashtag_type_3326') ('2025-09-11 07:03:21', 2896, 10, 'test_radom_deformation') ('2025-09-11 07:03:21', 4945, 8, 'learn_mask_pancarte_110625_2') ('2025-09-11 07:03:21', 230, 8, 'datou_test_rotate') ('2025-09-11 07:03:21', 3856, 8, 'RUBBIA_Carton_050821_extract_RYM') ('2025-09-11 07:03:21', 4184, 4, 'detection_plaque_valcor_010622') ('2025-09-11 07:03:21', 40, 4, 'mask_coco_origin') ('2025-09-11 07:03:21', 233, 4, 'datou_test_rotate_conditionnel') ('2025-09-11 07:03:21', 2719, 4, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-09-11 07:03:21', 4492, 4, 'copie_4387_test_replace') ('2025-09-11 07:03:21', 4553, 4, 'copie_4387_test_replace') ('2025-09-11 07:03:21', 4573, 3, 'test_sam_h') ('2025-09-11 07:03:21', 2, 2, 'classification_model') ('2025-09-11 07:03:21', 571, 2, 'datou_test_flip') ('2025-09-11 07:03:21', 2085, 2, 'train_points_upm_darker') ('2025-09-11 07:03:21', 2041, 2, 'test_data_aug') ('2025-09-11 07:03:21', 1818, 2, 'blanchir') ('2025-09-11 07:03:21', 1026, 2, 'mask_coco_for_test') 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 75, 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 86, 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.21user 0.15system 1:51:39elapsed 0%CPU (0avgtext+0avgdata 34560maxresident)k 41160inputs+48outputs (2618major+8541minor)pagefaults 0swaps