SYSLOG: Error on database?? - log getting full of errors...

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
chummers
Posts: 23
Joined: Wed Jul 02, 2008 6:44 am

SYSLOG: Error on database?? - log getting full of errors...

Post by chummers »

Hi Folks!

My cacti (CactiEZ) installation is going very well, but I have just checked the logs, and i have found this:

Code: Select all

05/29/2009 09:11:04 AM - SYSTEM STATS: Time:2.1885 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:11:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:10:03 AM - SYSTEM STATS: Time:2.1809 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 09:10:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:09:04 AM - SYSTEM STATS: Time:2.2075 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 09:09:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:08:04 AM - SYSTEM STATS: Time:2.1713 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:08:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:07:03 AM - SYSTEM STATS: Time:2.2492 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:07:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:06:04 AM - SYSTEM STATS: Time:2.1757 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:06:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:05:04 AM - SYSTEM STATS: Time:2.2307 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 09:05:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:04:04 AM - SYSTEM STATS: Time:2.2440 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 09:04:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:03:04 AM - SYSTEM STATS: Time:2.2458 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:03:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:02:04 AM - SYSTEM STATS: Time:2.2353 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:02:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:01:05 AM - SYSTEM STATS: Time:4.3243 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 09:01:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 09:00:04 AM - SYSTEM STATS: Time:2.1938 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 09:00:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:59:03 AM - SYSTEM STATS: Time:2.1840 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 08:59:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:58:03 AM - SYSTEM STATS: Time:2.1907 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:58:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:57:04 AM - SYSTEM STATS: Time:2.1945 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:57:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:56:03 AM - SYSTEM STATS: Time:2.1842 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:56:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:55:03 AM - SYSTEM STATS: Time:2.1809 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 08:55:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:54:03 AM - SYSTEM STATS: Time:2.1752 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 08:54:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:53:04 AM - SYSTEM STATS: Time:2.2427 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:53:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:52:03 AM - SYSTEM STATS: Time:2.1833 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:52:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:51:04 AM - SYSTEM STATS: Time:2.1844 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:51:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:50:03 AM - SYSTEM STATS: Time:2.1987 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 08:50:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:49:05 AM - SYSTEM STATS: Time:3.2338 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:35 RRDsProcessed:35
05/29/2009 08:49:02 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'
05/29/2009 08:48:03 AM - SYSTEM STATS: Time:2.2171 Method:spine Processes:1 Threads:1 Hosts:25 HostsPerProcess:25 DataSources:36 RRDsProcessed:36
05/29/2009 08:48:01 AM - CMDPHP: Poller[0] ERROR: A DB Exec Failed!, Error:'1062', SQL:"insert into settings values ('syslog_last_total','')'

I have no idea on what this means, but after some digging around, i managed to find something about a corrupt database.

I have run the repair on both cacti and syslog databases (as suggested by TheWitness) - when i repaired the syslog database it took hours and never finished, stopped graphing, then could not display graphs at all.. - rebooted and all seemed ok again..
run a fsck (found some bad stuff) but now all ok.
Checked for duplicate cdron jobs
Rebooted server.

But then it starts logging again...

it has been doing this for nearly a month now..

oh, before i forget this is a VM (sitting on a SAN), not a physical box.


Any ideas please??

Chummers..
Top
chummers
Posts: 23
Joined: Wed Jul 02, 2008 6:44 am

Post by chummers »

and here is the information about the server
Cacti Version - 0.8.7c
Plugin Architecture - 2.2
Poller Type - Cactid v
Server Info - Linux 2.6.9-78.0.22.plus.c4smp
Web Server - Apache/2.0.63 (CentOS)
PHP - 5.1.6
PHP Extensions - libxml, xml, wddx, tokenizer, sysvshm, sysvsem, sysvmsg, standard, SimpleXML, sockets, SPL, shmop, session, Reflection, pspell, posix, mime_magic, iconv, hash, gmp, gettext, ftp, exif, date, curl, ctype, calendar, bz2, zlib, pcre, openssl, apache2handler, gd, ldap, mysql, mysqli, PDO, pdo_mysql, pdo_sqlite, snmp, eAccelerator
MySQL - 5.0.68
RRDTool - 1.2.23
SNMP - 5.1.2
Plugins
  • Global Plugin Settings (settings - v0.5)
    Large Site Performane Booster for Cacti (boost - v2.2)
    Device Monitoring (monitor - v0.8.2)
    Network Discovery (discovery - v0.8.5)
    Network Tools (tools - v0.3)
    Syslog Monitoring (syslog - v0.5.2)
    Device Tracking (mactrack - v1.1)
    Login Page Mod (loginmod - v1.0)
    Update Checker (update - v0.4)
    FlowView (flowview - v0.6)
    Host Info (hostinfo - v0.2)
    Error Images (errorimage - v0.1)
    PHP Network Weathermap (weathermap - v0.95b)
    docs
    Cacti-ReportIt (reportit - v0.6.1)
    NTop Viewer (ntop - v0.1)
    SSL Redirector (ssl - v0.1)
    Router Configs (routerconfigs - v0.1)
    WMI Query (wmi - v0.1)
    Realtime Graph Viewer (realtime - v0.36)
Cacti Version 0.8.7c
Plugin Architecture 2.2
Poller Type Cactid v
Server Info Linux 2.6.9-78.0.22.plus.c4smp
Web Server Apache/2.0.63 (CentOS)
PHP Version 5.1.6
MySQL Version 5.0.68
RRDTool Version 1.2.23
SNMP Version 5.1.2
Top
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:
Contact gandalf

Post by gandalf »

Moved to plugins and changed title. This is a SYSLOG issue
Reinhard
Top
hamid_here
Posts: 9
Joined: Mon Nov 09, 2009 7:10 am

Post by hamid_here »

Hi,

Would you please elobarate

Regards,
Syed
Top
eddievenus
Cacti User
Posts: 60
Joined: Mon Jul 18, 2005 7:01 pm

Post by eddievenus »

I am having the same problem, does anyone know what the problem is yet?
Top
User avatar
TheWitness
Developer
Posts: 17007
Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Contact TheWitness

Post by TheWitness »

Change from "INSERT INTO" to "REPLACE INTO" and that problem will be resolved.

TheWitness
True understanding begins only when we realize how little we truly understand...

Life is an adventure, let yours begin with Cacti!

Author of dozens of Cacti plugins and customization's. Advocate of LAMP, MariaDB, IBM Spectrum LSF and the world of batch. Creator of IBM Spectrum RTM, author of quite a bit of unpublished work and most of Cacti's bugs.
_________________
Official Cacti Documentation
GitHub Repository with Supported Plugins
Percona Device Packages (no support)
Interesting Device Packages

For those wondering, I'm still here, but lost in the shadows. Yearning for less bugs. Who want's a Cacti 1.3/2.0? Streams anyone?
Top
aqfire
Posts: 1
Joined: Tue Oct 11, 2011 12:46 pm

Re: SYSLOG: Error on database?? - log getting full of errors

Post by aqfire »

I found it in the plugins/syslog/syslog_counter.php file somewhere around line 65:

$sql = "replace into settings values ('syslog_last_total','$total_rows')";

Worked for me. Thanks TheWitness!
Top
Post Reply

Return to “Plugin General”

Who is online

Users browsing this forum: No registered users and 1 guest