Cold Ramen Noodles
This account is closed.
Hey. I've been getting the 502 Bad Gateway errors on here for a few days now. Only this site is the one I'm getting them on.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
Hey. I've been getting the 502 Bad Gateway errors on here for a few days now. Only this site is the one I'm getting them on.
I've gotten them a couple times too. Not sure yet what's causing it, but they don't typically last long. A couple refreshes fixed it for me.
502 is really a server error, not a network or client error. The most likely place this would happen is between the server's webserver (nginx) and the PHP backend to process page requests.
Is there any particular time you can give me when this happens, or is it completely random?
[29-Nov-2017 18:44:56] WARNING: [pool rpnation] server reached pm.max_children setting (24), consider raising it
2017/11/29 18:45:56 [error] 12749#0: *7165357 connect() to unix:/var/run/rpnation.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client: 98.111.244.150, server: www.rpnation.com, request: "POST /threads/main-rp-here.371407/save-draft HTTP/1.1", upstream: "fastcgi://unix:/var/run/rpnation.sock:", host: "www.rpnation.com", referrer: "https://www.rpnation.com/threads/main-rp-here.371407/page-4"
# Time: 171129 18:45:56
# User@Host: ---------------- []
# Thread_id: 39802719 Schema: ------------- QC_hit: No
# Query_time: 68.437642 Lock_time: 0.000040 Rows_sent: 4 Rows_examined: 161522
# Rows_affected: 0
SET timestamp=1511999156;
SELECT post.*
,
bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
user_profile.*,
user_privacy.*,
signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
session_activity.view_date AS last_view_date,
liked_content.like_date,
xf_hoffi_dm_rolls.roll_id as roll_id,
threadmarks.threadmark_id,
threadmarks.threadmark_category_id as threadmark_category_id,
threadmarks.label as threadmark_label,
threadmarks.edit_count as threadmark_edit_count,
threadmarks.user_id as threadmark_user_id,
threadmarks.position as threadmark_position,
threadmarks.last_edit_date as threadmark_last_edit_date,
threadmarks.last_edit_user_id as threadmark_last_edit_user_id,
threadmarks.threadmark_date as threadmark_threadmark_date,
tm_user.username as threadmark_username
FROM xf_post AS post
LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = post.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = post.user_id)
LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
LEFT JOIN xf_liked_content AS liked_content
ON (liked_content.content_type = 'post'
AND liked_content.content_id = post.post_id
AND liked_content.like_user_id = 40384)
LEFT JOIN xf_hoffi_dm_rolls ON (post.post_id = xf_hoffi_dm_rolls.post_id)
LEFT JOIN threadmarks ON (threadmarks.post_id = post.post_id )
LEFT JOIN xf_user AS tm_user ON tm_user.user_id = threadmarks.user_id
WHERE post.thread_id = '343016'
AND post.post_date > '1498400954'
AND (post.message_state IN ('visible') OR (post.message_state = 'moderated' AND post.user_id = 40384))
ORDER BY post.post_date DESC
LIMIT 4;
We're working on the 502 issue. Last night's looong downtime was a different issue which hopefully is now resolved.