[SR-Users] Contact header from linphone too long to delete

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.pro d;pn-type=apple;pn-tok=AA31DC9642E76E7D7DA8A0E419B210E1A00E8DF43A7A77C8CD295 5291E1BAC85;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=A A31DC9642E76E7D7DA8A0E419B210E1A00E8DF43A7A77C8CD2955291E1BAC85;pn-msg-str=I M_MSG;pn-call-str=IC_MSG;pn-call-snd=ring.caf;pn-msg-snd=msg.caf;line=932257 155f64767' 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? Thank you, Ross