View previous topic :: View next topic |
Author |
Message |
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Tue Mar 22, 2011 7:37 am Post subject: can't get mysql/mariadb to work (solved) |
|
|
Hello Community,
as I already wrote there: https://forums.gentoo.org/viewtopic-p-6621787.html#6621787 I have a brand new AMD Fusion E350 system. I got it somehow installed and running but now mysql and mariadb won't start.
Emerge works fine but when I run Code: | /usr/bin/mysql_install_db | I got a segfault of mysqld with Error:0 in libgcc_s.so.1.
I will post any more information as soon as I am back home in front of my system.
Maybe somebody has any idea where to start...
thx _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect...
Last edited by drizzt on Mon May 30, 2011 7:11 pm; edited 2 times in total |
|
Back to top |
|
|
msalerno Veteran
Joined: 17 Dec 2002 Posts: 1338 Location: Sweating in South Florida
|
Posted: Tue Mar 22, 2011 3:04 pm Post subject: |
|
|
Did you try a revdep-rebuild ? |
|
Back to top |
|
|
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Tue Mar 22, 2011 4:33 pm Post subject: |
|
|
Yes, multiple times.
This is my emerge --info:
Code: |
emerge --info
Portage 2.1.9.43 (default/linux/amd64/10.0/server, gcc-4.5.2, glibc-2.13-r2, 2.6.38-gentoo x86_64)
=================================================================
System uname: Linux-2.6.38-gentoo-x86_64-AMD_E-350_Processor-with-gentoo-2.0.1
Timestamp of tree: Sun, 20 Mar 2011 20:30:01 +0000
app-shells/bash: 4.2_p8
dev-lang/python: 2.6.6-r2, 2.7.1-r1, 3.1.3-r1
dev-util/cmake: 2.8.4
sys-apps/baselayout: 2.0.1-r1
sys-apps/openrc: 0.7.0
sys-apps/sandbox: 2.4
sys-devel/autoconf: 2.68
sys-devel/automake: 1.10.3, 1.11.1
sys-devel/binutils: 2.21
sys-devel/gcc: 4.4.4-r2, 4.5.2
sys-devel/gcc-config: 1.4.1
sys-devel/libtool: 2.4-r1
sys-devel/make: 3.82
virtual/os-headers: 2.6.36.1 (sys-kernel/linux-headers)
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-mtune=generic -O2 -pipe -mssse3 -msse4a -mmmx -msse -msse2"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo"
CXXFLAGS="-mtune=generic -O2 -pipe -mssse3 -msse4a -mmmx -msse -msse2"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests binpkg-logs distlocks fixlafiles fixpackages news parallel-fetch protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
FFLAGS=""
GENTOO_MIRRORS="rsync://gentoo.tiscali.nl/gentoo/ http://gentoo.mirrors.easynews.com/linux/gentoo/ ftp://distro.ibiblio.org/pub/linux/distributions/gentoo/ rsync://gentoo.mirrors.tds.net/gentoo rsync://212.219.56.139/www.ibiblio.org/gentoo/ rsync://mirror.leaseweb.com/gentoo/ rsync://mirror.cambrium.nl/gentoo/ http://mirror.cambrium.nl/pub/os/linux/gentoo/ http://ftp.snt.utwente.nl/pub/os/linux/gentoo ftp://91.121.125.139/gentoo-distfiles/"
LANG="de_DE.utf8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY=""
SYNC="rsync://rsync8.de.gentoo.org/gentoo-portage"
USE="X acl acpi alsa amd64 apm bash-completion berkdb bzip2 cli consolekit cracklib crypt cups cxx dbus device-mapper dri extras fam fortran gdbm gdu gpm graphite iconv jpeg libnotify lzo mmx mmxext modules mudflap multilib ncurses nls nptl nptlonly openmp pam pcre policykit pppd python readline sdl sensord session snmp sse sse2 sse4 sse4a ssl ssse3 startup-notification sysfs tcpd truetype udev unicode xml xorg zlib" ALSA_CARDS="hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" PHP_TARGETS="php5-3" QEMU_SOFTMMU_TARGETS="x86_64" QEMU_USER_TARGETS="x86_64" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="radeon r600 r300" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
|
UPDATE:
After changing the CFLAGS (see my other thread mentioned above) the situation slightly changed. The script still fails but with no errormessage. It just says script failed, no segfault logged, no errorcode...
And I still can't access the mysql server. _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect... |
|
Back to top |
|
|
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Thu Mar 24, 2011 7:16 am Post subject: |
|
|
Since I can't find any solution I've thrown away the installation and started over again. Let's see how far I can get this time. _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect... |
|
Back to top |
|
|
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Thu Mar 24, 2011 6:34 pm Post subject: |
|
|
Here we go, fresh install, mysql still fails:
Quote: | 110324 20:06:32 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
ERROR: 1004 Can't create file '/tmp/' (errno: 21)
110324 20:06:40 [ERROR] Aborting
110324 20:06:40 [Note] /usr/sbin/mysqld: Shutdown complete
|
Of course /tmp is there and has proper rights:
Quote: | drwxr-xr-x 12 root root 0 Mar 24 19:03 sys
drwxrwxrwt 4 root root 4096 Mar 24 20:04 tmp
drwxr-xr-x 13 root root 4096 Mar 23 23:45 usr
drwxr-xr-x 12 root root 4096 Mar 24 17:31 var
|
Anybody any ideas ? _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect... |
|
Back to top |
|
|
BVer n00b
Joined: 11 Aug 2005 Posts: 7
|
Posted: Thu May 12, 2011 9:10 am Post subject: |
|
|
drizzt,
Code: | CFLAGS="-O1 -pipe -march=amdfam10 -mcx16 -mpopcnt -mmmx -msse -msse2 -mssse3 -msse4a" |
works for me.
It seems that mysql-5.1.56 does not like the -O2 optimisation level when using gcc 4.4.5 on AMD E-350.
Another packages were compiled with -O2 -- no issues. I have no idea why - and have no time for a deeper investigation.
Hope it helps. |
|
Back to top |
|
|
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Thu May 19, 2011 6:33 pm Post subject: |
|
|
Thanks for the hint, I will try as soon as I can. _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect... |
|
Back to top |
|
|
drizzt Guru
Joined: 21 Jul 2002 Posts: 428
|
Posted: Mon May 30, 2011 7:11 pm Post subject: |
|
|
Thank you very much for this tip. It worked right away.
I added "-mno-3dnow" to your line:
Code: | CFLAGS="-O1 -pipe -march=amdfam10 -mcx16 -mpopcnt -mmmx -msse -msse2 -mssse3 -msse4a -mno-3dnow" |
Since Fusion definitely don't support this anymore.
Hopefully one of the devs read this and puts this information into a proper place / or apply proper filter to packages. _________________ People don't have to earn my respect. I offer my respect to them, but be careful to lose my respect... |
|
Back to top |
|
|
hujuice Guru
Joined: 16 Oct 2007 Posts: 336 Location: Rome, Italy
|
Posted: Sat Nov 12, 2011 9:24 pm Post subject: |
|
|
Setting CFLAGS to -O1 was a solution for me too, compiling and running dev-db/mariadb-5.1.50 on Zacate.
CPU: | # cat /proc/cpuinfo|grep "model name"
model name : AMD E-350 Processor
model name : AMD E-350 Processor |
Also, for people don't knowing/remebering this feature, you can set per-package CFLAGS (or other variables).
Per-package settings: | # echo "CFLAGS=\"-march=amdfam10 -mno-3dnow -O2 -pipe\"" >> /etc/portage/env/O1-CFLAGS.conf
# echo "dev-db/mariadb O1-CFLAGS.conf" >> /etc/portage/package.env |
I did so, because I'm running a well working ("headless") machine with
General CFLAGS (make.conf): | CFLAGS="-march=amdfam10 -mno-3dnow -O2 -pipe" |
and I don't want to change the setting for the whole system.
I really love the Zacate/MiniITX solution, but it is somewhat pioneer (until the new gcc, I suppose).
Regards,
HUjuice _________________ Who hasn't a spine, should have a method.
Chi non ha carattere, deve pur avere un metodo. |
|
Back to top |
|
|
|