mysql type_float.reject
gjohnson5
tonyjohn5 at yahoo.com
Sun Jun 1 01:14:44 UTC 2008
Tom Lane-4 wrote:
>
> gjohnson5 <tonyjohn5 at yahoo.com> writes:
>> The compiler is gcc-4.3.0-8 which is the latest from Fedora
>> [gjohnson at localhost config]$ rpm -qa gcc
>> gcc-4.3.0-8.x86_64
>
> You're really making me beg for each individual nugget of information,
> aren't you? Is this F-9 or rawhide? Are you using any non-default
> CFLAGS when you build mysql? And I gather from the above that
> it's not IA64 at all, but exactly what CPU is it? It might make a
> difference in a case like this to know which sub-variant of x86_64
> we are talking about.
>
> (In case my frustration is not evident, mysql builds and passes its
> regression tests just fine for me in rawhide on an Intel Xeon, and Matt
> Domsch's recent rebuild tests didn't show a problem either. So there is
> *something* different about your system, but you're being quite
> unhelpful about providing information as to what.)
>
> regards, tom lane
>
> --
> fedora-test-list mailing list
> fedora-test-list at redhat.com
> To unsubscribe:
> https://www.redhat.com/mailman/listinfo/fedora-test-list
>
>
It's all good my man and thanks for the help. You're frustrated and I named
a computer "loser", so I guess we have something in common...
Anyway I just got this machine back from storage as I travel for a living
(not any more) and couldn't carry this thing around
ASUS NCT-D BIOS 1009001 (which is Beta for over a year) with 2 Single Core
Xeon 3.6GHZ and 4GB Ram
But:[gjohnson at loser ~]$ cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 3
cpu MHz : 3600.121
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 3
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm
constant_tsc pebs bts pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7206.92
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 3
cpu MHz : 3600.121
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
apicid : 6
initial apicid : 6
fpu : yes
fpu_exception : yes
cpuid level : 3
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm
constant_tsc pebs bts pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7200.17
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 3
cpu MHz : 3600.121
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 3
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm
constant_tsc pebs bts pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7200.14
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 3
cpu MHz : 3600.121
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 0
cpu cores : 1
apicid : 7
initial apicid : 7
fpu : yes
fpu_exception : yes
cpuid level : 3
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca
cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm
constant_tsc pebs bts pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7200.15
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
[gjohnson at loser proc]$ cat kcore
cat: kcore: Permission denied
[gjohnson at loser proc]$ su
Password:
[root at loser proc]# cat meminfo
MemTotal: 4010712 kB
MemFree: 697300 kB
Buffers: 403640 kB
Cached: 2120736 kB
SwapCached: 0 kB
Active: 928168 kB
Inactive: 1672308 kB
SwapTotal: 2096440 kB
SwapFree: 2096068 kB
Dirty: 252 kB
Writeback: 0 kB
AnonPages: 60704 kB
Mapped: 28840 kB
Slab: 648900 kB
SReclaimable: 526204 kB
SUnreclaim: 122696 kB
PageTables: 8124 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 4101796 kB
Committed_AS: 211944 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 292228 kB
VmallocChunk: 34359446071 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
[root at loser proc]# cat version
Linux version 2.6.26-0.44.rc4.git2.GAJTEST6.fc9.x86_64 (gjohnson at localhost)
(gcc version 4.3.0 20080428 (Red Hat 4.3.0-8) (GCC) ) #1 SMP Thu May 29
23:24:24 EDT 2008
[root at loser proc]#
But:
As far as CFLAGS , I've been trying to find a set of CFLAGS that worked....
If you have a set that work , I'll definitely put em' in
Anyway I'm running this test without an /etc/rpmrc or a ~/.rpmmacros
/usr/lib/rpm files are untouched as they should be
SSH from a laptop
login as: gjohnson
gjohnson at 192.168.1.105's password:
Last login: Sat May 31 20:26:49 2008 from 192.168.1.104
[gjohnson at loser ~]$ cat /etc/rpmrc
cat: /etc/rpmrc: No such file or directory
[gjohnson at loser ~]$ cat ~/.rpmmacros
%_topdir %(echo $HOME)/rpmbuild
%_smp_mflags -j3
%def_without test
#%__arch_install_post /usr/lib/rpm/check-rpaths
/usr/lib/rpm/check-buildroot
[gjohnson at loser src]$ cd /usr/local/src
[gjohnson at loser src]$ rpmbuild --rebuild mysql-5.0.51a-1.fc9.src.rpm
..........
sp-code [ skipped ] Test need debug binaries
sp-destruct [ pass ] 145
sp-dynamic [ pass ] 450
sp-error [ pass ] 1082
sp-prelocking [ pass ] 519
sp-security [ pass ] 635
sp-threads [ pass ] 2309
sp-ucs2 [ pass ] 54
sp-vars [ pass ] 503
sp [ pass ] 19989
sp_notembedded [ pass ] 2402
sp_stress_case [ pass ] 5040
sp_trans [ pass ] 2953
sp_trans_log [ pass ] 158
sql_mode [ pass ] 362
ssl-big [ skipped ] Test need 'big-test' option
ssl [ pass ] 11357
ssl_8k_key [ pass ] 125
ssl_compress [ pass ] 12037
ssl_connect [ pass ] 917
status [ pass ] 1155
strict [ pass ] 1526
strict_autoinc_1myisam [ pass ] 51
strict_autoinc_2innodb [ pass ] 80
strict_autoinc_3heap [ pass ] 43
strict_autoinc_4bdb [ pass ] 406
strict_autoinc_5ndb [ skipped ] No ndbcluster support
subselect [ pass ] 37059
subselect2 [ pass ] 921
subselect3 [ pass ] 1260
subselect_gis [ pass ] 45
subselect_innodb [ pass ] 1014
subselect_notembedded [ pass ] 4
sum_distinct-big [ skipped ] Test need 'big-test' option
sum_distinct [ pass ] 441
symlink [ pass ] 1046
synchronization [ pass ] 607
sysdate_is_now [ pass ] 1002
system_mysql_db [ pass ] 10
system_mysql_db_fix30020 [ pass ] 2880
system_mysql_db_fix40123 [ pass ] 2322
system_mysql_db_refs [ pass ] 260
tablelock [ pass ] 166
temp_table [ pass ] 378
timezone [ pass ] 75
timezone2 [ pass ] 244
timezone3 [ pass ] 75
timezone4 [ pass ] 3
timezone_grant [ pass ] 256
trigger-compat [ pass ] 365
trigger-grant [ pass ] 607
trigger-trans [ pass ] 391
trigger [ pass ] 7432
truncate [ pass ] 127
type_binary [ pass ] 358
type_bit [ pass ] 1215
type_bit_innodb [ pass ] 740
type_blob [ pass ] 1126
type_date [ pass ] 511
type_datetime [ pass ] 581
type_decimal [ pass ] 857
type_enum [ pass ] 997
type_float [ fail ]
--- /usr/local/rpmbuild/BUILD/mysql-5.0.51a/mysql-test/r/type_float.result
2008-01-11 18:23:41.000000000 +0300
+++
/usr/local/rpmbuild/BUILD/mysql-5.0.51a/mysql-test/var/log/type_float.reject2008-06-01
04:02:36.000000000 +0300
@@ -264,7 +264,7 @@
drop table t1,t2,t3;
select 1e-308, 1.00000001e-300, 100000000e-300;
1e-308 1.00000001e-300 100000000e-300
-1e-308 1.00000001e-300 1e-292
+0 1.00000001e-300 1e-292
select 10e307;
10e307
1e+308
mysqltest: Result content mismatch
Aborting: type_float failed in default mode.
To continue, re-run with '--force'.
Stopping All Servers
make: *** [test-ns] Error 1
error: Bad exit status from /var/tmp/rpm-tmp.45889 (%build)
RPM build errors:
user mockbuild does not exist - using root
group mockbuild does not exist - using root
......
So I've been playing with acovea with a number of CFLAGS and haven't found a
set that's safe and give good performance
Thanks again for the Help
Tony
--
View this message in context: http://www.nabble.com/mysql-type_float.reject-tp17575369p17581303.html
Sent from the Fedora Test List mailing list archive at Nabble.com.
More information about the fedora-test-list
mailing list