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

Re: [Firebird-test] fbtcs and FB 2.0 ibase.h

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

Konstantin Kuznetsov wrote:
> Hi All!
> 
> I am trying to prepare fb 2.0 Solaris Intel for testing with fbtcs
> so:
> 
> 1. fbtcs have not editable tag like fb 2_0_Release
> 2. a lot of data types like SSHORT disappears from ibase.h
> 
> Question to all:
> Is is planned to use fbtcs for testing fb 2.0 release or have another tool?

Can speak for others, but QA dep. uses QMTest test suite to test 2.0 
release, not fbtcs.

best regards
Pavel Cisar
IBPhoenix

[Firebird-test] fbtcs and FB 2.0 ibase.h

[Konstantin K. <kku...@us...>]

Hi All!

I am trying to prepare fb 2.0 Solaris Intel for testing with fbtcs
so:

1. fbtcs have not editable tag like fb 2_0_Release
2. a lot of data types like SSHORT disappears from ibase.h

Question to all:
Is is planned to use fbtcs for testing fb 2.0 release or have another tool?


Konstantin

Re: [Firebird-test] Firebird RC3 keeps restarting

[<ce...@re...>]

Hi Miguel,

Under windows I could investigate running FB as application: it was 63
connection.
Under Linux I didn't find out, but I suspect it was less than 100 as I had a
connection pool of 100. Now I am under MySQL I didn't investigate FB
backwards with my connection debugging code. You can do it easily logging
any open and close of connection in your codes (time, open or close, code
used).

Good luck...

Cedric.

-----Mensaje original-----
De: fir...@li...
[mailto:fir...@li...]En nombre de Miguel
Enviado el: Lunes, 07 de Agosto de 2006 07:16 a.m.
Para: fir...@li...
Asunto: Re: [Firebird-test] Firebird RC3 keeps restarting


Hey Cedric,

        Could you please tell me, how many connections on Firebird you found
out?

Miguel

----- Original Message -----
From: "Cedric Simon" <ce...@so...>
To: <xsa...@sb...>; <fir...@li...>
Sent: Saturday, August 05, 2006 10:32 AM
Subject: Re: [Firebird-test] Firebird RC3 keeps restarting


> Hi Mike,
>
> I got this problem earlier (RC1 & 2). The server restarted without
> apparent
> reason.
>
> Finally I found out (after moving to MySQL v5) that the problem was 'too
> many connection' open (or connection pool exhausted). The problem was that
> in one of my codings (of course, the most used...) I was opening a
> connection and not closing it properly!
>
> MySQL has error messages much more explicit than Firebird, and as MySQL
> has
> now views, procedures, triggers... I will stay with MySQL. I loved very
> much
> Firebird, I enjoyed it a lot, but I need a more reliable database for my
> business.
>
> Now I created a debugging option logging any open or closing of
> connection,
> so I can detect easily what (new) coding is not closing connection
> properly.
>
> I hope it will help you.
>
> Regards,
>
> Cedric.
>
> -----Mensaje original-----
> De: fir...@li...
> [mailto:fir...@li...]En nombre de Mike
> Starov ( aka xsaero00 )
> Enviado el: Jueves, 03 de Agosto de 2006 10:18 a.m.
> Para: fir...@li...
> Asunto: [Firebird-test] Firebird RC3 keeps restarting
>
>
> I am running FB RC3 on Suse Linux and for reason unknown firebird server
> just keep on restarting. I used to run RC3 with NPTL but because of the
> problem I switched to one without NPTL, but it did not help.
> I don't know how to go about debugging it to pinpoint the problem so
> here I am asking for pointers. It usually happens when I run python unit
> tests. I use kinterbasdb for connecting to the database. The restart
> usually happens when the statement is executed; the connection part
> seems to go fine. In the firebird log I simply get messages about server
> being abnormally shut down and then restarted by the fbguard.
> Like so:
> devserver (Client)    Tue Aug  1 15:58:01 2006
>    /opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)
>
> devserver (Client)    Tue Aug  1 15:58:01 2006
>    /opt/firebird/bin/fbguard: guardian starting bin/fbserver
>
> Where can I find out more about what caused the restart? What procedure
> to follow? Any suggestion is anticipated.
>
> --
> Mike Starov
> mik...@gm...
>
> CME Resource, Inc.
> Roseville, CA 95661
> www.netce.com
> (916) 783-4238
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 5/8/2006
>
>


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

