Using render.com database for migrate dev leads to error message ERROR: cannot drop view pg_buffercache because extension pg_buffercache requires it HINT: You can drop extension pg_buffercache instead.

[janpio]

2 cloud databases from render.com, then run migrate dev with some schema. Leads to this error message:

C:\Users\Jan\Documents\throwaway\repro8212>npx prisma migrate dev
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": PostgreSQL database "reproduction8212", schema "public" at "frankfurt-postgres.render.com:5432"

Error: P3016

The fallback method for database resets failed, meaning Migrate could not clean up the database entirely. Original error: 
Database error
Error querying the database: db error: ERROR: cannot drop view pg_buffercache because extension pg_buffercache requires it
HINT: You can drop extension pg_buffercache instead.
   0: sql_migration_connector::best_effort_reset
           with connection=Connection(Postgres((PostgreSql { client: PostgresClient, pg_bouncer: false, socket_timeout: None, statement_cache: Mutex { is_locked: false, has_waiters: false }, is_healthy: true }, PostgresUrl { url: Url { scheme: "postgres", username: "shadow", password: Some("..."), host: Some(Domain("frankfurt-postgres.render.com")), port: None, path: "/reproduction8212shadow", query: None, fragment: None }, query_params: PostgresUrlQueryParams { ssl_params: SslParams { certificate_file: None, identity_file: None, identity_password: <HIDDEN>, ssl_accept_mode: AcceptInvalidCerts }, connection_limit: None, schema: None, ssl_mode: Prefer, pg_bouncer: false, host: None, socket_timeout: None, connect_timeout: Some(5s), pool_timeout: Some(10s), statement_cache_size: 500, max_connection_lifetime: None, max_idle_connection_lifetime: Some(300s) } })))
             at migration-engine\connectors\sql-migration-connector\src\lib.rs:115
   1: sql_migration_connector::flavour::postgres::sql_schema_from_migration_history
             at migration-engine\connectors\sql-migration-connector\src\flavour\postgres.rs:367
   2: migration_core::api::DevDiagnostic
             at migration-engine\core\src\api.rs:89

Also: Password logged in plain text in the error message of best_effort_reset

Problem does also not go away if shadow database is not hosted at render.com

[janpio]

More information about this table (and extension): https://www.postgresql.org/docs/9.4/pgbuffercache.html

[pantharshit00]

I can reproduce this, migrate will require to ignore this extension like it ignores postgis.

[tomhoule]

Yep, we should special-case it, like postgis. Candidating.

[janpio]

Related: #8219

[worktechnotoil]

any solution for this ?

[janpio]

This should not happen any more after prisma/prisma-engines#2106. If it does, please open a new bug issue with all the informaiton the template asks for. Thanks.