Re: [Firebird-devel] Start transaction from base transaction

2017-04-19 Thread Vlad Khorsun
19.04.2017 14:56, Dimitry Sibiryakov wrote: > 19.04.2017 13:29, Vlad Khorsun wrote: >> I can't evaluate something not defined. Specify "array DML + >> asynchronous queries" and, >> probably, we will have the subject to speak about. > > Array DML is a

Re: [Firebird-devel] Start transaction from base transaction

2017-04-19 Thread Vlad Khorsun
19.04.2017 14:03, Dimitry Sibiryakov wrote: > 19.04.2017 12:57, Vlad Khorsun wrote: >> Sean speak about *read* consistency within few transactions\connections >> to the same >> database. No more, no less. > > Ok. What advantages can have derived

Re: [Firebird-devel] Start transaction from base transaction

2017-04-19 Thread Vlad Khorsun
19.04.2017 11:51, Dimitry Sibiryakov пишет: > 18.04.2017 18:43, Vlad Khorsun wrote: >> Some time ago there was discussion about sharing snapshots. As for me, it >> is useful feature. Not a "must have", but useful. > > As in Sean's scenario: you pumped data

Re: [Firebird-devel] GPRE and VARBINARY

2017-03-05 Thread Vlad Khorsun
05.03.2017 13:35, Dimitry Sibiryakov wrote: >Hello, All. > >What BLR and data type must generate GPRE for retrieving/storage of > VARBINARY fields? >For VARCHAR CHARACTER SET OCTETS it used to generate blr_cstring and plain > char[], > which is, IMHO, incorrect because binary strings

Re: [Firebird-devel] Legacy usermanager broken in Firebird 4?

2017-03-05 Thread Vlad Khorsun
05.03.2017 10:56, Mark Rotteveel wrote: > On 4-3-2017 22:52, Vlad Khorsun wrote: >> 04.03.2017 18:36, Mark Rotteveel wrote: >>> I have some problems with using legacy authentication with Firebird 4: >>> >>> * Using the default existing legacy sysdba/mast

Re: [Firebird-devel] Legacy usermanager broken in Firebird 4?

2017-03-05 Thread Vlad Khorsun
05.03.2017 15:37, Mark Rotteveel wrote: > Also curious: initializing the security database for Srp adds two Srp > SYSDBA accounts (but it might always have done that). I think you mixed two SYSDBA accounts created by different plugins. See below (security4.fdb just

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5493) Add context variable about transaction start timestamp

2017-03-03 Thread Vlad Khorsun
03.03.2017 13:15, Alex Peshkoff wrote: > On 03/01/17 20:51, Vlad Khorsun wrote: >> 01.03.2017 19:22, Dmitry Yemanov wrote: >>>> 01.03.2017 19:50, Vlad Khorsun wrote: >> .. >>>> Also, I prefer to avoid to return as a string something that is not a >>>

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5493) Add context variable about transaction start timestamp

2017-03-03 Thread Vlad Khorsun
03.03.2017 13:53, Alex Peshkoff wrote: > May be I was not enough precise - that's not big problem for major > release (FB4), but not good for 3.0.2. While i not agree re. "problem" for 3.0.2, i'm not going to insist. Regards, Vlad

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5493) Add context variable about transaction start timestamp

2017-03-01 Thread Vlad Khorsun
01.03.2017 19:22, Dmitry Yemanov wrote: >> 01.03.2017 19:50, Vlad Khorsun wrote: .. >> Also, I prefer to avoid to return as a string something that is not a string. > > Agreed here. From another side, I don't like polluting the global > namespace with non-standard but reserv

Re: [Firebird-devel] windows test build - least painful way?

2017-03-01 Thread Vlad Khorsun
01.03.2017 11:20, Dmitry Yemanov wrote: > 28.02.2017 17:18, Michal Kubecek wrote: >> >> as my Hackweek project, I played with struct rem_port and tried to turn >> it into class hierarchy with virtual functions. The plan is to use this >> to implement listening on multiple sockets (CORE-5219) and

[Firebird-devel] [SPAM] Re: object DATABASE is in use

