org.hibernate.HibernateException: More than one row with the given identifier was found

Options
nakhoe
nakhoe Registered Posts: 9 ✭✭

After trying creating EC2 instances on Fleet Manager, the almost all Fleet Manager menu (Instances-All, Instance templates, virtual networks, License management, etc) shows an error below.

I guess the Instance Ids from AWS EC2 servers were duplicated and it causes the error.

However, I can't find any database for Fleet Manager in order to delete duplicate identifier "li-4ffhM74ai1Ko"

How do I solve the problem?

---------------------------------------------------------------------------------

Oops: an unexpected error occurred

org.hibernate.HibernateException: More than one row with the given identifier was found: li-4ffhM74ai1Ko, for class: com.dataiku.fm.model.db.PhysicalInstance, caused by: HibernateException: More than one row with the given identifier was found: li-4ffhM74ai1Ko, for class: com.dataiku.fm.model.db.PhysicalInstance
Please see our options for getting help

HTTP code: 500, type: javax.persistence.PersistenceException


Operating system used: Linux (centos)

Tagged:

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker
    Options

    Hi @Nake
    ,
    If you haven't done so already, could you please open a support ticket with the diagnostics of the fleet manager and dump the database? So we can try to understand how you ended up in this situation in the first place.

    The FM instance has an SQL database, which can be accessed as the dataiku user with psql. We wouldn't recommend performing any changes directly to the database without specific guidance from support.

    To obtain a dump:

    pg_dump -a -t public.* -f /home/dataiku/dump_data.sql dataiku

    Kind Regards,


  • nakhoe
    nakhoe Registered Posts: 9 ✭✭
    Options

    Hi, AlexT,

    I opened a support ticket and dealt with it, successfully. (deleted the duplcated one)

    Thank you for your support.

    Best Regards

Setup Info
    Tags
      Help me…