search

dart-db / sqljocky5

MySQL driver for Dart
Other
40 stars 19 forks source link

MySQL Client Error: Connection cannot process a request for Instance of 'PrepareHandler' #37

Open u007 opened 4 years ago

u007 commented 4 years ago

i think after running the instance for a day, the connection seems to got disconnected. i suspect there are no mechanism to reconnect. getting some difficult to identify error:

MySQL Client Error: Connection cannot process a request for Instance of 'PrepareHandler' while a request is already in progress for Instance of 'PrepareHandler'
#0      setupLogger.<anonymous closure> (package:project/src/util/logging.dart:13)
#1      _rootRunUnary (dart:async/zone.dart:1136)
#2      _RootZone.runUnaryGuarded (dart:async/zone.dart:1317)
#3      _BufferingStreamSubscription._sendData (dart:async/stream_impl.dart:336)
#4      _BufferingStreamSubscription._add (dart:async/stream_impl.dart:263)
#5      _SyncBroadcastStreamController._sendData (dart:async/broadcast_stream_controller.dart:375)
#6      _BroadcastStreamController.add (dart:async/broadcast_stream_controller.dart:250)
#7      Logger._publish (package:logging/logging.dart:240)
#8      Logger.log (package:logging/logging.dart:186)
#9      Logger.severe (package:logging/logging.dart:221)
#10     Driver.handleRawRequest.<anonymous closure>.<anonymous closure>.<anonymous closure>.<anonymous closure> (package:angel_framework/src/core/driver.dart:200)
#11     new Future.<anonymous closure> (dart:async/future.dart:176)
#12     _rootRun (dart:async/zone.dart:1120)
#13     _CustomZone.run (dart:async/zone.dart:1021)
#14     _CustomZone.runGuarded (dart:async/zone.dart:923)
#15     _CustomZone.bindCallbackGuarded.<anonymous closure> (dart:async/zone.dart:963)
#16     _rootRun (dart:async/zone.dart:1124)
#17     _CustomZone.run (dart:async/zone.dart:1021)
#18     _CustomZone.bindCallback.<anonymous closure> (dart:async/zone.dart:947)
#19     Timer._createTimer.<anonymous closure> (dart:async-patch/timer_patch.dart:21)
#20     _Timer._runTimers (dart:isolate-patch/timer_impl.dart:382)
#21     _Timer._handleMessage (dart:isolate-patch/timer_impl.dart:416)
#22     _RawReceivePortImpl._handleMessage (dart:isolate-patch/isolate_patch.dart:172)
u007 commented 4 years ago

might be related to this: https://github.com/dart-db/sqljocky5/issues/27

insinfo commented 4 years ago

@u007 I'm having this same problem, did you find any solution?

u007 commented 4 years ago

no solution yet, right now im using logging to detect preparehandler error and restart the instance