[Pkg-mailman-hackers] Bug#921128: Bug#921128: Info received (mailman3-web fails to initialize mysql: Specified key was too long)

[Jonas Meurer]

Hi PEB, hi anarcat,

Pierre-Elliott Bécue:
> Le lundi 11 février 2019 à 16:27:21-0500, Antoine Beaupré a écrit :
>> On 2019-02-11 21:52:32, Pierre-Elliott Bécue wrote:
>>> Le lundi 11 février 2019 à 09:14:55-0500, Antoine Beaupré a écrit :
>>>> Right, the only way this could be properly implemented would be if
>>>> debconf would attempt to connect with the configured DB credentials to
>>>> check the remote server version (or, better, to test the actuall code
>>>> bugginess).
>>>>
>>>> That's probably overkill though.
>>>
>>> ISTM that it is.
>>>
>>> But if you wish to go to such extents I'd be glad to include a patch!
>>> (no time to dev it though)
>>
>> Alright, let good win in the face of non-existing perfect threats. ;)
> 
> I'll leave ourselves 24h of thinking and then I'll upload.
> 
> If you get attacked by insomnia, you know what to do. :P

Sorry for not responding earlier, I was to busy with other things.
Still, I should have reacted earlier ...

As you might have seen, mariadb-10.1 10.1.37-0+deb9u1 is in stable-new
queue[1]. I don't know the details why it didn't proceed to stable yet,
but there's hope that this issue will be sorted out in Stretch soon. The
10.1.37 contains both the upstream backport of
`innodb_default_row_format`[2] and the patch to the config[3] that sets
the default row format to `dynamic`, so the `max key length is 767
bytes` error is definitely fixed in this release.

Therefore I don't think it's still *needed* to upload the patch that PEB
poposed in this bugreport. I don't *object* to uploading it either. So
if you want to, go ahead, PEB. But we should track the mariadb 10.1
version in Stretch and remove the Debconf question again once mariadb
10.1.37 got accepted into Stretch.

Cheers
 jonas

[1]
https://tracker.debian.org/news/1004285/accepted-mariadb-101-10137-0deb9u1-source-into-stable-embargoed-stable/
[2] https://jira.mariadb.org/browse/MDEV-14904
[3]
https://salsa.debian.org/mariadb-team/mariadb-10.1/commit/89ae638d1d3b5a7157d086a9be2468cae764aae7

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/pkg-mailman-hackers/attachments/20190211/fc1ce397/attachment.sig>