14 Jan
2014
14 Jan
'14
4:57 p.m.
Pete Ashdown wrote:
What we found is that if the thread pool max_servers > sql num_sql_socks this error will occur.
That's also documented IIRC. If you have more threads than SQL sockets, then some threads can fail to get an SQL socket. This is because all of the thrreads run in parallel. And yes, the overwhelming majority of the time the issue is that the DB is slow. People configure the server to have 1000 threads and 1000 SQL sockets... and still run into the error. The only solution there is to fix the DB. Alan DeKok.