Skip to content

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

Open
@igorcoding

Description

@igorcoding

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
...

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions