mysql type_float.reject
gjohnson5
tonyjohn5 at yahoo.com
Sun Jun 1 01:24:05 UTC 2008
I forgot one piece of information this is Fedora 9 , but I've been using the
GIT kernels since I had the MTRR/PAT issue w 4GB of ram that I talked about
here
http://www.nabble.com/more-mtrr-pat-issues-x86_64-4gb-ram-to17543465.html#a17544234
PAT is an option in the devel kernels , so I've been using Rawhide kernels
[gjohnson at loser src]$ cat /etc/fedora-release
Fedora release 9 (Sulphur)
[gjohnson at loser src]$
Thanks again
Tony
gjohnson5 wrote:
>
>
> 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-tp17575369p17581363.html
Sent from the Fedora Test List mailing list archive at Nabble.com.
More information about the fedora-test-list
mailing list