Error 1156 "Got packets out of order" when connecting to a remote database.

[keith555]

Hi, I'm not clear whether this is intended only for accessing local databases, or if it can be used with remote databases. When I run the example program against a database on Amazon EC2 instance, I get a "Got packets out of order" exception.

Unhandled exception:
Error 1156 (08S01): Got packets out of order
#0      Handler.checkResponse
package:mysql1/…/handlers/handler.dart:77
#1      QueryStreamHandler.processResponse
package:mysql1/…/query/query_stream_handler.dart:50
#2      ReqRespConnection._handleData
package:mysql1/src/single_connection.dart:349
#3      ReqRespConnection._handleHeader
package:mysql1/src/single_connection.dart:318
<asynchronous suspension>
#4      ReqRespConnection._readPacket
package:mysql1/src/single_connection.dart:303
<asynchronous suspension>

Exited (255)

[mayur-16]

i cleared the issue using this step.. now app is working perfectly fine even without opening work bench to create local mysql instance.

[PurshuRana]

i cleared the issue using this step.. now app is working perfectly fine even without opening work bench to create local mysql instance.

thanks my issue solved as well

[caiohamamuraIFSP]

This is not a solution, maybe for development purposes, but in production you usually don't have control over the database installation and DB admins won't be happy to rollback security solutions just to be compatible with a non updated library.

i cleared the issue using this step.. now app is working perfectly fine even without opening work bench to create local mysql instance.