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

[Firebird-test] Abwesenheitsnotiz: SPAM:(2494.1) * [Firebird-devel] [FB-Tracker] Created: (CORE-4101) firebird.log contrains "I/O error during "write" operation" records but database works corrrectly

[HEIN. - H. T. <HE...@ho...>]

Vielen Dank für Ihre Nachricht. Ich bin bis einschließlich 26.05.2013 nicht im Büro. E-Mails werden nicht automatisch weitergeleitet. 
Bitte wenden Sie sich in dringenden Fällen an: Frau Specht, Tel.:+49 511 6102-234, E-Mail: sp...@ho...

Thank you for your email. I'll be out of the office until 2013-05-26. Please note that emails will not be forwarded automatically. 
For urgent matters please contact Mrs. Specht, phone: +49 511 6102-234, email: sp...@ho... 

Mit freundlichen Grüßen / Best regards

Thomas Hein
_____________________________
Höft & Wessel AG
F&E Backoffice
i. A. Thomas Hein
Rotenburger Straße 20 
30659 Hannover 
                                                                  
Tel	+49 511 6102-573
Fax	+49 511 6102-421 
Mail	he...@ho...
Web	www.hoeft-wessel.com
---------------------------------------------------------------------------------------------------------------
Höft & Wessel Aktiengesellschaft, Sitz Hannover 
Handelsregister (Commercial register): Amtsgericht Hannover HRB 57006 
USt-ID (VAT): DE 115681962 - WEEE-Reg.-Nr. DE 68170458
Vorstand (Board of Management): Rudolf Spiller (CEO)
Vorsitzender des Aufsichtsrates (Chairman of the Supervisory Board): Prof. Dr. Dr.-Ing. Dr. h.c. Klaus E. Goehrmann

[Firebird-test] New version of fbtest

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

Hi all,

Our QA toolset fbtest was significantly reworked. Now you can get it 
from PyPI (including documentation) at:
https://pypi.python.org/pypi/fbtest

best regards
Pavel Cisar
IBPhoenix

[Firebird-test] Abwesenheitsnotiz: [FB-Tracker] Updated: (CORE-2668) Write note into log when automatic sweep is started

[Christian M. - Z. A. G. <ma...@ze...>]

Vielen Dank für Ihre Nachricht. Ich bin am 16. Juli 2012 wieder im Büro. 
In dringenden Fällen wenden Sie sich bitte an Herrn Till Grondkowski (gro...@ze..., Tel.: +49 40 30 68 76 89).

Thank you for your e-mail. I will be back in the office on 16 July 2012. In urgent cases please contact Mr. Till Grondkowski (gro...@ze..., Tel.: +49 40 30 68 76 89).

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-659) gis implementation (opengis)

[Poul D. <pd...@ta...>]

We might be interested in sponsoring this feature. 

But as I guess ressources are limited, my first priority is that our current "hard core developers" are concentrating on making FB3 fly. 

