[ZBX-1055] Housekeeper does not count deleted records correctly with PostgreSQL Created: 2009 Sep 23 Updated: 2017 May 30 Resolved: 2009 Sep 28 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 1.6.6 |
| Fix Version/s: | 1.6.6, 1.9.0 (alpha) |
| Type: | Incident report | Priority: | Minor |
| Reporter: | Alexei Vladishev | Assignee: | Alexander Vladishev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: | |||
| Description |
|
When i was checking if the houskeeper was doing his job, i saw the following lines in the server logfile (old example, but still the same with 1.6.6) 6928:20090122:202631 Deleted 0 records from history and trends My google-searches gave me the indication that counting the deleted records should not be done with PQntuples() in zbx_db_vexecute (zabbix-1.6.6\src\libs\zbxdb\db.c). When deleting/inserting/updating a record, the function PQcmdTuples() should give the correct count. After modification: 30047:20090922:095640 Deleted 1273 records from history and trends Can a real programmer verify if this is the correct solution? |
| Comments |
| Comment by Alexander Vladishev [ 2009 Sep 28 ] |
|
Fixed in version pre1.6.7, rev 7983. |
| Comment by richlv [ 2009 Nov 10 ] |
|
close old, resolved issues |