Re: [Firebird-devel] How to? Coordinating transactions for multipleconnections in single call

2014-04-03 Thread Vlad Khorsun
> Instead of get from info and pass "everything" (possible MBs?) in the > TPB, isn't possible to pass only the "base transaction number" of cloned > transaction, and them the engine instances dumps necessary information, > like with monitoring, so the new transaction could reconstruct the snapshot?

Re: [Firebird-devel] garbage_collect_idx() doesn't work?..

2014-04-07 Thread Vlad Khorsun
> Please leave this ticket / patch up to me. This is the first reasonable idea at this branch of thread ;) Regards, Vlad -- Put Bad Developers to Shame Dominate Development with Jenkins Continuous Integration Continu

Re: [Firebird-devel] Regression: system generator RDB$BACKUP_HISTORY cannot be modified

2014-04-07 Thread Vlad Khorsun
> Unfortunately, rdb$backup_history is the only sys gen that's not modified > from an internal request. Time to use triggers and INSERT RETURNING ? :) Regards, Vlad -- Put Bad Developers to Shame Dominate Development

Re: [Firebird-devel] Regression: system generatorRDB$BACKUP_HISTORYcannot be modified

2014-04-08 Thread Vlad Khorsun
>> > Unfortunately, rdb$backup_history is the only sys gen >> that's not modified >> > from an internal request. >> >> Time to use triggers and INSERT RETURNING ? :) > > Or let VIO_store() handle rel_backup_history and do the generator increment > from set_metadata_id(). Agree. Regard

Re: [Firebird-devel] Regression: system generator RDB$BACKUP_HISTORY cannot be modified

2014-04-08 Thread Vlad Khorsun
>> >> > Unfortunately, rdb$backup_history is the only sys gen >> >> that's not modified >> >> > from an internal request. >> >> >> >> Time to use triggers and INSERT RETURNING ? :) >> > >> > Or let VIO_store() handle rel_backup_history and do the >> generator increment >> > from set_metadat

Re: [Firebird-devel] TraceAPI with Embedded and Unicode initialization problem

2014-04-16 Thread Vlad Khorsun
>> I see that icuin30.dll is tried to be loaded from various places >> (although excluding the embedded root path), but this fails. >> >> icuin30.dll is available in the embedded root directory. When I put the >> dll into the application sub-folder, then the trace output works. >> >> Can you please

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

2014-04-29 Thread Vlad Khorsun
>> I know people will feel outraged with my opinion, but anyway: make DDL >> operations atomic and immediate. This is the "Oracle way". > Atomic and immediate means autocommitted or always executed in a > separate (e.g. system) transaction? I have strong opinion that system transaction

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

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 o

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 forw

Re: [Firebird-devel] Cleaning up transaction info

2014-05-06 Thread Vlad Khorsun
> When Jaybird uses distributed transactions, it adds information on the > Xid (the distributed transaction id) in the call to isc_prepare. > > When the transaction is limbo-ed by destroying the connection, another > connection can recover that by performing a reconnect and then either > commit

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

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 tol

Re: [Firebird-devel] Cleaning up transaction info

2014-05-10 Thread Vlad Khorsun
> On Sat, 10 May 2014 10:53:05 +0300, "Vlad Khorsun" wrote: >>> 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 it

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 als

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

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 mi

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

2014-05-10 Thread Vlad Khorsun
> 10.05.2014 14:03, Vlad Khorsun wrote: >> For blob's we still need that lists, yes > > No. In my workcopy I got rid of them for blobs. The trick is not to garbage > collect > blobs that are referenced by potentially active versions in undo log. Explain, pleas

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 o

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 wh

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), re

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 bl

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

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 wh

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

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

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 or

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 FRE

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

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 k

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

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 on

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 >

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

2014-05-23 Thread Vlad Khorsun
23.05.2014 13:55, Dimitry Sibiryakov wrote: > 23.05.2014 12:48, Vlad Khorsun wrote: >> This "useless garbage" is required for self-documenting > > Self-documenting of what? Self-documenting of constants used to encode some values in system tables in database. &

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

2014-06-19 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 i

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 program

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 patc

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

2014-06-25 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 : >>>In this case why to use READ COMMITED transaction at all?.. >> >> Because opening cursor is not opening transaction. You can have long >> transaction but no

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

2014-06-25 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 >

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

2014-06-30 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 - ma

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

2014-07-24 Thread Vlad Khorsun
- Original Message - From: "Mark Rotteveel" To: "For discussion among Firebird Developers" Sent: Thursday, July 24, 2014 7:35 PM Subject: Re: [Firebird-devel] setCursorName in IResultSet rather thanIStatement > On 23-7-2014 17:59, Adriano dos Santos Fernandes wrote: >> Hi! >> >> Afte

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 simul

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 l

Re: [Firebird-devel] New Interface

2014-08-11 Thread Vlad Khorsun
11.08.2014 14:25, Dimitry Sibiryakov write: > I can't remember who did API translation for UIB, but he made a mistake > using classes > for declaration. It was me and it was not a mistake. As you already 'discovered' absence of not needed QueryInterface in our classes, you should understand

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

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 s

Re: [Firebird-devel] Usage of BLB_large_scan

2014-09-07 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 shar

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

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=160591471&iu=/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

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

2014-09-28 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 > > http://blogs.technet.com/b/wincat/archive/2012/12/05/fast-tcp-loopback-performance-and

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_0>gsec -add SYSDBA -pw masterkey -user > SYSDBA > An error occurred while att

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

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

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

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 32bi

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

2014-11-19 Thread Vlad Khorsun
19.11.2014 11:37, Mark Rotteveel wrote: > On Wed, 19 Nov 2014 11:28:15 +0200, Vlad Khorsun > wrote: ... >> Seems, recently introduced support for IPv6 doens't work in XP. >> It is currently investigated. > > Windows XP doesn't have IPv6 installed/enabled

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?

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 > wrote: >>> Lets play devils advocate: >>> Do we want to continue to support Windows XP? It is end-of-life, no >>> longer >>> receives security updates

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

2014-11-19 Thread Vlad Khorsun
19.11.2014 12:30, Mark Rotteveel wrote: > On Wed, 19 Nov 2014 12:19:36 +0200, Vlad Khorsun > wrote: >> Do you really propose us to drop support of OS just because MS did it >> ??? > > As I said: playing devils advocate. And yes, that is what I did. If you > co

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 > wrote: >> 19.11.2014 12:30, Mark Rotteveel wrote: >>> On Wed, 19 Nov 2014 12:19:36 +0200, Vlad Khorsun >>> wrote: >> >>>> Do you really prop

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

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 contain

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

2014-11-21 Thread Vlad Khorsun
21.11.2014 0:01, Michal Kubecek wrote: > So I suppose the question is: do we want to introduce a potentially > risky feature at this stage or would we rather accept the server not > being able to listen on both IPv4 and IPv6 on two platforms, one of them > already unsupported now, the other either

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 t

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?

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!

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

2014-11-22 Thread Vlad Khorsun
21.11.2014 16:45, Michal Kubecek wrote: > On Fri, Nov 21, 2014 at 02:01:09PM +0200, Vlad Khorsun wrote: >> 21.11.2014 13:11, Michal Kubecek wrote: >>> >>> That's unfortunate... I suppose the easiest way out of this would be >>> adding something like &g

Re: [Firebird-devel] Support for building Firebird with mingw-w64 toolchains.

2014-11-25 Thread Vlad Khorsun
25.11.2014 12:28, Alexey Pavlov wrote: > Finally, I'm now be able to build Firebird3 too. > > Can my patches be applied upstream? I going to check and apply them. If someone (Adriano?) already checked it and\or going to commit - let me know, please. Regards, Vlad ---

[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 pa

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

2014-12-01 Thread Vlad Khorsun
28.11.2014 13:39, Vlad Khorsun wrote: Done. Regards, Vlad -- Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with

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 doc\READM

Re: [Firebird-devel] FB 3 release notes

2014-12-08 Thread Vlad Khorsun
08.12.2014 10:03, Werner wrote: > I think there is a typo in the section "Execution Modes": > > It states: > Superserver is set up using the configuration SharedDatabase = true and > SharedCache = true > > but I think it should be, as the above contradicts the statement made in the > "Table 3.1. M

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

2014-12-08 Thread Vlad Khorsun
08.12.2014 18:22, Werner wrote: > Hi, > > I run following command (passwords changed to my liking) as per > ReleaseNotes. > gsec -modify SYSDBA -pw SomethingCryptic -user SYSDBA -password anything > > An error occurred while attempting to modify the user record. > Install incomplete, please read c

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 Archit

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

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 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, including known relation aliases. Read IB6 "API Guide", chapter "Working with Dynamic SQL". Guide is available here:

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

Re: [Firebird-devel] Fixes for recent changes

2014-12-17 Thread Vlad Khorsun
18.12.2014 9:13, Alexey Pavlov wrote: > From d437cb98a45566a51e36cf510434d2f3bd27d302 Mon Sep 17 00:00:00 2001 > From: Alexpux mailto:alexey.paw...@gmail.com>> > Date: Thu, 18 Dec 2014 10:11:09 +0300 > Subject: [PATCH] Fixes for commit "make all file descriptors, opened by > firebird, close on e

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

2014-12-18 Thread Vlad Khorsun
18.12.2014 12:01, Alexpux пишет: > >> 18 дек. 2014 г., в 11:35, Roman Simakov написал(а): >> >> Alex, >> >> I'd recommend you to prepare ONE good patch for good goal, send it as >> file ready for applying, explain why, etc >> AFAIU your message are generate automatically. But they must be read, >>

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

Re: [Firebird-devel] [PATCH] Don't use hack for mingw-w64

2014-12-18 Thread Vlad Khorsun
18.12.2014 10:28, Alexey Pavlov wrote: > From abe6a3d9f043550ebd7647422c2eeb89018caa33 Mon Sep 17 00:00:00 2001 > From: Alexpux mailto:alexey.paw...@gmail.com>> > Date: Thu, 20 Nov 2014 07:42:19 +0300 > Subject: [PATCH] mingw-w64 don't need hack for SecPkgContext_AccessToken Done. Regards, V

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 th

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

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

Re: [Firebird-devel] Missing checkins emails?

2015-01-15 Thread Vlad Khorsun
15.01.2015 9:29, Dmitry Yemanov wrote: > 15.01.2015 04:23, Adriano dos Santos Fernandes wrote: >> >> I just noted some own checkins not being sent (or received by me) in the >> mailing list. >> >> Do any of you received [60488] and [60495] revisions? > > Nope and they're missing in the SF mail arch

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

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

2015-02-18 Thread Vlad Khorsun
18.02.2015 11:18, liviusliv...@poczta.onet.pl пишет: > Hi, > > i setup Firebird 2.5 by normal setup install and set in config > RemoteServicePort = 3050 > and restart it > > then i install manually Firebird 3 > and set > RemoteServicePort = 3051 > and restart it So, you start two instances of F

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 e

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