innodb_page_size of 16384 is the default, so that is what I'm working with as well. The row size limit is half the page size minus some overhead, so it comes out to 8126 and I bet that is yours as well.
Yes, I am utf8mb4 at the database and table levels, and I bet you are right.
-Joel
On 12/26/2020 1:51 PM, Torge Riedel wrote:
I am also using MySQL and successfully upgraded to 3.3.2, the additional column was successfully added.
See this link: https://dev.mysql.com/doc/mysql-reslimits-excerpt/5.7/en/column-count-limit....
MySQL-Workbenchs shows me an innodb_page_size of 16384, so my guess is why you are hit by this limit and I am not is, that you might be using utf8mb4 where my DB is still on utf8!?
I see a lot (20 if I counted right) columns with VARCHAR(255) and 4 with VARCHAR(510) in table "mailinglist". Feels to me that this could bring the rows near or above to the limit.
But these are just rough guesses.
Kind regards Torge
Am 26.12.20 um 18:58 schrieb Joel Lord:
I've just upgraded python to 3.7, so now I can upgrade mailman from 3.3.1 to 3.3.2. Take it down, "pip install --upgrade mailman", and try a "mailman info". It fails hard, and what I think are the important parts of the stack trace are:
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1118, 'Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs') [SQL: ALTER TABLE mailinglist ADD COLUMN archive_rendering_mode INTEGER] (Background on this error at: http://sqlalche.me/e/13/e3q8)
Looks to me like the mailinglist table has been using awfully close to the default mysql max row length, and this added column pushes me over? Is there some other fix other than a terrifyingly gigantic process of dumping all my databases, changing my page size, and restoring them all? This DB server isn't serving just mailman...
Thanks
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
-- Joel Lord