Skip to content

'Lost connection to MySQL server during query' while executing query in pool #12

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

Open
igorcoding opened this issue Nov 26, 2016 · 0 comments
Labels
bug Something isn't working

Comments

@igorcoding
Copy link

Problem is that when trying to execute query using pool (created by mysql.pool_create) the following error is raised: error: Lost connection to MySQL server during query.
Doing the exact same query inside a connection created by mysql.connect goes fine.
This is a log of what I see:

 $ tarantool
tarantool: version 1.7.2-282-g45423ce
type 'help' for interactive help
tarantool> mysql = require('mysql')
---
...

tarantool> pool = mysql.pool_create({ host = '127.0.0.1', user = '<user>', password = '<pass>', db = '<db>', size = 2 })
---
...

tarantool> pool
---
- host: 127.0.0.1
  db: <db>
  size: 2
  pass: '<pass>'
  user: <user>
  queue: 'channel: 2'
  usable: true
...

tarantool> conn = pool:get()
---
...

tarantool> conn
---
- queue: 'channel: 1'
  __gc_hook: null
  usable: true
  conn: 'MYSQL: 0x01cb5070'
...

tarantool> conn:execute("SELECT ? AS a, 'xx' AS b, NULL as c", 42)
---
- error: Lost connection to MySQL server during query
...

@Totktonada Totktonada added the bug Something isn't working label Jul 8, 2020
@Totktonada Totktonada added backlog Issues for upcoming releases (to be done soon) prio5 teamE labels Dec 21, 2020
@LeonidVas LeonidVas removed prio5 backlog Issues for upcoming releases (to be done soon) labels Oct 5, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

4 participants