summaryrefslogtreecommitdiffstats
path: root/src/zabbix_server/housekeeper
diff options
context:
space:
mode:
authorhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-12 07:01:06 +0000
committerhugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082>2006-05-12 07:01:06 +0000
commit06f68476ff0a32ab823885118054595894016f06 (patch)
treeb0f18b6058f40b4daa8aafc0c4e6995372ccaf8d /src/zabbix_server/housekeeper
parentb327677b4e405ccc71f6292fad2ff08abe2f7c99 (diff)
downloadzabbix-06f68476ff0a32ab823885118054595894016f06.tar.gz
zabbix-06f68476ff0a32ab823885118054595894016f06.tar.xz
zabbix-06f68476ff0a32ab823885118054595894016f06.zip
- fixes to zabbix_sender and other changes (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2823 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'src/zabbix_server/housekeeper')
-rw-r--r--src/zabbix_server/housekeeper/housekeeper.c4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/zabbix_server/housekeeper/housekeeper.c b/src/zabbix_server/housekeeper/housekeeper.c
index cfaba903..e22c675a 100644
--- a/src/zabbix_server/housekeeper/housekeeper.c
+++ b/src/zabbix_server/housekeeper/housekeeper.c
@@ -90,7 +90,11 @@ static int housekeeping_process_log()
housekeeper.field=row[2];
housekeeper.value=atoi(row[3]);
+#ifdef HAVE_ORACLE
+ snprintf(sql,sizeof(sql)-1,"delete from %s where %s=%d and rownum<500",housekeeper.tablename, housekeeper.field,housekeeper.value);
+#else
snprintf(sql,sizeof(sql)-1,"delete from %s where %s=%d limit 500",housekeeper.tablename, housekeeper.field,housekeeper.value);
+#endif
DBexecute(sql);
if(( deleted = DBaffected_rows()) == 0)