python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/prod/suivi_dashboard.py -T message -J last -I 10 -cs -q -DS 3073,3142,3385,3980,3981,4189,4197,4311,4323,4346,4887,4891,4220 -C 533,4310,4219,4489,4892 -cs -ts -rc' -s temps_de_traitement -M 0 -S 0 -U 97,80,97 import MySQLdb succeeded Import error (python version) warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data suivi_dashboard start Starting time : 1781159546.2240539 Missing data for key 'pic_no_classify' in raspi data, skipping. 2026/06/10 : Working: - DECHET_VALCOR --> 86.09% (Total: 640 | Uploaded: 551 | No trait: 3 | No classify: 1 | Duplicated: 85) Warning : No infos about batches yet - PERLEN --> 65.36% (Total: 716 | Uploaded: 468 | No trait: 1 | No classify: 247) Batches (0): Warning : moins de 10 batchs - AUTRES --> 51.75% (Total: 487 | Uploaded: 252 | No trait: 7 | No classify: 221 | Duplicated: 7) Warning : No infos about batches yet Warning(<20%): - TEST --> 0.97% (Total: 1439 | Uploaded: 14 | No trait: 2 | Dark: 4) Warning : No infos about batches yet Error: No pictures found: ARC_EN_CIEL_PEU_DENSE ARC_EN_CIEL_MM ARC_EN_CIEL_JRM ARC_EN_CIEL_ACIER REFUS_AMIENS SEVRAN CEDRE DERICHEBOURG Warning : number of dashboard : 4 does not equal to what we wait : 10 message/check uploadsElapsed time : 0.14793944358825684 =====================check sts===================== perlen_0423_03062026 31146218 ni sts nor classifieur found in done. check datou current : () https://www.fotonower.com/view/31146218?reverse=true perlen_0423_10062026 31145473 last done with classifieur, try to relaunch sts! check datou current : ({'id': 4385219, 'mtr_portfolio_id': 31145473, 'mtd_id': 4189, 'state': 0, 'created_at': datetime.datetime(2026, 6, 11, 7, 0, 2), 'updated_at': datetime.datetime(2026, 6, 11, 8, 31, 17)},) https://www.fotonower.com/view/31145473?reverse=true perlen_0423_09062026 31145188 last done with classifieur, try to relaunch sts! INSERT into MTRPhoto.mtr_datou_current (mtd_id, mtr_photo_id, mtr_portfolio_id, mtr_user_id) VALUES (4189,NULL,31145188,1053) ON DUPLICATE KEY UPDATE backup = backup + 1 check datou current : () https://www.fotonower.com/view/31145188?reverse=true perlen_0423_08062026 31144925 last done with classifieur, try to relaunch sts! sts not found in done, should be still in current. check datou current : ({'id': 4385213, 'mtr_portfolio_id': 31144925, 'mtd_id': 4189, 'state': 0, 'created_at': datetime.datetime(2026, 6, 9, 7, 0, 2), 'updated_at': datetime.datetime(2026, 6, 11, 8, 31, 17)},) https://www.fotonower.com/view/31144925?reverse=true perlen_0423_02062026 31144897 last done with classifieur, try to relaunch sts! sts not found in done, should be still in current. check datou current : () https://www.fotonower.com/view/31144897?reverse=true perlen_0423_01062026 31143228 last done with classifieur, try to relaunch sts! check datou current : ({'id': 4385206, 'mtr_portfolio_id': 31143228, 'mtd_id': 4189, 'state': 1, 'created_at': datetime.datetime(2026, 6, 1, 20, 30, 2), 'updated_at': datetime.datetime(2026, 6, 11, 7, 35, 27)},) https://www.fotonower.com/view/31143228?reverse=true check_stsElapsed time : 12.695066690444946 Mail sent: {'message_id': '<202606110632.24508024961@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard arc_en_ciel_jrm Mail sent: {'message_id': '<202606110632.49409895903@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard refus_amiens Mail sent: {'message_id': '<202606110632.26467626250@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard arc_en_ciel_jrm_peu_dense Mail sent: {'message_id': '<202606110632.50177017443@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard angers_montee_convoyeur Mail sent: {'message_id': '<202606110632.72884553330@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard sevran Mail sent: {'message_id': '<202606110632.29463858359@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard plaque_Valcor Mail sent: {'message_id': '<202606110632.84490158299@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard dechet_Valcor_v2 Mail sent: {'message_id': '<202606110632.74628184701@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard arc_en_ciel_mm Mail sent: {'message_id': '<202606110632.73096921709@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard SCCU_cam6 Mail sent: {'message_id': '<202606110632.93215194471@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard SCCU_cam8 Mail sent: {'message_id': '<202606110632.37736612285@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard SCCU_cam7 Mail sent: {'message_id': '<202606110632.57213428504@smtp-relay.mailin.fr>', 'message_ids': None} mail d'alerte envoyé pour le dashboard arc_en_ciel_acier alert_checkElapsed time : 1.4661710262298584 Catched exception ! Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 106, in select cursor.execute(query, args) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 331, in _query self._do_get_result(db) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 136, in _do_get_result self._result = result = self._get_result() File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 363, in _get_result return self._get_db().store_result() MySQLdb.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 81, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/__init__.py", line 121, in Connect return Connection(*args, **kwargs) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 200, in __init__ super().__init__(*args, **kwargs2) MySQLdb.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/prod/suivi_dashboard.py", line 732, in TableSummary(context, datou_classifieur, last_days, relaunch_carac, verbose) File "/home/admin/workarea/git/Velours/python/prod/suivi_dashboard.py", line 479, in TableSummary df_score = retrieve_photo_quality(context, today_rows, verbose) File "/home/admin/workarea/git/Velours/python/prod/suivi_dashboard.py", line 508, in retrieve_photo_quality blur_info = get_quality_photo_data_by_pid(context, pid, quality_thcl=_blur_thr) File "/home/admin/workarea/git/Velours/python/prod/memo/lib_sla.py", line 414, in get_quality_photo_data_by_pid quality_info = context.gq.select(query_quality) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 115, in select self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 84, 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 1.60user 1.28system 7:30:21elapsed 0%CPU (0avgtext+0avgdata 166528maxresident)k 188168inputs+24outputs (17546major+64014minor)pagefaults 0swaps