fix: Erro ao enviar mensagem para grupos (remoteJid failed constraint) - #2162
Merged
DavidsonGomes merged 3 commits intoNov 7, 2025
Conversation
Copy link
Copy Markdown
Contributor
Sorry, something went wrong.
…B writes Refactors the cache-saving logic to prevent `Unique constraint failed` errors. This issue occurs when an item's `remoteJid` is not yet included in the `jidOptions` of the existing record. The database query now uses an `OR` condition to find a matching record by either `jidOptions` (using `contains`) or by the `remoteJid` itself in a single query. Additionally, this commit introduces several performance optimizations: 1. **Skip Unnecessary Updates**: The function now performs a deep comparison between the new payload and the `existingRecord`. An `update` operation is only executed if the data has actually changed, reducing unnecessary database writes. 2. **Parallel Processing**: The sequential `for...of` loop has been replaced with `Promise.allSettled`. This allows all items in the `data` array to be processed concurrently, significantly speeding up execution for batch inputs. 3. **Data Consistency**: The JIDs in `jidOptions` are now sorted alphabetically before being joined into a string. This ensures that the change-detection logic is accurate, regardless of the order in which JIDs were discovered. 4. **Refactor**: Simplified JID unification logic using a `Set` and introduced a `normalizeJid` helper function for cleaner code. TODO: Investigate the root cause of why `remoteJid` is sometimes not present in `jidOptions` upon initial discovery.
Copy link
Copy Markdown
Contributor
Reviewer's GuideRefactors the saveOnWhatsappCache function to prevent unique constraint errors by querying both jidOptions and remoteJid, optimize database writes through change detection, process items concurrently for performance, and improve JID normalization and error resilience. Sequence diagram for the updated saveOnWhatsappCache processsequenceDiagram
participant Caller
participant "saveOnWhatsappCache()"
participant "prismaRepository.isOnWhatsapp"
participant Logger
Caller->>"saveOnWhatsappCache()": Call with data array
"saveOnWhatsappCache()"->>Logger: Log start and config check
alt Parallel processing
loop For each item (concurrent)
"saveOnWhatsappCache()"->>Logger: Log normalization/skipped item
"saveOnWhatsappCache()"->>"prismaRepository.isOnWhatsapp": findFirst({ OR: [jidOptions contains jid, remoteJid] })
"saveOnWhatsappCache()"->>Logger: Log result of findFirst
alt Record exists
"saveOnWhatsappCache()"->>Logger: Log change detection
alt Data unchanged
"saveOnWhatsappCache()"->>Logger: Log skip update
else Data changed
"saveOnWhatsappCache()"->>Logger: Log update
"saveOnWhatsappCache()"->>"prismaRepository.isOnWhatsapp": update({ id, data })
end
else No record
"saveOnWhatsappCache()"->>Logger: Log create
"saveOnWhatsappCache()"->>"prismaRepository.isOnWhatsapp": create({ data })
end
"saveOnWhatsappCache()"->>Logger: Log errors if any
end
end
"saveOnWhatsappCache()"->>Caller: Return after all settled
Entity relationship diagram for IsOnWhatsapp table changeserDiagram
IsOnWhatsapp {
string id
string remoteJid
string jidOptions
string lid
datetime createdAt
datetime updatedAt
}
%% Note: The query now checks both remoteJid and jidOptions for existence
%% No new tables, but logic for querying IsOnWhatsapp is updated
Class diagram for updated saveOnWhatsappCache logicclassDiagram
class ISaveOnWhatsappCacheParams {
string remoteJid
string remoteJidAlt
string lid
}
class saveOnWhatsappCache {
+async saveOnWhatsappCache(data: ISaveOnWhatsappCacheParams[])
}
class normalizeJid {
+normalizeJid(jid: string | null | undefined): string | null
}
class prismaRepository_isOnWhatsapp {
+findFirst(where)
+update(where, data)
+create(data)
}
class Logger {
+verbose(...)
+warn(...)
+error(...)
}
ISaveOnWhatsappCacheParams <.. saveOnWhatsappCache : uses
saveOnWhatsappCache o-- normalizeJid : uses
saveOnWhatsappCache o-- prismaRepository_isOnWhatsapp : uses
saveOnWhatsappCache o-- Logger : uses
File-Level Changes
Possibly linked issues
Tips and commands Interacting with Sourcery
Customizing Your ExperienceAccess your dashboard to:
Getting Help
|
Sorry, something went wrong.
Copy link
Copy Markdown
Contributor
There was a problem hiding this comment.
Hey there - I've reviewed your changes - here's some feedback:
- Consider limiting the concurrency in Promise.allSettled (e.g. via a p-limit or batching) for large data arrays to prevent overwhelming your database connections.
- Using Prisma’s contains on the comma-separated jidOptions string may produce false positives; for more reliable lookups consider storing jidOptions as an array field or using an exact-match filter.
Please address the comments from this code review:
## Overall Comments
- Consider limiting the concurrency in Promise.allSettled (e.g. via a p-limit or batching) for large data arrays to prevent overwhelming your database connections.
- Using Prisma’s contains on the comma-separated jidOptions string may produce false positives; for more reliable lookups consider storing jidOptions as an array field or using an exact-match filter.
## Individual Comments
### Comment 1
<location> `src/utils/onWhatsappCache.ts:99-108` </location>
<code_context>
+ // 2. Unifica todos os JIDs usando um Set para garantir valores únicos
+ const finalJidOptions = new Set(expandedJids);
- if (existingRecord?.jidOptions) {
- const existingJids = existingRecord.jidOptions.split(',');
- // TODO: Adicionar JIDs existentes que não estão na lista atual
- existingJids.forEach((jid) => {
- if (!finalJidOptions.includes(jid)) {
- finalJidOptions.push(jid);
- }
- });
+ if (lidAltJid) {
+ finalJidOptions.add(lidAltJid);
}
-
- // TODO: Se tiver remoteJidAlt com @lid novo, adicionar
- if (altJid && !finalJidOptions.includes(altJid)) {
- finalJidOptions.push(altJid);
+
+ if (existingRecord?.jidOptions) {
+ existingRecord.jidOptions.split(',').forEach(jid => finalJidOptions.add(jid));
}
</code_context>
<issue_to_address>
**suggestion (bug_risk):** Merging existing JIDs may introduce legacy or malformed entries.
Validate each JID's format before adding to finalJidOptions to prevent legacy or malformed entries from being included.
Suggested implementation:
```typescript
// 2. Unifica todos os JIDs usando um Set para garantir valores únicos e válidos
function isValidJid(jid: string | null | undefined): boolean {
// Exemplo de validação: JID deve conter '@' e não ser vazio
return typeof jid === 'string' && jid.includes('@') && jid.trim().length > 0;
}
const finalJidOptions = new Set(
expandedJids.filter(jid => isValidJid(jid))
);
```
```typescript
if (lidAltJid && isValidJid(lidAltJid)) {
finalJidOptions.add(lidAltJid);
}
```
```typescript
if (existingRecord?.jidOptions) {
existingRecord.jidOptions
.split(',')
.filter(jid => isValidJid(jid))
.forEach(jid => finalJidOptions.add(jid));
}
```
</issue_to_address>Sourcery is free for open source - if you like our reviews please consider sharing them ✨ Help me be more useful! Please click 👍 or 👎 on each comment and I'll use the feedback to improve your reviews.
Sorry, something went wrong.
DavidsonGomes
merged commit 27be03e
into
evolution-foundation:develop
Nov 7, 2025
3 of 4 checks passed
This was referenced Nov 25, 2025
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.
📋 Description
O objetivo principal destas modificações é corrigir o problema das mensagens não serem enviadas para alguns grupos, principalmente os que tem o número do criador no jid (ex.: '559911223345-1234567890@g.us').
A interrupção no fluxo do request é causada por um erro ao tentar criar um novo registro na base de dados com um remoteJid já existente, isto acontece pois os registros são buscados utilizando apenas o jidOptions, que às vezes não tem o atual remoteJid na lista.
O erro em questão:
Os dados diretamente na base de dados, mostrando que o remoteJid não estava no jidOptions:
SELECT * FROM "IsOnWhatsapp" WHERE "remoteJid" = '554212345678-1625864928@g.us'; id | remoteJid | jidOptions | createdAt | updatedAt | lid ---------------------------+------------------------------+-----------------------------------------------------------+-------------------------+------------------------+----- cm...ok525sz | 554212345678-1625864928@g.us | 5542998558888-1625864928@g.us,55428558888-1625864928@g.us | 2025-10-19 13:40:08.508 | 2025-10-21 15:49:53.21 |A lógica de busca foi alterada para prevenir erros de 'Unique constraint failed'.
Para corrigir isso, a busca no banco agora usa OR para verificar tanto pelo jidOptions quanto pelo remoteJid em uma única query.
Além dessa correção, outras otimizações foram implementadas:
🧪 Type of Change
🧪 Testing
✅ Checklist
📝 Additional Notes
TODO: Investigar a causa raiz de o remoteJid às vezes não estar no jidOptions no momento da busca inicial. Também notei na base de dados que alguns números estão vindo com o "@g.us" duplicado.
Summary by Sourcery
Fix cache save errors for WhatsApp group messages and optimize saveOnWhatsappCache
Bug Fixes:
Enhancements:
Chores: