EvolutionAPI
Instancias Conectadas e Desconectadas sumiram DO NADA pela Segunda vez
Welcome!
- [x] Yes, I have searched for similar issues on GitHub and found none.
What did you do?
Eu assim como todos os dias loguei no N8N e apareceu algumas complicações de funcionamento na EVO, da primeira vez apenas criei uma nova instacia associei e acreditei que não iria acontecer mais.
Mas ontem 25/04, meu N8N apareceu um aviso de instabilidade pelo EasyPanel, e quando fui olhar os status da EVO e N8N estavam verdes... ao tentar prosseguir o fluxo constou erro e quando entrei na EVO, todas instancias sumiram, nem as conectadas e nem as desconectadas....
What did you expect?
Encontrar uma solução para meu problema.
What did you observe instead of what you expected?
.
Screenshots/Videos
Não possuo fotos apenas sumiram as instancias, mas tenho os dados dos Logs.
Which version of the API are you using?
2.2.3
What is your environment?
Windows
Other environment specifications
No response
If applicable, paste the log output
APÓS O ERRO eu reiniciei a EVO e reconectei o whatsapp, e a log que apareceu foi :
logs do meu easypael : "Deploying migrations for postgresql Database URL:
[email protected] db:deploy node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
Environment variables loaded from .env Prisma schema loaded from prisma/postgresql-schema.prisma Datasource "db": PostgreSQL database "evolution", schema "public" at "evolution_evo-postgres:5432"
Error: P1001: Can't reach database server at evolution_evo-postgres:5432
Please make sure your database server is running at evolution_evo-postgres:5432. Error executing command: rm -rf ./prisma/migrations && cp -r ./prisma/postgresql-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/postgresql-schema.prisma npm notice npm notice New major version of npm available! 10.8.2 -> 11.3.0 npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.3.0 npm notice To update run: npm install -g [email protected] npm notice Migration failed Deploying migrations for postgresql Database URL:
[email protected] db:deploy node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
Environment variables loaded from .env Prisma schema loaded from prisma/postgresql-schema.prisma Datasource "db": PostgreSQL database "evolution", schema "public" at "evolution_evo-postgres:5432"
Error: P1001: Can't reach database server at evolution_evo-postgres:5432
Please make sure your database server is running at evolution_evo-postgres:5432. Error executing command: rm -rf ./prisma/migrations && cp -r ./prisma/postgresql-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/postgresql-schema.prisma npm notice npm notice New major version of npm available! 10.8.2 -> 11.3.0 npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.3.0 npm notice To update run: npm install -g [email protected] npm notice Migration failed Deploying migrations for postgresql Database URL:
[email protected] db:deploy node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
Environment variables loaded from .env Prisma schema loaded from prisma/postgresql-schema.prisma Datasource "db": PostgreSQL database "evolution", schema "public" at "evolution_evo-postgres:5432"
Error: P1001: Can't reach database server at evolution_evo-postgres:5432
Please make sure your database server is running at evolution_evo-postgres:5432. Error executing command: rm -rf ./prisma/migrations && cp -r ./prisma/postgresql-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/postgresql-schema.prisma npm notice npm notice New major version of npm available! 10.8.2 -> 11.3.0 npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.3.0 npm notice To update run: npm install -g [email protected] npm notice Migration failed Deploying migrations for postgresql Database URL:
[email protected] db:deploy node runWithProvider.js "rm -rf ./prisma/migrations && cp -r ./prisma/DATABASE_PROVIDER-migrations ./prisma/migrations && npx prisma migrate deploy --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
Environment variables loaded from .env Prisma schema loaded from prisma/postgresql-schema.prisma Datasource "db": PostgreSQL database "evolution", schema "public" at "evolution_evo-postgres:5432"
49 migrations found in prisma/migrations
Applying migration 20240609181238_init Applying migration 20240610144159_create_column_profile_name_instance Applying migration 20240611125754_create_columns_whitelabel_chatwoot Applying migration 20240611202817_create_columns_debounce_time_typebot Applying migration 20240712144948_add_business_id_column_to_instances Applying migration 20240712150256_create_templates_table Applying migration 20240712155950_adjusts_in_templates_table Applying migration 20240712162206_remove_templates_table Applying migration 20240712223655_column_fallback_typebot Applying migration 20240712230631_column_ignore_jids_typebot Applying migration 20240713184337_add_media_table Applying migration 20240718121437_add_openai_tables Applying migration 20240718123923_adjusts_openai_tables Applying migration 20240722173259_add_name_column_to_openai_creds Applying migration 20240722173518_add_name_column_to_openai_creds Applying migration 20240723152648_adjusts_in_column_openai_creds Applying migration 20240723200254_add_webhookurl_on_message Applying migration 20240725184147_create_template_table Applying migration 20240725202651_add_webhook_url_template_table Applying migration 20240725221646_modify_token_instance_table Applying migration 20240729115127_modify_trigger_type_openai_typebot_table Applying migration 20240729180347_modify_typebot_session_status_openai_typebot_table Applying migration 20240730152156_create_dify_tables Applying migration 20240801193907_add_column_speech_to_text_openai_setting_table Applying migration 20240803163908_add_column_description_on_integrations_table Applying migration 20240808210239_add_column_function_url_openaibot_table Applying migration 20240811021156_add_chat_name_column Applying migration 20240811183328_add_unique_index_for_remoted_jid_and_instance_in_contacts Applying migration 20240813003116_make_label_unique_for_instance Applying migration 20240814173033_add_ignore_jids_chatwoot Applying migration 20240814202359_integrations_unification Applying migration 20240817110155_add_trigger_type_advanced Applying migration 20240819154941_add_context_to_integration_session Applying migration 20240821120816_bot_id_integration_session Applying migration 20240821171327_add_generic_bot_table Applying migration 20240821194524_add_flowise_table Applying migration 20240824161333_add_type_on_integration_sessions Applying migration 20240825130616_change_to_evolution_bot Applying migration 20240828140837_add_is_on_whatsapp_table Applying migration 20240828141556_remove_name_column_from_on_whatsapp_table Applying migration 20240830193533_changed_table_case Applying migration 20240906202019_add_headers_on_webhook_config Applying migration 20241001180457_add_message_status Applying migration 20241006130306_alter_status_on_message_table Applying migration 20241007164026_add_unread_messages_on_chat_table Applying migration 20241011085129_create_pusher_table Applying migration 20241011100803_split_messages_and_time_per_char_integrations Applying migration 20241017144950_create_index Applying migration 20250116001415_add_wavoip_token_to_settings_table
The following migration(s) have been applied:
migrations/ └─ 20240609181238_init/ └─ migration.sql └─ 20240610144159_create_column_profile_name_instance/ └─ migration.sql └─ 20240611125754_create_columns_whitelabel_chatwoot/ └─ migration.sql └─ 20240611202817_create_columns_debounce_time_typebot/ └─ migration.sql └─ 20240712144948_add_business_id_column_to_instances/ └─ migration.sql └─ 20240712150256_create_templates_table/ └─ migration.sql └─ 20240712155950_adjusts_in_templates_table/ └─ migration.sql └─ 20240712162206_remove_templates_table/ └─ migration.sql └─ 20240712223655_column_fallback_typebot/ └─ migration.sql └─ 20240712230631_column_ignore_jids_typebot/ └─ migration.sql └─ 20240713184337_add_media_table/ └─ migration.sql └─ 20240718121437_add_openai_tables/ └─ migration.sql └─ 20240718123923_adjusts_openai_tables/ └─ migration.sql └─ 20240722173259_add_name_column_to_openai_creds/ └─ migration.sql └─ 20240722173518_add_name_column_to_openai_creds/ └─ migration.sql └─ 20240723152648_adjusts_in_column_openai_creds/ └─ migration.sql └─ 20240723200254_add_webhookurl_on_message/ └─ migration.sql └─ 20240725184147_create_template_table/ └─ migration.sql └─ 20240725202651_add_webhook_url_template_table/ └─ migration.sql └─ 20240725221646_modify_token_instance_table/ └─ migration.sql └─ 20240729115127_modify_trigger_type_openai_typebot_table/ └─ migration.sql └─ 20240729180347_modify_typebot_session_status_openai_typebot_table/ └─ migration.sql └─ 20240730152156_create_dify_tables/ └─ migration.sql └─ 20240801193907_add_column_speech_to_text_openai_setting_table/ └─ migration.sql └─ 20240803163908_add_column_description_on_integrations_table/ └─ migration.sql └─ 20240808210239_add_column_function_url_openaibot_table/ └─ migration.sql └─ 20240811021156_add_chat_name_column/ └─ migration.sql └─ 20240811183328_add_unique_index_for_remoted_jid_and_instance_in_contacts/ └─ migration.sql └─ 20240813003116_make_label_unique_for_instance/ └─ migration.sql └─ 20240814173033_add_ignore_jids_chatwoot/ └─ migration.sql └─ 20240814202359_integrations_unification/ └─ migration.sql └─ 20240817110155_add_trigger_type_advanced/ └─ migration.sql └─ 20240819154941_add_context_to_integration_session/ └─ migration.sql └─ 20240821120816_bot_id_integration_session/ └─ migration.sql └─ 20240821171327_add_generic_bot_table/ └─ migration.sql └─ 20240821194524_add_flowise_table/ └─ migration.sql └─ 20240824161333_add_type_on_integration_sessions/ └─ migration.sql └─ 20240825130616_change_to_evolution_bot/ └─ migration.sql └─ 20240828140837_add_is_on_whatsapp_table/ └─ migration.sql └─ 20240828141556_remove_name_column_from_on_whatsapp_table/ └─ migration.sql └─ 20240830193533_changed_table_case/ └─ migration.sql └─ 20240906202019_add_headers_on_webhook_config/ └─ migration.sql └─ 20241001180457_add_message_status/ └─ migration.sql └─ 20241006130306_alter_status_on_message_table/ └─ migration.sql └─ 20241007164026_add_unread_messages_on_chat_table/ └─ migration.sql └─ 20241011085129_create_pusher_table/ └─ migration.sql └─ 20241011100803_split_messages_and_time_per_char_integrations/ └─ migration.sql └─ 20241017144950_create_index/ └─ migration.sql └─ 20250116001415_add_wavoip_token_to_settings_table/ └─ migration.sql
All migrations have been successfully applied. npm notice npm notice New major version of npm available! 10.8.2 -> 11.3.0 npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.3.0 npm notice To update run: npm install -g [email protected] npm notice Migration succeeded
[email protected] db:generate node runWithProvider.js "npx prisma generate --schema ./prisma/DATABASE_PROVIDER-schema.prisma"
Environment variables loaded from .env Prisma schema loaded from prisma/postgresql-schema.prisma
✔ Generated Prisma Client (v6.3.0) to ./*****/@prisma/client in 1.39s
Start by importing your Prisma Client (See: https://pris.ly/d/importing-client)
Tip: Want real-time updates to your database without manual polling? Discover how with Pulse: https://pris.ly/tip-0-pulse
Prisma generate succeeded
[email protected] start:prod node dist/main [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheEngine] [string] RedisCache initialized for groups [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheEngine] [string] RedisCache initialized for Re [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheEngine] [string] RedisCache initialized for instance [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheEngine] [string] RedisCache initialized for baileys [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [CacheService] [string] cacheservice created using cache engine: Gt [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 INFO [WA MODULE] [string] Module - ON [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [Redis] [string] redis connecting [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:43 VERBOSE [Redis] [string] redis ready [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:44 INFO [PrismaRepository] [string] Repository:Prisma - ON [Evolution API] v2.2.3 171 - Sat Apr 26 2025 00:25:44 LOG [SERVER] [string] HTTP - ON: 8080 create instance { instanceName: 'Elenice', integration: 'WHATSAPP-BAILEYS', token: '------------------' } [Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:14 INFO [ChannelStartupService] [string] Browser: Evolution API V2,Chrome,5.4.0-212-generic [Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:14 INFO [ChannelStartupService] [string] Baileys version env: 2,3000,1015901307 [Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:14 INFO [ChannelStartupService] [string] Group Ignore: false [Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:16 LOG [ChannelStartupService] [string]
{ instance: Elenice pairingCode: null, qrcodeCount: 1 } ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ █ ▄▄▄▄▄ █▄█▀▄▄ ▄▀▀▀▄▀▄█ ▄▄█▀▄ █▄ ▀▀▀▄▀ ▄ ▄ ▄ ██ ▄▄▄▄▄ █ █ █ █ █ ▀▄▄▀█▄▄▀ ██▄▄▀▀ ██▄█▀ █▄ ▄▄█▄▄ ▄▀▄ ██ █ █ █ █ █▄▄▄█ █▄▀ █▄▀█▀▀ ▀▄ █▀ ▄▄▄ ██▄▀▄▄ ▄███▀██▄▀▄██ █▄▄▄█ █ █▄▄▄▄▄▄▄█▄▀ █▄▀ █▄▀ ▀▄▀▄▀▄█ █▄█ ▀ ▀ █ █ ▀ █▄▀▄▀ █ █▄▄▄▄▄▄▄█ █ ▄█▀▄▀ ▀ ▀██ █ ▀ ▄▄▄ ▀▀▄▄▄ █ ▄▀▀█▄ ▄█ ▀ █ ██ ▄ ▀ █ █▀▀█ ▄█▄█ ██▄▀ ▀▄ ██ ▄▄▄▀▄██▄▀ █ ██ █ ▀ █ ▄▄▄ █ ▄██ ▄█ █ █ █▀ █ ▄▄█ ▄▄▀▄ ▀▄█▄▀ █▄ █▄▄█▀█▀▀█ █ ▀▀ ███▄█▀▄██▄ ▀██▄▀ █ █ █▄█▄▄▄▀█▀▄█▀ ██ ▄▄█▀ ▀ ▄▀█▀▀▀▄▀▀▀█ ▀██▄▀▄ ▄█ █▄█ ▀▀▀██ █▄▄▀▄▀ ▄▄█▀█▀ ▄ ▀██▄█ ▀▀█▄▀▄▄ █▄ █▀█▀██▄▀ █ ▀▀▄▄█▄▀█▄▀ ▄█ █▀ ▀▄ ▄█▄▄▀██▀▀█▄ ▄▀ ▀▀█▀ ▀ █▀▄▄▀ ▄█▀▀█ ▄█ ▀▀▄█▄▀ █▀▄ ██ █ ▀▀█▀▄▄▄ ▀▀ ██ ▀███▄▄▀█▀▀▄ ▀██ ▄ ▀▀▄ ▀ ▀██▄▄ ▄ ▄▄ ▀█ █▀█▄▀▄▄▄██▄▀ █▄ ▀▄ ▄ ▄█▀ █▀ ▀▀█ █▀▄▀█▄▄ ▀ ▀▀ ▀▀▀██▄ █ ██▄█ ███▄ ▄▄▀█▀▄▀ █ █▄ █ ███▄██▀▀██▄▄ ▄▄▀▀▀ █ ▀▀███ ██ █▄▄█ █▄▀ ▄ ▄▄▄ ▄ ▀█▀█▄▄▀▀█▄ ▀█ ▄▄▄ █ █▄ █ ▄▀▄▄██ ▄█ ▄▄▄ ▀▀█▀█ █ █ █▄█ ▄ █▄▄▄ █▄██▀▀▀▄█ █▄█ ▀▄▄ ▄█ ▄██▀█▄▄ ▀█ █▄█ ▀▀█ █ █▀▀██ ▄ ▄▀██ █ ▀▀▀█▄█ ▀▀ ▄ ▄▄█ █▀▄ ▀▀ █▄█▀ ▄▄▄█▄█▀█ █▀▄▄▀ ▀▄ ▄█▀ █ █▄█▀▄▀ ▀▄███▀▀ ▀ ▄▀▀ ▄▄▄█▀███▄█▀█▀▄▄▄ ▀▄█ █ ▄▄▀▄▀▄▄ █▄▀▀ ▀▄ █▀█ █ ▄ █ ▄ █ ▄█▄ █ █▄█▀▄▀▀ ▀▄▀ ██▀▄▄▄█ █▄▄ ▄ █▄▀ ▀ ▄▄ ▄███ ▀██▀ ▄████▄█▄▀█▄ ▀ ▀███▄██▄▀▄█▄▀█ ▄███ █▀ █ ▄▀▀██▄▀▄▄ ▄▀▀ ▀▄▀█ ▄ █▀▄ ██ ▄ ▀▄▀ █▄▄█▄▄▀███ ▀█▄█ █▀██▄██▄▀▀▄ ▀█▀█▄ ▀▀ █▄█▀▄▀ ▀▀ ██▄▄▀██▄█ ▀▀▄▄ ▀ ▄█▄ ▄ ▄▄█ █ █▄ █▄ ▄ ██▀▀ ███▀█▄ ▄█ ▄█▀████ ▀▀█▀ ▄▀▄▄▀▄██▄▀▄▀▄▀█▀▄█ ▀█ █ █▄▀█ ▄▀▀ ▄█ ██▀▀ ▄ ██ ▄██████▀▄█▄█▀█ █████▄▀█▄▄▄▄▄ █ █ ▀ ▀▀▄▄▀ ▄ ▄▀█▀▄ ▀█▄ ▄█▄▄█▀▀███▀ ██▀█▄▄▀ █▀ ▀ ▄▀▄▄ ▄█ ███████▄█▀█▄█▀█▀▀▄ ▀▀█▀███ ▄▄▄ ▀▄█▄▄ ▀▀█▄▄ ▀▀█▀ ▄▄▄ ▄█▀▄█ █ ▄▄▄▄▄ ███ ▄██▄ █▄▀████ ▄▄ █▄█ ██ █▀▀ █ ▄▄██▄▄▄ █▄█ ▀█▀█ █ █ █ █▀ ▄ ██▀█▀█ ▄▄▀ ▀▄▄▄▄ ▄▀ ██ ▄█▀ █▄ ▀ ▀▄ ▄▄▄█▄ ▄█ █ █▄▄▄█ █ ▀█▀ ▀▀ ▀▀▄▀▀▀█▀▄█▄▀█▀▄▀▀▀█▀▄ ▄▄▀█ ▄▀█ ▀ █▀███▀█ █▄▄▄▄▄▄▄█▄█▄██▄▄▄█▄█▄▄▄▄▄▄▄██████▄██████▄▄▄▄███▄▄██▄█▄▄████
{"level":50,"time":1745****,"pid":171,"hostname":"****","node":{"tag":"stream:error","attrs":{"code":"515"}},"msg":"stream errored out"}
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:30 INFO [ChannelStartupService] [string] Browser: Evolution API V2,Chrome,5.4.0-212-generic
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:30 INFO [ChannelStartupService] [string] Baileys version env: 2,3000,1015901307
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:30 INFO [ChannelStartupService] [string] Group Ignore: false
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:33 INFO [ChannelStartupService] [string]
┌──────────────────────────────┐
│ CONNECTED TO WHATSAPP │
└──────────────────────────────┘
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:33 INFO [ChannelStartupService] [string]
wuid: -------------------
name: Elenice
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55[email protected] (add-label_jid): 6
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55@s.whatsapp.net (add-label_jid): 7
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55***@s.whatsapp.net (add-label_jid): 7
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55***@s.whatsapp.net (add-label_jid): 6
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55***@s.whatsapp.net (add-label_jid): 7
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55***@s.whatsapp.net (add-label_jid): 6
[Evolution API] [Elenice] v2.2.3 171 - Sat Apr 26 2025 01:36:40 INFO [ChannelStartupService] [string] labels association - 55***@s.whatsapp.net (add-label_jid): 7
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
{
origin: Promise {
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
at Bn.handleRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:7362)
at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6686)
at Bn.request (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6393)
at async l (<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:130:9645)
at async Rs.addLabel (/evolution/dist/main.js:253:3945)
at async labels.association (/evolution/dist/main.js:230:31695) {
code: 'P2010',
clientVersion: '6.3.0',
meta: [Object]
}
}, stderr: 2 }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
PrismaClientKnownRequestError:
Invalid prisma.$executeRawUnsafe() invocation:
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification at Bn.handleRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:7362) at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6686) at Bn.request (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6393) at async l (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:130:9645) at async Rs.addLabel (/evolution/dist/main.js:253:3945) at async labels.association (/evolution/dist/main.js:230:31695) { code: 'P2010', clientVersion: '6.3.0', meta: { code: '42P10', message: 'ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification' } }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
{
origin: Promise {
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
at Bn.handleRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:7362)
at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6686)
at Bn.request (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6393)
at async l (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:130:9645)
at async Rs.addLabel (/evolution/dist/main.js:253:3945)
at async labels.association (/evolution/dist/main.js:230:31695) {
code: 'P2010',
clientVersion: '6.3.0',
meta: [Object]
}
}, stderr: 2 }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
PrismaClientKnownRequestError:
Invalid prisma.$executeRawUnsafe() invocation:
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification at Bn.handleRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:7362) at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6686) at Bn.request (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6393) at async l (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:130:9645) at async Rs.addLabel (/evolution/dist/main.js:253:3945) at async labels.association (/evolution/dist/main.js:230:31695) { code: 'P2010', clientVersion: '6.3.0', meta: { code: '42P10', message: 'ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification' } }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
{
origin: Promise {
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
at Bn.handleRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:7362)
at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6686)
at Bn.request (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6393)
at async l (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:130:9645)
at async Rs.addLabel (/evolution/dist/main.js:253:3945)
at async labels.association (/evolution/dist/main.js:230:31695) {
code: 'P2010',
clientVersion: '6.3.0',
meta: [Object]
}
}, stderr: 2 }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
PrismaClientKnownRequestError:
Invalid prisma.$executeRawUnsafe() invocation:
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification at Bn.handleRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:7362) at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6686) at Bn.request (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6393) at async l (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:130:9645) at async Rs.addLabel (/evolution/dist/main.js:253:3945) at async labels.association (/evolution/dist/main.js:230:31695) { code: 'P2010', clientVersion: '6.3.0', meta: { code: '42P10', message: 'ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification' } }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
{
origin: Promise {
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
at Bn.handleRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:7362)
at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6686)
at Bn.request (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6393)
at async l (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:130:9645)
at async Rs.addLabel (/evolution/dist/main.js:253:3945)
at async labels.association (/evolution/dist/main.js:230:31695) {
code: 'P2010',
clientVersion: '6.3.0',
meta: [Object]
}
}, stderr: 2 }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
PrismaClientKnownRequestError:
Invalid prisma.$executeRawUnsafe() invocation:
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification at Bn.handleRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:7362) at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6686) at Bn.request (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:121:6393) at async l (/<CAMINHO_INTERNO>//@prisma/client/runtime/library.js:130:9645) at async Rs.addLabel (/evolution/dist/main.js:253:3945) at async labels.association (/evolution/dist/main.js:230:31695) { code: 'P2010', clientVersion: '6.3.0', meta: { code: '42P10', message: 'ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification' } }
[Evolution API] v2.2.3 171 - Sat Apr 26 2025 01:36:40 ERROR [unhandledRejection] [object]
{
origin: Promise {
Raw query failed. Code: 42P10. Message: ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification
at Bn.handleRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:7362)
at Bn.handleAndLogRequestError (/<CAMINHO_INTERNO>/****/@prisma/client/runtime/library.js:121:6686)
Additional Notes
perguntei ao GPT enviando o contexto e logs ele me encaminhou isso :
" Sim, entendi perfeitamente. Esse trecho mostra que a instância “Elenice” foi criada com sucesso e conectada ao WhatsApp, mas houve erro ao tentar adicionar labels nos contatos. O erro específico do Prisma (42P10) indica que não há uma constraint única ou de exclusão para aplicar a cláusula ON CONFLICT na query SQL.
Isso normalmente acontece quando se tenta fazer um INSERT ... ON CONFLICT DO UPDATE em uma tabela que não tem nenhuma chave única ou índice de exclusão definido para evitar duplicações.
Você quer ajuda para resolver esse erro no banco ou ajustar o código da API? "
ao explicar contexto, ele respondeu outra coisa : " Perfeito, acabei de analisar os logs que você mandou, e aqui está o que encontrei:
📄 Análise dos logs Últimos registros: vbnet Copiar Editar INFO: Successfully connected to the database INFO: Starting to queue instance initialization jobs... INFO: [INSTANCE-INIT] Initialization failed: Cannot read properties of undefined (reading 'id') ERROR: Unhandled Rejection at: Promise: Reason: TypeError: Cannot read properties of undefined (reading 'id') 🧠 O que isso significa? Esses logs mostram que o servidor da Evolution tentou iniciar as instâncias, mas falhou porque tentou acessar uma propriedade .id de algo que estava undefined — ou seja, não existia ou não foi retornado corretamente.
Esse tipo de erro geralmente acontece quando:
O banco de dados ou API da EVO não retornou corretamente os dados das instâncias.
A estrutura dos dados foi alterada ou está corrompida.
Há inconsistência nos dados salvos (ex: um número foi removido, mas o sistema ainda tenta acessá-lo).
Houve queda temporária de conexão com o banco de dados ou Redis.
📉 Efeitos práticos: O sistema falhou ao carregar suas instâncias porque não conseguiu identificar os dados necessários. Por isso, elas "sumiram" da interface — mas isso não significa que foram apagadas, apenas não estão sendo exibidas corretamente.
✅ O que fazer agora? Reinicie o serviço da EVO (se você tiver acesso ao backend ou painel de admin):
Reiniciar geralmente força o sistema a tentar reprocessar as instâncias.
Verifique o banco de dados ou peça isso ao suporte:
Solicite que eles verifiquem se os dados das suas instâncias estão lá mas estão com algum erro de leitura.
Envie esse trecho de log ao suporte da EVO com o seguinte texto:
📩 Sugestão de mensagem para o suporte: Olá, equipe EVO.
Minhas instâncias sumiram de repente e, ao verificar os logs da aplicação, encontrei o seguinte erro:
bash Copiar Editar [INSTANCE-INIT] Initialization failed: Cannot read properties of undefined (reading 'id') Isso indica que o sistema está tentando acessar uma propriedade de um objeto indefinido, o que pode estar impedindo o carregamento das minhas instâncias.
Poderiam verificar se houve alguma falha na leitura do banco de dados ou inconsistência nos dados das instâncias?
Agradeço desde já.
Se quiser, posso te ajudar a revisar essa mensagem ou montar outra, dependendo de como você vai abrir o chamado (WhatsApp, e-mail, ou sistema deles). Quer que eu formate para WhatsApp? "
