Barrett Griffith forgotpw1

## gist:67398debfa82bb0f820c

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                forgotpw1
                / gist:67398debfa82bb0f820c
            
            
              Last active
              August 29, 2015 14:18
            
              
                Causes for hanging database transactions - Durascope
              
          
    Any situation which causes a Context object to go out of scope (which can happen if additional context objects are created in the course of the processing) can leave a hanging transaction.

  
## gist:9d6f0609f3cc44788d3e
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'DB'
  AND pid <> pg_backend_pid()
  AND state = 'idle in transaction (aborted)'
  AND state_change < current_timestamp - INTERVAL '5' MINUTE

## gist:593f9b3cb5b9752b1dc1
(sudo -u postgres pg_ctl stop -D /usr/local/pgsql/data -m i -t 5 || true) && sudo stop postgresql

# start again with

sudo start postgresql

## gist:2a55be5678a27001dac9
For your reference, you can use the following test credit card numbers when testing your connection. The expiration date must be set to the present date or later:
- American Express Test Card: 370000000000002
- Discover Test Card: 6011000000000012
- Visa Test Card: 4007000000027
- Second Visa Test Card: 4012888818888
- MasterCard: 5555555555554444
- JCB: 3088000000000017
- Diners Club/ Carte Blanche: 38000000000006

## gist:7439518
data:text/html, <html contenteditable>

## gist:3103083
git shortlog -s -n
	SELECT pg_terminate_backend(pid)
	FROM pg_stat_activity
	WHERE datname = 'DB'
	AND pid <> pg_backend_pid()
	AND state = 'idle in transaction (aborted)'
	AND state_change < current_timestamp - INTERVAL '5' MINUTE
	(sudo -u postgres pg_ctl stop -D /usr/local/pgsql/data -m i -t 5 \|\| true) && sudo stop postgresql

	# start again with

	sudo start postgresql
	For your reference, you can use the following test credit card numbers when testing your connection. The expiration date must be set to the present date or later:
	- American Express Test Card: 370000000000002
	- Discover Test Card: 6011000000000012
	- Visa Test Card: 4007000000027
	- Second Visa Test Card: 4012888818888
	- MasterCard: 5555555555554444
	- JCB: 3088000000000017
	- Diners Club/ Carte Blanche: 38000000000006