Thank you Mr. Evans! I changed the connection_validation_timeout to 60 and will check if the problem is solved. I'm not sure because the last time the error occurred, the program wasn't used for 2 weeks. So the connection was also inactive for 2 weeks, and the validation at checkout should have worked, right? But, I get the above error.
Best regards and thank you! Armin Jeremy Evans schrieb am Montag, 16. August 2021 um 16:04:34 UTC+2: > On Mon, Aug 16, 2021 at 1:07 AM armin <[email protected]> wrote: > >> >> Hey, >> >> I have a problem with a MSSQL-Database-Connection. After some idle, I get >> following error: >> >> /usr/local/bundle/gems/puma-5.3.2/lib/puma/thread_pool.rb:145:in >> `block in spawn_thread'Sequel::DatabaseDisconnectError: TinyTds::Error: >> DBPROCESS is dead or not enabled >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/adapters/tinytds.rb:74:in >> `execute' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/adapters/tinytds.rb:74:in >> `block (2 levels) in execute' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/database/logging.rb:43:in >> `log_connection_yield' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/adapters/tinytds.rb:73:in >> `block in execute' >> >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/connection_pool/threaded.rb:88:in >> >> `hold' >> >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/database/connecting.rb:269:in >> >> `synchronize' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/adapters/tinytds.rb:47:in >> `execute' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/dataset/actions.rb:1093:in >> `execute' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/adapters/tinytds.rb:215:in >> `fetch_rows' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/dataset/actions.rb:152:in >> `each' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/dataset/actions.rb:444:in >> `map' >> >> /usr/local/bundle/gems/sequel-5.45.0/lib/sequel/dataset/actions.rb:444:in >> `map' >> /usr/local/bundle/gems/rom-core-5.2.5/lib/rom/relation.rb:223:in >> `each' >> /usr/local/bundle/gems/rom-core-5.2.5/lib/rom/relation.rb:363:in >> `each' >> /usr/local/bundle/gems/rom-core-5.2.5/lib/rom/relation.rb:363:in >> `to_a' >> /usr/local/bundle/gems/rom-core-5.2.5/lib/rom/relation.rb:363:in >> `to_a' >> /app/app/lib/repositories/ai_records_repo.rb:14:in `all_filtered' >> >> The ConnectionValidator-plugin is enabled. >> >> container = ROM.container(configuration) >> container.gateways[:default].connection.extension(:connection_validator) >> > > You may want to set the connection validation timeout. The default is an > hour, which may be too long for your case. You can set it to check for > validity after than one minute idle using: > > container.gateways[:default].connection.pool.connection_validation_timeout > = 60 > > 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/223bdf36-1dbc-40de-b97d-effaa01a330dn%40googlegroups.com.
