We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I'm adding a view with a custom output function. If I replace the function, I'll start getting an error
cache lookup failed for function <NUMBER> And things will go down hill from there
cache lookup failed for function <NUMBER>
postgres | 2019-05-20 21:33:03.342 UTC [204] ERROR: cache lookup failed for function 21177 postgres | 2019-05-20 21:33:03.342 UTC [204] STATEMENT: engagement_stat_transforms postgres | 2019-05-20 21:33:33.620 UTC [1] LOG: received smart shutdown request postgres | 2019-05-20 21:33:33.671 UTC [164] LOG: terminating TimescaleDB background worker launcher due to administrator command postgres | 2019-05-20 21:33:33.671 UTC [162] LOG: pg_cron scheduler shutting down postgres | 2019-05-20 21:33:33.671 UTC [166] LOG: terminating TimescaleDB job scheduler due to administrator command postgres | 2019-05-20 21:33:33.671 UTC [164] FATAL: terminating connection due to administrator command postgres | 2019-05-20 21:33:33.671 UTC [166] FATAL: terminating connection due to administrator command postgres | 2019-05-20 21:33:33.671 UTC [185] LOG: pipelinedb process "reaper4 [help]" was killed postgres | Segmentation fault (PID 201) postgres | PostgreSQL version: 10.5 (Debian 10.5-2.pgdg90+1) postgres | PipelineDB version: 1.0.0 at revision b0569eda8ac0120b27075c8e3c367478361efdce postgres | query: (null) postgres | backtrace: postgres | /usr/lib/postgresql/10/lib/pipelinedb.so( postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | 2019-05-20 21:33:33.672 UTC [189] LOG: pipelinedb process "reaper0 [help]" was killed postgres | postgres: bgworker: worker2 [help] (PopActiveSnapshot+0x10)[0x55eeda6263f0] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(UnsetEStateSnapshot+0x11)[0x7ff4c9589471] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(+0x52e63)[0x7ff4c9587e63] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(ContinuousQueryWorkerMain+0xd7)[0x7ff4c9588027] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(cont_bgworker_main+0x220)[0x7ff4c95bf730] postgres | postgres: bgworker: worker2 [help] (StartBackgroundWorker+0x2cc)[0x55eeda45c0bc] postgres | postgres: bgworker: worker2 [help] (+0x30be15)[0x55eeda468e15] postgres | postgres: bgworker: worker2 [help] (+0x30c9b5)[0x55eeda4699b5] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(sigprocmask+0x10)[0x7ff4cf5e42e0] postgres | postgres: bgworker: worker2 [help] (+0x30c9a2)[0x55eeda4699a2] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(sigprocmask+0x10)[0x7ff4cf5e42e0] postgres | postgres: bgworker: worker2 [help] (+0x30c9a2)[0x55eeda4699a2] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | Segmentation fault (PID 208) postgres | PostgreSQL version: 10.5 (Debian 10.5-2.pgdg90+1) postgres | PipelineDB version: 1.0.0 at revision b0569eda8ac0120b27075c8e3c367478361efdce postgres | query: (null) postgres | backtrace: postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(debug_segfault+0x33)[0x7ff4c95bea53] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | 2019-05-20 21:33:33.676 UTC [192] LOG: pipelinedb process "combiner3 [help]" was killed postgres | 2019-05-20 21:33:33.676 UTC [194] LOG: pipelinedb process "combiner1 [help]" was killed postgres | 2019-05-20 21:33:33.676 UTC [195] LOG: pipelinedb process "combiner0 [help]" was killed postgres | postgres: bgworker: worker0 [help] (PopActiveSnapshot+0x10)[0x55eeda6263f0] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(UnsetEStateSnapshot+0x11)[0x7ff4c9589471] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(+0x52e63)[0x7ff4c9587e63] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(ContinuousQueryWorkerMain+0xd7)[0x7ff4c9588027] postgres | /usr/lib/postgresql/10/lib/pipelinedb.so(cont_bgworker_main+0x220)[0x7ff4c95bf730] postgres | postgres: bgworker: worker0 [help] (StartBackgroundWorker+0x2cc)[0x55eeda45c0bc] postgres | 2019-05-20 21:33:33.676 UTC [187] LOG: pipelinedb process "reaper2 [help]" was killed postgres | postgres: bgworker: worker0 [help] (+0x30be15)[0x55eeda468e15] postgres | ____ _ ___ ____ ____ postgres | / __ \(_)___ ___ / (_)___ ___ / __ \/ __ ) postgres | / /_/ / / __ \/ _ \/ / / __ \/ _ \/ / / / __ | postgres | / ____/ / /_/ / __/ / / / / / __/ /_/ / /_/ / postgres | /_/ /_/ .___/\___/_/_/_/ /_/\___/_____/_____/ postgres | /_/ postgres | ____ _ ___ ____ ____ postgres | / __ \(_)___ ___ / (_)___ ___ / __ \/ __ ) postgres | / /_/ / / __ \/ _ \/ / / __ \/ _ \/ / / / __ | postgres | / ____/ / /_/ / __/ / / / / / __/ /_/ / /_/ / postgres | /_/ /_/ .___/\___/_/_/_/ /_/\___/_____/_____/ postgres | /_/ postgres | 2019-05-20 21:33:33.676 UTC [190] LOG: pipelinedb process "queue1 [help]" was killed postgres | 2019-05-20 21:33:33.676 UTC [191] LOG: pipelinedb process "queue0 [help]" was killed postgres | postgres: bgworker: worker0 [help] (+0x30c9b5)[0x55eeda4699b5] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(sigprocmask+0x10)[0x7ff4cf5e42e0] postgres | postgres: bgworker: worker0 [help] (+0x30c9a2)[0x55eeda4699a2] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(sigprocmask+0x10)[0x7ff4cf5e42e0] postgres | postgres: bgworker: worker0 [help] (+0x30c9a2)[0x55eeda4699a2] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(sigprocmask+0x10)[0x7ff4cf5e42e0] postgres | postgres: bgworker: worker0 [help] (+0x30c418)[0x55eeda469418] postgres | /lib/x86_64-linux-gnu/libpthread.so.0(+0x110e0)[0x7ff4d19fd0e0] postgres | /lib/x86_64-linux-gnu/libc.so.6(__select+0x13)[0x7ff4cf6925e3] postgres | postgres: bgworker: worker0 [help] (+0xb31c2)[0x55eeda2101c2] postgres | 2019-05-20 21:33:33.677 UTC [1] LOG: worker process: TimescaleDB Background Worker Launcher (PID 164) exited with exit code 1 postgres | 2019-05-20 21:33:33.677 UTC [1] LOG: worker process: logical replication launcher (PID 165) exited with exit code 1 postgres | postgres: bgworker: worker0 [help] (PostmasterMain+0xfe8)[0x55eeda46ad08] postgres | 2019-05-20 21:33:33.677 UTC [1] LOG: worker process: TimescaleDB Background Worker Scheduler (PID 166) exited with exit code 1 postgres | postgres: bgworker: worker0 [help] (main+0x854)[0x55eeda2121c4] postgres | 2019-05-20 21:33:33.677 UTC [1] LOG: worker process: combiner1 [help] (PID 194) exited with exit code 1 postgres | 2019-05-20 21:33:33.677 UTC [193] LOG: pipelinedb process "combiner2 [help]" was killed postgres | /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf1)[0x7ff4cf5d12e1] postgres | 2019-05-20 21:33:33.677 UTC [1] LOG: worker process: combiner0 [help] (PID 195) exited with exit code 1 postgres | 2019-05-20 21:33:33.677 UTC [184] LOG: pipelinedb process "reaper5 [help]" was killed postgres | postgres: bgworker: worker0 [help] (_start+0x2a)[0x55eeda21227a] postgres | 2019-05-20 21:33:33.677 UTC [198] LOG: pipelinedb process "worker3 [help]" was killed postgres | Segmentation fault (PID 204)
The only way to fix this seems to be restarting postgres.
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I'm adding a view with a custom output function. If I replace the function, I'll start getting an error
cache lookup failed for function <NUMBER>
And things will go down hill from thereThe only way to fix this seems to be restarting postgres.
The text was updated successfully, but these errors were encountered: