<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
p.NurText, li.NurText, div.NurText
{mso-style-name:"Nur Text";
mso-style-link:"Nur Text Zchn";
margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.NurTextZchn
{mso-style-name:"Nur Text Zchn";
mso-style-priority:99;
mso-style-link:"Nur Text";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">I had that issue initially, and changed the value to 64MB. It was originally 4MB, then I increased it to 16MB, it’s been at 64MB for some time.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"># The maximum size of one packet or any generated or intermediate string, or any parameter sent by the<o:p></o:p></p>
<p class="MsoNormal"># mysql_stmt_send_long_data() C API function.<o:p></o:p></p>
<p class="MsoNormal">#max_allowed_packet=4M<o:p></o:p></p>
<p class="MsoNormal">#max_allowed_packet=16M<o:p></o:p></p>
<p class="MsoNormal">max_allowed_packet=64M<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It’s the oddest thing. The backups were working perfectly through most of December. Sometime between the week of Christmas and now it seems to have “blown up”. As a work around right now, I’ve split the backup in two pieces: just attachments,
and everything else. That appears to be working but I can’t seem to explain why this has happened.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:black">Stephen Cena<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:black">Senior Systems Administrator <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:black">Quality Vision International, Inc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Phone: (585) 544-0450 x300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">To notify helpdesk: <a href="http://helpdesk.ogp.qvii.com">
<span style="color:blue">http://helpdesk.ogp.qvii.com</span></a> or email: <u><a href="mailto:hd-general@qvii.com"><span style="color:black">hd-general@qvii.com</span></a><o:p></o:p></u></span></p>
<p class="MsoNormal"><span style="color:black">To report email issues: <a href="mailto:postmaster@qvii.com">
<span style="color:blue">postmaster@qvii.com</span></a><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Thomas Bätzler [mailto:t.baetzler@bringe.com] <br>
<b>Sent:</b> Thursday, January 19, 2017 3:04 AM<br>
<b>To:</b> 'rt-users@lists.bestpractical.com' <rt-users@lists.bestpractical.com><br>
<b>Cc:</b> Cena, Stephen (ext. 300) <SJC@qvii.com><br>
<b>Subject:</b> AW: [rt-users] MySQL backups of RT 4.4.1 truncated<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Hello Stephen,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">just a stab in the dark, but could you please check the value set for “max_allowed_packet” in the mysqldump section of /etc/mysql/my.cnf (or whatever your my.cnf file is named)? If you try to dump mysql objects
that are larger than this size, mysqldump will stop; probably with a message like “mysql server has gone away”. You can raise that value for mysqldump just by editing that file; no server restart is required.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">HTH,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Thomas Bätzler<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">-- <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">BRINGE Informationstechnik GmbH<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Zur Seeplatte 12<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">D-76228 Karlsruhe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Germany<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Fon: +49 721 94246-0<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Fon: +49 171 5438457<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Fax: +49 721 94246-66<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Web: <a href="http://www.bringe.de/">
http://www.bringe.de/</a><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Geschäftsführer: Dipl.-Ing. (FH) Martin Bringe<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D">Ust.Id: DE812936645, HRB 108943 Mannheim<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="DE" style="color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span lang="DE">Von:</span></b><span lang="DE"> rt-users [<a href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>]
<b>Im Auftrag von </b>Cena, Stephen (ext. 300)<br>
<b>Gesendet:</b> Mittwoch, 18. Januar 2017 18:23<br>
<b>An:</b> 'rt-users@lists.bestpractical.com' <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>
<b>Betreff:</b> Re: [rt-users] MySQL backups of RT 4.4.1 truncated<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="DE"><o:p> </o:p></span></p>
<p class="MsoNormal">I just ran a test with the attachments table “ignored”, and the backup worked perfectly. As a “sanity check”, I also ran mysqlcheck on the schema & no errors were found. Should I split my backup job into two pieces, or is there a better
way to get a backup all in one shot?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoPlainText">------------------------------<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Message: 4<o:p></o:p></p>
<p class="MsoPlainText">Date: Wed, 18 Jan 2017 13:54:57 +0000<o:p></o:p></p>
<p class="MsoPlainText">From: "Cena, Stephen (ext. 300)" <<a href="mailto:SJC@qvii.com">SJC@qvii.com</a>><o:p></o:p></p>
<p class="MsoPlainText">To: "'rt-users@lists.bestpractical.com'"<o:p></o:p></p>
<p class="MsoPlainText"> <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><o:p></o:p></p>
<p class="MsoPlainText">Subject: [rt-users] MySQL backups of RT 4.4.1 truncated<o:p></o:p></p>
<p class="MsoPlainText">Message-ID:<o:p></o:p></p>
<p class="MsoPlainText"> <<a href="mailto:87F81E27495DC8489147E34A4152E268A49508BA@MailStore2010.ogp.qvii.com">87F81E27495DC8489147E34A4152E268A49508BA@MailStore2010.ogp.qvii.com</a>><o:p></o:p></p>
<p class="MsoPlainText">Content-Type: text/plain; charset="us-ascii"<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">I'm currently running RT 4.4.1 on Ubuntu 14.04 LTS with MySQL 5.6 on Windows Server 2012. Recently, we enabled full-text indexing in native MySQL & everything is great. After doing some work on the server over the weekend, I discovered
that the .sql files being generated for the backup are being "truncated" after the attachments table (~18-19GB). After reviewing your documentation (<a href="https://docs.bestpractical.com/rt/4.4.1/backups.html">https://docs.bestpractical.com/rt/4.4.1/backups.html</a>)
I realized my mysqldump command was incorrect. I'm working in a lab environment now to see how I can optimize/change my script to more closely match yours. The only thought I have right now is to exclude the data from the AttachmentsIndex as that would get
rebuilt on restoration anyways. Is there any other reason that the backup would just "stop" after the attachment table? I apologize if this is beyond the scope of the forums thread.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Thank you in advance!<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Stephen Cena<o:p></o:p></p>
<p class="MsoPlainText">Senior Systems Administrator<o:p></o:p></p>
<p class="MsoPlainText">Quality Vision International, Inc.<o:p></o:p></p>
<p class="MsoPlainText">Phone: (585) 544-0450 x300<o:p></o:p></p>
<p class="MsoPlainText">To notify helpdesk: <a href="http://helpdesk.ogp.qvii.com">
http://helpdesk.ogp.qvii.com</a> or email: <a href="mailto:hd-general@qvii.com%3cmailto:hd-general@qvii.com">
hd-general@qvii.com<mailto:hd-general@qvii.com</a>><o:p></o:p></p>
<p class="MsoPlainText">To report email issues: <a href="mailto:postmaster@qvii.com%3cmailto:postmaster@qvii.com">
postmaster@qvii.com<mailto:postmaster@qvii.com</a>><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:14.0pt;color:black">Stephen Cena<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:black">Senior Systems Administrator <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="color:black">Quality Vision International, Inc.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">Phone: (585) 544-0450 x300<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:black">To notify helpdesk: <a href="http://helpdesk.ogp.qvii.com">
<span style="color:blue">http://helpdesk.ogp.qvii.com</span></a> or email: <u><a href="mailto:hd-general@qvii.com"><span style="color:black">hd-general@qvii.com</span></a><o:p></o:p></u></span></p>
<p class="MsoNormal"><span style="color:black">To report email issues: <a href="mailto:postmaster@qvii.com">
<span style="color:blue">postmaster@qvii.com</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</body>
</html>