Re: [Firebird-devel] Compiler for official Firebird 4 release on Windows

2016-02-28 Thread Vlad Khorsun
28.02.2016 12:47, Mark Rotteveel пишет: > On 28-2-2016 11:35, Dmitry Yemanov wrote: >> 28.02.2016 13:17, Dimitry Sibiryakov wrote: >> >>> 28.02.2016 11:05, Dmitry Yemanov wrote: It's not about VS 2015, but about C++14 in general >>> >>> Read some more. Problem is not standard, but VS 2015 code

Re: [Firebird-devel] RFC: Tablespaces

2016-03-02 Thread Vlad Khorsun
02.03.2016 23:23, Dmitry Yemanov wrote: > > Historically, Firebird databases consist of a sequential set of pages of > the fixed size (4-16KB currently). This page set is distributed across > one (usually) or multiple files (*) The page number initially was SLONG, > now it's ULONG. So the theoretic

Re: [Firebird-devel] Browse information in VS 2010

2016-03-03 Thread Vlad Khorsun
03.03.2016 12:28, Dimitry Sibiryakov wrote: > Hello, All. > > Do anybody use subj? Sure > Windows DDK 7.1 does not have browse symbol compiler for 64 bits. Because > of that build > of 64 bits version fail with VS 2010 Express. IIRC, VS 2010 Express have no 64-bit compiler. >

Re: [Firebird-devel] Browse information in VS 2010

2016-03-03 Thread Vlad Khorsun
03.03.2016 12:55, Dimitry Sibiryakov wrote: > 03.03.2016 11:52, Vlad Khorsun wrote: >>> Do anybody use subj? >> Sure > > Don't you use VS 2013?.. It have no impact on my opinion Vlad --

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Vlad Khorsun
03.03.2016 9:04, Dmitry Yemanov wrote: > 03.03.2016 09:48, Dmitry Yemanov wrote: >> >>> Blobs could be moved into separate tablespace. It could make backup of >>> "data" tablespace faster and smaller. We can even think about "offline" >>> tablespace. >> >> Really good idea. Maybe more important for

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

2016-03-03 Thread Vlad Khorsun
03.03.2016 13:07, Dimitry Sibiryakov wrote: > 03.03.2016 6:28, Dmitry Yemanov wrote: >> I've asked for a particular change patch, you've provided 220KB of the >> total tree diff to scan for the needed changes. If you want your patches >> reviewed sooner, better start to respect other's time. > >

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Vlad Khorsun
02.03.2016 23:58, Dimitry Sibiryakov wrote: > 02.03.2016 22:51, Vlad Khorsun wrote: >> Blobs could be moved into separate tablespace. It could make backup of >> "data" tablespace faster and smaller. We can even think about "offline" >> tablespace. &

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

2016-03-03 Thread Vlad Khorsun
03.03.2016 13:26, Dimitry Sibiryakov wrote: > 03.03.2016 12:21, Vlad Khorsun wrote: >> Do you have numbers ? I.e. what is profit of this change ? > > If you mean overall profit under multiuser load, then - no, I have no > numbers for that. Perfect Vlad PS There i

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Vlad Khorsun
03.03.2016 13:42, Dimitry Sibiryakov wrote: > 03.03.2016 12:29, Vlad Khorsun wrote: >>> How will be enforced consistency between tablespaces? How to detect >>> and handle cases if >>>> tablespace file is lost or is older/newer that main file? >>

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Vlad Khorsun
03.03.2016 15:36, Dimitry Sibiryakov wrote: > 03.03.2016 13:38, Vlad Khorsun wrote: >>> May be transaction counters in each header written on each commit that >>> change the >>>> tablespace can work better? >> This will create crazy overhead > >

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

2016-03-03 Thread Vlad Khorsun
03.03.2016 15:32, Dimitry Sibiryakov wrote: > 03.03.2016 12:56, Vlad Khorsun wrote: >>> If you mean overall profit under multiuser load, then - no, I have no >>> numbers for that. >> >> Perfect > > If you have at hand server with dozen of cor

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

2016-03-03 Thread Vlad Khorsun
03.03.2016 16:51, Dimitry Sibiryakov wrote: > 03.03.2016 15:07, Vlad Khorsun wrote: >>> I wouldn't expect much from lock manager, but hash joins can get >>> significant boost, >>>> especially on long keys. >> You don't need &

Re: [Firebird-devel] [Firebird-checkins] SF.net SVN: firebird:[63072] firebird/trunk/src

2016-03-03 Thread Vlad Khorsun
03.03.2016 16:15, Dimitry Sibiryakov wrote: > 03.03.2016 15:07, Vlad Khorsun wrote: >>>> Are you sure that lock manager doesn't work with data of one or two >>>> bytes long? At >>>> these sizes the function had a weak spot without these ifs. &g

Re: [Firebird-devel] RFC: Tablespaces

2016-03-03 Thread Vlad Khorsun
03.03.2016 17:57, Jim Starkey wrote: > The place to start is with a clear, well understood, and agreed set of > requirements. Here is a suggested starting point. > > First, some definitions. A "data space" is the collection of pointer and > data pages that hold the data from a single table. An

Re: [Firebird-devel] byacc bitness

2016-03-09 Thread Vlad Khorsun
09.03.2016 15:12, Dimitry Sibiryakov wrote: > Hello, All. > > Do result of btyacc's work depend on its bitness? > I wonder why Windows build generate separate btyacc executable for each > platform-build > combination. Is there something that prevent the build from using single > "Win3

Re: [Firebird-devel] byacc bitness

2016-03-09 Thread Vlad Khorsun
09.03.2016 15:27, Dimitry Sibiryakov wrote: > 09.03.2016 14:21, Vlad Khorsun wrote: >> What exact problem do you see ? > > Waste of time in batch build. Waste of time - it is current thread. > Impossible to build parse.cpp directly from IDE. Run "parse

Re: [Firebird-devel] byacc bitness

2016-03-09 Thread Vlad Khorsun
09.03.2016 15:43, Dimitry Sibiryakov wrote: > 09.03.2016 14:38, Vlad Khorsun wrote: >> Waste of time - it is current thread. > > If you forgot, I wasn't the man who insisted on discussing of every > change. Yep, you are the men who have nothing really useful

Re: [Firebird-devel] byacc bitness

2016-03-09 Thread Vlad Khorsun
09.03.2016 16:03, Dimitry Sibiryakov wrote: > 09.03.2016 14:55, Vlad Khorsun wrote: >> Yep, you are the men who have nothing really useful to do and a lot of >> free time to waste. > > Yep, I have a lot of spare time while current build system 100500 times > re

Re: [Firebird-devel] byacc bitness

2016-03-09 Thread Vlad Khorsun
09.03.2016 16:42, Dimitry Sibiryakov wrote: > 09.03.2016 15:33, Vlad Khorsun wrote: >> Compare it with v2.5 build system. > > 2.5 build is about two times faster. Let me not believe you >> Also, tell to yourself how much faster it could be >> if you apply

Re: [Firebird-devel] Phasing out BLR

2016-03-09 Thread Vlad Khorsun
09.03.2016 20:41, Adriano dos Santos Fernandes wrote: > On 09/03/2016 14:54, Dmitry Yemanov wrote: >> We don't have SQL/GDML sources for many system triggers, just the byte-code. >> They >> could be reverse engineered, but I'd rather throw away system triggers >> at all and embed their functionali

Re: [Firebird-devel] WideCharBuffer

2016-03-10 Thread Vlad Khorsun
10.03.2016 14:57, Dimitry Sibiryakov wrote: > Hello, All. > > WideCharBuffer from isc_file.cpp seems to be a useful thing in other > places too. Which > header is the best place to move it to? os_utils, i believe Vlad --

Re: [Firebird-devel] WideCharBuffer

2016-03-11 Thread Vlad Khorsun
11.03.2016 16:42, Dimitry Sibiryakov wrote: > 11.03.2016 8:35, Vlad Khorsun wrote: >>> WideCharBuffer from isc_file.cpp seems to be a useful thing in other >>> places too. Which >>>> header is the best place to move it to? >> os_utils, i believ

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-11 Thread Vlad Khorsun
11.03.2016 18:33, Leyne, Sean wrote: > It seems that no one has looked at the File Management Structures of the > Windows API for quite some time, > it seems that ObjectId of the FILE_OBJECTID_BUFFER structure (which is > supported as of WinXP) would also > seem to fit the bill! Why it is be

Re: [Firebird-devel] File lookup

