发布主题时出现 500 错误

KranthiKiranGude · 2020 年8 月 4 日 07:52

我在尝试发布新主题时遇到了 500 错误。我是管理员，已经发布过多个主题，也能成功发布其他主题。但只有某些特定主题会报错。
标题：
为什么我作为商科学生也应该学习计算机编程？计算机编程如何帮助我？
正文：
首先，几年后几乎所有事物都将可编程，因此了解这一点会很有用。但你可能并不在意，因为你可能只是消费者——这当然没问题。即使你像专业律师一样并不精通法律条文中的每一条，你仍然了解一些基本权利，那为什么不学习一些计算机编程的基础知识呢？
作为商科学生，我预计你会与大量数字打交道，如果有一些重复性任务，将其自动化可以为你节省大量时间。
最后但同样重要的是，你不应拒绝任何学习新事物的机会：无论是学习乐器、新语言，还是经典的编程。

继续阅读
首先，几年后几乎所有事物都将可编程，因此了解这一点会很有用。但你可能并不在意，因为你可能只是消费者——这当然没问题。即使你像专业律师一样并不精通法律条文中的每一条，你仍然了解一些基本权利，那为什么不学习一些计算机编程的基础知识呢？
作为商科学生，我预计你会与大量数字打交道，如果有一些重复性任务，将其自动化可以为你节省大量时间。
最后但同样重要的是，你不应拒绝任何学习新事物的机会：无论是学习乐器、新语言，还是经典的编程。

有人能帮我分析一下这里可能出了什么问题吗？

IAmGav · 2020 年8 月 4 日 08:14

可能是您主题标题的字符数限制。您可能已超过限制。

KranthiKiranGude · 2020 年8 月 4 日 08:31

你好 @IAmGav，

我已将主题字符限制设为最大值。
我已将最大帖子长度增加到 150000。
最大主题标题长度为 255。
标题最大单词长度为 2000000000。
还有其他可能的原因吗？

KranthiKiranGude · 2020 年8 月 4 日 14:57

500 错误数量显著增加，目前无法确定确切原因。这已严重影响到我的论坛。能否有人帮忙解决一下？

IAmGav · 2020 年8 月 4 日 16:11

我已经将您的文章发布到了我的一个 Discourse 服务器上，甚至没有触及任何限制。

发布成功。

您可能需要查看一下您的服务器错误日志。

这并非与 Discourse 相关的错误。

KranthiKiranGude · 2020 年8 月 4 日 17:31

谢谢，Gavin。
不知道为什么突然开始发生这种情况。

Falco · 2020 年8 月 4 日 17:37

访问论坛上的 /logs 页面并检查错误。

KranthiKiranGude · 2020 年8 月 4 日 18:10

/logs 页面在该域名中不存在（mpl.co/logs）
请问您能帮我了解如何访问吗？

Falco · 2020 年8 月 4 日 18:11

您必须以论坛管理员身份登录。

KranthiKiranGude · 2020 年8 月 4 日 18:19

我是论坛管理员。我们需要配置它吗？

KranthiKiranGude · 2020 年8 月 4 日 19:17

正如这里提到的，这是否确实是由正文内容过于相似导致的？

如果是的话，该如何禁用此功能？我可以接受检查重复标题，但不希望 Discourse 因正文内容相似而报错。

IAmGav · 2020 年8 月 4 日 19:32

你可以试试这些

设置 > 发帖

sam · 2020 年8 月 4 日 23:57

如果不查看 /logs，我们很难提供太多帮助。请在触发问题后访问 YOURSITENAME.COM/logs，复制您收到的错误信息并粘贴到这里。

KranthiKiranGude · 2020 年8 月 5 日 06:15

Error Message:

ActiveRecord::ValueTooLong (PG::StringDataRightTruncation: ERROR: value too long for type character varying(1000) ) lib/post_creator.rb:496:in `update_topic_stats' lib/post_creator.rb:199:in `block i

Error Info:

ActiveRecord::ValueTooLong (PG::StringDataRightTruncation: ERROR:  value too long for type character varying(1000)
)
lib/post_creator.rb:496:in `update_topic_stats'
lib/post_creator.rb:199:in `block in create'
lib/post_creator.rb:375:in `block in transaction'
lib/post_creator.rb:374:in `transaction'
lib/post_creator.rb:191:in `create'
lib/new_post_manager.rb:271:in `perform_create_post'
lib/new_post_manager.rb:209:in `perform'
app/controllers/posts_controller.rb:173:in `block in create'
lib/distributed_memoizer.rb:30:in `memoize'
app/controllers/posts_controller.rb:172:in `create'
app/controllers/application_controller.rb:340:in `block in with_resolved_locale'
app/controllers/application_controller.rb:340:in `with_resolved_locale'
lib/middleware/omniauth_bypass_middleware.rb:68:in `call'
lib/content_security_policy/middleware.rb:12:in `call'
lib/middleware/anonymous_cache.rb:328:in `call'
config/initializers/100-quiet_logger.rb:19:in `call'
config/initializers/100-silence_logger.rb:31:in `call'
lib/middleware/enforce_hostname.rb:22:in `call'
lib/middleware/request_tracker.rb:176:in `call'

Error Back Trace:
rack-mini-profiler (2.0.3) lib/patches/db/pg.rb:69:in `exec_params'

rack-mini-profiler (2.0.3) lib/patches/db/pg.rb:69:in `exec_params'

activerecord (6.0.3.2) lib/active_record/connection_adapters/postgresql_adapter.rb:675:in `block (2 levels) in exec_no_cache'

activesupport (6.0.3.2) lib/active_support/dependencies/interlock.rb:48:in `block in permit_concurrent_loads'

activesupport (6.0.3.2) lib/active_support/concurrency/share_lock.rb:187:in `yield_shares'

activesupport (6.0.3.2) lib/active_support/dependencies/interlock.rb:47:in `permit_concurrent_loads'

activerecord (6.0.3.2) lib/active_record/connection_adapters/postgresql_adapter.rb:674:in `block in exec_no_cache'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract_adapter.rb:722:in `block (2 levels) in log'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract_adapter.rb:721:in `block in log'

activesupport (6.0.3.2) lib/active_support/notifications/instrumenter.rb:24:in `instrument'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract_adapter.rb:712:in `log'

activerecord (6.0.3.2) lib/active_record/connection_adapters/postgresql_adapter.rb:673:in `exec_no_cache'

activerecord (6.0.3.2) lib/active_record/connection_adapters/postgresql_adapter.rb:654:in `execute_and_clear'

activerecord (6.0.3.2) lib/active_record/connection_adapters/postgresql/database_statements.rb:111:in `exec_delete'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/database_statements.rb:174:in `update'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/query_cache.rb:22:in `update'

activerecord (6.0.3.2) lib/active_record/persistence.rb:385:in `_update_record'

activerecord (6.0.3.2) lib/active_record/persistence.rb:681:in `update_columns'

lib/post_creator.rb:496:in `update_topic_stats'

lib/post_creator.rb:199:in `block in create'

lib/post_creator.rb:375:in `block in transaction'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `block in transaction'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/transaction.rb:280:in `block in within_new_transaction'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:26:in `block (2 levels) in synchronize'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `handle_interrupt'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:25:in `block in synchronize'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `handle_interrupt'

activesupport (6.0.3.2) lib/active_support/concurrency/load_interlock_aware_monitor.rb:21:in `synchronize'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/transaction.rb:278:in `within_new_transaction'

activerecord (6.0.3.2) lib/active_record/connection_adapters/abstract/database_statements.rb:280:in `transaction'

activerecord (6.0.3.2) lib/active_record/transactions.rb:212:in `transaction'

lib/post_creator.rb:374:in `transaction'

lib/post_creator.rb:191:in `create'

lib/new_post_manager.rb:271:in `perform_create_post'

lib/new_post_manager.rb:209:in `perform'

app/controllers/posts_controller.rb:173:in `block in create'

lib/distributed_memoizer.rb:30:in `memoize'

app/controllers/posts_controller.rb:172:in `create'

actionpack (6.0.3.2) lib/action_controller/metal/basic_implicit_render.rb:6:in `send_action'

actionpack (6.0.3.2) lib/abstract_controller/base.rb:195:in `process_action'

actionpack (6.0.3.2) lib/action_controller/metal/rendering.rb:30:in `process_action'

actionpack (6.0.3.2) lib/abstract_controller/callbacks.rb:42:in `block in process_action'

activesupport (6.0.3.2) lib/active_support/callbacks.rb:112:in `block in run_callbacks'

app/controllers/application_controller.rb:340:in `block in with_resolved_locale'

i18n (1.8.3) lib/i18n.rb:313:in `with_locale'

app/controllers/application_controller.rb:340:in `with_resolved_locale'

activesupport (6.0.3.2) lib/active_support/callbacks.rb:121:in `block in run_callbacks'

activesupport (6.0.3.2) lib/active_support/callbacks.rb:139:in `run_callbacks'

actionpack (6.0.3.2) lib/abstract_controller/callbacks.rb:41:in `process_action'

actionpack (6.0.3.2) lib/action_controller/metal/rescue.rb:22:in `process_action'

actionpack (6.0.3.2) lib/action_controller/metal/instrumentation.rb:33:in `block in process_action'

activesupport (6.0.3.2) lib/active_support/notifications.rb:180:in `block in instrument'

activesupport (6.0.3.2) lib/active_support/notifications/instrumenter.rb:24:in `instrument'

activesupport (6.0.3.2) lib/active_support/notifications.rb:180:in `instrument'

actionpack (6.0.3.2) lib/action_controller/metal/instrumentation.rb:32:in `process_action'

actionpack (6.0.3.2) lib/action_controller/metal/params_wrapper.rb:245:in `process_action'

activerecord (6.0.3.2) lib/active_record/railties/controller_runtime.rb:27:in `process_action'

actionpack (6.0.3.2) lib/abstract_controller/base.rb:136:in `process'

actionview (6.0.3.2) lib/action_view/rendering.rb:39:in `process'

rack-mini-profiler (2.0.3) lib/mini_profiler/profiling_methods.rb:78:in `block in profile_method'

actionpack (6.0.3.2) lib/action_controller/metal.rb:190:in `dispatch'

actionpack (6.0.3.2) lib/action_controller/metal.rb:254:in `dispatch'

actionpack (6.0.3.2) lib/action_dispatch/routing/route_set.rb:50:in `dispatch'

actionpack (6.0.3.2) lib/action_dispatch/routing/route_set.rb:33:in `serve'

actionpack (6.0.3.2) lib/action_dispatch/journey/router.rb:49:in `block in serve'

actionpack (6.0.3.2) lib/action_dispatch/journey/router.rb:32:in `each'

actionpack (6.0.3.2) lib/action_dispatch/journey/router.rb:32:in `serve'

actionpack (6.0.3.2) lib/action_dispatch/routing/route_set.rb:834:in `call'

lib/middleware/omniauth_bypass_middleware.rb:68:in `call'

rack (2.2.3) lib/rack/tempfile_reaper.rb:15:in `call'

rack (2.2.3) lib/rack/conditional_get.rb:40:in `call'

rack (2.2.3) lib/rack/head.rb:12:in `call'

lib/content_security_policy/middleware.rb:12:in `call'

lib/middleware/anonymous_cache.rb:328:in `call'

rack (2.2.3) lib/rack/session/abstract/id.rb:266:in `context'

rack (2.2.3) lib/rack/session/abstract/id.rb:260:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/cookies.rb:648:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/callbacks.rb:27:in `block in call'

activesupport (6.0.3.2) lib/active_support/callbacks.rb:101:in `run_callbacks'

actionpack (6.0.3.2) lib/action_dispatch/middleware/callbacks.rb:26:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/actionable_exceptions.rb:17:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/debug_exceptions.rb:32:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/show_exceptions.rb:33:in `call'

logster (2.9.1) lib/logster/middleware/reporter.rb:43:in `call'

railties (6.0.3.2) lib/rails/rack/logger.rb:37:in `call_app'

railties (6.0.3.2) lib/rails/rack/logger.rb:28:in `call'

config/initializers/100-quiet_logger.rb:19:in `call'

config/initializers/100-silence_logger.rb:31:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/remote_ip.rb:81:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/request_id.rb:27:in `call'

lib/middleware/enforce_hostname.rb:22:in `call'

rack (2.2.3) lib/rack/method_override.rb:24:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/executor.rb:14:in `call'

rack (2.2.3) lib/rack/sendfile.rb:110:in `call'

actionpack (6.0.3.2) lib/action_dispatch/middleware/host_authorization.rb:76:in `call'

rack-mini-profiler (2.0.3) lib/mini_profiler/profiler.rb:200:in `call'

message_bus (3.3.1) lib/message_bus/rack/middleware.rb:61:in `call'

lib/middleware/request_tracker.rb:176:in `call'

railties (6.0.3.2) lib/rails/engine.rb:527:in `call'

railties (6.0.3.2) lib/rails/railtie.rb:190:in `public_send'

railties (6.0.3.2) lib/rails/railtie.rb:190:in `method_missing'

rack (2.2.3) lib/rack/urlmap.rb:74:in `block in call'

rack (2.2.

Error Env:

hostname	discourse-app
process_id	21623
application_version	8a9e4504fea9edd693ceecf314308cd08e99f0ca
HTTP_HOST	mpl.co
REQUEST_URI	/posts.json
REQUEST_METHOD	POST
HTTP_USER_AGENT	python-requests/2.22.0
HTTP_ACCEPT	application/json
HTTP_X_FORWARDED_FOR	183.82.159.193
HTTP_X_REAL_IP	183.82.159.193
username	Nideesh
time	11:41 am

Please suggest next steps.

sam · 2020 年8 月 5 日 06:21

这是由于摘要导致的。

请将站点设置 topic_excerpt_maxlength 更改为 999。

KranthiKiranGude · 2020 年8 月 5 日 12:37

谢谢 @sam……问题已解决。

sam · 2020 年8 月 6 日 08:00

此主题在 25 小时后自动关闭。不再允许新的回复。

话题		回复	浏览量
User can't post: 500 internal server error Support	12	1400	2018 年4 月 18 日
Internal Error 500 when creating a topic Bug	12	1515	2015 年9 月 18 日
Users reporting lots of 502 errors when attempting to post due to "max consecutive replies" check Bug	37	2960	2019 年1 月 18 日
500 Error when loading a specific topic Support post-voting	5	589	2022 年12 月 5 日
PG::StringDataRightTruncation (ERROR: value too long for type character varying(500) ) Bug	11	3909	2021 年6 月 5 日

发布主题时出现 500 错误

相关话题