I keep getting this compilation error in all machine i have tried to build on:
[ 40%] Building CXX object storage/innobase/CMakeFiles/innobase.dir/row/row0log.cc.o
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc: In function ‘dberr_t row_log_table_apply_ops(que_thr_t*, row_merge_dup_t*)’:
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc:2367:11: error: ‘srv_buf_size’ was not declared in this scope
ofs, srv_buf_size);
^
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc: In function ‘dberr_t row_log_apply_ops(trx_t*, dict_index_t*, row_merge_dup_t*)’:
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc:3156:11: error: ‘srv_buf_size’ was not declared in this scope
ofs, srv_buf_size);
^
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc: In function ‘dberr_t row_log_table_apply_ops(que_thr_t*, row_merge_dup_t*)’:
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc:2310:39: warning: ignoring return value of ‘int ftruncate(int, __off64_t)’, declared with attribute warn_unused_result [-Wunused-result]
ftruncate(index->online_log->fd, 0);
^
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc: In function ‘dberr_t row_log_apply_ops(trx_t*, dict_index_t*, row_merge_dup_t*)’:
/root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/row0log.cc:3103:39: warning: ignoring return value of ‘int ftruncate(int, __off64_t)’, declared with attribute warn_unused_result [-Wunused-result]
ftruncate(index->online_log->fd, 0);
^
make[2]: *** [storage/innobase/CMakeFiles/innobase.dir/row/row0log.cc.o] Error 1
make[1]: *** [storage/innobase/CMakeFiles/innobase.dir/all] Error 2
make: *** [all] Error 2
==> ERROR: A failure occurred in build().
Aborting...
Search Criteria
Package Details: mysql 9.0.1-1
Package Actions
Git Clone URL: | https://aur.archlinux.org/mysql.git (read-only, click to copy) |
---|---|
Package Base: | mysql |
Description: | Fast SQL database server, community edition |
Upstream URL: | https://www.mysql.com/products/community/ |
Licenses: | GPL-2.0-only |
Conflicts: | mariadb |
Provides: | mariadb, mysql |
Submitter: | Barthalion |
Maintainer: | Muflone |
Last Packager: | Muflone |
Votes: | 82 |
Popularity: | 0.034019 |
First Submitted: | 2013-04-25 19:13 (UTC) |
Last Updated: | 2024-08-11 14:51 (UTC) |
Dependencies (28)
- bash (bash-devel-static-gitAUR, bash-devel-gitAUR, busybox-coreutilsAUR, bash-gitAUR)
- icu (icu-gitAUR)
- jemalloc (jemalloc-gitAUR)
- libaio (libaio-gitAUR)
- libevent (libevent-gitAUR)
- libsasl
- libtirpc
- lz4 (lz4-gitAUR)
- mysql-clientsAUR (mysql-clients55AUR, mysql-clients56AUR, mariadb-clients-gitAUR, mysql-clients81AUR, mysql-clients57AUR, mroongaAUR, mysql-clientsAUR, mysql-clients80AUR, mariadb-clients, mariadb-lts-clients, percona-server-clients)
- systemd-libs (systemd-chromiumos-libsAUR, systemd-libs-selinuxAUR, systemd-libs-gitAUR, systemd-libs-fmlAUR)
- zlib (zlib-ng-compat-gitAUR, zlib-gitAUR, zlib-ng-compat)
- zstd (zstd-gitAUR, zstd-staticAUR)
- cmake (cmake-gitAUR) (make)
- icu (icu-gitAUR) (make)
- jemalloc (jemalloc-gitAUR) (make)
- libaio (libaio-gitAUR) (make)
- libedit (make)
- libevent (libevent-gitAUR) (make)
- libfido2 (libfido2-fullAUR) (make)
- libtirpc (make)
- openssl (openssl-gitAUR, openssl-staticAUR) (make)
- rapidjson (rapidjson-gitAUR) (make)
- re2 (re2-gitAUR) (make)
- rpcsvc-proto (make)
- systemd-libs (systemd-chromiumos-libsAUR, systemd-libs-selinuxAUR, systemd-libs-gitAUR, systemd-libs-fmlAUR) (make)
- systemd-tools (systemd-chromiumosAUR, systemd-selinuxAUR, systemd-gitAUR, systemd-fmlAUR, systemd) (make)
- zlib (zlib-ng-compat-gitAUR, zlib-gitAUR, zlib-ng-compat) (make)
- perl-dbd-mysql (optional) – for mysqlhotcopy, mysql_convert_table_format, mysql_setpermission, mysqldumpslow
Required by (208)
- adminer (optional)
- adminer (requires mariadb) (optional)
- adminer-editor (requires mariadb) (optional)
- adminer-git (requires mariadb) (optional)
- aegir (requires mariadb)
- akonadi-git (requires mariadb) (optional)
- akonadi-git (requires mariadb) (make)
- amarok (requires mariadb)
- amarok-git (requires mariadb)
- ampache (requires mariadb)
- anope (requires mariadb) (optional)
- authpuppy
- avantfax (requires mariadb)
- azerothcore (requires mariadb)
- baikal (requires mariadb) (optional)
- baikal-git (requires mariadb) (optional)
- bareos-filedaemon-mariabackup-python-plugin (requires mariadb)
- bgbilling (requires mariadb) (optional)
- bgerp (requires mariadb) (optional)
- bgerp-git (requires mariadb) (optional)
- bookstack (requires mariadb) (optional)
- burstcoin-wallet (requires mariadb) (optional)
- camlistore (requires mariadb) (optional)
- casdoor (requires mariadb) (optional)
- chevereto (requires mariadb)
- citespace (optional)
- cockatrice-server-git (requires mariadb) (optional)
- codimd-git (requires mariadb) (optional)
- contao
- cqrlog-bin (requires mariadb)
- cqrlog-git (requires mariadb)
- cqrlog-source (requires mariadb)
- cqrtest-git (requires mariadb)
- craftbukkit-plugin-worldguard (requires mariadb) (optional)
- cups-print-to-programme (requires mariadb)
- diaspora-mysql (requires mariadb) (optional)
- diaspora-mysql-git (requires mariadb) (optional)
- documize-community-bin (requires mariadb) (optional)
- domjudge-docs (optional)
- domjudge-domserver (optional)
- domjudge-judgehost (optional)
- domjudge-submit (optional)
- drogon (requires mariadb) (make)
- drogon-git (requires mariadb)
- emoncms (requires mariadb)
- engelsystem (requires mariadb)
- erpnext (requires mariadb)
- etherdraw (requires mariadb) (optional)
- etherpad-lite (requires mariadb) (optional)
- ethoscope-device (requires mariadb)
- ethoscope-node (requires mariadb)
- ethoscope-virtuascope (requires mariadb)
- fabaria (requires mariadb)
- farmos (requires mariadb) (optional)
- file-rename-utils (requires mariadb)
- firefox-syncstorage (optional)
- firefox-syncstorage-git (optional)
- flyspray (requires mariadb) (optional)
- forgejo-git (requires mariadb) (optional)
- frappe-bench (requires mariadb) (optional)
- freshrss (optional)
- gdal-hdf4 (requires mariadb) (optional)
- gitea-git (requires mariadb) (optional)
- glpi
- gnunet (optional)
- gnunet-git (optional)
- gogs (requires mariadb) (optional)
- gogs-git (requires mariadb) (optional)
- halcyon (requires mariadb)
- hedgedoc2 (requires mariadb) (optional)
- holland-mariabackup (requires mariadb)
- hoteldruid
- hustoj-web-git (requires mariadb) (optional)
- invoiceninja (requires mariadb) (optional)
- iyuuplus (requires mariadb)
- iyuuplus-git (requires mariadb)
- jackal (requires mariadb) (optional)
- jackal-git (requires mariadb) (optional)
- joomla (requires mariadb) (optional)
- kamailio (requires mariadb) (make)
- kanboard (requires mariadb) (optional)
- kannel (requires mariadb) (make)
- kannel (requires mariadb) (optional)
- kea-git (requires mariadb) (optional)
- kimai-git (requires mariadb)
- kimai2 (requires mariadb)
- koel
- kolide-git
- kopano-core (requires mariadb)
- kopano-core-git (requires mariadb)
- kopano-postfixadmin
- leed
- libakonadi-git (requires mariadb) (make)
- libpreludedb (requires mariadb) (optional)
- librespeed-go (requires mariadb) (optional)
- limesurvey (requires mariadb) (optional)
- limesurvey (optional)
- limesurvey2 (requires mariadb) (optional)
- limesurvey2 (optional)
- lsky-pro (optional)
- lychee-photo-management (optional)
- lylibrary (requires mariadb)
- lyricue (requires mariadb) (optional)
- mantisbt (requires mariadb) (optional)
- matomo (requires mariadb) (optional)
- matomo-git (requires mariadb)
- mattermost-git (requires mariadb) (optional)
- meowsql (requires mariadb) (optional)
- meowsql-git (requires mariadb) (optional)
- mirthconnect (requires mariadb) (optional)
- modoboa (optional)
- monica-crm (requires mariadb) (optional)
- moodle (requires mariadb)
- moodle-stable (requires mariadb)
- movim (requires mariadb) (optional)
- movim-git (requires mariadb) (optional)
- mysqltcl (requires mariadb)
- mythtv-git (requires mariadb) (optional)
- my_timers (optional)
- my_timers (requires mariadb) (optional)
- nagiosql
- nextcloud-daily (requires mariadb) (optional)
- nextcloud-git (requires mariadb) (optional)
- officelife-git (optional)
- officelife-git (requires mariadb) (optional)
- ofork (requires mariadb) (optional)
- ojs (requires mariadb) (optional)
- onlyoffice-documentserver-bin (requires mariadb) (optional)
- open3d
- opengts (requires mariadb)
- openmeetings (optional)
- opennebula (requires mariadb)
- opennebula (requires mariadb) (make)
- opensimulator (optional)
- openstamanager (requires mariadb) (optional)
- ordersprinter
- osticket (requires mariadb)
- otrs (requires mariadb) (optional)
- owncloud (requires mariadb) (optional)
- pagure-mariadb (requires mariadb)
- paperless-ngx-venv (requires mariadb) (make)
- paperless-ngx-venv (requires mariadb) (optional)
- photoprism (requires mariadb) (optional)
- photoview (requires mariadb) (optional)
- piler (requires mariadb) (make)
- piwigo (requires mariadb)
- pixelfed (optional)
- plikd (optional)
- plikd (requires mariadb) (optional)
- policyd-mysql
- powershell-empire (optional)
- powershell-empire-git (optional)
- prestashop (requires mariadb)
- privacy-protection-messenger (requires mariadb)
- privacy-protection-messenger (requires mariadb) (make)
- pterodactyl-panel (requires mariadb) (optional)
- ptokax (requires mariadb) (optional)
- pydio (requires mariadb) (optional)
- python-gdal-hdf4 (requires mariadb) (optional)
- python-open3d
- python-py3d
- python-pydal-git (requires mariadb) (optional)
- qt3 (requires mariadb) (make)
- quickfix (optional)
- r-rmysql (requires mariadb) (check)
- racktables (requires mariadb) (optional)
- rivendell (requires mariadb)
- rompr (optional)
- seiscomp (requires mariadb)
- seiscomp-git (requires mariadb)
- selfoss (requires mariadb) (optional)
- selfoss-git (requires mariadb) (optional)
- semaphore-bin (requires mariadb) (optional)
- sftpgo (requires mariadb) (optional)
- sftpgo-bin (requires mariadb) (optional)
- sftpgo-git (requires mariadb) (optional)
- sharry (requires mariadb) (optional)
- shlink (requires mariadb) (optional)
- shlink (optional)
- snappymail (requires mariadb) (optional)
- sogo (requires mariadb) (optional)
- sogo2 (requires mariadb) (optional)
- sope (requires mariadb) (optional)
- sope2 (requires mariadb) (optional)
- sqls (optional)
- supysonic (requires mariadb) (optional)
- tango
- tango-database (requires mariadb)
- teampass
- thingspeak-git (requires mariadb)
- tieba-cloud-sign (requires mariadb)
- trojan-git (requires mariadb) (optional)
- tt-rss-git (optional)
- typecho (requires mariadb) (optional)
- udf-infusion-git (make)
- urweb-git (requires mariadb) (optional)
- vmangos-git (requires mariadb)
- vmangos-setupdb (requires mariadb)
- vtigercrm (requires mariadb)
- wiki-js (requires mariadb) (optional)
- wiki-js-git (requires mariadb) (optional)
- wordpress-git (requires mariadb) (optional)
- writefreely (requires mariadb) (optional)
- writefreely-git (requires mariadb) (optional)
- yourls (optional)
- yourls-git
- zoneminder (requires mariadb) (optional)
- zoneminder-git (requires mariadb) (optional)
Sources (8)
<deleted-account> commented on 2013-08-19 22:10 (UTC)
<deleted-account> commented on 2013-07-10 23:45 (UTC)
@rustam problem FIXED!
rustam commented on 2013-07-10 11:19 (UTC)
@vfbsilva: I've updated the package so it now cleans out the build directory before building, this should resolve the problem.
<deleted-account> commented on 2013-07-10 04:21 (UTC)
I cannot build this package
==> Making package: mysql 5.6.12-2 (Wed Jul 10 01:13:20 BRT 2013)
==> Checking runtime dependencies...
==> Checking buildtime dependencies...
==> Retrieving sources...
-> Found mysql-5.6.12.tar.gz
-> Found mysql-5.6.12.tar.gz.asc
-> Found mysqld-post.sh
-> Found mysqld-tmpfile.conf
-> Found mysqld.service
==> Validating source files with sha256sums...
mysql-5.6.12.tar.gz ... Passed
mysql-5.6.12.tar.gz.asc ... Skipped
mysqld-post.sh ... Passed
mysqld-tmpfile.conf ... Passed
mysqld.service ... Passed
==> Verifying source file signatures with gpg...
mysql-5.6.12.tar.gz ... FAILED (unknown public key 8C718D3B5072E1F5)
==> WARNING: Warnings have occurred while verifying the signatures.
Please make sure you really trust them.
==> Extracting sources...
-> Extracting mysql-5.6.12.tar.gz with bsdtar
==> Removing existing pkg/ directory...
==> Starting build()...
mkdir: cannot create directory ‘build’: File exists
==> ERROR: A failure occurred in build().
Aborting...
The build failed.
local database is up to date
How should I proceed?
rustam commented on 2013-06-13 09:07 (UTC)
Ah, I see now. On my systems it just throws a warning but doesn't prevent building, and I can see the same in the Arch wiki http://bit.ly/12oPo0W. Not sure why it's the error in your case. The reason for this verification failure is that Oracle's GPG keys are not added to the keyring. So, successful GPG checking would require you to manually init the keyring and import their key, run:
gpg --list-keys
gpg --recv-keys 8C718D3B5072E1F5
Then try installing aur/mysql again, it should resolve the problem. Probably I will need to drop gpg checking in this AUR package, as it makes no sense for me manually adding the signature, or build another package with their keyring and install it prior to MySQL installation as a dependency.
kralibes commented on 2013-06-13 06:13 (UTC)
With yaourt.
Now I see that it's not a checksum error but an error of failing gpg signature - sorry for this.
(german)
==> Überprüfe Signaturen der Quell-Dateien mit gpg...
mysql-5.6.11.tar.gz ... FEHLGESCHLAGEN
==> FEHLER: Eine oder mehrere PGP-Signaturen konnten nicht überprüft werden.
==> ERROR: Makepkg was unable to build mysql.
==> Restart building mysql ? [y/N]
==> ------------------------------
rustam commented on 2013-06-11 18:38 (UTC)
@kralibes: I see no issues with checksums; double checked it and it's valid and the package builds on my machines. Do you use yaourt or manually downloaded the pkgbuild and building in a directory with makepkg? In the latter case, try removing mysql-5.6.11.tar.gz and re-download it.
kralibes commented on 2013-06-11 18:10 (UTC)
No valid checksum for mysql 5.6.11.
rustam commented on 2013-05-29 10:20 (UTC)
MySQL 5.6.11 is the current stable GA release, so I'm gonna update this package to that version shortly. I've submitted the mysql55 package for those who still need v5.5.
Barthalion commented on 2013-05-16 13:01 (UTC)
If you don't have time to compile new release on your own, I uploaded signed packages here: http://repo.bpiotrowski.pl/tmp/mysql/
Pinned Comments
Muflone commented on 2023-08-16 17:21 (UTC) (edited on 2023-08-16 20:41 (UTC) by Muflone)
Warning
https://dev.mysql.com/doc/refman/8.1/en/downgrading.html
Downgrade from MySQL 8.1 to MySQL 8.0 or earlier is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you back up your data before starting the upgrade process.
MySQL 8.0 is available in https://aur.archlinux.org/packages/mysql80