Known errors and fixes - minernl/miningcore GitHub Wiki
"[ShareRecorder] Fallback due to Npgsql: PostgresExeception (23514: no partition of relation 'shares' found for row)"
Due to this, shares are not registered in the database and no payments can be done.
Solution: Some database configuration is not done or does not exest for this coin
- Advanced PostgreSQL Database setup
The following step needs to performed once for every new coin you add to your server or cluster.
Be sure to replace all occurences of pools_id
in the statement below with the id of your pool from your config.json
file:
sudo -u postgres -i
psql -d miningcore
CREATE TABLE shares_pools_id PARTITION OF shares FOR VALUES IN ('pools_id');
!!! Do this for every Coin you add to you server. If you have multiple server, add it on every server !!!
EXAMPLE:
lookup for the pools id in you config.json file. In this example pools id is VerusCoin
CREATE TABLE shares_VerusCoin PARTITION OF shares FOR VALUES IN ('VerusCoin');
config.json:
"pools": [
{
"id": "VerusCoin",
"enabled": true,
"coin": "VerusCoin",
"address": "RE9v8tCKiALVmkWbirTKc5cZpSJtuXswJ8",