Lenteur d'accès au réglage photos

Gwen · Janvier 24, 2021, 4:55

Bonjour

J’ai un petit soucis avec le module chambre noire des lors que je veux modifier une photo.

lorsque j’accède à la photo, celle-ci s’affiche normalement, ensuite lorsque je veux effectuer un réglage quelconque, je deplie un module (ex filmique) puis je modifie un curseur. A partir de ce moment là il faut 30 secondes avant que je puisse faire le réglage (la jolie petite roue de mac tourne!!).
Uniquement pour le premier réglage, ensuite les autres se font sans lenteur.
Si je change de photo et que je modifie un réglage idem encore 30 s avant d’accéder au réglage.

Par contre si je copie des réglages d’une photos à d’autres, là pas de temps d’attente.

Environnement :
Mac OSX 10.12 , macmini 2011, avec disque SSD et 16 Go Ram

Base de données DT 35000 photos.

Pour avoir pu comparer à d’autre moment j’ai vraiment l’impression que c’est lié à la taille de la base de donnée, plus elle est volumineuse plus l’accès est lent.
J’avais pu tester avec une base de donnée réduite et je n’avais pas cette lenteur (de mémoire).

si quelqu’un a des pistes je suis preneur.

Amities

jpverrue · Janvier 24, 2021, 5:42

En principe, la taille de la BdD n’a pas d’importance. Ma BdD principale contient ~65k photos ; je ne constate aucune différence de temps d’exécution par rapport à une autre BdD ne contenant que ~5k photos.
D’ailleurs 65k photos ce n’est pas grand-chose. De nombreux autres utilisateurs ont des BdD contenant beaucoup plus de photos que cela.

À propos des capacités de la BdD tu peux lire cet article : https://www.sqlite.org/limits.html

Gwen · Janvier 24, 2021, 6:46

Bonjour
Ce n’est pas la base de donnée en tant que telle,
j’ai l’impression que c’ est la requête d’accès à la base de donnée

G.Eco · Janvier 25, 2021, 11:11

Bonjour Gwen

Quelle version de darktable ?

Je t’invite à faire des recherches approfondies sur le forum car cette histoire de délai d’attente très long pour un premier réglage puis un traitement normal pour les réglages suivants me rappelle vaguement quelque chose… Mais de mémoire il me semble que c’était avec la version 3.0.2

Gwen · Janvier 25, 2021, 8:31

G.Eco:

Gwen:

[…]
lorsque j’accède à la photo, celle-ci s’affiche normalement, ensuite lorsque je veux effectuer un réglage quelconque, je deplie un module (ex filmique) puis je modifie un curseur. A partir de ce moment là il faut 30 secondes avant que je puisse faire le réglage (la jolie petite roue de mac tourne!!).
Uniquement pour le premier réglage, ensuite les autres se font sans lenteur.
Si je change de photo et que je modifie un réglage idem encore 30 s avant d’accéder au réglage.

Bonjour Gwen

Quelle version de darktable ?

Je t’invite à faire des recherches approfondies sur le forum car cette histoire de délai d’attente très long pour un premier réglage puis un traitement normal pour les réglages suivants me rappelle vaguement quelque chose… Mais de mémoire il me semble que c’était avec la version 3.0.2

Bonjour
Si je poste ce sujet c’est que c’est aussi le cas avec la version 3.4
mais je pense que c’est plutôt lié à l OS (mac)
As tu une piste pour retrouver ce post sur le forum ?
quelques mots clés ?
merci d’avance

Gwen · Janvier 26, 2021, 8:13

Bonjour
J’ai retrouvé le post de pierrem
Forum darktable FR › Utilisation de darktable › Installation v
Problème d’installation de la version 2.0.5
Comme par hasard c’est aussi un mac et il faut plusieurs secondes pour accéder aux réglage
et pas de solutions proposées.

A voir

G.Eco · Janvier 28, 2021, 1:38

Bonjour
Ce n’était pas à ce post que je pensais, l’autre était plus « général » mais du coup je ne sais pas trop quel mot-clé utiliser à part « lenteur » mais tu te doutes que ça renvoie des tonnes de discussions

Au hasard, jette un oeil à ta config cpu/gpu/mémoire, en particulier la valeur de tuilage : FrançoisH avait donné une formule intéressante dans ce post

