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: 06/02/2025, 00:01:25 Nombre de datou current ('date', 'nombre de datou current') ('2025-02-06 00:01:25', 1390) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-02-06 00:01:25', 637986) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-02-06 00:03:50', 114924) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-02-06 00:03:50', 27531) 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-06 00:04:04', 4310, 69407, 54399, 15008, 'classifieur_2camions_valcor_021122_v1', 339.77777777777777, '19559973:dechet_val:991:0,19642969:dechet_val:991:0,19672137:dechet_val:991:0,19698702:dechet_val:991:0,19724275:dechet_val:991:0,19739544:dechet_val:991:0,20165885:dechet_val:991:0,20197575:dechet_val:991:0,20238989:dechet_val:991:0', 9) ('2025-02-06 00:04:04', 3459, 3628, 850, 2778, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 215.93333333333334, '19754712:jrm_diff_b:1017:0,19762343:jrm_diff_b:1017:0,19762345:jrm_diff_b:1017:0,19763071:JRM_diff_b:739:0,19763324:jrm_diff_b:1017:0,19817047:JRM_diff_b:739:0,19817048:JRM_diff_b:739:0,19817049:JRM_diff_b:739:0,20036989:JRM_diff_b:739:0,20037563:JRM_diff_b:739:0,20037597:JRM_diff_b:739:0,20038647:JRM_diff_b:739:0,20041518:jrm_diff_b:1017:0,20041976:JRM_diff_b:739:0,20042812:JRM_diff_b:739:0,20043199:JRM_diff_b:739:0,20043200:JRM_diff_b:739:0,20043551:JRM_diff_b:739:0,20043629:jrm_diff_b:1017:0,20044107:JRM_diff_b:739:0,20068238:JRM_diff_b:739:0,20072387:JRM_diff_b:739:0,20073159:JRM_diff_b:739:0,20073646:JRM_diff_b:739:0,20081910:JRM_diff_b:739:0,20088399:JRM_diff_b:739:0,20088595:JRM_diff_b:739:0,20105157:JRM_diff_b:739:1,20105158:JRM_diff_b:739:1,20276875:JRM_diff_b:739:0', 30) ('2025-02-06 00:04:04', 4892, 13164, 10609, 2555, 'multi_classification_tapis_dechet', 20.5, '20232661:angers_mon:1017:0,20244820:sevran_122:739:0', 2) ('2025-02-06 00:04:04', 4322, 4561, 2473, 2088, 'RUBBIA_filmPE_151122', 171.83695652173913, '19783410:film_pedb_:739:0,19816763:film_pedb_:739:1,19816773:film_pedb_:739:0,19844078:film_pedb_:1017:0,19903206:film_pedb_:1017:0,19907038:film_pedb_:1017:0,19916122:film_pedb_:1017:0,19962211:film_pedb_:739:0,19969293:film_pedb_:1017:0,19972096:film_pedb_:1017:0,19976776:film_pedb_:1017:0,19980530:film_pedb_:1017:0,19989461:film_pedb_:739:0,20001205:film_pedb_:739:0,20003496:film_pedb_:1017:0,20003529:film_pedb_:739:0,20006222:film_pedb_:1017:0,20009325:film_pedb_:1017:0,20014717:film_pedb_:1017:0,20017063:film_pedb_:1017:0,20025749:film_pedb_:739:0,20028250:film_pedb_:1017:0,20031872:film_pedb_:739:0,20037390:film_pedb_:1017:1,20037415:film_pedb_:739:1,20037979:film_pedb_:739:0,20040826:film_pedb_:1017:0,20041520:film_pedb_:1017:0,20043467:film_pedb_:739:0,20043950:film_pedb_:739:0,20044533:film_pedb_:1017:0,20045086:film_pedb_:739:0,20046175:film_pedb_:739:0,20046353:film_pedb_:1017:0,20048101:film_pedb_:739:0,20048571:film_pedb_:739:0,20049407:film_pedb_:1017:0,20051041:film_pedb_:739:0,20052234:film_pe', 92) ('2025-02-06 00:04:04', 4234, 3374, 1507, 1867, 'refus_rym_velours_valcor', 156.375, '19846777:truck_diff:991:0,19849715:truck_diff:991:0,19852280:truck_diff:991:0,19852327:truck_diff:991:0,19856547:truck_diff:991:0,19898844:truck_diff:991:0,19954906:truck_diff:991:0,19954920:truck_diff:991:0,20005158:truck_diff:991:0,20005189:truck_diff:991:0,20024109:truck_diff:991:0,20028248:truck_diff:991:0,20028262:truck_diff:991:0,20028747:truck_diff:991:0,20029321:truck_diff:991:0,20029335:truck_diff:991:0,20029775:truck_diff:991:0,20030143:truck_diff:991:0,19897034:truck_diff:991:1,20050443:truck_diff:991:0,20052305:truck_diff:991:0,19954805:truck_diff:991:0,19954857:truck_diff:991:0,20068969:truck_diff:991:0,20070508:truck_diff:991:0,20071883:truck_diff:991:0,20072229:truck_diff:991:0,20072753:truck_diff:991:0,20073799:truck_diff:991:0,20074217:truck_diff:991:0,20075394:truck_diff:991:0,20076089:truck_diff:991:0,20077969:truck_diff:991:0,20079007:truck_diff:991:0,20079008:truck_diff:991:0,20080180:truck_diff:991:0,20080885:truck_diff:991:0,20115128:truck_diff:991:0,20119335:truck_diff:991:0,20119336:t', 56) ('2025-02-06 00:04:04', 4219, 1049, 3, 1046, 'detection_plaque_valcor_010622', 1582.0, '18808289:plaque_val:1064:0', 1) ('2025-02-06 00:04:04', 3993, 893, 220, 673, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 44.857142857142854, '20175371:emr_diff_b:1017:0,20176524:emr_diff_b:739:0,20176525:pcnc_diff_:739:0,20177014:pcnc_diff_:739:0,20178180:emr_diff_b:739:0,20179146:pcnc_diff_:739:0,20179147:emr_diff_b:739:0,20179396:emr_diff_b:739:0,20179397:pcnc_diff_:739:0,20179399:emr_diff_b:739:0,20254252:emr_diff_b:1017:0,20254666:emr_diff_b:739:1,20254691:emr_diff_b:739:1,20254692:pcnc_diff_:739:0', 14) ('2025-02-06 00:04:04', 3994, 801, 140, 661, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 204.66666666666666, '19909479:pcm_diff_b:739:0,19909480:pcm_diff_b:739:0,20198550:pcm_diff_b:739:0', 3) ('2025-02-06 00:04:04', 3804, 939, 470, 469, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 54.45454545454545, '20169285:pet_clair_:1017:0,20168059:pet_clair_:1017:0,20176514:pet_clair_:739:0,20177142:pet_clair_:1017:0,20177545:pet_clair_:1017:0,20178179:pet_clair_:739:1,20179148:pet_clair_:739:0,20179394:pet_clair_:739:0,20179405:pet_clair_:739:0,20179488:pet_clair_:739:0,20254697:pet_clair_:739:1', 11) ('2025-02-06 00:04:04', 3992, 180, 60, 120, 'RUBBIA_Alu_131221_add_surclassifier_rapport', 177.33333333333334, '19993272:aluminium_:739:0,20049554:aluminium_:739:0,20082424:aluminium_:739:0', 3) ('2025-02-06 00:04:04', 3991, 280, 180, 100, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 153.33333333333334, '20025651:ela_diff_b:1017:0,20045888:ela_diff_b:1017:0,20063543:ela_diff_b:1017:0,20073268:ela_diff_b:1017:0,20076857:ela_diff_b:739:0,20080190:ela_diff_b:1017:0,20104700:ela_diff_b:1017:0,20115134:ela_diff_b:1017:0,20119801:ela_diff_b:1017:0', 9) ('2025-02-06 00:04:04', 4748, 417, 340, 77, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 158.11764705882354, '19917998:flux_dev_r:739:0,20004721:flux_dev_r:739:0,20040412:flux_dev_r:739:0,20062003:flux_dev_r:739:0,20065065:flux_dev_r:739:0,20067085:flux_dev_r:739:0,20071351:flux_dev_r:739:0,20079077:flux_dev_r:739:0,20081686:flux_dev_r:739:0,20083114:flux_dev_r:739:0,20089569:flux_dev_r:739:0,20101944:flux_dev_r:739:0,20101951:flux_dev_r:739:0,20110666:flux_dev_r:739:0,20114135:flux_dev_r:739:0,20116095:flux_dev_r:739:0,20117424:flux_dev_r:739:0', 17) ('2025-02-06 00:04:04', 4433, 131, 80, 51, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', 48.5, '20171932:JRM_diff_b:1053:0,20206950:JRM_diff_b:1053:1', 2) ('2025-02-06 00:04:04', 4909, 78, 40, 38, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 12.0, '20254672:pehd_pp_di:739:0', 1) ('2025-02-06 00:04:04', 4153, 23, 23, 0, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', 13.0, '20253018:flux_dev_d:1017: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-02-06 00:04:05', 370, 25, 'proportion_papier_qualite_dechets_tri', Decimal('64.4000'), '13545772:papier_dif:739:0,13545779:papier_dif:739:0,13545783:papier_dif:739:0,13545787:papier_dif:739:0', 4) ('2025-02-06 00:04:05', 3385, 1598, 'split_time_score_JRM_Arc_En_Ciel_peu_dense', Decimal('0.0000'), '20244859:arc_en_cie:739:0', 1) ('2025-02-06 00:04:05', 3459, 13403, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights', Decimal('191.8474'), '19763321:jrm_diff_b:1017:0,19764220:JRM_diff_b:739:0,19765803:JRM_diff_b:739:0,19765804:JRM_diff_b:739:0,19765805:JRM_diff_b:739:0,19765806:JRM_diff_b:739:0,19767302:JRM_diff_b:739:0,19767303:JRM_diff_b:739:0,19767304:JRM_diff_b:739:0,19768592:jrm_diff_b:1017:0,19768736:JRM_diff_b:739:0,19768738:JRM_diff_b:739:0,19770114:JRM_diff_b:739:0,19770115:JRM_diff_b:739:0,19770116:JRM_diff_b:739:0,19795857:JRM_diff_b:739:0,19797270:JRM_diff_b:739:0,19798173:jrm_diff_b:1017:0,19798289:JRM_diff_b:739:0,19799584:JRM_diff_b:739:0,19802102:jrm_diff_b:1017:0,19802105:jrm_diff_b:1017:0,19809799:JRM_diff_b:739:0,19815786:JRM_diff_b:739:0,19815789:JRM_diff_b:739:0,19815791:JRM_diff_b:739:0,19815792:JRM_diff_b:739:0,19816873:jrm_diff_b:1017:0,19817050:JRM_diff_b:739:0,19821680:jrm_diff_b:739:0,19825189:JRM_diff_b:739:0,19825190:JRM_diff_b:739:0,19826990:JRM_diff_b:739:0,19827478:jrm_diff_b:1017:0,19827482:jrm_diff_b:1017:0,19827701:JRM_diff_b:739:0,19827702:JRM_diff_b:739:0,19827728:JRM_diff_b:739:0,19827729:JRM_diff_b:739:0,19', 210) ('2025-02-06 00:04:05', 3979, 1, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('62.0000'), '13545780:plastique_:739:0', 1) ('2025-02-06 00:04:05', 3991, 255, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('37.3137'), '20171947:ela_diff_b:1017:0,20179525:ela_diff_b:739:0,20181506:ela_diff_b:739:0,20183128:ela_diff_b:1017:0,20198513:ela_diff_b:739:0,20204920:ela_diff_b:1017:0,20215672:ela_diff_b:1017:0,20228245:ela_diff_b:1017:0,20251677:ela_diff_b:1017:0,20254671:ela_diff_b:739:0,20262031:ela_diff_b:1017:0', 11) ('2025-02-06 00:04:05', 3992, 135, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('35.9926'), '20179599:aluminium_:739:0,20179601:aluminium_:739:0,20186675:aluminium_:1017:0,20198515:aluminium_:739:0,20198531:aluminium_:739:0,20204921:aluminium_:1017:0,20220267:aluminium_:1017:0,20249726:aluminium_:1017:0,20254675:aluminium_:739:0,20266098:aluminium_:1017:0', 10) ('2025-02-06 00:04:05', 3993, 432, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('45.8310'), '20176484:emr_diff_b:739:0,20176485:emr_diff_b:739:0,20176486:pcnc_diff_:739:0,20176519:pcnc_diff_:739:0,20176522:emr_diff_b:739:0,20176523:pcnc_diff_:739:0,20177013:pcnc_diff_:739:0,20254663:pcnc_diff_:739:0,20254664:pcnc_diff_:739:0,20276980:emr_diff_b:1017:0', 10) ('2025-02-06 00:04:05', 3994, 119, 'RUBBIA_proportion_papier_add_surclassifier_rapport', Decimal('36.0756'), '20179527:pcm_diff_b:739:0,20179528:pcm_diff_b:739:0,20198527:pcm_diff_b:739:0,20254668:pcm_diff_b:739:0,20254736:pcm_diff_b:739:0', 5) ('2025-02-06 00:04:05', 3995, 219, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', Decimal('9.0411'), '20245966:pehd_pp_di:1017:0,20249724:pehd_pp_di:1017:0,20249727:pehd_pp_di:1017:0,20253023:pehd_pp_di:1017:0,20258543:pehd_pp_di:1017:0,20263701:pehd_pp_di:1017:0,20266081:pehd_pp_di:1017:0,20270891:pehd_pp_di:1017:0,20270893:pehd_pp_di:1017:0', 9) ('2025-02-06 00:04:05', 4219, 71765, 'detection_plaque_valcor_010622', Decimal('802.2180'), '18887370:plaque_val:1064:0,18909144:plaque_val:1064:0,18922048:plaque_val:1064:0,18948750:plaque_val:1064:0,18966527:plaque_val:1064:0,18984980:plaque_val:1064:0,18999159:plaque_val:1064:0,19036179:plaque_val:1064:0,19088052:plaque_val:1064:0,19109709:plaque_val:1064:0,19132512:plaque_val:1064:0,19150488:plaque_val:1064:0,19163211:plaque_val:1064:0,19176663:plaque_val:1064:0,19265243:plaque_val:1064:0,19283258:plaque_val:1064:0,19330815:plaque_val:1064:0,19362748:plaque_val:1064:0,19387885:plaque_val:1064:0,19407643:plaque_val:1064:0,19418253:plaque_val:1064:0,19426242:plaque_val:1064:0,19463603:plaque_val:1064:0,19482376:plaque_val:1064:0,19494244:plaque_val:1064:0,19643171:plaque_val:1064:0,19654020:plaque_val:1064:0,19674312:plaque_val:1064:0,19740119:plaque_val:1064:0,19749453:plaque_val:1064:0,19783840:plaque_val:1064:0,19806631:plaque_val:1064:0,19842456:plaque_val:1064:0,19908524:plaque_val:1064:0,19928190:plaque_val:1064:0,19942325:plaque_val:1064:0,19989529:plaque_val:1064:0,20031499:plaque_val:1064:', 43) ('2025-02-06 00:04:05', 4220, 6141, 'split_time_score_plaque_Valcor', Decimal('15.9511'), '20147280:plaque_val:1064:0,20163675:plaque_val:1064:0,20195603:plaque_val:1064:0,20242974:plaque_val:1064:0', 4) ('2025-02-06 00:04:05', 4234, 3632, 'refus_rym_velours_valcor', Decimal('36.2530'), '19820047:truck_diff:991:0,19844402:truck_diff:991:0,19844407:truck_diff:991:0,19844411:truck_diff:991:0,19845011:truck_diff:991:0,19845402:truck_diff:991:0,19846805:truck_diff:991:0,19847492:truck_diff:991:0,20040819:truck_diff:991:0,20040822:truck_diff:991:0,20040824:truck_diff:991:0,20040825:truck_diff:991:0,20040827:truck_diff:991:0,20040829:truck_diff:991:0,20040843:truck_diff:991:0,20040857:truck_diff:991:0,20040859:truck_diff:991:0,20040861:truck_diff:991:0,20040863:truck_diff:991:0,20040864:truck_diff:991:0,20040865:truck_diff:991:0,20040866:truck_diff:991:0,20040867:truck_diff:991:0,20040868:truck_diff:991:0,20040869:truck_diff:991:0,20040876:truck_diff:991:0,20041512:truck_diff:991:0,20041516:truck_diff:991:0,20162644:truck_diff:991:0,20162662:truck_diff:991:0,20162664:truck_diff:991:0,20162665:truck_diff:991:0,20162666:truck_diff:991:0,20172579:truck_diff:991:0,20172795:truck_diff:991:0,20172796:truck_diff:991:0,20172797:truck_diff:991:0,20172798:truck_diff:991:0,20172799:truck_diff:991:0,20172800:t', 651) ('2025-02-06 00:04:05', 4322, 2252, 'RUBBIA_filmPE_151122', Decimal('37.4618'), '20171948:film_pedb_:1017:0,20173925:film_pedb_:739:0,20175373:film_pedb_:1017:0,20176512:film_pedb_:739:0,20176516:film_pedb_:739:0,20176520:film_pedb_:739:0,20177541:film_pedb_:1017:0,20179400:film_pedb_:739:0,20179403:film_pedb_:739:0,20179404:film_pedb_:739:0,20179415:film_pedb_:739:0,20179514:film_pedb_:739:0,20179515:film_pedb_:739:0,20179516:film_pedb_:739:0,20179529:film_pedb_:739:0,20179531:film_pedb_:739:0,20179536:film_pedb_:739:0,20179537:film_pedb_:739:0,20179553:film_pedb_:739:0,20181504:film_pedb_:739:0,20181514:film_pedb_:739:0,20181519:film_pedb_:739:0,20181520:film_pedb_:739:0,20181546:film_pedb_:739:0,20181547:film_pedb_:739:0,20186673:film_pedb_:1017:0,20192830:film_pedb_:1017:0,20192833:film_pedb_:1017:0,20193392:film_pedb_:739:0,20194251:film_pedb_:739:0,20198517:film_pedb_:739:0,20198519:film_pedb_:739:0,20198520:film_pedb_:739:0,20198535:film_pedb_:739:0,20198545:film_pedb_:739:0,20198546:film_pedb_:739:0,20198548:film_pedb_:739:0,20199785:film_pedb_:1017:0,20200512:film_pedb_:1017:0,20', 66) ('2025-02-06 00:04:05', 4878, 8803, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('14.4731'), '20166663:arc_en_cie:979:0,20195867:arc_en_cie:979:0,20234215:arc_en_cie:979:0', 3) ('2025-02-06 00:04:05', 4887, 6136, 'split_time_score_Sevran_test', Decimal('0.0000'), '20244820:sevran_122:739:0', 1) ('2025-02-06 00:04:05', 4892, 12, 'multi_classification_tapis_dechet', Decimal('0.0000'), '20276947: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-02-06 00:04:06', 4310, 22437, 'classifieur_2camions_valcor_021122_v1') ('2025-02-06 00:04:06', 3459, 1200, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-06 00:04:06', 4322, 1553, 'RUBBIA_filmPE_151122') ('2025-02-06 00:04:06', 4234, 1328, 'refus_rym_velours_valcor') ('2025-02-06 00:04:06', 4748, 160, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-02-06 00:04:06', 4433, 450, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-06 00:04:06', 3804, 2590, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-02-06 00:04:06', 3993, 860, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-02-06 00:04:06', 4892, 29677, 'multi_classification_tapis_dechet') ('2025-02-06 00:04:06', 4153, 181, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-02-06 00:04:06', 4909, 320, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') Nombre de datous demandés par statut ('statut', 'nombre de datous') (1, 16) (-5, 21) (0, 1373) 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-06 00:04:09', 4234, 219339, 'refus_rym_velours_valcor') ('2025-02-06 00:04:09', 4876, 59505, 'split_time_score_JRM_Arc_En_Ciel_test_load') ('2025-02-06 00:04:09', 4883, 58205, 'split_time_score_JRM_Arc_En_Ciel') ('2025-02-06 00:04:09', 3459, 46189, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-06 00:04:09', 4892, 34469, 'multi_classification_tapis_dechet') ('2025-02-06 00:04:09', 4877, 33024, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live') ('2025-02-06 00:04:09', 4909, 32196, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-02-06 00:04:09', 3804, 25242, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM') ('2025-02-06 00:04:09', 4310, 22437, 'classifieur_2camions_valcor_021122_v1') ('2025-02-06 00:04:09', 3993, 21233, 'RUBBIA_Carton_131221_add_surclassifier_rapport') ('2025-02-06 00:04:09', 4302, 16020, 'RUBBIA_JRM_consolidate') ('2025-02-06 00:04:09', 3996, 15803, 'RUBBIA_Refus_add_surclassifier_rapport') ('2025-02-06 00:04:09', 4322, 7480, 'RUBBIA_filmPE_151122') ('2025-02-06 00:04:09', 3318, 7125, 'RUBBIA_Refus_mask_simple_non_aussi_rle') ('2025-02-06 00:04:09', 4153, 5793, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-02-06 00:04:09', 4433, 5602, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_weights') ('2025-02-06 00:04:09', 533, 5496, 'multi_classification_tapis_dechet') ('2025-02-06 00:04:09', 4871, 4285, 'blur_rubbia_live') ('2025-02-06 00:04:09', 4891, 4000, 'split_time_score_angers_montee_convoyeur') ('2025-02-06 00:04:09', 4311, 3800, 'sts_dechet_valcor_matching_v2_2022Q3') ('2025-02-06 00:04:09', 4748, 2410, 'RUBBIA_PET_Fonce_add_surclassifier_rapport') ('2025-02-06 00:04:09', 3994, 1620, 'RUBBIA_proportion_papier_add_surclassifier_rapport') ('2025-02-06 00:04:09', 3789, 1160, 'split_time_score_test_multi_matiere') ('2025-02-06 00:04:09', 4189, 1084, 'split_time_score_JRM_Perlen_convoyeur') ('2025-02-06 00:04:09', 4252, 1025, 'pehd_prod_consolidate') ('2025-02-06 00:04:09', 4851, 926, 'split_time_score_SCCU_8') ('2025-02-06 00:04:09', 3385, 893, 'split_time_score_JRM_Arc_En_Ciel_peu_dense') ('2025-02-06 00:04:09', 4850, 820, 'split_time_score_SCCU_7') ('2025-02-06 00:04:09', 4849, 720, 'split_time_score_SCCU_6') ('2025-02-06 00:04:09', 3995, 416, 'RUBBIA_PEHD_131221_add_surclassifier_rapport') ('2025-02-06 00:04:09', 3142, 380, 'STS_refus_Amiens') ('2025-02-06 00:04:09', 3787, 320, 'split_time_score_urban_fest') ('2025-02-06 00:04:09', 4887, 265, 'split_time_score_Sevran_test') ('2025-02-06 00:04:09', 3181, 165, 'split_time_score_JRM_Arc_En_Ciel') ('2025-02-06 00:04:09', 243, 156, 'prepare_varroa_ellipse_tile_rotate_whiten') ('2025-02-06 00:04:09', 4742, 119, 'entrant_consolidate') ('2025-02-06 00:04:09', 3164, 70, 'debug_sans_detect_pipeline_qualipapia_detect_crop_classify_rle_unique_nms_040321') ('2025-02-06 00:04:09', 3992, 57, 'RUBBIA_Alu_131221_add_surclassifier_rapport') ('2025-02-06 00:04:09', 4208, 50, 'test_acp_fit_transform_20') ('2025-02-06 00:04:09', 4209, 50, 'test_acp') ('2025-02-06 00:04:09', 4212, 50, 'ACP_from_port_5709050_type_5619_size_9') ('2025-02-06 00:04:09', 686, 46, 'copy_argmax_crop') ('2025-02-06 00:04:09', 4621, 36, 'tfhub_18_7_2023') ('2025-02-06 00:04:09', 4567, 36, 'tfhub_19_06_2023') ('2025-02-06 00:04:09', 3781, 35, 'cod_pipeline_Perlen_manuel_sts_test') ('2025-02-06 00:04:09', 1848, 30, 'Pipeline_upm_photos_blanches') ('2025-02-06 00:04:09', 2896, 25, 'test_radom_deformation') ('2025-02-06 00:04:09', 3070, 25, 'test_ventilate_hashtag_type_3326') ('2025-02-06 00:04:09', 3990, 25, 'test_crop_condition_blur') ('2025-02-06 00:04:09', 230, 24, 'datou_test_rotate') ('2025-02-06 00:04:09', 3856, 20, 'RUBBIA_Carton_050821_extract_RYM') ('2025-02-06 00:04:09', 40, 18, 'mask_coco_origin') ('2025-02-06 00:04:09', 2719, 16, 'pipeline_rubbia_detect_crop_classify_rle_unique_nms_080920_only_final') ('2025-02-06 00:04:09', 233, 12, 'datou_test_rotate_conditionnel') ('2025-02-06 00:04:09', 4184, 12, 'detection_plaque_valcor_010622') ('2025-02-06 00:04:09', 4573, 10, 'test_sam_h') ('2025-02-06 00:04:09', 4553, 10, 'copie_4387_test_replace') ('2025-02-06 00:04:09', 4492, 10, 'copie_4387_test_replace') ('2025-02-06 00:04:09', 1026, 8, 'mask_coco_for_test') ('2025-02-06 00:04:09', 571, 6, 'datou_test_flip') ('2025-02-06 00:04:09', 2, 6, 'classification_model') ('2025-02-06 00:04:09', 2085, 5, 'train_points_upm_darker') ('2025-02-06 00:04:09', 2041, 5, 'test_data_aug') ('2025-02-06 00:04:09', 1818, 5, 'blanchir') ('2025-02-06 00:04:09', 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') ('d4018_output_mask', 19683801) ('learn_RUBBIA_REFUS_AMIENS_23', 4991630) ('merge_pipeline_rubbia_jrm_details_3459', 3019087) ('PhotoDescForrotata_polygone', 1084776) ('output_type_final_datou_3068', 436854) ('datou_3996_rle', 291105) ('d4018_output_rle', 241458) ('datou_3993_rle', 229604) ('datou_4322_rle', 208058) ('datou_3995_rle', 197964) ('datou_3979_rle', 183663) ('type_merge_mask_detect_2486_2499', 182377) ('PhotoDescForlabels_result_test_step_tile', 129228) ('learn_mask_rubbia_rle_carton_03_08_21', 115652) ('mask_filmsPE_10_8_23', 91500) ('varroa_from_ellipse_tiled_rotate_shrink_whiten_ok', 55062) ('learn_convoyeur_qualipapia_nantes_poly_100521_1', 39636) ('pht_test_rle_unique_nms_output', 29558) ('test_sam', 9207) ('mask_coco_origin', 3688) ('test_non_regreg_generate_new_image', 2566) ('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 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.20user 0.09system 7:08:37elapsed 0%CPU (0avgtext+0avgdata 33824maxresident)k 39160inputs+56outputs (1660major+9306minor)pagefaults 0swaps