firebird icon indicating copy to clipboard operation
firebird copied to clipboard

FB 5.0.1: error at the end of the backup process

Open gsbelarus opened this issue 2 years ago • 11 comments

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.

gsbelarus avatar Apr 03 '24 11:04 gsbelarus

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

hvlad avatar Apr 03 '24 12:04 hvlad

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.

gsbelarus avatar Apr 03 '24 14:04 gsbelarus

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

hvlad avatar Apr 04 '24 10:04 hvlad

Any new info, test case probably ?

hvlad avatar Apr 28 '24 10:04 hvlad

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

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

gsbelarus avatar Apr 28 '24 10:04 gsbelarus

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

hvlad avatar Apr 28 '24 17:04 hvlad

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

hvlad avatar May 10 '24 07:05 hvlad

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

gsbelarus avatar May 10 '24 09:05 gsbelarus

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

hvlad avatar May 10 '24 09:05 hvlad

@hvlad sent instructions how to get the db by email

gsbelarus avatar Jun 25 '24 10:06 gsbelarus

Received your email, thanks

hvlad avatar Jun 25 '24 11:06 hvlad

Still can't reproduce it

hvlad avatar Jul 06 '24 07:07 hvlad

I'm closing it. Let's assume it is somehow related to the particular configuration of Windows 2019 Server and three Firebird servers (2.5, 3.0, 5.0) running on different ports.

gsbelarus avatar Jul 06 '24 09:07 gsbelarus