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

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

[amt <am...@al...>]

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

thanks... 

Re: [Firebird-test] Firebird on Linux Deamon restart command

[Michael J. [S. - MVP] <mic...@us...>]

Thanks Ann,

I appreciate it

"Ann W. Harrison" wrote:

> Michael Jenkin [SBS - MVP] wrote:
> > 
> > I hope this is not a stupid question
> 
> Not a stupid question, but addressed to the wrong list.  Try 
> firebird-support (fir...@ya...)
> 
> 
> Cheers,
> 
> 
> Ann
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Power Architecture Resource Center: Free content, downloads, discussions,
> and more. http://solutions.newsforge.com/ibmarch.tmpl
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
> 

-- 
Regards,

Michael Jenkin
MCP MVP SBS
Australia

www.mickyj.com

Re: [Firebird-test] Firebird on Linux Deamon restart command

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

Michael Jenkin [SBS - MVP] wrote:
> 
> I hope this is not a stupid question

Not a stupid question, but addressed to the wrong list.  Try 
firebird-support (fir...@ya...)


Cheers,


Ann

[Firebird-test] Firebird on Linux Deamon restart command

[Michael J. [S. - MVP] <mic...@us...>]

Hello,

I hope this is not a stupid question, I am a newbie to firebird.

I had Firebird up and running on a Redhat enterprise server 4. It worked
well and the end user client access the database well. Then it all
failed (4 months later). 

Instead of rebooting the server, I am sure I used to type
"service firebird restart"

but now I get an error saying 
"firebird: unrecognised service" 

What is the service or deamon name I should be restarting ?

I know firebird is running (gsec can log in).

Any ideas ?

Thanks
-- 
Regards,

Michael Jenkin
MCP MVP SBS
Australia

www.mickyj.com

Re: [Firebird-test] Vulcan: error connecting to ODS 10.x database

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

Simon,

    Vulcan supports only ODS 11.  I'll explain in more detail shortly.


Best,


Ann

[Firebird-test] Vulcan: error connecting to ODS 10.x database

[Simon B. <sim...@vo...>]

Hi,

With recent Vulcan build (29-sep-2005) I have problem connecting to datab=
ases.
I am using inetserver for testing and when I try to connect to database v=
ia
Vulcan ISQL (or IBExpert) I get message:

c:\Builds\vulcan\install\bin>inetserver -a -d -t
Dispatch: attachDatabase c:\employee.fdb
unsupported on-disk structure for file c:\employee.fdb; found 10, support=
 0

I tried to connect to various ODS (10, 10.1).

Connection is OK only to ODS 11 databases (Vulcan restore).

Best regards,
Simon

----------------------------------------------------------------
VOLJADSL brez ISDN. Paketi ze od 6.290 SIT. Modem in namestitev 0 SIT.
http://adsl.volja.net=20

Re: [Firebird-test] FB 1.5 with JvUIB fails to create database

[Sasa M. <of...@ms...>]

Hello,

Please, check your administrators permissions. I have been tested this 
sintax and it is OK!

Sasa Mihajlovic
msd Software Solutions

""N. Bogdanovic"" <aa...@st...> wrote in message 
news:d642cc$flg$1...@ne......
>I changed DatabaseAccess = Restrict 'D:\myData\Databases' and when calling
> JvUIBDatabase.CreateDatabase()
> with DatabaseName 'D:\myData\Databases\:mydb.fdb" it fails with a message
> about "administrator restricted access to
> 'D:\myData\Databases\:mydb.fdb".
> What is wrong?
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
> 

Re: [Firebird-test] FB 2.0 Alpha 3 - Doubts in optmizer improvements

[Alexandre B. S. <ib...@th...>]

Steve Landrum wrote:

>
> STARTING WITH and LIKE queries are not treated the same in the optimizer.
>
> Try this query it would be interesting to see what the plan looks like.
>
> Select
>  *
> from
>  TituloReceber TR join
>  TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) 
> join
>  Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
> TR.EmpresaCredorDevedorID) join
>  MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
> where
>  ECD.Nome STARTING 'Alpha Corantes'
>
>
Hi Steve !

AFAIK the operator LIKE without a wildcard on the first letter has an 
special treatement (Please correct me if I am wrong here), my query with 
LIKE will internally look something like:

Select
 *
from
 TituloReceber TR join
 TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) join
 Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
TR.EmpresaCredorDevedorID) join
 MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
where
 ECD.Nome STARTING 'Alpha Corantes' and
 ECD.Nome like 'Alpha Corantes%'

thats the reason the above query can use an index.

But to answer to your question. Then plan with STARTING WITH is exactly 
the one using LIKE
PLAN JOIN (TRB NATURAL, TR INDEX (PK_TITULORECEBER), ME INDEX 
(PK_MULTIEMPRESA), ECD INDEX (PK_EMPRESA_CREDORDEVEDOR))

see you !

-- 

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.2/55 - Release Date: 21/07/2005

Re: [Firebird-test] FB 2.0 Alpha 3 - Doubts in optmizer improvements

[Steve L. <st...@sl...>]

STARTING WITH and LIKE queries are not treated the same in the optimizer.

Try this query it would be interesting to see what the plan looks like.

Select
  *
from
  TituloReceber TR join
  TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) join
  Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
TR.EmpresaCredorDevedorID) join
  MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
where
  ECD.Nome STARTING 'Alpha Corantes'


Alexandre Benson Smith wrote:

> Guys,
>
> I have played a bit with FB 2.0 alpha 1, but now downloaded the alpha 
> 3 version. The main focus os my tests will be the new INTL module with 
> special attention to the new PT_BR collation.
>
> I have restored a 1.5 database and so far all appears ok !
>
> The other feature I like to look (not to test since I don't have 
> enough knowledge to stress test it) is the Optimizer improvements.
>
> I was looking at the Release Notes and found this:
> "Better support for STARTING WITH"
>
> I'd like to know a bit more about this feature. I will present an 
> example:
> Select
>   *
> from
>   TituloReceber TR join
>   TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) 
> join
>   Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
> TR.EmpresaCredorDevedorID) join
>   MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
> where
>   ECD.Nome like 'Alpha Corantes%'
>
> PLAN JOIN (TRB NATURAL, TR INDEX (PK_TITULORECEBER), ME INDEX 
> (PK_MULTIEMPRESA), ECD INDEX (PK_EMPRESA_CREDORDEVEDOR))
> around 79k reads on mos tables
>
> but when I change the LIKE to "="
> Select
>   *
> from
>   TituloReceber TR join
>   TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) 
> join
>   Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
> TR.EmpresaCredorDevedorID) join
>   MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
> where
>   ECD.Nome = 'Alpha Corantes'
>
> I got this plan
> PLAN JOIN (ECD INDEX (SK_EMPRESA_CREDORDEVEDOR_NOME), TR INDEX 
> (FK_TRECEBER_ECD), TRB INDEX (FK_TRECEBERBAIXA_TRECEBER), ME INDEX 
> (PK_MULTIEMPRESA))
> around 800 reads on most tables.
>
> The later was the expected plan for the first case. the 
> SK_Empresa_CredorDevedor_Nome index is very good (RDB$STATISTICS for 
> this index is 0,000321336759952828)
>    Index SK_EMPRESA_CREDORDEVEDOR_NOME (3)
>    Depth: 2, leaf buckets: 5, nodes: 3130
>    Average data length: 7.00, total dup: 18, max dup: 1
>    Fill distribution:
>         0 - 19% = 0
>        20 - 39% = 0
>        40 - 59% = 0
>        60 - 79% = 0
>        80 - 99% = 5
>
> AFAIR STARTING WITH has lower precedence (don't know if it's the 
> correct term) to specify the join order and index selection, is the 
> improvement mentioned above a better handling of this type of query ? 
> If so, why the index was not used in the first case ?
>
> I am ready to provide more information if someone need it.
>
> The optimization done in views with agregates was really fantastic ! :-D
>
> Good job guys !
>
> see you !
>

[Firebird-test] FB 2.0 Alpha 3 - Doubts in optmizer improvements

[Alexandre B. S. <ib...@th...>]

Guys,

I have played a bit with FB 2.0 alpha 1, but now downloaded the alpha 3 
version. The main focus os my tests will be the new INTL module with 
special attention to the new PT_BR collation.

I have restored a 1.5 database and so far all appears ok !

The other feature I like to look (not to test since I don't have enough 
knowledge to stress test it) is the Optimizer improvements.

I was looking at the Release Notes and found this:
"Better support for STARTING WITH"

I'd like to know a bit more about this feature. I will present an example:
Select
   *
from
   TituloReceber TR join
   TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) join
   Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
TR.EmpresaCredorDevedorID) join
   MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
where
   ECD.Nome like 'Alpha Corantes%'

PLAN JOIN (TRB NATURAL, TR INDEX (PK_TITULORECEBER), ME INDEX 
(PK_MULTIEMPRESA), ECD INDEX (PK_EMPRESA_CREDORDEVEDOR))
around 79k reads on mos tables

but when I change the LIKE to "="
Select
   *
