MySQLConnectionHandler.swift Fatal error: unhandled packet: ByteBuffer

yong-ya commented 1 year ago

Describe the bug

Server periodically crashes with the following output:

MySQLNIO/MySQLConnectionHandler.swift:89: Fatal error: unhandled packet: ByteBuffer { readerIndex: 0, writerIndex: 145, readableBytes: 145, capacity: 145, storageCapacity: 32768, slice: _ ByteBufferSlice { 4..<149 }, storage: 0x00007f78d8037030 (32768 bytes) }

ByteBufferSlice { 4..<149 }, storage: 0x00007f78d8037030 (32768 bytes) } readable bytes (max 1k): [ ff bf 0f 23 48 59 30 30 30 54 68 65 20 63 6c 69 65 6e 74 20 77 61 73 20 64 69 73 63 6f 6e 6e 65 63 74 65 64 20 62 79 20 74 68 65 20 73 65 72 76 65 72 20 62 65 6 3 61 75 73 65 20 6f 66 20 69 6e 61 63 74 69 76 69 74 79 2e 20 53 65 65 20 77 61 69 74 5f 74 69 6d 65 6f 75 74 20 61 6e 64 20 69 6e 74 65 72 61 63 74 69 76 65 5f 74 69 6d 65 6f 75 74 20 66 6f 72 20 63 6f 6e 66 69 67 75 72 69 6e 67 20 74 68 69 73 20 62 65 68 61 76 69 6f 72 2e ]

To Reproduce

Currently uncertain but appears to occur randomly during the execution of a select statement.

Expected behavior

No crash should occur.

Environment

Versions: dependencies: [ // 💧 A server-side Swift web framework. .package(url: "https://github.com/vapor/fluent.git", from: "4.7.1"), .package(url: "https://github.com/vapor/fluent-mysql-driver.git", from: "4.2.0"), .package(url: "https://github.com/vapor/vapor.git", from: "4.75.0") ],

Swift version 5.7.1 (swift-5.7.1-RELEASE)

Distributor ID: Ubuntu Description: Ubuntu 22.04.1 LTS Release: 22.04 Codename: jammy

Additional context

Similar or identical to https://github.com/vapor/mysql-nio/issues/8

0xTim commented 1 year ago

@yong-ya what version of MySQL are you connecting to?

gwynne commented 1 year ago

This is a duplicate of #87

yong-ya commented 1 year ago

@yong-ya what version of MySQL are you connecting to?

mysql Ver 8.0.31-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

ZhangHaoKun91 commented 1 year ago

Is there any way to temporarily avoid this problem? Or which version of MySQL does not encounter this issue?

gwynne commented 1 year ago

@ZhangHaoKun91 This should have been fixed by #95, which was released in MySQLNIO version 1.6.1. Are you still seeing the problem?

ZhangHaoKun91 commented 1 year ago

@gwynne Thank you very much for your reply. My MySQL nio version is still 15.0 and I need to update it. Thank you very much.

oprisk commented 1 year ago

I'm having the same issue. SPM pulls version 1.5 from Github, not the latest 1.6.1 Any suggestion: How to override the version 1.5 to 1.6.1 effectively without override of all packages? I deleted the SPM directory and package.resolved, with the same 1.5 pulled

gwynne commented 1 year ago

@oprisk I've seen that happen when SwiftPM's configuration gets wedged. An easy way to force it is to just add the explicit dependency to your Package.swift with the version, which will either force the update (at which point you should be able to remove the extra dependency) or make it give more details about why it's not pulling the latest:

.package(url: "https://github.com/vapor/mysql-nio.git", from: "1.6.1"),

oprisk commented 1 year ago

Thanks, will update if the same issue persists. info: pulls mysql-nio version 1.7.0

vapor / mysql-nio