Re: [Firebird-test] Firebird RC3 keeps restarting

[Miguel <mi...@fr...>]

Hey Cedric,

        Could you please tell me, how many connections on Firebird you found 
out?

Miguel

----- Original Message ----- 
From: "Cedric Simon" <ce...@so...>
To: <xsa...@sb...>; <fir...@li...>
Sent: Saturday, August 05, 2006 10:32 AM
Subject: Re: [Firebird-test] Firebird RC3 keeps restarting


> Hi Mike,
>
> I got this problem earlier (RC1 & 2). The server restarted without 
> apparent
> reason.
>
> Finally I found out (after moving to MySQL v5) that the problem was 'too
> many connection' open (or connection pool exhausted). The problem was that
> in one of my codings (of course, the most used...) I was opening a
> connection and not closing it properly!
>
> MySQL has error messages much more explicit than Firebird, and as MySQL 
> has
> now views, procedures, triggers... I will stay with MySQL. I loved very 
> much
> Firebird, I enjoyed it a lot, but I need a more reliable database for my
> business.
>
> Now I created a debugging option logging any open or closing of 
> connection,
> so I can detect easily what (new) coding is not closing connection 
> properly.
>
> I hope it will help you.
>
> Regards,
>
> Cedric.
>
> -----Mensaje original-----
> De: fir...@li...
> [mailto:fir...@li...]En nombre de Mike
> Starov ( aka xsaero00 )
> Enviado el: Jueves, 03 de Agosto de 2006 10:18 a.m.
> Para: fir...@li...
> Asunto: [Firebird-test] Firebird RC3 keeps restarting
>
>
> I am running FB RC3 on Suse Linux and for reason unknown firebird server
> just keep on restarting. I used to run RC3 with NPTL but because of the
> problem I switched to one without NPTL, but it did not help.
> I don't know how to go about debugging it to pinpoint the problem so
> here I am asking for pointers. It usually happens when I run python unit
> tests. I use kinterbasdb for connecting to the database. The restart
> usually happens when the statement is executed; the connection part
> seems to go fine. In the firebird log I simply get messages about server
> being abnormally shut down and then restarted by the fbguard.
> Like so:
> devserver (Client)    Tue Aug  1 15:58:01 2006
>    /opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)
>
> devserver (Client)    Tue Aug  1 15:58:01 2006
>    /opt/firebird/bin/fbguard: guardian starting bin/fbserver
>
> Where can I find out more about what caused the restart? What procedure
> to follow? Any suggestion is anticipated.
>
> --
> Mike Starov
> mik...@gm...
>
> CME Resource, Inc.
> Roseville, CA 95661
> www.netce.com
> (916) 783-4238
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share 
> your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.10.7/410 - Release Date: 5/8/2006
>
> 

Re: [Firebird-test] Firebird RC3 keeps restarting

[<ce...@so...>]

Hi Mike,

I got this problem earlier (RC1 & 2). The server restarted without apparent
reason.

Finally I found out (after moving to MySQL v5) that the problem was 'too
many connection' open (or connection pool exhausted). The problem was that
in one of my codings (of course, the most used...) I was opening a
connection and not closing it properly!

MySQL has error messages much more explicit than Firebird, and as MySQL has
now views, procedures, triggers... I will stay with MySQL. I loved very much
Firebird, I enjoyed it a lot, but I need a more reliable database for my
business.

Now I created a debugging option logging any open or closing of connection,
so I can detect easily what (new) coding is not closing connection properly.

I hope it will help you.

Regards,

Cedric.

-----Mensaje original-----
De: fir...@li...
[mailto:fir...@li...]En nombre de Mike
Starov ( aka xsaero00 )
Enviado el: Jueves, 03 de Agosto de 2006 10:18 a.m.
Para: fir...@li...
Asunto: [Firebird-test] Firebird RC3 keeps restarting


I am running FB RC3 on Suse Linux and for reason unknown firebird server
just keep on restarting. I used to run RC3 with NPTL but because of the
problem I switched to one without NPTL, but it did not help.
I don't know how to go about debugging it to pinpoint the problem so
here I am asking for pointers. It usually happens when I run python unit
tests. I use kinterbasdb for connecting to the database. The restart
usually happens when the statement is executed; the connection part
seems to go fine. In the firebird log I simply get messages about server
being abnormally shut down and then restarted by the fbguard.
Like so:
devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)

devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: guardian starting bin/fbserver

Where can I find out more about what caused the restart? What procedure
to follow? Any suggestion is anticipated.

--
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238





-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test

[Firebird-test] Firebird RC3 keeps restarting

[Mike S. ( a. x. ) <xsa...@sb...>]

I am running FB RC3 on Suse Linux and for reason unknown firebird server 
just keep on restarting. I used to run RC3 with NPTL but because of the 
problem I switched to one without NPTL, but it did not help.
I don't know how to go about debugging it to pinpoint the problem so 
here I am asking for pointers. It usually happens when I run python unit 
tests. I use kinterbasdb for connecting to the database. The restart 
usually happens when the statement is executed; the connection part 
seems to go fine. In the firebird log I simply get messages about server 
being abnormally shut down and then restarted by the fbguard.
Like so:
devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: bin/fbserver terminated abnormally (-1)

devserver (Client)    Tue Aug  1 15:58:01 2006
    /opt/firebird/bin/fbguard: guardian starting bin/fbserver

Where can I find out more about what caused the restart? What procedure 
to follow? Any suggestion is anticipated.

-- 
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238

Re: [Firebird-test] Firebird does not create unique constraint.

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

Mike,

> Leyne, Sean wrote:
> > A Firebird index includes index data for all active transactions,
this
> > is by design.
> >
> > Accordingly, what you are seeing is the correct behaviour.
> >
> >
> > Sean
> >
> I know that. The question is why there were active transactions
> affecting the new index.

Because a unique index requires that the engine consider both committed
transactions and also active transactions, in order to ensure
uniqueness.

You will note that the uniqueness error is noted when the insert/update
takes place, not when the transaction is committed.  Accordingly, the
index/engine is affected by active transactions.

>I don't think this is a new issue. See CORE-400
> <http://tracker.firebirdsql.org/browse/CORE-400> in bug database.

This case is not applicable -- it involves restoring a database which
now has a unique constraint but which has data which isn't unique.  This
is a restore problem.


> I have a copy of the database running on FB 1.5 and the same operation
> went through fine there.

Unless you had active transactions, I would have expected the same but
you didn't so the comparison is not equivalent.

Regards,

Sean

Re: [Firebird-test] Firebird does not create unique constraint.

[Mike S. ( a. x. ) <xsa...@sb...>]

Leyne, Sean wrote:
> A Firebird index includes index data for all active transactions, this
> is by design.
>
> Accordingly, what you are seeing is the correct behaviour.
>
>
> Sean
>   
I know that. The question is why there were active transactions 
affecting the new index. I don't think this is a new issue. See CORE-400 
<http://tracker.firebirdsql.org/browse/CORE-400> in bug database. I have 
a copy of the database running on FB 1.5 and the same operation went 
through fine there.

I have only been using the FireBird DB, did not get into development of 
debugging, so I don't know all the secrets. More of the end user point 
of view.

-- 
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238

Re: [Firebird-test] Firebird does not create unique constraint.

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

Mike

> I am using FB RC3 without NPTL support on SLES 9.
> I get the error message "ERROR: attempt to store duplicate value
(visible
> to active transactions) in unique index " when I try to create unique
> index on VarChar column in table with no duplicates. I even emptied
out
> the table and then tried to create the index but got the same message:
> Code:
> ALTER TABLE REFERRAL ADD CONSTRAINT REFERRALBYREFERRALCODE UNIQUE
> (REFERRALCODE);
> Result:
> ERROR: attempt to store duplicate value (visible
> to active transactions) in unique index
> "REFERRALBYREFERRALCODE ".
> I spent about an hour checking system tables and trying to pinpoint
the
> issue. Then I restarted the firebird server and tried again and all
went
> fine. Seems like there was an active transaction that did not let me
do
> it. I did not check outstanding transactions before restart so I dont
> know for sure.

A Firebird index includes index data for all active transactions, this
is by design.

Accordingly, what you are seeing is the correct behaviour.


Sean

[Firebird-test] Firebird does not create unique constraint.

