This repository has been archived by the owner on Dec 13, 2022. It is now read-only.
This repository has been archived by the owner on Dec 13, 2022. It is now read-only.
Closed
Description
Author Name: charles judith (charles judith)
Original Redmine Issue: 3639, https://forge.centreon.com/issues/3639
Original Date: 2012-09-05
Original Assignee: Maximilien Bersoult
Hi,
I've just met a strange error in centreon-purge.log:
5/9/2012 10:59:36 - Begin centstorage.data_bin purge
5/9/2012 10:59:36 - Finishing centstorage.data_bin purge
5/9/2012 10:59:46 - Begin centstorage.logs purge
5/9/2012 10:59:46 - End centstorage.logs purge
DBD::mysql::db do failed: Unknown column 'ctime' in 'where clause' at /usr/share/centreon/cron/purgeLogs line 132.
DBD::mysql::db do failed: Unknown column 'ctime' in 'where clause' at /usr/share/centreon/cron/purgeLogs line 133.
5/9/2012 10:59:46 - Purge log_archive table... Done
At line 132-133 on purgeLogs files there is:
# Purge Log Archive Database
$dbh->do("DELETE FROM `log_archive_host` WHERE `ctime` < '$last_log'");
$dbh->do("DELETE FROM `log_archive_service` WHERE `ctime` < '$last_log'");
The field ctime doesn't exist in the log_archive_host and log_archive_service tables:
mysql> desc log_archive_host;
+--------------------------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------+---------+------+-----+---------+----------------+
| log_id | int(11) | NO | PRI | NULL | auto_increment |
| host_id | int(11) | YES | MUL | NULL | |
| UPTimeScheduled | int(11) | YES | | NULL | |
| UPnbEvent | int(11) | YES | | NULL | |
| UPTimeAverageAck | int(11) | NO | | NULL | |
| UPTimeAverageRecovery | int(11) | NO | | NULL | |
| DOWNTimeScheduled | int(11) | YES | | NULL | |
| DOWNnbEvent | int(11) | YES | | NULL | |
| DOWNTimeAverageAck | int(11) | NO | | NULL | |
| DOWNTimeAverageRecovery | int(11) | NO | | NULL | |
| UNREACHABLETimeScheduled | int(11) | YES | | NULL | |
| UNREACHABLEnbEvent | int(11) | YES | | NULL | |
| UNREACHABLETimeAverageAck | int(11) | NO | | NULL | |
| UNREACHABLETimeAverageRecovery | int(11) | NO | | NULL | |
| UNDETERMINEDTimeScheduled | int(11) | YES | | NULL | |
| MaintenanceTime | int(11) | YES | | 0 | |
| date_end | int(11) | YES | MUL | NULL | |
| date_start | int(11) | YES | MUL | NULL | |
+--------------------------------+---------+------+-----+---------+----------------+
mysql> desc log_archive_service;
+-----------------------------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------------+---------+------+-----+---------+----------------+
| log_id | int(11) | NO | PRI | NULL | auto_increment |
| host_id | int(11) | NO | MUL | 0 | |
| service_id | int(11) | NO | MUL | 0 | |
| OKTimeScheduled | int(11) | NO | | 0 | |
| OKnbEvent | int(11) | NO | | 0 | |
| OKTimeAverageAck | int(11) | NO | | NULL | |
| OKTimeAverageRecovery | int(11) | NO | | NULL | |
| WARNINGTimeScheduled | int(11) | NO | | 0 | |
| WARNINGnbEvent | int(11) | NO | | 0 | |
| WARNINGTimeAverageAck | int(11) | NO | | NULL | |
| WARNINGTimeAverageRecovery | int(11) | NO | | NULL | |
| UNKNOWNTimeScheduled | int(11) | NO | | 0 | |
| UNKNOWNnbEvent | int(11) | NO | | 0 | |
| UNKNOWNTimeAverageAck | int(11) | NO | | NULL | |
| UNKNOWNTimeAverageRecovery | int(11) | NO | | NULL | |
| CRITICALTimeScheduled | int(11) | NO | | 0 | |
| CRITICALnbEvent | int(11) | NO | | 0 | |
| CRITICALTimeAverageAck | int(11) | NO | | NULL | |
| CRITICALTimeAverageRecovery | int(11) | NO | | NULL | |
| UNDETERMINEDTimeScheduled | int(11) | NO | | 0 | |
| MaintenanceTime | int(11) | YES | | 0 | |
| date_start | int(11) | YES | MUL | NULL | |
| date_end | int(11) | YES | MUL | NULL | |
+-----------------------------+---------+------+-----+---------+----------------+
Can you watch what's going on ?
Thanks,
Metadata
Assignees
Labels
No labels