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: 01/04/2025, 00:01:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-04-01 00:01:25', 170) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-04-01 00:01:25', 567106) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-04-01 00:02:36', 14806) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-04-01 00:02:36', 8409) 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-04-01 00:02:44', 4310, 14726, 8221, 6505, 'classifieur_2camions_valcor_021122_v1', 32.0, '21882554:dechet_val:991:0,21894409:dechet_val:991:0', 2) ('2025-04-01 00:02:44', 4219, 3100, 2019, 1081, 'detection_plaque_valcor_010622', 606.3333333333334, '20821622:plaque_val:1064:0,20658354:plaque_val:1064:0,21892382:plaque_val:1064:0', 3) ('2025-04-01 00:02:44', 4892, 12696, 12284, 412, 'multi_classification_tapis_dechet', 17.0, '21895404:angers_mon:1017:1,21897275:sevran_122:739:1', 2) ('2025-04-01 00:02:44', 3993, 387, 258, 129, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 6.363636363636363, '21906305:emr_diff_b:739:0,21905160:emr_diff_b:739:0,21918652:emr_diff_b:739:0,21904658:gros_carto:739:0,21917468:emr_diff_b:739:0,21919761:gros_carto:739:0,21922017:gros_carto:739:0,21911518:emr_diff_b:739:0,21923981:emr_diff_b:739:0,21913109:gros_carto:739:0,21925664:emr_diff_b:739:1', 11) ('2025-04-01 00:02:44', 4433, 202, 75, 127, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 8.666666666666666, '21911823:JRM_diff_b:1053:0,21907955:JRM_diff_b:1053:0,21912996:JRM_diff_b:1053:0', 3) ('2025-04-01 00:02:44', 3804, 415, 308, 107, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 8.4, '21913100:pet_clair_:1017:0,21925663:pet_clair_:739:1,21925135:pet_clair_:739:1,21914362:pet_clair_:739:0,21910600:pet_clair_:739:0,21902517:pet_clair_:739:0,21904653:pet_clair_:739:0,21904659:pet_clair_:1017:0,21904669:pet_clair_:1017:0,21906309:pet_clair_:739:0', 10) ('2025-04-01 00:02:44', 4748, 91, 60, 31, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 4.666666666666667, '21923983:flux_dev_r:739:0,21917469:flux_dev_r:739:0,21914363:flux_dev_r:739:0', 3) ('2025-04-01 00:02:44', 533, 12834, 12820, 14, 'multi_classification_tapis_dechet', 224.0, '21402976:jetson_tes:739:0,21897182:arc_en_cie:739:0', 2) ('2025-04-01 00:02:44', 4926, 31, 20, 11, 'RUBBIA_fluxdev_angers_280325', 9.0, '21909418:flux_dev_d:1017:0', 1) ('2025-04-01 00:02:44', 3459, 102, 96, 6, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 9.0, '21909419:jrm_diff_b:1017:1,21908935:JRM_diff_b:739:0', 2) ('2025-04-01 00:02:44', 3991, 24, 20, 4, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 7.0, '21913103:ela_diff_b:1017:0', 1) ('2025-04-01 00:02:44', 4234, 6, 6, 0, 'refus_rym_velours_valcor', 0.0, '21928373:incinerati:1103:1,21928372:incinerati:1103:1,21928371:incinerati:1103:1', 3) ('2025-04-01 00:02:44', 4741, 18, 18, 0, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 5.0, '21923207:entrant_di:775:1,21914675:entrant_di:775:1', 2) 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-04-01 00:03:01', 3142, 1010, 'STS_refus_Amiens', Decimal('0.0000'), '21892360:jetson_new:983:0', 1) ('2025-04-01 00:03:01', 3459, 155, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('12.0000'), '21902882:JRM_diff_b:739:0,21902884:JRM_diff_b:739:0,21902885:JRM_diff_b:739:0,21902886:JRM_diff_b:739:0,21902887:JRM_diff_b:739:0,21902888:JRM_diff_b:739:0', 6) ('2025-04-01 00:03:01', 3804, 306, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('4.1765'), '21916929:pet_clair_:739:0,21917396:pet_clair_:1017:0,21917451:pet_clair_:739:0,21919760:pet_clair_:739:0,21920670:pet_clair_:1017:0,21920673:pet_clair_:1017:0,21922016:pet_clair_:739:0,21923979:pet_clair_:739:0', 8) ('2025-04-01 00:03:01', 3991, 49, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('3.5306'), '21917463:ela_diff_b:739:0,21924615:ela_diff_b:1017:0', 2) ('2025-04-01 00:03:01', 3992, 40, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('3.9750'), '21917462:aluminium_:739:0,21918651:aluminium_:739:0,21920675:aluminium_:1017:0,21923986:aluminium_:739:0', 4) ('2025-04-01 00:03:01', 3993, 200, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('4.8000'), '21915748:emr_diff_b:739:0,21916925:emr_diff_b:739:0,21917404:emr_diff_b:1017:0,21917459:emr_diff_b:739:0,21917460:gros_carto:739:0,21917466:gros_carto:739:0,21922015:emr_diff_b:739:0,21923363:emr_diff_b:739:0', 8) ('2025-04-01 00:03:01', 4219, 7837, 'detection_plaque_valcor_010622', Decimal('892.5275'), '20625708:plaque_val:1064:0,20675558:plaque_val:1064:0,20699287:plaque_val:1064:0,20739642:plaque_val:1064:0,20753913:plaque_val:1064:0,20760543:plaque_val:1064:0,20785913:plaque_val:1064:0', 7) ('2025-04-01 00:03:01', 4220, 1738, 'split_time_score_plaque_Valcor', Decimal('4.0000'), '21878669:plaque_val:1064:0,21892382:plaque_val:1064:0', 2) ('2025-04-01 00:03:01', 4741, 218, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('4.9495'), '21916087:entrant_di:775:0,21916088:entrant_di:775:0,21916089:entrant_di:775:0,21916090:entrant_di:775:0,21916092:entrant_di:775:0,21916093:entrant_di:775:0,21917039:entrant_di:775:0,21917357:entrant_di:775:0,21917360:entrant_di:775:0,21918916:entrant_di:775:0,21918917:entrant_di:775:0,21918918:entrant_di:775:0,21919365:entrant_di:775:0,21919366:entrant_di:775:0,21919644:entrant_di:775:0,21920235:entrant_di:775:0,21920236:entrant_di:775:0,21920559:entrant_di:775:0,21920560:entrant_di:775:0,21920561:entrant_di:775:0,21920562:entrant_di:775:0,21920563:entrant_di:775:0,21921448:entrant_di:775:0,21921449:entrant_di:775:0,21921450:entrant_di:775:0', 25) ('2025-04-01 00:03:01', 4748, 92, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('3.9783'), '21917465:flux_dev_r:739:0,21919762:flux_dev_r:739:0,21922018:flux_dev_r:739:0', 3) ('2025-04-01 00:03:01', 4878, 2964, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '21894590:arc_en_cie:979:0', 1) ('2025-04-01 00:03:01', 4892, 9, 'multi_classification_tapis_dechet', Decimal('0.0000'), '21928446:angers_mon:1017:0', 1) ('2025-04-01 00:03:01', 4925, 104, 'RUBBIA_PEHD_240325_derichebourg', Decimal('3.9327'), '21917393:pehd_pp_di:1017:0,21917399:pehd_pp_di:1017:0,21920674:pehd_pp_di:1017:0,21924613:pehd_pp_di:1017:0', 4) ('2025-04-01 00:03:01', 4926, 90, 'RUBBIA_fluxdev_angers_280325', Decimal('4.4889'), '21917389:flux_dev_d:1017:0,21917391:flux_dev_d:1017:0,21917401:flux_dev_d:1017:0,21920671:flux_dev_d:1017:0,21920676:flux_dev_d:1017:0', 5) 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-04-01 00:03:01', 4219, 2698, 'detection_plaque_valcor_010622') ('2025-04-01 00:03:01', 533, 14274, 'multi_classification_tapis_dechet') ('2025-04-01 00:03:01', 4310, 3171, 'classifieur_2camions_valcor_021122_v1') ('2025-04-01 00:03:01', 4892, 33676, 'multi_classification_tapis_dechet') ('2025-04-01 00:03:01', 3804, 2075, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-01 00:03:01', 3993, 1974, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-04-01 00:03:01', 4433, 675, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-01 00:03:01', 3459, 672, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-01 00:03:01', 4926, 160, 'RUBBIA_fluxdev_angers_280325') ('2025-04-01 00:03:01', 3991, 160, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-04-01 00:03:01', 4748, 480, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-04-01 00:03:01', 4741, 18, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-01 00:03:01', 4234, 12, 'refus_rym_velours_valcor') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 19) (0, 154) (-5, 9) 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-04-01 00:03:43', 4234, 115087, 'refus_rym_velours_valcor') ('2025-04-01 00:03:43', 533, 48728, 'multi_classification_tapis_dechet') ('2025-04-01 00:03:43', 4883, 47563, 'split_time_score_JRM_Arc_En_Ciel') ('2025-04-01 00:03:43', 4876, 47352, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-04-01 00:03:43', 4892, 33952, 'multi_classification_tapis_dechet') ('2025-04-01 00:03:43', 4877, 29397, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-04-01 00:03:43', 4322, 28847, 'RUBBIA_filmPE_151122') ('2025-04-01 00:03:43', 4893, 26010, 'split_time_score_Sevran_test2') ('2025-04-01 00:03:43', 3993, 21504, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-04-01 00:03:43', 3996, 20135, 'RUBBIA_Refus_add_surclassifier_rapport') ('2025-04-01 00:03:43', 3459, 15468, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-01 00:03:43', 4302, 14708, 'RUBBIA_JRM_consolidate') ('2025-04-01 00:03:43', 3804, 13363, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-01 00:03:43', 3994, 12298, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-04-01 00:03:43', 3385, 11413, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-04-01 00:03:43', 4741, 10578, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-01 00:03:43', 3995, 8807, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-04-01 00:03:43', 4219, 8284, 'detection_plaque_valcor_010622') ('2025-04-01 00:03:43', 4748, 7132, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-04-01 00:03:43', 3318, 5099, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-04-01 00:03:43', 4925, 3915, 'RUBBIA_PEHD_240325_derichebourg') ('2025-04-01 00:03:43', 4311, 3620, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-04-01 00:03:43', 4891, 3600, 'split_time_score_angers_montee_convoyeur') ('2025-04-01 00:03:43', 4323, 3440, 'split_time_score_arc_en_ciel_mm') ('2025-04-01 00:03:43', 4310, 3192, 'classifieur_2camions_valcor_021122_v1') ('2025-04-01 00:03:43', 4871, 2965, 'blur_rubbia_live') ('2025-04-01 00:03:43', 4916, 2600, 'split_time_score_Acier_Arc_En_Ciel') ('2025-04-01 00:03:43', 4927, 2354, 'learn_generique_28032025_6000_v2') ('2025-04-01 00:03:43', 3991, 2195, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-04-01 00:03:43', 4433, 1762, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-01 00:03:43', 4926, 1759, 'RUBBIA_fluxdev_angers_280325') ('2025-04-01 00:03:43', 4489, 1391, 'multi_classification_tapis_dechet') ('2025-04-01 00:03:43', 4887, 1340, 'split_time_score_Sevran_test') ('2025-04-01 00:03:43', 4189, 1056, 'split_time_score_JRM_Perlen_convoyeur') ('2025-04-01 00:03:43', 3142, 1020, 'STS_refus_Amiens') ('2025-04-01 00:03:43', 3789, 928, 'split_time_score_test_multi_matiere') ('2025-04-01 00:03:43', 4851, 774, 'split_time_score_SCCU_8') ('2025-04-01 00:03:43', 4849, 736, 'split_time_score_SCCU_6') ('2025-04-01 00:03:43', 4850, 736, 'split_time_score_SCCU_7') ('2025-04-01 00:03:43', 3992, 722, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-04-01 00:03:43', 4746, 483, 'split_time_score_cod_upm_SyctomXV_Mask_23Q1') ('2025-04-01 00:03:43', 4346, 444, 'split_time_score_cedre') ('2025-04-01 00:03:43', 4220, 328, 'split_time_score_plaque_Valcor') ('2025-04-01 00:03:43', 3787, 256, 'split_time_score_urban_fest') ('2025-04-01 00:03:43', 3181, 132, 'split_time_score_JRM_Arc_En_Ciel') ('2025-04-01 00:03:43', 243, 131, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-04-01 00:03:43', 370, 108, 'proportion_papier_qualite_dechets_tri') ('2025-04-01 00:03:43', 3164, 56, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-04-01 00:03:43', 686, 54, 'copy_argmax_crop') ('2025-04-01 00:03:43', 4212, 40, 'ACP_from_port_5709050_type_5619_size_9') ('2025-04-01 00:03:43', 4209, 40, 'test_acp') ('2025-04-01 00:03:43', 4208, 40, 'test_acp_fit_transform_20') ('2025-04-01 00:03:43', 4621, 39, 'tfhub_18_7_2023') ('2025-04-01 00:03:43', 4567, 33, 'tfhub_19_06_2023') ('2025-04-01 00:03:43', 3781, 28, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-04-01 00:03:43', 230, 28, 'datou_test_rotate') ('2025-04-01 00:03:43', 1848, 25, 'Pipeline_upm_photos_blanches') ('2025-04-01 00:03:43', 3990, 20, 'test_crop_condition_blur') ('2025-04-01 00:03:43', 2896, 20, 'test_radom_deformation') ('2025-04-01 00:03:43', 3070, 20, 'test_ventilate_hashtag_type_3326') ('2025-04-01 00:03:43', 40, 18, 'mask_coco_origin') ('2025-04-01 00:03:43', 2719, 16, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-04-01 00:03:43', 3856, 16, 'RUBBIA_Carton_050821_extract_RYM') ('2025-04-01 00:03:43', 4184, 14, 'detection_plaque_valcor_010622') ('2025-04-01 00:03:43', 233, 12, 'datou_test_rotate_conditionnel') ('2025-04-01 00:03:43', 4573, 9, 'test_sam_h') ('2025-04-01 00:03:43', 1026, 9, 'mask_coco_for_test') ('2025-04-01 00:03:43', 4553, 8, 'copie_4387_test_replace') ('2025-04-01 00:03:43', 4492, 8, 'copie_4387_test_replace') ('2025-04-01 00:03:43', 2, 7, 'classification_model') ('2025-04-01 00:03:43', 571, 6, 'datou_test_flip') ('2025-04-01 00:03:43', 1818, 4, 'blanchir') ('2025-04-01 00:03:43', 2041, 4, 'test_data_aug') ('2025-04-01 00:03:43', 2085, 4, 'train_points_upm_darker') ('2025-04-01 00:03:43', 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 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (2013, 'Lost connection to MySQL server during query') 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 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: (1053, 'Server shutdown in progress') Command exited with non-zero status 1 0.20user 0.15system 7:08:37elapsed 0%CPU (0avgtext+0avgdata 33024maxresident)k 48624inputs+40outputs (3016major+8387minor)pagefaults 0swaps