ejabberd - Tuesday, July 17, 2018

ejabberd

Tuesday, July 17, 2018< ^ >

zinid has set the subject to: ejabberd discussions: https://docs.ejabberd.im

Room Configuration

Room Occupants

GMT+0
[00:07:27] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[00:08:02] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[00:16:21] zash leaves the room: Disconnected: closed
[00:16:23] ta leaves the room
[00:17:47] zash leaves the room: Disconnected: closed
[00:18:55] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[00:22:55] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[00:25:29] carlos leaves the room
[00:45:16] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[00:46:59] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[00:47:29] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[01:02:09] zash leaves the room: Disconnected: closed
[01:02:13] zash leaves the room
[01:02:39] zash leaves the room
[01:03:40] genofire leaves the room: Machine going to sleep
[01:06:09] carlos leaves the room
[01:08:30] zash leaves the room: Disconnected: closed
[01:17:16] xinit leaves the room
[01:22:19] zash leaves the room: Disconnected: No route to host
[01:23:46] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[01:30:04] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[01:40:57] beri leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[01:41:41] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[01:48:21] ta leaves the room
[01:51:13] xinit leaves the room
[02:01:13] mrDoctorWho leaves the room
[02:10:24] ave leaves the room: Stream closed by us: system-shutdown
[02:15:07] xinit leaves the room
[02:15:22] alexis leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[02:16:08] marek leaves the room: Machine going to sleep
[02:16:50] marek leaves the room: Machine going to sleep
[02:17:23] marek leaves the room: Machine going to sleep
[02:18:33] marek leaves the room: Machine going to sleep
[02:20:04] marek leaves the room
[02:21:48] marek leaves the room
[02:22:16] marek leaves the room
[02:22:27] marek leaves the room: Machine going to sleep
[02:23:25] marek leaves the room
[02:24:51] <Alacer> > Licaon_Kter, no, auto creation of SQL tables on startup
zinid: 👍...
[02:25:02] marek leaves the room
[02:25:11] marek leaves the room: Machine going to sleep
[02:26:47] marek leaves the room
[02:28:34] xinit leaves the room
[02:30:53] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[02:31:43] Alacer leaves the room
[02:35:01] zinid leaves the room: Stream closed by us: Replaced by new connection (conflict)
[02:44:26] <Alacer> zinid: Thanks Man... I believe this was much required in even personal Server due to MAM...
[02:47:29] genofire leaves the room: Machine going to sleep
[02:49:18] xinit leaves the room
[03:05:32] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[03:25:25] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[03:26:30] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[03:36:24] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[03:42:01] aditya_borikar leaves the room: Stream closed by us: Replaced by new connection (conflict)
[03:47:52] xinit leaves the room
[03:48:02] Alacer leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[03:48:29] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[03:51:56] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[04:04:09] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[04:05:01] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[04:05:14] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[04:26:11] ludo leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[04:27:21] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[04:35:48] xinit leaves the room
[04:37:40] deavmi leaves the room
[04:42:15] xinit leaves the room
[04:47:25] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[04:49:54] mimi89999 leaves the room
[04:52:24] xinit leaves the room
[04:52:55] nekit leaves the room: Stream closed by us: Replaced by new connection (conflict)
[04:54:48] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[04:56:49] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:01:38] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:02:00] <zinid> af: ProcessOne is actually a French company, so we have plenty of French translators 😁
[05:02:23] <bowlofeggs> bonjour
[05:05:35] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:08:28] <Licaon_Kter> bowlofeggs: `le` bonjour 🙄
[05:09:19] jere leaves the room
[05:09:59] vogt leaves the room: Stream closed by us: Replaced by new connection (conflict)
[05:10:08] <bowlofeggs> :)
[05:12:32] xinit leaves the room
[05:13:43] nekit leaves the room
[05:14:28] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:14:59] <zinid> Licaon_Kter: thank gods we don't have these stupid articles 😁
[05:15:31] <zinid> Article is a really pointless grammar unit
[05:16:20] <Licaon_Kter> zinid: I guess
[05:26:21] xinit leaves the room
[05:39:36] xinit leaves the room
[05:45:12] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:51:04] Licaon_Kter leaves the room: Stream closed by us: Replaced by new connection (conflict)
[05:52:15] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:53:48] rom1dep leaves the room: Stream closed by us: Replaced by new connection (conflict)
[05:56:11] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[05:56:41] <zinid> Holger, sorry, I'm gonna ditch old sql schema
[05:57:12] xinit leaves the room
[05:57:12] <zinid> Holger, starting from the next release there will be a warning
[05:59:20] <zinid> maintaining both is too complex
[06:01:47] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:04:02] paul is now known as paul/paul
[06:04:17] aditya_borikar leaves the room
[06:06:59] <rom1dep> > we have plenty of French translators
But is there an actual French translation? 😁
[06:08:14] <zinid> of what?
[06:08:43] <rom1dep> Dunno
[06:08:57] <rom1dep> The documentation?
[06:09:07] <rom1dep> Or anything in ejabberd, really?
[06:09:12] <zinid> no, only ejabberd messages ;)
[06:09:45] <zinid> https://github.com/processone/ejabberd/blob/master/priv/msgs/fr.po
[06:10:28] <rom1dep> Cool
[06:13:26] debalance leaves the room
[06:16:20] <zinid> rom1dep, can you please remind me what problems with sqlite you had?
[06:16:37] <zinid> rom1dep, I did some load testing and seems like sqlite works pretty fine
[06:17:24] <rom1dep> zinid: I had db time-outs every now and then
[06:17:43] <zinid> on RPi? :)
[06:17:46] <rom1dep> Bad IO on that server, I guess it isn't too good at caching
[06:17:51] <rom1dep> Atom
[06:18:11] <zinid> so do you think this was a problem of bad i/o or that was a bug in sqlite?
[06:18:22] <zinid> in sqlite driver
[06:18:49] <zinid> because you're the one who told me about such problems in sqlite
[06:21:21] <rom1dep> Bad IO I'd say
[06:21:49] <zinid> okay
[06:22:02] <zinid> then I'll finally go for sqlite as the default db in ejabberd
[06:22:09] <rom1dep> Not much ejabberd could do about, except maybe bumping the timeout
[06:22:51] <rom1dep> Good move, will bite less people than mnesia down the line
[06:23:25] mimi89999 leaves the room
[06:23:48] tester leaves the room
[06:24:34] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:27:46] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[06:27:52] bowlofeggs leaves the room
[06:31:22] madmalkav leaves the room
[06:31:24] aditya_borikar leaves the room: Stream closed by us: Replaced by new connection (conflict)
[06:33:25] <marek> > also, no need to read upgrade nodes, it will alter tables automatically
👍
[06:36:10] nekit leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:39:01] jannic leaves the room
[06:42:28] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:45:11] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:49:38] bowlofeggs leaves the room
[06:49:56] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:50:29] tester leaves the room
[06:50:53] <Alacer> zinid:
> okay
> then I'll finally go for sqlite as the default db in ejabberd
Bravo... Finally...
[06:55:43] <Alacer> zinid: So would the schema in SQLite be consistent  for other SQL DBs...
[06:56:04] <zinid> sure
[06:56:09] <zinid> it is now actually
[06:56:58] <Alacer> zinid: 👍...
[06:57:15] fp leaves the room: Stream closed by us: Replaced by new connection (conflict)
[06:57:31] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:02:18] rom1dep leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:04:57] mrDoctorWho leaves the room: Disconnected: Replaced by new connection
[07:07:49] xinit leaves the room
[07:08:15] Marzanna leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:09:29] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:14:10] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:15:02] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:16:02] tester leaves the room
[07:18:39] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:19:21] fp leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:19:24] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:21:42] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:23:46] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:25:25] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:26:07] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:26:30] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:27:05] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:28:05] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:28:25] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:29:01] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:29:54] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:36:25] beri leaves the room
[07:39:44] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:41:22] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:42:52] xinit leaves the room
[07:43:12] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:44:30] Alacer leaves the room
[07:48:54] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:50:36] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[07:52:46] <Holger> > Holger, sorry, I'm gonna ditch old sql schema
😱
[07:52:47] debalance leaves the room
[07:52:50] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[07:52:51] <Holger> That's gonna be fun.
[07:52:57] <Holger> But yes, cool stuff.
[07:56:41] daniel leaves the room
[07:58:47] adrien leaves the room
[07:58:59] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:02:15] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:04:11] ulrich leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:12:20] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:14:27] srgcdev leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:15:50] aditya_borikar leaves the room
[08:19:20] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:19:31] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:21:23] xinit leaves the room
[08:25:03] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:27:00] <mightyBroccoli> Zinid will your new MySQL updater help with the upgrade to the new schema?
[08:27:14] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:27:15] <zinid> mightyBroccoli, yes, I'm on it right now
[08:27:59] <mightyBroccoli> Awesome 👍 thank you
[08:29:09] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:30:53] aditya_borikar leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:32:34] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:33:08] Andrew Nenakhov leaves the room: Connection failed: connection closed
[08:33:40] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:34:41] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:35:23] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:35:47] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:36:11] <Holger> [info] Auto-upgrading your schema, this can take a few weeks ... 🙂
[08:38:17] cromain leaves the room
[08:39:32] sindrake leaves the room
[08:39:57] sindrake leaves the room
[08:41:11] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:43:34] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[08:45:35] <Licaon_Kter> mightyBroccoli:
[08:46:16] xinit leaves the room
[08:48:47] Dominik Paulus leaves the room: Machine going to sleep
[08:49:10] sindrake leaves the room
[08:54:13] spicewiesel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[08:57:37] xinit leaves the room
[08:59:01] Akasch leaves the room: Disconnected: Replaced by new connection
[09:03:12] 4223 leaves the room
[09:04:23] <rom1dep> Holger: few weeks? ^^
[09:05:11] <Holger> Dunno whether weeks but I'd imagine this to take ages if you have some GB worth of SQL data.
[09:05:16] Dominik Paulus leaves the room: Machine going to sleep
[09:06:36] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:09:29] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:10:07] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:11:13] sindrake leaves the room
[09:14:34] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:14:36] zash leaves the room: Disconnected: No route to host
[09:15:22] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:19:13] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:19:39] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:20:11] Andrew Nenakhov leaves the room: Connection failed: connection closed
[09:20:24] <zinid> mod_admin_update_sql doesn't work
[09:20:26] <zinid> at all
[09:20:30] <zinid> what the fuck...
[09:22:19] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:24:06] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:24:29] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:25:07] rom1dep leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:25:39] secret_agent leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:26:18] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:28:24] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:34:42] Andrew Nenakhov leaves the room: Connection failed: connection closed
[09:44:28] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:44:39] Andrew Nenakhov leaves the room: Connection failed: connection closed
[09:49:55] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:53:54] genofire leaves the room
[09:53:54] genofire leaves the room
[09:53:54] genofire leaves the room
[09:57:28] fp leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[09:57:46] Andrew Nenakhov leaves the room: unknown reason
[09:57:46] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[09:57:48] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:00:52] robert_mobil leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:01:51] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:06:59] Andrew Nenakhov leaves the room: unknown reason
[10:07:05] Man_Life leaves the room: Logged out
[10:13:05] vanitasvitae leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:13:45] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:19:27] daniel leaves the room
[10:19:43] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:19:53] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:20:20] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:24:43] 404 leaves the room: Machine going to sleep
[10:25:25] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:31:16] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:32:16] xinit leaves the room
[10:33:17] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:33:56] ta leaves the room
[10:34:18] cippaciong leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:39:24] debalance leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:39:53] <zinid> mysql> ALTER TABLE users ADD COLUMN server_host text NOT NULL DEFAULT 'zinid.ddns.net';
ERROR 1101 (42000): BLOB/TEXT column 'server_host' can't have a default value
[10:40:00] <zinid> use MySQL they said
[10:42:02] <zinid> https://bugs.mysql.com/bug.php?id=21532
[10:42:11] <zinid> a bunch of retards
[10:43:01] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:43:52] rom1dep leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:44:59] <zinid> as a developer I just hate MySQL
[10:45:15] <zinid> it's borked in so many ways
[10:45:51] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:45:58] <Holger> Isn't that just because you develop against Postgres and then stuff fails against MySQL?  I.e. you'd rant about stuff failing on Postgres if you went the other way round?
[10:47:17] <Licaon_Kter> > https://bugs.mysql.com/bug.php?id=21532
I guess that everyone switched to postgres in these 12 years already 🤷
[10:48:35] ThUnD3r|Gr33n® leaves the room
[10:48:46] <zinid> Holger, I don't, that's just an observation
[10:49:02] <zinid> Holger, most of the time I spend fighting with mysql, not pgsql or sqlite
[10:49:08] <Holger> I see.
[10:50:36] <zinid> Holger, did you see all those varchar(191) in mysql schema?
[10:50:48] <zinid> this is clearly a limitation of mysql, whaterver engine you love
[10:51:03] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:51:31] <bowlofeggs> Holger: mysql is awful - it goes out of its way to do SQL incorrectly
[10:51:37] nekit leaves the room
[10:51:43] <bowlofeggs> which i think makes its name make sense - "my" sql - not the one from the spec!
[10:52:04] <bowlofeggs> there are some hilarious videos that show a mysql console and pgsql console side by side and running the same queries
[10:52:15] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:52:16] <bowlofeggs> and postgres does what you think and mysql finds ways to be completely insane
[10:52:52] <bowlofeggs> i myself had a bug in my code years ago that accidentally queried mysql on a table for pk = NULL
[10:52:53] spicewiesel leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:53:07] <bowlofeggs> and it returned something, even though no such record actually existed
[10:53:21] <bowlofeggs> so the web app in question happily displayed incorrect data
[10:53:45] <bowlofeggs> of course, that was a bug in my code, but it was curious to me that mysql would return a record when i asked for pk NULL when pk was required not null
[10:53:51] <bowlofeggs> so i filed a bug against it
[10:54:01] <bowlofeggs> they closed it as "working as intended" because that was a "feature"
[10:54:06] Andrew Nenakhov leaves the room
[10:54:11] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[10:54:18] <bowlofeggs> they say that asking for pk NULL means you want to know the result of the most recent query
[10:54:26] <bowlofeggs> which is bonkers, just absolutely bonkers
[10:54:34] <Holger> zinid: I don't know why we have those varchar(191)?
[10:54:35] <bowlofeggs> anyways, pgsql returns no result if you do that same query
[10:54:41] <bowlofeggs> mysql--
[10:55:14] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:55:27] <Holger> bowlofeggs: Yes I'm aware MySQL cares less about standards-compliance but this might not be the only criterion (or any at all) from an admins perspective.
[10:56:27] <bowlofeggs> i'm having trouble digging up the hilarious video i once found but it was great
[10:56:52] <bowlofeggs> Holger: fair enough
[10:57:09] <Holger> I'm not a MySQL fanboy at all, I'm just clueless and interested in the actual pros and cons apart from query syntax foo.
[10:58:11] <bowlofeggs> i think their blatant disregard for the standard (and for that issue i reported) does demonstrate a cultural problem with the project that i find concerning
[10:58:41] <bowlofeggs> but i'm not an admin so can't really comment from that perspective
[10:59:11] bowlofeggs leaves the room: Stream reset by peer
[10:59:15] <edhelas> 2018, people still using MySQL
[10:59:50] <MattJ> I wanted to drop support for MySQL from Prosody, so I did a survey and it turned out the most popular choice :(
[11:00:35] <zinid> Holger, because mysql has a limit for an index length
[11:00:56] <zinid> and 191 is a magic number :D
[11:02:16] <Holger> zinid: But we could of course use much larger varchar fields even with length-limited index?  I'd assume you'd usually want to limit the index length anyway ...
[11:03:28] <zinid> Holger, well, for example for node/server part it's 1024
[11:03:30] bammes leaves the room
[11:03:42] <zinid> And mysql sucks here
[11:03:45] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:04:08] <edhelas> zinid I have exactly the same limitation in Movim
[11:04:20] <edhelas> that's also why I'm not supporting anymore old versions of MySQL
[11:04:38] <Holger> Because the index length is limited?!
[11:04:42] <Holger> This doesn't make sense to me.
[11:05:36] <edhelas> yup there was a really low limitation for the size of the indexes
[11:05:40] <edhelas> MySQL 5.7 or higher with utf8mb encoding
MariaDB 10.2 or higher with utf8mb encoding
[11:06:11] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:06:17] <Holger> And then the lookup was too slow because this limited the usefulness of the index or what?
[11:06:30] <Holger> I think 191 is way more than we ever need in practice :-)
[11:07:08] <edhelas> I have different way of doing things in Movim, and I needed those extra index lenght
[11:07:17] <Holger> I would've thought something between 10 and 20 would be more than enough for our use cases.
[11:07:18] <Holger> Ah.
[11:07:23] <Holger> Whatever.
[11:07:26] <edhelas> :p
[11:08:11] <edhelas> but looks like someone is adding SQLite support https://github.com/JKingweb/movim/tree/sqlite :D Maybe I can drop MySQL for SQLite
[11:08:30] <Holger> I mean I understand the point if you have tons of strings with a large identical prefix.  But we just don't.
[11:10:06] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:10:48] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:14:53] <zinid> Holger, for pubsub nodes? Kinda, "node:stuff:other:x:y"
[11:15:09] <zinid> so if they have the same prefix and out of 191 then you're fucked
[11:15:23] <zinid> so we kinda may face this limitation
[11:17:10] rom1dep leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:17:18] <Holger> urn:xmpp:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:bar:foo:now-we-are-fucked
[11:17:26] <prefiks> i always liked how mysql handled utf8, it assumed that 4 bytes codepoints are too extravagant so it just stored 3 bytes max, but unfortunatelly for them emojis started to be used ;)
[11:17:44] <edhelas> :p Movim can create quite long node names as well
[11:17:50] <edhelas> especially with 0277 and the comments
[11:18:01] <Holger> It's not about long node names but long identical prefixes.
[11:18:02] <zash> I especially like how a string with emoji gets silently cut off at that point
[11:18:36] <Holger> Tons of node names with long identical prefixes.
[11:18:55] <zinid> ah, we even have some bug report about cut-off, Holger would you please fix it? :)
[11:19:12] <Holger> zinid: Sounds like something unrelated?
[11:19:25] <zinid> Holger, sounds like retarded mysql limitation
[11:19:27] <Holger> zinid: Or do we have one regarding *index* lenght?
[11:19:41] <zinid> Holger, I don't know, but there is some mysql limitation for sure
[11:20:04] <zinid> myshit is not only limited to index limits ;)
[11:20:07] <Holger> zinid: Maybe.  As I said I'm not a fanboy at all, just interested in *relevant* reasoning which you guys didn't come up with so far :-P
[11:21:05] <zinid> the point is while pgsql and sqlite work, mysql hiccups
[11:21:05] <Holger> varchar length limit is 65k which is can be a problem indeed I guess.
[11:21:26] <Holger> zinid: Yah sorry that's actual reasoning.
[11:22:41] <Holger> E.g. we use the 'text' for the 'xml' and 'txt' fields of the archive table, that's limited to 64k as well, I ran into it myself.
[11:22:49] <Holger> Not sure why we don't use 'longtext' ...
[11:23:06] <Holger> *the 'text' type ...
[11:26:24] <zinid> because of copy pasting?
[11:26:28] af leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:26:42] <zinid> text is in all other schemas
[11:27:03] <zinid> and nobody cared to google about yet another mysql limitation ;)
[11:27:26] <Holger> Ah yes I see it's unlimited in Postgres.
[11:28:19] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:29:38] ta leaves the room
[11:30:52] <Holger> Maybe we should just switch to Postgres if we need to move to the new schema anyway.
[11:30:58] <Holger> So people stop laughing about me.
[11:31:53] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:32:33] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:35:54] <bammes> Holger, if you do so, let me know how you managed to do this
[11:35:54] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:36:01] <prefiks> btw that 191 limit is from being biggest integer that is lower than 768/4 (index can have 768 bytes max, and codepoint can have upto 4 bytes), if you are using only codepoints that can fit in 1 byte you can increase that value
[11:36:40] mightyBroccoli leaves the room: Rechner geht in den Ruhezustand
[11:37:36] <Holger> Yeah: https://dev.mysql.com/doc/refman/8.0/en/innodb-restrictions.html
[11:39:08] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:40:01] Marzanna leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:40:30] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:40:37] zash leaves the room: Disconnected: No route to host
[11:41:31] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:41:32] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:41:45] <Holger> bammes: My main concern would be the time it takes if you have non-trivial amounts of data.  But maybe it's doable if you switch without converting the MAM table and then fill that up during normal operation after switching.
[11:43:09] <Holger> Or, well, switch with just the past 48 hours worth of MAM data or something.
[11:43:11] alexis leaves the room
[11:43:44] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[11:44:01] zinid leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:44:01] zinid leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:44:26] alexis leaves the room
[11:47:34] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:49:28] sindrake leaves the room: Disconnected: Replaced by new connection
[11:53:17] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:04:01] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:05:01] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:07:29] Licaon_Kter leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:07:49] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:10:12] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:12:15] zash leaves the room: Disconnected: closed
[12:21:35] flow leaves the room
[12:23:23] beri leaves the room
[12:25:27] jere leaves the room: Disconnected: Replaced by new connection
[12:28:38] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:29:14] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:32:19] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:37:31] zash leaves the room: Disconnected: closed
[12:39:22] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:42:21] flow leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:50:14] sindrake leaves the room
[12:50:24] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:52:36] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:53:08] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:54:53] zinid leaves the room: Stream closed by us: Replaced by new connection (conflict)
[12:57:04] ChaosKid42 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[12:58:18] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:01:09] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:07:30] tester leaves the room
[13:07:55] sindrake leaves the room: Rechner geht in den Ruhezustand
[13:11:14] <Alacer> Guy correct me but I think Performance wise MySQL is better than PostgreSQL. So impact on MAM performance ... but I am not up to date on this as of 2018...
[13:11:53] <Alacer> Signal uses PostgreSQL by the way if I am not mistaken
[13:12:13] <zinid> Alacer: no, in my tests pgsql is faster, at least with ejabberd
[13:13:44] <Holger> General consensus seems to be that it depends on workload.
[13:14:19] <Alacer> zinid: thx... By the way what would be your recommendation for SQLite DB file size...
[13:14:37] <Holger> MySQL's caching might be better than Postgres' shared_buffers ...
[13:14:53] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:14:54] <Alacer> > General consensus seems to be that it depends on workload.
I am just worries about MAM Catchup...
[13:15:27] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:16:19] <Holger> Alacer: Our experience was that you want to make sure the cache is large enough to at least hold the full archive table index, I'd guess that's true for Postgres as well.
[13:16:33] <Holger> Alacer: Not sure you want SQLite if you're worried about performance?
[13:17:55] <Holger> https://www.quora.com/Why-prefer-MySQL-over-PostgreSQL/answer/Greg-Kemnitz
[13:20:02] <Alacer> Holger: I think for the same classical case of ease of use/management vs Performative but less open/propriety then SQLite may be worth... But yes in case of full DBMS issues like Indexing, Caching etc. Arise. Look at WhatsApp they are also using some caching mechanism
[13:20:58] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:21:33] pztrn leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:22:55] <Holger> According to https://github.com/reedr/reedr/blob/master/slides/efsf2014-whatsapp-scaling.pdf they're doing weird shit with Mnesia.
[13:23:59] <edhelas> Mnesia is already weird
[13:25:39] spicewiesel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:25:52] <Alacer> Ya..by the way Erlang Solutions Supported them in it...  Erlang Solutions with their Mongoose IM provide a caching solution as well I believe as I saw it once on Enterprise. but it's not usually downloadable
[13:26:10] zash leaves the room: Disconnected: closed
[13:26:12] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:26:17] <zinid> > MySQL's caching might be better than Postgres' shared_buffers ...
And? It still takes milliseconds to lookup
[13:26:38] <zinid> So it's still shit and the main bottle-neck
[13:26:44] <Holger> zinid: Nothing will beat your caching :-)
[13:29:04] <Holger> Though the other day you said that using a Unix Domain Socket rather than TCP would already help quite a bit (more than I expected)?
[13:29:36] <zinid> Holger: our SQL drivers don't support it, so who knows
[13:29:42] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:32:49] cippaciong leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:37:35] <Alacer> zinid: So would you be using the same Ejabberd based on SQLite for your IoT Clients
[13:37:56] <zinid> Alacer: of course not
[13:38:09] <Alacer> zinid: Reasons
[13:38:23] <zinid> sqlite is for localhosts
[13:38:38] <zinid> You cannot use it in clustering
[13:39:05] <zinid> Not to mention that we don't use SQL in production, at least on SaaS platform
[13:39:36] <Alacer> So Correct me. Mnesia would continue but SQLite would only be default. And what do you use on SaaS Platform??
[13:39:48] <zinid> Yes
[13:40:06] <zinid> We use our own hand made database
[13:41:38] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:41:42] <zinid> It's embedded into ejabberd, so queries are very fast (few microseconds) and it supports optimistic replication and anti entropy in background
[13:42:22] <zinid> No existing databases provide all this properties
[13:43:37] adrien leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:43:37] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:45:10] <Alacer> So your Boss is up for Vendor/OEM Lock... :)
[13:46:32] <zinid> Alacer: wut? Do you think we wanted to write a database? That's just because there is nothing at the market, because database development degraded just as the whole IT
[13:46:37] Andrew Nenakhov leaves the room: Connection failed: connection closed
[13:48:22] pod leaves the room
[13:48:58] edhelas leaves the room: Connection failed: timeout
[13:50:45] <af> So the database is GPL-licensed or so ?
[13:50:48] edhelas leaves the room: Stream reset by peer
[13:51:34] <zinid> af: I don't even think it has a license because strictly speaking we don't provide it's copies
[13:53:03] <af> zinid: I thought you were talking about ejabberd, sorry
[13:53:16] <zinid> No
[13:53:42] vanitasvitae leaves the room
[13:55:34] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[13:55:36] zuglufttier leaves the room
[13:58:34] debalance leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:59:50] <zinid> edhelas: people in conversations muc are ranting about movim design 😁
[13:59:59] debalance leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:00:32] Alacer leaves the room
[14:02:42] <Alacer> zinid: Man I am enjoying it as per the standard IT terms. Yup I can understand the performance issues as XMPP is not binary.... Also alot of IQ Messages
[14:03:04] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:03:05] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:04:03] <zinid> Alacer: the problem is that you need to perform dozens of database lookup while the stanza is in transit
[14:04:49] <zinid> And when you have a clear customer requirement: 10k stanza per second
[14:04:58] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[14:04:59] <zinid> What will you do?
[14:06:17] jere leaves the room
[14:06:35] <zinid> Let's say an average SQL request delay is 1ms, so for this rate the total delay will be 10 seconds, but we need to fit into one!
[14:07:43] <zinid> And it's assuming that only one SQL lookup is performed for a stanza
[14:09:06] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:10:49] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:11:17] 4223 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:11:46] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:12:11] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[14:13:43] mightyBroccoli leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:16:52] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:19:56] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:20:12] <edhelas> zinid in conversations@conference.siacs.eu ?
[14:20:33] <zinid> Yep
[14:20:47] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:22:52] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:26:47] Andrew Nenakhov leaves the room
[14:27:51] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:29:07] <Alacer> zinid: That's where MemCahe and other caching techniques come into play. Also SSD vd HDD and network card offloading engines plus raid controller performance. A Developer can optimize to an extent. But I think SQLite won't be bad for lets say few Users and PostgreSQL could be scaled but again PostgreSQL Clusters performance. We have Oracle 12 Cluster and besides using Unix based special hardware we had to spend quite a bunch of money on 10g network interconnect... Still I get nightmares during day peak loads
[14:30:40] <zinid> > zinid: That's where MemCahe and other caching techniques come into play. Also SSD vd HDD and network card offloading engines plus raid controller performance.
What will be the delay? That's simple math
[14:31:37] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[14:31:53] <zinid> Can you do 10 microseconds with memcached?
[14:32:02] <zinid> That's funny actually
[14:32:31] <zinid> The answer is of course you cannot, multiply that by 10
[14:32:36] <zinid> Best case
[14:42:21] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[14:45:33] <Alacer> > The answer is of course you cannot, multiply that by 10
> Best case
Well we have real time data coming in from Plant   even some thousand values being archived at 1 millisecond. So yes not micro but thousands of commits matter
[14:48:16] Marzanna leaves the room
[14:48:28] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[14:49:57] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[14:52:52] <zinid> We don't
[14:54:29] <zinid> The only solution to resolve the problem with existing shitty databases is to add MOAR nodes. But in this case we lose market competition, because we should increase price proportionally
[14:55:17] <zinid> That's what I am trying to say
[14:55:38] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:00:08] <Alacer> zinid: ... Ya... possible solution.... But let me Introduce you to a new technology that can give you market edge. It simple called Block Chain with Proof Of Work Algorithm.... it verifies every commit and could store unlimited history. Nothing like this... even the D Day problems gets Solved and Martians have already been using it for a Dacade.... 😜😝😂😁😀
[15:00:32] Alacer leaves the room
[15:01:36] <zinid> > unlimited history
The funniest part 😁
[15:01:52] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:04:12] <bowlofeggs> lol
[15:04:20] ChaosKid42 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:04:23] <bowlofeggs> don't forget to throw AI in there too
[15:06:15] daniel leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:06:53] aditya_borikar leaves the room
[15:09:55] <zinid> AI hype is amusing: basically collect as much data as possible (fuck GDPR), feed into well know algorithm from 1980, call it an INNOVATION
[15:10:46] zash leaves the room: Disconnected: closed
[15:10:56] <bowlofeggs> hahah
[15:11:18] <zinid> It's becoming even more funny when you know that Boston Dynamics don't use any AI for their robots
[15:11:56] pod leaves the room
[15:12:12] fp leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:12:22] genofire leaves the room
[15:12:31] <bowlofeggs> never let the truth get in the way of a good story
[15:12:33] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:13:16] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:13:19] sindrake leaves the room: Rechner geht in den Ruhezustand
[15:14:59] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:16:22] 404 leaves the room: Machine going to sleep
[15:16:43] <zinid> I remember that discussion where people fell into cognitive dissonance when they learnt how Boston Dynamics write their software, LOL
[15:17:10] <zinid> Every other commenter suggested them to start using AI immediately
[15:17:22] <zinid> Damn, that was a hilarious thread
[15:18:28] <Alacer> No to forget In-memory Database. We are now having SAP Hana being Implemeted... I think the Consultants want to tell us that In-memory Database is like ...... But it has its own use cases and Deep Learning/ AI is also the best use case like these things didn't existed prior to In-memory.....
[15:19:20] <zinid> Alacer: good weed, dude 👍
[15:19:49] <Alacer> Xmpp is a nice place to Troll about some S_ _ _  tech sales Buzz...
[15:20:58] <Alacer> By the way in the letest updates in iIoT Industry is to go back to edge node model as having alot of data Centralized makes no Sense... So the fortunate 500 are now like... Jac_ _$
[15:22:13] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:22:44] adrien leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:23:08] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:23:20] <Alacer> and by Edge Node ... Now get ready to bet your money in stock market for a new startup that would make SQlite Fly like unicorns
[15:23:32] Dominik Paulus leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:24:42] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:24:53] avb leaves the room
[15:25:06] mightyBroccoli leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:28:12] genofire leaves the room: Machine going to sleep
[15:28:13] <zinid> Didn't know 🦄 can fly
[15:29:02] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:30:04] <ThUnD3r|Gr33n®> zinid:  what the hell?
[15:30:04] <ThUnD3r|Gr33n®> Of course it can!
[15:30:33] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:34:13] mightyBroccoli leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:36:34] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:37:48] zash leaves the room: Disconnected: closed
[15:41:08] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:42:26] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:43:58] <Alacer> ThUnD3r|Gr33n®: Don't Take it this way please....
[15:44:08] ThUnD3r|Gr33n® leaves the room
[15:44:49] zash leaves the room: Disconnected: closed
[15:45:10] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:53:24] spicewiesel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[15:54:21] sindrake leaves the room: Disconnected: Replaced by new connection
[15:54:26] carlos leaves the room
[15:55:40] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[15:57:27] zash leaves the room: Disconnected: closed
[15:59:43] ta leaves the room
[16:00:31] sindrake leaves the room
[16:01:50] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:03:48] zash leaves the room: Disconnected: closed
[16:06:48] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:09:21] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:09:55] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:15:29] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:17:03] mightyBroccoli leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:18:33] <af> AFAIK, there are Japanese unicorns that are more like rinoceros with poisoned horns and they're super dangerous (they can't fly)
[16:19:27] <af> But we could put them on the blockchain, that would make a hell of a commercial name
[16:20:41] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:20:55] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:21:13] zash leaves the room: Disconnected: closed
[16:22:47] Andrew Nenakhov leaves the room
[16:23:30] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:25:16] ChaosKid42 leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:25:27] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:26:31] sindrake leaves the room: Disconnected: Replaced by new connection
[16:27:34] spicewiesel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:27:49] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:34:18] zash leaves the room: Disconnected: closed
[16:36:13] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:36:37] marc leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:36:46] zash leaves the room: Disconnected: closed
[16:36:58] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:37:05] lorddavidiii leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:37:45] zash leaves the room: Disconnected: closed
[16:40:09] pprrks leaves the room
[16:41:47] zash leaves the room: Disconnected: closed
[16:42:13] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:45:31] zash leaves the room: Disconnected: closed
[16:46:01] Akasch leaves the room: Rechner geht in den Ruhezustand
[16:46:54] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:47:09] bowlofeggs leaves the room: Connection failed: timeout
[16:49:23] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:49:39] Alacer leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:49:41] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:50:39] zash leaves the room: Disconnected: Broken pipe
[16:51:33] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:52:31] Licaon_Kter leaves the room: Stream closed by us: Replaced by new connection (conflict)
[16:52:45] lorddavidiii leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[16:58:32] zash leaves the room: Disconnected: closed
[17:01:48] sindrake leaves the room
[17:02:46] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:05:29] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[17:05:34] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:07:37] af leaves the room: Stream reset by peer
[17:08:10] sindrake leaves the room: Disconnected: Replaced by new connection
[17:08:28] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:12:55] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:17:31] af leaves the room: Stream reset by peer
[17:17:39] af leaves the room
[17:17:55] af leaves the room
[17:17:58] Dominik Paulus leaves the room
[17:17:59] af leaves the room
[17:18:05] af leaves the room
[17:18:13] af leaves the room
[17:19:25] Dominik Paulus leaves the room
[17:20:06] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[17:20:53] mightyBroccoli leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:21:23] sindrake leaves the room: Disconnected: Replaced by new connection
[17:23:25] aditya_borikar leaves the room: Stream closed by us: Client acknowledged more stanzas than sent by server (undefined-condition)
[17:23:38] Dominik Paulus leaves the room
[17:24:23] zash leaves the room: Disconnected: closed
[17:24:52] mightyBroccoli leaves the room: I'd rather be hibernating.
[17:29:34] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:30:55] jeremy leaves the room
[17:31:07] spicewiesel leaves the room: Machine going to sleep
[17:33:28] zuglufttier leaves the room
[17:36:30] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:37:05] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:37:35] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:37:50] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:38:26] <404> zinid, >no need to read upgrade nodes, it will alter tables automatically
Bravo! Bravo! MariaDB or PostgreSQL support?
[17:38:30] af leaves the room
[17:39:54] robert_mobil leaves the room: Stream closed by us: Replaced by new connection (conflict)
[17:41:31] Alacer leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:42:07] <Licaon_Kter> 404: I asume both
[17:45:53] <404> Das ist fantastisch
[17:48:40] zinid leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:49:33] zash leaves the room: Disconnected: closed
[17:50:29] spicewiesel leaves the room
[17:50:57] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:51:44] VC leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:56:18] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:57:13] vogt leaves the room
[18:02:06] ta leaves the room
[18:04:45] vogt leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:07:32] zinid leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:10:19] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:12:07] mightyBroccoli leaves the room: Rechner geht in den Ruhezustand
[18:12:19] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:12:24] deavmi leaves the room: Disconnected: Replaced by new connection
[18:19:48] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:22:44] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:23:50] Licaon_Kter leaves the room
[18:23:55] deavmi leaves the room
[18:25:46] zinid leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:25:57] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:28:55] rom1dep leaves the room
[18:29:11] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:29:59] prefiks leaves the room
[18:32:37] lorddavidiii leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:37:07] Dominik Paulus leaves the room: Machine going to sleep
[18:37:26] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:37:59] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:39:22] sindrake leaves the room: Disconnected: Received SIGTERM
[18:39:22] sindrake leaves the room: Disconnected: Received SIGTERM
[18:39:22] ta leaves the room: Disconnected: Received SIGTERM
[18:46:03] vogt leaves the room: Stream closed by us: Replaced by new connection (conflict)
[18:48:14] marc leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:49:35] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:52:06] af leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:54:04] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:54:27] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[18:58:09] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[18:58:20] vogt leaves the room
[18:58:20] vogt leaves the room
[18:58:57] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:07:34] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:07:49] Odin leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:08:01] rom1dep leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:10:43] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:20:14] jere leaves the room: Disconnected: Replaced by new connection
[19:27:18] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:28:49] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:30:33] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:35:46] VC leaves the room
[19:37:31] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:41:53] adrien leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:41:58] spicewiesel leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:42:09] aditya_borikar leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:42:51] erik leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:45:05] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:45:58] Andrew Nenakhov leaves the room: Connection failed: connection closed
[19:48:55] lorddavidiii leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:51:46] robert_mobil leaves the room: Stream closed by us: Replaced by new connection (conflict)
[19:53:18] Andrew Nenakhov leaves the room
[19:56:18] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[19:59:30] tester leaves the room
[20:00:11] Man_Life leaves the room: Logged out
[20:01:05] fp leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:04:45] Alacer leaves the room
[20:05:23] Alacer leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:05:35] 404 leaves the room
[20:06:10] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:09:52] Marzanna leaves the room
[20:12:07] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:12:56] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:15:10] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:15:31] marc leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:15:44] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:19:18] vogt leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:21:49] vanitasvitae leaves the room
[20:22:35] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:23:53] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:23:59] fp leaves the room
[20:25:02] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:25:29] pod leaves the room
[20:25:55] vanitasvitae leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:28:22] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:28:40] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:30:54] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:32:49] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:33:12] secret_agent leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:34:02] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:36:14] bammes leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:37:14] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:37:37] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:37:45] zinid leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:38:09] Odin leaves the room: Stream closed by us: system-shutdown
[20:38:59] marek leaves the room: Stream closed by us: Replaced by new connection (conflict)
[20:39:05] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:39:55] Odin leaves the room
[20:40:50] af leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:49:41] debalance leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:53:59] Andrew Nenakhov leaves the room: Connection failed: connection closed
[20:55:48] Odin leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:02:21] daniel leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:07:46] Andrew Nenakhov leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:08:38] paul leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:13:49] sezuan leaves the room: Replaced by new connection
[21:15:36] Akasch leaves the room
[21:15:52] alexis leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:19:47] cippaciong leaves the room
[21:19:50] jeremy leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:20:38] ThUnD3r|Gr33n® leaves the room
[21:22:16] marek leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:22:34] ThUnD3r|Gr33n® leaves the room
[21:23:15] ludo leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:30:06] <VC> Hello! How can this be fixed http://take.ms/jkShh  ImageMagick is installed
[21:31:37] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:34:03] badlop leaves the room: Stream reset by peer
[21:36:03] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:37:29] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:46:38] spicewiesel leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:47:54] <zinid> VC: something wrong with fonts
[21:50:25] 4223 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:50:33] <VC> zinid: thanks, solved , /opt/ejabberd-18.04/lib/ejabberd-18.04/priv/bin/captcha.sh 357921  and saw that yyou are rright
[21:51:50] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:54:35] genofire leaves the room: Machine going to sleep
[21:55:24] mightyBroccoli leaves the room: Rechner geht in den Ruhezustand
[21:56:23] Akasch leaves the room: Rechner geht in den Ruhezustand
[21:56:29] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[21:58:02] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:58:02] genofire leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:58:11] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[22:00:38] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:08:26] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:14:49] sindrake leaves the room
[22:15:14] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:21:15] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:23:42] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:26:37] Dominik Paulus leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:29:46] Dominik Paulus leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[22:30:50] sindrake leaves the room: Disconnected: Replaced by new connection
[22:31:14] lorddavidiii leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[22:40:45] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[22:50:28] zinid leaves the room: Stream closed by us: Replaced by new connection (conflict)
[22:51:01] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[22:51:38] targ leaves the room: offline
[22:53:24] nekit leaves the room
[23:00:50] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:06:54] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[23:11:13] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:12:27] Licaon_Kter leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:12:29] marc leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:15:20] jere leaves the room
[23:16:56] deavmi leaves the room: Disconnected: Replaced by new connection
[23:21:00] sindrake leaves the room
[23:22:56] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:25:31] rom1dep leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:31:58] Alacer leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:35:18] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[23:36:56] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[23:37:27] joekokker leaves the room: Stream closed by us: Replaced by new connection (conflict)
[23:44:47] frainz leaves the room: Stream closed by us: Replaced by new connection (conflict)
[23:46:58] Odin leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:49:51] jeremy leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:50:04] genofire leaves the room: Machine going to sleep
[23:55:10] Odin leaves the room: Stream closed by us: system-shutdown

Powered by ejabberd - robust, scalable and extensible XMPP server