[MCOL-3527] Calling stored procedure returned a user does not exist error Created: 2019-09-30  Updated: 2019-11-25  Resolved: 2019-11-25

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.4.0
Fix Version/s: 1.4.1

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2019-06

 Description   

Build tested: 1.4.0-1

engine commit:
1f47534

test: autopilot.features.crossEngineJoin

[root@localhost crossEngineJoin]# cat compressionRatiotestdb.log
ERROR 1449 (HY000) at line 1: The user specified as a definer (''@'') does not exist
--------------
call columnstore_info.compression_ratio()
--------------

Bye
[root@localhost crossEngineJoin]# cat totalDiskUsagetestdb.log
ERROR 1449 (HY000) at line 1: The user specified as a definer (''@'') does not exist
--------------
call columnstore_info.total_usage()
--------------

Bye

 Comments   
Comment by Daniel Lee (Inactive) [ 2019-10-30 ]

Build tested: 1.4.1-1

[dlee@master centos7]$ cat gitversionInfo.txt
engine commit:
3e7a964

I am still getting the same error message.

MariaDB [mytest]> call columnstore_info.total_usage();
ERROR 1449 (HY000): The user specified as a definer (''@'') does not exist
MariaDB [mytest]> show create procedure columnstore_info.total_usage;
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

total_usage ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `total_usage`()
BEGIN
SELECT
(SELECT columnstore_info.format_filesize(sum(data_size)) TOTAL_DATA_SIZE FROM INFORMATION_SCHEMA.COLUMNSTORE_EXTENTS) TOTAL_DATA_SIZE,
(SELECT columnstore_info.format_filesize(sum(file_size)) TOTAL_DISK_USAGE FROM INFORMATION_SCHEMA.COLUMNSTORE_FILES) TOTAL_DISK_USAGE;
END 		utf8 utf8_general_ci latin1_swedish_ci

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)

MariaDB [mysql]> select host, user from user;
----------------+

Host User

----------------+

localhost mysql
localhost root

----------------+
2 rows in set (0.003 sec)

Comment by Andrew Hutchings (Inactive) [ 2019-11-18 ]

Security settings for a function called in the procedures were incorrect. Instead of fixing that I've switched to INVOKER security level.

Comment by Daniel Lee (Inactive) [ 2019-11-25 ]

Build verified: 1.4.1-1 gitub source

/root/ColumnStore/buildColumnstoreFromGithubSource/server
commit f9ceb0a67ffb20631c936a7e8e8776c000d677ac
Author: Marko Mäkelä <marko.makela@mariadb.com>

/root/ColumnStore/buildColumnstoreFromGithubSource/server/engine
commit e1435a34ac4dcf49c5c86984d83839f91434c13b
Merge: 6b91667 a76ceb5
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>

[root@localhost crossEngineJoin]# cat totalDiskUsagetestdb.log
--------------
call columnstore_info.total_usage()
--------------

---------------------------------+

TOTAL_DATA_SIZE TOTAL_DISK_USAGE

---------------------------------+

146.14 MB 673.55 MB

---------------------------------+
1 row in set (0.903 sec)

Query OK, 0 rows affected (0.903 sec)

Bye
[root@localhost crossEngineJoin]# cat compressionRatiotestdb.log
--------------
call columnstore_info.compression_ratio()
--------------

-------------------

COMPRESSION_RATIO

-------------------

0.9335:1

-------------------
1 row in set (1.219 sec)

Query OK, 0 rows affected (1.219 sec)

Bye

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