Hi,
I cannot display task list - I get following error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2 bytes) in .../html/inc/db_conn.inc on line 125

It is a bit surprising that 128MB is not enough there. I checked original code and it loads only 20 results from DB at once. If you did not make any changes in this area, please log bug at https://github.com/BOINC/boinc/issues that something else consumes lots of memory.

---

I guess the system need an automatic process to purge the older WUs from this page ...

All WUs I computed since I started the project (November 30th) are still in this list ... I can't imagine how many entries the page has to handle for Daniel with such a high RAC ... :o

I guess the system need an automatic process to purge the older WUs from this page ...

All WUs I computed since I started the project (November 30th) are still in this list ... I can't imagine how many entries the page has to handle for Daniel with such a high RAC ... :o

It may be surprising, but it is enough to load and process 20 entries at once. Plus one or few ones extra to display various total numbers there. As I checked in BOINC sever code, it should be already working this way. Something strange is going there.

And yes, periodic removal of old WUs would help to keep server load low. I read somewhere that BOINC server comes with script which can do this, so there is no need to reinvent the wheel.

Edit: BTW, there are people who have higher RAC than me :) http://rake.boincfast.ru/rakesearch/top_users.php

---

This memory allocation error has been happening on quite a few projects for quite a few years.
The advice given is generally just to double the limit for the memory in the config file each time it occurs.

It is to do with the number of results the user has, the code may say only to load 20 but 'something' in the process is loading everything into memory.

Purging older results can help stop it from happening as well as speeding up the time it takes to load the page.

This memory allocation error has been happening on quite a few projects for quite a few years.
The advice given is generally just to double the limit for the memory in the config file each time it occurs.

It is to do with the number of results the user has, the code may say only to load 20 but 'something' in the process is loading everything into memory.

Purging older results can help stop it from happening as well as speeding up the time it takes to load the page.

Thanks for info. I have checked list of open issues at GitHub BOINC repository, and found that they do not have open issue for this, so I logged them new one: https://github.com/BOINC/boinc/issues/2277.

---

Thank you, Daniel!

Причина: https://github.com/BOINC/boinc/issues/2277#issuecomment-359722415

Если в БД старые задания и результаты никак не используются - т.е. у вас нет ссылок на них с каких-нибудь своих таблиц, то можно запустить db_purge. У меня она запущена с параметрами:

<daemon>
    <cmd>db_purge -d 3 --gzip --max_wu_per_file 10000 --min_age_days 7 --daily_dir</cmd>
</daemon>

Ещё можете создать дополнительные индексы:

ALTER TABLE `boinc_odlk`.`result`
ADD INDEX `tmp$res_userid_senttime` (`userid`, `sent_time`),
ADD INDEX `tmp$res_hostid_senttime` (`hostid`, `sent_time`),
ADD INDEX `tmp$res_ai_ss_o_rt` (`appid`, `server_state`, `outcome`, `received_time`),
ADD INDEX `tmp$res_ai_vs_rt` (`appid`, `validate_state`, `received_time`),
ADD INDEX `tmp$res_hi_st_o_vs` (`hostid`, `server_state`, `outcome`, `validate_state`),
ADD INDEX `tmp$res_es_wuid` (`exit_status`, `workunitid`)

Это может ускорить отображение некоторых страниц.

Hello folks!

Information about results and workunits may be useful, but it is not requred to store it in project database. We plan to migrate it to other database.

Thank you for participation!

This bug is fixed now in BOINC, you can selectively apply fix for it or upgrade everything to latest version.

---

This bug is fixed now in BOINC, you can selectively apply fix for it or upgrade everything to latest version.

Thanks Daniel and Progger for working out the fix and getting the code updated :)

It's still not fixed. Now getting the same error when trying to open my task list

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 2 bytes) in /home/boincadm/projects/rakesearch/html/inc/db_conn.inc on line 125