https://live.paloaltonetworks.com/t5/expedition-articles/expedition-migration-is-stacked-with-below-errors-messages-tmp/ta-p/509186 <DIV class="lia-message-template-content-zone"> <DIV class="lia-message-template-symptoms-zone"> <H2>Symptoms</H2> <P>While executing a migration you get one of bellow message errors on the /tmp/error file:&nbsp;</P> <UL> <LI>Got a packet bigger than 'max_allowed_packet' bytes</LI> <LI>Error while sending QUERY|STATISTICS packet</LI> </UL> <P>Also the migration process could be stacked at some point for a long period of time.</P> </DIV> <DIV class="lia-message-template-diagnosis-zone"> <H2>Diagnosis</H2> <P>MySQL is not supporting to create the among of objects defined on your config so you need to give more resources to MySQL.</P> </DIV> <DIV class="lia-message-template-solution-zone"> <H2>Solution</H2> <P>Resize the max allowed packets property on Mysql.</P> <DIV><SPAN>1) Locate your max_allowed_packet mysql configuration (for instance inside:&nbsp;/etc/mysql/mariadb.conf.d/50-server.cnf).</SPAN></DIV> <DIV><SPAN>2) Edit the mysql config file and increase the MB for the property&nbsp;max_allowed_packet (for instance:&nbsp;max_allowed_packet = 100M).</SPAN></DIV> <DIV><SPAN>3) Restart mysql (for instance: service mysql restart).&nbsp;</SPAN></DIV> <DIV data-removefontsize="true" data-originalcomputedfontsize="16">4) Execute the migration in a new clean Expedition project.</DIV> </DIV> </DIV> Mon, 18 Jul 2022 13:38:20 GMT dpuigdomenec 2022-07-18T13:38:20Z https://live.paloaltonetworks.com/t5/expedition-articles/expedition-migration-is-stacked-with-below-errors-messages-tmp/ta-p/509186 <DIV class="lia-message-template-content-zone"> <DIV class="lia-message-template-symptoms-zone"> <H2>Symptoms</H2> <P>While executing a migration you get one of bellow message errors on the /tmp/error file:&nbsp;</P> <UL> <LI>Got a packet bigger than 'max_allowed_packet' bytes</LI> <LI>Error while sending QUERY|STATISTICS packet</LI> </UL> <P>Also the migration process could be stacked at some point for a long period of time.</P> </DIV> <DIV class="lia-message-template-diagnosis-zone"> <H2>Diagnosis</H2> <P>MySQL is not supporting to create the among of objects defined on your config so you need to give more resources to MySQL.</P> </DIV> <DIV class="lia-message-template-solution-zone"> <H2>Solution</H2> <P>Resize the max allowed packets property on Mysql.</P> <DIV><SPAN>1) Locate your max_allowed_packet mysql configuration (for instance inside:&nbsp;/etc/mysql/mariadb.conf.d/50-server.cnf).</SPAN></DIV> <DIV><SPAN>2) Edit the mysql config file and increase the MB for the property&nbsp;max_allowed_packet (for instance:&nbsp;max_allowed_packet = 100M).</SPAN></DIV> <DIV><SPAN>3) Restart mysql (for instance: service mysql restart).&nbsp;</SPAN></DIV> <DIV data-removefontsize="true" data-originalcomputedfontsize="16">4) Execute the migration in a new clean Expedition project.</DIV> </DIV> </DIV> Mon, 18 Jul 2022 13:38:20 GMT https://live.paloaltonetworks.com/t5/expedition-articles/expedition-migration-is-stacked-with-below-errors-messages-tmp/ta-p/509186 dpuigdomenec 2022-07-18T13:38:20Z