Hi Kinh,
In the INI file you provided "MaxClientConnections =10" currently, what it set
to when the server was going down , as in the app provided the number of
Threads is set to 15 so I presume it would crash with this setting ?
I rechecked and noted I test on Linux where you seem to have been testing on
Mac OS X so retested and get the following error when the ServerThreads are
exceeded on my Mac OS X machine;
Hughs-MBP:virtuoso_driver hwilliams$ java -classpath
".:../lib/junit-4.5.jar:../lib/jena-arq-2.10.1.jar:../lib/jena-iri-0.9.6.jar:../lib/jena-core-2.10.1.jar:../lib/jena-core-2.10.1-tests.jar:../../../libsrc/JDBCDriverType4/virtjdbc4.jar:../virt_jena2.jar:../lib/jcl-over-slf4j-1.6.4.jar:../lib/log4j-1.2.16.jar:../lib/slf4j-api-1.6.4.jar:../lib/slf4j-log4j12-1.6.4.jar:../lib/xercesImpl-2.11.0.jar:../lib/xml-apis-1.4.01.jar"
Main1
log4j:WARN No appenders could be found for logger
(com.hp.hpl.jena.util.FileManager).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig
<http://logging.apache.org/log4j/1.2/faq.html#noconfig> for more info.
Exception in thread "Thread-4" Exception in thread "Thread-10" Exception in
thread "Thread-0" Exception in thread "Thread-11" Exception in thread
"Thread-7" com.hp.hpl.jena.shared.JenaException:
com.hp.hpl.jena.shared.JenaException: virtuoso.jdbc4.VirtuosoException: SR214:
Out of server threads. Server temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at Main1.saveUserProfile(Main1.java:69)
at Main1.createUser1(Main1.java:64)
at Main1.access$000(Main1.java:9)
at Main1$1.run(Main1.java:38)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtPrefixMapping.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.getPrefixMapping(Unknown Source)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.getPrefixMapping(ModelCom.java:959)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.withDefaultMappings(ModelCom.java:1003)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:74)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:70)
... 7 more
Caused by: virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads.
Server temporarily unavailable. Transaction rolled back.
at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source)
at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.executeQuery(Unknown Source)
... 13 more
com.hp.hpl.jena.shared.JenaException: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at Main1.saveUserProfile(Main1.java:69)
at Main1.createUser1(Main1.java:64)
at Main1.access$000(Main1.java:9)
at Main1$1.run(Main1.java:38)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtPrefixMapping.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.getPrefixMapping(Unknown Source)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.getPrefixMapping(ModelCom.java:959)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.withDefaultMappings(ModelCom.java:1003)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:74)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:70)
... 7 more
Caused by: virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads.
Server temporarily unavailable. Transaction rolled back.
at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source)
at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.executeQuery(Unknown Source)
... 13 more
com.hp.hpl.jena.shared.JenaException: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at Main1.saveUserProfile(Main1.java:69)
at Main1.createUser1(Main1.java:64)
at Main1.access$000(Main1.java:9)
at Main1$1.run(Main1.java:38)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtPrefixMapping.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.getPrefixMapping(Unknown Source)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.getPrefixMapping(ModelCom.java:959)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.withDefaultMappings(ModelCom.java:1003)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:74)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:70)
... 7 more
Caused by: virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads.
Server temporarily unavailable. Transaction rolled back.
at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source)
at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.executeQuery(Unknown Source)
... 13 more
com.hp.hpl.jena.shared.JenaException: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at Main1.saveUserProfile(Main1.java:69)
at Main1.createUser1(Main1.java:64)
at Main1.access$000(Main1.java:9)
at Main1$1.run(Main1.java:38)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtPrefixMapping.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.getPrefixMapping(Unknown Source)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.getPrefixMapping(ModelCom.java:959)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.withDefaultMappings(ModelCom.java:1003)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:74)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:70)
... 7 more
Caused by: virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads.
Server temporarily unavailable. Transaction rolled back.
at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source)
at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.executeQuery(Unknown Source)
... 13 more
com.hp.hpl.jena.shared.JenaException: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.<init>(Unknown Source)
at Main1.saveUserProfile(Main1.java:69)
at Main1.createUser1(Main1.java:64)
at Main1.access$000(Main1.java:9)
at Main1$1.run(Main1.java:38)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.hp.hpl.jena.shared.JenaException:
virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads. Server
temporarily unavailable. Transaction rolled back.
at virtuoso.jena.driver.VirtPrefixMapping.<init>(Unknown Source)
at virtuoso.jena.driver.VirtGraph.getPrefixMapping(Unknown Source)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.getPrefixMapping(ModelCom.java:959)
at
com.hp.hpl.jena.rdf.model.impl.ModelCom.withDefaultMappings(ModelCom.java:1003)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:74)
at com.hp.hpl.jena.rdf.model.impl.ModelCom.<init>(ModelCom.java:70)
... 7 more
Caused by: virtuoso.jdbc4.VirtuosoException: SR214: Out of server threads.
Server temporarily unavailable. Transaction rolled back.
at virtuoso.jdbc4.VirtuosoResultSet.process_result(Unknown Source)
at virtuoso.jdbc4.VirtuosoResultSet.<init>(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.sendQuery(Unknown Source)
at virtuoso.jdbc4.VirtuosoStatement.executeQuery(Unknown Source)
... 13 more
Hughs-MBP:virtuoso_driver hwilliams$ java -jar
../../../libsrc/JDBCDriverType4/virtjdbc4.jar
OpenLink Virtuoso(TM) Driver for JDBC(TM) Version 4.x [Build 3.65]
Hughs-MBP:virtuoso_driver hwilliams$ java -jar ../virt_jena2.jar
OpenLink Virtuoso(TM) Provider for Jena(TM) Version 2.10.1 [Build 1.9]
Hughs-MBP:virtuoso_driver hwilliams$
What are the versions of the Jena and JDBC Drivers being used in your test ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
<http://www.openlinksw.com/>
Weblog -- http://www.openlinksw.com/blogs/ <http://www.openlinksw.com/blogs/>
LinkedIn -- http://www.linkedin.com/company/openlink-software/
<http://www.linkedin.com/company/openlink-software/>
Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
Google+ -- http://plus.google.com/100570109519069333827/
<http://plus.google.com/100570109519069333827/>
Facebook -- http://www.facebook.com/OpenLinkSoftware
<http://www.facebook.com/OpenLinkSoftware>
Universal Data Access, Integration, and Management Technology Providers
> On 3 Feb 2015, at 08:28, Cong Kinh Nguyen <congkinh.ngu...@inria.fr
> <mailto:congkinh.ngu...@inria.fr>> wrote:
>
> Hi Hugh,
>
> If I increase number of maximal connections, it will be okay. However, I was
> wondering if there would be a way to prevent Virtuoso from being died when
> the number of concurrent connections is greater than the number of maximal
> connections defined in the virtuoso.ini file.
> You find a copy of virtuoso.ini in the enclosed file. Thanks!
>
> On 31/01/15 05:09, Hugh Williams wrote:
>> Hi Cong,
>>
>> I compiled your test app and it runs successfully against my Linux develop7
>> build:
>>
>>
>> VIRTMAIN@vpn184:~/binsrc/jena2/virtuoso_driver$ javac -classpath
>> ".:../lib/junit-4.5.jar:../lib/jena-arq-2.10.1.jar:../lib/jena-iri-0.9.6.jar:../lib/jena-core-2.10.1.jar:../lib/jena-core-2.10.1-tests.jar:../../../libsrc/JDBCDriverType4/virtjdbc4.jar:../virt_jena2.jar:../lib/jcl-over-slf4j-1.6.4.jar:../lib/log4j-1.2.16.jar:../lib/slf4j-api-1.6.4.jar:../lib/slf4j-log4j12-1.6.4.jar:../lib/xercesImpl-2.11.0.jar:../lib/xml-apis-1.4.01.jar"
>> Main1.java
>> VIRTMAIN@vpn184:~/binsrc/jena2/virtuoso_driver$ java -classpath
>> ".:../lib/junit-4.5.jar:../lib/jena-arq-2.10.1.jar:../lib/jena-iri-0.9.6.jar:../lib/jena-core-2.10.1.jar:../lib/jena-core-2.10.1-tests.jar:../../../libsrc/JDBCDriverType4/virtjdbc4.jar:../virt_jena2.jar:../lib/jcl-over-slf4j-1.6.4.jar:../lib/log4j-1.2.16.jar:../lib/slf4j-api-1.6.4.jar:../lib/slf4j-log4j12-1.6.4.jar:../lib/xercesImpl-2.11.0.jar:../lib/xml-apis-1.4.01.jar"
>> Main1
>> log4j:WARN No appenders could be found for logger
>> (com.hp.hpl.jena.util.FileManager).
>> log4j:WARN Please initialize the log4j system properly.
>> log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig
>> <http://logging.apache.org/log4j/1.2/faq.html#noconfig> for more info.
>> VIRTMAIN@vpn184:~/binsrc/jena2/virtuoso_driver$
>>
>> SQL> status('');
>> REPORT
>> VARCHAR
>> _______________________________________________________________________________
>>
>> OpenLink Virtuoso Server
>> Version 07.10.3211-pthreads for Linux as of Jan 24 2015
>> Started on: 2015-01-26 18:33 GMT+1
>>
>>
>> Can you provide a copy of your virtuoso.ini for comparison ?
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> <http://www.openlinksw.com/>
>> Weblog -- http://www.openlinksw.com/blogs/
>> <http://www.openlinksw.com/blogs/>
>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>> <http://www.linkedin.com/company/openlink-software/>
>> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
>> Google+ -- http://plus.google.com/100570109519069333827/
>> <http://plus.google.com/100570109519069333827/>
>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>> <http://www.facebook.com/OpenLinkSoftware>
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>
> Best regards,
> Kinh
> <virtuoso.ini>------------------------------------------------------------------------------
> Dive into the World of Parallel Programming. The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now.
> http://goparallel.sourceforge.net/_______________________________________________
>
> <http://goparallel.sourceforge.net/_______________________________________________>
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> <mailto:Virtuoso-users@lists.sourceforge.net>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
