[MCOL-1475] Improve cross engine error handling Created: 2018-06-14  Updated: 2018-06-28  Resolved: 2018-06-28

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

Type: New Feature Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-12, 2018-13

 Description   

Cross Engine Join handler has very rudimentary error handling. We need more details about what goes wrong in the MariaDB client/server, including proper error codes and messages where possible.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-06-14 ]

Please do not merge until 1.1.5 has been released.

For QA: best test I've found is to create a MariaDB user that can't access the tables, use that as the cross engine user and try to do a cross engine select query. You should now get a much more verbose error message.

Comment by Daniel Lee (Inactive) [ 2018-06-28 ]

Build verified: 1.1.6-1 source

[root@localhost ~]# cat mariadb-columnstore-1.1.6-1-centos7.x86_64.bin.tar.gz.txt
/root/columnstore/mariadb-columnstore-server
commit 1741c7e7d522d1245ec9c1e4c7c7474574f09bd2
Merge: 2adc4b5 6abef48
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Tue Jun 19 09:51:48 2018 -0500

Merge pull request #113 from mariadb-corporation/davidhilldallas-patch-3

update readme

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit c4e9b0ce3a396edd2353eb44532336e9db857f86
Merge: ac45350 ffb76bb
Author: David.Hall <david.hall@mariadb.com>
Date: Wed Jun 27 17:36:13 2018 -0500

Merge pull request #511 from mariadb-corporation/MCOL-1467-1

MCOL-1467 - changes to get back to 1.1.6

Executed the mentioned test.

In 1.1.6-1, the error message is:
ERROR 1815 (HY000): Internal error: fatal error reading result from crossengine client lib (1044) (Access denied for user 'testuser'@'localhost' to database 'infinidb_vtable')

Confirmed the expected error message with developer.

In 1.1.5-1, the error message is:
MariaDB [mytest]> select * from orders t1, orderids t2 where t1.o_orderkey = t2.okey;
ERROR 1815 (HY000): Internal error: fatal error reading result from crossengine client lib(4294967295)(null pointer)

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