AW: [firebird-support] Firebird 2.5 under Windows 8 64bit
Hello, I will check what Dmitry has suggested. Btw, the fb server is installed in the \program files (x86) folder and run as a service and it's a local machine, not a server, so the application is also run on this machine. Greetings -Ursprüngliche Nachricht- Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Im Auftrag von Thomas Steinmaurer Gesendet: Donnerstag, 20. Februar 2014 20:40 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Firebird 2.5 under Windows 8 64bit Hello Dirk, I have a customer where Firebird 2.5.2 (32bit) is running under Windows 8 64bit. The following errors are repeatedly found in the firebird.log BARBAR (Server) Wed Feb 19 14:22:54 2014 Error in isc_attach_database() API call when working with security database operating system directive CreateFile failed Access denied BARBAR (Server) Wed Feb 19 14:37:42 2014 INET/inet_error: read errno = 10054 What causes these errors, especially the first? Well, I don't have Windows 8 running, but it sounds a bit like a permission issue, e.g. having Firebird installed in the program files folder and running Firebird under a user with restricted privileges ... Is Firebird running as a Windows service or as an application? Other than that, what Dmitry has suggested. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. ++ 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 Virus checked by G Data AntiVirus Version: AVA 24.670 dated 21.02.2014 Virus news: www.antiviruslab.com
[firebird-support] Where I put firebird.msg on PC with two client?
Hallo, I have a PC with two clients: - fbclient21.dll (I use ZeosLib + Delphi) for version 2.1 in windows\system - fbclient.dll for version 2.5 in windows\system Both clients connect to the server version 2.5 and I cannot change this unless I update the application that uses fbclient21.dll. If I put firebird.msg in Windows\system I create a conflict by different versions of clients (2.1 + 2.5). There is a way to put firebird.msg for 2.1 version in a directory that not conflict with the one for version 2.5? Thanks. -- Luigi Siciliano -- ++ 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://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] For those who think they have performance problems
LockHashSlots to 8191. ;-) We have set 31013. Today situation is much better, users are surprised with +30% speed increase, with 700 active connections: LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 75440168, Used: 28721584 Flags: 0x0001 Enqs: 3143976306, Converts: 1574782, Rejects: 253168, Blocks: 6607562 Deadlock scans: 0, Deadlocks: 0, Scan interval: 10 Acquires: 3197419523, Acquire blocks:673, Spin count: 0 Mutex wait: 0.0% Hash slots: 31013, Hash lengths (min/avg/max):0/ 2/ 11 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (736): forward: 1369256, backward: 20828544 Free owners (35): forward: 6090320, backward: 10504960 Free locks (4172): forward: 262208, backward: 20547568 Free requests (14944): forward: 17197144, backward: 3648808 Regards, Alexey Kovyazin IBSurgeon
Re: [firebird-support] Concurrent connection on embedded firebird
How do you get the connected users? I did evaluate isc_database_info to list connected users. Elmar ++ 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://info.yahoo.com/legal/us/yahoo/utos/terms/
RES: [firebird-support] For those who think they have performance problems
I belive! We use 20011. When we raised to 20011 performance is much better and memory consume is a little bit more. I think FB developers must increase a lot the default value, specially with upcoming FB 2.5.3 De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Alexey Kovyazin Enviada em: sexta-feira, 21 de fevereiro de 2014 07:38 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] For those who think they have performance problems LockHashSlots to 8191. ;-) We have set 31013. Today situation is much better, users are surprised with +30% speed increase, with 700 active connections: LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 75440168, Used: 28721584 Flags: 0x0001 Enqs: 3143976306, Converts: 1574782, Rejects: 253168, Blocks: 6607562 Deadlock scans: 0, Deadlocks: 0, Scan interval: 10 Acquires: 3197419523, Acquire blocks:673, Spin count: 0 Mutex wait: 0.0% Hash slots: 31013, Hash lengths (min/avg/max):0/ 2/ 11 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (736): forward: 1369256, backward: 20828544 Free owners (35): forward: 6090320, backward: 10504960 Free locks (4172): forward: 262208, backward: 20547568 Free requests (14944): forward: 17197144, backward: 3648808 Regards, Alexey Kovyazin IBSurgeon
[firebird-support] RE: Where I put firebird.msg on PC with two client?
---In firebird-support@yahoogroups.com, luigisic@... wrote: Hallo, I have a PC with two clients: - fbclient21.dll (I use ZeosLib + Delphi) for version 2.1 in windows\system - fbclient.dll for version 2.5 in windows\system Why do you think you can't use just v2.5 client ? Both clients connect to the server version 2.5 and I cannot change this unless I update the application that uses fbclient21.dll. What problem do you have ? If I put firebird.msg in Windows\system I create a conflict by different versions of clients (2.1 + 2.5). Nope. But you better should not put non-system files into Windows system folder There is a way to put firebird.msg for 2.1 version in a directory that not conflict with the one for version 2.5? Choose any folder you like, put firebird.msg there and set environment variable FIREBIRD_MSG pointing to this folder. You should set it before you'll load fbclient.dll. But, again, you have no reason to do it. Regards, Vlad
RE: [firebird-support] Firebird 2.5 under Windows 8 64bit
I will check what Dmitry has suggested. Btw, the fb server is installed in the \program files (x86) folder and run as a service and it's a local machine, not a server, so the application is also run on this machine. The Firebird install kits are not Windows 7+ (Windows 2008?/2012+) complaint, they install components into incorrect path which are now access restricted. The only way to install Firebird on such platforms is to install into a root based path (ie. c:\Firebird\) Sean