Quoting Jan Lindström jplin...@mariadb.org:
Seppo,
Hi,
What means:
30925 15:10:36 [ERROR] Slave SQL: Could not execute Update_rows
event on table test.table10_key_pk_parts_2_int_autoinc; Can't find
record in 'table10_key_pk_parts_2_int_autoinc', Error_code: 1032;
handler error
I think the 'mysql' client with MariaDB has a similar problem as it has
with MySQL - refer?
http://bugs.mysql.com/bug.php?id=70443
MariaDB installer installs my.ini to /datadir - what with MariaDB is a
subfolder to /basedir.
The server will look for it correctly as the registry key defining the
Quoting Kristian Nielsen kniel...@knielsen-hq.org:
Jan Lindström jplin...@mariadb.org writes:
The point I do not understant is at ha_savepoint
we have again:
if ((err= ht-savepoint_set(ht, thd, (uchar *)(sv+1)+ht-savepoint_offset)))
(gdb) p *sv
$3 = {prev = 0xa5a5a5a5a5a5a5a5, name =
seppo.jaak...@codership.com writes:
Did I understand it right that the problem is with ROLLBACK TO
SAVEPOINT..., where the designated savepoint does not exist? Did you
No. It is a very simple issue.
The beginning of binlog_savepoint_set() reads:
#ifdef WITH_WSREP
if
Hi Sergei,
This is Shuang, a participant for GSoC 2013 Kerberize MariaDB project. I want
to ask the community to review the code before requesting for pull and send the
MCA.
How could I send the codes? In a diff file? or from other approaches?
Thank you very much and best regards!
Sincerely,
Hi, QIU!
On Sep 27, QIU Shuang wrote:
This is Shuang, a participant for GSoC 2013 Kerberize MariaDB project.
I want to ask the community to review the code before requesting for
pull and send the MCA.
How could I send the codes? In a diff file? or from other approaches?
Do you have a tree on
Hi Kentoku,
On Wed, Sep 25, 2013 at 02:53:17AM +0900, kentoku wrote:
Hi Sergey,
The above should have been fixed back in the beginning of 2012. Which
MariaDB
revision are you testing with?
It's same as lp:~kentokushiba/maria/10.0.4-spider-3.0.
That's very strange. How did you build it and
Hi,
I think I solved this issue by
#ifdef WITH_WSREP
if (!wsrep_emulate_bin_log)
binlog_trans_log_truncate(thd, *(my_off_t*)sv);
#endif
This avoids using the uninitialized memory in Galera, this was
error in merge.
Hi Sergei,
Do you have a tree on launchpad with your code?
Yes, I have. Here is the URL to my branch:
https://code.launchpad.net/~qiush-summer/maria/krb_auth_plugin.
Then the easiest way would be to propose a merge of your tree into
mariadb. See https://help.launchpad.net/Code/Review
I've
Hi Sergey,
The above should have been fixed back in the beginning of 2012. Which
MariaDB
revision are you testing with?
It's same as lp:~kentokushiba/maria/10.0.4-spider-3.0.
That's very strange. How did you build it and what command line options
did
you use (including those that are
Hi community,
I declare that all the work done so far (and future) on the project Kerberize
MariaDB is licenced by the new BSD Lisence.
Please contact me if any problems with the license.
Thank you all and best regards!
Sincerely, Shuang___
Mailing
Hi Kentoku,
BUILD/compile-amd64-debug-max
cd mysql-test
cat t/AAA.test
--source include/have_innodb.inc
install soname 'ha_spider.so';
--connection default
eval CREATE TABLE t1 (a INT) ENGINE=InnoDB;
--connect (con1,localhost,root,,)
XA START 'xa1';
INSERT INTO t1 (a) VALUES (1),(2);
XA END
Hi,
Among the topics of yesterday's optimizer call was the question of what is the
point of EXPLAIN INSERT. The point was that INSERT doesn't need a query plan.
Somebody has mentioned that perhaps, EXPLAIN INSERT could show results of
partition pruning.
This doesn't seem to be the case:
Could it be of use for the INSERT ... SELECT ... queries?
Sergei Petrunia pser...@askmonty.org wrote:
Hi,
Among the topics of yesterday's optimizer call was the question of what
is the
point of EXPLAIN INSERT. The point was that INSERT doesn't need a query
plan.
Somebody has mentioned that
It looks like a bug.The partition pruning kicks just fine for UPDATEsshow create table t2p\G*** 1. row *** Table: t2pCreate Table: CREATE TABLE `t2p` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1/*!50100
I agree that for INSERT .. SELECT, EXPLAIN is useful - it shows query plan of
the SELECT part.
I was wondering specifically about the INSERT ... VALUES (...) syntax. I was
just checking EXPLAIN in Maria vs EXPLAIN in MySQL, and could not find what is
the rationale for EXPLAIN INSERT ... VALUES.
The command line clients are not services, and they are not started with
--defaults-file, this is correct.
But
1.We install shortcut to mysql client and shortcut does have --defaults-file ,
and the default-file points to the right place, i.e whenever you installed the
mysql server
Thanks wlad for explanation, but this applies to 'shortcuts' (in start
menu) only I think, as I understand your reply.
If I navigate ('cd ..') to the /datadir where my.ini resides and launch
'mysql' from commnd line I will need to specify --defaults-file on the
command line, right? If not the
Justin, I appreciate your opinion, and if MySQL on Windows would not support
multiple versions running on the same machine, I would agree.
But since we (and/or generations of programmers before me) chose to support
multiple version of MySQL coexisting on the same machine, and I did not want to
Current directory does not play any role in choosing defaults file. You indeed
need either to specify –defauilts-file, or set MYSQL_HOME, or the bdefault
logic of finding my.ini will apply
On the other hand, I rarely find myself in need to use my.ini for clients. In
doubt, I provide –port ,
On Windows multiple MySQL servers run (if only they have distinct basedir,
datadir, port (and/or pipe) and service name). This is how Windows manages
servides (daemons) simply!
And BTW: this is the reason why Windows is a comfortable platform for
application testing if you want to test an
I rarely find myself in need to use my.ini for clients. Not me either
except for max_allowed_packet (what is implemented in both server and
client) that user want to set to INSERT table rows with photographs (.jpg's
typically) to a table.
And the 'mysql' command line client has a default
22 matches
Mail list logo