hsadia538 commented on issue #12070:
URL: https://github.com/apache/ignite/issues/12070#issuecomment-2895101867
Another follow up to this question
I tried to do the same in another java app and i face the same issue.
```
try (ResultSet<SqlRow> rs = client.sql().execute(null, "SELECT id FROM
mytable")) {
while (rs.hasNext()) {
SqlRow row = rs.next();
String id= row.stringValue("id"); // Extract the ID
idList.add(idList); // Add the ID to the list
}
} catch (Exception e) {
System.err.println("Error fetching ids using SQL: " +
e.getMessage());
e.printStackTrace();
}
```
Error i get is :
`Caused by:
org.apache.ignite.internal.sql.engine.exec.RemoteFragmentExecutionException:
IGN-TX-13 TraceId:7ce7b882-b2cd-45db-bc88-e746352e0b3f Transaction is already
finished () [txId=0196ee68-1f6c-0000-e5f1-efe300000001, readOnly=true].
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.onMessage(ExecutionServiceImpl.java:610)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.lambda$start$4(ExecutionServiceImpl.java:302)
at
org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.onMessageInternal(MessageServiceImpl.java:166)
at
org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.lambda$onMessage$2(MessageServiceImpl.java:132)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
... 1 more`
the above is from cluster logs and everything just fails after this.
What i dont understand( or confused about) is that it seems to be a simple
read operation. Is there no straightforward way of reading data from ignite
like this. Am I missing something.
In the ignite documentation, I searched for the error **IGN-TX-13 ** but
there are no leads on how to resolve this.
My usecase is very basic i-e writing some data and reading it. I am not even
using multiple nodes etc and everything is running locally.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
