Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 14:24, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 11-1-2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: >> I checked the system again - we use 3.0.2 indeed. >> >> There is no particular reason why we use -mend. We use it routinely >> between

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > I checked the system again - we use 3.0.2 indeed. > > There is no particular reason why we use -mend. We use it routinely > between backup/restore operations to prevent the situation that any > corruption errors my

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 13:21, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > My understanding is that mend can not and it should not cause any troubles. Your understanding is wrong. This switch is intended to save at least some data from a dead database with gbak. After you used it, database is

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

I checked the system again - we use 3.0.2 indeed. There is no particular reason why we use -mend. We use it routinely between backup/restore operations to prevent the situation that any corruption errors my intervene in our operations. My understanding is that mend can not and it should not

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

On 11-1-2018 09:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > We have observed, that Firebird 3.0.1 freezes on one specific table for > some 10-20 minutes during backup. This freezing happens only in the case > when gfix/mend had been performed before backup. Backup runs smoothly >

Re: [firebird-support] Re: Firebird role.

Thank you so much ! Atenciosamente. Alexandre Vinhaes Administrador de Banco de Dados - Tecnologia +55 21 2196-5206 <+55%2021%202196-5206> 2018-01-11 6:59 GMT-02:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > > > On 10-1-2018 22:21, Alexandre

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 11:29, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > No, we don't use -g. You should. > We are doing immedate restore anyway after each backup. It is very doubtful practice. Immediate restore into different place is good for many reasons, but need in replacing

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

No, we don't use -g. We are doing immedate restore anyway after each backup. The freeze during backup time greatly increases time when the system is down and unavailable and it is becoming unacceptable. I have experience that such freeze happened once to the database that soon got corrupted.

Re: [firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

11.01.2018 9:14, jonatan.laurit...@yahoo.dk [firebird-support] wrote: > Are there any ideas what happens and how to prevent it? Do you run gbak with -g switch? -- WBR, SD.

Re: [firebird-support] Re: Firebird role.

On 10-1-2018 22:21, Alexandre Vinhaes - Tecnico - Tecnologia alexandre.vinh...@cipa.com.br [firebird-support] wrote: > I have created a role and granted it to an user. For my surprise, > related user doesnt have privileges from that role. I dont want to set > the role previously. What should I

[firebird-support] Re: Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

Operating system is Windows

[firebird-support] Firebird 3.0.1 freezes on one table for some 10-20 minutes during backup after gfix/mend

Hi! We have observed, that Firebird 3.0.1 freezes on one specific table for some 10-20 minutes during backup. This freezing happens only in the case when gfix/mend had been performed before backup. Backup runs smoothly when no gfix/mend had been performed previously. There are no significat