SR214: Out of server threads. Server temporarily unavailable. Transaction rolled back

[leonqli]

We have 106 connections to run at the same time using isql. It raised the following errors, even when increasing the MaxClientConnections from 100 to 150. Please help if we need to set other parameters. Thanks in advance!

*** Error 40001: [Virtuoso Driver][Virtuoso Server]SR214: Out of server threads. Server temporarily unavailable. Transaction rolled back.
at line 0 of Top-Level:

Version: Virtuoso Open Source Edition (Column Store) (multi threaded) Version 7.2.0_p1.3212-pthreads as of Jul 27 2015

[HughWilliams]

There two MaxClientConnections settings in the [Parameters] and [HTTP Server] sections of the INI file thus which one have you changed ?

The one in the [Parameters] section would control the database SQL threads, for external connections with isql (or other SQL clients) and internal SQL threads for processing requests, thus I suspect your 106 isql connections are consuming more than 150 threads in the database. So I would suggest increasing to something like 1000, as these threads are only allocated on request and not preallocated, so there is no harm in setting it to a high value.

Finally I note your Virtuoso build is from 2015 and would recommend scheduling to update to a current build.

[leonqli]

Thanks @HughWilliams for your quick reply! We changed both previously. Now we will increase the MaxClientConnections at [Parameters] to 1000 as you suggested.