[RAS] magic sessions problem

[Christian Zimmermann]

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