2016-03-14 Thread Vlad Khorsun
14.03.2016 19:29, Dimitry Sibiryakov wrote: > 14.03.2016 18:12, Alex Peshkoff wrote: >> But use of by name search if ID is unusable due to file not >> exists appears unavoidable. > > Not true. Thread that is going to create file must do it while keeps db > list mutex. In > this case it can be

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-14 Thread Vlad Khorsun
14.03.2016 20:34, Leyne, Sean wrote: > Alex, > >> Sean, if we limit ourself to only already opened files - we have no problems. >> But there are places (like per-database config) where we are not sure does >> file exist and if yes is it opened or not. For posix (where file ID exists no >> matter is

Re: [Firebird-devel] RFC: File names with non-ASCII non-ANSI letters

2016-03-15 Thread Vlad Khorsun
15.03.2016 14:05, Dimitry Sibiryakov wrote: >In attachment you can find patch for CORE-3172 and another one that adds > minimal support for unicode database names into engine. You moved class WideCharBuffer into os_utils, as suggested, it is ok. But why you not included it into namespace o

Re: [Firebird-devel] Firebird support for "newer" compilers & SDKs / especially on Windows & MacOS X

2016-03-19 Thread Vlad Khorsun
15.03.2016 22:13, Dmitry Yemanov wrote: > 15.03.2016 18:37, Lionel Elie Mamane wrote: >> >> Short version: will Firebird (2.5? 3? latest?) in general be kept >> compatible with the latest major compilers (within a reasonable time >> of their release) for each platform for the foreseeable future? >

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-22 Thread Vlad Khorsun
20.04.2013 21:24, Nikolay Samofatov wrote: > Hello, All! > > We use NBACKUP for physical replication of the databases. For that we added 2 > features: > > 1) We only read one sector (with header) of each page when scanning for > changes. This is helpful for > SSD media and might provide 4x-32x sp

Re: [Firebird-devel] Restoring DB into shutdown state

2016-03-23 Thread Vlad Khorsun
23.03.2016 9:23, Jiří Činčura wrote: > Hi *, > > Is there a SPB combination to restore database and keep it in shutdown? > Hence manually requiring to online it? There is no direct way to do it (probably it could be a useful new feature), but you may put db i shutdown before backup and it will

Re: [Firebird-devel] Restoring DB into shutdown state

2016-03-23 Thread Vlad Khorsun
23.03.2016 10:22, Alex Peshkoff wrote: > On 03/23/2016 11:15 AM, Vlad Khorsun wrote: >> 23.03.2016 9:23, Jiří Činčura wrote: >>> Hi *, >>> >>> Is there a SPB combination to restore database and keep it in shutdown? >>> Hence manually requiring to onlin

Re: [Firebird-devel] Restoring DB into shutdown state

2016-03-23 Thread Vlad Khorsun
23.03.2016 10:28, Jiří Činčura wrote: > I can't even backup database in shutdown mode. There is few shutdown mode's. Default one is "multi-user maintenance" and it not prevents backup. If you need something non-default - specify it explicitly. Regards, Vlad --

[Firebird-devel] Atomics

2016-03-23 Thread Vlad Khorsun
All, in new codebase (v4) we going to use atomic operations more intensively than before. The question is: could we use standard features of C++11 or should choose some 3rd party library (such as libatomic_ops) for it ? The main concern about C++11 atomics is - if all platforms where Firebi

Re: [Firebird-devel] Atomics

2016-03-23 Thread Vlad Khorsun
23.03.2016 11:19, Alex Peshkoff wrote: > On 03/23/2016 12:04 PM, Vlad Khorsun wrote: >> All, >> >> in new codebase (v4) we going to use atomic operations more intensively than >> before. The question is: could we use standard features of C++11 or should >> ch

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-23 Thread Vlad Khorsun
23.03.2016 14:32, Dmitry Kuzmenko wrote: > Здравствуйте! > > Tuesday, March 22, 2016, 4:40:23 PM, you wrote: >>> 2) We added option into NBACKUP utility to create change set based on >>> baseline GUID rather than level. > > VK>Basic tests show it works :) If anyone have idea how to improve it

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-23 Thread Vlad Khorsun
23.03.2016 17:01, Dmitry Yemanov wrote: > 23.03.2016 17:43, Vlad Khorsun wrote: >> >> apply new increment to the target database: >>nbackup -INPLACE -R target.fdb source-inc.nbk > > Wouldn't something like "nbackup -merge" be more user-frie

Re: [Firebird-devel] Atomics

2016-03-23 Thread Vlad Khorsun
23.03.2016 16:59, Jim Starkey wrote: > On 3/23/2016 5:04 AM, Vlad Khorsun wrote: >> All, >> >> in new codebase (v4) we going to use atomic operations more intensively than >> before. The question is: could we use standard features of C++11 or should >> choos

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-24 Thread Vlad Khorsun
24.03.2016 9:42, Pavel Cisar wrote: > Hi, > > May I suggest to add isc_info_* code to query the backup GUID via > isc_database_info()? Parsing gstat output for it is very awful. I have same idea. I suppose it is better to return GUID in text representation, not binary, agree ? > New nbackup sw

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-25 Thread Vlad Khorsun
24.03.2016 10:56, Dmitry Yemanov wrote: > 24.03.2016 11:33, Vlad Khorsun wrote: > >>> May I suggest to add isc_info_* code to query the backup GUID via >>> isc_database_info()? Parsing gstat output for it is very awful. >> >> I have same idea. I suppose

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-25 Thread Vlad Khorsun
23.03.2016 17:31, Dmitry Yemanov wrote: > 23.03.2016 18:14, Vlad Khorsun wrote: >> >> Original patch contains just "-I" switch :) For me both "inplace" and "merge" >> are ok, let decide what to use. > > My point was to replace two sw

Re: [Firebird-devel] Physical replication using NBACKUP

2016-03-25 Thread Vlad Khorsun
24.03.2016 11:27, Simonov Denis wrote: > Vlad Khorsun wrote Wed, 23 Mar 2016 17:43:23 > +0300: > >> >> Let me show how it works. It is very simplified example, of course. >> >> Create database source.fdb. >> >> Create level-0 backup, as usual

Re: [Firebird-devel] [firebird] increment build number (773c7bf)

2016-03-26 Thread Vlad Khorsun
26.03.2016 17:43, Dmitry Yemanov wrote: > 25.03.2016 12:43, Dimitry Sibiryakov wrote: > >> 25.03.2016 10:37, Dmitry Yemanov wrote: >>> We used exactly the same approach with SVN and nobody complained about >>> polluted changelog. >> >> Because nighty commits weren't in ChangeLog and nobody cared a

Re: [Firebird-devel] Icu error with Firebird 3.0 patch

2016-04-01 Thread Vlad Khorsun
01.04.2016 10:58, Alex Peshkoff wrote: > On 03/31/2016 10:29 PM, Adriano dos Santos Fernandes wrote: >> On 31/03/2016 16:07, marius adrian popa wrote: >>> I started refactoring firebird 3.0 patch for libreoffice (updated to rc2) >>> >>> https://gist.github.com/mariuz/bcde7f783b657b2465e5 >>> >>> an

Re: [Firebird-devel] Icu error with Firebird 3.0 patch

2016-04-01 Thread Vlad Khorsun
01.04.2016 11:21, Alex Peshkoff wrote: > On 04/01/2016 11:15 AM, Vlad Khorsun wrote: >> 01.04.2016 10:58, Alex Peshkoff wrote: >>> Why at all is ICU built with fb3? >> fb3 uses pre-built binaries and data files, there is no more ICU >> sources in fb3 > >

Re: [Firebird-devel] [Firebird-checkins] [FirebirdSQL/firebird] 161500: Deploy fbclient to by default.

2016-04-01 Thread Vlad Khorsun
01.04.2016 15:39, Paul Reeves wrote: >Branch: refs/heads/B3_0_Release >Home: https://github.com/FirebirdSQL/firebird >Commit: 161500c4cac8cfc575f54e2502372f41c3bd8ff7 > > https://github.com/FirebirdSQL/firebird/commit/161500c4cac8cfc575f54e2502372f41c3bd8ff7 >Author: Paul

Re: [Firebird-devel] Version 4 and network shares

2016-04-05 Thread Vlad Khorsun
05.04.2016 18:46, Dmitry Yemanov wrote: > I'd go even further and wipe out the named pipes (aka WNET) protocol > too. I don't see any sense in it nowadays. +many Vlad -- Firebird-Devel mailing list, web interface at h

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-19 Thread Vlad Khorsun
20.04.2016 0:47, Thomas Steinmaurer wrote: ... > What else could I provide so that you can investigate the offending > thread? Full memory dump, please. Regards, Vlad -- Find and fix application performance issues fa

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Vlad Khorsun
21.04.2016 12:00, Thomas Steinmaurer wrote: >> Have you had time to look at it? Looking now, but seems you already on the way ;) >> Unfortunately this now also has happened in a production environment at >> a customer site. >> >> We did quite some testing in the trace area at Firebird 3 Alpha

Re: [Firebird-devel] Firebird 3 - Single CPU core fully utilized with Trace session

2016-04-21 Thread Vlad Khorsun
21.04.2016 13:35, Thomas Steinmaurer wrote: ... >>As you already found that fbtracemgr is OK, i guess something is not fully >> correct (or stepped on some another issue) at FB Trace Manager. Could you >> show >> how do you work with trace service ? > > The usage of the trace services in FBTM

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-26 Thread Vlad Khorsun
26.04.2016 14:12, Michal Kubecek wrote: > On Tue, Apr 26, 2016 at 12:05:44PM +0200, Dimitry Sibiryakov wrote: >> 26.04.2016 12:01, Stefan Heymann wrote: >>> So I think Michael's idea to expand the URL type database strings is a >>> good idea: >> >> No, it is just a workaround. >> Good solution will

Re: [Firebird-devel] Performance of fbclient.dll of recent snapshots

2016-04-28 Thread Vlad Khorsun
28.04.2016 18:48, Stefan Heymann wrote: >> Sean, can you confirm that there is no delay when using 3.0 fbclient >> with remote 2.5 server? > > I can confirm that: using a 3.0 fbclient to connect to a *remote* 2.5 > server is quick. The problem seems to be related to the local machine > (I didn't ma

Re: [Firebird-devel] Assertion in HEAD

2016-05-10 Thread Vlad Khorsun
10.05.2016 20:23, Alex Peshkoff wrote: > On 05/10/2016 07:54 PM, Dimitry Sibiryakov wrote: >> 10.05.2016 18:22, Alex Peshkoff wrote: >>> I think that for 32-bit systems it's time to change limit to 256Kb, for >>> 64 - to 512Kb. >> Max page size doesn't depend on bitness. Thus there is no point

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5240) Restore database with large page buffer - connection lost to database

2016-05-19 Thread Vlad Khorsun
19.05.2016 1:05, Walter R. Ojeda Valiente wrote: > As I understand, the page buffers rank is 50 to 131072 This restriction is applied for 32-bit builds only. Vlad PS Never, NEVER put whole message at the bottom of your answer !!! -

Re: [Firebird-devel] Using string.printf()

2016-05-28 Thread Vlad Khorsun
28.05.2016 15:58, Dimitry Sibiryakov wrote: >Hello, All. > >What is advantage of following code > >> string err_msg; >> err_msg.printf("INTL module '%s' is of incompatible version number %d", >> filename.c_str(), version); >> gds__log(err_msg.c_str()); >

Re: [Firebird-devel] Assertion in debug build on test bugs.core_1746

2016-06-12 Thread Vlad Khorsun
10.06.2016 17:30, Dimitry Sibiryakov wrote: >Hello, All. > >Debug build of current HEAD on Windows activates assertion in > BTR_description() with > following call stack. Should I open a ticket in tracker? Yes, with test case, pls Vlad

[Firebird-devel] [SPAM] Re: Stored procedures etc. in .NET

2016-06-27 Thread Vlad Khorsun
27.06.2016 21:51, Jiří Činčura wrote: > Hi *, > > there's something I've been working on for a few evenings and weekends. > As you might know, from Firebird 3 there's and interface to write a > plugin that allows to execute any code as stored procedure, function or > trigger. > > So why not to have

Re: [Firebird-devel] Unloading plugin

2016-07-09 Thread Vlad Khorsun
09.07.2016 13:36, Jiří Činčura wrote: > Hi *, > > can I force Firebird to unload an external engine plugin? No > Or when it happens automatically? 1 min after release of last reference Regards, Vlad -- Attend Sha

[Firebird-devel] [SPAM] Re: Intl library compatibility

2016-07-20 Thread Vlad Khorsun
20.07.2016 17:43, Dimitry Sibiryakov wrote: > 20.07.2016 16:35, Alex Peshkoff wrote: >> Does it have any practical meaning? > >If I load Firebird 3 library in embedded mode and Firebird 2.5 Embedded > engine into the > same process space, I'd prefer them not to fight with each other for intl

Re: [Firebird-devel] fbembed.lib

2016-07-20 Thread Vlad Khorsun
20.07.2016 18:39, Dimitry Sibiryakov wrote: >Hello, All. > >Where can I get import library for embedded engine for MSVC? Is building > from sources > the only option to get it? Seems so >I wonder why it isn't included into package... Nobody ask for it Regards, Vlad

Re: [Firebird-devel] Intl library compatibility

2016-07-20 Thread Vlad Khorsun
20.07.2016 18:56, Dimitry Sibiryakov wrote: > 20.07.2016 17:51, Vlad Khorsun wrote: >>Looks like bad idea: ODS 11.x used ICU 3 (for index keys on strings with >> multibyte encoding) >> while ODS 12 used ICU 5.2. If both embedded engines will use same fbintl - >>

Re: [Firebird-devel] Double deallocation in btr.cpp:falst_load()

2016-08-09 Thread Vlad Khorsun
10.08.2016 3:35, Adriano dos Santos Fernandes wrote: > Em 09/08/2016 12:46, Dimitry Sibiryakov escreveu: >> Hello, All. >> >> With applied patch f532dda9d8207e0d8cfdcd55eb916121fefedcb4, debug build >> of current >> master fails on Win64 with following call stack. >> > > This in delete_nod

[Firebird-devel] RFC: Timeouts

2016-08-17 Thread Vlad Khorsun
Hi All, There are user requests to implement statement, transaction and attachment timeouts: http://tracker.firebirdsql.org/browse/CORE-658 http://tracker.firebirdsql.org/browse/CORE-985 http://tracker.firebirdsql.org/browse/CORE-4238 More - it was decided by TTG to implement this feat

Re: [Firebird-devel] RFC: Timeouts

2016-08-17 Thread Vlad Khorsun
18.08.2016 0:58, Adriano dos Santos Fernandes wrote: > Em 17/08/2016 15:44, Vlad Khorsun escreveu: > >> >> a) Statement execution timeout >> - timeout is set in milliseconds, there is no guarantee of exact precision >>(especially under high load). The only pr

[Firebird-devel] [SPAM] Re: RFC: Timeouts

2016-08-17 Thread Vlad Khorsun
17.08.2016 22:07, Dimitry Sibiryakov wrote: > 17.08.2016 20:44, Vlad Khorsun wrote: >>- can't be greater than (non-zero) value at config > >I.e there is no way for DBA to make exceptions for some queries that are > known to be > good, but long, right? R

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 10:08, liviuslivius пишет: > Hi Vlad, > >>> I.e interactive Delphi application that fetch only really shown records >>> will get error >>> when user press "Down" key, >> >> If user fetch one record per hour - yes, such application should be >> better rewritten > > Is this query in

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 10:37, liviuslivius wrote: > > > W dniu 2016-08-18 09:26:22 użytkownik Vlad Khorsun > napisał: >> 18.08.2016 10:08, liviuslivius пишет: >>> Hi Vlad, >>> >>>>> I.e interactive Delphi application that fetch only really shown records &g

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 10:14, Dimitry Sibiryakov wrote: > 18.08.2016 8:47, Vlad Khorsun wrote: >>What about 2500 ms ? :) >> If user fetch one record per hour - yes, > >2500 ms is much less that an hour, you know... Do you intentionally mixed timeouts set by DBA and by

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 16:41, Dimitry Sibiryakov пишет: > 18.08.2016 15:33, Vlad Khorsun wrote: >>Do you intentionally mixed timeouts set by DBA and by app developer or >> you really not >> understand what is for what ? > >Yes, I don't understand. > >>Glob

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 13:04, liviuslivius wrote: > If i can start general discussion.. > > do you really use such feature in real systems? > I saw this in MSSQL environment and what was advice of DBA when someone reach > timeout? > Increase timeout settings... IIRC, default query timeout in MSSQL is 30 s

