search

YunoHost-Apps / dolibarr_ynh

Dolibarr ERP & CRM is a modern software to manage your organization's activity. This is an integration of Dolibarr in YunoHost
https://www.dolibarr.org/
GNU Affero General Public License v3.0
12 stars 18 forks source link

out of sort memory #38

Closed farvardin closed 3 years ago

farvardin commented 3 years ago

I got a "out of sort memory" in Dolibarr 12, in the invoice module. The same instance worked without problem on Dolibarr 11. Maybe on a smaller database it wouldn't display this.

image

It doesn't prevent to create a new invoice though. It just prevented a display a "customer invoices drafts" block. The other blocs worked fine.

To fix it, I had to modify

/etc/mysql/my.cnf

at the line

sort_buffer_size = 64K

I put

sort_buffer_size = 256K

instead. It's a global file, I don't know if it's possible to adjust this setting only for dolibarr.

mastereur commented 3 years ago

Indeed, this parameter cannot be modified by the application. This is a problem of mysql configuration in the system.

The only solution is the one you made.