Erreur due à l'absence de certains fichiers de filestore dans la base de données. [WikiElosys]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
== Erreur due à l'absence de certains fichiers de filestore dans la base de données. ==

<cli>

FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/odoo/filestore/ceil_prod/71/71167b7052bf3257d59b8db0491c13a22dd75958'
kissa15 | 2024-04-17 11:18:02,635 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /web/static/lib/bootstrap/css/bootstrap.css HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:02,671 1 INFO ceil_prod werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /web/assets/89-6d97960/web.report_assets_pdf.min.css HTTP/1.1" 404 - 2 0.006 0.077
kissa15 | 2024-04-17 11:18:02,678 1 INFO ceil_prod werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /web/assets/126-c42c333/web.report_assets_common.min.js HTTP/1.1" 200 - 2 0.017 0.059
kissa15 | 2024-04-17 11:18:02,712 1 INFO ceil_prod werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /web/assets/125-da61895/web.report_assets_common.min.css HTTP/1.1" 200 - 2 0.012 0.109
kissa15 | 2024-04-17 11:18:02,714 1 INFO ceil_prod werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /web/assets/123-df68a27/web.assets_common.min.js HTTP/1.1" 200 - 2 0.018 0.087
kissa15 | 2024-04-17 11:18:02,970 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:02] "GET /universite_mosta_diplome/static/src/img/font_diplome.jpg HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,113 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:03] "GET /web/static/fonts/lato/Lato-Reg-webfont.woff HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,191 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:03] "GET /web/static/fonts/lato/Lato-Bla-webfont.woff HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,195 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:03] "GET /web/static/fonts/lato/Lato-Bol-webfont.woff HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,199 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:03] "GET /web/static/fonts/lato/Lato-Hai-webfont.woff HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,201 1 INFO ? werkzeug: 127.0.0.1 - - [17/Apr/2024 11:18:03] "GET /web/static/fonts/lato/Lato-Lig-webfont.woff HTTP/1.1" 200 - - - -
kissa15 | 2024-04-17 11:18:03,861 1 INFO ceil_prod odoo.addons.base.models.ir_attachment: _read_file reading /var/lib/odoo/filestore/ceil_prod/71/71167b7052bf3257d59b8db0491c13a22dd75958
kissa15 | Traceback (most recent call last):
kissa15 |   File "/usr/lib/python3/dist-packages/odoo/api.py", line 879, in get
kissa15 |     return field_cache[record._ids[0]
kissa15 | KeyError: 89
kissa15 |
kissa15 | During handling of the above exception, another exception occurred:
kissa15 |
kissa15 | Traceback (most recent call last):
kissa15 |   File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1057, in __get__
kissa15 |     value = env.cache.get(record, self)
kissa15 |   File "/usr/lib/python3/dist-packages/odoo/api.py", line 882, in get
kissa15 |     raise CacheMiss(record, field)
kissa15 | odoo.exceptions.CacheMiss: 'ir.attachment(89,).datas'

</cli>

== Pour corriger cette erreur, nous devons supprimer les enregistrements de la base de données correspondant à ces fichiers manquants. ==

  * Accéder au conteneur de la base de données 
  * Se connecter à la base de données
  * Supprimer le fichier qui est enregistré dans la table ir_attachment dont le chomp est store_fname

<cli>

$ docker exec -it container_db bash

$ psql -U odoo

$ \c BD_name

$ DELETE FROM ir_attachment WHERE store_fname = 'b3/b3d86b2a52ba1fd6395106a127a40ced70d98c5f';

</cli>

**Note :** Le fichier ''b3/b3d86b2a52ba1fd6395106a127a40ced70d98c5f'' est celui qui est mentionné dans le journal d'erreurs.