1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
#!/usr/bin/python
#
# Copyright 2009 Canonical Ltd. This software is licensed under the
# GNU Affero General Public License version 3 (see the file LICENSE).
"""Kill transaction that have hung around for too long.
"""
__metaclass__ = type
__all__ = []
from optparse import OptionParser
import os
import psycopg2
import signal
import sys
import time
def main():
parser = OptionParser()
parser.add_option(
'-c', '--connection', type='string', dest='connect_string',
default='', help="Psycopg connection string",
)
parser.add_option(
'-s', '--max-seconds', type='int',
dest='max_seconds', default=60*60,
help='Maximum seconds time connections are allowed to remain active.',
)
parser.add_option(
'-q', '--quiet', action='store_true', dest="quiet",
default=False, help='Silence output',
)
parser.add_option(
'-n', '--dry-run', action='store_true', default=False,
dest='dry_run', help="Dry run - don't kill anything",
)
parser.add_option(
'-u', '--user', action='append', dest='users',
help='Kill connection of users matching REGEXP', metavar='REGEXP')
options, args = parser.parse_args()
if len(args) > 0:
parser.error('Too many arguments')
if not options.users:
parser.error('--user is required')
user_match_sql = 'AND (%s)' % ' OR '.join(
['usename ~* %s'] * len(options.users))
con = psycopg2.connect(options.connect_string)
cur = con.cursor()
cur.execute("""
SELECT usename, procpid, backend_start, xact_start
FROM pg_stat_activity
WHERE xact_start < CURRENT_TIMESTAMP - '%d seconds'::interval %s
ORDER BY procpid
""" % (options.max_seconds, user_match_sql), options.users)
rows = list(cur.fetchall())
if len(rows) == 0:
if not options.quiet:
print 'No transactions to kill'
return 0
for usename, procpid, backend_start, transaction_start in rows:
print 'Killing %s (%d), %s, %s' % (
usename, procpid, backend_start, transaction_start,
)
if not options.dry_run:
os.kill(procpid, signal.SIGTERM)
return 0
if __name__ == '__main__':
sys.exit(main())
|