2017-04-05 Thread Vlad Khorsun
05.04.2017 22:24, Jiří Činčura wrote: > Hi *, > > what the "object DATABASE is in use" signals? I understand when there's > table or trigger being used. But database? AFAIR, it is a sign that attachment's request for exclusive access to the database can't be granted. EX access to the whole

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 20:00, Jiří Činčura wrote: >> Could you try ISC_USER\ISC_PASSWORD ? Explicit -user\-password not >> works >> as it is not passed into internal attachment to the security database. > > In that case it works. But I suppose the ISC_PASSWORD is the password > for a user on server,

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 20:32, Jiří Činčura wrote: >> And it will be fixed soon > > Can't wait for it. Is there a tracker item I can follow? > You may create one ;) Regards, Vlad -- Check out the vibrant tech community on

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-13 Thread Vlad Khorsun
09.05.2017 21:34, Jiří Činčura wrote: > Hi, > > I have a weird behavior on FB 3.0.2 32b, confirmed on 3 machines > (Win2012 R2, Win 10 CU, Win 10 AU). When I execute `isql -x > database.fdb` the first run is fast. When I execute it then again the > run is slow, like 5-10x slower. Then again fast

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 11:27, Dimitry Sibiryakov wrote: > 16.05.2017 7:03, Jiří Činčura wrote: >>> The question i have no good answer for : should code which fills >>> SEC$XXX >>> tables use any providers other than embedded (Engine12) ? >> I don't think I can help you here. But if that solves the

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 11:44, Dimitry Sibiryakov wrote: > 16.05.2017 10:41, Vlad Khorsun wrote: >> PS What do you want to argue this time ? > > Single user database is simpler to maintain. That's my whole point. How it is related with subject ? Vlad PS No database even more siml

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 8:03, Jiří Činčura wrote: > Interesting. So the workaround would be to not have running server while > the embedded stuff is running? Not sure I can do that, but I'll think > about. Right now it's killing the performance of the embedded in my > case. It got from 6 minutes to 34 minutes

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 11:58, Dimitry Sibiryakov wrote: > 16.05.2017 10:52, Vlad Khorsun wrote: >> How it is related with subject ? > > Subject is caused by bad design of authentication module, right? I see a problem with implementation, not with design, so far. Do you have

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 12:07, Jiří Činčura пишет: >> Try to supply correct user credentials (explicitly or set >> ISC_USER\ISC_PASSWORD) > > Doesn't work. Doing ".\isql.exe -user SYSDBA -password masterkey -x > COMPARE_TARGET.FDB" surfaces the same behavior. Could you try ISC_USER\ISC_PASSWORD ?

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 11:49, Alex Peshkoff wrote: > On 05/13/17 23:25, Vlad Khorsun wrote: > >> The question i have no good answer for : should code which fills SEC$XXX >> tables use any providers other than embedded (Engine12) ? > > IMHO that to be changed. In FB4 I plan t

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-26 Thread Vlad Khorsun
26.05.2017 2:17, Leyne, Sean пишет: - Asynchronous File I/O It is not really asynchronous as it waits for the completion of every single IO request. True, but it allows the storage controller to decide the best order in which to perform the operations... Order of what ? IO

Re: [Firebird-devel] Every other execution of embedded isql slow

2017-05-16 Thread Vlad Khorsun
16.05.2017 21:34, Jiří Činčura wrote: >> You may create one ;) > > Done. > http://tracker.firebirdsql.org/browse/CORE-5540 Thanks. Check next snapshot build, please. Regards, Vlad -- Check out the vibrant tech

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-30 Thread Vlad Khorsun
30.05.2017 19:32, Leyne, Sean wrote: Async/Overlapped IO allows for IO on any number of file blocks (aka pages) without limit to their locations, consecutive or not. You words "single operation for any storage device" make me think that you are referring to a single OS call. There is no

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-30 Thread Vlad Khorsun
29.05.2017 23:45, Leyne, Sean wrote: Vlad, - Asynchronous File I/O It is not really asynchronous as it waits for the completion of every single IO request. True, but it allows the storage controller to decide the best order in which to perform the operations... Order of what ?

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 18:59, Adriano dos Santos Fernandes write: > Vlad and others, > > Can you look at this? > > https://github.com/asfernandes/firebird/tree/work/sharing-snapshot I took a quick look, so don't get me too serious. Also, my opinion could be incomplete and be changed later :) > It uses

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 20:36, Adriano dos Santos Fernandes wrote: > On 05/05/2017 14:01, Vlad Khorsun : ... >> I don't understand for what purpose tra_oldest_snapshot was added. > In my understand, it's a property that new transaction should copy from > the base transaction. Isn't

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
05.05.2017 21:10, Adriano dos Santos Fernandes wrote: > On 05/05/2017 14:43, Dmitry Yemanov wrote: >> 05.05.2017 20:01, Vlad Khorsun wrote: >>> %type snap_shot >>> snap_shot >>> : SNAPSHOT >>> | SNAPSHOT TABLE >>> | SN

Re: [Firebird-devel] Start transaction from base transaction

2017-05-05 Thread Vlad Khorsun
06.05.2017 0:17, Adriano dos Santos Fernandes wrote: > Em 05/05/2017 18:01, Vlad Khorsun escreveu: > >> >> Also, i offer to add additional rule for transaction which should export >> its snapshot data (it allows to avoid export by all transactions), somethin

Re: [Firebird-devel] Start transaction from base transaction

2017-05-06 Thread Vlad Khorsun
06.05.2017 11:47, livius wrote: > Hi, > > for me name is confusing - beacause here can be two cases: > 1. Snapshot transaction is shared Looks like wrong\incomplete definition, as > 2. only view of database from its start point is shared and any modification > caused by base snapshot and any

[Firebird-devel] [SPAM] Re: Start transaction from base transaction

2017-05-06 Thread Vlad Khorsun
06.05.2017 15:15, livius wrote: > >> Yes, but we should avoid to write whole novels at SQL statements ;) > > Agree - but to fast chice is also not good Could you offer better syntax ? >> It have no sence (if i understand you :) ) > Maybe, but it should be prohibited in code or designed to

Re: [Firebird-devel] SUPERSERVER_V2

2017-05-25 Thread Vlad Khorsun
25.05.2017 22:18, Leyne, Sean wrote: What's SUPERSERVER_V2 in the code? My review of the code (back in 2003, see attached) found the following: - Asynchronous File I/O It is not really asynchronous as it waits for the completion of every single IO request. Also, note, it completely

Re: [Firebird-devel] Time zones

2018-05-01 Thread Vlad Khorsun
30.04.2018 5:50, Adriano dos Santos Fernandes wrote: Hi! Time zones branch is almost feature complete. There is two important subjects left: - ICU in Windows - as I already said, it need to be upgraded and I would like it builded as the upstream does, i.e., with full data. It would be good if

[Firebird-devel] RFC: Statement-level read consistency and GC of intermediate versions

2018-07-03 Thread Vlad Khorsun
All, Few years ago Nikolay Samofatov presented his patch with implementation of commit order based snapshots, statement level read consistency, GC of intermediate versions and so on. The main characteristics of the feature was discussed here at June-October of 2014. After that

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
On 05/08/2018 22:44, Adriano dos Santos Fernandes wrote: Hi! In "read consistency" README's patch, it says about statement level consistency. JRD_start/JRD_start_and_send was been changed (retry logic). Can this retry be leaked from "SQL statements" (SELECT / UPDATE / DELETE) to PL/SQL or

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 9:54, Dmitry Yemanov пишет: 27.08.2018 09:30, Vlad Khorsun wrote: On 05/08/2018 22:44, Adriano dos Santos Fernandes wrote: Hi! In "read consistency" README's patch, it says about statement level consistency. JRD_start/JRD_start_and_send was been changed (retry lo

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 20:10, Adriano dos Santos Fernandes wrote: All, Please. If nobody else sees the magnitude of this problem, I'll shut up. What we talk here is something that is being said to fix read committed, but completely destroys it. Wrong statement which mixed *read consistency* and *side

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 13:55, Adriano dos Santos Fernandes wrote: On 27/08/2018 03:30, Vlad Khorsun wrote:   If it is not what you asked for - please, explain the question. What if a PSQL request calls an UDF/UDR, then executes a SELECT/UPDATE that triggers a retry, will the UDF/UDR

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 18:49, Adriano dos Santos Fernandes wrote: On 27/08/2018 12:16, Vlad Khorsun wrote:   Whole execution tree, starting from top-level request, will be executed again within new snapshot. So, yes, that UDF\UDR will be also executed again, unless control flow changed its path because

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 19:05, Adriano dos Santos Fernandes wrote: On 27/08/2018 12:59, Vlad Khorsun wrote:   How it is related with consistency ? Also, we already have such behaviour even within single statement. Show me it, please. select any_function() ... from ... order by 1 For example

Re: [Firebird-devel] Changes in JRD_start/JRD_start_and_send in "read consistency" patch

2018-08-27 Thread Vlad Khorsun
27.08.2018 19:21, Adriano dos Santos Fernandes пишет: On 27/08/2018 12:59, Vlad Khorsun wrote: Statement consistency should be about individual SQL (SELECT / UPDATE / INSERT / MERGE / UPDATE OR INSERT) statements, not requests.   This is not consistency. This is spaghetty. We should

