[firebird-support] Re: Is Firebird 2.5 support running on multi core processors?
In Firebird 2.5 release note, I read this note : "The default CpuAffinity setting still binds SuperServer to a single processor only. In order to take advantage of this improvement when working with multiple databases, this setting should be changed in firebird.conf" It means, Superserver supported for multicore, right? --- In firebird-support@yahoogroups.com, Alexandre Benson Smith wrote: > > Em 26/8/2011 20:34, trskopo escreveu: > > Hi all, > > > > If it can running on multi core, how to set that? It seems, setting > > CpuAffinityMask in firebird.conf has no effect. > > > > Thanks in advance. > > Best regards, > > Sugiarto. > > > > > > use ClassicServer or SuperClassic server... > > SuperServer continues to be useless for SMP machines... >
Re: [firebird-support] Is Firebird 2.5 support running on multi core processors?
Em 26/8/2011 20:34, trskopo escreveu: > Hi all, > > If it can running on multi core, how to set that? It seems, setting > CpuAffinityMask in firebird.conf has no effect. > > Thanks in advance. > Best regards, > Sugiarto. > > use ClassicServer or SuperClassic server... SuperServer continues to be useless for SMP machines...
[firebird-support] Is Firebird 2.5 support running on multi core processors?
Hi all, If it can running on multi core, how to set that? It seems, setting CpuAffinityMask in firebird.conf has no effect. Thanks in advance. Best regards, Sugiarto.
[firebird-support] Is Firebird support running on multi core processors?
Hi all, If it can running on multi core, how to set that? It seems, setting CpuAffinityMask in firebird.conf has no effect. Thanks in advance. Best regards, Sugiarto.
Re: [firebird-support] How to save a parent-child relation?
Thank you very much Philip, your sugestions are interestings. Greetings. Walter. On Fri, Aug 26, 2011 at 4:50 PM, unordained wrote: > ** > > > -- Original Message --- > From: W O > > Yes, because a parent without a child has not sense in my application. > > So, I want to avoid that possibility. > > Walter. > > > > On Sat, Aug 20, 2011 at 10:29 AM, Ann Harrison >wrote: > > > OK, let me try to restate that. The foeeign key constraint requires > that > > > each child have qa parent. You also want to require that each parent > have at > > > least one child. The obvious question is how do you ever store a new > parent, > > > in the absence of deferred constraints. You could use triggers. > > > Ann > --- End of Original Message --- > > Ann is pointing you down the right track. More precisely, I'd recommend you > > look at on-commit (transaction) triggers, which effectively let you write > most > deferred constraints. (Not appropriate for deferred unique/foreign-key > constraints, but you don't need those today.) > > I'd recommend: > > * create a global temporary table (transaction-scoped) to store a list of > parents you've touched during the current transaction. > * create triggers on the parent and child tables, so that on insert/update/ > delete (especially insert of parent, and delete of child, and update to > parent_id on child, in which case both the old and new parent should be > marked > for re-checking) you update-or-insert the parent_id into the temporary > table. > * create an on-commit trigger, which will look at every parent_id in the > temporary table, for which a parent still exists in the main table (you > don't > care about problems with recently-deleted parent records), and for each > one, > make sure it has at least one child. If you find a parent record that has > been > touched during the transaction that lacks any children, throw an exception > to > refuse to commit a change that results in invalid data (parent with no > children.) > * optionally, move the code for the trigger into a procedure (which you > call > from the trigger), and have the procedure clear the temporary table if it > runs > successfully; this allows you to run the procedure, at random, in the > middle of > a transaction, to verify that everything is "still okay", without actually > committing, and without doing double-work (check now and check again at > commit, > for no reason.) > > -Philip > [Non-text portions of this message have been removed]
Re: [firebird-support] How to save a parent-child relation?
-- Original Message --- From: W O > Yes, because a parent without a child has not sense in my application. > So, I want to avoid that possibility. > Walter. > > On Sat, Aug 20, 2011 at 10:29 AM, Ann Harrison wrote: > > OK, let me try to restate that. The foeeign key constraint requires that > > each child have qa parent. You also want to require that each parent have at > > least one child. The obvious question is how do you ever store a new parent, > > in the absence of deferred constraints. You could use triggers. > > Ann --- End of Original Message --- Ann is pointing you down the right track. More precisely, I'd recommend you look at on-commit (transaction) triggers, which effectively let you write most deferred constraints. (Not appropriate for deferred unique/foreign-key constraints, but you don't need those today.) I'd recommend: * create a global temporary table (transaction-scoped) to store a list of parents you've touched during the current transaction. * create triggers on the parent and child tables, so that on insert/update/ delete (especially insert of parent, and delete of child, and update to parent_id on child, in which case both the old and new parent should be marked for re-checking) you update-or-insert the parent_id into the temporary table. * create an on-commit trigger, which will look at every parent_id in the temporary table, for which a parent still exists in the main table (you don't care about problems with recently-deleted parent records), and for each one, make sure it has at least one child. If you find a parent record that has been touched during the transaction that lacks any children, throw an exception to refuse to commit a change that results in invalid data (parent with no children.) * optionally, move the code for the trigger into a procedure (which you call from the trigger), and have the procedure clear the temporary table if it runs successfully; this allows you to run the procedure, at random, in the middle of a transaction, to verify that everything is "still okay", without actually committing, and without doing double-work (check now and check again at commit, for no reason.) -Philip
Re: [firebird-support] Firebird Server Crashing - Please help
Hello Marius, > Further information on my request below. > > I have uninstalled 64-bit Firebird 2.5 and installed 2.1.4 64-bit > Firebird. > > With this configuration I can restore the backup without the crashes. > > Does this mean that Firebird 2.5 64-bit has a bug present? > It's unclear now - what happened with your database. To clarify it, make metadata only backup and repeat steps. If crash will occur again with metadata only backup, create ticket in tracker.firebirdsql.org - attach there compressed metadata fbk and steps to reproduce the crash. Regards, Alexey Kovyazin www.ibsurgeon.com [Non-text portions of this message have been removed]
RE: [firebird-support] Firebird Server Crashing - Please help
Further information on my request below. I have uninstalled 64-bit Firebird 2.5 and installed 2.1.4 64-bit Firebird. With this configuration I can restore the backup without the crashes. Does this mean that Firebird 2.5 64-bit has a bug present? Regards Marius From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Marius Labuschagne Sent: 25 August 2011 01:59 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird Server Crashing - Please help Hi, We are trying to restore a database of one of my Clients on there new server, but during the restore process it seems that Firebird "breaks". The platform is as follows: Windows 7 Professional 64-bit Firebird 2.50.26074 64-bit, downloaded from www.firebirdsql.org 8GB of RAM Firebird.conf is standard, no changes have been made The firebird log file shows the following: Snip USER-PC (Client) Thu Aug 25 13:27:37 2011 "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295) USER-PC (Client) Thu Aug 25 13:27:38 2011 Guardian starting: "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe" USER-PC (Client) Thu Aug 25 13:34:57 2011 "C:\Program Files\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295) USER-PC (Client) Thu Aug 25 13:34:58 2011 ...snip Could someone please recommend a solution for this problem? Regards Marius J. Labuschagne [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Embedded License
Em 26/8/2011 03:09, peterirbizon escreveu: > Hello, can I include and distribute Microsoft.VC80.CRT.manifest, msvcp80.dll > and msvcr80.dll with my app with embedded firebird? Is it license violation > or not? > Without these files is my app not working properly. thank you > These files are part of Microsoft Runtime Library, and are redistributable, I don't think there is a need to use an offical MS installer, so what prevents you to provide it in your distributable package ? But if you want, you could download the official MS installer and provide it with your package and let your installer run the MS installer. Another point, what would be the bennefit of using an OS RDBMS if you need to "buy" and/or violate a license if you need some files that requires licensing to run such a RDBMS ? see you !
[firebird-support] Re: Embedded License
Hello, can I include and distribute Microsoft.VC80.CRT.manifest, msvcp80.dll and msvcr80.dll with my app with embedded firebird? Is it license violation or not? Without these files is my app not working properly. thank you --- In firebird-support@yahoogroups.com, Helen Borrie wrote: > > At 08:27 AM 24/08/2011, you wrote: > >We are planning to release a commercial product that uses the embedded > >version of Firebird 2.5. We have not modified any of the Firebird source > >code. After reading the Firebird license agreement it seems that this > >distribution is legal if we provide some wording stating that the end users > >can get the Firebird source code for free. Is there any special place this > >statement needs to appear and is there specific wording that I need to > >include? > > If you're talking about the Windows version, you will find the files IPL.txt > and IDPL.txt in the root directory of the binary kit. It is sufficient to > include them, along with a link to the source code kit of the build you are > installing (that's the 5-digit number included in the file name of the binary > kit). > > I have just noticed that these texts appear to be missing from the Linux kits > and maybe also from the MacOS kits (I can't check). They should be there, so > apparently some oversight has occurred at some point. We'll get that fixed > for the 2.5.1 release but if you need them now for a Linux or MacOSX install, > you can pick them up here: > http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/branches/B2_5_Release/builds/install/misc/ > > ./heLen >