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

Regression: Prisma 3.15.0 with macOS / Azure SQL Server errors at database connection #13673

Closed
Jolg42 opened this issue Jun 7, 2022 · 4 comments · Fixed by prisma/prisma-engines#2964
Assignees
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/regression A reported bug in functionality that used to work before. team/schema Issue for team Schema. topic: Azure SQL Server topic: macos
Milestone

Comments

@Jolg42
Copy link
Member

Jolg42 commented Jun 7, 2022

Bug description

db pull errors with Error: Error in connector: Error querying the database: Error querying the database: The server terminated the connection.

Prisma Client errors with Server has closed the connection.

It only happens since internal dev version 3.15.0-dev.44 and up

I could find an error with the same error message:
#13305

And since it was introduced in dev 44, it's very likely from this change prisma/prisma-engines#2952

How to reproduce

Use an Azure SQL Server database and

npx prisma db pull
Prisma schema loaded from prisma/schema.prisma
Datasource "db" - SQL Server

✖ Introspecting based on datasource defined in prisma/schema.prisma

Error: Error in connector: Error querying the database: Error querying the database: The server terminated the connection.

or create a query with Prisma Client

Expected behavior

No response

Prisma information

Environment & setup

  • OS: macOS
  • Database: Azure SQL Server
  • Node.js version: 16.10.0

The SQL server behind has this config

select @@version as version;
Microsoft SQL Azure (RTM) - 12.0.2000.8 
	Feb 23 2022 11:32:53 
	Copyright (C) 2021 Microsoft Corporation

SELECT name, compatibility_level FROM sys.databases;
Compatibility level 150

Prisma Version

npx prisma -v
prisma                  : 3.15.0-dev.51
@prisma/client          : 3.15.0-dev.51
Current platform        : darwin
Query Engine (Node-API) : libquery-engine b9297dc3a59307060c1c39d7e4f5765066f38372 (at node_modules/@prisma/engines/libquery_engine-darwin.dylib.node)
Migration Engine        : migration-engine-cli b9297dc3a59307060c1c39d7e4f5765066f38372 (at node_modules/@prisma/engines/migration-engine-darwin)
Introspection Engine    : introspection-core b9297dc3a59307060c1c39d7e4f5765066f38372 (at node_modules/@prisma/engines/introspection-engine-darwin)
Format Binary           : prisma-fmt b9297dc3a59307060c1c39d7e4f5765066f38372 (at node_modules/@prisma/engines/prisma-fmt-darwin)
Default Engines Hash    : b9297dc3a59307060c1c39d7e4f5765066f38372
Studio                  : 0.462.0
@Jolg42 Jolg42 added bug/2-confirmed Bug has been reproduced and confirmed. kind/bug A reported bug. kind/regression A reported bug in functionality that used to work before. team/schema Issue for team Schema. topic: Azure SQL Server labels Jun 7, 2022
@Jolg42 Jolg42 added this to the 4.0.x milestone Jun 7, 2022
@pimeys
Copy link
Contributor

pimeys commented Jun 7, 2022

Will be fixed in a 3.15.1 patch release, stay tuned 🎶

@janpio janpio removed the kind/bug A reported bug. label Jun 7, 2022
Jolg42 pushed a commit that referenced this issue Jun 8, 2022
@Jolg42
Copy link
Member Author

Jolg42 commented Jun 8, 2022

Reopening until patch is published.

@Jolg42 Jolg42 reopened this Jun 8, 2022
@pantharshit00
Copy link
Contributor

Patch has been published

@Jolg42
Copy link
Member Author

Jolg42 commented Jun 9, 2022

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug/2-confirmed Bug has been reproduced and confirmed. kind/regression A reported bug in functionality that used to work before. team/schema Issue for team Schema. topic: Azure SQL Server topic: macos
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants