Clean zombie graph in AgroPortal

syphax-bouazzouni commented 2 weeks ago

Using the below SPARAL query, we list all the current existent graphs, we should have only the last one.

SELECT DISTINCT ?graph
WHERE {
  GRAPH ?graph {
    ?s ?p ?v.
  }

}

we have this table

[ ] VT, 45 | 21 | 12 | 48 | 57 | 18 | 42 | 24 | 69 | 54 | 63 | 51 | 60 | 19 | 55 | 16 | 46 | 22 | 13 | 49 | 58 | 43 | 25 | 64 | 67 | 52 | 61 | 14 | 17 | 20 | 47 | 56 | 23 | 68 | 59 | 53 | 62 | 65 | 44 | 26 | 50 | 41 | 15
[ ] OM, 18 | 1 | 3 | 5 | 2 | 30 | 31 | 28 | 29 | 27 | 25 | 26 | 22 | 23 | 24 | 4 | 19 | 20 | 21
[ ] SO, 71 | 86 | 83 | 69 | 75 | 78 | 80 | 87 | 100 | 72 | 84 | 99 | 76 | 79 | 81 | 88 | 103 | 73 | 101 | 68 | 70 | 85 | 82 | 104 | 77 | 74 | 102
[ ] CO_327, 10 | 16 | 5 | 7 | 15 | 42 | 2 | 41 | 60
[ ] CO_338, 8 | 63 | 10 | 19 | 45 | 4 | 18 | 44
[ ] CO_350, 12 | 13 | 39 | 57 | 38 | 6
[ ] E-PHY, 3 | 7 | 4 | 6 | 2
[ ] CO_337, 10 | 19 | 45 | 4 | 18 | 44 | 63 | 8
[ ] PPD-CR, 2 | 1
[ ] CO_358, 53 | 9 | 2 | 8 | 10 | 35
[ ] CO_347, 26 | 5 | 25 | 14 | 8 | 3
[ ] CO_365, 7 | 33 | 8 | 51
[ ] CO_345, 12 | 38 | 2 | 13 | 4 | 57 | 39
[ ] RO, 21 | 23 | 20 | 19 | 37 | 39 | 18 | 38 | 17 | 22 | 24
[ ] SPTO, 3 | 4
[ ] CO_320, 51 | 44 | 63 | 19 | 9 | 4 | 18 | 7 | 45
[ ] BIOREFINERY, 354 | 383 | 143 | 8 | 384
[ ] CO_340, 7 | 16 | 42 | 41 | 5 | 2 | 60 | 15
[ ] CO_331, 4 | 43 | 61 | 7 | 17 | 42 | 16 | 9
[ ] THESAGRO, 5 | 1 | 3 | 4 | 2
[ ] VOCGEO, 5 | 4 | 3 | 2
[ ] PPD-POF, 1 | 2
[ ] WHEATPHENOTYPE, 11 | 13 | 10 | 12
[ ] PPD-GEN, 1 | 2
[ ] TRIPHASE, 3 | 2 | 1
[ ] PO, 18 | 19 | 17
[ ] PR, 5 | 7 | 4 | 5 | 6
[ ] PATO, 25 | 24 | 42 | 41 | 23 | 22 | 40 | 21 | 20 | 18 | 19 | 28 | 27 | 26
[ ] CO_324, 16 | 5 | 41 | 7 | 42 | 2 | 15 | 60
[ ] CO_348, 39 | 40 | 14 | 58 | 13
[ ] TRANSFORMON, 7 | 3 | 4 | 6
[ ] PPDO, 8 | 7 | 9 | 10 | 6
[ ] LEXEAU, 42 | 40 | 18 | 22 | 27 | 34
[ ] CO_346, 15 | 59 | 8 | 14 | 3 | 41 | 5 | 40
[ ] EFO, 43 | 75
[ ] THVIANDE, 1 | 3 | 2 | 4
[ ] CO_325, 16 | 43 | 7 | 42 | 2 | 61 | 17 | 5
[ ] TRANSMAT, 5 | 346 | 150 | 385
[ ] CO_360, 50 | 33 | 8 | 7
[ ] CO_321, 9 | 44 | 63 | 19 | 18 | 4 | 7 | 45
[ ] CO_339, 63 | 7 | 19 | 45 | 9 | 43 | 12 | 4 | 18
[ ] CO_366, 9 | 23 | 10 | 11
[ ] PPD-STF, 2 | 1 | 3
[ ] PPD-SOL, 1 | 2
[ ] CO_715, 2 | 3
[ ] SPO-FTM, 1 | 2
[ ] CO_330, 38 | 57 | 13 | 39 | 2 | 12 | 4
[ ] OFSMR, 3 | 4 | 1 | 2
[ ] PBO, 2 | 3 | 4 | 1
[ ] ONTOAGROHIDRO, 2 | 1
[ ] CO_322, 43 | 62 | 18 | 10 | 17 | 44
[ ] LPT, 13 | 3
[ ] PPD-OLT, 2 | 3 | 1
[ ] CO_341, 9 | 62 | 44 | 43 | 7 | 4 | 18 | 17
[ ] TAXREF-LD, 5 | 5
[ ] PPD-LVFH, 1 | 2
[ ] CO_357, 58 | 5 | 3
[ ] NALT, 6 | 9
[ ] MILKOLIGO, 1 | 5 | 6 | 7
[ ] PPD-RSV, 2 | 1
[ ] SPO-FND, 1 | 2
[ ] CO_343, 38 | 11 | 2 | 37 | 12 | 56
[ ] C3PO, 2 | 1
[ ] PPD-GV, 1 | 2
[ ] STY, 3 | 4
[ ] FOODEX2, 1 | 2
[ ] CVO, 1 | 2
[ ] SAREF4ENVI, 1 | 2
[ ] SFWO, 7 | 6
[ ] SIO, 35 | 22 | 23 | 24
[ ] CGO, 7 | 4
[ ] AGROVOC, 15 | 51
[ ] PECO, 6 | 7
[ ] CO_356, 10 | 9 | 42 | 43 | 8
[ ] CROPUSAGE, 1 | 8 | 22
[ ] DEMETER-AIM, 1 | 8
[ ] BCO, 2 | 1
[ ] NCBITAXON, 7 | 5 | 25
[ ] CO_335, 57 | 12 | 13 | 6 | 38 | 39
[ ] RECORDBASIS, 1 | 2
[ ] SPO-FDM, 1 | 2
[ ] THESAE, 7 | 6
[ ] OFPE, 2 | 3
[ ] OBA, 4 | 3 | 1 | 2
[ ] BT, 2 | 4 | 3
[ ] SOY, 2 | 7

syphax-bouazzouni commented 2 weeks ago

For example VT has all this data graphs , 45 | 21 | 12 | 48 | 57 | 18 | 42 | 24 | 69 | 54 | 63 | 51 | 60 | 19 | 55 | 16 | 46 | 22 | 13 | 49 | 58 | 43 | 25 | 64 | 67 | 52 | 61 | 14 | 17 | 20 | 47 | 56 | 23 | 68 | 59 | 53 | 62 | 65 | 44 | 26 | 50 | 41 | 15, where should have only 69 which is the latest submission. And they are not empty graphs

syphax-bouazzouni commented 2 weeks ago

Normally we have this script that should prevent that https://github.com/ontoportal-lirmm/ncbo_cron/blob/master/bin/ncbo_cron#L321, https://github.com/ncbo/ncbo_cron/issues/21

agroportal / project-management

Clean zombie graph in AgroPortal #630