#dev | Logs for 2020-06-24

« return
[12:15:01] -!- MrPlow has quit [Remote host closed the connection]
[12:16:02] -!- MrPlow [MrPlow!MrPlow@Soylent/BotArmy] has joined #dev
[12:16:02] -!- MrPlow has quit [Changing host]
[12:16:02] -!- MrPlow [MrPlow!MrPlow@nsa.gov] has joined #dev
[12:18:16] -!- MrPlow has quit [Remote host closed the connection]
[12:19:02] -!- MrPlow [MrPlow!MrPlow@Soylent/BotArmy] has joined #dev
[12:19:02] -!- MrPlow has quit [Changing host]
[12:19:02] -!- MrPlow [MrPlow!MrPlow@nsa.gov] has joined #dev
[12:20:19] -!- MrPlow has quit [Remote host closed the connection]
[12:21:02] -!- MrPlow [MrPlow!MrPlow@Soylent/BotArmy] has joined #dev
[12:21:03] -!- MrPlow has quit [Changing host]
[12:21:03] -!- MrPlow [MrPlow!MrPlow@nsa.gov] has joined #dev
[18:24:37] <Bytram> PASTE_BEGIN
[18:24:38] <Bytram> mysql> select * from journals where id = 5571;
[18:24:38] <Bytram> +------+-------+---------------------+------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:24:38] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:24:38] <Bytram> +------+-------+---------------------+------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:24:40] <Bytram> | 5571 | 10059 | 2020-06-24 08:38:21 | 웹사이트먹튀유무를식별하고이를검증하는방법? | 1 | 38159 | 5 | publish | 2020-06-24 08:38:21 | 13856355601743418823 | 14456347297230438802 |
[18:24:44] <Bytram> +------+-------+---------------------+------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:24:49] <Bytram> 1 row in set (0.00 sec)
[18:24:51] <Bytram> PASTE_END
[18:33:15] <Bytram> brb
[18:36:36] -!- DECbot [DECbot!~49d12172@u-49-720-35-566.hsd2.in.comcast.net] has joined #dev
[18:38:59] <DECbot> Here's the google translate for that Korean text in the journal description: "How to identify and verify website presence"
[18:39:37] <Bytram> tyvm! here comes another...
[18:39:44] <Bytram> PASTE_BEGIN
[18:40:37] <Bytram> mysql> select * from journals where id = 5543 ;
[18:40:37] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:40:37] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:40:37] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:40:39] <Bytram> | 5543 | 10999 | 2020-06-18 04:43:01 | 온라인에서 좋은 성인용품 살 수 있는 방법? | 1 | 38063 | 5 | publish | 2020-06-18 04:43:01 | 13861473656832673439 | 14466162488688650217 |
[18:40:41] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:40:47] <Bytram> 1 row in set (0.01 sec)
[18:40:49] <Bytram> PASTE_END
[18:41:13] <DECbot> How to buy good adult supplies online?
[18:41:46] <Bytram> update journals set description = 'temporary filler' where id = 5543 ;
[18:42:16] <Bytram> mysql> update journals set description = 'temporary filler' where id = 5543 ;
[18:42:17] <Bytram> Query OK, 1 row affected (0.00 sec)
[18:42:17] <Bytram> Rows matched: 1 Changed: 1 Warnings: 0
[18:43:40] <DECbot> did you do that to 5571 as well?
[18:43:49] <Bytram> yes
[18:44:51] <Bytram> I think I found another
[18:45:48] <Bytram> PASTE_BEGIN
[18:45:53] <Bytram> mysql> select * from journals where id = 5512 ;
[18:45:53] <Bytram> +------+-------+---------------------+-----------------------------------------------------+----------+------------+-----+-------------+---------------------+---------------------+---------------------+
[18:45:53] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:45:53] <Bytram> +------+-------+---------------------+-----------------------------------------------------+----------+------------+-----+-------------+---------------------+---------------------+---------------------+
[18:45:55] <Bytram> | 5512 | 11057 | 2020-06-10 06:33:24 | 대구에서정말재밌게놀고여행하는방법 | 1 | 37949 | 5 | publish | 2020-06-10 06:33:24 | 2364766953208861743 | 2904782570389449909 |
[18:45:58] <Bytram> +------+-------+---------------------+-----------------------------------------------------+----------+------------+-----+-------------+---------------------+---------------------+---------------------+
[18:46:01] <Bytram> 1 row in set (0.00 sec)
[18:46:03] <Bytram> mysql>
[18:46:05] <Bytram> PASTE_END
[18:46:27] <DECbot> Google says: "How to have fun and travel in Daegu"
[18:47:15] <Bytram> mysql> update journals set description = 'temporary filler' where id = 5512 ;
[18:47:16] <Bytram> Query OK, 1 row affected (0.00 sec)
[18:47:17] <Bytram> Rows matched: 1 Changed: 1 Warnings: 0
[18:47:19] <Bytram> mysql>
[18:48:13] <DECbot> How lengthy of a process is it to get the 20 most recent journal entries?
[18:48:42] <Bytram> mysql> select * from journals where id = 5491 ;
[18:48:43] <Bytram> +------+-------+---------------------+----------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:48:43] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:48:43] <Bytram> +------+-------+---------------------+----------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:48:44] <Bytram> | 5491 | 10999 | 2020-06-05 09:28:36 | 섹스와 자위행위를 즐기기 위한 성인용품 종류 | 1 | 37868 | 5 | publish | 2020-06-05 09:28:36 | 13855790551144760977 | 14443064866022361455 |
[18:48:50] <Bytram> +------+-------+---------------------+----------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:48:53] <Bytram> 1 row in set (0.00 sec)
[18:48:55] <Bytram> mysql>
[18:49:26] <DECbot> Google says it's Korean again: "Types of adult products for enjoying sex and masturbation"
[18:49:40] <Bytram> mysql> update journals set description = 'temporary filler' where id = 5491 ;
[18:49:40] <Bytram> Query OK, 1 row affected (0.00 sec)
[18:49:40] <Bytram> Rows matched: 1 Changed: 1 Warnings: 0
[18:49:40] <Bytram> mysql>
[18:50:17] <DECbot> I guess rehash breaks on unicode in journal descriptions?
[18:50:34] <Bytram> this is prolly the one:
[18:50:35] <Bytram> mysql> select * from journals where id = 5470 ;
[18:50:35] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:50:35] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:50:35] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:50:38] <Bytram> | 5470 | 10184 | 2020-06-01 17:02:21 | هل تبحث عن شركة تطوير ويب معقولة | 1 | 37802 | 5 | publish | 2020-06-01 17:02:21 | 13890946169314554770 | 14450165016355844947 |
[18:50:41] <Bytram> +------+-------+---------------------+------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:50:47] <Bytram> 1 row in set (0.00 sec)
[18:50:49] <Bytram> mysql>
[18:51:21] <DECbot> Google detects Arabic: "Are you looking for a reasonable web development company"
[18:52:08] <Bytram> mysql> update journals set description = 'temporary filler' where id = 5470 ;
[18:52:09] <Bytram> Query OK, 1 row affected (0.00 sec)
[18:52:09] <Bytram> Rows matched: 1 Changed: 1 Warnings: 0
[18:52:09] <Bytram> mysql>
[18:52:59] <Bytram> Ima gonna try bouncing the servers again
[18:54:19] <Bytram> not yet; we still have issues:
[18:54:20] <Bytram> mysql> select * from journals order by date ;
[18:54:20] <Bytram> ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
[18:54:20] <Bytram> mysql> select * from journals order by date ;
[18:54:21] <Bytram> ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
[18:54:23] <Bytram> mysql>
[18:54:51] <Bytram> welll, a bounce should not hurt it any; might as well try it
[18:56:00] <Bytram> bounce complete
[18:56:29] <DECbot> still not seeing it.
[18:57:02] <chromas> Reboot all the things
[18:57:35] <DECbot> would a select * from journals where date greater than now() - duration 1 month order by date work ?
[18:58:34] -!- SoyCow0339_ [SoyCow0339_!~48e7b0c3@kmf-31-440-885-804.nycap.res.rr.com] has joined #dev
[18:59:32] <Bytram> mysql> select * from journals where id = 5464 ;
[18:59:32] <Bytram> +------+-------+---------------------+-----------------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:59:32] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[18:59:32] <Bytram> +------+-------+---------------------+-----------------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:59:33] <Bytram> | 5464 | 10059 | 2020-06-01 04:56:36 | 먹튀검증회사가온라인먹튀를판단하는데도움을주는방법 | 1 | 37791 | 5 | publish | 2020-06-01 04:56:36 | 13890946169314554770 | 14450165016355844947 |
[18:59:37] <Bytram> +------+-------+---------------------+-----------------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[18:59:40] <Bytram> 1 row in set (0.00 sec)
[18:59:42] <Bytram> mysql>
[19:00:10] <DECbot> Korean: "How to help a company that verifies online food"
[19:00:23] <Bytram> mysql> update journals set description = 'temporary filler' where id = 5464;
[19:00:23] <Bytram> Query OK, 1 row affected (0.00 sec)
[19:00:23] <Bytram> Rows matched: 1 Changed: 1 Warnings: 0
[19:00:23] <Bytram> mysql>
[19:01:04] <Bytram> mysql> select * from journals where id = 5440 ;
[19:01:04] <Bytram> +------+-------+---------------------+--------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[19:01:04] <Bytram> | id | uid | date | description | posttype | discussion | tid | promotetype | last_update | srcid_32 | srcid_24 |
[19:01:04] <Bytram> +------+-------+---------------------+--------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[19:01:05] <Bytram> | 5440 | 10184 | 2020-05-25 09:13:54 | توظيف خبراء لتطوير البرمجيات! | 1 | 37691 | 5 | publish | 2020-05-25 09:13:54 | 13890946169314554770 | 14450165016355844947 |
[19:01:09] <Bytram> +------+-------+---------------------+--------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[19:01:12] <Bytram> 1 row in set (0.00 sec)
[19:01:14] <Bytram> mysql>
[19:01:38] <DECbot> Arabic: Hiring software development experts!
[19:02:28] <DECbot> but that dates back to May... i'm pretty sure I've seen the journal box this month.
[19:03:00] <Bytram> yes, me too.
[19:03:12] <Bytram> but, I still get this:
[19:03:16] <Bytram> mysql> select * from journals order by date ;
[19:03:17] <Bytram> ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
[19:03:19] <Bytram> mysql>
[19:03:34] <chromas> Is there another stuck transaction? How's the memory usage?
[19:04:03] <DECbot> what if you minimize the search range to just the past week?
[19:04:26] <DECbot> chromas: good point
[19:04:30] <Bytram> I can look at everything sorted by id
[19:05:45] <Bytram> here is the last few days:
[19:05:50] <Bytram> | 5561 | 10593 | 2020-06-23 04:24:44 | When do you start looking for a pest control service? | 1 | 38137 | 5 | publish | 2020-06-23 04:24:44 | 13856355601743418823 | 14456347297230438802 |
[19:05:50] <Bytram> | 5562 | 11183 | 2020-06-23 08:21:47 | How You Can Spice-Up Your Sex Life? | 1 | 38138 | 5 | publish | 2020-06-23 08:21:47 | 13856355601743418823 | 14456347297230438802 |
[19:05:50] <Bytram> | 5563 | 11147 | 2020-06-23 09:13:22 | Amazing Benefits For The Lovers of Erotic Massage | 1 | 38139 | 5 | publish | 2020-06-23 09:13:22 | 13856355601743418823 | 14456347297230438802 |
[19:05:53] <Bytram> | 5564 | 11089 | 2020-06-23 09:34:42 | Get The Benefits of Sex With Erotic Massage | 1 | 38140 | 5 | publish | 2020-06-23 09:34:42 | 13856355601743418823 | 14456347297230438802 |
[19:05:57] <Bytram> | 5565 | 11186 | 2020-06-23 10:51:16 | Save Your Time With Effective Healthcare Practice Management | 1 | 38141 | 5 | publish | 2020-06-23 10:51:16 | 13856355601743418823 | 14456347297230438802 |
[19:06:01] <Bytram> | 5566 | 1683 | 2020-06-23 18:12:16 | Humanity Failed, Supplemental: Greta Thunberg is an Optimist | 2 | 38145 | 2 | publish | 2020-06-24 10:51:08 | 2312151819649974701 | 2935124563035556378 |
[19:06:05] <Bytram> | 5567 | 4318 | 2020-06-23 19:12:26 | Home-Made Router Part II | 1 | 38147 | 9 | publish | 2020-06-23 19:12:26 | 2376638947277701297 | 2917743717129935432 |
[19:06:09] <Bytram> | 5568 | 11155 | 2020-06-24 04:25:36 | Stainless steel: development and applications | 1 | 38156 | 5 | publish | 2020-06-24 04:25:36 | 13856355601743418823 | 14456347297230438802 |
[19:06:13] <Bytram> | 5569 | 9692 | 2020-06-24 07:28:35 | Foodies: gourmet experiences to live in Singapore | 1 | 38157 | 5 | publish | 2020-06-24 07:28:35 | 13856355601743418823 | 14456347297230438802 |
[19:06:19] <Bytram> | 5570 | 881 | 2020-06-24 08:01:02 | Fake Noose II: Electric Boogaloo | 1 | 38158 | 19 | publish | 2020-06-24 14:40:55 | 13846831571506549734 | 14423292323809973222 |
[19:06:23] <Bytram> | 5571 | 10059 | 2020-06-24 08:38:21 | temporary filler | 1 | 38159 | 5 | publish | 2020-06-24 18:28:11 | 13856355601743418823 | 14456347297230438802 |
[19:06:27] <Bytram> | 5572 | 10382 | 2020-06-24 09:02:14 | Show Your Style WithBraided Wigs | 1 | 38160 | 5 | publish | 2020-06-24 09:02:14 | 13856355601743418823 | 14456347297230438802 |
[19:06:31] <Bytram> | 5573 | 6957 | 2020-06-24 17:23:50 | Bye. | 2 | 38165 | 5 | publish | 2020-06-24 17:23:50 | 13897132128968391282 | 14415619512458638152 |
[19:06:35] <Bytram> +------+-------+---------------------+----------------------------------------------------------------------------------+----------+------------+-----+-------------+---------------------+----------------------+----------------------+
[19:07:04] <Bytram> chromas: how would I check?
[19:07:16] <chromas> I dunno
[19:10:08] <DECbot> googlefu suggests: https://www.percona.com
[19:10:16] <Bytram> top works... but won't hold still :/
[19:10:33] <DECbot> change sort to process name
[19:11:22] <Bytram> looks like there is plenty avail (from top)
[19:11:23] <Bytram> top - 19:08:39 up 249 days, 17:00, 4 users, load average: 0.26, 0.29, 0.26
[19:11:23] <Bytram> Tasks: 172 total, 2 running, 170 sleeping, 0 stopped, 0 zombie
[19:11:23] <Bytram> %Cpu(s): 3.0 us, 0.5 sy, 0.0 ni, 96.4 id, 0.0 wa, 0.0 hi, 0.1 si, 0.0 st
[19:11:23] <Bytram> KiB Mem: 8176636 total, 5941476 used, 2235160 free, 64192 buffers
[19:11:23] <Bytram> KiB Swap: 524284 total, 442996 used, 81288 free. 3010020 cached Mem
[19:11:23] <DECbot> it should be F6 to change top's sorting
[19:11:25] <Bytram> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
[19:11:27] <Bytram> 26550 slash 20 0 494452 144392 4268 S 10.0 1.8 0:09.44 /srv/soylentnew
[19:11:28] <Bytram> 1724 mysql 20 0 2934152 627468 8588 S 5.6 7.7 14849:22 mysqld
[19:11:30] <Bytram> 26548 slash 20 0 493380 145616 4360 S 3.0 1.8 0:15.70 /srv/soylentnew
[19:11:33] <Bytram> 26521 nobody 20 0 339608 48028 4900 S 0.3 0.6 0:02.27 varnishd
[19:11:35] <Bytram> FINIS
[19:12:25] <DECbot> is there normally 2 instances of slash running?
[19:13:07] <Bytram> I don't know.... but we do have two DB servers running with fallover
[19:13:22] <Bytram> or so I understand
[19:18:34] <DECbot> so, i'm not sure it is a recent description. I can search for journals, and get them from now to all the way back to October https://soylentnews.org
[19:19:35] <Bytram> hmmm
[19:21:05] <Bytram> DECbot: https://soylentnews.org
[19:21:43] <Bytram> gets me 30 entries going back to: On 2020.06.18 0:43
[19:22:41] * Bytram steps away for a few minutes to collect his thoughts
[19:25:41] <DECbot> I remember seeing takyon's journal from today in the box. Only two journals are newer than that.
[19:32:17] <Bytram> I checked my phone and takyon's journal entry (JE) was the newest one listed on it. "Fake Noose II: Electric Boogaloo"
[19:34:16] <Bytram> whelp, there is still the *text* oh the 2nd-most recent JE that could be an issue?
[19:34:24] <Bytram> https://soylentnews.org
[19:35:18] <DECbot> looks like harmless spam: https://translate.google.com
[19:36:39] <DECbot> does slash/rehash generate a log that might just spit out an error code?
[19:37:04] <Bytram> prolly, yes. where? Do-eyed ear
[19:37:16] <Bytram> No-eyed ear
[19:52:01] <Bytram> chromas: I do not know how to restart mysql
[19:52:41] <chromas> I think there's an init-like script wherever the instance is
[19:52:49] <chromas> But the mysqls seem to be all over the place on teh servers
[19:53:02] <Bytram> yuppers
[19:53:37] <chromas> Restart 'em all :D
[19:53:56] <DECbot> you were asking for a version of the front page with the JE box still present. I found a sleeping laptop with SN still up.
[19:54:18] <Bytram> YAY!
[19:54:24] <Bytram> what browser?
[19:54:32] <DECbot> firefox esr
[19:54:40] <Bytram> good good
[19:54:56] <Bytram> can you do a "view source"
[19:55:06] <DECbot> already there.
[19:55:14] <Bytram> DECbot++
[19:55:14] <Bender> karma - decbot: 1
[19:55:37] <Bytram> email it to me?
[19:55:38] <DECbot> journal box is div class block id top10journals
[19:55:41] <DECbot> sure
[19:55:44] <Bytram> k
[19:56:02] <DECbot> template id 192
[19:56:09] <Bytram> my nick (at) soylentnews.org
[19:56:13] <Bytram> the whole thing
[19:56:25] <DECbot> bytram or martyb?
[19:56:44] <Bytram> either, but I'd prefer the latter
[19:59:23] <DECbot> It should be on your way providing it get's through/around my ISP's SMTP server.
[20:03:05] * DECbot comparing today's page source to 6/18's page source....
[20:03:19] <DECbot> wow, the JE is completely missing
[20:03:36] <Bytram> yep
[20:03:39] <Bytram> got it
[20:03:58] <Bytram> bust for a couple minutes
[20:04:04] <Bytram> busy for a couple minutes
[20:18:12] <Bytram> DECbot: Sorry about that; wrote up a story to let the rest of the community know that we know about the problem.
[20:18:37] <Bytram> story should go live any moment
[20:23:04] <Bytram> Ugh...
[20:23:44] <Bytram> there's not a lot to go on with the template info.
[20:25:32] <DECbot> it looks like the DB is working... we can see journals in the search and with manual queries. Is there new slashcode that might be parsing the latest JE?
[20:26:04] <Bytram> nothing new
[20:27:43] <Bytram> I need to take a break; haven't really stopped since I got up this morning and I really need to take a break and also get something to eat.
[20:28:50] <DECbot> sure thing
[20:29:30] <Bytram> I truly appreciate your help!
[20:29:43] <DECbot> I'll just sit here in my arm chair and think of new ways you could try troubleshooting it when you get back :D
[20:30:36] <Bytram> BTW, the very first computer I ever used was a PDP/8 running TSS/8 over a phone line using a teletype (with paper tape!)
[20:31:13] <DECbot> nice. Mine was actually a commodore64
[20:32:00] <DECbot> Though I didn't think about it much, I just asked my father to insert such-and-such game cartage\ for me.
[20:32:57] <DECbot> The first that I actual used was a Packer Bell 286 with IBM-DOS. I never did get to use any PDPs
[20:33:42] <Bytram> your loss; they mad some nicely-engineered machines; *solid*
[20:33:53] <Bytram> s/mad/made/
[20:34:07] <Bytram> ok, really gtg;
[20:34:12] <Bytram> cul8r
[20:34:17] <DECbot> Yep, i get that feeling from how everyone talks about them
[20:34:21] <DECbot> l8r!
[20:34:26] <Bytram> thanks again!
[20:34:35] <DECbot> np
[20:42:25] <Bytram> I found some docs on the internal wiki; ran a script, but it did NOT restart mysql, so we are in the same shape as before :/