[RAS] Stuck: AUTOMATIC SEARCH SUGGESTIONS

[Thomas Krichel]

  Ivan Kurmanov writes

> This is simple. An obsolete record is left in the threads table in
> mysql, since the server shutdown/migration.

  The change of mySQL version also requires a change in the 
  ACIS code to deal with the background searches. The code
  changes were not in place at the time of upgrade. 

> I don't remember the details, but clearing that record should fix
> the problem immediately.

  If there are no new ones added...

  Looking at the table now, the threads are all old.

psid        type                started    checkpoint
pto90       res-autosearch      2009-06-12 06:13:34     NULL
pmi217      res-autosearch      2009-06-11 05:40:02     NULL
pfu93       res-autosearch      2009-05-29 11:45:35     NULL
phu74       res-autosearch      2009-05-21 10:29:18     NULL
pva218      res-autosearch      2009-05-17 17:55:11     NULL

  I have cleared these threads.

  Cheers,

  Thomas Krichel                    http://openlib.org/home/krichel
                                RePEc:per:1965-06-05:thomas_krichel
                                               skype: thomaskrichel