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

2011-04-09 Thread Vlad Khorsun
On 08-04-2011 13:43, alexpeshk...@users.sourceforge.net wrote: Revision: 52693 http://firebird.svn.sourceforge.net/firebird/?rev=52693view=rev Author: alexpeshkoff Date: 2011-04-08 16:43:05 + (Fri, 08 Apr 2011) Log Message: --- Use interface IBlrMessage

Re: [Firebird-devel] Feature request: database registration via aliases.conf, databases system table support

2011-04-13 Thread Vlad Khorsun
How is this feature related to upcoming support for schemas? This feature have nothing common with schema support. Regards, Vlad PS Access to the aliases list via new service seems enough as for me. -- Forrester

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-16 Thread Vlad Khorsun
I spend some time for revision and adaption of your copy of ICU library for VS2010 Thanks 1. Reduce number of compiler warnings I defined the _CRT_SECURE_NO_WARNINGS=1 in firebird2intl.props Good change, imho 2. Creation of PDB files for all binaries (debug/release) Not

Re: [Firebird-devel] The boot build again

2011-04-17 Thread Vlad Khorsun
Hello, I will continue making noise until I'm explained how the new build system is supposed to work. I'm tired of checking for possible differences between the VC10 and VC8 projects and my VC9 project. I found no differences between VC8 and VC9 (except of usage of manifest files and file

Re: [Firebird-devel] Index is corrupt (missing entries) in table

2011-04-20 Thread Vlad Khorsun
However, the important thing to note is, that backing up and restoring does not rectify the problem! Backing up and restoring finish their respective jobs without problems, but the validation problem is *immediately* there (i.e. without any usage of the DB between restoring and validating).

Re: [Firebird-devel] discussion about real fix for CORE-2348

2011-04-29 Thread Vlad Khorsun
I see that there this problem was analized completly More-or-less Is this really plan to fix this in FB3.0 None, AFAIK Vlad Korshun say that only transaction id will be unsigned int in FB3.0 - is this true or is in plan to fix this with two record header versions or other

Re: [Firebird-devel] ICU. VS2010 project files

2011-04-29 Thread Vlad Khorsun
we must provide binaries inside our Windows package :( Yes, that is right. I don't object to agreeing on a specific version of ICU for each release. We would just change the build script as required. (Presumably we will need .lib files.) Our main problem is likely to be finding icu

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Vlad Khorsun
All metadata objects moved into Attachment. Metadata syncronization is guarded by attachment's mutex now. Database::SyncGuard and company are replaced by corresponding Attachment::XXX classes. To make AST's work we need to release attachment mutex sometimes. This is very important change

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Vlad Khorsun
In this case may I suggest to use separate memory pool for the cache's elements?.. It is already separate Someday someone could implement shared memory pool... It is already shared ;) Regards, Vlad --

Re: [Firebird-devel] Shared page cache

2011-05-10 Thread Vlad Khorsun
Are there any database-level ASTs known to implicitly access the attachments? When should they lock the appropriate mutex? Database-level ASTs not need to access attachment internals usually. Usually differs from always :-) I seem to remember cases when the AST saves lck_attachment into

Re: [Firebird-devel] Shared page cache

2011-05-13 Thread Vlad Khorsun
-Original Message- From: Vlad Khorsun [mailto:hv...@users.sourceforge.net] Sent: Lunes, 09 de Mayo de 2011 6:07 To avoid contention on common dbb_pool its usage was replaced by att_pool when possible. To make this task slightly easy there was introduced jrd_rel

Re: [Firebird-devel] Semantics of release

2011-05-16 Thread Vlad Khorsun
On 05/16/11 20:33, Vlad Khorsun wrote: Could you explain, please, semantics of addRef/release on public provider interfaces? The issue was discussed on this list with two possibilities: - when refCount = 1, release does things like detach, rollback, free, etc. It's what was implemented so

Re: [Firebird-devel] Semantics of release

2011-05-16 Thread Vlad Khorsun
On 16/05/2011 13:33, Vlad Khorsun wrote: So, if code calls attach\release - this is bug, as for me, and i see no reasons to write code in this way intentionally. I consider at as very bad practice as it could lead to the inexpected side effects (such as implicit rollback). Now every

Re: [Firebird-devel] Firebird 3, Engine12 exists, but can not be loaded

2011-05-16 Thread Vlad Khorsun
I downloaded the Firebird-3.0.0.29349 snapshot of firebird, for a test. After unzipping the archive, I ran Firebird from the command prompt by: firebird.exe -a No errors were written to firebird.log at that moment, but as soon as I want to connect to a database using ISQL I have the

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Vlad Khorsun
PS: There is a paper (http://www.aristeia.com/Papers/DDJ_Jul_Aug_2004_revised.pdf) from Scott Meyers and Andrei Alexandrescu showing even or volatile usage in base classes are wrong. Unfortunately it's down. With MSVC we are safe as we use volatile and compiler used read\write memory

Re: [Firebird-devel] Semantics of release

2011-05-17 Thread Vlad Khorsun
On 17-05-2011 19:58, Vlad Khorsun wrote: PS: There is a paper (http://www.aristeia.com/Papers/DDJ_Jul_Aug_2004_revised.pdf) from Scott Meyers and Andrei Alexandrescu showing even or volatile usage in base classes are wrong. Unfortunately it's down. With MSVC we are safe as we use

Re: [Firebird-devel] File system cache vs. Firebird page cache?

2011-06-10 Thread Vlad Khorsun
So, what I'm saying is that MaxFileSystemCache may be useful for classic as well, in some situations. I haven't tried it though. Still on 2.1. And you speak about FileSystemCacheSize setting which was introduced in v2.5 and allows to limit size of file system cache. This is system-wide

Re: [Firebird-devel] nbackup: CORE-3521 and CORE-2648

2011-07-14 Thread Vlad Khorsun
Hello, currently investigating nbackup reliability/bugs. CORE-2648 is marked as fixed in 2.1.4 and CORE-3521, which is currently open, seems to like similar (forced writes vs. flushing to disc). How do they differ? CORE-2648 set FW mode for delta file in the same value as of main

Re: [Firebird-devel] nbackup: CORE-3521 and CORE-2648

2011-07-14 Thread Vlad Khorsun
So, before CORE-2648 was fixed, delta file was always opened in FW=OFF mode despite of database settings. So, if the server crashes, we have a problem here? If database setting is FW = ON but (before the fix) delta file is opens with FW = OFF then Firebird crash in stalled (or

Re: [Firebird-devel] Failure to read database file in embeddeddeployment

2011-08-08 Thread Vlad Khorsun
2. Constrained by the engine i must use RootDirectory so i can set the file location. Changing the variable in the conf file had no affect. The only way i could make the RootDirectory change is by setting Environment variable, but unfortunately thats not a good for solution for my application

Re: [Firebird-devel] Failure to read database file in embedded deployment

2011-08-08 Thread Vlad Khorsun
Thanks Vlad, i tried that as well before posting here, but it didn't work. If i do get this to work, will i be able to set a relative path to the DB file? Sorry, i'm not sure i understand what does you did, what you got and what you really need. More details could help us to help you ;)

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-27 Thread Vlad Khorsun
I am currently going over the XA implementation in Jaybird, and this prompted some questions regarding transactions, connections and two-phase commit in Firebird. First of all: are transactions associated with the connection that created it, or is it possible to 'share' the same

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-28 Thread Vlad Khorsun
28.08.2011 15:52, Alex Peshkoff wrote: Certainly, we can make API look like we_do_ join a new attachment to an existing distributed transaction. To do so we just start new transaction in API call internally (need to know TPB...) and join it with existing distributed transaction. What

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-29 Thread Vlad Khorsun
The XA semantics are a bit complicated, but essentially the database is a Resource Manager (RM), and a distributed transaction is assigned an Xid by the Transaction Manager (eg in the case of JavaEE it could be the application server). If I read the spec correctly, it is expected that a

Re: [Firebird-devel] Association of transactions, connections, and two-phase commit

2011-08-30 Thread Vlad Khorsun
Look also at isc_reconnect_transaction() API which allows to re-connect to the in-limbo transaction at recovery phase and finally commit or rollback it. As far as I have seen, this is already done in Jaybird. Very good. So the commit can be done from any connection, but what

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Vlad Khorsun
At the first glance it's possible to avoid loading trigger's body with WHEN clause. Should we check permissions of trigger's code ? If yes - we will load it anyway at query (insert\update\delete) prepare time. Regards, Vlad

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Vlad Khorsun
On 10/10/11 11:53, Vlad Khorsun wrote: At the first glance it's possible to avoid loading trigger's body with WHEN clause. Should we check permissions of trigger's code ? If yes - we will load it anyway at query (insert\update\delete) prepare time. We should not check permissions

Re: [Firebird-devel] Support conditional trigger firing (WHEN clause ala Oracle)

2011-10-10 Thread Vlad Khorsun
10.10.2011 12:26, Vlad Khorsun wrote: If such clause is inside trigger code then it not affects security checks and *whole* trigger code is checked. SQL standard says something about security checks for conditional triggers ? I believe the rules are the same. In general, it's impossible

Re: [Firebird-devel] Firebird 2.5.1 Winx64 Trace problem - crash dumpavailable

2011-10-17 Thread Vlad Khorsun
Thanks to Vlad and Alex the 2.5.2 snapshot from today (Oct. 17th) works fine so far from a Trace API POV. ;-) Thanks for confirmation :) One question though, which isn't specific to the 2.5.2 snapshot. I've seen that the various fb_trace* files in e.g. c:\programdata\firebird aren't

Re: [Firebird-devel] news from kernel 3.1

2011-10-25 Thread Vlad Khorsun
25.10.2011 14:03, Adriano dos Santos Fernandes wrote: 2) FW=OFF, and use fsync on COMMIT - pages will not be reordered, and when COMMIT happens they will be written to disk in order I believe this is wrong assumption. Nobody guarantees that OS will be flushing the dirty pages from the

Re: [Firebird-devel] Lock error in CCH

2011-11-05 Thread Vlad Khorsun
Running CORE-3650 test-case in different isql embedded sessions with SharedCache and SharedDatabase, I had (one time) a hang and a crash. The crash happened after the first command. I ran it in session1, session2, session1, etc (or some variant). This is more or less expected. When shared

Re: [Firebird-devel] Still on the ext4 slowness...

2011-11-13 Thread Vlad Khorsun
On 11/14/11 02:17, Vlad Khorsun wrote: I thought about to change cache_writer in this direction - make it to do mini-flush instead of writting one page at time. But, note, we have no cache_writer thread in CS\SC and we can do a little (almost nothing) when page lock is downgraded

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

2011-11-14 Thread Vlad Khorsun
Hi Vlad, as the subject says. What's the unit for the resulting values for number of reads, writes, fetches, marks? Just want to be sure if a particular result makes sense here. ;-) Same as for isql's statistics - number of operations. Note, we have no operations on group of pages,

Re: [Firebird-devel] Trace - Character set in output

2011-11-14 Thread Vlad Khorsun
Hello, I have the following character set (ISO88591) information in the trace output: 2011-10-27T20:58:16.5210 (920:00D4DA30) COMMIT_TRANSACTION fbtm_unittest.fdb (ATT_2, FBTM:NONE, ISO88591, TCPv4:127.0.0.1)

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

2011-11-14 Thread Vlad Khorsun
- Original Message - From: Thomas Steinmaurer t...@iblogmanager.com To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Tuesday, November 15, 2011 12:11 AM Subject: Re: [Firebird-devel] Trace API - What's the unit for number of (reads |fetches ...)

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

2011-11-14 Thread Vlad Khorsun
the fbtrace.conf sample file has examples on what services names one can/should use when using e.g. the include filter. I'm not sure if the following is ok or as designed, thus I'm checking here ... I want to trace Database Stats and I tried the following include filter samples: 1)

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

2011-11-14 Thread Vlad Khorsun
- Original Message - From: Thomas Steinmaurer t...@iblogmanager.com To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Tuesday, November 15, 2011 12:43 AM Subject: Re: [Firebird-devel] Trace API - Service names in include filter? the fbtrace.conf

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 time is

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 early

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, if the crash

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 be a great

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. Why is it

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 about the error isc_dsql_cte_wrong_clause, which, for example, happens if a recursive

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

2011-11-29 Thread Vlad Khorsun
columns -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 columns. It allows to not compare

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 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 API ?

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. These cascade triggers are system triggers but are backed-up and restored. If we

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 execution

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: Times was bad

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 this hack ?

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/arrays

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 checked at

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 - certainly. But if we speak about UDR

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 and

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 Firebird

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] 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) C:\Program

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
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 header such as clear, encrypted, encryption

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 encrypted pages

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 operation. Seems you

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 encryption

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 see no problem if physical backup of half-encrypted database

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 database. It have nothing common with encryption state, and i see no problem

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, if database is in encrypting state

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 TxnType

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 user (public) data types

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

2012-05-16 Thread Vlad Khorsun
- Original Message - From: Thomas Steinmaurer t...@iblogmanager.com To: develop-list firebird firebird-devel@lists.sourceforge.net Sent: Wednesday, May 16, 2012 5:15 PM Subject: [Firebird-devel] CORE-3539 - Trace addition Hello, thanks for extending the trace output with more

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, for

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] fbclient Deadlock in ISC_event_wait

2012-06-01 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

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 for

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 now. I noticed

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 Firebird

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 to

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 will be

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 Profiler, btw. Ask

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 encryption

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] 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

Re: [Firebird-devel] Possible alignment problem

2012-09-26 Thread Vlad Khorsun
In check_duplicates (idx.cpp), there are these lines: Firebird::HalfStaticArrayUCHAR, 256 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

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. i

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 gbak: ERROR:operating system directive CreateFile failed gbak

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 CreateFile failed

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 this

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

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 shutdown via

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 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 removal

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 call a yvalve

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 short

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 revision 51742 /

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

  1   2   3   4   5   6   7   8   9   10   >