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: 22/02/2025, 07:00:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-02-22 07:00:25', 209) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-02-22 07:00:25', 577668) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-02-22 07:01:32', 22208) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-02-22 07:01:32', 1303) 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-22 07:01:34', 3993, 973, 500, 473, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 14.5, '20703324:emr_diff_b:739:0,20681351:pcnc_diff_:739:0,20684264:emr_diff_b:1017:0,20681357:pcnc_diff_:739:0,20680377:emr_diff_b:1017:0,20677298:emr_diff_b:1017:0,20688394:emr_diff_b:1017:0,20690027:emr_diff_b:1017:0,20681341:pcnc_diff_:739:0,20681342:emr_diff_b:739:0,20681348:pcnc_diff_:739:0,20695689:emr_diff_b:1017:0,20699473:emr_diff_b:739:0,20699441:emr_diff_b:739:0,20708750:emr_diff_b:739:0,20708748:emr_diff_b:739:0,20699413:pcnc_diff_:739:0,20699414:emr_diff_b:739:0,20699443:emr_diff_b:739:0,20739144:pcnc_diff_:739:0,20741333:emr_diff_b:739:0,20742477:emr_diff_b:739:1', 22) ('2025-02-22 07:01:34', 4892, 3020, 2571, 449, 'multi_classification_tapis_dechet', 6.0, '20738675:angers_mon:1017:1,20742056:sevran_122:739:1', 2) ('2025-02-22 07:01:34', 3992, 164, 40, 124, 'RUBBIA_Alu_131221_add_surclassifier_rapport', 15.0, '20622470:aluminium_:739:0,20728871:aluminium_:1017:0', 2) ('2025-02-22 07:01:34', 4322, 379, 260, 119, 'RUBBIA_filmPE_151122', 15.2, '20729331:film_pedb_:739:0,20744716:film_pedb_:739:1,20730968:film_pedb_:1017:0,20730085:film_pedb_:1017:1,20729787:film_pedb_:1017:0,20727289:film_pedb_:1017:1,20729330:film_pedb_:739:0,20722874:film_pedb_:1017:1,20720579:film_pedb_:1017:0,20699407:film_pedb_:739:1', 10) ('2025-02-22 07:01:34', 4234, 181, 74, 107, 'refus_rym_velours_valcor', 9.833333333333334, '20747445:incinerati:1103:1,20733623:incinerati:1103:1,20733626:incinerati:1103:1,20747443:incinerati:1103:1,20724468:truck_diff:991:0,20718164:truck_diff:991:0', 6) ('2025-02-22 07:01:34', 3804, 99, 80, 19, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 3.0, '20744714:pet_clair_:739:1', 1) ('2025-02-22 07:01:34', 4310, 1086, 1074, 12, 'classifieur_2camions_valcor_021122_v1', 3.0, '20745849:dechet_val:991:0', 1) ('2025-02-22 07:01:34', 3994, 9, 9, 0, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 14.0, '20729334:pcm_diff_b:739:1', 1) ('2025-02-22 07:01:34', 4866, 22, 22, 0, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam', 105.88888888888889, '20603553:dib_diff_b:440:1,20607424:excoffier_:440:1,20603410:dib_diff_b:440:1,20603413:dib_diff_b:440:1,20603414:dib_diff_b:440:1,20603521:dib_diff_b:440:1,20603524:dib_diff_b:440:1,20603551:dib_diff_b:440:1,20603587:dib_diff_b:440:1,20675517:excoffier_:1117:1,20608797:excoffier_:1117:1,20603555:dib_diff_b:440:1,20608796:excoffier_:1117:1,20608795:excoffier_:1117:1,20603557:dib_diff_b:440:1,20603559:dib_diff_b:440:1,20603562:dib_diff_b:440:1,20603580:dib_diff_b:440:1', 18) 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-22 07:01:34', 3991, 15, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('4.0000'), '20742478:ela_diff_b:739:0', 1) ('2025-02-22 07:01:34', 3993, 398, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('5.3693'), '20739126:pcnc_diff_:739:0,20739127:emr_diff_b:739:0,20739128:emr_diff_b:739:0,20739129:pcnc_diff_:739:0,20739130:emr_diff_b:739:0,20739140:emr_diff_b:739:0,20739141:pcnc_diff_:739:0,20739143:emr_diff_b:739:0,20741322:pcnc_diff_:739:0,20741324:emr_diff_b:739:0,20742474:emr_diff_b:739:0,20742475:pcnc_diff_:739:0,20742476:emr_diff_b:739:0', 13) ('2025-02-22 07:01:34', 3994, 34, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('5.0588'), '20739132:pcm_diff_b:739:0,20742530:pcm_diff_b:739:0', 2) ('2025-02-22 07:01:34', 4219, 3565, 'detection_plaque_valcor_010622', Decimal('59.4210'), '20625708:plaque_val:1064:0,20658354:plaque_val:1064:0,20675558:plaque_val:1064:0,20699287:plaque_val:1064:0,20739642:plaque_val:1064:0', 5) ('2025-02-22 07:01:34', 4220, 1447, 'split_time_score_plaque_Valcor', Decimal('0.0000'), '20699287:plaque_val:1064:0,20739642:plaque_val:1064:0', 2) ('2025-02-22 07:01:34', 4234, 83, 'refus_rym_velours_valcor', Decimal('8.7831'), '20733597:incinerati:1103:0,20733598:incinerati:1103:0,20733599:incinerati:1103:0,20733600:incinerati:1103:0,20733601:incinerati:1103:0,20733602:incinerati:1103:0,20733603:incinerati:1103:0,20733604:incinerati:1103:0,20733605:incinerati:1103:0,20733606:incinerati:1103:0,20733607:incinerati:1103:0,20733608:incinerati:1103:0,20733609:incinerati:1103:0,20733610:incinerati:1103:0,20733611:incinerati:1103:0,20733612:incinerati:1103:0,20733613:incinerati:1103:0,20733614:incinerati:1103:0,20733615:incinerati:1103:0,20733616:incinerati:1103:0,20733617:incinerati:1103:0,20733618:incinerati:1103:0,20733619:incinerati:1103:0,20733620:incinerati:1103:0,20733621:incinerati:1103:0,20733622:incinerati:1103:0,20733624:incinerati:1103:0,20733625:incinerati:1103:0,20733627:incinerati:1103:0,20733628:incinerati:1103:0,20733630:incinerati:1103:0,20733631:incinerati:1103:0,20733633:incinerati:1103:0,20733636:incinerati:1103:0,20733640:incinerati:1103:0,20733643:incinerati:1103:0,20733645:incinerati:1103:0,20747444:incinerati:1103:', 38) ('2025-02-22 07:01:34', 4311, 5697, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('1.0000'), '20708309:dechet_val:991:1', 1) ('2025-02-22 07:01:34', 4322, 221, 'RUBBIA_filmPE_151122', Decimal('5.2760'), '20734875:film_pedb_:1017:0,20739124:film_pedb_:739:0,20741323:film_pedb_:739:0,20741326:film_pedb_:739:0,20741328:film_pedb_:739:0,20741330:film_pedb_:739:0,20744711:film_pedb_:739:0,20744715:film_pedb_:739:0', 8) ('2025-02-22 07:01:34', 4887, 9336, 'split_time_score_Sevran_test', Decimal('0.0000'), '20713767:sevran_122:739:0,20742056:sevran_122:739:0', 2) ('2025-02-22 07:01:34', 4891, 1340, 'split_time_score_angers_montee_convoyeur', Decimal('0.0000'), '20738675:angers_mon:1017:0', 1) ('2025-02-22 07:01:34', 4893, 72, 'split_time_score_Sevran_test2', Decimal('0.0000'), '20728384:sevran_122:739:0,20738870:sevran_122:739:0', 2) 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-22 07:01:34', 4866, 30, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-02-22 07:01:34', 3992, 320, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-02-22 07:01:34', 3993, 4000, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-02-22 07:01:34', 4322, 1460, 'RUBBIA_filmPE_151122') ('2025-02-22 07:01:34', 4234, 459, 'refus_rym_velours_valcor') ('2025-02-22 07:01:34', 3994, 9, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-02-22 07:01:34', 4892, 7293, 'multi_classification_tapis_dechet') ('2025-02-22 07:01:34', 3804, 640, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-02-22 07:01:34', 4310, 3222, 'classifieur_2camions_valcor_021122_v1') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 34) (-5, 19) (0, 172) 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-22 07:01:40', 4234, 131932, 'refus_rym_velours_valcor') ('2025-02-22 07:01:40', 4883, 69750, 'split_time_score_JRM_Arc_En_Ciel') ('2025-02-22 07:01:40', 4876, 69041, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-02-22 07:01:40', 4892, 52245, 'multi_classification_tapis_dechet') ('2025-02-22 07:01:40', 3459, 38193, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-22 07:01:40', 4877, 37115, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-02-22 07:01:40', 3993, 34310, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-02-22 07:01:40', 4302, 23768, 'RUBBIA_JRM_consolidate') ('2025-02-22 07:01:40', 3804, 23312, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-02-22 07:01:40', 4310, 21181, 'classifieur_2camions_valcor_021122_v1') ('2025-02-22 07:01:40', 3995, 11758, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-02-22 07:01:40', 4153, 10645, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-02-22 07:01:40', 4322, 9556, 'RUBBIA_filmPE_151122') ('2025-02-22 07:01:40', 3318, 7514, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-02-22 07:01:40', 533, 6600, 'multi_classification_tapis_dechet') ('2025-02-22 07:01:40', 4433, 4777, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-22 07:01:40', 4891, 4200, 'split_time_score_angers_montee_convoyeur') ('2025-02-22 07:01:40', 4311, 2900, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-02-22 07:01:40', 4871, 2739, 'blur_rubbia_live') ('2025-02-22 07:01:40', 4866, 2553, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-02-22 07:01:40', 3385, 1834, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-02-22 07:01:40', 3991, 1583, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-02-22 07:01:40', 3992, 1405, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-02-22 07:01:40', 4189, 1200, 'split_time_score_JRM_Perlen_convoyeur') ('2025-02-22 07:01:40', 4893, 1191, 'split_time_score_Sevran_test2') ('2025-02-22 07:01:40', 3789, 928, 'split_time_score_test_multi_matiere') ('2025-02-22 07:01:40', 4849, 864, 'split_time_score_SCCU_6') ('2025-02-22 07:01:40', 4851, 645, 'split_time_score_SCCU_8') ('2025-02-22 07:01:40', 4878, 500, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-02-22 07:01:40', 4850, 426, 'split_time_score_SCCU_7') ('2025-02-22 07:01:40', 4887, 400, 'split_time_score_Sevran_test') ('2025-02-22 07:01:40', 4220, 400, 'split_time_score_plaque_Valcor') ('2025-02-22 07:01:40', 4910, 385, 'pehd_prod_consolidate') ('2025-02-22 07:01:40', 4254, 337, 'pet_fonce_prod_consolidate') ('2025-02-22 07:01:40', 4255, 336, 'pet_clair_prod_consolidate') ('2025-02-22 07:01:40', 4251, 273, 'ela_prod_consolidate') ('2025-02-22 07:01:40', 3787, 256, 'split_time_score_urban_fest') ('2025-02-22 07:01:40', 3181, 132, 'split_time_score_JRM_Arc_En_Ciel') ('2025-02-22 07:01:40', 243, 104, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-02-22 07:01:40', 370, 75, 'proportion_papier_qualite_dechets_tri') ('2025-02-22 07:01:40', 3164, 56, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-02-22 07:01:40', 4212, 40, 'ACP_from_port_5709050_type_5619_size_9') ('2025-02-22 07:01:40', 4209, 40, 'test_acp') ('2025-02-22 07:01:40', 4208, 40, 'test_acp_fit_transform_20') ('2025-02-22 07:01:40', 3994, 36, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-02-22 07:01:40', 686, 36, 'copy_argmax_crop') ('2025-02-22 07:01:40', 4567, 33, 'tfhub_19_06_2023') ('2025-02-22 07:01:40', 4621, 33, 'tfhub_18_7_2023') ('2025-02-22 07:01:40', 3781, 28, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-02-22 07:01:40', 230, 24, 'datou_test_rotate') ('2025-02-22 07:01:40', 3990, 20, 'test_crop_condition_blur') ('2025-02-22 07:01:40', 1848, 20, 'Pipeline_upm_photos_blanches') ('2025-02-22 07:01:40', 2896, 20, 'test_radom_deformation') ('2025-02-22 07:01:40', 3070, 20, 'test_ventilate_hashtag_type_3326') ('2025-02-22 07:01:40', 40, 18, 'mask_coco_origin') ('2025-02-22 07:01:40', 3856, 16, 'RUBBIA_Carton_050821_extract_RYM') ('2025-02-22 07:01:40', 2719, 14, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-02-22 07:01:40', 4184, 12, 'detection_plaque_valcor_010622') ('2025-02-22 07:01:40', 4573, 10, 'test_sam_h') ('2025-02-22 07:01:40', 1026, 10, 'mask_coco_for_test') ('2025-02-22 07:01:40', 4553, 8, 'copie_4387_test_replace') ('2025-02-22 07:01:40', 4492, 8, 'copie_4387_test_replace') ('2025-02-22 07:01:40', 233, 8, 'datou_test_rotate_conditionnel') ('2025-02-22 07:01:40', 2, 6, 'classification_model') ('2025-02-22 07:01:40', 2665, 4, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920') ('2025-02-22 07:01:40', 2085, 4, 'train_points_upm_darker') ('2025-02-22 07:01:40', 2041, 4, 'test_data_aug') ('2025-02-22 07:01:40', 1818, 4, 'blanchir') ('2025-02-22 07:01:40', 571, 4, 'datou_test_flip') ('2025-02-22 07:01:40', 4914, 2, 'split_time_score_excoffier_gravat_labman') 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: (1053, 'Server shutdown in progress') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 43, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 179, in __init__ super(Connection, self).__init__(*args, **kwargs2) MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (111)") 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 77, in select self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 46, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) Exception: Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (111)") Command exited with non-zero status 1 0.19user 0.08system 9:37.33elapsed 0%CPU (0avgtext+0avgdata 36456maxresident)k 22384inputs+40outputs (664major+7722minor)pagefaults 0swaps