from
   TituloReceber TR join
   TituloReceberBaixa TRB on (TRB.TituloReceberID = TR.TituloReceberID) join
   Empresa_CredorDevedor ECD on (ECD.Empresa_CredorDevedor_ID = 
TR.EmpresaCredorDevedorID) join
   MultiEmpresa ME on (ME.MultiEmpresaID = TR.MultiEmpresaID)
where
   ECD.Nome = 'Alpha Corantes'

I got this plan
PLAN JOIN (ECD INDEX (SK_EMPRESA_CREDORDEVEDOR_NOME), TR INDEX 
(FK_TRECEBER_ECD), TRB INDEX (FK_TRECEBERBAIXA_TRECEBER), ME INDEX 
(PK_MULTIEMPRESA))
around 800 reads on most tables.

The later was the expected plan for the first case. the 
SK_Empresa_CredorDevedor_Nome index is very good (RDB$STATISTICS for 
this index is 0,000321336759952828)
    Index SK_EMPRESA_CREDORDEVEDOR_NOME (3)
    Depth: 2, leaf buckets: 5, nodes: 3130
    Average data length: 7.00, total dup: 18, max dup: 1
    Fill distribution:
         0 - 19% = 0
        20 - 39% = 0
        40 - 59% = 0
        60 - 79% = 0
        80 - 99% = 5

AFAIR STARTING WITH has lower precedence (don't know if it's the correct 
term) to specify the join order and index selection, is the improvement 
mentioned above a better handling of this type of query ? If so, why the 
index was not used in the first case ?

I am ready to provide more information if someone need it.

The optimization done in views with agregates was really fantastic ! :-D

Good job guys !

see you !

-- 

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.2/55 - Release Date: 21/07/2005

Re: [Firebird-test] First Question

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

Hi,

Alexandre Benson Smith wrote:
> 
> This is the correct list for FB alpha releases doubts and coments ?

Well, sort of :-) You can use both lists, firebird-test and 
firebird-devel to discus topics related to development releases. More QA 
people hang here, while more core developers hang in devel list than in 
this one. Important information will always find it's way from one list 
to another :-)

best regards
Pavel Cisar
IBPhoenix

[Firebird-test] First Question

[Alexandre B. S. <ib...@th...>]

Hi !

This is the correct list for FB alpha releases doubts and coments ?

see you !

-- 

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.9.2/55 - Release Date: 21/07/2005

[Firebird-test] FB 1.5 with JvUIB fails to create database

[N. B. <aa...@st...>]

I changed DatabaseAccess = Restrict 'D:\myData\Databases' and when calling
JvUIBDatabase.CreateDatabase()
with DatabaseName 'D:\myData\Databases\:mydb.fdb" it fails with a message
about "administrator restricted access to
'D:\myData\Databases\:mydb.fdb".
What is wrong?

[Firebird-test] Ver 2 Alpha 2

[Todd B. <t.b...@de...>]

Sorry for the cross post- I just found this NG

I am trying to restore a backup from Firebird 1.5 to 2 alpha 2 and get this
error:

gbak:    committing metadata
gbak: ERROR:table FACILITY_TEM_MAP is not referenced in plan
gbak:Exiting before completion due to errors

I use plans to optimize most procedures, is this going to be a problem?

metadata is available for testing

Todd

[Firebird-test] Firebird 2 Alpha 2

[Roland T. <ko...@ro...>]

Hello FireBird Support!

I tried to restore after backup and I received these warnings:
----------------------------------------------------------------------
gbak:    restoring index FK_SPISY_POV_ZAST
gbak:    restoring index FK_SPISY_OPRAVNENY_UCET
gbak:    restoring index RDB$FOREIGN59
gbak:    restoring index RDB$FOREIGN60
gbak:    restoring index FK_ADRESAR_ZAMESTNAVATEL
gbak:    committing metadata
gbak: WARNING:Concatenation overflow. Resulting string cannot exceed 32K in leng
th.
gbak: WARNING:    Concatenation overflow. Resulting string cannot exceed 32K in
length.
gbak: WARNING:    Concatenation overflow. Resulting string cannot exceed 32K in
length.
gbak: WARNING:Concatenation overflow. Resulting string cannot exceed 32K in leng
th.
gbak: WARNING:    Concatenation overflow. Resulting string cannot exceed 32K in
length.
gbak: WARNING:    Concatenation overflow. Resulting string cannot exceed 32K in
length.
gbak:finishing, closing, and going home
-----------------------------------------------------------

Why did I receive these warnings?

Thank you.

-- 
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk

[Firebird-test] Firebird 2 Alpha 2 - accessing an UDF

[Roland T. <ko...@ro...>]

