Ticket #616 (closed defect: wontfix)

Opened 1 year ago

Last modified 1 year ago

error in runitql on delete

Reported by: russ Assigned to: ronald
Priority: medium Milestone:
Component: topaz-mulgara Version: 0.8
Keywords: Cc:
Blocking: Blocked By:

Description

the delete works just fine, but i get an error at the end 

itql> delete
itql> select $s $p $o
itql> from <local:///topazproject#ri>
itql> where $s $p $o
itql> and <info:doi/10.1371/journal.pctr.0010010> $p $o
itql> from <local:///topazproject#ri>;
Error running query:
javax.xml.soap.SOAPException: ItqlInterpreter error - org.mulgara.query.QueryException: Unable to modify local:///topazproject#ri
Caused by: (QueryException) Unable to modify local:///topazproject#ri
Caused by: (IllegalStateException) Cannot get Transaction for commit

Dependency Graph

Change History

08/27/07 21:55:34 changed by amit

  • owner changed from ronald to ebrown.

09/21/07 14:26:47 changed by amit

  • owner changed from ebrown to ronald.
  • priority changed from low to medium.
  • version changed from 0.7 to 0.8.

We believe this might be dependent on the version of Mulgara. Do a: 

set autocommit off;

before and then: 

commit;

We need to investigate what happened on the mulgara side.

09/21/07 22:17:46 changed by pradeep

  • status changed from new to closed.
  • resolution set to wontfix.

It is the same situation that we ran into in #652 while trying to manually delete. The exception occurs when running in autocmmit mode. The work around is shown in Amit's comment. Closing this since there is a work around for the runitql tool and the plos-one app and otm does not run updates in autocmmit mode.