libera/#maemo-leste/ Friday, 2023-12-08

Wizzupfreemangordon: ok, tried that now, let's see if this works out00:32
WizzupI see this btw:00:33
Wizzup$ tracker daemon -s00:33
WizzupStarting miners…00:33
Wizzup(tracker daemon:30492): Tracker-CRITICAL **: 00:32:48.217: Could not create proxy on the D-Bus session bus, Error calling StartServiceByName for org.freedesktop.Tracker1.Miner.Extract: Timeout was reached00:33
Wizzupfreemangordon: there is also .cache/tracker btw00:38
Wizzupfreemangordon: so I get the exact problem after I killed the processes, did a hard reset, removed any extra files02:06
Wizzupsame problems: tracker-extract starting constantly02:06
Wizzupwith was with mafw not even running02:07
Wizzupthis was*02:07
freemangordonWizzup: maybe try to do hard reset, remove both directories (.cache/tracker and .local/share/tracker/) and then start trackers07:29
freemangordonif it still does not work, I am out of ideas07:29
freemangordonand yes, mafw has nothing to do07:29
arno11is it normal that my device (up-to-date) is not affected by trackers issue ?09:15
arno11just to be sure09:16
freemangordonseems the issue appears when there is a huge amount of music09:18
arno11ok09:18
freemangordonalso, after the last experiments, my device does not suffer as well09:19
arno11ah cool09:19
freemangordonnot really, as now i can't repro :)09:19
arno11ok :)09:20
Wizzupfreemangordon: I did that12:31
freemangordon:(14:34
freemangordonWizzup: how many GB of music do you have?14:35
Wizzuplet me check14:37
Wizzup# du -sh /mnt/sd/music/14:37
Wizzup17G/mnt/sd/music/14:37
freemangordonok14:37
freemangordonI'll copy some more to the VM14:37
WizzupI wonder if we need to take a step back to try to figure out what's going on here14:38
Wizzupthis seems like such a grave tracker bug maybe something else is going on14:38
freemangordonmhm14:38
freemangordonfor sure thre is a nasty memleak in mafw-tracker-source14:38
freemangordonI already fixed, have to issue a build14:38
Wizzupit looks like the tracker irc channel is mostly empty, probably the irc bridge is gone, so we'll have to install a matrix client to talk to gnome14:39
Wizzupwell, unless valgrind finds serious problems (not just with memleaks), I doubt they can cause the issues we are seeing14:39
Wizzupso you are sure that the behaviour we are seeing is because one db is deleted, and the other doesn't realise, and the db gets deleted, why? do we know?14:39
freemangordonyes, db gets deleted because tracker receives "CORRUPTED" result from some sqlite query14:40
freemangordonbut I can;t repro anyhmre14:41
Wizzupand then they just decide to the delete the db? interesting14:41
freemangordonon both my d4 and my VM after I deletet *all* tracker related files, I see no issue anymore14:41
WizzupI mean I'm happy to do it again, I just don't think it'll make a diff, sec14:42
freemangordonso:14:42
freemangordonstop ,mafw14:42
freemangordontracker reset -r14:42
Wizzupmafw-source-tracker is stopped14:42
freemangordonstart mafw14:42
freemangordonoh,sorry14:42
freemangordontracker reset -r14:42
WizzupI am confused now14:43
freemangordonrm -rf  ~/.cache/tracker14:43
freemangordonrm -rf ~/.local/share/tracker/14:43
freemangordonstart mafw14:43
freemangordonwhy?14:43
Wizzupand then tracker daemon -s14:43
Wizzup?14:43
freemangordonno need14:44
freemangordonstarting mafw will start the tracker14:44
freemangordonwhy are you confused?14:44
WizzupI was confused when you wrote 'oh,sorry'14:44
Wizzupin any case I did what you wrote above14:44
Wizzupthe only difference is that I didn't even run mafw, I just ran tracker daemon -s14:44
freemangordonbecause I missed the 'rm -rf' steps :)14:44
Wizzupto rule out mafw messing anything up14:44
freemangordonI see14:45
freemangordonanyway, I have 11GB on my VM14:45
freemangordonthe diff is that it is in MyDocs14:45
freemangordonmaybe that's the reason14:45
Wizzupdoes mafw-dbus-wrapper honour /etc/profile.d btw?14:45
freemangordonno idea14:46
freemangordonwhat is in there?14:46
Wizzuplooks like it14:46
Wizzup$ cat /etc/profile.d/tracker-maemo.sh14:46
Wizzupexport TRACKER_USE_LOG_FILES=114:46
Wizzupfreemangordon: ^14:46
freemangordonah14:46
Wizzupwell so far only tracker-store is running, but maybe others will start eventually14:46
freemangordonI am not sure what happens if started it from xsession file14:46
freemangordonyes, they will14:47
freemangordonI'll do the same here14:47
freemangordonto see if it will fail this time14:47
freemangordon(in the VM)14:47
Wizzupright14:47
freemangordonbtw, how do you stop mafw?14:47
Wizzup/usr/bin/mafw.sh stop mafw-tracker-source14:47
freemangordonok14:48
Wizzupstill only tracker-store14:49
Wizzup6 mins later14:49
freemangordonyeah14:49
Wizzupshall I run tracker daemon -s  ?14:49
freemangordonno14:49
Wizzupwhen/how do these get started then?14:50
freemangordonI guess tracker-store uses lots of cpu14:50
Wizzupit's doing something still14:50
freemangordontracker daemon -f14:50
Wizzupit just finished14:50
freemangordonand?14:51
freemangordonwhat does tracker daemon -f say?14:52
Wizzupfreemangordon: following14:58
Wizzupit's crawling various dirs14:58
Wizzupand now is processing14:58
Wizzupextractor not running yet14:58
freemangordonok14:59
freemangordonhmm, why extractor is not running?14:59
freemangordonit should14:59
freemangordonah, wait15:00
freemangordonminer shall finish with crawling first15:00
Wizzupyes15:00
Wizzupnow it is running on my d415:00
Wizzupbrb15:00
freemangordonok, after copying some more music in the VM, it happened again15:11
freemangordonWizzup: "(tracker-store:7084): Tracker-CRITICAL **: 16:49:35.135: SQLite error: database disk image is malformed (errno: Success)"15:50
Wizzupdo we have a line number for this somewhere?15:53
freemangordonrebuilding tracker with debug symbols, will have it in few minutes15:54
freemangordonWizzup: ../src/libtracker-data/tracker-db-interface-sqlite.c:234615:57
freemangordonthis is where g_unlink is called from15:57
freemangordonso it comes from link 234115:58
Wizzupok, I need to get vm started and apt-get source15:59
freemangordonlemme run that under valgrind15:59
Wizzupah, you got it to the point where it doesn't actually remove the db? that's good16:00
Wizzup(for testing)16:00
freemangordonno16:00
freemangordonI put a BP in g_unlink :)16:00
freemangordonand it got hit right after that error16:00
freemangordonso it does remove the db16:00
freemangordonso, somehow, someone is corrupting the database16:01
freemangordonand that seems to be for real16:01
WizzupSQLITE_CORRUPT isn't as bad as it sounds from my reading16:03
Wizzupbut yes, something is weird there16:03
freemangordonit should not happen without a crash, no?16:03
freemangordonbtw, there are 3453 frames in the backtrace16:04
freemangordonit seems to be executing huge query16:05
freemangordonhundreds if not thousands of DELETE statements16:06
Wizzupnot sure why there should be so many frames if it's a big delete16:07
freemangordonI suspect this is the final cleanup16:07
freemangordonmaybe they do a recursion16:07
Wizzup*facedesk* :)16:08
freemangordonyes, I see 2 functions again and again16:08
WizzupMaybe it runs out of stack depth then or something?16:08
Wizzupit might also be that it runs out of the size limits they themselves set16:09
Wizzupbut still, this should happen to many people, no?16:09
freemangordonok, under valgrind there is no issue :(16:09
freemangordonno idea16:09
freemangordonlemme try again16:09
WizzupI don't know if the page_size or cache_size have any effect here16:12
Wizzupit looks like I've gotten into the same situation again btw16:12
Wizzuplast update was 08 Dec 2023, 16:05:19:   69%  Extractor            - Extracting metadata 05m 55s remaining16:12
Wizzupand now the extractor is always idle16:12
Wizzupand the db 'seems' empty16:12
Wizzupinteresting, my tracker-miner-fs has two db handles open it looks like16:13
Wizzupat least judging from it's fds16:13
Wizzup0 lr-x------ 1 user user 64 Dec  8 16:12 10 -> '/home/user/.cache/tracker/meta.db (deleted)'16:13
Wizzup0 lrwx------ 1 user user 64 Dec  8 16:12 11 -> '/home/user/.cache/tracker/meta.db-wal (deleted)'16:13
Wizzup0 lrwx------ 1 user user 64 Dec  8 16:12 12 -> '/home/user/.cache/tracker/meta.db-shm (deleted)'16:14
Wizzup0 l-wx------ 1 user user 64 Dec  8 16:12 13 -> /home/user/.local/share/tracker/data/tracker-store.journal16:14
Wizzup0 lr-x------ 1 user user 64 Dec  8 16:12 14 -> anon_inode:inotify16:14
Wizzup0 lr-x------ 1 user user 64 Dec  8 16:12 15 -> '/home/user/.cache/tracker/meta.db (deleted)'16:14
Wizzup0 lrwx------ 1 user user 64 Dec  8 16:12 16 -> '/home/user/.cache/tracker/meta.db-wal (deleted)'16:14
Wizzuplooks like the same is true for tracker-extract, so maybe that means nothing16:14
Wizzup(but the ones it looks at aren't deleted of course)16:15
freemangordonit means that it was tracker-extract to delete the db16:17
Wizzupit gets started every 15 seconds16:18
Wizzupso I am not sure if that is true16:18
Wizzupbut your logs should tell you16:18
Wizzupbtw, I asked in the #gnome-tracker channel here just in case there would be a response16:18
Wizzuphttps://www.sqlite.org/forum/forumpost/2f005babea?t=c&unf16:20
Wizzupnot sure if this is relevant, googling atm for 'SQLITE_CORRUPT gnome tracker'16:20
Wizzupwe do have this specific version16:20
Wizzup(of sqlite3)16:21
Wizzuphttps://gitlab.gnome.org/GNOME/tracker/-/merge_requests/35316:21
Wizzupdo we have this?16:21
Wizzupfreemangordon: ^^16:21
freemangordonI doubt16:22
Wizzupwell, we have 3.34.1-316:22
Wizzupand I have text files in my music16:22
freemangordonmhm16:22
freemangordonlemme pull that and retest16:22
Wizzupbtw the dev seems active https://discourse.gnome.org/t/tracker-reports-database-disk-image-is-malformed/1734416:29
Wizzuphe's also on irc but didn't respond yet16:29
Wizzuphe just did16:32
Wizzupsaid 2.x is stagnant and not maintained, so that the problem is probably with updated deps (sqlite3), and that it would be best to switch to 3.x if we can16:33
Wizzup3.6.x specifically16:33
Wizzupfreemangordon: I'm getting a bit more confident this really is our problem16:33
freemangordonmhm16:34
freemangordontesting atm16:34
freemangordonwith the fix that is16:34
freemangordonseems like16:35
freemangordonlemme clone tracker16:35
Wizzupfreemangordon: btw, want to join #gnome-tracker even just to idle? the dev is somewhat chatty and then I won't have to relay the info16:36
Wizzuphe's linking me a list of changes from tracker 2-3, which you're probably aware of already (https://gnome.pages.gitlab.gnome.org/tracker/migrating-2to3.html)16:36
freemangordonWizzup: in the meanwhile, could you add tracker to jenkins?17:05
Wizzupsure, I thought we already had it17:07
WizzupI guess we had miners?17:07
Wizzupfreemangordon: what repo name?17:07
freemangordontracker17:08
freemangordonminers are separate repo17:08
Wizzupadded17:08
freemangordonhttps://github.com/maemo-leste-upstream-forks/tracker17:08
freemangordonok, thanks17:08
freemangordonWizzup: what?!? https://phoenix.maemo.org/job/tracker-source/1/consoleText17:13
freemangordonfatal: Authentication failed for 'https://github.com/maemo-leste-upstream-forks/tracker/'17:13
Wizzupfreemangordon: hangon17:14
freemangordonoh, wait17:14
freemangordonmy bad17:15
Wizzupfreemangordon: the repo is private17:15
Wizzupwant me to fix?17:15
freemangordonfixed17:15
freemangordonwhy private is the default?17:15
Wizzupgithub :)17:15
Wizzupidk17:15
Wizzupthey hate sharing I guess17:15
freemangordonM$ you mean :)17:16
Wizzupyes17:16
freemangordonWizzup: please upgrade tracker to see if the issue is fixed for you17:28
freemangordonhmm with the new tracker 11GB were indexed in less than a minute17:33
freemangordonon d4 that is17:33
Wizzuplet me try17:35
freemangordoni just reset the db17:36
freemangordonand restarted mafw17:36
freemangordonno manual deletion etc17:36
Wizzupdid you restart mafw?17:37
freemangordon(18,36,09) freemangordon: and restarted mafw17:37
Wizzupah17:37
Wizzupha17:37
Wizzupok17:37
freemangordonactually after db reset, I just killed mafw-tracker-source17:37
freemangordonthat's enough to trigger a new index17:37
Wizzupdoesn't look like mine will finish in a minute17:41
freemangordonwell...17:42
Wizzupbut hey, as long as it works :D17:42
freemangordonyou'd better pray for it to finish at all :p17:42
WizzupI'm not a religious man, but I'll sacrifice some plant17:42
freemangordonme neither, but that does not mean we shall lose opportunities... what is... :)17:43
freemangordon*what if17:43
Wizzupactually it is going much faster now it seems17:44
freemangordonmhm17:44
Wizzup08 Dec 2023, 17:43:41:   35%  File System          - Processing… 02m 55s remaining17:44
Wizzupmaybe some optimisations from our CI?17:44
freemangordonI doubt17:44
freemangordonbut... who knows17:44
Wizzuphah, now omp shows the right time indication as well17:45
Wizzupit follows tracker daemon -f17:45
freemangordonyes17:45
freemangordonok, if that's fixed, during the weekend I'll put xv support back in mafw-gst-renderer17:47
freemangordonafter that we can push all the recent work on multimedia to -stable17:47
Wizzupcool17:49
Wizzupagreed17:49
Wizzuplet's monitor pm meanwhile17:49
freemangordonyeah17:50
WizzupI could probably use some help with telepathy on the sip/xmpp front, in debugging some issues17:50
freemangordonsure17:50
freemangordondid it finish?17:50
freemangordon(tracker)17:50
Wizzupstill extracting17:52
Wizzupprobably 5 more mins17:52
freemangordon5 minutes passed :)18:03
Wizzup13:21 eta18:04
freemangordonomg18:04
Wizzupmy files are complicated :)18:04
Wizzupbtw, there is telepathy-tank18:04
Wizzupwe have it packaged I think (I packaged it)18:04
Wizzupbut I didn't get it to work yet with conversations18:04
Wizzuphttps://github.com/TelepathyIM/telepathy-tank18:04
freemangordonwe will need accounts plugin I guess18:05
Wizzupwell there was more to it18:06
Wizzupas in, I got the account set up18:09
Wizzupbut I only got it to connect once iirc18:09
Wizzup4 mins left18:19
Wizzupeta is a bit off:p18:19
freemangordonI wonder why it is so slow on your device18:20
freemangordonhow complicated could a music be?18:20
WizzupI don't know where you get it from, but I ripped a lot of it from CDs using custom sw that adds all kinds of metadata and embeds images in the files18:20
Wizzupsome of it is flac too18:20
Wizzup08 Dec 2023, 18:20:39:  ✓     Extractor            - Idle18:21
Wizzuplet's see18:21
Wizzupbrb, have to make some dinner18:22
Wizzuplooks like tracker is pacified for now18:46
freemangordonyeah18:53
Wizzupbtw, I took a quick look earlier today what would 'break' without python2 and pygtk2 and hildon pkgs in python20:22
Wizzupthese packages will not work anymore: binaryclock-plugin, quicknote, sojourner, syncevolution-frontend, modrana20:22
Wizzupfrom extras20:22
Wizzupwhich depend on one or more of these:20:23
Wizzuppython2-gconf python-conic python-hildon python-hildondesktop python-location python-mafw python-osso20:23
freemangordonWizzup: did you unpack your PPP?20:47
Wizzupfreemangordon: no, but I can tomorrow, or in ~2 hours or so20:48
freemangordonok, lets try to find some time tomorrow to look at h-d issue20:48
freemangordonthat's pointed to me as well20:49
Wizzupok21:02

Generated by irclog2html.py 2.17.0 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!