Environment
- ejabberd version: 26.03
- Erlang version: Erlang (SMP,ASYNC_THREADS) (BEAM) emulator version 12.3.2.15
- OS: Linux (Mageia)
- Installed from: official binary installer
Bug description
I have tried to set the profile image using Snikket, whicht never succeeded, so I did that using Monal IM. I have tried to check the logs in order to see, what is going on so I found the following:
2026-04-05 21:06:24.595181+02:00 [error] <0.550.0>@ejabberd_sql:check_error/2:1470 SQL query 'Q69783698' at {node_flat_sql,{851,9}} failed: <<"Data too long for column 'payload' at row 1">>
2026-04-05 21:06:24.602537+02:00 [error] <0.7256.0>@mod_pubsub:get_transaction_response/1:3967 Transaction aborted:
** exception throw: {aborted,<<"Data too long for column 'payload' at row 1">>}
in function ejabberd_sql:restart/1 (src/ejabberd_sql.erl:238)
in call from node_flat_sql:set_item/1 (src/node_flat_sql.erl:849)
in call from node_flat_sql:publish_item/7 (src/node_flat_sql.erl:272)
in call from mod_pubsub:node_call/4 (src/mod_pubsub.erl:3871)
in call from mod_pubsub:'-transaction/4-fun-0-'/3 (src/mod_pubsub.erl:3904)
in call from mod_pubsub:'-do_transaction/4-fun-0-'/3 (src/mod_pubsub.erl:3926)
in call from ejabberd_sql:execute_bloc/1 (src/ejabberd_sql.erl:690)
in call from ejabberd_sql:run_sql_cmd/4 (src/ejabberd_sql.erl:571)
I am not sure if this is related to the profile image or another thing, but after setting the profile image using Monal IM the error dissappeared.
If there is anything I can do to debug this, please tell me.
Environment
Bug description
I have tried to set the profile image using Snikket, whicht never succeeded, so I did that using Monal IM. I have tried to check the logs in order to see, what is going on so I found the following:
2026-04-05 21:06:24.595181+02:00 [error] <0.550.0>@ejabberd_sql:check_error/2:1470 SQL query 'Q69783698' at {node_flat_sql,{851,9}} failed: <<"Data too long for column 'payload' at row 1">>
2026-04-05 21:06:24.602537+02:00 [error] <0.7256.0>@mod_pubsub:get_transaction_response/1:3967 Transaction aborted:
** exception throw: {aborted,<<"Data too long for column 'payload' at row 1">>}
in function ejabberd_sql:restart/1 (src/ejabberd_sql.erl:238)
in call from node_flat_sql:set_item/1 (src/node_flat_sql.erl:849)
in call from node_flat_sql:publish_item/7 (src/node_flat_sql.erl:272)
in call from mod_pubsub:node_call/4 (src/mod_pubsub.erl:3871)
in call from mod_pubsub:'-transaction/4-fun-0-'/3 (src/mod_pubsub.erl:3904)
in call from mod_pubsub:'-do_transaction/4-fun-0-'/3 (src/mod_pubsub.erl:3926)
in call from ejabberd_sql:execute_bloc/1 (src/ejabberd_sql.erl:690)
in call from ejabberd_sql:run_sql_cmd/4 (src/ejabberd_sql.erl:571)
I am not sure if this is related to the profile image or another thing, but after setting the profile image using Monal IM the error dissappeared.
If there is anything I can do to debug this, please tell me.