- discuss - lists.mariadb.org

Re: [Maria-discuss] MariaDB Galera Cluster version 10.0 incompatible with the version 5.5
by Eric Kom 02 May '14

02 May '14

On 5/1/2014 12:04 PM, Jan Lindström wrote: > Hi Eric, > Hi Jan, > Can you share the error log from 5.5 when it refused to joint to the > cluster, please ? Please see below the syslog for mysql: Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: wsrep_load(): Galera 25.3.2-wheezy(rXXXX) by Codership Oy <info(a)codership.com> loade d successfully. Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm. Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Warning] WSREP: Could not open saved state file for reading: /var/lib/mysql//grastate.dat Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Passing config to GCS: base_host = 10.0.0.65; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_siz e = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gc s.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: wsrep_sst_grab() Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Start replication Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: protonet asio version 0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Using CRC-32C (optimized) for message checksums. Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: backend: asio Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: GMCast version 0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: (5940a401-d06d-11e3-94ce-7e204e80941d, 'tcp://0.0.0.0:4567') listening at tcp://0.0. 0.0:4567 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: (5940a401-d06d-11e3-94ce-7e204e80941d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: EVS version 0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: PC version 0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: gcomm: bootstrapping new group 'kom_wsrep_cluster' Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Node 5940a401-d06d-11e3-94ce-7e204e80941d state prim Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: view(view_id(PRIM,5940a401-d06d-11e3-94ce-7e204e80941d,1) memb { Apr 30 15:43:01 db65 mysqld: #0115940a401-d06d-11e3-94ce-7e204e80941d,0 Apr 30 15:43:01 db65 mysqld: } joined { Apr 30 15:43:01 db65 mysqld: } left { Apr 30 15:43:01 db65 mysqld: } partitioned { Apr 30 15:43:01 db65 mysqld: }) Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.62:4567 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr proto entry 0x7f9538ce3380 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.63:4567 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr proto entry 0x7f9538ce3440 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.64:4567 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr proto entry 0x7f9538ce3500 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr without UUID: tcp://10.0.0.65:4567 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: discarding pending addr proto entry 0x7f9538ce35c0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: gcomm: connected Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Opened channel 'kom_wsrep_cluster' Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Waiting for SST to complete. Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Starting new group from scratch: 5942929c-d06d-11e3-8540-372215cc2396 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 5942c362-d06d-11e3-b9bc-bba43078f040 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: STATE EXCHANGE: sent state msg: 5942c362-d06d-11e3-b9bc-bba43078f040 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: STATE EXCHANGE: got state msg: 5942c362-d06d-11e3-b9bc-bba43078f040 from 0 (db65) Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Quorum results: Apr 30 15:43:01 db65 mysqld: #011version = 3, Apr 30 15:43:01 db65 mysqld: #011component = PRIMARY, Apr 30 15:43:01 db65 mysqld: #011conf_id = 0, Apr 30 15:43:01 db65 mysqld: #011members = 1/1 (joined/total), Apr 30 15:43:01 db65 mysqld: #011act_id = 0, Apr 30 15:43:01 db65 mysqld: #011last_appl. = -1, Apr 30 15:43:01 db65 mysqld: #011protocols = 0/5/2 (gcs/repl/appl), Apr 30 15:43:01 db65 mysqld: #011group UUID = 5942929c-d06d-11e3-8540-372215cc2396 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Flow-control interval: [16, 16] Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Restored state OPEN -> JOINED (0) Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Member 0 (db65) synced with group. Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 0) Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: New cluster view: global state: 5942929c-d06d-11e3-8540-372215cc2396:0, view# 1: Pri mary, number of nodes: 1, my index: 0, protocol version 2 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 [Note] WSREP: SST complete, seqno: 0 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: The InnoDB memory heap is disabled Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: Compressed tables use zlib 1.2.7 Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: Using Linux native AIO Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: Initializing buffer pool, size = 256.0M Apr 30 15:43:01 db65 mysqld: 140430 15:43:01 InnoDB: Completed initialization of buffer pool Apr 30 15:43:02 db65 mysqld: 140430 15:43:02 InnoDB: highest supported file format is Barracuda. Apr 30 15:43:02 db65 mysqld: 140430 15:43:02 InnoDB: Waiting for the background threads to start Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1598139 Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] Plugin 'FEEDBACK' is disabled. Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] Server socket created on IP: '0.0.0.0'. Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] Event Scheduler: Loaded 0 events Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] /usr/sbin/mysqld: ready for connections. Apr 30 15:43:03 db65 mysqld: Version: '5.5.36-MariaDB-1~wheezy-wsrep-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binar y distribution, wsrep_25.9.r3961 Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: REPL Protocols: 5 (3, 1) Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: Service thread queue flushed. Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: Synchronized with group, ready for connections Apr 30 15:43:03 db65 mysqld: 140430 15:43:03 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Apr 30 15:43:03 db65 /etc/mysql/debian-start[6832]: Upgrading MySQL tables if necessary. Apr 30 15:43:04 db65 /etc/mysql/debian-start[6836]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Apr 30 15:43:04 db65 /etc/mysql/debian-start[6836]: Looking for 'mysql' as: /usr/bin/mysql Apr 30 15:43:04 db65 /etc/mysql/debian-start[6836]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Apr 30 15:43:04 db65 /etc/mysql/debian-start[6836]: This installation of MySQL is already upgraded to 5.5.36-MariaDB, use --force if you still need to run mysql_upgrade Apr 30 15:43:04 db65 /etc/mysql/debian-start[6851]: Checking for insecure root accounts. Apr 30 15:43:04 db65 /etc/mysql/debian-start[6856]: Triggering myisam-recover for all MyISAM tables Apr 30 15:49:24 db65 mysqld: 140430 15:49:24 [Warning] Access denied for user 'root'@'localhost' (using password: NO) Apr 30 15:50:27 db65 mysqld: 140430 15:50:27 [Warning] Access denied for user 'root'@'localhost' (using password: NO) Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] /usr/sbin/mysqld: Normal shutdown Apr 30 15:58:49 db65 mysqld: Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Stop replication Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Closing send monitor... Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Closed send monitor. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: gcomm: terminating thread Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: gcomm: joining thread Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: gcomm: closing backend Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: view((empty)) Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Received self-leave message. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: gcomm: closed Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Flow-control interval: [0, 0] Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Received SELF-LEAVE. Closing connection. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 0) Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: RECV thread exiting 0: Success Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: New cluster view: global state: 5942929c-d06d-11e3-8540-372215cc2396:0, view# -1: no n-Primary, number of nodes: 0, my index: -1, protocol version 2 Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: recv_thread() joined. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Closing replication queue. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: Closing slave action queue. Apr 30 15:58:49 db65 mysqld: 140430 15:58:49 [Note] WSREP: applier thread exiting (code:0) Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: rollbacker thread exiting Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] Event Scheduler: Purging the queue. 0 events Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: dtor state: CLOSED Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: apply mon: entered 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: apply mon: entered 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: cert index usage at exit 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: cert trx map usage at exit 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: deps set usage at exit 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: avg deps dist 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 0) Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 [Note] WSREP: Flushing memory map to disk... Apr 30 15:58:51 db65 mysqld: 140430 15:58:51 InnoDB: Starting shutdown... Apr 30 15:58:52 db65 mysqld: 140430 15:58:52 InnoDB: Shutdown completed; log sequence number 1598293 Apr 30 15:58:52 db65 mysqld: 140430 15:58:52 [Note] /usr/sbin/mysqld: Shutdown complete Apr 30 15:58:52 db65 mysqld: Apr 30 15:58:52 db65 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Apr 30 16:03:32 db65 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Apr 30 16:03:32 db65 mysqld_safe: WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.34Qk5U' --pid-file='/var/lib /mysql/db65-recover.pid' Apr 30 16:03:35 db65 mysqld_safe: WSREP: Recovered position 5942929c-d06d-11e3-8540-372215cc2396:0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: wsrep_start_position var submitted: '5942929c-d06d-11e3-8540-372215cc2396:0' Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Read nil XID from storage engines, skipping position init Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib/galera/libgalera_smm.so' Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: wsrep_load(): Galera 25.3.2-wheezy(rXXXX) by Codership Oy <info(a)codership.com> loade d successfully. Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm. Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Found saved state: 5942929c-d06d-11e3-8540-372215cc2396:0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Passing config to GCS: base_host = 10.0.0.65; base_port = 4567; cert.log_conflicts = no; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_siz e = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1; gcs.fc_limit = 16; gcs.fc_master_slave = NO; gcs.max_packet_size = 64500; gc s.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = NO; repl.causal_read_timeout = PT30S; repl.commit_order = 3; repl.key_format = FLAT8; repl.proto_max = 5 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Assign initial position for certification: 0, protocol version: -1 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: wsrep_sst_grab() Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Start replication Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Setting initial position to 5942929c-d06d-11e3-8540-372215cc2396:0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: protonet asio version 0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: Using CRC-32C (optimized) for message checksums. Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: backend: asio Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: GMCast version 0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') listening at tcp://0.0. 0.0:4567 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: EVS version 0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: PC version 0 Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: gcomm: connecting to group 'kom_wsrep_cluster', peer '10.0.0.62:,10.0.0.63:,10.0.0.6 4:,10.0.0.65:' Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Warning] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0. 0.65:4567' points to own listening address, blacklisting Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: (386aadec-d070-11e3-801b-a63af238b289, 'tcp://0.0.0.0:4567') address 'tcp://10.0.0.6 5:4567' pointing to uuid 386aadec-d070-11e3-801b-a63af238b289 is blacklisted, skipping Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: declaring 1124381f-d070-11e3-b129-bf8f84b28b14 stable Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: declaring c6d4dcad-d06f-11e3-b556-667aa2e751ca stable Apr 30 16:03:35 db65 mysqld: 140430 16:03:35 [Note] WSREP: declaring d4e40948-d06f-11e3-a8a9-8ff215511f2f stable Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Node 1124381f-d070-11e3-b129-bf8f84b28b14 state prim Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: view(view_id(PRIM,1124381f-d070-11e3-b129-bf8f84b28b14,5) memb { Apr 30 16:03:36 db65 mysqld: #0111124381f-d070-11e3-b129-bf8f84b28b14,0 Apr 30 16:03:36 db65 mysqld: #011386aadec-d070-11e3-801b-a63af238b289,0 Apr 30 16:03:36 db65 mysqld: #011c6d4dcad-d06f-11e3-b556-667aa2e751ca,0 Apr 30 16:03:36 db65 mysqld: #011d4e40948-d06f-11e3-a8a9-8ff215511f2f,0 Apr 30 16:03:36 db65 mysqld: } joined { Apr 30 16:03:36 db65 mysqld: } left { Apr 30 16:03:36 db65 mysqld: } partitioned { Apr 30 16:03:36 db65 mysqld: }) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: gcomm: connected Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Opened channel 'kom_wsrep_cluster' Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 1, memb_num = 4 Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: Waiting for state UUID. Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: sent state msg: 39c599f2-d070-11e3-afbf-3e07438fadfe Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Waiting for SST to complete. Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: got state msg: 39c599f2-d070-11e3-afbf-3e07438fadfe from 0 (db64) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: got state msg: 39c599f2-d070-11e3-afbf-3e07438fadfe from 3 (db63) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: got state msg: 39c599f2-d070-11e3-afbf-3e07438fadfe from 2 (db62) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: STATE EXCHANGE: got state msg: 39c599f2-d070-11e3-afbf-3e07438fadfe from 1 (db65) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Quorum results: Apr 30 16:03:36 db65 mysqld: #011version = 3, Apr 30 16:03:36 db65 mysqld: #011component = PRIMARY, Apr 30 16:03:36 db65 mysqld: #011conf_id = 3, Apr 30 16:03:36 db65 mysqld: #011members = 3/4 (joined/total), Apr 30 16:03:36 db65 mysqld: #011act_id = 0, Apr 30 16:03:36 db65 mysqld: #011last_appl. = -1, Apr 30 16:03:36 db65 mysqld: #011protocols = 0/5/2 (gcs/repl/appl), Apr 30 16:03:36 db65 mysqld: #011group UUID = 869942f0-d06d-11e3-b7cd-e255df31948c Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Flow-control interval: [32, 32] Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 0) Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: State transfer required: Apr 30 16:03:36 db65 mysqld: #011Group state: 869942f0-d06d-11e3-b7cd-e255df31948c:0 Apr 30 16:03:36 db65 mysqld: #011Local state: 5942929c-d06d-11e3-8540-372215cc2396:0 Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Note] WSREP: New cluster view: global state: 869942f0-d06d-11e3-b7cd-e255df31948c:0, view# 4: Pri mary, number of nodes: 4, my index: 1, protocol version 2 Apr 30 16:03:36 db65 mysqld: 140430 16:03:36 [Warning] WSREP: Gap in state sequence. Need state transfer. Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '10.0.0.65' --auth '' --datadir '/var/lib/mysql/' --defaults-file '/etc/mysql/my.cnf' --parent '7843'' Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Prepared SST request: rsync|10.0.0.65:4444/rsync_sst Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: REPL Protocols: 5 (3, 1) Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Assign initial position for certification: 0, protocol version: 3 Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Service thread queue flushed. Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (5942929c-d06d -11e3-8540-372215cc2396) does not match group state UUID (869942f0-d06d-11e3-b7cd-e255df31948c): 1 (Operation not permitted) Apr 30 16:03:39 db65 mysqld: #011 at galera/src/replicator_str.cpp:prepare_for_IST():445. IST will be unavailable. Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Node 1.0 (db65) requested state transfer from '*any*'. Selected 0.0 (db64)(SYNCED) a s donor. Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 0) Apr 30 16:03:39 db65 mysqld: 140430 16:03:39 [Note] WSREP: Requesting state transfer: success, donor: 0 Apr 30 16:03:51 db65 rsyncd[8107]: rsync to rsync_sst/./mysql from UNKNOWN (10.0.0.64) Apr 30 16:03:52 db65 mysqld: 140430 16:03:52 [Note] WSREP: 0.0 (db64): State transfer to 1.0 (db65) complete. Apr 30 16:03:52 db65 mysqld: 140430 16:03:52 [Note] WSREP: Member 0 (db64) synced with group. Apr 30 16:03:52 db65 mysqld: WSREP_SST: [INFO] Joiner cleanup. (20140430 16:03:52.890) Apr 30 16:03:53 db65 mysqld: WSREP_SST: [INFO] Joiner cleanup done. (20140430 16:03:53.416) Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 [Note] WSREP: SST complete, seqno: 0 Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: The InnoDB memory heap is disabled Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: Compressed tables use zlib 1.2.7 Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: Using Linux native AIO Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: Initializing buffer pool, size = 256.0M Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 InnoDB: Completed initialization of buffer pool Apr 30 16:03:53 db65 mysqld: InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes Apr 30 16:03:53 db65 mysqld: InnoDB: than specified in the .cnf file 0 5242880 bytes! Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 [ERROR] Plugin 'InnoDB' init function returned error. Apr 30 16:03:53 db65 mysqld: 140430 16:03:53 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Apr 30 16:03:54 db65 mysqld: 140430 16:03:54 [Note] Plugin 'FEEDBACK' is disabled. Apr 30 16:03:54 db65 mysqld: 140430 16:03:54 [ERROR] Unknown/unsupported storage engine: innodb Apr 30 16:03:54 db65 mysqld: 140430 16:03:54 [ERROR] Aborting Apr 30 16:03:54 db65 mysqld: Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Closing send monitor... Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Closed send monitor. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: gcomm: terminating thread Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: gcomm: joining thread Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: gcomm: closing backend Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: view(view_id(NON_PRIM,1124381f-d070-11e3-b129-bf8f84b28b14,5) memb { Apr 30 16:03:56 db65 mysqld: #011386aadec-d070-11e3-801b-a63af238b289,0 Apr 30 16:03:56 db65 mysqld: } joined { Apr 30 16:03:56 db65 mysqld: } left { Apr 30 16:03:56 db65 mysqld: } partitioned { Apr 30 16:03:56 db65 mysqld: #0111124381f-d070-11e3-b129-bf8f84b28b14,0 Apr 30 16:03:56 db65 mysqld: #011c6d4dcad-d06f-11e3-b556-667aa2e751ca,0 Apr 30 16:03:56 db65 mysqld: #011d4e40948-d06f-11e3-a8a9-8ff215511f2f,0 Apr 30 16:03:56 db65 mysqld: }) Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: view((empty)) Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1 Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: gcomm: closed Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Flow-control interval: [16, 16] Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Received NON-PRIMARY. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Shifting JOINER -> OPEN (TO: 0) Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Received self-leave message. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Flow-control interval: [0, 0] Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Received SELF-LEAVE. Closing connection. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Shifting OPEN -> CLOSED (TO: 0) Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: RECV thread exiting 0: Success Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: recv_thread() joined. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Closing replication queue. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Closing slave action queue. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: Service disconnected. Apr 30 16:03:56 db65 mysqld: 140430 16:03:56 [Note] WSREP: rollbacker thread exiting Apr 30 16:03:57 db65 mysqld: 140430 16:03:57 [Note] WSREP: Some threads may fail to exit. Apr 30 16:03:57 db65 mysqld: 140430 16:03:57 [Note] /usr/sbin/mysqld: Shutdown complete Apr 30 16:03:57 db65 mysqld: Apr 30 16:04:02 db65 mysqld: Error in my_thread_global_end(): 1 threads didn't exit Apr 30 16:04:02 db65 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Apr 30 16:04:04 db65 /etc/init.d/mysql[8309]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted i n Apr 30 16:04:04 db65 /etc/init.d/mysql[8309]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Apr 30 16:04:04 db65 /etc/init.d/mysql[8309]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' Apr 30 16:04:04 db65 /etc/init.d/mysql[8309]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Apr 30 16:04:04 db65 /etc/init.d/mysql[8309]: Apr 30 16:04:19 db65 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Apr 30 16:04:19 db65 mysqld_safe: WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.soIOZM' --pid-file='/var/lib /mysql/db65-recover.pid' Apr 30 16:04:20 db65 mysqld_safe: WSREP: Failed to recover position: #012'140430 16:04:19 InnoDB: The InnoDB memory heap is disabled#012140430 16:04:19 InnoDB: Mutexes and rw_locks use GCC atomic builtins#012140430 16:04:19 InnoDB: Compressed tables use zlib 1.2.7#012140430 16:04:19 In noDB: Using Linux native AIO#012140430 16:04:19 InnoDB: Initializing buffer pool, size = 256.0M#012140430 16:04:20 InnoDB: Completed initializa tion of buffer pool#012InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes#012InnoDB: than specified in the .cnf file 0 5242880 bytes!#012140430 16:04:20 [ERROR] Plugin 'InnoDB' init function returned error.#012140430 16:04:20 [ERROR] Plugin 'InnoDB' registratio n as a STORAGE ENGINE failed.#012140430 16:04:20 [Note] Plugin 'FEEDBACK' is disabled.#012140430 16:04:20 [ERROR] Unknown/unsupported storage e ngine: innodb#012140430 16:04:20 [ERROR] Aborting#012#012140430 16:04:20 [Note] /usr/sbin/mysqld: Shutdown complete' Apr 30 16:04:49 db65 /etc/init.d/mysql[9512]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted i n Apr 30 16:04:49 db65 /etc/init.d/mysql[9512]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Apr 30 16:04:49 db65 /etc/init.d/mysql[9512]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Apr 30 16:04:49 db65 /etc/init.d/mysql[9512]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Apr 30 16:04:49 db65 /etc/init.d/mysql[9512]: Apr 30 16:04:56 db65 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Apr 30 16:04:56 db65 mysqld_safe: WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.lmU7Ap' --pid-file='/var/lib /mysql/db65-recover.pid' Apr 30 16:04:57 db65 mysqld_safe: WSREP: Failed to recover position: #012'140430 16:04:56 InnoDB: The InnoDB memory heap is disabled#012140430 16:04:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins#012140430 16:04:56 InnoDB: Compressed tables use zlib 1.2.7#012140430 16:04:56 In noDB: Using Linux native AIO#012140430 16:04:56 InnoDB: Initializing buffer pool, size = 256.0M#012140430 16:04:56 InnoDB: Completed initializa tion of buffer pool#012InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes#012InnoDB: than specified in the .cnf file 0 5242880 bytes!#012140430 16:04:57 [ERROR] Plugin 'InnoDB' init function returned error.#012140430 16:04:57 [ERROR] Plugin 'InnoDB' registratio n as a STORAGE ENGINE failed.#012140430 16:04:57 [Note] Plugin 'FEEDBACK' is disabled.#012140430 16:04:57 [ERROR] Unknown/unsupported storage e ngine: innodb#012140430 16:04:57 [ERROR] Aborting#012#012140430 16:04:57 [Note] /usr/sbin/mysqld: Shutdown complete' Apr 30 16:05:26 db65 /etc/init.d/mysql[10715]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Apr 30 16:05:26 db65 /etc/init.d/mysql[10715]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed Apr 30 16:05:26 db65 /etc/init.d/mysql[10715]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Apr 30 16:05:26 db65 /etc/init.d/mysql[10715]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! Apr 30 16:05:26 db65 /etc/init.d/mysql[10715]: Apr 30 16:08:37 db65 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Apr 30 16:08:37 db65 mysqld_safe: WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.Cju4Ru' --pid-file='/var/lib /mysql/db65-recover.pid' Apr 30 16:08:38 db65 mysqld_safe: WSREP: Failed to recover position: #012'140430 16:08:38 InnoDB: The InnoDB memory heap is disabled#012140430 16:08:38 InnoDB: Mutexes and rw_locks use GCC atomic builtins#012140430 16:08:38 InnoDB: Compressed tables use zlib 1.2.7#012140430 16:08:38 In noDB: Using Linux native AIO#012140430 16:08:38 InnoDB: Initializing buffer pool, size = 256.0M#012140430 16:08:38 InnoDB: Completed initializa tion of buffer pool#012InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes#012InnoDB: than specified in the .cnf file 0 5242880 bytes!#012140430 16:08:38 [ERROR] Plugin 'InnoDB' init function returned error.#012140430 16:08:38 [ERROR] Plugin 'InnoDB' registratio n as a STORAGE ENGINE failed.#012140430 16:08:38 [Note] Plugin 'FEEDBACK' is disabled.#012140430 16:08:38 [ERROR] Unknown/unsupported storage e ngine: innodb#012140430 16:08:38 [ERROR] Aborting#012#012140430 16:08:38 [Note] /usr/sbin/mysqld: Shutdown complete' Apr 30 16:09:07 db65 /etc/init.d/mysql[11918]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in > > R: Jan >> >> On 5/1/2014 11:01 AM, Jan Lindström wrote: >>> Hi, >>> >>> It depends on exact version you had on 5.5, can you share us the >>> exact version and error messages you got ? >>> mariadb-5.5.35 should be compatible with 10.0, but earlier 5.5 >>> versions are not because they use older Galera >>> cluster provider version 23.2.x when newer one you can use 25.2.x or >>> 25.3.x, >> mariadb-galera-server-5.5 (5.5.37+maria-1~wheezy) >>> >>> R: Jan >>>> Hi All, >>>> I'm new in the clustering, after installed 4 nodes with 3 having >>>> version 10.0 and another with version 5.5, this last did not want >>>> to join the cluster until I upgrade it to version 10.0. >>>> My question is, they is an incompatibility between the two versions? >>>> Thanks >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~maria-discuss >>>> Post to : maria-discuss(a)lists.launchpad.net >>>> Unsubscribe : https://launchpad.net/~maria-discuss >>>> More help : https://help.launchpad.net/ListHelp >>> >>> >>> -- >>> >>> -- >>> >>> Jan Lindström, Principal Engineer >>> SkySQL - The MariaDB Company >>> >>> MariaDB | MaxScale | skype: jan_p_lindstrom >>> >>> www.skysql.com <http://www.skysql.com/> >>> >>> Twitter <http://twitter.com/skysql> Blog >>> <http://www.skysql.com/blog/> Facebook >>> <http://www.facebook.com/skysql> LinkedIn >>> <http://www.linkedin.com/company/1214250> Google+ >>> <https://plus.google.com/117544963211695643458/posts> >>> >>> >>> >>> _______________________________________________ >>> Mailing list:https://launchpad.net/~maria-discuss >>> Post to :maria-discuss@lists.launchpad.net >>> Unsubscribe :https://launchpad.net/~maria-discuss >>> More help :https://help.launchpad.net/ListHelp >> > > > -- > > -- > > Jan Lindström, Principal Engineer > SkySQL - The MariaDB Company > > MariaDB | MaxScale | skype: jan_p_lindstrom > > www.skysql.com <http://www.skysql.com/> > > Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> > Facebook <http://www.facebook.com/skysql> LinkedIn > <http://www.linkedin.com/company/1214250> Google+ > <https://plus.google.com/117544963211695643458/posts> >

1 0

[Maria-discuss] clustering
by Eric Kom 01 May '14

01 May '14

Hi All, In the real wold of database cluster multi-master, if the application uses node01 to query the database, its happened that the node01 its down, the other nodes won't be accessible. What happen in that case?

1 0

Re: [Maria-discuss] warning after installing mariadb-galera-server-10.0
by Eric Kom 30 Apr '14

30 Apr '14

On 30 April 2014 21:58:13 SAST, Nirbhay Choubey <nirbhay(a)skysql.com> wrote: >Hi Eric, > >On Wed, Apr 30, 2014 at 10:07 AM, Eric Kom <erickom(a)kom.za.net> wrote: > >> Hi All, >> >> After successfully installed mariadb-galera-server-10.0 on my debian >> wheezy: >> sudo aptitude install rsync galera mariadb-galera-server >> >> I received the above warning: >> 140430 14:29:48 [Warning] Failed to load slave replication state from >> table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB' >> > >mysqld bootstrap command in debian post installation script wrongly >retained 'loose-innodb=OFF' >option, which disabled innodb. The script has been updated. > >https://mariadb.atlassian.net/browse/MDEV-6192 > >Thanks for reporting. Thanks for logged the bug and fixed it. > >-- Nirbhay > > >> >> >> -- >> Kind Regards >> >> Eric Kom >> >> Senior IT Manager - Metropolitan Schools >> _________________________________________ >> / You are scrupulously honest, frank, and \ >> | straightforward. Therefore you have few | >> \ friends. / >> ----------------------------------------- >> \ >> \ >> .--. >> |o_o | >> |:_/ | >> // \ \ >> (| Kom | ) >> /'\_ _/`\ >> \___)=(___/ >> >> 2 Hennie Van Till, White River, 1240 >> Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 >> erickom(a)kom.za.net | erickom(a)metropolitancollege.co.za >> www.kom.za.net | www.kom.za.org | www.erickom.co.za >> >> Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5 >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> -- Sent from my Android device with K-9 Mail. Please excuse my brevity.

1 0

[Maria-discuss] MariaDB Galera Cluster 5.5.37 now available
by Daniel Bartholomew 30 Apr '14

30 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.37 This is a Stable release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 5.5.37 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-5537-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-5537-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/5.5.37 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] warning after installing mariadb-galera-server-10.0
by Eric Kom 30 Apr '14

30 Apr '14

Hi All, After successfully installed mariadb-galera-server-10.0 on my debian wheezy: sudo aptitude install rsync galera mariadb-galera-server I received the above warning: 140430 14:29:48 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB' -- Kind Regards Eric Kom Senior IT Manager - Metropolitan Schools _________________________________________ / You are scrupulously honest, frank, and \ | straightforward. Therefore you have few | \ friends. / ----------------------------------------- \ \ .--. |o_o | |:_/ | // \ \ (| Kom | ) /'\_ _/`\ \___)=(___/ 2 Hennie Van Till, White River, 1240 Tel: 013 750 2255 | Fax: 013 750 0105 | Cell: 078 879 1334 erickom(a)kom.za.net | erickom(a)metropolitancollege.co.za www.kom.za.net | www.kom.za.org | www.erickom.co.za Key fingerprint: 513E E91A C243 3020 8735 09BB 2DBC 5AD7 A9DA 1EF5

1 0

[Maria-discuss] Name for Native MariaDB Client Library RPM
by Honza Horak 29 Apr '14

29 Apr '14

Hi guys, I'd like to package the native MariaDB client library as an RPM for Fedora. But I got into troubles when discussing the name of the RPM. In Fedora we have some rules about packages names and there are some other facts that need to be taken into account. These are restrictions I face: * not to use underscope unless absolutely necessary * follow upstream's name as much as possible (tarball is called mariadb_client-2.0.0-src.tar.gz) * we already have mariadb-libs and there might be mariadb-client packages in the future, if we start follow upstream naming for subpackages, so we cannot use mariadb-libs or mariadb-client Having these restrictions on my mind and seeing mariadb-native-client as a name for Windows installers, I think this would be also the best name for Fedora. In practice the packages will include these files: mariadb-native-client-2.0.0-1.fc20.x86_64.rpm /usr/lib64/mariadb/libmariadb.so.2 LICENSE, README, ... mariadb-native-client-devel-2.0.0-1.fc20.x86_64.rpm /usr/bin/mariadb_config /usr/include/mariadb/* /usr/lib64/mariadb/libmariadb.so /usr/lib64/mariadb/libmysql.so /usr/lib64/mariadb/libmysqlclient.so /usr/lib64/mariadb/libmysqlclient_r.so By this mail I'd like to check if you, MariaDB upstream, will be OK with that (no response means confirmation). Regards, Honza

1 0

[Maria-discuss] virtual columns and indexes on attributes in JSON objects
by MARK CALLAGHAN 26 Apr '14

26 Apr '14

Does the support for virtual columns allow an index to be created on an attribute in a JSON object stored in a BLOB column? http://falseisnotnull.wordpress.com/2014/04/25/descending-indexes-in-mariadb https://mariadb.com/kb/en/virtual-columns/ -- Mark Callaghan mdcallag(a)gmail.com

4 3

[Maria-discuss] New Question: Loading CSV files
by AskMonty KB 26 Apr '14

26 Apr '14

Hello, A new question has been asked in "CONNECT" by danielkrysiak: -------------------------------- Hi, I have data in CSV files. Partitioned inside a directory, one file per day, alive (constantly written to, insert at the end). I want to load them on-line (not once a day). Normally I would write peace of code, that remembers the last file and place, so it can easily go back and continue. But the Connect engine looks like a great ready solution for this kind of thing. I'm just not sure about: 1. I can't use indexes, because the file is changed all the time. Can I somehow make sure the data will be visible in a "connect table" always in the same order? 2. About "Multiple File Tables". Whats the order of data inside them? 3. What about simple file format change: add column at the end. Will data from older files be visible in "Multiple File Table" as null? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/loading-csv-files/

1 0

[Maria-discuss] New Question: Descending Indexes
by AskMonty KB 25 Apr '14

25 Apr '14

Hello, A new question has been asked in "MariaDB community" by juliobetta: -------------------------------- Does anyone know if MariaDB supports descending indexes? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/descending-indexes/

1 0

[Maria-discuss] New Question: TokuDB engine Installation problem
by AskMonty KB 25 Apr '14

25 Apr '14

Hello, A new question has been asked in "TokuDB" by johnzobolas: -------------------------------- Hi! I downloaded mariadb-10.0.10-linux-x86_64.tar.gz from your website to install and test MariaDB 10.0.10 and specifically the engine TokuDB (and Connect). My questions are: 1)My server's OS is: Ubuntu 12.04.1 LTS (GNU/Linux 3.2.0-29-generic x86_64). Is this supported for TokuDB engine or not? (after i installed mariaDB, there was no plugin for TokuDB (ha_tokudb.so?) in the plugins folder...) 2)Also with connect engine: there was indeed a file called ha_connect.so in the plugins folder and i used: install soname 'ha_connect'; and got: ERROR 1126 (HY000): Can't open shared library '/usr/local/mysql/lib/plugin/ha_connect.so' (errno: 2, libodbc.so.1: cannot open shared object file: No such file or directory). What is wrong here? (With the engines spider and sequence the above command is successfull and they were installed!). Thanks, John. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/tokudb-engine-installation-problem/

1 0

[Maria-discuss] New Question: don't you have pdf version document?
by AskMonty KB 25 Apr '14

25 Apr '14

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by zouweixing: -------------------------------- don't you have pdf version document? In fact, it is difficult to read document on you website. I want to download some full content pdf or html files so that I can read it easily. Just as MySQL and Percona did. Can you help me? Regards. Weixing Zou -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/dont-you-have-pdf-version-document/

1 0

[Maria-discuss] tokudb & replication
by Federico Razzoli 24 Apr '14

24 Apr '14

Hi list, I have a simple question. When SBR is used and we have TokuDB tables on the master, can READ COMMITTED be used? Regards, Federico

1 0

[Maria-discuss] New Question: MariaDB Galera
by AskMonty KB 22 Apr '14

22 Apr '14

Hello, A new question has been asked in "Galera" by zainalabidinmamat: -------------------------------- Hi, Does free version of MariaDB Galera support active-active cluster topology? Can it be write/read on both node? Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-galera/

1 0

[Maria-discuss] MariaDB Galera Cluster 10.0.10 now available
by Daniel Bartholomew 22 Apr '14

22 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.10 This is a Beta release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Galera Cluster 10.0.10 - Release Notes: https://mariadb.com/kb/en/mariadb-galera-cluster-10010-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-galera-cluster-10010-changelog - Downloads: https://downloads.mariadb.org/mariadb-galera/10.0.10 About MariaDB Galera Cluster: - https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] MariaDB 5.5.37 now available
by Daniel Bartholomew 17 Apr '14

17 Apr '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.37 This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.37 - Release Notes: https://mariadb.com/kb/en/mariadb-5537-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5537-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.37 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Work the master slave replication only with the same database name on server and client?
by AskMonty KB 17 Apr '14

17 Apr '14

Hello, A new question has been asked in "Replication" by wschwauer: -------------------------------- Work the master slave replication only with the same database name on server and client? So I can’t replicate the table cars from the server DB with name “serverdb” (serverdb.cars) to the client DB with name “client1” (client1.cars)? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/work-the-master-slave-replication-only-with-the-sa…

1 0

[Maria-discuss] Problem in Connect engine with XML default namespace
by Rasmus Johansson 17 Apr '14

17 Apr '14

Hello Olivier, I run into a problem in the Connect engine with XML default namespace. I've reported the problem in JIRA: https://mariadb.atlassian.net/browse/MDEV-6125 Best regards, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

2 1

[Maria-discuss] New Question: Connect to Excel
by AskMonty KB 17 Apr '14

17 Apr '14

Hello, A new question has been asked in "Connect" by arturpritzkau: -------------------------------- How can i connect to an Excel file? I try this: create table Customer engine=connect table_type=ODBC tabname='Sheet1' Connection='DSN=ExcelDSN;DBQ=C:/Test/test.xls;'; I get always get the message: SQL Fehler (1105): [Microsoft][ODBC Driver Manager] Der angegebene DSN weist eine nicht �bereinstimmende Architektur von Treiber und Anwendung auf. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-to-excel/

1 0

[Maria-discuss] MariaDB subquery
by James Qian Wang 15 Apr '14

15 Apr '14

Hi All, I have a query which shows type REF when explained in MySQL 5.5/5.6. However, the same query shows type INDEX in MariaDB 10.0.9 I.e. the query is a lot slower in MariaDB. Any one has the similar experience please? Please drop me a line. -- James Qian Wang

3 5

[Maria-discuss] New Question: MariaDB 10.0 installation errors on Linux Mint 16
by AskMonty KB 15 Apr '14

15 Apr '14

Hello, A new question has been asked in "MariaDB community" by israelbravo: -------------------------------- Trying to install as it is explained on https://downloads.mariadb.org/mariadb/repositories/#mirror=mephi&distro=Min… I get the following error messages: dpkg: error processing mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.0 (= 10.0.10+maria-1~saucy); however: Package mariadb-server-10.0 is not configured yet. dpkg: error processing mariadb-server (--configure): dependency problems - leaving unconfigured Processing triggers for libc-bin ... Processing triggers for menu ... Errors were encountered while processing: mariadb-server-10.0 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-100-installation-errors-on-linux-mint-16/

1 0

[Maria-discuss] InnoDB pain points
by Jan Lindström 14 Apr '14

14 Apr '14

Hi all, I would like to know the most affecting InnoDB pain points the customers/potential customers first refer. By pain point, I mean anything that causes concerns, restricts sales etc, pain point can be bug, missing feature, usage problem, performance etc. My goal on asking this question is to find out what are the real issues customers or potential customer are struggling or issues that block customers using MariaDB. After that I will see what I can do about the situation and plan forward to address the raised issues with proper priorities. Dean, if this list does to reach the support engineers and technical sales teams please forward to more suitable list. R: Jan -- Jan Lindström Principal Engineer MariaDB | MaxScale | skype: jan_p_lindstrom www.skysql.com <http://www.skysql.com/> Twitter <http://twitter.com/skysql> Blog <http://www.skysql.com/blog/> Facebook <http://www.facebook.com/skysql> LinkedIn <http://www.linkedin.com/company/1214250> Google+ <https://plus.google.com/117544963211695643458/posts>

14 24

[Maria-discuss] innodb_adaptive_flushing_method option in MariaDB 10.0
by Tsai Li Ming 11 Apr '14

11 Apr '14

Hi, I’m looking at the option innodb_adaptive_flushing_method in the docs but I see it has been removed in 10.0 and replaced? https://mariadb.com/kb/en/xtradbinnodb-server-system-variables/#innodb_adap… "Removed: MariaDB 10.0/XtraDB 5.6 - replaced with InnoDB flushing method from MySQL 5.6" Has it been replaced by innodb_flush_method because I’m trying to set “keep_average” for SSD drives. $ mysql --version mysql Ver 15.1 Distrib 10.0.10-MariaDB, for Linux (x86_64) using readline 5.1 Thanks!

2 1

[Maria-discuss] Heartbleed (OpenSSL) -bug and MariaDB
by Peter Laursen 10 Apr '14

10 Apr '14

A far as I understand MariaDB uses OpenSSL (unlike Oracle-MySQL that uses YaSSL). Now what about the heartbleed bug: http://heartbleed.com/ Will all still suported MariaDB versions (5.1, 5.2, 5.3, 5.5 and 10.0 are all still suported I think?) need a release for this bug in OpenSSL? -- Peter -- Webyog

3 6

[Maria-discuss] New Question: Problem with multi master replication and a trigger with mariadb 10.0.10.
by AskMonty KB 10 Apr '14

10 Apr '14

Hello, A new question has been asked in "Triggers" by wschwauer: -------------------------------- I have a problem with multi master replication and a trigger with mariadb 10.0.10. First. I have installed master db with name DB1 on a Windows system 1 master1 with a table m1, m2, m3, mg Second, I have install “slave” db with name DB1 on a Windows system 2 slave1 with a table s1, s2 Now I setup a row based replication with the table m1 from master1 to slave1. Next I setup a row based replication with the table s1 from slave1 to master1. Now I have a master with table m1, m2, m3, mg and s1 and a slave with table s1, s2 and m1. All replications work well. Ad next I create a trigger on master to manipulate and copy the data from table s1 to mg, but it do not work. I found this information (https://mariadb.atlassian.net/browse/MDEV-5095) but I have not the variable slave_run_triggers_for_rbr or slave_run_triggers. When I create the same trigger on master with table m1 and mg, it still works. But it not work with the replication table s1. I think it is a problem with the replication table s1. Can anyone help me? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/problem-with-multi-master-replication-and-a-trigge…

1 0

[Maria-discuss] Backup locks in MariaDB
by Colin Charles 09 Apr '14

09 Apr '14

Hi! Percona Server 5.6 includes backup locks that work with xtrabackup 2.2 MariaDB 10 might want this feature as well. More information: http://www.mysqlperformanceblog.com/2014/03/11/introducing-backup-locks-per… Thoughts? -- Colin Charles, Chief Evangelist, SkySQL - The MariaDB Company blog: http://bytebot.net/blog/| t: +6-012-204-3201 | Skype: colincharles

1 0

[Maria-discuss] New Question: Connecting issues
by AskMonty KB 09 Apr '14

09 Apr '14

Hello, A new question has been asked in "MariaDB ODBC Driver" by openiduser41: -------------------------------- Hi I have en application written in Visual Studio 2008 where I use CDatabase to connect to MariaDB via ODBC. When I try and connect I get an exception with the text "Invalid information type" I have tried alot of ODBC connect strings for instance: DRIVER={MariaDB ODBC 1.0 Driver};SERVER=localhost;DATABASE=mydb;UID=test;PWD= or DSN=mydb When I create the DSN every think looks ok. If I change to use {MySQL ODBC 3.51 Driver} it works fine. Another thing is that even though I use the noOdbcDialog option, it still show an ODBC dialog. Also if I create a new Project with database support in VS2008 and select a mariaDB DSN Visual studio crashes. Thanks for your help. /Kennet -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connecting-issues/

1 0

[Maria-discuss] locking on endpoints of range deletes
by Daniel Black 09 Apr '14

09 Apr '14

Anyone see why tx_isolation=REPEATABLE-READ should have a next-record lock on record 3 rather than a record lock? SESSION 1: MariaDB [drupal_test]> create table x ( x bigint unsigned not null auto_increment, PRIMARY KEY x) ); Query OK, 0 rows affected (0.02 sec) MariaDB [drupal_test]> select @@tx_isolation; +-----------------+ | @@tx_isolation | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec) MariaDB [drupal_test]> insert into x values (1),(2),(3); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 MariaDB [drupal_test]> begin -> ; Query OK, 0 rows affected (0.00 sec) MariaDB [drupal_test]> delete from x where x <= 3; Query OK, 3 rows affected (0.00 sec) ---TRANSACTION 290E30, ACTIVE 12 sec 2 lock struct(s), heap size 376, 4 row lock(s), undo log entries 3 MySQL thread id 7437, OS thread handle 0x7f37307f5700, query id 3298653 localhost debian-sys-maint sleeping TABLE LOCK table `drupal_test`.`x` trx id 290E30 lock mode IX RECORD LOCKS space id 82547 page no 3 n bits 72 index `PRIMARY` of table `drupal_test`.`x` trx id 290E30 lock_mode X SESSION 2: MariaDB [drupal_test]> insert into x values (DEFAULT); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction And it works in READ-COMMITTED SESSION 1: MariaDB [drupal_test]> set tx_isolation='READ-COMMITTED'; begin; delete from x where x <= 3; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) Query OK, 3 rows affected (0.00 sec) SESSION 2: ---TRANSACTION 290E33, ACTIVE 44 sec 2 lock struct(s), heap size 376, 3 row lock(s), undo log entries 3 MySQL thread id 7437, OS thread handle 0x7f37307f5700, query id 3298661 localhost debian-sys-maint sleeping TABLE LOCK table `drupal_test`.`x` trx id 290E33 lock mode IX RECORD LOCKS space id 82547 page no 3 n bits 72 index `PRIMARY` of table `drupal_test`.`x` trx id 290E33 lock_mode X locks rec but not gap MariaDB [drupal_test]> insert into x values (DEFAULT); Query OK, 1 row affected (0.00 sec) -- -- Daniel Black, Engineer @ Open Query (http://openquery.com.au) Remote expertise & maintenance for MySQL/MariaDB server environments.

1 0

[Maria-discuss] Trouble getting MariaDB to start up
by Jonathan Gazeley 07 Apr '14

07 Apr '14

Hi folks, I'm reasonably experienced with MySQL and MMM for cluster management but now I am working on a project to replace this with a MariaDB Galera cluster. Basic system info: [jg4461@db3 ~]$ uname -a Linux db3.resnet.bris.ac.uk 2.6.32-431.11.2.el6.x86_64 #1 SMP Tue Mar 25 19:59:55 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux [jg4461@db3 ~]$ cat /etc/redhat-release CentOS release 6.5 (Final) [jg4461@db3 ~]$ mysql -V mysql Ver 15.1 Distrib 5.5.36-MariaDB, for Linux (x86_64) using readline 5.1 I've set up a Galera prototype with two nodes and I got the clustering working. Then I decided to add a load of config options from my old MySQL install to the MariaDB install, and now it fails to start up, but doesn't give an obvious error message. The options were mostly to do with InnoDB buffers etc. This is the output in the log file /var/lib/mysql/db3.resnet.bris.ac.uk.err, the init script hangs for ages after this without giving any further output. 140331 15:07:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140331 15:07:49 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.mlbT89' --pid-file='/var/lib/mysql/db3.resnet.bris.ac.uk-recover.pid' 140331 15:07:51 mysqld_safe WSREP: Failed to recover position: '140331 15:07:49 InnoDB: The InnoDB memory heap is disabled 140331 15:07:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins 140331 15:07:49 InnoDB: Compressed tables use zlib 1.2.3 140331 15:07:49 InnoDB: Using Linux native AIO 140331 15:07:49 InnoDB: Initializing buffer pool, size = 1.5G 140331 15:07:49 InnoDB: Completed initialization of buffer pool 140331 15:07:49 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! 140331 15:07:49 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... 140331 15:07:49 InnoDB: Waiting for the background threads to start 140331 15:07:50 Percona XtraDB (http://www.percona.com) 5.5.36-MariaDB-33.0 started; log sequence number 1607692 140331 15:07:50 [Note] Plugin 'FEEDBACK' is disabled.' My MariaDB config file is attached. Please could someone point me in the right direction of where to go with debugging this. I can't find any other error message so I'm struggling to track down why the server can't start. Any advice gratefully accepted! Thanks, Jonathan

4 6

[Maria-discuss] New Question: upgraded to MariaDB 10.0 but the systemctl status mariadb.service is not working? mysql command works instead?
by AskMonty KB 06 Apr '14

06 Apr '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- Have the MariaDB programmers taken out the systemctl status mariadb.service command from the MariaDB 10.0 server. the command was working on my mariadb 5.5 server. can someone help shed some light Server: MariaDB Server version: 10.0.10-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 1 day 14 hours 11 min 29 sec Threads: 1 Questions: 143 Slow queries: 0 Opens: 31 Flush tables: 1 Open tables: 57 Queries per second avg: 0.001 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/upgraded-to-mariadb-100-but-the-systemctl-status-m…

1 0

[Maria-discuss] Building on Windows with cmake 2.8.12.2 and Visul Studio 2012
by Wes Bullard 03 Apr '14

03 Apr '14

I've been trying for a few days now first with 10.0.9 and now with 10.0.10 to build on windows x64 both by command line and in visual studio 2012. Straight building seems to go fine but if I try and build --target package or even --target msi I get errors about missing pdb files. This is both in RelWithDebInfo and Release configuration. The following are outputs from the builds RelWithDebInfo - http://paste.chainscriptz.net/?paste=5 Release - http://paste.chainscriptz.net/?paste=6 This is in Visual Studio 2012 Ultimate update 4. Sorry if this is in the wrong format first time using a mailing list.

2 1

[Maria-discuss] New Question: Circular Dependency on 5.5.36
by AskMonty KB 03 Apr '14

03 Apr '14

Hello, A new question has been asked in "Installing MariaDB RPM Files" by peter-mclarty: -------------------------------- Does anyone have a clever solution to installing 5.5.36 when compat and common rpms have a circular dependency, Since the contents appear to be needed do we need them packaged separately? [root@faws01_dbs itadmin]# yum install MariaDB-5.5.36-centos6-x86_64-compat.rpm Loaded plugins: product-id, subscription-manager Updating certificate-based repositories. Setting up Install Process Examining MariaDB-5.5.36-centos6-x86_64-compat.rpm: MariaDB-compat-5.5.36-1.el6.x86_64 Marking MariaDB-5.5.36-centos6-x86_64-compat.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package MariaDB-compat.x86_64 0:5.5.36-1.el6 will be installed --> Processing Dependency: MariaDB-common for package: MariaDB-compat-5.5.36-1.el6.x86_64 --> Finished Dependency Resolution Error: Package: MariaDB-compat-5.5.36-1.el6.x86_64 (/MariaDB-5.5.36-centos6-x86_64-compat) Requires: MariaDB-common You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest [root@faws01_dbs itadmin]# yum install MariaDB-5.5.36-centos6-x86_64-common.rpm Loaded plugins: product-id, subscription-manager Updating certificate-based repositories. Setting up Install Process Examining MariaDB-5.5.36-centos6-x86_64-common.rpm: MariaDB-common-5.5.36-1.el6.x86_64 Marking MariaDB-5.5.36-centos6-x86_64-common.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package MariaDB-common.x86_64 0:5.5.36-1.el6 will be installed --> Processing Dependency: MariaDB-compat for package: MariaDB-common-5.5.36-1.el6.x86_64 --> Finished Dependency Resolution Error: Package: MariaDB-common-5.5.36-1.el6.x86_64 (/MariaDB-5.5.36-centos6-x86_64-common) Requires: MariaDB-compat You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest As you can see one is dependent on the other, that is not a smart approach Any thoughts Peter -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/circular-dependency-on-5536/

1 0

[Maria-discuss] New Question: unable to upgrade from MariaDB 5.5 to MariaDB 10.0 using YUM
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "MariaDB community" by cyberdomecyberdome: -------------------------------- I created a file mariadb.repo and put in info for mariadb 10.0, when I run the command yum -y update or yum -y upgrade mariadb-server mariadb-client, Loaded plugins: langpacks, refresh-packagekit Resolving Dependencies --> Running transaction check ---> Package MariaDB-server.x86_64 0:10.0.10-1.fc20 will be obsoleting ---> Package mariadb-server.x86_64 1:5.5.36-1.fc20 will be obsoleted --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: MariaDB-server x86_64 10.0.10-1.fc20 mariadb 49 M replacing mariadb-server.x86_64 1:5.5.36-1.fc20 Transaction Summary ================================================================================ Install 1 Package Total download size: 49 M Downloading packages: MariaDB-10.0.10-fedora20-x86_64-server.rpm | 49 MB 00:00:10 Running transaction check Running transaction test Transaction test succeeded Running transaction sed: invalid option -- '1' Usage: sed [OPTION]... {script-only-if-no-other-script} [input-file]... -n, --quiet, --silent suppress automatic printing of pattern space -e script, --expression=script add the script to the commands to be executed -f script-file, --file=script-file add the contents of script-file to the commands to be executed --follow-symlinks follow symlinks when processing in place -i[SUFFIX], --in-place[=SUFFIX] edit files in place (makes backup if SUFFIX supplied) -c, --copy use copy instead of rename when shuffling files in -i mode -b, --binary does nothing; for compatibility with WIN32/CYGWIN/MSDOS/EMX ( open files in binary mode (CR+LFs are not treated specially)) -l N, --line-length=N specify the desired line-wrap length for the `l' command --posix disable all GNU extensions. -r, --regexp-extended use extended regular expressions in the script. -s, --separate consider files as separate rather than as a single continuous long stream. -u, --unbuffered load minimal amounts of data from the input files and flush the output buffers more often -z, --null-data separate lines by NUL characters --help display this help and exit --version output version information and exit If no -e, --expression, -f, or --file option is given, then the first non-option argument is taken as the sed script to interpret. All remaining arguments are names of input files; if no input files are specified, then the standard input is read. GNU sed home page: <http://www.gnu.org/software/sed/>. General help using GNU software: <http://www.gnu.org/gethelp/>. ****************************************************************** A MySQL or MariaDB server package () is installed. The current MariaDB server package is provided by a different vendor (package is not installed) than Monty Program AB. Some files may be installed to different locations, including log files and the service startup script in /etc/init.d/. Upgrading directly from MySQL <unrecognized version package is not installed> to MariaDB 10.0 may not be safe in all cases. A manual dump and restore using mysqldump is recommended. It is important to review the MariaDB manual's Upgrading section for version-specific incompatibilities. A manual upgrade is required. - Ensure that you have a complete, working backup of your data and my.cnf files - Shut down the MySQL server cleanly - Remove the existing MySQL packages. Usually this command will list the packages you should remove: rpm -qa | grep -i '^mysql-' You may choose to use 'rpm --nodeps -ev <package-name>' to remove the package which contains the mysqlclient shared library. The library will be reinstalled by the MariaDB-shared package. - Install the new MariaDB packages supplied by Monty Program AB - Ensure that the MariaDB server is started - Run the 'mysql_upgrade' program This is a brief description of the upgrade process. Important details can be found in the MariaDB manual, in the Upgrading section. ****************************************************************** error: %pre(MariaDB-server-10.0.10-1.fc20.x86_64) scriptlet failed, exit status 1 Error in PREIN scriptlet in rpm package MariaDB-server-10.0.10-1.fc20.x86_64 Verifying : MariaDB-server-10.0.10-1.fc20.x86_64 1/2 1:mariadb-server-5.5.36-1.fc20.x86_64 was supposed to be removed but is not! Verifying : 1:mariadb-server-5.5.36-1.fc20.x86_64 2/2 Failed: MariaDB-server.x86_64 0:10.0.10-1.fc20 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/unable-to-upgrade-from-mariadb-55-to-mariadb-100-u…

1 0

[Maria-discuss] New Question: crash recovery
by AskMonty KB 01 Apr '14

01 Apr '14

Hello, A new question has been asked in "Backing Up and Restoring" by joemurray: -------------------------------- An XtraDB database running in MariaDB - no cluster, no replication - has been crashing about 15 x per day for 3 days and we suspect it may be corrupt. We don't see any reason in the log files for the crashes. We have taken a mysqldump and restored into a new db and run mysqlcheck on the new db and not fond any errors, but I suspect that the dumping and restoring has hidden them. After testing a staging site with this new database we are planning to repeat the process of dumping and restoring into a new db and then making it live. I intend to run mysqlcheck on the production database once it is no longer in production. Any other suggestions from DBAs to this developer? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/crash-recovery/

1 0

[Maria-discuss] MariaDB 10.0.10 now available
by Daniel Bartholomew 31 Mar '14

31 Mar '14

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.10. This is a Stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.10 - Release Notes: https://mariadb.com/kb/en/mariadb-10010-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-10010-changelog - Downloads: https://downloads.mariadb.org/mariadb/10.0.10 About MariaDB 10.0: - https://mariadb.com/kb/en/what-is-mariadb-100/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB & MySQL community event, 3 Apr 2014 - - - - - - - - - - - The MariaDB Foundation is holding a community event to complement the Percona Live conference and expo in Santa Clara, CA. The event is free. Visit the Community Events page on mariadb.org for full details, including the speaker schedule and to register. - https://mariadb.org/en/community-events/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - SkySQL has held several MariaDB-focused Webinars recently which are available on an on-demand basis at: - http://www.skysql.com/why-skysql/webinars/ They are also planning several more MariaDB-focused webinars that will be held over the comming months. Details available at the above link. - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - The newly published MariaDB Cookbook contains nearly 100 recipes covering a variety of features in MariaDB. - http://www.packtpub.com/exclusive-and-unique-features-of-mariadb/book Another book, Getting Started with MariaDB is a how-to guide for beginners to help them get up to speed quickly with MariaDB. No prior database experience required. - http://www.packtpub.com/getting-started-with-mariadb/book - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

3 2

[Maria-discuss] New Question: MariaDB wire protocol
by AskMonty KB 31 Mar '14

31 Mar '14

Hello, A new question has been asked in "MariaDB Documentation" by steveteale: -------------------------------- Where is the wire protocol described please. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-wire-protocol/

1 0

[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

[Maria-discuss] New Question: pre-seeding databases from remote servers for multi-source replication
by AskMonty KB 17 Mar '14

17 Mar '14

Hello, A new question has been asked in "Backup, Restore and Import" by ivesstoddard: -------------------------------- I'm in the process of pre-seeding a mariadb 10.0.9 multi-source replica server with databases from remote 5.5 servers. I'm looking for the fastest and most stable way of doing this (preferably without using mysqldump). I'm curious if there is a way to import entire databases directly from block-level snapshots, similar to the transportable tablespaces (only on a database level instead of a table level, by copying .idb/.frm/etc. files directly to the target server). NOTE: Transportable tablespaces aren't yet available in 5.5 and also have to be done on a table-by-table basis. Some of the databases are large enough that running mysqldump & import will are impractical. Not only will this process take a considerable amount of time, but to do this in a way that is closest to a snapshot will require a separate server instance to ensure all transactions have been committed to the tablespaces. Is there anyone out there looking at multi-source replication who has a simple solution to this that i might be overlooking? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pre-seeding-databases-from-remote-servers-for-mult…

1 0

[Maria-discuss] MariaDB vs. MySQL error codes (1900+)
by Felipe Gasper 17 Mar '14

17 Mar '14

Hi everyone, I notice that MariaDB is using the 1900+ range for its own error codes; however, MySQL 5.7, at least, has a few errors in that range as well. Are error codes just going to be an area of increasing conflict between the two, or is there a plan to migrate MariaDB codes to a different numbering scheme? -Felipe Gasper Houston, TX

2 2

[Maria-discuss] Participation in GSOC 2014
by Ivoline Ngong 17 Mar '14

17 Mar '14

Hi, My name is Ngong Ivoline.I am a second year student reading Computer Engineering in the University of Buea (Cameroon in West Africa). I am very excited working with an open source organization as i will finally have the chance to share my ideas as well as learn from others. I love coding and i am proficient in Java ,C and mysql.I will like to not only test but improve my skills by taking part in a google summer of code 2014. One of my goals as an African woman is to encourage the growth of programming in my community, country and continent as a whole. I am interested in the project to statistically optimize mysql-test runs by running less tests. It will be great if i get some guidance on how to continue from here.Look forward to participating in this group. Cheers!! Ivoline.

2 1

[Maria-discuss] New Question: Reentrant mariadbclient on the horizon?
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB community" by markcianfaglione: -------------------------------- I've written an test application that can be multi-threaded and I've done a bit of testing only to find that mariadbclient is not reentrant! (Oh the humanity!) I have got it to run using the reentrant library (libmysqlclient_r) for MySQL but there doesn't seem to be a similar library for mariadbclient. Is this even on the horizon? Mark -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/reentrant-mariadbclient-on-the-horizon/

2 1

[Maria-discuss] New Question: Question about testing
by AskMonty KB 14 Mar '14

14 Mar '14

Hello, A new question has been asked in "MariaDB FAQ" by openiduser40: -------------------------------- I'd like to run the test suite on MariaDB-5 + MariaDB-10 both. https://mariadb.com/kb/en/mysql-test-overview gives some information + fails to give enough. Suggest docs add a full example. Something like this... 1) create a database net1# mysql_create_database --dbname=mariadb_test --dbuser=mariadb --dbpass=mariadb /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'CREATE DATABASE mariadb_test CHARACTER SET utf8 COLLATE utf8_general_ci' /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'GRANT ALL PRIVILEGES ON mariadb_test.* to 'mariadb@localhost' IDENTIFIED BY "mariadb"; FLUSH PRIVILEGES;' 2) run a test The reason I ask about this is every test I run fails. lsof shows my socket is /var/run/mysqld/mysqld.sock + here are the failures. mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SHOW DATABASES' | grep mariadb_test shows my database exists. These tests fail to connect to database... net1# mysqltest --verbose --protocol=socket --socket=/var/run/mysqld/mysqld.sock --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server (null):3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# mysqltest --verbose --host=localhost --database=name=mariadb_test --user=mariadb --password=mariadb mysqltest: Logging to ''. mysqltest: Results saved in ''. mysqltest: Connecting to server localhost:3306 (socket /var/run/mysqld/mysqld.sock) as 'mariadb', connection 'default', attempt 0 ... mysqltest: Could not open connection 'default': 1044 Access denied for user 'mariadb'@'localhost' to database 'name=mariadb_test' not ok net1# /usr/bin/mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SELECT db,user,host FROM mysql.db WHERE db="mariadb_test"' +--------------+---------+-----------+ | db | user | host | +--------------+---------+-----------+ | mariadb_test | mariadb | localhost | +--------------+---------+-----------+ Obviously I'm missing something simple + having a complete example would help. Please update this question with all steps required to run mysqltest. Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/question-about-testing/

1 0