a111: Logged on 2017-04-04 22:32 mircea_popescu: think in terms of that cartoon re final cs class at stanford : "and you are the idiots who didn't get hired in 2nd or 3rd year". same deal, whoring is a fine plan for cut-above-rest 16yo. by the time she's 30 she's either married or too rich to care.
mircea_popescu: this'd be a fine indication of infection/nsaization/extremely sloppy opsec corp/whatever.
mircea_popescu: this is prolly worth of a qntra or something. who the fuck copies ssh keys across the field.
mircea_popescu: ah looks like tiny powerplant, maybe solar on someone's house ?
mircea_popescu: "Use Enlighten or contact Enphase Energy customer support for a profile change token Serial number: 110939095462 Authorization number: 95477310"
phf: asciilifeform: do you have a set of high dpi (150/200) bitmap fonts for x11 that you use by any chance?
☟︎ mircea_popescu: so if i change the settings now re eg voltage ima start a battery fire.
scriba: ssh banner of 141.239.148.243 as seen on 2016-06-13: SSH-2.0-OpenSSH_5.1p1 Debian-5
CompanionCube: I would say 'what if the owner finds out'...but since they left it at admin/admin...
CompanionCube: mircea_popescu: so you're planning to turn the batteries of or something then
mircea_popescu: asciilifeform hey, it was published in the princeton review!!1
CompanionCube wonders how they would find out. It's not like they'd *notice* a changed password
mircea_popescu: hey, ineptitude is not an excuse from duty. they shouyld find out.
phf: CompanionCube: they will most likely go and change something 10 months from now, then will spend couple of days searching for "that paper with password"
CompanionCube: also, shitty web UIs generally do not have that option.
mircea_popescu: asciilifeform if the item is anything like empire made, the reset button is up on the roof shimmied next to the chimney
mircea_popescu: so basically, the idea here is "enphase energy" simply stamps the same (broken!) ssh key on all its boxes ?
shinohai reset all their DNS servers to google's
mircea_popescu: well, "cost them". obama gave them 48 mn or some shit, of which they kept 3, the obama-contractor kept 11, the obama-producer kept 16, and the end result was 100ish MW (wthose thigs aren't accurate) over 5 years ie about 5 grand worth of "Clean" power.
mircea_popescu: except it produced so much solid waste it'll take a few GW to clean up to some storable state.
mircea_popescu just chopped up a coupla vanilla beans to sit in rum for eventual rompope
mircea_popescu: for srs. this is actual data, as opposed to the bs that someone publishes.
mircea_popescu: "chump". it's all paid by unfunded future payments which ain't fucking happening.
mircea_popescu: asciilifeform only 28 items on your pastebin, was supposed to bne more ?
a111: Logged on 2017-04-06 00:26 mircea_popescu: anyway. the new password is now phuctor.
mircea_popescu: i dunno we care enough to actually bother. will see what this list tallies up to.
mircea_popescu: certainly much more valid survey than what the pantsuit tribe customarily passes for "research"
a111: Logged on 2017-04-06 00:25 phf: asciilifeform: do you have a set of high dpi (150/200) bitmap fonts for x11 that you use by any chance?
phf: i think i'm going to not do computers anymore. i'm done.
mod6: <+asciilifeform> mod6 ? << need some perl? <+mircea_popescu> asciilifeform working on list. << looks like mp is on it.
shinohai: Guppies are food for the sharks yo!
BingoBoingo: <asciilifeform> if mircea_popescu dun feel like qntra -- BingoBoingo , then ? << I can/will qntra, but in the future when you are lulzing about the details of a thing and are unsure if editor is awake/digging-liming holes/trying to get older sober lady to 13th step him, maybe consider writing a qntra while you have and are playing with the details? Makes for more timely publication when editor is awake? Publication can happen faster when
BingoBoingo: editor is verifying details in submission lulzed at in logs than when reconstructing them...
shinohai was awake, but is rather unsure about Qntra submissions of late
BingoBoingo: <mircea_popescu> anyway, no explaining, ridiculous move. << perhaps move to lure pantsuits into self hanging? Either that or clog fake news circuit.
BingoBoingo: With media favorite Katie Stewart out of whiteouse and fundraising, media has to eat intrigue actually generated by Trump
BingoBoingo: In other news, Trumpreich endorsed by King of Jordan.
mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
☟︎ a111: Logged on 2017-04-06 02:27 mircea_popescu: asciilifeform lulz of all time : you can get further victims AS THEY ARE INDEXED BY GOOGLE through for instance searching for "800-00038-r08" or such strings. you get a very lulzy welcome if selecting eg "deutshc" : everything's "translation missing"
mircea_popescu: ample room for more people to dig more lulz if so inclined.
BingoBoingo: Sometimes when you lol at a deeptail, it is easiest to write up the lollercoaster yourself.
mircea_popescu has revised some numbers, it turns out microinverters are generally about 200W rather than the more kw style stuff he remembered from youth
BingoBoingo: Loading bricks is hard work. Writing is disciplined work.
mircea_popescu: anyway, so 200W unit produced 731 Wh/day on 5year average
trinque: "though no word was available as to whether the agent and his female companion explored a full range of disciplinary actions on their own before the tryst was interrupted." << top kek
jhvh1: shinohai: Error: "tyvm" is not a valid command.
jhvh1: You are very welcome Daddy
mircea_popescu: phf asciilifeform to make you both feel better : sat i'm going to a "russian rock concert" at this massage parlour slash blinyi restaurant run by a buncha russian chicks.
shinohai hopes mircea_popescu 's Russian chicks aren't anti-semitic
shinohai: They might read trilema, see mircea_popescu in earlier days with joofro and start pogrom
mircea_popescu: only 660 or so mIs, say about half mil total worth or so
shinohai: trb blocks, now individually wrapped for your convenience.
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 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: sent query to n-gate (in the sense of reducing meaning to a tweet and pretending that's communication)
deedbot: DaSancho voiced for 30 minutes.
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.)
☟︎ 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.
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
Framedragger: at least the currency will inflate now so that they can export ugly girls cheaper
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
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: except google can't index it because the /stats/ dies on it i guess.
☟︎ 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: thing is, it doesnt' crash, it always comes up but you gotta know to retry.
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.
a111: Logged on 2017-04-06 12:43 mircea_popescu: lel. the cheapest is for the site to support it natively!
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: <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) <sshscan-queries+60.213.15.140@mkj.lt>; </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) ?
Framedragger: yes in retrospect i did not expect for there to be so many pops lol.
Framedragger: asciilifeform: MEng here means 'master of engineering' (which can include software engineering, yesyes), not mech
mircea_popescu: i am taking the entire table as found on stats page and putting it on trilema.
mircea_popescu: now, how do i tell awk to turn the blather quoted above into the intended result ? hm ? HM ?
Framedragger: i sed'ed the relative urls, as in "<a href="/">Submit GPG Key</a>", to point them to phuctor, etc
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: asciilifeform it's not missing, it has an extra 1 megabyte of Framedragger 's hello world
mircea_popescu: (which is very good and useful as it is, not the problem there. but gotta fix it here)
mircea_popescu: that's not something i, or anyone else, can be "cured" of.
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)
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
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: apparently mysql recommends storing large data/text blobs in separate 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.
mircea_popescu: well apparently trilema's going to be offline for a while for reasons of unexpected explosion.
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: there's a "repair by sorting" going and five billion agents waiting for metadata lock
Framedragger: i wonder if it's due to data type misuse, or just mysqlol
trinque: mysql's kinda notorious for this shit
mircea_popescu: on the basis of too many dorks hammering it on the www!
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: ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
Framedragger: do you still have a running mysql cli session mircea_popescu?
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
mircea_popescu: insanely, i am still getting a lot of www requests, so i guess i incidentally found some other issue here as well.
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)
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: 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
lobbes: Or rather, my process too slow heh
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)
mircea_popescu: entirely not fucking iron-bound problem in trilema case for instance. wtf can "repair table" need >1200 s !
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
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: 0 indication of what this is. will it take another 6 weeks ? "maybe". how do i tell ? what do i do ?
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!
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: 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
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
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.
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)) :)
mircea_popescu: anyway, turns out the myslq files are stored on a tiny partition for some incomprehensible reason. fancy that wonder.
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: 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.
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.
Framedragger: ^ new (trivial) command. a bunch of URLs so may be useful
Framedragger: pete_dushenski: plox to update bot commands at some point, ty! :)
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: google will definitely slurp 5mn pages in the next week-ish
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 ?
mircea_popescu: but i get tons of idiots trying to you know, spam trilema claiming to be googlebot.
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
shinohai will tweet them the trilema article along with tranny porn when trilema is back online ....
deedbot: gabriel_laddel_p voiced for 30 minutes.
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
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.
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
trinque: gabriel_laddel_p: why the FUCK would you spend any time whatsoever on doing it that way?
trinque: in this thread we listen to how gabriel_laddel_p is very special, and you don't understand me mom
shinohai: buenas tardes ben_vulpes, listo para cojer putas?
trinque: and portage is seriously one coke bump from being ported to lisp.
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: 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
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
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"
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.
jhvh1: mircea_popescu: Error: "ud" is not a valid command.
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 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
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."
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 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!
jhvh1: mircea_popescu: ERROR: 'woke whore' not defined on UrbanDictionary.
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: how are sarin death videos not in that list
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)
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)
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)
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]
shinohai: "obama :: The Messiah for brain-dead Democrats. " <<< Accurate
mircea_popescu: any ideas on probing and cutting large files ? dd freezes.
mircea_popescu: i guess i'm naive to imagine standard tools can do the job of fixing the mess standard tools created huh
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.
mircea_popescu: copied multiple 100s of gb past hours, none failed anything.
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
mircea_popescu: and in other lulz : apparently tail -n+x | head -n10 takes 4 times less than tail -nx+1 | head -n10
mircea_popescu: 111119289 tril_posts.sql << that took ~5 minutes of wc time.
mircea_popescu: apparently if you send it usr1 sig it will spit stats to stderr
a111: Logged on 2017-04-06 19:05 mircea_popescu: head doesn't work on a large file.
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.
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: 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: here's a heads-up : head has been going for ~4 minutes. i expect it to crash without output.
mircea_popescu: Framedragger bingo, "00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00"
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: 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
deedbot: gabriel_laddel_p voiced for 30 minutes.
Framedragger: mircea_popescu: hm okok. an .sql file should not contain any non-printable chars so that in itself is alarming.. weird
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.
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: 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)
Framedragger: (but output of mysqldump is *supposed* to be a set of sql statements.)
CompanionCube can't speak for mysql but knows that postgres dumps can be a mixture of text and binary data
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: 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: "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.
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 goes back to remotely setting up a lovense ....
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?
CompanionCube: in the sense that it/the dump tool produced a overly-large 40gb file?
Framedragger: i mean even if mircea_popescu aborted a db write, it shouldn't have forked into gigs of crap?..
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
mircea_popescu: and then it crashed because suddenly turning 10s of ks of article into a 3mb turd inflated the db.
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
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)
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)
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:51:27 ben_vulpes ups fromloper to great crickets
ben_vulpes: fromloper likely not even looking at browser tab anymore
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: I was hungry and I smelled smores.
fromloper: actually, I found sweet rants on clojure, and followed the crumbs.
shinohai: I'm actually impressed some fromloper finally speaks
shinohai: First one I am privy to in recent memory.
deedbot: fromloper voiced for 30 minutes.
fromloper: fromloper studies his marshmallow, admiring its gentle bronzing in the crackling fire.
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.