Re: [Firebird-devel] Trace API - Service names in include filter?

2011-11-14 Thread Vlad Khorsun
- Original Message - From: "Thomas Steinmaurer" To: "For discussion among Firebird Developers" Sent: Tuesday, November 15, 2011 12:43 AM Subject: Re: [Firebird-devel] Trace API - Service names in include filter? >>> the fbtrace.conf sample file has examples on what services names one

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

2011-11-14 Thread Vlad Khorsun
> It would be also interesting if "reads" exposed in various places (isql, > monitoring tables, trace api) are pure physical reads from disk and/or > fetched from the OS file system cache. > > I guess, it could be also from the file system cache, because I've seen > situations where execution t

Re: [Firebird-devel] Trace API - Service names in include filter?

2011-11-14 Thread Vlad Khorsun
>>> Perhaps this is worth to be mentioned in fbtrace.conf, because one could >>> think, due to the provided list, to use Database Stats (without quotes) >>> etc. as filter? >> >> Hmm... it was so obvious for me that i even can't imagine such case ;) > > I wasn't for me, as I didn't know Vulca

Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

2011-11-14 Thread Vlad Khorsun
> Vlad, > >> PS Snapshot (concurrency) transaction guarantees that once read record >> could be read again and will be the same. So, in theory, we can just >> re-read same data page when looking for next record. > > Why "in theory"? Because i want to be careful and don't want to make too ear

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Vlad Khorsun
> Dmitry Yemanov [2011-10-25 17:55] : >> 25.10.2011 14:39, Philippe Makowski wrote: >> >>> in fact with theses settings, FW=OFF is safer than before >>> safe enough to be the default ? >> >> Even in the "paranoid mode" (MaxUnflushedWrites = 1) they still don't >> guarantee the write order. So,

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Vlad Khorsun
> On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: >> On 17/11/2011 07:52, Dmitry Yemanov wrote: >>> The only way to guarantee ordered writes is to flush individual pages >>> and this is what FW=ON does. >> Or to flush group of independent pages at once, like I proposed. I think >> this can

Re: [Firebird-devel] news from kernel 3.1

2011-11-17 Thread Vlad Khorsun
> On 11/17/11 15:37, Vlad Khorsun wrote: >>> On 11/17/11 14:14, Adriano dos Santos Fernandes wrote: >>>> On 17/11/2011 07:52, Dmitry Yemanov wrote: >>>>> The only way to guarantee ordered writes is to flush individual pages >>>>> and this is

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-17 Thread Vlad Khorsun
> On 16-11-2011 22:39, Frank Ingermann wrote: >> >> ...but it leads to an endless loop/recursion (using latest Fb3 beta) >> :-( >> > > Before decide what to do, I'd like to hear Vlad about the error > isc_dsql_cte_wrong_clause, which, for example, happens if a recursive > query has a GROUP BY. >

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-18 Thread Vlad Khorsun
>>> Before decide what to do, I'd like to hear Vlad about the error >>> isc_dsql_cte_wrong_clause, which, for example, happens if a recursive >>> query has a GROUP BY. >>> >>> Why is it not allowed? >> Because standard prohibits any kind of aggregates in recursive CTE >> members. >> > Could y

Re: [Firebird-devel] Fb3: Window functions in recursive CTEs - endless recursion ?

2011-11-18 Thread Vlad Khorsun
> On 18/11/2011 05:38, Vlad Khorsun wrote: >>> On 16-11-2011 22:39, Frank Ingermann wrote: >>>> ...but it leads to an endless loop/recursion (using latest Fb3 beta) >>>> :-( >>>> >>> Before decide what to do, I'd like to hear Vlad abo

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-29 Thread Vlad Khorsun
> 28.11.2011 23:08, Adriano dos Santos Fernandes wrote: > >> No. It happens with large varchar column. So it turns back to my >> question: can we describe a column with a length we know will fit and >> will have no side effects other than just being described different? > > I believe we can and w

Re: [Firebird-devel] Created: (CORE-3672) computed index by substring function for long columns

2011-11-29 Thread Vlad Khorsun
> 29.11.2011 12:35, Vlad Khorsun wrote: > >> While i agree with you about SUBSTRING, i think the much better solution >> will be to allow to index COMPUTED BY columns. It allows to not compare >> potentially complex expressions at optimize time and to not write exactl

Re: [Firebird-devel] Created: (CORE-3672) computed indexbysubstring function for long columns

2011-11-29 Thread Vlad Khorsun
; -Original Message- >> From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] >> Sent: Martes, 29 de Noviembre de 2011 5:36 >> >> While i agree with you about SUBSTRING, i think the much >> better solution >> will be to allow to index COMPUTED BY

Re: [Firebird-devel] Created: (CORE-3672) computed indexbysubstring function for long columns

2011-11-29 Thread Vlad Khorsun
>> -Original Message- >> From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] >> Sent: Martes, 29 de Noviembre de 2011 5:36 >> >> While i agree with you about SUBSTRING, i think the much >> better solution >> will be to allow to index

Re: [Firebird-devel] Engine interface for Trace Plugin

2011-11-30 Thread Vlad Khorsun
> I may be wrong, but I'm unable to find a way how a trace plugin can call > engine to get > more information that is sent via parameters. > Particularly I'm interested in getting BLOB/array content from > trace_dsql_execute() > handler. > Is it possible to expand TraceConnection class to

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Vlad Khorsun
>> I expect the "Delphi people" will work on it. > > No way, I'm afraid. I'm quite good in Delphi, but I have no idea how to > convert C++ > classes to Delphi classes. I can help. Regards, Vlad -- Cloud Services

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Vlad Khorsun
>> I can help. > > I'm very interrested in seeing how to use the new Firebird OO API in > Delphi. We gave it a try two weeks ago and we only succeeded with the > getVersion() function ! Everything else generated errors or access > violations. Could you send to me your Delphi wrapper for the AP

Re: [Firebird-devel] CORE-3073 and downgrades

2011-12-09 Thread Vlad Khorsun
> CORE-3073 [1] requires special BLR verb meaning "get the default value > of a field". There is request to expose the same functionality in SQL > too, but doesn't matter here. > > These cascade triggers are system triggers but are backed-up and > restored. If we use new BLR on them, downgrades

Re: [Firebird-devel] CORE-3073 and downgrades

2011-12-09 Thread Vlad Khorsun
> On 09/12/2011 16:34, Vlad Khorsun wrote: >>> CORE-3073 [1] requires special BLR verb meaning "get the default value >>> of a field". There is request to expose the same functionality in SQL >>> too, but doesn't matter here. >>> >>> T

Re: [Firebird-devel] CORE-3073 and downgrades

2011-12-09 Thread Vlad Khorsun
>> We can even trow exception on execution of such verbs and suggest to >> re-create corresponding metadata object. >> >> > Hum? It will throw exception automatically, why would we need to bother > and it then? It must be parsed correctly to allow to create metadata from backup. But at e

Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)

2011-12-15 Thread Vlad Khorsun
> As I said before, ext4 performance with FW=ON is much slower than ext3, > but I now found something new. > > I've verified that with FB 2.5, TCS times was ok (0s - 3s), and only > with FB 3 they are very bad (first test takes 16s, then 12s, 8s, 7s, 7s, > etc) > > What I found is that: > > Time

Re: [Firebird-devel] Reason for slow CREATE DATABASE in FB 3 (Linux)

2011-12-15 Thread Vlad Khorsun
>>> So now we're spending time while the database is not even completely >>> created. >> >> While we can restore previous behavior (put FW ON flag at header page >> when database is created but create db file with this flag switched off) i >> prefer >> to ask - are we really want to maintain

Re: [Firebird-devel] New API? What about protocol enhancements?

2011-12-16 Thread Vlad Khorsun
> It is not actually about testing, but rather practical usability. API can > work without > any glitch, but don't provide some functions that are required for "real" > usage. As an > example - API for trace plugins which is enough for single existing plugin > but missed > access to BLOBs/a

Re: [Firebird-devel] Embedded 2.5.2 snapshot build

2011-12-24 Thread Vlad Khorsun
> It looks like the snapshots on the website do no include embedded. It is included. There is no separate packages for server\embedded. All binaries are at single common archive. Regards, Vlad -- Write once. Port to

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Vlad Khorsun
> 03.01.2012 13:00, Alex Peshkoff wrote: > >> Not sure about current state of code (you can easily check yourself), >> but quite sure that UDRs should behave exactly like classical SPs, i.e. >> it should be possible to grant rights to them. > > With the difference that these grants cannot be chec

Re: [Firebird-devel] UDRs and SQL rights

2012-01-03 Thread Vlad Khorsun
> 03.01.2012 18:06, Vlad Khorsun wrote: >> >> Who will be the CALLER if UDR function is used in SELECT statement issued by >> client ? > > CALLER is UDR itself, so this question is meaningless for me, sorry. If we speak about statements that issued by UDR - certai

