Re: {Disarmed} Re: [firebird-support] Forced write, page size and buffer size
Am 19.08.2014 um 18:30 schrieb 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]: > Re: [firebird-support] Forced write, page size and buffer size The > best thing would be if someone could simulate some crashes (like power > failure) in both configurations and report back about existence of > corruption. Such an simulation does hardly cover all possible problems. In general there was an statement about old interbase database which should be "up again" shortly after an power fail in an tank-environment caused by firing the gun. There is some chance that firebird can recover after crash. The Problem itself does arise from the order the physical writes are done. If the OS (or even the disk) does reorder writes I would suspect to generate problems. You can simulate power-fail by using QEMU emulation and killing the emulator. Elmar ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: {Disarmed} Re: [firebird-support] Forced write, page size and buffer size
I never said it would cover all possibilities. I just said that instead of "guessing" or stay only with the "theory", a real test could give more trustful results ;) Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br EHehdfs> Am 19.08.2014 um 18:30 schrieb 'Carlos H. Cantu' lis...@warmboot.com.br EHehdfs> [firebird-support]: >> Re: [firebird-support] Forced write, page size and buffer size The >> best thing would be if someone could simulate some crashes (like power >> failure) in both configurations and report back about existence of >> corruption. EHehdfs> Such an simulation does hardly cover all possible problems. EHehdfs> In general there was an statement about old interbase database which EHehdfs> should be "up again" shortly after an power fail in an tank-environment EHehdfs> caused by firing the gun. There is some chance that firebird can recover EHehdfs> after crash. EHehdfs> The Problem itself does arise from the order the physical writes are EHehdfs> done. If the OS (or even the disk) does reorder writes I would suspect EHehdfs> to generate problems. EHehdfs> You can simulate power-fail by using QEMU emulation and killing the EHehdfs> emulator. EHehdfs> Elmar EHehdfs> EHehdfs> EHehdfs> ++ EHehdfs> Visit http://www.firebirdsql.org and click the Documentation item EHehdfs> on the main (top) menu. Try FAQ and other links from the left-side menu there. EHehdfs> Also search the knowledgebases at EHehdfs> http://www.ibphoenix.com/resources/documents/ EHehdfs> ++ EHehdfs> EHehdfs> Yahoo Groups Links
Re: [firebird-support] Forced write, page size and buffer size
> The hard truth is that the only _absolute guarantee_ to prevent database corruption is FW = ON. Provided that the file system also has barrier enabled ... Regards, Aldo ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Forced write, page size and buffer size
I've a question regarding this, since the context has been in Linux. I run 2.5.2 on a virtual Server 2008R2 machine. Is FW on by default on this install? If not, is that a setting in the conf file or do I need to use GFix On Wed, Aug 20, 2014 at 9:05 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > > The hard truth is that the only _absolute guarantee_ to prevent > database corruption is FW = ON. > > Provided that the file system also has barrier enabled ... > > Regards, > Aldo > > > > > > > ++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++ > > > Yahoo Groups Links > > > > -- Dixon Epperson
Re: [firebird-support] Forced write, page size and buffer size
You can check whether forced writes status is on or off submitting on a FB console the following command SHOW DATABASE In order to set it on / off, you shoud run gfix -user [user_name] -password [psw] -w [sync | async] [database_name] Regards, Aldo
Re: [firebird-support] Forced write, page size and buffer size
Thanks for the tip. I did take the default install and yes, FW is on. On Wed, Aug 20, 2014 at 10:08 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > > > You can check whether forced writes status is on or off submitting on a > FB console the following command > > SHOW DATABASE > > In order to set it on / off, you shoud run > > gfix -user [user_name] -password [psw] -w [sync | async] [database_name] > > Regards, > Aldo > > -- Dixon Epperson
[firebird-support] Export data to CSV file from stored procedure?
Hi there, As subject, is it possible to export a query result set to an external csv file from a Firebird stored procedure? I know this can be done with IBExpert but we are looking for a pure firebird sql solution. We are using Firebrd 2.5. Any pointers on how to do this will be much appreciated. Regards, -Ed
Re: [firebird-support] Export data to CSV file from stored procedure?
you could define an external table with 1 field, construct a csv within the SP and write to the table Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 20 August 2014 17:19, conver...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Hi there, > > As subject, is it possible to export a query result set to an external csv > file from a Firebird stored procedure? I know this can be done with > IBExpert but we are looking for a pure firebird sql solution. We are using > Firebrd 2.5. > > > Any pointers on how to do this will be much appreciated. > > > Regards, > > > -Ed > > > >
Re: [firebird-support] Export data to CSV file from stored procedure?
You want to be looking around your external CSV file being an "external table" - that's the only way to write to files from stored procedures AFAIK, so, no matter how convoluted the code ends up, that's probably the approach you'll have to take. (Unless there's new stuff in 2.5 I don't know about, I've only done this with 2.1.) On 20/08/2014 17:19, conver...@gmail.com [firebird-support] wrote: Hi there, As subject, is it possible to export a query result set to an external csv file from a Firebird stored procedure? I know this can be done with IBExpert but we are looking for a pure firebird sql solution. We are using Firebrd 2.5. Any pointers on how to do this will be much appreciated. Regards, -Ed -- Tim Ward
Re: [firebird-support] Forced write, page size and buffer size
On Aug 20, 2014, at 9:05 AM, "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" wrote: >> The hard truth is that the only _absolute guarantee_ to prevent > database corruption is FW = ON. > > Provided that the file system also has barrier enabled ... Firebird's forced write should be sufficient if the file system and disk honor forced write (fsync) - and if Firebird implements forced write correctly. If those criteria are met, barriers serve only to protect the disk journal. Firebird long predates file system journalling and operates correctly without journals. Best regards, Ann
RE: [firebird-support] Forced write, page size and buffer size
> I run 2.5.2 on a virtual Server 2008R2 machine. > Is FW on by default on this install? FW is not a function of the install or server config, it is a database property that is determined by the OS which was used to create the database*. For all version of Windows the default = ON I am not sure about *nux platforms, other will need to confirm. Sean * 1 - It is possible to copy a database between Windows and Linux (with the same CPU architecture). So, a database created on Windows would have FW = ON on Linux, even if the default for that platform is FW=OFF. 2- The property survives backup/restore and can only be changed using gfix. So, create and backup from Windows and restore to Linux would have FW=ON.
Re: [firebird-support] Forced write, page size and buffer size
Ann, thanks for the correction. I erroneously missinterpreted that file system barriers were also necessary. Aldo ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Strange date values
I thought I'd save some time by spending some money on XMLWizard to do some CSV imports of data sets ... rather than pulling together my own PHP scripts. It seems to work well enough on Windows, but I could not get the Linux version working. But the problem I've found is that while the date import is set to Y-m-d and the raw data is in exactly the same format, evey date value is displaying with the month replaced by a capital N - I did not even think that Firebird could do that? Running into 2.5.2 on one of the Linux boxes. Have reported it to GuacoSoft but I wonder if the problem is with Flamerobin displaying it? OK - thinking out loud works ... the date format on this machine was set to Y-N-D rather than Y-M-D ... fixed that now :) -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk