A large number of traces are in a pending state?

[wangxiaojia-wxj]

A large number of traces are in a pending state, but they have indeed been completed

Pending traces: 329966 Pending edges: 1543 Broken traces: 429

For example, one of them:trace_id='ycqOqX6papQ/CXrFY2Mu7ukytoFhExbz/PxhnNAIb9c='

[wangxiaojia-wxj]

For example, one of them:trace_id='ycqOqX6papQ/CXrFY2Mu7ukytoFhExbz/PxhnNAIb9c='
{
"trace_id": "ycqOqX6papQ/CXrFY2Mu7ukytoFhExbz/PxhnNAIb9c=",
"external_hash": "0ioaUAVoZqChAO0aHZMhfmWK96OoWICtlVIh/GJwXIU=",
"mc_seqno_start": "42339034",
"mc_seqno_end": "42339037",
"start_lt": "51239066000003",
"start_utime": 1732531647,
"end_lt": "51239069000002",
"end_utime": 1732531655,
"trace_info": {
"trace_state": "pending",
"messages": 13,
"transactions": 13,
"pending_messages": 2,
"classification_state": "unclassified"
},

Block 42339038 does indeed exist in the database，but mc_deqno_end=42339037
Can you give me some advice? What might be the problem？

[wangxiaojia-wxj]

Is there a problem with this modification statement in the InsertManagerial Postgres. cpp file?
if (!is_first_trace) {
traces_query << " ON CONFLICT (trace_id) DO UPDATE SET "
<< "mc_seqno_end = EXCLUDED.mc_seqno_end, "
<< "end_lt = EXCLUDED.end_lt, "
<< "end_utime = EXCLUDED.end_utime, "
<< "state = EXCLUDED.state, "
<< "pending_edges_ = EXCLUDED.pending_edges_, "
<< "edges_ = EXCLUDED.edges_, "
<< "nodes_ = EXCLUDED.nodes_ "
<< "WHERE traces.end_lt < EXCLUDED.end_lt;\n";

It should be like this, right?
traces_query << " ON CONFLICT (trace_id) DO UPDATE SET "
<< "mc_seqno_end = EXCLUDED.mc_seqno_end, "
<< "end_lt = EXCLUDED.end_lt, "
<< "end_utime = EXCLUDED.end_utime, "
<< "state = EXCLUDED.state, "
<< "pending_edges_ = EXCLUDED.pending_edges_, "
<< "edges_ = EXCLUDED.edges_, "
<< "nodes_ = EXCLUDED.nodes_ "
<< "WHERE traces.end_lt < EXCLUDED.end_lt or traces.mc_seqno_end < EXCLUDED.mc_seqno_end ;\n";