I've just tried to reproduce the sqlbox issue with the MO's being lost, and couldn't. Tried with up to 100K messages using fakesmsc and all of them were inserted on the DB.
I've tried both with latest sqlbox SVN and also with 0.7.2 and in both cases worked exactly the same. Perhaps something changed on Kannel's side during last year that fixed the issue without us noticing? Anyway, it's definitely gone for good :) BTW, I've been bitten by the retry bug: the few messages that failed on smsbox (because the web server couldn't cope with them) were queued in _memory_ (they'd be gone if I'd stop smsbox) and retried one by one on 30 seconds interval. IMHO_that_ is a serious bug on Kannel that should be taken care of asap. 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:41 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:09:49 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:10:19 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:10:49 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:11:19 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:11:49 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:12:19 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:12:49 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:13:19 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" 127.0.0.1 - - [11/Sep/2010:18:13:49 -0300] "GET /kannel.html HTTP/1.1" 200 4 "-" "Kannel/svn-r4838" Settings were: http-request-retry = 10 http-queue-delay = 30 Regards, -- Alejandro Guerrieri [email protected] On 11/09/2010, at 11:55, Alexander Malysh wrote: > oops, this patch should definitely go in. > > > Am 10.09.2010 um 22:07 schrieb Rene Kluwen: > >> Not sure if anybody noticed. But not all sms messages were acked properly >> before, leaving messages in the message store. >> I stuck across this, while implementing sqlbox for a client. >> >> This patch solves the problem. I would like to see it implemented before >> next devel-release. Votes? >> >> == Rene >> >> >> From: Alejandro Guerrieri [mailto:[email protected]] >> Sent: Friday, 10 September, 2010 20:30 >> To: Rene Kluwen >> Cc: 'Alejandro Guerrieri'; 'Kannel Devel' >> Subject: Re: Release plan >> >> Yes, that was what I was thinking also. I'll try with an older version of >> Sqlbox and latest SVN to see if there's any differences. >> >> Regards, >> -- >> Alejandro Guerrieri >> [email protected] >> >> >> >> On 10/09/2010, at 20:12, Rene Kluwen wrote: >> >> >> If it has something to do with acks, then this might be the case. >> >> == Rene >> >> From: Alejandro Guerrieri [mailto:[email protected]] >> Sent: Friday, 10 September, 2010 19:23 >> To: Rene Kluwen >> Cc: Alexander Malysh; Victor Luchitz; Kannel Devel >> Subject: Re: Release plan >> >> Wow, that's odd. Perhaps one of the latest patches solved it? >> >> I'll try to reproduce it this weekend to be sure. >> >> Regards, >> >> Alex >> >> On Fri, Sep 10, 2010 at 7:16 PM, Rene Kluwen <[email protected]> wrote: >> Just sent a million messages via Nikos' stress test. >> And they all arrived, without losing a single message. >> >> == Rene >> >> >> > 2010/9/10 Alexander Malysh <[email protected]>: >> >> Hi Rene, >> >> >> >> we can delay release for one more week but not longer. If you think it's >> better to delay let us know. >> >> >> >> Thanks, >> >> Alexander Malysh >> >> >> >> Am 09.09.2010 um 17:46 schrieb Rene Kluwen: >> >> >> >>> @Alejandro: >> >>> Not sure if it is a show stopper. It could be in the section "known >> bugs". >> >>> >> >>> @Alexander: Even though I am +1 for a new release (the older release has >> >>> been a while) next weekend is really a short notice. >> >>> >> >>> @ both: I will investigate the "MO" problem of sqlbox. >> >>> >> >>> == Rene >> >>> >> >>> -----Original Message----- >> >>> From: [email protected] [mailto:[email protected]] On >> Behalf >> >>> Of Alejandro Guerrieri >> >>> Sent: Thursday, 09 September, 2010 15:34 >> >>> To: Alexander Malysh >> >>> Cc: Kannel Devel >> >>> Subject: Re: Release plan >> >>> >> >>> On Sqlbox, we have that unsolved issue that arose when the meta-data >> branch >> >>> was applied on Kannel. That's a showstopper imho. >> >>> >> >>> To describe the problem further: >> >>> >> >>> The issue arises when sqlbox is between bearerbox and smsbox, and it's >> only >> >>> observed on MO traffic. >> >>> >> >>> When you receive just a few MO messages, it works fine. However, if you >> >>> sustain a moderate level of inbound messages, some of them are lost. The >> >>> logs shows nothing relevant. >> >>> >> >>> The bug was observed by many users on the list. I've also confirmed it's >> >>> happening. >> >>> >> >>> I'm not sure if it's really an sqlbox bug, or if it's really on Kannel's >> >>> side. The problem doesn't occur if you use an older version of Kannel >> (pre >> >>> meta-data). >> >>> >> >>> Regards, >> >>> -- >> >>> Alejandro Guerrieri >> >>> [email protected] >> >>> >> >>> >> >>> >> >>> On 09/09/2010, at 15:12, Alexander Malysh wrote: >> >>> >> >>>> Hi together, >> >>>> >> >>>> we are plan to release new Kannel developer version. >> >>>> For this task we have at this point in time only one patch to merge, >> wtls >> >>> branch. >> >>>> >> >>>> We also plan to release sqlbox & opensmppbox with Kannel. Rene & Alex: >> >>> could you please >> >>>> check status of both boxes and let us know whether you agree to release >> >>> with Kannel and whether >> >>>> boxes ready for release? >> >>>> >> >>>> The plan would be: >> >>>> 1) this weekend WTLS branch merge >> >>>> 2) next week testing >> >>>> 3) next weekend release but here depends on Stipe >> >>>> >> >>>> Please let me know which not commited patches should go in and whether >> >>> somebody sees showstopper. >> >>>> >> >>>> Thanks, >> >>>> Alexander Malysh >> >>> >> >>> >> >>> >> >>> >> >> >> >> >> >> >> > >> > >> > >> > -- >> > Best regards, >> > Victor Luchitz >> > >> >> >> >> >> >> >> >> <sqlbox_acks_3.patch> >
