Error 500 after running fine for 1-2 hours

[zwogorg]

Hi,

I've setup a self hosted Plausible instance on a vps running Ubuntu 20.04.
I use the official docker images and followed the provided instructions with using nginx as a reverse proxy.

Everything works so far, I can login and visits to my website are tracked. But after a while (about 1-2 hours) I can't login anymore.
Instead I get a server error 500:

500
Oops! Looks like we're having server issues

And visits to my website are not tracked anymore.

I think the problem is that the events db crashes with a segfault:

plausible_events_db_1 | 2021.07.09 12:00:45.756100 [ 107 ] {} BaseDaemon: ########################################
plausible_events_db_1 | 2021.07.09 12:00:45.756277 [ 107 ] {} BaseDaemon: (version 21.3.2.5 (official build), build id: 179BDBBF228667883DFCD900B8CD498272FC044F) (from thread 99) (query_id: de4ce91d-74a1-4c8f-a179-2d675c16c339) Received signal Segmentation fault (11)
plausible_events_db_1 | 2021.07.09 12:00:45.756352 [ 107 ] {} BaseDaemon: Address: NULL pointer. Access: read. Unknown si_code.
plausible_events_db_1 | 2021.07.09 12:00:45.756379 [ 107 ] {} BaseDaemon: Stack trace: 0xfb161b2 0xef92b67 0xf12d3a2 0xf130a78 0xf84675a 0xf84a8ee 0xf8d35ff 0x11f7ccbf 0x11f7e6d1 0x120b4df9 0x120b0c5a 0x7f13eea8e609 0x7f13ee9b5293
plausible_events_db_1 | 2021.07.09 12:00:45.759780 [ 107 ] {} BaseDaemon: 1. DB::QueryPlan::buildQueryPipeline(DB::QueryPlanOptimizationSettings const&) @ 0xfb161b2 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.759856 [ 107 ] {} BaseDaemon: 2. DB::InterpreterSelectWithUnionQuery::execute() @ 0xef92b67 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.759878 [ 107 ] {} BaseDaemon: 3. ? @ 0xf12d3a2 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.759916 [ 107 ] {} BaseDaemon: 4. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&, std::__1::basic_string<char, std::__1::char_traits, std::__1::allocator > const&)>) @ 0xf130a78 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.759967 [ 107 ] {} BaseDaemon: 5. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optionalDB::CurrentThread::QueryScope&) @ 0xf84675a in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.759990 [ 107 ] {} BaseDaemon: 6. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0xf84a8ee in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760023 [ 107 ] {} BaseDaemon: 7. DB::HTTPServerConnection::run() @ 0xf8d35ff in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760051 [ 107 ] {} BaseDaemon: 8. Poco::Net::TCPServerConnection::start() @ 0x11f7ccbf in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760082 [ 107 ] {} BaseDaemon: 9. Poco::Net::TCPServerDispatcher::run() @ 0x11f7e6d1 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760114 [ 107 ] {} BaseDaemon: 10. Poco::PooledThread::run() @ 0x120b4df9 in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760135 [ 107 ] {} BaseDaemon: 11. Poco::ThreadImpl::runnableEntry(void*) @ 0x120b0c5a in /usr/bin/clickhouse
plausible_events_db_1 | 2021.07.09 12:00:45.760163 [ 107 ] {} BaseDaemon: 12. start_thread @ 0x9609 in /usr/lib/x86_64-linux-gnu/libpthread-2.31.so
plausible_events_db_1 | 2021.07.09 12:00:45.760189 [ 107 ] {} BaseDaemon: 13. clone @ 0x122293 in /usr/lib/x86_64-linux-gnu/libc-2.31.so
plausible_events_db_1 | 2021.07.09 12:00:45.951100 [ 107 ] {} BaseDaemon: Checksum of the binary: 6A8A5851E18458237528EFE3B3339F9D, integrity check passed.

I'm not really familiar with using docker, here is the output from when I run docker-compose up without detaching: plausible.log

Let me know if you need anything else

Greetings
zwog