[Firebird-devel] firebird.msg

[Paul Reeves]

I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be around 
550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta releases of Fb 
3 it is also around 150Mb.

What's happened? 


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Dmitry Yemanov]

16.09.2015 12:04, Paul Reeves пишет:
>
> I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be around
> 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta releases of Fb
> 3 it is also around 150Mb.

You surely meant KB, not MB ;-) Just checked the last (tonight's) 
snapshot of v3 - size is 148KB.


Dmitry


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Paul Reeves]

On Wednesday 16 September 2015 12:14:28 Dimitry Sibiryakov wrote:
> 16.09.2015 11:56, Vlad Khorsun wrote:
> > Just run make_boot and newly generated firebird.msg have size 148104
> > bytes.
>
>May be Paul got French one in UTF-8?..

Definitely not French but UTF-8 did cross my mind. On the other hand, I've 
looked at the file in a hex editor. Basically it looks as if the normal 
string messages stop at around offset 00024280 and then the rest of the file 
is filled with this hex sequence: 92 C1 05 FF 01 00 00 00 12 00 00 00.

Not sure what to make of it but it is not urgent for now. I'll do a fresh 
check out at some point and diff it against my code. It is my development 
tree, so maybe something I was playing with has caused the problem. I never 
do production builds from my dev tree and I never commit directly from my dev 
tree either. All my commits are made by diffing the dev tree to a fresh 
checkout, and then carefully copying over the changes to the fresh checkout 
so that each change gets committed separately with correct documentation.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Paul Reeves]

On Wednesday 16 September 2015 13:34:12 James Starkey wrote:
> > >
> > > You surely meant KB, not MB ;-)
> >
> > But hey, it was just an error of a single order of magnitude :-)
> >
> >

> Uh, try three orders of magnitude.  Even better that you're not a
> government economist.


Actually Jim, I bet you a beer that I'm more correct than you are :-) The 
difference between a Kb and a Mb is a single order of magnitude. OTOH, the 
difference between 1,024 and 1,048,576 is definitely three orders of 
magnitude. But I didn't use decimal units. 

So I guess as long as I understand the units of measurment I'm using that 
government economist job might still be open. The pay would have to be an 
order of magnitude better, mind you, and with a good early retirement 
package.


Paul
-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Paul Reeves]

On Wednesday 16 September 2015 11:35:02 Dmitry Yemanov wrote:
> 16.09.2015 12:04, Paul Reeves пишет:
> > I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be
> > around 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta
> > releases of Fb 3 it is also around 150Mb.
>
> You surely meant KB, not MB ;-) 

But hey, it was just an error of a single order of magnitude :-)

Just as well that I'm not a futures trader.


> Just checked the last (tonight's) 
> snapshot of v3 - size is 148KB.
>

Thanks - that looks to be about right. Don't know why I'm getting 550Kb. I 
thought I was doing a regular build. I'll keep an eye on this. It is not 
important for now, but I wouldn't want it to slip out into a released 
version.


Paul

-- 
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Vlad Khorsun]

16.09.2015 12:04, Paul Reeves wrote:
>
> I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be around
> 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta releases of Fb
> 3 it is also around 150Mb.
>
> What's happened?

   Just run make_boot and newly generated firebird.msg have size 148104 bytes.

Regards,
Vlad


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[James Starkey]

On Wednesday, September 16, 2015, Paul Reeves  wrote:

> On Wednesday 16 September 2015 11:35:02 Dmitry Yemanov wrote:
> > 16.09.2015 12:04, Paul Reeves пишет:
> > > I just noticed the size of firebird.msg in Fb 3 trunk - it seems to be
> > > around 550 Mb. In Fb 2.5 it is around 150 Mb and in the previous beta
> > > releases of Fb 3 it is also around 150Mb.
> >
> > You surely meant KB, not MB ;-)
>
> But hey, it was just an error of a single order of magnitude :-)
>
> Just as well that I'm not a futures trader.
>
>
> Uh, try three orders of magnitude.  Even better that you're not a
> government economist.



-- 
Jim Starkey
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Altering collation of field

[Jiří Činčura]

Hi *,

there's currently no way of altering collation of field in 2.5.4, right?
I checked all the possible documentation on firebirdsql.org and haven't
found a way. So only system table modification seems to be an option.

Let's have these two tables:
create table parent (
id bigint not null,
code varchar(512) character set utf8 not null collate utf8
);
create table foobar (
id bigint not null,
id_master bigint not null,
code computed by ((select code from parent where id = id_master))
);

Now the collation ids for both CODE column are 0, as expected:
select rdb$collation_id
from rdb$relation_fields
where rdb$field_name = 'CODE' and rdb$relation_name = 'PARENT';
select rdb$collation_id
from rdb$relation_fields
where rdb$field_name = 'CODE' and rdb$relation_name = 'FOOBAR';

Now I'll change the collation of PARENT.CODE:
update rdb$relation_fields
set rdb$collation_id = 3
where rdb$field_name = 'CODE' and rdb$relation_name = 'PARENT';

And "recreate" the FOOBAR.CODE (I'm using alter to avoid hitting
dependencies):
alter table foobar alter code computed by ((select code from parent
where id = id_master));

Now the collation id for PARENT.CODE is 3, as expected. But FOOBAR.CODE
is still 0. It doesn't even help if I "recreate" from and to:
alter table foobar alter code computed by ((select code from parent
where id = id_master + 1));
alter table foobar alter code computed by ((select code from parent
where id = id_master));

I know this is quite dirty. But I need to be able to change collation on
a field and - lucky me - the field is used in another (computed) field.
Is there a way to force system tables to "sync"? Or other way to change
collation?

-- 
Mgr. Jiří Činčura
Independent IT Specialist

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] firebird.msg

[Dimitry Sibiryakov]

16.09.2015 11:56, Vlad Khorsun wrote:
> Just run make_boot and newly generated firebird.msg have size 148104 
> bytes.

   May be Paul got French one in UTF-8?..

-- 
   WBR, SD.

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4936) Reduce internal contention in background garbage collector

[Leyne, Sean]

> Reduce internal contention in background garbage collector
> --
> 
>  Key: CORE-4936
>  URL: http://tracker.firebirdsql.org/browse/CORE-4936
>  Project: Firebird Core
>   Issue Type: Improvement
>   Components: Engine
> Affects Versions: 3.0 Beta 2, 3.0 Beta 1, 3.0 Alpha 2, 3.0 Alpha 1
> Reporter: Vlad Khorsun

Some description of the issue/change (since you tend to create cases when you 
are ready to check-in fix) would be appreciated

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4935) Increase performance of backout of dead record version (or undo of just created primary record version) when backversions chain is too long

[Vlad Khorsun]

17.09.2015 1:13, Claudio Valderrama C. wrote:
>>   Key: CORE-4935
>>   URL: http://tracker.firebirdsql.org/browse/CORE-4935
>>   Project: Firebird Core
>>
>> Another improvement is to cut and cleanup tail of the
>> back-versions chain at point where it is legal
>
> Vlad,
> did you do that second improvement, too or is it an idea to be logged
> separately in the tracker?

   Yes, it is implemented and committed at once.

Regards,
Vlad


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] Firebird package updated in Debian with reproducible builds

[marius adrian popa]

This version will make the build reproducible.
https://anonscm.debian.org/cgit/pkg-firebird/2.5.git/commit/?id=c425202385f055bb9beb67fcc8a861cb29c38917

The reproducible builds initiative aims to enable anyone to reproduce bit
by bit identical binary packages from a given source, thus enabling anyone
to independently verify that a binary matches the source code from which it
was said it was derived.
https://wiki.debian.org/ReproducibleBuilds

prune tool :
 sets the creation stamp in the database header to a fixed value (taken
   from the last changelog stanza)
prune unused space on index/data pages of shipped databases

https://anonscm.debian.org/cgit/pkg-firebird/2.5.git/tree/debian/fdb-r15y-prune.cpp
--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] [FB-Tracker] Created: (CORE-4935) Increase performance of backout of dead record version (or undo of just created primary record version) when backversions chain is too long

[Vlad Khorsun (JIRA)]

Increase performance of backout of dead record version (or undo of just created 
primary record version) when backversions chain is too long
---

 Key: CORE-4935
 URL: http://tracker.firebirdsql.org/browse/CORE-4935
 Project: Firebird Core
  Issue Type: Improvement
  Components: Engine
Affects Versions: 3.0 Beta 2, 2.5.4, 2.5.3 Update 1, 2.1.7, 3.0 Beta 1, 
2.5.3, 2.1.6, 3.0 Alpha 2, 3.0 Alpha 1, 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 
2.5.1, 2.5.0
Reporter: Vlad Khorsun


Function list_staying() used in backout and undo processes have complexity 
O(N^2), where N is the number of back versions.

