rasqlinsert disconnect issues

[David Edelman]

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/20140925/f1de310d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6217 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20140925/f1de310d/attachment.bin>