There are supposed to be two batches of magic sessions every hour, at :16 and :46. I verified, they are still in cron. The last batch finished at 11:50:40 today, then just one magic session at 14:16:02. Any idea what is going on? 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
Christian Zimmermann writes
There are supposed to be two batches of magic sessions every hour, at :16 and :46. I verified, they are still in cron.
The last batch finished at 11:50:40 today, then just one magic session at 14:16:02.
Any idea what is going on?
Maybe they are not allowed to overlap. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours. On Sat, 25 Dec 2010, Thomas Krichel wrote:
Christian Zimmermann writes
There are supposed to be two batches of magic sessions every hour, at :16 and :46. I verified, they are still in cron.
The last batch finished at 11:50:40 today, then just one magic session at 14:16:02.
Any idea what is going on?
Maybe they are not allowed to overlap.
Cheers,
Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Christian Zimmermann writes
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours.
I think you may want to inspect the apu_queue table. BTW, we did want to update the database tables to get to mysql 5.1 at Xmas. I was lying like dead in the last couple of days, but with the night up here, I am feeling like ready to rock. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
I am not in a position to inspect the tables before Monday at least. I would appreciate if you could investigate. And in case of trouble, I cannot get to the machine room until Tuesday at lest. I have to go tomorrow to pick up someone in Boston, and a major snow storm is coming. Not looking good for travel. On Sat, 25 Dec 2010, Thomas Krichel wrote:
Christian Zimmermann writes
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours.
I think you may want to inspect the apu_queue table.
BTW, we did want to update the database tables to get to mysql 5.1 at Xmas.
I was lying like dead in the last couple of days, but with the night up here, I am feeling like ready to rock.
Cheers,
Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Christian Zimmermann writes
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours.
I have done some studying. Looking at opt/apu-job.log, it appears mySQL server is giving us errors and troubles. I suggest doing the upgrade to mySQL and then working with the /etc/my.conf for some tuning. I will be offline traveling to Nsk for a couple of days. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
I am back safely from my winterly travels. It appears no magic sessions are happening anymore. I am on standby if I need to push a button, but not Monday, as the weather will only improve later in the day. On Sun, 26 Dec 2010, Thomas Krichel wrote:
Christian Zimmermann writes
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours.
I have done some studying. Looking at opt/apu-job.log, it appears mySQL server is giving us errors and troubles. I suggest doing the upgrade to mySQL and then working with the /etc/my.conf for some tuning.
I will be offline traveling to Nsk for a couple of days.
Cheers,
Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Christian Zimmermann writes
I am back safely from my winterly travels.
But I am stuck in Darmstadt. I am on a t-online line.
It appears no magic sessions are happening anymore. I am on standby if I need to push a button, but not Monday, as the weather will only improve later in the day.
I don't think it will come to that. I am just not in a stable situation. I may travel today. I prefer to wait a bit. We then upgrade mysql. I think the problem must be somewhere that a profile is using too many resources and hogs up all others. But I am not sure how to find that profile. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
It looks like everything works now. I notice you reverted to 7 magic sessions twice an hour. You think 9 was too much? On Sun, 26 Dec 2010, Thomas Krichel wrote:
Christian Zimmermann writes
Yes, they are sequential. But how can one figure out if one is holding up the queue? There is a apu process that seems to be using a lot of CPU for the past hours.
I have done some studying. Looking at opt/apu-job.log, it appears mySQL server is giving us errors and troubles. I suggest doing the upgrade to mySQL and then working with the /etc/my.conf for some tuning.
I will be offline traveling to Nsk for a couple of days.
Cheers,
Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
Christian Zimmermann writes
It looks like everything works now. I notice you reverted to 7 magic sessions twice an hour.
No, I did not do this. Somebody else must have. I tweaked /etc/mysql/my.cnf and /etc/mysql/debian-start. I spent several hours carefully preparing for the upgrade, only to notice that mysql 5.1 is not part of Debian stable. Arghh! It was all in vain. I felt like an idiot. Actually I am an idiot. I went down to the hotel bar and got drunk with the Russians. Cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel
participants (2)
-
Christian Zimmermann -
Thomas Krichel