search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.19k stars 204 forks source link

FB 5.0.1: error at the end of the backup process #8068

Open gsbelarus opened 1 month ago

gsbelarus commented 1 month ago

Server mode: Classic or Super (tested for both) Max parallel workers: 64 Parallel workers: 16

At the end of database backup gets the following message:

12:42:46,47 C:\Program Files\FB5>gbak -b "G:\XXXXXX.FDB" "G:\XXXXXXX.bk" -pas XXXXXXX -user sysdba -se localhost/3056:service_mgr
gbak: ERROR:Error reading data from the connection.
gbak:Exiting before completion due to errors

There is a record in the firebird.log:

XXXXXXXX    Wed Apr  3 12:57:23 2024
    INET/inet_error: read errno = 10054, server host = localhost, address = ::1/3056

Visually, the resulting bk file looks fine, though I didn't check how the database will be restored from it.

hvlad commented 1 month ago

Title shows "restore", command line shows "-b", i.e. backup. What is correct ? ;) How it can be reproduced ? Or you have a crash dump ?

gsbelarus commented 1 month ago

Sorry, fixed the title. This is an issue with back up now. I'm still in my thoughts about that restoring error, that was fixed recently.

hvlad commented 1 month ago

I need more info to investigate the issue. Tried to reproduce with db that I've used to reproduce #7942 - no luck.

hvlad commented 2 weeks ago

Any new info, test case probably ?

gsbelarus commented 2 weeks ago

I will wait until this commit goes into the FB 5 build and then recheck.

https://github.com/FirebirdSQL/firebird/commit/e96fc77d504740d2d8e7b69d9594c2700877c9a3

hvlad commented 2 weeks ago

Hmm... that was about restore. Anyway, it was fixed in v5 first, two days ago.

hvlad commented 1 week ago

Look like 5.0.1 will not include fix for this "Elusive Joe". Should I close the issue as not reproducible ?

gsbelarus commented 1 week ago

it is reproducible 100%. I'm just weighting procs and cons of sending sensitive data.

hvlad commented 1 week ago

It is up to you, but I can't fix something that is not reproducible and with no info.