Missing tables of clickhouse after migrating from community edition

[Diorges Rocha]

Hello, I got this error in grafana:

error querying the database: code: 60, message: Table fastnetmon.asn_metrics_ipv4 does not exist

[Pavel Odintsov]

Hello!

Can you check that ASN reports are enabled in configuration: https://fastnetmon.com/fastnetmon-asn-peering-reports/

On Tue, 5 Mar 2024 at 20:33, Diorges Rocha <dio...@gis.net.br> wrote:

Hello, I got this error in grafana:

error querying the database: code: 60, message: Table fastnetmon.asn_metrics_ipv4 does not exist

--
Follow us on social media: Twitter: https://twitter.com/fastnetmon | Facebook: https://www.facebook.com/fastnetmon/ | LinkedIn: https://www.linkedin.com/company/fastnetmon/
---
You received this message because you are subscribed to the Google Groups "FastNetMon user group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to fastnetmon+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/fastnetmon/bd80c7c2-8c72-4a5d-8ccf-9a8385e8ad84n%40googlegroups.com.

--

Sincerely yours, Pavel Odintsov

[Diorges Rocha]

Thank you, this solved this issue, but now I have another problem...

I added a new m2 nvme as storage and change the paths for influxdb/clickhouse...

And now I have this problem:

``` code: 481, message: File path /var/lib/clickhouse/user_files/asn_descriptions.tsv is not inside /mnt/fastnetmon/db/clickhouse/user_files/: while executing 'FUNCTION dictGetOrDefault('fastnetmon.asn_information' :: 3, 'asn_name' :: 4, asn_number :: 0, 'Unknown' :: 5) -> dictGetOrDefault('fastnetmon.asn_information', 'asn_name', asn_number, 'Unknown') String : 2': Could not process SQL results```

[Diorges Rocha]

I copied the file to the new storage, but same error:

fastnetmon:/home/diorges# ls -lhsa /mnt/fastnetmon/db/clickhouse/user_files/
total 3.4M
4.0K drwxr-x---  2 clickhouse clickhouse 4.0K Mar  5 17:23 .
4.0K drwx------ 16 clickhouse clickhouse 4.0K Jan 29 10:13 ..
3.4M -rw-r--r--  1 clickhouse clickhouse 3.4M Mar  5 17:23 asn_descriptions.tsv

[Pavel Odintsov]

Hello!

You need to re-create / edit dictionary configuration manually if you use another non standard path.

By default we create it this way:

CREATE DICTIONARY IF NOT EXISTS fastnetmon.asn_information
        (
        `asn`      UInt64 INJECTIVE,
        `asn_name` String,
        `country`  String
        )
        PRIMARY KEY asn
        SOURCE(FILE(PATH '/var/lib/clickhouse/user_files/asn_descriptions.tsv' FORMAT 'TabSeparated'))
        LIFETIME(MIN 0 MAX 300)
        LAYOUT(HASHED())

You will need to remove old dictionary and create new one with new path.

To view this discussion on the web visit https://groups.google.com/d/msgid/fastnetmon/d38e2999-8a10-422c-a205-d35977f7d9e1n%40googlegroups.com.

--

___________

Kind regards,

Pavel Odintsov

CTO, FastNetMon LTD

fastnetmon.com

[Diorges Rocha]

Hello!

Thank you, worked like a charm.