JanZerebecki added a comment.

  [wikidatawiki]> select length(change_info) from wb_changes where change_id in 
(236998945, 236999268, 237059314, 237059627) ;
  +---------------------+
  | length(change_info) |
  +---------------------+
  |               65535 |
  |               65535 |
  |               65535 |
  |               65535 |
  +---------------------+
  4 rows in set (0.00 sec)

"A BLOB column with a maximum length of 65,535 (216 - 1) bytes" - 
https://mariadb.com/kb/en/mariadb/blob/
At some point I checked what the then current MySQL does when you insert longer 
values, in default settings it gave no error and just cut it off. Seems that 
happened here.

Fix our MariaDB settings or add checks everywhere for length?
Move to MEDIUMBLOB?


TASK DETAIL
  https://phabricator.wikimedia.org/T108130

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: JanZerebecki
Cc: Addshore, daniel, JanZerebecki, Aklapper, hoo, Wikidata-bugs, aude, 
Malyacko, P.Copp



_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to