Issue: Sequel::DatabaseConnectionError - SQLite3::CantOpenException: unable to open database file (Sequel::DatabaseConnectionError)

[Nishantbhagat57]

Hi @JoshuaMart,

Hope you are doing well :) I don't know how much I can thank you for this tool - it has really helped me a lot in my bug bounty journey. Once again, I am really grateful to you for maintaining this project.

Recently I updated ScopesExtractor to the latest version 2.x. (tbh, I was using the old version haha - I didn't want to shift as it was working superbly, but ultimately decided to update after seeing that you added some more scope patterns, and it's always good to stay updated anyway). But, it seems there are some issues I am facing. On the first start it's running fine, but after several hours it starts giving SQL database errors.

Docker command I am using:

sudo docker run -d \
           -v $(pwd)/config/settings.yml:/app/config/settings.yml:ro \
           -v $(pwd)/.env:/app/.env:ro \
           -v scopes_db:/app/db \
           -p 4567:4567 \
           --name scopes_extractor \
           scopes_extractor \
           bundle exec bin/scopes_extractor serve --sync

Errors (after 2-3 hours):

	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#open_v2'
	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Sequel::SQLite::Database#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:245:in 'Sequel::Database#new_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool.rb:163:in 'Sequel::ConnectionPool#make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:134:in 'Sequel::TimedQueueConnectionPool#preallocated_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:188:in 'Sequel::TimedQueueConnectionPool#try_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:223:in 'Sequel::TimedQueueConnectionPool#acquire'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:89:in 'Sequel::TimedQueueConnectionPool#hold'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:283:in 'Sequel::Database#synchronize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:291:in 'Sequel::Database#test_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/misc.rb:209:in 'Sequel::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:116:in 'Sequel::SQLite::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Sequel::Database.connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:124:in 'Sequel::SequelMethods#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:441:in 'Sequel::SequelMethods#adapter_method'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:448:in 'block (2 levels) in Sequel.def_adapter_method'
	/app/lib/scopes_extractor/database.rb:10:in 'ScopesExtractor::Database.connect'
	/app/lib/scopes_extractor/api.rb:43:in 'block in <class:API>'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'Method#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'block in Sinatra::Base.compile!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1123:in 'block in Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1060:in 'block in Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Array#each'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1194:in 'block in Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1192:in 'Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'block in Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:993:in 'Sinatra::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/xss_header.rb:20:in 'Rack::Protection::XSSHeader#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/path_traversal.rb:18:in 'Rack::Protection::PathTraversal#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/json_csrf.rb:28:in 'Rack::Protection::JsonCsrf#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/frame_options.rb:33:in 'Rack::Protection::FrameOptions#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/middleware/logger.rb:17:in 'Sinatra::Middleware::Logger#call'
	/usr/local/bundle/gems/rack-3.2.5/lib/rack/head.rb:15:in 'Rack::Head#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:227:in 'Sinatra::ExtendedRack#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:2144:in 'Sinatra::Wrapper#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'block in Sinatra::Base.call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1902:in 'Sinatra::Base.synchronize'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'Sinatra::Base.call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/configuration.rb:300:in 'Puma::Configuration::ConfigMiddleware#call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:101:in 'block in Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:355:in 'Puma::ThreadPool#with_force_shutdown'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:100:in 'Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:503:in 'Puma::Server#process_client'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:262:in 'block in Puma::Server#run'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:182:in 'block in Puma::ThreadPool#spawn_thread'
2026-03-06 18:53:08 - Sequel::DatabaseConnectionError - SQLite3::CantOpenException: unable to open database file (Sequel::DatabaseConnectionError):
	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#open_v2'
	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Sequel::SQLite::Database#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:245:in 'Sequel::Database#new_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool.rb:163:in 'Sequel::ConnectionPool#make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:134:in 'Sequel::TimedQueueConnectionPool#preallocated_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:188:in 'Sequel::TimedQueueConnectionPool#try_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:223:in 'Sequel::TimedQueueConnectionPool#acquire'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:89:in 'Sequel::TimedQueueConnectionPool#hold'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:283:in 'Sequel::Database#synchronize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:291:in 'Sequel::Database#test_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/misc.rb:209:in 'Sequel::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:116:in 'Sequel::SQLite::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Sequel::Database.connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:124:in 'Sequel::SequelMethods#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:441:in 'Sequel::SequelMethods#adapter_method'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:448:in 'block (2 levels) in Sequel.def_adapter_method'
	/app/lib/scopes_extractor/database.rb:10:in 'ScopesExtractor::Database.connect'
	/app/lib/scopes_extractor/api.rb:43:in 'block in <class:API>'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'Method#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'block in Sinatra::Base.compile!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1123:in 'block in Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1060:in 'block in Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Array#each'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1194:in 'block in Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1192:in 'Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'block in Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:993:in 'Sinatra::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/xss_header.rb:20:in 'Rack::Protection::XSSHeader#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/path_traversal.rb:18:in 'Rack::Protection::PathTraversal#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/json_csrf.rb:28:in 'Rack::Protection::JsonCsrf#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/frame_options.rb:33:in 'Rack::Protection::FrameOptions#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/middleware/logger.rb:17:in 'Sinatra::Middleware::Logger#call'
	/usr/local/bundle/gems/rack-3.2.5/lib/rack/head.rb:15:in 'Rack::Head#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:227:in 'Sinatra::ExtendedRack#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:2144:in 'Sinatra::Wrapper#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'block in Sinatra::Base.call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1902:in 'Sinatra::Base.synchronize'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'Sinatra::Base.call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/configuration.rb:300:in 'Puma::Configuration::ConfigMiddleware#call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:101:in 'block in Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:355:in 'Puma::ThreadPool#with_force_shutdown'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:100:in 'Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:503:in 'Puma::Server#process_client'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:262:in 'block in Puma::Server#run'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:182:in 'block in Puma::ThreadPool#spawn_thread'
