search

euglena1215 / isucon7q-20190427

Apache License 2.0
0 stars 0 forks source link

threading db connection #9

Closed euglena1215 closed 5 years ago

euglena1215 commented 5 years ago

threadごとでDBのconnectionを持つようにした。 多分Too many connectionが起こらなくなるはず。

euglena1215 commented 5 years ago

違うエラーが出るようになった。

Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]: 2019-04-27 10:03:16 - Mysql2::Error - Commands out of sync; you can't run this command now:
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:8:in `_execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:8:in `block in execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:7:in `handle_interrupt'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:7:in `execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:129:in `block (2 levels) in <class:App>'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:125:in `each'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:125:in `block in <class:App>'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1632:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1632:in `block in compile!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:991:in `block (3 levels) in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1010:in `route_eval'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:991:in `block (2 levels) in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1037:in `block in process_route'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1035:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1035:in `process_route'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:989:in `block in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:988:in `each'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:988:in `route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1094:in `block in dispatch!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `block in invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1091:in `dispatch!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:923:in `block in call!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `block in invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:923:in `call!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:913:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/xss_header.rb:18:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/path_traversal.rb:16:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/json_csrf.rb:26:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/frame_options.rb:31:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:232:in `context'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:226:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/null_logger.rb:9:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:194:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1955:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1499:in `block in call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1726:in `synchronize'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1499:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/configuration.rb:225:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:605:in `handle_request'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:437:in `process_client'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:301:in `block in run'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/thread_pool.rb:120:in `block in spawn_thread'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]: 2019-04-27 10:03:16 - Mysql2::Error - Commands out of sync; you can't run this command now:
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:8:in `_execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:8:in `block in execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:7:in `handle_interrupt'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/mysql2-0.4.9/lib/mysql2/statement.rb:7:in `execute'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:356:in `db_get_user'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:27:in `user'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/app.rb:54:in `block in <class:App>'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1632:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1632:in `block in compile!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:991:in `block (3 levels) in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1010:in `route_eval'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:991:in `block (2 levels) in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1037:in `block in process_route'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1035:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1035:in `process_route'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:989:in `block in route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:988:in `each'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:988:in `route!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1094:in `block in dispatch!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `block in invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1091:in `dispatch!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:923:in `block in call!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `block in invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `catch'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1073:in `invoke'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:923:in `call!'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:913:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/xss_header.rb:18:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/path_traversal.rb:16:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/json_csrf.rb:26:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/base.rb:50:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-protection-2.0.0/lib/rack/protection/frame_options.rb:31:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:232:in `context'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/session/abstract/id.rb:226:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/null_logger.rb:9:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/head.rb:12:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:194:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1955:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1499:in `block in call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1726:in `synchronize'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/sinatra-2.0.0/lib/sinatra/base.rb:1499:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/configuration.rb:225:in `call'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:605:in `handle_request'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:437:in `process_client'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/server.rb:301:in `block in run'
Apr 27 10:03:16 ip-172-31-17-207 bundle[12215]:         /home/isucon/isubata/webapp/ruby/vendor/bundle/ruby/2.4.0/gems/puma-3.10.0/lib/puma/thread_pool.rb:120:in `block in spawn_thread'
q^C
euglena1215 commented 5 years ago

なんかちょいちょいstatement.close忘れがある気がするのでそのあたりが原因かも。 対応してみる

euglena1215 commented 5 years ago

対応したらまたToo many connectionが発生するようになった。

euglena1215 commented 5 years ago

@spring1018 scoreの変化はほとんどなかったですが、悪くなることはないと信じています！

euglena1215 commented 5 years ago

mergeしちゃえ