15.11.2017 7:49, Anto Edin Charley antoedinchar...@gmail.com [firebird-support]
wrote:
> For every Level 2 Backup it takes more than 30 Minutes to complete. Is there
> anything i
> need to Check/Improve
1) Try switch -d. NBackup should work at disk's speed.
2) You can migrate to Firebird 3 wher
04.08.2017 20:37, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
wrote:
> Unfortunately, in your later post you suggested that nbackup is never safe to
> use.
Sure, as any other software it may have destructive bugs. Every software
license has
words like "this software is provi
> El 4 ago 2017, a las 19:05, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] escribió:
>
> 04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote:
>> As I understood he was saying to not use nbackup, and if one person involved
>> in any way to
>> firebird says n
>There is a difference between "do not use it" and "do not use it with this
> version".
Unfortunately, in your later post you suggested that nbackup is never safe to
use.
04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote:
> As I understood he was saying to not use nbackup, and if one person involved
> in any way to
> firebird says not to use it, then what make him think to others?
There is a difference between "do not use it" and "do not
> Hello Sean, I was replying to dimitry s. Have you read his response?
>
> As I understood he was saying to not use nbackup, and if one person
> involved in any way to firebird says not to use it, then what make him think
> to others?
Let's just say that I find Dimitry S POV on many subject and
> El 4 ago 2017, a las 16:54, 'Leyne, Sean' s...@broadviewsoftware.com
> [firebird-support] escribió:
>
> > I only see three items pending, but anyway, why not remove Nbackup from
> > firebird until it is safe to use?
>
> As others have pointed out, the latest FB versions have an updated nb
Jesus Garcia,
> I only see three items pending, but anyway, why not remove Nbackup from
> firebird until it is safe to use?
As others have pointed out, the latest FB versions have an updated nbackup
> Why is there a tool that cannot be used in a safe way?
Q1: How do you *know* if a tool is saf
>
> Always use the latest release. For 2.5 it is 2.5.7. But even with this it is
> not
> guaranteed to work. Check list of nbackup-related bugs in tracker:
> http://tracker.firebirdsql.org/secure/IssueNavigator.jspa?sorter/field=updated&sorter/order=
>
I only see three items pending, but anyw
03.08.2017 11:00, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote:
> From which version is safe to use nbackup ?
Always use the latest release. For 2.5 it is 2.5.7. But even with this it is
not
guaranteed to work. Check list of nbackup-related bugs in tracker:
http://tracker.fir
>Restore your database from backup and never use nbackup with this bugged
FB version any
>more.
Done ...
>From which version is safe to use nbackup ?
02.08.2017 15:20, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote:
> Any idea how to prevent this problem to appear again in the future ?
>
> FB Version : 2.5.2.26539
Restore your database from backup and never use nbackup with this bugged FB
version any
more.
--
WBR, SD.
Hi,
Interesting that FB 3.0 reduces the nbackup time. Thanks for the info.
We have so many installations so I think we will wait for FB 4.0 which have
incremental nbackup restore and native replication.
BR,
Fadi
Hi Hugo,
Yes, in this case you can check MON$ tables.
Please note that in case of many connections query to MON$ can consume
significant resources.
How do you recover if it's stuck?
nbackup -n
>I noticed that the larger the database is the longer it takes to do
nbackup even if the delta
Hi Alexey,
In my case the database is seldom larger 500 MB and the backup takes 30 maximum
seconds.
Would it not be sufficient to check the MON$BACKUP_STATE field (thanks Thomas)
and if its stuck on state 1 or 2 for several minutes then I execute "ALTER
DATABASE END BACKUP".
How do you recove
Hello,
> Hello,
>
> Is there a way to ask a database if someone is performing a nbackup?
>
> If it's in "the physical backup mode".
>
> I'm always paranoid if there is a power failure during a backup and it
> gets stuck in that mode and I would like it to recover from such situation.
> We have
Hi Hugo,
In HQbird, we monitor size and age of delta files.
If it is bigger or older than appropriate size/age (like 500Mb/6 hours,
for example), the database is marked as critical in Control Center.
You can implement the same - the status of the database and path to
delta file can be retrieved
ar.nl [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Sunday, September 11, 2016 5:11 PM
Subject: Re: [firebird-support] "nbackup needs local access to database file"
On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I am getting this e
On 11-9-2016 09:11, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> Gbak and nbackup are different tools that work in a different way. Gbak
> works through a Firebird server (real or embedded), while nbackup works
> with the physical backup file.
That should have been "physical da
On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I am getting this error while running nbackup:
>
> "nbackup needs local access to database file"
>
> The nbackup sentence is:
>
> Nbackup.exe -user SYSDBA -pas HereMyPass -B 0
> localhost:MyDB_FB3.fdbC:\temp\MyDB_
On 27 Mar 2015 02:52:54 -0700, "hugo.lar...@yahoo.com [firebird-support]"
wrote:
> So if the computer is shutdown during a nbackup the database is locked
in
> this way indefinelty?
As far as I know: yes, until you manually end the physical backup mode.
> What do you suggest I should do with Jay
Hi Hugo,
So if the computer is shutdown during a nbackup the database is locked
in this way indefinelty?
Yes, it's one of the most prevalent problems with nbackup.
To prevent it you need to monitor delta file age and size - manually, or
automatically using our FBDataGuard tool.
What do
Hello Mark,
So if the computer is shutdown during a nbackup the database is locked in this
way indefinelty?
What do you suggest I should do with JayBird when the exception is thrown?
Execute "alter database end backup"?
BR,
On 27 Mar 2015 01:24:06 -0700, "hugo.lar...@yahoo.com [firebird-support]"
wrote:
> We have a POS application using Firebird 2.5.3 together with JayBird on
> about 300 sites.
>
> The applications runs nbackup several times everyday. It has happened
> several times on several sites that nbackup fai
What is you firebird version?
AFAIK the only working version, whit no bugs, is 2.5.3
So, try updating customer's Firebird and try again.
Em 04/12/2014 13:10, "wobble...@yahoo.co.uk [firebird-support]" <
firebird-support@yahoogroups.com> escreveu:
>
>
> Hi All,
>
>
> We use nbackup to pull live cop
Hello,
If you have moved or deleted .delta-file, you got the correct message.
If delta file was corrupted, or database was corrupted in the way which
prevent merge, there could be various error messages.
Check your database with gfix -v -full now, to be sure it's Ok.
>Is it risky to run a nba
> From a quick search, I suspect that will be the "pag_scn" 4 byte value.
I don't recall exactly, if you want to pursue this you should ask on the Devel
list for confirmation.
> That would mean that I could relatively easily write my own sync code that
> could also read all those values and de
> But as far as I understand, the database has to track which page changes
> since which backup.
Correct, but that information is actually stored as a "version number" in the
header of each data page. When page data changes the "version number" is
changed.
The nbackup database structure only
Every operating system has some limit on environment strings like command
line, that can be a problem on restore where the every level's filename
should be supplied.
Not sure if it's a theoretical or practical problem in Your case.
I use 3 levels (0 - friday night, 1 - every other weekday night,
> > There is no formal limit, ...
>
> Is there a negative effect on too many levels?
> (Slowdown or database storage overhead?)
No negative effect.
The database does track the ID of the last backup at each level, so you would
have 2 or 3 more entries that the typical usage, but the details ar
>I understand your problem. Would it be possible to measure the size of each
>level 5 backup, and if it's over a certain threshold use a higher
>level for the rest of that day to keep from copying the same large set of data
>over and over?
>
>In essence, you would create a script that backs up e
Steffen Heil (Mailinglisten) skriver:
>
> Hi
>
> > > I could simply create backups with incrementing levels, move the
> > > backup to the other server(s) and apply them there (that database is
> > > offline).
> > > However, I suspect there is a limit for the number of backup levels a
> > > database
Hello Steffen,
> I know that nbackup keeps track of which blocks in the database changed and
> which did not so that backups contain only the blocks that changes since the
> last backup of the next lower level.
> I want to use that feature to do syncs between servers.
>
> I could simply create b
Den 2014-05-05 22:27 skrev Steffen Heil (Mailinglisten) såhär:
>
> I know that nbackup keeps track of which blocks in the database
> changed and which did not so that backups contain only the blocks that
> changes since the last backup of the next lower level.
> I want to use that feature to do s
Hello,
> Hello,
> We have a POS applications with hundreds of clients and need some advice
> on how to backup.
> Each application has it's own Firebird database.
> Read about nbackup and thought that this could be a solution since the
> clients has low bandwidth.
I'm not entirely sure if I unders
Hello Hugo,
> We have a POS applications with hundreds of clients and need some advice on
> how to backup.
> Each application has it's own Firebird database.
> Read about nbackup and thought that this could be a solution since the
> clients has low bandwidth.
>
> My first idea was to daily backu
Hello Maury,
> So a little Google-fu was all that took. Now armed with the credentials, what
> would be the next steps at this point?
>
> I suspect the next step is to END BACKUP. However, I wish to tread
> carefully... I don't have a backup newer than last May, the existing FDB is
> not a usab
On 2014-01-15, at 8:23 PM, Paul Vinkenoog wrote:
>
> I think you should contact Fishbowl Inventory support to clear this up.
So a little Google-fu was all that took. Now armed with the credentials, what
would be the next steps at this point?
I suspect the next step is to END BACKUP. However, I
There are some things you should observe:
1 - Use the same version of FB server in the computer you move the 'fdb'
to that you use in the 'source' computer;
2 - Before copying the 'fdb' stop the FB server service;
Another thing I would tell you is that you should use 'gbak' to backup
your sou
On 2014-01-15, at 8:23 PM, Paul Vinkenoog wrote:
>
> I think you should contact Fishbowl Inventory support to clear this up.
Indeed; they currently have a multi-hour phone wait time.
> Most keep it at "masterkey" though. In your case, I assume that the
> Fishbowl software has generated a secure
Hello Maury,
>> Why don't you contact the administrator of the system in question? After
>> all, *someone* should know the SYSDBA password, shouldn't they?
>
> I don't believe so. The installer process that created the DB, which comes
> from Fishbowl, not Firebird, never asked for a SYSDBA passwo
On 2014-01-15, at 5:40 PM,
wrote:
>
> This is too strong statement. To verify it we need to know physical backup
> state of the database. gstat -h will show it (and it not requires admin
> privileges).
I am able to run this on the original server, are there some additional
switches you wou
On 2014-01-15, at 4:29 PM, Paul Vinkenoog wrote:
>
> Why don't you contact the administrator of the system in question? After
> all, *someone* should know the SYSDBA password, shouldn't they?
I don't believe so. The installer process that created the DB, which comes from
Fishbowl, not Firebird,
Maury Markowitz wrote:
> But wait... what about...
>
> ALTER DATABASE END BACKUP
>
> If I am reading it correctly, this appears to do the same thing as nbackup
> -N. Is that correct?
That is correct, but in order to issue that command you must connect to
the database as SYSDBA or owner.
From
On 2014-01-15, at 2:43 PM, Alexandre Benson Smith wrote:
>
> Take a look on nbackup (http://www.firebirdsql.org/manual/nbackup.html)
> manual so you could try to merge it back manually.
But wait... what about...
ALTER DATABASE END BACKUP
If I am reading it correctly, this appears to do the sam
On 2014-01-15, at 2:43 PM, Alexandre Benson Smith wrote:
>
> Take a look on nbackup (http://www.firebirdsql.org/manual/nbackup.html)
> manual so you could try to merge it back manually.
Indeed, but that brings me back to the actual problem... I do not know the
password for SYSDBA, and the only
Em 15/1/2014 17:30, Maury Markowitz escreveu:
> On 2014-01-15, at 2:02 PM, Hugo Eyng wrote:
>> I am not sure if i understood your question.
>>
>> You want to move the "fdb" file to another computer?
> That is correct.
>
> For reasons that I do not understand, the simple method of simply copying the
On 2014-01-15, at 2:02 PM, Hugo Eyng wrote:
>
> I am not sure if i understood your question.
>
> You want to move the "fdb" file to another computer?
That is correct.
For reasons that I do not understand, the simple method of simply copying the
FDB from one machine to another does not work. Wh
Hi.
I am not sure if i understood your question.
You want to move the "fdb" file to another computer?
Hugo Eyng
Em 15/01/2014 12:52, Maury Markowitz escreveu:
I am a admin of the Fishbowl Inventory (FBI) system for our company,
which is a Java app on top of Firebird.
I need to move the sy
Hi
Yes, I have access to the folder. Thank you for your attention.
The problem was the quotes
resolved
"C:\nbackup.exe" -U sysdba -P masterkey-B 0 "C:\nomedobanco.FDB"
"C:\nomedobackup.TMPNBK"
[]´s
2013/12/20 Dmitry Kuzmenko
>
>
> Hello, alessandroyamasaki!
>
> Friday, December 20, 2013,
Hello, alessandroyamasaki!
Friday, December 20, 2013, 8:16:17 PM, you wrote:
agc> I'm trying to run nBackup Firebird through command line below
agc> C: \ nbackup.exe-U sysdba-P masterkey-B 0 C: \ nomedobanco.FDB C: \
nomedobackup.TMPNBK
exactly nbackup-U ? and other spaces/nospaces ?
do you
Hello, atunccekic!
Friday, December 20, 2013, 12:35:54 PM, you wrote:
adct> It's no big deal but,
adct> Maybe it can be written in the help like :
adct> Use or not direct I/O when scanning database (Default: Off)
I think there is a mistake, because nbackup is a part of Firebird
server, so
Dmitry,
> Tuesday, October 8, 2013, 2:37:57 PM, you wrote:
>
> KR> Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0
> KR> perform compared to a high-performance copy utility like FastCopy?
>
> as I see on my desktop nbackup -b 0 is 2-3 times slower than lock/file
> copy/unlock. I
On Tue, 8 Oct 2013 12:37:57 +0200
Kjell Rilbe wrote:
> Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0
> perform compared to a high-performance copy utility like FastCopy?
>
> I'm asking because my DB is 80+ Gbyte and both the database and the
> backup are currently on the same
Dmitry Kuzmenko skriver:
>
> Hello, Kjell!
>
> Tuesday, October 8, 2013, 2:37:57 PM, you wrote:
>
> KR> Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0
> perform
> KR> compared to a high-performance copy utility like FastCopy?
>
> as I see on my desktop nbackup -b 0 is 2-3 times sl
Hello, Kjell!
Tuesday, October 8, 2013, 2:37:57 PM, you wrote:
KR> Working with FB 2.5 on Windows 64 bit, how does Nbackup level 0 perform
KR> compared to a high-performance copy utility like FastCopy?
as I see on my desktop nbackup -b 0 is 2-3 times slower than
lock/file copy/unlock. I think th
Matthias,
> We have Firebird 2.5.2.26540, using SuperClassic, 70 users, our
> database file has 2GB, we schedule nbackup every 20 minutes to make a
> incremental backup, after implantation we had a problem, on average once a
> day and happens deadlock and the firebird service stops and we have to
> I just made some nbackup tests (FB 2.5.2 SS, Windows XP) and noticed that
whenever I use it to restore a database, it's Oldest transaction (OIT) gets
stuck. It remains at the same value until next database sweep. Is it a bug
or a feature ?
I think the problem is here:
What nbackup do is
On Tue, Apr 16, 2013 at 4:48 AM, remk_1 wrote:
>
> I just made some nbackup tests (FB 2.5.2 SS, Windows XP) and noticed that
> whenever I use it to restore a database, it's Oldest transaction (OIT) gets
> stuck. It remains at the same value until next database sweep. Is it a bug
> or a feature ?
Hi,
I've just had 2 level 2 backups, 5 mins apart, the first was ok, the second
wasn't, outputting
Fatal lock manager error: invalid lock id (43240), errno: 22
--Invalid argument
subsequent calls to nbackup (all levels including 0) result in
unsuccessful metadata update
-Database is already in
Hello,
Unfortunately, I can't say more without thorough investigation.
It can be bug or corruption or misconfiguration.
Regards,
Alexey Kovyazin
> the level 0 backup restores ok and gbak will then backup& restore that,
> could the corruption be somewhere that that doesn't matter?
> how can I fi
the level 0 backup restores ok and gbak will then backup & restore that,
could the corruption be somewhere that that doesn't matter?
how can I find and deal with it?
On 1 November 2011 09:47, Nick Upson wrote:
> sorry, didn't think to say, its version 2.1.4
>
>
> On 31 October 2011 17:21, Alexey
sorry, didn't think to say, its version 2.1.4
On 31 October 2011 17:21, Alexey Kovyazin wrote:
> **
>
>
> Hello Nick,
>
> It seems like you have database corruption.
> What is Firebird version?
>
> Regards,
> Alexey Kovyazin
> IBSurgeon (www.ib-aid.com)
>
>
> > Hi,
> >
> > I have recently starte
Hello Nick,
It seems like you have database corruption.
What is Firebird version?
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
> Hi,
>
> I have recently started using nbackup and have a system where, at the
> end of an attempt to do a level 0 I got
>
> Fatal lock manager error: invalid l
65 matches
Mail list logo