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: 14/04/2025, 00:01:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-04-14 00:01:25', 504) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-04-14 00:01:25', 694904) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-04-14 00:38:47', 66) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-04-14 00:38:47', 42527) 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-14 00:39:31', 4310, 59339, 26592, 32747, 'classifieur_2camions_valcor_021122_v1', 212.0, '21894409:dechet_val:991:0,21932448:dechet_val:991:0,21964660:dechet_val:991:1,22004773:dechet_val:991:1,22052008:dechet_val:991:1,22083520:dechet_val:991:1,22311108:dechet_val:991:1,22328825:dechet_val:991:1', 8) ('2025-04-14 00:39:31', 4219, 8281, 3948, 4333, 'detection_plaque_valcor_010622', 804.0, '20593540:plaque_val:1064:1,20625708:plaque_val:1064:1,20658354:plaque_val:1064:1,22312570:plaque_val:1064:1,22327423:plaque_val:1064:1', 5) ('2025-04-14 00:39:31', 4433, 3360, 1365, 1995, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 245.51111111111112, '22013882:JRM_diff_b:1053:0,22013883:JRM_diff_b:1053:0,22013884:JRM_diff_b:1053:0,22013885:JRM_diff_b:1053:0,22013886:JRM_diff_b:1053:0,22014129:JRM_diff_b:1053:0,22014130:JRM_diff_b:1053:0,22014131:JRM_diff_b:1053:0,22014133:JRM_diff_b:1053:0,22014134:JRM_diff_b:1053:0,22014135:JRM_diff_b:1053:0,22014136:JRM_diff_b:1053:0,22014592:JRM_diff_b:1053:0,22014594:JRM_diff_b:1053:0,22014595:JRM_diff_b:1053:0,22014596:JRM_diff_b:1053:0,22014881:JRM_diff_b:1053:0,22014883:JRM_diff_b:1053:0,22014885:JRM_diff_b:1053:0,22014887:JRM_diff_b:1053:0,22014889:JRM_diff_b:1053:0,22015083:JRM_diff_b:1053:0,22015090:JRM_diff_b:1053:0,22015093:JRM_diff_b:1053:0,22015297:JRM_diff_b:1053:0,22015582:JRM_diff_b:1053:0,22015583:JRM_diff_b:1053:0,22015584:JRM_diff_b:1053:0,22015585:JRM_diff_b:1053:0,22015586:JRM_diff_b:1053:0,22018565:JRM_diff_b:1053:0,22019802:JRM_diff_b:1053:0,22019803:JRM_diff_b:1053:0,22062226:JRM_diff_b:1053:0,22062227:JRM_diff_b:1053:0,22062228:JRM_diff_b:1053:0,22062230:JRM_diff_b:1053:0,22065377:JRM_diff_b:1053:', 45) ('2025-04-14 00:39:31', 3804, 4282, 3278, 1004, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 221.28813559322035, '21993371:pet_clair_:739:0,22009681:pet_clair_:739:0,22014822:pet_clair_:1017:0,22022346:pet_clair_:739:0,22023872:pet_clair_:1017:0,22035184:pet_clair_:1017:0,22036577:pet_clair_:739:0,22055708:pet_clair_:739:0,22057685:pet_clair_:739:0,22057692:pet_clair_:739:0,22058817:pet_clair_:1017:0,22061806:pet_clair_:739:0,22061820:pet_clair_:739:0,22066201:pet_clair_:739:0,22066338:pet_clair_:739:0,22066744:pet_clair_:739:0,22066645:pet_clair_:739:0,22066792:pet_clair_:739:0,22066511:pet_clair_:739:0,22066566:pet_clair_:739:0,22066575:pet_clair_:739:0,22066583:pet_clair_:739:0,22067098:pet_clair_:739:0,22067189:pet_clair_:739:0,22067129:pet_clair_:739:0,22067233:pet_clair_:739:0,22067299:pet_clair_:739:0,22067308:pet_clair_:739:0,22067376:pet_clair_:739:0,22067408:pet_clair_:739:0,22067884:pet_clair_:739:1,22067902:pet_clair_:739:1,22067932:pet_clair_:739:1,22068104:pet_clair_:739:0,22068116:pet_clair_:739:0,22068135:pet_clair_:739:0,22068153:pet_clair_:739:0,22068179:pet_clair_:739:0,22068193:pet_clair_:739:0,220682', 118) ('2025-04-14 00:39:31', 4234, 1495, 622, 873, 'refus_rym_velours_valcor', 12.3125, '22331537:truck_diff:991:0,22331551:truck_diff:991:1,22331640:truck_diff:991:1,22331658:truck_diff:991:1,22331700:truck_diff:991:0,22331734:truck_diff:991:0,22331815:truck_diff:991:1,22331917:truck_diff:991:1,22332033:truck_diff:991:1,2('2025-04-14 00:39:33', 3543, 66, 'cod_pipline_qualipapia_automatique_cod', Decimal('308.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) 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-14 00:39:33', 4219, 4440, 'detection_plaque_valcor_010622') ('2025-04-14 00:39:33', 4926, 343, 'RUBBIA_fluxdev_angers_280325') ('2025-04-14 00:39:33', 4310, 31476, 'classifieur_2camions_valcor_021122_v1') ('2025-04-14 00:39:33', 533, 727, 'multi_classification_tapis_dechet') ('2025-04-14 00:39:33', 3804, 3297, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-14 00:39:33', 3993, 1078, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-04-14 00:39:33', 4748, 1028, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-04-14 00:39:33', 3992, 340, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-04-14 00:39:33', 4433, 405, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-14 00:39:33', 4234, 3674, 'refus_rym_velours_valcor') ('2025-04-14 00:39:33', 3996, 287, 'RUBBIA_Refus_add_surclassifier_rapport') Nombre de datous demandés par statut ('statut', 'nombre de datous') (0, 383) (1, 132) 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-14 00:39:43', 4234, 311475, 'refus_rym_velours_valcor') ('2025-04-14 00:39:43', 3804, 116182, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-04-14 00:39:43', 4748, 82275, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-04-14 00:39:43', 4310, 45429, 'classifieur_2camions_valcor_021122_v1') ('2025-04-14 00:39:43', 3993, 32783, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-04-14 00:39:43', 533, 24227, 'multi_classification_tapis_dechet') ('2025-04-14 00:39:43', 3459, 13727, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-14 00:39:43', 3991, 9557, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-04-14 00:39:43', 4892, 9198, 'multi_classification_tapis_dechet') ('2025-04-14 00:39:43', 3992, 8795, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-04-14 00:39:43', 4433, 8424, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-04-14 00:39:43', 4219, 5982, 'detection_plaque_valcor_010622') ('2025-04-14 00:39:43', 4926, 1599, 'RUBBIA_fluxdev_angers_280325') ('2025-04-14 00:39:43', 4311, 1200, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-04-14 00:39:43', 3789, 1160, 'split_time_score_test_multi_matiere') ('2025-04-14 00:39:43', 4851, 758, 'split_time_score_SCCU_8') ('2025-04-14 00:39:43', 4850, 758, 'split_time_score_SCCU_7') ('2025-04-14 00:39:43', 4220, 750, 'split_time_score_plaque_Valcor') ('2025-04-14 00:39:43', 4916, 700, 'split_time_score_Acier_Arc_En_Ciel') ('2025-04-14 00:39:43', 3142, 600, 'STS_refus_Amiens') ('2025-04-14 00:39:43', 3996, 585, 'RUBBIA_Refus_add_surclassifier_rapport') ('2025-04-14 00:39:43', 4849, 564, 'split_time_score_SCCU_6') ('2025-04-14 00:39:43', 4742, 553, 'entrant_consolidate') ('2025-04-14 00:39:43', 4878, 548, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-04-14 00:39:43', 4323, 440, 'split_time_score_arc_en_ciel_mm') ('2025-04-14 00:39:43', 3787, 320, 'split_time_score_urban_fest') ('2025-04-14 00:39:43', 4891, 200, 'split_time_score_angers_montee_convoyeur') ('2025-04-14 00:39:43', 3181, 165, 'split_time_score_JRM_Arc_En_Ciel') ('2025-04-14 00:39:43', 243, 156, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-04-14 00:39:43', 370, 117, 'proportion_papier_qualite_dechets_tri') ('2025-04-14 00:39:43', 4189, 100, 'split_time_score_JRM_Perlen_convoyeur') ('2025-04-14 00:39:43', 4893, 88, 'split_time_score_Sevran_test2') ('2025-04-14 00:39:43', 3164, 70, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-04-14 00:39:43', 686, 54, 'copy_argmax_crop') ('2025-04-14 00:39:43', 4208, 50, 'test_acp_fit_transform_20') ('2025-04-14 00:39:43', 4209, 50, 'test_acp') ('2025-04-14 00:39:43', 4212, 50, 'ACP_from_port_5709050_type_5619_size_9') ('2025-04-14 00:39:43', 4621, 36, 'tfhub_18_7_2023') ('2025-04-14 00:39:43', 4567, 36, 'tfhub_19_06_2023') ('2025-04-14 00:39:43', 3781, 35, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-04-14 00:39:43', 4302, 32, 'RUBBIA_JRM_consolidate') ('2025-04-14 00:39:43', 3990, 25, 'test_crop_condition_blur') ('2025-04-14 00:39:43', 2896, 25, 'test_radom_deformation') ('2025-04-14 00:39:43', 3070, 25, 'test_ventilate_hashtag_type_3326') ('2025-04-14 00:39:43', 1848, 25, 'Pipeline_upm_photos_blanches') ('2025-04-14 00:39:43', 230, 24, 'datou_test_rotate') ('2025-04-14 00:39:43', 3385, 20, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-04-14 00:39:43', 3856, 20, 'RUBBIA_Carton_050821_extract_RYM') ('2025-04-14 00:39:43', 40, 17, 'mask_coco_origin') ('2025-04-14 00:39:43', 233, 12, 'datou_test_rotate_conditionnel') ('2025-04-14 00:39:43', 4184, 12, 'detection_plaque_valcor_010622') ('2025-04-14 00:39:43', 2719, 12, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-04-14 00:39:43', 4573, 11, 'test_sam_h') ('2025-04-14 00:39:43', 4492, 10, 'copie_4387_test_replace') ('2025-04-14 00:39:43', 4553, 10, 'copie_4387_test_replace') ('2025-04-14 00:39:43', 1026, 10, 'mask_coco_for_test') ('2025-04-14 00:39:43', 2, 6, 'classification_model') ('2025-04-14 00:39:43', 571, 6, 'datou_test_flip') ('2025-04-14 00:39:43', 1818, 5, 'blanchir') ('2025-04-14 00:39:43', 2041, 5, 'test_data_aug') ('2025-04-14 00:39:43', 2085, 5, 'train_points_upm_darker') ('2025-04-14 00:39: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/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.24user 0.11system 8:33:56elapsed 0%CPU (0avgtext+0avgdata 33996maxresident)k 28496inputs+48outputs (2476major+8568minor)pagefaults 0swaps