database error: ERROR: new data for materialized view

[dincho]

Note: for support questions, please use the forum. This repository's issues are reserved for feature requests and bug reports.

• I'm submitting a ...

  • [x] bug report
  • [ ] feature request
  • [ ] support request => Please do not submit support request here, see note at the top of this template.

• Do you want to request a feature or report a bug?

• What is the current behavior?

• If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem

• What is the expected behavior?

• What is the motivation / use case for changing the behavior?

• Please tell us about your environment:

  • Node Version: v0.0.0
  • Protocol Version: 1
  • Sophia Compiler version: v0.0.0
  • Rust version: v0.00

• Other information (e.g. detailed explanation, stacktraces, related issues, suggestions how to fix, links for us to have context, eg. forum, telegram, etc)

2020-03-13T11:38:42.031521973+01:00 ERROR aeternal - Error refreshing name view: MiddlewareError { details: "database error: ERROR: new data for materialized view \"name_auction_entries\" contains duplicate rows without any null columns\nstack backtrace:\n   0: aeternal::middleware_result::MiddlewareError::new\n             at src/middleware_result.rs:14\n   1: <aeternal::middleware_result::MiddlewareError as core::convert::From<postgres_shared::error::Error>>::from\n             at src/middleware_result.rs:55\n   2: aeternal::refresh_materialized_views::_refresh\n             at src/main.rs:168\n   3: aeternal::refresh_materialized_views::{{closure}}\n             at src/main.rs:172\n   4: std::sys_common::backtrace::__rust_begin_short_backtrace\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/sys_common/backtrace.rs:136\n   5: __rust_maybe_catch_panic\n             at src/libpanic_unwind/lib.rs:81\n   6: std::panicking::try\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panicking.rs:267\n      std::panic::catch_unwind\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panic.rs:395\n      std::thread::Builder::spawn_unchecked::{{closure}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/thread/mod.rs:468\n      core::ops::function::FnOnce::call_once{{vtable.shim}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libcore/ops/function.rs:232\n   7: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n   8: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n      std::sys_common::thread::start_thread\n             at src/libstd/sys_common/thread.rs:13\n      std::sys::unix::thread::Thread::new::thread_start\n             at src/libstd/sys/unix/thread.rs:79\n   9: start_thread\n  10: __clone\n" }
2020-03-13T11:39:13.425887658+01:00 ERROR aeternal - Error refreshing name view: MiddlewareError { details: "database error: ERROR: new data for materialized view \"name_auction_entries\" contains duplicate rows without any null columns\nstack backtrace:\n   0: aeternal::middleware_result::MiddlewareError::new\n             at src/middleware_result.rs:14\n   1: <aeternal::middleware_result::MiddlewareError as core::convert::From<postgres_shared::error::Error>>::from\n             at src/middleware_result.rs:55\n   2: aeternal::refresh_materialized_views::_refresh\n             at src/main.rs:168\n   3: aeternal::refresh_materialized_views::{{closure}}\n             at src/main.rs:172\n   4: std::sys_common::backtrace::__rust_begin_short_backtrace\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/sys_common/backtrace.rs:136\n   5: __rust_maybe_catch_panic\n             at src/libpanic_unwind/lib.rs:81\n   6: std::panicking::try\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panicking.rs:267\n      std::panic::catch_unwind\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panic.rs:395\n      std::thread::Builder::spawn_unchecked::{{closure}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/thread/mod.rs:468\n      core::ops::function::FnOnce::call_once{{vtable.shim}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libcore/ops/function.rs:232\n   7: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n   8: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n      std::sys_common::thread::start_thread\n             at src/libstd/sys_common/thread.rs:13\n      std::sys::unix::thread::Thread::new::thread_start\n             at src/libstd/sys/unix/thread.rs:79\n   9: start_thread\n  10: __clone\n" }
2020-03-13T11:39:45.747006199+01:00 ERROR aeternal - Error refreshing name view: MiddlewareError { details: "database error: ERROR: new data for materialized view \"name_auction_entries\" contains duplicate rows without any null columns\nstack backtrace:\n   0: aeternal::middleware_result::MiddlewareError::new\n             at src/middleware_result.rs:14\n   1: <aeternal::middleware_result::MiddlewareError as core::convert::From<postgres_shared::error::Error>>::from\n             at src/middleware_result.rs:55\n   2: aeternal::refresh_materialized_views::_refresh\n             at src/main.rs:168\n   3: aeternal::refresh_materialized_views::{{closure}}\n             at src/main.rs:172\n   4: std::sys_common::backtrace::__rust_begin_short_backtrace\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/sys_common/backtrace.rs:136\n   5: __rust_maybe_catch_panic\n             at src/libpanic_unwind/lib.rs:81\n   6: std::panicking::try\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panicking.rs:267\n      std::panic::catch_unwind\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/panic.rs:395\n      std::thread::Builder::spawn_unchecked::{{closure}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libstd/thread/mod.rs:468\n      core::ops::function::FnOnce::call_once{{vtable.shim}}\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/libcore/ops/function.rs:232\n   7: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n   8: <alloc::boxed::Box<F> as core::ops::function::FnOnce<A>>::call_once\n             at /rustc/e87a205c2e117d9fb57f6cdeac0a7f6e95c88316/src/liballoc/boxed.rs:969\n      std::sys_common::thread::start_thread\n             at src/libstd/sys_common/thread.rs:13\n      std::sys::unix::thread::Thread::new::thread_start\n             at src/libstd/sys/unix/thread.rs:79\n   9: start_thread\n  10: __clone\n" }