On 30-5-2015 10:49, Maxim Smyatkin wrote:
> Oh, and it worth mentioning - I tried it only with latest FB 2.5
It breaks with Firebird 3 (a snapshot of last week). The test
TestFBDatabaseMetaData.testGetProcedureColumns hangs when executed
against Firebird 3: the entire server hangs.
The test set
On 5/31/2015 5:33 AM, Dimitry Sibiryakov wrote:
> 31.05.2015 9:17, Mark Rotteveel wrote:
>>
>> The problem is probably that there is still an active transaction at
>> that point, where before it was already committed or rolled back.
> Prepared statements are not bound to a transaction, they (an
31.05.2015 12:33, Dimitry Sibiryakov wrote:
> Prepared statements are not bound to a transaction, they (and I believe their
> existence
> locks) exists till explicitly unprepared/freed or connection ends.
Existence locks are bound to *both* statement and transaction lifetime.
Dmitry
31.05.2015 9:17, Mark Rotteveel wrote:
> On 30-5-2015 21:54, Maxim Smyatkin wrote:
>> Yes, it makes sence. I was wrong as the procedure still depends on the
>> table, so it's the intented behaviour. But what I still can't understand
>> is why did it work before? I mean, old tests were using Jaybird
On 30-5-2015 21:54, Maxim Smyatkin wrote:
> Yes, it makes sence. I was wrong as the procedure still depends on the
> table, so it's the intented behaviour. But what I still can't understand
> is why did it work before? I mean, old tests were using Jaybird's
> AutoCommitTransaction which is just a w
Yes, it makes sence. I was wrong as the procedure still depends on the
table, so it's the intented behaviour. But what I still can't understand is
why did it work before? I mean, old tests were using Jaybird's
AutoCommitTransaction which is just a wrapper around Manageable
transaction, so it should
29.05.2015 17:10, Maxim Smyatkin wrote:
>
> - we create a procedure P using a table T.
> - the P states its interest in the T (while looking for P's dependencies);
> - transaction commits the changes with retaining flag and forgets to say
> that it isn't interested in the T anymore;
Externally (fo
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 test
Oh, and it worth mentioning - I tried it only with latest FB 2.5
On Sat, May 30, 2015 at 11:33 AM, Mark Rotteveel
wrote:
> On 30-5-2015 10:21, Maxim Smyatkin wrote:
> > Surely I would like to see the same optimization in Jaybird 3, but I'm
> > currently more interested in 2.2.*.
>
> I understand
On 30-5-2015 10:21, Maxim Smyatkin wrote:
> Surely I would like to see the same optimization in Jaybird 3, but I'm
> currently more interested in 2.2.*.
I understand and it will end up in 2.2, just not in 2.2.8 ;). This
change has some implications that I need to understand better before I
can r
Yes, that's right. Commit_retaining doesn't release acquired resources and
it shouldn't. But I still believe it's a bug in the Firebird itself,
because procedure after creation should decrement relation use count, but
it doesn't. Any of the steam blob tests fail even when executed separetely.
Surel
On 29-5-2015 16:10, Maxim Smyatkin wrote:
> Hello,
> Recently we've got an information from some company that they would like
> to use Firebird/Red Database with OpenCMS, but they couldn't afford it
> because of bad performance. We compared it with PostgreSQL and it was
> true - on some page views
Reply message -
Van: "Maxim Smyatkin"
Aan:
Onderwerp: [Firebird-devel] Moving Jaybird auto-commit implementation into
Firebird
Datum: vr, mei 29, 2015 16:10
Hello,Recently we've got an information from some company that they would like
to use Firebird/Red Database with O
Hello,
Recently we've got an information from some company that they would like to
use Firebird/Red Database with OpenCMS, but they couldn't afford it because
of bad performance. We compared it with PostgreSQL and it was true - on
some page views PG showed 4 seconds while for Firebird it was almost
14 matches
Mail list logo