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: 04/09/2025, 07:00:24

Nombre de datou current
('date', 'nombre de datou current')
('2025-09-04 07:00:24', 154)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-09-04 07:00:24', 748484)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-09-04 07:09:28', 12931)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-09-04 07:09:28', 11645)

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-04 07:10:25', 4219, 23586, 16912, 6674, 'detection_plaque_valcor_010622', 860.25, '23315443:plaque_val:1064:0,26464569:plaque_val:1064:0,26420453:plaque_val:1064:0,26381191:plaque_val:1064:0,25386830:plaque_val:1064:0,25155783:plaque_val:1064:0,25116808:plaque_val:1064:0,24979422:plaque_val:1064:0', 8)
('2025-09-04 07:10:25', 533, 27738, 25109, 2629, 'multi_classification_tapis_dechet', 1369.0, '22940755:aec_metal_:979:0,24113525:jetson_tes:979:0,26511108:jetson_tes:979:0,25480052:jetson_tes:979:0', 4)
('2025-09-04 07:10:25', 4876, 1349, 100, 1249, 'split_time_score_JRM_Arc_En_Ciel_test_load', 1.0, '26511073:arc_en_cie:979:1', 1)
('2025-09-04 07:10:25', 3993, 948, 380, 568, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 14.666666666666666, '26497230:pcnc_diff_:1042:0,26493013:pcnc_diff_:1042:0,26491584:pcnc_diff_:1042:0', 3)
('2025-09-04 07:10:25', 4892, 5042, 4516, 526, 'multi_classification_tapis_dechet', 7.0, '26511091:angers_mon:1017:0,26511077:Sevran_302:1042:1', 2)
('2025-09-04 07:10:25', 4871, 1349, 1328, 21, 'blur_rubbia_live', 7.0, '26511073:arc_en_cie:979:0', 1)
('2025-09-04 07:10:25', 4877, 87, 70, 17, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.42105263157894735, '26522652:JRM_diff_b:979:0,26523581:JRM_diff_b:979:1,26523575:JRM_diff_b:979:1,26510720:JRM_diff_b:979:0,26523360:JRM_diff_b:979:0,26523131:JRM_diff_b:979:0,26521438:JRM_diff_b:979:0,26523016:JRM_diff_b:979:1,26522885:JRM_diff_b:979:0,26521532:JRM_diff_b:979:0,26522593:JRM_diff_b:979:0,26522442:JRM_diff_b:979:0,26522308:JRM_diff_b:979:0,26522166:JRM_diff_b:979:0,26522094:JRM_diff_b:979:0,26521914:JRM_diff_b:979:0,26521851:JRM_diff_b:979:0,26521782:JRM_diff_b:979:0,26521687:JRM_diff_b:979:0', 19)
('2025-09-04 07:10:25', 4310, 2672, 2664, 8, 'classifieur_2camions_valcor_021122_v1', 15.0, '26471136:dechet_val:991:0,26519229:dechet_val:991:0', 2)
('2025-09-04 07:10:25', 3804, 8, 8, 0, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 0.0, '26523452:pet_clair_:979:1', 1)
('2025-09-04 07:10:25', 3995, 7, 7, 0, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 0.0, '26523454:pehd_pp_di:979:1', 1)
('2025-09-04 07:10:25', 4234, 4, 4, 0, 'refus_rym_velours_valcor', 0.0, '26523048:incinerati:1103:1', 1)
('2025-09-04 07:10:25', 4322, 13, 13, 0, 'RUBBIA_filmPE_151122', 0.0, '26523468:film_pedb_:979:1', 1)

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-04 07:10:39', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('3747.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-04 07:10:39', 3804, 35, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('0.0000'), '26523326:pet_clair_:979:0,26523362:pet_clair_:979:0,26523392:pet_clair_:979:0', 3)
('2025-09-04 07:10:39', 3993, 50, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('0.0000'), '26523329:emr_diff_b:979:0,26523337:emr_diff_b:979:0,26523345:emr_diff_b:979:0,26523348:gros_carto:979:0,26523353:emr_diff_b:979:0,26523359:gros_carto:979:0,26523390:emr_diff_b:979:0,26523396:emr_diff_b:979:0,26523414:gros_carto:979:0,26523444:emr_diff_b:979:0,26523455:gros_carto:979:0', 11)
('2025-09-04 07:10:39', 3995, 15, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', Decimal('0.0000'), '26523333:pehd_pp_di:979:0,26523376:pehd_pp_di:979:0', 2)
('2025-09-04 07:10:39', 4220, 3238, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '26464569:plaque_val:1064:0,26513871:plaque_val:1064:0', 2)
('2025-09-04 07:10:39', 4322, 51, 'RUBBIA_filmPE_151122', Decimal('0.0000'), '26523323:film_pedb_:979:0,26523342:film_pedb_:979:0,26523356:film_pedb_:979:0,26523400:film_pedb_:979:0', 4)
('2025-09-04 07:10:39', 4323, 815, 'split_time_score_arc_en_ciel_mm', Decimal('0.0000'), '26511108:jetson_tes:979:1', 1)
('2025-09-04 07:10:39', 4748, 31, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('0.0000'), '26523331:flux_dev_r:979:0,26523351:flux_dev_r:979:0,26523394:flux_dev_r:979:0,26523446:flux_dev_r:979:0,26523448:flux_dev_r:979:0', 5)
('2025-09-04 07:10:39', 4877, 102, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '26521687:JRM_diff_b:979:0,26521782:JRM_diff_b:979:0,26521851:JRM_diff_b:979:0,26521914:JRM_diff_b:979:0,26522094:JRM_diff_b:979:0,26522166:JRM_diff_b:979:0,26522308:JRM_diff_b:979:0,26522442:JRM_diff_b:979:0,26522593:JRM_diff_b:979:0,26522652:JRM_diff_b:979:0,26522885:JRM_diff_b:979:0,26523131:JRM_diff_b:979:0,26523360:JRM_diff_b:979:0,26523542:JRM_diff_b:979:0,26523544:JRM_diff_b:979:0,26523546:JRM_diff_b:979:0,26523548:JRM_diff_b:979:0,26523550:JRM_diff_b:979:0,26523551:JRM_diff_b:979:0,26523569:JRM_diff_b:979:0,26523571:JRM_diff_b:979:0,26523573:JRM_diff_b:979:0,26523577:JRM_diff_b:979:0', 23)
('2025-09-04 07:10:39', 4878, 4934, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '26463903:arc_en_cie:979:0', 1)
('2025-09-04 07:10:39', 4916, 1291, 'split_time_score_Acier_Arc_En_Ciel', Decimal('0.0000'), '26511117:aec_metal_:979:0', 1)
('2025-09-04 07:10:39', 4949, 525, 'blur_detection_test_ken', Decimal('1647.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-04 07:10:39', 533, 35391, 'multi_classification_tapis_dechet')
('2025-09-04 07:10:39', 4219, 2940, 'detection_plaque_valcor_010622')
('2025-09-04 07:10:39', 4310, 5998, 'classifieur_2camions_valcor_021122_v1')
('2025-09-04 07:10:39', 3993, 3040, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-09-04 07:10:39', 4877, 512, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-09-04 07:10:39', 4871, 1328, 'blur_rubbia_live')
('2025-09-04 07:10:39', 4876, 100, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-09-04 07:10:39', 4892, 12811, 'multi_classification_tapis_dechet')
('2025-09-04 07:10:39', 4234, 8, 'refus_rym_velours_valcor')
('2025-09-04 07:10:39', 3804, 16, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-09-04 07:10:39', 3995, 21, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-09-04 07:10:39', 4322, 39, 'RUBBIA_filmPE_151122')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(99, 1)
(-100, 10)
(1, 21)
(0, 144)
(-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-04 07:10:47', 4234, 211259, 'refus_rym_velours_valcor')
('2025-09-04 07:10:47', 533, 83714, 'multi_classification_tapis_dechet')
('2025-09-04 07:10:47', 4935, 67700, 'split_time_score_JRM_Arc_En_Ciel_merge')
('2025-09-04 07:10:47', 4876, 58000, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-09-04 07:10:47', 4883, 53200, 'split_time_score_JRM_Arc_En_Ciel')
('2025-09-04 07:10:47', 4892, 47691, 'multi_classification_tapis_dechet')
('2025-09-04 07:10:47', 4302, 42548, 'RUBBIA_JRM_consolidate')
('2025-09-04 07:10:47', 4877, 36076, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-09-04 07:10:47', 3993, 23668, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-09-04 07:10:47', 4323, 22900, 'split_time_score_arc_en_ciel_mm')
('2025-09-04 07:10:47', 3804, 20318, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-09-04 07:10:47', 3995, 11008, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-09-04 07:10:47', 4322, 9733, 'RUBBIA_filmPE_151122')
('2025-09-04 07:10:47', 4310, 6010, 'classifieur_2camions_valcor_021122_v1')
('2025-09-04 07:10:47', 4219, 5942, 'detection_plaque_valcor_010622')
('2025-09-04 07:10:47', 4871, 4801, 'blur_rubbia_live')
('2025-09-04 07:10:47', 4891, 3900, 'split_time_score_angers_montee_convoyeur')
('2025-09-04 07:10:47', 4311, 3800, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-09-04 07:10:47', 4748, 3735, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-09-04 07:10:47', 4433, 3600, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-09-04 07:10:47', 3459, 3478, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-09-04 07:10:47', 3318, 3230, 'RUBBIA_Refus_mask_simple_non_aussi_rle')
('2025-09-04 07:10:47', 4153, 2814, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-09-04 07:10:47', 4916, 2500, 'split_time_score_Acier_Arc_En_Ciel')
('2025-09-04 07:10:47', 4887, 2480, 'split_time_score_Sevran_test')
('2025-09-04 07:10:47', 4934, 2400, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour')
('2025-09-04 07:10:47', 3991, 1795, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-09-04 07:10:47', 3994, 1568, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-09-04 07:10:47', 3789, 1392, 'split_time_score_test_multi_matiere')
('2025-09-04 07:10:47', 4849, 1158, 'split_time_score_SCCU_6')
('2025-09-04 07:10:47', 4850, 1071, 'split_time_score_SCCU_7')
('2025-09-04 07:10:47', 4851, 880, 'split_time_score_SCCU_8')
('2025-09-04 07:10:47', 3992, 687, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-09-04 07:10:47', 4189, 600, 'split_time_score_JRM_Perlen_convoyeur')
('2025-09-04 07:10:47', 4878, 500, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-09-04 07:10:47', 4220, 400, 'split_time_score_plaque_Valcor')
('2025-09-04 07:10:47', 4252, 280, 'pehd_prod_consolidate')
('2025-09-04 07:10:47', 4932, 278, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1')
('2025-09-04 07:10:47', 3787, 192, 'split_time_score_urban_fest')
('2025-09-04 07:10:47', 4250, 147, 'pcnc_prod_consolidate')
('2025-09-04 07:10:47', 4253, 105, 'alu_prod_consolidate')
('2025-09-04 07:10:47', 3181, 99, 'split_time_score_JRM_Arc_En_Ciel')
('2025-09-04 07:10:47', 243, 78, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-09-04 07:10:47', 4742, 56, 'entrant_consolidate')
('2025-09-04 07:10:47', 4148, 53, 'test_paddle_ocr')
('2025-09-04 07:10:47', 3164, 42, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-09-04 07:10:47', 4209, 30, 'test_acp')
('2025-09-04 07:10:47', 4212, 30, 'ACP_from_port_5709050_type_5619_size_9')
('2025-09-04 07:10:47', 4208, 30, 'test_acp_fit_transform_20')
('2025-09-04 07:10:47', 686, 27, 'copy_argmax_crop')
('2025-09-04 07:10:47', 3781, 21, 'cod_pipeline_Perlen_manuel_sts_test')
('2025-09-04 07:10:47', 4621, 18, 'tfhub_18_7_2023')
('2025-09-04 07:10:47', 4567, 15, 'tfhub_19_06_2023')
('2025-09-04 07:10:47', 1848, 15, 'Pipeline_upm_photos_blanches')
('2025-09-04 07:10:47', 3990, 15, 'test_crop_condition_blur')
('2025-09-04 07:10:47', 3070, 15, 'test_ventilate_hashtag_type_3326')
('2025-09-04 07:10:47', 2896, 15, 'test_radom_deformation')
('2025-09-04 07:10:47', 230, 12, 'datou_test_rotate')
('2025-09-04 07:10:47', 3856, 12, 'RUBBIA_Carton_050821_extract_RYM')
('2025-09-04 07:10:47', 40, 6, 'mask_coco_origin')
('2025-09-04 07:10:47', 233, 6, 'datou_test_rotate_conditionnel')
('2025-09-04 07:10:47', 2719, 6, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-09-04 07:10:47', 4184, 6, 'detection_plaque_valcor_010622')
('2025-09-04 07:10:47', 4553, 6, 'copie_4387_test_replace')
('2025-09-04 07:10:47', 4492, 6, 'copie_4387_test_replace')
('2025-09-04 07:10:47', 2085, 3, 'train_points_upm_darker')
('2025-09-04 07:10:47', 2041, 3, 'test_data_aug')
('2025-09-04 07:10:47', 1818, 3, 'blanchir')
('2025-09-04 07:10:47', 1026, 3, 'mask_coco_for_test')
('2025-09-04 07:10:47', 4573, 3, 'test_sam_h')
('2025-09-04 07:10:47', 571, 3, 'datou_test_flip')
('2025-09-04 07:10:47', 2, 3, 'classification_model')

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 <module>
    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.20user 0.15system 1:33:18elapsed 0%CPU (0avgtext+0avgdata 36912maxresident)k
26792inputs+40outputs (2501major+8729minor)pagefaults 0swaps