[Trunk] many2many with many records doesn't load

Bug #699960 reported by Claude Petit
64
This bug affects 8 people
Affects Status Importance Assigned to Milestone
Odoo GTK Client (MOVED TO GITHUB)
Fix Released
Low
OpenERP sa GTK client R&D
Odoo Web Client
Fix Released
Low
OpenERP R&D Web Team

Bug Description

I have to write a wizard that allow mass mailing to partner contacts based on criteria. The user want to be able to add and remove contacts from the mailing list. I have a many2many field that I fill with the contacts that match these criteria. When the list is huge (about 1000), the form fail to load. BTW, when using the GTK client, it works, but it's always limited to 100 records ! (GTK) i.e the limit combo is not in action when the default limit is reached.

Related branches

Revision history for this message
Claude Petit (claude.petit) wrote :

It's the same problem with the one2many widget

Revision history for this message
Claude Petit (claude.petit) wrote :

After many tests, the problem begins with 267 records and more. It's not due to characters in the data.

Revision history for this message
Cristian Salamea (ovnicraft) wrote :

I was working in something like that in stock.picking with +300 but now with the new wizard works ok (tested with 420)
Can you share any CSV to test it.

Regards,

Revision history for this message
Claude Petit (claude.petit) wrote :

I'd like to share data with you, but it contains private data (names and email addresses).

Revision history for this message
Claude Petit (claude.petit) wrote :

It works with Opera. I use FireFox 3.6.13 on Ubuntu 10.04. It's strange because FireFox receives the HTML code, but the page is blank. It have no errors.

Revision history for this message
Claude Petit (claude.petit) wrote :

openerp.base.js line 107:

        var data = xhr.responseText || data;
+ alert(data);

The variable "data" is empty. Is there a limitation on the size of data received with the XMLHttpRequest object ?

Revision history for this message
OpenERP buildbot (openerp-buildbot) wrote : Re: [Bug 699960] Re: [RC2] many2many with many records doesn't load

On Saturday 15 January 2011, you wrote:
> openerp.base.js line 107:
>
> var data = xhr.responseText || data;
> + alert(data);
>
> The variable "data" is empty. Is there a limitation on the size of data
> received with the XMLHttpRequest object ?

(without looking at the code or reproducing the issue)

Imagine that request being a full HTML document. The limitation, if any, will
be well above some MBytes, which means that it is highly unlikely that it
would affect the data..

However, most HTTP requests are subject to timeouts[1]. If such a timeout
occurs, request result would be empty[2]

[1] short timeouts for inactivity when request answer is expected, longer
timeouts when some data slowly comes. Still, /unless you are using a proxy/
most AJAX implementations raise the timeouts to a big values for those
requests. Example (minimum tested vals): 2-3min for inactivity >10min for slow
data, >30min for AJAX.

[2] if the answer is "cancelled" by the receiving side, you /might/ get an
empty string instead of partial data.

--
Say NO to spam and viruses. Stop using Microsoft Windows!

Revision history for this message
Claude Petit (claude.petit) wrote : Re: [RC2] many2many with many records doesn't load

I found the problem. It's because the value X-Concurrency-Info in the HTTP Response Header is too big and FireFox aborts the session. Do you really need to send this information in the header with the List widget ? The only thing you do with this is to refresh the last updated date for existing concurrency info in the form, but these records are not already here and the information is also provided in the returned HTML code !

addons/openerp/widget/listgrid.py - Line 176 :

        if ids and len(ids) > 0:

            ctx = rpc.session.context.copy()
            ctx.update(context)

            try:
                data = proxy.read(ids, fields.keys() + ['__last_update'], ctx)
            except:
                pass

- ConcurrencyInfo.update(self.model, data)
            self.concurrency_info = ConcurrencyInfo(self.model, ids)

summary: - [RC2] many2many with many records doesn't load
+ [Trunk] many2many with many records doesn't load
Revision history for this message
DBR (OpenERP) (dbr-openerp) wrote :

Hello ,

Following Steps I followed to Reproduce the bug:

1) Administration/Users/Groups:
   Create more than 100 groups.
2) Administration/Users/Users:
   Create new user.
   Add Groups [M2M field].
   Try to add More than 100.
   Select unlimited option from the paging.

But,That page list not able to load.[see the attached screenshot]
This type of same problem confirm in bug # 713934.

Thanks.

Changed in openobject-client-web:
assignee: nobody → OpenERP SA's Web Client R&D (openerp-dev-web)
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
DBR (OpenERP) (dbr-openerp) wrote :
description: updated
Revision history for this message
DBR (OpenERP) (dbr-openerp) wrote :

Hello,

This Bug is confirming in GTK Because:
"when using the GTK client, it works, but it's always limited to 100 records !"
Problem in M2M field's paging limit,
But Not with O2M field.[#1]
See the attached Screenshots.

Thanks.

Changed in openobject-client:
assignee: nobody → OpenERP sa GTK client R&D (openerp-dev-gtk)
importance: Undecided → Low
status: New → Confirmed
Revision history for this message
DBR (OpenERP) (dbr-openerp) wrote :
Revision history for this message
DBR (OpenERP) (dbr-openerp) wrote :
Changed in openobject-client:
status: Confirmed → In Progress
milestone: none → 6.0.2
Revision history for this message
Naresh(OpenERP) (nch-openerp) wrote :

Hello,

Thanks for reporting !

It has been fixed in trunk client with revision info as 1819 <email address hidden>

Thanks

Changed in openobject-client:
status: In Progress → Fix Released
Revision history for this message
Jay Vora (Serpent Consulting Services) (jayvora) wrote :

Hello Sickle,

This has been fixed into stable 6.0.1 by revision 1809 <email address hidden> authored to Naresh(OpenERP).

Thanks guys.

Changed in openobject-client-web:
milestone: none → 6.0.2
Changed in openobject-client-web:
status: Confirmed → In Progress
Changed in openobject-client-web:
status: In Progress → Fix Committed
Revision history for this message
Sananaz (Open ERP) (sma-tiny) wrote :

Hello All,

The fix for web-client has been committed to lp:~openerp-dev/openobject-client-web/6.0-opw-4547-sma
with the following revision.

Revision-info:
4555 <email address hidden>

Now its merged into trunk and stable web-client. Please update your code and notify us.

Thank you for reporting.

Changed in openobject-client-web:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.