Re: [Firebird-devel] CORE-5877 Garbage in the compound index after several updates

2018-07-20 Thread Vlad Khorsun
20.07.2018 14:45, liviuslivius wrote: Hi, i ask here to not spam into the tracker. I know that indexes in Firebird are not transactional objects. My understanding was that when we update record then old record vesion go to new place and new record version replace place where old record version

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

2018-07-23 Thread Vlad Khorsun
23.07.2018 21:10, Dimitry Sibiryakov wrote: 23.07.2018 19:42, Vlad Khorsun wrote: Note, upper allowed value for INET_remote_buffer is MAX_DATA_HW (32768).   That's bad. > const SSHORT l = (SSHORT) MIN(length, INET_remote_buffer)   If length >= INET_remote_buffer It can't

Re: [Firebird-devel] Automatic Windows builds with AppVeyor

2018-07-23 Thread Vlad Khorsun
23.07.2018 22:21, Adriano dos Santos Fernandes wrote: On 23/07/2018 16:15, Vlad Khorsun wrote: 23.07.2018 21:51, Dimitry Sibiryakov wrote: 23.07.2018 20:46, Adriano dos Santos Fernandes wrote: Is these errors happening on your local Windows machines too?    Yes, unless line "*.bat 

Re: [Firebird-devel] Automatic Windows builds with AppVeyor

2018-07-23 Thread Vlad Khorsun
23.07.2018 21:51, Dimitry Sibiryakov wrote: 23.07.2018 20:46, Adriano dos Santos Fernandes wrote: Is these errors happening on your local Windows machines too?   Yes, unless line "*.bat   eol=crlf" is added to file ".gitattributes" before checkout. While issue could be in EOL's, must

Re: [Firebird-devel] Jaybird hang on Firebird 4 with modified TcpRemoteBufferSize

2018-07-23 Thread Vlad Khorsun
23.07.2018 19:45, Adriano dos Santos Fernandes wrote: On 23/07/2018 13:18, Mark Rotteveel wrote: On 23-7-2018 17:25, Adriano dos Santos Fernandes wrote: On 23/07/2018 11:12, Mark Rotteveel wrote: The problem can't be reproduced with the native client, which suggests Jaybird does something

Re: [Firebird-devel] CORE-5877 Garbage in the compound index after several updates

2018-07-23 Thread Vlad Khorsun
20.07.2018 21:27, livius wrote:   Not exactly so. When index key is not changed by UPDATE statement, engine doesn't   add it into the index. Ok, so it has not changed. Yes tx1: insert record (r1) with index key (k1) table contains one record version: r1-tx1 index contains one entry:

Re: [Firebird-devel] Read consistency patch

2018-07-24 Thread Vlad Khorsun
24.07.2018 11:13, liviuslivius wrote: Hi, question about this patch https://github.com/FirebirdSQL/firebird/pull/105 Is this possible that this CN(commit number) of transactions (pair transaction id + CN) can be stored into some table? Currently - no. Probably we could find a way for it.

Re: [Firebird-devel] Tests and debug build crashes

2018-07-11 Thread Vlad Khorsun
08.07.2018 0:28, Adriano dos Santos Fernandes wrote: Hi! I'm trying to run the official tests with the debug build and memory corruptions was happening. Previously I already fixed a assert problem found in this way. It seems important to (also) run the tests with the debug build. With master,

Re: [Firebird-devel] Some OLTP numbers

2018-10-22 Thread Vlad Khorsun
22.10.2018 16:37, Gabor Boros wrote: Hi All, After executed an OLTP test with multiple Firebird SS versions got the attached numbers. The test executed three times per Firebird version. Same OLTP configuration, same server (Debian 9.5 64bit) and same client (Windows 10 64bit). The result

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere? Could you provide html reports generated by the test runs ? Regards, Vlad Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 18:37, Gabor Boros пишет: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    Could you provide html reports generated by the test runs

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 18:35, Gabor Boros wrote: 2018. 10. 25. 16:06 keltezéssel, Dimitry Sibiryakov írta: 25.10.2018 15:05, Gabor Boros wrote: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    It is kinda expected.

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
25.10.2018 19:05, Gabor Boros wrote: 2018. 10. 25. 17:45 keltezéssel, Vlad Khorsun írta: 25.10.2018 18:37, Gabor Boros wrote: 2018. 10. 25. 16:16 keltezéssel, Vlad Khorsun írta: I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made

Re: [Firebird-devel] Some OLTP numbers

2018-10-25 Thread Vlad Khorsun
I have the 2 hours numbers and attached the refreshed picture. 2.5 is still the fastest. Is it the truth or I made a mistake somewhere?    It is kinda expected. How many worker isqls you had? Five.    Five ?! It is not serious, try 50 at least I do not want to blow up my test machine.

Re: [Firebird-devel] Some OLTP numbers

2018-11-02 Thread Vlad Khorsun
02.11.2018 9:23, Karol Bieniaszewski wrote: Hi, Result for Firebird 2.5 SuperClassic is amazing. And i do not know why FB3 here is not so fast? FB2.5 is the fastest. It do 2x more job then FB4. Interesting is also db size after. In FB 2.5 SuperServer it is ~5GB In FB 2.5 SuperClassic which

Re: [Firebird-devel] Error java.sql.SQLException: internal Firebird consistency check (Incorrect snapshot deallocation - too few slots) [SQLState:XX000, ISC error code:335544333]

2018-09-29 Thread Vlad Khorsun
29.09.2018 19:14, Mark Rotteveel wrote: ... Do I need to create a ticket for this, or is this a known problem? Yes, create a ticket please. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Broken read committed consistency (was Changes in JRD_start/JRD_start_and_send in "read consistency" patch)

2018-09-03 Thread Vlad Khorsun
28.08.2018 13:39, Adriano dos Santos Fernandes wrote: On 28/08/2018 02:20, Dmitry Yemanov wrote: 27.08.2018 20:10, Adriano dos Santos Fernandes wrote: the whole thing may execute repeated times Imagine selectable SP/UDR joined to a table. Depending on the plan, SP/UDR may be executed once

Re: [Firebird-devel] FB4 vs CORE-5222

2018-09-03 Thread Vlad Khorsun
31.08.2018 22:23, Gabor Boros wrote: Hi All, Now (with 4.0.0.1190) works with one (ISQL) client but got "update conflicts with concurrent update" immediately with two or more clients. This is because i fixed handling of request snapshot in autonomous transactions. Thank to your message.

Re: [Firebird-devel] Automatic Windows builds with AppVeyor

2018-09-02 Thread Vlad Khorsun
23.07.2018 21:46, Adriano dos Santos Fernandes wrote: Hi! I integrated Firebird with AppVeyor CI, like we have with travis, but appveyor is for Windows. I think it makes sence to enable "Rolling builds" as described here: https://www.appveyor.com/docs/build-configuration/#rolling-builds

Re: [Firebird-devel] ODP: ODP: CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 22:37, Karol Bieniaszewski wrote: Hi Vlad, Maybe you should go first to the end of may email (quite long – sorry please be patient) Not so long ;) I suppose that i misunderstand names and meaining. This is the commit number of currently used snapshot, if present. Non-RC

Re: [Firebird-devel] CORE-5921

2018-09-25 Thread Vlad Khorsun
24.09.2018 10:19, liviuslivius wrote: Hi, can you point me about usage cases about http://tracker.firebirdsql.org/browse/CORE-5921? The main goal is to provide ability to investigate new engine characteristics and behaviour for end users, testers, etc (i.e. not only for the core

Re: [Firebird-devel] CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 17:25, liviuslivius wrote: Ok, i supposed that this go further. I need global CN from transaction start POV. For snapshot\concurrency transaction you could obtain it using SNAPSHOT_CN context variable. For read-comitted transaction it doesn't exists. I do not know if i can

Re: [Firebird-devel] ODP: CORE-5921

2018-09-25 Thread Vlad Khorsun
25.09.2018 19:02, Karol Bieniaszewski wrote: What is then SNAPSHOT_CN? This is the commit number of currently used snapshot, if present. Non-RC transactions create snapshot at own start and SNAPSHOT_CN is the CN of that snapshot. RCRC transactions create snapshot when user query execution

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-22 Thread Vlad Khorsun
22.01.2019 16:09, Jiří Činčura wrote: Hi, do I need to call fb_shutdown on application exit when all connections are closed before the unloading happens by the OS? The README.fb_shutdown says I don't have to, but I remember some discussion here that it *should* preferably be called.

Re: [Firebird-devel] ODS hdr_creation_date

2018-11-23 Thread Vlad Khorsun
23.11.2018 22:12, Dimitry Sibiryakov wrote:   ...recently invented SCN Recently ? What do you speak about ? Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] ODS hdr_creation_date

