#maria Log v0.1

logs Catalogue

This page loads from the db, refresh as and when. It displays 24 hrs
For older data http://marialog.archivist.info/previous.php, logs go back to 2009-01-18
Some user stats
Table logs
date_time
user
message
2014-10-21 22:37:50
nobody18188181
i was able to subscribe without a google account (fortunately); I'll send email
2014-10-21 22:38:12
kolbe
great!
2014-10-21 22:47:43
nobody18188181
i also sent my limitation that i experienced awhile back (that I thought I sent)
2014-10-22 08:51:38
Guest59570
ssss
2014-10-22 08:52:21
danblack
tttt
2014-10-22 08:58:22
Guest59570
uuuu
2014-10-22 09:15:48
hartmut
spetrunia: i share your pain ...
2014-10-22 09:16:50
hartmut
enough that i did http://php-groupies.de/maxscale/ // https://github.com/hholzgra/MaxScale/tree/asciidoc/Documentation/AsciiDoc a while ago ... it is still on the state of the first beta though ...
2014-10-22 09:33:49
xenol
hi, I am trying to install mariadb-server from the official repository, but I am unable to install it because the package conflicts with mariadb-libs, which is needed by postfix
2014-10-22 09:36:13
xenol
I can install mariadb-server from mariadb repository, but I can't have postfix installed w/o doing some mess
2014-10-22 09:43:13
serg
xenol: distribution?
2014-10-22 09:43:23
hartmut
spetrunia: do you have an account on bugs.mariadb.com to file bugs?
2014-10-22 09:43:25
xenol
serg: centos 7
2014-10-22 09:44:09
serg
xenol: what do you mean "from the official repository"? our (mariadb) repository or centos7 repository?
2014-10-22 09:44:24
xenol
serg: official mariadb repository
2014-10-22 09:45:07
serg
ok, did you install MariaDB-shared? It should provide mysql-libs (unless we have a bug)
2014-10-22 09:45:33
serg
ah, ok, I see
2014-10-22 09:46:32
serg
this was our first release for centos7, so dependencies weren't quite polished out yet. sorry. in centos6 mariadb-shared indeed provides mysql-libs, but not on centos7 :( we'll fix it in the next release, there's a patch for it already
2014-10-22 09:47:03
xenol
serg: nice!
2014-10-22 09:47:07
spetrunia
hartmut: ok, so I'm not the only one
2014-10-22 09:47:10
xenol
serg: I can help with testing if needed
2014-10-22 09:47:41
xenol
serg: and also, the package in centos 7 is called mariadb-libs (changed from centos 6)
2014-10-22 09:47:48
spetrunia
hartmut: no, I didn't even know bugs.mariadb.com existed...
2014-10-22 09:48:35
hartmut
spetrunia: maxscale is full of NIH surprises like that i'm afraid
2014-10-22 09:49:06
serg
xenol: yes, like in a recent fedora. so hopefully the same fix will work
2014-10-22 09:49:10
hartmut
at least we're finally beyond the weirdest one now (handwritten makefiles)
2014-10-22 09:50:25
hartmut
spetrunia: if no new issues come in for me today i'll see if i can get usable diffs from pdftotext output to merge in beta-1.0.1 changes from the pdfs
2014-10-22 09:50:27
serg
svoj: did you create a bug report for RHEL7 or it's only a patch?
2014-10-22 09:50:39
serg
svoj: I mean the packaging, rpm dependencies
2014-10-22 09:51:02
hartmut
and right away i start to curse upon the use of whitespace in maxscale PDF filenames again :(
2014-10-22 09:51:03
jkavalik
spetrunia, just to add to yesterday info, we added covering index on production (mysql 5.1.59) and it still tries to use merge instead of covering index, maria from yesterday case does it right, but data are not exactly same (2.5M vs 2.1M rows)
2014-10-22 09:51:42
hartmut
spetrunia: we should move over to the #maxscale channel here on freenode maybe?
2014-10-22 09:52:00
svoj
serg: there is a bug report
2014-10-22 09:52:27
serg
your patch doesn't mention it, that's why I asked. ok, I'll find it
2014-10-22 09:52:38
svoj
serg: it's assigned to you
2014-10-22 09:53:00
spetrunia
hartmut: yes.. I'll join it now (although I dont have much else to say right now)
2014-10-22 09:53:05
svoj
serg: 6886
2014-10-22 09:53:48
serg
thanks
2014-10-22 09:54:14
serg
xenol: see https://mariadb.atlassian.net/browse/MDEV-6886 you can add yourself to the watch list to be notified when this bug is fixed
2014-10-22 09:54:28
hartmut
hartmut learns about the $IFS shell variable that allows to change the delimiter used by sh "for"
2014-10-22 09:55:50
spetrunia
jkavalik_afk: I see.. I haven't had time to look at it, yet
2014-10-22 09:55:52
xenol
serg: thanks man!
2014-10-22 10:04:27
fossxplorer
Hi, i had my server down last night i see a lots of 140622 2:29:32 InnoDB: Warning: trying to read doublewrite buffer page 94
2014-10-22 10:07:28
fossxplorer
I suspect space issue, although i see 8GB left now
2014-10-22 10:12:10
raw_
im getting duplicate key errors in galera nodes in a table with a multi-column primary key. i have read in the "known limitations" that you need a primary key, but it does not state if that key has to be single-column. any infos about that?
2014-10-22 12:02:17
Error404NotFound
Is mariadb supposed to pick all .cnf files from /etc/my.cnf.d/ ? I created a new file there and it doesnt seem like its taking effect. I tried changing tag from [mysqld] to [maridb] but same result.
2014-10-22 12:03:20
serg
Error404NotFound: mariadb does not magically picks up files from /etc/my.cnf.d/, it only reads /etc/my.cnf, but our /etc/my.cnf ends with !includedir /etc/my.cnf.d
2014-10-22 12:03:41
serg
and *that* causes all files from /etc/my.cnf.d to be included
2014-10-22 12:03:58
serg
so check if you has this line
2014-10-22 12:04:26
Error404NotFound
serg: hmm, must be the CentOS package then as I don't see any /etc/my.cnf at all and /etc/my.cnf.d/{server|clients).cnf are just empty
2014-10-22 12:05:28
serg
if you want to use /etc/my.cnf.d, add this includedir line to /etc/my.cnf
2014-10-22 12:07:19
Error404NotFound
serg: ya, did that and it works but isnt it strange for the upstream package to not have that by default yet have the placeholder configs in my.cnf.d?
2014-10-22 12:07:46
Error404NotFound
I must admit that i used mariadb from CentOS repos instead of Maria's own ones, so that might be the reason here.
2014-10-22 12:08:07
serg
agree, that is strange. makes /etc/my.cnf.d kind of useless
2014-10-22 12:08:27
serg
may be centos packagers didn't know that it's not magically read
2014-10-22 12:08:44
Error404NotFound
Gonna try to figure the upstream maintainer for centos package of mariadb. I am sure other users would make same assumptions as me.
2014-10-22 12:08:54
serg
thanks!
2014-10-22 12:16:43
erkules
Isn't it typical for redhat/centos *not* to provide a my.cnf
2014-10-22 12:16:52
erkules
A big mistake imho
2014-10-22 12:18:53
serg
erkules: but then it make no sense to create /etc/my.cnf.d/ and files in there
2014-10-22 12:19:07
serg
because this directory name is in no way special for mariadb or mysql
2014-10-22 12:19:11
erkules
serg: indeed
2014-10-22 12:53:03
knielsen
serg: I found a couple of races in two of your test cases. I fixed them, just FYI if you are interested: http://lists.askmonty.org/pipermail/commits/2014-October/006833.html
2014-10-22 13:01:43
erkules
anyone else than me does spider@mariadb10?
2014-10-22 13:21:30
tanj
erkules: svar is our spider pro :)
2014-10-22 13:21:37
tanj
you may want to talk to him
2014-10-22 13:29:42
erkules
tanj: :)
2014-10-22 13:29:50
erkules
erkules hugs svar
2014-10-22 13:37:19
tanj
erkules: he has already some customers with spider-mdb10 in prod :)
2014-10-22 13:37:28
tanj
if you need info you can also talk directly to kentoku
2014-10-22 13:38:58
erkules
great. Got started after some abstinence right now I hate the timeout defaults.
2014-10-22 13:39:17
erkules
Got to have a look into the HA feature indeed.
2014-10-22 13:39:39
erkules
erkules got to find/create spider customers too.
2014-10-22 13:39:41
erkules
:D
2014-10-22 13:39:50
tanj
have to give Spider a try sometime :)
2014-10-22 13:40:01
erkules
Do it it is great
2014-10-22 13:40:11
thumbs
thumbs doesn't like spiders
2014-10-22 13:40:24
erkules
Indeed some managing features are missing
2014-10-22 14:14:40
tanj
erkules: which binaries do you use?
2014-10-22 14:32:22
erkules
tanj: mariadb 10 for ubuntu
2014-10-22 14:39:38
tanj
erkules: were you the one who suggested to add wsrep_reject_queries to MGC?
2014-10-22 14:39:59
tanj
erkules: I have some up to date binaries, maybe with more functionality (not sure)
2014-10-22 14:41:25
erkules
tanj: no until now I didn't even knew it exists
2014-10-22 14:41:27
erkules
:)
2014-10-22 14:41:57
tanj
hmm.. .can't remember why I opened this issue
2014-10-22 14:43:51
erkules
me too. Is there a way to tell which connection are allowed?
2014-10-22 14:43:58
erkules
I.e. doing the maintenance stuff?
2014-10-22 14:44:08
tanj
I don't think so
2014-10-22 14:44:22
tanj
and besides, nirbhay tells me that it's impossible to do a mysqldump in this mode
2014-10-22 14:44:25
tanj
not sure if that's useful
2014-10-22 14:44:26
erkules
hmm sounds useless
2014-10-22 14:44:29
tanj
can't remember the original case...
2014-10-22 14:44:46
tanj
nirbhay: if you are around just ping me back...
2014-10-22 14:44:49
erkules
ok nirbhay proved it then
2014-10-22 14:45:04
erkules
Maybe it is for the session only
2014-10-22 14:45:23
erkules
but than again no mysqldump or even innodbackupex should work
2014-10-22 14:46:04
erkules
In fact the idea is good. But without a filter kind of useless
2014-10-22 14:47:06
erkules
tanj: I told you already about OS@paris and Dockerconf@Amsterdam do I?
2014-10-22 14:47:29
tanj
erkules: no!! tell me all about it
2014-10-22 14:47:53
erkules
tanj: please attend and we would have a drink :)
2014-10-22 14:50:57
tanj
erkules: if you can pitch in on the issue
2014-10-22 14:52:08
erkules
erkules sewars
2014-10-22 14:52:27
tanj
https://mariadb.atlassian.net/browse/MDEV-6798
2014-10-22 14:52:41
tanj
erkules: hmm. the early bird for dockerconf@AMS already closed... :(
2014-10-22 14:53:11
erkules
yeah it is sold out
2014-10-22 14:53:15
tanj
too bad
2014-10-22 14:53:19
tanj
300 eur is bit expensive for my taste
2014-10-22 14:53:23
tanj
what is OS Paris?
2014-10-22 14:53:29
erkules
OpenStack
2014-10-22 14:53:33
tanj
ah,
2014-10-22 14:55:03
tanj
erkules: my ex-colleagues are organizing that :) they do openstack consulting
2014-10-22 14:55:25
erkules
tanj: so maybe you can get there for free :)
2014-10-22 14:55:42
tanj
erkules: I doubt that, nothing's free anymore in this world... friends or not
2014-10-22 14:55:57
erkules
erkules disagrees with tanj
2014-10-22 14:55:59
tanj
yeah, 1K$
2014-10-22 14:56:05
tanj
I said colleagues not friends
2014-10-22 14:56:09
tanj
different thing :)
2014-10-22 14:56:13
erkules
indeed
2014-10-22 14:56:17
tanj
good to be a speaker I guess
2014-10-22 14:56:57
erkules
erkules has been given a free ticket
2014-10-22 14:58:11
erkules
tanj: forget it it is hard to become a speaker
2014-10-22 14:58:29
erkules
tanj: you need broad shoulders to stand on.
2014-10-22 14:58:32
tanj
hah, thought you were speaking there
2014-10-22 14:58:41
tanj
erkules: well you have the broad shoulders for sure :)
2014-10-22 14:59:16
erkules
tanj: And I would love to carry you around ;)
2014-10-22 15:00:14
erkules
Maybe Im going to give a talk at the dockerconf. But being a lonely freelancer odds are against me :(
2014-10-22 15:01:17
tanj
get one of your customers to sponsor you :)
2014-10-22 15:01:34
tanj
I'll probably go to FOSDEM. FOSDEM is free at least :)
2014-10-22 15:01:48
erkules
yeah I'll be there also
2014-10-22 15:02:30
erkules
tanj: this works when you have a long term customer. But right now there is to much fun out there to have only (nearly) one customer :)
2014-10-22 15:04:10
tanj
sure thing :)
2014-10-22 15:48:45
t_dot_zilla
hello
2014-10-22 15:48:51
t_dot_zilla
im new to maria
2014-10-22 15:49:12
t_dot_zilla
i read it's a dropin replacement to mysql
2014-10-22 15:49:34
t_dot_zilla
does that mean connecting to the server will not change for mysql clients?
2014-10-22 15:49:51
t_dot_zilla
also, which version is recommended, im confused there is 5.5, 10.0, 10.1
2014-10-22 15:49:56
t_dot_zilla
im on debian 7
2014-10-22 15:50:59
elenst
t_dot_zilla: which version of MySQL do you want to drop-replace?
2014-10-22 15:51:09
t_dot_zilla
5.X
2014-10-22 15:51:19
elenst
t_dot_zilla: then start with MariaDB 5.5
2014-10-22 15:51:26
t_dot_zilla
start with?
2014-10-22 15:51:33
elenst
when you get it up and running, you can upgrade to 10.0 if you want
2014-10-22 15:51:38
t_dot_zilla
elenst: what if im building a new server
2014-10-22 15:51:47
elenst
t_dot_zilla: then 10.0
2014-10-22 15:51:47
t_dot_zilla
and no users/websites on it yet
2014-10-22 15:52:03
t_dot_zilla
many users will request mysql backend
2014-10-22 15:52:26
t_dot_zilla
if they are dev'ing a site, let's say in wordpress
2014-10-22 15:52:35
elenst
t_dot_zilla: regarding mysq client, if you mean whether one can connect wih MySQL's client to MariaDB server, it's a yes
2014-10-22 15:52:43
t_dot_zilla
they won't need to do anything special to use mariadb?
2014-10-22 15:52:53
elenst
no
2014-10-22 15:52:54
t_dot_zilla
what about via php
2014-10-22 15:53:09
t_dot_zilla
what is diff between 10.1 and 10.0 ?
2014-10-22 15:53:16
t_dot_zilla
is 10.1 bleeding edge?
2014-10-22 15:53:18
elenst
i'm not aware of any problems with php + 5.5
2014-10-22 15:53:32
elenst
t_dot_zilla: 10.1 is an alpha
2014-10-22 15:53:40
t_dot_zilla
okay... if i use repos
2014-10-22 15:53:40
elenst
not recommended to be used anywhere near production
2014-10-22 15:53:49
t_dot_zilla
will updates be pushed
2014-10-22 15:53:52
t_dot_zilla
to 10.0?
2014-10-22 15:53:59
t_dot_zilla
what if 10.1 becomes stable ?
2014-10-22 15:54:35
elenst
t_dot_zilla: we have separate repos for 5.5, 10.0 and 10.1, and there are no plans to change it afaik. It means that unless you change the repo explicitly to 10.1, it will keep pulling 10.0 versions
2014-10-22 15:54:59
t_dot_zilla
okay so 10.0 will be stable and receive security updates
2014-10-22 15:55:01
t_dot_zilla
etc...
2014-10-22 15:55:16
elenst
10.0 is stable and it receives security updates
2014-10-22 15:55:25
elenst
but please ask around about 10.0 + php
2014-10-22 15:55:35
elenst
i heard some vague complaints about 10.0 + phpAdmin
2014-10-22 15:55:52
elenst
can't give you any specifics
2014-10-22 15:56:22
t_dot_zilla
okay, thanks
2014-10-22 15:56:43
grknight
i use 10.0.14 + php-5.5 (mysqlnd driver) and no errors with that alone. some apps like phpAdmin may complain, i don't use it
2014-10-22 15:57:22
t_dot_zilla
cool... i want to move away from mysql... i've really learned to despise it
2014-10-22 15:57:28
t_dot_zilla
i prefer postgres now
2014-10-22 15:57:37
t_dot_zilla
but users want mysql
2014-10-22 15:57:55
t_dot_zilla
for websites (even though most site backends support postgres)
2014-10-22 20:49:32
tyler_
I am getting a server version error when trying to run mysql_upgrade after removing mysql 5.0 from my server and installing mariadb 5.5 form my server. from what I have read it doesn't sound like that should be happening.
2014-10-22 21:01:02
kolbe
tyler_: what's the actual error you see?
2014-10-22 21:01:15
tyler_
Error: Server version (5.0.95) does not match with the version of
2014-10-22 21:01:15
tyler_
the server (5.5.40-MariaDB) with which this program was built/distributed. You can
2014-10-22 21:01:19
tyler_
use --skip-version-check to skip this check.
2014-10-22 21:02:06
kolbe
well if it's getting/giving that error you probably haven't really rmoved mysql 5.0 correctly
2014-10-22 21:02:22
kolbe
or maybe the mysql 5.0 server was still running when you removed it, and it was neveractually shut down?
2014-10-22 21:02:31
tyler_
hm that could be it one moment
2014-10-22 21:04:27
tyler_
it looks like the mysql process was still running after mysql was removed.
2014-10-22 21:04:34
kolbe
oops :)
2014-10-22 21:04:44
tyler_
thank you.
2014-10-22 21:05:07
tyler_
couldn't puzzle out why the server version was different then all the package information and mysql -V
2014-10-22 21:05:58
kolbe
:)