Project

General

Profile

Bug #2

"Multiple writers not supported" transactioning error occurs if reading and writing concurrently

Added by stephen.bayliss - almost 18 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Immediate
Assignee:
Andrae Muys -
Category:
Mulgara
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
fixed

Description

Errors while attempting to read and write to the same model, from different iTQL sessions.
<br/>

<br/>
- Repeatedly load a file containing (eg) 5000 statements in one iTQL session, for example through an iTQL script
<br/>
- concurrently, repeatedly issue queries from another iTQL session, eg used select $s $p $o from &lt;<a href="rmi://localhost/server1#tranTest">rmi://localhost/server1#tranTest</a>&gt; where $s $p $o limit 100;
<br/>

<br/>
Periodically the following error occurs:
<br/>

<br/>
2006-06-22 13:15:24,839 ERROR [[StatementStoreXAResource]] - Attempting to prepare from different transaction. Multiple writers not supported
<br/>

<br/>
2006-06-22 13:15:24,839 ERROR [[SubCoordinator]] - Got XAException from
<br/>
resource.prepare: Cannot send
<br/>
res.prepare:javax.transaction.xa.XAException (error code = -4) -null
<br/>

Also available in: Atom PDF