Welcome to our community, and thanks for trying out our database.
The cuda_mapd_rt.a library contains the code to do SUMs, counts, and other kinds of aggregations, so I believe you are getting this error when you run queries containing aggregates in GPU mode. You don’t get the error when you run projection query with filtering and or joins.
Anyway, the error looks to be self-explaining. Into the path where you installed the software, it seems the library is missing, or the user you used to run the server hasn’t the right to read it.
In a regular installation, until 5.2.x release, the QueryEngine directory would look like that
mapd@zion16:/opt/mapd/omnisci-ee-5.2.0-20200416-4cc64c2b32-Linux-x86_64-render$ ls -la QueryEngine/
drwxrwxr-x 2 mapd mapd 4096 Apr 17 00:49 .
drwxrwxr-x 12 mapd mapd 4096 Jul 3 2019 ..
-rw-r--r-- 1 mapd mapd 3621492 Apr 16 23:52 cuda_mapd_rt.a
-rw-r--r-- 1 mapd mapd 18761 Apr 16 23:51 ExtensionFunctions.ast
-rw-r--r-- 1 mapd mapd 3869 Apr 16 23:50 OmniSciTypes.h
-rw-r--r-- 1 mapd mapd 134456 Apr 16 23:51 RuntimeFunctions.bc
-rw-r--r-- 1 mapd mapd 1941 Apr 16 23:50 serialized_result_set.thrift
I guess those files are used to generate the shaders needed from the database at runtime the first time you run queries where the GPU is required, but I can wrong.
Anyway, to be able to help you, you would share some data with us.
- version of the omnisci database (looks you are using
- the method you used to install (tarball apt/rpm or compiling by yourself)
- the OS you are using (ubuntu, centos)
- the detailed contents of the QueryEngine directory
- the precise circumstances you are getting the error (e.g., after I installed the database, I loaded some data and tried out a group by query, and I got the error immediately or after some seconds )
Maybe with this data, we will able to reproduce the error and give you a quick solution.
I almost reproduced your error in 2 ways renaming the cuda_mapd_rt.a file into QueryEngine directory, but I am not able to run any query in GPU mode, and the message is slightly different, because is missing the rollback part
Exception: OmniSci GPU runtime library not found at /opt/mapd/omnisci-ee-5.2.0-20200416-4cc64c2b32-Linux-x86_64-render/QueryEngine/cuda_mapd_rt.a