FS#36801 - [virtuoso-base] After downagraded to version 6.1.6 causes dolphin to stutter

Attached to Project: Arch Linux
Opened by dlh (dlh) - Thursday, 05 September 2013, 21:01 GMT
Last edited by Andrea Scarpino (BaSh) - Friday, 13 September 2013, 15:53 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Andrea Scarpino (BaSh)
Sven-Hendrik Haase (Svenstaro)
Architecture All
Severity High
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 5
Private No

Details

Description:
After downagraded virtuoso dolphin slow down and I am unable to use it. So I decided to turn off Nepomuk Service at all and then kill virtuoso process.

Additional info:
* 1:6.1.6-1
* default


Steps to reproduce:
Switch catalogs in dolphin, try to mark files with mouse and so...
This task depends upon

Closed by  Andrea Scarpino (BaSh)
Friday, 13 September 2013, 15:53 GMT
Reason for closing:  Fixed
Additional comments about closing:  Updated again to 6.1.7. Upstream will fix broken rating in 6.1.7 ASAP.
Comment by Faramarz Talesh (FarTa) - Friday, 06 September 2013, 07:12 GMT
KMail is also very slow: High cpu usage by virtuoso-t.
After downgrade to virtuoso-base-6.1.7-1 and virtuoso-6.1.7-1 everything works again.
Comment by zless (roentgen) - Sunday, 08 September 2013, 11:58 GMT
According to the announcement downgrading
virtuoso-base also needs reverting 0e01d5b5
in nepomuk-core.
Comment by Andrea Scarpino (BaSh) - Monday, 09 September 2013, 07:14 GMT
@Artur
commit 0e01d5b5 really does "nothing" http://quickgit.kde.org/?p=nepomuk-core.git&a=commitdiff&h=0e01d5b5

I'm waiting for upstream here, they told us to "absolutely" downgrade virtuoso...so I did.
Comment by Andrea Scarpino (BaSh) - Tuesday, 10 September 2013, 13:58 GMT
Seems that the update to 4.11.1 solved this issue. Could anyone confirm?
Comment by zless (roentgen) - Tuesday, 10 September 2013, 16:26 GMT
I can't really confirm. Both Dolphin and Kmail behave sub-optimal.

There's a very distinct and random lag on certain actions like
selecting an email in Kmail, pressing arrow-down on the file list
with Dolphin.
Comment by Andrea Scarpino (BaSh) - Tuesday, 10 September 2013, 16:35 GMT
Yep, after using dolphin/kmail for 2 hours I confirm your last feedback.
Comment by dlh (dlh) - Tuesday, 10 September 2013, 21:20 GMT
I can confirm that after 4.11 lag is a little bit smaller, but it still very uncomfortable to use dolphin with nepomuk service
Comment by Simeon (bladud) - Wednesday, 11 September 2013, 15:02 GMT
Try making a backup (if you have tags), deleting your db, and letting everything reindex. I think the database format changed somewhat on upgrade, and the older version flips out when trying to read it. Probably this only hits you with files indexed when 6.1.7 was installed, so you might be able to do something clever to remove them. But hey, reindexing is easy and relatively fast now, plus you get to test that the indexer is working!

For me the issue was actually that dolphin search didn't really work at all - a bunch of files kept showing up as unindexed.

==Why I think this:==

I turned on debug output with kdebugdialog, restarted nepomuk with "nepomukctl restart" in a terminal and then reindexed some things using systemsettings.

I got a bunch of errors like this:
"SQLExecDirect failed on query 'sparql DEFINE input:inference <nepomukinference> select ?r where { ?r <http://www.semanticdesktop.org/ontologies/2007/01/19/nie#url> <file:///test.test> . } limit 1' (iODBC Error: [OpenLink][Virtuoso iODBC Driver][Virtuoso Server]SR496: Property <http://www.openlinksw.com/schemas/virtrdf#qmfMapsOnlyNullToNull> is not a field of struct qm_format_s, RDF class <http://www.openlinksw.com/schemas/virtrdf#QuadMapFormat>)")

If you look at this file:
https://github.com/openlink/virtuoso-opensource/blob/v6.1.6/libsrc/Wi/rdf_mapping.jso
vs this one:
https://github.com/openlink/virtuoso-opensource/blob/v6.1.7/libsrc/Wi/rdf_mapping.jso
you see that the latter has the row:
JSO_SCALAR qmfMapsOnlyNullToNull BOOLEAN OPTIONAL --!< Nonzero if the format gives NULL IFF short value is NULL

So, yes, the new db is not the same as the old.

==How to reindex (the brutal way, if you have no tags)==
Stop nepomuk
Edit $HOME/.kde4/share/config/nepomukstrigirc
so that it has "first run=true" instead of "first run=false"
Move $HOME/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend somewhere else.
Start nepomuk again

==How to reindex (the less brutal way==
Make a backup in system settings. Do the above. Restore the backup.
(arguably there should be a big red button somewhere to do this)
Comment by Simeon (bladud) - Wednesday, 11 September 2013, 22:03 GMT
PS Probably a bad idea to upgrade again, because some of the nepomuk tests fail on 6.1.7, or at least did last time I tried.
Comment by Andrea Scarpino (BaSh) - Wednesday, 11 September 2013, 22:09 GMT
Yes, upstream told me to NOT upgrade to 6.1.7 again.

I fixed the lag by wiping the nepomuk database.

Loading...