Benoit Tigeot benoittgt

When we raise a ActiveRecord::PreparedStatementCacheExpired we don't know which query raise the exception. It can be tricky to find it when you don't have database logs. I would like to add a message to ActiveRecord::PreparedStatementCacheExpired with the STATEMENT.

In Postgresql:

DROP TABLE IF EXISTS abc CASCADE; 
DEALLOCATE FOO;
CREATE TABLE abc(i INT);
PREPARE FOO AS SELECT * FROM abc;
ALTER TABLE abc ADD COLUMN u INT;

	def self.checkout_max_connections(role:)
	threads = []
	before = nil
	after = nil
	pool_size = nil
	base_connection_class.connected_to(role: role) do
	before = connection_pool.stat
	pool_size = connection_pool.size
	end
	pool_size.times do

	DROP TABLE IF EXISTS events;
	CREATE table events (
	id serial PRIMARY KEY,
	project_id BIGINT NOT NULL,
	kind TEXT NOT NULL,
	emitted_at TIMESTAMP NOT NULL,
	created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
	);

	# frozen_string_literal: true

	require "bundler/inline"
	require "json"

	gemfile(true) do
	source "https://rubygems.org"

	git_source(:github) { \|repo\| "https://github.com/#{repo}.git" }

	function! IAmAPutsEmojiDebugger()
	ruby <<EOS
	separator = rand(0x1F601..0x1F64F).chr('UTF-8')

	VIM::command("normal! oputs '#{separator}' * (`tput cols`.to_i / 2)")

	VIM::command('normal! oputs "#{__FILE__}:#{__LINE__}"')

	VIM::command("normal! oputs '#{separator}' * (`tput cols`.to_i / 2)")
	EOS

	--- Setup
	CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

	DROP TABLE IF EXISTS planner_checksums CASCADE;
	CREATE TABLE IF NOT EXISTS planner_checksums (
	identifiers_checksum uuid,
	attributes_checksum uuid,
	version INT
	);
	CREATE INDEX planner_checksums_idx ON planner_checksums(identifiers_checksum);

	puts Process.pid
	_, w = IO.pipe
	(0..).each do \|n\|
	$stderr.puts "About to write 1KB of data into the pipe, written so far #{n * 1024}"
	sleep 0.1
	p w.write(Random.new.bytes(1024))
	end

	# lsof -n -P -r1 -c ruby \| grep -e 'PIP' -e '===' -e 'COMMAND'

	# start FactoryBot id sequence at a different number. Naive approach.
	# other idea https://github.com/thoughtbot/factory_bot/issues/350#issuecomment-14475441

	FactoryBot.define do
	factory :app do
	sequence(:id) { \|n\| 1.to_s.ljust(self.instance.class.name.size, "0").to_i + n }
	end
	end