VirtualTam's bookmarks

1. jackc/pgx - PostgreSQL Driver and Toolkit 2023-07-04

   tags: concurrency, database/postgresql, programming/go

   [ permalink ]

   • Getting started with pgx
   • https://donchev.is/post/working-with-postgresql-in-go-using-pgx/
   • jackc/pgx/v5/pgtype - Map between all common base types directly between Go and PostgreSQL
   • jackc/pgx/v5/pgxpool - Concurrency-safe connection pool for pgx
   • scany/v2/pgxscan - Scan data into Go structs and other composite types
   • Bulk INSERT in Postgres in GO using pgx
   • Postgres table batch updates using golang pgxpool not reflected in database
   • pgx.Conn can see uncommitted changes made from a pgx.Tx - TL;DR use pgxpool for concurrency-safe transactions
   • Not clear if caller is required to close in case of QueryRow or if QueryRow properly closes in case of error
2. Debugging Certificate Errors 2023-02-18

   tags: cryptography/certificate, curl, network/http, network/transport-layer-security, openssl

   [ permalink ]

   • https://www.netmeister.org/whatsthatcert/
3. AWS | Enable Enhanced Networking with Elastic Network Adapters for vintage OS AMIs 2019-09-17

   tags: chroot, cloud/aws, linux, linux/debian, linux/kernel, virtualization, xen

   [ permalink ]

   Paravirtual (PV) to Hardware Virtual Machine (HVM):

   • https://stackoverflow.com/questions/24330721/amazon-ec2-how-to-convert-an-existing-pv-ami-to-hvm

   ENA support:

   • https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/enhanced-networking-ena.html
   • https://forums.aws.amazon.com/thread.jspa?threadID=166135
   • https://aws.amazon.com/premiumsupport/knowledge-center/boot-error-linux-m5-c5/
   • https://bugs.centos.org/view.php?id=14107
   • https://ygrene.tech/how-to-enable-ena-support-for-aws-amis-in-5-steps-and-make-your-bamboo-remote-jobs-really-fast-f2a4254a9955

   Build Debian AMIs from scratch:

   • https://bootstrap-vz.readthedocs.io/en/master/
   • https://github.com/andsens/bootstrap-vz
   • https://www.slideshare.net/JamesBromberger/debian-cloud-building-the-debian-amis
   • https://blog.james.rcpt.to/2012/12/06/official-debian-images-on-amazon-web-services-ec2/

   Squeeze:

   • https://lists.debian.org/debian-cloud/2013/02/msg00023.html

   Wheezy:

   • https://lists.debian.org/debian-cloud/2014/10/msg00009.html
   • https://lists.debian.org/debian-cloud/2014/11/msg00000.html

   Boot to chroot:

   • https://unix.stackexchange.com/questions/85714/boot-into-a-chroot
   • https://wiki.debian.org/chroot
   • https://wiki.debian.org/Debootstrap
   • https://superuser.com/questions/384437/booting-linux-system-from-chroot-is-there-a-better-way-to-do-this/384457#384457
   • https://github.com/lemonsqueeze/boot-chroot
4. Tuning PHP-FPM for high traffic 2019-03-29

   tags: network/http, network/http-server/nginx, performance, php-fpm, programming/php

   [ permalink ]

   • https://haydenjames.io/php-fpm-tuning-using-pm-static-max-performance/
   • https://www.if-not-true-then-false.com/2011/nginx-and-php-fpm-configuration-and-optimizing-tips-and-tricks/
   • http://www.softwareprojects.com/resources/programming/t-optimizing-nginx-and-php-fpm-for-high-traffic-sites-2081.html
   • https://www.php.net/manual/en/install.fpm.configuration.php
   • https://serverfault.com/questions/773216/php-error-pool-www-seems-busy-you-may-need-to-increase-pm-start-servers-or-p
   • https://serverfault.com/questions/874642/configuring-nginx-php-fpm-for-high-traffic-load
5. Cycle error when trying to create AWS VPC security groups using Terraform - Stack Overflow 2019-02-20

   tags: cloud/aws, configuration-management/terraform, cycle, graph

   [ permalink ]

   TL;DR: break the dependency cycle by declaring rules between two of the groups from the dependency chain with aws_security_group_rule

   • https://github.com/hashicorp/terraform/issues/539
   • https://github.com/hashicorp/terraform/issues/530
   • https://github.com/hashicorp/terraform/pull/1620
   • https://omarkhawaja.com/terraform-resolving-aws-security-group-cyclic-dependency/
6. [openvpn] ERROR: could not find an available, non-overlapping IPv4 address pool among the defaults to assign to the network · Issue #418 · docker/for-linux · GitHub 2019-01-28

   tags: linux/container/docker, network, network/vpn

   [ permalink ]

   • https://www.reddit.com/r/docker/comments/5nf966/cant_start_daemon/
7. Vaughan Hilts - Using Huginn for profit and fun; finding price errors on the Internet 2019-01-05

   tags: automation, feed, huginn, network/http, programming/ruby, web/scraping, web/syndication

   [ permalink ]
8. time series - Simple way to algorithmically identify a spike in recorded errors - Cross Validated 2018-10-30

   tags: mathematics, observability, observability/time-series, observability/time-series/prometheus, statistics

   [ permalink ]
9. Redis - FAQ - Background saving fails with a fork() error under Linux even if I have a lot of free RAM! 2018-10-29

   tags: database/redis, hardware/ram, linux/container/docker, memory

   [ permalink ]

   • https://github.com/docker-library/redis/issues/159
   • https://gist.github.com/kapkaev/4619127
   • https://stackoverflow.com/questions/19581059/misconf-redis-is-configured-to-save-rdb-snapshots
   • https://stackoverflow.com/questions/42502636/unable-to-save-in-background-redis-server
   • https://people.redhat.com/nhorman/papers/rhel4_vm.pdf
10. Jenkins Pipeline docker.build() gives error '"docker build" requires exactly 1 argument(s)' - Stack Overflow 2018-09-27

    tags: continuous-integration/jenkins, linux/container/docker

    [ permalink ]

    • https://stackoverflow.com/questions/44805076/setting-build-args-for-dockerfile-agent-using-a-jenkins-declarative-pipeline
11. The USE Method: Utilization, Saturation and Errors 2018-08-18

    tags: application, observability, observability/logging, performance, plot, resource, service

    [ permalink ]

    • https://twitter.com/LindsayofSF/status/692191001692237825
    • http://peter.bourgon.org/blog/2016/02/07/logging-v-instrumentation.html
    • http://www.brendangregg.com/USEmethod/use-rosetta.html
12. This is strictly a violation of the TCP specification 2017-12-21

    tags: linux, network, network/http, network/proxy, network/socket, strace

    [ permalink ]

    • https://support.cloudflare.com/hc/en-us/articles/200171906-Error-522-Connection-timed-out
    • https://access.redhat.com/solutions/437133
    • https://benohead.com/tcp-about-fin_wait_2-time_wait-and-close_wait/
    • https://github.com/cloudflare/cloudflare-blog/blob/master/2016-08-time-out/listener.go
13. Monitoring the Dark Army with Kibana on Mr. Robot | Elastic 2017-11-22

    tags: dashboard, data, engine, observability/elastic/elasticsearch, observability/elastic/kibana, search, series, visualization

    [ permalink ]

    • https://medium.com/@ryankazanciyan/mr-robot-disassembled-3-4-runtime-error-r00-9319c70c30f2
14. How Sentry Receives 20 Billion Events Per Month While Preparing to Handle Twice That 2017-11-09

    tags: crash, data, error, observability, programming/python, report

    [ permalink ]

    • https://news.ycombinator.com/item?id=15655135
      • https://news.ycombinator.com/item?id=15660707
      • https://news.ycombinator.com/item?id=15656474
    • https://sentry.io/welcome/
