[RAS] magic sessions problem

[Christian Zimmermann]

The problem reappeared with the supposed memory leak. Same account. I 
pushed its refresh date further in the future.

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 Sun, 15 Jun 2008, Christian Zimmermann wrote:

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