Skip to content

Instantly share code, notes, and snippets.

View justizin's full-sized avatar

Justin Alan Ryan justizin

View GitHub Profile
@justizin
justizin / gist:9945174
Created April 2, 2014 23:10
gmetad segfault
access("/etc/ganglia/gmetad.conf", R_OK) = 0
open("/etc/ganglia/gmetad.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=4920, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f5af5767000
read(3, "# This is an example of a Gangli"..., 4096) = 4096
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV (core dumped) +++
Segmentation fault (core dumped)
gmetad.
/* Feel free to specify as many udp_send_channels as you like. Gmond
used to only support having a single channel */
udp_send_channel {
host = 10.1.0.48
port =
ttl = 1
}
/* always send to localhost */
udp_send_channel {
@justizin
justizin / gist:10427383
Created April 10, 2014 21:59
londiste ini
[londiste3]
job_name = st3_l3simple_db1
db = dbname=l3simple_db1
queue_name = replika
logfile = st3simple/log/st3_l3simple_db1.log
pidfile = st3simple/pid/st3_l3simple_db1.pid
@justizin
justizin / gist:10428288
Created April 10, 2014 22:15
londiste drop-node error
[S] [hm@pg06 l3simple]$ sudo -u postgres londiste3 st3simple/st3_l3simple_db1.ini drop-node node2
2014-04-10 22:14:52,769 19253 ERROR Job st3_l3simple_leaf crashed: find_root_db: got loop: dbname=l3simple_db1
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/skytools/scripting.py", line 579, in run_func_safely
r = func()
File "/usr/local/lib/python2.7/dist-packages/skytools/adminscript.py", line 62, in work
fn(*cmdargs)
File "/usr/local/lib/python2.7/dist-packages/pgq/cascade/admin.py", line 659, in cmd_drop_node
root_db = self.find_root_db()
File "/usr/local/lib/python2.7/dist-packages/pgq/cascade/admin.py", line 365, in find_root_db
@justizin
justizin / gist:10429095
Created April 10, 2014 22:30
londiste db error
[S] [hm@pg06 l3simple]$ sudo -u postgres /usr/bin/python /usr/local/bin/londiste3 -vvv st3simple/st3_l3simple_db1.ini worker
2014-04-10 22:28:53,845 19359 DEBUG __init__
2014-04-10 22:28:53,847 19359 DEBUG Connect 'db' to 'dbname=l3simple_db1'
2014-04-10 22:28:53,854 19359 DEBUG exec_cmd: select * from pgq_node.get_consumer_state('replika', 'st3_l3simple_leaf')
2014-04-10 22:28:53,857 19359 ERROR Unknown consumer: replika/st3_l3simple_leaf
2014-04-10 22:28:53,858 19359 DEBUG Query was: select * from pgq_node.get_consumer_state('replika', 'st3_l3simple_leaf')
2014-04-10 22:28:53,858 19359 DEBUG Connect 'db' to 'dbname=l3simple_db1'
2014-04-10 22:28:53,863 19359 DEBUG exec_cmd: select * from pgq_node.set_consumer_error('replika', 'st3_l3simple_leaf', 'db error')
2014-04-10 22:28:53,866 19359 DEBUG 101 Consumer not known, ignoring: replika/st3_l3simple_leaf
2014-04-10 22:28:53,866 19359 ERROR Job st3_l3simple_leaf crashed: db error
postgres=# \c l3simple_db1
You are now connected to database "l3simple_db1" as user "postgres".
l3simple_db1=# select * from pgq_node.local_state;
queue_name | consumer_name | provider_node | last_tick_id | cur_error | paused | uptodate
------------+------------------+---------------+--------------+---------------------------------------------------+--------+----------
replika | st3_l3simple_db1 | node1 | 1 | Not subscriber to queue: replika/st3_l3simple_db1 | f | t
(1 row)
l3simple_db1=# select * from pgq_node.node_location;
queue_name | node_name | node_location | dead
@justizin
justizin / gist:10502674
Created April 11, 2014 21:22
add pkey constraint to all id columns
DO $$
DECLARE
tables CURSOR FOR SELECT tablename FROM pg_tables WHERE schemaname = 'public' ORDER BY tablename;
nbRow int;
BEGIN
FOR table_record IN tables LOOP
EXECUTE 'ALTER TABLE ' || table_record.tablename 'add primary key (id)';
END LOOP;
END$$;
@justizin
justizin / gist:49d535ce7beb6b1240d3
Created May 9, 2014 18:24
rrdcached/run changes?
* template[/etc/sv/rrdcached/run] action create
- update content in file /etc/sv/rrdcached/run from e06919 to 43e7bf
--- /etc/sv/rrdcached/run 2014-04-25 19:16:16.812552956 +0000
+++ /tmp/chef-rendered-template20140509-3493-8t1bwo 2014-05-09 18:23:17.403457002 +0000
@@ -1,8 +1,7 @@
#!/bin/sh
exec 2>&1
-exec chpst -u nobody /usr/bin/rrdcached -w 30 -z 5 -F -g -p /tmp/rrdcached.pid \
- -m 664 -l unix:/tmp/rrdcached.sock \
- -m 777 -P FLUSH,STATS,HELP -l unix:/tmp/rrdacached_limited.sock \
* template[/etc/ganglia/gmond.conf] action create
- update content in file /etc/ganglia/gmond.conf from 65a4c8 to d56b00
--- /etc/ganglia/gmond.conf 2014-04-28 05:56:26.363457002 +0000
+++ /tmp/chef-rendered-template20140509-3493-11iakcf 2014-05-09 18:23:08.551457005 +0000
@@ -1,345 +1,345 @@
-/* This configuration is as close to 2.5.x default behavior as possible
- The values closely match ./gmond/metric.h definitions in 2.5.x */
-globals {
- daemonize = yes
- setuid = yes
@justizin
justizin / gist:c79f3ec31c4ee9ec414e
Created May 9, 2014 18:27
example gmond collector init script
* template[/etc/init.d/ganglia-monitor-recappg] action create
- update content in file /etc/init.d/ganglia-monitor-recappg from 448aa0 to 25a103
--- /etc/init.d/ganglia-monitor-recappg 2014-04-13 22:05:09.328552956 +0000
+++ /tmp/chef-rendered-template20140509-3493-9lgb8d 2014-05-09 18:23:15.847457002 +0000
@@ -5,7 +5,7 @@
# Required-Stop: $network $named $remote_fs $syslog
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
-### END INIT INFO
+### END INIT INFO