#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
2017-10-23 09:24:49
qwebirc50628
Hi, can see that release notes for 10.2.10 is online. Does anybody know when binaries for 10.2.10 are released?
2017-10-23 09:38:33
dr-m
serg: â
2017-10-23 09:39:31
dr-m
qwebirc50628: afaiu, a merge of changes from 10.1 is still needed, and binaries have to be uploaded to the mirrors. Iâd guess at least 1 day, but I am not familiar with the details of the process.
2017-10-23 09:56:54
qwebirc50628
thanks!
2017-10-23 13:26:21
Zombie_Ryushu
Are there any bugs in mariadb-10.1.26 that would create excess or unusual disk usage by OwnCloud?
2017-10-23 14:26:15
mitescugd
Could someone help me out with setting up a MariaDB to open an odbc port? Any kind of link would be useful, I think my google searches are uninspired today.
2017-10-23 14:26:50
grknight
mitescugd: what do you mean by "open an odbc port"
2017-10-23 14:28:00
grknight
do you want an ODBC client connecting to MariaDB? or do you want MariaDB to source another database using ODBC?
2017-10-23 14:28:22
mitescugd
Set up (probably with the help of some libraries), an ODBC api, open to connection and queries. I just assumed that it should be configured inside the maria configuration, but I don't really know what I'm talking about.
2017-10-23 14:28:25
mitescugd
Second one.
2017-10-23 14:28:40
mitescugd
Not really second one.
2017-10-23 14:28:58
mitescugd
My bad. Is it possible for MariaDB to be a source for another database?
2017-10-23 14:29:12
grknight
yes, using the CONNECT engine
2017-10-23 14:30:29
mitescugd
Nice, thank you. I found the page, I will try it now.
2017-10-23 14:30:37
grknight
mitescugd: oh the other way around?
2017-10-23 14:30:41
grknight
i'm confused here
2017-10-23 14:30:54
mitescugd
Yes, the other waay around.
2017-10-23 14:31:19
grknight
if you want an ODBC connection into MariaDB, then use Oracle's Connector/ODBC or MariaDB's Connector/ODBC
2017-10-23 14:31:26
grknight
has nothing to do with the server
2017-10-23 14:32:22
mitescugd
Ah, so it's separate. Thank you
2017-10-23 14:33:08
FinalX
hm, 1 table, 1 row, 1000 clients want to update it at relatively the same time, but causing table locks in between (obviously). not my application or design and I can't really influence it that much, but I'd like to improve performance. data integrity is not the main issue here, it's ok if a few get lost if the machine dies or something. anyone have any idea as to improving performance there that doesn't
2017-10-23 14:33:10
FinalX
involve changing the application?
2017-10-23 14:33:32
grknight
mitescugd: https://dev.mysql.com/downloads/connector/odbc/ or https://mariadb.com/kb/en/library/mariadb-connector-odbc/
2017-10-23 14:33:44
FinalX
(would syncing to disk less often help perhaps? can't use the MEMORY-engine as it wouldn't replicate)
2017-10-23 14:34:37
linuxconformer
anyone here?
2017-10-23 14:35:41
Ninpo
FinalX: Only thing I can think of is playing with isolation levels but honestly, my response would be "it's this bad because the design is stupid, fix it or live with it"
2017-10-23 14:36:16
FinalX
yeah, we're gonna contact the vendor, it's retarded tbh
2017-10-23 14:36:42
FinalX
and it's only a damn counter to inform the application that that specific thing completed its update
2017-10-23 14:37:41
FinalX
oh, and isolation levels don't even apply, since it's MyISAM even ;)
2017-10-23 14:37:51
Ninpo
Oh well innodb will improve the performance
2017-10-23 14:38:03
Ninpo
Providing enough redo log/change buffer
2017-10-23 14:38:24
Ninpo
This is the bit where you tell me it has a ton of auto inc columns so innodb won't work haha
2017-10-23 14:39:33
catphish
i'm interested in using maria as a key value store (because unlike most key value stores it can provide proper multi-user authentication), is there any way to use the memory engine in a manner than automatically discards old data if it gets full?
2017-10-23 14:41:07
FinalX
Ninpo: nope, it only has 1 auto_increment and that's only for when new entries in the table are created. we're currently talking about a lot of UPDATEs on 1 specific row, so that id never gets updated automatically. another column in that row just gets +1'd
2017-10-23 14:41:30
FinalX
so basically: UPDATE something SET counter = counter + 1 WHERE id = x;
2017-10-23 14:41:46
Ninpo
hmm innodb might help you some then
2017-10-23 14:44:30
linuxconformer
guys why am i getting an "access denied" error when trying to access my mariadb instance?
2017-10-23 14:45:03
Ninpo
Because you're not providing relevant credentials
2017-10-23 14:45:39
linuxconformer
Ninpo: when i access the container, it still gives me access denied from "mysql -u root -p"
2017-10-23 14:46:01
linuxconformer
i set the MYSQL_ROOT_PASSWORD var in my docker-compose file, still get that error
2017-10-23 14:47:22
catphish
linuxconformer: try with sudo
2017-10-23 14:47:36
grknight
linuxconformer: if you are running Debian or Ubuntu with recent MariaDB, you'll need to do 'sudo mysql' (without -p)
2017-10-23 14:47:37
linuxconformer
catphish: the only user is root
2017-10-23 14:47:39
Ninpo
Why would sudo help?
2017-10-23 14:47:54
grknight
or just mysql as root
2017-10-23 14:48:12
catphish
Ninpo: the default maria config on ubuntu doesn't allow non-root users local access to the root database user
2017-10-23 14:48:22
linuxconformer
i am root
2017-10-23 14:48:24
Ninpo
ooohhh
2017-10-23 14:48:33
linuxconformer
im using the "mariadb" image
2017-10-23 14:48:35
Ninpo
I always drop the root account from MariaDB
2017-10-23 14:49:16
catphish
Ninpo: i always leave it as a backup, it's nicely locked down
2017-10-23 14:49:18
linuxconformer
running "mysql" as root gives "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"
2017-10-23 14:49:34
catphish
linuxconformer: in that case i guess you just don't have the right password :(
2017-10-23 14:49:53
linuxconformer
catphish: i set the password in my docker-compose file
2017-10-23 14:49:58
linuxconformer
MYSQL_ROOT_PASSWORD: root
2017-10-23 14:50:20
catphish
linuxconformer: your error suggests you're sending no password at all
2017-10-23 14:50:34
catphish
"(using password: NO)"
2017-10-23 14:50:35
Ninpo
oh yeah
2017-10-23 14:50:39
Ninpo
good spot catphish
2017-10-23 14:50:44
catphish
mysql -u root -proot
2017-10-23 14:51:10
catphish
although originally he pasted "mysql -u root -p"
2017-10-23 14:51:15
catphish
so maybe thats not the problem :(
2017-10-23 14:51:29
linuxconformer
sorry, it should have been "mysql -u root -p"
2017-10-23 14:51:47
linuxconformer
same error, execept for the (using password: YES/NO) text
2017-10-23 14:52:17
catphish
linuxconformer: it seems like the root user just wasn't created correctly :(
2017-10-23 14:52:19
Ninpo
My next step would be starting mysqld with --skip-grant-tables and seeing what users it thinks it has
2017-10-23 14:52:58
catphish
^ i'd try this
2017-10-23 14:53:37
linuxconformer
Ninpo: not sure how to do that from the docker container though
2017-10-23 14:54:04
Ninpo
I've zero docker knowledge I'm too old fashioned a sysadmin :P
2017-10-23 14:54:41
catphish
enter the container, stop maria, start it again with the option
2017-10-23 14:54:53
catphish
it's a pain to do, but no different in docker afaik
2017-10-23 14:55:06
catphish
unless docker is running just the database, then it gets way more complicated :(
2017-10-23 14:55:35
linuxconformer
catphish: docker is already running apache
2017-10-23 14:56:13
catphish
so its probably running maria in a normal init, so the process is the standard password bypass process
2017-10-23 14:57:10
Ninpo
are you in a shell in docker or not?
2017-10-23 14:57:19
Ninpo
Because if you're not that'll be your problem, localhost is a socket
2017-10-23 14:57:59
Ninpo
try connecting with -hip.add.re.ss replacing with the iP of the docker instance
2017-10-23 14:58:42
catphish
sometimes 127.0.0.1 might work where localhost does not so just adding "-h 127.0.0.1" may help
2017-10-23 14:58:57
catphish
(assuming you're inside the container and maria is also inside the same container)
2017-10-23 14:59:00
linuxconformer
i was in the database container
2017-10-23 14:59:22
Ninpo
try -h 127.0.0.1 or -h ip of docker instance
2017-10-23 14:59:29
Ninpo
possible the image doesn't configure a socket
2017-10-23 14:59:35
Ninpo
hang on I'm being stupid
2017-10-23 14:59:48
Ninpo
socket obviously exists but root@localhost may not
2017-10-23 15:00:01
Ninpo
(would get a different error if the socket just wasn't there)
2017-10-23 15:00:48
linuxconformer
in the mariadb container the port the db is running on is 80 i think
2017-10-23 15:01:07
Ninpo
ehwha
2017-10-23 15:01:13
linuxconformer
or maybe not
2017-10-23 15:01:31
linuxconformer
no, not
2017-10-23 15:01:42
linuxconformer
hmm should pinging localhost:3306 return anything?
2017-10-23 15:01:48
Ninpo
no
2017-10-23 15:01:54
linuxconformer
ok good
2017-10-23 15:02:03
Ninpo
other than maybe an error lol
2017-10-23 15:02:54
Ninpo
netstat -anpt | grep mysql
2017-10-23 15:06:46
linuxconformer
Ninpo: hmm can't install netstat
2017-10-23 15:07:08
Ninpo
man I hate docker :P
2017-10-23 15:07:27
Ninpo
(don't take that as official advice to not use it)
2017-10-23 15:07:38
linuxconformer
honestly i love it, it has its quirks but damn is it useful
2017-10-23 15:39:35
FinalX
Ninpo: your suggestion that simply making it InnoDB would help a lot already, helped a lot. thanks :) the vendor won't support it if we change from MyISAM to InnoDB, but we explained the situation to them and that we're expecting them to change their view on it and that they should've supported it years ago since it's been the default for some time now
2017-10-23 15:47:40
Ninpo
FinalX: oh good glad I could help
2017-10-23 15:51:24
catphish
FinalX: good luck, innodb really is the way to go
2017-10-23 15:54:37
FinalX
catphish: yeah, tell me 'bout it.. :( I don't even get why people are still using MyISAM in 2017.
2017-10-23 15:55:08
FinalX
read performance perhaps? but even then I don't expect it to be that big of a difference
2017-10-23 16:00:57
Ninpo
With the amount of memory DBs can have available these days does innodb really suffer much performance penalty over myisam anymore? If at all?
2017-10-23 16:01:17
FinalX
that's what I'm saying, I don't think so :)
2017-10-23 16:01:33
FinalX
just trying to think of an argument that someone might make for sticking to MyISAM..
2017-10-23 16:01:47
salle
Tell that to people who are running very small VM servers with less than 1G RAM :)
2017-10-23 16:02:04
Ninpo
poorly resourcing your DB isn't an argument for myisam :P
2017-10-23 16:02:44
Ninpo
FinalX: there are edge case schema designs that innodb just breaks on, like auto inc columns that aren't the PK
2017-10-23 16:03:00
FinalX
ah
2017-10-23 16:03:01
Ninpo
There's a table at work that has 3 auto incs in it, none of which are the PK
2017-10-23 16:03:04
Ninpo
innodb doesn't like that
2017-10-23 16:03:15
FinalX
... I wouldn't like that, either ;P
2017-10-23 16:03:28
catphish
makes sense, innodb is quite opinionated about auto increment
2017-10-23 16:03:31
Ninpo
neither do I, the idiot dev essentially uses the auto inc as a new value generator
2017-10-23 16:03:54
catphish
i'm not aware of any situations where myisam performs better, but maybe they exist
2017-10-23 16:03:54
Ninpo
I'd love to see autogen UUID as an option on the PK column in innodb though
2017-10-23 16:04:23
FinalX
that'd be cool :)
2017-10-23 16:06:20
salle
catphish: The nice way auto_increment works in MyISAM is probably the last one
2017-10-23 16:06:32
salle
it requires triggers to emulate that in InnoDB
2017-10-23 16:06:52
Ninpo
the on any column thing? yeah
2017-10-23 16:07:02
catphish
i have often thought additional auto increment fields could be useful
2017-10-23 16:08:01
Ninpo
we have a use case but I'm not convinced it's the best example of it hehe
2017-10-23 16:08:32
Zombie
Are there any bugs in mariadb-10.1.26 that would create excess or unusual disk usage by OwnCloud?
2017-10-23 16:08:37
catphish
i'm interested in using maria as a key value store (because unlike most key value stores it can provide proper multi-user authentication), is there any way to use the memory engine (or any other engine) in a manner than automatically discards old data as it gets full (over a specific data size)?
2017-10-23 16:08:52
Ninpo
Zombie: OwnCloud in my experience does a pretty good job of doing that by itself :v
2017-10-23 16:09:23
Ninpo
catphish: use it as a cassandra front?
2017-10-23 16:11:02
Ninpo
maybe a trigger if row count > X then delete from etc ?
2017-10-23 16:12:40
MadMerlin|work
the PK(a, b) auto_increment on b trick for myisam is pretty useful sometimes
2017-10-23 16:12:50
MadMerlin|work
and doesn't work with innodb
2017-10-23 16:12:55
Ninpo
ahhh yes
2017-10-23 16:13:04
Ninpo
forgot that one
2017-10-23 16:13:30
Ninpo
though I've never been that sure why column order matters..
2017-10-23 16:14:17
Ninpo
other than for optimising composite keys and selects going from left to right....which might actually answer my own question ha
2017-10-23 16:14:25
MadMerlin|work
it matters because myisam uses separate namespaces for the auto_increment there
2017-10-23 16:14:52
MadMerlin|work
so you would have (1, 1), (1, 2), (2, 1), (2, 2), etc
2017-10-23 16:18:08
catphish
Ninpo: maybe a trigger, trying to keep things simple, considering various options
2017-10-23 16:18:52
Ninpo
Shame there's still nothing decent that let's you plug redis in for storage
2017-10-23 16:19:29
catphish
i basically just want a multi-tenanted redis
2017-10-23 16:20:13
catphish
will probably end up using something like this: https://github.com/markbertoglio/akvstore (a simple k-v store on top of redis)
2017-10-23 16:21:15
tom[]
on debian 9, using its mariadb-server-10.1 package, i start the server with systemctl start mysql. but if wsrep sst takes a long time then systemctl markes the service as failed and, after sst completes, mysqld has exited
2017-10-23 16:21:45
MadMerlin|work
you need to bump your max wait time for systemd
2017-10-23 16:22:11
tom[]
ok
2017-10-23 16:22:47
MadMerlin|work
/etc/systemd/system/mariadb.service.d/override.conf [Service] TimeoutStartSec=10m
2017-10-23 16:22:49
MadMerlin|work
or so
2017-10-23 16:23:10
tom[]
gr8. tnx MadMerlin|work
2017-10-23 16:24:34
tom[]
my salt states already add an override/conf so that was easy
2017-10-23 16:24:48
tom[]
(easy doesn't happen often enough)
2017-10-23 16:41:51
Ninpo
must. resist. bitching about. systemd.
2017-10-23 16:48:30
qwebirc75980
hi, is anyone familiar with the mysql binary protocol (on wire format)?
2017-10-23 16:49:37
qwebirc75980
having an extremely odd issue where a simple select is sometimes not returning results
2017-10-23 16:50:44
qwebirc75980
i took two tcpdumps of a failing query and a successful query and i'm curious what the difference is
2017-10-23 16:53:35
markusjm
qwebirc75980: the protocol is documented here: https://mariadb.com/kb/en/library/clientserver-protocol/
2017-10-23 16:54:15
tom[]
Ninpo: "an abhorrent and violent slap in the face to the Unix philosophy"
2017-10-23 16:54:52
Ninpo
tom[]: indeed. Where'd you source that?
2017-10-23 16:55:05
Ninpo
feels like it's from a good rant I'd enjoy reading hehe
2017-10-23 16:55:23
Ninpo
If Poettering didn't work at red hat we wouldn't be in this mess :P
2017-10-23 16:55:24
tom[]
web search "an abhorrent and violent slap in the face to the Unix philosophy"
2017-10-23 16:57:07
tom[]
linux is an abhorrent and ...
2017-10-23 16:57:15
tom[]
i happen to like systemd a lot. i've been using unixes since '86, only recently switching from *BSD to linux
2017-10-23 16:57:32
tom[]
if it wasn't for torvalds we wouldn;t be in this mess
2017-10-23 16:59:20
tom[]
i thought even upstart was an improvment over sysvinit
2017-10-23 17:10:45
qwebirc75980
are comments within queries allowed in the binary protocol?
2017-10-23 17:11:00
qwebirc75980
i notice that most clients strip them before sending
2017-10-23 17:11:08
qwebirc75980
and removing the comment makes the query start working :o
2017-10-23 17:11:39
markusjm
qwebirc75980: do you mean prepared statements?
2017-10-23 17:12:20
qwebirc75980
no, just a standard COM_QUERY with SELECT /* blah blah */ FROM ...
2017-10-23 17:12:27
markusjm
comments are allowed
2017-10-23 17:12:45
markusjm
mysql command line keeps them with the -c flag
2017-10-23 17:12:53
qwebirc75980
let me test with that
2017-10-23 17:13:00
markusjm
that's something I always forget when debugging comments
2017-10-23 17:24:15
qwebirc75980
if query caching is disabled, are there any other types of cache that might continuously return bad results until the query is changed?
2017-10-23 17:25:09
qwebirc75980
adding whitespace, adding/removing comments, etc gets things working for a short while
2017-10-23 17:26:58
markusjm
qwebirc75980: not that I know of, maybe you are using some sort of a framework that caches results?
2017-10-23 17:27:50
qwebirc75980
that's what i thought at first so i started watching the query over the wire
2017-10-23 17:28:04
qwebirc75980
its definitely being sent to the server and the server responds with an empty set
2017-10-23 17:28:17
qwebirc75980
and restarting the server fixes it briefly
2017-10-23 17:53:35
qwebirc75980
making progress...
2017-10-23 17:53:46
qwebirc75980
issuing a flush tables fixes the issue
2017-10-23 18:13:30
wanna
Hello, i have problème accessing a DB with the created user as you can see: https://pastebin.com/DHPK9UST
2017-10-23 18:13:51
wanna
i don't understand what i missed
2017-10-23 18:16:23
wanna___
(i am still here, conection problems)
2017-10-23 18:18:05
Naktibalda
wanna___: you made a mistake at grant all privileges on t to lerol ;
2017-10-23 18:18:18
Naktibalda
it had to be grant all privileges on toto.t to lerol ;
2017-10-23 18:20:26
wanna___
Naktibalda, thank you, i changed it but always the same error ( update : https://pastebin.com/jxL24qrr )
2017-10-23 18:24:36
wanna___
Naktibalda, in fact, if i grant select on t to tit it works... it's like it's ignoring the role
2017-10-23 18:25:01
Naktibalda
I had no idea that mariadb has roles
2017-10-23 18:25:40
wanna___
wut
2017-10-23 18:25:56
qwebirc75980
so it turns out the query cache was actually enabled even though my config sets it off
2017-10-23 18:26:32
qwebirc75980
disabling it using set global query_cache_type = off has seemingly fixed it for good
2017-10-23 18:26:44
wanna___
Naktibalda, it has : https://mariadb.com/kb/en/library/roles_overview/
2017-10-23 18:26:47
qwebirc75980
this would suggest the query cache is unsafe to use in production though
2017-10-23 18:28:09
grknight
wanna___: make sure the connected user is on a certain role... SELECT CURRENT_ROLE()
2017-10-23 18:29:28
wanna___
grknight, current role is null :( and both user() an current_user is 'tit'@'localhost'
2017-10-23 18:30:00
grknight
if not, select it after connect or make it the default role like in the role documentation
2017-10-23 18:30:38
grknight
see SET ROLE and SET DEFAULT ROLE
2017-10-23 18:30:44
wanna___
i tried it : ERROR 1959 (OP000): Invalid role specification `lerol`.
2017-10-23 18:36:19
wanna___
grknight, could you test my script on your computer ? just to check if the problem is related to my computer
2017-10-23 18:39:10
grknight
wanna___: you have lerole vs lerol
2017-10-23 18:40:29
wanna___
oups.. old version of the script... i change it but tit doen'st show the toto database (root see it)
2017-10-23 18:57:46
wanna___
find a way .. add the role in mysql.user and after it "set role" works...
2017-10-23 18:57:50
wanna___
stinky solution
2017-10-23 19:58:19
Guest82
hello, I'm running Koha under MariaDB but the CPU of the server is constantly high... any suggestions?
2017-10-24 01:07:59
raynold
ahh it's a wonderful day
2017-10-24 05:05:07
ws2k3
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'bogus data in log event; the first event 'mysql-bin.035918' at 966054951, the last event read from 'mysql-bin.035920' at 597347, the last byte read from 'mysql-bin.035920' at 597366.' what can this be?
2017-10-24 05:18:01
ws2k3
anyone?
2017-10-24 06:01:18
IgorK_
good evening
2017-10-24 06:01:55
IgorK_
could someone please look at my question here: https://stackoverflow.com/questions/46882353/weird-error-on-mysql-stmt-execute?noredirect=1#comment80712161_46882353
2017-10-24 06:02:34
IgorK_
I just tried to run the query in question inside WB and it ran fine
2017-10-24 06:02:46
IgorK_
what might be the problem?
2017-10-24 06:03:45
IgorK_
I understand that it is not mysql forum, but unfortunately I can't send an email to the ML of mysql
2017-10-24 06:03:54
IgorK_
thank you in advance
2017-10-24 06:23:08
jkavalik
IgorK_, there is #mysql too.. did you try the exact query using commandline client?
2017-10-24 06:37:15
markusjm
IgorK_: I think the strings are not null-terminated