#archlinux32 | Logs for 2019-10-18
Back
[00:00:05] -!- deep42thought has quit [Quit: Leaving.]
[00:18:44] -!- thePiGrepper has joined #archlinux32
[00:43:05] -!- samantaz__ has quit [Ping timeout: 276 seconds]
[00:57:37] -!- skydrome has joined #archlinux32
[01:10:23] -!- niki has quit [Ping timeout: 276 seconds]
[01:11:24] -!- niki has joined #archlinux32
[03:28:20] <buildmaster> pentium4/gitea is broken (says buildknecht): https://archlinux32.org
[03:31:46] <buildmaster> i686/gitea is broken (says rechenknecht): https://archlinux32.org
[05:06:03] -!- thePiGrepper has quit [Ping timeout: 240 seconds]
[05:38:50] -!- eschwartz has quit [Ping timeout: 276 seconds]
[05:42:06] -!- eschwartz has joined #archlinux32
[06:00:03] -!- niki has quit [Ping timeout: 240 seconds]
[07:11:25] -!- finsternis has quit [Excess Flood]
[07:11:58] -!- finsternis has joined #archlinux32
[07:40:28] -!- abaumann has joined #archlinux32
[07:40:29] <buildmaster> Hi abaumann!
[07:40:29] <buildmaster> !rq abaumann
[07:40:30] <phrik> buildmaster: <abaumann> they should have called it 'features: side-channel'
[07:40:48] <abaumann> deep42thought: aha, this makes things more clear.
[07:41:35] <abaumann> I personally don't appreciate MySql datatypes, far too many and combinations of stuff which should IMHO be handled with function-based indexes, for instance unique(tolower(name)) as an index is much more obvious that _ci :-)
[07:42:07] <abaumann> let me clone the table and play with it :->
[07:56:20] <abaumann> it looks like Postgresql has also this type of charset handling.. presumably to allow easier migration from Postgresql :->
[08:06:50] <abaumann> alter table abatest modify name VARCHAR(128) character set utf8mb4 collate utf8mb4_bin;
[08:07:14] <abaumann> does exactly the right thing. I cannot insert intel-ucode then, but I can insert INTEL-UCODE, InTeL-UCodE, etc.
[08:08:17] <abaumann> so it works for new values, the problem is old existing entries.
[08:08:41] <abaumann> we cannot have duplicates in the table as the unique condition was stronger before.. or am I missing something?
[08:09:29] <abaumann> the constraint is on name, not on to_base64(name)
[08:10:03] <abaumann> to_base64 is _not_ a hash function, so I should get exactly as many count(name) as count(to_base64(name))
[08:10:27] <abaumann> 133087 both, ok.
[08:16:24] <abaumann> if you transform name to character set utf8mb4 collate utf8mb4_bin, insert a INTEL-UCODE along to intel-ucode and then transform the column back to utf8mb4_unicode_ci, you cannot select either intel-ucode or INTEL-UCODE
[08:16:43] <abaumann> I'm astonished this actually works, because the second transformation violates the unique constraint!
[08:20:30] -!- deep42thought has joined #archlinux32
[08:20:30] <buildmaster> Hi deep42thought!
[08:20:30] <buildmaster> !rq deep42thought
[08:20:31] <phrik> buildmaster: <deep42thought> one day, some genius will prove, that all programming languages are isomorphic and there is actually only _one_ compiler
[08:20:36] <deep42thought> Hi abaumann!
[08:20:48] <deep42thought> yes, violated UNIQUE constraints was my breaking point
[08:21:13] <deep42thought> but before that, all slaves broke down due to unknown issues - I had to re-bootstrap them from a database backup
[08:22:08] <deep42thought> can one have a "UNIQUE KEY `key_name`(some_function(`column_name`))"? Is this valid?
[08:44:15] <T`aZ> is iti safe to update pentium4 yet ? :D
[08:44:58] <deep42thought> was it ever unsafe?
[08:58:27] <T`aZ> good answer, wich me luck
[09:02:36] <abaumann> morning deep42thought
[09:02:41] <abaumann> morning T`aZ
[09:03:10] <abaumann> function based constraints, yes, in a normal database this also works :->
[09:03:14] <T`aZ> hi
[09:19:44] -!- T`aZ has quit [Remote host closed the connection]
[09:22:53] -!- T`aZ has joined #archlinux32
[09:25:57] <T`aZ> well, no major breakage, thx guys :p
[09:41:47] <abaumann> ok. pcmciautils misses a dependency on sysfsutils
[09:41:54] <abaumann> otherwise it works on the 240X
[09:42:16] * abaumann remembers the problems about perf..
[09:46:52] -!- rcf has quit [Quit: WeeChat 2.4]
[09:49:07] -!- rcf has joined #archlinux32
[09:55:11] <T`aZ> qtcreator is complaining that the clangformat plugin is not compatible with current clang's libformat
[10:09:20] <T`aZ> (haven't looked further where the prob is)
[10:09:49] <abaumann> most likely it also lacks a rebuild
[10:09:57] <abaumann> there was an llvm/clang update lately
[10:10:01] <deep42thought> "it"= ...?
[10:10:52] <deep42thought> I reschduled qtcreator, lets see :-)
[10:13:07] <buildmaster> i686/linux-tools are broken (says rechenknecht): https://archlinux32.org
[10:16:55] <buildmaster> pentium4/linux-tools are broken (says eurobuild6-1): https://archlinux32.org
[10:37:20] -!- davor_ has joined #archlinux32
[10:37:37] -!- davor has quit [Ping timeout: 250 seconds]
[10:37:37] davor_ is now known as davor
[12:08:49] <buildmaster> any/subdownloader is broken (says buildknecht2): https://archlinux32.org
[12:30:44] -!- OsirisX has quit [Remote host closed the connection]
[12:52:36] -!- thePiGrepper has joined #archlinux32
[14:01:34] <buildmaster> i686/qtcreator is broken (says rechenknecht): https://archlinux32.org
[14:24:52] -!- deep42thought has quit [Remote host closed the connection]
[14:27:53] -!- nit-picker has joined #archlinux32
[14:27:54] <buildmaster> Hi nit-picker!
[14:27:54] <buildmaster> !rq nit-picker
[14:27:56] <phrik> buildmaster: <nit-picker> abaumann: but there are only 18 "intermediate" versions
[14:29:19] -!- deep42thought has joined #archlinux32
[14:29:19] <buildmaster> Hi deep42thought!
[14:29:19] <buildmaster> !rq deep42thought
[14:29:21] <phrik> buildmaster: <deep42thought> good software is like a good meal: you cannot expect to get something really good if it's done in 5 minutes ...
[14:32:47] -!- buildmaster has quit [Remote host closed the connection]
[14:34:06] -!- buildmaster has joined #archlinux32
[14:34:06] <buildmaster> !rq buildmaster
[14:34:07] <phrik> buildmaster: <buildmaster> I might be insane, but never confused ... ;-)
[14:36:51] -!- thePiGrepper has quit [Ping timeout: 240 seconds]
[14:37:20] -!- trotz has joined #archlinux32
[14:38:57] -!- thePiGrepper has joined #archlinux32
[14:47:56] <buildmaster> pentium4/virtualbox-modules-arch is broken (says buildknecht2): https://archlinux32.org
[16:21:35] -!- deep42thought has quit [Quit: Leaving.]
[16:28:52] -!- thePiGrepper has quit [Ping timeout: 265 seconds]
[17:02:43] -!- niki has joined #archlinux32
[17:02:49] <buildmaster> i686/virtualbox-modules-arch is broken (says rechenknecht): https://archlinux32.org
[18:18:06] -!- abaumann has quit [Quit: leaving]
[18:55:05] -!- thePiGrepper has joined #archlinux32
[20:32:27] -!- niki has quit [Read error: Connection reset by peer]
[20:52:07] -!- oaken-source has quit [Remote host closed the connection]
[20:58:55] -!- niki has joined #archlinux32
[21:04:39] -!- oaken-source has joined #archlinux32
[21:07:44] -!- samantaz__ has joined #archlinux32
[23:01:19] <buildmaster> i486/fingerterm is broken (says nlopc46-i486bs0): https://archlinux32.org
[23:03:44] <trotz> 2019/10/18 23:03 CRIT okeanos Home HTTP CRITICAL - Invalid HTTP response received from host on port 80: cURL returned 7 - Couldn't connect to server
[23:03:44] <trotz> 2019/10/18 23:03 CRIT okeanos Home Certificate HTTP CRITICAL - Invalid HTTP response received from host on port 443: cURL returned 7 - Couldn't connect to server
[23:04:44] <trotz> 2019/10/18 23:04 CRIT okeanos Home Secure HTTP CRITICAL - Invalid HTTP response received from host on port 443: cURL returned 7 - Couldn't connect to server
[23:13:44] <trotz> 2019/10/18 23:13 OK okeanos Home HTTP OK: HTTP/2.0 200 - 22300 bytes in 2.000 second response time
[23:13:44] <trotz> 2019/10/18 23:13 OK okeanos Home Certificate OK - Certificate 'archlinux32.org' will expire on Thu 02 Jan 2020 11:46:21 PM GMT +0000.
[23:14:44] <trotz> 2019/10/18 23:14 OK okeanos Home Secure HTTP OK: HTTP/2.0 200 - 22069 bytes in 1.990 second response time
[23:16:51] -!- thePiGrepper has quit [Ping timeout: 240 seconds]
[23:17:57] -!- thePiGrepper has joined #archlinux32
[23:31:17] <buildmaster> i686/linux-lts are broken (says eurobuild6-3): https://archlinux32.org