[Bug]: Find & Replace not working correctly all the time #2886

Open
opened 2026-02-28 20:31:36 -06:00 by GiteaMirror · 12 comments
Owner

Originally created by @Juulz on GitHub (Feb 3, 2026).

Originally assigned to: @MatissJanis, @Copilot on GitHub.

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

After a few large find/replace operations, I found a few duplicated transactions and some missing transactions. Previously reconciled accounts with matching running balances no longer matched.

One transaction, in a closed account, was duplicated twice.

I had to revert to a backup.

How can we reproduce the issue?

How can we reproduce the issue? I don't believe I can reproduce it exactly, nor do I want to mess with my data again. Also, the find/replace works strangely and has no "Apply", you have to press "Enter". Not intuitive at all.

Where are you hosting Actual?

None

What browsers are you seeing the problem on?

No response

Operating System

None

Originally created by @Juulz on GitHub (Feb 3, 2026). Originally assigned to: @MatissJanis, @Copilot on GitHub. ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? After a few large find/replace operations, I found a few duplicated transactions and some missing transactions. Previously reconciled accounts with matching running balances no longer matched. One transaction, in a closed account, was duplicated twice. I had to revert to a backup. ### How can we reproduce the issue? How can we reproduce the issue? I don't believe I can reproduce it exactly, nor do I want to mess with my data again. Also, the find/replace works strangely and has no "Apply", you have to press "Enter". Not intuitive at all. ### Where are you hosting Actual? None ### What browsers are you seeing the problem on? _No response_ ### Operating System None
GiteaMirror added the needs infobug labels 2026-02-28 20:31:36 -06:00
Author
Owner

@youngcw commented on GitHub (Feb 3, 2026):

I wonder if rules are getting run after and causing the problems.

@youngcw commented on GitHub (Feb 3, 2026): I wonder if rules are getting run after and causing the problems.
Author
Owner

@Juulz commented on GitHub (Feb 3, 2026):

I wonder if rules are getting run after and causing the problems.

That might explain the dupes made in a closed account. That's the one that really threw me!

@Juulz commented on GitHub (Feb 3, 2026): > I wonder if rules are getting run after and causing the problems. That might explain the dupes made in a closed account. That's the one that really threw me!
Author
Owner

@youngcw commented on GitHub (Feb 3, 2026):

I looked at the code for the find an replace again. Nothing in there seems like it would change amounts or create transactions. I would check your rules to see if anything jumps out.

@youngcw commented on GitHub (Feb 3, 2026): I looked at the code for the find an replace again. Nothing in there seems like it would change amounts or create transactions. I would check your rules to see if anything jumps out.
Author
Owner

@Juulz commented on GitHub (Feb 3, 2026):

Schedule with a rule, but no rule on its own. A couple of the operations were done on "All Accounts" and included about 90 transactions. I tested slowly before I did the whole batch, so I was surprised when a few balances were lower than I remembered when I reconciled an hour before. Hopefully it was a one-off as I was find/replacing an emoji (which is now back for Jan-Jun 2025, but I'm just gonna live with it)

@Juulz commented on GitHub (Feb 3, 2026): Schedule with a rule, but no rule on its own. A couple of the operations were done on "All Accounts" and included about 90 transactions. I tested slowly before I did the whole batch, so I was surprised when a few balances were lower than I remembered when I reconciled an hour before. Hopefully it was a one-off as I was find/replacing an emoji (which is now back for Jan-Jun 2025, but I'm just gonna live with it)
Author
Owner

@youngcw commented on GitHub (Feb 3, 2026):

If you could do it again and try to figure out edit caused the issue that would be useful. You should be able to CTRL-Z the changes once you find the one that is breaking things

@youngcw commented on GitHub (Feb 3, 2026): If you could do it again and try to figure out edit caused the issue that would be useful. You should be able to CTRL-Z the changes once you find the one that is breaking things
Author
Owner

@Juulz commented on GitHub (Feb 3, 2026):

OK... I went through month by month and it happened. I ctrl-z back and went forward and it was fine. I loaded up the backup again and it happened. I'm touching up screenshots, but I'm thinking it was merged transactions.

@Juulz commented on GitHub (Feb 3, 2026): OK... I went through month by month and it happened. I ctrl-z back and went forward and it was fine. I loaded up the backup again and it happened. I'm touching up screenshots, but I'm thinking it was merged transactions.
Author
Owner

@Juulz commented on GitHub (Feb 3, 2026):

In order:
Before find/replace in just the Checking Account:

Image

In All Accounts

Image

Find/replace for 🔗 complete. Closed accounts now have amounts!

Image

Here's All Accounts for that date. The 🔗s are gone. Transactions appeared. Looks like the transactions may have been merged?

Image
@Juulz commented on GitHub (Feb 3, 2026): In order: Before find/replace in just the Checking Account: <img width="1690" height="194" alt="Image" src="https://github.com/user-attachments/assets/54e7843c-484c-480f-98c4-963675061a7b" /> In All Accounts <img width="1707" height="124" alt="Image" src="https://github.com/user-attachments/assets/41a540c3-cccd-46bb-98e8-ff678aab0c78" /> Find/replace for 🔗 complete. Closed accounts now have amounts! <img width="305" height="201" alt="Image" src="https://github.com/user-attachments/assets/5662ca0d-31e6-47e3-9a39-65d6be8a2669" /> Here's All Accounts for that date. The 🔗s are gone. Transactions appeared. Looks like the transactions may have been merged? <img width="1717" height="383" alt="Image" src="https://github.com/user-attachments/assets/607e178d-ad9c-4c56-bc80-93cb5e95285e" />
Author
Owner

@Juulz commented on GitHub (Feb 3, 2026):

Ctrl-z back to before the find/replace, redid the find/replace and no error. Closed accounts are fine:

Image
@Juulz commented on GitHub (Feb 3, 2026): Ctrl-z back to before the find/replace, redid the find/replace and no error. Closed accounts are fine: <img width="293" height="185" alt="Image" src="https://github.com/user-attachments/assets/e13a4805-dd58-4c96-a931-13c97fc45d7b" />
Author
Owner

@youngcw commented on GitHub (Feb 3, 2026):

I wonder if it isn't because of merged transactions, but transfers in general. I wonder if new transfers are getting made

@youngcw commented on GitHub (Feb 3, 2026): I wonder if it isn't because of merged transactions, but transfers in general. I wonder if new transfers are getting made
Author
Owner

@MatissJanis commented on GitHub (Feb 4, 2026):

Which PR introduced find&replace? We (or I) can ask an AI agent to do a preliminary analysis there to see if it finds any problems.

@MatissJanis commented on GitHub (Feb 4, 2026): Which PR introduced find&replace? We (or I) can ask an AI agent to do a preliminary analysis there to see if it finds any problems.
Author
Owner

@Juulz commented on GitHub (Feb 4, 2026):

Which PR introduced find&replace? We (or I) can ask an AI agent to do a preliminary analysis there to see if it finds any problems.

#6282

@Juulz commented on GitHub (Feb 4, 2026): > Which PR introduced find&replace? We (or I) can ask an AI agent to do a preliminary analysis there to see if it finds any problems. #6282
Author
Owner

@MatissJanis commented on GitHub (Feb 4, 2026):

@copilot please investigate what could cause the problem reported in this issue. It was possibly introduced in #6282

@MatissJanis commented on GitHub (Feb 4, 2026): @copilot please investigate what could cause the problem reported in this issue. It was possibly introduced in #6282
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#2886