Re: [Virtuoso-users] Error 40005 After INSERT SOFT

2009-02-18 Thread André Ramos
Hi Ivan, Thanks for your answer. I managed to insert all articles at once after setting some parameters as described in [1], especially the TransactionAfterImageLimit. So I guess the point of your suggestion was to prevent the roll-forward log entry of the transaction exceed its maximum size, was

Re: [Virtuoso-users] Error 40005 After INSERT SOFT

2009-02-17 Thread Ivan Mikhailov
Hello Andre, I'd recommend to insert in smaller fractions than all articles at once. Say, create procedure fill_dbpedia_article () { for ( select "uri", "title", "abstract", count(*) as specificity from ( sparql select * where { graph

[Virtuoso-users] Error 40005 After INSERT SOFT

2009-02-17 Thread André Ramos
Hello, I commanded Virtuoso to insert the results of a query into a table and then I got this error message about 24 hours after I started the insert command. This is the error message: *** Error 40005: [Virtuoso Driver][Virtuoso Server]SR325: Transaction aborted because it's log after image size