[Mike S. ( a. x. ) <xsa...@sb...>]

I am using FB RC3 without NPTL support on SLES 9.
I get the error message "ERROR: attempt to store duplicate value (visible
to active transactions) in unique index " when I try to create unique
index on VarChar column in table with no duplicates. I even emptied out
the table and then tried to create the index but got the same message:
Code:
ALTER TABLE REFERRAL ADD CONSTRAINT REFERRALBYREFERRALCODE UNIQUE
(REFERRALCODE);
Result:
ERROR: attempt to store duplicate value (visible
to active transactions) in unique index
"REFERRALBYREFERRALCODE ".
I spent about an hour checking system tables and trying to pinpoint the
issue. Then I restarted the firebird server and tried again and all went
fine. Seems like there was an active transaction that did not let me do
it. I did not check outstanding transactions before restart so I dont
know for sure.

-- 
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238

[Firebird-test] Firebird does not create unique constraint.

[Mike S. <mik...@gm...>]

I am using FB RC3 without NPTL support on SLES 9.
I get the error message "ERROR: attempt to store duplicate value (visible
to active transactions) in unique index " when I try to create unique 
index on VarChar column in table with no duplicates. I even emptied out 
the table and then tried to create the index but got the same message:
Code:
ALTER TABLE REFERRAL ADD CONSTRAINT REFERRALBYREFERRALCODE UNIQUE 
(REFERRALCODE);
Result:
 ERROR: attempt to store duplicate value (visible
to active transactions) in unique index
"REFERRALBYREFERRALCODE ".
I spent about an hour checking system tables and trying to pinpoint the 
issue. Then I restarted the firebird server and tried again and all went 
fine. Seems like there was an active transaction that did not let me do 
it. I did not check outstanding transactions before restart so I dont 
know for sure.

-- 
Mike Starov
mik...@gm...

CME Resource, Inc.
Roseville, CA 95661
www.netce.com
(916) 783-4238

[Firebird-test] Firebird 2.0 performance issue

[Andrew G. <dev...@fe...>]

Hello Firebird team,

I have migrated existing application from Firebird 1.5.2 to 2.0 RC3 on 
the same server. The database was restored from backup with new gbak. 
There is a query that becomes too slow right after migration. Firebird 
1.5.2 executed the query in 2-4 seconds, but it takes about 25-40 sec 
with Firebird 2.0. I have no idea why it happened:  the database is 
small, so number of records involved is not heavy.
Could you please clarify the situation?

The query is:

select c.id, c.name, /*c.email,*/ i.event_date, i.event_time,
  c.hot_flag, c.no_spam, /*a.name as aname,*/
  cast(1 as smallint) as atype,  t.name as itype,
  /*a.subject as template,*/ a.id as action_id, t.id as type_id
from customers c
  inner join interactions i on i.customer_id = c.id
    and c.deleted = 0 and c.no_spam = 0
  inner join cust_subscr s on s.customer_id = c.id
    and s.type_id = i.type_id
  inner join actions a on a.type_id = i.type_id
    and a.relative = 1 and a.deleted = 0 and a.is_active > 0
    and current_date-a.day_period >= i.event_date
  inner join intr_types t on i.type_id = t.id
  left join last_actions l on l.customer_id = c.id and l.action_id = a.id
/*     and l.event_tsc > i.event_date*/
where
  l.event_tsc <
  i.event_date+coalesce(i.event_time, cast('00:00' as time))+a.day_period

Results on my powerful PC, windows (the server is much slower)

Plan
------------------------------------------------
PLAN JOIN (JOIN (A NATURAL, T INDEX (RDB$PRIMARY13), S INDEX 
(RDB$FOREIGN17), C INDEX (RDB$PRIMARY9), I INDEX (RDB$FOREIGN15, 
RDB$FOREIGN16)), L INDEX (RDB$FOREIGN13, RDB$FOREIGN2))

Adapted Plan
------------------------------------------------
PLAN JOIN (JOIN (A NATURAL, T INDEX (INTEG_34), S INDEX (INTEG_44), C 
INDEX (INTEG_23), I INDEX (INTEG_39, INTEG_42)), L INDEX (INTEG_200, 
INTEG_144))

Query Time
------------------------------------------------
Prepare       : 0.00 ms
Execute       : 13 156.00 ms
Avg fetch time: 548.17 ms

Memory
------------------------------------------------
Current: 1 985 876
Max    : 2 019 904
Buffers: 8 192

Operations
------------------------------------------------
Read   : 0
Writes : 8
Fetches: 378 270


Enchanced Info:
+--------------------------+-----------+-----------+-------------+---------+---------+---------+
|        Table Name        |  Records  |  Indexed  | Non-Indexed | 
Updates | Deletes | Inserts |
|                          |   Total   |   reads   |    reads    
|         |         |         |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+
|                   ACTIONS|         0 |         0 |          50 |       
0 |       0 |       0 |
|                 CUSTOMERS|         0 |     14940 |           0 |       
0 |       0 |       0 |
|               CUST_SUBSCR|         0 |     14940 |           0 |       
0 |       0 |       0 |
|              INTERACTIONS|         0 |     14529 |           0 |       
0 |       0 |       0 |
|                INTR_TYPES|         0 |         6 |           0 |       
0 |       0 |       0 |
|              LAST_ACTIONS|         0 |     11255 |           0 |       
0 |       0 |       0 |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+


These are involved tables:

create table customers (
  id integer not null primary key,
  name varchar(100) not null,
  email varchar(100) not null,
  phone varchar(100),
  name_alias varchar(100),
  company_name varchar(100),
  www varchar(250),
  info blob sub_type 1,
  no_spam smallint default 0,
  hot_flag smallint default 0,
  deleted smallint default 0 not null
);
/* 6327 records */

create index idx_cust_email on customers(email);
create index idx_cust_name on customers(name);
create index idx_customer_alias on customers(name_alias);

/* customer interaction kinds */
create table intr_types (
  id smallint not null primary key,
  name varchar(100) not null,
  ord_num smallint,
  ntype smallint default 0
);
/* 29 records */

/* customer interactions history */
create table interactions (
  id integer not null primary key,
  type_id smallint not null references intr_types(id),
  event_date date not null,
  event_time time default current_time,
  product_id integer references products(id),
  customer_id integer not null references customers(id),
  auction_id integer references auctions(id),
  campaign_id integer references campaigns(id),
  ref_num varchar(50),
  revenue numeric(18, 4),
  period integer,
  details blob sub_type 1
);
/* 7983 records */

create index idx_intr_date on interactions(event_date);
create index idx_intr_refn on interactions(ref_num);

/* kinds of postings to subscribers */
create table actions (
  id smallint not null primary key,
  name varchar(100),
  type_id smallint references intr_types(id),
  start_date date,
  day_period smallint,
  relative smallint not null,
  from_addr varchar(100),
  subject varchar(250),
  text blob sub_type 1,
  is_active smallint default 1,
  deleted smallint default 0 not null
);
/* 50 records */

/* customer subscriptions */
create table cust_subscr (
  type_id smallint not null references intr_types(id),
  customer_id integer not null references customers(id)
);
/* 7391 records */

create table last_actions (
  action_id smallint not null references actions(id) on delete cascade,
  customer_id integer not null references customers(id) on delete cascade,
  event_tsc timestamp not null
);
/* 38078 records */

create index idx_last_action on last_actions(event_tsc);

I'm ready to send you the database backup if it helps.

Thank you,

Andrew

[Firebird-test] Like and index

[Philippe M. <mak...@a6...>]

SELECT myfield LIKE 'A%' use index
SELECT myfield STARTING WITH 'A' use index

SELECT myfield STARTING WITH 'A' OR myfield STARTING WITH 'B' use index
SELECT myfield LIKE 'A%' OR myfield LIKE 'B%' does not use index

I thought that for the optimizer, LIKE 'A%' is equivalent to STARTING
WITH 'A', it seems that is not true when there is an OR

[Firebird-test] Re: Problems connecting fbserver 2.5.1

[Nikolay T. <nt...@ma...>]

I have the following problem:
 WinXP SP2  - with firewall down for the test.
Firebird services - runing.
 When I register database in IBExpert:

Attempting to connect to:
C:\Program Files\Firebird\Firebird_1_5\examples\EMPLOYEE.FDB

Connecting... Failed!
------------------------------------
Unsuccessful execution caused by an unavailable resource.
unavailable database.

Attempting to connect to services manager... Failed!
------------------------------------

