Magic sessions are now working as usual. So it is this particular account that was creating problems: zaharey@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@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@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@lists.openlib.org http://lists.openlib.org/cgi-bin/mailman/listinfo/ras-run