- discuss - lists.mariadb.org

[Maria-discuss] bugs in the testsuite
by Reindl Harald 31 Mar '14

31 Mar '14

hi, i see the errors below for a longer time and thought i should mention them - in case of running the test-suite completly alone i would not expect that /usr/bin/su -c 'cd /usr/share/mysql-test; ./mysql-test-run.pl --default-myisam --parallel=1 --max-test-fail=0 --mysqld=--binlog-format=mixed --skip-ndb --force' mysql ________________________________________________- rpl.rpl_row_utf32 'row' [ fail ] Test ended at 2014-03-05 19:57:46 CURRENT_TEST: rpl.rpl_row_utf32 mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_row_utf32.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_row_utf32-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_row_utf32-row/' rpl.rpl_row_view01 'row' [ skipped ] Not ROW format rpl.rpl_row_wide_table 'row' [ skipped ] Not ROW format rpl.rpl_tmp_table_and_DDL 'row' [ fail ] Test ended at 2014-03-05 19:57:50 CURRENT_TEST: rpl.rpl_tmp_table_and_DDL mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_tmp_table_and_DDL.test at line 8: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_tmp_table_and_DDL-row/' to '/usr/share/mysql-test/var/log/rpl.rpl_tmp_table_and_DDL-row/' rpl.semisync_memleak_4066 'row' [ skipped ] Need semisync plugins rpl.rpl_stm_sql_mode 'stmt' [ fail ] Test ended at 2014-03-05 19:58:31 CURRENT_TEST: rpl.rpl_stm_sql_mode mysqltest: In included file "./include/rpl_init.inc": included from ./include/master-slave.inc at line 38: included from /usr/share/mysql-test/suite/rpl/t/rpl_stm_sql_mode.test at line 2: At line 179: query 'RESET SLAVE' failed: 1198: This operation cannot be performed with a running slave; run STOP SLAVE first The result from queries just before the failure was: include/master-slave.inc - saving '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/' to '/usr/share/mysql-test/var/log/rpl.rpl_stm_sql_mode-stmt/'

2 1

[Maria-discuss] New Question: Multi Master Replication
by AskMonty KB 27 Mar '14

27 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by eddow: -------------------------------- Greetings, I am attempting to set up Multi Master Replication. So far, I have been able to set up multiple masters and data is replicated to one slave. This works great. What I am having a problem with is if I add a new master. When I add the master the data in the slave table is truncated and only the data from the new master is replicated. I loose all my old data in the slave. Example: Master 1300: +----------------+ | name | +----------------+ t1300 Master 13: +----------------+ | name | +----------------+ t13 +----------------+ Slave: +----------------+ | name | +----------------+ t1300 t13 +----------------+ On the slave I do this: change master 't68' to master_host='10.79.84.149', master_user='replication_user', master_port=3306; start slave t1300; select * from name; Slave: +----------------+ | name | +----------------+ t68 +----------------+ -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multi-master-replication/

2 1

[Maria-discuss] Does ADD/DROP INDEX update the InnoDB buffer pool?
by Markus "Shorty" Uckelmann 25 Mar '14

25 Mar '14

Hi all, When adding or dropping a primary and/or secondary index is the InnoDB buffer pool updated too? Is the pool changed in place or will the LRU algo just evict to make room? In the second case buffers of other tables on the server might be affected too and the server would run with a more or less cold buffer pool. We have to fiddle with indices on production servers, which by itself is a precarious matter. So I tried to find out how ADD/DROP INDEX operations affect the memory/buffer pool of our servers. Since I wasn't able (or too stupid) to find something about this topic it would be great if someone could help me out and point me in the right direction. BTW: Version is MariaDB 5.5 Cheers, Shorty

2 1

[Maria-discuss] New Question: can't get mariadb to start in Slackware
by AskMonty KB 25 Mar '14

25 Mar '14

Hello, A new question has been asked in "MariaDB community" by boomhower182: -------------------------------- After my fresh install it was starting just fine and the only thing I changed was my apache config files to get php to work and then I did some updates and it was still working, then all of a sudden it stopped working. this is what my .err file states.. 140324 16:49:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140324 16:49:05 InnoDB: The InnoDB memory heap is disabled 140324 16:49:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140324 16:49:05 InnoDB: Compressed tables use zlib 1.2.8 140324 16:49:05 InnoDB: Using Linux native AIO 140324 16:49:05 InnoDB: Initializing buffer pool, size = 128.0M 140324 16:49:05 InnoDB: Completed initialization of buffer pool 140324 16:49:05 InnoDB: highest supported file format is Barracuda. InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 140324 16:49:05 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 140324 16:49:05 InnoDB: Waiting for the background threads to start 140324 16:49:06 Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; log sequence number 1597945 140324 16:49:06 [Note] Plugin 'FEEDBACK' is disabled. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 140324 16:49:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 140324 16:49:06 [ERROR] mysqld: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 140324 16:49:06 mysqld_safe mysqld from pid file /var/run/mysql/mysql.pid ended -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/cant-get-mariadb-to-start-in-slackware/

2 1

[Maria-discuss] subscribe please
by James Qian Wang 21 Mar '14

