​
Overview

Learn more about the common errors and how to resolve them. Below you can find a list of the common errors you may encounter while connecting or running the Oxla server and their resolutions.

​
Undefined Volume and Invalid Compose Project

If you encounter an error like this:

service "oxla_node" refers to undefined volume local_csvs: invalid compose project

Please follow these steps:

  1. Change the directory where you store the docker-compose configuration file by executing this command
cd your_folder_name
  1. Open the docker-compose configuration file
vim your_file_name.yml
  1. Remove local_csvs:/local_csvsin your docker compose file

​
Too Many Open Files

If you encounter an error as follows when deploying Oxla server:

Jan 24 13:58:26 server[XXXXXX]: 2023-01-24 13:58:26.301 ERROR [229223] [network::StateHandlerManager>::start@241] could not accept incoming connection because:
Jan 24 13:58:26 server[XXXXXX]: --------------------------------------------------------------------------------
Jan 24 13:58:26 server[XXXXXX]: Too many open files

Please follow these steps:

  1. Change the directory where you store the docker compose configuration file by executing this command
cd your_folder_name
  1. Open the docker compose configuration file
vim your_file_name.yml
  1. Ensure that your docker compose file has the correct limit set
ulimits:
      nofile:
        soft: 40000
        hard: 40000

​
Command Not Recognized - psql

If you encounter an error like this:

'psql' is not recognized as an internal or external command, operable program, or batch file

Please follow these steps:

For Windows

  1. Open the PostgreSQL folder > scripts and then open the command prompt on your computer:

(c) Microsoft Corporation. All rights reserved.

C:\Program Files\PostgreSQL\14\scripts>
  1. Run the following command: cd "C:\Program Files\PostgreSQL\14\bin"
(c) Microsoft Corporation. All rights reserved.

C:\Program Files\PostgreSQL\14\scripts> cd "C:\Program Files\PostgreSQL\14\bin"
  1. Last but not least, execute the following command to run the Oxla server: psql -h 44.210.23.203“
(c) Microsoft Corporation. All rights reserved. 

C:\Program Files\PostgreSQL\14\scripts> cd "C:\Program Files\PostgreSQL\14\bin" 

C:\Program Files\PostgreSQL\14\bin> psql.exe -h 44.210.23.203

​
Encoding Is Not Supported

If you encounter an error like this:

Psql: error: connection to server at "44.210.23.203", port 5432 failed: FATAL: WIN1252 encoding is not supported

Please follow these steps:

  1. Run the following command:
SET PGCLIENTENCODING=UTF8
  1. Then, activate the code page with the command below:
chcp 65001Command

You will get the following output:

Active code page: 65001
  1. Execute the following command to run the Oxla server: psql -h 44.210.23.203
C:\Program Files\PostgreSQL\14\bin>SET PGCLIENTENCODING=UTF8

C:\Program Files\PostgreSQL\14\bin>chcp 65001
Active code page: 65001

C:\Program Files\PostgreSQL\14\bin>psql.exe -h 44.210.23.203

​
Missing Argument

If you encounter an error like this:

Psql: warning: extra command-line argument "44.210.23.203" ignored

Re-check the command. Keep an eye on each component, even the symbols and uppercase/lowercase words.

​
Command Not Found - psql

If you encounter an error like this:

Psql.exe: command not found

Download and install PostgreSQL on your computer:

  • For Windows, download PostgreSQL from here.
  • For Linux, install PostgreSQL by following the steps here.
  • For Mac, install PostgreSQL through terminal using brew: mac$ brew install postgresql.