Hi all, We are running FB SC 64 bit build on a Win2k8R2 machine.
>From the process explorer I can see that there are around 300-400 connections >(threads) for the Firebird process, distributed amongst a similar amount of >databases, i.e. typically one or two users per DB, though there may be more >connections for some of the DB's. The customers do "normal" DB-work, but they >also backup databases, modify metadata, and thus shut down the databases and >"throw off" other users, also when doing restores. All in all a variety of >operations on lots of different database files. We do all backups and restores >via the "new" WAN-friendly backup function introduced in FB2.5.2. Several times a day we experience a server crash where the FB process simply terminates, no log entries in the firebird log, but of course an entry in the windows system logs: "The Firebird Server - DefaultInstance service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: Restart the service." We get regular "INET/inet_error: read errno = 10054", but that is not very unusual, except that sometimes we get a whole lot of "INET/inet_error: read errno = 10054" at the exact same time, like the server simply drops (all?) connections. Today at 10:20 we had 65 entries with the same time stamp, but no log entry in the windows system logs, so the FB server itself survived. Of course, these events can be caused by an internet provider having a glitch and is not necessarily caused by the FB-server. We experienced this with FB2.5.1 and hoped that the problem would be eliminated with 2.5.2, but it didn't disappear. And now we have tried one of the latest nightly builds (2.5.3.26612) but with the same result (the above system log entry is from 2.5.3). I want to try to set up the system for CS instead of SC, hoping that only one process at a time will crash thus leaving the other connections running. I want to install the debug build to hope for a useful trace log so that "we" (meaning you FB-developers :) can hunt down the error. Are there any advices, comments, or hints, that I should know of before going this way? Are there any cook books regarding how to setup the system for doing proper and interesting crash dumps? Best regards Poul Dige ------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