I have no what so ever experience or knowledge of implementation of GIS, I just know that our developers here are looking at PostGress as a storage for GIS data. Meaning we will eventually be running two databases (well, we already use PostGress for some project with Ruby on Rails because Rails and PostGress are like PHP and MySQL... at least that's my understanding of it).

Perhaps (still I'm completely ignorant) the PostGis code could be adapted "easily" to fit into Firebird. But I'm not that ignorant that I don't know that it is only easy for those who don't have to do it :)

Regards
Poul



 

> -----Oprindelig meddelelse-----
> Fra: Juergen Seelmann (JIRA) [mailto:tr...@fi...]
> Sendt: 7. marts 2012 03:34
> Til: Poul Dige
> Emne: [FB-Tracker] Commented: (CORE-659) gis implementation (opengis)
> 
> 
>     [ http://tracker.firebirdsql.org/browse/CORE-
> 659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-
> tabpanel&focusedCommentId=24968#action_24968 ]
> 
> Juergen Seelmann commented on CORE-659:
> ---------------------------------------
> 
> Sorry, I send a bit fast yesterday: Can we take up this BLOG proposal: To gather all
> those who would support/sponsor the issue?
> I wouldn't like to use a 'slow' database such as PostGre/PostGIS just for 'fast' GIS...
> 
> 
> 
> 
> 
> > gis implementation (opengis)
> > ----------------------------
> >
> >                 Key: CORE-659
> >                 URL: http://tracker.firebirdsql.org/browse/CORE-659
> >             Project: Firebird Core
> >          Issue Type: New Feature
> >          Components: Engine
> >            Reporter: kohan_gg
> >
> > SFID: 995200#
> > Submitted By: kohan_gg
> > Implementation of spatial operator (cf. opengis
> > consortium) will be very very useful
> > For example Postgres and Mysql had already yet implemented.
> > Do you think that it's possible in near future ?
> 
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://tracker.firebirdsql.org/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
> 
> 

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3772) Firebird 2.5 GBak Restore does not create a required USERS table when backing up and restoring a Fb2.0-formatted database.

[<Pv...@zo...>]

Hello Dmitry,

Thanks for your quick response.

However, I think you missed my point; the issue is ***** GBAK ******  (and
not gsec, the latter just reports a missing table USERS).

I still have a question:  How can I appoint co-admins to a specific database
only.

Please read the following text fragment, taken from the description of
Firebird 2.5 QuickStart manual,
topic "Server configuration and management" and sub-topics "Appointing
co-administrators" and "Differences between co-administrators and SYSDBA":

"Please remember:
The RDB$ADMIN role in a database gives the grantee SYSDBA rights in that
database only!

    If it is the security database, the grantee can manage user accounts,
but has no special privileges in other databases.

    If it is a regular database, the grantee can control that database like
he was SYSDBA, but again has no special privileges in other databases, and
has no user administation privileges.
"


As said, earlier, GSEC reports that a USERS table should be defined in a
custom database.
*******************************************************************
***** The issue isn't in GSEC, but the issue is in GBAK! **********
*******************************************************************

Also, to make use of the monitor tables, to see the number of attachments
for example (needed for multi-user usage), one need to log in with the
rdb$admin role. Well, THIS ONLY WORKS WHEN THE USERS TABLE IS IN PLACE! Do
you know another solution?

To me, and to gsec, a table USERS is required.

Please tell me how to appoint co-admins in a custom database that was backed
up and restore with gbak 2.5.1.

Best regards,
Peter  

-----Oorspronkelijk bericht-----
Van: Dmitry Yemanov (JIRA) [mailto:tr...@fi...] 
Verzonden: vrijdag 24 februari 2012 18:35
Aan: pv...@zo...
Onderwerp: [FB-Tracker] Commented: (CORE-3772) Firebird 2.5 GBak Restore
does not create a required USERS table when backing up and restoring a
Fb2.0-formatted database.


    [
http://tracker.firebirdsql.org/browse/CORE-3772?page=com.atlassian.jira.plug
in.system.issuetabpanels:comment-tabpanel&focusedCommentId=24936#action_2493
6 ] 

Dmitry Yemanov commented on CORE-3772:
--------------------------------------

USERS is not a system table per se and it's not a part of the Firebird ODS.
It exists in security2.fdb only and GSEC requires it being present there.
But it *should not* exist in any other database. And GSEC *is not* intended
to work with security in user databases.

Thus I see no issue here and IMO this ticket must be rejected.

> Firebird 2.5 GBak Restore does not create a required USERS table when
backing up and restoring a Fb2.0-formatted database.
> ----------------------------------------------------------------------
> ----------------------------------------------------
>
>                 Key: CORE-3772
>                 URL: http://tracker.firebirdsql.org/browse/CORE-3772
>             Project: Firebird Core
>          Issue Type: Bug
>          Components: GBAK
>    Affects Versions: 2.5.1
>         Environment: Firebird 2.5.1 on Windows (7, Vista and XP)
>            Reporter: Peter Vandel
>
> To reproduce:
>   Use Firebird 2.5.1 utility gbak.exe to backup a Firebird database which
has an old 2.0 format.
>   Use Firebird 2.5.1 utility gbak.exe to restore from the backup file made
above.
> The converted database does contain the new (2.1) Monitor tables (like 
> MON$ATTACHMENTS, etc.) HOWEVER, the same database does not contain a USERS
(or RDB$USERS) table.
> The USERS table is required by gsec.exe to add co-admins users to a custom
database.
> GSec reports the following if USERS does not exist.
> "gsec -user sysdba -pass <pw> -database <database name/alias>"
> GSEC> disp
> gesec reports the following error: "invalid request BLR at offset 37 table
USERS is not defined".
> A workaround can be to create the table yourself in the database.
> Ok, I hope this isue can be solved soon.
> Thanks in advance,
> Peter Vandel.
> Firebird 2.5 GBak Restore does not create a USERS or RDB$USERS table 
> when restoring a 2.0-formatted database

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

        

Re: [Firebird-test] [FB-Tracker] Resolved: (CORE-3772) Firebird 2.5 GBak Restore does not create a required USERS table when backing up and restoring a Fb2.0-formatted database.

[<Pv...@zo...>]

Hello Sean,

Please make Firebird a greater product and do not resolve this ticket.
Please, first ask some other specialists.

Read the QuickStart 2.5.1 manual about 'Appointing co-administrators' and
tell me then how to appoint co-admins in a custom Firebird database that was
in the old v2.0-format, is backed up and restore with gbak 2.5.1.

Best regards,
Peter.

-----Oorspronkelijk bericht-----
Van: Sean Leyne (JIRA) [mailto:tr...@fi...] 
Verzonden: vrijdag 24 februari 2012 19:25
Aan: pv...@zo...
Onderwerp: [FB-Tracker] Resolved: (CORE-3772) Firebird 2.5 GBak Restore does
not create a required USERS table when backing up and restoring a
Fb2.0-formatted database.


     [
http://tracker.firebirdsql.org/browse/CORE-3772?page=com.atlassian.jira.plug
in.system.issuetabpanels:all-tabpanel ]

Sean Leyne resolved CORE-3772.
------------------------------

    Resolution: Won't Fix

> Firebird 2.5 GBak Restore does not create a required USERS table when
backing up and restoring a Fb2.0-formatted database.
> ----------------------------------------------------------------------
> ----------------------------------------------------
>
>                 Key: CORE-3772
>                 URL: http://tracker.firebirdsql.org/browse/CORE-3772
>             Project: Firebird Core
>          Issue Type: Bug
>          Components: GBAK
>    Affects Versions: 2.5.1
>         Environment: Firebird 2.5.1 on Windows (7, Vista and XP)
>            Reporter: Peter Vandel
>
> To reproduce:
>   Use Firebird 2.5.1 utility gbak.exe to backup a Firebird database which
has an old 2.0 format.
>   Use Firebird 2.5.1 utility gbak.exe to restore from the backup file made
above.
> The converted database does contain the new (2.1) Monitor tables (like 
> MON$ATTACHMENTS, etc.) HOWEVER, the same database does not contain a USERS
(or RDB$USERS) table.
> The USERS table is required by gsec.exe to add co-admins users to a custom
database.
> GSec reports the following if USERS does not exist.
> "gsec -user sysdba -pass <pw> -database <database name/alias>"
> GSEC> disp
> gesec reports the following error: "invalid request BLR at offset 37 table
USERS is not defined".
> A workaround can be to create the table yourself in the database.
> Ok, I hope this isue can be solved soon.
> Thanks in advance,
> Peter Vandel.
> Firebird 2.5 GBak Restore does not create a USERS or RDB$USERS table 
> when restoring a 2.0-formatted database

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

        

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3738) Charset UTF8 with collate UNICODE: ORDER BY works wrong for polish characters

