Failed: Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[55000]:

thank you @andypost for correcting the issue tag and adding the related issues.

sorry, I'm switching to DDEV from docker4drupal and I was confused about my environments. I've changed my DDEV's PostgreSQL config and the problem disappeared.

thanks for everything. I'm closing the issue.

Hi Orkut Murat Yilmaz,
I have exactly the same problem and cannot resolve it. Could you be more explicit on the change you made in the DDEV PostgreSQL config ?
I am currently using postgres:14 (apparently the only version that works with DDEV). Did you go to mysql to fix this issue?
Many thanks for any help, I am stucked with this!
Philippe

@planceleur, sorry for the late reply.

Yes, I was enlightened like you did and solved my problem with changing the settings.ddev.php file parameters. Thank you for making me feel not alone:)

I am using lando what changes should i make @Orkut Murat Yılmaz

@neelam_wadhwani have you checked lando's postgres config?

I had the same issue, and solved it with changing the owner in the database. First access the container with ddev ssh, then use psql to run the following:

DO $$DECLARE r RECORD;
BEGIN
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP
        EXECUTE 'ALTER TABLE IF EXISTS public.' || quote_ident(r.tablename) || ' OWNER TO db';
    END LOOP;
END$$;

I also ran this for sequences, but didn't test first if it was actually needed:

DO $$DECLARE r RECORD;
BEGIN
    FOR r IN (SELECT sequence_name FROM information_schema.sequences WHERE sequence_schema = 'public') LOOP
        EXECUTE 'ALTER SEQUENCE public.' || quote_ident(r.sequence_name) || ' OWNER TO db';
    END LOOP;
END$$;

Note: this worked for me, by help of chatGPT. It is not an area I know deeply, so do backup first and use at own risk!