@muflone Thanks, yeah I did rebuild the package after sending that message. It took 3 hours to compile but it works now!
Search Criteria
Package Details: mysql 8.2.0-1
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 |
Conflicts: | mariadb |
Provides: | mariadb, mysql |
Submitter: | Barthalion |
Maintainer: | Muflone |
Last Packager: | Muflone |
Votes: | 81 |
Popularity: | 0.83 |
First Submitted: | 2013-04-25 19:13 (UTC) |
Last Updated: | 2023-11-15 01:11 (UTC) |
Dependencies (28)
- bash (bash-devel-static-gitAUR, bash-gitAUR, bash-devel-gitAUR, busybox-coreutilsAUR)
- 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-clientsAUR, mysql-clients81AUR, mysql-clients57AUR, mroongaAUR, mysql-clients80AUR, mariadb-clients, mariadb-lts-clients, percona-server-clients)
- systemd-libs (systemd-libs-gitAUR, systemd-libs-fmlAUR, systemd-chromiumos-libsAUR, systemd-libs-selinuxAUR)
- zlib (zlib-ng-compat-gitAUR, zlib-gitAUR, zlib-ng-compatAUR)
- 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)
- Show 8 more dependencies...
Required by (205)
- adminer (optional)
- adminer (requires mariadb) (optional)
- adminer-editor (requires mariadb) (optional)
- adminer-git (requires mariadb) (optional)
- aegir (requires mariadb)
- akonadi-git (requires mariadb) (make)
- akonadi-git (requires mariadb) (optional)
- 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
- 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-ecw (requires mariadb) (optional)
- gdal-hdf4 (requires mariadb) (optional)
- gdal1 (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)
- jupyter_contrib_nbextensions (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 (optional)
- limesurvey (requires mariadb) (optional)
- limesurvey2 (requires mariadb) (optional)
- limesurvey2 (optional)
- lsky-pro (optional)
- lychee-photo-management (optional)
- lylibrary
- 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)
- 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)
- onlyoffice-documentserver-bin (requires mariadb) (optional)
- 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)
- pagure-mariadb (requires mariadb)
- paperless-ngx (requires mariadb) (optional)
- photoview (requires mariadb) (optional)
- piler (requires mariadb) (make)
- piwigo (requires mariadb)
- pixelfed (optional)
- plikd (requires mariadb) (optional)
- plikd (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-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)
- stalwart-mail-bin (requires mariadb) (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)
- trojan-plus (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)
- vtk6-legacy (requires mariadb) (make)
- vtk6-legacy (requires mariadb) (optional)
- 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)
Sources (7)
Speykious commented on 2023-12-18 18:42 (UTC)
Muflone commented on 2023-12-18 17:51 (UTC)
@Speykious this sort of error means you haven't rebuilt the package after the icu change: https://wiki.archlinux.org/title/Arch_User_Repository#Updating_packages
Speykious commented on 2023-12-18 15:11 (UTC) (edited on 2023-12-18 15:14 (UTC) by Speykious)
mysqld
kept failing to launch, so I looked at the logs with journalctl and saw this:
/usr/bin/mysqld: error while loading shared libraries: libicuuc.so.73: cannot open shared object file: No such file or directory
The package core/icu
just got an update and is now apparently on version 74. I'd love to rollback icu
but way too many things depend on it, I'd be happy for some kind of solution.
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
Muflone commented on 2023-08-13 21:04 (UTC) (edited on 2023-08-13 21:08 (UTC) by Muflone)
@bokic the PKGBUILDs must never change the user preferences, like the building processes, until there's a strong reason to do, like disabling some option which may cause issues
https://wiki.archlinux.org/title/Makepkg#Parallel_compilation
bokic commented on 2023-08-13 20:39 (UTC)
@muflone If set in makepkg.conf might fail to build some packages that do not support it. thus AFAIK is best to be per project setting.
Muflone commented on 2023-08-13 14:27 (UTC)
@bokic
you have to configure this in your MAKEFLAGS in makepkg.conf
bokic commented on 2023-08-13 13:34 (UTC)
Can we build with make -j$(nproc)
to use all cores?
zenochen commented on 2023-08-11 01:36 (UTC) (edited on 2023-08-27 08:07 (UTC) by zenochen)
this bug fixed in glibc 2.38-3, mysql cannot be started only in 2.38-2.
old post below: After updating to glibc 2.38, mysqld is no longer available, upgrade cautiously.
mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
2023-08-11T01:12:40.308126Z 0 [System] [MY-013169] [Server] /usr/bin/mysqld (mysqld 8.0.34) initializing of server in progress as process 405
2023-08-11T01:12:40Z UTC - mysqld got signal 11 ;
Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.
BuildID[sha1]=8bce192f80e0338fa73a2ba7266c4d76c054e30d
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x100000
/usr/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x42) [0x558c830b0e22]
/usr/bin/mysqld(print_fatal_signal(int)+0x3e7) [0x558c826e7887]
/usr/bin/mysqld(handle_fatal_signal+0x82) [0x558c826e7a12]
/usr/lib/libc.so.6(+0x3e710) [0x7fc6c803e710]
/usr/bin/mysqld(+0x90b14e) [0x558c823d514e]
/usr/bin/mysqld(delegates_init()+0x33) [0x558c82e6d793]
/usr/bin/mysqld(+0x9e9ab3) [0x558c824b3ab3]
/usr/bin/mysqld(mysqld_main(int, char**)+0x1d84) [0x558c824bc264]
/usr/lib/libc.so.6(+0x27cd0) [0x7fc6c8027cd0]
/usr/lib/libc.so.6(__libc_start_main+0x8a) [0x7fc6c8027d8a]
/usr/bin/mysqld(_start+0x25) [0x558c8248e9d5]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
maybe this is the bug of glibc, it only can be reproduced in vps runs in proxmox virtual environment and also the glibc is 2.38, I tried the same version in esxi, but no problem.
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