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: 16/07/2025, 07:00:25

Nombre de datou current
('date', 'nombre de datou current')
('2025-07-16 07:00:25', 148)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-07-16 07:00:25', 568312)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-07-16 07:08:19', 20043)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-07-16 07:08:19', 4777)

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-07-16 07:09:11', 4219, 3652, 2186, 1466, 'detection_plaque_valcor_010622', 630.5, '23315443:plaque_val:1064:0,24979422:plaque_val:1064:0', 2)
('2025-07-16 07:09:11', 533, 22024, 21202, 822, 'multi_classification_tapis_dechet', 433.5, '24047899:jetson_tes:979:1,24978287:aec_metal_:979:1,24978286:jetson_new:983:0,24835529:aec_metal_:979:1,24230041:jetson_tes:979:1,24113525:jetson_tes:979:1,24178823:jetson_tes:979:1,24075733:jetson_tes:979:1', 8)
('2025-07-16 07:09:11', 4877, 275, 126, 149, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 14.25, '24990034:JRM_diff_b:979:1,24947907:JRM_diff_b:979:0,24762755:JRM_diff_b:979:0,24762753:JRM_diff_b:979:0', 4)
('2025-07-16 07:09:11', 4892, 367, 261, 106, 'multi_classification_tapis_dechet', 1.0, '24988214:angers_mon:1017:1', 1)
('2025-07-16 07:09:11', 4433, 32, 15, 17, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 42.0, '24915476:JRM_diff_b:1053:0', 1)
('2025-07-16 07:09:11', 4322, 33, 20, 13, 'RUBBIA_filmPE_151122', 0.0, '24989884:film_pedb_:979:1', 1)
('2025-07-16 07:09:11', 3804, 15, 15, 0, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 0.0, '24989836:pet_clair_:1017:1', 1)
('2025-07-16 07:09:11', 3993, 14, 14, 0, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 0.0, '24989882:gros_carto:979:1', 1)
('2025-07-16 07:09:11', 3995, 17, 17, 0, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 0.0, '24989889:pehd_pp_di:979:1', 1)
('2025-07-16 07:09:11', 4234, 12, 12, 0, 'refus_rym_velours_valcor', 0.0, '24989724:incinerati:1103:1,24989725:incinerati:1103:1,24989726: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-07-16 07:09:22', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('2547.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-07-16 07:09:22', 3992, 4, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('0.0000'), '24989890:aluminium_:979:0', 1)
('2025-07-16 07:09:22', 3996, 209, 'RUBBIA_Refus_add_surclassifier_rapport', Decimal('0.0000'), '24989916:refus_diff:983:0,24989918:refus_diff:983:0,24989920:refus_diff:983:0,24989921:refus_diff:983:0,24989923:refus_diff:983:0,24989924:refus_diff:983:0,24989926:refus_diff:983:0', 7)
('2025-07-16 07:09:22', 4220, 3742, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '24949303:plaque_val:1064:0', 1)
('2025-07-16 07:09:22', 4323, 486, 'split_time_score_arc_en_ciel_mm', Decimal('0.0000'), '24978288:jetson_tes:979:1', 1)
('2025-07-16 07:09:22', 4748, 18, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('0.0000'), '24989888:flux_dev_r:979:0', 1)
('2025-07-16 07:09:22', 4877, 12, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '24990031:JRM_diff_b:979:0,24990157:JRM_diff_b:979:0', 2)
('2025-07-16 07:09:22', 4916, 6171, 'split_time_score_Acier_Arc_En_Ciel', Decimal('0.6932'), '24949343:aec_metal_:979:0,24978287:aec_metal_:979:0', 2)
('2025-07-16 07:09:22', 4934, 2327, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour', Decimal('0.0000'), '24978206:arc_en_cie:979:0', 1)
('2025-07-16 07:09:22', 4949, 525, 'blur_detection_test_ken', Decimal('447.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-07-16 07:09:22', 4219, 1732, 'detection_plaque_valcor_010622')
('2025-07-16 07:09:22', 533, 13017, 'multi_classification_tapis_dechet')
('2025-07-16 07:09:22', 4877, 900, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-07-16 07:09:22', 4892, 305, 'multi_classification_tapis_dechet')
('2025-07-16 07:09:22', 4234, 8, 'refus_rym_velours_valcor')
('2025-07-16 07:09:22', 3804, 30, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-07-16 07:09:22', 3993, 42, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-07-16 07:09:22', 4322, 60, 'RUBBIA_filmPE_151122')
('2025-07-16 07:09:22', 3995, 34, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 18)
(0, 140)
(-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-07-16 07:10:07', 4234, 80833, 'refus_rym_velours_valcor')
('2025-07-16 07:10:07', 4877, 78918, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-07-16 07:10:07', 4935, 71434, 'split_time_score_JRM_Arc_En_Ciel_merge')
('2025-07-16 07:10:07', 4876, 71334, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-07-16 07:10:07', 4883, 70834, 'split_time_score_JRM_Arc_En_Ciel')
('2025-07-16 07:10:07', 4302, 65228, 'RUBBIA_JRM_consolidate')
('2025-07-16 07:10:07', 4323, 49984, 'split_time_score_arc_en_ciel_mm')
('2025-07-16 07:10:07', 533, 40374, 'multi_classification_tapis_dechet')
('2025-07-16 07:10:07', 3996, 8594, 'RUBBIA_Refus_add_surclassifier_rapport')
('2025-07-16 07:10:07', 4892, 7742, 'multi_classification_tapis_dechet')
('2025-07-16 07:10:07', 4871, 7334, 'blur_rubbia_live')
('2025-07-16 07:10:07', 4219, 4640, 'detection_plaque_valcor_010622')
('2025-07-16 07:10:07', 4310, 4116, 'classifieur_2camions_valcor_021122_v1')
('2025-07-16 07:10:07', 4916, 2200, 'split_time_score_Acier_Arc_En_Ciel')
('2025-07-16 07:10:07', 3142, 1840, 'STS_refus_Amiens')
('2025-07-16 07:10:07', 4934, 1000, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour')
('2025-07-16 07:10:07', 4220, 800, 'split_time_score_plaque_Valcor')
('2025-07-16 07:10:07', 4849, 606, 'split_time_score_SCCU_6')
('2025-07-16 07:10:07', 4878, 600, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-07-16 07:10:07', 4851, 525, 'split_time_score_SCCU_8')
('2025-07-16 07:10:07', 4850, 520, 'split_time_score_SCCU_7')
('2025-07-16 07:10:07', 3993, 487, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-07-16 07:10:07', 4311, 200, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-07-16 07:10:07', 4891, 100, 'split_time_score_angers_montee_convoyeur')
('2025-07-16 07:10:07', 4189, 100, 'split_time_score_JRM_Perlen_convoyeur')
('2025-07-16 07:10:07', 4742, 63, 'entrant_consolidate')
('2025-07-16 07:10:07', 4322, 60, 'RUBBIA_filmPE_151122')
('2025-07-16 07:10:07', 3995, 34, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-07-16 07:10:07', 3804, 30, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-07-16 07:10:07', 4749, 14, 'split_time_score_cod_valoraisne_auto_with_sam')
('2025-07-16 07:10:07', 4741, 11, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-07-16 07:10:07', 4573, 10, 'test_sam_h')
('2025-07-16 07:10:07', 4746, 10, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1')
('2025-07-16 07:10:07', 2719, 6, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-07-16 07:10:07', 4148, 5, 'test_paddle_ocr')

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 68, 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 79, 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.05system 1:49:08elapsed 0%CPU (0avgtext+0avgdata 39820maxresident)k
9400inputs+24outputs (1079major+6665minor)pagefaults 0swaps