21 Mar '14

-- James Qian Wang Mobile: 44 7986 099 233

2 1

[Maria-discuss] New Question: ETL tool for MariaDB
by AskMonty KB 21 Mar '14

21 Mar '14

Hello, A new question has been asked in "Replication, Cluster, & Multi-Master" by Sunil: -------------------------------- Hello, Please let me know the ETL tools that we can integrate with MAriaDB. Thanks Sunil -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/etl-tool-for-mariadb/

1 0

[Maria-discuss] New Question: installation issue
by AskMonty KB 20 Mar '14

20 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by rahulsharma: -------------------------------- during installation mariadb5.5 .tar i am getting issue as following:- root@localhost mysql]# ./scripts/mysql_install_db ./scripts/mysql_install_db: line 268: ./bin/my_print_defaults: cannot execute binary file either host 'localhost.localhost' nor 'localhost' could be looked up with ./bin/resolveip please configure the 'hostname' commmand to return a correct hostname. kindly suggest me!!!!! -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/installation-issue/

3 2

[Maria-discuss] help - i'm not finding one sql function
by Roberto Spadim 20 Mar '14

20 Mar '14

hi guys, i'm not finding a function to return how many character i have, for example: "banana" i want a function that return 2 "n" characters, example: substr_count("banana","n") => 2 sorry it a begginners question, but i didn't found it in mysql/mariadb manual -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

7 21

[Maria-discuss] New Question: mariaDB_client-1-0-0_win64 in Visual Studio 2012
by AskMonty KB 18 Mar '14

18 Mar '14

Hello, A new question has been asked in "Client libraries" by olivierf77: -------------------------------- Hello, I have installed MariaDB 5.6 , and its works perfectly. Thanks to all the MariaDB team. I also installed (by *.msi) mariaDB_client-1-0-0_win64 in c:\L\SQLClient\mariadb_client-1.0.0-win64\ + added paths as follow in project properties: INCLUDE DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\mariadbclient\include;$(IncludePath) LIBRARY DIRECTORIES = C:\L\SQLClient\mariadb_client-1.0.0-win64\lib;$(LibraryPath) However, when trying to use it even with the most simple programs, compilation is OK, **BUT** linking fails: --- my minimal c++ program (c++ console under Visual Studio 2012 --- #include "stdafx.h" #include <mysql.h> int _tmain(int argc, _TCHAR* argv[]) { MYSQL *my; my = mysql_init(NULL); } -- end of program -- BUILDING PROJETS -> following error msg: 1>------ Build started: Project: cppconMariaDB02, Configuration: Debug Win32 ------ 1>cppconMariaDB02.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _wmain 1>c:\users\olivier\documents\visual studio 2012\Projects\cppconMariaDB02\Debug\cppconMariaDB02.exe : fatal error LNK1120: 1 unresolved externals ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== Every mysql function gets the same "unresolved external symbol" error, even though I believe I did specify the path to the directory containing the 3 files "libmariadb.dll, libmariadb.lib & mariadbclient.lib", which I even tried (for testing purposes only, and with no better results) to copy into windows/system32. I have spent a lot of time on this issue, with no success. I did see that this question was asked several times on several programming sites, but it never gets any answer. As additional info, here is my directory for the c mariadb_client client: Directory of c:\L\SQLClient\mariadb_client-1.0.0-win64 <DIR> .. docs examples html lib libmysql mariadbclient mysql_config unittest zlib I hope that the above information (and question) is clear and complete, but not over verbose, and that someone in your team will have a few seconds to answer my query, even though the answer may be trivial (at least for him). And once again, many thanks for a very nice product. Sincerely yours Olivier, Paris, France PS And hello to Michael 'Monty' Widenus, whom I met in Paris six months ago. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb_client-1-0-0_win64-in-visual-studio-2012/

1 0

[Maria-discuss] Mariadb Java Driver useOldAliasMetadataBehavior and useColumnNamesInFindColumn
by Peter Mclarty 18 Mar '14

18 Mar '14

Hi Our context file presently has the useOldAliasMetadataBehavior=true in it to handle select count(*) as Bignumber type scenarios.( select as as b from table ) We tried using the mariadb driver as we have started the journey to using mariadb.5.5 and had a meltdown in our app (dev only thanks). I have done some research and it as i read it the mariadb code doesn't honour that parameter. I have done some research and one article stated With JDBC drivers version 4.0 and later you will eventually not get the aliasName As i haven't fully digested the JDBC 4.0 spec, barely scratched the surface am I right to conclude Maria and MySQL drivers will not eventually support this behavior and what is the approach to this using aliases or the selact a as b type scenario. Just point me to the pages is fine Any assistance appreciated Cheers -- *Peter McLarty* *Data Analyst DBA* Compare The Market -- Compare The Market is a brand and trading name of Compare The Market (Pty) Ltd (CTM). This email is for the intended addressee and is confidential and subject to copyright. If you are not the intended addressee, confidentiality has not been waived and any use, interference with, or disclosure of this email is unauthorised. If you are not the intended addressee please immediately notify CTM and then delete the email. CTM does not warrant that this email is error or virus free.

1 0