[MDEV-15613] Cannot showing procedure after minor upgrade Created: 2018-03-21  Updated: 2018-07-02  Resolved: 2018-07-02

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Pramudya Aditya Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

CentOS


Attachments: JPEG File error#1.jpg     JPEG File error#2.jpg     JPEG File error#3.JPG    

 Description   

Hi all, today i upgraded minor version from 10.1.21 to 10.1.31 (also 10.1.33) with step below

  • stopping mariadb
  • remove mariadb
  • delete all datafiles
  • delete configuration files
  • install newest mariadb
  • do mysql_upgrade
  • do mysql_secure_installation
  • join galera cluster

but after upgrade, i saw a weird error that either the procedure and function cannot be shown (see #error1).

It says "column length too big for column '(null)' (max = 65532); use BLOB or TEXT instead."

i thought that my db tool (toad for mysql) is error or something, but i tried upgrade toad for mysql to the newest version it still same. Also i try another db tool like dbeaver and heidisql are the same

i try to query directly by shell (see #error2) and facing same error.

i am sure every step i did was so true and nothing error happen, especially do mysql_upgrade.

FYI : i create new procedure then i run it, it was success but not for showing

*UPDATE : try to 'show procedure status' it went normal, but 'show function status' is not



 Comments   
Comment by Elena Stepanova [ 2018-05-29 ]

Side note: it's unclear what you're trying to achieve. If you deleted all data files and configuration files, then why would you run mysql_upgrade?

Please provide the whole server error log, starting before the upgrade and ending after you got the errors you describe.

Generated at Thu Feb 08 08:22:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.