Innimellom s\u00e5 begynner CactiEZ \u00e5 logge masse, og da g\u00e5r en tom for plass. For \u00e5 ikke \u00f8delegge grafene er trikset \u00e5 restore en gammel backup. Ogs\u00e5 s\u00f8rge for at poller_output cachen blir opprettet p\u00e5 ny i mysql.<\/p>\n
S\u00e5 for \u00e5 gjenskape mysql output tabellen. Innimellom s\u00e5 begynner CactiEZ \u00e5 logge masse, og da g\u00e5r en tom for plass. For \u00e5 ikke \u00f8delegge grafene er trikset \u00e5 restore en gammel backup. Ogs\u00e5 s\u00f8rge for at poller_output cachen blir opprettet p\u00e5 ny i mysql. # \/etc\/init.d\/httpd stop # cd \/ # tar zxvf \/var\/www\/backups\/cacti-backup-2015-03-08.tar.gz # mysql -ppassord cacti < \/var\/www\/html\/cacti-backup.sql # […]\n<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,10],"tags":[106,107,108],"class_list":["post-386","post","type-post","status-publish","format-standard","hentry","category-data","category-linux-data","tag-cacti","tag-cactiez","tag-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/posts\/386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":1,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions"}],"predecessor-version":[{"id":387,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=\/wp\/v2\/posts\/386\/revisions\/387"}],"wp:attachment":[{"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kpolberg.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n# \/etc\/init.d\/httpd stop
\n# cd \/
\n# tar zxvf \/var\/www\/backups\/cacti-backup-2015-03-08.tar.gz
\n# mysql -ppassord cacti < \/var\/www\/html\/cacti-backup.sql\n# mysql -ppassord syslog < \/var\/www\/html\/syslog.sql\n# cd \/var\/www\/html\/cli\/\n# php repair_database.php\n<\/code><\/p>\n
\n
\nuse cacti;
\ntruncate poller_output;
\n<\/code>
\nDenne bruker typisk hvis du ser
\n
\n03\/10\/2015 02:29:07 PM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'1017', SQL:\"select poller_output.output, poller_output.time, UNIX_TIMESTAMP(poller_output.time) as unix_time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000\"
\n<\/code>
\ni loggene.<\/p>\n","protected":false},"excerpt":{"rendered":"