2026-03-06 18:53:08 - Sequel::DatabaseConnectionError - SQLite3::CantOpenException: unable to open database file (Sequel::DatabaseConnectionError):
	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#open_v2'
	/usr/local/bundle/gems/sqlite3-2.9.0-x86_64-linux-gnu/lib/sqlite3/database.rb:167:in 'SQLite3::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:149:in 'Sequel::SQLite::Database#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:245:in 'Sequel::Database#new_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool.rb:163:in 'Sequel::ConnectionPool#make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:134:in 'Sequel::TimedQueueConnectionPool#preallocated_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:188:in 'Sequel::TimedQueueConnectionPool#try_make_new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:223:in 'Sequel::TimedQueueConnectionPool#acquire'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/connection_pool/timed_queue.rb:89:in 'Sequel::TimedQueueConnectionPool#hold'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:283:in 'Sequel::Database#synchronize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:291:in 'Sequel::Database#test_connection'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/misc.rb:209:in 'Sequel::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/adapters/sqlite.rb:116:in 'Sequel::SQLite::Database#initialize'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Class#new'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/database/connecting.rb:54:in 'Sequel::Database.connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:124:in 'Sequel::SequelMethods#connect'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:441:in 'Sequel::SequelMethods#adapter_method'
	/usr/local/bundle/gems/sequel-5.100.0/lib/sequel/core.rb:448:in 'block (2 levels) in Sequel.def_adapter_method'
	/app/lib/scopes_extractor/database.rb:10:in 'ScopesExtractor::Database.connect'
	/app/lib/scopes_extractor/api.rb:43:in 'block in <class:API>'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'Method#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1811:in 'block in Sinatra::Base.compile!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1123:in 'block in Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1121:in 'Sinatra::Base#process_route'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1060:in 'block in Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Array#each'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1059:in 'Sinatra::Base#filter!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1194:in 'block in Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1192:in 'Sinatra::Base#dispatch!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'block in Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Kernel#catch'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1168:in 'Sinatra::Base#invoke'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1004:in 'Sinatra::Base#call!'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:993:in 'Sinatra::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/xss_header.rb:20:in 'Rack::Protection::XSSHeader#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/path_traversal.rb:18:in 'Rack::Protection::PathTraversal#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/json_csrf.rb:28:in 'Rack::Protection::JsonCsrf#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/base.rb:53:in 'Rack::Protection::Base#call'
	/usr/local/bundle/gems/rack-protection-4.2.1/lib/rack/protection/frame_options.rb:33:in 'Rack::Protection::FrameOptions#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/middleware/logger.rb:17:in 'Sinatra::Middleware::Logger#call'
	/usr/local/bundle/gems/rack-3.2.5/lib/rack/head.rb:15:in 'Rack::Head#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:227:in 'Sinatra::ExtendedRack#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:2144:in 'Sinatra::Wrapper#call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'block in Sinatra::Base.call'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1902:in 'Sinatra::Base.synchronize'
	/usr/local/bundle/gems/sinatra-4.2.1/lib/sinatra/base.rb:1681:in 'Sinatra::Base.call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/configuration.rb:300:in 'Puma::Configuration::ConfigMiddleware#call'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:101:in 'block in Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:355:in 'Puma::ThreadPool#with_force_shutdown'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/request.rb:100:in 'Puma::Request#handle_request'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:503:in 'Puma::Server#process_client'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/server.rb:262:in 'block in Puma::Server#run'
	/usr/local/bundle/gems/puma-7.1.0/lib/puma/thread_pool.rb:182:in 'block in Puma::ThreadPool#spawn_thread'

Not sure if this is something on my side or a potential issue with the new version. Let me know if you need any more logs or details.

Thanks and Regards,
Nishant

[JoshuaMart]

Hey @Nishantbhagat57 ,
Thanks a lot for the comment :)

I think I see the bug, but just to make sure I've understood it correctly, did you make a lot of calls to the API ?

Regards

[Nishantbhagat57]

Hi @JoshuaMart,

I think I see the bug, but just to make sure I've understood it correctly, did you make a lot of calls to the API ?

That's great if you've already identified the issue. Yes, I do make a lot of calls to the API. I currently have around 6 other servers regularly making requests to the main server that is running the ScopesExtractor API.

Just to add, I didn't face this issue with the previous 1.x version under a similar setup.

Hope this helps. Let me know if you need any additional logs or details from my side.

Thanks and Regards,
Nishant

[JoshuaMart]

For my own follow-up, the issue was a broken check in the API's before filter, it was checking Database.instance_variable_get(:@db) which is always nil, causing Database.connect to be called on every request and creating a new SQLite connection each time without closing the previous one. Over time, this exhausts file descriptors, leading to the CantOpenException you observed.

Fixed in #28 - the check now correctly uses ScopesExtractor.db.

---

Can you pull and check if everything is ok ? :)

[Nishantbhagat57]

Hi @JoshuaMart,

Thanks for the quick fix.

I’ve updated the lib/scopes_extractor/api.rb file and performed a rebuild. So far it looks like the issue is resolved. I’ll let it run for a while (around 12 hours) under the same load and will update here if everything remains stable.

Thanks again for the prompt response and fix :)

Thanks and Regards,
Nishant

[Nishantbhagat57]

Hi @JoshuaMart,

ScopesExtractor has been running for the past 20 hours without any issues. The problem appears to be fixed, and everything is working perfectly.

Once again, thank you for the prompt fix :)

Regards,
Nishant