[MDEV-29405] Odd behavior on Jammy with first select Created: 2022-08-29  Updated: 2022-10-13  Resolved: 2022-10-13

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

Type: Bug Priority: Major
Reporter: Kim Gert Nielsen Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

ubuntu jammy



 Description   

Hi,

I have created a test for mariadb 10.6.9 on Jammy in a qemu instance but .. on a fresh install I get

Database changed
MariaDB [mysql]> show databases;
ERROR:
MariaDB [mysql]> show tables;
+---------------------+
| Database            |
+---------------------+
| _mysql_housekeeping |
| information_schema  |
| mysql               |
| performance_schema  |
| sys                 |
+---------------------+
5 rows in set (0.000 sec)
 
MariaDB [mysql]> show functions;
+---------------------------+
| Tables_in_mysql           |
+---------------------------+
| column_stats              |
| columns_priv              |
| db                        |
| event                     |
| func                      |
| general_log               |
| global_priv               |
| gtid_slave_pos            |
| help_category             |
| help_keyword              |
| help_relation             |
| help_topic                |
| index_stats               |
| innodb_index_stats        |
| innodb_table_stats        |
| plugin                    |
| proc                      |
| procs_priv                |
| proxies_priv              |
| roles_mapping             |
| servers                   |
| slow_log                  |
| table_stats               |
| tables_priv               |
| time_zone                 |
| time_zone_leap_second     |
| time_zone_name            |
| time_zone_transition      |
| time_zone_transition_type |
| transaction_registry      |
| user                      |
+---------------------------+
31 rows in set (0.000 sec)
 
MariaDB [mysql]>
MariaDB [mysql]> show functions;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'functions' at line 1

or

mysql mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 10.6.9-MariaDB-1:10.6.9+maria~ubu2204
 
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
MariaDB [mysql]> repair table proc;
+---------------------------------+
| @@version_comment               |
+---------------------------------+
| mariadb.org binary distribution |
+---------------------------------+
1 row in set (0.000 sec)
 
MariaDB [mysql]>

packages installed

ii  libmariadb3:amd64                    1:10.6.9+maria~ubu2204                          amd64        MariaDB database client library
ii  mariadb-client                       1:10.6.9+maria~ubu2204                          all          MariaDB database client (metapackage depending on the latest version)
ii  mariadb-client-10.6                  1:10.6.9+maria~ubu2204                          amd64        MariaDB database client binaries
ii  mariadb-client-core-10.6             1:10.6.9+maria~ubu2204                          amd64        MariaDB database core client binaries
ii  mariadb-common                       1:10.6.9+maria~ubu2204                          all          MariaDB common configuration files
ii  mariadb-server-10.6                  1:10.6.9+maria~ubu2204                          amd64        MariaDB database server binaries
ii  mariadb-server-core-10.6             1:10.6.9+maria~ubu2204                          amd64        MariaDB database core server files
i  libmysqlclient21:amd64               8.0.30-0ubuntu0.22.04.1                         amd64        MySQL database client library
ii  mysql-common                         1:10.6.9+maria~ubu2204                          all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

I also see this when connection from the python library mysql connector. First select always gives a out of index error .. second select works.

all of it installed from mariadb downloads.

I also did a test of 10.6.9 on Focal and that works as expected.



 Comments   
Comment by Kim Gert Nielsen [ 2022-10-03 ]

No news?

Comment by Kim Gert Nielsen [ 2022-10-13 ]

oki so in the mean time 10.6.10 is released and its fixed whatever it was

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