The only problem is to make sure there is no race condition and UPDATE gets executed AFTER there is already an entry.
I've found a bug in sqlbox and kannel - sometimes report from kannel comes earlier than record being moved from send_sms to sent_sms (i think its because MySQL sometimes delays record insertion). 2012/12/27 Alvaro Cornejo <cornejo.alv...@gmail.com> > Hi > > Use update xxxx instead of insert xxxx on your script, thererefore > you can keep the unique key coherent with the logs. > > > > On 12/27/12, spameden <spame...@gmail.com> wrote: > > All the solutions based on parsing logs will affect your performance and > > cause a delay on processing MO's. > > > > You need to take care about 'duplicate entries' bug - either patch kannel > > or re-write your processing script to avoid multiple entries insterted > with > > the same sql-id. > > > > 2012/12/27 Jose Figueroa <josen.figue...@unixmexico.org> > > > >> Hello Ombongi > >> > >> I had the same problem once and I had to write a awk scripting file in > >> order to accomplish it. On the previous email you said to process them > at > >> least to send to the subscribers so It would be easy if you need this > and > >> even if you need to insert them into the MySQL table. > >> > >> If you need some help with the awk scripting file I can help you on > doing > >> this. > >> > >> Saludos mi querido Ombongi. > >> Jose > >> > >> On Dec 26, 2012, at 11:42 PM, Tapan Kumar Thapa > >> <tapan.thapa2...@gmail.com> > >> wrote: > >> > >> I think automatically by kannel itself is not possible however you can > >> write a small program which will parse access logs and will reinsert the > >> same in MySQL table. > >> > >> Thanks & Regards > >> Tapan Thapa > >> > >> On Thu, Dec 27, 2012 at 11:03 AM, Ombongi Moraa Fe < > >> moraa.lovetak...@gmail.com> wrote: > >> > >>> Hello Team, > >>> > >>> I realized some 20 Hours later that insertion of messages into mysql > >>> database wasn't working. When I tried to insert manually, I got the > >>> error > >>> "duplicate entry to autoincrement field...." Therefore, almost 10000 > >>> messages were never inserted into the mysql table holding messages > >>> because > >>> of this. Hence, basically nothing was done to these requests. > >>> > >>> When I check the kannel MO log file, I can see alot of those messages > >>> that were never processed as a result. I wonder, Is i possible to > >>> reprocess > >>> my log entries during this period and at least send out responses to > the > >>> subscribers? I cannot reprocess them from the database since they were > >>> never inserted into the table for holding incoming messages. I > therefore > >>> need another position of re-running my processing. > >>> > >>> I'll appreciate your advise. > >>> > >>> Saludos > >>> > >>> Ombongi Moraa fe > >>> > >> > >> > >> > > > > > -- > > |-----------------------------------------------------------------------------------------------------------------| > Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier > celular y Nextel > en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via > SMS y GPRS online > Visitenos en www.perusms.NET www.smsglobal.com.mx y > www.pravcom.com >
