[csw-maintainers] mysql-5.0.84 in testing (a garified package)

[Maciej (Matchek) Blizinski]

On Fri, Nov 6, 2009 at 12:00 AM, Philip Brown <phil at bolthole.com> wrote:
> On Thu, Nov 5, 2009 at 1:25 PM, Ihsan Dogan <ihsan at opencsw.org> wrote:
>>
>>
>> I'm wondering if it makes sense to build an optimized Solaris 10 binary
>> with the optimisations mentioned on
>> http://developers.sun.com/solaris/articles/mysql_perf_tune.html .
>>
>>
>
> I would accept a multi-OS release set, if this effort were made (grmblegrumble)
>
> that is to say, like openssh, if you offered a sol [8/9] compiled
> package, and in addition, a separate sol10 compiled and optimized
> package.

Yes, it makes sense.  Once the package is satisfactory in the basic
form, we can go ahead and try add the optimization flags.

Meanwhile, I started looking at the included unit tests.  I don't know
if the package was passing the tests previously, but I think it's a
good idea to have all the unit tests pass.  I suspect that the tests
will need some porting or adjusting to Solaris.  The first problem I'm
seeing is:

binlog_start_comment           [ fail ]

mysqltest: At line 13: query 'load data infile
'../std_data_ln/words.dat' into table t1 -- load data to t1' failed:
1085: The file '/export/home/blizinski/opencsw/pkg/mysql5/branches/mysql-5.0.x/work/build-isa-i386/mysql-5.0.84/mysql-test/var/std_data_ln/words'
must be in the database directory or be readable by all

The result from queries just before the failure was:
reset master;
drop table if exists t1,t2;
create table t1 (word varchar(20)) -- create table t1;
create table t2 (word varchar(20)) -- create table t2;
load data infile '../std_data_ln/words.dat' into table t1 -- load data to t1;

More results from queries before failure can be found in
/export/home/blizinski/opencsw/pkg/mysql5/branches/mysql-5.0.x/work/build-isa-i386/mysql-5.0.84/mysql-test/var/log/binlog_start_comment.log

Aborting: binlog_start_comment failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
gmake: *** [test-ns] Error 1
gmake: Leaving directory
`/export/home/blizinski/opencsw/pkg/mysql5/branches/mysql-5.0.x/work/build-isa-i386/mysql-5.0.84'

Do people know if those tests were passing before and what has been
done to make them pass?

Maciej