2010-11-10 00:53:19 |
SatPhil |
bug |
|
|
added bug |
2011-01-01 19:58:08 |
Jeff |
summary |
gnucash 2.3 with sqlite retrieves all numbers as zero |
libdbi / libdbd-sqlite3 returns incorrect values for several data types |
|
2011-01-01 20:02:22 |
Jeff |
libdbi-drivers (Ubuntu): status |
New |
Confirmed |
|
2011-01-04 11:48:27 |
Forest Bond |
bug |
|
|
added subscriber Forest Bond |
2011-01-04 14:36:24 |
David Eisner |
bug |
|
|
added subscriber David Eisner |
2011-01-06 00:34:15 |
Clint Byrum |
libdbi-drivers (Ubuntu): importance |
Undecided |
High |
|
2011-01-06 15:53:17 |
Brian Murray |
tags |
apport-bug i386 maverick |
apport-bug i386 maverick regression-release |
|
2011-01-06 15:53:45 |
Brian Murray |
nominated for series |
|
Ubuntu Maverick |
|
2011-01-06 15:53:45 |
Brian Murray |
bug task added |
|
libdbi-drivers (Ubuntu Maverick) |
|
2011-01-06 15:53:57 |
Brian Murray |
libdbi-drivers (Ubuntu Maverick): status |
New |
Confirmed |
|
2011-01-06 15:54:00 |
Brian Murray |
libdbi-drivers (Ubuntu Maverick): importance |
Undecided |
High |
|
2011-01-06 15:54:02 |
Brian Murray |
libdbi-drivers (Ubuntu Maverick): status |
Confirmed |
Triaged |
|
2011-01-06 15:55:04 |
Brian Murray |
bug watch added |
|
https://bugzilla.redhat.com/show_bug.cgi?id=629964 |
|
2011-01-06 15:55:04 |
Brian Murray |
bug task added |
|
libdbi-drivers (Fedora) |
|
2011-01-06 15:57:29 |
Brian Murray |
bug task added |
|
gnucash |
|
2011-01-06 15:57:52 |
Brian Murray |
bug watch added |
|
https://bugzilla.gnome.org/show_bug.cgi?id=611936 |
|
2011-01-06 15:57:52 |
Brian Murray |
gnucash: remote watch |
Red Hat Bugzilla #629964 |
GNOME Bug Tracker #611936 |
|
2011-01-06 18:35:29 |
Clint Byrum |
libdbi-drivers (Ubuntu): status |
Confirmed |
In Progress |
|
2011-01-06 18:35:31 |
Clint Byrum |
libdbi-drivers (Ubuntu): assignee |
|
Clint Byrum (clint-fewbar) |
|
2011-01-06 20:10:48 |
Clint Byrum |
affects |
libdbi-drivers (Ubuntu) |
libdbi (Ubuntu) |
|
2011-01-06 20:49:27 |
Launchpad Janitor |
branch linked |
|
lp:~clint-fewbar/ubuntu/natty/libdbi/no-fast-math |
|
2011-01-06 20:57:35 |
Clint Byrum |
bug watch added |
|
http://sourceforge.net/support/tracker.php?aid=3152613 |
|
2011-01-06 21:20:40 |
Clint Byrum |
bug watch added |
|
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=599127 |
|
2011-01-06 21:20:40 |
Clint Byrum |
bug task added |
|
libdbi (Debian) |
|
2011-01-10 05:59:19 |
Bug Watch Updater |
libdbi (Debian): status |
Unknown |
New |
|
2011-01-10 20:23:30 |
Bug Watch Updater |
gnucash: status |
Unknown |
Confirmed |
|
2011-01-10 20:23:30 |
Bug Watch Updater |
gnucash: importance |
Unknown |
High |
|
2011-02-01 13:44:28 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/libdbi |
|
2011-02-01 13:50:12 |
Launchpad Janitor |
libdbi (Ubuntu): status |
In Progress |
Fix Released |
|
2011-02-08 03:21:20 |
Bug Watch Updater |
gnucash: status |
Confirmed |
Fix Released |
|
2011-02-11 05:25:12 |
Clint Byrum |
description |
This is related to
- Gnome's bugzilla bug 611936 https://bugzilla.gnome.org/show_bug.cgi?id=611936
- https://bugzilla.redhat.com/show_bug.cgi?id=629964 in Fedora's bugtracker
It seems that the 8.3 version of libdbd-sqlite3 delivered with Ubuntu 10.10 i386 is complied with optimisation -ffast-math which causes all the numeric values in gnucash 2.3.15 (svn r19751) with SQLite backend to be retrieved as zero.
This problem only started after I upgraded from Ubuntu 10.04 to 10.10.
ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: libdbd-sqlite3 0.8.3-1-0ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
Architecture: i386
Date: Wed Nov 10 11:40:17 2010
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100427.1)
ProcEnviron:
LANG=en_AU.utf8
SHELL=/bin/bash
SourcePackage: libdbi-drivers |
This is related to
- Gnome's bugzilla bug 611936 https://bugzilla.gnome.org/show_bug.cgi?id=611936
- https://bugzilla.redhat.com/show_bug.cgi?id=629964 in Fedora's bugtracker
It seems that the 8.3 version of libdbd-sqlite3 delivered with Ubuntu 10.10 i386 is complied with optimisation -ffast-math which causes all the numeric values in gnucash 2.3.15 (svn r19751) with SQLite backend to be retrieved as zero.
This problem only started after I upgraded from Ubuntu 10.04 to 10.10.
ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: libdbd-sqlite3 0.8.3-1-0ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
Architecture: i386
Date: Wed Nov 10 11:40:17 2010
InstallationMedia: Ubuntu 10.04 LTS "Lucid Lynx" - Release i386 (20100427.1)
ProcEnviron:
LANG=en_AU.utf8
SHELL=/bin/bash
SourcePackage: libdbi-drivers
== SRU Information ==
=== IMPACT ===
This bug prevents any programs that use floating point numbers in a libdbi accessed database from functioning properly on i386. This includes GNUcash, a widely used piece of accounting software.
=== DEV FIX ===
This was fixed by turning off fast-math optimizations in libdbi.
=== PATCH ===
See linked merge proposal against maverick
=== TEST CASE: ===
This only affects the i386 architecture, and so much be run on an i386 machine/chroot/vm.
1. sudo apt-get install libdbd-sqlite3 -- note this should install libdbi0 as well
2. sudo apt-get build-dep libdbi-drivers
3. apt-get source libdbi-drivers
4. cd into libdbi-drivers-$version
5. run 'debian/rules build'
6. run 'make check'
7. Accept the default answer for libdbidriver directory of /usr/lib/dbd
8. type in 'sqlite3' to answer 'test which driver?'
9. Accept the default answer for database directory and database name
10. Tests will run with "SUCCESS", but the test for double floats will look like this:
the_double: in:1.7976931348623157E+307 out:0.000000e+00<<
11. Upgrade libdbi0 to the fixed package, then rerun steps 6 - 10, the test should now look like this:
the_double: in:1.7976931348623157E+307 out:1.797693e+307<<
=== REGRESSION POTENTIAL ===
This is a change only in compile flags, and so the only regression potential is that it will slow down all floating point operations in libdbi. Given that the alternative is the wrong answer, slower is actually better in this case. |
|
2011-02-11 05:27:28 |
Launchpad Janitor |
branch linked |
|
lp:~clint-fewbar/ubuntu/maverick/libdbi/no-fast-math |
|
2011-02-11 05:33:52 |
Clint Byrum |
libdbi (Ubuntu Maverick): assignee |
|
Clint Byrum (clint-fewbar) |
|
2011-02-11 05:33:58 |
Clint Byrum |
libdbi (Ubuntu Maverick): status |
Triaged |
In Progress |
|
2011-02-12 14:56:40 |
Benjamin Drung |
bug |
|
|
added subscriber Benjamin Drung |
2011-02-15 09:38:18 |
Martin Pitt |
libdbi (Ubuntu Maverick): status |
In Progress |
Fix Committed |
|
2011-02-15 09:38:23 |
Martin Pitt |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2011-02-15 09:38:26 |
Martin Pitt |
bug |
|
|
added subscriber SRU Verification |
2011-02-15 09:38:30 |
Martin Pitt |
tags |
apport-bug i386 maverick regression-release |
apport-bug i386 maverick regression-release verification-needed |
|
2011-02-15 10:29:29 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/maverick-proposed/libdbi |
|
2011-02-16 07:36:27 |
Martin Pitt |
tags |
apport-bug i386 maverick regression-release verification-needed |
apport-bug i386 maverick regression-release verification-done |
|
2011-02-23 20:36:03 |
Launchpad Janitor |
libdbi (Ubuntu Maverick): status |
Fix Committed |
Fix Released |
|
2011-08-11 12:02:24 |
Bug Watch Updater |
libdbi (Debian): status |
New |
Fix Released |
|
2011-09-19 21:38:44 |
Ubuntu Foundations Team Bug Bot |
tags |
apport-bug i386 maverick regression-release verification-done |
apport-bug i386 maverick regression-release testcase verification-done |
|
2017-10-27 17:30:44 |
Bug Watch Updater |
libdbi-drivers (Fedora): status |
Unknown |
Fix Released |
|
2017-10-27 17:30:44 |
Bug Watch Updater |
libdbi-drivers (Fedora): importance |
Unknown |
Medium |
|