[firebird-support] tempdirectories
Hi All, Setting the optional size argument on "TempDirectories" in firebird.conf doesn't seem to work. We've played with setting different locations and can demonstrate it works: TempDirectories = /location1; /location2; /location3 But specifying sizes seems to get the whole line ignored: TempDirectories = /location1 5000 ;/location2 1000 ; /location3 Are we doing something wrong? I've tried voodoo with different spaces and sizes to no affect ISQL Version: LI-V2.5.6.27020 Firebird 2.5 Server version: LI-V2.5.6.27020 Firebird 2.5 Thanks Ian
[firebird-support] Re: tempdirectories
I've just tried TempDirectories = /location1 5000 ;/location2 ; /location3 And location1 is ignored, but 2 and 3 used!
Re: [firebird-support] tempdirectories
27.07.2018 17:20, wobble...@yahoo.co.uk [firebird-support] wrote: > Setting the optional size argument on "TempDirectories" in firebird.conf > doesn't seem to > work. Description of TempDirectories in firebird.conf does not mention any optional size argument. -- WBR, SD. ++ 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] Firebird 3.0 - Won't Start - terminated due to startup error (2)
Problem: Firebird 3.0 will not start. NOTE: the following three (3) errors generated every time firebird tries to start, either from reboot or manual start via /etc/init.d/firebird3.0 start -- From the firebird log (name of testing computer is 'client'): clientFri Jul 27 11:15:30 2018 /usr/sbin/fbguard: guardian starting /usr/sbin/firebird clientFri Jul 27 11:15:31 2018 /usr/sbin/fbguard: /usr/sbin/firebird terminated due to startup error (2) clientFri Jul 27 11:15:31 2018 /usr/sbin/fbguard: /usr/sbin/firebird terminated due to startup error (2) Environment: Devuan Linux version 2.0 - 64-bit --- fresh install (derivative of debian, see devuan.org) Desktop = Mate Firebird 3.0 (installed directly from default repository using synaptic) Please advise. Thank you in advance for any help offered. Dave D. Grand Rapids, MI USA
Re: [firebird-support] Firebird 3.0 - Won't Start - terminated due to startup error (2)
27.07.2018 18:41, mailinglist.int.it.firebird.supp...@principledgroup.com [firebird-support] wrote: > client Fri Jul 27 11:15:30 2018 > /usr/sbin/fbguard: guardian starting /usr/sbin/firebird > > client Fri Jul 27 11:15:31 2018 > /usr/sbin/fbguard: /usr/sbin/firebird terminated due to startup > error (2) > > client Fri Jul 27 11:15:31 2018 > /usr/sbin/fbguard: /usr/sbin/firebird terminated due to startup > error (2) Check that file /usr/sbin/firebird exists. This is an unusual place for firebird executable, so I wonder why devuan packagers broke standard file layout. Check that it has all dependencies resolved. If nothing helps, use strace to check which files are tried to open and why one of them was not found. -- WBR, SD. ++ 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] Re: tempdirectories
wobble...@yahoo.co.uk wrote: > I've just tried > TempDirectories = /location1 5000 ;/location2 ; /location3 > And location1 is ignored, but 2 and 3 used! Which tells you something. ;-) The engine doesn't recognise the format of the first member of the list but it's OK with the second and third because they are legal. I don't know where you got the idea that you could specify the size of a temp directory. It's never been a thing and it wouldn't make sense if it were. The idea of being able to specify multiple locations is that you can avoid an out-of-space crash if the engine has somewehere else to go when it needs to put temp files to disk and the first (or default) temp space is used up. Another point is that, if your user environment has a lot of users doing lots of ordered queries and keeping them alive for long periods, you can consider having a dedicated disk, such as a fast SSD, for TempDirectories. The engine holds the temp file structures in RAM if it can: it only puts them to disk if available RAM is too low. Hence, allocating a RAM disk for TempDirectories doesn't make sense, either. Helen --- This email has been checked for viruses by AVG. https://www.avg.com
Re: [firebird-support] Re: tempdirectories
27.07.2018 21:41, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > I don't know where you got the idea that you could specify the size of > a temp directory. It is an Interbase feature. -- WBR, SD. ++ 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/