Re: [Maria-discuss] rsync failure?

2016-11-08 Thread l vic
on the joiner i see: WSREP: Failed to prepare for incremental state transfer: Local state UUID (----) does not match group state UUID (f74ffa7e-a5f2-11e6-b2a3-1fead9a6118d): 1 (Operation not permitted) at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will

Re: [Maria-discuss] rsync timeout?

2016-11-08 Thread l vic
Why exactly do you want to increase it? because i think dns may slow down rsync On Tue, Nov 8, 2016 at 3:42 PM, Nirbhay Choubey wrote: > Hi, > > On Tue, Nov 8, 2016 at 2:22 PM, l vic wrote: > >> Is it possible to increase rsync timeout? I checked >> http://galeracluster.com/documentation-webpag

Re: [Maria-discuss] rsync timeout?

2016-11-08 Thread Nirbhay Choubey
Hi, On Tue, Nov 8, 2016 at 2:22 PM, l vic wrote: > Is it possible to increase rsync timeout? I checked > http://galeracluster.com/documentation-webpages/galeraparameters.html > but couldn't find corresponding parameters... > Currently, there is no way to configure rsync timeout other than editi

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Richard Bensley
> What do you mean? Sorry Sergei, my mistake, I mean Out Parameters, https://mariadb.com/kb/en/mariadb/out-parameters-in-prepare/ They are still there. I thought they were removed for some reason. Rich ___ Mailing list: https://launchpad.net/~maria-di

Re: [Maria-discuss] rsync failure?

2016-11-08 Thread l vic
>From your previous answer about using node-name vs. node-address to identify the node: use wsrep-node-address; wsrep-node-name, OTOH, could be used to assign a name to the node. It helps identify the node in the error logs and can be used in wsrep-sst-donor On Tue, Nov 8, 2016 at 12:54 PM, Nirbh

[Maria-discuss] rsync timeout?

2016-11-08 Thread l vic
Is it possible to increase rsync timeout? I checked http://galeracluster.com/documentation-webpages/galeraparameters.html but couldn't find corresponding parameters... Thanks, -V ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-d

Re: [Maria-discuss] rsync failure?

2016-11-08 Thread Nirbhay Choubey
On Tue, Nov 8, 2016 at 11:32 AM, l vic wrote: > How can i determine the donor node? Would that be seed node? > On the joiner you will see the following: 2016-11-08 12:13:57 140589576218368 [Note] WSREP: Member 1.0 (node2) requested state transfer from '*any*'. Selected 0.0 (node1)(SYNCED) as do

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Sergei Golubchik
Hi, Richard! On Nov 08, Richard Bensley wrote: > Will we ever see a return of prepared statement parameters that were > introduced then removed in 10.2? What do you mean? Regards, Sergei Chief Architect MariaDB and secur...@mariadb.org ___ Mailing li

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Richard Bensley
I would LOVE to see the SQL language receive extensions, or the ability to plugin a scripting language; something useful like Guile or Lua (not javascript, what is wrong with people?). Will we ever see a return of prepared statement parameters that were introduced then removed in 10.2? I can achi

Re: [Maria-discuss] rsync failure?

2016-11-08 Thread l vic
I don't see any log entries pertaining to node3 join on the donor nodes On Tue, Nov 8, 2016 at 11:04 AM, Nirbhay Choubey wrote: > > > On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote: > >> Have the rsync failure (see the trace below): >> >> 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed

Re: [Maria-discuss] rsync failure?

2016-11-08 Thread l vic
How can i determine the donor node? Would that be seed node? Thank you On Tue, Nov 8, 2016 at 11:04 AM, Nirbhay Choubey wrote: > > > On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote: > >> Have the rsync failure (see the trace below): >> >> 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed t

Re: [Maria-discuss] rsync failure?

2016-11-08 Thread Nirbhay Choubey
On Tue, Nov 8, 2016 at 10:50 AM, l vic wrote: > Have the rsync failure (see the trace below): > > 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready > ' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' > --datadir '/var/lib/mysql/' --parent '114' '' > R

[Maria-discuss] rsync failure?

2016-11-08 Thread l vic
Have the rsync failure (see the trace below): 2016-11-08 15:17:34 139959897945856 [ERROR] WSREP: Failed to read 'ready ' from: wsrep_sst_rsync --role 'joiner' --address 'node3.frame.mesos' --datadir '/var/lib/mysql/' --parent '114' '' Read: '(null)' 2016-11-08 15:17:34 139959897945856 [ERROR] W

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Justin Swanhart
I forgot about 'async'. It is a multi-threaded asynchronous (and client agnostic) SQL queue built entirely from MySQL primitives with no external dependencies. On Tue, Nov 8, 2016 at 7:45 AM, Justin Swanhart wrote: > There are a great many uses for stored procedures. They can eliminate > round

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Justin Swanhart
There are a great many uses for stored procedures. They can eliminate round trips, and they can encapsulate logic in the database. It is a pity that MySQL stored procedures are so limited that hey do not even encapsulate the full standard, and require difficult constructs by not implementing "for

Re: [Maria-discuss] on stored procedures

2016-11-08 Thread Игорь Пашев
2016-11-07 18:43 GMT+03:00 Sergei Golubchik : > Hi, Federico! > > On Nov 07, Federico Razzoli wrote: >> Some good points from Bill Karwin: >> https://www.quora.com/What-are-the-reasons-not-to-use-or-not-use-stored-procedures/answer/Bill-Karwin > > Thanks. > > These are valid points, and some of the