moofkit

class ApplicationRecord < ActiveRecord::Base
  self.abstract_class = true  

  class << self
    # Start a new transaction with a statement timeout.
    # The timeout is reset after the block is executed. Works even with pg_bouncer in transaction mode
    # This is useful for queries that are expected to be slower than the default timeout
    # timeout - the timeout in seconds
    # Usage:
    # with_statement_timeout(10) do

moofkit

#!/usr/bin/env ruby
# frozen_string_literal: true

files = Dir.glob("app/jobs/**/*.rb")

puts "Found #{files.count} files"
files.each do |file|
  content = File.read(file).split("\n")
  content.each_with_index do |line, index|
    if match = line.match(/Worker/)

moofkit

$find . -depth -name "*old.txt" -exec sh -c 'f="{}"; mv -- "$f" "${f%old.txt}new.csv"' \;

moofkit

#!/usr/bin/env ruby
# frozen_string_literal: true

# https://juanitofatas.com/series/sidekiq/rename
files = Dir.glob("app/workers/**/*.rb")

puts "Found #{files.count} files"
files.each do |file|
  content = File.read(file)
  if match = content.match(/class (\S+)Worker/)

moofkit

use std::sync::{Arc, Mutex};
use std::thread;
use std::time::Duration;

fn main() {
    let counter = Arc::new(Mutex::new(0));
    let counter2 = Arc::new(Mutex::new(0));
    let mut handles = vec![];

    for _ in 0..10 {

moofkit

en:
  dry_validation:
    errors:
      rules:
        data:
          attributes:
            phone_number:
              invalid_format: 'is of invalid format'

moofkit

start:
	rackup config.ru -p 9292

test:
	time curl 'http://localhost:9292/exception'

moofkit

After a bit of digging, I believe the issue was that the 9.6 install setup a cluster for the new instance which was interrupting the pg_upgrade. I ended up getting it working by dropping the new cluster and upgrading the 9.3 cluster using pg_upgradecluster from the following gist: https://gist.github.com/delameko/bd3aa2a54a15c50c723f0eef8f583a44

Install packages

sudo apt-get install postgresql-9.6 postgresql-server-dev-9.6 postgresql-contrib-9.6 -y

List clusters. Should show existing (9.3) and newly installed (9.6)

pg_lsclusters

moofkit

CREATE VIEW lock_monitor AS
 SELECT COALESCE(((blockingl.relation)::regclass)::text, blockingl.locktype) AS locked_item,
    (now() - blockeda.query_start) AS waiting_duration,
    blockeda.pid AS blocked_pid,
    blockeda.query AS blocked_query,
    blockedl.mode AS blocked_mode,
    blockinga.pid AS blocking_pid,
    blockinga.query AS blocking_query,
    blockingl.mode AS blocking_mode
   FROM (((pg_locks blockedl

moofkit

module ApplicationType
  extend ActiveSupport::Concern

  module ClassMethods
    def model_name
      superclass.model_name
    end

    def name
      superclass.name