Re: [Firebird-devel] 32-bit Firebird attempting to create large amount of thread on 64-bit server

[Alex P. <pes...@ma...>]

 On 01/25/11 21:58, Dmitry Yemanov wrote:
> 25.01.2011 21:37, Yi Lu wrote:
>> It appears that the crash always occur when FB2.5 32-bit is running on
>> 64-bit OS. Also we observed that on 64-bit system, FB2.5 32-bit was trying
>> to create a lot more thread than FB2.1 did in the same situation, which we
>> suspect exceeded the limit of thread numbers of the OS and caused the
>> shortage of memory or other system resources. We notice that it is much more
>> likely to crash when 32-bit fbserver.exe has more than 500 threads.
> 500 threads * 2MB of stack = 1GB. Add the buffer cache etc and you get 
> pretty close to the address space limit for 32-bit processes. Error 
> "_beginthreadex failed" with error code 8 (ERROR_NOT_ENOUGH_MEMORY) 
> confirms that. And this is pretty much expected.
>
> The question is why v2.5 SS creates much more threads than v2.1.

If people access more than 1 database, this is more or less obvious.