RE: Re: Scarab stopped to send eMails

We see this problem about every week or so.  We're running RH4, Scarab .21, MySQL 4.x.  The notification queue will fill up but the messages will not be sent.  We've created a cron to look at the number of records in the table and if it gets too high, we get paged out.  We've found restarting Scarab is the workaround to the problem.  But as we get more users (~350 right now) this becomes a less elegant solution.  Our notification.log has a lot of these errors:
 
2008-01-07 10:19:39,646 [TP-Processor10] ERROR org.tigris.scarab.notification.ScarabNewNotificationManager - queueNotifications():
org.apache.torque.TorqueException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'STATUS_COMMENT' at row 1

________________________________

From: Jorge Uriarte Aretxaga [mailto:[email protected]] 
Sent: Tuesday, January 29, 2008 8:54 AM
To: [email protected]
Subject: Re: Scarab stopped to send eMails


Does notification.log hold any information?
Also... do you see any message for every "generated but not sent" notification in the Notifications screen?

Wold you copy&pase that screen here?

_
Jorge


On 1/29/08, Uwe Fechner <[email protected]> wrote: 

	Hello,

	 

	I have to correct myself.

	 

	The notifications are beeing generated, but not send (I couldn't see any first, because

	I was logged in as administrator).

	 

	If the notification manager tries to send the emails, but is not successfull, would there

	be an error message in any of the log files (and in which one)?

	 

	Regards:

	 

	Uwe Fechner

	 

	
________________________________


	Von: Jean-François El Fouly [mailto:[email protected]] 
	Gesendet: Dienstag, 29. Januar 2008 13:44
	An: [email protected]
	Betreff: Re: AW: Re: Scarab stopped to send eMails

	 

	Uwe Fechner a écrit : 
	
	

	 

	We did not change the scarab configuration or settings, but suddenly no more notifications are beeing

	generated.

	The only thing I did was to create two new modules and to move tickets from the old modules into the

	new modules.

	Do the notifications work from these new modules ?