[GH-ISSUE #96] Restoration task stuck #76

Open
opened 2026-02-26 21:34:19 +03:00 by kerem · 3 comments
Owner

Originally created by @TristisOris on GitHub (Feb 12, 2025).
Original GitHub issue: https://github.com/eduardolat/pgbackweb/issues/96

  • Nothing happens, no traffic.
  • Container restart not cancel this tasks.
  • Restoration page loading for a few minutes.

Image

at /tmp folder both dumps exist.

Image

nothing changed after their removal.

i tried to remove task from database, but it cause memory leak at my client.

then i connect to db inside container. no succeess.

Image

Image

i can SELECT * FROM restorations LIMIT 10; but limit 20 already broken

Image

Originally created by @TristisOris on GitHub (Feb 12, 2025). Original GitHub issue: https://github.com/eduardolat/pgbackweb/issues/96 - Nothing happens, no traffic. - Container restart not cancel this tasks. - Restoration page loading for a few minutes. ![Image](https://github.com/user-attachments/assets/fa0433a1-cd09-4884-b8d0-196ca464e885) at /tmp folder both dumps exist. ![Image](https://github.com/user-attachments/assets/5a334ac7-b129-4bef-a8fe-fb965e5a6a91) nothing changed after their removal. i tried to remove task from database, but it cause memory leak at my client. then i connect to db inside container. no succeess. ![Image](https://github.com/user-attachments/assets/c502ee8f-3116-4c29-ace3-406cbda56afc) ![Image](https://github.com/user-attachments/assets/147489ff-5b86-4ede-95ce-1a6bcdaea6bf) i can `SELECT * FROM restorations LIMIT 10;` but limit 20 already broken ![Image](https://github.com/user-attachments/assets/db739f14-eab9-4109-8b4e-75e0d4c86343)
Author
Owner

@TristisOris commented on GitHub (Feb 12, 2025):

Image

no id of running tasks here, so nothing to remove.
nvm id changed after restart or something else. removed them.

Problem was not with running tasks, but with some huge with a lot of error records. I even can't open it detais at UI.

Image

4 times! don't ask me. After this removal everything goes fine.

<!-- gh-comment-id:2653017481 --> @TristisOris commented on GitHub (Feb 12, 2025): ![Image](https://github.com/user-attachments/assets/b9cc6fee-79ec-4033-b708-383ab72b1446) no id of running tasks here, so nothing to remove. nvm id changed after restart or something else. removed them. Problem was not with running tasks, but with some huge with a lot of error records. I even can't open it detais at UI. ![Image](https://github.com/user-attachments/assets/0d6b8761-90ec-4b8d-85f7-14542ce97764) 4 times! don't ask me. After this removal everything goes fine.
Author
Owner

@TristisOris commented on GitHub (Feb 12, 2025):

2 db restoratation always failed and UI became slow. reproduced few times.

Image

Image

9min to restore 600mb.

other db succeed to restore into same source.

can't copy log because it too huge.

Image

Image

both db with TImescale. RIght now it fall into restore state, so can't create a TS extention, that a root of problem.

<!-- gh-comment-id:2653413065 --> @TristisOris commented on GitHub (Feb 12, 2025): 2 db restoratation always failed and UI became slow. reproduced few times. ![Image](https://github.com/user-attachments/assets/2085be32-44a1-4433-977d-083c0f3260c4) ![Image](https://github.com/user-attachments/assets/12a97982-8fa1-4d7b-91f2-a1af52b2faf0) 9min to restore 600mb. other db succeed to restore into same source. can't copy log because it too huge. ![Image](https://github.com/user-attachments/assets/096048a8-fd4b-4dec-9d6e-0e5e6216ef8c) ![Image](https://github.com/user-attachments/assets/1e556feb-88f7-40f5-a6d7-618a28741427) both db with TImescale. RIght now it fall into restore state, so can't create a TS extention, that a root of problem.
Author
Owner

@TristisOris commented on GitHub (Feb 12, 2025):

repeat it again. Same DB restoration failed on fresh instance.

<!-- gh-comment-id:2653619474 --> @TristisOris commented on GitHub (Feb 12, 2025): repeat it again. Same DB restoration failed on fresh instance.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/pgbackweb#76
No description provided.