| Title | Enormous changelist descriptions break replication to Bugzilla |
| Status | suspended |
| Priority | essential |
| Assigned user | Nick Barnes |
| Organization | Ravenbrook |
| Description | If 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. |
| Analysis | MySQL 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 found | customer |
| Evidence | [1] <http://info.ravenbrook.com/mail/2004/07/22/14-07-22/0.txt> |
| Observed in | 2.1.2 |
| Introduced in | 0.3.0 |
| Created by | Nick Barnes |
| Created on | 2004-07-22 15:37:29 |
| Last modified by | Nick Barnes |
| Last modified on | 2018-07-05 17:28:14 |
| History | 2004-07-22 NB Created. 2018-07-05 NB Suspended because the P4DTI is obsolete. |