Hello, i'm using Firebird 2.5.2 Superclassic in windows 2008 R2 64 bits.
The system runs for two days, and i have seen in firebird log this entries
in the first work day:
Thu Jul 05 11:52:59 2012
Database: Gestlab
page 1296554, page type 4 lock denied (216)
Thu Jul 05 13:36:41 2012
Database:
--- In firebird-support@yahoogroups.com, "unordained" wrote:
> I suppose there's the possibility of index corruption. You could test that by
> making sure the optimizer can't use the index:
>
> and (ARTICLE.ISACTIVE || '' = 'F')
>
> or something similar. The only time I've seen an index retur
--- In firebird-support@yahoogroups.com, Helen Borrie wrote:
>
> If you have a row in a table that depends on values in other rows in the same
> table then you have a serious flaw in your relational design. Move that
> column or set into another table.
That's an interesting point you are maki
Aldo Caruso wrote:
>When I try to restore a backup done in a 2.5 firebird server to a 2.1
> firebird server, I get the following error message:
>
> gbak:transportable backup -- data in XDR format
> gbak: ERROR:Expected backup version 1..8. Found 9
> gbak:Exiting before completion due to erro
hanszorn2000 wrote:
> declare LOCATION integer;
> declare ARTICLEID varchar(20);
> BEGIN
> select first 1 NEWLOCATION, ARTICLEID from ARTICLE
> where ARTICLE.CUSTID = NEW.CUSTID
> and ARTICLE.ISACTIVE = 'F'
> and ARTICLE.NEWLOCATION is not null
> order by NEWLOCA
Two days ago, we moved from one server with interbase 2009 windows 2003 and
4 Gb RAM to Firebird 2.5.2 Superclassic, 16 Gb RAM
The database is around 21 Gb, and yesterday seems all was running fine.
Today, i have checked Firebird.log and i have seen that there is an error
of type
1296554 page type
Hello,
Is there any reason to delete connection which lasts 4 hours?
How did you plan migration? Did you perform compatibility and load tests?
Why you are using SuperClassic, not Classic?
Look here how migration should be done (regardless of start and end
database versions, steps are almost the
Hi,
I have a problem where a select query works on one user's data but not
another's. (Firebird server 2.5.1.26351)
Strangely, if I reverse the join and from statements, the query works for both
why?
This query fails for one user: (by fail, I mean it never returns)
Select
TRANSACTIONS.INVOIC
At 10:18 PM 6/07/2012, hanszorn2000 wrote:
>--- In firebird-support@yahoogroups.com, Helen Borrie wrote:
>>
>> If you have a row in a table that depends on values in other rows in the
>> same table then you have a serious flaw in your relational design. Move
>> that column or set into another
-- Original Message ---
From: "brian.matchey"
> I have a problem where a select query works on one user's data but not
> another's. (Firebird server 2.5.1.26351) Strangely, if I reverse the
> join and from statements, the query works for both why?
>
> This query fails for one
The plan is similar, only reversed.
Performant query:
PLAN JOIN (COMMISSIONS NATURAL, TRANSACTIONS NATURAL)
Non-performant query:
PLAN JOIN (TRANSACTIONS NATURAL, COMMISSIONS NATURAL)
There is no physical relationship between these tables as they were migrated
from Paradox.
There is, however,
On Fri, Jul 6, 2012 at 10:44 AM, brian.matchey wrote:
>
> This query fails for one user: (by fail, I mean it never returns)
> Select
> TRANSACTIONS.INVOICENUMBER,
> TRANSACTIONS.ITEMNUMBER
> From TRANSACTIONS
> LEFT JOIN COMMISSIONS ON
> (COMMISSIONS.INVOICENUMBER=TRANSACTIONS.INVOICENUMBER) AND
>
At 08:22 AM 7/07/2012, you wrote:
>The plan is similar, only reversed.
>
>Performant query:
>PLAN JOIN (COMMISSIONS NATURAL, TRANSACTIONS NATURAL)
>
>Non-performant query:
>PLAN JOIN (TRANSACTIONS NATURAL, COMMISSIONS NATURAL)
>
>
>There is no physical relationship between these tables as they were
I have client who has been using old FB on server with no problems.
My application in this email is called 'ASE'
Are there any known issues on Win 7 server?
I got this email from him:
Had to reinstall windows on our main scoring computer.
Previously it was running XP SP2, now Windows 7 Pro.
Not
On 7-7-2012 1:01, ianmck61 wrote:
> I have client who has been using old FB on server with no problems.
> My application in this email is called 'ASE'
> Are there any known issues on Win 7 server?
Windows 7 isn't a server OS, it is a desktop OS (Windows Server 2008 is
the equivalent server OS).
In your working query you are asking firebird to take the rows from comm that
match the where clause and join that small subset of data with the matching
rows in tran. In the one that never returns you are asking firebird to join
every table in tran with every row in comm and then apply the filt
16 matches
Mail list logo