There is a way to reduce complexity down to O(N) in most cases. Specifically - 
when current transaction (which does backout
or undo) already own the record (i.e. primary record version is marked by 
current transaction) there is guarantee that no other
transaction will try to backout\undo the record. 

Another improvement is to cut and cleanup tail of the back-versions chain at 
point where it is legal

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira



--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4936) Reduce internal contention in background garbage collector

[Vlad Khorsun]

17.09.2015 0:20, Leyne, Sean wrote:
>
>> Reduce internal contention in background garbage collector
>> --
>>
>>   Key: CORE-4936
>>   URL: http://tracker.firebirdsql.org/browse/CORE-4936
>>   Project: Firebird Core
>>Issue Type: Improvement
>>Components: Engine
>>  Affects Versions: 3.0 Beta 2, 3.0 Beta 1, 3.0 Alpha 2, 3.0 Alpha 1
>>  Reporter: Vlad Khorsun
>
> Some description of the issue/change (since you tend to create cases when you 
> are ready to check-in fix) would be appreciated

   Done in tracker. Feel free to ask for details if necessary.

Vlad


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4935) Increase performance of backout of dead record version (or undo of just created primary record version) when backversions chain is too long

[Claudio Valderrama C.]

>  Key: CORE-4935
>  URL: http://tracker.firebirdsql.org/browse/CORE-4935
>  Project: Firebird Core
> 
> Another improvement is to cut and cleanup tail of the 
> back-versions chain at point where it is legal

Vlad,
did you do that second improvement, too or is it an idea to be logged
separately in the tracker?

C.


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] RDB$VIEW_RELATIONS

[Helen Borrie]

The new FBLangref 25 says RDB$VIEW_RELATIONS is not used in current versions.  
As Mark R. has pointed in his review (and as I meant to ask before, and forgot 
to!) it clearly *is* used or, at least, populated when a view is created.

What's the back-story?

Helen


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RDB$VIEW_RELATIONS

[Adriano dos Santos Fernandes]

Em 16-09-2015 21:45, Helen Borrie escreveu:
> The new FBLangref 25 says RDB$VIEW_RELATIONS is not used in current versions. 
>  As Mark R. has pointed in his review (and as I meant to ask before, and 
> forgot to!) it clearly *is* used or, at least, populated when a view is 
> created.
> 
> What's the back-story?
> 

It's used to detect base tables of a view (tables used in FROM/JOIN, but
not for subqueries).

It's used for plans, for UPDATE OR INSERT...


Adriano

--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] RDB$VIEW_RELATIONS

[Claudio Valderrama C.]

> -Original Message-
> From: Helen Borrie [mailto:hele...@tpg.com.au] 
> Sent: Miércoles, 16 de Septiembre de 2015 21:46
> 
> The new FBLangref 25 says RDB$VIEW_RELATIONS is not used in 
> current versions.  As Mark R. has pointed in his review (and 
> as I meant to ask before, and forgot to!) it clearly *is* 
> used or, at least, populated when a view is created.
> 
> What's the back-story?

Strange assertion in FBLangRef.

In FB2.5, VIEW_RELATIONS is used in
dsql/metd.epp
jrd/dfw.epp
jrd/dyn.epp
jrd/dyn_def.epp
jrd/dyn_del.epp
jrd/dyn_mod.epp
jrd/dyn_util.epp
jrd/met.epp
and other places (gbak for example).

In FB3, Adriano moved the DYN logic to
dsql/DdlNodes.epp
so VIEW_RELATIONS is there, in addition to
dsql/metd.epp, jrd/dfw and jrd/met.

I don't know what the author of FBLangRef meant. That table is important
because it keeps the equivalence between a table or selectable procedure
used in the view and the context in the view, for example, tested on FB2.5:

SQL> create view v2(x, y) as
 select r.rdb$relation_name, rdb$field_name
 from rdb$relations r join rdb$relation_fields rf
 on r.rdb$relation_name = rf.rdb$relation_name;

SQL> commit;
SQL> set list;
SQL> select * from rdb$view_relations;

RDB$VIEW_NAME   V2
RDB$RELATION_NAME   RDB$RELATION_FIELDS
RDB$VIEW_CONTEXT2
RDB$CONTEXT_NAMERF  <-- table alias

RDB$VIEW_NAME   V2
RDB$RELATION_NAME   RDB$RELATIONS
RDB$VIEW_CONTEXT1
RDB$CONTEXT_NAMER  <-- table alias

C.


--
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991=/4140
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel