[MDEV-32563] Describe table1 shows error Created: 2023-10-24  Updated: 2023-11-04  Resolved: 2023-11-04

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Procedure
Affects Version/s: 10.3.39
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Sudhanshu Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Rockylinux


Issue Links:
Duplicate
is duplicated by MDEV-32562 mysqldump crashing Closed

 Description   

From inside MAriadb-CLI - just asking description of table produces error like below

MariaDB [inventory]> describe outward;
ERROR 2013 (HY000): Lost connection to MySQL server during query



 Comments   
Comment by Sudhanshu [ 2023-10-25 ]

already done mysqlcheck and no error found on tables or databases with all OK

But issue persist

Comment by Sudhanshu [ 2023-10-26 ]

tried upgrading to Mariadb11 version also , problem persist

All queries like select * from table1 table2 works

But queries like
show fields from table1
describe table1

ERROR 2013 (HY000): Lost connection to server during query

Comment by Sudhanshu [ 2023-10-26 ]

Ok now able to solve this issue with below commands

mysql_upgrade -u root -p

Comment by Sergei Golubchik [ 2023-11-03 ]

do you still have that table that causes the crash?

Comment by Sudhanshu [ 2023-11-04 ]

This is solved already

Sudhanshu Bhasin
LensBazaar.com

Generated at Thu Feb 08 10:32:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.