Re: [Firebird-devel] Firebird Transaction ID limit solution

2012-01-04 Thread Vlad Khorsun
> How do I debug if firebird server running with code changes that we made? Are you asking how to debug applications ? Using debugger ;) > I am running fbserver.exe with "-a -p 3050 -database > "localhost:..\myDatabase.fdb"". Firebird tray icon is showing me that > nothing has been attached

Re: [Firebird-devel] Shared database access with FB 2.5 embedded with Windows service app

2012-01-17 Thread Vlad Khorsun
> I have a database with Firebird 2.5.0 embedded which I want to access > from a regular application started by the currently logged in user > (member of the local workstation administrators group) and a Windows > service application. > > I can do this just fine when going through a regular Fir

Re: [Firebird-devel] 2.1.4 final pdb - segfault/access violation

2012-02-10 Thread Vlad Khorsun
> I'm on Server 2008 and seemingly can't use drwatson anymore, so I'm trying to > use "DebugDiag", which I'm not familiar with, please excuse the poor > stacktrace. The following's from the middle of the crash report. > > Function Arg 1 Arg 2 Arg 3 Source > msvcr80!memmove+5a

Re: [Firebird-devel] Engine crashes repeatedly when lock table exceeds 2 gigabyte limit

2012-02-13 Thread Vlad Khorsun
> 11.02.2012 20:03, marius adrian popa wrote: > >> I will respond for 2) at first changing the offsets to 64bit doesn't >> look too hard replace SLONG with SINT64 >> in the lock.cpp functions >> but i might be wrong so i leave the core dev if is easy > > First of all, this must be conditional de

Re: [Firebird-devel] Firebird 3 - Trace API - Status Quo compared to FB2.5?

2012-03-20 Thread Vlad Khorsun
> tried the Trace API in Firebird 3 and it a quick test showed, it > basically works. The obvious change in V3 is that the trace > configuration syntax/content has been changed slightly. Yes, we now using common configuration file format in all places. > Are there already any other changes

Re: [Firebird-devel] Firebird 3 - Problem in FREE_STATEMENT trace output

2012-03-30 Thread Vlad Khorsun
> On 03/30/12 09:32, Thomas Steinmaurer wrote: >> Hello, >> >> have a few occurences of the following in a Firebird 3 (Build: 29892) >> trace output. >> >> 2012-03-30T07:28:46.6410 (952:03822F68) FREE_STATEMENT >> tourism.fdb (ATT_162, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) >>

Re: [Firebird-devel] Firebird 3 - Problem in FREE_STATEMENT trace output

2012-03-30 Thread Vlad Khorsun
> have a few occurences of the following in a Firebird 3 (Build: 29892) > trace output. > > 2012-03-30T07:28:46.6410 (952:03822F68) FREE_STATEMENT > tourism.fdb (ATT_162, TOURISM:NONE, UNICODE_FSS, TCPv4:127.0.0.1) > C:\Program Files (x86)\Upscene Productions\Database Workbench 4

Re: [Firebird-devel] tool for encrypting database initially (andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
> To work with encrypted database file we need a tool to encrypt database. > I see 3 possible solutions for it. In all 3 cases some plugin dependent > parameter may be passed to plugin. In all cases one may use decrypt > instead encrypt to make Encryption must be resistent to the database shut

Re: [Firebird-devel] tool for encrypting database initially (andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
> 03.04.2012 10:44, Vlad Khorsun wrote: >> To not read whole database searching >> for the not encrypted pages after restart i offer to store last encrypted >> page number >> at header page (also, obviously, we need to store encription state on the >> head

Re: [Firebird-devel] tool for encrypting database initially(andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
> VK> Encryption must be resistent to the database shutdown\server restart > and so on. > VK> Therefore it must be restartable. As we going to add "encrypted" flag for > each page > VK> we can know pages that already encrypted. To not read whole database > searching > VK> for the not encrypt

Re: [Firebird-devel] tool for encrypting databaseinitially(andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
>>> Pages itself does not need that flags - they are being written >>> in atomic way, so they can't be "in progress". > > VK> This flag is *required* to distinguish encrypted pages. I don't > understand > VK> why do you object it. > > Because I consider decryption as a "single-user" operatio

Re: [Firebird-devel] tool for encryptingdatabaseinitially(andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
- Original Message - From: "Dmitry Kuzmenko" To: "For discussion among Firebird Developers" Sent: Tuesday, April 03, 2012 1:52 PM Subject: Re: [Firebird-devel] tool for encryptingdatabaseinitially(andprobably decrypting it) > Hello, Vlad! > > Tuesday, April 3, 2012, 2:36:23 PM, you

Re: [Firebird-devel] tool for encryptingdatabaseinitially(andprobably decrypting it)

2012-04-03 Thread Vlad Khorsun
> Hello, Vlad! > > Tuesday, April 3, 2012, 2:36:23 PM, you wrote: > >>> Because I consider decryption as a "single-user" operation. Seems you >>> want people to work with DB while it is being encrypted. > > VK> Of course ! "single-user" operations is BAD in *multy-user* software, > let not

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> I suppose that simultaneous encryption (changing encryption state of DB) > and nbackup will not be possible. Why ? > Getting half-crypted DB copy is something too exotic :-) Physical backup is "physical backup", i.e. page-level copy of a database. It have nothing common with encrypti

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 10:14, Vlad Khorsun wrote: >>> Getting half-crypted DB copy is something too exotic :-) >> >> Physical backup is "physical backup", i.e. page-level copy of a >> database. It have >> nothing common with encryption state, and i se

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 10:32, Vlad Khorsun wrote: >>> On 04/04/2012 10:14, Vlad Khorsun wrote: >>>>> Getting half-crypted DB copy is something too exotic :-) >>>> Physical backup is "physical backup", i.e. page-level copy of a >>>> datab

Re: [Firebird-devel] tool for encrypting database initially (and probably decrypting it)

2012-04-04 Thread Vlad Khorsun
> On 04/04/2012 11:12, Vlad Khorsun wrote: >> Do you have better idea ? > > Yes, I do! > > If encryption detects (at start or after it) that database is in backup > mode, it stops its activity and the next-page-to-encrypt will not advance. > > At merge time

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Vlad Khorsun
> Ok, I would like to create a type. If > typedef ULONG TxnType; > is too awkward, suggest something better. Don't name it TxnType, please. It is transaction *number* and not an isolation level, for example. We already have RecordNumber and PageNumber, let be consistent. Regards, Vlad --

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Vlad Khorsun
> 17.04.2012 14:53, Claudio Valderrama C. wrote: > >> Ok, I would like to create a type. If >> typedef ULONG TxnType; >> is too awkward, suggest something better. > > TxnId or txn_id_t or something like that. Look, currently we have SLONG tra_number; // transaction number compare it with

Re: [Firebird-devel] Transaction type

2012-04-17 Thread Vlad Khorsun
> 17.04.2012 14:20, Vlad Khorsun wrote: > >> TraNumber tra_number; > > From another side, it's isc_info_tra_id in API, TRANSACTION_ID in > context variables and MON$TRANSACTION_ID in the monitoring tables :-) This is another important point. There is user POV and

Re: [Firebird-devel] Connecting to Firebird 3

2012-04-18 Thread Vlad Khorsun
> In the conf file I have uncommented: > AuthClient = Srp, Win_Sspi, Legacy_Auth This is client setting. > Am I missing an additional step to get things working with legacy > authentication? Add Legacy_Auth to the AuthServer setting Regards, Vlad -

Re: [Firebird-devel] CORE-3539 - Trace addition

2012-05-16 Thread Vlad Khorsun
- Original Message - From: "Thomas Steinmaurer" To: "develop-list firebird" Sent: Wednesday, May 16, 2012 5:15 PM Subject: [Firebird-devel] CORE-3539 - Trace addition > Hello, > > thanks for extending the trace output with more information when > something fails. > > One thing I wo

Re: [Firebird-devel] fbclient Deadlock in ISC_event_wait

2012-05-30 Thread Vlad Khorsun
> I have an application that is using Firebird DB. After running for some > time, application get stuck in following stack trace of fbclient.dll Always tell version of software you use\complain about. Information about environment also required. > In the dump, there are many thread that are

Re: [Firebird-devel] CORE-3539 - Trace addition - WARNING example

2012-05-31 Thread Vlad Khorsun
> what's needed to create a warning trace event in context of the > CORE-3539 addition? How does a WARNING output look like. The example in > the tracker is only for ERROR AT. WARNING output looks like ERROR with "WARNING" instead of "ERROR" :) You can look at CORE-3690 or CORE-3801, fo

Re: [Firebird-devel] fbclient Deadlock in ISC_event_wait

2012-05-31 Thread Vlad Khorsun
> Thanks a lot Vlad for quick response. > > Sorry for missing information. > > fbclient version is 2.1.1.17910 in Windows 2k3 Service Pack 2 x86 processor. 2.1.4 was released a while ago and 2.1.5 is expected soon. Even if there was some bug in old 2.1.1 - it is impossible to fix it there.

Re: [Firebird-devel] Trace API - Faulty database filter crashes server

2012-05-31 Thread Vlad Khorsun
> by "accident", I discovered that a faulty database filter in a trace > configuration can crash the server. Tested with a few days old Firebird > 2.5.2 Snapshot SC 64-bit on Windows. > > The used database filter doesn't make sense, but because it crashes the > server, I thought reporting here

Re: [Firebird-devel] fbclient Deadlock in ISC_event_wait

2012-05-31 Thread Vlad Khorsun
> Thanks again Vlad for clarification. > > One more clarification, is it Ok, to use differenct connection object to the > same DB simultaneously. As much as your HW allows :) Regards, Vlad -- Live Security Virtual C

Re: [Firebird-devel] Warnings

2012-06-14 Thread Vlad Khorsun
> Is it enough to agree that keeping warnings in our API is the only > correct solution? I, personally, prefer to have warnings, but, probably it should be delivered not using status-vector. If we can produce and deliver many warnings per statement (or per API call) it will be the best, as fo

Re: [Firebird-devel] Testing fix for CORE-3860 (Trace API)

2012-06-25 Thread Vlad Khorsun
> downloaded todays snapshot build. While a faulty database filter doesn't > crash the server anymore, I wonder if it is a security breach, when the > physical path of the security database is transferred to the trace > client. A typical trace output looks like that now: > > Trace session ID 1

Re: [Firebird-devel] incomplete crash report (now with mini-dump)

2012-06-27 Thread Vlad Khorsun
> Happened again this morning, and I've got a mini-dump this time; who wants it? Send me the url where i can download it Regards, Vlad -- Live Security Virtual Conference Exclusive live event will cover all the ways

Re: [Firebird-devel] Question on CORE-3656 (Trace API and sweep)

2012-06-29 Thread Vlad Khorsun
> tracing sweeps is a very nice addition, thanks! Glad you like it ;) > I can't get the detailed information about relations for the > SWEEP_PROGRESS event type though. Ooops, per-table stats was disabled in RELEASE builds for sweeper. Will fix it now. Thanks, Vlad

Re: [Firebird-devel] Question on CORE-3656 (Trace API and sweep)

2012-06-29 Thread Vlad Khorsun
> Hello Vlad, > >>> tracing sweeps is a very nice addition, thanks! >> >> Glad you like it ;) >> >>> I can't get the detailed information about relations for the >>> SWEEP_PROGRESS event type though. >> >> Ooops, per-table stats was disabled in RELEASE builds for sweeper. Will >> fix it

Re: [Firebird-devel] Extrange transaction_ID counter problem

2012-07-06 Thread Vlad Khorsun
> Hello, y write to the developer group because i'm observing a very strange > behaviour in transaction counter, > and i don't know what needed for open it in the tracker. > > I use 2.5.2 superclassic in windows 2008 server 64 bits. I have migrated one > customer from Interbase 2009 > to Fireb

Re: [Firebird-devel] Trace API: Improved PSQL tracing?

2012-07-09 Thread Vlad Khorsun
> from a previous discussion, I was told that there is no way to trace > embedded SQL statements of stored procedure / trigger. True > While this is true for regular DML statements, stored procedures calling > other procedures result in additional EXECUTE_PROCEDURE_* events, so I'm > able

Re: [Firebird-devel] Trace API: Improved PSQL tracing?

2012-07-09 Thread Vlad Khorsun
>> There is idea to add trace event for every point at PSQL module which >> was >> recognized by parser as start of some statement (the line numbers available >> at debug info\call stack). >> > > I think these ideas should not mix concepts of trace with debug and > profile. So for what it

Re: [Firebird-devel] Trace API: Improved PSQL tracing?

2012-07-09 Thread Vlad Khorsun
>>> I think these ideas should not mix concepts of trace with debug and >>> profile. So for what it will be useful? >> >> Trace *is* very useful for both debugging and profiling. > > No objections here. Especially at the absence of better tools ;-) True. >> Ask google for "SQL Server Profil

Re: [Firebird-devel] Trace API: Improved PSQL tracing?

2012-07-10 Thread Vlad Khorsun
> I think that making everyone pay the cost of the overhead generated by so > many "hooks" inside the engine is a very bad idea. Are you measured trace overhead ? Compare call of a function with cost of statement execution... > For me, it would be a > great thing if all tracing and encrypt

Re: [Firebird-devel] Question on CORE-2668 (sweep info in firebird.log)

2012-07-11 Thread Vlad Khorsun
> is it expected, that OIT can be higher than OAT/OST when logging sweep > transaction counters in firebird.log? It happens if you sweep finished and there was no transactions after it, for example if you run sweep at single connection. Sweep advance OIT and Next but not touched OAT\OST. More

Re: [Firebird-devel] Firebird 2.5.2 - fb_lock_print issue/question

2012-09-04 Thread Vlad Khorsun
>> What was the problem?:-) > > You need at least one connection to the specified database. ;-) If you have lock table file to analyze and no database connections at moment, you can use -f switch instead of -d, btw. First database connection will reset lock table... Regards, Vlad --

Re: [Firebird-devel] RFC - FB 3.0 IPv6 support

2012-09-11 Thread Vlad Khorsun
> Attached is a patch series implementing IPv6 support for current HEAD. Thanks for implementing it ! > I did some testing including events handling (aux connections) and > interoperability with 2.5 and everything seemed to work correctly. But > as I could test only on Linux, I'm not sure it

Re: [Firebird-devel] Firebird 2.5.2 RC1 - Trace API - Rock solid

2012-09-18 Thread Vlad Khorsun
Thomas, Thank you for testing and feedback ! Vlad -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respon

Re: [Firebird-devel] Possible alignment problem

2012-09-26 Thread Vlad Khorsun
> In check_duplicates (idx.cpp), there are these lines: > >Firebird::HalfStaticArray tmp; > > ... > >desc1.dsc_address = tmp.getBuffer(idx_dsc_length); > > It seems there may be an alignment problem here, when idx_dsc_length <= 256. Probably > However, I'm unable to m

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Vlad Khorsun
> I don't know wether it has something to do with CORE-3940, but ... > gbak:activating and creating deferred index IDX_RMGM_IMPORT_DNA > gbak:cannot commit index IDX_RMGM_IMPORT_DNA > gbak: ERROR:operating system directive CreateFile failed > gbak: ERROR:Das Gerät ist nicht bereit.

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Vlad Khorsun
> On 4-10-2012 19:30, Vlad Khorsun wrote: >>>I don't know wether it has something to do with CORE-3940, but >> >> ... >>> gbak:activating and creating deferred index IDX_RMGM_IMPORT_DNA >>> gbak:cannot commit index IDX_RMGM_IMPORT_DNA >>

Re: [Firebird-devel] [possible SPAM] Re: ERROR:operating system directive CreateFile failed

2012-10-04 Thread Vlad Khorsun
>>> Why does Firebird return such a low level OS-dependent(?) error message >>> instead of returning a Firebird-specific message that explains what went >>> wrong (eg creating temporary files), instead of why it failed (the >>> low-level error message)? >> >>- because it was written this way many y

Re: [Firebird-devel] ERROR:operating system directive CreateFile failed

2012-10-04 Thread Vlad Khorsun
>>>I agree that sometime more context from intermediate levels could >>>help to better understand what happens. For example, when transliterate >>>error happens it is good to know assignment destination (field or >>>variable) name. I'm not sure it is easy to implement. But in the case >>>of "Cr

Re: [Firebird-devel] Fix for CORE-3034 causes server collapse under load

2012-11-01 Thread Vlad Khorsun
> Hello, All! > > The fix effectively disables JRD_reschedule calls. For example in > btr.cpp:scan() JRD_reschedule will > never yield control to another thread because it is always called with at > least one latch. > > Since AST processing in Firebird 2.5 and later requires yield of control t

Re: [Firebird-devel] Quoting single/double quotes in Trace API

2012-11-23 Thread Vlad Khorsun
> the fbtrace.conf for FB 2.5.2 states: > # String values should be enclosed into (any kind of) quotes if contains > # spaces embedded, for example: > # log_filename 'C:\Documents and Settings\Firebird\My Documents\trace.log' > # include_filter "Database Stats" > > What if the string contains sing

Re: [Firebird-devel] Quoting single/double quotes in Trace API

2012-11-23 Thread Vlad Khorsun
> On Fri, Nov 23, 2012 at 3:33 PM, Vlad Khorsun wrote: >> Backslash should work for all kind of regexp's (include_filter, >> exclude_filter, >> database name pattern). > > Should the backslash already in RegEx be handled in a specific way? The backslash is th

