OmniSci server issue


#1

Hi!

We recently setup a table for a prototype that has ~1.5Bil records. Strangely afterwards there were performance issues and it crashed. When we startup here is the error that pops-up.

Backend HTTP: localhost:9090
Frontend Web: localhost:9092
Calcite TCP: localhost:9093

  • sleeping for 5s while server starts
    Thrift: Wed Jan 2 16:12:35 2019 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Wed Jan 2 16:12:35 2019 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Wed Jan 2 16:12:35 2019 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    Thrift: Wed Jan 2 16:12:35 2019 TSocket::open() connect() <Host: localhost Port: 9093>Connection refused
    F0102 16:13:47.628609 29531 File.cpp:89] Error trying to open file ‘data/mapd_data/table_1_35//epoch’, the errno is 13

I do not have a /data/mapd_data folder at all the config file points to the right data dir.

Any thoughts on how troubleshoot this one ?

_Ben


#2

Hi @benjose,

You can safely ignore the Thrift warning messages, but you are getting a permission problem on the database’s files; in fact, the errno 13 means permission denied.

I suggest checking if the user you are using to start the mapd_server is the owner of database files because the software needs the read and write permission on them to work correctly.

So if you are using the user mapd to start the server an ls -la of the $MAPD_STORAGE/data/mapd_data/table_1_35//epoch should return an output like this

-rw-r--r-- 1 mapd mapd 4 jan 2 07:30 /opt/mapd_storage/data/mapd_data/table_1_325/epoch

Do you have started the server before with a different user or you moved all the database files on a different filesystem with the root user?


#3

It was a perm issue. Once the service was started using mapd UID, things were normal.

_Ben