On Wednesday, January 29, 2020 at 12:35:49 AM UTC-8, Jurgens du Toit wrote: > > I'm not sure if it's my setup causing this, but in my logs I see a > connection that dies, but then Sequel continues trying to use the > connection: > > The following comes from recent logs. > > You can see a batch of successful queries on the 28th just after 15:12. > > D, [2020-01-28T15:12:59.206710 #12916] DEBUG -- : (0.000255s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.208963 #12916] DEBUG -- : (0.000073s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.211040 #12916] DEBUG -- : (0.000059s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.213096 #12916] DEBUG -- : (0.000112s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.214248 #12916] DEBUG -- : (0.000056s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.220084 #12916] DEBUG -- : (0.000073s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > D, [2020-01-28T15:12:59.226383 #12916] DEBUG -- : (0.000077s) (conn: > 1821020, server: default) SELECT SOMETHING, THIS WORKS > > The system then becomes idle until the next morning at 8:19. It looks like > the error connection fails (It does a SELECT NULL). > > E, [2020-01-29T08:19:05.746825 #12916] ERROR -- : NoMethodError: undefined > method `each' for false:FalseClass: (conn: 1821020, server: default) SELECT > NULL > E, [2020-01-29T08:19:05.835454 #12916] ERROR -- : undefined method `each' > for false:FalseClass (NoMethodError) > /home/aex/fno-interface-stage/vendor/bundle/ruby/2.7.0/gems/sequel-5.28.0/lib/sequel/adapters/tinytds.rb:153:in > > `block in log_connection_execute' > > After that the connection is still used. It's only discarded once I > restart the whole process (A Sinatra webapp) > > E, [2020-01-29T09:06:49.984170 #12916] ERROR -- : TinyTds::Error: > DBPROCESS is dead or not enabled: (conn: 1821020, server: default) SELECT > THAT NO LONGER WORKS >
We need to add this as a recognized disconnect error in the tiny_tds adapter. I'll take care of that before the next release. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/bb7cc87e-2566-4cf9-a687-38d01b537ccc%40googlegroups.com.
