Re: [Maria-developers] Compilation problem on an old 32-bit machine

2011-12-12 Thread Paul McCullagh
uot;movb %1, %0" : "=r" (val) : "m" (*mptr) : "memory"); > + asm volatile ("movb %1, %0" : "=q" (val) : "m" (*mptr) : "memory"); > val--; > - asm volatile ("xchgb %1,%0" : "=r" (

Re: [Maria-developers] Pbxt loses rows

2011-02-25 Thread Paul McCullagh
I suspect that this is not due to rows being lost, but rather to the rows not being found for some timing reason. But, of course, only debugging will tell... We have scheduled time to look at this error. On Feb 25, 2011, at 3:58 PM, Michael Widenius wrote: Hi! This is a bug that has been

Re: [Maria-developers] Fix for PBXT for problem with 'repair-pending'

2011-02-25 Thread Paul McCullagh
Thanks for the patch! The patch is correct, this was indeed forgotten in drop table. On Feb 25, 2011, at 3:52 PM, Michael Widenius wrote: Hi! We have got some failures of the following type in pushbuild: pbxt.mysqlslap w2 [ fail ] Test ended at 2011-02-25 14

Re: [Maria-developers] Implementing new "group commit" API in PBXT?

2010-12-13 Thread Paul McCullagh
Hi Kristian, Sorry I have not had time for this. December is busy. I will try to allocate a few days in January. On Dec 7, 2010, at 10:00 AM, Kristian Nielsen wrote: Paul McCullagh writes: On Oct 15, 2010, at 4:07 PM, Kristian Nielsen wrote: Thanks to your help, I got it working! It

Re: [Maria-developers] Strange pbxt issue in 5.1 (missing rows)

2010-11-29 Thread Paul McCullagh
Hi Monty, Unfortunately I have no idea what this problem is, except that I have never seen it in the insert test before. Has the insert test been modified recently? I guess it is more likely that the select is delivering a different number of rows than the INSERT failing. On Nov 25, 2010

Re: [Maria-developers] Implementing new "group commit" API in PBXT?

2010-10-18 Thread Paul McCullagh
;selectrow_arrayref("SELECT SUM(b) FROM test_consistent_snapshot1"); +$s1= $s1->[0]; +my $s2= $dbh->selectrow_arrayref("SELECT SUM(b) FROM test_consistent_snapshot2"); +$s2= $s2->[0]; +$dbh->commit(); +if ($s1 + $s2 != 0) { + print STDERR

Re: [Maria-developers] Implementing new "group commit" API in PBXT?

2010-10-06 Thread Paul McCullagh
On Oct 5, 2010, at 3:10 PM, Kristian Nielsen wrote: Paul McCullagh writes: The easiest way to do this would be to add a parameter to xn_end_xact() that indicates that the log should not be written or flushed. Ok, I gave it a shot, but I had some problems due to not knowing the PBXT code

Re: [Maria-developers] Implementing new "group commit" API in PBXT?

2010-10-04 Thread Paul McCullagh
the presence of hot spots (probably does not apply to PBXT). - Kristian. -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to

Re: [Maria-developers] Repeated Error in accept: Bad file descriptor

2010-07-16 Thread Paul McCullagh
Hi All, Yes, PBXT uses a lot of file handles: generally 3 per table. It opens all tables before recovery. Unfortunately, I have not worked on optimizing this behavior. Although the only reason for this is to resolve possible FK/PK relationships. So I think this should be considered a PBXT

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/pbxt-1.0.11 into lp:maria

2010-05-14 Thread Paul McCullagh
Hi Kristian, Please go ahead with the patch, its fine with me. On May 14, 2010, at 8:22 PM, Kristian Nielsen wrote: Paul McCullagh writes: Thanks for clearing this up. The problem is certainly as you say: it depends on the speed of a background thread. From this point of view the test

Re: [Maria-developers] Patch to fix compiler Warnings and build failure in pbxt

2010-05-14 Thread Paul McCullagh
CHECK_TABLE_READ_DATA_LOG XTactExtRecEntryDRecext_rec; size_t log_size; xtLogID log_id; xtLogOffset log_offset; +#endif xtRecordID rec_id;

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/pbxt-1.0.11 into lp:maria

2010-05-12 Thread Paul McCullagh
work in all cases with PBXT. On May 10, 2010, at 4:57 PM, Kristian Nielsen wrote: Paul McCullagh writes: All tests in the PBXT suite run through on Mac and Linux, except for one error under Linux, which is a bit weird (see below). -- pbxt.select_safe

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-30 Thread Paul McCullagh
tables +1 SIMPLE t2 ALL NULLNULLNULLNULL3 Using where +1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.id 1 Using index drop table t1,t2; CREATE TABLE t1 ( id int(11) NOT NULL auto_increment, mysqltest: Result length m

Re: [Maria-developers] PBXT test failure in MySQL 5.1.46 merge

2010-04-29 Thread Paul McCullagh
MPLE t2 ALL NULLNULLNULLNULL3 Using where +1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.id 1 Using index drop table t1,t2; CREATE TABLE t1 ( id int(11) NOT NULL auto_increment, mysqltest: Result length mismatch -- Paul McCullagh Pri

Re: [Maria-developers] Storage Engine Summit 2010

2010-03-31 Thread Paul McCullagh
: https://help.launchpad.net/ListHelp -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscri

Re: [Maria-developers] LOCK_plugin in pbxt_init()

2010-03-04 Thread Paul McCullagh
This is a good point! :) Speaks for killing the server if recover fails. On Mar 3, 2010, at 1:39 AM, Stewart Smith wrote: On Mon, 1 Mar 2010 10:27:44 +0100, Paul McCullagh > wrote: This would make it possible to prevent startup of the server if recovery fails. But I am not so sure this is

Re: [Maria-developers] LOCK_plugin in pbxt_init()

2010-03-03 Thread Paul McCullagh
Hi Sergei, On Mar 3, 2010, at 10:06 AM, Sergei Golubchik wrote: Hi, Paul! On Mar 01, Paul McCullagh wrote: Thanks for the info. That was a problem that caused me a lot of trouble until we finally made recovery asynchronous. The unlock hack can probably be removed altogether now. I have

Re: [Maria-developers] LOCK_plugin in pbxt_init()

2010-03-01 Thread Paul McCullagh
SQL too. Regards, Sergei -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Un

Re: [Maria-developers] Strange compiler error from pbxt

2010-01-29 Thread Paul McCullagh
ing in buildbot, but you may want to take a look at this. Regards, Monty -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to

Re: [Maria-developers] Compiling MariaDB on Solaris (pbxt)

2010-01-07 Thread Paul McCullagh
rr = pthread_create(&child_thread, &attr, thr_main_pbxt, &data); } #else - err = pthread_create(&child_thread, NULL, thr_main, &data); + err = pthread_create(&child_thread, NULL, thr_main_pbxt, &data);

Re: [Maria-developers] 2PC between two engines + binlog

2009-12-29 Thread Paul McCullagh
Hi Hakan, All tests look good, so I have proposed the bug fix mentioned below for merging: lp:~paul-mccullagh/maria/maria-pbxt-1009g On Dec 21, 2009, at 3:09 PM, Hakan Kuecuekyilmaz wrote: Hi Paul, I will wait for your update. Cheers, Hakan On 21.12.2009, at 14:21, Paul McCullagh

Re: [Maria-developers] commit performance when the binlog is enabled

2009-12-29 Thread Paul McCullagh
ock prepare_commit_mutex + trx_commit_complete_for_mysql() # force to disk the trx log buffer including commit record for this trx # fsync done here, group commit may amortize that -- Mark Callaghan mdcal...@gmail.com -- Paul McCullagh PrimeBase Techno

Re: [Maria-developers] 2PC between two engines + binlog

2009-12-21 Thread Paul McCullagh
Hi Hakan, Unfortunately there is a bug in 1.0.09f which prevents PBXT XA from working correctly with the binlog. I have pushed the patch to: lp:~paul-mccullagh/maria/maria-pbxt-1009g We have already tested the patch with MySQL 5.1.41. I will propose the patch for merge as soon as I have

Re: [Maria-developers] Crash during shutdown (need help from PBXT team)

2009-12-07 Thread Paul McCullagh
help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/List

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/maria-pbxt-rc3 into lp:maria

2009-12-02 Thread Paul McCullagh
XT and the binlog (although 1.0.09 supports 2-phase commit). I am investigating the problem, and will push a patch as soon as I have fixed the problem. In the meantime, I believe it is still OK to merge 1.0.09 after testing, as you say. Best regards, Paul -- Paul McCullagh PrimeBase Te

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/maria-pbxt-rc3 into lp:maria

2009-12-02 Thread Paul McCullagh
mark_trx_read_write(); if (unlikely(error= write_row(buf))) DBUG_RETURN(error); if (unlikely(error= binlog_log_row(table, 0, buf, log_func))) DBUG_RETURN(error); /* purecov: inspected */ DBUG_RETURN(0); } On Dec 2, 2009, at 12:26 PM, Sergei Golubchik wrote: Hi, Paul! On Dec 02, Pau

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/maria-pbxt-rc3 into lp:maria

