Loading...
> >

Duplicate key value

Noah LGPNoah LGP Posts: 2,587
edited October 2020 in Technical Help (nuts n bolts)

Hi,

Yet another issue, Daz Studio 4.12.1.118 refuse to install these products :

  • 4826 Oriental Tranquility (DIM)
  • 12331 Umbrella Patio Table (DIM)
  • 17857 Nick (DIM)
  • 72281 dForce Le Roi Outfit Michele (Daz Connect SEP/SEA)

2020-10-18 11:44:48.725 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Query (UPDATE "product" SET name = 'dForce Le Roi Outfit Michele', default_name = 'dForce Le Roi Outfit Michele', store_id = NULL, token = '72281', artists = '', description = '', guid = 'a4fd1251-c5ed-4e2b-bc34-78ecff12fd2f', meta_hash = '91f1d5da8b8574388ea0d87969b6e89d', file_hash = '3505a33ed4e515232b51bfee47cfc0b3', thumbnail_path = 'meta/1_72281.jpg', thumbnail_hash = 'b8b06f4a7dba3cf79d1a4bfc1f0ad121', last_update = '2020-10-07 15:30:24', date_purchased = NULL, date_installed = '2020-10-18 09:44:48', release_date = '1970-01-01 00:00:00', group_num = 0, hide = 'f', is_vendor = 't', has_cloud_meta_data = 't', is_installed = 'f', is_cloud_owned = 't', needs_update = 't', normalized_name = 'dforce le roi outfit michele', normalized_name_first_letter = 'D' WHERE id = 5156) failed with exception: ERROR:  duplicate key value violates unique constraint "product_guid_key"
DETAIL:  Key (guid)=(a4fd1251-c5ed-4e2b-bc34-78ecff12fd2f) already exists.

2020-10-18 11:44:48.725 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): ERROR:  duplicate key value violates unique constraint "product_guid_key"
DETAIL:  Key (guid)=(a4fd1251-c5ed-4e2b-bc34-78ecff12fd2f) already exists.

Post edited by Noah LGP on

Comments

  • Noah LGPNoah LGP Posts: 2,587

    Fresh install on a new computer

  • Richard HaseltineRichard Haseltine Posts: 99,368

    Have you reported these?

  • Noah LGPNoah LGP Posts: 2,587
    edited October 2020

    Not yet.

    dForce Le Roi Outfit Michele is installed by using Daz Connect (online)

    Post edited by Noah LGP on
  • Noah LGPNoah LGP Posts: 2,587
    edited October 2020

    Well I reset the database now these products are installed. I have to re-install the other 5140 products (892 GB)

    Post edited by Noah LGP on
  • Noah LGPNoah LGP Posts: 2,587

    I don't think that is a good idea to force the user to download the whole library when the files are already on the computer in particular with these slow servers.

  • Richard HaseltineRichard Haseltine Posts: 99,368
    Noah LGP said:

    I don't think that is a good idea to force the user to download the whole library when the files are already on the computer in particular with these slow servers.

    Connect should see the files are there and just verify that they match those on the servers, though I admit it doesn't really look as if that reliably happens.

  • Noah LGPNoah LGP Posts: 2,587
    edited October 2020

    Everything is installed now but these products vanished once again.

    Marvelous Bodysuit (65005) and texture add-on (65021) are missing too.

     

    I think "Update Metadata" removed these products without uninstalling them properly from the database, that would explain why there is duplcate key value.

    I reset the database and reinstall the whole library.

     

    2020-10-19 00:50:59.393 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Query (UPDATE "product" SET name = 'Marvelous Bodysuit Male Super Hero Textures', default_name = 'Marvelous Bodysuit Male Super Hero Textures', store_id = 1, token = '65021', artists = '', description = '', guid = '7554794d-c13f-4892-ac27-400c4ee28a15', meta_hash = 'dea93260bd63ad29adf6174760aa06ec', file_hash = 'a32410f5522f61ccb91ba34cc7fb4278', thumbnail_path = '', thumbnail_hash = '', last_update = '2020-09-03 18:12:58', date_purchased = '2020-09-04 11:23:34', date_installed = '2020-10-18 22:50:59', release_date = '1970-01-01 00:00:00', group_num = 0, hide = 'f', is_vendor = 't', has_cloud_meta_data = 't', is_installed = 'f', is_cloud_owned = 't', needs_update = 'f', normalized_name = 'marvelous bodysuit male super hero textures', normalized_name_first_letter = 'M' WHERE id = 5317) failed with exception: ERROR:  duplicate key value violates unique constraint "product_guid_key"
    DETAIL:  Key (guid)=(7554794d-c13f-4892-ac27-400c4ee28a15) already exists.

    2020-10-19 00:50:59.393 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): ERROR:  duplicate key value violates unique constraint "product_guid_key"
    DETAIL:  Key (guid)=(7554794d-c13f-4892-ac27-400c4ee28a15) already exists.

    2020-10-19 00:50:59.393 Updated metadata for 3 of 6 items.
    2020-10-19 00:50:59.627 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): Query (UPDATE "product" SET name = 'Marvelous Bodysuit for Genesis 8 Male(s)', default_name = 'Marvelous Bodysuit for Genesis 8 Male(s)', store_id = 1, token = '65005', artists = '', description = '', guid = 'f95030a8-8d3a-45eb-ae44-6b7b0b8085a5', meta_hash = '2e1a2d36830771b4c27fd8d03fc518da', file_hash = 'c365c55ecc434584a35717f2aa6b84ca', thumbnail_path = '', thumbnail_hash = '', last_update = '2020-09-03 18:12:48', date_purchased = '2020-09-04 11:23:34', date_installed = '2020-10-18 22:50:59', release_date = '1970-01-01 00:00:00', group_num = 0, hide = 'f', is_vendor = 't', has_cloud_meta_data = 't', is_installed = 'f', is_cloud_owned = 't', needs_update = 'f', normalized_name = 'marvelous bodysuit for genesis 8 males', normalized_name_first_letter = 'M' WHERE id = 5318) failed with exception: ERROR:  duplicate key value violates unique constraint "product_guid_key"
    DETAIL:  Key (guid)=(f95030a8-8d3a-45eb-ae44-6b7b0b8085a5) already exists.

    2020-10-19 00:50:59.627 WARNING: ..\..\..\..\..\src\sdksource\cloud\dzcloudtasknotifier.cpp(178): ERROR:  duplicate key value violates unique constraint "product_guid_key"

    Post edited by Noah LGP on
  • stitlownstitlown Posts: 282

    I'm getting persistent ERROR:  duplicate key value violates unique constraint "product_guid_key" on four products that appear to be part of my 8 "Metadata update failed: 616 items succeeded, 8 items failed.". The products are:

    SET name = 'Millennium Big Cat LE', default_name = 'Millennium Big Cat LE', store_id = 1, token = '3744', artists = 'DAZ 3D',

    SET name = 'Millennium Cat LE', default_name = 'Millennium Cat LE', store_id = 1, token = '3743', artists = 'DAZ 3D',

    SET name = 'Goya HairStyle', default_name = 'Goya HairStyle', store_id = 1, token = '14101', artists = 'Neftis3D',

    SET name = 'M5 Poses 01 Standing', default_name = 'M5 Poses 01 Standing', store_id = 1, token = '14528', artists = 'Shimuzu',

    Is this anything to be concerned about / interested in?  If it is, what is the "fix".  Sounds like it might be uninstall / reinstall, but that whasn't 100% clear to me. I'm certainly not using the cats in any scene, but don't think I'm using the other two either.

    Cheers, Lx

  • Noah LGPNoah LGP Posts: 2,587
    edited July 2021

    @stitlown

    You can try to uninstall these products and delete the entries in the Content Library pane. It will force Daz Studio to re-download the metadata.

    Try to install them with another download manager (Daz Connect or DIM)

    Post edited by Noah LGP on
  • stitlownstitlown Posts: 282

    Thanks - will give it a go. Not sure how to "delete the entries in the Content Library pane" but I'm sure I'lll figure it out. :)

Sign In or Register to comment.