On Sun, 15 Jun 2008, Thomas Krichel wrote:
Christian Zimmermann writes
Note that he has more name variations, so it hangs in the search.
It sholud not, but there may be a timeout, esp if the machine is busy. metadata updates are a killer job.
It is independent of other jobs.
He has then magic sessions on a reglar basis ever since.
Note that simply removing this account from the magic session schedule may solve the symptom...
Can you do this? I don't know how.
Just found this: http://acis.openlib.org/software/doc/apu.html#id2245992 aras@nebka:/var/lib/mysql$ mysql acis -u corner -p Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 16028 Server version: 5.0.32-Debian_7etch5-log Debian etch distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from apu_queue where what='pza50'; +-------+------------+---------------------+--------+-------+-------+---------------------+ | what | position | filed | status | class | notes | worked | +-------+------------+---------------------+--------+-------+-------+---------------------+ | pza50 | 1200593767 | 2008-04-22 20:54:05 | | 0 | NULL | 0000-00-00 00:00:00 | +-------+------------+---------------------+--------+-------+-------+---------------------+ 1 row in set (0.23 sec) mysql> select * from apu_queue where what='pzi1'; +------+------------+---------------------+--------+-------+-------+---------------------+ | what | position | filed | status | class | notes | worked | +------+------------+---------------------+--------+-------+-------+---------------------+ | pzi1 | 1206903310 | 2008-04-22 20:54:05 | | 0 | NULL | 0000-00-00 00:00:00 | +------+------------+---------------------+--------+-------+-------+---------------------+ 1 row in set (0.08 sec) mysql> replace into apu_queue (position,what) values('1206903310','pza50'); Query OK, 2 rows affected (0.06 sec) mysql> select * from apu_queue where what='pza50'; +-------+------------+---------------------+--------+-------+-------+---------------------+ | what | position | filed | status | class | notes | worked | +-------+------------+---------------------+--------+-------+-------+---------------------+ | pza50 | 1206903310 | 2008-06-15 11:55:55 | | 0 | NULL | 0000-00-00 00:00:00 | +-------+------------+---------------------+--------+-------+-------+---------------------+ 1 row in set (0.00 sec)
I can then try to check him out separately.
I am getting very tired.
Cheers,
Thomas Krichel http://openlib.org/home/krichel RePEc:per:1965-06-05:thomas_krichel phone: +7 383 330 6813 skype: thomaskrichel