ODP: ODP: ODP: [firebird-support] Stored procedure stopsfunctioningcorrectlyafter restore under Firebird 3

2019-02-15 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
> Then maybe some switch to restore process should be added?
>>You can always post a feature request in the tracker.

I will do, thanks

> Now this is nightmare for the end user.
>>I'd hardly call it a nightmare, and the alternative to use sources is 
>>not much better: it just has different caveats.

Using sources can only be treated as can compile under new version or not.
But as you pointed that someone (developer) can hide sources than i suppose 
that adding restore switch 
or mayby implement some crypto possibility for sources will be much better. 
Someone can crypt sources and then during restore with switch recompile
he must provide some crypto key.

Regards,
Karol Bieniaszewski


Re: ODP: [firebird-support] Firebird3 files - Updated

2019-02-15 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 15-2-2019 17:59, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
>  >>set FIREBIRD_LOCK env variable at *_system_* level and reboot.
> 
>  >>Be careful as wrong usage could damage database.
> 
> Thank you Vlad. Can you explain more about risk?

As I understand it, the problem can surface if you use 
Classic/SuperClassic and also an application using Firebird Embedded run 
in a session with a different value for FIREBIRD_LOCK. In a situation 
where both the server and the application access the same database, they 
will not share the same lock files. This can lead to data corruption 
because - for example - both can obtain a lock to modify the same page 
given they use different lockfiles.

Mark
-- 
Mark Rotteveel


ODP: [firebird-support] Firebird3 files - Updated

2019-02-15 Thread Karol Bieniaszewski liviusliv...@poczta.onet.pl [firebird-support]
>>set FIREBIRD_LOCK env variable at system level and reboot.
>>Be careful as wrong usage could damage database.

Thank you Vlad. Can you explain more about risk?

Regards,
Karol Bieniaszewski


Re: ODP: ODP: [firebird-support] Stored procedure stops functioningcorrectlyafter restore under Firebird 3

2019-02-15 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-2-2019 19:49, Karol Bieniaszewski liviusliv...@poczta.onet.pl 
[firebird-support] wrote:
> Then maybe some switch to restore process should be added?

You can always post a feature request in the tracker.

> Now this is nightmare for the end user.

I'd hardly call it a nightmare, and the alternative to use sources is 
not much better: it just has different caveats.

Mark
-- 
Mark Rotteveel