15. How to Use Elasticsearch, Logstash, and Kibana to Manage Apache Logs 2017-09-30

    tags: network/http-server/apache-httpd, observability/elastic/elasticsearch, observability/elastic/logstash, observability/logging

    [ permalink ]

    • https://www.elastic.co/guide/en/logstash/master/config-examples.html
    • https://github.com/logstash-plugins/logstash-patterns-core/blob/master/patterns/httpd
    • https://discuss.elastic.co/t/apache-error-logs-timestamp/82010/9
    • https://discuss.elastic.co/t/parsing-apache-logs-combinedapachelog-commonapachelog-not-working/82007
    • http://www.thegeekstuff.com/2014/12/logstash-setup/
16. Fixing nginx client body temp permission denied errors · wincent.com 2017-06-02

    tags: file, linux, linux/container/docker, network/http-server/nginx, permission, user

    [ permalink ]

    • https://github.com/dockerfile/nginx/issues/4
    • https://nginx.org/en/docs/http/ngx_http_core_module.html#client_body_temp_path
17. Building a DLL in Cygwin 2017-04-25

    tags: autotools, cygwin, microsoft/windows, programming/c, programming/c++, programming/library, shared

    [ permalink ]

    error: relocation truncated to fit: R_X86_64_PC32 against undefined symbol `len'

    • https://cygwin.com/ml/cygwin/2014-04/msg00058.html
    • https://stackoverflow.com/questions/10486116/what-does-this-gcc-error-relocation-truncated-to-fit-mean
    • https://www.technovelty.org/c/relocation-truncated-to-fit-wtf.html

    error: undefined symbols not allowed

    • http://www.gnu.org/software/libtool/manual/html_node/LT_005fINIT.html
    • http://stackoverflow.com/questions/17487891/libtool-undefined-symbols-not-allowedin-i686-pc-mingw32-shared#22884787

    error: undefined reference to winmain

    • http://stackoverflow.com/questions/33734016/undefined-reference-to-winmain-with-cygwin-and-cmake
    • http://stackoverflow.com/questions/13871617/winmain-and-main-in-c-extended

    Autotools:

    • https://www.sourceware.org/autobook/autobook/autobook_135.html
    • https://www.sourceware.org/autobook/autobook/autobook_136.html
    • https://sourceware.org/autobook/autobook/autobook_137.html
    • http://stackoverflow.com/questions/26151995/autotools-make-doesnt-create-dll-under-cygwin
    • https://autotools.io/libtool/windows.html

    Cygwin:

    • https://cygwin.com/cygwin-ug-net/dll.html
    • https://cygwin.com/problems.html

    General:

    • http://stackoverflow.com/questions/25105573/compile-for-windows-using-mingw-w64-and-autotools
18. Introduction to Literate Programming 2016-03-29

    tags: development, editor/emacs, error, literate, mode, org, programming, trial

    [ permalink ]

    "Instead of imagining that our main task is to instruct a computer what to do, let us concentrate rather on explaining to human beings what we want a computer to do."

    • Donald Knuth
19. Language Tools for Reducing Mistakes 2015-08-05

    tags: continuous-integration, development, error, quality, syntax, tool

    [ permalink ]

    • http://ariya.ofilabs.com/2012/11/language-tools-for-reducing-mistakes.html (original URL)
    • https://web.archive.org/web/20160324065850/http://ariya.ofilabs.com/2012/11/language-tools-for-reducing-mistakes.html (archive)
20. PHP: php_value vs php_admin_value and the use of php_flag explained 2015-07-06

    tags: configuration, development, observability/logging, programming/php, server, setting, value, web

    [ permalink ]

    via http://stackoverflow.com/questions/176/error-log-per-virtual-host see http://php.net/manual/en/function.error-log.php