[OpenSER-Devel] [ openser-Bugs-1783705 ] SIPTRACE: date column contains invalid data

[SourceForge.net]

Bugs item #1783705, was opened at 2007-08-28 17:22
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1783705&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: SIPTRACE: date column contains invalid data

Initial Comment:
This is an intermittent problem.

The resulting date column contains "0000-00-00 00:00:00" when the invalid data is attempted to be inserted.

Turning on the MySQL logging facility (/etc/mysql/my.cnf)
produced the following:

29 Query insert into sip_trace (...,date,...) values (...,'1493958-10-30 11:27:37',...)

The problem appears to be isolated to records with an 'in' direction.

Below is an 'out' direction record.

28 Query insert into sip_trace (...,date,...) values
 (...,'2007-08-28 20:08:25',...)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1783705&group_id=139143