matti

#!/usr/bin/env bash
set -euo pipefail

export PAGER=""

TARGET_DBNAME=$1

psql --dbname "$TARGET_DBNAME" -c "SELECT * FROM pg_stat_activity;"

#TODO: user hardcoded to postgres

matti

#!/usr/local/bin/php
<?php

require_once("config.inc");
require_once("system.inc");
require_once("interfaces.inc");
require_once("util.inc");

$subsystem = !empty($argv[1]) ? $argv[1] : '';
$type = !empty($argv[2]) ? $argv[2] : '';

matti

failed to create containerd task: failed to create shim task: failed to mount rootfs component: invalid argument: unknown\"" component=containerd stream=stderr
time="2023-11-14 20:00:39" level=info msg="E1114 20:00:39.603695      99 remote_runtime.go:176] \"RunPodSandbox from runtime service failed\" err=\"rpc error: code = Unknown desc = failed to create containerd task: failed to create shim task: failed to mount rootfs component: invalid argument: unknown\"" component=kubelet stream=stderr
time="2023-11-14 20:00:39" level=info msg="E1114 20:00:39.603730      99 kuberuntime_sandbox.go:72] \"Failed to create sandbox for pod\" err=\"rpc error: code = Unknown desc = failed to create containerd task: failed to create shim task: failed to mount rootfs component: invalid argument: unknown\" pod=\"kube-system/kube-proxy-nlgsw\"" component=kubelet stream=stderr
time="2023-11-14 20:00:39" level=info msg="E1114 20:00:39.603743      99 kuberuntime_manager.go:1122] \"CreatePodSandbox for pod failed\" err=\"rpc error: c

matti

version: '3.9'

services:
  worker:
    image: ghcr.io/usvacomputer/platform/worker:2adbe3a8aa4ff7f5f7edc30131148184b1c4c1ed
    environment:
      - USVA_ENV=matti-1
      - USVA_DOMAIN=usva.io
      - USVA_NAME=default
    privileged: true

matti

SELECT *
FROM `project.dataset.table`
WHERE 
	time BETWEEN PARSE_TIMESTAMP("%Y%m%d", @DS_START_DATE) AND PARSE_TIMESTAMP("%Y%m%d", @DS_END_DATE)

matti

  while true; do
    nodesWithFailingPods=""
    if failedPods=$(kubectl get pods -n default --no-headers | awk  '$4 > 1 {print $1}') && [[ "$failedPods" != "" ]]; then
      for failedPod in $failedPods; do
        echo "$(date) pod failed too many times: '$failedPod'"
        if failedPodNodeName=$(kubectl get pod -n default "$failedPod" -ojsonpath='{.spec.nodeName'}); then
          nodesWithFailingPods="$nodesWithFailingPods $failedPodNodeName"
        fi
      done

matti

while true; do
  kubectl get pods --all-namespaces --no-headers | awk  '$5 > 3 {print $1,$2}' | xargs -r kubectl delete pod -n || echo "failed to delete pods"
  sleep 30
done

matti

while true; do
  kubectl delete pods -n "$NAMESPACE" --field-selector=status.phase=Failed || true
  sleep 10
done

matti

var items = document.querySelectorAll(".list-item--8QFZA")
var elements = Array.from(items)
//var els = elements.slice(0, 3)
var els = elements

document.addEventListener("visibilitychange", function () {
  if (document.visibilityState === 'visible') {
    els.pop().click()
  }

matti

gs -q -dNOPAUSE -dBATCH -sDEVICE=pdfwrite -sOutputFile=merged.pdf $(printf "$(ls -tr)")