Unsuccessful execution caused by an unavailable resource.
Cannot attach to services manager.

Disconnecting from database... Passed!

The same situation with my app - D7 - FIBPlus.

Any ideas?
Nik

[Firebird-test] Problems connecting fbserver 2.5.1

[Nikolay T. <nt...@ma...>]

I have the following problem:
WinXP SP2  - with firewall down for the test. 

[Firebird-test] Opinion requested on alias use in FB 2

[russell <ru...@be...>]

I am requesting an opinion on the use of aliases in FB 2. Having read the 
new rules for SQL aliases in FB2.0 (RC1) release noes I am not sure I 
understand how they apply to my cloning case below.

INSERT statements do not allow the use of an alias by my reading of 
descriptions of the INSERT statement (FB Ref Guide).

In the following an existing objects contents are referenced by 
"source_nmds_ID" and the cloned objects contents by "newnmdsid".

The following code works (compiles and when run gives expected results) in 
FB 1.5.3 and FB 2.0 (RC1).

Will the following code work in FB 2.x versions?


   /* copy the data from the source NMDS to the new NMDS */
   for select NMD.Field_Name,NMD.FIELD_TYPE_ID, NMD.Data
   from NAMED_MATTER_DATA NMD
   where (NMD.NMDS_ID=:source_nmds_ID)
   into :FName, FTypeID, :FData do
   begin
     insert into NAMED_MATTER_DATA
     (NMDS_ID, FIELD_NAME, FIELD_TYPE_ID, DATA)
     values
     (:newnmdsid,
     cast(:FNAME as varchar(48)),
     cast(:FTYPEID as varchar(18)),
     :FDATA);
   end

Thanks
Russell Belding

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.384 / Virus Database: 268.4.1/312 - Release Date: 14-04-2006
 

[Firebird-test] Opinion requested on alias use

[Russell B. <st...@be...>]

I am requesting an opinion on the use of aliases in FB 2. Having read the 
new rules for SQL aliases in FB2.0 (RC1) release noes I am not sure I 
understand how they apply to my cloning case below.

INSERT statements do not allow the use of an alias by my reading of 
descriptions of the INSERT statement (FB Ref Guide).

In the following an existing objects contents are referenced by 
"source_nmds_ID" and the cloned objects contents by "newnmdsid".

The following code works (compiles and when run gives expected results) in 
FB 1.5.3 and FB 2.0 (RC1).

Will the following code work in FB 2.x versions?


  /* copy the data from the source NMDS to the new NMDS */
  for select NMD.Field_Name,NMD.FIELD_TYPE_ID, NMD.Data
  from NAMED_MATTER_DATA NMD
  where (NMD.NMDS_ID=:source_nmds_ID)
  into :FName, FTypeID, :FData do
  begin
    insert into NAMED_MATTER_DATA
    (NMDS_ID, FIELD_NAME, FIELD_TYPE_ID, DATA)
    values
    (:newnmdsid,
    cast(:FNAME as varchar(48)),
    cast(:FTYPEID as varchar(18)),
    :FDATA);
  end

Thanks
Russell Belding 

[Firebird-test] case sensitivity

[osman <of...@su...>]

Hi,


when i create a Firebird table without "", it automatically creates it (name 
and fields name) into upper case. so I can execute a SQL statement like :
SELECT * FROM mytable;
but not :
SELECT * FROM "mytable"; (due to the case sensitivity)

I have a big application which uses these 2 kinds of statements , and i 
can't modify it.

I think its impossible to make Firebird be likely to accept these requests 
unless configuring its ODBC driver.


In fact, I ve seen in the driver configuration  some "Extended Identifier 
Properties" like case sensitivity, ... but I can't make them work.

Does anybody know?
Is it possible to solve my problem thanks to that?

Thanks for your help?

[Firebird-test] Firebird 2.0 Beta 2 Released

[Helen B. <he...@tp...>]

The Firebird Project has released the second Firebird 2.0 beta. Over 
the weekend, kits for Win32, Linux x86 (including NPTL builds for 
Superserver) and Linux x64 are being released for testing. Mirrors 
are slowly filling up; slower downloads from the pre-release area are 
also available temporarily but please try the main (mirror) links first.

Quick access URL:
http://firebird.sourceforge.net/index.php?op=files&id=fb2_beta02

Enjoy testing it!

The Firebird Project

Re: [Firebird-test] index on columns and on arrays

[Ann W. H. <aha...@ib...>]

Gluon wrote:

> Can we create an index on 128 integer columns (fields) ?
> 
> I need this index very much, and in FB2.0 beta 1, it is impossible because an index can contain no more than 16 columns.
> 
> Since we enhanced the indexing, index size limitation of 252 bytes is gone (Thanks to A. Brinkman and other developers), why an index cannot be created on an array or more than 16 columns? 
> 
> I learned very little on DB indexing, and need your help indeed :) 
> 

You'll get better answers on the firebird-support list

fir...@ya...


But when you send mail there, do explain why you need
an index on 128 columns at once rather than several indexes.


Regards,


Ann

[Firebird-test] index on columns and on arrays

[Gluon <ft...@21...>]

RGVhciBGcmllbmRzLA0KDQpDYW4gd2UgY3JlYXRlIGFuIGluZGV4IG9uIDEyOCBpbnRlZ2VyIGNv
bHVtbnMgKGZpZWxkcykgPw0KDQpJIG5lZWQgdGhpcyBpbmRleCB2ZXJ5IG11Y2gsIGFuZCBpbiBG
QjIuMCBiZXRhIDEsIGl0IGlzIGltcG9zc2libGUgYmVjYXVzZSBhbiBpbmRleCBjYW4gY29udGFp
biBubyBtb3JlIHRoYW4gMTYgY29sdW1ucy4NCg0KU2luY2Ugd2UgZW5oYW5jZWQgdGhlIGluZGV4
aW5nLCBpbmRleCBzaXplIGxpbWl0YXRpb24gb2YgMjUyIGJ5dGVzIGlzIGdvbmUgKFRoYW5rcyB0
byBBLiBCcmlua21hbiBhbmQgb3RoZXIgZGV2ZWxvcGVycyksIHdoeSBhbiBpbmRleCBjYW5ub3Qg
YmUgY3JlYXRlZCBvbiBhbiBhcnJheSBvciBtb3JlIHRoYW4gMTYgY29sdW1ucz8gDQoNCkkgbGVh
cm5lZCB2ZXJ5IGxpdHRsZSBvbiBEQiBpbmRleGluZywgYW5kIG5lZWQgeW91ciBoZWxwIGluZGVl
ZCA6KSANCg0KVGhhbmsgeW91IGZvciB5b3VyIGF0dGVudGlvbi4NCg0KQmVzdCB3aXNoZXMgdG8g
eW91Lg0KDQpzaW5jZXJlbHksIEdsdW9u

[Firebird-test] Test, please ignore

[Jonathan Neve[Microtec] <jon...@mi...>]

Just testing posting from the newsgroup interface.

-- 
Best regards,
Jonathan Neve
_______________
CopyTiger - advanced database replicator for Interbase/Firebird!
Web : http://www.microtec.fr/copycat/ct
_______________________________________
CopyCat - database replication components for Delphi/C++Builder!
Web : http://www.microtec.fr/copycat/cc

[Firebird-test] Firebird 2 and 64 Bit

[Martin S. <m.s...@eq...>]

Hi,

I want to test Firdbird 2 on 64 Bit OS on Intel Plattform.

Which version can I use on Linux and which on Windows 2003 x64?

Thanks Martin 

Re: [Firebird-test] can we use queries instead of tables

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

Hi,

amt wrote:
> when i write query instead of tables it doesnt work error -104
> like
> select *from (select name,surname from names) N
> or
> select *from from names n
> left join (select *from adres) a on a.ind=n.ind

1. This should be posted to firebird-support list, this one is dedicated 
to Firebird Quality Assurance.

2. You have used derived tables (select instead table name) that are not 
supported in current stable version 1.5. However, they are implemented 
in Firebird 2.0.

best regards
Pavel Cisar
IBPhoenix

Re: [Firebird-test] can we use queries instead of tables

[Martijn T. <m.t...@up...>]

Hi,

This actually is a topic for "firebird-support", but here you go ...

> hi,
> when i write query instead of tables it doesnt work error -104
> like
> select *from (select name,surname from names) N
> or
> select *from from names n
> left join (select *from adres) a on a.ind=n.ind

You can do this in Firebird 2 and up.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com