Eventum causing MySQL to eat 100% CPU

Wow, this is nasty!

Haven't come accross this, but we are running eventum on a
windows box 
too. I have a few questions:
- Do you have email download active?
- Do you have a lot of attachements in the database?
- How many issues are in your system? We are running ID's
above 10000, 
because we migrated from another system, I would like to
know if we have 
a risk of running into problems here

So sorry, no answers, just more questions. But I am willing
to think 
with you though!

Kind regards,

Milo van der Linden

Kipp Grose schreef:
> Hi All:
>  
>    Our Eventum installation has been running smoothly
since February.  Last
> week, we had an issue where MySQL went nuts and
throttled the server it was
> running on at 100%.  We rebooted the box, couldn't
find anything useful in
> the MySQL logs, shrugged and carried on.  Then it
happened to us again,
> today, except that after the reboot, the MySQL service
wouldn't start up
> (yes, it's on windows, lame, I'm well aware),
throwing up an "Error 1067:
> Process Terminated Unexpectedly."  Googling Error
1067 brings up a whole
> Pandora's box of crap - best advice I could turn up
was "remove and
> reinstall".  We're moving MySQL to a new server
/ new installation to see if
> this makes a diff.  Quite irritating after you get
addicted to Eventum and
> it's now running your department.
>  
>    Anyhow, my question for the list is:  Is anyone
aware of any existing
> Eventum 1.7.1 issues that could cause MySQL to throttle
like this?  I'm
> worried that even when I get it fixed up, its just
going to happen again
> next week.  Since MySQL doesn't leave a clue as to
what happened to it in
> it's logs, I'm stuck speculating.    Has anyone else
had to deal with this
> before?  Or is this a pure MySQL issue and Eventum, the
innocent bystander.
> Cheers,
>  
>  
> Kipp Grose 
> ClaimSecure 
> Web Developer 
> k.groseclaimsecure.com <mailto:k.groseclaimsecure.com>  
>
>
> Visit our website at: http://www.claimsecure.com

>
>
> ********Internet Email Confidentiality********
> This e-mail and any attachments may contain
confidential and privileged  information.  If you are not
the intended recipient, or believe that you may have
received this communication in error, please notify the
sender immediately by return e-mail, delete this e-mail and
destroy any copies.  In addition, you should not print,
copy, retransmit, disseminate, or otherwise use the
information contained in this communication.  Unless
otherwise stated, opinions expressed in this e-mail are
those of the author and are not endorsed by the author's
company.
> Thank you.
>
> Visit our website at: http://www.claimsecure.com

>
>
>
> ********Internet Email Confidentiality********
> This e-mail and any attachments may contain
confidential and privileged  information.  If you are not
the intended recipient, or believe that you may have
received this communication in error, please notify the
sender immediately by return e-mail, delete this e-mail and
destroy any copies.  In addition, you should not print,
copy, retransmit, disseminate, or otherwise use the
information contained in this communication.  Unless
otherwise stated, opinions expressed in this e-mail are
those of the author and are not endorsed by the author's
company.
> Thank you.
>
>
>   



-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com

Morning Milo:

   1) Absolutely, checks every 30 minutes (using the windows
2000 task
scheduler)  
   2) Lots
   3) We are just approaching 1000 now...

 If your at 10000 and you haven't seen this yet, I
wouldn't worry about it.
Wish me luck on the migration today ;)

     Kipp

-----Original Message-----
From: Milo van der Linden [mailto:mlindenzeelandnet.nl] 
Sent: Thursday, September 21, 2006 5:42 PM
To: Kipp Grose
Cc: eventum-userslists.mysql.com
Subject: Re: Eventum causing MySQL to eat 100% CPU

Wow, this is nasty!

Haven't come accross this, but we are running eventum on a
windows box too.
I have a few questions:
- Do you have email download active?
- Do you have a lot of attachements in the database?
- How many issues are in your system? We are running ID's
above 10000,
because we migrated from another system, I would like to
know if we have a
risk of running into problems here