Re: [Firebird-devel] CTE problem

2012-12-01 Thread Vlad Khorsun
> Hi, > I asked this in the support list, but got no answer: > > > I do not understand why > > set planonly; > with recursive > CTE_CNT1 as (select 0 as I >from RDB$DATABASE >union all select I + 1 >from CTE_CNT1 >where I < 9), > > CTE_CNT2 as (select I, 0 as J >from CTE_C

Re: [Firebird-devel] Upgrade of Firebird project to new Alluraplatform

2012-12-16 Thread Vlad Khorsun
>> Ahh - understood. It's RO now. And status is still importing... >> Pavel, is not it time to ask SF for support? I understand that our repo >> is big, but at least it's 2012 now, and servers are fast. >> >> > > The Code link in http://sourceforge.net/projects/firebird/ is giving a > error no

Re: [Firebird-devel] Fwd: SourceForge Repo Clone Complete

2012-12-16 Thread Vlad Khorsun
> You and any other developers should do a fresh checkout using the new > repository location. Please, read my message about relocation. Checkout more than 10 copies of different branches looks as overkill for me. Thanks, Vlad --

Re: [Firebird-devel] Forced detach vs ON DISCONNECT triggers

2012-12-24 Thread Vlad Khorsun
> All, > > I'd like to get opinions whether the "on disconnect" triggers should be > fired in the cases when some connection is forcibly closed. > > We have a number of cases that cause a more or less asynchronous > disconnection: > > 1) server shutdown > 2) database shutdown > 3) connection s

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

2013-01-05 Thread Vlad Khorsun
05.01.2013 12:35, Dimitry Sibiryakov wrote: > 05.01.2013 10:55, Александр Пешков wrote: >> When record on a data page is garbage collected a lot of other pages are >> touched - indices >> for example. > > A dumb question: when touched pages are flushed to disk? > > a) after each single

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

2013-01-05 Thread Vlad Khorsun
05.01.2013 12:35, Dimitry Sibiryakov wrote: > 05.01.2013 10:55, Александр Пешков wrote: >> When record on a data page is garbage collected a lot of other pages are >> touched - indices >> for example. > > A dumb question: when touched pages are flushed to disk? > > a) after each single version

Re: [Firebird-devel] [firebird-support] Re: Sweep process too many writes to disc

2013-01-05 Thread Vlad Khorsun
05.01.2013 19:18, Dimitry Sibiryakov wrote: > 05.01.2013 17:43, Ann Harrison wrote: >> Err, no on three counts. The first is that there was no other activity on >> the database >> that demonstrated 1Tb of writes for a 55Gb database. The second is that >> even if there >> were conflicts, that sw

Re: [Firebird-devel] Codebase degradation

2013-03-18 Thread Vlad Khorsun
18.03.2013 19:11, Adriano dos Santos Fernandes wrote: ... >>> And this is what I saw it's required to support, but do you think the >>> current code allows it? >> As far as I know - yes, it does. > I'm not sure I understand you. More below. Let me try to explain it > , as the engines will

Re: [Firebird-devel] FB3 crash

2013-03-19 Thread Vlad Khorsun
19.03.2013 21:52, Dmitry Kovalenko wrote: > Hi > > Work with server from multiple clients [IBProvider test system]: > > firebird.exe!set_server(rem_port * port=0x, unsigned short flags=56) > Строка 5455 + 0x6 байтC++ > >firebird.exe!SRVR_main(rem_port * main_port=0x, unsigned sho

Re: [Firebird-devel] FB3 crash

2013-03-20 Thread Vlad Khorsun
> So the solution is either to check return value for NULL in > xnet_connect_wait_thread() (as inet_connect_wait_thread() does) or throw > exception instead of returning NULL, either in XNET_connect() or as deep > as in connect_server() (in src/remote/os/win32/xnet.cpp). I'm not > familiar with the

Re: [Firebird-devel] FB3 crash

2013-03-20 Thread Vlad Khorsun
>> But in v2.5 there was correct code, so bug was introduced in trunk only. >> >> So far i'm failed to see revision before 51654, i.e. before srvr_w32.cpp >> was moved >> from src/remote/os/win32 to the src/remote/server/os/win32... > > It seems to be introduced after the move, by SVN revis

Re: [Firebird-devel] FB3 crash

2013-03-20 Thread Vlad Khorsun
> I think, crash can reproduced without any problem ... Could you test just committed patch for it ? Thanks, Vlad -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDyna

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4067) Problem with "CREATE DATABASE ... COLLATION ..." and 1 dialect

2013-03-23 Thread Vlad Khorsun
> Problem with "CREATE DATABASE ... COLLATION ..." and 1 dialect > -- > > Key: CORE-4067 > URL: http://tracker.firebirdsql.org/browse/CORE-4067 > Project: Firebird Core > Issue Type: Bug

Re: [Firebird-devel] FB3: Unexpected problem [assert] with isql and fbclient [at shutdown time?]

2013-03-24 Thread Vlad Khorsun
24.03.2013 14:56, Dmitry Kovalenko wrote: There are still some issues with DLL unloading. I working on it but not finished yet. Regards, Vlad -- Everyone hates slow websites. So do we. Make your web apps faster with A

[Firebird-devel] RFC: non-expandable fields

2013-04-04 Thread Vlad Khorsun
Hi all, i wrote this RFC by request of one local company which have (as many others) wrote own replicator and got some issues which could be resolved very easy with a little support from the Firebird engine side. I think we could discuss it and determine if requested feature could add some v

Re: [Firebird-devel] RFC: human-readable DBKEY

2013-04-05 Thread Vlad Khorsun
> I'd like to propose some ways to convert DBKEY into a human-readable > form but still be able to quickly (without a full table scan) access the > record via its human-readable DBKEY. > > Primarily, it could be used to report a unique id of the offending > record in error messages allowing use

Re: [Firebird-devel] Is Firebird 3 ready?

2013-04-10 Thread Vlad Khorsun
> How about some discussion about strategic features - like the lack of > straight-forward support for clustering? With pleasure. Would you like to start one ? -- Regards, Vlad -- Precog is a next-generation analyti

Re: [Firebird-devel] Physical replication using NBACKUP

2013-04-20 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] FB binaries fail on Microsoft Platform Ready Test

2013-04-22 Thread Vlad Khorsun
> Having problem to pass the Microsoft Plattform Ready Test for Windows 8 and > Windows Server 2012 > While distribute the FB 2.5 binaries of the embedded 64 Bit version, > the Microsoft BinScope Test for the DLL raise the following issue: > > \fbembed.dll - DBCheck ( FAIL ) > Information : >

Re: [Firebird-devel] Physical replication using NBACKUP

2013-05-08 Thread Vlad Khorsun
> Patch against FB HEAD in attach. Thanks. After quick review i want to point to a trivial bug in NBackup::backup_database() short null_flag = 0; - in_sqlda->sqlvar[0].sqldata = (char*) &level; - in_sqlda->sqlvar[0].sqlind = &null_flag; + if (level >= 0) + { + in_sqlda->sqlvar[

Re: [Firebird-devel] Question about GCC and Firebird page structs

2013-05-12 Thread Vlad Khorsun
> Afternoon all, > > I have been working on a Firebird Internals manual for some time, and it > was built with the help of a small tool I wrote to dump out specific > pages from a database. The structs for each page were blatantly copied > from jrd/ods.h and when I compiled my app back then (ah

Re: [Firebird-devel] Question about GCC and Firebird page structs

2013-05-13 Thread Vlad Khorsun
> Morning Vlad, > > On 13/05/13 07:27, Vlad Khorsun wrote: > >> Looks like your ULONG is 8-byte integer while it shold be 4-byte. > > Thanks for that, I have defined the various types as follows - stolen > from somewhere in the Firebird source code. >

Re: [Firebird-devel] Firebird as backend in LibreOffice.

2013-05-13 Thread Vlad Khorsun
> I have not seen in Firebird web any comment about the intention in > LibreOffice for use Firebird as backend. > > https://wiki.documentfoundation.org/Development/GSoC/Ideas#Support_for_Firebird_Database_in_Base > > https://bugs.freedesktop.org/show_bug.cgi?id=51780 > > I am user of Firebird and

Re: [Firebird-devel] event connection lost after long inactivity

2013-06-20 Thread Vlad Khorsun
> We are experiencing problems with unreceived db events. > After some investigation found out that the connection to the event > (aux) port from the client to the server is lost and the client never > understands about that. > Many routers and firewalls automatically close idle connections a

Re: [Firebird-devel] event connection lost after long inactivity

2013-06-21 Thread Vlad Khorsun
> > PS keepalive for event's connection was turned on in year 2009 before v2.5 > > release... And backported into v 2.1.4, btw > On client side? Or only in server? On client side only Regards, Vlad -- This

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