Echo dot présent dans la Base de donnée mais absent dans l'interface d'affichage

Didier3L · Décembre 13, 2025, 7:41

Bonjour,

Cela était arrivé, une fois, que je perde tous mes équipements Alexa dans Jeedom.
Grosse galère à cette époque, puisqu’il m’a fallu repartir de zéro surtout avec les scénarios associés aux équipements.

Hier, je constate que un de mes équipements Alexa existe sur la page Jeedom, mais est introuvable dans la base de données avec aucune commande.

Voici l’explication en vidéo
Kapture 2025-12-12 at 18.56.59 2(1)

Heureusement, une restauration d’une sauvegarde de la veille à régler le problème.

Ce qui est très étonnant, c’est que l’équipement répond à toutes les demandes de commande ou d’information …
Il est donc difficile de savoir ou de comprendre cette erreur

[2025-12-12 18:50:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-12 18:56:51][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst counter (rqstCounter) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-12 18:56:51][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst status (rqstStatus) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-12 19:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-12 19:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-12 19:00:16][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/notifications >>> Server down ?
[2025-12-12 19:20:18][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXX/XXXXXXX >>> Server down ?
[2025-12-12 19:20:27][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-12 19:40:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-12 20:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-12 20:00:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-12 20:10:15][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXX >>> Server down ?
[2025-12-12 20:20:15][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-12 20:50:15][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXX >>> Server down ?
[2025-12-12 21:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-12 21:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-12 21:40:16][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXX/XXXXXXXX >>> Server down ?
[2025-12-12 22:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-12 23:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-12 23:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-12 23:00:23][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-12 23:10:14][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXX/XXXXXX >>> Server down ?
[2025-12-13 00:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 00:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 00:20:14][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 01:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 01:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 01:00:15][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: skills-store.amazon.fr at GET https://skills-store.amazon.fr/app/secure/your-skills-page?deviceType=app&ref-suffix=ysa_gw&pfm=XXXXXXXX&cor=FR&lang=en-us >>> Server down ?
[2025-12-13 01:40:20][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 01:50:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXXX >>> Server down ?
[2025-12-13 02:00:11][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 02:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 03:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 03:00:09][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 03:00:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXX/XXXXXX >>> Server down ?
[2025-12-13 03:10:10][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/devices/deviceType/dsn/audio/v1/allDeviceVolumes >>> Server down ?
[2025-12-13 04:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 04:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 05:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 05:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 05:00:20][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 05:20:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXXX >>> Server down ?
[2025-12-13 06:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 06:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 07:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 07:30:21][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXX >>> Server down ?
[2025-12-13 08:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 09:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 09:00:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 09:40:20][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 10:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 10:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 10:10:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/G070VM1493930QJU/AKPGW064GI9HE >>> Server down ?
[2025-12-13 11:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 11:05:19][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst counter (rqstCounter) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-13 11:05:19][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst status (rqstStatus) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-13 11:06:04][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst counter (rqstCounter) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-13 11:06:04][WARNING] : 	createOrUpdateCmds [Alexa System] cmd histRqst status (rqstStatus) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
[2025-12-13 11:10:10][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 11:26:03][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 11:27:03][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 11:30:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 11:34:03][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 11:35:03][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 11:40:12][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 11:41:43][WARNING] : Erreur getLibHistoryRecords  : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `id`, `name`, `father_id`, `isVisible`, `position`, `configuration`, `display`, `image` 		FROM object 		WHERE id=:id
[2025-12-13 11:41:49][WARNING] : Erreur getLibHistoryRecords  : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `id`, `name`, `father_id`, `isVisible`, `position`, `configuration`, `display`, `image` 		FROM object 		WHERE id=:id
[2025-12-13 11:41:56][WARNING] : Erreur getLibHistoryRecords  : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `id`, `name`, `father_id`, `isVisible`, `position`, `configuration`, `display`, `image` 		FROM object 		WHERE id=:id
[2025-12-13 11:42:03][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 11:50:14][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXX/XXXXXX >>> Server down ?
[2025-12-13 12:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 12:00:18][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 13:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 13:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 14:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 14:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 14:30:25][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 15:00:11][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 15:00:11][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 15:10:11][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/ascending-alarm >>> Server down ?
[2025-12-13 15:30:21][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXX >>> Server down ?
[2025-12-13 16:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 16:10:15][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 16:20:19][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXX/XXXXXXXXXX >>> Server down ?
[2025-12-13 16:30:13][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 17:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 17:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 18:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 18:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false
[2025-12-13 18:10:14][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXX/XXXXXXX >>> Server down ?
[2025-12-13 18:20:20][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/bluetooth?cached=true >>> Server down ?
[2025-12-13 18:23:06][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 18:30:13][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/equalizer/XXXXXXXXX/XXXXXXXX >>> Server down ?
[2025-12-13 18:36:02][ERROR] : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name
[2025-12-13 19:00:10][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 19:10:16][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXX >>> Server down ?
[2025-12-13 19:40:12][WARNING] : connectorAlexa::makeRequest curl error(6) : Could not resolve host: alexa.amazon.fr at GET https://alexa.amazon.fr/api/device-notification-state/XXXXXXXXXX/1/XXXXXXXXX >>> Server down ?
[2025-12-13 20:00:09][WARNING] : getSysInfos cmd_postTextMessage found => amzn1.account.XXXXXXXXXXXXXX|Didier
[2025-12-13 20:00:10][WARNING] : connectorAlexa::makeRequest code 429 at GET https://alexa-comms-mobile-service.amazon.com/homegroups/amzn1.comms.id.hg.amzn1~XXXXXXXXXX/devices?target=false

limad44 · Décembre 13, 2025, 8:53

[quote=« Didier3L, post:1, topic:145457 »]

[/quote][MySQL] Error code : 42S02 (1146). Table ‹ jeedom.object › doesn’t exist : SELECT el.id, el.name,

[quote]

Probablement une corruption de la bd. Ça me rappelle des signes précurseurs d’un HDD HS.

Didier3L · Décembre 13, 2025, 10:10

Hello,

Pour les log je suis pas vraiment sur que se soient les bon.
Id 1146 n’existe pas
Mon écho est le 1972

limad44 · Décembre 14, 2025, 2:43

Je sais pas à quoi correspond cet id probablement à jeedom.object. qui n’existe plus.

Didier3L · Décembre 14, 2025, 9:30

Ce matin je vérifie si mon écho est toujours opérationnel
Même problème que dans mon message initial
Je fais la restauration du matin à 7h.
L’écho est de nouveau opérationnel.
Et je trouve cette ligne dans les logs après restauration

0000|[2025-12-14 10:22:02] ERROR  : Erreur sur la fonction cron du plugin : [MySQL] Error code : 42S02 (1146). Table 'jeedom.object' doesn't exist  : SELECT `el`.`id`, `el`.`name`, `el`.`logicalId`, `el`.`generic_type`, `el`.`object_id`, `el`.`eqType_name`, `el`.`isVisible`, `el`.`isEnable`, `el`.`configuration`, `el`.`timeout`, `el`.`category`, `el`.`display`, `el`.`order`, `el`.`comment`, `el`.`tags` 		FROM eqLogic el 		LEFT JOIN object ob ON el.object_id=ob.id 		WHERE eqType_name=:eqType_name  AND isEnable=1 ORDER BY ob.name,el.name

limad44 · Décembre 14, 2025, 10:52

C’est toujours sur le même echo ? Les autres rien ?

Didier3L · Décembre 14, 2025, 10:54

Oui toujours le même
J’ai mis les logs en debug et je vais attendre pour voir si cela se reproduit

limad44 · Décembre 14, 2025, 1:44

un scan des devices se passe bien ?

Didier3L · Décembre 14, 2025, 3:27

Oui

170|[2025-12-14 16:25:01] DEBUG  :   rqstDaemon getAuthInfos => http://192.168.1.242:3467/getAuthInfos
1171|[2025-12-14 16:25:03] DEBUG  :   checkCmds_Device [Echo chambre parents] End
1172|[2025-12-14 16:25:04] DEBUG  :   checkCmds_Device [Echo du Salon] End
1173|[2025-12-14 16:25:06] DEBUG  :   checkCmds_Device [Echo du Sous sol] End
1174|[2025-12-14 16:25:06] DEBUG  :   checkCmds_Device [Echo de la salle de bain] End
1175|[2025-12-14 16:25:07] DEBUG  :   checkCmds_Device [Fire TV] End
1176|[2025-12-14 16:25:07] DEBUG  :   checkCmds_Device [Voice in a Can for iOS] End
1177|[2025-12-14 16:25:07] DEBUG  :   checkCmds_Device [Groupe du bas] End
1178|[2025-12-14 16:25:07] DEBUG  :   checkCmds_Device [Groupe du haut] End
1179|[2025-12-14 16:25:07]WARNING : 	createOrUpdateCmds [Alexa System] cmd histRqst counter (rqstCounter) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
1180|[2025-12-14 16:25:07]WARNING : 	createOrUpdateCmds [Alexa System] cmd histRqst status (rqstStatus) No More exist removing...["refresh","sendTextCommand","postTextMessage","annonce","message","speak","skillsLive","skillsDev","runRoutine","runAlarm","SendMobilePush"]
1181|[2025-12-14 16:25:07] DEBUG  :   checkCmds_Device [Alexa System] End

Didier3L · Décembre 15, 2025, 10:08

Ce matin mon écho est toujours là.
Je clôture

edit : Suite : Echo dot présent dans la Base de donnée mais absent dans l'interface d'affichage

system · Décembre 16, 2025, 10:08

Ce sujet a été automatiquement fermé après 24 heures suivant le dernier commentaire. Aucune réponse n’est permise dorénavant.