Fails to compile on Arm/PPC in time_collector

Adding fpermissive to CXXFLAGS should fix it IMO.

I tried that and had no luck.

[ 78%] Building CXX object sql/CMakeFiles/sql.dir/query_response_time.cc.o
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc: In member function 'uint32 query_response_time::time_collector::count(uint) const':
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc:161:5: error: invalid conversion from 'const pthread_mutex_t*' to 'pthread_mutex_t*' [-fpermissive]
/usr/include/pthread.h:746:12: error: initializing argument 1 of 'int pthread_mutex_lock(pthread_mutex_t*)' [-fpermissive]
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc:163:5: error: invalid conversion from 'const pthread_mutex_t*' to 'pthread_mutex_t*' [-fpermissive]
/usr/include/pthread.h:757:12: error: initializing argument 1 of 'int pthread_mutex_unlock(pthread_mutex_t*)' [-fpermissive]
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc: In member function 'uint64 query_response_time::time_collector::total(uint) const':
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc:168:5: error: invalid conversion from 'const pthread_mutex_t*' to 'pthread_mutex_t*' [-fpermissive]
/usr/include/pthread.h:746:12: error: initializing argument 1 of 'int pthread_mutex_lock(pthread_mutex_t*)' [-fpermissive]
/root/Percona-Server-5.5.23-rel25.3/sql/query_response_time.cc:170:5: error: invalid conversion from 'const pthread_mutex_t*' to 'pthread_mutex_t*' [-fpermissive]
/usr/include/pthread.h:757:12: error: initializing argument 1 of 'int pthread_mutex_unlock(pthread_mutex_t*)' [-fpermi

On Tue, 22 May 2012 12:35:54 -0000, George <email address hidden> wrote:
> It would appear this has also happened on Sparc:
> This happens on Debian Wheezy on Arm.

neither sparc nor ARM are currently on the list of supported platforms
for Percona Server, so this will be pretty low down on our priority
list.

You are welcome to engage Percona to fix it, otherwise this will likely
remain unfixed for a long time.

--
Stewart Smith

In addition to what Stewart said, we may also consider patch submissions to fix such issues.

For reference, this also appears on PPC:

[ 91%] Building CXX object sql/CMakeFiles/sql.dir/query_response_time.cc.o
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc: In member function ‘uint32 query_response_time::time_collector::count(uint) const’:
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:161: error: invalid conversion from ‘const my_pthread_fastmutex_t*’ to ‘my_pthread_fastmutex_t*’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:161: error: initializing argument 1 of ‘int my_pthread_fastmutex_lock(my_pthread_fastmutex_t*)’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:163: error: invalid conversion from ‘const pthread_mutex_t*’ to ‘pthread_mutex_t*’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:163: error: initializing argument 1 of ‘int pthread_mutex_unlock(pthread_mutex_t*)’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc: In member function ‘uint64 query_response_time::time_collector::total(uint) const’:
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:168: error: invalid conversion from ‘const my_pthread_fastmutex_t*’ to ‘my_pthread_fastmutex_t*’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:168: error: initializing argument 1 of ‘int my_pthread_fastmutex_lock(my_pthread_fastmutex_t*)’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:170: error: invalid conversion from ‘const pthread_mutex_t*’ to ‘pthread_mutex_t*’
/mnt/backup1/mysql/Percona-Server-5.5.24-rel26.0/sql/query_response_time.cc:170: error: initializing argument 1 of ‘int pthread_mutex_unlock(pthread_mutex_t*)’
make[2]: *** [sql/CMakeFiles/sql.dir/query_response_time.cc.o] Error 1
make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2
make: *** [all] Error 2

gcc -v
Using built-in specs.
Target: powerpc-linux-gnu
Configured with: ../src/configure -v --with-pkgversion='Debian 4.4.5-8' --with-bugurl=file:///usr/share/doc/gcc-4.4/README.Bugs --enable-languages=c,c++,fortran,objc,obj-c++ --prefix=/usr --program-suffix=-4.4 --enable-shared --enable-multiarch --enable-linker-build-id --with-system-zlib --libexecdir=/usr/lib --without-included-gettext --enable-threads=posix --with-gxx-include-dir=/usr/include/c++/4.4 --libdir=/usr/lib --enable-nls --enable-clocale=gnu --enable-libstdcxx-debug --enable-objc-gc --enable-secureplt --disable-softfloat --enable-targets=powerpc-linux,powerpc64-linux --with-cpu=default32 --with-long-double-128 --enable-checking=release --build=powerpc-linux-gnu --host=powerpc-linux-gnu --target=powerpc-linux-gnu
Thread model: posix
gcc version 4.4.5 (Debian 4.4.5-8)

@George,

Did you remove CMakecache.txt and re-run cmake (or if you are on 5.1 then re-running ./configure) and do a clean build? fpermissive should downgrade the errors to warnings. So, unless you have Werror set (which causes warnings to become errors again) it shouldn't fail.

Can you provide us logs similar to http://buildlogs.pld-linux.org/index.php?dist=ac&arch=sparc&ok=0&ns=&cnt=50&off=0&name=mysql&id=6c312fca-446a-4c20-a51c-fbdbc724e4b5&action=text where it failed with fpermissive added to CXXFLAGS (don't add it to CFLAGS)?

[Expired for Percona Server 5.5 because there has been no activity for 60 days.]

I've managed to reproduce it ( chrooted debian running on an android phone ), and I also managed to bypass the compile error. The problems seems so that even if it compiles, it does not start up, fails with powering up InnoDB threads.
At the current state I don't think Percona could be pushed on ARM.

@peter

Interesting, Can you share the error (in the error log) which was emitted when the server failed to start?

Also, did passing -fpermissive in CXXFLAGS help?

There's a solution mentioned on Stackoverflow:
http://stackoverflow.com/questions/11501971/working-around-invalid-conversion-from-const

I've combined the portability patch and made one for the time collector bug as well, please see attached patch.
It as made for 5.5.29-rel4

this also happens with 5.5.32, linux debian 6 and pgi 2012.

"/devel/Percona-Server-5.5.32-rel31.0/sql/query_response_time.cc", line 161: error:
          argument of type "const pthread_mutex_t *" is incompatible with
          parameter of type "pthread_mutex_t *"
      my_atomic_rwlock_rdlock(&time_collector_lock);
      ^

"/devel/Percona-Server-5.5.32-rel31.0/sql/query_response_time.cc", line 163: error:
          argument of type "const pthread_mutex_t *" is incompatible with
          parameter of type "pthread_mutex_t *"
      my_atomic_rwlock_rdunlock(&time_collector_lock);
      ^

"/devel/Percona-Server-5.5.32-rel31.0/sql/query_response_time.cc", line 168: error:
          argument of type "const pthread_mutex_t *" is incompatible with
          parameter of type "pthread_mutex_t *"
      my_atomic_rwlock_rdlock(&time_collector_lock);
      ^

"/devel/Percona-Server-5.5.32-rel31.0/sql/query_response_time.cc", line 170: error:
          argument of type "const pthread_mutex_t *" is incompatible with
          parameter of type "pthread_mutex_t *"
      my_atomic_rwlock_rdunlock(&time_collector_lock);
      ^

4 errors detected in the compilation of "/devel/Percona-Server-5.5.32-rel31.0/sql/query_response_time.cc".

class time_collector::time_collector_lock field has to be marked as mutable. And in 5.7 fixed by removing atomic operation fallbacks.

Hello George, or anyone else affected,

Accepted percona-xtradb-cluster-5.5 into trusty-proposed. The package will build now and be available at https://launchpad.net/ubuntu/+source/percona-xtradb-cluster-5.5/5.5.37-25.10+dfsg-0ubuntu0.14.04.5 in a few hours, and then in the -proposed repository.

Please help us by testing this new package. See https://wiki.ubuntu.com/Testing/EnableProposed for documentation on how to enable and use -proposed.Your feedback will aid us getting this update out to other Ubuntu users.

If this package fixes the bug for you, please add a comment to this bug, mentioning the version of the package you tested and change the tag from verification-needed-trusty to verification-done-trusty. If it does not fix the bug for you, please add a comment stating that, and change the tag to verification-failed-trusty. In either case, details of your testing will help us make a better decision.

Further information regarding the verification process can be found at https://wiki.ubuntu.com/QATeam/PerformingSRUVerification . Thank you in advance!

This bug was fixed in the package percona-xtradb-cluster-5.5 - 5.5.37-25.10+dfsg-0ubuntu0.14.04.5

---------------
percona-xtradb-cluster-5.5 (5.5.37-25.10+dfsg-0ubuntu0.14.04.5) trusty; urgency=medium

  [ Mario Splivalo ]
  * d/p/fix-power8-crash-under-load.patch: Create proper barriers at
    mutex_exit() to fix crashes on ppc64el (LP: #1657256)

  [ Jorge Niedbalski ]
  * d/p/fix_time_collector_lock_type.patch: Fix FTBFS on multiple
    architectures by making time_collector_lock mutable (LP: #1002848).

 -- Christian Ehrhardt <email address hidden> Tue, 24 Oct 2017 09:24:33 +0200

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1916