So sorry, no answers, just more questions. But I am willing
to think with
you though!

Kind regards,

Milo van der Linden

Kipp Grose schreef:
> Hi All:
>  
>    Our Eventum installation has been running smoothly
since February.  
> Last week, we had an issue where MySQL went nuts and
throttled the 
> server it was running on at 100%.  We rebooted the box,
couldn't find 
> anything useful in the MySQL logs, shrugged and carried
on.  Then it 
> happened to us again, today, except that after the
reboot, the MySQL 
> service wouldn't start up (yes, it's on windows,
lame, I'm well aware),
throwing up an "Error 1067:
> Process Terminated Unexpectedly."  Googling Error
1067 brings up a 
> whole Pandora's box of crap - best advice I could turn
up was "remove 
> and reinstall".  We're moving MySQL to a new
server / new installation 
> to see if this makes a diff.  Quite irritating after
you get addicted 
> to Eventum and it's now running your department.
>  
>    Anyhow, my question for the list is:  Is anyone
aware of any 
> existing Eventum 1.7.1 issues that could cause MySQL to
throttle like 
> this?  I'm worried that even when I get it fixed up,
its just going to 
> happen again next week.  Since MySQL doesn't leave a
clue as to what
happened to it in
> it's logs, I'm stuck speculating.    Has anyone else
had to deal with this
> before?  Or is this a pure MySQL issue and Eventum, the
innocent
bystander.
> Cheers,
>  
>  
> Kipp Grose
> ClaimSecure
> Web Developer
> k.groseclaimsecure.com <mailto:k.groseclaimsecure.com>
>
>
> Visit our website at: http://www.claimsecure.com

>
>
> ********Internet Email Confidentiality******** This
e-mail and any 
> attachments may contain confidential and privileged 
information.  If you
are not the intended recipient, or believe that you may have
received this
communication in error, please notify the sender immediately
by return
e-mail, delete this e-mail and destroy any copies.  In
addition, you should
not print, copy, retransmit, disseminate, or otherwise use
the information
contained in this communication.  Unless otherwise stated,
opinions
expressed in this e-mail are those of the author and are not
endorsed by the
author's company.
> Thank you.
>
> Visit our website at: http://www.claimsecure.com

>
>
>
> ********Internet Email Confidentiality******** This
e-mail and any 
> attachments may contain confidential and privileged 
information.  If you
are not the intended recipient, or believe that you may have
received this
communication in error, please notify the sender immediately
by return
e-mail, delete this e-mail and destroy any copies.  In
addition, you should
not print, copy, retransmit, disseminate, or otherwise use
the information
contained in this communication.  Unless otherwise stated,
opinions
expressed in this e-mail are those of the author and are not
endorsed by the
author's company.
> Thank you.
>
>
>   




Visit our website at: http://www.claimsecure.com



********Internet Email Confidentiality********
This e-mail and any attachments may contain confidential and
privileged  information.  If you are not the intended
recipient, or believe that you may have received this
communication in error, please notify the sender immediately
by return e-mail, delete this e-mail and destroy any copies.
 In addition, you should not print, copy, retransmit,
disseminate, or otherwise use the information contained in
this communication.  Unless otherwise stated, opinions
expressed in this e-mail are those of the author and are not
endorsed by the author's company.
Thank you.
Visit our website at: http://www.claimsecure.com




********Internet Email Confidentiality********
This e-mail and any attachments may contain confidential and
privileged  information.  If you are not the intended
recipient, or believe that you may have received this
communication in error, please notify the sender immediately
by return e-mail, delete this e-mail and destroy any copies.
 In addition, you should not print, copy, retransmit,
disseminate, or otherwise use the information contained in
this communication.  Unless otherwise stated, opinions
expressed in this e-mail are those of the author and are not
endorsed by the author's company.
Thank you.




-- 
Eventum Users Mailing List
For list archives: http://lists.mys
ql.com/eventum-users
To unsubscribe:    http:
//lists.mysql.com/eventum-users?unsub=bondyahoo.com