On Fri, Jul 5, 2013 at 11:53 AM, Schmidauer Martin <[email protected]>wrote:
> > Looking at the log, it looks like MSSQL is continously failing as long as > the log > > runs. Rsyslog retries, then tries to begin a new transaction and then > MSSQL > > returns an error state (at least this is what it looks ;)). > > That is interesting. I cannot see any tcp SYN packet, once the TCP > connection is terminated. > > OK, that's sufficient indication. Leave the MSSQL guys unbothered ;) > > Can you see anything in some MSSQL tools to see if there is a new > connect? > > I'm not the MSSQL guy, but I will ask the colleague once again. Frankly, I > doubt that there is any new connect, because I cannot see it with tcpdump. > > > It looks like we have one of three options > > > > a) bug in rsyslog's omlibdbi > > b) problem in libdbi's MSSQL driver and reconnect > > c) problem with MSSQL itself > > > > I hope it's a) and will have some more look at the code. I'll probably > create a > > special version for your use. If so, can you build from source and > execute > that > > version? I am asking because without that, creating instrumented code > makes > > little sense ;) > > Yes, I can build from source, actually I compiled libdbi, libdbi-drivers, > libee, librelp, libestr and rsyslog from source. Freetds came from the > package manager: > freetds-0.91-2.el6.x86_64 > freetds-devel-0.91-2.el6.x86_64 > > excellent! > > Do you know valgrind? Could you run your lab under valgrind control? > > That usally is immensely helpful. > > Now I have an additional testing machine with valgrind compiled and > running. > What do you want me to do exactly? > > it is best to run rsyslog interactively. You can then simply say - in a terminal window: $ valgrind /path/to/rsyslogd -n ...regular options-- 2> valgrind.log You need to $ kill rsyslog-pid to terminate the rsyslog run (do NOT use kill -9, just the regular SIGTERM). Let me know if the desription is too brief. TIA, Rainer > Martin > > > > > > _______________________________________________ > rsyslog mailing list > http://lists.adiscon.net/mailman/listinfo/rsyslog > http://www.rsyslog.com/professional-services/ > What's up with rsyslog? Follow https://twitter.com/rgerhards > NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad > of sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you > DON'T LIKE THAT. > _______________________________________________ rsyslog mailing list http://lists.adiscon.net/mailman/listinfo/rsyslog http://www.rsyslog.com/professional-services/ What's up with rsyslog? Follow https://twitter.com/rgerhards NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE THAT.
