matti

#SingleInstance

; Sharpkeys:
; - LAlt -> RControl
; - Copilot -> LAlt

; copilot-key "Special: Right Shift (00_36)" to Left Windows (E0_5B)


; ~LWin::vkE8   ; prevents windows key

matti

#!/usr/bin/env bash

set -eEuo pipefail

declare -A name_pid
declare -A name_start

(
  echo "eka started"
  sleep 1

matti

#!/usr/bin/env bash

set -eEuo pipefail
set -x

storage=local-btrfs

mkdir -p /var/lib/vz/snippets

cd /root

matti

#SingleInstance

; MsgBox "yo dawg"
; ^+r::Reload

SelectAll := 0

LWin::LAlt
LAlt::LWin

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