Last Modified: Oct 16, 2023
Affected Product(s):
BIG-IP LTM
Known Affected Versions:
12.0.0, 12.0.0 HF1, 12.1.0 HF1, 12.0.0 HF2, 12.1.0 HF2, 12.0.0 HF3, 12.0.0 HF4, 12.1.1 HF1, 12.1.1 HF2, 12.1.2 HF1, 12.1.2 HF2, 12.1.0, 12.1.1, 12.1.2, 12.1.3, 12.1.3.1, 12.1.3.2, 12.1.3.3, 12.1.3.4, 12.1.3.5, 12.1.3.6, 12.1.3.7, 12.1.4, 12.1.4.1, 12.1.5, 12.1.5.1, 12.1.5.2, 12.1.5.3, 12.1.6, 13.0.0, 13.0.0 HF1, 13.0.0 HF2, 13.0.0 HF3, 13.0.1
Opened: Oct 05, 2017 Severity: 4-Minor Related Article:
K25417808
Running 'load sys config merge verify' will add new users to the PostGres database. The system posts an error similar to the following: 010719a2:3: PostgreSQL database error: ERROR: duplicate key value violates unique constraint "auth_user_pkey" DETAIL: Key (name)=(admin1) already exists.
It is not possible to use the verify argument when using 'load sys config merge' with configurations containing user definitions. 'verify' argument to 'load sys config' does not prevent or rollback side effects
Issue occurs only under the following conditions: -- 'load config merge verify' of configurations including user definition. -- Attempt to create user with same name using 'load config merge', 'create user', or GUI options.
Manually remove the user data from the PSQL database; from a bash prompt: psql -U postgres \c tmdb DELETE FROM auth_user WHERE name='admin1'; DROP OWNED BY admin1; DROP ROLE admin1; DROP SCHEMA admin1 CASCADE; \q
None