Are you using JDBC or the PSQL interpreter? I had encountered something similar while using the PSQL interpreter and I had to restart Zeppelin.
My experience using PSQL (Postgresql, HAWK) was not as good as using spark/scala wrappers (JDBC data source) to connect via JDBC and then register temp tables. This approach allowed me to work with dynamic forms in a more meaningful way e.g. use SQL results to create a new drop down to drive the next page etc… > On Jan 5, 2017, at 12:57 PM, Benjamin Kim <bbuil...@gmail.com> wrote: > > We are getting “out of shared memory” errors when multiple users are running > SQL queries against our PostgreSQL DB either simultaneously or throughout the > day. When this happens, Zeppelin 0.6.0 becomes unresponsive for any more SQL > queries. It looks like this is being caused by too many locks being taken and > not released, transactions never closing, and/or connections never closing. > Has anyone encountered Zeppelin 0.6.0 such an issue as this? If so, is there > a solution for it? > > Thanks, > Ben
