[Firebird-devel] [FB-Tracker] Created: (CORE-5671) Fb 3 gstat not properly reporting old ODS error

2017-11-27 Thread Helen Borrie (JIRA)
Fb 3 gstat not properly reporting old ODS error --- Key: CORE-5671 URL: http://tracker.firebirdsql.org/browse/CORE-5671 Project: Firebird Core Issue Type: Bug Components: GSTAT Affect

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> I've reproduced an issue. Somewhere between catching error in looper and > rethrowing it again when leaving looper tdbb_status_vector is cleaned Great to know, you found it. > up. BTW, for me it's reproduced each time I logoff/logon from/to isql. Yes. For me as well. -- Mgr. Jiří Činčura

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? I've reproduced an issue. Somewhere between catching error in looper and rethrowing it again when leaving looper tdbb_status_vector is cleaned up. BTW, for me it's reproduced each time I logoff/logon

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
>gfix -v -f ? $ .\gfix.exe -v -fu -user sysdba -password masterkey C:\Users\Jiri\Downloads\aaa\aaa\aaa.FDB $ Nothing. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community o

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Vlad Khorsun via Firebird-devel
27.11.2017 16:50, Jiří Činčura wrote: But mostly wierd is that even in theory crypt plugin can not affect integrity constraints - encryption works a few logical levels deeper than constraints violation, that's absolutely different parts of code. Yeah. I though the database was somewhat corrupt

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 18:08, Jiří Činčura wrote: What is the size of compressed database backup? 52 264 210 bytes, why? Will not fit into email (32M limit on mail.ru), please put it to some reasonable share. -- Check out t

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> AES128 plugin also works fine for me: Yeah, as I said. On a new database it works fine. It's something with this database that triggers some undefined behavior. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ --

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Any ideas what could be wrong and where to look at? AES128 plugin also works fine for me: localhost bin # localhost bin # ./isql e1.fdb Database: e1.fdb, User: SYSDBA SQL> alter database encrypt with AES128; SQL> insert into country values('Russia', 'Ru

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> What is the size of compressed database backup? 52 264 210 bytes, why? -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slash

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:55, Jiří Činčura wrote: To be precise - it's IBSurgeon plugin. Hmm. Of course, could be. Wondering why it fails only on this database? Even more. Test table on this database works fine. What is the size of compressed database backup? --

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> To be precise - it's IBSurgeon plugin. Hmm. Of course, could be. Wondering why it fails only on this database? Even more. Test table on this database works fine. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ --

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:43, Alex Peshkoff via Firebird-devel wrote: Wierd - I could not reproduce it with . plugin. To be precise - it's IBSurgeon plugin. -- Check out the vibrant tech community on one of the wo

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
> Wierd - I could not reproduce it with . plugin. I agree. It's weird. > SQL> alter database encrypt with "DbCrypt" key Red; Can I download somewhere binary version of this plugin? > But mostly wierd is that even in theory crypt plugin can not affect > integrity constraints - encry

Re: [Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Alex Peshkoff via Firebird-devel
On 11/27/17 17:17, Jiří Činčura wrote: Hi, I have a weird behavior here. Database after b&r, no errors. I try to insert non-unique value into table with unique constraint and it fails as it should. I encrypt it (AES128 from IBPhoenix) and the same statement does not fail. Only the next one will

[Firebird-devel] Unique constraint not working on first command after encryption

2017-11-27 Thread Jiří Činčura
Hi, I have a weird behavior here. Database after b&r, no errors. I try to insert non-unique value into table with unique constraint and it fails as it should. I encrypt it (AES128 from IBPhoenix) and the same statement does not fail. Only the next one will throw unique violation. Here's a snap fr