Known errors and fixes

MiningCore logs show this warning or error:

---

"[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",

---