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 unordained_00@... 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
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... 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
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 errors
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 NEWLOCATION
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
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
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
At 10:18 PM 6/07/2012, hanszorn2000 wrote:
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... 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
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 migrated
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.
11 matches
Mail list logo
