#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
2015-07-31 19:59:06
wiza
It seems that select release_lock crashes server irregularly
2015-07-31 19:59:17
wiza
might be because of galera, or not
2015-07-31 19:59:44
wiza
but itâs the last query in general-log
2015-07-31 21:26:12
rharwood
so I'm trying to add a conf variable to the server section. I've added the appropriate definition to sys_vars.cc, but the parser doesn't seem to recognize it. Is there another step I'm missing?
2015-07-31 21:26:39
serg
rharwood: show the patch, please
2015-07-31 21:27:11
serg
adding to sys_vars.cc should be enough
2015-07-31 21:35:29
rharwood
there will be an ifdef around this when it's done, but I'm leaving that out for now: https://gist.github.com/frozencemetery/037a91c1b7917dd94d1d
2015-07-31 21:57:50
serg
rharwood: looks good to me. it's difficult to do it wrong anyway :) how does parser "not recognize it" ?
2015-07-31 21:58:23
rharwood
well, in the log during startup, mysqld bails with "2015-07-31 16:46:22 140375789598848 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable 'kerberos-principal-name=MySQL/maria.rharwood.biz@RHARWOOD.BIZ'
2015-07-31 21:58:25
rharwood
"
2015-07-31 21:58:55
serg
ah, but of course. You have NO_CMD_LINE - so, this is a server variable, but not a command-line argument
2015-07-31 21:59:20
rharwood
right. It's set in /etc/my.cnf.d/server.cnf
2015-07-31 22:01:13
rharwood
(which is coming in through the !includedir in /etc/my.cnf)
2015-07-31 22:03:43
rharwood
since I'm not setting it on the command line, I think it should pick that up from the config file?
2015-07-31 22:04:54
serg
no, config file and command line - that's basically the same thing. any command line argument can be set from a file. and vice versa. a "server variable" is something you can see in SQL, like "SELECT @@kerberos_principal_name". That SELECT works with your variable, btw.
2015-07-31 22:05:05
rharwood
OH
2015-07-31 22:05:14
rharwood
okay, thanks!
2015-07-31 22:05:30
serg
you need CMD_LINE(REQUIRED_ARG) instead
2015-07-31 22:07:37
rharwood
that seems to be working. Thanks much!
2015-07-31 22:13:13
rharwood
next question. Why isn't the ON_CHECK function being called?
2015-07-31 22:15:27
rharwood
I can see that the value is set from the config file, but the breakpoint on the check function is not hit
2015-07-31 22:20:10
serg
it's only called when you assign a variable from sql. like SET @@kerberos_principal_name=xxx
2015-07-31 22:20:23
serg
but that can never happen as your variable is READ_ONLY
2015-07-31 22:21:07
serg
serg . o O (I should've had an assert that read-only variables don't have on_check and on_update functions...)
2015-07-31 22:21:33
rharwood
well that answers my next question too :) thanks
2015-08-01 01:07:57
GitGud
hi there
2015-08-01 01:38:00
GitGud
hey JimmyNeutron
2015-08-01 11:54:42
Braden`
Hello!
2015-08-01 11:54:51
Braden`
I have a galera three brain cluster
2015-08-01 11:55:05
Braden`
If I want to change the IP addresses of one of the servers, is there an easy way to do that?
2015-08-01 14:40:52
linuxmint2
just installed MariaDB, but # sudo /etc/init.d/mysql start, says error: Sudo: /etc/init.d/mysql: command not found
2015-08-01 14:42:19
linuxmint2
Is this the MariaDB forum? https://atomicorp.com/forums/viewforum.php?f=24