rasqlinsert disconnect issues

[David Edelman]

Carter,

I¹m running rasqlinsert using ­S localhost:561 to process the output of
radium which is doing labeling. I¹ll fire up an instance of the release code
with the same parameter but a different table name and see if there is
anything obvious. I¹ve built the release code with both .debug and .devel do
you have a recommendation for a debug value?

‹Dave

From:  Carter Bullard <carter at qosient.com>
Date:  Monday, September 29, 2014 at 1:51 PM
To:  David Edelman <dedelman at iname.com>
Cc:  "John T. Myers" <myersj0 at gmail.com>, Argus
<argus-info at lists.andrew.cmu.edu>
Subject:  Re: [ARGUS] rasqlinsert disconnect issues

Hey Dave,
Well, that¹s not what we¹re striving for, so
if we can capture what that is all about, I¹ll
fix as soon as I can.

Carter

On Sep 28, 2014, at 5:47 PM, David Edelman <dedelman at iname.com> wrote:

> The running but seems to no update the database was a problem that I reported
> and you fixed in one of the very last release candidates. The current 3.0.8
> does not have that problem as best I can tell but it does stop after between
> 8-20 hours with no log messages that I have been able to find.
>  
> --Dave
>  
> From: Carter Bullard [mailto:carter at qosient.com]
> Sent: Sunday, September 28, 2014 11:34 AM
> To: David Edelman
> Cc: John T. Myers; Argus
> Subject: Re: [ARGUS] rasqlinsert disconnect issues
>  
> Well the earlier rasqlinsert.1 code does have a problem that the new one tried
> to fix.  I¹ll try to see what may be up with mysql_real_query() error
> messages,
> and see if we missed something there.
>  
> But in the OP, the problem is that rasqlinsert.1 is running, but not updating
> the database, in this second report, rasqlinsert.1 is failing ??
>  
> Carter
>  
>  
> On Sep 25, 2014, at 8:11 PM, David Edelman <dedelman at iname.com> wrote:
> 
> 
>> Carter,
>>  
>> I am seeing something similar with Netflow data processed by Radium (labels
>> added) and rasqlinsert reading the processed radium data from port 561. In my
>> case the rasqlinsert process dies without any error messages (it is built
>> with .debug and .devel) It isn¹t practical for me to enable debuigger output
>> since the failure can be many hours into the run.
>>  
>> The one clue that I do have it that the release candidate set (3.0.8-rc1)
>> worked fine.
>>  
>> I haven¹t had time to do much more than go back to the working release.
>>  
>> --Dave
>>  
>> From: argus-info-bounces+dedelman=iname.com at lists.andrew.cmu.edu
>> [mailto:argus-info-bounces+dedelman=iname.com at lists.andrew.cmu.edu] On Behalf
>> Of Carter Bullard
>> Sent: Thursday, September 25, 2014 1:34 PM
>> To: John T. Myers
>> Cc: Argus
>> Subject: Re: [ARGUS] rasqlinsert disconnect issues
>>  
>> Hey John,
>> rasqlinsert() is multi-threaded, and its possible that
>> the cache concurrency thread, the one that is managing the
>> database cache, exited if the database fails.
>>  
>> rasqlinsert() should close, if that thread is done.
>>  
>> So you are seeing rasqlinsert() is still running, but
>> not updating the database ??  Is rasqlinsert() getting
>> bigger ???  (should be generating INSERT and UPDATE
>> requests, but the DB thread is not processing them ???)
>>  
>> Carter
>>  
>>  
>> On Sep 25, 2014, at 10:35 AM, John T. Myers <myersj0 at gmail.com
>> <mailto:myersj0 at gmail.com> > wrote:
>> 
>> 
>> 
>>> Hello,
>>>  
>>> I was wondering if it¹s normal behavior for rasqlinsert to cease inserting
>>> netflow into the database if the connection becomes interrupted? It seems if
>>> the mysql database is restarted or any part of the connection between
>>> rasqlinsert and the db is broken, it will not attempt to re-connect and
>>> continue flow insertion.
>>>  
>>> Thanks!
>>> John



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20141002/63a616f3/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5745 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20141002/63a616f3/attachment.bin>