Change job table params from blob to mediumblob
authorErik Bernhardson <ebernhardson@wikimedia.org>
Mon, 1 Apr 2019 16:05:08 +0000 (09:05 -0700)
committerErik Bernhardson <ebernhardson@wikimedia.org>
Mon, 1 Apr 2019 16:07:35 +0000 (09:07 -0700)
commitc3c22e9ae8b21db6a708c1ebb4ddd984c6018f94
tree37172b9c87d5beb17037448a44eac12b299e8f12
parent2379bd01251bee365095f32b1eaba12b8f449d3d
Change job table params from blob to mediumblob

The default blob type holds 65kB which is often enough, but some
jobs push over this limit. When using mysql these are silently
truncated to 65kB which only issues errors when the data is retrieved.

Increase from blob to mediumblob which gives a max size of 16MB. There
may be some valid use cases for jobs > 64kB, but there should be no
use case for jobs > 16MB.

Bug: T124196
Change-Id: I6df6634bd3a5b5fa27ce6f8ff20d251a9b5eba32
includes/installer/MysqlUpdater.php
maintenance/archives/patch-job-params-mediumblob.sql [new file with mode: 0644]
maintenance/tables.sql