[firebird-support] Re: Cannot connect to server under heavy load
--- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > > Cannot connect to server under heavy load. > > I get "connection rejected by remote interface" (335544421). > > > > Is this a bug, ot there is an option in firebird.conft to avoid this? > > > > > > Firebird.log (FB20 Classic Server) > > L3S-4 Wed Oct 24 14:04:28 2012 > > I/O error for file "C:\PROGRAM > > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB" > > > > > > L3S-4 Wed Oct 24 14:04:28 2012 > > lock conflict on no wait transaction > > > > > > L3S-4 Wed Oct 24 14:04:32 2012 > > Error while trying to access file > > > > > > L3S-4 Wed Oct 24 14:04:32 2012 > > no permission for read-write access to database C:\PROGRAM > > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB > > > > > > L3S-4 Wed Oct 24 14:04:36 2012 > > The process cannot access the file because it is being used by > > another process > > These errors suggest that there is some other process which is accessing the > files... > > You need to find that other process, the problem may not exist in Firebird at > all. > > > Sean > ProcessMonitor log contaions only fb_inet_server.exe accessing to security2.fdb. BTW : QueryAllInformationFile (IRP_MJ_QUERY_INFORMATION) always results in BUFFER OVERFLOW. Is that normal?
[firebird-support] Restoring database with Delphi components
Hi all! I use a program write with Delphi XE2 to backup/restore my database. Currently I use the component: TIBRestoreService Sometimes I get an Access Violation in the restore process. I guess that this component is used for Interbase database, not Firebird! I looked out at dbExpress components TSQLConnection, etc and I can´t figure out any component/way to backup and restore a Firebird database. Someone can tell me how to backup/restore a database, the right way. Thanks, Fabiano. [Non-text portions of this message have been removed]
[firebird-support] Re: Cannot connect to server under heavy load
Increasing the thread numbers the same error appears when only 1 application runs with many threads... --- In firebird-support@yahoogroups.com, "ma_golyo" wrote: > > Another strange fact : > > Running 1 application with 250 thread where each thread connects to 2 > database and runs 2 select works perfectly, BUT > > Running 50 application with 5 thread where each thread connects to 2 database > and runs 2 select throw errors mentioned eralier. > > --- In firebird-support@yahoogroups.com, "ma_golyo" wrote: > > > > Hi! > > > > Cannot connect to server under heavy load. > > I get "connection rejected by remote interface" (335544421). > > > > Is this a bug, ot there is an option in firebird.conft to avoid this? > > > > > > Firebird.log (FB20 Classic Server) > > L3S-4 Wed Oct 24 14:04:28 2012 > > I/O error for file "C:\PROGRAM > > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB" > > > > > > L3S-4 Wed Oct 24 14:04:28 2012 > > lock conflict on no wait transaction > > > > > > L3S-4 Wed Oct 24 14:04:32 2012 > > Error while trying to access file > > > > > > L3S-4 Wed Oct 24 14:04:32 2012 > > no permission for read-write access to database C:\PROGRAM > > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB > > > > > > L3S-4 Wed Oct 24 14:04:36 2012 > > The process cannot access the file because it is being used by another > > process > > >
Re: [firebird-support] Compound foreign key & null value bug?
Rick, > I forgot to populate the new column in the child table, so all the > relationships looked like this: > > ChildParent > --- > Col1:null -> Col1:A > Col2:B-> Col2:B > > The new foreign keys were created without any errors. Since (null,B) > doesn't match anything, shouldn't the creation have failed? > Since you want a quick answer, I believe that behavior follows the standard. I have it in front of me, but digging out the expected null behavior is a pain, but from the fact that one of the acceptable behaviors of a cascading update or delete is to set the matching field(s) in the child table to null, I'd have to say that for foreign key relationships a null in the referencing field is considered to match. Good luck, Ann [Non-text portions of this message have been removed]
[firebird-support] Re: Cannot connect to server under heavy load
Heavy load does not required. Just connecting to a database with many connection in short period of time throws errors. --- In firebird-support@yahoogroups.com, "ma_golyo" wrote: > > Hi! > > Cannot connect to server under heavy load. > I get "connection rejected by remote interface" (335544421). > > Is this a bug, ot there is an option in firebird.conft to avoid this? > > > Firebird.log (FB20 Classic Server) > L3S-4 Wed Oct 24 14:04:28 2012 > I/O error for file "C:\PROGRAM > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB" > > > L3S-4 Wed Oct 24 14:04:28 2012 > lock conflict on no wait transaction > > > L3S-4 Wed Oct 24 14:04:32 2012 > Error while trying to access file > > > L3S-4 Wed Oct 24 14:04:32 2012 > no permission for read-write access to database C:\PROGRAM > FILES\FIREBIRD\FIREBIRD_2_0\SECURITY2.FDB > > > L3S-4 Wed Oct 24 14:04:36 2012 > The process cannot access the file because it is being used by another > process >
RE: [firebird-support] Compound foreign key & null value bug?
> I'd have to say that for foreign key relationships a null in the referencing > field is considered to match How about in the referenced field? BTW, thanks for the quick reply. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison Sent: Thursday, October 25, 2012 10:33 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Compound foreign key & null value bug? Rick, > I forgot to populate the new column in the child table, so all the > relationships looked like this: > > Child Parent > - -- > Col1:null -> Col1:A > Col2:B -> Col2:B > > The new foreign keys were created without any errors. Since (null,B) > doesn't match anything, shouldn't the creation have failed? > Since you want a quick answer, I believe that behavior follows the standard. I have it in front of me, but digging out the expected null behavior is a pain, but from the fact that one of the acceptable behaviors of a cascading update or delete is to set the matching field(s) in the child table to null, I'd have to say that for foreign key relationships a null in the referencing field is considered to match. Good luck, Ann [Non-text portions of this message have been removed]
[firebird-support] Re: Cannot connect to server under heavy load
Same issue on 2.5.1.26351 Classic Server. A slight difference is that it waits a long time before the connection reject error message. --- In firebird-support@yahoogroups.com, Mark Rotteveel wrote: > > On Wed, 24 Oct 2012 12:18:01 -, "ma_golyo" wrote: > > Hi! > > > > Cannot connect to server under heavy load. > > I get "connection rejected by remote interface" (335544421). > > > > Is this a bug, ot there is an option in firebird.conft to avoid this? > > > > > > Firebird.log (FB20 Classic Server) > > What is the exact version of your Firebird? > > Mark >
Re: [firebird-support] Compound foreign key & null value bug?
On Thu, Oct 25, 2012 at 12:49 PM, Rick Debay wrote: > > I'd have to say that for foreign key relationships a null in the > referencing field is considered to match > > How about in the referenced field? BTW, thanks for the quick reply. > The referenced fields have to be subject to a primary or unique key constraint. Primary is easy. No nulls. Unique constraints are not so very clear and various databases handle them differently. My understanding of the standard is that if you have a Unique constraint the following pairs of values are OK: (A, B), (A, null), (null, B) but that you could not have two pairs (A, null) and (A, null). Cheers, Ann [Non-text portions of this message have been removed]
RE: [firebird-support] Compound foreign key & null value bug?
Anyone available for a quick reply? Schools are closing early for hurricane Sandy and I'd like to resolve this before an involuntary long weekend babysitting :-( -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Rick Debay Sent: Wednesday, October 24, 2012 10:50 AM To: firebird-support@yahoogroups.com Subject: [firebird-support] Compound foreign key & null value bug? I'm modifying a foreign key from one column to two. I dropped the original foreign key from the child table, populated the new columns, and then created the new key. I forgot to populate the new column in the child table, so all the relationships looked like this: ChildParent --- Col1:null -> Col1:A Col2:B-> Col2:B The new foreign keys were created without any errors. Since (null,B) doesn't match anything, shouldn't the creation have failed? ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
