Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:01, Jiří Činčura wrote: Hi *, I have this fbtrace.conf file: database { enabled = true log_connections = true log_statement_prepare = true log_statement_start = true log_statement_finish = true time_threshold = 0 } And I'm starting

Re: [Firebird-devel] fbtrace.conf format

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:02, Jiří Činčura wrote: Hi *, I realized the fbtrace.conf has new format in FB3. Is the old one still supported (because that's what the .NET provider is currently using - I was not expecting this to be change "just because we can")? In FB3 we used same configuration files

Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 11:26, Jiří Činčura wrote: What Firebird account you used to run trace ? I haven't specified any username/password. The command line I posted is all I executed. It uses your OS user name (i guess) and thus it can't trace sessions of other users. Specify correct user

Re: [Firebird-devel] icudt52.dll FB3

2017-07-10 Thread Vlad Khorsun via Firebird-devel
10.07.2017 11:11, D. Kruise пишет: ... I installed in the exe directory FBclient.dll firebird.msg ib_util.dll icudt52.dll icuin52.dll icuuc52.dll Seems you missed icudt52l.dat. Also, make sure, you used 64-bit DLL's And into subdir intl fbintl.conf fbintl.dll And into subdir plugins

Re: [Firebird-devel] Trace no returning any data

2017-07-14 Thread Vlad Khorsun via Firebird-devel
14.07.2017 12:14, Jiří Činčura wrote: It uses your OS user name (i guess) and thus it can't trace sessions of other users. Specify correct user credentials and it should work. No luck. I tried both ".\fbsvcmgr service_mgr user sysdba password masterkey action_trace_start trc_name ..."

Re: [Firebird-devel] HASH function (CORE-4436)

2017-07-18 Thread Vlad Khorsun via Firebird-devel
18.07.2017 21:55, Adriano dos Santos Fernandes wrote: Hi! We have HASH function that returns a 64 bit integer. The algorithm is bad and the result too small for a hash. I propose to extend the same function with a second parameter with the algorithm name. > When only one parameter is passed,

Re: [Firebird-devel] Detecting connection is using wire encryption

2017-07-16 Thread Vlad Khorsun via Firebird-devel
16.07.2017 12:59, Mark Rotteveel wrote: Is there a way to programmatically detect a connection is using wire encryption (eg in a monitoring table or the service API)? I'm writing a test to check if Jaybird is correctly (not) using encryption depending on its connection properties, and I'd

[Firebird-devel] test

2017-08-18 Thread Vlad Khorsun via Firebird-devel
Ignore please Vlad -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] 3.0.2 consistent crash

2017-08-19 Thread Vlad Khorsun via Firebird-devel
18.08.2017 19:45, Jiří Činčura wrote: Could you try latest snapshot build ? Running it (3.0.3.32798) for about an hour now. So far so good. Sounds good ;) Send full memory dump to me, please. Or, better, reproducible test case, if it is possible. I can only trigger it from

Re: [Firebird-devel] 3.0.2 consistent crash

2017-08-18 Thread Vlad Khorsun via Firebird-devel
18.08.2017 14:59, Jiří Činčura wrote: Hi *, I'm running 3.0.2 x64 SS (on Win 2016 (if it matters)) and I can consistently get "internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 282)". Sometimes it's quick sometimes it takes few minutes. Always this.

[Firebird-devel] [SPAM] Re: Build sources

2017-10-13 Thread Vlad Khorsun via Firebird-devel
13.10.2017 12:16, liviuslivius wrote: Hi, I try to build Fb master from sources. What is the recommended environment for Windows. Can i use MSVC14 Express? I never used Express version by myself. I use VS 2015 Community Edition currently for testing VC14 builds. Or it must be MSVC12? I

Re: [Firebird-devel] FB 3.0 Replacing ICU libraries on Windows

2017-10-12 Thread Vlad Khorsun via Firebird-devel
12.09.2017 15:33, Adriano dos Santos Fernandes wrote: On 12/09/2017 08:46, Magnus Johansson wrote: ... SELECT FIELD_UTF_SV_CI_NUM FROM TABLE_T WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b' ORDER BY 1; FIELD_UTF_SV_CI_NUM === 1 2 10 20 a A aa Aa AA b

Re: [Firebird-devel] Plans to support cross and outer apply

2017-09-06 Thread Vlad Khorsun via Firebird-devel
06.09.2017 9:45, Jiří Činčura wrote: Hi *, I was searching the tracker but couldn't find anything. Any plans around supporting cross and outer apply "joins"? I think we should consider standard LATERAL JOIN. It seems not too hard to implement. Regards, Vlad

Re: [Firebird-devel] Lateral derived tables

2017-09-10 Thread Vlad Khorsun via Firebird-devel
08.09.2017 11:03, Dmitry Yemanov wrote: All, The key point of this standard feature is to allow sub-queries to reference priorly defined contexts (in joins). While thinking about this, I have a few questions to raise here. The standard defines LATERAL for derived tables only. This sounds

Re: [Firebird-devel] Test - please ignore

2017-09-30 Thread Vlad Khorsun via Firebird-devel
Test 2 -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 23:33, Dimitry Sibiryakov wrote: 11.10.2017 22:14, Vlad Khorsun via Firebird-devel wrote:    IIRC, it is already implemented.   No. This functionality is in fbsvcmgr, but not in gbak. It is implemented at Service API level, i.e. by all the providers (engine, remote, etc

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
12.10.2017 0:37, Dimitry Sibiryakov wrote: 11.10.2017 22:56, Vlad Khorsun via Firebird-devel wrote:    The problem is that you don't undestand that auth parameters (required to create connection) should not be mixed with action's parameters.   I can't understand what you talking about

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 21:09, Dimitry Sibiryakov wrote: 11.10.2017 19:47, Vlad Khorsun via Firebird-devel wrote:    I don't see it as a problem, as user already should understand what is connection string and how to construct is from host name and database name. From my expirience "usual" ap

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 21:34, Adriano dos Santos Fernandes wrote: I must agree that host:service_mgr is weird, but not all services expects (or would expect) a database. Can't say it is weird. Probably, we could allow to skip service manager name, but it will be hard to specify XNET protocol without

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 16:59, Dimitry Sibiryakov пишет: 10.10.2017 18:00, Dimitry Sibiryakov wrote:    I'd suggest to offer to the application developer third, more convenient, option: subj.    If database connection string is used this way, server can automatically set the database name to expected_db

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
10.10.2017 19:00, Dimitry Sibiryakov wrote:   Hello.   Imagine that you are an application developer and develop an application that allow users to enter connection string for database they want to work with. Imagine that in new version of the application you would like to add some work with

Re: [Firebird-devel] Using ordinary database connection string in isc_service_attach() call

2017-10-11 Thread Vlad Khorsun via Firebird-devel
11.10.2017 22:22, Dimitry Sibiryakov wrote: 11.10.2017 20:57, Vlad Khorsun via Firebird-devel wrote:   I don't understand your speculations   Ok, turn your imagination on: Performance of gbak must be improved by feeding of backup stream from server using services instead of sending queries

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

Re: [Firebird-devel] Database opened in another session

2017-12-18 Thread Vlad Khorsun via Firebird-devel
17.12.2017 17:33, Jiří Činčura wrote: I.e. it is failed to initialize shared memory for monitoring snapshot. I can't explain how it is possible to initialize lock manager shared memory first and then fail to initialize shared memory for monitoring snapshot. Need more time to investigate it.

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-12 Thread Vlad Khorsun via Firebird-devel
12.12.2017 17:38, Gabor Boros wrote: If the problem can't be reproduces with a simple database and simple application, it's probably another problem. I have a simple application and three databases. Can I send to you privately? I attached earlier but got a message about the 40 KB body limit.

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-14 Thread Vlad Khorsun via Firebird-devel
12.12.2017 19:55, Gabor Boros wrote: 2017. 12. 12. 18:31 keltezéssel, Vlad Khorsun via Firebird-devel írta: 12.12.2017 17:38, Gabor Boros wrote: If the problem can't be reproduces with a simple database and simple application, it's probably another problem. I have a simple application

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 10:45, liviuslivius wrote: Hi Vlad, "This temporary blobs could be released on commit (rollback) only" just curious, why it can not be released after it is used? When its become unused ? That blobs returned to the client aplication and should be accessible until transaction

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 12:34, Dimitry Sibiryakov wrote: 15.12.2017 10:03, Vlad Khorsun via Firebird-devel wrote: PS In theory, it should be possible to postpone transliteration into attachment charset until application opens blob. But i see no easy\direct way to do it.   In theory it is possible

Re: [Firebird-devel] Memory leak - How can I provide information about it?

2017-12-15 Thread Vlad Khorsun via Firebird-devel
15.12.2017 11:20, Adriano dos Santos Fernandes пишет: On 15/12/2017 07:03, Vlad Khorsun via Firebird-devel wrote: 15.12.2017 10:45, liviuslivius wrote: Hi Vlad, "This temporary blobs could be released on commit (rollback) only" just curious, why it can not be released after

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Vlad Khorsun via Firebird-devel
18.12.2017 14:26, Jiří Činčura wrote: Right now I isolated the databases, so only apps from the same session (0) are accessing the database and always via TCP/IP. I'm afraid it's something else. I found one change in v3 not backported into v2.5 which could be related to this issue. Could you

Re: [Firebird-devel] Database opened in another session

2017-12-20 Thread Vlad Khorsun via Firebird-devel
20.12.2017 11:16, Jiří Činčura wrote: v3 after you isolated the databases (what do you mean by this, btw) ? I'm keeping eye on v3. For sure it's not often. But I think I saw it even on 3 before. Will wait a week or so to see whether it happens or not. Isolated: I went through all apps and

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Vlad Khorsun via Firebird-devel
07.12.2017 16:23, Jiří Činčura wrote: Hi *, I'm getting, for quite some time, "Database is probably already opened by another engine instance in another Windows session" on servers (2x 2.5.7, 1x 3.0.3 (although it's less common here)). The problem is, that the database is only accessed via

Re: [Firebird-devel] Database opened in another session

2017-12-07 Thread Vlad Khorsun via Firebird-devel
07.12.2017 17:16, Jiří Činčura wrote: Nope. Still happening. Even with `-i`. Hmm... i was not attentive enough, error is about database not about listener. It means that one engine instance is already open database and another instance going to open it too and both instances runs in

Re: [Firebird-devel] Virtual table for time zones

2018-05-14 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:   I guess the question is about the case when users have historical data and need to apply old time zone rule to the old data and new timezone rule to the new data

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:02, Adriano dos Santos Fernandes wrote: On 10/05/2018 12:53, Lester Caine wrote: ... And how will the version of TZ data be handled! This is a key element that has screwed normalized data in the past, and some way to manage that normalized data needs to be included in the

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:02, Adriano dos Santos Fernandes wrote: On 10/05/2018 12:53, Lester Caine wrote: ... And how will the version of TZ data be handled! This is a key element that has screwed normalized data in the past, and some way to manage that normalized data needs to be included in the

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:   I guess the question is about the case when users have historical data and need to apply old time zone rule to the old data and new timezone rule to the new data

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 19:57, Adriano dos Santos Fernandes пишет: On 10/05/2018 13:47, Vlad Khorsun via Firebird-devel wrote: 10.05.2018 19:23, Adriano dos Santos Fernandes wrote: On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:    I guess the question is about the case when users have

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 20:29, Adriano dos Santos Fernandes пишет: On 10/05/2018 14:23, Vlad Khorsun via Firebird-devel wrote:    Look how MSK time zone was changed at 2014.10.26 https://www.timeanddate.com/time/zone/russia/moscow I think about something like this: ID    Name    Valid from

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 21:13, Lester Caine wrote: On 10/05/18 18:47, Vlad Khorsun via Firebird-devel wrote: Regions that use Daylight Saving Time (DST) change the time zone name and time during the DST period. The words “daylight” or “summer” are then usually included in the time zone name. The areas

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 21:21, Adriano dos Santos Fernandes wrote: The name for Moskow is Europe/Moscow. Please, convert to UTC and explain how to do it: 2010.03.01 04:00 Europe/Moscow, 2013.03.01 04:00 Europe/Moscow, 2016.03.01 04:00 Europe/Moscow Regards, Vlad

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
10.05.2018 22:08, Adriano dos Santos Fernandes wrote: On 10/05/2018 15:30, Vlad Khorsun via Firebird-devel wrote:   The key is that DST doesn't affect given time zone. TZ could be "standard time" based (such as MSK) or "DST based" (such as MSD or IST you speak

