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

Nombre de datou current
('date', 'nombre de datou current')
('2025-08-25 07:00:26', 139)

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

Nombre total de photos restant a traiter non commence
('date', 'Nombre total de photos restant a traiter non commence')
('2025-08-25 07:09:53', 2092)

Nombre total de photos restant a traiter
('date', 'Nombre total de photos restant a traiter')
('2025-08-25 07:09:53', 4460)

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-08-25 07:10:38', 4219, 17722, 13745, 3977, 'detection_plaque_valcor_010622', 882.8571428571429, '24979422:plaque_val:1064:0,25116808:plaque_val:1064:0,25155783:plaque_val:1064:0,25386830:plaque_val:1064:0,25432819:plaque_val:1064:0,23315443:plaque_val:1064:0,26189131:plaque_val:1064:1', 7)
('2025-08-25 07:10:38', 4892, 2053, 1752, 301, 'multi_classification_tapis_dechet', 4.0, '26188412:Sevran_302:1042:1,26191170:angers_mon:1017:1', 2)
('2025-08-25 07:10:38', 533, 5190, 5003, 187, 'multi_classification_tapis_dechet', 823.0, '24113525:jetson_tes:979:1,26188413:jetson_tes:979:1', 2)
('2025-08-25 07:10:38', 4310, 2464, 2455, 9, 'classifieur_2camions_valcor_021122_v1', 15.0, '26183821:dechet_val:991:0,26190457:dechet_val:991:0', 2)
('2025-08-25 07:10:38', 4302, 37, 31, 6, 'RUBBIA_JRM_consolidate', 0.0, '26192047:JRM_diff_b:979:0', 1)
('2025-08-25 07:10:38', 4871, 327, 321, 6, 'blur_rubbia_live', 2.0, '26190656:arc_en_cie:979:0', 1)
('2025-08-25 07:10:38', 4234, 8, 8, 0, 'refus_rym_velours_valcor', 0.0, '26191934:incinerati:1103:1,26191935:incinerati:1103:1', 2)
('2025-08-25 07:10:38', 4322, 12, 12, 0, 'RUBBIA_filmPE_151122', 0.0, '26192116: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-08-25 07:10:51', 3459, 13, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('0.0000'), '26192344:jrm_diff_b:1017:0', 1)
('2025-08-25 07:10:51', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('3507.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-08-25 07:10:51', 3993, 38, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('0.0000'), '26192040:emr_diff_b:979:0,26192046:emr_diff_b:979:0,26192049:gros_carto:979:0', 3)
('2025-08-25 07:10:51', 4220, 459, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '26183444:plaque_val:1064:0,26189131:plaque_val:1064:0', 2)
('2025-08-25 07:10:51', 4302, 37, 'RUBBIA_JRM_consolidate', Decimal('0.0000'), '26192047:JRM_diff_b:979:0', 1)
('2025-08-25 07:10:51', 4748, 20, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('0.0000'), '26192038:flux_dev_r:979:0', 1)
('2025-08-25 07:10:51', 4877, 229, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '26192000:JRM_diff_b:979:0,26192003:JRM_diff_b:979:0,26192005:JRM_diff_b:979:0,26192007:JRM_diff_b:979:0,26192009:JRM_diff_b:979:0,26192011:JRM_diff_b:979:0,26192013:JRM_diff_b:979:0,26192015:JRM_diff_b:979:0,26192017:JRM_diff_b:979:0,26192019:JRM_diff_b:979:0,26192021:JRM_diff_b:979:0,26192023:JRM_diff_b:979:0,26192025:JRM_diff_b:979:0,26192027:JRM_diff_b:979:0,26192029:JRM_diff_b:979:0,26192031:JRM_diff_b:979:0,26192033:JRM_diff_b:979:0,26192034:JRM_diff_b:979:0,26192035:JRM_diff_b:979:0,26192037:JRM_diff_b:979:0,26192039:JRM_diff_b:979:0,26192041:JRM_diff_b:979:0,26192043:JRM_diff_b:979:0,26192045:JRM_diff_b:979:0,26192048:JRM_diff_b:979:0,26192051:JRM_diff_b:979:0,26192052:JRM_diff_b:979:0,26192053:JRM_diff_b:979:0,26192054:JRM_diff_b:979:0,26192055:JRM_diff_b:979:0,26192056:JRM_diff_b:979:0,26192057:JRM_diff_b:979:0,26192058:JRM_diff_b:979:0,26192059:JRM_diff_b:979:0,26192072:JRM_diff_b:979:0,26192086:JRM_diff_b:979:0,26192088:JRM_diff_b:979:0,26192090:JRM_diff_b:979:0,26192092:JRM_diff_b:979:0,26192094:J', 66)
('2025-08-25 07:10:51', 4949, 525, 'blur_detection_test_ken', Decimal('1407.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-08-25 07:10:51', 533, 3893, 'multi_classification_tapis_dechet')
('2025-08-25 07:10:51', 4219, 730, 'detection_plaque_valcor_010622')
('2025-08-25 07:10:51', 4310, 5700, 'classifieur_2camions_valcor_021122_v1')
('2025-08-25 07:10:51', 4892, 4669, 'multi_classification_tapis_dechet')
('2025-08-25 07:10:51', 4871, 321, 'blur_rubbia_live')
('2025-08-25 07:10:51', 4234, 32, 'refus_rym_velours_valcor')
('2025-08-25 07:10:51', 4302, 124, 'RUBBIA_JRM_consolidate')
('2025-08-25 07:10:51', 4322, 36, 'RUBBIA_filmPE_151122')

Nombre de datous demandés par statut
('statut', 'nombre de datous')
(1, 12)
(0, 181)
(-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-08-25 07:11:47', 4234, 126479, 'refus_rym_velours_valcor')
('2025-08-25 07:11:47', 4892, 29546, 'multi_classification_tapis_dechet')
('2025-08-25 07:11:47', 533, 20082, 'multi_classification_tapis_dechet')
('2025-08-25 07:11:47', 4310, 5706, 'classifieur_2camions_valcor_021122_v1')
('2025-08-25 07:11:47', 4935, 4636, 'split_time_score_JRM_Arc_En_Ciel_merge')
('2025-08-25 07:11:47', 4876, 4636, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-08-25 07:11:47', 4219, 3568, 'detection_plaque_valcor_010622')
('2025-08-25 07:11:47', 4883, 2439, 'split_time_score_JRM_Arc_En_Ciel')
('2025-08-25 07:11:47', 3804, 2190, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM')
('2025-08-25 07:11:47', 4748, 1713, 'RUBBIA_PET_Fonce_add_surclassifier_rapport')
('2025-08-25 07:11:47', 3993, 1478, 'RUBBIA_Carton_131221_add_surclassifier_rapport')
('2025-08-25 07:11:47', 4322, 1401, 'RUBBIA_filmPE_151122')
('2025-08-25 07:11:47', 3789, 1392, 'split_time_score_test_multi_matiere')
('2025-08-25 07:11:47', 4323, 1380, 'split_time_score_arc_en_ciel_mm')
('2025-08-25 07:11:47', 4302, 1308, 'RUBBIA_JRM_consolidate')
('2025-08-25 07:11:47', 3991, 1294, 'RUBBIA_ELA_131221_add_surclassifier_rapport')
('2025-08-25 07:11:47', 4849, 1190, 'split_time_score_SCCU_6')
('2025-08-25 07:11:47', 4851, 1041, 'split_time_score_SCCU_8')
('2025-08-25 07:11:47', 4891, 1000, 'split_time_score_angers_montee_convoyeur')
('2025-08-25 07:11:47', 4850, 931, 'split_time_score_SCCU_7')
('2025-08-25 07:11:47', 4311, 900, 'sts_dechet_valcor_matching_v2_2022Q3')
('2025-08-25 07:11:47', 3995, 759, 'RUBBIA_PEHD_131221_add_surclassifier_rapport')
('2025-08-25 07:11:47', 4887, 480, 'split_time_score_Sevran_test')
('2025-08-25 07:11:47', 4220, 391, 'split_time_score_plaque_Valcor')
('2025-08-25 07:11:47', 4877, 349, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live')
('2025-08-25 07:11:47', 4871, 322, 'blur_rubbia_live')
('2025-08-25 07:11:47', 4934, 200, 'split_time_score_JRM_Arc_En_Ciel_test_load_1hour')
('2025-08-25 07:11:47', 3787, 192, 'split_time_score_urban_fest')
('2025-08-25 07:11:47', 4878, 100, 'split_time_score_JRM_Arc_En_Ciel_test_load')
('2025-08-25 07:11:47', 3181, 99, 'split_time_score_JRM_Arc_En_Ciel')
('2025-08-25 07:11:47', 3992, 90, 'RUBBIA_Alu_131221_add_surclassifier_rapport')
('2025-08-25 07:11:47', 243, 78, 'prepare_varroa_ellipse_tile_rotate_whiten')
('2025-08-25 07:11:47', 3164, 42, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321')
('2025-08-25 07:11:47', 4208, 30, 'test_acp_fit_transform_20')
('2025-08-25 07:11:47', 4209, 30, 'test_acp')
('2025-08-25 07:11:47', 4212, 30, 'ACP_from_port_5709050_type_5619_size_9')
('2025-08-25 07:11:47', 686, 27, 'copy_argmax_crop')
('2025-08-25 07:11:47', 3781, 21, 'cod_pipeline_Perlen_manuel_sts_test')
('2025-08-25 07:11:47', 4621, 18, 'tfhub_18_7_2023')
('2025-08-25 07:11:47', 4567, 18, 'tfhub_19_06_2023')
('2025-08-25 07:11:47', 3070, 15, 'test_ventilate_hashtag_type_3326')
('2025-08-25 07:11:47', 1848, 15, 'Pipeline_upm_photos_blanches')
('2025-08-25 07:11:47', 2896, 15, 'test_radom_deformation')
('2025-08-25 07:11:47', 3990, 15, 'test_crop_condition_blur')
('2025-08-25 07:11:47', 3856, 12, 'RUBBIA_Carton_050821_extract_RYM')
('2025-08-25 07:11:47', 230, 12, 'datou_test_rotate')
('2025-08-25 07:11:47', 4553, 6, 'copie_4387_test_replace')
('2025-08-25 07:11:47', 4492, 6, 'copie_4387_test_replace')
('2025-08-25 07:11:47', 2719, 6, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final')
('2025-08-25 07:11:47', 4184, 6, 'detection_plaque_valcor_010622')
('2025-08-25 07:11:47', 233, 6, 'datou_test_rotate_conditionnel')
('2025-08-25 07:11:47', 40, 5, 'mask_coco_origin')
('2025-08-25 07:11:47', 4573, 3, 'test_sam_h')
('2025-08-25 07:11:47', 2085, 3, 'train_points_upm_darker')
('2025-08-25 07:11:47', 2041, 3, 'test_data_aug')
('2025-08-25 07:11:47', 1818, 3, 'blanchir')
('2025-08-25 07:11:47', 1026, 3, 'mask_coco_for_test')
('2025-08-25 07:11:47', 2, 3, 'classification_model')
('2025-08-25 07:11:47', 571, 3, 'datou_test_flip')

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.28user 0.10system 1:36:32elapsed 0%CPU (0avgtext+0avgdata 35176maxresident)k
26704inputs+32outputs (3011major+8491minor)pagefaults 0swaps