saicitus

**Issue**:
1) Start a long running query say ~5 minutes. Ex:
SELECT count(*) from github_events g1,github_events g2 WHERE g1.repo_id=g2.repo_id;
2) Terminate a worker whilst the query is running.
3) Now the system hangs indefinitely.

**Reasoning**
I think what's happening is that removing the network interface doesn't kill the connection. As a result, the coordinator node waits for a response from the worker node, which never comes.

Citus uses PostgreSQL's client connection library (libpq) to communicate between machines; and Postgres uses system defaults to timeout in this scenario. On Linux, I think the default TCP keepalive time (tcp_keepalive_time) is set to 7200 seconds.

AtulKsol

psql: FATAL: Peer authentication failed for user “postgres” (or any user)

The connection failed because by default psql connects over UNIX sockets using peer authentication, that requires the current UNIX user to have the same user name as psql. So you will have to create the UNIX user postgres and then login as postgres or use sudo -u postgres psql database-name for accessing the database (and psql should not ask for a password).

If you cannot or do not want to create the UNIX user, like if you just want to connect to your database for ad hoc queries, forcing a socket connection using psql --host=localhost --dbname=database-name --username=postgres (as pointed out by @meyerson answer) will solve your immediate problem.

But if you intend to force password authentication over Unix sockets instead of the peer method, try changing the following pg_hba.conf* line:

from

zimuliu

module Concerns
  module NestedAttributesSync
    extend ActiveSupport::Concern

    included do
      class_attribute :nested_attributes_sync_options, instance_writer: false
      self.nested_attributes_sync_options = {}
    end

    class_methods do

briankung

First, add pry-rails to your Gemfile:
https://github.com/rweng/pry-rails

gem 'pry-rails', group: :development

Then you'll want to rebuild your Docker container to install the gems

mpneuried

# import config.
# You can change the default config with `make cnf="config_special.env" build`
cnf ?= config.env
include $(cnf)
export $(shell sed 's/=.*//' $(cnf))

# import deploy config
# You can change the default deploy config with `make cnf="deploy_special.env" release`
dpl ?= deploy.env
include $(dpl)

lopezjurip

www.mysite.com, mysite.com {
  proxy / webapp:3000 {
    proxy_header Host {host}
    proxy_header X-Real-IP {remote}
    proxy_header X-Forwarded-Proto {scheme}
  }
  gzip
  tls [email protected]
}

SamSaffron

require 'benchmark/ips'

LONG_STRING = "   this is a longer test
      this is a longer test
      this is a longer test
      this is a longer test
      this is a longer test"

class String
  def original_blank?

hadees

module ArelHelpers
  extend self

  def self.included(base)
    base.extend self
  end

  def asterisk(arel_table_or_model)
    arel_table, columns = case arel_table_or_model
                          when Arel::Table

denji

#!/usr/bin/env ruby
require 'resolv'
require 'set'
require 'thread'
require 'yaml'

KnownSelfDomains = [
  'groupon.com',
  'airbnb.com',
  'citi.com',

fredbenenson

layout	title	description	tags
default	SQL Style Guide	A guide to writing clean, clear, and consistent SQL.	data process

Purpose