firebird-test — Firebird engine testing, test flight/suite discussion/information

RE: [Firebird-test] Memory Usage Test

[Leyne, S. <Se...@br...>]

JS,

> Can somebody do this test for me? There seems to be some memory leak
in
> the
> udf 'addDay'(fbudf comes with firebird). If I call the Stored
> Procedure given below in a loop, memory usage of firebird (using top
> command in linux) crosses 100MB in a few minutes. When I comment the
> statement calling 'addDay', there is no memory increase.

Please confirm which Firebird version you are using.


Sean

[Firebird-test] Memory Usage Test

[Joga S. <jog...@in...>]

Can somebody do this test for me? There seems to be some memory leak in the
udf 'addDay'(fbudf comes with firebird). If I call the Stored
Procedure given below in a loop, memory usage of firebird (using top
command in linux) crosses 100MB in a few minutes. When I comment the
statement calling 'addDay', there is no memory increase.



JS

-------------------------------------
SET TERM !!;

CREATE OR ALTER PROCEDURE testget_maxdate RETURNS (retval int)
AS
declare date_in timestamp;
declare ret_in timestamp;
begin
date_in=current_timestamp;
ret_in=addday(date_in,1);
-- ret_in=addday(cast(date_in as date),1);
-- ret_in=addmillisecond(addday(cast(date_in as date),1),-1);
retval=1;
SUSPEND;
end !!

SET TERM ; !!

RE: [Firebird-test] Unable to complete connection to "localhost"

[Leyne, S. <Se...@br...>]

Carlos,

> "Pavel Cisar" wrote:
>=20
> > Hi,
> >
> > First, this is not a support forum, use
> > fir...@ya... instead in future.
> >
>=20
> Why not replacing this list name for something which move away the
> newbyes?

How clearer does the description for the list have to be?

The original description was: "Firebird test flight /suite information"

I just updated to read: "Firebird engine testing, test flight/suite
discussion/information"


Sean

RE: [Firebird-test] mult-database connect in SQL!

[Leyne, S. <Se...@br...>]

> Can I use SQL syntax in FireBird like this:
>=20
> SELECT DB1.C_NAME,DB2.N_NUMBER FROM "C:\DB1.FDB' DB1,"C:\DB2.FDB' DB2
> WHERE
> DB1.N_ID=3DDB2.N_ID

First, this is not a support forum, use fir...@ya...
instead in future.

To your question:=20

No you can't.  The engine does not support cross-database queries.


Sean

[Firebird-test] mult-database connect in SQL!

[cOOl <coo...@ma...>]

Hello,
Can I use SQL syntax in FireBird like this:

SELECT DB1.C_NAME,DB2.N_NUMBER FROM "C:\DB1.FDB' DB1,"C:\DB2.FDB' DB2 WHERE
DB1.N_ID=DB2.N_ID

Re: [Firebird-test] Unable to complete connection to "localhost"

[Carlos M. <CM...@su...>]

"Pavel Cisar" wrote:

> Hi,
> 
> First, this is not a support forum, use
> fir...@ya... instead in future.
> 

Why not replacing this list name for something which move away the
newbyes?

Carlos Macao

Re: [Firebird-test] Unable to complete connection to "localhost"

[Pavel C. <pc...@ib...>]

Hi,

On 13 Sep 2004 at 21:48, kelv wrote:

>     Hi,
>        I have installed FirebirdSS-1.5.1.4481-0.i686 on a red hat 8. When I
> gbak -r a gbk file(backup from v1 firebird running on red hat 7.2).
> Following error occur:
> Unable to complete network connection to "localhost"...
> error in reading data..
> broken pipe.
> 
> I have checked that firebird server is started and "gds_db tcp/3050" was
> included in the /etc/services.
> 
> Would u please advice how to I fix this problem. Thank a lot!

First, this is not a support forum, use fir...@ya... 
instead in future.

To your question: You apparently doesn't have /etc/host.equiv file with 
localhost.localdomain entry (sometimes, an + entry is also needed). It's 
needed for SS local connections to work properly.

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] Unable to complete connection to "localhost"

[kelv <ke...@ya...>]

    Hi,
       I have installed FirebirdSS-1.5.1.4481-0.i686 on a red hat 8. When I
gbak -r a gbk file(backup from v1 firebird running on red hat 7.2).
Following error occur:
Unable to complete network connection to "localhost"...
error in reading data..
broken pipe.

I have checked that firebird server is started and "gds_db tcp/3050" was
included in the /etc/services.

Would u please advice how to I fix this problem. Thank a lot!

kelv

[Firebird-test] I can't install UDF

[Zbigniew C. <z.c...@ga...>]

sorry for my english

FB 1.5.1 on linux (debian)


I write some udf's. they are in "zbylo_udf" file

When i try use my UDF function (function is ok. he work fine on FB 
1.0.3. and second 1.5.1). I have two error:

Invalid token.
invalid request BLR at offset 63.
function INTTOIP is not defined.
module name or entrypoint could not be found.

or

Access to UDF library "libzbylo_udf.so" is denied by server administrator.



we have second server (same like this) and this work very well.

[Firebird-test] Open and Close connection to Firebird 1.03 972 server is slow in Windows XP

[Chau C. Y. <cc...@es...>]

Dear All,

I found a problem with Firebird 1.03 972 windows version.  I hope 
someone may help.

The problem is the Open and Close connection to Firebird 1.03 server is 
slow in some situations. 

I use Delphi to write a simple test case to Open / Close repeatedly:


Access database locally:
========================

procedure TForm1.Button1Click(Sender: TObject);
var i: integer;
    d1, d2: integer;
begin
  IBDatabase1.DatabaseName := 'c:\test.fdb';
  for i := 1 to 10 do begin
    IBDatabase1.Open;
    IBDatabase1.Close;
  end;
end;

The above procedures show the results:

             IB 6         FB 1.03(972)       FB 1.5.1

Win98        Fast             Fast             Fast
WinXP        Fast             Fast             Fast



Access database using TCP:
==========================

procedure TForm1.Button1Click(Sender: TObject);
var i: integer;
    d1, d2: integer;
begin
  IBDatabase1.DatabaseName := 'localhost:c:\test.fdb';
  for i := 1 to 10 do begin
    IBDatabase1.Open;
    IBDatabase1.Close;
  end;
end;


The above procedures show the results:

             IB 6         FB 1.03(972)       FB 1.5.1

Win98        Fast             Fast             Fast
WinXP        Fast          -> Slow <-          Fast


I suspect it could be the Firebird 1.03 972 's problem.  It shows slow 
performance over TCP connection in Windows XP.

I don't think it is machine's problem or TCP/IP network problem as 
implicated from the above result.  If you use IB Console to repeatedly 
open/Close database running on Firebird 1.03 972 windows xp, you can 
feel the some pause as well.

Since my application still running on Firebird 1.03, I couldn't upgrade 
to Firebird 1.5 at the moment.  Could anyone please give me some 
advice?  I suspect it is the compilation problem in Firebird 1.03 972 
release.

-- 
Best regards,
Chau Chee Yang

E Stream Software Sdn Bhd
URL: www.sql.com.my
SQL Financial Accounting

[Firebird-test] firebird test system

[Tang H. <tan...@12...>]

http://test.3asoft.com

[Firebird-test] Experiences with qmdb: Testing 1.5.1

[Ignacio J. O. <na...@si...>]

Hola a todos:

Last weekend i was trying QMDB with 1.5.X Branch, and i have some
comments/ questions:

1) i've tried HEAD of the qmdb module, is this correct for testing 1.5.1
branch?
2) Some test fail with problems related to the use of linux only things,
so commented them and go ( rel=F1ated to WIFSIGNALED)=20
3) Just now the database used for crating user resources is isc5.gdb,
for 1.5.1 is securioty.fdb.. so corrected it and some test more passes..
4) theres is a bug in the code that closes and deletes  the stdout file,
it deltes it before closing, changed order of operations another some
tests passed..
5) all the create database tests fail with problms related to versiongn
of the infos tested to see if everything works ok, concretely test ask
for 146 pages in clena empty database and 1.5.x gibves 142 pages.. =
a=F1as
test is actually ok.. but the it's done.. fails..


I have this problems solved in my local tree, but it seems to me that
should be a branch for fb 1.0.X, testing another for 1.5.X testing
leaving HEAD for HEAD testing.. i can commit a doit things but i need to
ask here, to not srtep in another one shoes..

Any help will be appreciatted..

Saludos,
Ignacio J. Ortega

[Firebird-test] Firebird and Delphi: create table with primary key, information about primary key lost in Delphi

[Jörg A. <_no...@oa...>]

Hello,

we are using Firebird-Server (1.5.1.4481). Our programs are written in
Delphi 5 and database connection is made with IBObjects\IBX (both with same
behavior).

There seems to be a bug in Firebird.
We need to know the primary key of a TIBOTable-Object and use the value
ixPrimary of Property IndexDef.Options. Under any circumstances this
information is not delivered by Firebird.
When we create the table with primary index at an Interbase-Server
(6.0.1.6) and use the database under Firebird everything is ok. When you
create the same table under Firebird, the information about the primary key
is lost, even if you use the database under Interbase.

If anybody knows about this problem, it would be great to help us

With best regards

Jörg Antoni

RE: [Firebird-test] What is a TEST?

[Leyne, S. <Se...@br...>]

> I have compiled FB  version "SI-V1.5.1.4481 Firebird 1.5".
>=20
> What is a "official" test module for releasing binaries?
>=20
> qmdb? tsc? fbtcs?

All of the above? ;-)


Seriously, I'm not aware of any "official"/single test module.

In the long run, I expect that qmdb will be that platform, it is much
nicer to work with that fbtcs.

At the moment, however, there are a number of tests in fbtcs (which is
descendant from the IB tcs source) which don't yet have coverage in
qmdb.

So, the 2 are pretty much required.


Sean

[Firebird-test] What is a TEST?

[Konstantin K. <klk...@ns...>]

Hi All!

I have compiled FB  version "SI-V1.5.1.4481 Firebird 1.5".

What is a "official" test module for releasing binaries?

qmdb? tsc? fbtcs?

Konstantin Kuznetsov

[Firebird-test] Turkish Character Problem :: JDBC

[Webmaster <jxa...@ya...>]

    I run a query in the JSP pages or JAVA application and then when i print
the output of resultset; my Turkish characters are not shown correctly. How
can i set characterset in FireBird ? I tried this line : <%@ page
contentType="text/html; charset=CP1254" %> in JSP pages but problem
continues.

    Please help me. Thanks alot.

Re: [Firebird-test] Connection problem

[Pavel C. <pc...@ib...>]

Hi,

On 19 May 2004 at 12:37, Dan wrote:

> When I connect to a FirebirdSS 1.x server running on Red Hat 7.2 my WinXP
> app works well. The same FirebirdSS 1.x server but on Red Hat 9 - when I
> start the same application, it throws a fatal exception and dies!
> 
> What's happening? Any hint?

I think that this relate to shared libraries issue, very likely to 
pthreads RH9 library. Try FB 1.5 on RH9, or older libc/libpthread etc. 
libraries taken from RH 7.2. But I guess that FB 1.5 would be the best 
way to go.

P.S.: Please, use firebird-support list for future support questions.

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] Connection problem

[Dan <off...@ul...>]

When I connect to a FirebirdSS 1.x server running on Red Hat 7.2 my WinXP
app works well. The same FirebirdSS 1.x server but on Red Hat 9 - when I
start the same application, it throws a fatal exception and dies!

What's happening? Any hint?

[Firebird-test] server start problem under linux

[Maciej M. <rea...@po...>]

hi!
my system: gentoo

i have problem with firebird-1.5.0
configured ro run as standalone server as user 'firebird' of same group

this is my log:
"
reaver (Client) Sat Apr 17 02:32:15 2004
        INET/inet_error: connect errno = 111
reaver (Client) Sat Apr 17 02:32:15 2004
        /opt/firebird/bin/fbguard: guardian starting bin/fbserver
reaver (Server) Sat Apr 17 02:32:17 2004
        SERVER/process_packet: connection rejected for firebird
[...]
"

i'm totally new in databases - i'm only to host this database for some time
on my machine for someone else, so any help would be appreciated

thanks in advance

-- 
reaver
http://reavertm.webpark.pl/
Registered Linux User #305535
GG: 1902752

Re: [Firebird-test] Starting FireBird in Win2000/XP

[Pavel C. <pc...@ib...>]

Hi,

On 31 Mar 2004 at 17:04, Tony Andersen wrote:

> hi all...
> I'm using below code in win2000/xp computers for starting Interbase.
> >>>> net start "Interbase Guardian"
> but I don't know FireBird's service name and I cannot run..
> what can I do??

First, this is not a support list, for future support questions, use 
Firebird-support instead. 

Now to your question: According to the FB 1.5 Release Notes, the new 
service names on Windows are "Firebird Guardian – DefaultInstance" and 
"Firebird Server – DefaultInstance".

Best regards
Pavel Cisar (ICQ: 89017288)
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information

[Firebird-test] Starting FireBird in Win2000/XP

[Tony A. <ya...@sa...>]

hi all...
I'm using below code in win2000/xp computers for starting Interbase.
>>>> net start "Interbase Guardian"
but I don't know FireBird's service name and I cannot run..
what can I do??

Tony

Re: [Firebird-test] Server terminated while updating database

[Aage J. <aag...@on...>]

On Sat, 6 Mar 2004 19:05:07 +0000 (UTC), Rafik wrote:

> Here is some updates that crashes the server :
> ...
> -- This doesn't happen in version 1, only in version 1.5


Try the firebird-support NG.
Which version of 1.5 - RC1-RC9 or final?
If final, the firebird-devel may be the best NG.


-- 
Aage J.

Re: [Firebird-test] create table

[Aage J. <aag...@on...>]

On Sat, 6 Mar 2004 19:05:07 +0000 (UTC), renniw one wrote:

> Hi,
> Is there a way to create table with a field set to a default value? For
> example...
>
> CREATE TABLE my_table (
> my_num BIGINT NOT NULL );
>
> Is there a way to have the my_num initially hold the value 0? Thanks.


This is a question for the firebird-support NG.
And, the answer is in the docs: default 0.


-- 
Aage J.

[Firebird-test] Server terminated while updating database

[Rafik <rb...@mi...>]

Here is some updates that crashes the server :

update contacts_guest cg set
    cg.frequency = (select count(md.record_no)
                    from master_detail md
                    where md.contact_code = cg.contact_code and
                          md.reservation_type in (9, 16)) ^

update contacts_guest cg set
    cg.number_nights = (select sum(md.number_nights)
                    from master_detail md
                    where md.contact_code = cg.contact_code and
                          md.reservation_type in (9, 16)) ^

VP_MINGUS (Client) Wed Mar 03 09:48:29 2004
 C:\PROGRAM FILES\FIREBIRD\FIREBIRD_1_5\bin\fbserver.exe: terminated
abnormally (3221225477)

-- This doesn't happen in version 1, only in version 1.5

--
Rafik Berzi

[Firebird-test] create table

[renniw o. <re...@ms...>]

Hi,
    Is there a way to create table with a field set to a default value? For
example...

CREATE TABLE my_table (
    my_num BIGINT NOT NULL );

Is there a way to have the my_num initially hold the value 0? Thanks.

Ren