-
Incident report
-
Resolution: Incomplete
-
Blocker
-
None
-
2.4.0
-
None
-
FreeBSD 10.0-RELEASE-p9,x64
psql (PostgreSQL) 9.3.5, with table partitions
Hi support,
Get this error during database updates.
31515:20140917:163413.167 completed 27% of database upgrade 31515:20140917:163413.241 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: cannot drop table history_sync because other objects depend on it DETAIL: default for table tpl_history_sync column id depends on sequence history_sync_id_seq table partitions.history_sync_20140904 depends on table history_sync
table partitions.history_sync_20140918 depends on table history_sync
HINT: Use DROP ... CASCADE to drop the dependent objects too.
[drop table history_sync]
31515:20140917:163413.243 completed 28% of database upgrade
31515:20140917:163413.243 database upgrade fully completed
31515:20140917:163413.273 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: column "bulk" does not exist
LINE 1: ...ct interfaceid,hostid,type,main,useip,ip,dns,port,bulk from ...
^
[select interfaceid,hostid,type,main,useip,ip,dns,port,bulk from interface]
31661:20140917:163414.880 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: column t.headers does not exist
LINE 1: ...tid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,...
^
[select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries,t.ssl_cert_file,t.ssl_key_file,t.ssl_k
31660:20140917:163414.881 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: column t.headers does not exist
LINE 1: ...tid,h.host,h.name,t.httptestid,t.name,t.variables,t.headers,...
^
table partitions may be a problem.
here only help a db restore from the latest db backup v.2.2.5