Advanced search doesn't work.

miquelangel · 19 July 2017 07:33

Hello, when I try to do a search:

I get this screen without any result:

But If I click in Basic Search, then I get results:

Any Idea?

pgr · 19 July 2017 10:05

The advanced search depends on a couple of Scheduler Jobs (see in Admin / Schedulers):

Perform Lucene Index
Optimise AOD Index

Did you set up your cron jobs at all? Are these two running successfully, or do they report errors? See the “last run time” etc on that screen.

miquelangel · 19 July 2017 10:11

Hello, yes I configured the cron correctly and both tasks are executed correctly today.

pgr · 19 July 2017 10:23

Do you have any messages in your logs regarding “Index” or “Lucene”?

What permissions do you see in

modules/AOD_Index/Index

run command “ls -al” in that folder and post results here.

miquelangel · 19 July 2017 10:30

Inside that folder i have another onw called also Index.

Inside that:
ls -al /var/www/php/crm/modules/AOD_Index/Index/Index/

drwxrwxr-x 2 www-data www-data 323584 Jun 29 12:46 .
drwxrwxr-x 3 www-data www-data 4096 Jun 20 11:51 …
-rw-rw-rw- 1 www-data www-data 241 Jun 29 12:42 _1y1q_4.del
-rw-rw-rw- 1 www-data www-data 645658 Jun 29 12:16 _1y1q.cfs
-rw-rw-rw- 1 www-data www-data 10663 Jun 29 12:16 _1y1q.sti
-rw-rw-rw- 1 www-data www-data 489683 Jun 29 12:28 _1zb0.cfs
-rw-rw-rw- 1 www-data www-data 9661 Jun 29 12:28 _1zb0.sti
-rw-rw-rw- 1 www-data www-data 491863 Jun 29 12:41 _20kb.cfs
-rw-rw-rw- 1 www-data www-data 9728 Jun 29 12:41 _20kb.sti
-rw-rw-rw- 1 www-data www-data 104646 Jun 29 12:43 _20tc.cfs
-rw-rw-rw- 1 www-data www-data 2126 Jun 29 12:43 _20tc.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212b.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212b.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212d.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212d.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212e.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212e.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212f.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212f.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212g.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212g.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212h.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212h.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212i.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212i.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212j.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212j.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212k.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212k.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212l.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212l.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212m.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212m.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212n.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212n.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212o.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212o.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212p.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212p.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212q.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212q.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212r.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212r.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212s.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212s.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212t.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212t.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212u.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212u.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212v.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212v.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212w.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212w.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212x.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212x.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212y.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212y.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212z.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _212z.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2130.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2130.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2131.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2131.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2132.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2132.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2133.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2133.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2134.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2134.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2135.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2135.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2136.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2136.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2137.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2137.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2138.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2138.sti
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 _2139.cfs
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 optimization.lock.file
-rw-rw-rw- 1 www-data www-data 0 Jul 19 12:00 read.lock.file
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 read-lock-processing.lock.file
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 segments_3xug
-rwxrwxr-x 1 www-data www-data 20 Jun 29 12:46 segments.gen
-rw-rw-rw- 1 www-data www-data 0 Jun 29 12:46 write.lock.file

pgr · 19 July 2017 11:34

It seems like your indexing has stopped since the 29th of June, does this sound correct?

You should have something in your logs when you get that blank search screen…

Maybe try to remove those lock files and see if indexing resumes.

It is possible to force a complete reindex of Lucene, and this often solves index corruption issues. But it can be very time consuming. How big is your data? Try

du -h /var/www/php/crm/modules/AOD_Index/Index/

miquelangel · 19 July 2017 11:38

2.1M /var/www/php/crm/modules/AOD_Index/Index/Index
2.1M /var/www/php/crm/modules/AOD_Index/Index/

Si I can remove this files safely?

-rwxrwxr-x 1 www-data www-data 0 Jun 29 12:46 optimization.lock.file
-rw-rw-rw- 1 www-data www-data 0 Jul 19 13:31 read.lock.file
-rwxrwxr-x 1 www-data www-data 0 Jun 29 12:46 read-lock-processing.lock.file
-rwxrwxr-x 1 www-data www-data 0 Jun 29 12:46 write.lock.file

How can I force a reindex?

now I have about 16k contacts, but the CRM is not in production

pgr · 19 July 2017 11:44

Yes I guess you can delete the lock files if it all looks stalled for weeks…

And below is my recipe to reindex completely.

Please do a full backup of the affected directories and tables before running these procedures!

Try to make steps 1 and 2 in quick succession so that no indexing cron jobs run betweem them (or if you prefer, disable cron jobs temporarily)

From your SuiteCRM root, delete the folder:
modules/AOD_Index/Index/Index

You must delete also that final Index directory, not just the files within it.

Then in your database delete SQL tables aod_index aod_indexevent
In SuiteCRM Schedulers, make sure that “Optimise AOD Index” and “Perform Lucene Index” are running at their appointed times.
If you want to track the reindexing (may take a LONG time) do this command
watch du -h modules/AOD_Index/Index/Index

This shows the directory size. As the indexer progresses, it seems to create and delete many temporary files, so the size will both increase and decrease, that’s normal. Of course eventually the final size will be bigger than the initial.

miquelangel · 19 July 2017 13:53

you nailed it!

I guess I messed up the folder permisions trying to fix another issue.

Thanks!!!