Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Robin H. Johnson]

[-- Attachment #1: Type: text/plain, Size: 616 bytes --]

On Thu, Feb 26, 2009 at 03:06:11AM -0500, Caleb Cushing wrote:
> this is semi-targeted @ robbat2
> So I've been working on getting this ebuild working...
> here's what I know
...
> but with these patches mysql fails to build.
There were security changes in MySQL that caused the patches to not work
quite right anymore. Percona has updated patches, I just haven't got to
them yet, work is more pressing, trying for a product launch right
now...

-- 
Robin Hugh Johnson
Gentoo Linux Developer & Infra Guy
E-Mail     : robbat2@gentoo.org
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85

[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]

[gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Caleb Cushing]

this is semi-targeted @ robbat2

So I've been working on getting this ebuild working...

here's what I know

*   1001_all_show_patches-percona-5.0.75-b12.patch ...
              [ ok ]

all patches before this work and mysql builds
---
these are the only later patches that will cleanly apply

 *   1005_all_innodb_io_patches-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1007_all_mysqld_safe_syslog-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1008_all_innodb_locks_held-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1010_all_innodb_show_hashed_memory-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1011_all_innodb_check_fragmentation-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1013_all_innodb_fsync_source-percona-5.0.75-b12.patch ...
               [ ok ]
 *   1101_all_innodb_rw_lock-percona-5.0.75-b12.patch ...
               [ ok ]

but with these patches mysql fails to build.

srv0srv.c: In function ‘srv_printf_innodb_monitor’:
srv0srv.c:1763: error: ‘buf_pool_t’ has no member named
‘io_counter_heap’
srv0srv.c:1764: error: ‘buf_pool_t’ has no member named
‘io_counter_heap’
srv0srv.c:1817: error: ‘buf_pool_t’ has no member named
‘io_counter_hash’
srv0srv.c:1818: error: ‘buf_pool_t’ has no member named
‘io_counter_hash’
srv0srv.c:1820: error: ‘buf_pool_t’ has no member named
‘io_counter_hash’
srv0srv.c:1821: error: ‘buf_pool_t’ has no member named ‘io_counter_hash’

I just thought I'd post you on the fact that I'm working on it, and if
anyone wants to help get the latest 5.0 mysql working... the process
is a bit of a pita.
-- 
Caleb Cushing

http://xenoterracide.blogspot.com

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Caleb Cushing]

On Thu, Feb 26, 2009 at 2:08 AM, Robin H. Johnson <robbat2@gentoo.org> wrote:
> There were security changes in MySQL that caused the patches to not work
> quite right anymore. Percona has updated patches, I just haven't got to
> them yet, work is more pressing, trying for a product launch right
> now...

do these patches have a required order that you know of? some of the
new ones fail to apply... but they don't seem to have an order...

-- 
Caleb Cushing

http://xenoterracide.blogspot.com

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Robin H. Johnson]

[-- Attachment #1: Type: text/plain, Size: 887 bytes --]

On Fri, Feb 27, 2009 at 01:48:14AM -0500, Caleb Cushing wrote:
> On Thu, Feb 26, 2009 at 2:08 AM, Robin H. Johnson <robbat2@gentoo.org> wrote:
> > There were security changes in MySQL that caused the patches to not work
> > quite right anymore. Percona has updated patches, I just haven't got to
> > them yet, work is more pressing, trying for a product launch right
> > now...
> do these patches have a required order that you know of? some of the
> new ones fail to apply... but they don't seem to have an order...
Yes. There is a well defined order, you can get it from their SRPM
specfile. Also check to see which patches it deliberately DOESN'T apply.
Percona 5.0.75-b12 skipped the binlog-mirroring patch EG.

-- 
Robin Hugh Johnson
Gentoo Linux Developer & Infra Guy
E-Mail     : robbat2@gentoo.org
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85

[-- Attachment #2: Type: application/pgp-signature, Size: 330 bytes --]

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Caleb Cushing]

On Fri, Feb 27, 2009 at 2:01 AM, Robin H. Johnson <robbat2@gentoo.org> wrote:
> Yes. There is a well defined order, you can get it from their SRPM
> specfile. Also check to see which patches it deliberately DOESN'T apply.
> Percona 5.0.75-b12 skipped the binlog-mirroring patch EG.

http://www.percona.com/mysql/5.0.77-b13/patches/ < found their patches
there, I don't see any SRPM (source rpm?) on their download page.
patch documentation doesn't seem to imply an order either.

-- 
Caleb Cushing

http://xenoterracide.blogspot.com

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Caleb Cushing]

I went ahead and use the order you used previously all the patches
apply, but it still doesn't build.

86_64-pc-linux-gnu-g++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/var/lib/mysql\""
-DSHAREDIR="\"/usr/share/mysql\"" -I. -I../include
-I../innobase/include -I../innobase/include -I../include -I../include
-I../sql -I../sql -I../sql/examples -I../regex      -DDBUG_OFF -O2
-pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing
-felide-constructors -fno-rtti -fno-implicit-templates
-fno-implicit-templates -fno-exceptions -fno-rtti -MT field_conv.o -MD
-MP -MF .deps/field_conv.Tpo -c -o field_conv.o field_conv.cc
In file included from lib_sql.cc:34:
../sql/mysqld.cc: In function ‘int init_server_components()’:
../sql/mysqld.cc:3436: error: ‘make_master_open_index’ was not
declared in this scope
../sql/mysqld.cc:3488: error: ‘make_master’ was not declared in this
scope
make[3]: *** [lib_sql.o] Error 1
make[3]: *** Waiting for unfinished jobs....
mv -f .deps/derror.Tpo .deps/derror.Po
mv -f .deps/field_conv.Tpo .deps/field_conv.Po
mv -f .deps/field.Tpo .deps/field.Po
make[3]: Leaving directory
`/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql/libmysqld'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory
`/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql/libmysqld'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory
`/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql'
make: *** [all] Error 2


I'm going to try attaching the git patch to the version bump bug
(send-email won't handle it )
-- 
Caleb Cushing

http://xenoterracide.blogspot.com

Re: [gentoo-dev] working on mysql-community 5.0.77 - mysql-extras

[Gordon Malm]

On Friday, February 27, 2009 15:12:04 Caleb Cushing wrote:
> I went ahead and use the order you used previously all the patches
> apply, but it still doesn't build.
>
> 86_64-pc-linux-gnu-g++ -DEMBEDDED_LIBRARY -DMYSQL_SERVER
> -DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/var/lib/mysql\""
> -DSHAREDIR="\"/usr/share/mysql\"" -I. -I../include
> -I../innobase/include -I../innobase/include -I../include -I../include
> -I../sql -I../sql -I../sql/examples -I../regex      -DDBUG_OFF -O2
> -pipe -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -fno-strict-aliasing
> -felide-constructors -fno-rtti -fno-implicit-templates
> -fno-implicit-templates -fno-exceptions -fno-rtti -MT field_conv.o -MD
> -MP -MF .deps/field_conv.Tpo -c -o field_conv.o field_conv.cc
> In file included from lib_sql.cc:34:
> ../sql/mysqld.cc: In function ‘int init_server_components()’:
> ../sql/mysqld.cc:3436: error: ‘make_master_open_index’ was not
> declared in this scope
> ../sql/mysqld.cc:3488: error: ‘make_master’ was not declared in this
> scope
> make[3]: *** [lib_sql.o] Error 1
> make[3]: *** Waiting for unfinished jobs....
> mv -f .deps/derror.Tpo .deps/derror.Po
> mv -f .deps/field_conv.Tpo .deps/field_conv.Po
> mv -f .deps/field.Tpo .deps/field.Po
> make[3]: Leaving directory
> `/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql/libmysqld'
> make[2]: *** [all-recursive] Error 1
> make[2]: Leaving directory
> `/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql/libmysqld'
> make[1]: *** [all-recursive] Error 1
> make[1]: Leaving directory
> `/mnt/sda8/tmp/portage/dev-db/mysql-community-5.0.77/work/mysql'
> make: *** [all] Error 2
>
>
> I'm going to try attaching the git patch to the version bump bug
> (send-email won't handle it )

I've had success building dev-db/mysql-community-5.0.77 some days ago.  I 
commented on your version bump bug[1].  Can we please take this discussion 
there?  Thanks.

[1] http://bugs.gentoo.org/show_bug.cgi?id=260574

Gordon Malm (gengor)