bug visited

[SiNaPsEr0x]

bug on view

but if recap to 1 years not problem...
the log of postgresql is:

2021-05-24 22:26:16.321 UTC [49] ERROR: could not load library "/usr/lib/postgresql/13/lib/llvmjit.so": libLLVM-7.so.1: ELF load command alignment not page-aligned
2021-05-24 22:26:16.321 UTC [49] STATEMENT: SELECT
to_timestamp(floor((extract('epoch' FROM date) / 60)) * 60) AT TIME ZONE 'UTC' AS time,
avg(latitude) AS lat,
avg(longitude) AS lng
FROM
positions
WHERE
car_id = '1' AND
date BETWEEN '2020-05-24T22:26:17.426Z' AND '2021-05-24T22:26:17.426Z'
GROUP BY
1
ORDER BY
1 ASC

Environment

• TeslaMate version: 1.22
• Type of installation: Docker
• OS TeslaMate is installed on: qnap
• User OS & Browser: safari mac
• Others:

[DrMichael]

Looks like a problem with postgresql 13 in qnap docker. Did you try postgresql 12?

[SiNaPsEr0x]

I used version on docker official