Error Handling
Learn more about the common errors and how to resolve them.
Below is the list of the common errors and its resolutions you might encounter while connecting or running the Oxla server.
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
β Follow these steps:
- Change the directory where you store the docker-compose configuration file by executing this command:
cd your_folder_name
- Open the docker-compose configuration file by executing this command:
vim your_file_name.yml
- Remove
local_csvs:/local_csvs
in your docker compose file.
Too many open files
π§ If you encounter an error as follows when deploying Oxla servers
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
β Follow these steps:
- Change the directory where you store the docker compose configuration file by executing this command:
cd your_folder_name
- Open the docker compose configuration file by executing this command:
vim your_file_name.yml
- Ensure that your docker compose file has the correct limit as follows:
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
β Follow these steps:
For windows:
- Open the PostgreSQL folder > **scripts **folder and open the command prompt on your computer:
(c) Microsoft Corporation. All rights reserved.
C:\Program Files\PostgreSQL\14\scripts>
- 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"
- 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
β Follow these steps:
- Run the following command:
SET PGCLIENTENCODING=UTF8
- Then, activate the code page with the command below:
chcp 65001Command
You will get the following output:
Active code page: 65001
- 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: