mysql1_dart icon indicating copy to clipboard operation
mysql1_dart copied to clipboard

[WARNING] MySqlConnection: Error sending quit on connection Bad state: Cannot write to socket, it is closed #0

Open luX0r-reload opened this issue 5 years ago • 2 comments

Hi. I'm trying to call a simple stored procedure:

Future<List<User>> getUsers() async {
    final conn = await MySqlConnection.connect(Config.dbConnectionSettings);

    const query = "CALL `getUsers`();";

    final results = await conn.query(query);
    final List<User> users = [];
    for (var row in results) {
      users.add(User.fromRow(row));
    }
    await conn.close();
    return users;
  }

It works but bring up a WARNING:

[WARNING] MySqlConnection: Error sending quit on connection Bad state: Cannot write to socket, it is closed #0 BufferedSocket.writeBufferPart (package:mysql1/src/buffered_socket.dart:119:7)

This warning only appears if stored procedure is used.

Any suggest to avoid it?

Thanks

luX0r-reload avatar Jun 27 '20 12:06 luX0r-reload

Anybody?

luX0r-reload avatar Jul 03 '20 09:07 luX0r-reload

@luX0r-reload have you resolved this issue? I'm struggling with this one

Fraa-124 avatar Jan 17 '22 13:01 Fraa-124