Re: [Firebird-devel] Planning the post v3 development

2014-04-29 Thread Vlad Khorsun
29.04.2014 12:03, Vlad Khorsun wrote: So, i see autocommit as only possibility, if we choose Oracle way Out of curiosity, why cannot it be done in a separate *non-system* transaction? I.e. instead of committing user transaction start we and immediately commit a new one. Technically

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-02 Thread Vlad Khorsun
OK, the alternative to record lookups is to store the transaction id in index. This would require an index insertion for all indexes defined on a table even if the key value didn't change. It would also require a corresponding index deletion for each index defined on the table when a

Re: [Firebird-devel] Questions on External Sort logic

2014-05-03 Thread Vlad Khorsun
3. Does sorting use pointers to row sort data or are the rows moved in memory during sort? Rows are moved. This is done this way to avoid duplicated record fetches (when sort results are retrieved) causing random I/O. Sorting itself may be also highly I/O bound, but it always operates

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-03 Thread Vlad Khorsun
AFAIK, transformation of string into key is up to ICU which does not provide a way for backward transformation. INTL collations are a separate beast, I'm more interested in simpler datatypes. If we could mark at least some indices as decodable, it would already be a step forward.

Re: [Firebird-devel] Cleaning up transaction info

2014-05-07 Thread Vlad Khorsun
On Wed, 7 May 2014 09:38:16 +0300, Vlad Khorsun wrote: This leads me to the questions: 1) When are prepared or rolled back transactions removed from RDB$TRANSACTIONS? Or are they kept indefinitely? Its never removed. And i see no problem with it. I was a bit wrong - when

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Vlad Khorsun
I will see if I can come up with a solution for Firebird 3 without needing RDB$TRANSACTIONS to be unprotected, but doesn't - potentially - degenerate to iterating over a list of thousands if not millions of transaction records when recovering a distributed transaction. Am i already told

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-10 Thread Vlad Khorsun
On 5/2/2014 3:25 PM, Vlad Khorsun wrote: OK, the alternative to record lookups is to store the transaction id in index. This would require an index insertion for all indexes defined on a table even if the key value didn't change. It would also require a corresponding index deletion for each

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Vlad Khorsun
On Sat, 10 May 2014 13:46:46 +0300, Vlad Khorsun wrote: Surprise : after you got list of tx numbers it can be used to query RDB$TRANSACTIONS for additional info. But then I could just as well query RDB$TRANSACTIONS directly. I don't know the Firebird transaction id: I need to identify

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Vlad Khorsun
After thinking more on it... I could (with FB 2.5 and later) also query with RDB$TRANSACTION_DESCRIPTION = X'' (where X'' is the serialized Xid I am looking for) although I wonder about its performance implications. On the other hand, recovery situations should be rare so it might

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-10 Thread Vlad Khorsun
In short: blob id which going version is referring to can cleaned only if it is not referred by both previous or next versions. All other versions are irrelevant because they cannot refer the same blob id. At least in current codebase which creates a new copy of blob content on

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-10 Thread Vlad Khorsun
10.05.2014 15:30, Vlad Khorsun wrote: Here you wrong: if blob contents was not changed by update, there will be no new blob. Yes, and in this case blob cannot be garbage collected because next record version refers to it. No need to analyze whole versions chain (collect staying

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-11 Thread Vlad Khorsun
is your scenario even possible? wouldn't the engine report an update collision when update version3 was attempted? Since tx2 is read-committed and tx4 is already committed - yes, it is possible. Regards, Vlad

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-11 Thread Vlad Khorsun
11.05.2014 0:18, Vlad Khorsun wrote: It is wrong for lost update scenario, which is allowed for read-committed transactions: att1: start tx1, insert version1 (blob1), commit tx1 att1: start tx2 (read-committed), read version1 (blob1) att2: start tx4, update version2 (blob2), commit

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-12 Thread Vlad Khorsun
11.05.2014 16:46, Dimitry Sibiryakov wrote: 11.05.2014 10:44, Vlad Khorsun wrote: It is better to write application to test it. And application should be clever enough to be able to put already read blob_id into parameter instead of creating new blob_id. I tested with attached

Re: [Firebird-devel] CORE-3515

2014-05-12 Thread Vlad Khorsun
12.05.2014 17:11, Dimitry Sibiryakov wrote: Hello, All. Similar logic as described in subj can be found also in expunge(). Record is deleted from data page first and only then garbage in index is collected. May it be another source of the problem? Sure. And this is why i

Re: [Firebird-devel] Collection of garbage in record with uncommitted version

2014-05-13 Thread Vlad Khorsun
If a record has uncommitted head version created by active transaction and some garbage in backversions tail, can anyone (background GC thread, sweep or parallel transaction) wipe this garbage from the tail while the transaction is still active? Yes I can't understand why

Re: [Firebird-devel] Collection of garbage in record with uncommitted version

2014-05-13 Thread Vlad Khorsun
13.05.2014 13:36, Vlad Khorsun wrote: Yes How? If I remember your lesson right, garbage in a record is collected only if head version is marked with transaction number lesser that OAT. This is a most often case. But, if you look at VIO_chase_record_version, you'll see

Re: [Firebird-devel] CORE-3515

2014-05-13 Thread Vlad Khorsun
12.05.2014 16:30, Vlad Khorsun wrote: Sure. And this is why i wrote recently currently used way of GC ... not 100% safe in highly concurrent environment. Can this case be fixed by moving call to delete_record() below garbage_collect()? Something like

Re: [Firebird-devel] CORE-3515

2014-05-14 Thread Vlad Khorsun
13.05.2014 14:33, Vlad Khorsun wrote: Your code will leave record with broken backversion pointer in case of failure while garbage_collect is running. To avoid this, we need to zero backpointer before garbage_collect. It also have risk to create orphan backversions but it is not a big

Re: [Firebird-devel] FIFO list

2014-05-14 Thread Vlad Khorsun
Firebird::Stack implements LIFO list. Is there a ready to use template for FIFO list? Any Array could by used as FIFO list Regards, Vlad -- Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE

Re: [Firebird-devel] Double update in trigger

2014-05-14 Thread Vlad Khorsun
Hello, All. In Firebird 3.0 following script works differently from 2.5. Is it expected side-effect of cursor stability? If you really interested in answer and respect other list members, add results of your scripts here to not force others to do what you already did. Regards,

Re: [Firebird-devel] Feature request discussion (Reply to Planning the post v3 development)

2014-05-14 Thread Vlad Khorsun
10.05.2014 14:03, Vlad Khorsun wrote: As for A-B-A updates i see no problem as there will be 3 separate index entries with own tx numbers. Currently we also have 3 index entires for such scenario, btw. Old IB's optimization to not store existing key second time is not working

Re: [Firebird-devel] Double update in trigger

2014-05-14 Thread Vlad Khorsun
2.5 result: Statement failed, SQLSTATE = 22012 arithmetic exception, numeric overflow, or string truncation -Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero. -At trigger 'DBL_BOOM' line: 7, col: 4 After line 17 in file u_dbl_test.sql

Re: [Firebird-devel] Double update in trigger

2014-05-14 Thread Vlad Khorsun
14.05.2014 18:10, Vlad Khorsun wrote: I'd said it is really because cursor stability. Looks like top-level update ignores update of record with ID = 2, made by trigger. Not only this. Two new versions of the record were created instead of one (because update_in_place() wasn't

Re: [Firebird-devel] A patch to submit

2014-05-21 Thread Vlad Khorsun
I would like to submit an attached patch. It does following things: I'll look at it but don't expect quick review. Regards, Vlad -- Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-22 Thread Vlad Khorsun
Yes, it's a bit mask. See the constants: Shouldn't it be present in RDB$TYPES, as all other special numbers ? Regards, Vlad -- Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run

Re: [Firebird-devel] DDL Triggers, how to retrieve type?

2014-05-23 Thread Vlad Khorsun
23.05.2014 12:43, Dimitry Sibiryakov wrote: 23.05.2014 11:29, Alex Peshkoff wrote: It's not absolutely required to have bigint column - it's enough to store bit number, which is less than 64. It makes impossible to use JOIN to retrieve trigger's type via SQL query. In this case there

Re: [Firebird-devel] fb_inet_server on Linux hangs instead of returning the error on this query

2014-06-20 Thread Vlad Khorsun
we've started validation of FB built on Linux and we met this situation: fb_inet_server hangs instead of returning the error on this query: insert into s select * from s It not hungs, it insert rows until disk have space :) What kind of error do you expect here ? It is well known

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-23 Thread Vlad Khorsun
21.06.2014 0:52, Nikolay Samofatov wrote: Hello, All! We have encountered subtle errors and data corruptions when using complex triggers/stored procedures in READ COMMITTED transactions. I assume you tell about logical data corruptions, not physical, correct ? Most applied programmers

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-25 Thread Vlad Khorsun
AFAIK, concurrent GC in pre-committed transactions without transaction lock was unsafe, and created permanently broken databases. I believe corruption has become especially apparent after commit intended to fix CORE-3515. I don't know who fixed it, but Red Soft builds include a patch for

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-26 Thread Vlad Khorsun
25.06.2014 12:52, Dimitry Sibiryakov wrote: 25.06.2014 11:46, Roman Simakov wrote: 2014-06-25 12:09 GMT+04:00 Dimitry Sibiryakov s...@ibphoenix.com: In this case why to use READ COMMITED transaction at all?.. Because opening cursor is not opening transaction. You can have long transaction

Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

2014-06-26 Thread Vlad Khorsun
23.06.2014 20:41, Nikolay Samofatov wrote: Hello, Dmitry! On 06/23/2014 04:15 AM, Dmitry Yemanov wrote: 21.06.2014 01:52, Nikolay Samofatov wrote: I attach patch for this functionality to give you an idea of implementation. It depends on a couple other changes so it doesn't apply to FB2.5

Re: [Firebird-devel] GetPlugins() and failed plugin

2014-07-01 Thread Vlad Khorsun
01.07.2014 9:40, Alex Peshkoff wrote: On 06/30/14 17:50, Dimitry Sibiryakov wrote: 30.06.2014 15:44, Alex Peshkoff wrote: On 06/30/14 17:40, Dimitry Sibiryakov wrote: It makes issues with plugins harder to detect and diagnose. Yes, but the reason was also rather strong - make it

Re: [Firebird-devel] setCursorName in IResultSet rather thanIStatement

2014-07-24 Thread Vlad Khorsun
- Original Message - From: Mark Rotteveel m...@lawinegevaar.nl To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Thursday, July 24, 2014 7:35 PM Subject: Re: [Firebird-devel] setCursorName in IResultSet rather thanIStatement On 23-7-2014 17:59,

Re: [Firebird-devel] setCursorName in IResultSet rather than IStatement

2014-07-24 Thread Vlad Khorsun
On 24-7-2014 19:27, Vlad Khorsun wrote: As far as I understand it, you can't have an IResultSet unless the result set is open, so setting the cursor name on an IResultSet is not very logical. What about more than one simultaneously active result set produced by the same statement

Re: [Firebird-devel] New Interface

2014-08-10 Thread Vlad Khorsun
However, apparently FB devs don't think it's important to keep it in sync with the C++ interface - even if third parties could submit patches for that. This is not true Regards, Vlad -- Firebird-Devel mailing

Re: [Firebird-devel] New Interface

2014-08-11 Thread Vlad Khorsun
11.08.2014 15:36, Dimitry Sibiryakov wrote: 11.08.2014 13:39, Vlad Khorsun wrote: As you already 'discovered' absence of not needed QueryInterface in our classes, you should understand why it was not a mistake. It wasn't a mistake for Delphi only. It failed for FPC. I don't have

Re: [Firebird-devel] New Interface

2014-08-11 Thread Vlad Khorsun
11.08.2014 17:47, Dmitry Yemanov wrote: 11.08.2014 18:18, Jim Starkey wrote: Since plugins pretty much need to be compiled with the same compiler as the engine Very questionable requirement. I can easily expect plugins written in Delphi. Agree. More, there is no reason to use same C++

Re: [Firebird-devel] Usage of BLB_large_scan

2014-09-08 Thread Vlad Khorsun
07.09.2014 17:27, Dimitry Sibiryakov wrote: Hi, All. I see that flag large scan is set for blob reading only if reader is gbak or size of blob is bigger than page cache. Doesn't it mean that reading of BLOB that is little smaller than page cache will flush whole shared cache

Re: [Firebird-devel] Usage of BLB_large_scan

2014-09-08 Thread Vlad Khorsun
08.09.2014 10:20, Dimitry Sibiryakov wrote: 08.09.2014 8:37, Vlad Khorsun wrote: Corresponding number of LRU pages will be evicted, yes. I cannot imagine an application pattern that read the same BLOB repeatedly. Can you? May be it has sense to cache only BLOB pointer pages

Re: [Firebird-devel] RFC: Data page allocation algorithm

2014-09-18 Thread Vlad Khorsun
All Implementation is committed (see CORE-4556). Regards, Vlad PS ODS changed ! -- Slashdot TV. Video for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471iu=/4140/ostg.clktrk

Re: [Firebird-devel] Firebird 3 memory manager

2014-09-23 Thread Vlad Khorsun
In a similar vein, if Firebird is still using the venerable Quick Sort that a coded more or less straight from Knuth, Volume 2, in 1984, see Bentley McIlroy's Engineering a Sort Function for a must faster version. If anyone is interested, I've turned it into a C++ template, which I'd be

Re: [Firebird-devel] TCP Loopback fast path in Windows

2014-09-29 Thread Vlad Khorsun
26.09.2014 13:27, marius adrian popa : I have seen this patch for openjdk http://mail.openjdk.java.net/pipermail/net-dev/2014-September/008685.html Maybe is worth to be implemented in Firebird also

Re: [Firebird-devel] Firebird 3, adding users via gsec, again

2014-10-06 Thread Vlad Khorsun
06.10.2014 12:48, Martijn Tonies (Upscene Productions) wrote: 06.10.2014 11:34, Martijn Tonies (Upscene Productions) wrote: Any clue? Add -user SYSDBA Same error: C:\Program Files\Firebird\Firebird_3_0gsec -add SYSDBA -pw masterkey -user SYSDBA An error occurred while attempting to add

Re: [Firebird-devel] Rules are not reduced

2014-10-10 Thread Vlad Khorsun
09.10.2014 18:02, Alex Peshkoff wrote: On 10/09/14 16:57, Dimitry Sibiryakov wrote: Hello, All. Is following warning safe? Generating parse.cpp and dsql.tab.h warning - the symbol db_ddl_privilege is undefined C:\Users\SD\MYDOCU~1\firebird\temp\Win32\debug\btyacc\btyacc: 2 rules

Re: [Firebird-devel] Thought about constraint declarations for V4

2014-10-28 Thread Vlad Khorsun
When we decided not to validate constraints on declaration, our reasoning was that computations and database access were expensive and any decent application programmer or DBA would always validate constraints before declaring them and control access to the constrained items until the

Re: [Firebird-devel] Visual Studio Community 2013

2014-11-18 Thread Vlad Khorsun
18.11.2014 17:39, Adriano dos Santos Fernandes wrote: On 18/11/2014 09:00, Mark Rotteveel wrote: While it makes sense to have a single official VS projects files based on a fully free VS, since Microsoft do not learned how to support the same files in multiple versions, it does not have any

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 11:01, liviuslivius wrote: Hi, I downloaded today FB 3.0.0.31439 - but i can not connect to it And i do not see 3050 listen port with netstat -a I try also run firebird.exe -a - without succes - it start but not listen 3 days ago there were no problems. environment WinXP 32bit I

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 11:42, Michal Kubecek wrote: On Wed, Nov 19, 2014 at 10:01:32AM +0100, liviuslivius wrote: I downloaded today FB 3.0.0.31439 - but i can not connect to it And i do not see 3050 listen port with netstat -a Does setting RemoteBindAddress 127.0.0.1 in firebird.conf help? No. And

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 12:00, Mark Rotteveel wrote: On Wed, 19 Nov 2014 11:44:56 +0200, Vlad Khorsun hv...@users.sf.net wrote: Lets play devils advocate: Do we want to continue to support Windows XP? It is end-of-life, no longer receives security updates and should therefor be considered insecure

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 12:52, Mark Rotteveel wrote: On Wed, 19 Nov 2014 12:44:04 +0200, Vlad Khorsun hv...@optima.com.ua wrote: 19.11.2014 12:30, Mark Rotteveel wrote: On Wed, 19 Nov 2014 12:19:36 +0200, Vlad Khorsun hv...@users.sf.net wrote: Do you really propose us to drop support of OS just

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 13:52, Michal Kubecek wrote: Could you please try attached patch? It uses AF_UNSPEC in getaddrinfo() hints whenever host string is non-empty and retries getaddrinfo() with AF_UNSPEC if AF_INET6 fails for empty host string. It doesn't look at error codes and tries to guess what

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-19 Thread Vlad Khorsun
19.11.2014 16:08, Michal Kubecek wrote: Could you check if first getaddrinfo() call returns EAI_FAMILY on Windows XP without IPv6 support? Unfortunately - no. I have no XP machine right now. The way I read the manual page it should but I would rather make sure. Agree here. Regards,

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-21 Thread Vlad Khorsun
19.11.2014 16:08, Michal Kubecek пишет: Could you check if first getaddrinfo() call returns EAI_FAMILY on Windows XP without IPv6 support? The way I read the manual page it should but I would rather make sure. On W2K3 without IPv6 i see that getaddrinfo() returns 0 and gai_result contains

Re: [Firebird-devel] Patch for mark_full()

2014-11-21 Thread Vlad Khorsun
21.11.2014 12:06, Dimitry Sibiryakov wrote: Hello, All. In current trunk if next page is already full, ppg_min_space got frozen, causin unnecessary loops in locate_space(). It is not frozen, of course, but not advanced up to the next non-full slot - here you are correct.

Re: [Firebird-devel] Patch for mark_full()

2014-11-21 Thread Vlad Khorsun
21.11.2014 12:30, Dimitry Sibiryakov wrote: 21.11.2014 11:25, Vlad Khorsun wrote: Sorry, but this is bad code. It doesn't check for number of slots on PP and allows unlimited grow of ppg_min_space. No, ppg_min_space cannot grow more than slot+1, exactly as it was in version 2.5

Re: [Firebird-devel] Snapshot 3.0.0.31439 Not listen on any port?

2014-11-21 Thread Vlad Khorsun
21.11.2014 13:11, Michal Kubecek wrote: On Fri, Nov 21, 2014 at 10:03:12AM +0200, Vlad Khorsun wrote: 19.11.2014 16:08, Michal Kubecek пишет: Could you check if first getaddrinfo() call returns EAI_FAMILY on Windows XP without IPv6 support? The way I read the manual page it should but I

Re: [Firebird-devel] Patch for mark_full()

2014-11-21 Thread Vlad Khorsun
21.11.2014 13:59, Dimitry Sibiryakov wrote: You are right Good to know :) Patch is committed, check it please. Regards, Vlad -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate!

[Firebird-devel] Wire compression and zlib on Windows

2014-11-28 Thread Vlad Khorsun
Hi all. Recently wire compression was implemented by Alex. It uses well known zlib library. On Linux zlib could be installed as a standalone package and there is no problems with its presence nor for Firebird users, nor for those who going to build Firebird. But on Windows i found no common

Re: [Firebird-devel] Wire compression and zlib on Windows

2014-11-28 Thread Vlad Khorsun
28.11.2014 14:50, Adriano dos Santos Fernandes wrote: On 28/11/2014 09:39, Vlad Khorsun wrote: Hi all. Recently wire compression was implemented by Alex. It uses well known zlib library. On Linux zlib could be installed as a standalone package and there is no problems with its

Re: [Firebird-devel] Wire compression and zlib on Windows

2014-12-01 Thread Vlad Khorsun
01.12.2014 19:41, Fabiano Kureck - Desenvolvimento SCI wrote: How can I enable wire compression? I downloaded Firebird today, and not found any documentation about that (That I can found). Windows build was committed just today, don't hurry ;) Try next snapshot build and look for

Re: [Firebird-devel] FB3 - embeded?

2014-12-09 Thread Vlad Khorsun
09.12.2014 21:58, liviusliv...@poczta.onet.pl wrote: Hi, is somwhere FB3 embeded version to download? There is no more separate embedded version. Just stop (or don't start) server and use local connection string. Regards, Vlad PS re-read the Release Notes, page 6 : The Providers

Re: [Firebird-devel] FB 3.0 Beta - How to intialize security db

2014-12-10 Thread Vlad Khorsun
10.12.2014 10:15, Alex Peshkoff wrote: Looks like server can not find/access security database, may be it locates firebird root folder incorrectly. Is there firebird info in your host's registry? a) server not used registry to locate root directory for a very long time b) client not used

Re: [Firebird-devel] GarbageCollector.cpp

2014-12-13 Thread Vlad Khorsun
13.12.2014 10:29, Claudio Valderrama C. пишет: People, can someone explain how does this work? Probably it's obvious but I couldn't find the answer myself. GarbageCollector::~GarbageCollector() { SyncLockGuard exGuard(m_sync, SYNC_EXCLUSIVE, GarbageCollector::~GarbageCollector);

Re: [Firebird-devel] Retrieving relation alias

2014-12-16 Thread Vlad Khorsun
16.12.2014 11:13, Mark Rotteveel wrote: On Tue, 16 Dec 2014 11:03:39 +0200, Vlad Khorsun hv...@users.sf.net wrote: 16.12.2014 10:27, Rudolf Grauberger wrote: I would like to read the table aliases, After call of isc_dsql_prepare() you'll have XSQLDA structure filled with all info

Re: [Firebird-devel] [PATCH] Fix using function pointer

2014-12-18 Thread Vlad Khorsun
18.12.2014 9:53, Alexey Pavlov wrote: Some times ago I'm send patch to http://tracker.firebirdsql.org/browse/CORE-4619 Will be it applied? Done. Vlad -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT

Re: [Firebird-devel] [PATCH] Mingw compilers don't support Win98

2014-12-18 Thread Vlad Khorsun
18.12.2014 10:30, Alexey Pavlov wrote: From 99c644e7ae0a87573f51d088973e6e43da944e2b Mon Sep 17 00:00:00 2001 From: Alexpux alexey.paw...@gmail.com mailto:alexey.paw...@gmail.com Date: Thu, 20 Nov 2014 20:17:46 +0300 Subject: [PATCH] Mingw don't support Win98. Done. Regards, Vlad

Re: [Firebird-devel] [PATCH] Use Win32 threads fro windows targets

2014-12-18 Thread Vlad Khorsun
18.12.2014 10:21, Alexey Pavlov wrote: Mingw also have posix threads library so to resolve conflict we need guard using posix threads for Windows. Done. Regards, Vlad -- Download BIRT iHub F-Type - The Free

Re: [Firebird-devel] MSVC build is broken

2014-12-22 Thread Vlad Khorsun
22.12.2014 16:02, Dimitry Sibiryakov wrote: c:\users\sd\my documents\firebird\extern\icu\include\unicode\umachine.h(200): error C2146: syntax error : missing ';' before identifier 'UBool' ...and so on. Could somebody fix it?.. Should be already fixed. Regards, Vlad

Re: [Firebird-devel] Are blob puts buffered?

2014-12-28 Thread Vlad Khorsun
27.12.2014 12:31, Mark Rotteveel wrote: I have a weird problem. In a test I am writing a blob of 24576 bytes. This is done in a write (isc_put_segment) of 16384 and 8192 bytes. If I subsequently query the blob for the length (isc_info_blob_total_length), I receive the correct number in the

Re: [Firebird-devel] Are blob puts buffered?

2015-01-02 Thread Vlad Khorsun
02.01.2015 17:01, Mark Rotteveel wrote: On 28-12-2014 14:07, Vlad Khorsun wrote: 27.12.2014 12:31, Mark Rotteveel wrote: I have a weird problem. In a test I am writing a blob of 24576 bytes. This is done in a write (isc_put_segment) of 16384 and 8192 bytes. If I subsequently query the blob

Re: [Firebird-devel] Are blob puts buffered?

2015-01-02 Thread Vlad Khorsun
AFAIK, client library parse info buffer anyway, so may be it should add unflushed info to the counter?.. For what ? Regards, Vlad -- Dive into the World of Parallel Programming! The Go Parallel Website,

Re: [Firebird-devel] execute statement on external role

2015-02-05 Thread Vlad Khorsun
05.02.2015 14:36, Geoff Worboys wrote: Hi, Firebird v2.5.3 I've been studying the source trying to understand the reasons behind a particular aspect of EXECUTE STATEMENT with ON EXTERNAL. Specifically, why are USER PASSWORD and ROLE tied together here? Why do you think so ? See below:

Re: [Firebird-devel] Firebird FB3 coexistence with FB2.5 - raport some errors in log

2015-02-18 Thread Vlad Khorsun
18.02.2015 15:46, liviusliv...@poczta.onet.pl wrote: To avoid this message you could start second instance with XNET disabled. To do it, specify switch -i in command line. Of course, it will disable local protocol for this instance. It is disabled in any case, btw, but you can explicitly

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Vlad Khorsun
22.03.2015 12:43, Thomas Steinmaurer wrote: I can't exactly recall concrete numbers from the past, but I wonder if Firebird can currently go beyond 10MB/s disk I/O utilization. And this is not about being limited by spinning disk and seek time (random I/O). You'll be wonder if reevaluate

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Vlad Khorsun
22.03.2015 13:44, Thomas Steinmaurer пишет: Vlad, I can't exactly recall concrete numbers from the past, but I wonder if Firebird can currently go beyond 10MB/s disk I/O utilization. And this is not about being limited by spinning disk and seek time (random I/O). You'll be wonder if

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Vlad Khorsun
17.03.2015 22:08, liviusliv...@poczta.onet.pl wrote: It would be easy if you share your current code in a github. Adriano Nothing to share for this little problem ;-) try this: //bufor GenRowsInMessage = Array[0..100] of Byte; //proc in db create procedure gen_rows_pascal (

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Vlad Khorsun
17.03.2015 11:54, liviusliv...@poczta.onet.pl wrote: After re-reading docs http://docwiki.embarcadero.com/RADStudio/XE6/en/Internal_Data_Formats#Record_Types i'd say you should not use nor special(explicit) alignment nor packed records. Just ensure you have {$A+} when record type is

Re: [Firebird-devel] Firebird 3 API demo usage with Pascal

2015-03-17 Thread Vlad Khorsun
17.03.2015 12:45, liviusliv...@poczta.onet.pl wrote: i assign it to whole record not for member by member So, you don't know what values should be in what member ? but how offsets can hange any in this representation? It show us exactly how compiler works I should do for one integer

Re: [Firebird-devel] The Power of C++11 in CUDA 7

2015-03-22 Thread Vlad Khorsun
22.03.2015 15:21, Thomas Steinmaurer wrote: I'm confused. ;-) Sorry ;) With FB 2.5.2 SC 64-bit on Windows 7 Prof. While copying a 18GB database from folder A to B on the same spinning physical disk at ~33MB/s read + ~33MB/s write, thus 66MB/s total, doing a select count(*) on that

Re: [Firebird-devel] Provider objects has different semantics than y-valve objects

2015-02-23 Thread Vlad Khorsun
22.02.2015 20:11, Adriano dos Santos Fernandes wrote: A solution must be to pass a parameter to destroy methods specifying if they should release or not the object. Must be ? I don't think so. I'm not ready to point to correct solution right now, but additional parameter is not a solution,

Re: [Firebird-devel] Sweep in FB3.0

2015-02-25 Thread Vlad Khorsun
24.02.2015 18:30, Ivan Přenosil wrote: Hi, What may be the reason that sweep does not start automatically in FB3 ? I have sweep interval set to 2, and the difference between OIT/OAT is 4. When I connect to similar database using FB2.5 I immediately see SWEEPER in rdb$attachments.

Re: [Firebird-devel] Adding sysdb - no permission for INSERT access to TABLE PLG$VIEW_USERS

2015-06-05 Thread Vlad Khorsun
05.06.2015 10:42, liviuslivius wrote: ... C:\Program Files\Firebird\Firebird_3gsec -add SYSDBA -pw masterkey -admin yes An error occurred while attempting to add the user. no permission for INSERT access to TABLE PLG$VIEW_USERS ... How can i add sysdba? What are the reall steps? You must

Re: [Firebird-devel] Regular Expression Library

2015-06-11 Thread Vlad Khorsun
11.06.2015 13:44, Adriano dos Santos Fernandes wrote: On 11/06/2015 06:08, Dmitry Yemanov wrote: 10.06.2015 21:03, Adriano dos Santos Fernandes wrote: At a first look, boost.regex is the library who can do it. It's templatized and works with iterators and traits for customization. It has

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Vlad Khorsun
30.05.2015 11:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? AFAIR, no I'd especially like to know at which point the commit is executed, and the impact this

Re: [Firebird-devel] Moving Jaybird auto-commit implementation into Firebird

2015-05-30 Thread Vlad Khorsun
29.05.2015 17:10, Maxim Smyatkin wrote: 2. Whole TestFBBlobStream family (6 tests) fails. The reason is bug in Firebird transaction engine. When transaction started in auto-commit mode actually commits (via commit_retaining) it doesn't free any resources. E.g., what happens in these tests

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 16:34, Dmitry Yemanov wrote: 01.07.2015 13:49, Vlad Khorsun wrote: Not sure what you mean by same? Let's say I change it from smallint to int. All kind of numbers have the same representation in index keys. Except BIGINT, IIRC. Correct. Regards, Vlad PS One can find

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 12:14, Jiří Činčura wrote: Hi *, Firebird allows me to change domain's datatype even if column with this domain is used in an index. Is it OK or should the index be dropped and created again? If new datatype is the same from index POV, there is no need to rebuild index.

Re: [Firebird-devel] Dropping index on domain change?

2015-07-01 Thread Vlad Khorsun
01.07.2015 13:34, Jiří Činčura wrote: If new datatype is the same from index POV, there is no need to rebuild index. Not sure what you mean by same? Let's say I change it from smallint to int. All kind of numbers have the same representation in index keys. So, in the case above there

Re: [Firebird-devel] Parsing fbtrace.conf

2015-07-28 Thread Vlad Khorsun
28.07.2015 20:12, Paul Reeves wrote: I managed to accidentally create this pseudo config file today: database mydb enabled false blah blah /database database mydb enabled true blah blah /database and was very surprised to find no trace output for mydb. After a lot of head

Re: [Firebird-devel] System tables changes in read only databases

2015-07-30 Thread Vlad Khorsun
30.07.2015 19:32, Dimitry Sibiryakov wrote: What's the point to have system transaction read-write? I will celebrate when (if) it will be readonly. Regards, Vlad -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] System tables changes in read only databases

2015-07-30 Thread Vlad Khorsun
30.07.2015 19:01, Adriano dos Santos Fernandes пишет: Hi! I purposely put a MODIFY of system tables in epp file without considering dbb-readOnly() flag. And it worked (changed the database) and committed the change. Shouldn't that be prevent in lower layers? Then I chmod -w the database.

Re: [Firebird-devel] Preventing error code collision

2015-07-26 Thread Vlad Khorsun
26.07.2015 12:08, Mark Rotteveel wrote: On 25-7-2015 15:08, Vlad Khorsun wrote: 25.07.2015 15:45, Mark Rotteveel wrote: How would I go about that if none of the errors in that facility are defined inside Firebird, We could define and reserve facility code for Jaybird and let you

Re: [Firebird-devel] Preventing error code collision

2015-07-27 Thread Vlad Khorsun
27.07.2015 1:24, Ann Harrison wrote: On Sun, Jul 26, 2015 at 5:15 PM, Vlad Khorsun wrote: Or is there a reason to ignore those higher bits for the facility and code? I have no idea why ENCODE_ISC_MSG written in this way. CLASS_MASK seems to not be used

Re: [Firebird-devel] Preventing error code collision

2015-07-25 Thread Vlad Khorsun
25.07.2015 14:57, Mark Rotteveel wrote: Up to now Jaybird has always used the Firebird error codes, or specific error messages defined in code. I am currently looking into defining some Jaybird specific error codes, with associated messages and SQL states. Are you going to report is using

Re: [Firebird-devel] Problems with fresh install and gsec

2015-07-15 Thread Vlad Khorsun
14.07.2015 16:09, Carlos H. Cantu wrote: I just downloaded today's Win32 FB 3 snapshot (Firebird-3.0.0.31940-0_Win32.7z) and extracted it to an empty directory. When I try gsec -add sysdba -pw masterkey -user sysdba (no Firebird process running), the command prompt never return. Should

Re: [Firebird-devel] Firebird 3.0 B2 (and lastsnapshot)fbclient.dll(Win32) slow unload?

2015-10-28 Thread Vlad Khorsun
28.10.2015 13:42, Mark Rotteveel wrote: > I notice that you use the new API. What happens if you use the old API? Speaking about *dll unload* - i think nothing should be changed. Regards, Vlad -- Firebird-Devel

Re: [Firebird-devel] Firebird 3 - Trace API - Single CPU core fully occupied when stopping trace session

2015-10-26 Thread Vlad Khorsun
17.10.2015 1:21, Thomas Steinmaurer wrote: Just for info - I'll look into it Regards, Vlad -- Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] How to build release build with pdb?

2015-10-22 Thread Vlad Khorsun
21.10.2015 14:44, Dimitry Sibiryakov wrote: > Hello, All. > > Subj, actually, on Windows with MSVC 2010 Express. It is already built with .pdb files. Look in /temp Regards, Vlad -- Firebird-Devel mailing

Re: [Firebird-devel] Firebird 3.0 B2 (and lastsnapshot)fbclient.dll(Win32) slow unload?

2015-10-28 Thread Vlad Khorsun
28.10.2015 10:36, Arno Brinkman wrote: Hi, Latest snapshot build Firebird-3.0.0.32134-0_Win32.zip using the fbclient.dll Still 500ms for unloading the fbclient.dll :-( I can't reproduce it. How did you measure unload delay ? Regards, Vlad PS I've attached source code of my tiny test

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