AOD will finish?

đź’¬ General Discussion
1

After 10 days the server continues overloaded indexing with AOD jobs.

I have 139542 non deleted leads. In the “Global Search” settings I just have enabled the leads module but I see the AOD is indexing notes, tasks…

Any way to estimate the time to finish or the percent of the indexed elements?

I think the aod_indexevent register the indexed elments… but I’m not sure.


mysql> select record_module, success, error, count(1) from aod_indexevent group by record_module, success, error;
+-------------------+---------+----------------------------------------------------+----------+
| record_module     | success | error                                              | count(1) |
+-------------------+---------+----------------------------------------------------+----------+
| Calls             |       1 | NULL                                               |    60263 |
| Contacts          |       1 | NULL                                               |       10 |
| DocumentRevisions |       0 | Mime type  application/octet-stream not supported  |        2 |
| DocumentRevisions |       0 | Mime type application/force-download not supported |       14 |
| DocumentRevisions |       0 | Mime type application/octet-stream not supported   |        1 |
| DocumentRevisions |       1 | NULL                                               |      101 |
| Documents         |       1 | NULL                                               |       18 |
| Leads             |       1 | NULL                                               |   108721 |
| Meetings          |       1 | NULL                                               |        4 |
| Notes             |       1 | NULL                                               |   108441 |
| ProspectLists     |       1 | NULL                                               |        1 |
| Tasks             |       1 | NULL                                               |    15114 |
+-------------------+---------+----------------------------------------------------+----------+
12 rows in set (1.90 sec)
2

Yesterday the cron tasks stopped, the server is 100% idle time but now, when I make a global search I get no result and I just see the link to “Use standard SugarCRM search” .

No log errors, but there was no disk space. The sugar/modules/AOD_Index/Index/Index/ has 15Gb. Today I have gave more disk space but nothing happen.

Those are the last files in index directory:

-rw-rw-rw- 1 www-data www-data 2160 Dec 25 16:10 _7lgl.cfs
-rw-rw-rw- 1 www-data www-data 17 Dec 25 16:10 _7lej_e.del
-rw-rw-rw- 1 www-data www-data 1868 Dec 25 16:10 segments_7uv9
-rw-rw-rw- 1 www-data www-data 547 Dec 25 16:10 _7lgm.cfs
-rw-rw-rw- 1 www-data www-data 2315 Dec 25 16:10 _7lgn.cfs
-rw-rw-rw- 1 www-data www-data 1892 Dec 25 16:11 segments_7uva
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:11 read-lock-processing.lock.file
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:11 _7lgk.sti
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:11 _7lgj.sti
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:11 _7lgi.sti
-rw-rw-rw- 1 www-data www-data 16 Dec 25 16:11 segments_7uvb
-rw-rw-rw- 1 www-data www-data 8 Dec 25 16:11 _0.fdx
-rw-rw-rw- 1 www-data www-data 221 Dec 25 16:11 _0.fdt
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:11 optimization.lock.file
-rw-rw-rw- 1 www-data www-data 8 Dec 25 16:11 _1.fdx
-rw-rw-rw- 1 www-data www-data 221 Dec 25 16:11 _1.fdt
-rw-rw-rw- 1 www-data www-data 121993116 Dec 25 16:14 _7lg5.cfs
-rw-rw-rw- 1 www-data www-data 0 Dec 25 16:14 write.lock.file
-rw-rw-rw- 1 www-data www-data 20 Dec 25 16:15 segments.gen
-rw-rw-rw- 1 www-data www-data 4 Dec 25 16:15 segments_7uvc
-rw-rw-rw- 1 www-data www-data 0 Dec 26 16:59 read.lock.file

Any suggestion to restore the index process? I have been indexing for 2 weeks and I don’t want to lose the indexed work.