I've noticed that some messages disappear from mail_message. The id is 90k higher than the count of all stored messages.
Is there any parameter that needs to be set that custom messages won't get deleted?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
10
Replies
2329
Views
OK I've figured it out... this happens when you copy template code from tutorials without checking what every parameter does. I had
<field name="auto_delete" eval="True"/>
in my template.
Hi Samo:
Did you by any chance uninstall an app/module ? If you uninstall an app/module, the corresponding messages get deleted.
No I didn't uninstalled any modules. And that wouldn't be 1/8 off the records. ID at ~790k, number of messages ~700k.
Are the ids in the system sequential i.e. without gaps ?
nope there are small gaps between. Is it possible that the mail_thread widget doesn't show all messages?
You can check at the database level. If there are gaps, maybe that explains the difference.
I've looked in the DB. Does it delete the messages that failed to send?
As far as I know, I don't think it deletes messages. It may be using a pooling mechanism and caching a block of message ids. Unused message ids may be getting discarded at some time. This will need further digging into the code to ascertain the exact reason.
Any chance somebody tried to import a lot of messages into your system? If somebody tried to import a big amount of messages and the import failed the ID's will still be incremented.
No, mails started from scratch.