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: 10/03/2025, 00:01:26 Nombre de datou current ('date', 'nombre de datou current') ('2025-03-10 00:01:26', 928) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-03-10 00:01:26', 547347) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-03-10 00:14:45', 28191) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-03-10 00:14:45', 6388) 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-03-10 00:15:39', 4219, 5848, 2728, 3120, 'detection_plaque_valcor_010622', 167.0, '20658354:plaque_val:1064:0,21093986:plaque_val:1064:0,21130800:plaque_val:1064:0,21163827:plaque_val:1064:0', 4) ('2025-03-10 00:15:39', 4489, 2546, 1212, 1334, 'multi_classification_tapis_dechet', 95.33333333333333, '20995110:cedre_arge:1080:0,21090076:cedre_arge:1080:0,21165468:cedre_arge:1080:0', 3) ('2025-03-10 00:15:39', 4322, 3218, 1912, 1306, 'RUBBIA_filmPE_151122', 79.28571428571429, '21010623:film_pedb_:739:0,21033315:film_pedb_:1017:0,21049097:film_pedb_:739:0,21049814:film_pedb_:1017:0,21064481:film_pedb_:739:0,21071194:film_pedb_:1017:0,21080849:film_pedb_:1017:0,21082430:film_pedb_:739:0,21089619:film_pedb_:739:0,21089620:film_pedb_:739:1,21089669:film_pedb_:739:0,21091671:film_pedb_:739:0,21092007:film_pedb_:739:0,21092016:film_pedb_:739:0,21104063:film_pedb_:739:0,21104073:film_pedb_:739:0,21104105:film_pedb_:739:0,21104181:film_pedb_:739:0,21109992:film_pedb_:1017:0,21109991:film_pedb_:739:0,21112971:film_pedb_:1017:0,21114544:film_pedb_:739:0,21117586:film_pedb_:1017:0,21120260:film_pedb_:1017:0,21120278:film_pedb_:1017:0,21120290:film_pedb_:1017:0,21120299:film_pedb_:1017:0,21120306:film_pedb_:1017:0,21120583:film_pedb_:1017:0,21120960:film_pedb_:1017:0,21120992:film_pedb_:1017:0,21121002:film_pedb_:1017:0,21122347:film_pedb_:1017:0,21122360:film_pedb_:1017:0,21122400:film_pedb_:1017:0,21122457:film_pedb_:1017:0,21122464:film_pedb_:1017:0,21122469:film_pedb_:1017:0,21123360:film_', 91) ('2025-03-10 00:15:39', 3994, 1320, 1015, 305, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 72.59615384615384, '21089668:pcm_diff_b:739:0,21112973:gm_diff_ba:1017:0,21117031:gm_diff_ba:1017:0,21120262:gm_diff_ba:1017:0,21120271:gm_diff_ba:1017:0,21120309:gm_diff_ba:1017:0,21120522:gm_diff_ba:1017:0,21120562:gm_diff_ba:1017:0,21120928:gm_diff_ba:1017:0,21120958:gm_diff_ba:1017:0,21120987:gm_diff_ba:1017:0,21120994:gm_diff_ba:1017:0,21121005:gm_diff_ba:1017:0,21122302:gm_diff_ba:1017:0,21122304:gm_diff_ba:1017:0,21122346:gm_diff_ba:1017:0,21122456:gm_diff_ba:1017:0,21122468:gm_diff_ba:1017:0,21123352:gm_diff_ba:1017:0,21123368:gm_diff_ba:1017:0,20833037:emr_diff_b:1017:0,21123998:gm_diff_ba:1017:0,21124009:gm_diff_ba:1017:0,20742145:jrm_diff_b:1017:0,21124059:gm_diff_ba:1017:0,21125560:gm_diff_ba:1017:0,20688365:jrm_diff_b:1017:0,21125609:gm_diff_ba:1017:0,20695689:emr_diff_b:1017:0,21125615:gm_diff_ba:1017:0,21125626:gm_diff_ba:1017:0,21001227:gm_diff_ba:1017:0,21001287:gm_diff_ba:1017:0,21053262:gm_diff_ba:1017:0,21053264:gm_diff_ba:1017:0,21053706:gm_diff_ba:1017:0,21053720:gm_diff_ba:1017:0,21054293:gm_diff_ba:1017:0', 52) ('2025-03-10 00:15:39', 3991, 393, 260, 133, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 72.0, '21117583:ela_diff_b:1017:0,21120585:ela_diff_b:1017:0,21120953:ela_diff_b:1017:0,21120982:ela_diff_b:1017:0,21122482:ela_diff_b:1017:0,21123359:ela_diff_b:1017:0,21001284:ela_diff_b:1017:0,21053272:ela_diff_b:1017:0,21053297:ela_diff_b:1017:0,21001694:ela_diff_b:1017:0,21001717:ela_diff_b:1017:0,21143651:ela_diff_b:1017:0,21173043:ela_diff_b:1017:0', 13) ('2025-03-10 00:15:39', 533, 162, 66, 96, 'multi_classification_tapis_dechet', 0.0, '21214869:jetson_tes:739:1,21214918:aec_metal_:739:1', 2) ('2025-03-10 00:15:39', 4234, 163, 77, 86, 'refus_rym_velours_valcor', 0.2222222222222222, '21211784:incinerati:1103:1,21214895:truck_diff:991:1,21214896:truck_diff:991:1,21214897:truck_diff:991:1,21214916:truck_diff:991:1,21214917:truck_diff:991:1,21214919:truck_diff:991:1,21214941:truck_diff:991:1,21214942:truck_diff:991:1', 9) ('2025-03-10 00:15:39', 4310, 14207, 14181, 26, 'classifieur_2camions_valcor_021122_v1', 32.0, '21167974:dechet_val:991:0,21198295:dechet_val:991:0', 2) ('2025-03-10 00:15:39', 4650, 7, 2, 5, 'sem_seg_film_PE_08_23', 59.0, '21066813:AutoGenera:31:0', 1) ('2025-03-10 00:15:39', 4748, 42, 40, 2, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 111.5, '21010905:flux_dev_r:739:0,21092008:flux_dev_r:739:0', 2) ('2025-03-10 00:15:39', 4866, 4, 4, 0, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam', 489.0, '20603557:dib_diff_b:440:1,20603562:dib_diff_b:440:1,20603587:dib_diff_b:440:1', 3) 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-03-10 00:15:41', 3991, 366, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('61.5328'), '21026651:ela_diff_b:739:0,21055192:ela_diff_b:1017:0,21056532:ela_diff_b:1017:0,21059205:ela_diff_b:1017:0,21059359:ela_diff_b:1017:0,21059806:ela_diff_b:1017:0,21135532:ela_diff_b:739:0,21136810:ela_diff_b:739:0,21136824:ela_diff_b:739:0,21136910:ela_diff_b:1017:0,21137168:ela_diff_b:739:0,21139048:ela_diff_b:1017:0,21140594:ela_diff_b:1017:0,21172726:ela_diff_b:1017:0,21172923:ela_diff_b:1017:0', 15) ('2025-03-10 00:15:41', 3992, 248, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('59.5766'), '21002710:aluminium_:1017:0,21053146:aluminium_:739:0,21055166:aluminium_:1017:0,21055579:aluminium_:1017:0,21058334:aluminium_:1017:0,21135544:aluminium_:1017:0,21136794:aluminium_:739:0,21136807:aluminium_:739:0,21136826:aluminium_:739:0,21136917:aluminium_:1017:0,21137275:aluminium_:1017:0,21137301:aluminium_:1017:0,21137314:aluminium_:1017:0,21138587:aluminium_:1017:0,21138610:aluminium_:1017:0,21138611:aluminium_:1017:0,21138728:aluminium_:1017:0,21138752:aluminium_:1017:0,21140596:aluminium_:1017:0,21146336:aluminium_:739:0,21151378:aluminium_:1017:0,21172809:aluminium_:1017:0,21172887:aluminium_:1017:0,21172892:aluminium_:1017:0', 24) ('2025-03-10 00:15:41', 3994, 6163, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('63.3171'), '19428659:emr_diff_b:1017:0,19438276:emr_diff_b:1017:0,19458329:emr_diff_b:1017:0,19458789:emr_diff_b:1017:0,19460977:emr_diff_b:1017:0,19467828:emr_diff_b:1017:0,19469398:emr_diff_b:1017:0,19474557:jrm_diff_b:1017:0,19474561:emr_diff_b:1017:0,19474563:emr_diff_b:1017:0,19477264:jrm_diff_b:1017:0,19498629:emr_diff_b:1017:0,19500653:emr_diff_b:1017:0,19505863:emr_diff_b:1017:0,19516423:emr_diff_b:1017:0,19516780:emr_diff_b:1017:0,19524618:emr_diff_b:1017:0,19543451:emr_diff_b:1017:0,19571015:emr_diff_b:1017:0,19580444:emr_diff_b:1017:0,19581718:emr_diff_b:1017:0,20410111:emr_diff_b:1017:0,20411272:emr_diff_b:1017:0,20421518:emr_diff_b:1017:0,20451769:emr_diff_b:1017:0,20454229:emr_diff_b:1017:0,20455316:emr_diff_b:1017:0,20477525:jrm_diff_b:1017:0,20479234:emr_diff_b:1017:0,20479473:emr_diff_b:1017:0,20485444:emr_diff_b:1017:0,20489623:emr_diff_b:1017:0,20513203:emr_diff_b:1017:0,20515633:emr_diff_b:1017:0,20515635:emr_diff_b:1017:0,20515637:refus_diff:1017:0,20524360:jrm_diff_b:1017:0,20561523:emr_diff_b:1017:', 419) ('2025-03-10 00:15:41', 4219, 14280, 'detection_plaque_valcor_010622', Decimal('300.4307'), '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,20821622:plaque_val:1064:0,20860771:plaque_val:1064:0,20901341:plaque_val:1064:0,20944761:plaque_val:1064:0,20954168:plaque_val:1064:0,20958095:plaque_val:1064:0,20999208:plaque_val:1064:0,21035886:plaque_val:1064:0', 15) ('2025-03-10 00:15:41', 4234, 29, 'refus_rym_velours_valcor', Decimal('0.0000'), '21214886:truck_diff:991:0,21214887:truck_diff:991:0,21214888:truck_diff:991:0,21214889:truck_diff:991:0,21214891:truck_diff:991:0,21214892:truck_diff:991:0', 6) ('2025-03-10 00:15:41', 4322, 5034, 'RUBBIA_filmPE_151122', Decimal('62.7068'), '21002620:film_pedb_:1017:0,21002631:film_pedb_:1017:0,21002634:film_pedb_:1017:0,21002636:film_pedb_:1017:0,21002641:film_pedb_:1017:0,21002717:film_pedb_:1017:0,21002718:film_pedb_:1017:0,21002724:film_pedb_:1017:0,21024404:film_pedb_:739:0,21053141:film_pedb_:739:0,21054591:film_pedb_:1017:0,21054601:film_pedb_:1017:0,21054607:film_pedb_:1017:0,21054610:film_pedb_:1017:0,21054615:film_pedb_:1017:0,21054634:film_pedb_:1017:0,21054637:film_pedb_:1017:0,21054640:film_pedb_:1017:0,21054648:film_pedb_:1017:0,21055165:film_pedb_:1017:0,21055177:film_pedb_:1017:0,21055180:film_pedb_:1017:0,21055182:film_pedb_:1017:0,21055191:film_pedb_:1017:0,21055196:film_pedb_:1017:0,21055518:film_pedb_:1017:0,21055550:film_pedb_:1017:0,21055582:film_pedb_:1017:0,21055633:film_pedb_:1017:0,21055639:film_pedb_:1017:0,21055659:film_pedb_:1017:0,21055665:film_pedb_:1017:0,21056506:film_pedb_:1017:0,21056508:film_pedb_:1017:0,21056516:film_pedb_:1017:0,21056525:film_pedb_:1017:0,21058220:film_pedb_:1017:0,21058225:film_pedb_:1017:0,', 156) ('2025-03-10 00:15:41', 4346, 897, 'split_time_score_cedre', Decimal('56.0000'), '21090076:cedre_arge:1080:0', 1) ('2025-03-10 00:15:41', 4489, 946, 'multi_classification_tapis_dechet', Decimal('72.0000'), '21130766:cedre_arge:1080:0', 1) ('2025-03-10 00:15:41', 4748, 183, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('60.1803'), '21025313:flux_dev_r:739:0,21026649:flux_dev_r:739:0,21029270:flux_dev_r:739:0,21135533:flux_dev_r:739:0,21136790:flux_dev_r:739:0,21136798:flux_dev_r:739:0,21136805:flux_dev_r:739:0,21136813:flux_dev_r:739:0,21136818:flux_dev_r:739:0,21142354:flux_dev_r:739:0', 10) 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-03-10 00:15:41', 3994, 3140, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-03-10 00:15:41', 4866, 8, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-03-10 00:15:41', 4322, 6104, 'RUBBIA_filmPE_151122') ('2025-03-10 00:15:41', 3991, 960, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-03-10 00:15:41', 4219, 1440, 'detection_plaque_valcor_010622') ('2025-03-10 00:15:41', 4310, 19142, 'classifieur_2camions_valcor_021122_v1') ('2025-03-10 00:15:41', 4234, 84, 'refus_rym_velours_valcor') ('2025-03-10 00:15:41', 533, 162, 'multi_classification_tapis_dechet') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 25) (-5, 17) (0, 918) 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-03-10 00:16:50', 3994, 149100, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-03-10 00:16:50', 4234, 115706, 'refus_rym_velours_valcor') ('2025-03-10 00:16:50', 4322, 73987, 'RUBBIA_filmPE_151122') ('2025-03-10 00:16:50', 533, 45225, 'multi_classification_tapis_dechet') ('2025-03-10 00:16:50', 3995, 29521, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-03-10 00:16:50', 3993, 27335, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-03-10 00:16:50', 4153, 27011, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-03-10 00:16:50', 4310, 19142, 'classifieur_2camions_valcor_021122_v1') ('2025-03-10 00:16:50', 4892, 17209, 'multi_classification_tapis_dechet') ('2025-03-10 00:16:50', 3804, 6851, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-03-10 00:16:50', 4866, 6576, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-03-10 00:16:50', 3991, 6045, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-03-10 00:16:50', 3992, 2882, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-03-10 00:16:50', 4489, 2790, 'multi_classification_tapis_dechet') ('2025-03-10 00:16:50', 4219, 1910, 'detection_plaque_valcor_010622') ('2025-03-10 00:16:50', 3789, 1624, 'split_time_score_test_multi_matiere') ('2025-03-10 00:16:50', 4220, 864, 'split_time_score_plaque_Valcor') ('2025-03-10 00:16:50', 4851, 842, 'split_time_score_SCCU_8') ('2025-03-10 00:16:50', 4311, 800, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-03-10 00:16:50', 4916, 700, 'split_time_score_Acier_Arc_En_Ciel') ('2025-03-10 00:16:50', 4849, 640, 'split_time_score_SCCU_6') ('2025-03-10 00:16:50', 4323, 620, 'split_time_score_arc_en_ciel_mm') ('2025-03-10 00:16:50', 4748, 586, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-03-10 00:16:50', 4878, 469, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-03-10 00:16:50', 4850, 457, 'split_time_score_SCCU_7') ('2025-03-10 00:16:50', 3787, 448, 'split_time_score_urban_fest') ('2025-03-10 00:16:50', 3181, 231, 'split_time_score_JRM_Arc_En_Ciel') ('2025-03-10 00:16:50', 4891, 200, 'split_time_score_angers_montee_convoyeur') ('2025-03-10 00:16:50', 243, 157, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-03-10 00:16:50', 3164, 98, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-03-10 00:16:50', 370, 80, 'proportion_papier_qualite_dechets_tri') ('2025-03-10 00:16:50', 4212, 70, 'ACP_from_port_5709050_type_5619_size_9') ('2025-03-10 00:16:50', 4209, 70, 'test_acp') ('2025-03-10 00:16:50', 4208, 70, 'test_acp_fit_transform_20') ('2025-03-10 00:16:50', 686, 55, 'copy_argmax_crop') ('2025-03-10 00:16:50', 3781, 49, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-03-10 00:16:50', 4621, 45, 'tfhub_18_7_2023') ('2025-03-10 00:16:50', 4567, 42, 'tfhub_19_06_2023') ('2025-03-10 00:16:50', 2896, 35, 'test_radom_deformation') ('2025-03-10 00:16:50', 3990, 35, 'test_crop_condition_blur') ('2025-03-10 00:16:50', 3070, 35, 'test_ventilate_hashtag_type_3326') ('2025-03-10 00:16:50', 1848, 35, 'Pipeline_upm_photos_blanches') ('2025-03-10 00:16:50', 230, 32, 'datou_test_rotate') ('2025-03-10 00:16:50', 3856, 28, 'RUBBIA_Carton_050821_extract_RYM') ('2025-03-10 00:16:50', 2719, 20, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-03-10 00:16:50', 3385, 20, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-03-10 00:16:50', 40, 19, 'mask_coco_origin') ('2025-03-10 00:16:50', 4184, 16, 'detection_plaque_valcor_010622') ('2025-03-10 00:16:50', 233, 14, 'datou_test_rotate_conditionnel') ('2025-03-10 00:16:50', 4492, 14, 'copie_4387_test_replace') ('2025-03-10 00:16:50', 4553, 14, 'copie_4387_test_replace') ('2025-03-10 00:16:50', 4573, 10, 'test_sam_h') ('2025-03-10 00:16:50', 1026, 9, 'mask_coco_for_test') ('2025-03-10 00:16:50', 2, 8, 'classification_model') ('2025-03-10 00:16:50', 571, 7, 'datou_test_flip') ('2025-03-10 00:16:50', 1818, 7, 'blanchir') ('2025-03-10 00:16:50', 2041, 7, 'test_data_aug') ('2025-03-10 00:16:50', 2085, 7, 'train_points_upm_darker') ('2025-03-10 00:16:50', 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: (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.25user 0.16system 7:08:35elapsed 0%CPU (0avgtext+0avgdata 33384maxresident)k 42832inputs+48outputs (2598major+8523minor)pagefaults 0swaps