This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

postgres-errors after upgrade from 8.103 to 8.201

one day after upgrading...

In system messages:

-- snip --
2011:08:23-06:52:20 xyz daemon-watcher[5302]: Watching selfmonng.plx - running fine
2011:08:23-06:55:01 xyz /usr/sbin/cron[30566]: (root) CMD (   /usr/local/bin/reporter/system-reporter.pl)
2011:08:23-07:00:01 xyz /usr/sbin/cron[30650]: (root) CMD (nice -n19 /usr/local/bin/create_rrd_graphs.plx)
2011:08:23-07:00:01 xyz /usr/sbin/cron[30649]: (root) CMD (   /usr/local/bin/reporter/system-reporter.pl)
2011:08:23-07:02:01 xyz /usr/sbin/cron[30827]: (root) CMD (/sbin/audld.plx --trigger)
2011:08:23-07:02:01 xyz /usr/sbin/cron[30828]: (root) CMD (  nice -n19 /usr/local/bin/gen_inline_reporting_data.plx)
2011:08:23-07:05:01 xyz /usr/sbin/cron[30934]: (root) CMD (   /usr/local/bin/reporter/system-reporter.pl)
2011:08:23-07:08:04 xyz postgres[30992]: [2-1] ERROR:  duplicate key value violates unique constraint "websec_reqcat_request_key"
2011:08:23-07:08:04 xyz postgres[30992]: [2-2] CONTEXT:  SQL statement "insert into websec_reqcat (request, category) values ( $1 , unnest( $2 ))"
2011:08:23-07:08:04 xyz postgres[30992]: [2-3] PL/pgSQL function "ins_websecurity" line 27 at SQL statement
2011:08:23-07:08:04 xyz postgres[30992]: [2-4] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [3-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [3-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [4-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [4-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [5-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [5-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [6-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [6-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [7-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [7-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [8-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [8-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [9-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [9-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [10-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [10-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [11-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [11-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [12-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [12-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [13-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [13-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:23-07:08:04 xyz postgres[30992]: [14-1] ERROR:  current transaction is aborted, commands ignored until end of transaction block
2011:08:23-07:08:04 xyz postgres[30992]: [14-2] STATEMENT:  select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
--snap--

these errors are continously raising and filling the system-log.

don't know if this is relevant:
i don't know exactely if these problem begins when clicking the pdf-icon in Web-Sec-Report. After clicking the pdf-icon in "Web Usage Report" the result-lists shows error-messages and no results. After relogin the reporting lists are okay.

edit: Dashboard / Today's threat status / Web Filter -> Counter is broken (seems i'am not alone with this problem)

greets to all
silent

This thread was automatically locked due to age.

Parents

0 Scott_Klassen over 13 years ago
It would be a heavy handed possible solution, and you would lose any current reporting data, but you might want to try rebuilding the reporting database:

/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v
Cancel
Vote Up 0 Vote Down

Cancel
0 silentdaemon over 13 years ago in reply to Scott_Klassen
It would be a heavy handed possible solution, and you would lose any current reporting data, but you might want to try rebuilding the reporting database:

/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v

won't run.

after doing this:

2011:08:26-08:10:35 xyz postgres[14535]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:35 xyz postgres[14535]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:35 xyz ulogd[5250]: pg1: connect: FATAL: database "reporting" does not exist
2011:08:26-08:10:36 xyz postgres[14537]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:36 xyz postgres[14537]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:36 xyz syslog-ng[5901]: POLLERR occurred while idle; fd='38'
2011:08:26-08:10:40 xyz postgres[14540]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:40 xyz postgres[14540]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:40 xyz ulogd[5250]: pg1: connect: FATAL: database "reporting" does not exist
2011:08:26-08:13:26 xyz postgres[14664]: [2-1] ERROR: duplicate key value violates unique constraint "websec_reqcat_request_key"
2011:08:26-08:13:26 xyz postgres[14664]: [2-2] CONTEXT: SQL statement "insert into websec_reqcat (request, category) values ( $1 , unnest( $2 ))"
2011:08:26-08:13:26 xyz postgres[14664]: [2-3] PL/pgSQL function "ins_websecurity" line 27 at SQL statement
2011:08:26-08:13:26 xyz postgres[14664]: [2-4] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [3-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [3-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [4-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [4-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [5-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [5-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [6-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [6-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [7-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [7-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [8-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [8-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [9-1] ERROR: current transaction is aborted, commands ignored until end of transaction block

the same log-flooding as before. our users give me the message, that pdf-downloads, some banking-sites and other sites won't work through web-security. back to 8.103! [:@]

cya
Cancel
Vote Up 0 Vote Down

Cancel

Reply

0 silentdaemon over 13 years ago in reply to Scott_Klassen
It would be a heavy handed possible solution, and you would lose any current reporting data, but you might want to try rebuilding the reporting database:

/etc/init.d/postgresql stop
rm -fr /var/log/reporting/pgsql
/etc/init.d/postgresql start
mkdir /var/log/reporting/pgsql
chown postgres[:P]ostgres /var/log/reporting/pgsql
/var/storage/pgsql/init/reporting_db_init.sh -v

won't run.

after doing this:

2011:08:26-08:10:35 xyz postgres[14535]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:35 xyz postgres[14535]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:35 xyz ulogd[5250]: pg1: connect: FATAL: database "reporting" does not exist
2011:08:26-08:10:36 xyz postgres[14537]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:36 xyz postgres[14537]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:36 xyz syslog-ng[5901]: POLLERR occurred while idle; fd='38'
2011:08:26-08:10:40 xyz postgres[14540]: [2-1] FATAL: database "reporting" does not exist
2011:08:26-08:10:40 xyz postgres[14540]: [2-2] DETAIL: The database subdirectory "pg_tblspc/16546/16547" is missing.
2011:08:26-08:10:40 xyz ulogd[5250]: pg1: connect: FATAL: database "reporting" does not exist
2011:08:26-08:13:26 xyz postgres[14664]: [2-1] ERROR: duplicate key value violates unique constraint "websec_reqcat_request_key"
2011:08:26-08:13:26 xyz postgres[14664]: [2-2] CONTEXT: SQL statement "insert into websec_reqcat (request, category) values ( $1 , unnest( $2 ))"
2011:08:26-08:13:26 xyz postgres[14664]: [2-3] PL/pgSQL function "ins_websecurity" line 27 at SQL statement
2011:08:26-08:13:26 xyz postgres[14664]: [2-4] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [3-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [3-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [4-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [4-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [5-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [5-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [6-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [6-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [7-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [7-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [8-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
2011:08:26-08:13:26 xyz postgres[14664]: [8-2] STATEMENT: select ins_websecurity($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15)
2011:08:26-08:13:26 xyz postgres[14664]: [9-1] ERROR: current transaction is aborted, commands ignored until end of transaction block

the same log-flooding as before. our users give me the message, that pdf-downloads, some banking-sites and other sites won't work through web-security. back to 8.103! [:@]

cya
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data