It looks like a database problem, but I don't know squat about databases. Any ideas on how to fix? I've rebooted to no avail.
Thanks.
Here are some excerpts while watching the Live Log
The following occurs repeatedly (every 10 or 20 seconds) when Accounting is enabled in Reporting->Settings:
2009:10:25-12:38:20 Firewall postgres[4730]: [3-1] ERROR: could not open relation 16969/16519/16525: No such file or directory
2009:10:25-12:38:20 Firewall postgres[4730]: [3-2] STATEMENT: INSERT INTO public.accounting
2009:10:25-12:38:20 Firewall postgres[4730]: [3-3] (ip_saddr,ip_daddr,ip_protocol,l4_dport,raw_in_pktlen,raw_in_pktcount,raw_out_pktlen,raw_out_pktcount,flow_start_day,flow_start
2009:10:25-12:38:20 Firewall postgres[4730]: [3-4] _sec,flow_duration) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11);
2009:10:25-12:38:20 Firewall ulogd[3017]: pg1: ERROR: could not open relation 16969/16519/16525: No such file or directory
2009:10:25-12:38:25 Firewall ulogd[3017]: input key `flow.start.sec' already has source
So I disabled Accounting. In a few minutes, this burst of activity popped up:
2009:10:25-12:58:01 Firewall system: database aggregation starting
2009:10:25-12:58:01 Firewall postgres[5354]: [3-1] ERROR: column "ipid" of relation "websec_aud" does not exist at character 33
2009:10:25-12:58:01 Firewall postgres[5354]: [3-2] STATEMENT: insert into websec_aud (dayabs, ipid, clientip, userid, clientusername, serverhostname, serverdomain, duration,
2009:10:25-12:58:01 Firewall postgres[5354]: [3-3] requests, transfer, secabs) select dayabs, ipid, clientip, userid, clientusername, serverhostname, serverdomain, sum(duration),
2009:10:25-12:58:01 Firewall postgres[5354]: [3-4] sum(requests), sum(transfer), NULL from websec_aud where dayabs = $1 and secabs is not null group by ipid, clientip, userid,
2009:10:25-12:58:01 Firewall postgres[5354]: [3-5] clientusername, serverhostname, serverdomain, dayabs
2009:10:25-12:58:01 Firewall system: INSERT failed in websec_aud (day 733705)
2009:10:25-12:58:01 Firewall postgres[5354]: [4-1] ERROR: column "ipid" of relation "websec_au" does not exist at character 32
2009:10:25-12:58:01 Firewall postgres[5354]: [4-2] STATEMENT: insert into websec_au (dayabs, ipid, clientip, userid, clientusername, duration, requests, transfer, secabs) select
2009:10:25-12:58:01 Firewall postgres[5354]: [4-3] dayabs, ipid, clientip, userid, clientusername, sum(duration), sum(requests), sum(transfer), NULL from websec_au where dayabs =
2009:10:25-12:58:01 Firewall postgres[5354]: [4-4] $1 and secabs is not null group by ipid, clientip, userid, clientusername, dayabs
2009:10:25-12:58:01 Firewall system: INSERT failed in websec_au (day 733705)
.
.
.
2009:10:25-12:58:01 Firewall system: INSERT failed in websec_bud (day 733705)
2009:10:25-12:58:01 Firewall system: database aggregation finished successfully
Somehow, I don't think it was successful regardless of what it says.
Now, I get pages and pages of this sort of stuff every 15 minutes:
2009:10:25-13:02:02 Firewall postgres[5538]: [13-1] ERROR: could not open relation 16969/16519/16611: No such file or directory
2009:10:25-13:02:02 Firewall postgres[5538]: [13-2] STATEMENT: SELECT reason as extension,transform_common(CAST(sum(mailcount) AS BIGINT)) as sum_count_str,sum(mailcount) as
2009:10:25-13:02:02 Firewall postgres[5538]: [13-3] sum_count_int,transform_SI(CAST(sum(mailsize) AS BIGINT),1) as sum_size_str,sum(mailsize) as sum_size_int FROM mailsec_data
2009:10:25-13:02:02 Firewall postgres[5538]: [13-4] WHERE dayabs = 733705 AND type = 5 GROUP BY extension ORDER BY sum_count_int DESC,sum_size_int DESC LIMIT 10
2009:10:25-13:02:02 Firewall postgres[5538]: [14-1] ERROR: could not open relation 16969/16519/16611: No such file or directory
2009:10:25-13:02:02 Firewall postgres[5538]: [14-2] STATEMENT: SELECT transform_common(CAST(sum(mailcount) AS BIGINT)) as sum_count_str,sum(mailcount) as
2009:10:25-13:02:02 Firewall postgres[5538]: [14-3] sum_count_int,transform_SI(CAST(sum(mailsize) AS BIGINT),1) as sum_size_str,sum(mailsize) as sum_size_int FROM mailsec_data
2009:10:25-13:02:02 Firewall postgres[5538]: [14-4] WHERE dayabs = 733705 AND type = 5
2009:10:25-13:02:02 Firewall postgres[5538]: [15-1] ERROR: could not open relation 16969/16519/16611: No such file or directory
2009:10:25-13:02:02 Firewall postgres[5538]: [15-2] STATEMENT: SELECT reason as expression,sum(mailcount) as sum_count_int,transform_common(CAST(sum(mailcount) AS BIGINT)) as
2009:10:25-13:02:02 Firewall postgres[5538]: [15-3] sum_count_str,sum(mailsize) as sum_size_int,transform_SI(CAST(sum(mailsize) AS BIGINT),1) as sum_size_str FROM mailsec_data
2009:10:25-13:02:02 Firewall postgres[5538]: [15-4] WHERE dayabs = 733705 AND type = 6 GROUP BY expression ORDER BY sum_count_int DESC,sum_size_int DESC LIMIT 10
2009:10:25-13:02:02 Firewall postgres[5538]: [16-1] ERROR: could not open relation 16969/16519/16611: No such file or directory
2009:10:25-13:02:02 Firewall postgres[5538]: [16-2] STATEMENT: SELECT sum(mailcount) as sum_count_int,transform_common(CAST(sum(mailcount) AS BIGINT)) as
2009:10:25-13:02:02 Firewall postgres[5538]: [16-3] sum_count_str,sum(mailsize) as sum_size_int,transform_SI(CAST(sum(mailsize) AS BIGINT),1) as sum_size_str FROM mailsec_data
2009:10:25-13:02:02 Firewall postgres[5538]: [16-4] WHERE dayabs = 733705 AND type = 6
I would greatly appreciate your help. [:$]
This thread was automatically locked due to age.
