ERROR 1062 Duplicate entry - Cacti is not updating graphs

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
rapco
Posts: 2
Joined: Thu Feb 17, 2011 1:05 pm

ERROR 1062 Duplicate entry - Cacti is not updating graphs

Post by rapco »

Hi,

I need some help. I had to hard reboot the VM that runs Cacti.

After it came up it ran into one error "126 - Incorrect key file for table './syslog/syslog_incoming'; try to repair it", then i ran "check table syslog_incoming;" followed by fsk -t ext /dev/sda2 in init 1 and reboot, it came up, but i keep getting error ERROR 1062 (23000) at line 1: Duplicate entry ´794095´ for key 1" and is not graphying anymore.
Cacti Version - 0.8.7c
Plugin Architecture - 2.2
Poller Type - Cactid v
Server Info - Linux 2.6.9-89.35.1.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.82sp1
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)
    Router Configs (routerconfigs - v0.1)
    WMI Query (wmi - v0.1)
    Realtime for Cacti (realtime - v0.35)
Update 1:
Is updating graphs, however I still get the error on the console (SSH). "ERROR 1062 (23000) at line 1: Duplicate entry ´794095´ for key 1"

Update 2:
I reinstall and restore from a previous Backup, now I have other issues but will open a new thread.
Last edited by rapco on Sat Feb 19, 2011 2:59 pm, edited 1 time in total.
User avatar
gandalf
Developer
Posts: 22383
Joined: Thu Dec 02, 2004 2:46 am
Location: Muenster, Germany
Contact:

Re: ERROR 1062 Duplicate entry - Cacti is not updating graph

Post by gandalf »

Moving, as this is a syslog plugin issue
R.
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests