Hi, i had some problems with my raidcontroler on my XENserver (two weeks ago).
Today it seemed the mail delivery has been stopped but i could not find out why.
It seemed the astaro box was not working the way it should but ... after a restart the mail was running again (i use astaro as a mailproxy for home usage).
When i examined the logging i found out a lot of logging about postgres.. is this normal?
It seems to me the astaro appliance is not working ok ...
3]: [1173-2] STATEMENT: SELECT transform_common(CAST(sum(flow_count) AS BIGINT)) as cnt_flow_str, sum(flow_count) as cnt_flow_int, transform_SI(CAST(sum(raw_in_pktlen+raw_out_pktlen) AS BIGINT),1) as sum_tra_total_str, sum(raw_in_pktlen+raw_out_pktlen) as sum_tra_total_int, transform_common(CAST(sum(raw_in_pktcount+raw_out_pktcount) AS BIGINT)) as sum_pktcount_str, sum(raw_in_pktcount+raw_out_pktcount) as sum_pktcount_int FROM accounting WHERE logday = '2011-04-11'
2011:04:11-21:02:02 fw postgres[13163]: [1174-1] ERROR: invalid page header in block 0 of relation pg_tblspc/16549/16550/16615
2011:04:11-21:02:02 fw postgres[13163]: [1174-2] STATEMENT: SELECT ip2country(dstip) as dstcountry, dstip, transform_common(CAST(sum(flow_count) AS BIGINT)) as cnt_flow_str, sum(flow_count) as cnt_flow_int, transform_SI(CAST(sum(raw_in_pktlen+raw_out_pktlen) AS BIGINT),1) as sum_tra_total_str, sum(raw_in_pktlen+raw_out_pktlen) as sum_tra_total_int, transform_common(CAST(sum(raw_in_pktcount+raw_out_pktcount) AS BIGINT)) as sum_pktcount_str, sum(raw_in_pktcount+raw_out_pktcount) as sum_pktcount_int FROM accounting WHERE logday = '2011-04-11' GROUP BY dstip ORDER BY sum_tra_total_int DESC, cnt_flow_int DESC LIMIT 10
2011:04:11-21:02:02 fw postgres[13163]: [1175-1] ERROR: invalid page header in block 0 of relation pg_tblspc/16549/16550/16615
2011:04:11-21:02:02 fw postgres[13163]: [1175-2] STATEMENT: SELECT transform_common(CAST(sum(flow_count) AS BIGINT)) as cnt_flow_str, sum(flow_count) as cnt_flow_int, transform_SI(CAST(sum(raw_in_pktlen+raw_out_pktlen) AS BIGINT),1) as sum_tra_total_str, sum(raw_in_pktlen+raw_out_pktlen) as sum_tra_total_int, transform_common(CAST(sum(raw_in_pktcount+raw_out_pktcount) AS BIGINT)) as sum_pktcount_str, sum(raw_in_pktcount+raw_out_pktcount) as sum_pktcount_int FROM accounting WHERE logday = '2011-04-11'
2011:04:11-21:02:02 fw postgres[13164]: [1170-1] WARNING: 1 attrdef record(s) missing for rel pfilter at character 252
2011:04:11-21:02:02 fw postgres[13164]: [1171-1] WARNING: 1 attrdef record(s) missing for rel ips at character 606
2011:04:11-21:02:02 fw postgres[13165]: [1170-1] WARNING: 1 attrdef record(s) missing for rel imp2p at character 346
2011:04:11-21:02:02 fw postgres[13166]: [1170-1] WARNING: 1 attrdef record(s) missing for rel mailsec
2011:04:11-21:02:02 fw postgres[13166]: [1171-1] WARNING: 1 attrdef record(s) missing for rel mailanon_addrs
2011:04:11-21:02:02 fw postgres[13166]: [1172-1] WARNING: 1 attrdef record(s) missing for rel mailanon_domains
2011:04:11-21:02:02 fw postgres[13167]: [1170-1] WARNING: 1 attrdef record(s) missing for rel websec_au
2011:04:11-21:02:02 fw postgres[13167]: [1171-1] WARNING: 1 attrdef record(s) missing for rel webanon_clients
2011:04:11-21:02:02 fw postgres[13167]: [1172-1] WARNING: 1 attrdef record(s) missing for rel webanon_users
2011:04:11-21:02:02 fw postgres[13167]: [1173-1] WARNING: 1 attrdef record(s) missing for rel websec_aud
2011:04:11-21:02:02 fw postgres[13167]: [1174-1] WARNING: 1 attrdef record(s) missing for rel websec_bud
2011:04:11-21:02:02 fw postgres[13168]: [1170-1] WARNING: 1 attrdef record(s) missing for rel pfilter at character 104
2011:04:11-21:02:02 fw postgres[13168]: [1171-1] WARNING: 1 attrdef record(s) missing for rel ips at character 146
2011:04:11-21:02:02 fw postgres[13169]: [1170-1] WARNING: 1 attrdef record(s) missing for rel mailsec
2011:04:11-21:02:02 fw postgres[13169]: [1171-1] WARNING: 1 attrdef record(s) missing for rel mailanon_addrs
2011:04:11-21:02:02 fw postgres[13169]: [1172-1] WARNING: 1 attrdef record(s) missing for rel mailanon_domains
2011:04:11-21:02:02 fw postgres[13170]: [1170-1] WARNING: 1 attrdef record(s) missing for rel websec_aud
2011:04:11-21:02:02 fw postgres[13170]: [1171-1] WARNING: 1 attrdef record(s) missing for rel webanon_clients
2011:04:11-21:02:02 fw postgres[13170]: [1172-1] WARNING: 1 attrdef record(s) missing for rel webanon_users
2011:04:11-21:02:02 fw postgres[13170]: [1173-1] WARNING: 1 attrdef record(s) missing for rel websec_bud
2011:04:11-21:02:02 fw postgres[13171]: [1170-1] WARNING: 1 attrdef record(s) missing for rel vpn at character 652
2011:04:11-21:02:02 fw postgres[13172]: [1170-1] WARNING: 1 attrdef record(s) missing for rel waf at character 317
2011:04:11-21:02:02 fw postgres[13172]: [1171-1] WARNING: 1 attrdef record(s) missing for rel waf_events at character 214
2011:04:11-21:02:02 fw postgres[13177]: [1170-1] WARNING: 1 attrdef record(s) missing for rel vpn at character 652
2011:04:11-21:02:02 fw postgres[13179]: [1170-1] WARNING: 1 attrdef record(s) missing for rel waf at character 207
2011:04:11-21:02:02 fw postgres[13179]: [1171-1] WARNING: 1 attrdef record(s) missing for rel waf_events at character 234
2011:04:11-21:02:04 fw postgres[13182]: [1170-1] WARNING: 2 attrdef record(s) missing for rel accounting at character 8
2011:04:11-21:02:04 fw postgres[13182]: [1170-2] QUERY: update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 , raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and dstip = $7 and ip_protocol = $8 and l4_dport = $9
2011:04:11-21:02:04 fw postgres[13182]: [1170-3] CONTEXT: PL/pgSQL function "ins_accounting" line 6 at SQL statement
2011:04:11-21:02:04 fw ulogd[5892]: pg1: server closed the connection unexpectedly
2011:04:11-21:02:04 fw ulogd[5892]: pg1: no connection to the server
2011:04:11-21:02:04 fw postgres[5834]: [1170-1] LOG: server process (PID 13182) was terminated by signal 11: Segmentation fault
2011:04:11-21:02:04 fw postgres[5834]: [1171-1] LOG: terminating any other active server processes
2011:04:11-21:02:04 fw postgres[13180]: [1170-1] WARNING: terminating connection because of crash of another server process
2011:04:11-21:02:04 fw postgres[13180]: [1170-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2011:04:11-21:02:04 fw postgres[13180]: [1170-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011:04:11-21:02:04 fw postgres[13153]: [1170-1] WARNING: terminating connection because of crash of another server process
2011:04:11-21:02:04 fw postgres[13153]: [1170-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
2011:04:11-21:02:04 fw postgres[13153]: [1170-3] HINT: In a moment you should be able to reconnect to the database and repeat your command.
2011:04:11-21:02:04 fw postgres[5834]: [1172-1] LOG: all server processes terminated; reinitializing
2011:04:11-21:02:04 fw postgres[13184]: [1173-1] LOG: database system was interrupted; last known up at 2011-04-11 21:01:58 CEST
2011:04:11-21:02:04 fw postgres[13184]: [1174-1] LOG: database system was not properly shut down; automatic recovery in progress
2011:04:11-21:02:04 fw postgres[13184]: [1175-1] LOG: redo starts at 1/7FE68704
2011:04:11-21:02:04 fw postgres[13184]: [1176-1] LOG: record with zero length at 1/7FE7A5EC
2011:04:11-21:02:04 fw postgres[13184]: [1177-1] LOG: redo done at 1/7FE7A5C0
2011:04:11-21:02:04 fw postgres[13184]: [1178-1] LOG: last completed transaction was at log time 2011-04-11 19:02:03.682105+00
2011:04:11-21:02:04 fw postgres[13187]: [1173-1] FATAL: the database system is in recovery mode
2011:04:11-21:02:04 fw postgres[13188]: [1173-1] FATAL: the database system is in recovery mode
2011:04:11-21:02:04 fw postgres[13189]: [1173-1] FATAL: the database system is in recovery mode
2011:04:11-21:02:04 fw postgres[13192]: [1173-1] LOG: autovacuum launcher started
2011:04:11-21:02:04 fw postgres[5834]: [1173-1] LOG: database system is ready to accept connections
2011:04:11-21:02:10 fw postgres[13205]: [1174-1] WARNING: 2 attrdef record(s) missing for rel accounting at character 8
2011:04:11-21:02:10 fw postgres[13205]: [1174-2] QUERY: update accounting set raw_in_pktlen = raw_in_pktlen + $1 , raw_in_pktcount = raw_in_pktcount + $2 , raw_out_pktlen = raw_out_pktlen + $3 , raw_out_pktcount = raw_out_pktcount + $4 , flow_count = flow_count + 1 where logday = $5 and srcip = $6 and dstip = $7 and ip_protocol = $8 and l4_dport = $9
2011:04:11-21:02:10 fw postgres[13205]: [1174-3] CONTEXT: PL/pgSQL function "ins_accounting" line 6 at SQL statement
2011:04:11-21:02:10 fw ulogd[5892]: pg1: server closed the connection unexpectedly
2011:04:11-21:02:10 fw ulogd[5892]: pg1: no connection to the server
2011:04:11-21:02:10 fw postgres[5834]: [1174-1] LOG: server process (PID 13205) was terminated by signal 11: Segmentation fault
2011:04:11-21:02:10 fw postgres[5834]: [1175-1] LOG: terminating any other active server processes
2011:04:11-21:02:10 fw postgres[13202]: [1174-1] WARNING: terminating connection because of crash of another server process
2011:04:11-21:02:10 fw postgres[13202]: [1174-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
This thread was automatically locked due to age.