Re: [Firebird-devel] Virtual table for time zones

2018-05-10 Thread Vlad Khorsun via Firebird-devel
11.05.2018 1:27, Adriano dos Santos Fernandes wrote: On 10/05/2018 18:03, Vlad Khorsun via Firebird-devel wrote: ... Could you answer my question below ?   Please, convert to UTC and explain how to do it:    2010.03.01 04:00 Europe/Moscow,    2013.03.01 04:00 Europe/Moscow,    2016.03.01

Re: [Firebird-devel] Time zone feature documentation

2018-05-11 Thread Vlad Khorsun via Firebird-devel
12.05.2018 1:12, Lester Caine wrote: On 11/05/18 20:37, Adriano dos Santos Fernandes wrote: * PST is Pitcairn or Pacific, with the same offset, they are considered different time zones ICU data is derived from TZ data hosted by IANA (http://site.icu-project.org/tznotice). I really can't

Re: [Firebird-devel] Reason for "Missing master config file firebird.conf"

2018-05-18 Thread Vlad Khorsun via Firebird-devel
18.05.2018 11:00, Jiří Činčura wrote: Hi *, what could be the reason for "Missing master config file firebird.conf" mesage when doing ".\firebird.exe -a"? I'm traying to start Firebird on AAppVeyor for tests for NETProvider. When I execute it manually it starts fine. Only when from script

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Vlad Khorsun via Firebird-devel
19.05.2018 11:04, Mark Rotteveel wrote: On 18-5-2018 18:44, Vlad Khorsun via Firebird-devel wrote: ...    Please, read and comment: https://github.com/FirebirdSQL/firebird/blob/ExternalConnectionsPool/doc/sql.extensions/README.external_connections_pool 1. I'm not sure how I should read

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Vlad Khorsun via Firebird-devel
19.05.2018 13:08, Mark Rotteveel wrote: If it is global, then the permission for ALTER EXTERNAL CONNECTIONS POOL needs to be changed: """    New SQL statement is introduced to manage the pool :  ALTER EXTERNAL CONNECTIONS POOL.    When prepared it desribed as DDL statement but have

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Vlad Khorsun via Firebird-devel
19.05.2018 18:52, Dimitry Sibiryakov wrote: >>Also, i want to speak about possible extension of the feature. I think it would >> be good to have new monitoring table with list of all external connections. Not >> sure if we should allow to DELETE here but it should be at least considered

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-19 Thread Vlad Khorsun via Firebird-devel
19.05.2018 19:38, Dimitry Sibiryakov wrote:   BTW, what behavior is expected from GTT ON COMMIT PRESERVE in pooled connection? Nothing special was done in this area - GTT contents will be preserved. The same for context variables. So, we have a question - should we clear session-level

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:06, Mark Rotteveel wrote: On 20-5-2018 12:47, Vlad Khorsun via Firebird-devel wrote: 20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:13, Dimitry Sibiryakov пишет: 20.05.2018 13:00, Vlad Khorsun via Firebird-devel wrote:    I'd suggest to add to EDS an option to use "isolated" connection, which is guaranteed the connection to be new and after use to be deleted, not returned to pool.    Why one s

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 12:55, Mark Rotteveel wrote: On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote: 19.05.2018 13:08, Mark Rotteveel wrote: 2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_POOL or if shorter is preferred: ALTER_EXT_CONN_POOL 3

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 17:53, Dimitry Sibiryakov wrote: 20.05.2018 16:25, Adriano dos Santos Fernandes wrote: Isn't (some parts of) the config file already reloaded sometimes (timeout)?   Firebird.conf is reloaded when its timestamp changed. Plugins' configs are not reloaded. Where do you see it ?

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 12:38, Dimitry Sibiryakov wrote: 19.05.2018 18:44, Vlad Khorsun via Firebird-devel wrote:    Nothing special was done in this area - GTT contents will be preserved. The same for context variables.    So, we have a question - should we clear session-level state when connection become

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:15, Mark Rotteveel wrote: On 20-5-2018 13:00, Vlad Khorsun via Firebird-devel wrote:    I plan to introduce new database object "EXTERNAL DATA SOURCE" since initial implementation of EXECUTE STATEMENT ON EXTERNAL, but I never have time\priority to implement it, unf

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 19:14, Dimitry Sibiryakov wrote: 20.05.2018 17:29, Vlad Khorsun via Firebird-devel wrote:    Where do you see it ?   You are right, it is nowhere in main tree. Sorry, I missed it up with one of my branches.   In any case it is easy to add cache object to ConfigImpl constructor

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-20 Thread Vlad Khorsun via Firebird-devel
20.05.2018 14:11, liviuslivius wrote: Hi, can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on database 2 from 1. Third connect simply to database 1 why it can not benefit from pool? Explain, please. The statement

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 14:58, Rashid Abzalov wrote: 21.05.2018 14:42, Vlad Khorsun via Firebird-devel wrote:    I don't see how persistent connections in Postgres could be reused by different user sessions. No, in Postgres you can reuse only your own connections. You see - all approaches have its

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 14:25, Rashid Abzalov wrote: Instead of implementing a pool of connections that the system implicitly manages, it might be better to implement named connections as it is done in Postgres (https://www.postgresql.org/docs/current/static/contrib-dblink-function.html)? Which the user

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:   All,   I going to merge into master implementation of pool of external connections. The feature was initially developed more than a year ago, and works at production with good feedback. According to discussion in this topic i

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 12:32, Dimitry Sibiryakov wrote: 23.05.2018 11:24, Vlad Khorsun via Firebird-devel wrote: - At tracker there was proposition to add new database trigger ON RESET which should    fire when ALTER SESSION RESET is run. Should we implement it ?   What useful could such trigger do

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 12:58, Dmitry Yemanov wrote: 23.05.2018 12:39, Vlad Khorsun wrote:    What useful could such trigger do? I suppose - the most of the thing that users do on CONNECT (init some context variables, for example) and DISCONNECT (free some resources). Wouldn't it make sense to call ON

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 13:40, Adriano dos Santos Fernandes wrote: On 23/05/2018 06:48, Dimitry Sibiryakov wrote:   In this case I guess there must be two triggers: BEFORE RESET and AFTER RESET. I like this more than the other approaches. I strongly suggest to consider existing DISCONNECT\CONNECT

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 13:48, Mark Rotteveel wrote: On 23-5-2018 11:24, Vlad Khorsun via Firebird-devel wrote: 18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:    All,    I going to merge into master implementation of pool of external connections. The feature was initially developed more than

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
24.05.2018 0:39, Dimitry Sibiryakov wrote: 23.05.2018 21:18, Vlad Khorsun via Firebird-devel wrote:    At second, there is no way to upgrade server without breaking established connection (obviously).   Nobody tell about it. And it change nothing.   Then could you, please, explain what

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-24 Thread Vlad Khorsun via Firebird-devel
24.05.2018 11:35, Dimitry Sibiryakov wrote: 24.05.2018 1:08, Vlad Khorsun via Firebird-devel wrote: 24.05.2018 0:39, Dimitry Sibiryakov wrote:    What visible changes can happen after upgrade of server version?    We have local server v4 and remote server v3. v4 runs external statements

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Vlad Khorsun via Firebird-devel
24.05.2018 12:06, Dimitry Sibiryakov wrote: 24.05.2018 10:50, Vlad Khorsun via Firebird-devel wrote:    From reading documentation I have a feeling that currently external connection is reused only within transaction. When local transaction ends, connection is disconnected.    Yes, almost

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Vlad Khorsun via Firebird-devel
25.05.2018 18:33, Dimitry Sibiryakov wrote: 25.05.2018 17:26, Vlad Khorsun via Firebird-devel wrote: I.e. all works a bit slower than before v4.   I think that it can be a good motivation to upgrade remote server to v4. Bad joke All works much faster than before v4.   Do you have

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Vlad Khorsun via Firebird-devel
25.05.2018 16:40, Dimitry Sibiryakov пишет: 25.05.2018 15:28, Vlad Khorsun via Firebird-devel wrote:    We have local server v4 and remote server v3. v4 runs external statements against v3 and remote sessions have some context that is re-used by remote statements somehow. Then remote server

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Vlad Khorsun via Firebird-devel
24.05.2018 12:01, Mark Rotteveel wrote: On 2018-05-24 01:08, Vlad Khorsun via Firebird-devel wrote: 24.05.2018 0:39, Dimitry Sibiryakov wrote:   So far we have following propositions: 1. Always reset external connection when it gets out of use. Close connection if any kind of error happens

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-25 Thread Vlad Khorsun via Firebird-devel
25.05.2018 17:05, Dimitry Sibiryakov wrote: 25.05.2018 15:53, Vlad Khorsun via Firebird-devel wrote:    Remote statement could check some context variable and run this or that branch of code in dependence of variable value. Then it could assign another value to this context variable. It all

[Firebird-devel] RFC: External Connections Pool

2018-05-18 Thread Vlad Khorsun via Firebird-devel
All, I going to merge into master implementation of pool of external connections. The feature was initially developed more than a year ago, and works at production with good feedback. Some bugs was fixed since then, so it should be stable enough and definitely good for beta release of

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-18 Thread Vlad Khorsun via Firebird-devel
18.05.2018 22:15, Dimitry Sibiryakov wrote: 18.05.2018 20:49, Vlad Khorsun via Firebird-devel wrote:    Whole EDS feature is implemented as part of engine.   Shouldn't new configuration parameters to be in the right place for plugin's parameters: engine13.conf instead of legacy pile

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 15:40, Mark Rotteveel wrote: - New session management statement ALTER SESSION RESET is implemented (see CORE-5832).    Ticket is not marked as closed for a while as i want to make sure implementation    is complete. Thus any suggestions, notes, etc are welcome. As I said in

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-23 Thread Vlad Khorsun via Firebird-devel
23.05.2018 15:59, Dimitry Sibiryakov wrote: 23.05.2018 14:40, Mark Rotteveel wrote: I think it should unconditionally do a session reset on return to the pool if the protocol is v16 or higher (assuming v16 is the Firebird 4 protocol version).    This is not truly unconditionally :)    But

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-21 Thread Vlad Khorsun via Firebird-devel
21.05.2018 11:47, Dimitry Sibiryakov wrote: 21.05.2018 10:13, Mark Rotteveel wrote:   if pool contain connection to database 1 and user try to connect to also database 1 he can use pool instead normal connection. That wouldn't really work   Yes, that wouldn't work. But generally speaking

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-10 Thread Vlad Khorsun via Firebird-devel
Mark, all I just committed changes as we discussed above. I.e. session reset now ignores prepared transactions, rollback currently active user transaction and start new one, issue warning if user transaction made changes in tables. Here is how it looks now: SQL> alter session reset;

[Firebird-devel] TRANSACTION START trigger

2018-06-08 Thread Vlad Khorsun via Firebird-devel
All, I have a questions about error handling after TRANSACTION START trigger and I want to clear my doubts or fix the bug (if confirmed). From README.db_triggers.txt: - TRANSACTION START Triggers are fired in the newly user created transaction - uncaught exceptions are returned

Re: [Firebird-devel] TRANSACTION START trigger

2018-06-08 Thread Vlad Khorsun via Firebird-devel
08.06.2018 12:16, Dimitry Sibiryakov wrote: 08.06.2018 11:01, Vlad Khorsun via Firebird-devel wrote:    Another question is how to handle rollback error. I mean rollback that run at catch block. I offer to ignore rollback error (maybe log it into firebird.log, if database is not bug-checked

Re: [Firebird-devel] RFC: External Connections Pool

2018-06-18 Thread Vlad Khorsun via Firebird-devel
  All,   I going to merge into master implementation of pool of external connections. The feature was initially developed more than a year ago, and works at production with good feedback.   Some bugs was fixed since then, so it should be stable enough and definitely good for beta release of

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
28.05.2018 18:03, Dimitry Sibiryakov wrote: 28.05.2018 16:45, Vlad Khorsun via Firebird-devel wrote:    On one hand third option would be consistent with behavior of isc_detach_database() on client. On the other hand server cannot handle such error and it will result in endless transaction

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-27 Thread Vlad Khorsun via Firebird-devel
23.05.2018 15:07, Adriano dos Santos Fernandes wrote: On 23/05/2018 08:51, Vlad Khorsun via Firebird-devel wrote: 23.05.2018 13:40, Adriano dos Santos Fernandes wrote: On 23/05/2018 06:48, Dimitry Sibiryakov wrote:    In this case I guess there must be two triggers: BEFORE RESET and AFTER

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-29 Thread Vlad Khorsun via Firebird-devel
29.05.2018 2:06, Adriano dos Santos Fernandes wrote: On 28/05/2018 09:13, Vlad Khorsun via Firebird-devel wrote:   There is still no agreement. Current offers: - single ON SESSION RESET trigger - pair of new triggers: BEFORE SESSION RESET and AFTER SESSION RESET - use existing ON CONNECT

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-04 Thread Vlad Khorsun via Firebird-devel
02.06.2018 19:54, Mark Rotteveel wrote: On 2-6-2018 17:56, Vlad Khorsun via Firebird-devel wrote: 02.06.2018 18:07, Mark Rotteveel wrote: I just saw the following commit: https://github.com/FirebirdSQL/firebird/commit/bbf8348817c4592999fc137b18ba1be7326ad42d This disallows execution of ALTER

Re: [Firebird-devel] ALTER SESSION RESET not allowed if there are transactions?

2018-06-02 Thread Vlad Khorsun via Firebird-devel
02.06.2018 18:07, Mark Rotteveel wrote: I just saw the following commit: https://github.com/FirebirdSQL/firebird/commit/bbf8348817c4592999fc137b18ba1be7326ad42d This disallows execution of ALTER SESSION RESET if there are transactions active. I think this is too restrictive. Only from

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
All, Some update on this topic 18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:    All,    I going to merge into master implementation of pool of external connections. The feature was initially developed more than a year ago, and works at production with good feedback

Re: [Firebird-devel] RFC: External Connections Pool

2018-05-28 Thread Vlad Khorsun via Firebird-devel
28.05.2018 15:57, Dimitry Sibiryakov wrote: 28.05.2018 14:13, Vlad Khorsun via Firebird-devel wrote: - forcebly rollback active transactions and reset connection    same as if connection was broken - raise error and don't reset connection.    Obviously, first case is not an option and we must

Re: [Firebird-devel] Time zones

2018-05-02 Thread Vlad Khorsun via Firebird-devel
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

Re: [Firebird-devel] where is ':' valid in Firebird SQL?

2018-01-03 Thread Vlad Khorsun via Firebird-devel
03.01.2018 7:57, Lionel Elie Mamane wrote: I'd like to avoid completely parsing the SQL statement for that, mainly so that the SQL statement is not modified by the LibreOffice SQL parser (and in particular quoting keywords it doesn't know as identifiers). So I'm hoping to simply go through the

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5704) Avoid UPDATE of RDB$DATABASE by ALTER DATABASE statement when possible

2018-01-09 Thread Vlad Khorsun via Firebird-devel
09.01.2018 13:38, Dimitry Sibiryakov wrote: 09.01.2018 12:21, Vlad Khorsun (JIRA) wrote: Actually, isql connects successfully, but it reads RDB$DATABASE itself right after attachment (using READ COMMITTED NO RECORD VERSION WAIT transaction)   Shouldn't it be changed as well? For what ?

Re: [Firebird-devel] Database opened in another session

2018-01-19 Thread Vlad Khorsun via Firebird-devel
27.12.2017 0:38, Vlad Khorsun via Firebird-devel wrote: 26.12.2017 16:48, Vlad Khorsun via Firebird-devel wrote: 26.12.2017 11:45, Jiří Činčura wrote: Looks like the issue is not happening in nightly 3.0.3 (about two weeks old).    Good to know, thanks. Meanwile, i'm trying to reproduce

Re: [Firebird-devel] Firebird 3 and ICU

2018-01-19 Thread Vlad Khorsun via Firebird-devel
19.01.2018 11:41, Adriano dos Santos Fernandes wrote: On 19/01/2018 07:14, Roman Simakov wrote: Hello! It seems that we have a problem with installation of Firebird 3 on OpenSuse. I get "Could not find acceptable ICU library". I took a look into sources. FB tries to search ICU modules in some

Re: [Firebird-devel] Database opened in another session

2018-01-29 Thread Vlad Khorsun via Firebird-devel
28.01.2018 10:44, Jiří Činčura wrote: Sadly it has happened again few hours ago. 2.5.8 x64, running on Windows Server. Sad. I'll backport shared memory initialization from v3 Regards, Vlad -- Check out the vibrant

Re: [Firebird-devel] [SPAM] Re: Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-07 Thread Vlad Khorsun via Firebird-devel
07.02.2018 15:21, Mark Rotteveel wrote: On 7-2-2018 13:54, Vlad Khorsun via Firebird-devel wrote: 07.02.2018 14:41, Mark Rotteveel wrote: On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote: 07.02.2018 13:26, Mark Rotteveel wrote: On 7-2-2018 11:55, Mark Rotteveel wrote: Shouldn't

Re: [Firebird-devel] Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-07 Thread Vlad Khorsun via Firebird-devel
07.02.2018 12:55, Mark Rotteveel wrote: Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow: https://stackoverflow.com/questions/48644878/appcrash-in-fbintl-dll-if-using-embedded-mode-in-my-c-app. I can reproduce it with the provided example

Re: [Firebird-devel] Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-07 Thread Vlad Khorsun via Firebird-devel
07.02.2018 13:26, Mark Rotteveel wrote: On 7-2-2018 11:55, Mark Rotteveel wrote: Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow: https://stackoverflow.com/questions/48644878/appcrash-in-fbintl-dll-if-using-embedded-mode-in-my-c-app. I can

Re: [Firebird-devel] Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-07 Thread Vlad Khorsun via Firebird-devel
07.02.2018 14:17, Mark Rotteveel пишет: On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote: 07.02.2018 13:26, Mark Rotteveel wrote: On 7-2-2018 11:55, Mark Rotteveel wrote: Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow: https

Re: [Firebird-devel] [SPAM] Re: Crash Firebird 2.5.8 Embedded with Firebird Ado.net provider.

2018-02-07 Thread Vlad Khorsun via Firebird-devel
07.02.2018 14:41, Mark Rotteveel wrote: On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote: 07.02.2018 13:26, Mark Rotteveel wrote: On 7-2-2018 11:55, Mark Rotteveel wrote: Shouldn't the engine be able to cope with this?    Yes, and fb_shutdown handle it. But it can't handle

Re: [Firebird-devel] Database opened in another session

2017-12-26 Thread Vlad Khorsun via Firebird-devel
26.12.2017 11:45, Jiří Činčura wrote: Looks like the issue is not happening in nightly 3.0.3 (about two weeks old). Good to know, thanks. Meanwile, i'm trying to reproduce it on v2.5.8 using test case from CORE-4680. No luck so far. Regards, Vlad

Re: [Firebird-devel] Database opened in another session

2017-12-26 Thread Vlad Khorsun via Firebird-devel
26.12.2017 16:48, Vlad Khorsun via Firebird-devel wrote: 26.12.2017 11:45, Jiří Činčura wrote: Looks like the issue is not happening in nightly 3.0.3 (about two weeks old).   Good to know, thanks. Meanwile, i'm trying to reproduce it on v2.5.8 using test case from CORE-4680. No luck so far

  1   2   >