Comments (3)
We have millions of queries on this DB per day, but about once per day, we get a deadlock error with a query where we're not using locks. The query:
The error:
Deadlock found when trying to get lock; try restarting transaction
Our code uses no manually created transactions, but we're getting a transaction error, which leads me to believe the library is creating one on our behalf, and doing so incorrectly.
By default, autocommit mode is enabled in MySQL and each SQL statement forms a single transaction on its own.
It's normal to experience occasional deadlocks when you have multiple connections performing lots of updates targeting a single table. Your code should be written to detect these deadlock errors when they occur and re-run the statement.
from node-mysql2.
Are you using this driver directly or via orm / query builder? This driver does not start transactions implicitly, maybe some other layer adds that?
from node-mysql2.
Directly
from node-mysql2.
Related Issues (20)
- Timeout since 3.9.4 HOT 2
- HANDSHAKE_SSL_ERROR with RDS and 3.9.3+ HOT 12
- Can't create more than max prepared stmtount statements(current value: 16382) HOT 4
- Release 3.9.4 breaks code that depended on .hasOwnProperty() HOT 3
- got warning when host is an IP address HOT 3
- Transaction issue in my code. Please Help!
- read ECONNRESET after upgrading HOT 11
- typeCast: false causes out of bounds reads to packet when result set contains NULL values and binary protocol is used.
- README documentation HOT 1
- True negative: ssl-mode query params in connectionString considered as invalid HOT 1
- TypeError: LRU is not a constructor HOT 4
- PoolConnection.execute() retrun object v3.9.7 HOT 6
- [createConnection] Can't add new command when connection is in closed state HOT 8
- Sporadic read ETIMEDOUT error HOT 9
- Incorrect typings lead to pool.destroy is not a function HOT 2
- Invalid ssl option but still DB connection working fine HOT 1
- Access Denied after database restart (but granted after login via CLI) HOT 23
- Importing mysql2 causes source maps not working in project bundled with webpack HOT 7
- DELIMITER causes syntax error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-mysql2.