Hello,
We noticed an issue with a
bunch of stale entries in the mysql location table recently –
all for the same user. It turns out that if you install
linphone 2.0.2 on an iOS device (other versions/platforms
might also be affected) with the transport mode set to TCP and
the ‘Push Notification’ feature enabled, the client generates
very long contact (258+ character) headers. The
contact column in the location table is varchar(255), anything
longer than this automatically gets truncated upon insert.
When the entry later expires and usrloc tries to remove it, it
generates a delete query that matches on the entire
contact value and not the truncated version. This causes the
delete query to fail and the usrloc record gets left behind in
the location table.
The (truncated) contact header value from
the database:
sip:22448462@98.248.37.244:52008;transport=tcp;app-id=org.linphone.phone.prod;pn-type=apple;pn-tok=AA31DC9642E76E7D7DA8A0E419B210E1A00E8DF43A7A77C8CD2955291E1BAC85;pn-msg-str=IM_MSG;pn-call-str=IC_MSG;pn-call-snd=ring.caf;pn-msg-snd=msg.caf;line=932257155
The failed delete query:.
delete from
location where username='XXXXXXXX' AND
contact='sip:XXXXXXXX@11.22.333.
44:52000;transport=tcp;app-id=org.linphone.phone.prod;pn-type=apple;pn-tok=AA31DC9642E76E7D7DA8A0E419B210E1A00E8DF43A7A77C8CD2955291E1BAC85;pn-msg-str=IM_MSG;pn-call-str=IC_MSG;pn-call-snd=ring.caf;pn-msg-snd=msg.caf;line=932257155f64767' AND
callid='1962857815';
What do you all think the best solution
here is? My intuition is to simply increase the size of this
column. If this is the right approach then it probably also
makes sense to update the .sql file for new installs.
Thoughts?