[firebird-support] An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll
I am creating a project windows runtime component with c# , I want to create a embedded DB so i am using Firebird-2.5.2.26540-0_x64_embed and .net provider NETProvider-2.5.2-CF . every time i am getting same error: An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll . my project is not targeted to any .net framework because it is only WinRT( c# )... Please help me guys..please reply
[firebird-support] Re: SQL query aborts when SQL statement is too long or complex.
Thanks! I check the contents. --- In firebird-support@yahoogroups.com, Dmitry Yemanov dimitr@... wrote: 10.02.2014 08:55, hosodaamiya wrote: What do you mean by available range? Documented 1500 items limit or something else? I meant documented 1500 items limit. I create the WHERE clause with less than 1000 constants. But 1000 or less constants makes the query execution unsuccessful. My script cannot handle the error. The error in windows event log that I have meant before is recorded instead. The 1500 items limit is not abstract. The IN list is transformed into a set of ORs and then processed recursively, thus requiering a large enough stack. Every thread has a limited stack size. On Windows, the default value is 1MB and it's predefined for exe-files at their linkage time. This is not enough for Firebird, so both fbserver.exe and fb_inet_server.exe override the limit to be 2MB on 32-bit platforms and 4MB on 64-bit ones. However, the embedded server is a library, so it depends on the stack size of the application that loads fbembed.dll. In your case this should be IIS and you surely cannot recompile it, but there are some tricks that you could try, see for example: http://blogs.msdn.com/b/tom/archive/2008/03/31/stack-sizes-in-iis-affects-asp-net.aspx http://stackoverflow.com/questions/2319711/increase-stack-size-iis-asp-net-3-5 Another option is to use a standalone Firebird server instead of the embedded one. Dmitry
Re: [firebird-support] An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll
Am 10.02.2014 08:31, schrieb nkd...@gmail.com: I am creating a project windows runtime component with c# , I want to create a embedded DB so i am using Firebird-2.5.2.26540-0_x64_embed and .net provider NETProvider-2.5.2-CF . every time i am getting same error: An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll . my project is not targeted to any .net framework because it is only WinRT( c# )... Please help me guys..please reply You probably will get more answers here: https://lists.sourceforge.net/lists/listinfo/firebird-net-provider hth fsg -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling
[firebird-support] Occasional server hangs/major slowdowns
Hello, Every now and then (about week or two) one of my systems hangs, and it seems to be related to Firebird server. I'm running Firebird 2.5.2 on 32-bit Windows 7 as SuperServer. It looks like Firebird server process stops responding. Usually I've restarted the server process, but today I just killed most of the applications and waited some time and it came back to life. I'm kind of lost how to start debugging this. What would be the first steps? Is there any benefit switching to classic server? Does it require changes in clients? Server log contained today only: INET/inet_error: read errno: 10054 messages, earlier there has been also XNET: can't start worker thread. connection terminated and Operating system call _beginthreadex failed. Error code 8.
[firebird-support] RE: Occasional server hangs/major slowdowns
Seems that Firebird is running out of virtual memory 2G limit for 32bit version http://tracker.firebirdsql.org/browse/CORE-2978
[firebird-support] Firebird slowdowns while resources are available
Hi, I have a strange slowdown problem with a Firebird database. During the daily use of the database the clients experience significant slowdowns while the system still have lots of resources available. Some information about the environment: - 64 bit Firebird 2.5.2 server running in SuperServer mode - the database is running on a 64 bit Windows 2008 R2 server OS - the server OS is running in a VMware 4.1 VM with 4 CPU cores and 16 GB of RAM - the database size is around 37 GB and the number of concurrent connections to the database is around 150. While observing the slowdowns: - the CPU usage on the machine is between 40-60% without higher spikes and the load is nicely distributed among all 4 cores - the memory usage of the server is around 4-6 GB and the rest of the memory is used as OS cache - the disc queue lenghts almost never go over 0.3 with around 2-5 ms latency - there is almost no network activity on the server. Still, the slowdown seems to be linked to the general load on the server. During the night when no users are connected to the database/no background jobs are running a test query used for reference executes in 4-5 seconds while during the day when all the users are connected to the database executing the same reference query requires 60+ seconds to finish. It should be added though that the slowdown is general in nature, there are no specific queries that are slower while the server is under load, everything gets slower within the specific Firebird database. The server has other databases with a very low number of transactions executed daily and these other databases show no sign of slowdowns. I even created a copy of the live database experiencing slowdowns and executed the same query against both the originaly and the duplicate database - the original did execute the query slow and hte duplicate fast. The only difference between the original and the duplicate I know is the number of connected users/concurrent transactions. As I found no evident reasons of all these in the available OS resources so I tried to fetch statistics from Firebird. The observations: - at peak times the databse has 30-40 transactions running in parallel according to mon$statements (where mon$state == 1 which according to the archives means the transactions are running or are waiting for a lock) - fb_lock_print displays the following about the database: LOCK_HEADER BLOCK Version: 145, Active owner: 0, Length: 2097152, Used: 1335440 Flags: 0x0001 Enqs: 9993237, Converts: 93191, Rejects: 1417230, Blocks: 2 Deadlock scans: 0, Deadlocks: 0, Scan interval: 10 Acquires: 19972846, Acquire blocks: 0, Spin count: 0 Mutex wait: 0.0% Hash slots: 1009, Hash lengths (min/avg/max):0/ 2/ 7 Remove node: 0, Insert queue: 0, Insert prior: 0 Owners (38):forward: 20824, backward: 872088 Free owners (126): forward: 973360, backward: 728016 Free locks (370): forward: 852200, backward: 195936 Free requests (12425): forward: 614608, backward: 1230536 Lock Ordering: Enabled Here I noted that the rejects field accounts for ~14% of enqs field but unfortunately I don't know the exact meaning of these values. I guess about 14% of the lock requests are rejected for some reason but I might be completely wrong. So the questions: - How should the output of fb_lock_print interpreted in this case? Are these numbers wrong in some sense? Can they be improved by some parameter tuning? - What additional steps should be taken to pinpoint what causes the slowdowns? Thanks, Zoltan
[firebird-support] INET/inet_error
Hi, I'm running Firebird Superserver on Linux Debian 6.0 for a couple of years. Inspecting connected clients, I found a client process of my own ( a cron python script ) that didn't finished and remained hanged since many days. I killed it from linux shell ( killall scriptname ), and so when I listed connected clients it effectively dissapeared. Suddenly after, the firebird server remained deaf: it stopped answering not only remote clients but local clients as well. Running the command isql-fb -user username -password psw localhost:databasename lasted forever. Looking into /var/log/firebird2.5.log I found six of the following messages: my_server_name (Server) Mon Feb 10 15:01:26 2014 INET/inet_error: read errno = 104 I restarted Firebird server daemon and now everything seems to work well ( I run a gfix validate to my database and it went OK ) As it is the first time in my experience that the firebird sever stops responding, I'm concerned about what could be the cause of this behaivour, and how to prevent it. Thanks in advance for any diagnose. Aldo Caruso
[firebird-support] A question about rdb$character_set_id
Hi Is the integer value of the column rdb$character_set_id from the table rdb$character_sets constant between Firebird versions? E.g. will character set UTF8 always be 4 (and was it 4 in pre-2.5 versions)? Thanks Ian Barwick