2018-11-23 Thread Vlad Khorsun
24.11.2018 0:32, Dimitry Sibiryakov пишет: 23.11.2018 21:36, Vlad Khorsun wrote:    ...recently invented SCN    Recently ? What do you speak about ?   "When any transaction is committed, database Commit Number is incremented and its value is associated with this transaction".

Re: [Firebird-devel] Full ICU in Firebird 4?

2019-01-26 Thread Vlad Khorsun
26.01.2019 10:41, Mark Rotteveel wrote: With the recent changes to the ICU version, does Firebird 4 on Windows now have the full ICU? Yes. Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Fwd: XNET and IpcName

2019-03-26 Thread Vlad Khorsun
26.03.2019 8:51, Emil Totev wrote: The question remained unanswered in firebird-support, so I am trying it here. Basically I'm asking how can a client connect via XNET to a firebird server using non-default IpcName, for example "Firebird4". -- Forwarded message - Date: Mon, 18

Re: [Firebird-devel] Backup of message (msg) database of recent Firebird 4 build.

2019-03-23 Thread Vlad Khorsun
23.03.2019 15:43, Mark Rotteveel wrote: I want to refresh the error messages in Jaybird with the messages from a recent Firebird 4 build. Unfortunately, I am running into problems with building Firebird 4 locally as the build complains I haven't installed the C++ Windows XP support, while - as

Re: [Firebird-devel] Start transaction from base transaction

2019-02-23 Thread Vlad Khorsun
23.02.2019 21:14, Adriano dos Santos Fernandes wrote: Hi! After changes to use commit number instead of base transaction number, I offer to make that interfaces for the feature: I offer to not introduce additional confusing with different usages of commit numbers. Commit Number (CN)

Re: [Firebird-devel] Start transaction from base transaction

2019-02-24 Thread Vlad Khorsun
24.02.2019 12:37, Dimitry Sibiryakov wrote: 24.02.2019 3:23, Adriano dos Santos Fernandes wrote:     maybe:         SET TRANSACTION SNAPSHOT [USING SNAPSHOT ]     or         SET TRANSACTION SNAPSHOT [USING SNAPSHOT NUMBER ] What I dislike here is double SNAPSHOT words.   You can

Re: [Firebird-devel] Start transaction from base transaction

2019-02-24 Thread Vlad Khorsun
24.02.2019 4:23, Adriano dos Santos Fernandes wrote: On Sat, Feb 23, 2019, 21:30 Vlad Khorsun wrote: 23.02.2019 21:14, Adriano dos Santos Fernandes wrote: > Hi! > > After changes to use commit number instead of base transaction number, I > offer to make tha

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-03-04 Thread Vlad Khorsun
04.03.2019 14:01, Alex Peshkoff via Firebird-devel wrote: On 3/4/19 2:57 PM, Vlad Khorsun wrote:   I have additional question: is it true that fbclient now depends on ICU ? As fas as I know - not. At least IntlManager.cpp is placed in src/jrd, which is used only in engine. Client is using

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-03-04 Thread Vlad Khorsun
04.03.2019 11:16, Simonov Denis via Firebird-devel wrote: Faced the following problem when working with Firebird 4.0 via IBExpert. Trying to execute the following SQL query. SELECT current_time FROM $RDB$DATABASE SQLCODE: -902 GDSCODE: 335545167 Unsuccessful execution caused by a system

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-04 Thread Vlad Khorsun
02.03.2019 14:25, Mark Rotteveel wrote: On 28-12-2018 17:44, Mark Rotteveel wrote: It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through org.firebirdsql.management.FBManager) takes roughly 200ms, while

Re: [Firebird-devel] Start transaction from base transaction

2019-03-01 Thread Vlad Khorsun
01.03.2019 15:40, Adriano dos Santos Fernandes wrote: On 01/03/2019 10:28, Vlad Khorsun wrote: ...   BTW, what branch go you mean ? https://github.com/FirebirdSQL/firebird/pull/193 I'll change SNAPSHOT_CN name in different commit as it's already present in master. Understand now BTW

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-11 Thread Vlad Khorsun
08.03.2019 17:22, Mark Rotteveel wrote: On 7-3-2019 10:52, Vlad Khorsun wrote: ... PS i see how to make database creation faster (by reusing compiled statements whenever possible), but it will not solve general problem with compiation time. Is this something that could be improved

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-11 Thread Vlad Khorsun
07.03.2019 13:45, Adriano dos Santos Fernandes wrote: On 07/03/2019 06:52, Vlad Khorsun wrote:   Database creation time mostly contains from compiling and parsing requests. Unfortunately, it is slower in fb4 than fb3 and fb3 is much slower than fb25. IIRC, it was said here sometime ago

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-13 Thread Vlad Khorsun
13.03.2019 2:37, Adriano dos Santos Fernandes wrote: On 12/03/2019 17:22, Vlad Khorsun wrote: Let me demonstrate it. With this (wrong) patch now the code compiles: -- diff --git a/src/dsql/ExprNodes.cpp b/src/dsql/ExprNodes.cpp index 4ff5253a2b..26f826ae09 100644 --- a/src/dsql

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-07 Thread Vlad Khorsun
05.03.2019 0:59, Vlad Khorsun wrote: 02.03.2019 14:25, Mark Rotteveel wrote: On 28-12-2018 17:44, Mark Rotteveel wrote: It looks like database creation in Firebird 4 is slower (about 50%) compared to 3.0.4. On my system, creating a database in Firebird 3.0.4 (through

Re: [Firebird-devel] Core-5658 tested

2019-03-19 Thread Vlad Khorsun
09.03.2019 12:01, Omacht András wrote: Hi All! I’m unable  to add comment tot he tracker, Hmm... it is strange, you should be able to comment at tracker... so I send it: http://tracker.firebirdsql.org/browse/CORE-5658 Hi Vlad! We tested it and works well. Thanks for testing. Is

Re: [Firebird-devel] Building Firebird 2.5 on Windows

2019-03-19 Thread Vlad Khorsun
19.03.2019 15:48, Paul Reeves wrote: On Tue, 19 Mar 2019 15:33:23 +0200 Vlad Khorsun wrote: The best (and only guarantee) is to use "official" compiler. For fb25 on Windows it is VC8 (VS2005). Actually, it is MSVC10 :-) VC10 is used for fb3 MSVC8 was for 2.1, i

Re: [Firebird-devel] Building Firebird 2.5 on Windows

2019-03-19 Thread Vlad Khorsun
19.03.2019 12:26, Bastian Seeleib - Ölmühle Solling wrote: Hello, I’m trying to build Firebird 2.5 with msvc14 (Visual Studio 2015, Version 14.0.25420.1) but I’m running into issues. I don’t know if this is the correct Mailing-List to ask this question, hopefully you can help me (-: I have

Re: [Firebird-devel] Database creation slower in Firebird 4

2019-03-12 Thread Vlad Khorsun
12.03.2019 17:24, Adriano dos Santos Fernandes wrote: On 11/03/2019 09:35, Vlad Khorsun wrote:   I just committed few patches and have few more things to ask here: Vlad, the change just broke reason for NodeRef/NodeRefImpl existence (which is still commented but not working

Re: [Firebird-devel] ICU in HEAD

2019-02-07 Thread Vlad Khorsun
08.02.2019 9:31, Alex Peshkoff via Firebird-devel wrote: On 2/7/19 6:14 PM, Dimitry Sibiryakov wrote: Hello, All.   I somehow understand why build of current HEAD is failing with message "Could not find acceptable ICU library", but I wonder why it takes so much time to get this error? More

Re: [Firebird-devel] ICU in HEAD

2019-02-08 Thread Vlad Khorsun
08.02.2019 10:48, Alex Peshkoff via Firebird-devel wrote: On 2/8/19 10:56 AM, Vlad Khorsun wrote:   Is it time to re-think how UnicodeUtil::getConversionICU() search for ICU library ? Suggestions? The fastest way sooner of all will be storing favorite ICU verson (once detected using long

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-18 Thread Vlad Khorsun
18.02.2019 1:49, Adriano dos Santos Fernandes wrote: Open two connections C1 and C2. C2: select current_transaction from rdb$database; -- let's call the result T2 C2: commit; C1: select rdb$get_transaction_cn(T2) from rdb$database; In Super C1 returns the commit number. In Classic it returns

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-18 Thread Vlad Khorsun
18.02.2019 13:50, Dimitry Sibiryakov wrote: 18.02.2019 12:47, Adriano dos Santos Fernandes wrote: If the change is going to appear only in Beta 2, then ok and I file a ticket. Otherwise a ticket would not be necessary as the feature didn't appeared in any alpha/beta release yet.   This

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-18 Thread Vlad Khorsun
18.02.2019 13:47, Adriano dos Santos Fernandes wrote: On 18/02/2019 08:37, Vlad Khorsun wrote:   Seriously, if you (and others) consider it is important enough to try to refresh TIP cache in such cases - fill the ticket in tracker and i'll fix it. If the change is going to appear only

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-18 Thread Vlad Khorsun
18.02.2019 13:19, Adriano dos Santos Fernandes wrote: On 18/02/2019 05:50, Vlad Khorsun wrote: 18.02.2019 1:49, Adriano dos Santos Fernandes wrote: Open two connections C1 and C2. C2: select current_transaction from rdb$database; -- let's call the result T2 C2: commit; C1: select rdb

Re: [Firebird-devel] RDB$GET_TRANSACTION_CN works different in Super and Classic

2019-02-18 Thread Vlad Khorsun
18.02.2019 17:18, liviuslivius wrote: If you consider to remove it in CS only... Nobody going to remove it, don't worry ;) Regards, Vlad Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Start transaction from base transaction

2019-02-19 Thread Vlad Khorsun
19.02.2019 18:24, Adriano dos Santos Fernandes wrote: Hi Vlad, I restarted work on this feature now using commit numbers. Good to know. Could you publish user interface before it is too late ? ;) Initial prototype seems to work easily. It should be not too hard, agree So now with

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Vlad Khorsun
24.01.2019 15:13, Jiří Činčura wrote: Vlad, is it OK to call this method multiple times (nothing else is called in between)? Yes. All calls after first one is (almost) no-op I'm asking because some application might load same library using different paths via symlinks. And at least

Re: [Firebird-devel] fb_shutdown in embedded mode

2019-01-24 Thread Vlad Khorsun
24.01.2019 16:14, Adriano dos Santos Fernandes wrote: On 24/01/2019 12:00, Vlad Khorsun wrote: 24.01.2019 15:13, Jiří Činčura wrote: Vlad, is it OK to call this method multiple times (nothing else is called in between)?   Yes. All calls after first one is (almost) no-op I'm asking because

Re: [Firebird-devel] Backtracking bomb

2019-05-25 Thread Vlad Khorsun
25.05.2019 2:19, Adriano dos Santos Fernandes wrote: Hi! We always let btyacc nicely handle parser backtracking alone but seems in some cases we should not let it. CORE-6068 is such a case. Parser enters in near-infinite loop allocating and freeing memory trying new paths. Based on the short

Re: [Firebird-devel] Firebird 4: Could not find acceptable ICU library

2019-06-08 Thread Vlad Khorsun
08.06.2019 18:00, Simonov Denis via Firebird-devel wrote: Windows Server 2012 x64. After installation Firebird 4.0.0.1436 x64 we have the following. Connect from IBExpert use c:\Program Files\Firebird\Firebird_4_0\WOW64\fbclient.dll When trying to execute a query, we get the error "Could not

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-14 Thread Vlad Khorsun
14.06.2019 14:58, Mark Rotteveel wrote: On 2019-06-13 22:12, Vlad Khorsun wrote: 13.06.2019 17:02, Adriano dos Santos Fernandes wrote: On 13/06/2019 06:43, Vlad Khorsun wrote:    I don't offer to change internal representation (UTC + offset\region_id) as is. This is the only way to have

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-14 Thread Vlad Khorsun
14.06.2019 16:27, Adriano dos Santos Fernandes wrote: On 14/06/2019 09:56, Vlad Khorsun wrote:   Mapping between region_ID and regin_Name could be easily obtained from server (RDB$TIME_ZONES) if necessary. It could be done once per client process lifetime. Initial mapping could be hardcoded

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-14 Thread Vlad Khorsun
14.06.2019 16:17, Adriano dos Santos Fernandes wrote: On 13/06/2019 17:05, Vlad Khorsun wrote: 13.06.2019 16:44, Alex Peshkoff via Firebird-devel wrote: On 13.06.2019 12:43, Vlad Khorsun wrote: First, you loose things. The adjusted (displayable) timestamp is not convertible back

Re: [Firebird-devel] ODP: Firebird 4: Could not find acceptable ICUlibrary

2019-06-13 Thread Vlad Khorsun
12.06.2019 18:27, Adriano dos Santos Fernandes wrote: On 12/06/2019 10:18, Dimitry Sibiryakov wrote: 12.06.2019 13:43, Adriano dos Santos Fernandes wrote: Then we will not have a single source of truth anymore. When user will create a client timestamp-tz value, he will need to fill that

<    1   2   3   4   5   6   7   8   9   10   >