Hi, all my filesystsems are ext4.
As I don't really use dt for organizing my fotos and I find the hangs to be really annoying I've completely wiped the library and cache. I probably never waited longer than a minute, will try it next time. Regards, Oliver Am Dienstag, den 05.05.2015, 21:50 +0200 schrieb Ochal Christophe: > Hi, > > Looks similar to what I've seen on my system with a large brtfs > filesystem, do you happen to use btrfs? I've noticed hangs when a lot of > io is happening on the sql lite database. > > These mount options seem to have reduced their frequency for me: > /home btrfs > noatime,nodiratime,space_cache,autodefrag,compress=lzo,subvol=@home > > While it still occacionally happens, I've not had the chance to actually > debug this in detail yet. > Let me know if you also use btrfs or not. > > PS: Waiting long enough (more then a minute) sometimes actually gets DT > moving again on my system. > My database is quite big: > Intel-DH77EB:~/.config/darktable$ ls -alh > total 568M > drwxrwxr-x 1 ochal ochal 160 mei 5 19:22 . > drwx------ 1 ochal ochal 764 mei 5 21:26 .. > -rw-rw-r-- 1 ochal ochal 16K mei 4 23:27 darktablerc > -rw-r--r-- 1 ochal ochal 78K apr 21 2014 keyboardrc > -rw-rw-r-- 1 ochal ochal 75K mei 5 19:22 keyboardrc_default > -rw-r--r-- 1 ochal ochal 568M mei 5 21:43 library.db > -rw-rw-rw- 1 ochal ochal 5 mei 5 19:20 library.db.lock > drwxr-xr-x 1 ochal ochal 862 apr 17 15:31 styles > drwxrwxr-x 1 ochal ochal 540 nov 5 2013 watermarks > > > On 05-05-15 21:32, Oliver Bedford wrote: > > Hi, > > > > I think, the hangs I see are not associated with opencl. I encounter > > them with opencl disabled, too. > > > > It seems, that I can provoke them by importing a directory (which was > > already processed by dt in the past) and then quickly scrolling down and > > selecting an image for editing in darkroom mode. At this stage top shows > > dt is already eating some cpu. So perhaps some sort of race condition? > > dt then becomes unresponsive, top outputs something similar to this: > > > > > > top - 21:14:30 up 14 min, 3 users, load average: 0.88, 0.59, 0.39 > > Tasks: 236 total, 2 running, 234 sleeping, 0 stopped, 0 zombie > > Cpu(s): 12.6%us, 0.1%sy, 0.0%ni, 87.3%id, 0.0%wa, 0.0%hi, 0.0%si, > > 0.0%st > > Mem: 16375288k total, 5452888k used, 10922400k free, 89880k buffers > > Swap: 33235964k total, 0k used, 33235964k free, 3696580k cached > > > > PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND > > 14818 ojo 20 0 39.5g 1.0g 40m R 100 6.5 1:23.54 darktable > > 1574 root 20 0 162m 55m 30m S 0 0.3 0:27.53 Xorg > > 2523 ojo 20 0 368m 65m 35m S 0 0.4 0:09.31 compiz > > [rest skipped] > > > > Last output of darktable -d all: > > > > [...] > > > > [camera_control] unregistering listener 0x2a2a220 > > [sql] prepare "select count(id) from images where (flags & 256) != 256 > > and ((film_id in (select id from film_rolls where folder like > > '/home/ojo/Bilder/EigenePhotos/Lissabon2015/ORGNL'))) order by filename, > > version" > > [sql] prepare "select count (distinct imgid) from selected_images" > > [sql] exec "DELETE FROM memory.collected_images" > > [sql] prepare "INSERT INTO memory.collected_images (imgid) select > > distinct id from images where (flags & 256) != 256 and ((film_id in > > (select id from film_rolls where folder like > > '/home/ojo/Bilder/EigenePhotos/Lissabon2015/ORGNL'))) order by filename, > > version limit ?1, ?2" > > [sql] prepare "SELECT imgid FROM memory.collected_images ORDER by rowid > > LIMIT ?1, ?2" > > [add_job] 0 | lua: overlay button toggled | queue: 0 | priority: 0 > > [sql] prepare "SELECT DISTINCT T.id, T.name FROM tagged_images JOIN tags > > T on T.id = tagged_images.tagid WHERE tagged_images.imgid = 7704 ORDER > > BY T.name" > > [sql] prepare "INSERT INTO memory.tagq (id) SELECT id FROM tags T WHERE > > T.name LIKE ?1" > > [sql] exec "INSERT INTO memory.taglist (id, count) SELECT > > DISTINCT(TXT.id2), TXT.count FROM tagxtag TXT WHERE TXT.count > 0 AND > > TXT.id1 IN (SELECT id FROM memory.tagq) ORDER BY TXT.count DESC" > > [sql] exec "INSERT OR REPLACE INTO memory.taglist (id, count) SELECT > > DISTINCT(TXT.id1), TXT.count FROM tagxtag TXT WHERE TXT.count > 0 AND > > TXT.id2 IN (SELECT id FROM memory.tagq) ORDER BY TXT.count DESC" > > [sql] prepare "SELECT T.name, T.id FROM tags T JOIN memory.taglist MT ON > > MT.id = T.id WHERE T.id IN (SELECT DISTINCT(MT.id) FROM memory.taglist > > MT) AND T.name NOT LIKE 'darktable|%%' ORDER BY MT.count DESC" > > [sql] exec "DELETE from memory.taglist" > > [sql] exec "DELETE from memory.tagq" > > [run_job+] 11 140245221,498666 in darkroom mode > > [sql] prepare "select count (distinct imgid) from selected_images" > > [sql] exec "delete from selected_images" > > [sql] prepare "insert or ignore into selected_images values (?1)" > > [sql] prepare "UPDATE images SET width = ?1, height = ?2, maker = ?3, > > model = ?4, lens = ?5, exposure = ?6, aperture = ?7, iso = ?8, > > focal_length = ?9, focus_distance = ?10, film_id = ?11, datetime_taken > > = ?12, flags = ?13, crop = ?14, orientation = ?15, raw_parameters = ?16, > > group_id = ?17, longitude = ?18, latitude = ?19, color_matrix = ?20, > > colorspace = ?21, raw_black = ?22, raw_maximum = ?23 WHERE id = ?24" > > [sql] prepare "UPDATE images SET width = ?1, height = ?2, maker = ?3, > > model = ?4, lens = ?5, exposure = ?6, aperture = ?7, iso = ?8, > > focal_length = ?9, focus_distance = ?10, film_id = ?11, datetime_taken > > = ?12, flags = ?13, crop = ?14, orientation = ?15, raw_parameters = ?16, > > group_id = ?17, longitude = ?18, latitude = ?19, color_matrix = ?20, > > colorspace = ?21, raw_black = ?22, raw_maximum = ?23 WHERE id = ?24" > > > > > > Any help is greatly appreciated. > > > > Regards, > > Oliver > > > ------------------------------------------------------------------------------ > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > _______________________________________________ > Darktable-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/darktable-users ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Darktable-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/darktable-users
