Skip to content

Instantly share code, notes, and snippets.

View hut8's full-sized avatar
👋

Liam hut8

👋
  • Supervillain Software Group
  • Albany, NY, USA
View GitHub Profile
@hut8
hut8 / page.sql
Created October 29, 2022 21:37
sqlglot-mysql-bug
This file has been truncated, but you can view the full file.
INSERT INTO `page` VALUES (42606694,3,'Wntrfields',0,0,0.730828127623,'20220906235535','20220828184310',1088743429,36841,'wikitext',NULL),(42606695,3,'Trebusckar',0,0,0.072998462551,'20220921214032','20220708061733',1076828330,14472,'wikitext',NULL),(42606696,3,'124.171.161.240',0,1,0.945031610466,'20200903145333','20220726051342',606159662,1278,'wikitext',NULL),(42606697,0,'Ancyroclepsis_nakhasathieni',0,0,0.663480402719,'20220925145955','20220925134054',997199953,676,'wikitext',NULL),(42606698,3,'108.252.143.80',0,1,0.699785130689,'20220901190010','20220901190009',606159696,809,'wikitext',NULL),(42606699,1,'Ancyroclepsis_nakhasathieni',0,1,0.470864374751,'20220828102536','20220828133018',606159697,45,'wikitext',NULL),(42606702,2,'Rkrish67/Books/Automobile_Engineering',0,0,0.521466770236,'20220910033428','20220715082419',606160347,1840,'wikitext',NULL),(42606703,0,'康熙字典',1,1,0.810067565268,'20220919032306','20220921063906',606159731,63,'wikitext',NULL),(42606704,1,'Homelessness_in_the_United_States/Archive_1
@hut8
hut8 / innodb-status.txt
Created January 30, 2022 00:34
*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2022-01-30 00:29:10 0x7f7234541700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
-----------------
BACKGROUND THREAD
@hut8
hut8 / libpq-crash-analyze-20220122
Created January 23, 2022 01:46
Microsoft (R) Windows Debugger Version 10.0.22473.1005 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.
*** wait with pending attach
************* Path validation summary **************
Response Time (ms) Location
Deferred srv*
OK C:\Users\dcbow\pg-14.1\libpq
@hut8
hut8 / libpq-crash-analyze-52a1022.md
Created January 21, 2022 01:03

libpq crash analysis

Revision 52a1022

Session

Microsoft (R) Windows Debugger Version 10.0.22473.1005 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.
@hut8
hut8 / libpq-crash-analyze-092b785fad.md
Last active January 20, 2022 06:09

Postmortem debugger session for libpq crash

Commit 092b785fad

Microsoft (R) Windows Debugger Version 10.0.22473.1005 AMD64
Copyright (c) Microsoft Corporation. All rights reserved.

*** wait with pending attach
@hut8
hut8 / gist:bda7e9e87f90ecadc7a5bb47603c3e9d
Created December 30, 2021 21:17
Crash Dump !analyze -v
0:011> !analyze -v
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************
KEY_VALUES_STRING: 1
@hut8
hut8 / thing.go
Created June 21, 2016 02:36
package main
import (
"fmt"
"syscall"
"unsafe"
)
type (
DWORD uint32
@hut8
hut8 / rails-assets-bower-deps
Created April 13, 2016 17:25
#!/usr/bin/env ruby
# frozen_string_literal: true
require 'json'
require 'open-uri'
components = JSON.parse(open('https://rails-assets.org/components.json').read)
i = 0
components.each do |c|
cn = c['name']
c['versions'].each do |v|
cv = "#{cn}##{v}"
@hut8
hut8 / gist:80557e834856756f6b98
Created March 7, 2016 22:04
roll
{
"body": {
"trace": {
"frames": [
{
"lineno": 79,
"method": "rollrus.(*Hook).Fire",
"filename": "github.com/heroku/rollrus/rollrus.go"
},
{
@hut8
hut8 / bug_report_template.rb
Created December 26, 2015 20:55
# Use this template to report PaperTrail bugs.
# It is based on the ActiveRecord template.
# https://github.com/rails/rails/blob/master/guides/bug_report_templates/active_record_gem.rb
begin
require 'bundler/inline'
rescue LoadError => e
$stderr.puts 'Bundler version 1.10 or later is required. Please update your Bundler'
raise e
end