PubSub persistence exceeds column length limit on ejabberd with SQL storage
2023-01-08 15:15:59.877 [error] <0.453.0>@ejabberd_sql:check_error:1229 SQL query 'Q81295254' at {node_flat_sql,824} failed: "#22001Data too long for column 'payload' at row 1"
2023-01-08 15:15:59.878 [error] <0.23081.41>@mod_pubsub:get_transaction_response:3894 Transaction aborted:
** exception throw: {aborted,"#22001Data too long for column 'payload' at row 1"}
in function ejabberd_sql:restart/1 (src/ejabberd_sql.erl, line 196)
in call from node_flat_sql:set_item/1 (src/node_flat_sql.erl, line 820)
in call from node_flat_sql:publish_item/7 (src/node_flat_sql.erl, line 254)
in call from mod_pubsub:node_call/4 (src/mod_pubsub.erl, line 3802)
in call from mod_pubsub:'-transaction/4-fun-0-'/3 (src/mod_pubsub.erl, line 3833)
in call from mod_pubsub:'-do_transaction/4-fun-0-'/3 (src/mod_pubsub.erl, line 3855)
in call from ejabberd_sql:execute_bloc/1 (src/ejabberd_sql.erl, line 570)
in call from ejabberd_sql:run_sql_cmd/4 (src/ejabberd_sql.erl, line 487)