Clean zombie graph in AgroPortal

[syphax-bouazzouni]

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]

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]

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