Ttdfjt

How should i charge 3 lithium ion batteries?

I don't have the theoretical background in my PhD topic. I can't justify getting the degree

Why is a statement like 1 + n *= 3 allowed in Ruby?

Can Orcus use Multiattack with any melee weapon?

Is the internet in Madagascar faster than in UK?

Is the negative potential of 書く used in this sentence and what is its meaning?

What are these white rings in the Undead parish?

Count the number of paths to n

Redacting URLs as an email-phishing preventative?

How do I remap "å" to type "å"?

Prevent use of CNAME record for untrusted domain

Expanding powers of expressions of the form ax+b

Tex Quotes(UVa 272)

What is the name of my succulent?

How can I download a file from a host I can only SSH to through another host?

How were medieval castles built in swamps or marshes without draining them?

Why did my folder names end up like this, and how can I fix this using a script?

"There were either twelve sexes or none."

Is one hour layover sufficient at Singapore Changi Airport (Indian citizen travelling from US to India)?

Adoption records in 1871 based on census info

50-move rule: only the last 50 or any consecutive 50?

Can an Arcane Focus be embedded in one's body?

Can you board the plane when your passport is valid less than 3 months?

How is linear momentum conserved in case of a freely falling body?

Magento 2 Migration: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes

Source fields are not mapped - migration errorMigration magento 1 to magento 2Magento migration SQL errorMagento 2 Migration Error (eav_attribute)Warning: Error while sending QUERY packet. - Magento MigrationMagento Migration errorMagento 2.3.2 Failed to load the “Magento_Checkout/js/view/billing-address/list” component

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  reference link=> stackoverflow.com/questions/93128/…
  
  – Savan Patel
  Aug 14 at 11:28
  
  

  
  
  
  

add a comment | 

0

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  reference link=> stackoverflow.com/questions/93128/…
  
  – Savan Patel
  Aug 14 at 11:28
  
  

  
  
  
  

add a comment | 

In Map Step some time after below type error showing

Communication link failure: 1153 Got a packet bigger than
'max_allowed_packet' bytes

Source Magento : 1.9.3.3

Destination Magento : 2.3.2

How can solve above error

Any help would be appreciated.

Thanks.

migration magento2.3.2 magento-1.9.3.3

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

share|improve this question

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

edited Aug 14 at 13:43

Sumit

51511 silver badge1414 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

asked Aug 14 at 11:26

Rakesh DongaRakesh Donga

3,05566 silver badges2525 bronze badges

1 Answer
1

active

oldest

votes

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f285467%2fmagento-2-migration-communication-link-failure-1153-got-a-packet-bigger-than%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

0

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have tried that not working for me
  
  – Rakesh Donga
  Aug 14 at 12:22
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Also, change my.cnf or my.ini file under the mysqld section and set: max_allowed_packet=100M
  
  – Sumit
  Aug 14 at 12:39
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  i have changed that two time but still not working for me
  
  – Rakesh Donga
  Aug 14 at 12:42
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Restart the MySQL server and apache 2.
  
  – Sumit
  Aug 14 at 12:44
  

  
  
  
  

add a comment | 

I've faced the same issue while migration.

You can fix this issue by following the below steps:

Change the MySQL max_pocket_size from the MySQL console to
1000000000.

run below query in MySQL console:

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

Hope it'll help!

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

set global net_buffer_length=1000000;
set global max_allowed_packet=1000000000;

share|improve this answer

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

edited Aug 14 at 11:34

Savan Patel

1,12044 silver badges2222 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges

answered Aug 14 at 11:32

SumitSumit

51511 silver badge1414 bronze badges