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

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

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

Steve Landrum wrote:
> Hi all.
> 
> 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 can confirm that this issue exists, as I've got another such report.

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

Yes, that would be most helpful. Could you create a bug tracker entry 
for it in Field-test tracker? You can attach the backup to it.

Best regards
Pavel Cisar

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

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

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

[Firebird-test] Database that will not restore using Firebird 2.0 Alpha

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

Hi all.

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

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

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

Andy Colson wrote:
>>
>> I have a createdb app that fires off a "create database" call.  Then 
>> it uses gfix to disable forced writes... (humm.. I'll try the process 
>> using forced writes to see if it makes a difference).
>>
> 
> Using forced writes didnt make a difference.  It still corrupts the db.
> 
> -Andy

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.

-Andy

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

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

> 
> I have a createdb app that fires off a "create database" call.  Then it 
> uses gfix to disable forced writes... (humm.. I'll try the process using 
> forced writes to see if it makes a difference).
> 

Using forced writes didnt make a difference.  It still corrupts the db.

-Andy

[Firebird-test] Firebird 2.0, corrupting a db

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

Hi all.

I have installed fb2 (as a service) on my windows 2000 pc (amd xp 1400, 
512k ram).

I have a reproducable method of corrupting a db, and I get the following 
message:

Message: database file appears corrupt ()
wrong page type
page 0 is of wrong type (expected 5, found 1)

However... setting up to corrupt the db is easy on my pc, but I dont 
know if I can setup my full app on one of the developers pc's.  I can 
get you the database, before and after, if it would help (its about 16 
meg uncompressed).

With a little work I might be able to pull out the code and make a small 
app that recreates the problem... but I cant be sure.

So, I'm wondering... Whats the best way for me to help you?

In general, here is the process:

I have a createdb app that fires off a "create database" call.  Then it 
uses gfix to disable forced writes... (humm.. I'll try the process using 
forced writes to see if it makes a difference).

Then it uses isql to fire off 3 sql scripts.
Then it runs ImportPricing (which dynamicly generates many tables based 
on the structure of some paradox tables)
Then it runs 14 more sql scripts via isql.

This process seems to work, after ward I can backup the database just fine.

In our main application we have a batch process that seems to hose the 
tables though.  during the process I get the above error.  As well, I 
can no longer backup the database (I get the same error).


Your humble tester,

-Andy

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

At 08:44 AM 18/03/2005 -0600, Andy Colson wrote:

>My first message hasnt made it through yet (I wasnt subscribed to the ng 
>yet so it's "being moderated".
>
>I'll just repost it here:
>
>Spelling error:
>at the top of section "Stored Procedure Language (PSQL)"
>
>we see:
>"EXECUTE BLOCK structure as well as in sotred procedures"
>
>sorry, have no idea what page number it is.

Thanks.  All typo reports are welcome.  Don't worry about page numbers, 
what's more useful is the section title (top left of the PDF page), since 
we're building the releasenotes entirely from static HTML files this time 
around.  Less beauty but better version control....

The r/notes ARE going to change again before the Alpha release kits are 
built - projected today or tomorrow.  At the 11th hour, some of the devs 
have decided to correct/update their content.  Translators, please take 
note....

regards,
Helen

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

Helen Borrie wrote:
> At 12:04 PM 17/03/2005 -0600, you wrote:
> 
>> Andy Colson wrote:
>>
>>> Helen Borrie wrote:
>>>
>>>> I hope some of the international language test group coordinators 
>>>> are watching this and can update their links to the Alpha release 
>>>> notes.
>>>> The link is now
>>>>
>>>> http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
>>>>
>>>>
>>>> In case anyone reading this is on the translator team for release 
>>>> notes, please contact me if you are ready to receive the source.
>>>>
>>>> regards
>>>> Helen
>>
>>
>> In Section: "ISQL improvements",
>> the second bullet says: "When isql stops, it means"  and just stops. 
>> What?  What does it mean?!  Dont leave me hanging like this!  :-)
> 
> 
> It should have been deleted.
> 
> 
>> Also a question (you may want to add), I assume with the -b[ail] 
>> option that if there is an error the last tranaction is rolled back?  
>> The doc doesnt comment if this is the case or not.
> 
> 
> If you understand how isql scripts work, you'll know that the default is 
> SET AUTO ON, which causes each statement to be executed in its own 
> transaction.  With SET AUTO OFF, everything (tries to) happen[s] in one 
> transaction.  So the transaction effect really depends on that setting.
> 
> Since it's not the purpose of the release notes to teach people how to 
> use ancient utility programs, but to introduce new/changed features, I 
> think it would be inconsistent to include "how-to basics" for isql...
> 
> Thanks for the proof-reading, though - much appreciated.
> 
> regards,
> Helen

:-)  yea, you can see how much I'v used isql, huh?  You are correct 
though, when reading that doc I was only interested in the new/changed.

My first message hasnt made it through yet (I wasnt subscribed to the ng 
yet so it's "being moderated".

I'll just repost it here:

Spelling error:
at the top of section "Stored Procedure Language (PSQL)"

we see:
"EXECUTE BLOCK structure as well as in sotred procedures"

sorry, have no idea what page number it is.


-Andy

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

At 10:45 AM 17/03/2005 -0600, you wrote:
>Helen Borrie wrote:
>>I hope some of the international language test group coordinators are 
>>watching this and can update their links to the Alpha release notes.
>>The link is now
>>http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
>>
>>In case anyone reading this is on the translator team for release notes, 
>>please contact me if you are ready to receive the source.
>>regards
>>Helen
>
>Found another error...
>
>Section: "PSQL stack trace          V. Horsun"
>Line: "The API client can now extract s simple"

Thanks for the proof-reading assistance!

Helen

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

At 12:04 PM 17/03/2005 -0600, you wrote:
>Andy Colson wrote:
>>Helen Borrie wrote:
>>
>>>I hope some of the international language test group coordinators are 
>>>watching this and can update their links to the Alpha release notes.
>>>The link is now
>>>
>>>http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
>>>
>>>
>>>In case anyone reading this is on the translator team for release notes, 
>>>please contact me if you are ready to receive the source.
>>>
>>>regards
>>>Helen
>
>In Section: "ISQL improvements",
>the second bullet says: "When isql stops, it means"  and just stops. 
>What?  What does it mean?!  Dont leave me hanging like this!  :-)

It should have been deleted.


>Also a question (you may want to add), I assume with the -b[ail] option 
>that if there is an error the last tranaction is rolled back?  The doc 
>doesnt comment if this is the case or not.

If you understand how isql scripts work, you'll know that the default is 
SET AUTO ON, which causes each statement to be executed in its own 
transaction.  With SET AUTO OFF, everything (tries to) happen[s] in one 
transaction.  So the transaction effect really depends on that setting.

Since it's not the purpose of the release notes to teach people how to use 
ancient utility programs, but to introduce new/changed features, I think it 
would be inconsistent to include "how-to basics" for isql...

Thanks for the proof-reading, though - much appreciated.

regards,
Helen

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

Andy Colson wrote:
> Helen Borrie wrote:
> 
>> I hope some of the international language test group coordinators are 
>> watching this and can update their links to the Alpha release notes.  
>> The link is now
>>
>> http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
>>
>>
>> In case anyone reading this is on the translator team for release 
>> notes, please contact me if you are ready to receive the source.
>>
>> regards
>> Helen

In Section: "ISQL improvements",
the second bullet says: "When isql stops, it means"  and just stops. 
What?  What does it mean?!  Dont leave me hanging like this!  :-)

Also a question (you may want to add), I assume with the -b[ail] option 
that if there is an error the last tranaction is rolled back?  The doc 
doesnt comment if this is the case or not.

-Andy

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

Helen Borrie wrote:
> I hope some of the international language test group coordinators are 
> watching this and can update their links to the Alpha release notes.  
> The link is now
> 
> http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
> 
> 
> In case anyone reading this is on the translator team for release notes, 
> please contact me if you are ready to receive the source.
> 
> regards
> Helen

Found another error...

Section: "PSQL stack trace          V. Horsun"
Line: "The API client can now extract s simple"


-Andy

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

[andy <and...@ca...>]

Helen Borrie wrote:
> I hope some of the international language test group coordinators are 
> watching this and can update their links to the Alpha release notes.  
> The link is now
> 
> http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 
> 
> 
> In case anyone reading this is on the translator team for release notes, 
> please contact me if you are ready to receive the source.
> 
> regards
> Helen


Spelling error:
at the top of section "Stored Procedure Language (PSQL)"

we see:
"EXECUTE BLOCK structure as well as in sotred procedures"

sorry, have no idea what page number it is.

-Andy

Re: [Firebird-test] Firebird 2 alpha release notes NEW LINK

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

At 01:09 PM 17/03/2005 +0200, Mustafa YILMAZ wrote:
>is link correct and server up ?
>error "HTTP 404 - File not found"
>
sorry, typo


> >
>http://firebird.sourceforge.net/download/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip
> >

Helen 

[Firebird-test] Firebird 2 alpha release notes NEW LINK

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

I hope some of the international language test group coordinators are 
watching this and can update their links to the Alpha release notes.  The 
link is now

http://firebird.sourceforge.net/downloads/prerelease/Firebird_v2Alpha01.ReleaseNotes_0200_02.zip 


In case anyone reading this is on the translator team for release notes, 
please contact me if you are ready to receive the source.

regards
Helen

[Firebird-test] Firebird 2.0: Call for testers

[marius p. <ma...@re...>]

there are any official page for this call ?

http://lxer.com/nw_viewvote.php?id=32610

is better for posting it on other sites that don't accept news from blogs :(
-- 
Regards,

Marius - linux admin

Re: [Firebird-test] database corrupt

[Feroz <fa...@pr...>]

i think u shoud post this one in firebird-support.

""lmf"" <lm...@yg...> wrote in message news:cop02p$59n$1...@ne......
>    We use firebird 1.52 RC4 as our enterise database system, there are 
> four
> or five database file in our Win2000 NTFS file volume, the corrupt 
> database
> is D:\DATA\SSERP.GDB and the size of the database is 4345612 KB. There are
> more than 600 table in the database, if include other objects like views,
> store procedures, triggers, and indexes, there are more than 900 objects 
> in
> the database.
>    Several days ago, the database corrupted, and all client cannot access
> databases in the Win2000 machine. Three days before yesterday we tried
> almost we could tried and at last we used Firebird 2.0 and succeed in
> mending, backuping and restoring the database.
>    But the database only runned two days, yesterday it could not work
> again, and at the night we dropped one big table, then we could backup and
> restore the database with Firebird 1.52 RC4, and mend, backup, restore the
> database with the big table with Firebird 2.0, at last we merged the big
> table into the database.
>    Today the database corrupted again!!! And it cannot connect it
> gain( mabye it says that the database file is used by other user). We feel
> very shameful at our clients. I dont know what is limit of the firebird
> database system, who can give me some explanation.
>    The followings is today's firdbird.log
>
> Database: D:\DATA\SSERP.GDB
> database file appears corrupt ()
> wrong page type
> page 1056022 is of wrong type (expected 7, found 5)
> internal gds software consistency check (error during savepoint backout
> (290), file: exe.cpp line: 2807)
>
>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
> 

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

[Jocelyn D. <joc...@ur...>]

Test.


"Chau Chee Yang" <cc...@es...> a écrit dans le message de news: 
412...@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
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
> 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
> Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
> http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
> 

Re: [Firebird-test] newbie testing questions

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

Hi Leen,

Leen De Schutter wrote:
> Hi guys,
> 
> I want to run the tests accompanying Firebird, but I can't get the hang
> of it. I downloaded the latest stable release (Firebird 1.5.1), Qmtest
> (+ dependencies), read the QA docs a couple of times, but I can't find
> out where to download the Firebird QA toolbox mentioned in the docs (I
> need the qadbm tool in order to create a test database from the CVS
> module qdbm - and qadbm seems to be part of that QA toolkit).

Well, sorry, but off-the-shelf QA package is not yet available for 
download. We're working on one. For time being, you need to checkout the 
qmdb module from our CVS. The qadbm tool (qadbm.py) is right there. It's 
a CLI tool that has its own command shell and integrated help.

> I don't even know if I will be able to run all of the tests since the
> README accompanying the qmdb module says something about the tests not
> running on Linux (which is my OS). Does anyone know if this has been
> fixed?

The README is outdated. Looks like I forgot to commit new ones to the 
CVS. Will fix that soon. But guides on our website should provide you 
with all information you'd need. If not, feel free to ask here. And YES, 
the test suite works on Linux.

> Also, when looking at the CVS tree, I saw that there was a directory
> called client-java containing (predictably :) Java code. That code is
> accompanied by JUnit test code which should, unlike the rest of the
> QMtests, run on Linux. But I can't seem to figure out what this part
> does exactly. I've seen that this code is not part of the stable release
> I downloaded from Sourceforge, and I wonder why.

client-java is our JayBird JDBC type 4 and 2 driver. It has it's own 
JUnit-based test suite. It's packaged and available separately from core 
engine, because its development cycle is independent from it. JayBird QA 
is done by JayBird development team itself, separately from core engine QA.

There are also .NET Data Provider and ODBC driver. I'm not sure about 
ODBC right now, but .NET Data provider definitely has xUnit test suite too.

Best regards
Pavel Cisar

[Firebird-test] newbie testing questions

[Leen De S. <lee...@sc...>]

Hi guys,

I want to run the tests accompanying Firebird, but I can't get the hang
of it. I downloaded the latest stable release (Firebird 1.5.1), Qmtest
(+ dependencies), read the QA docs a couple of times, but I can't find
out where to download the Firebird QA toolbox mentioned in the docs (I
need the qadbm tool in order to create a test database from the CVS
module qdbm - and qadbm seems to be part of that QA toolkit).
 
I don't even know if I will be able to run all of the tests since the
README accompanying the qmdb module says something about the tests not
running on Linux (which is my OS). Does anyone know if this has been
fixed?

Also, when looking at the CVS tree, I saw that there was a directory
called client-java containing (predictably :) Java code. That code is
accompanied by JUnit test code which should, unlike the rest of the
QMtests, run on Linux. But I can't seem to figure out what this part
does exactly. I've seen that this code is not part of the stable release
I downloaded from Sourceforge, and I wonder why.

I apologize in advance if these questions seem ignorant to you guys :/
The problem is that I don't have the time to dig any further and find
the answers myself. I'm reviewing Firebird as part of my master's
thesis, and I can't afford to spend weeks trying to understand what each
part of the code does. I've read most of the docs I could get my hands
on (both in the Sourceforge docs section and the homepage docs), but I
still can't find the information I'm looking for.

It would be really great if you guys could help me out.

Thanks in advance!

Leen

PS: If you want to follow up on the review, here's the link:
http://www.win.ua.ac.be/~s005407/thesis/pmwiki.php/ThesisTracker/Firebird
Comments and suggestions are always welcome.

[Firebird-test] database corrupt

[lmf <lm...@yg...>]

    We use firebird 1.52 RC4 as our enterise database system, there are four
or five database file in our Win2000 NTFS file volume, the corrupt database
is D:\DATA\SSERP.GDB and the size of the database is 4345612 KB. There are
more than 600 table in the database, if include other objects like views,
store procedures, triggers, and indexes, there are more than 900 objects in
the database.
    Several days ago, the database corrupted, and all client cannot access
databases in the Win2000 machine. Three days before yesterday we tried
almost we could tried and at last we used Firebird 2.0 and succeed in
mending, backuping and restoring the database.
    But the database only runned two days, yesterday it could not work
again, and at the night we dropped one big table, then we could backup and
restore the database with Firebird 1.52 RC4, and mend, backup, restore the
database with the big table with Firebird 2.0, at last we merged the big
table into the database.
    Today the database corrupted again!!! And it cannot connect it
gain( mabye it says that the database file is used by other user). We feel
very shameful at our clients. I dont know what is limit of the firebird
database system, who can give me some explanation.
    The followings is today's firdbird.log

 Database: D:\DATA\SSERP.GDB
 database file appears corrupt ()
 wrong page type
 page 1056022 is of wrong type (expected 7, found 5)
 internal gds software consistency check (error during savepoint backout
(290), file: exe.cpp line: 2807)

[Firebird-test] Firebird QA updates

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

Hi all,

As you may have noticed, there are some new changes and improvements.

1. I completely rewrote the qadbm tool. Above all, it now uses it's own 
command shell with integrated help. 

2. FirebirdTest class now fully supports UNICODE.

3. FirebirdTest class now support interactive debugging of Python-based 
tests.

I've also updated QA papers 
(http://firebird.sourceforge.net/index.php?op=devel&sub=qa) about how to 
use qmtest and how to implement new tests re. unicode and integrated 
debugger.

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

Re: [Firebird-test] New Features in Unify

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

Sorry Guys. Message sent to this list by mistake.

Can somebody delete this ?

JS


""Joga Singh"" <jog...@in...> wrote in message
news:cmurfu$cgn$1...@ne......
> 1. Qos Polices
>     - Burstable Bandwidth
>     - Contention Ratio
>
> 2. Packages
>     - Multiple Service Types
>     - Quota and Validity Expiry Policies
>     - Day and Holidays specific QoS Policies
>
> 3. Messages & Announcements
>
> 4. Pre-Paid
>     - Copon Upload facility - administrator can upload the coupons from a
> text file
>     - Coupon PIN generation facility.
>     - Coupon Inventory - issues to franchise etc.
>     - Void coupons.
>     - Value based coupons
>     - New Reports
>         - Activations, Deactivations in a period, domain and coupon type
>         - Inventory status
>
> 5. Separate admin rights for Post-Paid and Pre-Paid accounts.
>
> 6. Networking
>     - P2P and URL blocking
>     - Multi-Gateway and Load Balancing
>     - Subneting
>     - PPPoE Support
>     - Windows Client
>     - Surveillance
>     - Proxy Control - Number of TCP sessions
>
> 7. Graphs
>     - Link Graphs
>     - Layer7 Graphs for Users
>     - Total Graph
>
> 8. Basic Post-Paid Billing
>
>
>
> JS
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> Firebird-test mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-test
>

[Firebird-test] New Features in Unify

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

1. Qos Polices
    - Burstable Bandwidth
    - Contention Ratio

2. Packages
    - Multiple Service Types
    - Quota and Validity Expiry Policies
    - Day and Holidays specific QoS Policies

3. Messages & Announcements

4. Pre-Paid
    - Copon Upload facility - administrator can upload the coupons from a
text file
    - Coupon PIN generation facility.
    - Coupon Inventory - issues to franchise etc.
    - Void coupons.
    - Value based coupons
    - New Reports
        - Activations, Deactivations in a period, domain and coupon type
        - Inventory status

5. Separate admin rights for Post-Paid and Pre-Paid accounts.

6. Networking
    - P2P and URL blocking
    - Multi-Gateway and Load Balancing
    - Subneting
    - PPPoE Support
    - Windows Client
    - Surveillance
    - Proxy Control - Number of TCP sessions

7. Graphs
    - Link Graphs
    - Layer7 Graphs for Users
    - Total Graph

8. Basic Post-Paid Billing



JS

Re: [Firebird-test] Memory Usage Test

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

I am using 1.5.1 on linux.
I had posted my further experiment on the firebird-devel list. What I found
out was that this behaviour occurs only when any udf library is statically
linked with libfbclient. fbudf (which comes with 1.5.1 distribtion) is
linked with libfbclient for its dependency on 'isc_decode_timestamp' etc. If
I remove the linking of libfbclient it (addDay) function works fine. But
then there are some functions (addYear), which stops working.

Some people had suggested me to test the 1.5.2, but I havn't had the chance
to test it yet.

JS



----- Original Message ----- 
From: "Leyne, Sean" <Se...@br...>
To: "Joga Singh" <jog...@in...>;
<fir...@li...>
Sent: Monday, November 08, 2004 11:18 PM
Subject: RE: [Firebird-test] Memory Usage Test


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


-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_idU88&alloc_id065&op=ick
_______________________________________________
Firebird-test mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-test