Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres: ERROR: cache lookup failed for type 24684 #4

Open
lnxd opened this issue Aug 5, 2023 · 0 comments
Open

Postgres: ERROR: cache lookup failed for type 24684 #4

lnxd opened this issue Aug 5, 2023 · 0 comments

Comments

@lnxd
Copy link

lnxd commented Aug 5, 2023

I am attempting to migrate to v2. v1.40 works normally, tracks normally, etc. without producing any errors.

When I try to use the migration script I get db error: ERROR: cache lookup failed for type 24684.

I've tried running the script by executing interactive sh on the latest image, v2.0.0 and v1.40. I'm using Docker version 24.0.5, build ced0996.

I'm creating this as a bug report in case anyone experiences this in the future. But as a side note, I'm happy to lose all historical data. I just don't want to have to reconfigure all websites, events, etc. To test, I have also reset all website statistics using the Umami UI, and tried running in the latest container after letting the migrations complete for v1.40.

Logs below:

/app $ npx @umami/migrate-v1-v2@latest

Need to install the following packages:
  @umami/migrate-v1-v2@0.15.0
Ok to proceed? (y)
Running v0.15.0
✓ DATABASE_URL is defined.
✓ Database connection successful.
Preparing v1 tables for migration
✓ Dropped v1 database keys.
✓ Dropped v1 database indexes.
PrismaClientKnownRequestError:
Invalid `prisma.$executeRaw()` invocation:


Raw query failed. Code: `XX000`. Message: `db error: ERROR: cache lookup failed for type 24684`
    at Zr.handleRequestError (/app/node_modules/@prisma/client/runtime/library.js:171:6414)
    at Zr.handleAndLogRequestError (/app/node_modules/@prisma/client/runtime/library.js:171:5948)
    at Zr.request (/app/node_modules/@prisma/client/runtime/library.js:171:5786)
    at async Proxy._request (/app/node_modules/@prisma/client/runtime/library.js:174:10455) {
  code: 'P2010',
  clientVersion: '4.11.0',
  meta: {
    code: 'XX000',
    message: 'db error: ERROR: cache lookup failed for type 24684'
  }
}
✗ Failed to rename v1 database tables.
npm notice
npm notice New minor version of npm available! 9.5.0 -> 9.8.1
npm notice Changelog: https://github.com/npm/cli/releases/tag/v9.8.1
npm notice Run npm install -g npm@9.8.1 to update!
npm notice

Thanks in advance for any help!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant