Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Sat Mar 25, 2017 4:38 am

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: Update 1.0.3 to 1.0.5 SQL Error
PostPosted: Mon Mar 13, 2017 11:03 am 
Offline

Joined: Thu Nov 10, 2005 6:11 am
Posts: 31
Hello,

during upgrade of an 1.0.3 (which was successfully and easily upgraded from 0.8.7h btw) to the latest 1.0.5 I saw the following sql error:

DBCALL: ERROR: A DB Exec Failed!, Error:1062, SQL:"ALTER TABLE poller_reindex DROP PRIMARY KEY, ADD PRIMARY KEY (host_id, data_query_id)'
2017 Mar 13 16:08:32 hostname CMDPHP: ERROR: A DB Exec Failed!, Error: Duplicate entry '2096-1' for key 'PRIMARY'


I checked the table and her entries, removed the host referencing the id 2096 from the cacti, but the sql command now bails out another host. Any Ideas on howto proceed with this?

thanks in advance,

cheers,
Tom


Top
 Profile  
 
 Post subject: Re: Update 1.0.3 to 1.0.5 SQL Error
PostPosted: Mon Mar 13, 2017 7:45 pm 
Offline
Cacti User
User avatar

Joined: Mon Jan 05, 2015 10:10 am
Posts: 109
It's a corner case. Not sure it has any 'major' impact. How it happened is a mystery. It won't happen again though ;)

_________________
Before history, there was a paradise, now dust.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group