rasqlinsert disconnect issues

John T. Myers myersj0 at gmail.com
Thu Sep 25 16:21:02 EDT 2014


After the connection goes down, rasqlinsert() constantly logs a “No database selected” error to syslog.


On September 25, 2014 at 4:11:17 PM, John T. Myers (myersj0 at gmail.com) wrote:

rasqlinsert() is running but not updating the database, the size is not getting bigger. I am also running it with ‘-m none’ 


On September 25, 2014 at 1:34:27 PM, Carter Bullard (carter at qosient.com) wrote:

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> 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/becaa49e/attachment.html>


More information about the argus mailing list