Re: [Sguil-users] 0.9.0 upgrade died
Status: Beta
Brought to you by:
bamm
From: Bamm V. <bam...@gm...> - 2014-07-03 12:09:04
|
I would check to make sure the localtime for your sensors/servers are all set to UTC. Not just the DB. Bamm On Wed, Jul 2, 2014 at 9:40 PM, James Lay <jl...@sl...> wrote: > On Wed, 2014-07-02 at 19:22 -0600, James Lay wrote: > > On Wed, 2014-07-02 at 20:53 -0400, Bamm Visscher wrote: > > Did this cause your DB to fail again? Restarting BY should fix it. > > > Bamm > > > On Wed, Jul 2, 2014 at 8:16 PM, James Lay <jl...@sl...> > wrote: > > On Wed, 2014-07-02 at 12:47 -0400, Bamm Visscher wrote: > > Hi James, > > > This does look like there is a TZ issue at play. I'll dig deeper when I > get a chance this evening. One way to get back up would be to temporarily > disable the autocat rule that is triggering the update. > > > Bamm > > > > And again...moments ago: > > Jul 2 18:01:59 x.x.x.x barnyard2[15859]: FATAL ERROR: sguil: Expected > Confirm 904 and got: Failed to insert 904: mysqlexec/db server: Duplicate > entry 4-904 for key PRIMARY#012. I'm officially at a loss at one to do now > besides roll back to 0.8.0. > > James > > > Negative....sguild will no longer start....exact same thing as > earlier...around the same time as well: > > [19:20:47 @ids <jlay@goids>:~$] mysqlexec/db server: Table > 'sguildb.event_External_20140703' doesn't exist > while executing > "mysqlexec $MAIN_DB_SOCKETID $updateString" > (procedure "UpdateDBStatus" line 11) > invoked from within > "UpdateDBStatus [lindex $data 3] [lindex $data 4] [lindex $data 5] [lindex > $data 6] [GetCurrentTimeStamp] $AUTOID $acCat($rid)" > (procedure "AutoCat" line 43) > invoked from within > "AutoCat $row" > ("foreach" body line 6) > invoked from within > "foreach row [mysqlsel $MAIN_DB_SOCKETID $tmpQry -list] { > > InfoMessage "Archived Alert: $row" > set LAST_EVENT_ID([lindex $row 3]) "[li..." > invoked from within > "if { $mergeTableListArray(event) != "" } { > > # Get the archived alerts > LogMessage "Querying DB for archived events..." > set MAJOR_MYSQL_VERS..." > (file "/opt/bin/sguil/sguild" line 734) > > > > Anyway I've got sguild, agents, and barnyard2 all shut down for the rest > of this week...I'll either roll back to 0.8.0 or something else...thanks > Bamm...I appreciate it. > > James > > > > ------------------------------------------------------------------------------ > Open source business process management suite built on Java and Eclipse > Turn processes into business applications with Bonita BPM Community Edition > Quickly connect people, data, and systems into organized workflows > Winner of BOSSIE, CODIE, OW2 and Gartner awards > http://p.sf.net/sfu/Bonitasoft > _______________________________________________ > Sguil-users mailing list > Sgu...@li... > https://lists.sourceforge.net/lists/listinfo/sguil-users > > -- sguil - The Analyst Console for NSM http://www.sguil.net |