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