2009-12-02 Thread Paul McCullagh
Hi Sergei, Thanks for the great explanation. On Dec 1, 2009, at 2:50 PM, Sergei Golubchik wrote: Hi, Paul! On Dec 01, Paul McCullagh wrote: Thanks for the heads-up on that! The code in question is as follows: #ifndef WILL_BE_DELETED_LATER /* for now, only InnoDB supports 2pc. It

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/maria-pbxt-rc3 into lp:maria

2009-12-01 Thread Paul McCullagh
, Paul On Dec 1, 2009, at 1:14 PM, Sergei Golubchik wrote: Hi, Paul! On Dec 01, Paul McCullagh wrote: This patch changes MariaDB code in one case: File handler.cc, Line 1591 DBUG_ASSERT(total_ha_2pc == (ulong) opt_bin_log+1); // only InnoDB and binlog This line has been commented out

Re: [Maria-developers] Plugin 'PBXT' will be forced to shutdown

2009-11-27 Thread Paul McCullagh
OK, thanks! This has been reported as bug #489088 (https://bugs.launchpad.net/pbxt/+bug/489088 ) We will have a look... On Nov 26, 2009, at 7:45 PM, Kristian Nielsen wrote: Paul McCullagh writes: I have seen this warning occasionally with other versions of MySQL. Since it also happens

Re: [Maria-developers] pbxt.join_nested test failure (was Re: Test failures in PBXT after merging with MySQL-5.1.41)

2009-11-27 Thread Paul McCullagh
This has been reported as bug #489091 (https://bugs.launchpad.net/pbxt/+bug/489091 ) On Nov 26, 2009, at 5:47 PM, Paul McCullagh wrote: Hi Kristian, This could be tricky. Basically, the way PBXT works this is possible, because the statistics can depend on the speed of threads running in

[Maria-developers] pbxt.join_nested test failure (was Re: Test failures in PBXT after merging with MySQL-5.1.41)

2009-11-26 Thread Paul McCullagh
t`.`t3`.`c`) or isnull(`test`.`t4`.`c`)) and ((`test`.`t5`.`a` >= 2) or isnull(`test`.`t5`.`c`)) and ((`test`.`t6`.`a` >= 4) or isnull(`test`.`t6`.`c`)) and ((`test`.`t7`.`a` <= 2) or isnull(`test`.`t7`.`c`)) and ((`test`.`t8`.`a` < 1) or isnull(`test`.`t8`.`c`)) and

[Maria-developers] Plugin 'PBXT' will be forced to shutdown (was Re: Test failures in PBXT after merging with MySQL-5.1.41)

2009-11-26 Thread Paul McCullagh
:00 [Note] Plugin 'InnoDB' is disabled. 091124 15:11:00 [Note] PrimeBase XT (PBXT) Engine 1.0.08d RC loaded... 091124 15:11:00 [Note] Paul McCullagh, PrimeBase Technologies GmbH, http://www.primebase.org 091124 15:11:00 [Note] Event Scheduler: Loaded 0 events 091124 15:11:00 [Note] /home/k

Re: [Maria-developers] Test failures in PBXT after merging with MySQL-5.1.41

2009-11-24 Thread Paul McCullagh
you a patch for merging into PBXT to update to 5.1.41? - Kristian. -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-dev

Re: [Maria-developers] Warnings in MariaDB

2009-10-30 Thread Paul McCullagh
Hi Monty, On Oct 30, 2009, at 3:09 PM, Michael Widenius wrote: Hi! "Paul" == Paul McCullagh writes: Paul> Hi Monty, Paul> Thanks for the information. Paul> For PBXT I think it would be best if you correct such errors Paul> immediately when compiling and then pu

Re: [Maria-developers] Warnings in MariaDB

2009-10-27 Thread Paul McCullagh
ou just fix this next time you push? Regards, Monty -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@l

Re: [Maria-developers] MariaDB and the SCA

2009-09-03 Thread Paul McCullagh
this arrangement, contributors ensure that Sun is able to continue that. Do you want that? "yes" might be a valid choice, on the basis that it might be more important to get the changes upstream. But I think the question needs to be asked explicitly. Hence. -- Paul Mc

Re: [Maria-developers] [Merge] lp:~paul-mccullagh/maria/maria-pbxt-rc2 into lp:maria

2009-08-28 Thread Paul McCullagh
gh. The other problems seem to have to do with case-sensitivity. I will see if I can repeat those errors on one of my machines. Best regards, Paul On Aug 28, 2009, at 3:33 PM, Kristian Nielsen wrote: > Paul McCullagh writes: > >> Paul McCullagh has proposed merging lp:~pau

Re: [Maria-developers] Fixing compiler warnings

2009-08-27 Thread Paul McCullagh
On Aug 27, 2009, at 12:07 PM, Kristian Nielsen wrote: Paul McCullagh writes: Hi Kristian, Thanks for the patch! I will definitely include these changes in the PBXT trunk. I am happy to accept any changes that allow the code to compile without warnings (this is also a requirement for

Re: [Maria-developers] Bug tracker for MariaDB

2009-07-08 Thread Paul McCullagh
://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.l

Re: [Maria-developers] Patches to consider to include

2009-05-14 Thread Paul McCullagh
On May 14, 2009, at 5:15 PM, Vadim Tkachenko wrote: Paul, I do not think it happens soon. Probably not :( On conference Mark said - No more upgrades :) Yup, they are happy that their system is running and that they have all the features they require now. -- Paul McCullagh

Re: [Maria-developers] Patches to consider to include

2009-05-14 Thread Paul McCullagh
-- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria

Re: [Maria-developers] MariaDB + PBXT

2009-05-13 Thread Paul McCullagh
cd mysql-test/suite/pbxt/ && patch -p0 -s < /tmp/3) bzr ci -m"After-merge fixes for re-merge of PBXT into MariaDB with proper history and merge tracking." -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com

Re: [Maria-developers] MariaDB + PBXT

2009-05-12 Thread Paul McCullagh
009, at 5:30 PM, Kristian Nielsen wrote: Paul McCullagh writes: I am just trying to merge for the second time into mariadb-5.1-pbxt- merge-new, and get the following: pmc-2:Repositories/maria/mariadb-5.1-pbxt-merge-new] build% bzr merge lp:pbxt M storage/pbxt/src/cache_xt.cc M storage/pbxt/s

Re: [Maria-developers] MariaDB + PBXT

2009-05-12 Thread Paul McCullagh
x27;new-0' The merge was aborted because, after this I have: [pmc-2:Repositories/maria/mariadb-5.1-pbxt-merge-new] build% bzr diff . [pmc-2:Repositories/maria/mariadb-5.1-pbxt-merge-new] build% No diff. Any ideas? -- Paul McCullagh PrimeBase Technologi

Re: [Maria-developers] MariaDB + PBXT

2009-05-11 Thread Paul McCullagh
Hi Kristian, On May 11, 2009, at 4:24 PM, Kristian Nielsen wrote: Stewart, thanks for providing this procedure! Nice to know that this method with renaming to common paths and merging can work. Paul McCullagh writes: So to correct this I will have to redo the integration of PBXT is

Re: [Maria-developers] MariaDB + PBXT

2009-05-11 Thread Paul McCullagh
ip up a script that automatically tests a PBXT commit against current Drizzle and MariaDB. Hope this helps -- Stewart Smith -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Maili

Re: [Maria-developers] MariaDB + PBXT

2009-05-09 Thread Paul McCullagh
: Paul McCullagh writes: On Apr 6, 2009, at 1:17 PM, Kristian Nielsen wrote: Do you have a plan for merging in subsequent PBXT changes to MariaDB? (I guess you do, just don't know how it works). Would you be in charge of regular merging, or should the MariaDB team pull/merge from PBXT?

Re: [Maria-developers] MariaDB + PBXT

2009-04-07 Thread Paul McCullagh
On Apr 7, 2009, at 2:21 PM, Kristian Nielsen wrote: Paul McCullagh writes: The problem is occurring when running the PBXT test suite from the Maria mysql-test directory. So maybe the problem is that udf_example.so was not built. That was my thought too, but I checked, and the

Re: [Maria-developers] MariaDB + PBXT

2009-04-07 Thread Paul McCullagh
ee, and does not have its own config. The problem is occurring when running the PBXT test suite from the Maria mysql-test directory. So maybe the problem is that udf_example.so was not built. -- Paul McCullagh PrimeBase Technologies www.pri

Re: [Maria-developers] MariaDB + PBXT

2009-04-07 Thread Paul McCullagh
Hi Kristian, On Apr 7, 2009, at 12:48 PM, Kristian Nielsen wrote: Paul McCullagh writes: On Apr 6, 2009, at 1:17 PM, Kristian Nielsen wrote: Just let me know if you need more help/information on these failures. Yes, thanks. I would like to get these fixed. I have attached a log of

Re: [Maria-developers] MariaDB + PBXT

2009-04-06 Thread Paul McCullagh
gards, Paul - Kristian. -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : htt

[Maria-developers] MariaDB + PBXT

2009-04-03 Thread Paul McCullagh
only know that PBXT is installed because of the startup message it prints in the log. It does not create any files in the database root directory. Please let me know if this is OK for merge. Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org

Re: [Maria-developers] PBXT and MariaDB

2009-03-18 Thread Paul McCullagh
OK, thanks. Will do. On Mar 18, 2009, at 1:05 AM, Michael Widenius wrote: Hi! "Paul" == Paul McCullagh writes: From: Paul McCullagh Date: March 9, 2009 9:48:44 AM GMT+01:00 To: maria-developers@lists.launchpad.net Subject: [Maria-developers] PBXT and MariaDB Hi Monty, I

[Maria-developers] PBXT and MariaDB

2009-03-09 Thread Paul McCullagh
Hi Monty, In our call last week you suggested that I push PBXT into the MariaDB tree. Which branch should I push to? Best regards, Paul -- Paul McCullagh PrimeBase Technologies www.primebase.org www.blobstreaming.org pbxt.blogspot.com