Skip to content

Instantly share code, notes, and snippets.

@IMMORTALxJO
IMMORTALxJO / clickhouse-backup.remote-restore.error.log
Created September 25, 2023 21:01
Clickhouse-backup restore_remote log
2023/09/25 20:55:32.487728 info clickhouse connection prepared: tcp://localhost:9000 run ping logger=clickhouse
2023/09/25 20:55:32.488644 info clickhouse connection open: tcp://localhost:9000 logger=clickhouse
2023/09/25 20:55:32.488669 info SELECT value FROM `system`.`build_options` where name='VERSION_INTEGER' logger=clickhouse
2023/09/25 20:55:32.490151 info SELECT count() is_disk_type_present FROM system.columns WHERE database='system' AND table='disks' AND name='type' logger=clickhouse
2023/09/25 20:55:32.492018 info SELECT path, any(name) AS name, any(type) AS type FROM system.disks GROUP BY path logger=clickhouse
2023/09/25 20:55:32.495021 info SELECT max(toInt64(bytes_on_disk * 1.02)) AS max_file_size FROM system.parts logger=clickhouse
2023/09/25 20:55:32.497382 info SELECT count() AS is_macros_exists FROM system.tables WHERE database='system' AND name='macros' SETTINGS empty_result_for_aggregation_by_empty_set=0 logger=clickhouse
2023/09/25 20:55:32.499367 info SELECT macro, substitution F
@IMMORTALxJO
IMMORTALxJO / nginx-certificates-validation
Last active May 23, 2023 11:10
Check nginx configuration has valid certificates
#!/usr/bin/env python3
import crossplane
import os
from cryptography import x509
from cryptography.hazmat.backends import default_backend
from cryptography.hazmat.primitives.serialization import load_pem_private_key
from cryptography.x509.oid import NameOID
from functools import lru_cache
EXIT_CODE = 0
@IMMORTALxJO
IMMORTALxJO / swarm.networkdb.events.log
Created January 19, 2021 11:52
Networkdb events log for moby issue
## Common events related to online endpoint from bulk sync
2021-01-19T06:38:10.886180117Z {Type:CREATE,LTime:93557892,NodeName:1b906f7d2be0,NetworkID:f312pn3rfujkpupqzeyumtvpm,TableName:endpoint_table,Key:96309316d9ca369cfae8bd02f9ecfa4cc468e4fd60cd0e33863ec33ef4a0bdd6,ResidualReapTime:0}
2021-01-19T06:38:40.905904777Z {Type:CREATE,LTime:93557892,NodeName:1b906f7d2be0,NetworkID:f312pn3rfujkpupqzeyumtvpm,TableName:endpoint_table,Key:96309316d9ca369cfae8bd02f9ecfa4cc468e4fd60cd0e33863ec33ef4a0bdd6,ResidualReapTime:0}
2021-01-19T06:39:10.885634958Z {Type:CREATE,LTime:93557892,NodeName:1b906f7d2be0,NetworkID:f312pn3rfujkpupqzeyumtvpm,TableName:endpoint_table,Key:96309316d9ca369cfae8bd02f9ecfa4cc468e4fd60cd0e33863ec33ef4a0bdd6,ResidualReapTime:0}
2021-01-19T06:39:41.193478062Z {Type:CREATE,LTime:93557892,NodeName:1b906f7d2be0,NetworkID:f312pn3rfujkpupqzeyumtvpm,TableName:endpoint_table,Key:96309316d9ca369cfae8bd02f9ecfa4cc468e4fd60cd0e33863ec33ef4a0bdd6,ResidualReapTime:0}
## Deploy process started, node 1b906f7d
@IMMORTALxJO
IMMORTALxJO / swarm.bitseq.analyzer.sh
Created October 23, 2020 12:26
Swarm bitseq visualization
#!/bin/bash
PRINT_INTERVAL="${PRINT_INTERVAL:-10}"
NETWORK_NAME="${1}"
if [[ -z "${NETWORK_NAME}" ]]; then
echo "usage: $0 <network_name>"
exit 0
fi;
set -eu