I, [2023-12-03T19:57:59.984594 #3056] INFO -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 654fbe24-c328-462b-b299-4ca9eb93c0df) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00d5529f90 @uri=#<URI::GID gid://julia-observer/Visit/16787555>>

I, [2023-12-03T19:57:59.989440 #3056] INFO -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] [ActiveJob] [PackageSorterJob] [226eb892-0b30-4c87-a0dc-2dcb6fd2618e] Performing PackageSorterJob from DelayedJob(default) with arguments: {"controller"=>"packages", "action"=>"index"}, #<ActionDispatch::Cookies::CookieJar:0x00007f00d3b2b760 @set_cookies={"ahoy_visitor"=>{:value=>"3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", :expires=>Wed, 03 Dec 2025 19:57:59 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}, "ahoy_visit"=>{:value=>"deb32b02-a892-44f9-9733-952628530b8e", :expires=>Sun, 03 Dec 2023 23:57:59 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}}, @delete_cookies={}, @request=#<ActionDispatch::Request:0x00007f01005367d8 @env={"rack.version"=>[1, 3], "rack.errors"=>#<IO:<STDERR>>, "rack.multithread"=>true, "rack.multiprocess"=>false, "rack.run_once"=>false, "SCRIPT_NAME"=>"", "QUERY_STRING"=>"", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"puma 3.12.1 Llamas in Pajamas", "GATEWAY_INTERFACE"=>"CGI/1.2", "REQUEST_METHOD"=>"GET", "REQUEST_PATH"=>"/packages", "REQUEST_URI"=>"/packages", "HTTP_VERSION"=>"HTTP/1.0", "HTTP_HOST"=>"cdn.juliaobserver.com", "HTTP_X_REAL_IP"=>"64.252.88.190", "HTTP_X_FORWARDED_FOR"=>"213.180.203.22, 64.252.88.190", "HTTP_X_FORWARDED_PROTO"=>"http", "HTTP_CONNECTION"=>"close", "HTTP_USER_AGENT"=>"Amazon CloudFront", "HTTP_X_AMZ_CF_ID"=>"vInVS3Qsu9tWpMRnDcWNtUIlwVwrldVUqNz0UXS94QrbgMkOUhgzeQ==", "HTTP_VIA"=>"1.1 c636ba9295dbf02e90f35b717bb16656.cloudfront.net (CloudFront)", "HTTP_ACCEPT_ENCODING"=>"gzip", "HTTP_FROM"=>"support@search.yandex.ru", "HTTP_CLOUDFRONT_VIEWER_COUNTRY"=>"RU", "SERVER_NAME"=>"cdn.juliaobserver.com", "SERVER_PORT"=>"80", "PATH_INFO"=>"/packages", "REMOTE_ADDR"=>"127.0.0.1", "puma.socket"=>#<TCPSocket:fd 13, AF_INET, 127.0.0.1, 3000>, "rack.hijack?"=>true, "rack.hijack"=>#<Puma::Client:0x3f808083aa00 @ready=true>, "rack.input"=>#<Puma::NullIO:0x000055fc7cbc5ad8>, "rack.url_scheme"=>"http", "rack.after_reply"=>[], "puma.config"=>#<Puma::Configuration:0x000055fc7cd33a28 @options=#<Puma::UserFileDefaultOptions:0x000055fc7cd33848 @user_options={:environment=>"production"}, @file_options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @default_options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}>, @plugins=#<Puma::PluginLoader:0x000055fc7cd337f8 @instances=[#<#<Class:0x000055fc7cd6fa00>:0x000055fc7cd6f938 @loader=Puma::Plugin>]>, @user_dsl=#<Puma::DSL:0x000055fc7cd337a8 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:environment=>"production"}, @plugins=[]>, @file_dsl=#<Puma::DSL:0x000055fc7cd33758 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @plugins=[], @path="config/puma.rb">, @default_dsl=#<Puma::DSL:0x000055fc7cd33708 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}, @plugins=[]>>, "action_dispatch.parameter_filter"=>[:password], "action_dispatch.redirect_filter"=>[], "action_dispatch.secret_token"=>nil, "action_dispatch.secret_key_base"=>"4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", "action_dispatch.show_exceptions"=>true, "action_dispatch.show_detailed_exceptions"=>true, "action_dispatch.logger"=>#<ActiveSupport::Logger:0x000055fc7f4a8748 @level=0, @progname=nil, @default_formatter=#<Logger::Formatter:0x000055fc7f4a86d0 @datetime_format=nil>, @formatter=#<Logger::Formatter:0x000055fc7f4a95d0 @datetime_format=nil, @thread_key="activesupport_tagged_logging_tags:47271477857000">, @logdev=#<Logger::LogDevice:0x000055fc7f4a8680 @shift_period_suffix=nil, @shift_size=nil, @shift_age=nil, @filename=nil, @dev=#<File:/home/rails/julia_observer/log/production.log>, @mon_mutex=#<Thread::Mutex:0x000055fc7f4a8608>, @mon_mutex_owner_object_id=47271477855040, @mon_owner=nil, @mon_count=0>, @local_levels=#<Concurrent::Map:0x000055fc7f4a8270 entries=0 default_proc=nil>, @thread_hash_level_key=:"ThreadSafeLogger#47271477855140@level">, "action_dispatch.backtrace_cleaner"=>#<Rails::BacktraceCleaner:0x000055fc7dbfcf78 @filters=[#<Proc:0x000055fc7dc3e2c0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:14>, #<Proc:0x000055fc7dc3e158@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:15>, #<Proc:0x000055fc7dc3dcf8@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:16>, #<Proc:0x000055fc7dc23ec0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:29>], @silencers=[#<Proc:0x000055fc7dc23ab0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:19>], @root="/home/rails/julia_observer/">, "action_dispatch.key_generator"=>#<ActiveSupport::CachingKeyGenerator:0x000055fc7f0ea520 @key_generator=#<ActiveSupport::KeyGenerator:0x000055fc7f0ea548 @secret="4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", @iterations=1000>, @cache_keys=#<Concurrent::Map:0x000055fc7f0ea480 entries=3 default_proc=nil>>, "action_dispatch.http_auth_salt"=>"http authentication", "action_dispatch.signed_cookie_salt"=>"signed cookie", "action_dispatch.encrypted_cookie_salt"=>"encrypted cookie", "action_dispatch.encrypted_signed_cookie_salt"=>"signed encrypted cookie", "action_dispatch.cookies_serializer"=>:json, "action_dispatch.cookies_digest"=>nil, "action_dispatch.routes"=>#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>, "ROUTES_47271477352840_SCRIPT_NAME"=>"", "ORIGINAL_FULLPATH"=>"/packages", "ORIGINAL_SCRIPT_NAME"=>"", "rack.cors"=>#<Rack::Cors::Result:0x00007f0101074d98 @preflight=false, @hit=false, @miss_reason="no-origin">, "action_dispatch.request_id"=>"6eff5e06-d7e0-41ce-be22-767a0b4495cd", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::GetIp:0x00007f0101074208 @req=#<ActionDispatch::Request:0x00007f0101074230 @env={...}, @filtered_parameters=nil, @filtered_env=nil, @filtered_path=nil, @protocol=nil, @port=nil, @method=nil, @request_method=nil, @remote_ip=nil, @original_fullpath=nil, @fullpath=nil, @ip=nil>, @check_ip=true, @proxies=[#<IPAddr: IPv4:127.0.0.1/255.255.255.255>, #<IPAddr: IPv6:0000:0000:0000:0000:0000:0000:0000:0001/ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff>, #<IPAddr: IPv6:fc00:0000:0000:0000:0000:0000:0000:0000/fe00:0000:0000:0000:0000:0000:0000:0000>, #<IPAddr: IPv4:10.0.0.0/255.0.0.0>, #<IPAddr: IPv4:172.16.0.0/255.240.0.0>, #<IPAddr: IPv4:192.168.0.0/255.255.0.0>], @ip="64.252.88.190">, "rack.session"=>#<ActionDispatch::Request::Session:0x7f0101074140 not yet loaded>, "rack.session.options"=>#<ActionDispatch::Request::Session::Options:0x00007f01010740f0 @by=#<ActionDispatch::Session::CookieStore:0x000055fc80517d68 @app=#<Rack::Head:0x000055fc80517d90 @app=#<Rack::ConditionalGet:0x000055fc80517db8 @app=#<Rack::ETag:0x000055fc80517de0 @app=#<Rack::Attack:0x000055fc80517e08 @app=#<Ahoy::Throttle:0x000055fc80517e30 @app=#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>>>, @cache_control="max-age=0, private, must-revalidate", @no_cache_control="no-cache">>>, @default_options={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}, @key="_julia_observer_session", @cookie_only=true>, @delegate={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}>, "rack.attack.throttle_data"=>{"req/ip"=>{:count=>2, :period=>300, :limit=>500, :epoch_time=>1701633479}}, "action_dispatch.request.path_parameters"=>{:controller=>"packages", :action=>"index"}, "action_controller.instance"=>#<PackagesController:0x00007f0100535a40 @_action_has_layout=true, @_routes=nil, @_request=#<ActionDispatch::Request:0x00007f01005367d8 ...>, @_response=#<ActionDispatch::Response:0x00007f0100535c48 @mon_mutex=#<Thread::Mutex:0x00007f0100535bf8>, @mon_mutex_owner_object_id=69821138578980, @mon_owner=nil, @mon_count=0, @header={"X-Frame-Options"=>"SAMEORIGIN", "X-XSS-Protection"=>"1; mode=block", "X-Content-Type-Options"=>"nosniff"}, @stream=#<ActionDispatch::Response::Buffer:0x00007f0100535ba8 @response=#<ActionDispatch::Response:0x00007f0100535c48 ...>, @buf=[], @closed=false, @str_body=nil>, @status=200, @cv=#<MonitorMixin::ConditionVariable:0x00007f0100535b80 @monitor=#<ActionDispatch::Response:0x00007f0100535c48 ...>, @cond=#<Thread::ConditionVariable:0x00007f0100535b58>>, @committed=false, @sending=false, @sent=false, @cache_control={}, @request=#<ActionDispatch::Request:0x00007f01005367d8 ...>>, @_lookup_context=#<ActionView::LookupContext:0x00007f0100535978 @details_key=nil, @cache=true, @prefixes=["packages", "application"], @rendered_format=nil, @details={:locale=>[:en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :coffee, :jbuilder]}, @view_paths=#<ActionView::PathSet:0x00007f0100535888 @paths=[#<ActionView::OptimizedFileSystemResolver:0x000055fc7f479240 @pattern=":prefix/:action{.:locale,}{.:formats,}{+:variants,}{.:handlers,}", @cache=#<ActionView::Resolver::Cache:0x55fc7f479218 keys=477 queries=0>, @path="/home/rails/julia_observer/app/views">]>>, @_action_name="index", @_response_body=nil, @ahoy=#<Ahoy::Tracker:0x00007f01005348c0 @store=#<Ahoy::Store:0x00007f0100534848 @options={:controller=>#<PackagesController:0x00007f0100535a40 ...>, :ahoy=>#<Ahoy::Tracker:0x00007f01005348c0 ...>}, @controller=#<PackagesController:0x00007f0100535a40 ...>, @request=#<ActionDispatch::Request:0x00007f01005367d8 ...>, @bot=false, @ahoy=#<Ahoy::Tracker:0x00007f01005348c0 ...>, @user=nil, @visit=#<Visit id: 16787555, visit_token: "deb32b02-a892-44f9-9733-952628530b8e", visitor_token: "3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", ip: "64.252.88.190", user_agent: "Amazon CloudFront", referrer: nil, landing_page: "http://cdn.juliaobserver.com/packages", user_id: nil, referring_domain: nil, search_keyword: nil, browser: "Other", os: "Other", device_type: "Desktop", screen_height: nil, screen_width: nil, country: nil, region: nil, city: nil, postal_code: nil, latitude: nil, longitude: nil, utm_source: nil, utm_medium: nil, utm_term: nil, utm_content: nil, utm_campaign: nil, started_at: "2023-12-03 19:57:59">>, @controller=#<PackagesController:0x00007f0100535a40 ...>, @request=#<ActionDispatch::Request:0x00007f01005367d8 ...>, @options={:controller=>#<PackagesController:0x00007f0100535a40 ...>}, @visitor_header=nil, @visitor_cookie=nil, @existing_visitor_token=nil, @visitor_token_helper="3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", @visitor_id="3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", @visit_header=nil, @visit_cookie=nil, @existing_visit_token=nil, @visit_token_helper="deb32b02-a892-44f9-9733-952628530b8e", @visit_id="deb32b02-a892-44f9-9733-952628530b8e", @visit_token="deb32b02-a892-44f9-9733-952628530b8e", @visitor_token="3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", @visit_properties=#<Ahoy::VisitProperties:0x00007f00d3b28628 @request=#<ActionDispatch::Request:0x00007f01005367d8 ...>, @options={:api=>nil}, @request_deckhand=#<Ahoy::Deckhands::RequestDeckhand:0x00007f00d3b28538 @request=#<ActionDispatch::Request:0x00007f01005367d8 ...>, @options={:api=>nil}, @params={"controller"=>"packages", "action"=>"index"}>, @traffic_source_deckhand=#<Ahoy::Deckhands::TrafficSourceDeckhand:0x00007f0108e34030 @referrer=nil, @referring_domain=nil, @search_keyword=nil>, @utm_parameter_deckhand=#<Ahoy::Deckhands::UtmParameterDeckhand:0x00007f010a93b680 @landing_page="http://cdn.juliaobserver.com/packages", @params={"controller"=>"packages", "action"=>"index"}, @landing_params={}>, @technology_deckhand=#<Ahoy::Deckhands::TechnologyDeckhand:0x00007f010a93acd0 @user_agent="Amazon CloudFront", @agent=#<UserAgentParser::UserAgent Other (Other) (Other)>, @device_type="Desktop">>>, @marked_for_same_origin_verification=true, @_config={}, @_params=<ActionController::Parameters {"controller"=>"packages", "action"=>"index"} permitted: false>>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"", "rack.request.query_hash"=>{}, "action_dispatch.request.query_parameters"=>{}, "action_dispatch.request.parameters"=>{"controller"=>"packages", "action"=>"index"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x000055fc7e34f410 @synonyms=["application/xhtml+xml"], @symbol=:html, @string="text/html", @hash=-2234802910782609731>], "rack.request.cookie_hash"=>{}, "action_dispatch.cookies"=>#<ActionDispatch::Cookies::CookieJar:0x00007f00d3b2b760 ...>, "action_dispatch.request.unsigned_session_cookie"=>{}}, @filtered_parameters={"controller"=>"packages", "action"=>"index"}, @filtered_env=nil, @filtered_path=nil, @protocol="http://", @port=80, @method=nil, @request_method="GET", @remote_ip="64.252.88.190", @original_fullpath="/packages", @fullpath="/packages", @ip=nil, @headers=#<ActionDispatch::Http::Headers:0x00007f0100534eb0 @req=#<ActionDispatch::Request:0x00007f01005367d8 ...>>>, @cookies={"ahoy_visitor"=>"3f1ba0cd-10c1-4c82-8bf8-a0b5c3f8ff03", "ahoy_visit"=>"deb32b02-a892-44f9-9733-952628530b8e"}, @committed=false, @encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00d5529888 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00d3b2b760 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00d5529720 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00d5529680 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>, @signed_or_encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00d5529888 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00d3b2b760 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00d5529720 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00d5529680 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>>

D, [2023-12-03T19:57:59.992864 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] [ActiveJob] [PackageSorterJob] [226eb892-0b30-4c87-a0dc-2dcb6fd2618e] ][1m][36mOrganization Load (2.1ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

I, [2023-12-03T19:57:59.993590 #3056] INFO -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] [ActiveJob] [PackageSorterJob] [226eb892-0b30-4c87-a0dc-2dcb6fd2618e] Performed PackageSorterJob from DelayedJob(default) in 3.97ms

D, [2023-12-03T19:58:00.677679 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][35mSQL (682.4ms)][0m ][1m][34mSELECT "packages"."id" AS t0_r0, "packages"."name" AS t0_r1, "packages"."created_at" AS t0_r2, "packages"."updated_at" AS t0_r3, "packages"."description" AS t0_r4, "packages"."homepage" AS t0_r5, "packages"."owner_type" AS t0_r6, "packages"."owner_id" AS t0_r7, "packages"."is_registered" AS t0_r8, "packages"."readme" AS t0_r9, "packages"."readme_type" AS t0_r10, "daters"."id" AS t1_r0, "daters"."created" AS t1_r1, "daters"."updated" AS t1_r2, "daters"."pushed" AS t1_r3, "daters"."package_id" AS t1_r4, "daters"."created_at" AS t1_r5, "daters"."updated_at" AS t1_r6, "daters"."touched" AS t1_r7, "counters"."id" AS t2_r0, "counters"."fork" AS t2_r1, "counters"."stargazer" AS t2_r2, "counters"."open_issue" AS t2_r3, "counters"."package_id" AS t2_r4, "counters"."created_at" AS t2_r5, "counters"."updated_at" AS t2_r6, "counters"."contributor" AS t2_r7, "activities"."id" AS t3_r0, "activities"."commits" AS t3_r1, "activities"."package_id" AS t3_r2, "activities"."created_at" AS t3_r3, "activities"."updated_at" AS t3_r4, "activities"."recent_commit_count" AS t3_r5 FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 INNER JOIN "daters" ON "daters"."package_id" = "packages"."id" INNER JOIN "counters" ON "counters"."package_id" = "packages"."id" INNER JOIN "activities" ON "activities"."package_id" = "packages"."id" WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."is_registered" = $3 ORDER BY counters.stargazer desc LIMIT $4 OFFSET $5][0m [["item_type", "Package"], ["marker", 5931], ["is_registered", true], ["LIMIT", 30], ["OFFSET", 0]]]

D, [2023-12-03T19:58:00.696779 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][36mCategory Load (10.2ms)][0m ][1m][34mSELECT "categories".* FROM "categories" INNER JOIN "batches" ON "batches"."item_id" = "categories"."id" AND "batches"."item_type" = $1 INNER JOIN "labels" ON "labels"."category_id" = "categories"."id" INNER JOIN "packages" ON "packages"."id" = "labels"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY categories.id ORDER BY count(categories.id) desc][0m [["item_type", "Category"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:00.955485 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][36mRelease Load (248.5ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:01.416932 #3056] DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] [ahoy] Visit excluded

D, [2023-12-03T19:58:01.419778 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mOrganization Load (0.6ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:02.729539 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mPackage Exists (1308.2ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "SharedWords"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:02.731426 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mPackage Exists (0.6ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."id" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["id", 0], ["LIMIT", 1]]]

D, [2023-12-03T19:58:02.732634 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:02.885370 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mPackage Load (151.4ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%SharedWords%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:02.894041 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mUser Load (3.8ms)][0m ][1m][34mSELECT "users".* FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1) ORDER BY sum(contributions.score) desc LIMIT $4 OFFSET $5][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true], ["LIMIT", 100], ["OFFSET", 1600]]]

D, [2023-12-03T19:58:03.005287 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][35m (109.9ms)][0m ][1m][34mSELECT COUNT(*) AS count_all, users.id AS users_id FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1)][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:03.693003 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][35m (17.9ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:03.696302 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][35mSQL (2.2ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787555], ["name", "Viewed: packages#index"], ["properties", "{}"], ["time", 2023-12-03 19:58:03 UTC]]]

D, [2023-12-03T19:58:03.697351 #3056 DEBUG -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] ][1m][35m (0.7ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:03.697640 #3056] INFO -- : [6eff5e06-d7e0-41ce-be22-767a0b4495cd] {:_method=>"GET", :_path=>"/packages", :_format=>:html, :_controller=>"PackagesController", :_action=>"index", :_status=>200, :_duration=>3728.51, :_view=>2735.91, :_db=>971.88, :_time=>2023-12-03 19:57:59 +0000, :short_message=>"[200] GET /packages (PackagesController#index)"}

D, [2023-12-03T19:58:03.876837 #3056 DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] ][1m][36mRelease Load (750.5ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:06.133478 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:06.237190 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35mSQL (102.5ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "240c2a65-c327-4b3e-9165-12fb41374eed"], ["visitor_token", "85a91401-8191-4409-9040-bc447b50b125"], ["ip", "64.252.72.83"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/packages/CommonSubexpressions"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:06 UTC]]]

D, [2023-12-03T19:58:06.312495 #3056] DEBUG -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] [ahoy] Event excluded

I, [2023-12-03T19:58:06.312986 #3056] INFO -- : [f62b00ed-f0c5-4180-8ab2-05341034d763] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>4896.66, :_view=>2561.2, :_db=>2324.89, :_time=>2023-12-03 19:58:01 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:58:06.312710 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35m (74.9ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:06.315013 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:06.316305 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35mSQL (0.3ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 814e0ffb-fc06-4669-b375-6dcf8544f92b\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787556\n locale: en\n"], ["run_at", 2023-12-03 19:58:06 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:06 UTC], ["updated_at", 2023-12-03 19:58:06 UTC]]]

D, [2023-12-03T19:58:06.317472 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35m (0.9ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:06.317749 #3056] INFO -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 814e0ffb-fc06-4669-b375-6dcf8544f92b) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00f39512d0 @uri=#<URI::GID gid://julia-observer/Visit/16787556>>

D, [2023-12-03T19:58:06.319704 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][36mOrganization Load (0.6ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:06.705261 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35m (0.2ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:06.708289 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35mSQL (1.1ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "39483292-1902-4291-aa9b-6ee6154780d8"], ["visitor_token", "0d68ff9e-8551-441b-bfd7-2946c7de4901"], ["ip", "64.252.72.83"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/packages/JWAS"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:06 UTC]]]

D, [2023-12-03T19:58:06.709334 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:06.710845 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:06.712223 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35mSQL (0.3ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 542feddf-368d-4fcd-961e-c38e8765c3a7\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787557\n locale: en\n"], ["run_at", 2023-12-03 19:58:06 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:06 UTC], ["updated_at", 2023-12-03 19:58:06 UTC]]]

D, [2023-12-03T19:58:06.713213 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:06.713577 #3056] INFO -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 542feddf-368d-4fcd-961e-c38e8765c3a7) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00f02d1868 @uri=#<URI::GID gid://julia-observer/Visit/16787557>>

D, [2023-12-03T19:58:06.716276 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][36mOrganization Load (0.6ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:07.456316 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][36mPackage Load (1135.3ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "CommonSubexpressions"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:07.458036 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:07.500015 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][36mPackage Load (41.1ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%CommonSubexpressions%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:07.504115 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35m (0.2ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:07.505837 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35mSQL (0.4ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: ActionMailer::DeliveryJob\n job_id: b2e57bed-94a9-4099-8b03-273077ea1ce5\n queue_name: mailers\n priority: \n arguments:\n - ErrorLogMailer\n - log_email\n - deliver_now\n - Package\n - CommonSubexpressions\n - \n - controller: packages\n action: show\n id: CommonSubexpressions\n _aj_hash_with_indifferent_access: true\n - ahoy_visitor: 85a91401-8191-4409-9040-bc447b50b125\n ahoy_visit: 240c2a65-c327-4b3e-9165-12fb41374eed\n _aj_symbol_keys: []\n - \n locale: en\n"], ["run_at", 2023-12-03 19:58:07 UTC], ["queue", "mailers"], ["created_at", 2023-12-03 19:58:07 UTC], ["updated_at", 2023-12-03 19:58:07 UTC]]]

D, [2023-12-03T19:58:07.506962 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] ][1m][35m (0.8ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:07.507209 #3056] INFO -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] [ActiveJob] Enqueued ActionMailer::DeliveryJob (Job ID: b2e57bed-94a9-4099-8b03-273077ea1ce5) to DelayedJob(mailers) with arguments: "ErrorLogMailer", "log_email", "deliver_now", "Package", "CommonSubexpressions", nil, {"controller"=>"packages", "action"=>"show", "id"=>"CommonSubexpressions"}, {"ahoy_visitor"=>"85a91401-8191-4409-9040-bc447b50b125", "ahoy_visit"=>"240c2a65-c327-4b3e-9165-12fb41374eed"}, nil

D, [2023-12-03T19:58:07.842272 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][36mRelease Load (321.0ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:08.025695 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][36mPackage Load (1307.8ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "JWAS"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:08.027390 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:08.266619 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][36mPackage Load (238.4ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%JWAS%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:08.373158 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35m (103.7ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:08.677092 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35mSQL (301.7ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: ActionMailer::DeliveryJob\n job_id: a6fcc9b5-290f-4800-8ed8-4add902ed572\n queue_name: mailers\n priority: \n arguments:\n - ErrorLogMailer\n - log_email\n - deliver_now\n - Package\n - JWAS\n - \n - controller: packages\n action: show\n id: JWAS\n _aj_hash_with_indifferent_access: true\n - ahoy_visitor: 0d68ff9e-8551-441b-bfd7-2946c7de4901\n ahoy_visit: 39483292-1902-4291-aa9b-6ee6154780d8\n _aj_symbol_keys: []\n - \n locale: en\n"], ["run_at", 2023-12-03 19:58:08 UTC], ["queue", "mailers"], ["created_at", 2023-12-03 19:58:08 UTC], ["updated_at", 2023-12-03 19:58:08 UTC]]]

D, [2023-12-03T19:58:08.778739 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] ][1m][35m (101.1ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:08.779070 #3056] INFO -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] [ActiveJob] Enqueued ActionMailer::DeliveryJob (Job ID: a6fcc9b5-290f-4800-8ed8-4add902ed572) to DelayedJob(mailers) with arguments: "ErrorLogMailer", "log_email", "deliver_now", "Package", "JWAS", nil, {"controller"=>"packages", "action"=>"show", "id"=>"JWAS"}, {"ahoy_visitor"=>"0d68ff9e-8551-441b-bfd7-2946c7de4901", "ahoy_visit"=>"39483292-1902-4291-aa9b-6ee6154780d8"}, nil

D, [2023-12-03T19:58:10.284972 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35m (5.3ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:10.286648 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35mSQL (0.5ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787556], ["name", "Viewed: packages#show"], ["properties", "{}"], ["time", 2023-12-03 19:58:10 UTC]]]

D, [2023-12-03T19:58:10.287955 #3056 DEBUG -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] ][1m][35m (1.0ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:10.288329 #3056] INFO -- : [a2c50bb0-04a6-4a69-8443-e6cb4b4a8379] {:_method=>"GET", :_path=>"/packages/CommonSubexpressions", :_format=>:html, :_controller=>"PackagesController", :_action=>"show", :_status=>404, :_duration=>4158.1, :_view=>2455.88, :_db=>1685.06, :_time=>2023-12-03 19:58:06 +0000, :short_message=>"[404] GET /packages/CommonSubexpressions (PackagesController#show)"}

D, [2023-12-03T19:58:10.465062 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:10.474351 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35mSQL (8.1ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "8869f040-619b-4673-83f6-aeb5c25b60b4"], ["visitor_token", "8bcd4629-96e9-40a0-8f31-777e5db961ae"], ["ip", "64.252.72.83"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/packages/ViscousFlow"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:10 UTC]]]

D, [2023-12-03T19:58:10.475433 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:10.476669 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35m (0.2ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:10.477954 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35mSQL (0.4ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: e692836a-adfc-4212-9e86-668a7303e6f9\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787558\n locale: en\n"], ["run_at", 2023-12-03 19:58:10 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:10 UTC], ["updated_at", 2023-12-03 19:58:10 UTC]]]

D, [2023-12-03T19:58:10.479203 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35m (1.0ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:10.479526 #3056] INFO -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: e692836a-adfc-4212-9e86-668a7303e6f9) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00d9e74268 @uri=#<URI::GID gid://julia-observer/Visit/16787558>>

D, [2023-12-03T19:58:10.482049 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][36mOrganization Load (1.1ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:10.564042 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][36mRelease Load (1519.9ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:11.665787 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][36mPackage Load (1182.5ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "ViscousFlow"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:11.667524 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:11.809825 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][36mPackage Load (141.3ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%ViscousFlow%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:11.921096 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35m (105.8ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:12.023334 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35mSQL (100.8ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: ActionMailer::DeliveryJob\n job_id: 60e4d19d-609c-411c-aed8-6f2d2454f078\n queue_name: mailers\n priority: \n arguments:\n - ErrorLogMailer\n - log_email\n - deliver_now\n - Package\n - ViscousFlow\n - \n - controller: packages\n action: show\n id: ViscousFlow\n _aj_hash_with_indifferent_access: true\n - ahoy_visitor: 8bcd4629-96e9-40a0-8f31-777e5db961ae\n ahoy_visit: 8869f040-619b-4673-83f6-aeb5c25b60b4\n _aj_symbol_keys: []\n - \n locale: en\n"], ["run_at", 2023-12-03 19:58:11 UTC], ["queue", "mailers"], ["created_at", 2023-12-03 19:58:11 UTC], ["updated_at", 2023-12-03 19:58:11 UTC]]]

D, [2023-12-03T19:58:12.124888 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] ][1m][35m (101.1ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:12.125181 #3056] INFO -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] [ActiveJob] Enqueued ActionMailer::DeliveryJob (Job ID: 60e4d19d-609c-411c-aed8-6f2d2454f078) to DelayedJob(mailers) with arguments: "ErrorLogMailer", "log_email", "deliver_now", "Package", "ViscousFlow", nil, {"controller"=>"packages", "action"=>"show", "id"=>"ViscousFlow"}, {"ahoy_visitor"=>"8bcd4629-96e9-40a0-8f31-777e5db961ae", "ahoy_visit"=>"8869f040-619b-4673-83f6-aeb5c25b60b4"}, nil

D, [2023-12-03T19:58:12.956775 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35m (5.3ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:12.958803 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35mSQL (0.8ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787557], ["name", "Viewed: packages#show"], ["properties", "{}"], ["time", 2023-12-03 19:58:12 UTC]]]

D, [2023-12-03T19:58:12.960072 #3056 DEBUG -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] ][1m][35m (0.8ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:12.960485 #3056] INFO -- : [0ee76bc6-efca-4099-803f-21c1a3b011c0] {:_method=>"GET", :_path=>"/packages/JWAS", :_format=>:html, :_controller=>"PackagesController", :_action=>"show", :_status=>404, :_duration=>6263.52, :_view=>2656.71, :_db=>3583.0, :_time=>2023-12-03 19:58:06 +0000, :short_message=>"[404] GET /packages/JWAS (PackagesController#show)"}

D, [2023-12-03T19:58:13.216494 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][36mRelease Load (1082.9ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:15.409007 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35m (6.6ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:15.411019 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35mSQL (1.0ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787558], ["name", "Viewed: packages#show"], ["properties", "{}"], ["time", 2023-12-03 19:58:15 UTC]]]

D, [2023-12-03T19:58:15.412191 #3056 DEBUG -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] ][1m][35m (0.8ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:15.412513 #3056] INFO -- : [ccb96ad6-968b-47cd-8bb8-fbf8bcd51866] {:_method=>"GET", :_path=>"/packages/ViscousFlow", :_format=>:html, :_controller=>"PackagesController", :_action=>"show", :_status=>404, :_duration=>4953.99, :_view=>2200.69, :_db=>2734.44, :_time=>2023-12-03 19:58:10 +0000, :short_message=>"[404] GET /packages/ViscousFlow (PackagesController#show)"}

D, [2023-12-03T19:58:17.470746 #3056] DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] [ahoy] Visit excluded

D, [2023-12-03T19:58:17.476925 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mOrganization Load (3.4ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:18.555973 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mPackage Exists (1077.7ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "Nihilist"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:18.557637 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mPackage Exists (0.6ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."id" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["id", 0], ["LIMIT", 1]]]

D, [2023-12-03T19:58:18.558650 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:18.597173 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mPackage Load (37.7ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%Nihilist%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:18.605901 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mUser Load (3.7ms)][0m ][1m][34mSELECT "users".* FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1) ORDER BY sum(contributions.score) desc LIMIT $4 OFFSET $5][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true], ["LIMIT", 100], ["OFFSET", 1700]]]

D, [2023-12-03T19:58:18.610646 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][35m (3.5ms)][0m ][1m][34mSELECT COUNT(*) AS count_all, users.id AS users_id FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1)][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:18.886759 #3056 DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] ][1m][36mRelease Load (266.6ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:21.236200 #3056] DEBUG -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] [ahoy] Event excluded

I, [2023-12-03T19:58:21.236492 #3056] INFO -- : [0ccd11ad-9080-491e-ae84-23d841287dc2] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>3766.55, :_view=>2363.34, :_db=>1393.23, :_time=>2023-12-03 19:58:17 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:58:31.640910 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35m (4.7ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:31.644123 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35mSQL (2.0ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "b22d2c11-bf51-40a1-a410-cd258ee79220"], ["visitor_token", "716ed863-32c5-40ef-baba-857221ba078b"], ["ip", "64.252.67.9"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/packages?depended_id=DiscreteFunctions"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:31 UTC]]]

D, [2023-12-03T19:58:31.645442 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35m (1.0ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:31.646557 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:31.647705 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] ][1m][35mSQL (0.3ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: b6da8421-fec8-403b-87a6-8a5f07d7fcfc\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787559\n locale: en\n"], ["run_at", 2023-12-03 19:58:31 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:31 UTC], ["updated_at", 2023-12-03 19:58:31 UTC]]]

D, [2023-12-03T19:58:31.648499 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] ][1m][35m (0.5ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:31.648767 #3056] INFO -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: b6da8421-fec8-403b-87a6-8a5f07d7fcfc) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00df1f5b08 @uri=#<URI::GID gid://julia-observer/Visit/16787559>>

I, [2023-12-03T19:58:31.653840 #3056] INFO -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] Performing PackageSorterJob from DelayedJob(default) with arguments: {"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"}, #<ActionDispatch::Cookies::CookieJar:0x00007f00df20a7b0 @set_cookies={"ahoy_visitor"=>{:value=>"716ed863-32c5-40ef-baba-857221ba078b", :expires=>Wed, 03 Dec 2025 19:58:31 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}, "ahoy_visit"=>{:value=>"b22d2c11-bf51-40a1-a410-cd258ee79220", :expires=>Sun, 03 Dec 2023 23:58:31 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}}, @delete_cookies={}, @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 @env={"rack.version"=>[1, 3], "rack.errors"=>#<IO:<STDERR>>, "rack.multithread"=>true, "rack.multiprocess"=>false, "rack.run_once"=>false, "SCRIPT_NAME"=>"", "QUERY_STRING"=>"depended_id=DiscreteFunctions", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"puma 3.12.1 Llamas in Pajamas", "GATEWAY_INTERFACE"=>"CGI/1.2", "REQUEST_METHOD"=>"GET", "REQUEST_PATH"=>"/packages", "REQUEST_URI"=>"/packages?depended_id=DiscreteFunctions", "HTTP_VERSION"=>"HTTP/1.0", "HTTP_HOST"=>"cdn.juliaobserver.com", "HTTP_X_REAL_IP"=>"64.252.67.9", "HTTP_X_FORWARDED_FOR"=>"185.191.171.10, 64.252.67.9", "HTTP_X_FORWARDED_PROTO"=>"http", "HTTP_CONNECTION"=>"close", "HTTP_USER_AGENT"=>"Amazon CloudFront", "HTTP_X_AMZ_CF_ID"=>"I68LuBnFcCrUAq6RmyG-2MIqUh5gf9uqWVFvcUnmczEd8oHLRolXQg==", "HTTP_VIA"=>"1.1 d3cd567650e598ded7d5dd9266aa396c.cloudfront.net (CloudFront)", "HTTP_ACCEPT_ENCODING"=>"gzip", "HTTP_CLOUDFRONT_VIEWER_COUNTRY"=>"GB", "SERVER_NAME"=>"cdn.juliaobserver.com", "SERVER_PORT"=>"80", "PATH_INFO"=>"/packages", "REMOTE_ADDR"=>"127.0.0.1", "puma.socket"=>#<TCPSocket:fd 13, AF_INET, 127.0.0.1, 3000>, "rack.hijack?"=>true, "rack.hijack"=>#<Puma::Client:0x3f806f90a450 @ready=true>, "rack.input"=>#<Puma::NullIO:0x000055fc7cbc5ad8>, "rack.url_scheme"=>"http", "rack.after_reply"=>[], "puma.config"=>#<Puma::Configuration:0x000055fc7cd33a28 @options=#<Puma::UserFileDefaultOptions:0x000055fc7cd33848 @user_options={:environment=>"production"}, @file_options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @default_options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}>, @plugins=#<Puma::PluginLoader:0x000055fc7cd337f8 @instances=[#<#<Class:0x000055fc7cd6fa00>:0x000055fc7cd6f938 @loader=Puma::Plugin>]>, @user_dsl=#<Puma::DSL:0x000055fc7cd337a8 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:environment=>"production"}, @plugins=[]>, @file_dsl=#<Puma::DSL:0x000055fc7cd33758 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @plugins=[], @path="config/puma.rb">, @default_dsl=#<Puma::DSL:0x000055fc7cd33708 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}, @plugins=[]>>, "action_dispatch.parameter_filter"=>[:password], "action_dispatch.redirect_filter"=>[], "action_dispatch.secret_token"=>nil, "action_dispatch.secret_key_base"=>"4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", "action_dispatch.show_exceptions"=>true, "action_dispatch.show_detailed_exceptions"=>true, "action_dispatch.logger"=>#<ActiveSupport::Logger:0x000055fc7f4a8748 @level=0, @progname=nil, @default_formatter=#<Logger::Formatter:0x000055fc7f4a86d0 @datetime_format=nil>, @formatter=#<Logger::Formatter:0x000055fc7f4a95d0 @datetime_format=nil, @thread_key="activesupport_tagged_logging_tags:47271477857000">, @logdev=#<Logger::LogDevice:0x000055fc7f4a8680 @shift_period_suffix=nil, @shift_size=nil, @shift_age=nil, @filename=nil, @dev=#<File:/home/rails/julia_observer/log/production.log>, @mon_mutex=#<Thread::Mutex:0x000055fc7f4a8608>, @mon_mutex_owner_object_id=47271477855040, @mon_owner=nil, @mon_count=0>, @local_levels=#<Concurrent::Map:0x000055fc7f4a8270 entries=0 default_proc=nil>, @thread_hash_level_key=:"ThreadSafeLogger#47271477855140@level">, "action_dispatch.backtrace_cleaner"=>#<Rails::BacktraceCleaner:0x000055fc7dbfcf78 @filters=[#<Proc:0x000055fc7dc3e2c0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:14>, #<Proc:0x000055fc7dc3e158@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:15>, #<Proc:0x000055fc7dc3dcf8@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:16>, #<Proc:0x000055fc7dc23ec0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:29>], @silencers=[#<Proc:0x000055fc7dc23ab0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:19>], @root="/home/rails/julia_observer/">, "action_dispatch.key_generator"=>#<ActiveSupport::CachingKeyGenerator:0x000055fc7f0ea520 @key_generator=#<ActiveSupport::KeyGenerator:0x000055fc7f0ea548 @secret="4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", @iterations=1000>, @cache_keys=#<Concurrent::Map:0x000055fc7f0ea480 entries=3 default_proc=nil>>, "action_dispatch.http_auth_salt"=>"http authentication", "action_dispatch.signed_cookie_salt"=>"signed cookie", "action_dispatch.encrypted_cookie_salt"=>"encrypted cookie", "action_dispatch.encrypted_signed_cookie_salt"=>"signed encrypted cookie", "action_dispatch.cookies_serializer"=>:json, "action_dispatch.cookies_digest"=>nil, "action_dispatch.routes"=>#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>, "ROUTES_47271477352840_SCRIPT_NAME"=>"", "ORIGINAL_FULLPATH"=>"/packages?depended_id=DiscreteFunctions", "ORIGINAL_SCRIPT_NAME"=>"", "rack.cors"=>#<Rack::Cors::Result:0x00007f00df214238 @preflight=false, @hit=false, @miss_reason="no-origin">, "action_dispatch.request_id"=>"2c716803-4808-4734-94ff-6451a49bf471", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::GetIp:0x00007f00f6aa3680 @req=#<ActionDispatch::Request:0x00007f00f6aa36a8 @env={...}, @filtered_parameters=nil, @filtered_env=nil, @filtered_path=nil, @protocol=nil, @port=nil, @method=nil, @request_method=nil, @remote_ip=nil, @original_fullpath=nil, @fullpath=nil, @ip=nil>, @check_ip=true, @proxies=[#<IPAddr: IPv4:127.0.0.1/255.255.255.255>, #<IPAddr: IPv6:0000:0000:0000:0000:0000:0000:0000:0001/ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff>, #<IPAddr: IPv6:fc00:0000:0000:0000:0000:0000:0000:0000/fe00:0000:0000:0000:0000:0000:0000:0000>, #<IPAddr: IPv4:10.0.0.0/255.0.0.0>, #<IPAddr: IPv4:172.16.0.0/255.240.0.0>, #<IPAddr: IPv4:192.168.0.0/255.255.0.0>], @ip="64.252.67.9">, "rack.session"=>#<ActionDispatch::Request::Session:0x7f00f6aa35b8 not yet loaded>, "rack.session.options"=>#<ActionDispatch::Request::Session::Options:0x00007f00f6aa3568 @by=#<ActionDispatch::Session::CookieStore:0x000055fc80517d68 @app=#<Rack::Head:0x000055fc80517d90 @app=#<Rack::ConditionalGet:0x000055fc80517db8 @app=#<Rack::ETag:0x000055fc80517de0 @app=#<Rack::Attack:0x000055fc80517e08 @app=#<Ahoy::Throttle:0x000055fc80517e30 @app=#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>>>, @cache_control="max-age=0, private, must-revalidate", @no_cache_control="no-cache">>>, @default_options={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}, @key="_julia_observer_session", @cookie_only=true>, @delegate={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}>, "rack.attack.throttle_data"=>{"req/ip"=>{:count=>3, :period=>300, :limit=>500, :epoch_time=>1701633511}}, "action_dispatch.request.path_parameters"=>{:controller=>"packages", :action=>"index"}, "action_controller.instance"=>#<PackagesController:0x00007f00f6aa0e80 @_action_has_layout=true, @_routes=nil, @_request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>, @_response=#<ActionDispatch::Response:0x00007f00f6aa1060 @mon_mutex=#<Thread::Mutex:0x00007f00f6aa1010>, @mon_mutex_owner_object_id=69821057534000, @mon_owner=nil, @mon_count=0, @header={"X-Frame-Options"=>"SAMEORIGIN", "X-XSS-Protection"=>"1; mode=block", "X-Content-Type-Options"=>"nosniff"}, @stream=#<ActionDispatch::Response::Buffer:0x00007f00f6aa0fc0 @response=#<ActionDispatch::Response:0x00007f00f6aa1060 ...>, @buf=[], @closed=false, @str_body=nil>, @status=200, @cv=#<MonitorMixin::ConditionVariable:0x00007f00f6aa0f98 @monitor=#<ActionDispatch::Response:0x00007f00f6aa1060 ...>, @cond=#<Thread::ConditionVariable:0x00007f00f6aa0f70>>, @committed=false, @sending=false, @sent=false, @cache_control={}, @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>>, @_lookup_context=#<ActionView::LookupContext:0x00007f00f6aa0db8 @details_key=nil, @cache=true, @prefixes=["packages", "application"], @rendered_format=nil, @details={:locale=>[:en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :coffee, :jbuilder]}, @view_paths=#<ActionView::PathSet:0x00007f00f6aa0cc8 @paths=[#<ActionView::OptimizedFileSystemResolver:0x000055fc7f479240 @pattern=":prefix/:action{.:locale,}{.:formats,}{+:variants,}{.:handlers,}", @cache=#<ActionView::Resolver::Cache:0x55fc7f479218 keys=484 queries=0>, @path="/home/rails/julia_observer/app/views">]>>, @_action_name="index", @_response_body=nil, @ahoy=#<Ahoy::Tracker:0x00007f00df20b840 @store=#<Ahoy::Store:0x00007f00df20b7c8 @options={:controller=>#<PackagesController:0x00007f00f6aa0e80 ...>, :ahoy=>#<Ahoy::Tracker:0x00007f00df20b840 ...>}, @controller=#<PackagesController:0x00007f00f6aa0e80 ...>, @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>, @bot=false, @ahoy=#<Ahoy::Tracker:0x00007f00df20b840 ...>, @user=nil, @visit=#<Visit id: 16787559, visit_token: "b22d2c11-bf51-40a1-a410-cd258ee79220", visitor_token: "716ed863-32c5-40ef-baba-857221ba078b", ip: "64.252.67.9", user_agent: "Amazon CloudFront", referrer: nil, landing_page: "http://cdn.juliaobserver.com/packages?depended_id=...", user_id: nil, referring_domain: nil, search_keyword: nil, browser: "Other", os: "Other", device_type: "Desktop", screen_height: nil, screen_width: nil, country: nil, region: nil, city: nil, postal_code: nil, latitude: nil, longitude: nil, utm_source: nil, utm_medium: nil, utm_term: nil, utm_content: nil, utm_campaign: nil, started_at: "2023-12-03 19:58:31">>, @controller=#<PackagesController:0x00007f00f6aa0e80 ...>, @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>, @options={:controller=>#<PackagesController:0x00007f00f6aa0e80 ...>}, @visitor_header=nil, @visitor_cookie=nil, @existing_visitor_token=nil, @visitor_token_helper="716ed863-32c5-40ef-baba-857221ba078b", @visitor_id="716ed863-32c5-40ef-baba-857221ba078b", @visit_header=nil, @visit_cookie=nil, @existing_visit_token=nil, @visit_token_helper="b22d2c11-bf51-40a1-a410-cd258ee79220", @visit_id="b22d2c11-bf51-40a1-a410-cd258ee79220", @visit_token="b22d2c11-bf51-40a1-a410-cd258ee79220", @visitor_token="716ed863-32c5-40ef-baba-857221ba078b", @visit_properties=#<Ahoy::VisitProperties:0x00007f00fec5f750 @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>, @options={:api=>nil}, @request_deckhand=#<Ahoy::Deckhands::RequestDeckhand:0x00007f00fec5f660 @request=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>, @options={:api=>nil}, @params={"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"}>, @traffic_source_deckhand=#<Ahoy::Deckhands::TrafficSourceDeckhand:0x00007f00df207380 @referrer=nil, @referring_domain=nil, @search_keyword=nil>, @utm_parameter_deckhand=#<Ahoy::Deckhands::UtmParameterDeckhand:0x00007f00df206a48 @landing_page="http://cdn.juliaobserver.com/packages?depended_id=DiscreteFunctions", @params={"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"}, @landing_params={"depended_id"=>"DiscreteFunctions"}>, @technology_deckhand=#<Ahoy::Deckhands::TechnologyDeckhand:0x00007f00df205d00 @user_agent="Amazon CloudFront", @agent=#<UserAgentParser::UserAgent Other (Other) (Other)>, @device_type="Desktop">>>, @marked_for_same_origin_verification=true, @_config={}, @_params=<ActionController::Parameters {"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"} permitted: false>>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"depended_id=DiscreteFunctions", "rack.request.query_hash"=>{"depended_id"=>"DiscreteFunctions"}, "action_dispatch.request.query_parameters"=>{"depended_id"=>"DiscreteFunctions"}, "action_dispatch.request.parameters"=>{"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x000055fc7e34f410 @synonyms=["application/xhtml+xml"], @symbol=:html, @string="text/html", @hash=-2234802910782609731>], "rack.request.cookie_hash"=>{}, "action_dispatch.cookies"=>#<ActionDispatch::Cookies::CookieJar:0x00007f00df20a7b0 ...>, "action_dispatch.request.unsigned_session_cookie"=>{}}, @filtered_parameters={"depended_id"=>"DiscreteFunctions", "controller"=>"packages", "action"=>"index"}, @filtered_env=nil, @filtered_path=nil, @protocol="http://", @port=80, @method=nil, @request_method="GET", @remote_ip="64.252.67.9", @original_fullpath="/packages?depended_id=DiscreteFunctions", @fullpath="/packages?depended_id=DiscreteFunctions", @ip=nil, @headers=#<ActionDispatch::Http::Headers:0x00007f00df20be30 @req=#<ActionDispatch::Request:0x00007f00f6aa1ba0 ...>>>, @cookies={"ahoy_visitor"=>"716ed863-32c5-40ef-baba-857221ba078b", "ahoy_visit"=>"b22d2c11-bf51-40a1-a410-cd258ee79220"}, @committed=false, @encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00df1f55b8 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00df20a7b0 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00df1f5450 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00df1f53b0 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>, @signed_or_encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00df1f55b8 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00df20a7b0 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00df1f5450 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00df1f53b0 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>>

D, [2023-12-03T19:58:31.656884 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] ][1m][36mOrganization Load (1.6ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:32.697088 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] ][1m][36mPackage Load (1039.0ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "DiscreteFunctions"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:32.698773 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:32.733187 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] ][1m][36mPackage Load (33.6ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%DiscreteFunctions%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:32.734776 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

I, [2023-12-03T19:58:32.735461 #3056] INFO -- : [2c716803-4808-4734-94ff-6451a49bf471] [ActiveJob] [PackageSorterJob] [5c8f1484-48a4-4cef-9cb3-e7be4922d5d2] Performed PackageSorterJob from DelayedJob(default) in 1081.4ms

D, [2023-12-03T19:58:33.574500 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35mSQL (837.4ms)][0m ][1m][34mSELECT "packages"."id" AS t0_r0, "packages"."name" AS t0_r1, "packages"."created_at" AS t0_r2, "packages"."updated_at" AS t0_r3, "packages"."description" AS t0_r4, "packages"."homepage" AS t0_r5, "packages"."owner_type" AS t0_r6, "packages"."owner_id" AS t0_r7, "packages"."is_registered" AS t0_r8, "packages"."readme" AS t0_r9, "packages"."readme_type" AS t0_r10, "daters"."id" AS t1_r0, "daters"."created" AS t1_r1, "daters"."updated" AS t1_r2, "daters"."pushed" AS t1_r3, "daters"."package_id" AS t1_r4, "daters"."created_at" AS t1_r5, "daters"."updated_at" AS t1_r6, "daters"."touched" AS t1_r7, "counters"."id" AS t2_r0, "counters"."fork" AS t2_r1, "counters"."stargazer" AS t2_r2, "counters"."open_issue" AS t2_r3, "counters"."package_id" AS t2_r4, "counters"."created_at" AS t2_r5, "counters"."updated_at" AS t2_r6, "counters"."contributor" AS t2_r7, "activities"."id" AS t3_r0, "activities"."commits" AS t3_r1, "activities"."package_id" AS t3_r2, "activities"."created_at" AS t3_r3, "activities"."updated_at" AS t3_r4, "activities"."recent_commit_count" AS t3_r5 FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 INNER JOIN "daters" ON "daters"."package_id" = "packages"."id" INNER JOIN "counters" ON "counters"."package_id" = "packages"."id" INNER JOIN "activities" ON "activities"."package_id" = "packages"."id" WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."is_registered" = $3 ORDER BY counters.stargazer desc LIMIT $4 OFFSET $5][0m [["item_type", "Package"], ["marker", 5931], ["is_registered", true], ["LIMIT", 30], ["OFFSET", 0]]]

D, [2023-12-03T19:58:33.599750 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][36mCategory Load (13.5ms)][0m ][1m][34mSELECT "categories".* FROM "categories" INNER JOIN "batches" ON "batches"."item_id" = "categories"."id" AND "batches"."item_type" = $1 INNER JOIN "labels" ON "labels"."category_id" = "categories"."id" INNER JOIN "packages" ON "packages"."id" = "labels"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY categories.id ORDER BY count(categories.id) desc][0m [["item_type", "Category"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:33.960538 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][36mRelease Load (344.8ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:36.164969 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35m (3.2ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:36.168140 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35mSQL (1.8ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787559], ["name", "Viewed: packages#index"], ["properties", "{}"], ["time", 2023-12-03 19:58:36 UTC]]]

D, [2023-12-03T19:58:36.170149 #3056 DEBUG -- : [2c716803-4808-4734-94ff-6451a49bf471] ][1m][35m (1.6ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:36.170561 #3056] INFO -- : [2c716803-4808-4734-94ff-6451a49bf471] {:_method=>"GET", :_path=>"/packages", :_format=>:html, :_controller=>"PackagesController", :_action=>"index", :_status=>200, :_duration=>4537.55, :_view=>2226.9, :_db=>2285.03, :_time=>2023-12-03 19:58:31 +0000, :short_message=>"[200] GET /packages (PackagesController#index)"}

D, [2023-12-03T19:58:37.896993 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:37.899255 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35mSQL (1.2ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "7df31af6-0c06-4632-b1cc-6ff1d09fda1c"], ["visitor_token", "bbf6a3d9-5b8b-4eb2-8fde-cce079721f2e"], ["ip", "64.252.66.216"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/users?package_id=AbstractDomains"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:37 UTC]]]

D, [2023-12-03T19:58:37.900170 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:37.901259 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:37.902325 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] [ActiveJob] ][1m][35mSQL (0.2ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 15972d36-70c0-477c-8405-0ce177523b8a\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787560\n locale: en\n"], ["run_at", 2023-12-03 19:58:37 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:37 UTC], ["updated_at", 2023-12-03 19:58:37 UTC]]]

D, [2023-12-03T19:58:37.903162 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] [ActiveJob] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:37.903405 #3056] INFO -- : [aace781f-e02c-43b7-989f-852d78458fc0] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 15972d36-70c0-477c-8405-0ce177523b8a) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00fd9b0b68 @uri=#<URI::GID gid://julia-observer/Visit/16787560>>

D, [2023-12-03T19:58:37.905324 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mOrganization Load (0.5ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:39.932010 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mPackage Exists (2025.5ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "AbstractDomains"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:39.933449 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:39.958700 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mPackage Load (24.2ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "AbstractDomains"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:39.960693 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mContribution Load (0.4ms)][0m ][1m][34mSELECT "contributions".* FROM "contributions" WHERE "contributions"."package_id" = $1 ORDER BY "contributions"."score" DESC][0m [["package_id", 45639768]]]

D, [2023-12-03T19:58:40.247399 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][36mRelease Load (267.5ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:42.564904 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35m (4.6ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:42.569911 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35mSQL (3.9ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787560], ["name", "Viewed: users#index"], ["properties", "{}"], ["time", 2023-12-03 19:58:42 UTC]]]

D, [2023-12-03T19:58:42.571184 #3056 DEBUG -- : [aace781f-e02c-43b7-989f-852d78458fc0] ][1m][35m (0.9ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:42.571712 #3056] INFO -- : [aace781f-e02c-43b7-989f-852d78458fc0] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>4677.88, :_view=>2327.98, :_db=>2330.4, :_time=>2023-12-03 19:58:37 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:58:46.093074 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:46.095672 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35mSQL (1.2ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "referrer", "landing_page", "referring_domain", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING "id"][0m [["visit_token", "c3f66093-848e-43bb-b7bf-ad13067f8d47"], ["visitor_token", "cd784081-6786-4c57-ae00-f95a04b00e91"], ["ip", "64.252.104.5"], ["user_agent", "Amazon CloudFront"], ["referrer", "https://juliaobserver.com/packages/TalkSetup"], ["landing_page", "http://cdn.juliaobserver.com/packages?depended_id=TalkSetup"], ["referring_domain", "juliaobserver.com"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:46 UTC]]]

D, [2023-12-03T19:58:46.096690 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:46.097975 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:46.099134 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] ][1m][35mSQL (0.3ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 9237ea7b-90e5-4ea0-9a32-c949e74201b9\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787561\n locale: en\n"], ["run_at", 2023-12-03 19:58:46 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:46 UTC], ["updated_at", 2023-12-03 19:58:46 UTC]]]

D, [2023-12-03T19:58:46.099950 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:46.100397 #3056] INFO -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 9237ea7b-90e5-4ea0-9a32-c949e74201b9) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00e45fc0a8 @uri=#<URI::GID gid://julia-observer/Visit/16787561>>

I, [2023-12-03T19:58:46.109822 #3056] INFO -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] Performing PackageSorterJob from DelayedJob(default) with arguments: {"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"}, #<ActionDispatch::Cookies::CookieJar:0x00007f00ff369168 @set_cookies={"ahoy_visitor"=>{:value=>"cd784081-6786-4c57-ae00-f95a04b00e91", :expires=>Wed, 03 Dec 2025 19:58:46 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}, "ahoy_visit"=>{:value=>"c3f66093-848e-43bb-b7bf-ad13067f8d47", :expires=>Sun, 03 Dec 2023 23:58:46 UTC +00:00, :domain=>".juliaobserver.com", :path=>"/"}}, @delete_cookies={}, @request=#<ActionDispatch::Request:0x00007f00ff40d330 @env={"rack.version"=>[1, 3], "rack.errors"=>#<IO:<STDERR>>, "rack.multithread"=>true, "rack.multiprocess"=>false, "rack.run_once"=>false, "SCRIPT_NAME"=>"", "QUERY_STRING"=>"depended_id=TalkSetup", "SERVER_PROTOCOL"=>"HTTP/1.1", "SERVER_SOFTWARE"=>"puma 3.12.1 Llamas in Pajamas", "GATEWAY_INTERFACE"=>"CGI/1.2", "REQUEST_METHOD"=>"GET", "REQUEST_PATH"=>"/packages", "REQUEST_URI"=>"/packages?depended_id=TalkSetup", "HTTP_VERSION"=>"HTTP/1.0", "HTTP_HOST"=>"cdn.juliaobserver.com", "HTTP_X_REAL_IP"=>"64.252.104.5", "HTTP_X_FORWARDED_FOR"=>"114.119.129.199, 64.252.104.5", "HTTP_X_FORWARDED_PROTO"=>"http", "HTTP_CONNECTION"=>"close", "HTTP_USER_AGENT"=>"Amazon CloudFront", "HTTP_X_AMZ_CF_ID"=>"stajh7JY9_oF-l3Q4b2FZ8eoEg3Spkk6dE3iYQPd6mFf4H-4omWfJg==", "HTTP_REFERER"=>"https://juliaobserver.com/packages/TalkSetup", "HTTP_VIA"=>"1.1 9f6f7c775068d68476f4af0ffa848d4a.cloudfront.net (CloudFront)", "HTTP_ACCEPT_ENCODING"=>"gzip", "HTTP_CLOUDFRONT_VIEWER_COUNTRY"=>"SG", "SERVER_NAME"=>"cdn.juliaobserver.com", "SERVER_PORT"=>"80", "PATH_INFO"=>"/packages", "REMOTE_ADDR"=>"127.0.0.1", "puma.socket"=>#<TCPSocket:fd 13, AF_INET, 127.0.0.1, 3000>, "rack.hijack?"=>true, "rack.hijack"=>#<Puma::Client:0x3f807f884674 @ready=true>, "rack.input"=>#<Puma::NullIO:0x000055fc7cbc5ad8>, "rack.url_scheme"=>"http", "rack.after_reply"=>[], "puma.config"=>#<Puma::Configuration:0x000055fc7cd33a28 @options=#<Puma::UserFileDefaultOptions:0x000055fc7cd33848 @user_options={:environment=>"production"}, @file_options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @default_options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}>, @plugins=#<Puma::PluginLoader:0x000055fc7cd337f8 @instances=[#<#<Class:0x000055fc7cd6fa00>:0x000055fc7cd6f938 @loader=Puma::Plugin>]>, @user_dsl=#<Puma::DSL:0x000055fc7cd337a8 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:environment=>"production"}, @plugins=[]>, @file_dsl=#<Puma::DSL:0x000055fc7cd33758 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>5, :max_threads=>5, :binds=>["tcp://0.0.0.0:3000"], :environment=>"production"}, @plugins=[], @path="config/puma.rb">, @default_dsl=#<Puma::DSL:0x000055fc7cd33708 @config=#<Puma::Configuration:0x000055fc7cd33a28 ...>, @options={:min_threads=>0, :max_threads=>16, :log_requests=>false, :debug=>false, :binds=>["tcp://0.0.0.0:9292"], :workers=>0, :daemon=>false, :mode=>:http, :worker_timeout=>60, :worker_boot_timeout=>60, :worker_shutdown_timeout=>30, :remote_address=>:socket, :tag=>"julia_observer", :environment=>"production", :rackup=>"config.ru", :logger=>#<IO:<STDOUT>>, :persistent_timeout=>20, :first_data_timeout=>30}, @plugins=[]>>, "action_dispatch.parameter_filter"=>[:password], "action_dispatch.redirect_filter"=>[], "action_dispatch.secret_token"=>nil, "action_dispatch.secret_key_base"=>"4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", "action_dispatch.show_exceptions"=>true, "action_dispatch.show_detailed_exceptions"=>true, "action_dispatch.logger"=>#<ActiveSupport::Logger:0x000055fc7f4a8748 @level=0, @progname=nil, @default_formatter=#<Logger::Formatter:0x000055fc7f4a86d0 @datetime_format=nil>, @formatter=#<Logger::Formatter:0x000055fc7f4a95d0 @datetime_format=nil, @thread_key="activesupport_tagged_logging_tags:47271477857000">, @logdev=#<Logger::LogDevice:0x000055fc7f4a8680 @shift_period_suffix=nil, @shift_size=nil, @shift_age=nil, @filename=nil, @dev=#<File:/home/rails/julia_observer/log/production.log>, @mon_mutex=#<Thread::Mutex:0x000055fc7f4a8608>, @mon_mutex_owner_object_id=47271477855040, @mon_owner=nil, @mon_count=0>, @local_levels=#<Concurrent::Map:0x000055fc7f4a8270 entries=0 default_proc=nil>, @thread_hash_level_key=:"ThreadSafeLogger#47271477855140@level">, "action_dispatch.backtrace_cleaner"=>#<Rails::BacktraceCleaner:0x000055fc7dbfcf78 @filters=[#<Proc:0x000055fc7dc3e2c0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:14>, #<Proc:0x000055fc7dc3e158@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:15>, #<Proc:0x000055fc7dc3dcf8@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:16>, #<Proc:0x000055fc7dc23ec0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:29>], @silencers=[#<Proc:0x000055fc7dc23ab0@/home/rails/.rvm/gems/ruby-2.6.3/gems/railties-5.0.1.rc2/lib/rails/backtrace_cleaner.rb:19>], @root="/home/rails/julia_observer/">, "action_dispatch.key_generator"=>#<ActiveSupport::CachingKeyGenerator:0x000055fc7f0ea520 @key_generator=#<ActiveSupport::KeyGenerator:0x000055fc7f0ea548 @secret="4fba9bb4f507809b538fbfaec3d81791ceb10d67c2c41396d13713d6c9e2fbbe936e079ab7efaad736ac19f965e1e7b8811c20c0b159ecab2c3cf24e88dccdd5", @iterations=1000>, @cache_keys=#<Concurrent::Map:0x000055fc7f0ea480 entries=3 default_proc=nil>>, "action_dispatch.http_auth_salt"=>"http authentication", "action_dispatch.signed_cookie_salt"=>"signed cookie", "action_dispatch.encrypted_cookie_salt"=>"encrypted cookie", "action_dispatch.encrypted_signed_cookie_salt"=>"signed encrypted cookie", "action_dispatch.cookies_serializer"=>:json, "action_dispatch.cookies_digest"=>nil, "action_dispatch.routes"=>#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>, "ROUTES_47271477352840_SCRIPT_NAME"=>"", "ORIGINAL_FULLPATH"=>"/packages?depended_id=TalkSetup", "ORIGINAL_SCRIPT_NAME"=>"", "rack.cors"=>#<Rack::Cors::Result:0x00007f00ff1084c8 @preflight=false, @hit=false, @miss_reason="no-origin">, "action_dispatch.request_id"=>"20982efc-f89c-48ba-b796-d40d0879f89c", "action_dispatch.remote_ip"=>#<ActionDispatch::RemoteIp::GetIp:0x00007f00ff40f658 @req=#<ActionDispatch::Request:0x00007f00ff40f680 @env={...}, @filtered_parameters=nil, @filtered_env=nil, @filtered_path=nil, @protocol=nil, @port=nil, @method=nil, @request_method=nil, @remote_ip=nil, @original_fullpath=nil, @fullpath=nil, @ip=nil>, @check_ip=true, @proxies=[#<IPAddr: IPv4:127.0.0.1/255.255.255.255>, #<IPAddr: IPv6:0000:0000:0000:0000:0000:0000:0000:0001/ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff>, #<IPAddr: IPv6:fc00:0000:0000:0000:0000:0000:0000:0000/fe00:0000:0000:0000:0000:0000:0000:0000>, #<IPAddr: IPv4:10.0.0.0/255.0.0.0>, #<IPAddr: IPv4:172.16.0.0/255.240.0.0>, #<IPAddr: IPv4:192.168.0.0/255.255.0.0>], @ip="64.252.104.5">, "rack.session"=>#<ActionDispatch::Request::Session:0x7f00ff40f568 not yet loaded>, "rack.session.options"=>#<ActionDispatch::Request::Session::Options:0x00007f00ff40f4f0 @by=#<ActionDispatch::Session::CookieStore:0x000055fc80517d68 @app=#<Rack::Head:0x000055fc80517d90 @app=#<Rack::ConditionalGet:0x000055fc80517db8 @app=#<Rack::ETag:0x000055fc80517de0 @app=#<Rack::Attack:0x000055fc80517e08 @app=#<Ahoy::Throttle:0x000055fc80517e30 @app=#<ActionDispatch::Routing::RouteSet:0x000055fc7f3b3310>>>, @cache_control="max-age=0, private, must-revalidate", @no_cache_control="no-cache">>>, @default_options={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}, @key="_julia_observer_session", @cookie_only=true>, @delegate={:path=>"/", :domain=>nil, :expire_after=>nil, :secure=>false, :httponly=>true, :defer=>false, :renew=>false}>, "rack.attack.throttle_data"=>{"req/ip"=>{:count=>3, :period=>300, :limit=>500, :epoch_time=>1701633526}}, "action_dispatch.request.path_parameters"=>{:controller=>"packages", :action=>"index"}, "action_controller.instance"=>#<PackagesController:0x00007f00ff40c2f0 @_action_has_layout=true, @_routes=nil, @_request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>, @_response=#<ActionDispatch::Response:0x00007f00ff40c520 @mon_mutex=#<Thread::Mutex:0x00007f00ff40c4d0>, @mon_mutex_owner_object_id=69821129581200, @mon_owner=nil, @mon_count=0, @header={"X-Frame-Options"=>"SAMEORIGIN", "X-XSS-Protection"=>"1; mode=block", "X-Content-Type-Options"=>"nosniff"}, @stream=#<ActionDispatch::Response::Buffer:0x00007f00ff40c480 @response=#<ActionDispatch::Response:0x00007f00ff40c520 ...>, @buf=[], @closed=false, @str_body=nil>, @status=200, @cv=#<MonitorMixin::ConditionVariable:0x00007f00ff40c458 @monitor=#<ActionDispatch::Response:0x00007f00ff40c520 ...>, @cond=#<Thread::ConditionVariable:0x00007f00ff40c408>>, @committed=false, @sending=false, @sent=false, @cache_control={}, @request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>>, @_lookup_context=#<ActionView::LookupContext:0x00007f00ff40c200 @details_key=nil, @cache=true, @prefixes=["packages", "application"], @rendered_format=nil, @details={:locale=>[:en], :formats=>[:html], :variants=>[], :handlers=>[:raw, :erb, :html, :builder, :ruby, :coffee, :jbuilder]}, @view_paths=#<ActionView::PathSet:0x00007f00ff40c0c0 @paths=[#<ActionView::OptimizedFileSystemResolver:0x000055fc7f479240 @pattern=":prefix/:action{.:locale,}{.:formats,}{+:variants,}{.:handlers,}", @cache=#<ActionView::Resolver::Cache:0x55fc7f479218 keys=486 queries=0>, @path="/home/rails/julia_observer/app/views">]>>, @_action_name="index", @_response_body=nil, @ahoy=#<Ahoy::Tracker:0x00007f00ff36a7c0 @store=#<Ahoy::Store:0x00007f00ff36a748 @options={:controller=>#<PackagesController:0x00007f00ff40c2f0 ...>, :ahoy=>#<Ahoy::Tracker:0x00007f00ff36a7c0 ...>}, @controller=#<PackagesController:0x00007f00ff40c2f0 ...>, @request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>, @bot=false, @ahoy=#<Ahoy::Tracker:0x00007f00ff36a7c0 ...>, @user=nil, @visit=#<Visit id: 16787561, visit_token: "c3f66093-848e-43bb-b7bf-ad13067f8d47", visitor_token: "cd784081-6786-4c57-ae00-f95a04b00e91", ip: "64.252.104.5", user_agent: "Amazon CloudFront", referrer: "https://juliaobserver.com/packages/TalkSetup", landing_page: "http://cdn.juliaobserver.com/packages?depended_id=...", user_id: nil, referring_domain: "juliaobserver.com", search_keyword: nil, browser: "Other", os: "Other", device_type: "Desktop", screen_height: nil, screen_width: nil, country: nil, region: nil, city: nil, postal_code: nil, latitude: nil, longitude: nil, utm_source: nil, utm_medium: nil, utm_term: nil, utm_content: nil, utm_campaign: nil, started_at: "2023-12-03 19:58:46">>, @controller=#<PackagesController:0x00007f00ff40c2f0 ...>, @request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>, @options={:controller=>#<PackagesController:0x00007f00ff40c2f0 ...>}, @visitor_header=nil, @visitor_cookie=nil, @existing_visitor_token=nil, @visitor_token_helper="cd784081-6786-4c57-ae00-f95a04b00e91", @visitor_id="cd784081-6786-4c57-ae00-f95a04b00e91", @visit_header=nil, @visit_cookie=nil, @existing_visit_token=nil, @visit_token_helper="c3f66093-848e-43bb-b7bf-ad13067f8d47", @visit_id="c3f66093-848e-43bb-b7bf-ad13067f8d47", @visit_token="c3f66093-848e-43bb-b7bf-ad13067f8d47", @visitor_token="cd784081-6786-4c57-ae00-f95a04b00e91", @visit_properties=#<Ahoy::VisitProperties:0x00007f00e416d438 @request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>, @options={:api=>nil}, @request_deckhand=#<Ahoy::Deckhands::RequestDeckhand:0x00007f00e416d2f8 @request=#<ActionDispatch::Request:0x00007f00ff40d330 ...>, @options={:api=>nil}, @params={"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"}>, @traffic_source_deckhand=#<Ahoy::Deckhands::TrafficSourceDeckhand:0x00007f00e42cfc90 @referrer="https://juliaobserver.com/packages/TalkSetup", @referring_domain="juliaobserver.com", @search_keyword=nil>, @utm_parameter_deckhand=#<Ahoy::Deckhands::UtmParameterDeckhand:0x00007f00e42ce818 @landing_page="http://cdn.juliaobserver.com/packages?depended_id=TalkSetup", @params={"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"}, @landing_params={"depended_id"=>"TalkSetup"}>, @technology_deckhand=#<Ahoy::Deckhands::TechnologyDeckhand:0x00007f00e42cd7d8 @user_agent="Amazon CloudFront", @agent=#<UserAgentParser::UserAgent Other (Other) (Other)>, @device_type="Desktop">>>, @marked_for_same_origin_verification=true, @_config={}, @_params=<ActionController::Parameters {"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"} permitted: false>>, "action_dispatch.request.content_type"=>nil, "action_dispatch.request.request_parameters"=>{}, "rack.request.query_string"=>"depended_id=TalkSetup", "rack.request.query_hash"=>{"depended_id"=>"TalkSetup"}, "action_dispatch.request.query_parameters"=>{"depended_id"=>"TalkSetup"}, "action_dispatch.request.parameters"=>{"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"}, "action_dispatch.request.formats"=>[#<Mime::Type:0x000055fc7e34f410 @synonyms=["application/xhtml+xml"], @symbol=:html, @string="text/html", @hash=-2234802910782609731>], "rack.request.cookie_hash"=>{}, "action_dispatch.cookies"=>#<ActionDispatch::Cookies::CookieJar:0x00007f00ff369168 ...>, "action_dispatch.request.unsigned_session_cookie"=>{}}, @filtered_parameters={"depended_id"=>"TalkSetup", "controller"=>"packages", "action"=>"index"}, @filtered_env=nil, @filtered_path=nil, @protocol="http://", @port=80, @method=nil, @request_method="GET", @remote_ip="64.252.104.5", @original_fullpath="/packages?depended_id=TalkSetup", @fullpath="/packages?depended_id=TalkSetup", @ip=nil, @headers=#<ActionDispatch::Http::Headers:0x00007f00ff36af18 @req=#<ActionDispatch::Request:0x00007f00ff40d330 ...>>>, @cookies={"ahoy_visitor"=>"cd784081-6786-4c57-ae00-f95a04b00e91", "ahoy_visit"=>"c3f66093-848e-43bb-b7bf-ad13067f8d47"}, @committed=false, @encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00e5853a08 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00ff369168 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00e5853850 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00e5853788 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>, @signed_or_encrypted=#<ActionDispatch::Cookies::EncryptedCookieJar:0x00007f00e5853a08 @parent_jar=#<ActionDispatch::Cookies::CookieJar:0x00007f00ff369168 ...>, @encryptor=#<ActiveSupport::MessageEncryptor:0x00007f00e5853850 @secret="\xE1\xA4\xD1\xA4}e\xA7NG\xA2\xC1Rsp\t\xBA\xCDv\xCE\x94L?l\xD6\xF5z\b\x8C\xD3\xE0\x9A\xB1", @sign_secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @cipher="aes-256-cbc", @verifier=#<ActiveSupport::MessageVerifier:0x00007f00e5853788 @secret="\x01\xA6\e\x9C)\xA0\xB0o\xCA\xC9\x83\r\xE0\xE0\xF2)\xCCxY\e1\v\xC0\x04\x95\x92\xDF\xF7\x19b\xD2d[}\xC8\x88\xB5E$\xE6i\xA2\x97d\x18c\x01\xD0\x99\x81xU#<\x89\xBB)\xC7\x93J\xF1\xCCfd", @digest="SHA1", @serializer=ActiveSupport::MessageEncryptor::NullSerializer>, @serializer=ActiveSupport::MessageEncryptor::NullSerializer>>>

D, [2023-12-03T19:58:46.112233 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] ][1m][36mOrganization Load (0.7ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:47.155653 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] ][1m][36mPackage Load (1042.1ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "TalkSetup"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:47.157766 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:47.194022 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] ][1m][36mPackage Load (35.3ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%TalkSetup%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:47.195769 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

I, [2023-12-03T19:58:47.196593 #3056] INFO -- : [20982efc-f89c-48ba-b796-d40d0879f89c] [ActiveJob] [PackageSorterJob] [b2dbbb0e-a0fb-4ac8-98dc-f756381e5ef1] Performed PackageSorterJob from DelayedJob(default) in 1086.55ms

D, [2023-12-03T19:58:47.300568 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:47.304553 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35mSQL (2.9ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "51161699-0874-4211-b826-6a900ed37623"], ["visitor_token", "fc4c62fa-288f-467f-a229-f8e39d568484"], ["ip", "64.252.67.9"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/users?package_id=Giac&page=2"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:58:47 UTC]]]

D, [2023-12-03T19:58:47.305881 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35m (0.7ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:58:47.308900 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] [ActiveJob] ][1m][35m (1.9ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:47.310471 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] [ActiveJob] ][1m][35mSQL (0.4ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 016a62fb-0eeb-4e6c-9338-4c61a2f42ecc\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787562\n locale: en\n"], ["run_at", 2023-12-03 19:58:47 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:58:47 UTC], ["updated_at", 2023-12-03 19:58:47 UTC]]]

D, [2023-12-03T19:58:47.313525 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] [ActiveJob] ][1m][35m (2.8ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:47.314016 #3056] INFO -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 016a62fb-0eeb-4e6c-9338-4c61a2f42ecc) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f00e79da460 @uri=#<URI::GID gid://julia-observer/Visit/16787562>>

D, [2023-12-03T19:58:47.317612 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mOrganization Load (1.8ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:47.949534 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35mSQL (750.6ms)][0m ][1m][34mSELECT "packages"."id" AS t0_r0, "packages"."name" AS t0_r1, "packages"."created_at" AS t0_r2, "packages"."updated_at" AS t0_r3, "packages"."description" AS t0_r4, "packages"."homepage" AS t0_r5, "packages"."owner_type" AS t0_r6, "packages"."owner_id" AS t0_r7, "packages"."is_registered" AS t0_r8, "packages"."readme" AS t0_r9, "packages"."readme_type" AS t0_r10, "daters"."id" AS t1_r0, "daters"."created" AS t1_r1, "daters"."updated" AS t1_r2, "daters"."pushed" AS t1_r3, "daters"."package_id" AS t1_r4, "daters"."created_at" AS t1_r5, "daters"."updated_at" AS t1_r6, "daters"."touched" AS t1_r7, "counters"."id" AS t2_r0, "counters"."fork" AS t2_r1, "counters"."stargazer" AS t2_r2, "counters"."open_issue" AS t2_r3, "counters"."package_id" AS t2_r4, "counters"."created_at" AS t2_r5, "counters"."updated_at" AS t2_r6, "counters"."contributor" AS t2_r7, "activities"."id" AS t3_r0, "activities"."commits" AS t3_r1, "activities"."package_id" AS t3_r2, "activities"."created_at" AS t3_r3, "activities"."updated_at" AS t3_r4, "activities"."recent_commit_count" AS t3_r5 FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 INNER JOIN "daters" ON "daters"."package_id" = "packages"."id" INNER JOIN "counters" ON "counters"."package_id" = "packages"."id" INNER JOIN "activities" ON "activities"."package_id" = "packages"."id" WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."is_registered" = $3 ORDER BY counters.stargazer desc LIMIT $4 OFFSET $5][0m [["item_type", "Package"], ["marker", 5931], ["is_registered", true], ["LIMIT", 30], ["OFFSET", 0]]]

D, [2023-12-03T19:58:47.972575 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][36mCategory Load (6.5ms)][0m ][1m][34mSELECT "categories".* FROM "categories" INNER JOIN "batches" ON "batches"."item_id" = "categories"."id" AND "batches"."item_type" = $1 INNER JOIN "labels" ON "labels"."category_id" = "categories"."id" INNER JOIN "packages" ON "packages"."id" = "labels"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY categories.id ORDER BY count(categories.id) desc][0m [["item_type", "Category"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:48.292861 #3056] DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] [ahoy] Visit excluded

D, [2023-12-03T19:58:48.303246 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mOrganization Load (2.5ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:48.334788 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][36mRelease Load (340.9ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:49.033702 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mPackage Exists (1714.1ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "Giac"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.136624 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mPackage Exists (101.1ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."id" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["id", 0], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.138180 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.289377 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mPackage Load (149.9ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%Giac%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:49.484830 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mPackage Exists (1174.9ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "CALFEM"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.488986 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mUser Load (193.4ms)][0m ][1m][34mSELECT "users".* FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1) ORDER BY sum(contributions.score) desc LIMIT $4 OFFSET $5][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true], ["LIMIT", 100], ["OFFSET", 100]]]

D, [2023-12-03T19:58:49.593216 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mPackage Exists (107.1ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."id" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["id", 0], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.698612 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:58:49.697057 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35m (206.7ms)][0m ][1m][34mSELECT COUNT(*) AS count_all, users.id AS users_id FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1)][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:50.298045 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mPackage Load (297.5ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%CALFEM%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:58:50.407618 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mUser Load (100.8ms)][0m ][1m][34mSELECT "users".* FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1) ORDER BY sum(contributions.score) desc LIMIT $4 OFFSET $5][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true], ["LIMIT", 100], ["OFFSET", 1400]]]

D, [2023-12-03T19:58:50.611113 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][35m (101.0ms)][0m ][1m][34mSELECT COUNT(*) AS count_all, users.id AS users_id FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1)][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:58:50.913603 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35m (4.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:50.916935 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35mSQL (2.3ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787561], ["name", "Viewed: packages#index"], ["properties", "{}"], ["time", 2023-12-03 19:58:50 UTC]]]

D, [2023-12-03T19:58:50.919150 #3056 DEBUG -- : [20982efc-f89c-48ba-b796-d40d0879f89c] ][1m][35m (1.4ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:50.919478 #3056] INFO -- : [20982efc-f89c-48ba-b796-d40d0879f89c] {:_method=>"GET", :_path=>"/packages", :_format=>:html, :_controller=>"PackagesController", :_action=>"index", :_status=>200, :_duration=>4834.28, :_view=>2610.36, :_db=>2186.87, :_time=>2023-12-03 19:58:46 +0000, :short_message=>"[200] GET /packages (PackagesController#index)"}

D, [2023-12-03T19:58:51.266355 #3056 DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] ][1m][36mRelease Load (355.8ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:53.045215 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][36mRelease Load (2835.3ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:58:56.850178 #3056] DEBUG -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] [ahoy] Event excluded

I, [2023-12-03T19:58:56.850573 #3056] INFO -- : [71213651-17db-4126-aeb6-c94b6b1d11ab] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>8559.33, :_view=>5992.67, :_db=>2139.57, :_time=>2023-12-03 19:58:48 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:58:57.496899 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35m (3.9ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:58:57.498398 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35mSQL (0.5ms)][0m ][1m][32mINSERT INTO "ahoy_events" ("visit_id", "name", "properties", "time") VALUES ($1, $2, $3, $4) RETURNING "id"][0m [["visit_id", 16787562], ["name", "Viewed: users#index"], ["properties", "{}"], ["time", 2023-12-03 19:58:57 UTC]]]

D, [2023-12-03T19:58:57.499940 #3056 DEBUG -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] ][1m][35m (1.3ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:58:57.500204 #3056] INFO -- : [ec1676ea-fce3-4490-b233-c2a2a0f66b04] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>10205.93, :_view=>4965.43, :_db=>5216.79, :_time=>2023-12-03 19:58:47 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:58:59.800506 #3056] DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] [ahoy] Visit excluded

D, [2023-12-03T19:58:59.806317 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mOrganization Load (0.7ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:59:00.875945 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mPackage Exists (1068.1ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."name" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["name", "QTL"], ["LIMIT", 1]]]

D, [2023-12-03T19:59:00.877948 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mPackage Exists (0.6ms)][0m ][1m][34mSELECT 1 AS one FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND "packages"."id" = $3 LIMIT $4][0m [["item_type", "Package"], ["marker", 5931], ["id", 0], ["LIMIT", 1]]]

D, [2023-12-03T19:59:00.879292 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mCACHE (0.0ms)][0m ][1m][34mSELECT "organizations".* FROM "organizations" INNER JOIN "batches" ON "batches"."item_id" = "organizations"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND "organizations"."name" = $3 LIMIT $4][0m [["item_type", "Organization"], ["marker", 5931], ["name", "UnofficialJuliaMirror"], ["LIMIT", 1]]]

D, [2023-12-03T19:59:00.915490 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mPackage Load (35.3ms)][0m ][1m][34mSELECT "packages".* FROM "packages" INNER JOIN "batches" ON "batches"."item_id" = "packages"."id" AND "batches"."item_type" = $1 WHERE "batches"."marker" = $2 AND (NOT (owner_id = 1033299 and owner_type = 'Organization')) AND (name ILIKE '%QTL%')][0m [["item_type", "Package"], ["marker", 5931]]]

D, [2023-12-03T19:59:00.924555 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mUser Load (3.8ms)][0m ][1m][34mSELECT "users".* FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1) ORDER BY sum(contributions.score) desc LIMIT $4 OFFSET $5][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true], ["LIMIT", 100], ["OFFSET", 200]]]

D, [2023-12-03T19:59:00.933084 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][35m (6.9ms)][0m ][1m][34mSELECT COUNT(*) AS count_all, users.id AS users_id FROM "users" INNER JOIN "batches" ON "batches"."item_id" = "users"."id" AND "batches"."item_type" = $1 INNER JOIN "contributions" ON "contributions"."user_id" = "users"."id" INNER JOIN "packages" ON "packages"."id" = "contributions"."package_id" WHERE "batches"."marker" = $2 AND "packages"."is_registered" = $3 GROUP BY users.id HAVING (sum(contributions.score) >= 10 or count(contributions.score) > 1)][0m [["item_type", "User"], ["marker", 5931], ["is_registered", true]]]

D, [2023-12-03T19:59:01.244704 #3056 DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] ][1m][36mRelease Load (301.7ms)][0m ][1m][34mSELECT "releases".* FROM "releases" ORDER BY "releases"."published_at" ASC][0m]

D, [2023-12-03T19:59:03.371495 #3056] DEBUG -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] [ahoy] Event excluded

I, [2023-12-03T19:59:03.371782 #3056] INFO -- : [b1602f76-292f-4abb-a1b7-9fc9931b823b] {:_method=>"GET", :_path=>"/users", :_format=>:html, :_controller=>"UsersController", :_action=>"index", :_status=>200, :_duration=>3571.81, :_view=>2141.59, :_db=>1417.25, :_time=>2023-12-03 19:58:59 +0000, :short_message=>"[200] GET /users (UsersController#index)"}

D, [2023-12-03T19:59:25.029101 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:59:25.032839 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] ][1m][35mSQL (2.5ms)][0m ][1m][32mINSERT INTO "visits" ("visit_token", "visitor_token", "ip", "user_agent", "landing_page", "browser", "os", "device_type", "started_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) RETURNING "id"][0m [["visit_token", "a030da6a-9bc5-4c6f-a4be-ffaf9ef3f393"], ["visitor_token", "87cc7904-4c9d-48a1-a97c-3d2492a4a4d2"], ["ip", "64.252.67.9"], ["user_agent", "Amazon CloudFront"], ["landing_page", "http://cdn.juliaobserver.com/logs/production"], ["browser", "Other"], ["os", "Other"], ["device_type", "Desktop"], ["started_at", 2023-12-03 19:59:25 UTC]]]

D, [2023-12-03T19:59:25.034359 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] ][1m][35m (1.1ms)][0m ][1m][35mCOMMIT][0m]

D, [2023-12-03T19:59:25.035666 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] [ActiveJob] ][1m][35m (0.1ms)][0m ][1m][35mBEGIN][0m]

D, [2023-12-03T19:59:25.036982 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] [ActiveJob] ][1m][35mSQL (0.4ms)][0m ][1m][32mINSERT INTO "delayed_jobs" ("handler", "run_at", "queue", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5) RETURNING "id"][0m [["handler", "--- !ruby/object:ActiveJob::QueueAdapters::DelayedJobAdapter::JobWrapper\njob_data:\n job_class: Ahoy::GeocodeJob\n job_id: 9fe16909-d379-419f-aefe-3e362e83095a\n queue_name: ahoy\n priority: \n arguments:\n - _aj_globalid: gid://julia-observer/Visit/16787563\n locale: en\n"], ["run_at", 2023-12-03 19:59:25 UTC], ["queue", "ahoy"], ["created_at", 2023-12-03 19:59:25 UTC], ["updated_at", 2023-12-03 19:59:25 UTC]]]

D, [2023-12-03T19:59:25.037861 #3056 DEBUG -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] [ActiveJob] ][1m][35m (0.6ms)][0m ][1m][35mCOMMIT][0m]

I, [2023-12-03T19:59:25.038141 #3056] INFO -- : [c1fe26b0-891e-4c47-9b6c-58f887285457] [ActiveJob] Enqueued Ahoy::GeocodeJob (Job ID: 9fe16909-d379-419f-aefe-3e362e83095a) to DelayedJob(ahoy) with arguments: #<GlobalID:0x00007f0110b58458 @uri=#<URI::GID gid://julia-observer/Visit/16787563>>