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: 11/03/2025, 07:00:27 Nombre de datou current ('date', 'nombre de datou current') ('2025-03-11 07:00:27', 671) Nombre total de photos traitees dans les dernieres 24 heures ('date', 'total de photos traitees') ('2025-03-11 07:00:27', 666715) Nombre total de photos restant a traiter non commence ('date', 'Nombre total de photos restant a traiter non commence') ('2025-03-11 07:05:12', 45385) Nombre total de photos restant a traiter ('date', 'Nombre total de photos restant a traiter') ('2025-03-11 07:05:17', 15525) 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-11 07:09:55', 4311, 7616, 100, 7516, 'sts_dechet_valcor_matching_v2_2022Q3', 1.0, '21218632:dechet_val:991:1', 1) ('2025-03-11 07:09:55', 4219, 5848, 3428, 2420, 'detection_plaque_valcor_010622', 198.0, '20658354:plaque_val:1064:0,21093986:plaque_val:1064:0,21130800:plaque_val:1064:0,21163827:plaque_val:1064:0', 4) ('2025-03-11 07:09:55', 4322, 5007, 3007, 2000, 'RUBBIA_filmPE_151122', 101.22377622377623, '21033315:film_pedb_:1017:0,21049814:film_pedb_:1017:1,21071194:film_pedb_:1017:0,21080849:film_pedb_:1017:0,21082430:film_pedb_:739:0,21089619:film_pedb_:739:0,21089669:film_pedb_:739:0,21089671:film_pedb_:739:0,21091671:film_pedb_:739:0,21092007:film_pedb_:739:0,21106593: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_pedb_:1017:0,21123364:film_pedb_:1017:0,21123376:film_pedb_:1017:0,21123387:film_pedb_:1017:0,21124003:film_pedb_:1017:0,21124039:film_pedb_:1017:0,21124050:film_pedb_:1017:0,2112405', 143) ('2025-03-11 07:09:55', 4489, 2586, 932, 1654, 'multi_classification_tapis_dechet', 66.5, '21090076:cedre_arge:1080:0,21130766:cedre_arge:1080:0,21214967:cedre_arge:1080:0,21247513:cedre_arge:1080:0', 4) ('2025-03-11 07:09:55', 4220, 1181, 227, 954, 'split_time_score_plaque_Valcor', 0.0, '21218521:plaque_val:1064:0', 1) ('2025-03-11 07:09:55', 3994, 1779, 1397, 382, 'RUBBIA_proportion_papier_add_surclassifier_rapport', 104.24285714285715, '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,21054304:gm_diff_ba:1017:', 70) ('2025-03-11 07:09:55', 4892, 2194, 1943, 251, 'multi_classification_tapis_dechet', 3.5, '21247121:angers_mon:1017:1,21262955:sevran_122:739:1', 2) ('2025-03-11 07:09:55', 3991, 490, 320, 170, 'RUBBIA_ELA_131221_add_surclassifier_rapport', 104.875, '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,21055192:ela_diff_b:1017:0,21056532:ela_diff_b:1017:0,21059359:ela_diff_b:1017:0,21059806:ela_diff_b:1017:0,21143651:ela_diff_b:1017:0', 16) ('2025-03-11 07:09:55', 533, 5008, 4894, 114, 'multi_classification_tapis_dechet', 4.666666666666667, '21247122:jetson_tes:739:1,21247140:aec_metal_:739:1,21263015:arc_en_cie:739:1', 3) ('2025-03-11 07:09:55', 3804, 303, 231, 72, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', 2.0, '21248021:pet_clair_:739:1,21263036:pet_clair_:739:1,21263065:pet_clair_:739:1', 3) ('2025-03-11 07:09:55', 4310, 1134, 1116, 18, 'classifieur_2camions_valcor_021122_v1', 3.0, '21255643:dechet_val:991:0', 1) ('2025-03-11 07:09:55', 4877, 36, 29, 7, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', 0.0, '21261723:JRM_diff_b:979:1,21261781:JRM_diff_b:979:1,21261875:JRM_diff_b:979:1,21262482:JRM_diff_b:979:1,21262682:JRM_diff_b:979:1,21262783:JRM_diff_b:979:1,21263291:JRM_diff_b:979:0', 7) ('2025-03-11 07:09:55', 4234, 31, 25, 6, 'refus_rym_velours_valcor', 5.5, '21236229:truck_diff:991:0,21262780:incinerati:1103:1', 2) ('2025-03-11 07:09:55', 3993, 16, 10, 6, 'RUBBIA_Carton_131221_add_surclassifier_rapport', 0.0, '21263067:emr_diff_b:739:0', 1) ('2025-03-11 07:09:55', 4650, 7, 2, 5, 'sem_seg_film_PE_08_23', 90.0, '21066813:AutoGenera:31:0', 1) ('2025-03-11 07:09:55', 3995, 17, 17, 0, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', 0.0, '21263064:pehd_pp_di:739:1', 1) ('2025-03-11 07:09:55', 4866, 5, 5, 0, 'dib_crop_merge_2486_2499_classifiy_2547_extract_RYM_with_sam', 516.5, '20608796:excoffier_:1117:1,20608797:excoffier_:1117:1,20608798:excoffier_:1117:1,20610133:excoffier_:1117:1', 4) 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-11 07:09:57', 3804, 161, 'Rubbia_crop_merge_2486_2499_classifiy_2547_extract_RYM', Decimal('0.0000'), '21262951:pet_clair_:1017:0,21263024:pet_clair_:739:0,21263030:pet_clair_:739:0,21263036:pet_clair_:739:1,21263045:pet_clair_:739:0,21263048:pet_clair_:739:0,21263056:pet_clair_:739:0,21263060:pet_clair_:739:0', 8) ('2025-03-11 07:09:57', 3991, 191, 'RUBBIA_ELA_131221_add_surclassifier_rapport', Decimal('62.6283'), '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,21227244:ela_diff_b:739:0,21232888:ela_diff_b:1017:0,21247983:ela_diff_b:739:0,21263037:ela_diff_b:739:0', 10) ('2025-03-11 07:09:57', 3992, 189, 'RUBBIA_Alu_131221_add_surclassifier_rapport', Decimal('71.1164'), '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,21225874:aluminium_:1017:0,21227245:aluminium_:739:0,21232706:aluminium_:739:0,21242157:aluminium_:739:0,21263029:aluminium_:739:0,21263040:aluminium_:739:0,21263054:aluminium_:739:0', 20) ('2025-03-11 07:09:57', 3993, 188, 'RUBBIA_Carton_131221_add_surclassifier_rapport', Decimal('0.0000'), '21263027:emr_diff_b:739:0,21263033:emr_diff_b:739:0,21263034:gros_carto:739:0,21263039:emr_diff_b:739:0,21263043:emr_diff_b:739:0,21263044:gros_carto:739:0,21263047:emr_diff_b:739:0,21263051:emr_diff_b:739:0,21263052:gros_carto:739:0,21263055:emr_diff_b:739:0,21263058:emr_diff_b:739:0,21263062:gros_carto:739:0,21263063:emr_diff_b:739:0', 13) ('2025-03-11 07:09:57', 3995, 130, 'RUBBIA_PEHD_131221_add_surclassifier_rapport', Decimal('0.0000'), '21262950:pehd_pp_di:1017:0,21263028:pehd_pp_di:739:0,21263035:pehd_pp_di:739:0,21263041:pehd_pp_di:739:0,21263049:pehd_pp_di:739:0,21263057:pehd_pp_di:739:0', 6) ('2025-03-11 07:09:57', 4219, 14280, 'detection_plaque_valcor_010622', Decimal('331.1660'), '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-11 07:09:57', 4220, 1417, 'split_time_score_plaque_Valcor', Decimal('1.8320'), '21195861:plaque_val:1064:0,21218521:plaque_val:1064:0', 2) ('2025-03-11 07:09:57', 4234, 734, 'refus_rym_velours_valcor', Decimal('15.0041'), '21221311:truck_diff:991:0,21221312:truck_diff:991:0,21221313:truck_diff:991:0,21221314:truck_diff:991:0,21221315:truck_diff:991:0,21221316:truck_diff:991:0,21221317:truck_diff:991:0,21221319:truck_diff:991:0,21221321:truck_diff:991:0,21222314:incinerati:1103:0,21222316:incinerati:1103:0,21222318:incinerati:1103:0,21222320:incinerati:1103:0,21222324:incinerati:1103:0,21222342:incinerati:1103:0,21222353:incinerati:1103:0,21222441:truck_diff:991:0,21222442:truck_diff:991:0,21222444:truck_diff:991:0,21222445:truck_diff:991:0,21222446:truck_diff:991:0,21222447:truck_diff:991:0,21222448:truck_diff:991:0,21222449:truck_diff:991:0,21222466:truck_diff:991:0,21222483:truck_diff:991:0,21222484:truck_diff:991:0,21222485:truck_diff:991:0,21222486:truck_diff:991:0,21222487:truck_diff:991:0,21222489:truck_diff:991:0,21222490:truck_diff:991:0,21222491:truck_diff:991:0,21222493:truck_diff:991:0,21222498:truck_diff:991:0,21222501:truck_diff:991:0,21222502:truck_diff:991:0,21222503:truck_diff:991:0,21222504:truck_diff:991:0,212', 124) ('2025-03-11 07:09:57', 4311, 7616, 'sts_dechet_valcor_matching_v2_2022Q3', Decimal('1.0000'), '21218632:dechet_val:991:1', 1) ('2025-03-11 07:09:57', 4322, 2694, 'RUBBIA_filmPE_151122', Decimal('76.8081'), '21136642:film_pedb_:1017:0,21136785:film_pedb_:739:0,21136789:film_pedb_:739:0,21136799:film_pedb_:739:0,21136806:film_pedb_:739:0,21136815:film_pedb_:739:0,21136821:film_pedb_:739:0,21136896:film_pedb_:1017:0,21136901:film_pedb_:1017:0,21136906:film_pedb_:1017:0,21136912:film_pedb_:1017:0,21136915:film_pedb_:1017:0,21136922:film_pedb_:1017:0,21136927:film_pedb_:1017:0,21136947:film_pedb_:1017:0,21136954:film_pedb_:1017:0,21137241:film_pedb_:1017:0,21137247:film_pedb_:1017:0,21137270:film_pedb_:1017:0,21137274:film_pedb_:1017:0,21137281:film_pedb_:1017:0,21137304:film_pedb_:1017:0,21137310:film_pedb_:1017:0,21137317:film_pedb_:1017:0,21137324:film_pedb_:1017:0,21137506:film_pedb_:1017:0,21137516:film_pedb_:1017:0,21137526:film_pedb_:1017:0,21137530:film_pedb_:1017:0,21137540:film_pedb_:1017:0,21137549:film_pedb_:1017:0,21137571:film_pedb_:1017:0,21137953:film_pedb_:1017:0,21137956:film_pedb_:1017:0,21137960:film_pedb_:1017:0,21137965:film_pedb_:1017:0,21137972:film_pedb_:1017:0,21138545:film_pedb_:1017:0,2113', 83) ('2025-03-11 07:09:57', 4346, 971, 'split_time_score_cedre', Decimal('13.6251'), '21193918:cedre_arge:1080:0,21247513:cedre_arge:1080:0', 2) ('2025-03-11 07:09:57', 4742, 9, 'entrant_consolidate', Decimal('12.0000'), '21221267:entrant_di:1092:0', 1) ('2025-03-11 07:09:57', 4748, 362, 'RUBBIA_PET_Fonce_add_surclassifier_rapport', Decimal('34.5359'), '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,21223417:flux_dev_r:739:0,21227259:flux_dev_r:739:0,21231205:flux_dev_r:739:0,21234392:flux_dev_r:739:0,21238134:flux_dev_r:739:0,21242155:flux_dev_r:739:0,21263025:flux_dev_r:739:0,21263031:flux_dev_r:739:0,21263038:flux_dev_r:739:0,21263046:flux_dev_r:739:0,21263053:flux_dev_r:739:0,21263061:flux_dev_r:739:0', 18) ('2025-03-11 07:09:57', 4877, 15, 'RUBBIA_JRM_detail_conts_mask2896_sc2868_rubbia_live', Decimal('0.0000'), '21263291:JRM_diff_b:979:0,21263433:JRM_diff_b:979:0,21263434:JRM_diff_b:979:0', 3) ('2025-03-11 07:09:57', 4878, 1733, 'split_time_score_JRM_Arc_En_Ciel_test_load', Decimal('0.0000'), '21219185:arc_en_cie:979:0', 1) ('2025-03-11 07:09:57', 4887, 7240, 'split_time_score_Sevran_test', Decimal('0.0000'), '21220062:sevran_122:739:0', 1) ('2025-03-11 07:09:57', 4891, 6138, 'split_time_score_angers_montee_convoyeur', Decimal('0.0000'), '21219775: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') 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.22user 0.11system 9:34.56elapsed 0%CPU (0avgtext+0avgdata 35684maxresident)k 28008inputs+32outputs (2473major+8005minor)pagefaults 0swaps