Differences

This shows you the differences between two versions of the page.

--- erreurs_odoo:ir_attachment_fichiers_inexistant_de_filestore [2024/04/18 09:37] – created yasser
+++ erreurs_odoo:ir_attachment_fichiers_inexistant_de_filestore [2024/04/18 10:27] (current) – yasser
@@ Line 1: / Line 1: @@
-Erreur du à l'absence de certains fichiers de filestore dans la base de donnés.
+== Erreur due à l'absence de certains fichiers de filestore dans la base de données. ==
-Pour fixer cette erreur, on suprime les fichiers de 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.