P4DTI issue job000972

TitleEnormous changelist descriptions break replication to Bugzilla
Assigned userNick Barnes
DescriptionIf a changelist has a huge description, the replication poll will fail when attempting to replicate that changelist to Bugzilla. The limit on changelist size is unknown, but probably a little under one megabyte. The poll failure message includes this message: OperationalError: (2006, 'MySQL server has gone away'). This will also occur with enormous job fields.
AnalysisMySQL servers have a limit on "packet size" which by default is one megabyte. This apparently limits both queries and results (although I haven't seen it for results; presumably a result can occupy more than one packet). This can be changed on the server with the option "-O max_allowed_packet=#" (e.g. -O max_allowed_packet=16M). The P4DTI should also handle this failure, probably by truncating the description and mailing the administrator.
How foundcustomer
Evidence[1] <http://info.ravenbrook.com/mail/2004/07/22/14-07-22/0.txt>
Observed in2.1.2
Introduced in0.3.0
Created byNick Barnes
Created on2004-07-22 15:37:29
Last modified byNick Barnes
Last modified on2018-07-05 17:28:14
History2004-07-22 NB Created.
       2018-07-05 NB Suspended because the P4DTI is obsolete.