[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: |
|
| Description |
|
Hi all, today i upgraded minor version from 10.1.21 to 10.1.31 (also 10.1.33) with step below
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. |