Re: mysql type_float.reject

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@loser src]$ cat /etc/fedora-release
Fedora release 9 (Sulphur)
[gjohnson@loser src]$


Thanks again
Tony

gjohnson5 wrote:
> 
> 
> Tom Lane-4 wrote:
>> 
>> gjohnson5 <tonyjohn5@xxxxxxxxx> writes:
>>> The compiler is gcc-4.3.0-8  which is the latest from Fedora
>>> [gjohnson@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@xxxxxxxxxx
>> 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@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@loser proc]$ cat kcore
> cat: kcore: Permission denied
> [gjohnson@loser proc]$ su
> Password:
> [root@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@loser proc]# cat version
> Linux version 2.6.26-0.44.rc4.git2.GAJTEST6.fc9.x86_64
> (gjohnson@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@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@xxxxxxxxxxxxx's password:
> Last login: Sat May 31 20:26:49 2008 from 192.168.1.104
> [gjohnson@loser ~]$ cat /etc/rpmrc
> cat: /etc/rpmrc: No such file or directory
> [gjohnson@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@loser src]$ cd /usr/local/src
> [gjohnson@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.

-- 
fedora-test-list mailing list
fedora-test-list@xxxxxxxxxx
To unsubscribe: 
https://www.redhat.com/mailman/listinfo/fedora-test-list

[Index of Archives]     [Fedora Desktop]     [Fedora SELinux]     [Photo Sharing]     [Yosemite Forum]     [KDE Users]

  Powered by Linux