[firebird-support] Re: gbak to a non existing directory - Email found in subject
Why do you not want something like that? What is te purpose of this restriction? Or it's not a restriction, just not implemeted? --- In firebird-support@yahoogroups.com, "Leyne, Sean" wrote: > > > > > Running "gbak -c" does not create directories when not exists. > > How can I force to create directories? I cannot find any gbak swith which > > can > > help. > > There is no switch to do that. Nor would I want one. > > Performing file system folder operations is not something that gbak should be > doing. > > > Sean >
Re: [firebird-support] Re: Embedded Firebird leaves a lot of temp files behind
2012.06.06. 20:41 keltezéssel, Alec Swan írta: > > I also confirmed that Flamerobin still works even if I delete firebird.conf > from directory where flamerobin_unicode.exe resides. So, Flamerobin must > have firebird.conf packaged internally, which sounds kind of weird. > > > Alec Hi, In the default firebird.conf file every line is commented out. If you use an empty firebird.conf or remove the conf file the engine use the default values same as with the default conf file. Gabor ++ 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 <*> 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Re: Embedded Firebird leaves a lot of temp files behind
I confirmed that TempDirectories works with our embedded Firebird database. "Success!" I thought yet to find out that TempDirectories doesn't work completely with ALTER INDEX ACTIVE (see my latest thread). I also confirmed that Flamerobin still works even if I delete firebird.conf from directory where flamerobin_unicode.exe resides. So, Flamerobin must have firebird.conf packaged internally, which sounds kind of weird. Thank you to all who contributed to this discussion. It was fun ;-) Alec On Sun, Jun 3, 2012 at 12:17 PM, Alec Swan wrote: > Vlad, > > Actually, FB correctly deletes fb_sort file used by a transaction after > the transaction completes. However, we have a lot of long-running > concurrent transactions which generate a lot of large fb_sort files. > Moreover, when our customer rebuilt indexes they ran out of system disk > space (since this is where %TEMP% points to) and left FB in corrupt state. > > I am using Flamrobin and set TempDirectories in firebird.conf in the same > directory as flamerobin_unicode.exe. Let me test it in other environments. > > Thanks! > > Alec > > > On Sun, Jun 3, 2012 at 11:16 AM, hvlad wrote: > >> ** >> >> >> >> >> --- In firebird-support@yahoogroups.com, Alec Swan wrote: >> > >> > Vlad, the large files have fb_sort prefix. But we also see a lot of >> small >> > fb_lock files. >> >> They could be left only if engine was not shutted down correctly. >> >> fb_sort_XXX files left means application was crushed. >> >> fb_lock_XXX files are per database and will be reused at next connect. >> I don't think it is an issue unless you works with different databases >> every time. Note, since v2.5 Firebird embedded doesn't put lock files >> into temp folder, so this files was left by another embedded Firebrid >> version. >> >> Make sure you close all attachments before program exits. It would be >> the best if you call fb_shutdown() before exit. Also, you can cleanup >> that files at your program startup before first call of ISC API. >> >> >> > Lester, we are a Windows-based shop and most of our customers have FB >> > databases are under 200MB. There are just a few that have 10-20GB >> databases. >> > >> > Our customers need the ability to put those files on a separate disk and >> > restrict their cumulative size. TempDirectories setting would have been >> > perfect for it, but I can't get it to work with embedded Firebird. >> > >> > If its is supposed to work in embedded mode then I will spend more time >> > making sure that I am not doing something wrong before taking any more >> of >> > your time. >> >> It must work. Sooner of all engine can't find firebird.conf. For v2.5 it >> should be placed at the same folder as fbembed.dll. >> >> Regards, >> Vlad >> >> >> > > [Non-text portions of this message have been removed] ++ 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 <*> 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: http://docs.yahoo.com/info/terms/
[firebird-support] TempDirectories and ALTER INDEX ACTIVE
Hello, Our app rebuilds indexes periodically (about once a month) by calling "ALTER INDEX index_name ACTIVE" on a bunch of indexes in the database. I need to estimate how much free disk space the customer should have in order to complete this process. I decided to restrict TempDirectories size, run the command and see when it starts failing. Here are my findings: 1. TempDirectories = C:\Temp\Firebird Running "ALTER INDEX idx_physical_copy_commit_number ACTIVE" succeeds 2. TempDirectories = C:\Temp\Firebird 1000 Running "ALTER INDEX idx_physical_copy_commit_number ACTIVE" causes "GDS Exception. 335544675. sort error" The database size is 1.5GB so 100 GB should be more than enough to activate any index, right? My main question is how can we calculate the temp sort space required to ALTER INDEX ACTIVE (on all indexes serially) given the size of the database? Is twice the size of the database a good upper bound? We will provide this as a recommendation to our customers, so it has to be simple :) Thanks, Alec
Re: [firebird-support] Slow query because an index is not picked up during sort
SET thanks, it makes sense. So, Firebird is unable to pick the right plan for >= because it doesn't have histograms, right? On Tue, Jun 5, 2012 at 9:55 AM, Ann Harrison wrote: > ** > > > > > > > > > > > I am assuming you meant to use LEFT not INNER JOIN, right? > > > > Right - and right that I got SAP and SAS confused (again). Typing, > talking, and trying to get the dog to stop emptying the trash should not be > done simultaneously. > > > Ann > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] ++ 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 <*> 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Simple query interface for the Mac
On 2012-06-06, at 11:22 AM, mariuz wrote: > you can use isql from unixodbc > I have installed it on ubuntu linux so it should be possible to work on > macosx too > http://www.firebirdnews.org/?p=1324 I found an installer-based version of this, which appears to have installed a DSN editor and iQSL-Viewer in my Utilities folder. These appear to be generic versions of the OpenLink iODBC versions? It appears iSQL is a version of iODBC from the OpenLink package? It does not appear to see my DNSs, so I suppose I have to set up the JDBC side of things. Can anyone point me to a classpath that it might accept? I don't seem to have anything on my drive that's suitable.
[firebird-support] Re: Simple query interface for the Mac
--- In firebird-support@yahoogroups.com, Maury Markowitz wrote: > > Can someone suggest a simple ODBC-based text-based query interface for the > Mac? > > I'm using RazorSQL, but it's based on JDBC and its more than it should be. > you can use isql from unixodbc I have installed it on ubuntu linux so it should be possible to work on macosx too http://www.firebirdnews.org/?p=1324 also you can use the command line utility from firebird and that is called the same isql but is more powerful , it doesn't need odbc http://www.firebirdsql.org/manual/isql.html
RE: [firebird-support] gbak to a non existing directory - Email found in subject
> Running "gbak -c" does not create directories when not exists. > How can I force to create directories? I cannot find any gbak swith which can > help. There is no switch to do that. Nor would I want one. Performing file system folder operations is not something that gbak should be doing. Sean
[firebird-support] Re: Execute Block SQL error 901 ISC error 335544569
If you use IBX to connect then ParamCheck of TIBQuery should be FALSE. --- In firebird-support@yahoogroups.com, "Jack Mills" wrote: > > I have a query that show the above error, yet runs OK when run from IBExpert. > > EXECUTE BLOCK AS > declare variable D bigint; declare variable A bigint; > declare variable V integer; declare variable I bigint; > declare variable J bigint; declare variable X integer; > declare variable W integer; declare variable U integer; > begin > select first 1 (cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' > into i; > select max(cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' into j; > while (i <= j) > do > begin > select cast(dxs_no as integer), cast(abs_no as integer), cast(Value1 as > integer), > cast(uop as integer), cast(DB as integer), cast(DW as integer) from > IMPORT_DXS > where :i = cast(dxs_no as integer) into d, a, v, u, x, w; > update DXS set ABS_NO = :a, Value1 = :v, USED = 'T', UOP = :u > where DX = :x and DW = :w; > i= i+1; > end > end > > Prior to this query are 2 others. the 1st uses an execute block statement to > delete IMPORT_DXS if it exists & the 2nd creates the IMPORT_DXS table from an > external file, both of these run without errors. > > Can anyone see where I'm going wrong? > > Jack >
[firebird-support] Execute Block SQL error 901 ISC error 335544569
I have a query that show the above error, yet runs OK when run from IBExpert. EXECUTE BLOCK AS declare variable D bigint; declare variable A bigint; declare variable V integer; declare variable I bigint; declare variable J bigint; declare variable X integer; declare variable W integer; declare variable U integer; begin select first 1 (cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' into i; select max(cast(DXS_NO as integer)) from IMPORT_DXS where Used = 'T' into j; while (i <= j) do begin select cast(dxs_no as integer), cast(abs_no as integer), cast(Value1 as integer), cast(uop as integer), cast(DB as integer), cast(DW as integer) from IMPORT_DXS where :i = cast(dxs_no as integer) into d, a, v, u, x, w; update DXS set ABS_NO = :a, Value1 = :v, USED = 'T', UOP = :u where DX = :x and DW = :w; i= i+1; end end Prior to this query are 2 others. the 1st uses an execute block statement to delete IMPORT_DXS if it exists & the 2nd creates the IMPORT_DXS table from an external file, both of these run without errors. Can anyone see where I'm going wrong? Jack
[firebird-support] Simple query interface for the Mac
Can someone suggest a simple ODBC-based text-based query interface for the Mac? I'm using RazorSQL, but it's based on JDBC and its more than it should be.
[firebird-support] Re: gbak to a non existing directory
I want to restor to a remote server so batch is not good for me :( --- In firebird-support@yahoogroups.com, Michael Ludwig wrote: > > ma_golyo schrieb am 06.06.2012 um 11:45 (-): > > Running "gbak -c" does not create directories when not exists. > > How can I force to create directories? I cannot find any gbak swith > > which can help. > > Forcing won't help - GBAK is not an eierlegende Wollmilchsau. > > https://www.google.com/search?q=eierlegende+Wollmilchsau&tbm=isch > > Use the command-line processor: > > D:\MiLu\RepoHgSvn\comp\win\http :: more restore.bat > @ECHO OFF > IF /I "%~x1" NEQ ".bak" GOTO:USAGE > IF /I "%~x2" NEQ ".gdb" GOTO:USAGE > IF"%3" NEQ "" GOTO:USAGE > > IF NOT EXIST "%~dp2" md "%~dp2" > gbak -c "%1" "%~f2" > echo "%~f2" > dir "%~f2" > GOTO:EOF > > :USAGE > ECHO Usage: %0 path\to\my.bak path\to\my\restored.gdb >&2 > > REM -- Michael >
Re: [firebird-support] gbak to a non existing directory
ma_golyo schrieb am 06.06.2012 um 11:45 (-): > Running "gbak -c" does not create directories when not exists. > How can I force to create directories? I cannot find any gbak swith > which can help. Forcing won't help - GBAK is not an eierlegende Wollmilchsau. https://www.google.com/search?q=eierlegende+Wollmilchsau&tbm=isch Use the command-line processor: D:\MiLu\RepoHgSvn\comp\win\http :: more restore.bat @ECHO OFF IF /I "%~x1" NEQ ".bak" GOTO:USAGE IF /I "%~x2" NEQ ".gdb" GOTO:USAGE IF"%3" NEQ "" GOTO:USAGE IF NOT EXIST "%~dp2" md "%~dp2" gbak -c "%1" "%~f2" echo "%~f2" dir "%~f2" GOTO:EOF :USAGE ECHO Usage: %0 path\to\my.bak path\to\my\restored.gdb >&2 REM -- Michael
[firebird-support] gbak to a non existing directory
Hi! Running "gbak -c" does not create directories when not exists. How can I force to create directories? I cannot find any gbak swith which can help.
