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: 21/02/2025, 07:00:26

Nombre de datou current
('date', 'nombre de datou current')
('2025-02-21 07:00:26', 124)

Nombre total de photos traitees dans les dernieres 24 heures
('date', 'total de photos traitees')
('2025-02-21 07:00:26', 447780)

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-02-21 07:15:07', 2733)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-02-21 07:15:07', 968)

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-02-21 07:15:39', 4892, 8111, 7804, 307, 'multi_classification_tapis_dechet', 20.666666666666668, '20713767:sevran_122:739:1,20698944:angers_mon:1017:1,20657815:angers_mon:1017:0', 3)
('2025-02-21 07:15:39', 4310, 18095, 17802, 293, 'classifieur_2camions_valcor_021122_v1', 37.0, '20708309:dechet_val:991:0,20675559:dechet_val:991:0,20660698:dechet_val:991:0,20626705:dechet_val:991:0', 4)
('2025-02-21 07:15:39', 4322, 334, 200, 134, 'RUBBIA_filmPE_151122', 8.125, '20699471:film_pedb_:739:0,20677297:film_pedb_:1017:0,20708752:film_pedb_:739:0,20692250:film_pedb_:1017:0,20695691:film_pedb_:1017:0,20699107:film_pedb_:1017:0,20699407:film_pedb_:739:0,20699440:film_pedb_:739:0', 8)
('2025-02-21 07:15:39', 3993, 199, 70, 129, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 7.0, '20699443:emr_diff_b:739:0,20699414:emr_diff_b:739:0,20699413:pcnc_diff_:739:0', 3)
('2025-02-21 07:15:39', 3459, 77, 10, 67, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 0.0, '20714269:jrm_diff_b:1017:1', 1)
('2025-02-21 07:15:39', 4877, 86, 69, 17, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '20714336:JRM_diff_b:979:0,20714212:JRM_diff_b:979:1,20714114:JRM_diff_b:979:1,20713858:JRM_diff_b:979:1,20714365:JRM_diff_b:979:1,20713766:JRM_diff_b:979:1,20713663:JRM_diff_b:979:1,20713612:JRM_diff_b:979:1,20713558:JRM_diff_b:979:1,20713481:JRM_diff_b:979:1,20713358:JRM_diff_b:979:1,20713258:JRM_diff_b:979:1,20713227:JRM_diff_b:979:1,20713037:JRM_diff_b:979:1,20712889:JRM_diff_b:979:1,20712712:JRM_diff_b:979:1,20712634:JRM_diff_b:979:1', 17)
('2025-02-21 07:15:39', 533, 1369, 1359, 10, 'multi_classification_tapis_dechet', 9.5, '20713804:arc_en_cie:739:1,20675551:arc_en_cie:739:1', 2)
('2025-02-21 07:15:39', 3991, 21, 20, 1, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 13.0, '20684265:ela_diff_b:1017:1', 1)
('2025-02-21 07:15:39', 3994, 21, 20, 1, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 7.0, '20699411:pcm_diff_b:739:0', 1)
('2025-02-21 07:15:39', 4433, 90, 90, 0, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 18.0, '20675993:JRM_diff_b:1053:1', 1)
('2025-02-21 07:15:39', 4866, 19, 19, 0, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam', 86.85714285714286, '20603410:dib_diff_b:440:1,20610149:excoffier_:1117:1,20603519:dib_diff_b:440:1,20607424:excoffier_:440:1,20603520:dib_diff_b:440:1,20603521:dib_diff_b:440:1,20603524:dib_diff_b:440:1,20603551:dib_diff_b:440:1,20603553:dib_diff_b:440:1,20603555:dib_diff_b:440:1,20603557:dib_diff_b:440:1,20603559:dib_diff_b:440:1,20610139:excoffier_:1117:1,20610140:excoffier_:1117:1', 14)

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-02-21 07:15:39', 3385, 23, 'split_time_score_JRM_Arc_En_Ciel_peu_dense', Decimal('0.0000'), '20713804:arc_en_cie:739:0', 1)
('2025-02-21 07:15:39', 3991, 30, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('5.0000'), '20703033:ela_diff_b:1017:0', 1)
('2025-02-21 07:15:39', 4219, 2187, 'detection_plaque_valcor_010622', Decimal('54.2318'), '20625708:plaque_val:1064:0,20658354:plaque_val:1064:0,20675558:plaque_val:1064:0,20699287:plaque_val:1064:0', 4)
('2025-02-21 07:15:39', 4220, 317, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '20675558:plaque_val:1064:0,20699287:plaque_val:1064:0', 2)
('2025-02-21 07:15:39', 4322, 82, 'RUBBIA_filmPE_151122', Decimal('4.2439'), '20703026:film_pedb_:1017:0,20703327:film_pedb_:739:0,20703331:film_pedb_:739:0,20708746:film_pedb_:739:0,20708747:film_pedb_:739:0', 5)
('2025-02-21 07:15:39', 4877, 16, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '20712889:JRM_diff_b:979:1,20714336:JRM_diff_b:979:0,20714427:JRM_diff_b:979:0', 3)
('2025-02-21 07:15:39', 4887, 96, 'split_time_score_Sevran_test', Decimal('0.0000'), '20713767:sevran_122:739: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-02-21 07:15:39', 4866, 29, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam')
('2025-02-21 07:15:39', 4892, 8079, 'multi_classification_tapis_dechet')
('2025-02-21 07:15:39', 4310, 19870, 'classifieur_2camions_valcor_021122_v1')
('2025-02-21 07:15:39', 533, 4071, 'multi_classification_tapis_dechet')
('2025-02-21 07:15:39', 4433, 780, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-02-21 07:15:39', 4322, 1600, 'RUBBIA_filmPE_151122')
('2025-02-21 07:15:39', 3991, 20, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-02-21 07:15:39', 3994, 160, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-02-21 07:15:39', 3993, 560, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-02-21 07:15:39', 4877, 327, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-02-21 07:15:39', 3459, 90, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 39)
(-5, 21)
(0, 92)

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-02-21 07:18:13', 4234, 95013, 'refus_rym_velours_valcor')
('2025-02-21 07:18:13', 4883, 48365, 'split_time_score_JRM_Arc_En_Ciel')
('2025-02-21 07:18:13', 4876, 47765, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-02-21 07:18:13', 4877, 43482, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-02-21 07:18:13', 4892, 39762, 'multi_classification_tapis_dechet')
('2025-02-21 07:18:13', 3459, 23530, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-02-21 07:18:13', 4302, 23340, 'RUBBIA_JRM_consolidate')
('2025-02-21 07:18:13', 4310, 19870, 'classifieur_2camions_valcor_021122_v1')
('2025-02-21 07:18:13', 3993, 17586, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-02-21 07:18:13', 3804, 15984, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-02-21 07:18:13', 3995, 9908, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-02-21 07:18:13', 4322, 9784, 'RUBBIA_filmPE_151122')
('2025-02-21 07:18:13', 4866, 9166, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam')
('2025-02-21 07:18:13', 533, 8667, 'multi_classification_tapis_dechet')
('2025-02-21 07:18:13', 4433, 7093, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights')
('2025-02-21 07:18:13', 3318, 5320, 'RUBBIA_Refus_mask_simple_non_aussi_rle')
('2025-02-21 07:18:13', 4153, 4822, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-02-21 07:18:13', 4871, 3651, 'blur_rubbia_live')
('2025-02-21 07:18:13', 4891, 3300, 'split_time_score_angers_montee_convoyeur')
('2025-02-21 07:18:13', 4311, 3278, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-02-21 07:18:13', 3994, 3179, 'RUBBIA_proportion_papier_add_surclassifier_rapport')
('2025-02-21 07:18:13', 3385, 1662, 'split_time_score_JRM_Arc_En_Ciel_peu_dense')
('2025-02-21 07:18:13', 4910, 1631, 'pehd_prod_consolidate')
('2025-02-21 07:18:13', 4189, 1072, 'split_time_score_JRM_Perlen_convoyeur')
('2025-02-21 07:18:13', 3992, 947, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-02-21 07:18:13', 3991, 820, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-02-21 07:18:13', 4220, 500, 'split_time_score_plaque_Valcor')
('2025-02-21 07:18:13', 4887, 440, 'split_time_score_Sevran_test')
('2025-02-21 07:18:13', 4878, 330, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-02-21 07:18:13', 4851, 315, 'split_time_score_SCCU_8')
('2025-02-21 07:18:13', 4849, 306, 'split_time_score_SCCU_6')
('2025-02-21 07:18:13', 4850, 290, 'split_time_score_SCCU_7')
('2025-02-21 07:18:13', 40, 11, 'mask_coco_origin')
('2025-02-21 07:18:13', 4573, 8, 'test_sam_h')
('2025-02-21 07:18:13', 2719, 6, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-02-21 07:18:13', 1026, 6, 'mask_coco_for_test')
('2025-02-21 07:18:13', 2665, 4, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920')

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 "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 316, in _query
    self._do_get_result(db)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 147, in _do_get_result
    self._result = result = self._get_result()
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 349, in _get_result
    return self._get_db().store_result()
MySQLdb._exceptions.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 "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute
    res = self._query(query)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 316, in _query
    self._do_get_result(db)
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 147, in _do_get_result
    self._result = result = self._get_result()
  File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 349, in _get_result
    return self._get_db().store_result()
MySQLdb._exceptions.OperationalError: (1317, 'Query execution was interrupted')
Command exited with non-zero status 1
0.27user 0.10system 2:26:05elapsed 0%CPU (0avgtext+0avgdata 34460maxresident)k
41112inputs+32outputs (3189major+8687minor)pagefaults 0swaps