[CentOS] Python/sqlite date time problems.

Will McDonald wmcdonald at gmail.com
Tue Oct 10 16:12:23 UTC 2006

On 10/10/06, Bryan Cardillo <dillo at pcbi.upenn.edu> wrote:
> On Tue, Oct 10, 2006 at 03:59:42PM +0100, Will McDonald wrote:
> > Bear with me, this is CentOS related. :)
>        [...]
> > As far as I can tell, python, sqlite and python-sqlite are all identical.
> >
> > Obviously there some date/time issues but I can't pinpoint exactly
> > what. Can anyone shed any light or prod me in the right direction? The
> > Whitebox systems *do* still have a smattering of Whitebox related
> > RPMs...
>        what about mx?  this rpm provides python modules which do
>        date/time type conversion (and more), yet you haven't listed
>        it above.  perhaps its installed on one machine, but not the
>        other?
>        on my centos 4 machine:
>        $ rpm -q mx
>        mx-2.0.5-3

Bingo! Cheers dude.

I was just trawling through strace output. On the functioning machine
(or at least, the one on which the code behaves as I expected) mx
isn't installed, on the others it is.

"Working" system:

[root at willspc python]# strace ./testcase.py 2>&1 | wc -l
[root at willspc python]# rpm -q mx
package mx is not installed

"Broken" system:

[root at devmon1 python]# strace ./testcase.py 2>&1 | wc -l
[root at devmon1 python]# rpm -q mx
[root at devmon1 python]#

And a lot of those divergences appeared to be mx related though I
hadn't put 2 & 2 together until now.

On another previously "broken" system, after the removal of mx and python-MySQL

[root at stella python]# rpm -e mx MySQL-python
[root at stella python]# ./testcase.py
[('2006-10-10',), ('2006-10-11',)]

I guess it's upstream but it might be useful if that package was named
python-mx, though it could equally be argued that I should've just

$ rpm -q --whatrequires python

Anyway, that lets me know what the differences are, and I can either
code to take it into account, or just require/remove mx as necessary.
Thanks Bryan.


More information about the CentOS mailing list