Hello FireBird Support!

I have my own UDF which works fine on FB1.5 and I tried to use it with
my application and I receive this error message, but UDF library is in
UDF directory:

Access to UDF/BLOB-filter module "Sedas_Udf." is denied by server administrator.

What I can do?

-- 
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk

[Firebird-test] Firebird 2.0 Alpha-02 Release

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

The Firebird Project is pleased to announce the release today of the second 
round of Firebird 2.0 public Alpha kits for immediate download and testing.
This version of Firebird 2 is an alpha version, meant for field testing 
only and not for use in production.
All changes and new features are subject to further change and/or 
withdrawal in subsequent alpha and beta releases, leading up to final 
release. Do not assume that databases created by or upgraded to the on-disk 
structure of this alpha will be upwardly compatible with subsequent test 
builds/releases.
Bugs, problems, etc. can be posted to the Field Test bug tracker or to the 
Firebird Development List.

Firebird 2 release contains a large number of new features. Alpha 2 
includes fixes for several problems that showed up in the testing of Alpha 
1. Please read the Release Notes for more details.

Downloads of builds for Linux-i686 and Win32 are currently available here:

http://firebird.sourceforge.net/index.php?op=files&id=fb2_alpha02

Feedback, input and comments re this release will be appreciated.

-- Firebird Project 

[Firebird-test] New "Vulcan" category in field test tracker

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

Hi all,

Because we want to keep track of known issues related to current Vulcan 
code (yes, Vulcan is used as is, and reports start to roll in, and more 
would follow once Vulcan alpha would be released), I have created a new 
category "Vulcan" in our *Field test* tracker. So, if you (will) have 
any bug report against Vulcan, please use this general category for all 
Vulcan-related bugs, instead other categories. Taking the state of 
Vulcan release/development, one general category is enough for now to 
distinguish it from FB 2.0 field test bug reports.

best regards
Pavel Cisar

[Firebird-test] Firebird and Visual Studio.Net Server Explorer

[Etienne <mys...@ho...>]

Is it possible to have a Firebird database in the Server Explorer section of 
VS.Net 2003 to edit the database?

Thanks for the info,
Etienne 

Re: [Firebird-test] ]Firebird 2.0 Alpha 1 Database will not restore

[Steve L. <st...@sl...>]

Pavel Cisar wrote:

> Hi,
>
> any chance that your database contains triggers with assign to OLD. 
> context variables?
>

Hi Pavel,

Not intentionally but I will check for that.

Steve

> best regards
> --Pavel
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005
> Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows
> Embedded(r) & Windows Mobile(tm) platforms, applications & content.  
> Register
> by 3/29 & save $300 
> http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>
>

Re: [Firebird-test] ]Firebird 2.0 Alpha 1 Database will not restore

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

Hi,

any chance that your database contains triggers with assign to OLD. 
context variables?

best regards
--Pavel

Re: [Firebird-test] Firebird 2.0, corrupting a db

[Andy C. <an...@ca...>]

Pavel Cisar wrote:
> 
> If the new spot gives you the same error then this is definitely somehow 
> connected to tables (header page is assigned to hold table data in 
> Pointer Page). It would be good to know if header page was overwritten 
> by table data or not (in this case only the Pointer Page was mangled. My 
> personal guess is that the page number was not set at all, so it's still 
> zero and zero means header page). Can you try to run gstat -h on 
> corrupted database? If it fails or show weird results, then header was 
> overwritten.

gstat -h worked fine.  Here's some output:


D:\dbs>gbak -b IOWACITY.IB x.bak
gbak: ERROR:database file appears corrupt ()
gbak: ERROR:    wrong page type
gbak: ERROR:    page 0 is of wrong type (expected 5, found 1)
gbak: ERROR:gds_$compile_request failed
gbak:Exiting before completion due to errors

D:\dbs>gstat -h IOWACITY.IB

Database "IOWACITY.IB"
Database header page information:
         Flags                   0
         Checksum                12345
         Generation              1972
         Page size               4096
         ODS version             11.0 type 0200
         Oldest transaction      1966
         Oldest active           1967
         Oldest snapshot         1967
         Next transaction        1970
         Bumped transaction      1
         Sequence number         0
         Next attachment ID      0
         Implementation ID       16
         Shadow count            0
         Page buffers            0
         Next header page        0
         Database dialect        3
         Creation date           Mar 22, 2005 16:36:45
         Attributes

     Variable header data:
         *END*

Re: [Firebird-test] Firebird 2.0, corrupting a db

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

Andy Colson wrote:

