Mysql version 8.0.28 also has the issue on Packet out of order on federate table
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
AZAR THAMEEMUN September 14, 2023 at 5:34 AM
Team!! Any solution for it?
AZAR THAMEEMUN September 3, 2023 at 8:20 AM
Hi Aaditya,
It was in oracle mysql community edition and this issue is happening while trying to select a data from the ferderate table, i heard it is fixed in 8.0.28. But still facing the same issue
Aaditya Dubey September 1, 2023 at 1:47 PMEdited
Hi [~accountid:5fb22feb47ac91006f459fba],
Thank you for the report.
Please let us know if this is upstream or Percona server ?
Please check this https://jira.percona.com/browse/PS-8747 where this issue is actually fixed.
Duplicate
Details
Details
Assignee
Aaditya Dubey
Aaditya DubeyReporter
AZAR THAMEEMUN
AZAR THAMEEMUNNeeds QA
Yes
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created September 1, 2023 at 10:29 AM
Updated March 6, 2024 at 9:34 AM
Resolved September 1, 2023 at 5:40 PM
Hi, getting this error on Mysql 8.0.28 in random manner, is there any solution for it
ERROR 1156 (08S01) at line 1: Got packets out of order
mysql> select version();
-----------
version()
-----------
8.0.28
-----------
1 row in set (0.00 sec)
Have also increased the timeout to 8 hrs
mysql> show variables like '%timeout%';
----------------------------------{-}{-}---------+
Variable_name
Value
----------------------------------{-}{-}---------+
connect_timeout
10
delayed_insert_timeout
300
have_statement_timeout
YES
innodb_flush_log_at_timeout
1
innodb_lock_wait_timeout
100
innodb_rollback_on_timeout
OFF
interactive_timeout
28800
lock_wait_timeout
31536000
mysqlx_connect_timeout
30
mysqlx_idle_worker_thread_timeout
60
mysqlx_interactive_timeout
28800
mysqlx_port_open_timeout
0
mysqlx_read_timeout
30
mysqlx_wait_timeout
28800
mysqlx_write_timeout
60
net_read_timeout
3600
net_write_timeout
31536000
replica_net_timeout
60
rpl_stop_replica_timeout
31536000
rpl_stop_slave_timeout
31536000
slave_net_timeout
60
wait_timeout
28800
----------------------------------{-}{-}---------+
22 rows in set (0.00 sec)
This case happens, when we have scheduled a cron to update data on a federate table one day once , getting this error in random manner. And also we have made federate connection for the table from 2 different DB server, but has same mysql version and same timeout config to 8 hrs. Any solution for this issue