[RAS] Stuck: AUTOMATIC SEARCH SUGGESTIONS

[Christian Zimmermann]

Thanks. Note that updating is still not working for various archives for 
which I have to perfom updareq after complaints.

Christian Zimmermann                                     FIGUGEGL!
Department of Economics
University of Connecticut
341 Mansfield Road, Unit 1063
Storrs, CT 06269-1063
http://ideas.repec.org/zimm/   christian.zimmermann at uconn.edu
http://ideas.repec.org/e/pzi1.html

On Tue, 30 Jun 2009, Thomas Krichel wrote:

>
>  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
>