#archlinux32 | Logs for 2019-01-19

Back
[00:11:28] -!- MrBIOS has quit [Quit: MrBIOS]
[00:41:01] <buildmaster> i686/percona-server is broken (says eurobuild3).
[00:50:03] -!- oaken-source has quit [Ping timeout: 245 seconds]
[00:54:03] <buildmaster> i686/gitlab is broken (says nlopc46).
[02:46:03] -!- thePiGrepper has quit [Ping timeout: 246 seconds]
[03:03:35] -!- isacdaavid has quit [Quit: Leaving.]
[03:25:13] -!- thePiGrepper has joined #archlinux32
[03:42:58] -!- thePiGrepper has quit [Ping timeout: 245 seconds]
[03:51:18] -!- bill-auger has quit [Remote host closed the connection]
[03:55:30] -!- bill-auger has joined #archlinux32
[04:30:43] -!- thePiGrepper has joined #archlinux32
[06:07:39] -!- thePiGrepper has quit [Ping timeout: 246 seconds]
[06:34:14] -!- Dimtree has quit [Quit: Peace]
[06:51:40] -!- Dimtree has joined #archlinux32
[08:34:17] -!- oaken-source has joined #archlinux32
[09:16:48] -!- woshty has joined #archlinux32
[09:55:44] * buildmaster failed to execute a mysql query - can you have a look at "tmp.mysql-functions.query.2019-01-19T08:53:45.gnVYWe.stdin"?.
[10:13:23] -!- abaumann has joined #archlinux32
[10:13:23] <buildmaster> Hi abaumann!
[10:13:23] <buildmaster> !rq abaumann
[10:13:24] <phrik> buildmaster: <abaumann> The future looks bright, no window managers working, Xorg not working, sound and video stuff "optimized", so not working. Gives us a nice text-only distribution. :-)
[10:13:58] <abaumann> deep42thought: mmh, "I could not complete a mysql query!", it would be quite interesting to know, which one? I updates mariadb, maybe some syntax changed?
[10:14:44] <abaumann> maybe leftovers from the restart and the slave tries to reexecute a query (tmp.* files)?
[10:15:00] <abaumann> I'll run a sanity check just to make sure and I'm restarting my build slaves..
[10:17:03] * buildmaster resumes sanity.
[10:17:08] <abaumann> aha.
[10:17:16] <abaumann> buildmaster: good boy! :-)
[10:29:33] <abaumann> ERROR 1265 (01000) at line 1: Data truncated for column 'trials' at row 1
[10:29:39] <abaumann> mmh. don't like this one too much..
[10:31:10] <abaumann> well. mysql stop and start and then I loose data? you must be kidding me.
[10:34:51] * buildmaster failed to execute a mysql query - can you have a look at "tmp.mysql-functions.query.2019-01-19T09:32:36.Ssb9EF.stdin"?.
[10:37:38] <abaumann> ui. I think, I broke the buildmaster
[10:38:26] <abaumann> I didn't run mysql_upgrade
[10:39:06] <abaumann> and, I don't really have the root password for the database..
[10:44:51] * buildmaster resumes sanity.
[10:47:48] <abaumann> mmh. I hope, it runs again now..
[10:48:38] <abaumann> what kind of database allows a restart after changing internal data structure, shows a message 'please run mysql_upgrade' and merely continues eventually corrupting data?
[10:48:51] <abaumann> postgres simply doesn't start till data has been migrated..
[10:54:51] <abaumann> ok.. I'm stopping the buildmaster and mysql for now..
[10:55:13] <abaumann> ..don't know how to fix this..
[10:55:24] -!- abaumann has quit [Quit: leaving]
[11:23:43] -!- abaumann has joined #archlinux32
[11:24:32] <abaumann> fun facts of the day: if you set the stack size in systemd: a) don't set it globally, b) read the manual and don't set it to 8192 bytes but to 8192 kilobytes.
[11:25:02] <abaumann> *abaumann swears and tries to mount his libvirtd image with a qemu fuse thingy..
[11:32:42] <abaumann> only good that systemd can boot into single user mode without systemd, so I could actually reconfigre /etc/systemd configuration files.. :->
[11:35:00] <abaumann> so.. borked up too many things.. doing something practical, like cooking..
[11:35:04] -!- abaumann has quit [Quit: leaving]
[12:38:07] -!- alexandre9099 has joined #archlinux32
[12:39:32] -!- alexandre9099_ has quit [Ping timeout: 250 seconds]
[12:41:17] -!- oaken-source has quit [Quit: leaving]
[12:47:12] -!- oaken-source has joined #archlinux32
[13:26:39] -!- thePiGrepper has joined #archlinux32
[13:43:05] -!- woshty has quit [Ping timeout: 268 seconds]
[14:02:36] <buildmaster> Hi abaumann!
[14:02:36] <buildmaster> !rq abaumann
[14:02:36] -!- abaumann has joined #archlinux32
[14:02:36] <buildmaster> Hi abaumann!
[14:02:36] <buildmaster> !rq abaumann
[14:02:36] <phrik> buildmaster: <abaumann> "give developers mighty machines and trouble you have with software.."
[14:02:38] <phrik> buildmaster: <abaumann> "give developers mighty machines and trouble you have with software.."
[14:02:48] <abaumann> mmh, double buildmaster?!
[14:03:03] <abaumann> buildmaster: how many are you?
[14:03:39] <abaumann> deep42thought: I upgraded the schema of mysql and hope things run now again..
[14:34:04] * buildmaster failed to execute a mysql query - can you have a look at "tmp.mysql-functions.query.2019-01-19T13:31:38.oobWiF.stdin"?.
[14:51:02] -!- abaumann has quit [Quit: leaving]
[15:36:57] -!- deep42thought has joined #archlinux32
[15:37:05] <deep42thought> buildmaster: what's up?
[15:39:13] <deep42thought> abaumann: mysqld is not running on the buildmaster?
[15:41:18] <deep42thought> buildmaster: say something new!
[15:41:18] <buildmaster> Hi deep42thought!
[15:41:18] <buildmaster> !rq deep42thought
[15:41:18] <buildmaster> up? I'm up for 1 day, 22 hours, 1 minute, load average: 0.26, 0.18, 0.12 ... and I'm insane :-D
[15:41:18] <buildmaster> deep42thought: aect
[15:41:20] <phrik> buildmaster: <deep42thought> arch32 is on the bleeding edge of arch, which is on the bleeding edge of software?
[15:41:30] <deep42thought> ah, it's aliiiivve!
[16:13:40] * buildmaster resumes sanity.
[16:13:54] <deep42thought> \o/
[16:43:12] -!- alexandre9099 has quit [Quit: ZNC 1.7.1 - https://znc.in]
[16:56:29] -!- alexandre9099 has joined #archlinux32
[17:03:07] -!- woshty has joined #archlinux32
[17:15:49] * buildmaster failed to execute a mysql query - can you have a look at "tmp.mysql-functions.query.2019-01-19T16:13:34.YjCHNZ.stdin"?.
[17:49:03] <deep42thought> looks, like we need to fix some of my crappy mysql statements :-D
[17:49:23] <deep42thought> apparently 'ADDTIME(x, "-7 00:00:00")' did not work anymore
[17:49:38] <deep42thought> s/ADDTIME/ADDDATE/
[17:51:52] * buildmaster resumes sanity.
[17:58:55] -!- T`aZ has quit [Read error: Connection reset by peer]
[18:04:08] -!- T`aZ has joined #archlinux32
[18:15:54] <deep42thought> systemd-resolved systemd-networkd systemd-timesyncd ... I wonder, what's next ...
[18:16:27] <T`aZ> systemd-windowsd
[18:16:32] <deep42thought> hehe :-D
[18:17:10] <deep42thought> systemd-think-for-med
[18:33:03] -!- nyn has joined #archlinux32
[18:34:51] <nyn> why is my firefox package version firefox 60.0.1-1.0 when the web search lists 63 as the current version? pacman -Syu tells me there's nothing to do..
[18:35:22] <nyn> i dont get it -.-
[18:54:23] <thePiGrepper> nyn: what's your first mirror in /etc/pacman.d/mirrorlist?
[18:54:43] <thePiGrepper> you're probably using one that's not up to date.
[18:55:07] <nyn> that would be http://arch32.mirrors.simplysam.us
[18:55:20] <nyn> i have all of them uncommented though
[18:55:37] <thePiGrepper> yeah, but it doesnt work that way. it only picks the first one that connects
[18:55:48] <thePiGrepper> not necessarily the most up to date
[18:56:14] <nyn> ok i'll comment that one out and try the next one
[18:56:26] <thePiGrepper> try this one, it's the one Im currently using. http://archlinux32.vollzornbrot.de
[18:56:46] <thePiGrepper> after checking that everything is ok, you can use any other one if you prefer.
[18:57:45] <thePiGrepper> try the https:// version instead if you like. I just noticed the http one is first in mine :(
[18:58:19] <nyn> omg that was it
[18:58:28] <nyn> theres 900mb worth of updates in there
[18:58:34] <thePiGrepper> hehe. good
[18:58:43] <nyn> thank you very much
[18:58:47] <thePiGrepper> np
[19:13:01] <deep42thought> yeah, simplysam is no longer
[20:33:30] -!- abaumann has joined #archlinux32
[20:33:30] <buildmaster> Hi abaumann!
[20:33:30] <buildmaster> !rq abaumann
[20:33:31] <phrik> buildmaster: <abaumann> the better the lint tools of a language, the crappier the language ;-)
[20:33:32] <abaumann> deep42thought: I hoped, it is a SQL statement on the buildmaster, but just to make sure, I stopped it, in order not to risk data shredding. :-)
[20:33:35] <deep42thought> Hi abaumann!
[20:33:40] <abaumann> hi deep42thought
[20:33:45] <deep42thought> yeah, I saw
[20:33:49] <deep42thought> but I restarted it
[20:33:55] <deep42thought> ... in the end, we have backups :-D
[20:34:01] <abaumann> yep.
[20:34:40] <abaumann> I had to forcefully change the root password of mysqld.
[20:34:58] <abaumann> you can change it back - also with force :-)
[20:40:21] <abaumann> ok. reset.
[20:41:43] <deep42thought> thanks :-)
[20:42:22] <abaumann> ERROR 1265 (01000) at line 1: Data truncated for column 'trials' at row 1
[20:42:35] <abaumann> mmh. trials is a temporary table created by some script?
[20:42:36] <deep42thought> still?
[20:42:45] <deep42thought> no, trials is a column
[20:42:47] <abaumann> 9:42
[20:42:50] <abaumann> 19:42
[20:42:52] <abaumann> ah now.
[20:42:54] <abaumann> old logfiles. :-)
[20:42:58] <deep42thought> *phew*
[20:43:05] <abaumann> *uff*
[20:43:07] <deep42thought> I thought, I deleted them
[20:43:14] <deep42thought> ah, but not from the webserver ...
[20:43:21] <deep42thought> where are these logs?
[20:43:28] <deep42thought> in work or in /srv/http?
[20:43:34] <abaumann> work
[20:43:37] <deep42thought> :-(
[20:43:42] <deep42thought> I cleaned that one ...
[20:43:54] <abaumann> mmh.
[20:43:56] <abaumann> clean again?
[20:43:57] <abaumann> :-)
[20:44:10] <deep42thought> no, give me some time
[20:44:16] <deep42thought> they do not make the buildmaster fail
[20:44:22] <deep42thought> but it's good to repair them anyways
[20:44:26] <abaumann> ah. then it's no problem.
[20:44:31] <deep42thought> (they should have "unimportant" in the name)
[20:44:47] <abaumann> yeah. actually, they all do.
[20:44:51] <deep42thought> :-)
[20:45:21] <abaumann> sorry, for creating this mess. I should have thought something when doing the routine 'pacman -Syyu' :-)
[20:45:31] <deep42thought> nah, no problem
[20:45:42] <deep42thought> if you had waited, it would simply have failed later ;-)
[20:46:50] <abaumann> I still get 'I could not complete a mysql query!' in the slave.
[20:47:24] <deep42thought> umm, then the query is not important in the sense, that the master does not become inconsistent - but it's still unoperational
[20:47:44] <abaumann> it's at the very end, everything builds and gets pushed.
[20:47:54] <deep42thought> let me just finish these sheets of paper here and I'll take a look at the query in 15 mins max
[20:48:05] <abaumann> oh. no pressure. :-)
[20:48:06] <deep42thought> probably just some logging
[20:49:10] <abaumann> "wget: error while loading shared libraries: libidn2.so.0: cannot open shared object file: No such file or directory"
[20:49:17] <abaumann> *grmpf* I'll deal with that one.
[20:49:36] <abaumann> on i486, anyway.
[20:51:48] -!- nyn has quit [Ping timeout: 250 seconds]
[20:58:29] <deep42thought> hmm
[20:58:36] <deep42thought> I don't understand, why that query fails
[20:58:45] <deep42thought> it's reaaaaallly simple
[21:00:01] <abaumann> trials`=from_base64(xxx), base64 invalid?
[21:00:08] <deep42thought> no, it's valid
[21:00:12] <deep42thought> it has no lf
[21:00:18] <deep42thought> is that a problem now?
[21:00:22] <deep42thought> (it was not before)
[21:00:27] <abaumann> base64(MQo=) == 1, indeed.
[21:00:44] <deep42thought> ah, no
[21:00:47] <deep42thought> it _has_ a lf
[21:01:05] <deep42thought> maybe, _that_s the problem ...
[21:01:18] <abaumann> mmh. your are base64 encoding integers and strings?
[21:01:24] <deep42thought> yeah
[21:01:30] <deep42thought> everything that comes from the outside
[21:01:55] <deep42thought> yep, the lf is the problem
[21:02:08] <abaumann> ah. glad you found it. :-)
[21:04:29] <deep42thought> the base64 is a safeguard against sql injections
[21:05:32] <abaumann> never thought about that. uses a little bit too much space though.
[21:05:51] <deep42thought> hmm space?
[21:05:57] <deep42thought> it's generated on-the-fly
[21:06:12] <deep42thought> large data sets are imported by "load from file"
[21:06:35] <deep42thought> (e.g. the list of dependencies or provided install targets)
[21:06:35] <abaumann> ah. not for temp tables, yeah.
[21:06:39] <abaumann> there it is irrelevant.
[21:32:54] <deep42thought> good night!
[21:33:21] -!- deep42thought has quit [Quit: Leaving.]
[21:36:19] <abaumann> cu
[21:36:21] -!- abaumann has quit [Quit: leaving]
[22:39:24] -!- Fear has quit [Quit: ZNC - https://znc.in]
[22:40:09] -!- Fear has joined #archlinux32
[23:21:49] -!- woshty has quit [Ping timeout: 244 seconds]