[Firebird-devel] [SPAM] Re: RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 18:08, Dimitry Sibiryakov wrote: > 18.08.2016 16:55, Vlad Khorsun wrote: >>Global timeout is a last line of defense for DBA against bad apps, wrong >> queries, >> developer mistakes, unlucky days (dropped some indices last week but now >> some queries

Re: [Firebird-devel] RFC: Timeouts

2016-08-18 Thread Vlad Khorsun
18.08.2016 18:59, Adriano dos Santos Fernandes wrote: > On 18/08/2016 11:55, Vlad Khorsun wrote: >>Global timeout is a last line of defense for DBA against bad apps, wrong >> queries, >> developer mistakes, unlucky days (dropped some indices last week but now >>

Re: [Firebird-devel] Problem cch / nbak

2016-08-31 Thread Vlad Khorsun
31.08.2016 22:26, Adriano dos Santos Fernandes wrote: > TCS test ISC_ER43_TRAN is causing this error in cch.cpp:1563: > > fb_assert(bdb->bdb_flags & BDB_nbak_state_lock); Assertions should be fixed now. Thanks, Vlad

Re: [Firebird-devel] Foreign key error even there should not be one (maybe, Weird problem in one database)

2016-09-20 Thread Vlad Khorsun
19.09.2016 14:06, Tommi Prami wrote: > Weird part was that I actually pumped the data to the empty database and it > behaved the same. > > This is more than less puzzling. > > And the Backup and restore did not help,. which also, I think, should > recreate the indexes and so on... Without rep

Re: [Firebird-devel] Stuck transaction in 2.5.6

2016-09-27 Thread Vlad Khorsun
26.09.2016 13:02, Jiří Činčura wrote: > Hi *, > > I've had quite a few occurrences of transaction being stuck on Firebird > 2.5.6 in last 7 days. Even trying to close the connection from > monitoring tables was not working. I had to kill the process. > > I was able to take a dump (actually 2, from

Re: [Firebird-devel] Fwd: [Firebird-checkins] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

2016-11-11 Thread Vlad Khorsun
11.11.2016 17:20, Alex Peshkoff wrote: > Decimal floating point numbers - first draft Great ! > This is according to FB4 roadmap - enhancement of precision of > calculations in firebird. > You can read about decfloat datatype here: > https://www.toadworld.com/platforms/ibmdb2/w/wiki/7700.decfl

Re: [Firebird-devel] (CORE-4563): Add support for Windows 8/2012 fast/low-latency "TCP Loopback Fast Path" functionality

2016-11-11 Thread Vlad Khorsun
11.11.2016 11:06, Karsten Strobel wrote: > Hi Firebird Developers! > > > > I access Firebird frequently from Windows services running on the same > machine. I have a huge number of accesses each with small > impact, many updates and inserts rather than selects. Roundtrip time is very > critical.

Re: [Firebird-devel] [FirebirdSQL/firebird] 5aede1: Decimal floating point numbers - first draft

2016-11-13 Thread Vlad Khorsun
13.11.2016 17:06, Dmitry Yemanov wrote: > 11.11.2016 18:26, Dimitry Sibiryakov wrote: > >>> - Added new datatypes: DECFLOAT(16) and DECFLOAT(34), using 64/128 bits >>> for numbers representation. >> >> What is the point of these new types? Cannot you just expand list of >> back-end storage >> for

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 16:09, Thomas Steinmaurer wrote: > Hello Simon, > >> Thomas Steinmaurer wrote Mon, 14 Nov 2016 15:03:41 >> +0300: >> >>> Hello, >>> >>> using Firebird-3.0.1.32609-0_x64_pdb.zip SuperServer on Windows 10 Prof. >>> with 16G RAM, spinning disk (7200K) and Xeon 1230 CPU (4 physical cores) >

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 20:27, Thomas Steinmaurer wrote: ... > So, with 16G RAM and an OLTP emul database with ~ 2,9G, it is still > recommended with Firebird 3 SS and the shared page cache, to rather use > a smaller number, lets say 50K and keep the FileSystemCacheThreshold at > 64K to have the file system cac

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 21:00, Thomas Steinmaurer wrote: > But still, IMHO it does not explain why additional connect request with > SS while running OLTP emul with 100 users are taking considerable time, > although they are almost instant with SC? This is not SS vs SC. This is absence vs presence of suppo

Re: [Firebird-devel] Firebird 3.0.1 - SuperServer - Scalability

2016-11-14 Thread Vlad Khorsun
14.11.2016 21:26, Thomas Steinmaurer пишет: >> >>> But still, IMHO it does not explain why additional connect request with >>> SS while running OLTP emul with 100 users are taking considerable time, >>> although they are almost instant with SC? >> >>This is not SS vs SC. This is absence vs pre

Re: [Firebird-devel] Wire protocol changes in Firebird 4?

2016-12-19 Thread Vlad Khorsun
19.12.2016 19:51, Mark Rotteveel wrote: > Are there any wire protocol changes in Firebird 4 (or planned for > Firebird 4). And if so, where can I find information on those changes? I could remember the only small change, bug fix for CORE-5296 by Alex (commit 056164ab95c0ae52c970ab6603cf54d18fbc

Re: [Firebird-devel] [B3_0_Release] Can't compile in VS2015.

2016-12-30 Thread Vlad Khorsun
Fixed Regards, 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 https://lists.sourcefor

Re: [Firebird-devel] Cancelling events

2017-01-10 Thread Vlad Khorsun
10.01.2017 17:32, Jiří Činčura wrote: > Hi, > > do I get some response on aux connection after op_cancel_events? Yes, you should got usual op_response Regards, Vlad -- Developer Access Program for Intel Xeon Phi Proc

Re: [Firebird-devel] Aux connection closed with op_disconnect?

2017-01-10 Thread Vlad Khorsun
10.01.2017 19:22, Jiří Činčura wrote: > Hi *, > > when I call op_disconnect on main connection (the one from which I got > the aux connection details), the aux connection is closed as well. Is > that how it should be? Yes, of course Regards, Vlad -

Re: [Firebird-devel] Cancelling events

2017-01-10 Thread Vlad Khorsun
10.01.2017 21:29, Jiří Činčura wrote: >>Yes, you should got usual op_response > > I get a response on main connection, not on aux. There should be > something on aux as well? I was not clear. You send op_cancel_events on main conneciton and you get response at the same main connection. If y

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-11 Thread Vlad Khorsun
Hi all, I tried it on Windows and here is my observations: - SuperServer have no problem - for Classic and SuperClassic problem is confirmed of course, operations with another DB's are not affected - the reason is that attachment doing garbage collection doesn't react on AST's: yes, it

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-11 Thread Vlad Khorsun
11.01.2017 13:18, Alex Peshkoff wrote: > Vlad, I can not reproduce initial issue in master branch on linux. > GC does not affect ability to connect to database and execute simple > queries. Does you tried classic ? Could you try fb2.5 (as i did) ? Regards, Vlad -

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-11 Thread Vlad Khorsun
11.01.2017 15:09, Alex Peshkoff wrote: > > >>> Could you try fb2.5 (as i did) ? >> Will do. >> > > On 2.5 I see approx 50% slowdown when GC is in progress. Same slowdown > is present when 'delete from test' is executed. Slowdown of what operation ? > Nothing special for GC, but must say that m

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-11 Thread Vlad Khorsun
11.01.2017 16:01, Alex Peshkoff wrote: > On 01/11/17 16:19, Vlad Khorsun wrote: >> 11.01.2017 15:09, Alex Peshkoff wrote: >>> >>>>> Could you try fb2.5 (as i did) ? >>>> Will do. >>>> >>> On 2.5 I see approx 50% slowdown when GC i

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-11 Thread Vlad Khorsun
11.01.2017 20:59, Alex Peshkoff wrote: > On 01/11/17 20:36, Vlad Khorsun wrote: ... >>> I.e. slowdown is obviously present but it's too far from being irresponsive. >> Thanks. Sad you can't reproduce it. > > I remember that long ago linux had some problems wit

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Vlad Khorsun
12.01.2017 10:24, Alex Peshkoff wrote: > On 01/11/17 23:35, Vlad Khorsun wrote: > >>>> I do it easily. AST thread is blocked at >>>> Database::Sync::lock on syncMutex.enter() despite of a lot of checkouts in >>>> worker >>>> thread. >&g

Re: [Firebird-devel] op_exit/op_disconnect in aux connection

2017-01-12 Thread Vlad Khorsun
12.01.2017 12:25, Jiří Činčura пишет: > Hi *, > > I'm looking at > https://github.com/FirebirdSQL/firebird/blob/master/src/remote/client/interface.cpp#L6007 > and wondering whether the server can ever send op_exit/op_disconnect on > aux connection? Is that possible? And I can somehow do it (for tes

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-5419) Index garbage collection on varchar column causes server to hang

2017-01-12 Thread Vlad Khorsun
12.01.2017 12:10, Alex Peshkoff wrote: > On 01/12/17 13:00, Vlad Khorsun wrote: >> 12.01.2017 10:24, Alex Peshkoff wrote: >>> On 01/11/17 23:35, Vlad Khorsun wrote: >>> >>>>>> I do it easily. AST thread is blocked at >>>>>> Database

Re: [Firebird-devel] Windows build of Firebird 3 is broken

2017-01-15 Thread Vlad Khorsun
15.01.2017 11:53, Mark Rotteveel wrote: > The windows build of Firebird 3 is broken (note: I haven't checked the > Firebird 4 build, might have the same problem). > > It fails when building gpre_boot, this failure is introduced in: > > commit 40f782ae3e918c4f3842571ff8064be1c4f54961 > Author: AlexP

Re: [Firebird-devel] rare segfault in fb_shutdown()

2017-01-16 Thread Vlad Khorsun
16.01.2017 15:49, Stephan Bergmann wrote: > On 01/16/2017 02:18 PM, liviuslivius wrote: >> http://www.firebirdsql.org/en/snapshot-builds/ >> or >> you can build it from code >> https://github.com/FirebirdSQL/firebird/commits/B3_0_Release > > Ah, I was looking/hoping for a reasonably small and self

Re: [Firebird-devel] RFC: Timeouts

2017-02-16 Thread Vlad Khorsun
Hi All, The code is committed at separate branch: https://github.com/FirebirdSQL/firebird/tree/timeouts Documentation is there: https://github.com/FirebirdSQL/firebird/blob/timeouts/doc/README.statement_timeouts https://github.com/FirebirdSQL/firebird/blob/ti

Re: [Firebird-devel] RFC: Timeouts

2017-02-18 Thread Vlad Khorsun
18.02.2017 1:46, Leyne, Sean wrote: > Vlad, > > >> Documentation is there: >> >> https://github.com/FirebirdSQL/firebird/blob/timeouts/doc/READM >> E.statement_timeouts >> >> https://github.com/FirebirdSQL/firebird/blob/timeouts/doc/READM >> E.session_idle_timeouts >> >> If there will be

[Firebird-devel] [SPAM] Re: RFC: Timeouts

2017-02-19 Thread Vlad Khorsun
19.02.2017 5:21, Leyne, Sean wrote: > > >>> If I read the documentation correctly, a statement which performed >>> (say) a SELECT against a table that >> > follows a NATURAL scan, which is 'paused' awaiting the next Fetch, would >> run into the timeout, even > though there is no "cost" to the eng

Re: [Firebird-devel] RFC: Timeouts

2017-02-22 Thread Vlad Khorsun
16.02.2017 12:59, Vlad Khorsun wrote: > > Hi All, > >The code is committed at separate branch: > > https://github.com/FirebirdSQL/firebird/tree/timeouts > > Documentation is there: > > > https://github.com/FirebirdSQL/firebird/blob/timeo

Re: [Firebird-devel] RFC: Timeouts

2017-02-22 Thread Vlad Khorsun
22.02.2017 16:16, Michal Kubecek wrote: > Breaks build on openSUSE Factory for me. The patch below seems to fix it > (didn't check too thouroughly so far). > > Michal Kubecek > > > --8< > diff --git a/builds/posix/firebird.vers b/

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