# Failed to run query: 000012: Operation not supported for streaming result sets (Internal Server Error) **URL:** \ **Category:** Support\ **Created:** [February 21, 2020, 7:47am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258 "2020-02-21T07:47:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![anuragroy11](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/anuragroy11/32/606_2.png) [@anuragroy11](https://community.stardog.com/u/anuragroy11)\ **Post date:** [February 21, 2020, 7:47am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/1 "2020-02-21T07:47:12Z")
Hi, I was trying to create a virtual graph in Stardog without providing any R2RML or SMS files. My data source is in my local MySql Server and the data is the one provided in StarDog's virtual graph tutorial with this [schema](https://github.com/stardog-union/stardog-tutorials/blob/master/using-virtual-graphs/music_schema.sql) and [data](https://github.com/stardog-union/stardog-tutorials/blob/master/using-virtual-graphs/beatles.sql). It successfully creates the virtual graph but when I try to run some queries I get this error(given in the title). But some of the queries run. One which doesn't work is: CONSTRUCT { ?s ?p ?o }WHERE{ GRAPH \{ ?s ?p ?o } } Even the COPY command doesn't work and gives the same error. Any help will be appreciated. Thanks, Anurag ---
**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\ **Post date:** [February 21, 2020, 10:59am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/2 "2020-02-21T10:59:29Z")
Hi Anurag, Please attach the portion of the stardog.log file that relates to this error. Thanks, -Paul ---
**Author:** ![Prodipta\_Golder](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/prodipta_golder/32/615_2.png) [@Prodipta\_Golder](https://community.stardog.com/u/Prodipta_Golder)\ **Post date:** [February 21, 2020, 4:16pm UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/3 "2020-02-21T16:16:59Z")
Anurag, try below: `construct {?s ?p ?o} where {graph { select * where {?s ?p ?o}} }` Prodipta. ---
**Author:** ![anuragroy11](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/anuragroy11/32/606_2.png) [@anuragroy11](https://community.stardog.com/u/anuragroy11)\ **Post date:** [February 24, 2020, 5:37am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/4 "2020-02-24T05:37:38Z")
Hi, I tried your given query but it gives the same result. Anurag. ---
**Author:** ![anuragroy11](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/anuragroy11/32/606_2.png) [@anuragroy11](https://community.stardog.com/u/anuragroy11)\ **Post date:** [February 24, 2020, 5:39am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/5 "2020-02-24T05:39:46Z")
Hi Paul, The portion of the log file you had requested: WARN 2020-02-22 15:56:49,212 [stardog-user-4] com.complexible.stardog.protocols.http.server.StardogUndertowErrorHandler:accept(61): Unexpected exception was handled by the server com.mysql.jdbc.OperationNotSupportedException: Operation not supported for streaming result sets at com.mysql.jdbc.RowDataDynamic.notSupported(RowDataDynamic.java:403) ~[mysql-connector-java-5.1.48.jar:5.1.48] at com.mysql.jdbc.RowDataDynamic.getCurrentRowNumber(RowDataDynamic.java:222) ~[mysql-connector-java-5.1.48.jar:5.1.48] at com.mysql.jdbc.ResultSetImpl.getRow(ResultSetImpl.java:4882) ~[mysql-connector-java-5.1.48.jar:5.1.48] at com.complexible.stardog.virtual.vega.mapping.TemplateTermMap$1.createValue(TemplateTermMap.java:231) ~[stardog-virtual-core-7.1.2.jar:?] at com.complexible.stardog.virtual.ValueGenerator$AbstractValueGenerator.generateValue(ValueGenerator.java:100) ~[stardog-virtual-core-7.1.2.jar:?] at com.complexible.stardog.virtual.VirtualGraphStatementIterator.computeValue(VirtualGraphStatementIterator.java:40) ~[stardog-virtual-core-7.1.2.jar:?] at com.complexible.stardog.virtual.VirtualGraphStatementIterator.computeValue(VirtualGraphStatementIterator.java:26) ~[stardog-virtual-core-7.1.2.jar:?] at com.complexible.stardog.virtual.VirtualGraphIterator.computeNext(VirtualGraphIterator.java:156) ~[stardog-virtual-core-7.1.2.jar:?] at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-26.0-jre.jar:?] at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-26.0-jre.jar:?] at com.complexible.stardog.virtual.StatementToSolutionIterator.hasNext(StatementToSolutionIterator.java:47) ~[stardog-virtual-core-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:93) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:33) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.SingleProjectionOp.computeNext(SingleProjectionOp.java:87) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.SingleProjectionOp.computeNext(SingleProjectionOp.java:29) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.LazySortedGroupify$1.computeNext(GroupifyAlgorithms.java:390) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.LazySortedGroupify$1.computeNext(GroupifyAlgorithms.java:381) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.AbstractGroupOp.computeNext(AbstractGroupOp.java:161) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.AbstractGroupOp.computeNext(AbstractGroupOp.java:34) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.DistinctOp.computeNext(DistinctOp.java:58) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.DistinctOp.computeNext(DistinctOp.java:21) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:119) ~[stardog-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:26) ~[stardog-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.1.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.OpBasedAbstractStatementIteration.computeNext(OpBasedAbstractStatementIteration.java:71) ~[stardog-7.1.2.jar:?] at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-26.0-jre.jar:?] at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-26.0-jre.jar:?] at com.complexible.common.rdf.query.IteratorAsGraphQueryResult.hasNext(IteratorAsGraphQueryResult.java:93) ~[stardog-utils-rdf-7.1.2.jar:?] at com.complexible.stardog.plan.eval.TransactionManagedQueryResult.next(TransactionManagedQueryResult.java:81) ~[stardog-7.1.2.jar:?] at com.stardog.stark.io.RDFWriters.write(RDFWriters.java:196) ~[stardog-stark-io-api-7.1.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:581) ~[stardog-protocols-http-server-7.1.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:509) ~[stardog-protocols-http-server-7.1.2.jar:?] at com.complexible.stardog.protocols.http.server.SPARQLProtocol.executeQuery(SPARQLProtocol.java:129) ~[stardog-protocols-http-server-7.1.2.jar:?] at com.complexible.stardog.protocols.http.server.SPARQLProtocol.post(SPARQLProtocol.java:94) ~[stardog-protocols-http-server-7.1.2.jar:?] at com.stardog.http.server.undertow.jaxrs.ExtractRoutes.lambda$handleIt$5(ExtractRoutes.java:192) ~[stardog-protocols-http-server-7.1.2.jar:?] at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120) [shiro-core-1.3.0.jar:1.3.0] at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108) [shiro-core-1.3.0.jar:1.3.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0\_242] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0\_242] at java.lang.Thread.run(Thread.java:748) [?:1.8.0\_242] Thanks, Anurag. ---
**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\ **Post date:** [February 24, 2020, 11:20am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/6 "2020-02-24T11:20:33Z")
Please try adding these JDBC connection parameters to your connection URL: UseStreamingResults=false&useCursorFetch=true&defaultFetchSize=10000 -Paul ---
**Author:** ![anuragroy11](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/anuragroy11/32/606_2.png) [@anuragroy11](https://community.stardog.com/u/anuragroy11)\ **Post date:** [February 25, 2020, 6:23am UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/7 "2020-02-25T06:23:32Z")
Hi Paul, I used this connection url: jdbc.url=jdbc:mysql://localhost/music?UseStreamingResults=false&useCursorFetch=true&defaultFetchSize=10000 but still the error persists. Thanks, Anurag ---
**Author:** ![Prodipta\_Golder](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/prodipta_golder/32/615_2.png) [@Prodipta\_Golder](https://community.stardog.com/u/Prodipta_Golder)\ **Post date:** [February 25, 2020, 3:07pm UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/8 "2020-02-25T15:07:57Z")
Try adding those properties in driver option or other options from studio instead of parameters in jdbc url ---
**Author:** ![PaulJackson](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/pauljackson/32/243_2.png) [@PaulJackson](https://community.stardog.com/u/PaulJackson)\ **Post date:** [February 25, 2020, 3:43pm UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/9 "2020-02-25T15:43:48Z")
I see, it has to do with us calling `ResultSet.getRow`, which we do when we map row numbers to bnodes, which, in turn, we do when we generate mappings for tables with no primary key. You either add a primary (or unique) key constraint, or reload our auto-generated mappings. To do the latter: ``` stardog-admin virtual options vgname > vgname.properties stardog-admin virtual mappings vgname > vgname.mappings stardog-admin virtual add -o vgname.properties vgname.mappings ``` -Paul ---
**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\ **Post date:** [March 10, 2020, 3:43pm UTC](https://community.stardog.com/t/failed-to-run-query-000012-operation-not-supported-for-streaming-result-sets-internal-server-error/2258/10 "2020-03-10T15:43:49Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.