Gwen · Janvier 28, 2021, 8:14

Bonjour
Merci pour ta réponse
j’avais déjà regarder ma config CPU tuilage et je l’ai remis par défaut et juste augmenter la memoire
en mettant un tuilage trop fort j’avais des soucis.
Là ça fait déjà pas mal de temps que ce problème existe malgré le changement de version 3.02 puis 3.2 puis 3.4 et le soucis est toujours présent.
Et c’est precisement au moment du premier reglage sur la photo.
Exemple tu ouvre une photo dans la chambre noire, pas de soucis elle s’affiche
tu deplie par exemple le module filmique no problem
tu modifie un curseur => attente de 30s voir 40
une fois fait tu peux modifier tout ce que tu veux cette lenteur ne reapparait pas

tu change de photo et premier reglage re 30s
j’avais eu aussi ce phenomène lorsque je mettait un mot clé sur une photo via la table lumineuse.

je peux eventuellement lancer DT avec une ligne de commande (le terminal existe sous mac)
Sur quoi faut il se focaliser pour trouver l’anomalie ?

merci

G.Eco · Janvier 29, 2021, 12:25

Désolé mais je suis bien incapable de te donner un paramètre précis à surveiller.

Tu peux lancer darktable en ligne de commande en activant le débuggage avec l’option « -d all » et rediriger la sortie vers un fichier de log.
Sous Linux c’est par exemple ceci, ça ne doit pas être très différent sur Mac :

/opt/darktable/bin/darktable -d all > /home/toto/Applications/darktable/log/darktable.log 2>&1

Tu pourras ensuite aller voir dans le fichier de log et essayer de trouver ce qui bloque (chaque ligne débute par une valeur d’horodatage, très pratique pour voir ce qui prend du temps)

Gwen · Janvier 29, 2021, 7:38

Merci je vais essayer ça et je te tiens au courant

Gwen · Janvier 30, 2021, 9:14

voici un extrait du log
avec option -d all
on dirai que darktable cherche ma camera sur le port usb
62,555939 [camera_control] loaded 6 port drivers.
à
100,104215 [camera_control] loaded 6 port drivers.
40 seconde d’attente
est ce bien ça ?

[code]–extrait—
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare « SELECT folder || ‹ / › || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1 »
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare « SELECT COUNT() FROM memory.darktable_tags"
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare « SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name »
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT() FROM memory.darktable_tags »
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare « SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name »
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare « SELECT COUNT() FROM memory.darktable_tags"
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT() FROM main.tagged_images GROUP BY tagid »
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare « SELECT count() FROM main.selected_images"
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare « SELECT folder || ‹ / › || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1 »
61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare « SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value »
61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT() FROM memory.darktable_tags »
61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare « SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name »
61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare « SELECT COUNT() FROM memory.darktable_tags"
61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare « SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name »
61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT() FROM memory.darktable_tags »
61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare « INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT() FROM main.tagged_images GROUP BY tagid"
61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count() FROM main.selected_images »
61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name "
62,555939 [camera_control] loaded 6 port drivers.
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec « DELETE FROM memory.taglist »
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type « float », field: g2
validation check failed in _iop_validate_params for type « dt_iop_temperature_params_t »
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe process
62,588719 [camera_control] 0 cameras connected
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec « DELETE FROM memory.taglist »
66,722437 [camera_control] loaded 6 port drivers.
66,754403 [camera_control] 0 cameras connected
70,888176 [camera_control] loaded 6 port drivers.
70,920022 [camera_control] 0 cameras connected
75,065995 [camera_control] loaded 6 port drivers.
75,098091 [camera_control] 0 cameras connected
79,232863 [camera_control] loaded 6 port drivers.
79,263328 [camera_control] 0 cameras connected
83,414218 [camera_control] loaded 6 port drivers.
83,444291 [camera_control] 0 cameras connected
87,606963 [camera_control] loaded 6 port drivers.
87,640153 [camera_control] 0 cameras connected
91,777077 [camera_control] loaded 6 port drivers.
91,807026 [camera_control] 0 cameras connected
95,925173 [camera_control] loaded 6 port drivers.
95,955419 [camera_control] 0 cameras connected
100,104215 [camera_control] loaded 6 port drivers.
100,134584 [camera_control] 0 cameras connected
100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329
100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365
100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414
100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459
100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image.
[pixelpipe] pipeline state changed for pipe 4
100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2
[pixelpipe] synch all modules with defaults_params for pipe 4
100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
validation check failed in _iop_validate_params for type « float », field: g2
validation check failed in _iop_validate_params for type « dt_iop_temperature_params_t »
100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,350663 [params] commit for flip in pipe 4 with hash 6381475781
100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901
100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901
100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901
100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,374738 [pixelpipe] synch all modules with history for pipe 4
100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668
100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893
100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851
100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908
100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821
100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376
100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567
100,401922 [params] commit for flip in pipe 4 with hash 6381475781
100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012
100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284
100,404121 [pixelpipe_process] [preview] using device 0
[memory] before pixelpipe process
en débranchant la camera j’ai encore le souci

657,911811 [camera_control] loaded 5 port drivers.
657,929364 [camera_control] 0 cameras connected
660,204092 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec « DELETE FROM memory.taglist »
662,075993 [camera_control] loaded 5 port drivers.
662,094808 [camera_control] 0 cameras connected
666,216067 [camera_control] loaded 5 port drivers.
666,235945 [camera_control] 0 cameras connected
670,364151 [camera_control] loaded 5 port drivers.
670,383674 [camera_control] 0 cameras connected
674,537299 [camera_control] loaded 5 port drivers.
674,557128 [camera_control] 0 cameras connected
678,714180 [camera_control] loaded 5 port drivers.
678,733938 [camera_control] 0 cameras connected
682,897903 [camera_control] loaded 5 port drivers.
682,917794 [camera_control] 0 cameras connected
687,048108 [camera_control] loaded 5 port drivers.
687,069078 [camera_control] 0 cameras connected[/code]

FrancoisH · Janvier 30, 2021, 9:52

[color=#005dc2]Pour la visibilité sur les smartphones, merci d’éditer ton post et de tout mettre le code dans la zone « code » qui va s’ouvrir en cliquant sur le parchemin « code » presque tout à gauche du format de texte.[/color]

Gwen · Janvier 30, 2021, 10:51

OK
le voici avec le format code

à regarder à partir de 61, 09 secondes

61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1" 61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid" 61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images" 61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name " 61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1" 61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid" 61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images" 61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name " 62,555939 [camera_control] loaded 6 port drivers. 62,588719 [camera_control] 0 cameras connected 65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist" 66,722437 [camera_control] loaded 6 port drivers. 66,754403 [camera_control] 0 cameras connected 70,888176 [camera_control] loaded 6 port drivers. 70,920022 [camera_control] 0 cameras connected 75,065995 [camera_control] loaded 6 port drivers. 75,098091 [camera_control] 0 cameras connected 79,232863 [camera_control] loaded 6 port drivers. 79,263328 [camera_control] 0 cameras connected 83,414218 [camera_control] loaded 6 port drivers. 83,444291 [camera_control] 0 cameras connected 87,606963 [camera_control] loaded 6 port drivers. 87,640153 [camera_control] 0 cameras connected 91,777077 [camera_control] loaded 6 port drivers. 91,807026 [camera_control] 0 cameras connected 95,925173 [camera_control] loaded 6 port drivers. 95,955419 [camera_control] 0 cameras connected 100,104215 [camera_control] loaded 6 port drivers. 100,134584 [camera_control] 0 cameras connected 100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329 100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365 100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414 100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459 100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image. [pixelpipe] pipeline state changed for pipe 4 100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2 [pixelpipe] synch all modules with defaults_params for pipe 4 100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668 validation check failed in _iop_validate_params for type "float", field: g2 validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t" 100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376 100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567 100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893 100,350663 [params] commit for flip in pipe 4 with hash 6381475781 100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851 100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908 100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901 100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901 100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901 100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821 100,374738 [pixelpipe] synch all modules with history for pipe 4 100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668 100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893 100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851 100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908 100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821 100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376 100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567 100,401922 [params] commit for flip in pipe 4 with hash 6381475781 100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012 100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284 100,404121 [pixelpipe_process] [preview] using device 0 [memory] before pixelpipe process

FrancoisH · Janvier 30, 2021, 10:54

Gwen:

OK
le voici avec le format code

à regarder à partir de 61, 09 secondes

61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1" 61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid" 61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images" 61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name " 61,084380 [sql] /Users/parafin/src/darktable/src/common/image.c:313, function dt_image_full_path(): prepare "SELECT folder || '/' || filename FROM main.images i, main.film_rolls f WHERE i.film_id = f.id and i.id = ?1" 61,085940 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086092 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086224 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086330 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086432 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086504 [sql] /Users/parafin/src/darktable/src/common/metadata.c:454, function dt_metadata_get(): prepare "SELECT value FROM main.meta_data WHERE id = ?1 AND key = ?2 ORDER BY value" 61,086588 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086613 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,086799 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,086823 [sql] /Users/parafin/src/darktable/src/common/tags.c:656, function dt_tag_get_attached(): prepare "SELECT DISTINCT I.tagid, T.name, T.flags, T.synonyms, COUNT(DISTINCT I.imgid) AS inb FROM main.tagged_images AS I JOIN data.tags AS T ON T.id = I.tagid WHERE I.imgid IN (53115) AND T.id NOT IN memory.darktable_tags GROUP BY I.tagid ORDER by T.name" 61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid" 61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images" 61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name " 62,555939 [camera_control] loaded 6 port drivers. 62,588719 [camera_control] 0 cameras connected 65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist" 66,722437 [camera_control] loaded 6 port drivers. 66,754403 [camera_control] 0 cameras connected 70,888176 [camera_control] loaded 6 port drivers. 70,920022 [camera_control] 0 cameras connected 75,065995 [camera_control] loaded 6 port drivers. 75,098091 [camera_control] 0 cameras connected 79,232863 [camera_control] loaded 6 port drivers. 79,263328 [camera_control] 0 cameras connected 83,414218 [camera_control] loaded 6 port drivers. 83,444291 [camera_control] 0 cameras connected 87,606963 [camera_control] loaded 6 port drivers. 87,640153 [camera_control] 0 cameras connected 91,777077 [camera_control] loaded 6 port drivers. 91,807026 [camera_control] 0 cameras connected 95,925173 [camera_control] loaded 6 port drivers. 95,955419 [camera_control] 0 cameras connected 100,104215 [camera_control] loaded 6 port drivers. 100,134584 [camera_control] 0 cameras connected 100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329 100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365 100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414 100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459 100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image. [pixelpipe] pipeline state changed for pipe 4 100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2 [pixelpipe] synch all modules with defaults_params for pipe 4 100,350595 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668 validation check failed in _iop_validate_params for type "float", field: g2 validation check failed in _iop_validate_params for type "dt_iop_temperature_params_t" 100,350625 [params] commit for temperature in pipe 4 with hash 14616125947125888376 100,350636 [params] commit for highlights in pipe 4 with hash 6428222210663212567 100,350649 [params] commit for demosaic in pipe 4 with hash 6359879594925717893 100,350663 [params] commit for flip in pipe 4 with hash 6381475781 100,350772 [params] commit for colorin in pipe 4 with hash 1455802194412340851 100,374629 [params] commit for colorout in pipe 4 with hash 10257528088492143908 100,374698 [params] commit for finalscale in pipe 4 with hash 6381440901 100,374715 [params] commit for overexposed in pipe 4 with hash 6381440901 100,374724 [params] commit for rawoverexposed in pipe 4 with hash 6381440901 100,374733 [params] commit for gamma in pipe 4 with hash 7567884774754821 100,374738 [pixelpipe] synch all modules with history for pipe 4 100,374754 [params] commit for rawprepare in pipe 4 with hash 15340363110112797668 100,374771 [params] commit for demosaic in pipe 4 with hash 6359879594925717893 100,374860 [params] commit for colorin in pipe 4 with hash 1455802194412340851 100,401841 [params] commit for colorout in pipe 4 with hash 10257528088492143908 100,401889 [params] commit for gamma in pipe 4 with hash 7567884774754821 100,401901 [params] commit for temperature in pipe 4 with hash 14616125947125888376 100,401912 [params] commit for highlights in pipe 4 with hash 6428222210663212567 100,401922 [params] commit for flip in pipe 4 with hash 6381475781 100,403944 [params] commit for basecurve in pipe 4 with hash 484382437236258012 100,404074 [params] commit for filmicrgb in pipe 4 with hash 1426964850665486284 100,404121 [pixelpipe_process] [preview] using device 0 [memory] before pixelpipe process

[color=#00369b]Merci [/color]

nicoauffray · Janvier 30, 2021, 5:19

Ca aurait été encore mieux d’éditer le précédent post pour réduire la longueur du fil et faciliter la visibilité.

G.Eco · Janvier 31, 2021, 12:38

Pour en revenir au fond du problème, je viens de tester simplement en chargeant une image dans la chambre noire, sans rien faire d’autre, et il apparaît à intervalles plus ou moins réguliers (à peu près toutes les 4s, comme pour toi) des lignes semblables aux tiennes :

141,420491 [camera_control] loaded 36 port drivers.
141,428945 [camera_control] 0 cameras connected

donc je pense que c’est un fonctionnement normal de dt (il faudrait qu’un développeur puisse nous éclairer sur ce point) et je ne pense pas que ce soit la cause de ton problème.

Il faudrait plutôt isoler dans ton log ce qui ne concerne pas cette histoire de [camera_control] et voir ce qui bloque pendant une trentaine de secondes, ce qui donne ceci :

61,087005 [sql] /Users/parafin/src/darktable/src/common/tags.c:603, function dt_set_darktable_tags(): prepare "SELECT COUNT(*) FROM memory.darktable_tags" 61,087028 [sql] /Users/parafin/src/darktable/src/common/tags.c:1264, function dt_tag_get_with_usage(): prepare "INSERT INTO memory.taglist (id, count) SELECT tagid, COUNT(*) FROM main.tagged_images GROUP BY tagid" 61,094910 [sql] /Users/parafin/src/darktable/src/common/tags.c:1229, function dt_selected_images_count(): prepare "SELECT count(*) FROM main.selected_images" 61,094976 [sql] /Users/parafin/src/darktable/src/common/tags.c:1281, function dt_tag_get_with_usage(): prepare "SELECT T.name, T.id, MT.count, CT.imgnb, T.flags, T.synonyms FROM data.tags T LEFT JOIN memory.taglist MT ON MT.id = T.id LEFT JOIN (SELECT tagid, COUNT(DISTINCT imgid) AS imgnb FROM main.tagged_images WHERE imgid IN (SELECT imgid FROM main.selected_images) GROUP BY tagid) AS CT ON CT.tagid = T.id WHERE T.id NOT IN memory.darktable_tags ORDER BY T.name " 65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec "DELETE FROM memory.taglist" 100,350298 [add_job_res] 0 | 100,350325 develop process image | queue: 0 | priority: 0100,350329 100,350358 [add_job_res] 1 | 100,350362 develop process preview | queue: 0 | priority: 0100,350365 100,350390 [run_job+] 00 321389543,242947 100,350406 develop process image | queue: 0 | priority: 0100,350414 100,350419 [run_job+] 01 321389543,242978 100,350455 develop process preview | queue: 0 | priority: 0100,350459 100,350468 100,350469 [dev] took 0,000 secs (0,000 CPU) to load the image. [pixelpipe] pipeline state changed for pipe 4 100,350504 100,350508 [pixelpipe] pipeline state changed for pipe 2 [pixelpipe] synch all modules with defaults_params for pipe 4
Il se passe bien quelque chose de bloquant entre 65 et 100s mais je ne sais pas exactement quoi.

Est-ce cette requête SQL qui pose problème et pour quelle raison ?
65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec « DELETE FROM memory.taglist »

Gwen · Janvier 31, 2021, 3:42

Bonjour j’ai effectivement constaté la meme chose coté usb driver - « 62,555939 [camera_control] loaded 6 port drivers »

Et ce que tu signale en remontant sur la ligne précédente c’est ce que je soupçonne depuis le début une requête SQL (accès à la base de donnée)

« Est-ce cette requête SQL qui pose problème et pour quelle raison ? »

65,444703 [sql] /Users/parafin/src/darktable/src/common/tags.c:1304, function dt_tag_get_with_usage(): exec « DELETE FROM memory.taglist »

Est ce ma base donnée qui a des soucis ou est ce propre à ma configuration? Comment peut on identifier le problème ?

A+