Madhan Neethiraj created RANGER-4885:
----------------------------------------
Summary: upgrade from 2.4.0 to 2.5.0 fails due to missing column
Key: RANGER-4885
URL: https://issues.apache.org/jira/browse/RANGER-4885
Project: Ranger
Issue Type: Bug
Components: Ranger
Affects Versions: 2.5.0
Reporter: Madhan Neethiraj
Assignee: Madhan Neethiraj
Apache Ranger 2.5.0 upgraded from 2.4.0 fails during startup with the following
error:
{noformat}
2024-08-01 18:24:05,193 [I] java patch
PatchForOzoneServiceDefConfigUpdate_J10051 is being applied..
log4j:WARN No appenders could be found for logger
(org.apache.ranger.patch.PatchForOzoneServiceDefConfigUpdate_J10051).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more
info.
[EL Warning]: metadata: 2024-08-01 18:24:06.907--ServerSession(1578026015)--You
have specified multiple ids for the entity class
[org.apache.ranger.entity.view.VXXPrincipal] without specifying an @IdClass. By
doing this you may lose the ability to find by identity, distributed cache
support etc. Note: You may however use EntityManager find operations by passing
a list of primary key fields. Else, you will have to use JPQL queries to read
your entities. For other id options see @PrimaryKey.
[EL Warning]: 2024-08-01 18:24:07.888--UnitOfWork(712753515)--Exception
[EclipseLink-4002] (Eclipse Persistence Services -
2.7.12.v20230209-e5c4074ef3):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "category"
does not exist
Position: 25
Error Code: 0
Call: SELECT id, ADDED_BY_ID, category, CREATE_TIME, datamask_options, def_id,
item_id, label, name, sort_order, rb_key_label, rowfilter_options, UPDATE_TIME,
UPD_BY_ID FROM x_access_type_def WHERE (def_id = ?) ORDER BY sort_order
bind => [1 parameter bound]
Query: ReadAllQuery(name="XXAccessTypeDef.findByServiceDefId"
referenceClass=XXAccessTypeDef sql="SELECT id, ADDED_BY_ID, category,
CREATE_TIME, datamask_options, def_id, item_id, label, name, sort_order,
rb_key_label, rowfilter_options, UPDATE_TIME, UPD_BY_ID FROM x_access_type_def
WHERE (def_id = ?) ORDER BY sort_order")
[EL Warning]: 2024-08-01 18:24:07.893--UnitOfWork(712753515)--Exception
[EclipseLink-4002] (Eclipse Persistence Services -
2.7.12.v20230209-e5c4074ef3):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: current
transaction is aborted, commands ignored until end of transaction block
Error Code: 0
...
...
[EL Warning]: 2024-08-01 18:24:08.194--UnitOfWork(1608894091)--Exception
[EclipseLink-4002] (Eclipse Persistence Services -
2.7.12.v20230209-e5c4074ef3):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "category"
does not exist
Position: 25
Error Code: 0
Call: SELECT id, ADDED_BY_ID, category, CREATE_TIME, datamask_options, def_id,
item_id, label, name, sort_order, rb_key_label, rowfilter_options, UPDATE_TIME,
UPD_BY_ID FROM x_access_type_def WHERE (def_id = ?) ORDER BY sort_order
bind => [1 parameter bound]
Query: ReadAllQuery(name="XXAccessTypeDef.findByServiceDefId"
referenceClass=XXAccessTypeDef sql="SELECT id, ADDED_BY_ID, category,
CREATE_TIME, datamask_options, def_id, item_id, label, name, sort_order,
rb_key_label, rowfilter_options, UPDATE_TIME, UPD_BY_ID FROM x_access_type_def
WHERE (def_id = ?) ORDER BY sort_order")
2024-08-01 18:24:08,227 [JISQL] /usr/lib/jvm/java-8-openjdk-arm64/bin/java
-cp /usr/share/java/postgresql.jar:/opt/ranger/ranger-2.5.0-admin/jisql/lib/*
org.apache.util.sql.Jisql -driver postgresql -cstring
jdbc:postgresql://ranger-db/ranger -u rangeradmin -p '********' -noheader -trim
-c \; -query "delete from x_db_version_h where version = 'J10051' and active =
'N' and updated_by='ranger.example.com';"
2024-08-01 18:24:08,308 [E] applying java patch
PatchForOzoneServiceDefConfigUpdate_J10051 failed
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
