#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-06-22 09:02:17
willemb
Hi. Does anyone know of a tool to test msyql trigger syntax?
2017-06-22 10:25:01
cryocaustik
what int type would i need to use to store a value of 1e+35
2017-06-22 10:25:54
cryocaustik
or would i need to convert it to string?
2017-06-22 10:27:12
DarsVaeda
hi, how do I import a table with a primary key that has auto_increment and a value of 0 (zero)?
2017-06-22 10:27:25
DarsVaeda
my import fails on this with a duplicate key error
2017-06-22 10:27:38
DarsVaeda
I tried exporting with mysqldump and phpmyadmin
2017-06-22 10:31:31
willemb
DarsVaeda: isn't this where you disable constraints during your import?
2017-06-22 10:31:44
DarsVaeda
with disable keys?
2017-06-22 10:31:51
cryocaustik
nvm - using float fixed my issue
2017-06-22 10:31:56
willemb
SET FOREIGN_KEY_CHECKS=0;
2017-06-22 10:32:01
willemb
https://stackoverflow.com/questions/15501673/how-to-temporarily-disable-a-foreign-key-constraint-in-mysql
2017-06-22 10:32:25
DarsVaeda
I'll try it
2017-06-22 10:33:44
DarsVaeda
hmm there is this line in the dump: /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
2017-06-22 10:33:54
DarsVaeda
so it should be disabled I think
2017-06-22 10:37:02
DarsVaeda
there are a lot of foreign keys in other tables and import works there, so I don't think that is the problem
2017-06-22 10:37:17
DarsVaeda
for me it seems it just can't handle the value of "0" for the primary key
2017-06-22 10:44:18
willemb
SET sql_mode='NO_AUTO_VALUE_ON_ZERO';
2017-06-22 10:44:28
willemb
https://stackoverflow.com/questions/16549566/mysql-cant-insert-record-with-unsigned-primary-key-being-zero
2017-06-22 10:44:58
DarsVaeda
that's set too
2017-06-22 10:47:19
jkavalik
it tells you what key is duplicated and with what values
2017-06-22 10:48:02
DarsVaeda
yeah but it's not correct
2017-06-22 10:48:30
DarsVaeda
there is a key 1 but the key to be inserted is zero 0 and with those options set, zero shouldn't trigger an increment
2017-06-22 10:48:34
DarsVaeda
as far as I get it
2017-06-22 10:50:47
jkavalik
the error message definitely should be correct, it tells you what is happening, does it complain about 1 ?
2017-06-22 10:51:21
DarsVaeda
yes
2017-06-22 10:51:35
willemb
yes, auto-increment tries to change 0 to 1, then, when it imports 1, there is a duplicate. if you set 'no auto_calue_on_zero, the 0 will stay a zero when you import it
2017-06-22 10:51:39
DarsVaeda
I try to import primary key 0 and 1
2017-06-22 10:52:00
DarsVaeda
willemb: it should but it seems that doesn't work
2017-06-22 10:52:39
DarsVaeda
I can change it manually to zero just fine
2017-06-22 10:53:07
jkavalik
just tried - NO_AUTO_VALUE_ON_ZERO works for me, 10.0 - maybe add the SET to your dump because it may be setting the mode itself otherwise?
2017-06-22 10:53:55
DarsVaeda
that's how it's set: /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
2017-06-22 10:54:08
DarsVaeda
but I run 10.2.6 maybe it's a bug in the current version
2017-06-22 10:56:00
DarsVaeda
I'll switch to 10.0 and see if the problem still appears
2017-06-22 11:02:41
DarsVaeda
nope doesn't work either :(
2017-06-22 11:03:27
jkavalik
and you wrote it works from commandline? then thats not by version but something in the dump
2017-06-22 11:03:53
DarsVaeda
no it doesn't work anywhere
2017-06-22 11:04:21
DarsVaeda
but if I let it import with new keys I can change it back to zero
2017-06-22 11:04:31
DarsVaeda
or import it manually and set it to zero too
2017-06-22 11:59:15
DarsVaeda
if I remove the disabling of the foreign key checks it works
2017-06-22 12:54:52
lufi
im having an error when starting the service (maria5.5) in centos6.9. it only works when selinux is disabled `/usr/bin/mysqld_safe_helper: Can't create/write to file '/var/lib/mysql/python27.err' (Errcode: 13)`
2017-06-22 21:25:48
tom[]
i'm a bit confused about the instructions to backup galera cluster data here http://galeracluster.com/documentation-webpages/backingupthecluster.html
2017-06-22 21:26:13
tom[]
it mentions that the garbd command invokes wsrep_sst_backup.sh. is that a file that i must provide?
2017-06-22 21:36:17
tom[]
do the scripts on my server like wsrep_sst_mysqldump have any bearing on this?