Skip to content

Instantly share code, notes, and snippets.

@lcatlett

lcatlett/binding_binding_1a49ea8f28df49aca3c6807386976633.json

Created July 24, 2025 18:44
Show Gist options
  • Save lcatlett/9cb508f5cb1df61d3a514da4ada180cd to your computer and use it in GitHub Desktop.
Save lcatlett/9cb508f5cb1df61d3a514da4ada180cd to your computer and use it in GitHub Desktop.
Download ZIP
Pantheon Binding Audit Report - Site: 4e9372f2-e74f-43d2-9245-fc45643f2624 (live) - 2025-07-24 14:44:34
Raw
binding_binding_1a49ea8f28df49aca3c6807386976633.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:43:25Z",
"binding_id": "1a49ea8f28df49aca3c6807386976633",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/1a49ea8f28df49aca3c6807386976633",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "da4b451c-b275-41c7-8eb5-d2871921cbee"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 4,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2608,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 183523,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 927,
"url_patterns": [],
"cascade_indicators": [
" 927 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 927,
"worker_waste_percent": 0,
"response_distribution": "200:556 404:183 403:177 304:70 301:6 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/images/custom/bio_curran_annamarie_24.jpg(10658535.0s) /sites/default/files/images/custom/bio_Courtney_Matthew_19.jpg(8521540.0s) /sites/default/files/images/custom/bio_kauffman_graham_24_v2.jpg?odnHeight=372&odnWidth=372&odnBg=FFFFFF(5068583.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 927 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 19,
"nginx_error_logs": 5,
"php_logs": 3,
"total_log_size_mb": 12
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_2a79f40197924801af6f6288301a6052.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:43:25Z",
"binding_id": "2a79f40197924801af6f6288301a6052",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/2a79f40197924801af6f6288301a6052",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "807843b8-2338-4e41-b5de-16e6c66446f7"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 7584,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 7584,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 102696,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 5,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 6.2
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 927,
"url_patterns": [],
"cascade_indicators": [
" 927 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"115 user 499s > 52 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 115,
"bot_499s": 52,
"avg_499_response_time": 0.00,
"long_running_requests": 927,
"worker_waste_percent": 0,
"response_distribution": "200:635 404:175 403:82 304:68 405:13 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/Piper_Sandler_2023_Automotive_Service_Year_in_Review.pdf(7568103.0s) /sites/default/files/document/2024_PiperSandler_Sustainability_Report.pdf(6588716.0s) /sites/default/files/document/AutoServiceQuarterlyUpdate_spring2023_0.pdf(6048611.0s) ",
"top_499_urls": "/pantheon_healthcheck(11) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(8) /user(4) ",
"top_499_user_agents": "Mozilla/5.0(14) Mozilla/5.0(13) Mozilla/5.0(12) ",
"cascade_indicators": [" 927 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","115 user 499s > 52 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 52,
"user_499s": 115,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 2,
"nginx_error_logs": 1,
"php_logs": 3,
"total_log_size_mb": 12
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (115 user vs 52 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_31df242b1d454a1abaddd8f659139816.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:42:12Z",
"binding_id": "31df242b1d454a1abaddd8f659139816",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/31df242b1d454a1abaddd8f659139816",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "26a472ee-f2df-438d-965c-d7dac0b8ac7e"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 7784,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 7784,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 162316,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 5,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 6.2
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 914,
"url_patterns": [],
"cascade_indicators": [
" 914 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"125 user 499s > 55 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 125,
"bot_499s": 55,
"avg_499_response_time": 0.00,
"long_running_requests": 914,
"worker_waste_percent": 0,
"response_distribution": "200:675 404:146 304:79 403:73 301:10 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/crej_278192_prep_20220511111153741.pdf(21513110.0s) /sites/default/files/images/custom/bio_dinneen_colin_24.jpg(8648545.0s) /sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) ",
"top_499_urls": "/user(6) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(5) /taxonomy/term/630(4) ",
"top_499_user_agents": "Mozilla/5.0(26) Mozilla/5.0(17) Mozilla/5.0(15) ",
"cascade_indicators": [" 914 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","125 user 499s > 55 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 55,
"user_499s": 125,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 5,
"nginx_error_logs": 1,
"php_logs": 5,
"total_log_size_mb": 21
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (125 user vs 55 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_75c116a1e2de46c99a37461cdcd686a7.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:43:23Z",
"binding_id": "75c116a1e2de46c99a37461cdcd686a7",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/75c116a1e2de46c99a37461cdcd686a7",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "d00ef372-a5e6-4ac6-a62e-45bb5125497a"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 8085,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 8085,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 97535,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 6,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 7.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 941,
"url_patterns": [],
"cascade_indicators": [
" 941 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"141 user 499s > 69 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 141,
"bot_499s": 69,
"avg_499_response_time": 0.00,
"long_running_requests": 941,
"worker_waste_percent": 0,
"response_distribution": "200:648 404:174 403:81 304:50 301:17 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/PSC_2023_Annual_Report.pdf(4824558.0s) /sites/default/files/document/Piper_Sandler_ESG_Report_2023_0.pdf(3879789.0s) ",
"top_499_urls": "/pantheon_healthcheck(13) /user(10) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(5) ",
"top_499_user_agents": "Mozilla/5.0(23) Mozilla/5.0(20) Mozilla/5.0(16) ",
"cascade_indicators": [" 941 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","141 user 499s > 69 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 69,
"user_499s": 141,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 2,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 8
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (141 user vs 69 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_7b567f7c87804920bfacd8d155f5dedc.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:42:13Z",
"binding_id": "7b567f7c87804920bfacd8d155f5dedc",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/7b567f7c87804920bfacd8d155f5dedc",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "cd74d7d0-9da2-47ee-ace5-6a0e1c6cde39"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 1,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 19,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 44820,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 0,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 0.0
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 16,
"url_patterns": [],
"cascade_indicators": [
" 16 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 16,
"worker_waste_percent": 0,
"response_distribution": "200:9 404:3 403:3 304:3 301:1 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/js/js_wtay8gQvEEeLzNOpkvK8QAzqTLcjeMImlXq0U2ROGwk.js?scope=footer&delta=0&language=en&theme=pipersandler&include=eJx1zlEOwzAIA9ALLd2ZPEK2SAkgYOr1x2-l9dd-lmzT2APSF_uTdJsKSx6UaC9429qxHvYfjbmy8ms9VBInh26-FgbH22Gfg4rUvhG8xx0ajPw695YOCVBOlVssfMbirDcNROq98A_SaVZH(189262.0s) /sites/default/files/styles/large/public/images/custom/group-2-technologies.png.webp?itok=3zfKG-nm(44820.0s) /sites/default/files/styles/large/public/images/custom/pacira_biosciences_inc_slide_1_image.jpg?itok=X3Bmz1ST(16061.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 16 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 1
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_8092a78191df42beb1585e9c99b77b14.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:43:25Z",
"binding_id": "8092a78191df42beb1585e9c99b77b14",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/8092a78191df42beb1585e9c99b77b14",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "2420afdf-5aaa-4d1f-8f3b-951bbda7ddd7"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 4,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2516,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 179850,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 920,
"url_patterns": [],
"cascade_indicators": [
" 920 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 920,
"worker_waste_percent": 0,
"response_distribution": "200:558 404:177 403:169 304:79 302:8 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/images/custom/istock-1328677020_conf_room.jpg(10761504.0s) /sites/default/files/images/custom/NYC_horizontal-fullwidth.jpg(5508809.0s) /sites/default/files/images/custom/bio_niggel_joe_24.jpg(3140826.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 920 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_8488e465ba93461ab44b35a19f0903ac.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:42:15Z",
"binding_id": "8488e465ba93461ab44b35a19f0903ac",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/8488e465ba93461ab44b35a19f0903ac",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "0f6bd5a9-a227-4eea-93a6-49c03e9041a5"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 6688,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 6688,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 5,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 6.2
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"url_patterns": [],
"cascade_indicators": [
" 915 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"125 user 499s > 55 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 125,
"bot_499s": 55,
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"worker_waste_percent": 0,
"response_distribution": "200:700 404:99 403:88 304:78 301:13 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/Heartland_Summit_2022_Recap.pdf(10429633.0s) /sites/default/files/document/PSC_Aftermarket_YIR_2022.pdf(4879043.0s) /sites/default/files/images/custom/bio_Carver_Alex_25.jpg(4850207.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(12) /pantheon_healthcheck(7) /sites/default/files/css/css_2q_U3-kK4zOR2A0iou_COPk3KIlORF_X2_BXHSc1DN4.css?delta=0&language=en&theme=pipersandler&include=eJx1j0EOwjAMBD8UNU-qTLIUFycOcQKU11O1B4QoF2s1o5XWQchs8ScyuLDnBDOaYC5ohY-1F5KBZnruIGtNJPyCm28ddRk7j5EaCocrqv9EV7igGuUoK59UJ8Fw1tzs21hbVrEtOOBBU9GMPy2hRXs7Mr2xcOP1DdPAJGNCZBqF89X8LxraBQnuzniY3-6QNHbBG063cfk(3) ",
"top_499_user_agents": "Mozilla/5.0(23) Mozilla/5.0(18) Mozilla/5.0(13) ",
"cascade_indicators": [" 915 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","125 user 499s > 55 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 55,
"user_499s": 125,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 3,
"nginx_error_logs": 1,
"php_logs": 5,
"total_log_size_mb": 14
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (125 user vs 55 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_b6bec5d9e7504be9991acb29df8eb576.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:42:13Z",
"binding_id": "b6bec5d9e7504be9991acb29df8eb576",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/b6bec5d9e7504be9991acb29df8eb576",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "75428e69-7b14-4bb3-8d53-3378e0cb5430"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 3,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 887,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 158063,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 1,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 1.2
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 826,
"url_patterns": [],
"cascade_indicators": [
" 826 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 1,
"user_499s": 1,
"bot_499s": 0,
"avg_499_response_time": 0.00,
"long_running_requests": 826,
"worker_waste_percent": 0,
"response_distribution": "200:520 403:149 404:148 304:58 302:5 ",
"cascade_stats": "Count: 1, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/images/custom/esckilsen_christine_testimonial.png(22190911.0s) /sites/default/files/images/custom/tedesco_sam_testimonial.png(13258272.0s) /sites/default/files/images/custom/gettyimages-1252668228-careers.jpg(10342367.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(1) ",
"top_499_user_agents": "Mozilla/5.0(1) ",
"cascade_indicators": [" 826 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 1,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 3,
"nginx_error_logs": 2,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_cec117893fd444d3b02697f3e8768ad5.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:43:24Z",
"binding_id": "cec117893fd444d3b02697f3e8768ad5",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/cec117893fd444d3b02697f3e8768ad5",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "b8d6ae27-ea2d-4fab-ad0a-daafa089d3f2"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 8192,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 8192,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 111075,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 6,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 7.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 902,
"url_patterns": [],
"cascade_indicators": [
" 902 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"126 user 499s > 60 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 126,
"bot_499s": 60,
"avg_499_response_time": 0.00,
"long_running_requests": 902,
"worker_waste_percent": 0,
"response_distribution": "200:750 304:86 403:75 404:41 301:16 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/heavyduty_commercial_report_spring2023_0.pdf(6614500.0s) /sites/default/files/document/2024_PiperSandler_Sustainability_Report.pdf(6588716.0s) /sites/default/files/document/10K_2019_Q4.pdf(6059244.0s) ",
"top_499_urls": "/pantheon_healthcheck(12) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(12) /user(7) ",
"top_499_user_agents": "Mozilla/5.0(18) Mozilla/5.0(17) Mozilla/5.0(14) ",
"cascade_indicators": [" 902 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","126 user 499s > 60 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 60,
"user_499s": 126,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 2,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 8
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"CRITICAL: High user 499 errors (126 user vs 60 bot)",
"ACTION: Prioritize fixing user-facing timeout issues"
]
}
Raw
binding_binding_df47046c10294c128695b9ec9001464c.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:42:15Z",
"binding_id": "df47046c10294c128695b9ec9001464c",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/df47046c10294c128695b9ec9001464c",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "5806624d-54ef-41bb-bb96-b4523c406716"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 6147,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 6147,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 4,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 5.0
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"url_patterns": [],
"cascade_indicators": [
" 915 slow requests >10s (cascade triggers)",
"6 old workers + 50 recent 499s = worker waste pattern",
"70 user 499s > 49 bot 499s = real user impact"
],
"severity": "CRITICAL"
},
"cascade_analysis_enhanced": {
"total_499s": 50,
"user_499s": 70,
"bot_499s": 49,
"avg_499_response_time": 0.00,
"long_running_requests": 915,
"worker_waste_percent": 0,
"response_distribution": "200:631 404:164 403:80 304:78 301:18 ",
"cascade_stats": "Count: 50, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/document/Fed_$2.3_Trillion_Plan.pdf(8431662.0s) /sites/default/files/document/Piper_Sandler_2023_Automotive_Service_Year_in_Review.pdf(7568103.0s) /sites/default/files/document/Simmons_Priv_Co_Energy_Conf_18_Recap.pdf(3791257.0s) ",
"top_499_urls": "/pantheon_healthcheck(7) /cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(7) /news(4) ",
"top_499_user_agents": "Mozilla/5.0(14) Mozilla/5.0(13) Mozilla/5.0(11) ",
"cascade_indicators": [" 915 slow requests >10s (cascade triggers)","6 old workers + 50 recent 499s = worker waste pattern","70 user 499s > 49 bot 499s = real user impact"],
"severity": "CRITICAL",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 49,
"user_499s": 70,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 31,
"nginx_error_logs": 5,
"php_logs": 4,
"total_log_size_mb": 53
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
"CRITICAL: 499 cascade pattern detected",
"ACTION: Implement request_terminate_timeout and optimize long-running operations"
]
}
Raw
binding_binding_e9d931b9014d484fbdca82db24732401.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:44:30Z",
"binding_id": "e9d931b9014d484fbdca82db24732401",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/e9d931b9014d484fbdca82db24732401",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "eabd6d3d-b484-4b70-ad2b-8073006b26db"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 2,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 35,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 117558,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 0,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 0.0
},
"cascade_analysis": {
"avg_499_response_time": 0,
"long_running_requests": 31,
"url_patterns": [],
"cascade_indicators": [
" 31 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 0,
"user_499s": 0,
"bot_499s": 0,
"avg_499_response_time": 0,
"long_running_requests": 31,
"worker_waste_percent": 0,
"response_distribution": "200:24 404:4 304:4 403:2 405:1 ",
"cascade_stats": "",
"slow_urls": "/sites/default/files/document/PSC_Asset_Wealth_Management_Report_September_2024.pdf(851215.0s) /sites/default/files/document/021025_CAMarketUpdate.pdf(480260.0s) /sites/default/files/images/custom/bio_okeefe_kevin_22.jpg(117558.0s) ",
"top_499_urls": "",
"top_499_user_agents": "",
"cascade_indicators": [" 31 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 0,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 1
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
binding_binding_f4f01c8a31704c5f85c297d0814e943d.json
{
"audit_metadata": {
"timestamp": "2025-07-24T18:44:30Z",
"binding_id": "f4f01c8a31704c5f85c297d0814e943d",
"audit_version": "1.0",
"cache_directory": "./binding_cache/4e9372f2-e74f-43d2-9245-fc45643f2624/live/f4f01c8a31704c5f85c297d0814e943d",
"date_range": {
"start_date": "2025-07-23",
"end_date": "2025-07-24",
"duration_days": 2,
"filter_type": "last_n_days"
}
},
"binding_metadata": {
"site_name": "piper-sandler-co",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"plan_name": "Elite",
"service_level": "elite_1m",
"framework": "drupal8",
"php_version": "83",
"appserver_count": 1,
"endpoint": "a595034e-817f-4d7f-bbf8-569be82b6a76"
},
"plan_tier_analysis": {
"detected_tier": "Elite",
"worker_range": "4-8",
"error_rate_targets": {
"warning_threshold": 2.0,
"critical_threshold": 5.0
},
"performance_targets": {
"p95_target_seconds": 10.0,
"worker_efficiency_target": 1.0,
"socket_availability_target": 99.0
}
},
"current_usage": {
"php_processes": 0,
"binding_php_processes": 0,
"nginx_processes": 0,
"total_processes": 0,
"memory_usage_mb": 0,
"memory_usage_percent": 0.0,
"cpu_cores": 1,
"load_average": "0.0",
"load_per_core": 0.00,
"old_workers": 6,
"stuck_workers": 0,
"worker_efficiency": 0.0,
"overall_health_score": 0,
"health_status": "DEGRADED",
"uptime_seconds": 86400
},
"resource_exhaustion": {
"overall_status": "OK",
"exhaustion_score": 0,
"cpu_status": "OK",
"memory_status": "OK",
"php_status": "OK",
"efficiency_status": "OK",
"php_process_multiplier": 1.0,
"expected_workers": 8,
"indicators": [],
"analysis_approach": "enhanced_diagnostic"
},
"resource_limits": {
"php_memory_limit_mb": "1024M",
"mysql_memory_limit_mb": "unknown",
"redis_memory_limit_mb": "unknown"
},
"configuration": {
"php_fpm": {
"pm_mode": "dynamic",
"max_children": 8,
"start_servers": 1,
"min_spare_servers": 1,
"max_spare_servers": 5,
"max_requests": 100,
"request_terminate_timeout": 120
},
"php_memory_limit": "1024M",
"nginx": {
"worker_processes": 4,
"worker_connections": 128,
"max_connections": 1024,
"connection_utilization_percent": 0.0
},
"issues": [
]
},
"error_analysis": {
"today": {
"requests": 00,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"last_7_days": {
"requests": 2860,
"499_errors": 0,
"502_errors": 0,
"503_errors": 0,
"504_errors": 0,
"error_rate_percent": 0
},
"timeout_patterns": {
"30s_timeouts": 0,
"59s_timeouts": 0,
"120s_timeouts": 0,
"long_requests_today": 0
}
},
"socket_exhaustion": {
"nginx_socket_errors_today": 0,
"nginx_socket_errors_week": 0,
"phpfpm_exhaustion_today": 0,
"phpfpm_exhaustion_week": 0,
"max_children_hits": 0,
"worker_scaling_events": 0,
"connection_refused_errors": 0,
"upstream_timeout_errors": 0,
"php_process_kills": 0,
"severity": "OK"
},
"performance_metrics": {
"response_times": {
"p50_seconds": 0,
"p95_seconds": 189156,
"p99_seconds": 0
},
"throughput": {
"requests_per_minute": 2,
"worker_efficiency": 0.0
},
"severity": "OK"
},
"slow_endpoints": [],
"worker_analysis": {
"total_workers": 8,
"old_workers": 6,
"stuck_workers": 0,
"efficiency_percent": 2.5
},
"cascade_analysis": {
"avg_499_response_time": 0.00,
"long_running_requests": 928,
"url_patterns": [],
"cascade_indicators": [
" 928 slow requests >10s (cascade triggers)"
],
"severity": "OK"
},
"cascade_analysis_enhanced": {
"total_499s": 2,
"user_499s": 2,
"bot_499s": 0,
"avg_499_response_time": 0.00,
"long_running_requests": 928,
"worker_waste_percent": 0,
"response_distribution": "200:575 403:197 404:149 304:70 301:4 ",
"cascade_stats": "Count: 2, Min: 0s, Max: 0s, Avg: 0.00s",
"slow_urls": "/sites/default/files/images/custom/tedesco_sam_testimonial.png(13258272.0s) /sites/default/files/images/custom/gettyimages-1252668228-careers.jpg(10342367.0s) /sites/default/files/images/custom/bio_binette_ryan_24.jpg(9926321.0s) ",
"top_499_urls": "/cron/DzoUf8QZwyhelIs95Dldu5x2yGp4cvwqWKr1R-1D7gnqHiRnp84knhCOe13uQAhoLshFupisyg(2) ",
"top_499_user_agents": "Mozilla/5.0(2) ",
"cascade_indicators": [" 928 slow requests >10s (cascade triggers)"],
"severity": "OK",
"analysis_approach": "working_diagnostic"
},
"user_agent_analysis": {
"bot_499s": 0,
"user_499s": 2,
"bot_user_agents": ""
},
"log_inventory": {
"nginx_access_logs": 1,
"nginx_error_logs": 1,
"php_logs": 2,
"total_log_size_mb": 2
},
"health_checks": {
"status": "UNKNOWN",
"alerts": [
],
"warnings": [
]
},
"memory_validation": {
"status": "UNKNOWN",
"safety_factor": 0,
"headroom_percent": 0,
"recommendations": [
]
},
"worker_scaling": {
"current_workers": 8,
"optimal_workers": 0,
"scaling_algorithm": "dynamic",
"plan_based_range": "8-16"
},
"recommendations": [
]
}
Raw
summary_recommendations.json
{
"recommendations_metadata": {
"timestamp": "2025-07-24T18:44:33Z",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"total_bindings_analyzed": 12,
"bindings_with_recommendations": 6
},
"summary": {
"critical_actions_count": 11,
"warning_actions_count": 11,
"optimization_opportunities_count": 0,
"affected_bindings_count": 6
},
"critical_actions": [
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (126 user vs 60 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (125 user vs 55 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (115 user vs 52 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (141 user vs 69 bot)",
"CRITICAL: 499 cascade pattern detected",
"CRITICAL: High user 499 errors (125 user vs 55 bot)"
],
"warning_actions": [
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues",
"ACTION: Implement request_terminate_timeout and optimize long-running operations",
"ACTION: Prioritize fixing user-facing timeout issues"
],
"optimization_opportunities": [
],
"affected_bindings": [
"cec117893fd444d3b02697f3e8768ad5",
"df47046c10294c128695b9ec9001464c",
"8488e465ba93461ab44b35a19f0903ac",
"2a79f40197924801af6f6288301a6052",
"75c116a1e2de46c99a37461cdcd686a7",
"31df242b1d454a1abaddd8f659139816"
]
}
Raw
summary_site_summary.json
{
"summary_metadata": {
"timestamp": "2025-07-24T18:44:33Z",
"site_id": "4e9372f2-e74f-43d2-9245-fc45643f2624",
"environment": "live",
"binding_count": 12,
"audit_version": "1.0"
},
"site_overview": {
"site_name": "piper-sandler-co",
"plan_name": "Elite",
"service_level": "elite_1m",
"total_bindings": 12,
"overall_severity": "CRITICAL"
},
"aggregated_metrics": {
"total_requests_today": 44494,
"total_requests_week": 53405,
"total_499_errors_today": 0,
"total_499_errors_week": 0,
"total_502_errors_today": 0,
"total_502_errors_week": 0,
"overall_error_rate_today_percent": 0.00,
"overall_error_rate_percent": 0.00
},
"binding_health": {
"critical_bindings": 6,
"warning_bindings": 0,
"healthy_bindings": 6,
"health_distribution_percent": {
"critical": 50.0,
"warning": 0.0,
"healthy": 50.0
}
},
"binding_reports": [
{"binding_id": "8092a78191df42beb1585e9c99b77b14", "report_file": "binding_8092a78191df42beb1585e9c99b77b14.json"},
{"binding_id": "b6bec5d9e7504be9991acb29df8eb576", "report_file": "binding_b6bec5d9e7504be9991acb29df8eb576.json"},
{"binding_id": "1a49ea8f28df49aca3c6807386976633", "report_file": "binding_1a49ea8f28df49aca3c6807386976633.json"},
{"binding_id": "7b567f7c87804920bfacd8d155f5dedc", "report_file": "binding_7b567f7c87804920bfacd8d155f5dedc.json"},
{"binding_id": "cec117893fd444d3b02697f3e8768ad5", "report_file": "binding_cec117893fd444d3b02697f3e8768ad5.json"},
{"binding_id": "f4f01c8a31704c5f85c297d0814e943d", "report_file": "binding_f4f01c8a31704c5f85c297d0814e943d.json"},
{"binding_id": "df47046c10294c128695b9ec9001464c", "report_file": "binding_df47046c10294c128695b9ec9001464c.json"},
{"binding_id": "8488e465ba93461ab44b35a19f0903ac", "report_file": "binding_8488e465ba93461ab44b35a19f0903ac.json"},
{"binding_id": "2a79f40197924801af6f6288301a6052", "report_file": "binding_2a79f40197924801af6f6288301a6052.json"},
{"binding_id": "e9d931b9014d484fbdca82db24732401", "report_file": "binding_e9d931b9014d484fbdca82db24732401.json"},
{"binding_id": "75c116a1e2de46c99a37461cdcd686a7", "report_file": "binding_75c116a1e2de46c99a37461cdcd686a7.json"},
{"binding_id": "31df242b1d454a1abaddd8f659139816", "report_file": "binding_31df242b1d454a1abaddd8f659139816.json"}
]
}
Raw
summary_summary.md

Pantheon Binding Tool - Comprehensive Report

Executive Summary

  • Site Name: piper-sandler-co
  • Site ID: 4e9372f2-e74f-43d2-9245-fc45643f2624
  • Plan: Elite
  • Total Bindings: 12
  • Overall Status: CRITICAL
  • Audit Date: Thu Jul 24 14:44:33 EDT 2025

Performance Overview (Last 7 Days)

  • Total Requests: 53,405
  • 499 Errors (Client Disconnects): 0
  • 502 Errors (Bad Gateway): 0
  • Overall Error Rate: 0.00%

Binding Health Summary

  • 🔴 Critical Issues: 6 bindings
  • 🟡 Warning Issues: 0 bindings
  • 🟢 Healthy: 6 bindings

Technical Details

Audit Methodology:

  • Log analysis covers last 7 days of nginx access/error logs
  • Configuration analysis of PHP-FPM, nginx, and Redis settings
  • Performance metrics extracted from current and historical log files
  • Error rate calculations based on total requests vs error responses

Key Metrics Explained:

  • 499 Errors: Client disconnected before server response
  • 502 Errors: Bad gateway errors
  • Socket Errors: Resource exhaustion at nginx level
  • PHP-FPM Pool Exhaustion: All PHP workers busy, requests queued/dropped

Thresholds:

  • Critical: Error rate > 5% OR > 1000 errors/day
  • Warning: Error rate > 1% OR > 100 errors/day
  • Healthy: Error rate < 1% AND < 100 errors/day

Next Steps

  1. Immediate Actions:

    • Review critical recommendations above
    • Implement fixes for high-priority items
    • Monitor error rates closely

  2. Scheduled Improvements:

    • Address warning-level issues during maintenance windows
    • Implement optimization recommendations
    • Update monitoring and alerting

  3. Follow-up:

    • Re-run audit after 24-48 hours to verify improvements
    • Set up regular auditing schedule
    • Review trends over time for capacity planning

Report Files

  • Site Summary: site_summary.json - Machine-readable aggregate data
  • Recommendations: recommendations.json - Detailed actionable items
  • Individual Bindings: bindings/binding_*.json - Per-binding detailed analysis

Generated: Thu Jul 24 14:44:33 EDT 2025 Audit Tool: Pantheon Binding Tool v1.0 Data Source: Last 7 days of log files and current configuration

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment