Re: [firebird-support] Isql exclusive mode?
Den 2020-01-23 kl. 08:32, skrev Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]: > I have a vague recollection that Firebird's isql utility will in some > situations make an exclusive connection to the database, meaning that > any other connection attempts will be refused. > > I fail to find information about this. > > Can anyone explain in which situations this happens, and in particular > how I can make sure it does NOT happen? > > My intended usage is to execute some commands/queries in a scheduled > task, and I don't want to run the risk of blocking other database work > while this task is executing. > > Also asked at DBA@StackExchange, feel free to reply there or here or > both: > https://dba.stackexchange.com/questions/258038/firebird-isql-exclusive-mode > > From a few simple tests it seems like I get an exclusive connection, i.e. no other connections are allowed, when there are no other connections present. Conversely, if there are other connections when isql connects, isql's connection doesn't block other connections. I tested this with Firebird 3.0.4 in superserver mode and FlameRobin, using the same database alias for both isql and FlameRobin connections. The alias is defined with an absolute local file path. Should I include host and port to ensure that isql always connects through the superserver (allowing other connections) rather than opening the file directly (blocking other connections)? Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] Isql exclusive mode?
23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > Can anyone explain in which situations this happens, and in particular > how I can make sure it does NOT happen? If it is version 3 - do not use embedded mode. -- 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] Isql exclusive mode?
Den 2020-01-23 kl. 11:32, skrev Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]: > 23.01.2020 08:32, Kjell Rilbe kjell.ri...@marknadsinformation.se > [firebird-support] wrote: >> Can anyone explain in which situations this happens, and in particular >> how I can make sure it does NOT happen? > If it is version 3 - do not use embedded mode. I guess that's what I found and noted in the StackExchange question. So is it correct that I avoid embedded mode by specifying "localhost/3050:AliasName" instead of just "AliasName"? Kjell [Non-text portions of this message have been removed]
Re: [firebird-support] Isql exclusive mode?
23.01.2020 11:59, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > So is it correct that I avoid embedded mode by specifying > "localhost/3050:AliasName" instead of just "AliasName"? Yes. -- 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/
