[RAS] magic sessions problem

Christian Zimmermann christian.zimmermann at uconn.edu
Sun Jun 15 14:03:55 EDT 2008 

Magic sessions are now working as usual. So it is this particular account 
that was creating problems: zaharey at gmail.com. Here are his name 
variations:

      <names-list>
       <list-item>mr zaharey sr</list-item>
       <list-item>zaharey mr sr</list-item>
       <list-item>m zaharey sr</list-item>
       <list-item>zaharey sr m</list-item>
       <list-item>mr zaharey</list-item>
       <list-item>zaharey mr</list-item>
       <list-item>m zaharey</list-item>
       <list-item>zaharey m</list-item>
       <list-item>economic</list-item>
       <list-item>finance</list-item>
       <list-item>journal</list-item>
       <list-item>myecom my ecommerce com</list-item>
       <list-item>mohd zahari bin mat amin</list-item>
      </names-list>

It is a rather silly list... But anyway, the script seems to be hanging 
constant one the "economic" one:

Wed Apr 30 19:00:39 2008 [3381] exact name: 'mr zaharey sr', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'zaharey mr sr', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'm zaharey sr', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'zaharey sr m', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'mr zaharey', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'zaharey mr', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'm zaharey', found: 0
Wed Apr 30 19:00:39 2008 [3381] exact name: 'zaharey m', found: 0
Wed Apr 30 20:54:03 2008 [3990] for profile pza50 
(repec:per:2005-05-09:mr_zaharey_sr_)
Wed Apr 30 20:54:03 2008 [3990] exact name: 'mr zaharey sr', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'zaharey mr sr', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'm zaharey sr', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'zaharey sr m', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'mr zaharey', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'zaharey mr', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'm zaharey', found: 0
Wed Apr 30 20:54:03 2008 [3990] exact name: 'zaharey m', found: 0
Wed Apr 30 21:54:04 2008 [8686] for profile pza50 
(repec:per:2005-05-09:mr_zaharey_sr_)
Wed Apr 30 21:54:04 2008 [8686] exact name: 'mr zaharey sr', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'zaharey mr sr', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'm zaharey sr', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'zaharey sr m', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'mr zaharey', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'zaharey mr', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'm zaharey', found: 0
Wed Apr 30 21:54:04 2008 [8686] exact name: 'zaharey m', found: 0
Wed Apr 30 22:54:03 2008 [8934] for profile pza50 
(repec:per:2005-05-09:mr_zaharey_sr_)
Wed Apr 30 22:54:03 2008 [8934] exact name: 'mr zaharey sr', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'zaharey mr sr', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'm zaharey sr', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'zaharey sr m', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'mr zaharey', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'zaharey mr', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'm zaharey', found: 0
Wed Apr 30 22:54:03 2008 [8934] exact name: 'zaharey m', found: 0

etc.

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
>> 
>
> _______________________________________________
> RAS-run mailing list
> RAS-run at lists.openlib.org
> http://lists.openlib.org/cgi-bin/mailman/listinfo/ras-run
>

More information about the RAS-run mailing list