[Ann H. <aha...@nu...>]

On Sat, Jan 21, 2012 at 12:52 PM, Mariusz Nogala <mn...@am...> wrote:

Quite possibly I'm responding to a month-old message that's been
answered elsewhere, but it appeared for me on Firebird-tests and
belongs to Firebird-support, so I'm responding in two places.  The
message was a response to a bug report (CORE-3738) about the collation
of some Polish characters under the default UTF-8 collation.

>
> I have tried the solution with CREATE COLLATION,
> but it does not solve my problem.

You may not have followed all the steps in creating and using a collation.

> (moreover the attribute LOCALE does not work with my
> Firebird 2.5.1. I don't know why).

Some databases intuit a lot of information from the LOCALE of the
server, including character set and collation for string data, date
format, whether fractions are separated from integer parts of numbers
with a "," or a "." and inversely whether hundreds are separated by a
".' or a ",".  Firebird does not.  And that's a good thing, in my
opinion.  When server determines all those things from its locale,
writing multi-lingual applications becomes a nightmare.  My career in
databases spans the old days of "ASCII is good enough for me, it
should be good enough for you" and "If God had meant upper and lower
case to sort near each other, He wouldn't have put them so far apart
in the ASCII code set"  through "Why don't Americans care about
rational sorting of upper and lower case?" and "My character set is
better than your character set"  to the relative peace of Unicode and
UTF-8.

Then from time to time there's a collation problem.  We all have
cultural biases - people who live at the edges of several cultures are
more aware of them than others. A bias that's hard to recognize is
"When I learned my alphabet (at the age of 4 or 5), I learned the one
true order of characters in the world.  My kindergarten teacher would
never lie to me."  Alas, no.  Nearly every country orders words
differently - non-phonetic character sets being the most confusing to
those of us who learned them late in life.  But even in phonetic
languages with Latin character sets, there are huge differences in the
"right" sorting of characters.  In some Iberian langauges, "ll"
(double L) sorts after "y" and nowhere near a single lower case L.
And, in some cases, the same character ("a" with a circle over it in
Nordic languages for one) sorts in different places in different
languages.

>
> But I am not convinced.

I believe you.  You want a classic Polish collation.  That requires a
table - possibly quite complex - that matches each character's binary
representation with a weighted version that sorts naturally in the way
you expect.  The weighted versions are often larger than the binary
representation of the character - often two bytes, sometimes three for
multi-level collations.  The Unicode Standard Website probably has one
- start at Unicode.org.  Then build that table into a collation object
that Firebird can use, then introduce it through the collations table,
then use that collation name as the default for the database, or for
each column that you want to have ordered that way.

> I steel think that something is wrong with collate UNICODE.

Unfortunately, the correct collation for Unicode is whatever the
Unicode standard organization says it is, however illogical it may
seem and however much it may violate your kindergarten teacher's
rules.

> The point is that it sorts single character texts properly and
> longer texts IN A DIFFERENT WAY. The sorting order should
> mainly depend on the first character in a column.

Sometimes it depends on the first two.  Sometimes it depends on the
last accented character in the string (French is accent sensitive, but
considers accents from the back forward.)

> If accented characters follow the non-accented in single character texts,
> so why it does not happen when sorting longer texts?
>
> See the example:
>
> ORDER BY gives:
> a, ą, ab   (here 'ą' follows 'a', but not 'ab' - it makes no sense...)
>
> I am sure it should be:
> a, ab, ą   (because UNICODE collation is accent sensitive)
>

That is the effect of a secondary ordering.  In the primary ordering a
and ą are equal, so the next letters are considered.   Once the whole
string has been compared and the two are still equal, the secondary
characteristics are considered.  In the secondary ordering  a comes
before ą.  To extend your example

a, ą, ab, ąb, abc, ac, ąc,

The correct Polish collation may consider a and ą to be different in
primary ordering, but the ordering in the Unicode collation does not.

Good luck,

Ann

Re: [Firebird-test] Quality Assurance Project Status

[Luca B. <lb...@gm...>]

On Fri, Feb 17, 2012 at 4:52 PM, Mark Rotteveel <ma...@la...> wrote:
> I think it is more that for most people this setup and intent of this list
> was not known; the silence on the mailinglist at least does not inspire to
> participate ;)

Not only to partecipate (and eventually contribute) but can also
discourage the adoption (well I'll admit I worked too much in
"*-critical" sector).
Anyhow this weekend I've already planned an  exploration of the codebase...

Re: [Firebird-test] Quality Assurance Project Status

[Mark R. <ma...@la...>]

On Fri, 17 Feb 2012 16:42:40 +0100, Pavel Cisar <pc...@ib...>
wrote:
> Dne 17.2.2012 15:11, Luca Benini napsal(a):
>> Hi All (if there's someone :) )
>> 
>> I've a question: Is the Firebird QA project live or dead?
>> I wasn't able to find nothing more recent than 2 years and also the
>> empty page "List of Tests" on web sites doesn't look very promising
> 
> Firebird QA it's pretty much alive and kicking :) Empty list of tests is
> an artefact of migration to new test system and migration of Firebird
> website to new platform as well. All QA tools and tests are in project's
> Subversion repository, module QA, current suite is fbtest. This list is
> dormant as QA team communication is mostly direct or in Admin group
> (reports), this list is for communication between QA team and public.
> Seems that nobody was interested to intercept QA team through it for
> long time :)

I think it is more that for most people this setup and intent of this list
was not known; the silence on the mailinglist at least does not inspire to
participate ;)

Mark

Re: [Firebird-test] Quality Assurance Project Status

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

