To share some extra info about it: The problem appeared after the meta-data branch was merged on Jan/14/09. Kannel CVS 2009-01-13 and before works perfectly fine with sqlbox.
I've checked on redmine the revision for that date, is of course a big patch modifying lots of stuff, but I couldn't find anything blatantly wrong with it. Still trying to figure out where to fix it, if you find out anything let me know :) Regards, Alex On Thu, Jan 14, 2010 at 2:10 PM, Bruno Aguirre <brunoaguirreris...@gmail.com > wrote: > You're right mt traffic is perfect but i think the problem is when sqlbox > is trying to read from bearerbox, i'm trying to find some evidence but the > issue appears to be in the method read_from_box(Connection *conn, Boxc > *boxconn) but i'm also confused because is almost a carbon copy > of read_from_bearerbox_real(Connection *conn, Msg **msg, double seconds). > > Anyway, if i have any info i'll send it here. > > > > 2010/1/13 Alejandro Guerrieri <alejandro.guerri...@gmail.com> > > Some MO's are dropped under heavy traffic. >> >> MT traffic is NOT affected at all. >> >> Not sure about DLR's (didn't experienced myself, but since DLR's and MO's >> are fairly similar... maybe) >> >> Regards, >> >> Alex >> >> >> On Wed, Jan 13, 2010 at 8:54 PM, Kenny <ken.bell...@gmail.com> wrote: >> >>> Hi, >>> >>> Is the loss on MO or MT or BOTH ? >>> >>> >>> -- >>> Kenny >>> w: www.nuObjects.com >>> Bulk SMS Solutions | Managed Hosting | Enterprise Application Development >>> >>> >>> >>> On Wed, Jan 13, 2010 at 8:18 PM, Alejandro Guerrieri < >>> alejandro.guerri...@gmail.com> wrote: >>> >>>> My patch adds support for meta-data on _all_ DB engines, not only mysql. >>>> Have you tried with other DB engines? >>>> >>>> Anyway, there seems to be another (still unknown) problem, perhaps not >>>> related with sqlbox itself but with the way sqlbox talks with bearerbox. We >>>> still need to do extra testing to determine where the problem occurs. >>>> >>>> Regards, >>>> >>>> Alex >>>> >>>> >>>> On Wed, Jan 13, 2010 at 8:01 PM, Bruno Aguirre < >>>> brunoaguirreris...@gmail.com> wrote: >>>> >>>>> Hi to all!. >>>>> I'm running some tests with SMPP Sim and a cvs kannel with the >>>>> sqlbox-meta. The "meta-data-aware" patch is quite similar to my original >>>>> patch, i'm having the same issues than before, some loss between sqlbox >>>>> and >>>>> smsbox. >>>>> >>>>> Anyone is having similar issues? >>>>> >>>>> >>>>> 2009/12/29 Alejandro Guerrieri <alejandro.guerri...@gmail.com> >>>>> >>>>> Ok, so maybe the problem is related to the way bearerbox and sqlbox >>>>>> exchange messages. Good to know... >>>>>> >>>>>> Regards, >>>>>> >>>>>> Alex >>>>>> >>>>>> >>>>>> On Tue, Dec 29, 2009 at 2:01 PM, Willy <sangpr...@gmail.com> wrote: >>>>>> >>>>>>> I use cvs 20090114 (pre meta data) with sqlbox 0.72, tested against >>>>>>> 100 thousands MO, speed around 100 MO/sec. Still fine. >>>>>>> >>>>>>> >>>>>>> >>>>>>> Willy >>>>>>> Sent from my Sony Ericsson XPERIA™ X1. >>>>>>> >>>>>>> ------------------------------ >>>>>>> From: Alejandro Guerrieri <alejandro.guerri...@gmail.com> >>>>>>> Sent: 29 December 2009 18:41 >>>>>>> To: Willy Mularto <sangpr...@gmail.com> >>>>>>> Cc: ken.bell...@gmail.com; users@kannel.org; de...@kannel.org >>>>>>> Subject: Re: SQLBox Issues and Limit per cycle SQLBox patch >>>>>>> >>>>>>> >>>>>>> You asked for it, you've got it ;) >>>>>>> >>>>>>> [Sorry, I'm cross-posting this one, since it's probably people >>>>>>> interested on both lists for different reasons] >>>>>>> >>>>>>> >>>>>>> http://www.kannel.org/~aguerrieri/SqlBox/Snapshots/sqlbox-meta-20091229.tar.gz<http://www.kannel.org/%7Eaguerrieri/SqlBox/Snapshots/sqlbox-meta-20091229.tar.gz> >>>>>>> >>>>>>> This snapshot is not commited to CVS yet, since it needs proper >>>>>>> testing on ALL DB engines: mysql, postgres, sqlite(2), sqlite3, oracle, >>>>>>> mssql/sybase and sdb. Volunteers are needed to test all of them (I'll >>>>>>> do my >>>>>>> best as well, but any help is appreciated). >>>>>>> >>>>>>> To build it, run ./bootstrap first, then ./configure >>>>>>> --with-<dbengine>, make and sudo make install. You need a Kannel >>>>>>> compiled >>>>>>> with support for the same DB engine you're going to use of course. >>>>>>> >>>>>>> WARNING: There still seems to be an issue with MO under heavy load: >>>>>>> some messages are lost. After further testing, this doesn't seem to be >>>>>>> related with meta-data at all. To reproduce the error, you need to put >>>>>>> sqlbox between bearerbox and smsbox and use it to capture all traffic >>>>>>> (MO >>>>>>> and MT). Then, if you sent a bunch of messages from a fake smsc at high >>>>>>> rates (100 or more messages with .01 delay is enough to cause it), some >>>>>>> of >>>>>>> them are not recorded nor forwarded to smsbox. I need to investigate it >>>>>>> further, I've only tried with mysql so far, so I'm not sure if this is >>>>>>> a DB >>>>>>> problem, or something related with threading or so. Actually I think the >>>>>>> same problem would happen with a pre-meta-data kannel version (anyone >>>>>>> can >>>>>>> confirm this?). >>>>>>> >>>>>>> NOTE: There's NO problem with MT, if you use SqlBox to send messages >>>>>>> by inserting on send_sms, then you won't notice any problems at all. >>>>>>> >>>>>>> Last but not least, I'm out of luck building on Snow Leopard. It >>>>>>> compiles but segfaults afterwards. >>>>>>> >>>>>>> >>>>>>> [The entire original message is not included] >>>>>>> >>>>>> >>>>>> >>>>> >>>> >>> >> >
