IBM Support

IJ22716: QCHANGE_NETSETUP FAILS WITH 'ERROR: DUPLICATE KEY VALUE VIOLATES UNIQUE CONSTRAINT 'MANAGEDHOST_IP_KEY'

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • The qchange_netsetup script fails when attempting to change a
    QRadar console's IP address to an IP that exists as a deleted
    Managed Host in the database.
    Messages similar to the following might be visible in
    /var/log/qradar.log when this issue is occurring:
    [hostcontext.hostcontext] [main] Caused by:
    [hostcontext.hostcontext] [main] <openjpa-2.4.3-r422266:1833086
    fatal store error>
    org.apache.openjpa.persistence.EntityExistsException: ERROR:
    duplicate key value violates unique constraint
    "managedhost_ip_key"
      Detail: Key (ip)=(127.0.0.1) already exists. {prepstmnt
    -1085858985 UPDATE ManagedHost SET ip = ? WHERE id = ?}
    [code=0, state=23505]
    FailedObject:
    com.q1labs.core.dao.platform.registry.ManagedHost-53
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.jav
    a:4988)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDic
    tionary.java:4963)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions
    .java:133)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions
    .java:75)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus
    hAndUpdate(PreparedStatementManagerImpl.java:144)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerI
    mpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus
    hInternal(PreparedStatementManagerImpl.java:100)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus
    h(PreparedStatementManagerImpl.java:88)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Con
    straintUpdateManager.java:550)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(Con
    straintUpdateManager.java:107)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.f
    lush(BatchingConstraintUpdateManager.java:59)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(Abstr
    actUpdateManager.java:104)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(Abstr
    actUpdateManager.java:77)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreM
    anager.java:731)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.kernel.DelegatingStoreManager.flush(Delegatin
    gStoreManager.java:131)
    [hostcontext.hostcontext] [main]    ... 13 more
    [hostcontext.hostcontext] [main] Caused by:
    [hostcontext.hostcontext] [main]
    org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR:
    duplicate key value violates unique constraint
    "managedhost_ip_key"
      Detail: Key (ip)=(127.0.0.1) already exists. {prepstmnt
    -1085858985 UPDATE ManagedHost SET ip = ? WHERE id = ?}
    [code=0, state=23505]
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(Logg
    ingConnectionDecorator.java:218)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(Logg
    ingConnectionDecorator.java:194)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$10
    00(LoggingConnectionDecorator.java:58)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingCo
    nnection$LoggingPreparedStatement.executeUpdate(LoggingConnectio
    nDecorator.java:1133)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeU
    pdate(DelegatingPreparedStatement.java:275)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeU
    pdate(DelegatingPreparedStatement.java:275)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedSt
    atement.executeUpdate(JDBCStoreManager.java:1791)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.exec
    uteUpdate(PreparedStatementManagerImpl.java:268)
    [hostcontext.hostcontext] [main]    at
    org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flus
    hAndUpdate(PreparedStatementManagerImpl.java:119)
    [hostcontext.hostcontext] [main]    ... 23 more
    [hostcontext.hostcontext] [pool-1-thread-4]
    com.ibm.si.application.platform.exception.ApplicationPlatformSer
    viceException: Unable to start application with id [qapp-1051]
    on host [8e634203e32e3588ed7c.localdeployment] with port
    [9000], r
    esponseCode [0], responseBody [null]
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.processEx
    ception(ConManPlatformService.java:389)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.startApp(
    ConManPlatformService.java:554)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.hostcontext.app.tasks.conman.PlatformStartAppTask.run
    Task(PlatformStartAppTask.java:54)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.frameworks.taskmanagement.Task.run(Task.java:108)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    java.util.concurrent.Executors$RunnableAdapter.call(Executors.ja
    va:522)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    java.util.concurrent.FutureTask.run(FutureTask.java:277)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExec
    utor.java:1160)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExe
    cutor.java:635)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    java.lang.Thread.run(Thread.java:812)
    [hostcontext.hostcontext] [pool-1-thread-4] Caused by:
    [hostcontext.hostcontext] [pool-1-thread-4]
    com.ibm.si.api.workload.v1.ApiException:
    java.net.UnknownHostException:
    8e634203e32e3588ed7c.localdeployment
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.api.workload.v1.ApiClient.execute(ApiClient.java:844)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.api.workload.v1.api.WorkloadsApi.showWorkloadByIdWith
    HttpInfo(WorkloadsApi.java:500)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.api.workload.v1.api.WorkloadsApi.showWorkloadById(Wor
    kloadsApi.java:486)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.getAppsWo
    rkload(ConManPlatformService.java:348)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.buildWork
    load(ConManPlatformService.java:404)
    hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.buildWork
    load(ConManPlatformService.java:399)
    [hostcontext.hostcontext] [pool-1-thread-4]    at
    com.ibm.si.application.conman.v1.ConManPlatformService.startApp(
    ConManPlatformService.java:527)
    [hostcontext.hostcontext] [pool-1-thread-4]    ... 7 more
    [tomcat.tomcat] [gui_app_startup_thread]
    com.q1labs.uiframeworks.util.ApplicationStartupThread: [ERROR]
    [NOT:0000003000][127.0.0.1253.7.60/- -] [-/- -]Error occurred
    processing [QRadar Assistant] 1051
    [tomcat.tomcat] [gui_app_startup_thread]
    com.q1labs.restapi_annotations.content.exceptions.endpointExcept
    ions.ServerProcessingException: An error occurred setting app
    status to [RUNNING]. Task state found to be [EXCEPTION].
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.application.api.service.status.handlers.
    RunningStatusHandler.handleStatus(RunningStatusHandler.java:99)
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.application.api.service.DefaultApplicati
    onAPIService.updateAppStatus(DefaultApplicationAPIService.java:5
    05)
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.application.api.service.DefaultApplicati
    onAPIService.updateAppStatus(DefaultApplicationAPIService.java:4
    62)
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.util.ApplicationStartupThread.processRun
    ningApplication(ApplicationStartupThread.java:148)
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.util.ApplicationStartupThread.processApp
    lications(ApplicationStartupThread.java:127)
    [tomcat.tomcat] [gui_app_startup_thread]    at
    com.q1labs.uiframeworks.util.ApplicationStartupThread.run(Applic
    ationStartupThread.java:89)
    

Local fix

  • Contact Support for a possible workaround that might address
    this issue in some instances.
    

Problem summary

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Problem conclusion

  • This issue was fixed in QRadar QRM QVM release of 7.4.3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ22716

  • Reported component name

    QRADAR SOFTWARE

  • Reported component ID

    5725QRDSW

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-02-12

  • Closed date

    2021-05-25

  • Last modified date

    2021-05-25

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    QRADAR SOFTWARE

  • Fixed component ID

    5725QRDSW

Applicable component levels

[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSBQAC","label":"IBM Security QRadar SIEM"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720"}]

Document Information

Modified date:
26 May 2021