Dne 17.2.2012 15:11, Luca Benini napsal(a):
> Hi All (if there's someone :) )
> 
> I've a question: Is the Firebird QA project live or dead?
> I wasn't able to find nothing more recent than 2 years and also the
> empty page "List of Tests" on web sites doesn't look very promising

Firebird QA it's pretty much alive and kicking :) Empty list of tests is
an artefact of migration to new test system and migration of Firebird
website to new platform as well. All QA tools and tests are in project's
Subversion repository, module QA, current suite is fbtest. This list is
dormant as QA team communication is mostly direct or in Admin group
(reports), this list is for communication between QA team and public.
Seems that nobody was interested to intercept QA team through it for
long time :)

best regards
Pavel Cisar
Firebird QA Team
IBPhoenix

[Firebird-test] Quality Assurance Project Status

[Luca B. <lb...@gm...>]

Hi All (if there's someone :) )

I've a question: Is the Firebird QA project live or dead?
I wasn't able to find nothing more recent than 2 years and also the
empty page "List of Tests" on web sites doesn't look very promising

Luca

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3738) Charset UTF8 with collate UNICODE: ORDER BY works wrong for polish characters

[Mariusz N. <mn...@am...>]

Thank you very much for your (very quick) answer !!!


I have tried the solution with CREATE COLLATION,
but it does not solve my problem.
(moreover the attribute LOCALE does not work with my
Firebird 2.5.1. I don't know why).

But I am not convinced.
I steel think that something is wrong with collate UNICODE.
The point is that it sorts single character texts properly and
longer texts IN A DIFFERENT WAY. The sorting order should
mainly depend on the first character in a column.
If accented characters follow the non-accented in single character texts,
so why it does not happen when sorting longer texts?

See the example:

ORDER BY gives:
a, ą, ab   (here 'ą' follows 'a', but not 'ab' - it makes no sense...)

I am sure it should be:
a, ab, ą   (because UNICODE collation is accent sensitive)



Best regards
Mariusz Nogala

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3688) Fast method to get transaction ID

[Dimitry S. <sd...@ib...>]

05.12.2011 11:10, Alexander Peshkov (JIRA) wrote:
> Alexander Peshkov commented on CORE-3688:
> -----------------------------------------
>
> One question - what is suggetsed to do if this is distributed transaction?

   I'm disappointed in distributed transactions, so I don't care. What is returned by 
getInfo() for them?

-- 
   SY, SD.

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3591) gbak intermittantly reports "Fatal lock manager error: invalid lock id (143540), errno: 22"

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

Nick Upson  [2011-09-06 12:34] :
> its just that there is a company policy that prefers author-generated rpms
> for software, second choice is where we produce the rpm.
> 
I'm the maintainer of Firebird rpm for Fedora, Centos, RHEL
so these rpm in EPEL repository as just as it "author-generated rpms"

;)

unless, you can use tar.gz without problem

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3591) gbak intermittantly reports "Fatal lock manager error: invalid lock id (143540), errno: 22"

[Nick U. <nu...@te...>]

On 6 September 2011 11:28, Alexander Peshkov (JIRA) <tr...@fi...
> wrote:

>
>    [
> http://tracker.firebirdsql.org/browse/CORE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=24036#action_24036]
>
> Alexander Peshkov commented on CORE-3591:
> -----------------------------------------
>
> The reason to drop rpm support is very simple - we can't provide enough
> good quality of rpm-s for difefrent distros and can't release as many types
> of rpms as types of linux distro-s exist.
> I'm very sorry if you will have to change the database due to such strange
> reason... Be sure that .tar.gz installer is fine when upgrading database.
> And certainly you are free to build your own rpm! Moreover, if it's specific
> for centos it will upgrade perfectly.
>
>
its just that there is a company policy that prefers author-generated rpms
for software, second choice is where we produce the rpm.

This isn't a problem yet as I have no intention of moving to 2.5 for several
months let alone version 3



-- 
Nick Upson (01799 533252)

Re: [Firebird-test] -923 isc_attach_database: connection rejected by remote interface

[novrain <nov...@gm...>]

We have the same problem.
Here is some information in the attached file.

And environment:
http://firebird.1100200.n4.nabble.com/file/n3754256/CLOSE_WAIT-10.44.120.6.7z
CLOSE_WAIT-10.44.120.6.7z 
> [root@OMM-32Klinux ~]# /opt/firebird/bin/fb_config --version
> 2.1.3.18185-0.i686
>
> [root@OMM-32Klinux ~]# cat /proc/version
> Linux version 2.6.18-164.el5 (root@localhost.localdomain) (gcc version
> 4.1.2 20080704 (Red Hat 4.1.2-46)) #1 SMP Fri Dec 3 09:02:01 CST 2010

--
View this message in context: http://firebird.1100200.n4.nabble.com/923-isc-attach-database-connection-rejected-by-remote-interface-tp2402587p3754256.html
Sent from the firebird-test mailing list archive at Nabble.com.

Re: [Firebird-test] [FB-Tracker] Account signup (verification)

[Jonathan <jo...@sp...>]

Jonathan here,

I'm protecting myself from receiving junk mail.


Please click the link below to complete the verification process.
You have to do this only once.

http://www.spamarrest.com/a2?ZGx0AQxjAmb6qUWuL2gypxOznKWyLzylMUAkoP5ipzpj




Spam Arrest - Take control of your inbox!

------------------------------------------------------------
You are receiving this message in response to your email to
Jonathan, a Spam Arrest customer.

Spam Arrest requests that senders verify themselves before
their email is delivered.

When you click the above link, you will be taken to a page
with a graphic on it. Simply read the word in the graphic,
type it into the form, and you're verified.

You have to do this only once per Spam Arrest customer.
------------------------------------------------------------
Below are the complete headers of the message that this email 
was generated in response to.

Received: (qmail 5844 invoked from network); 16 Aug 2011 15:20:49 +0200
Received: from mail.ibphoenix.com (70.88.243.51)
  by ns.microtec-dns.net with (DHE-RSA-AES256-SHA encrypted) SMTP; 16 Aug 2011 15:20:49 +0200
Received: from localhost (localhost [127.0.0.1])
	by mail.ibphoenix.com (Postfix) with ESMTP id B348E180DB
	for <jn...@mi...>; Tue, 16 Aug 2011 15:20:47 +0200 (CEST)
X-Virus-Scanned: amavisd-new at ibphoenix.com
Received: from mail.ibphoenix.com ([127.0.0.1])
	by localhost (mail.ibphoenix.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id LQtA8VvNY3rA for <jn...@mi...>;
	Tue, 16 Aug 2011 15:20:43 +0200 (CEST)
Received: from tracker.firebirdsql.org (unknown [209.183.20.106])
	by mail.ibphoenix.com (Postfix) with ESMTPA id 4EEB9180D1
	for <jn...@mi...>; Tue, 16 Aug 2011 15:20:43 +0200 (CEST)
Message-ID: <184...@tr...>
Date: Tue, 16 Aug 2011 13:20:42 +0000 (GMT+00:00)
From: tr...@fi...
To: jn...@mi...
Subject: [FB-Tracker] Account signup
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 73c7732cdae1bf4908123ddd91d39bfc
Received-SPF: pass(firebirdsql.org: domain of
	firebirdsql.org designates 70.88.243.51 as permitted sender)



------------------------------------------------------------
Webmasters help stop spam and make 50%.
http://www.spamarrest.com/affl?1944907/affiliates/index.jsp 

------------------------------------------------------------

[Firebird-test] New book on Firebird!

[marynadar <ma...@pa...>]

Hi,

I am an author recruiter at Packt Publishing (www.packtpub.com). We publish
computer-related books on a wide variety of IT topics.

We are planning to publish a new book on */Firebird 2.5 High Performance/*.
I am in search for an author to write this book for us.

To give you an idea about the way things works at Packt:

- The editorial team at Packt works with the author through out the project.
- We pay a royalty of 16% and an advance against it.
- The marketing team at Packt ensures that the book is well promoted.
- In its ongoing commitment to OpenSource, Packt donates a percentage of
revenue generated by the book to the OpenSource project on which it is
based. We have donated more than 150, 000 dollars to various OpenSource
projects since inception in 2004.

Could you please let me know if you find it interesting to write this book?

Thanks,
Mary.
-- 

Mary Nadar
Author Relationship Executive
Packt Publishing
www.packtpub.com
MSN: ma...@pa...
Skype: marynadar
Interested in becoming an author? Visit http://authors.packtpub.com for all
the information you need about writing for Packt.
Join our Packt Authors Group on Linkedin


--
View this message in context: http://firebird.1100200.n4.nabble.com/New-book-on-Firebird-tp3726743p3726743.html
Sent from the firebird-test mailing list archive at Nabble.com.

Re: [Firebird-test] -923 isc_attach_database: connection rejected by remote interface

[novrain <nov...@gm...>]

Have this problem been confirmed and solved?

--
View this message in context: http://firebird.1100200.n4.nabble.com/923-isc-attach-database-connection-rejected-by-remote-interface-tp2402587p3724747.html
Sent from the firebird-test mailing list archive at Nabble.com.

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3565) Uncorrect calculation of Select with case statement

[Pink E. <in...@ba...>]

Good morning,

>You haven't said specifically what the expected results should be for a 
>given condition.

Yes, you right. I am blond, I am sorry. :-)

Further, although the database will be appreciated, should it be needed, you 
need to provide specific details to reproduce, the current details are not 
enough for that purpose.

I`ll prepare today and send you link

It seems that you believe that if a REM.{field} is NULL that the results 
should have a non-NULL value, you are mistaken.  SQL defines very specific 
rules for the handling of NULLs.

No.  Problem in calculation while field has null and non null values. If all 
values are null result will Ok. if all values are not null result will ok.
If values mixed and case is presented and Sum is present result is not ok in 
sum


Dmytro Lendel
Pink Elephant
(+38) 0312 612136
www.bagel.com.ua
www.pidkova.biz 

Re: [Firebird-test] [FB-Tracker] Commented: (DNET-364) Executing Procedure that returns values.

[ISC. V. I. H. C. <vi...@ac...>]

The code has the SUSPEND; part at the end of this procedure, so it supposed that it will returns some row at end of this.

Regards!

Accesscom Comunicaciones S.A. de C.V.
ISC. Victor Israel Herrera Coronado
Departamento de Ingeniería y Desarrollo de Software
Calle 20 # 231 x 13 y 15 Col. Vista Alegre
Telefonos: (999)930 24 90, 930 24 95
Lada sin costo: 01 800 670 62 82
web: www.accesscom.com.mx
blog: www.accesscom.com.mx/blogs
twitter: @accesscom_mx



-----Mensaje original-----
De: Jiri Cincura (JIRA) [mailto:tr...@fi...] 
Enviado el: sábado, 14 de mayo de 2011 10:18 a.m.
Para: vi...@ac...
Asunto: [FB-Tracker] Commented: (DNET-364) Executing Procedure that returns values.


    [ http://tracker.firebirdsql.org/browse/DNET-364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23472#action_23472 ] 

Jiri Cincura commented on DNET-364:
-----------------------------------

How the code of SP looks like?

> Executing Procedure that returns values.
> ----------------------------------------
>
>                 Key: DNET-364
>                 URL: http://tracker.firebirdsql.org/browse/DNET-364
>             Project: .NET Data provider
>          Issue Type: Bug
>          Components: ADO.NET Provider
>    Affects Versions: 2.6
>         Environment: C#,Windows 7, Visual Studio 2010, Net Framework 4
>            Reporter: Victor Israel Herrera Coronado
>            Assignee: Jiri Cincura
>
> The problem or issue that I've with the new version of Firebird.Net 2.6. library it's that I can't execute store procedures as I'd usually do with the previous version (2.5). Not produces any kind of error, only the procedure that would output information returns nothing. 
> For example: With C#, Getting a DataSet
> // Supposed m_fb_cnn as a valid FirebirdConnection
> FbAdapter m_fb_ad = new FbAdapter("GET_INFO", m_fb_cnn);
> m_fb_ad.SelectCommand.CommandType = CommandType.StoreProcedure;
> m_fb_ad.SelectCommand.Params.Add("V_PARAM","VALUE");
> // new dataset
> DataSet m_dst = new DataSet();
> // fill dataset
> m_fb_ad.Fill(m_dst);
> It supposed that the dataset wouldn't be empty. With the library 2.5 that not occurs, this functioned very good but in this one (2.6) doesn't function.
> What I do wrong??
> Best regards

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

        

Re: [Firebird-test] [FB-Tracker] Updated: (CORE-3385) Server is Crashing after cannot start sweep thread (0)

[Mark R. <Ava...@gm...>]

> The most consistent error I get is : INET/inet_error: read errno = 10054,
> this is regardless of when the engine is started.

That is usually an indication that your program is discarding connections without explicitly closing them.

Mark
-- 
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de

Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3441) Problem upgrade to FIREBIRD 2.5 (from 2.1)

[pfg 7. <pf...@7g...>]

it's ok
 thank you for your prompt response
 and have a nice day

Pierre François GAIE
7G SOFT

-----Message d'origine-----
De : Dmitry Yemanov (JIRA) [mailto:tr...@fi...] 
Envoyé : mercredi 13 avril 2011 15:29
À : pf...@7g...
Objet : [FB-Tracker] Commented: (CORE-3441) Problem upgrade to FIREBIRD 2.5 (from 2.1)


    [ http://tracker.firebirdsql.org/browse/CORE-3441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=23241#action_23241 ] 

Dmitry Yemanov commented on CORE-3441:
--------------------------------------

Read firebird.conf regarding the parameter OldSetClauseSemantics.

> Problem upgrade to FIREBIRD 2.5 (from 2.1)
> ------------------------------------------
>
>                 Key: CORE-3441
>                 URL: http://tracker.firebirdsql.org/browse/CORE-3441
>             Project: Firebird Core
>          Issue Type: Bug
>          Components: Engine
>    Affects Versions: 2.5.0
>         Environment: Delphi 5 / windows XP pro SP3 / Interbase objects  (ibquery on standard borland VCL)/ FIREBIRD 1.5/2.1/2.5
>            Reporter: GAIE PF
>            Priority: Critical
>
> hello,
> Firebird 1.5 to 2.1 with this sql query works :
>  sql.add('UPDATE STOCK SET ');
>  sql.add('  QTEDEPART=QTEDEPART+ :QTEDEPART');
>  sql.add(', QTEENTREE=QTEENTREE+ :QTEENTREE');
>  sql.add(', QTESORTIE=QTESORTIE+ :QTESORTIE');
>  sql.add(', QTESTOCK=QTEDEPART+QTEENTREE-QTESORTIE ');
> but she no longer works on the last line with Firebird 2.5 and you must write
> sql.add(', QTESTOCK=QTEDEPART+ :QTEDEPART +QTEENTREE + :QTEENTREE -QTESORTIE -:QTESORTIE');
> but with this line, Firebird 2.1 doubles matches....
> this poses a problem when you have many clients already installed. ( upgrade firebird to 2.5)
> Many thank's
> Pierre François GAIE
> 7G SOFT

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

       

Re: [Firebird-test] [FB-Tracker] Resolved: (DNET-374) An exception was thrown by the type initializer for FirebirdSql.Data.Common.Charset

[Антон <Ton...@ya...>]

thanks for all  =)

Re: [Firebird-test] [FB-Tracker] Updated: (CORE-3385) Server is Crashing after cannot start sweep thread (0)

[Andre v. Z. <an...@sp...>]

Key: CORE-3385

We've been monitoring Firebird's memory use on Windows 7, this would be
version >= 2.5.1.26237 using the windows task manager.  The memory use on
the fbserver.exe process increases at a steady rate (over the course of a
day / 2 days) until it is at a point where the engine does not respond to
any connections.  I am a bit baffled as to what will cause the steady use of
memory?

I will be happy if it is a programming problem on my side, but I have built
similar type systems for Firebird 2.0 (Windows XP) without these effects.
I do not see the same happening on our Linux server on the same 2.5.1 builds
(64 bit version).

The only functionality that I have in this system that I do not have in any
other system is the executing of a statement on an external FB database,
could this be the cause (this is not a problem on Linux) ?

The most consistent error I get is : INET/inet_error: read errno = 10054,
this is regardless of when the engine is started.

-- 
Andre van Zuydam
Spiceware Software (Pty) Ltd
<https://www.ohloh.net/accounts/75973?ref=Tiny>
=============================
Email:  an...@sp...
Tel:    +27 83 646 4535
Fax:   +27 86 682 6944
Web:    www.spiceware.co.za
=============================