On Wed, Aug 29, 2018 at 5:48 PM Sand Stone <sand.m.st...@gmail.com> wrote: > I attached a query (and its query plan) that caused the crash: "dsa_allocate > could not find 13 free pages" on one of the worker nodes. I anonymised the > query text a bit. Interestingly, this time only one (same one) of the nodes > is crashing. Since this is a production environment, I cannot get the stack > trace. Once turned off parallel execution for this node. The whole query > finished just fine. So the parallel query plan is from one of the nodes not > crashed, hopefully the same plan would have been executed on the crashed > node. In theory, every worker node has the same bits, and very similar data.
I wonder if this was a different symptom of the problem fixed here: https://www.postgresql.org/message-id/flat/194c0706-c65b-7d81-ab32-2c248c3e2344%402ndquadrant.com Can you still reproduce it on current master, REL_11_STABLE or REL_10_STABLE? -- Thomas Munro http://www.enterprisedb.com
