On Wednesday, January 29, 2020 at 4:58:52 PM UTC+2, Jeremy Evans wrote: > > 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 > Awesome, great, thanx! J -- 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/111450ee-8953-4265-ae80-bae5c39da674%40googlegroups.com.