> Shoot...  Things got a little more complicated.  I setup fb2 on my 
> laptop at home, created a new db, and ran my script, and it worked fine. 
>  No problems at all.
> 
> Then I tried the batch function in our application, and at least that 
> still crashed the db.
> 
> (Interesting side note, after the app crashes the db then I can create a 
> new database and just run the script and it will crash.  but If I 
> restart the fb service I can no longer crash with the script alone, I 
> have to run the batch function at least once.)
> 
> (another interesting node: on my pc at work it always crashed at the 
> same spot (giveing me the same table name.  At home it crashed later in 
> the process (a new spot, and always that spot)).

If the new spot gives you the same error then this is definitely somehow 
connected to tables (header page is assigned to hold table data in 
Pointer Page). It would be good to know if header page was overwritten 
by table data or not (in this case only the Pointer Page was mangled. My 
personal guess is that the page number was not set at all, so it's still 
zero and zero means header page). Can you try to run gstat -h on 
corrupted database? If it fails or show weird results, then header was 
overwritten.

I guess that in your narrow-down attempt you should concentrate on 
table/data operations.

> So, I guess we have a couple options.  I can try to pull out the code 
> and make a little test app, or I can setup the application on one of the 
> developers machines.
> 
> I assume they'd prefer a little test app, so I'll start working on that.
> 
> As soon as I get something I'll post to firebird-devel list.

Thanks a lot.

best regards
--Pavel

Re: [Firebird-test] Firebird 2.0, corrupting a db

[Andy C. <an...@ca...>]

Pavel Cisar wrote:
> Hi,
> 
> I forwarded the initial report to firebird-devel.
> 
> Andy Colson wrote:
> 
>> Progress... (well, a little)
>>
>> I was able to extract the sql that is run duing the batch and generate 
>> a sql script.
>>
>> If I run the script with sqlWin it corrupts the db, however, when I 
>> run the script with isql it works fine.
>>
>> When I get home I'm going to make sure I dont have any stray 
>> gds*.dll's or fbclient.dll's laying around, and run it a few times on 
>> my laptop just to make sure its reproducable.
>>
>> then I can post it and see if anyone else gets the problem.
> 
> 
> Great, please send it to firebird-devel because all db corruption issues 
> as top priority ones should be handled there.
> 
> best regards
> Pavel Cisar

Shoot...  Things got a little more complicated.  I setup fb2 on my 
laptop at home, created a new db, and ran my script, and it worked fine. 
  No problems at all.

Then I tried the batch function in our application, and at least that 
still crashed the db.

(Interesting side note, after the app crashes the db then I can create a 
new database and just run the script and it will crash.  but If I 
restart the fb service I can no longer crash with the script alone, I 
have to run the batch function at least once.)

(another interesting node: on my pc at work it always crashed at the 
same spot (giveing me the same table name.  At home it crashed later in 
the process (a new spot, and always that spot)).

So, I guess we have a couple options.  I can try to pull out the code 
and make a little test app, or I can setup the application on one of the 
developers machines.

I assume they'd prefer a little test app, so I'll start working on that.

As soon as I get something I'll post to firebird-devel list.

-Andy

[Firebird-test] ]Firebird 2.0 Alpha 1 Database will not restore

[Steve L. <ste...@gm...>]

Hi all.

I have been trying to post to to the list but it is not showing up so
I apologize in advance for multiple posts.

Thank you all for an execelent job done on Firebird 2.0.  I have been
testing the program with several databases and so far have only found
1 issue with 1 database.

Operating System WinXP SP2
Firebird Superserver
Local restore using gbak did not try with the services api.
30 Gig free on the drive.
Athalon64 3400 processor.

Found a database I can't restore.  This database does restore properly
using 1.5.2 It looks like the restore fails when trying to add a role
to the database. The error message varies depending the switches used
so there may be more than one issue here.

When restoring regularly with just the -c switch the error message is.

D:\>"c:\program files\firebird\firebird_2_0\bin\gbak" -c -user sysdba -password
masterkey d:\db\master.gbk d:\db\master.fdb

gbak: ERROR:attempted update of read-only column
gbak:Exiting before completion due to errors

Using switch -c -i the message is

D:\>"c:\program files\firebird\firebird_2_0\bin\gbak" -c -v -i -user sysdba
-password masterkey d:\db\master.fbk d:\db\master.fdb

gbak:    restoring privilege for user SYSDBA
gbak:    restoring privilege for user SYSDBA
gbak:restoring SQL role: TREADWARE
gbak:creating indexes
gbak:    committing metadata
gbak: ERROR:attempted update of read-only column
gbak:Exiting before completion due to errors

I have the metadata backup that will reproduce this if needed.

Steve