August 2015 - discuss - lists.mariadb.org

[Maria-discuss] Galera 23.2.7 mariadb 5.5.33a msvc 1600 binaries available
by Yann Nayn 18 Nov '24

18 Nov '24

Binaries have been uploaded for both x86 and amd64 platforms. due to github file size limitations , the directories have been uploaded unarchived. for Win33 binaries , please checkout https://github.com/YannNayn/galera-mariadb-win32.git and for Win64(amd64) binaries (being uploaded/pushed): https://github.com/YannNayn/galera-mariadb-win64.git they are not recommended for a production environment. in the my.cnf file: _________ wsrep_provider=galera_smm.dll wsrep_sst_method=msqldump # percona xtrabackup will be tested soon _________ libevent and openssl(the provided binaries use respectively 2.1.3-alpha and 1.1.0-dev versions ) will be added next on github some limitations are stated on openssl website copied here for convenience: ____________ from http://www.openssl.org/ ____________ This software package uses strong cryptography, so even if it is created, maintained and distributed from liberal countries in Europe (where it is legal to do this), it falls under certain export/import and/or use restrictions in some other parts of the world. PLEASE REMEMBER THAT EXPORT/IMPORT AND/OR USE OF STRONG CRYPTOGRAPHY SOFTWARE, PROVIDING CRYPTOGRAPHY HOOKS OR EVEN JUST COMMUNICATING TECHNICAL DETAILS ABOUT CRYPTOGRAPHY SOFTWARE IS ILLEGAL IN SOME PARTS OF THE WORLD. SO, WHEN YOU IMPORT THIS PACKAGE TO YOUR COUNTRY, RE-DISTRIBUTE IT FROM THERE OR EVEN JUST EMAIL TECHNICAL SUGGESTIONS OR EVEN SOURCE PATCHES TO THE AUTHOR OR OTHER PEOPLE YOU ARE STRONGLY ADVISED TO PAY CLOSE ATTENTION TO ANY EXPORT/IMPORT AND/OR USE LAWS WHICH APPLY TO YOU. THE AUTHORS OF OPENSSL ARE NOT LIABLE FOR ANY VIOLATIONS YOU MAKE HERE. SO BE CAREFUL, IT IS YOUR RESPONSIBILITY. ________________________________________________ msvc 1600 redistributables SP1 need to be installed/available on the target machine: vcredist_x86.exe : http://www.microsoft.com/en-us/download/details.aspx?id=8328 vcredist_x64.exe : http://www.microsoft.com/en-us/download/details.aspx?id=13523 MSys binaries are provided and msqld.bat should then be used instead of mysqld.exe (e.g. mysld.bat --console --wsrep_cluster_address=gcomm:// ) in order to have a working sh shell(cygwin has been proved to do it as well) Please note that oqgraph is disabled (boost trunk is used , that is 1.55) Comments and suggestions are welcome.

2 1

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] WHY re TMM files never removed in 10.0.x
by Reindl Harald 20 Sep '15

20 Sep '15

i was flooded once again with mcron-mails "ERROR 144 (HY000) at line 1: Table './asterisk/cdr' is marked as crashed and last (automatic?) repair failed" well, because mariadb creates such temp files and don't remove them which makes myisam-recover-options = "FORCE" useless -rw-rw---- 1 mysql mysql 0 2015-08-21 13:47 cdr.TMM MariaDB [asterisk]> optimize table cdr; +--------------+----------+----------+------------------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+----------+----------+------------------------------------------------------------------------+ | asterisk.cdr | optimize | error | Can't create new tempfile: '/Volumes/dune/mysql_data/asterisk/cdr.TMM' | | asterisk.cdr | optimize | status | Operation failed | +--------------+----------+----------+------------------------------------------------------------------------+

2 5

[Maria-discuss] Cross compile issue
by Johnson Cheng 18 Sep '15

18 Sep '15

Hi, I have problem to do cross compile on mariadb-10.0.21. Where can I find the relative document? Best Regards, Johnson

2 17

[Maria-discuss] New Question: Login Question
by AskMonty KB 31 Aug '15

31 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/login-question/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to log into a remote MairaDB and keep getting Host [IP] is not allowed to connect to this mariadb server. {client side} tried both mysql -p --port=3307 -h [hostname] mysql -p --port=3307 -h [hostname.domain.xxx] {server side} mysql login accounts tried user/root @ %.domain.xxx user/root @ hostname% Both client and server are in DNS and resolvable. What or how does mariadb determine when to use an IP vs hostname with connection security ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/login-question/

1 0

[Maria-discuss] Double linked list
by Roberto Spadim 28 Aug '15

28 Aug '15

hi guys, i'm with some doibts... I'm trying to replicate a double linked list, my information is: 1) insert at position xxx (and move others to next position) 2) update position yyyy 3) change position zzz with www 4) delete position xxxx to vvvv 5) return all positions 6) return positions with value > zzz My doubt is... I have only one writer and many many readers, writer can't be blocked for more than 1-3 seconds Some times i need to read history (functions 1 to 6) and recreate the linked list at a point in time List is something like: Position - json structure (arraylist in c#) like 0-[0,1,2,4,5] 1-[2.3,4,8,0] It update very fast, minimal update interval is 0.001second (max of 1000updates per second) for each list I will have 100-2000 lists --- Doubts : 1) Whats the best method to create the current double linked list? (The list positioned at last operatiom) A memory table? A row level lock table? A cache solution (memcached) with only one key-value and value with the full list? 2) considering a table: 2.1)what the best method to change position? Update set position=if() where position in (xxx, yyy) In this case what should be the primary key? If i use positionas primary key in this update i cam have non unique values... 2.2) ehat to do with delete/inserts? Insert+update positions? Delete+update positions? 3) any idea if oqgraph could solve this or if there's a storage engine solving this problem? Thanks guys :) -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] random non-zero exit status 1
by Reindl Harald 26 Aug '15

26 Aug '15

on machines mysqld mysqld regulary for backup reasons i observe over months now *randomly* starting mysqld fails because exit-code 1 leading in systemd stop the service and start it again while the is no single indication on the mysqld error-log anybody else? ________________________________________________________________________________ Aug 26 01:45:02 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:03 buildserver systemd: Stopped MariaDB Database. Aug 26 01:45:10 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:10 buildserver mysqld: 150826 1:45:10 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31936 ... Aug 26 01:45:10 buildserver systemd: mysqld.service: control process exited, code=exited status=1 Aug 26 01:45:12 buildserver systemd: Failed to start MariaDB Database. Aug 26 01:45:12 buildserver systemd: Unit mysqld.service entered failed state. Aug 26 01:45:12 buildserver systemd: mysqld.service failed. Aug 26 01:45:13 buildserver systemd: mysqld.service holdoff time over, scheduling restart. Aug 26 01:45:14 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:14 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:14 buildserver mysqld: 150826 1:45:14 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31988 ... Aug 26 01:45:14 buildserver systemd: Started MariaDB Database. ________________________________________________________________________________ 150826 1:45:02 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:02 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:02 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:02 [Note] InnoDB: Starting shutdown... 150826 1:45:03 [Note] InnoDB: Shutdown completed; log sequence number 17271831 150826 1:45:03 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:10 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:10 [Note] InnoDB: Memory barrier is not used 150826 1:45:10 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:10 [Note] InnoDB: Using Linux native AIO 150826 1:45:10 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:10 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:10 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:10 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:10 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:10 [Note] InnoDB: Waiting for purge to start 150826 1:45:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271831 150826 1:45:10 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:10 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:10 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:10 [Note] Event Scheduler: Loaded 0 events 150826 1:45:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge 150826 1:45:10 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:10 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:10 [Note] InnoDB: Starting shutdown... 150826 1:45:12 [Note] InnoDB: Shutdown completed; log sequence number 17271841 150826 1:45:12 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:14 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:14 [Note] InnoDB: Memory barrier is not used 150826 1:45:14 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:14 [Note] InnoDB: Using Linux native AIO 150826 1:45:14 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:14 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:14 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:14 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:14 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:14 [Note] InnoDB: Waiting for purge to start 150826 1:45:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271841 150826 1:45:14 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:14 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:14 [Note] Event Scheduler: Loaded 0 events 150826 1:45:14 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge

1 0

[Maria-discuss] New Question: MariaDB 10.1 system variables
by AskMonty KB 26 Aug '15

26 Aug '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by diptijoshi. Please answer it at http://mariadb.com/kb/en/mariadb-101-system-variables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the difference between MariaDB 10.1 and MySQL 5.6 system variables ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-101-system-variables/

1 0

[Maria-discuss] New Question: SET Variable statement
by AskMonty KB 24 Aug '15

24 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/set-variable-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to write a SQL script that creates a database and a few other things. I'm having trouble with a user defined variable statement. SET @dbname = CAST(trees AS VARCHAR(10)); comes directly from https://mariadb.com/kb/en/mariadb/user-defined-variables/ And I keep getting --> Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(10))' at line 1 Running MariaDB 10.0.20 on SLES 12, I have no idea what the problem is ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/set-variable-statement/

1 0

[Maria-discuss] New Question: Visual Studio - MariaDB - Entity Framework 6+
by AskMonty KB 23 Aug '15

23 Aug '15

Hello, A new question has been asked in "MariaDB FAQ" by vaclav. Please answer it at http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Dear Specialists, We can use at the moment "Visual Studio ADO.NET Driver for MySQL" (https://www.mysql.com/products/connector/) and also there was lots of work done with Visual Studio Integration for MySQL. (http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html) The question is while now it is compatible with MariaDB and I can use MariaDB instead of MySQL, how long if at all there will be a point when this won't become anymore compatible. Is this connection compatibility related with a core or some layer in MariaDB which doesn't change and so it should be working in the future. The reason I am asking is to decide with the strategy. I am testing MariaDB with Entity Framework and the driver/connection mentioned above and it is working but what if you deviate from the connectivity at certain point? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/

1 0