Max Query Length Exceeded and Field Truncated
aland at deployingradius.com
Thu Mar 18 18:07:11 CET 2010
Robert Gabriel wrote:
> Hello all,
> Our network had some change somewhere and now all MySQL insert queries
> are failing
> with the last field been truncated and the character count is always
> 4097 from the CDRs
What does that mean? What's a "character count"?
> been sent by our NAS (Acme Packet SBC).
> Having looked at the source we see:
> /* SQL defines */
> #define MAX_QUERY_LEN 4096
> #define SQL_LOCK_LEN MAX_QUERY_LEN
> I'm not sure here, can we just increase to 8192 etc. or is this being stupid?
> Can I edit the above and recompile?
Yes. But I fail to see why the SQL queries are huge. There's really
no reason for this.
> MySQL log (shortened for brevity's sake):
> INSERT into accounting (AcctStatusType, AcctTerminateCause,
> CalledStationId, NASIdentifier, h323setuptime, h323connecttime,
> h323disconnecttime, h323disconnectcause) values ('0', '0', '0', '0',
> '0', '0', '0', 'sip:0738063114 at h
Think a bit: that line looks truncated, but there is NO WAY it's 4K in
Something else is going on. Find out what, and fix it.
More information about the Freeradius-Users