openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #25726
[Bug 1233730] [NEW] [7.0] large number of mail.message prevents displaying a record
Public bug reported:
Hello,
On a test instance running on my customer, the scheduler runs through a
cron about 6x each day.
Each of these runs generates 3 mail.messages on procurements which are
in exception:
=> select id,date, author_id, subject, body from mail_message where
model='procurement.order' and res_id = 97 order by date;
4577 | 2013-07-19 10:40:10 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
4569 | 2013-07-19 10:40:10 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4576 | 2013-07-19 10:40:10 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4715 | 2013-07-19 11:40:42 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4727 | 2013-07-19 11:40:43 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
4726 | 2013-07-19 11:40:43 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4775 | 2013-07-19 12:40:08 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4786 | 2013-07-19 12:40:09 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4787 | 2013-07-19 12:40:09 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
[...]
On some of these records, the number of generated mail.messages over
time can be high:
=> select count(id) from mail_message where model='procurement.order' and res_id = 97;
count
-------
5287
(1 ligne)
It is not possible to display that record in Firefox or Chrome, because the page takes forever to display with the browser becoming totally unresponsive, until the tab is killed.
Several problems here:
* automated generation of messages on a periodic tasks, which runs the risk of generating an uncontrolled amount of messages.
* no pagination of the display of messages. The feature seems to exists (cf. the Messaging -> Inbox screen) but it is not used when displaying a record with attached messages
* no way of mass marking messages as read (typically admin is used to run the scheduler via cron and admin is not connected every day on a customer's instance to mark messages as read. When I connect using that account to do support, I am blocked by the amount of unread messages on the procurement order)
** Affects: openobject-addons
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1233730
Title:
[7.0] large number of mail.message prevents displaying a record
Status in OpenERP Addons (modules):
New
Bug description:
Hello,
On a test instance running on my customer, the scheduler runs through
a cron about 6x each day.
Each of these runs generates 3 mail.messages on procurements which are
in exception:
=> select id,date, author_id, subject, body from mail_message where
model='procurement.order' and res_id = 97 order by date;
4577 | 2013-07-19 10:40:10 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
4569 | 2013-07-19 10:40:10 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4576 | 2013-07-19 10:40:10 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4715 | 2013-07-19 11:40:42 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4727 | 2013-07-19 11:40:43 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
4726 | 2013-07-19 11:40:43 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4775 | 2013-07-19 12:40:08 | 6 | | <div> • <b>Status</b>: Exception → Confirmed</div>
4786 | 2013-07-19 12:40:09 | 6 | | <div> • <b>Status</b>: Confirmed → Exception</div>
4787 | 2013-07-19 12:40:09 | 6 | | <p>Aucun fournisseur défini pour cet article !</p>
[...]
On some of these records, the number of generated mail.messages over
time can be high:
=> select count(id) from mail_message where model='procurement.order' and res_id = 97;
count
-------
5287
(1 ligne)
It is not possible to display that record in Firefox or Chrome, because the page takes forever to display with the browser becoming totally unresponsive, until the tab is killed.
Several problems here:
* automated generation of messages on a periodic tasks, which runs the risk of generating an uncontrolled amount of messages.
* no pagination of the display of messages. The feature seems to exists (cf. the Messaging -> Inbox screen) but it is not used when displaying a record with attached messages
* no way of mass marking messages as read (typically admin is used to run the scheduler via cron and admin is not connected every day on a customer's instance to mark messages as read. When I connect using that account to do support, I am blocked by the amount of unread messages on the procurement order)
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1233730/+subscriptions
Follow ups
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Martin Trigaux (OpenERP), 2013-10-17
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Martin Trigaux (OpenERP), 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Alexandre Fayolle - camptocamp, 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Martin Trigaux (OpenERP), 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Launchpad Bug Tracker, 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Alexandre Fayolle - camptocamp, 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Martin Trigaux (OpenERP), 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Martin Trigaux (OpenERP), 2013-10-04
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Vinay Rana (OpenERP), 2013-10-03
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Alexandre Fayolle - camptocamp, 2013-10-02
-
[Bug 1233730] Re: [7.0] large number of mail.message prevents displaying a record
From: Nhomar - Vauxoo, 2013-10-01
-
[Bug 1233730] [NEW] [7.0] large number of mail.message prevents displaying a record
From: Alexandre Fayolle - camptocamp, 2013-10-01
References