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: 05/03/2025, 00:01:24 Nombre de datou current ('date', 'nombre de datou current') ('2025-03-05 00:01:24', 360) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-03-05 00:01:24', 606389) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-03-05 00:02:16', 39428) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-03-05 00:02:16', 18487) 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-05 00:02:25', 4892, 51741, 34528, 17213, 'multi_classification_tapis_dechet', 62.714285714285715, '20999403:sevran_122:739:0,20995109:angers_mon:1017:0,20963253:sevran_122:739:0,20961399:angers_mon:1017:0,20791115:sevran_122:739:0,20763370:sevran_122:739:1,20168060:sevran_122:739:0', 7) ('2025-03-05 00:02:25', 4489, 967, 305, 662, 'multi_classification_tapis_dechet', 24.0, '20995110:cedre_arge:1080:0', 1) ('2025-03-05 00:02:25', 4433, 719, 510, 209, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 26.666666666666668, '20967779:JRM_diff_b:1053:0,21011080:JRM_diff_b:1053:1,21004718:JRM_diff_b:1053:0,21004690:JRM_diff_b:1053:0,20966286:JRM_diff_b:1053:0,21003465:JRM_diff_b:1053:0,20966293:JRM_diff_b:1053:0,20967777:JRM_diff_b:1053:0,20967781:JRM_diff_b:1053:0', 9) ('2025-03-05 00:02:25', 4234, 199, 86, 113, 'refus_rym_velours_valcor', 8.2, '21008692:truck_diff:991:0,21008688:truck_diff:991:0,21008156:truck_diff:991:0,21009814:truck_diff:991:0,21033062:incinerati:1103:1', 5) ('2025-03-05 00:02:25', 4322, 327, 220, 107, 'RUBBIA_filmPE_151122', 15.555555555555555, '21007213:film_pedb_:739:0,20966348:film_pedb_:1017:0,21006297:film_pedb_:739:0,20999700:film_pedb_:1017:0,21005978:film_pedb_:739:0,21005970:film_pedb_:739:0,21005963:film_pedb_:739:0,21005929:film_pedb_:739:0,21004725:film_pedb_:739:0', 9) ('2025-03-05 00:02:25', 533, 1514, 1432, 82, 'multi_classification_tapis_dechet', 16.0, '20999550:arc_en_cie:739:1', 1) ('2025-03-05 00:02:25', 3459, 30, 10, 20, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 0.0, '21031494:JRM_diff_b:739:1', 1) ('2025-03-05 00:02:25', 3993, 60, 40, 20, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 10.666666666666666, '21010717:emr_diff_b:739:1,21003466:emr_diff_b:739:0,21009866:gros_carto:739:0', 3) ('2025-03-05 00:02:25', 4310, 7014, 7001, 13, 'classifieur_2camions_valcor_021122_v1', 44.0, '20959707:dechet_val:991:0', 1) ('2025-03-05 00:02:25', 4748, 72, 60, 12, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 12.0, '21005928:flux_dev_r:739:0,21005966:flux_dev_r:739:0,21005973:flux_dev_r:739:0', 3) ('2025-03-05 00:02:25', 4877, 60, 49, 11, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '21032557:JRM_diff_b:979:1,21032559:JRM_diff_b:979:1,21032665:JRM_diff_b:979:1,21032740:JRM_diff_b:979:1,21033061:JRM_diff_b:979:1,21033152:JRM_diff_b:979:1,21032507:JRM_diff_b:979:1,21032405:JRM_diff_b:979:1,21032345:JRM_diff_b:979:1,21032147:JRM_diff_b:979:1,21032095:JRM_diff_b:979:1,21031866:JRM_diff_b:979:1,21031777:JRM_diff_b:979:1', 13) ('2025-03-05 00:02:25', 3804, 20, 10, 10, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 9.0, '21010652:pet_clair_:739:1', 1) ('2025-03-05 00:02:25', 3991, 29, 20, 9, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 26.0, '20993232:ela_diff_b:1017:0', 1) ('2025-03-05 00:02:25', 4871, 2905, 2900, 5, 'blur_rubbia_live', 23.0, '20995339:arc_en_cie:979:0', 1) ('2025-03-05 00:02:25', 3995, 28, 27, 1, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 10.5, '21005927:pehd_pp_di:1017:0,21010323:pehd_pp_di:739:1', 2) ('2025-03-05 00:02:25', 4866, 1, 1, 0, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam', 363.0, '20610133:excoffier_:1117: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-03-05 00:02:26', 370, 25, 'proportion_papier_qualite_dechets_tri', Decimal('8.0000'), '13545772:papier_dif:739:0,13545779:papier_dif:739:0,13545783:papier_dif:739:0,13545787:papier_dif:739:0', 4) ('2025-03-05 00:02:26', 3385, 1514, 'split_time_score_JRM_Arc_En_Ciel_peu_dense', Decimal('0.0000'), '20999550:arc_en_cie:739:0', 1) ('2025-03-05 00:02:26', 3804, 158, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('9.0000'), '21010328:pet_clair_:739:0,21010342:pet_clair_:739:0,21010350:pet_clair_:739:0,21010360:pet_clair_:739:0,21010366:pet_clair_:739:0,21010378:pet_clair_:739:0,21010388:pet_clair_:739:0,21010396:pet_clair_:739:0,21010431:pet_clair_:739:0,21010441:pet_clair_:739:0,21010452:pet_clair_:739:0,21010498:pet_clair_:739:0,21010550:pet_clair_:739:0,21010622:pet_clair_:739:0', 14) ('2025-03-05 00:02:26', 3991, 103, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('7.8447'), '21010374:ela_diff_b:739:0,21010450:ela_diff_b:739:0,21010564:ela_diff_b:739:0,21010662:ela_diff_b:739:0,21010756:ela_diff_b:739:0,21010903:ela_diff_b:739:0,21026651:ela_diff_b:739:0', 7) ('2025-03-05 00:02:26', 3992, 105, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('7.5905'), '21010393:aluminium_:739:0,21010666:aluminium_:739:0,21010708:aluminium_:739:0,21010751:aluminium_:739:0,21010769:aluminium_:739:0,21010803:aluminium_:739:0,21010876:aluminium_:739:0,21010918:aluminium_:739:0,21013795:aluminium_:739:0,21017757:aluminium_:739:0,21019892:aluminium_:739:0,21020702:aluminium_:1017:0', 12) ('2025-03-05 00:02:26', 3993, 386, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('8.8368'), '21010324:gros_carto:739:0,21010325:emr_diff_b:739:0,21010327:emr_diff_b:739:0,21010334:emr_diff_b:739:0,21010336:gros_carto:739:0,21010338:emr_diff_b:739:0,21010344:emr_diff_b:739:0,21010352:emr_diff_b:739:0,21010356:emr_diff_b:739:0,21010358:gros_carto:739:0,21010370:emr_diff_b:739:0,21010375:gros_carto:739:0,21010380:emr_diff_b:739:0,21010386:emr_diff_b:739:0,21010394:emr_diff_b:739:0,21010395:gros_carto:739:0,21010423:emr_diff_b:739:0,21010427:emr_diff_b:739:0,21010439:emr_diff_b:739:0,21010443:emr_diff_b:739:0,21010467:emr_diff_b:739:0,21010566:emr_diff_b:739:0,21010595:emr_diff_b:739:0,21010598:emr_diff_b:739:0,21010624:gros_carto:739:0,21010646:emr_diff_b:739:0,21010653:emr_diff_b:739:0,21010655:emr_diff_b:739:0,21010657:gros_carto:739:0,21010658:emr_diff_b:739:0,21010663:emr_diff_b:739:0,21010667:emr_diff_b:739:0,21010670:gros_carto:739:0,21010697:emr_diff_b:739:0,21010701:emr_diff_b:739:0,21010704:emr_diff_b:739:0,21010709:emr_diff_b:739:0,21010710:gros_carto:739:0,21010713:emr_diff_b:739:0,21033316:e', 40) ('2025-03-05 00:02:26', 3994, 65, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('6.5077'), '21010382:gm_diff_ba:739:0,21010659:gm_diff_ba:739:0,21010698:gm_diff_ba:739:0,21010711:gm_diff_ba:739:0,21010923:gm_diff_ba:739:0,21020700:gm_diff_ba:1017:0,21024341:gm_diff_ba:1017:0', 7) ('2025-03-05 00:02:26', 3995, 123, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', Decimal('9.0000'), '21010330:pehd_pp_di:739:0,21010346:pehd_pp_di:739:0,21010364:pehd_pp_di:739:0,21010376:pehd_pp_di:739:0,21010392:pehd_pp_di:739:0,21010421:pehd_pp_di:739:0,21010464:pehd_pp_di:739:0,21010552:pehd_pp_di:739:0,21010596:pehd_pp_di:739:0,21010651:pehd_pp_di:739:0,21010654:pehd_pp_di:739:0', 11) ('2025-03-05 00:02:26', 4219, 15062, 'detection_plaque_valcor_010622', Decimal('199.6511'), '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,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', 15) ('2025-03-05 00:02:26', 4220, 1008, 'split_time_score_plaque_Valcor', Decimal('4.0000'), '20958095:plaque_val:1064:0,20999208:plaque_val:1064:0', 2) ('2025-03-05 00:02:26', 4234, 488, 'refus_rym_velours_valcor', Decimal('6.7541'), '21007627:truck_diff:991:0,21012337:truck_diff:991:0,21012338:truck_diff:991:0,21012339:truck_diff:991:0,21012340:truck_diff:991:0,21013583:truck_diff:991:0,21013584:truck_diff:991:0,21013596:truck_diff:991:0,21013603:truck_diff:991:0,21013621:truck_diff:991:0,21013622:truck_diff:991:0,21013623:truck_diff:991:0,21020632:truck_diff:991:0,21020633:truck_diff:991:0,21020652:truck_diff:991:0,21020671:truck_diff:991:0,21022096:truck_diff:991:0,21022097:truck_diff:991:0,21022098:truck_diff:991:0,21022099:truck_diff:991:0,21022100:truck_diff:991:0,21022101:truck_diff:991:0,21023138:truck_diff:991:0,21023139:truck_diff:991:0,21023141:truck_diff:991:0,21027579:incinerati:1103:0,21027580:incinerati:1103:0,21027581:incinerati:1103:0,21027582:incinerati:1103:0,21027583:incinerati:1103:0,21027584:incinerati:1103:0,21027585:incinerati:1103:0,21027586:incinerati:1103:0,21027587:incinerati:1103:0,21027588:incinerati:1103:0,21027589:incinerati:1103:0,21027590:incinerati:1103:0,21027591:incinerati:1103:0,21027592:incinerati:110', 76) ('2025-03-05 00:02:26', 4311, 7182, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('0.0000'), '20997635:dechet_val:991:0', 1) ('2025-03-05 00:02:26', 4322, 1053, 'RUBBIA_filmPE_151122', Decimal('7.7417'), '21010326:film_pedb_:739:0,21010340:film_pedb_:739:0,21010354:film_pedb_:739:0,21010368:film_pedb_:739:0,21010384:film_pedb_:739:0,21010422:film_pedb_:739:0,21010433:film_pedb_:739:0,21010459:film_pedb_:739:0,21010469:film_pedb_:739:0,21010557:film_pedb_:739:0,21010623:film_pedb_:739:0,21010656:film_pedb_:739:0,21010668:film_pedb_:739:0,21010703:film_pedb_:739:0,21010714:film_pedb_:739:0,21010725:film_pedb_:739:0,21010758:film_pedb_:739:0,21010766:film_pedb_:739:0,21010775:film_pedb_:739:0,21010866:film_pedb_:739:0,21010875:film_pedb_:739:0,21010908:film_pedb_:739:0,21010914:film_pedb_:739:0,21010921:film_pedb_:739:0,21011127:film_pedb_:1017:0,21011152:film_pedb_:739:0,21013794:film_pedb_:739:0,21016638:film_pedb_:739:0,21019891:film_pedb_:739:0,21020698:film_pedb_:1017:0,21024404:film_pedb_:739:0,21029268:film_pedb_:739:0,21033315:film_pedb_:1017:0', 33) ('2025-03-05 00:02:26', 4346, 1648, 'split_time_score_cedre', Decimal('3.3058'), '20957787:cedre_arge:1080:0,20995110:cedre_arge:1080:0', 2) ('2025-03-05 00:02:26', 4510, 17, 'entrant_rym_velours_sans_suffix_nouveaux_cont', Decimal('6.0000'), '21019825:entrant_di:1080:0', 1) ('2025-03-05 00:02:26', 4748, 556, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('8.0216'), '21010332:flux_dev_r:739:0,21010348:flux_dev_r:739:0,21010362:flux_dev_r:739:0,21010372:flux_dev_r:739:0,21010390:flux_dev_r:739:0,21010424:flux_dev_r:739:0,21010437:flux_dev_r:739:0,21010447:flux_dev_r:739:0,21010472:flux_dev_r:739:0,21010560:flux_dev_r:739:0,21010637:flux_dev_r:739:0,21010665:flux_dev_r:739:0,21010696:flux_dev_r:739:0,21010702:flux_dev_r:739:0,21010707:flux_dev_r:739:0,21010715:flux_dev_r:739:0,21010723:flux_dev_r:739:0,21010757:flux_dev_r:739:0,21010764:flux_dev_r:739:0,21010773:flux_dev_r:739:0,21010790:flux_dev_r:739:0,21010868:flux_dev_r:739:0,21010874:flux_dev_r:739:0,21010905:flux_dev_r:739:0,21010912:flux_dev_r:739:0,21010919:flux_dev_r:739:0,21011151:flux_dev_r:739:0,21013789:flux_dev_r:739:0,21016634:flux_dev_r:739:0,21019138:flux_dev_r:739:0,21025313:flux_dev_r:739:0,21026649:flux_dev_r:739:0,21029270:flux_dev_r:739:0', 33) ('2025-03-05 00:02:26', 4876, 2, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '21033292:arc_en_cie:979:0', 1) ('2025-03-05 00:02:26', 4878, 2905, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '20995339:arc_en_cie:979:0', 1) ('2025-03-05 00:02:26', 4883, 2, 'split_time_score_JRM_Arc_En_Ciel', Decimal('0.0000'), '21033292:arc_en_cie:979:0', 1) ('2025-03-05 00:02:26', 4887, 7024, 'split_time_score_Sevran_test', Decimal('0.0000'), '20999403:sevran_122:739:0', 1) ('2025-03-05 00:02:26', 4892, 4, 'multi_classification_tapis_dechet', Decimal('0.0000'), '21033291:angers_mon:1017: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-03-05 00:02:26', 4892, 38660, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:26', 4866, 3, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-03-05 00:02:26', 4310, 36, 'classifieur_2camions_valcor_021122_v1') ('2025-03-05 00:02:26', 4433, 3645, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-03-05 00:02:26', 4322, 1600, 'RUBBIA_filmPE_151122') ('2025-03-05 00:02:26', 3991, 160, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-03-05 00:02:26', 4489, 915, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:26', 4871, 2900, 'blur_rubbia_live') ('2025-03-05 00:02:26', 533, 4296, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:26', 3993, 250, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-03-05 00:02:26', 3995, 174, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-03-05 00:02:26', 4748, 480, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-03-05 00:02:26', 4234, 590, 'refus_rym_velours_valcor') ('2025-03-05 00:02:26', 3804, 80, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-03-05 00:02:26', 3459, 80, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-03-05 00:02:26', 4877, 244, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 28) (-5, 18) (0, 336) 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-05 00:02:29', 4892, 106860, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:29', 4234, 83597, 'refus_rym_velours_valcor') ('2025-03-05 00:02:29', 533, 82640, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:29', 4883, 55694, 'split_time_score_JRM_Arc_En_Ciel') ('2025-03-05 00:02:29', 4876, 55480, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-03-05 00:02:29', 4877, 36329, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-03-05 00:02:29', 3804, 27175, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-03-05 00:02:29', 4302, 25112, 'RUBBIA_JRM_consolidate') ('2025-03-05 00:02:29', 4310, 21507, 'classifieur_2camions_valcor_021122_v1') ('2025-03-05 00:02:29', 3993, 16659, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-03-05 00:02:29', 3995, 16488, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-03-05 00:02:29', 4433, 14660, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-03-05 00:02:29', 3459, 12481, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-03-05 00:02:29', 4322, 9197, 'RUBBIA_filmPE_151122') ('2025-03-05 00:02:29', 4748, 6082, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-03-05 00:02:29', 4891, 4800, 'split_time_score_angers_montee_convoyeur') ('2025-03-05 00:02:29', 4311, 4100, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-03-05 00:02:29', 4323, 2960, 'split_time_score_arc_en_ciel_mm') ('2025-03-05 00:02:29', 3994, 2954, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-03-05 00:02:29', 3385, 2922, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-03-05 00:02:29', 4871, 2905, 'blur_rubbia_live') ('2025-03-05 00:02:29', 4153, 2250, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-03-05 00:02:29', 4489, 1967, 'multi_classification_tapis_dechet') ('2025-03-05 00:02:29', 3318, 1410, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-03-05 00:02:29', 4189, 1400, 'split_time_score_JRM_Perlen_convoyeur') ('2025-03-05 00:02:29', 3991, 1272, 'RUBBIA_ELA_131221_add_surclassifier_rapport') ('2025-03-05 00:02:29', 3789, 1160, 'split_time_score_test_multi_matiere') ('2025-03-05 00:02:29', 4849, 909, 'split_time_score_SCCU_6') ('2025-03-05 00:02:29', 4346, 864, 'split_time_score_cedre') ('2025-03-05 00:02:29', 4878, 700, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-03-05 00:02:29', 4851, 648, 'split_time_score_SCCU_8') ('2025-03-05 00:02:29', 4220, 600, 'split_time_score_plaque_Valcor') ('2025-03-05 00:02:29', 3992, 480, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-03-05 00:02:29', 4850, 406, 'split_time_score_SCCU_7') ('2025-03-05 00:02:29', 3787, 320, 'split_time_score_urban_fest') ('2025-03-05 00:02:29', 4887, 240, 'split_time_score_Sevran_test') ('2025-03-05 00:02:29', 4866, 225, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam') ('2025-03-05 00:02:29', 3181, 165, 'split_time_score_JRM_Arc_En_Ciel') ('2025-03-05 00:02:29', 243, 130, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-03-05 00:02:29', 370, 85, 'proportion_papier_qualite_dechets_tri') ('2025-03-05 00:02:29', 3164, 70, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-03-05 00:02:29', 4212, 50, 'ACP_from_port_5709050_type_5619_size_9') ('2025-03-05 00:02:29', 4209, 50, 'test_acp') ('2025-03-05 00:02:29', 4208, 50, 'test_acp_fit_transform_20') ('2025-03-05 00:02:29', 686, 45, 'copy_argmax_crop') ('2025-03-05 00:02:29', 3781, 35, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-03-05 00:02:29', 4621, 30, 'tfhub_18_7_2023') ('2025-03-05 00:02:29', 4567, 27, 'tfhub_19_06_2023') ('2025-03-05 00:02:29', 1848, 25, 'Pipeline_upm_photos_blanches') ('2025-03-05 00:02:29', 3990, 25, 'test_crop_condition_blur') ('2025-03-05 00:02:29', 3070, 25, 'test_ventilate_hashtag_type_3326') ('2025-03-05 00:02:29', 2896, 25, 'test_radom_deformation') ('2025-03-05 00:02:29', 230, 20, 'datou_test_rotate') ('2025-03-05 00:02:29', 3856, 20, 'RUBBIA_Carton_050821_extract_RYM') ('2025-03-05 00:02:29', 40, 19, 'mask_coco_origin') ('2025-03-05 00:02:29', 2719, 16, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-03-05 00:02:29', 4184, 10, 'detection_plaque_valcor_010622') ('2025-03-05 00:02:29', 233, 10, 'datou_test_rotate_conditionnel') ('2025-03-05 00:02:29', 4573, 10, 'test_sam_h') ('2025-03-05 00:02:29', 4553, 10, 'copie_4387_test_replace') ('2025-03-05 00:02:29', 4492, 10, 'copie_4387_test_replace') ('2025-03-05 00:02:29', 1026, 8, 'mask_coco_for_test') ('2025-03-05 00:02:29', 2, 5, 'classification_model') ('2025-03-05 00:02:29', 571, 5, 'datou_test_flip') ('2025-03-05 00:02:29', 2085, 5, 'train_points_upm_darker') ('2025-03-05 00:02:29', 2041, 5, 'test_data_aug') ('2025-03-05 00:02:29', 1818, 5, 'blanchir') ('2025-03-05 00:02:29', 2665, 2, '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') ('PhotoDescForrotata_polygone', 468426) ('merge_pipeline_rubbia_jrm_details_3459', 153317) ('type_merge_mask_detect_2486_2499', 72000) ('test_sam_h', 70274) ('output_merge_d4380', 58784) ('PhotoDescForlabels_result_test_step_tile', 55803) ('d4018_output_rle', 43213) ('varroa_from_ellipse_tiled_rotate_shrink_whiten_ok', 29925) ('pht_test_rle_unique_nms_output', 29558) ('datou_3995_rle', 28099) ('learn_convoyeur_qualipapia_nantes_poly_100521_1', 24298) ('d4018_output_mask', 23435) ('test_sam', 9071) ('mask_coco_origin', 8842) ('test_non_regreg_generate_new_image', 2733) ('datou_3993_rle', 2258) ('detection_filter_test', 1600) Nombre total de sub photos associees à chaque hashtag type ('hashtag type id', 'hashtag type name', 'Nombre de photos total') 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.20user 0.10system 7:08:39elapsed 0%CPU (0avgtext+0avgdata 34056maxresident)k 37680inputs+64outputs (2869major+8066minor)pagefaults 0swaps