msilvey

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

msilvey

java.lang.RuntimeException: Error calling eventfd_write(...): Bad file descriptor
        at io.netty.channel.epoll.Native.eventFdWrite(Native Method)
        at io.netty.channel.epoll.EpollEventLoop.wakeup(EpollEventLoop.java:119)
        at io.netty.util.concurrent.SingleThreadEventExecutor.shutdownGracefully(SingleThreadEventExecutor.java:561)
        at io.netty.util.concurrent.MultithreadEventExecutorGroup.shutdownGracefully(MultithreadEventExecutorGroup.java:146)
        at com.datastax.driver.core.NettyOptions.onClusterClose(NettyOptions.java:200)
        at com.datastax.driver.core.Connection$Factory.shutdown(Connection.java:825)
        at com.datastax.driver.core.Cluster$Manager$ClusterCloseFuture$1.run(Cluster.java:2303)

msilvey

#!/bin/bash

NOW=`date +%s`
SIXHOURSAGO=`echo "$NOW - 21600" |bc`
HADOOPBIN="/usr/bin/hadoop"

IFS=$'\n'
for i in `$HADOOPBIN fs -ls /user/root/.staging/`; do
  IFS=' '
  JOBDATE=`echo $i|awk '{print $6" "$7}'`