Re: [pysqlite] Pysqlite 2.5.5 Regression Test failed

Melton Low <[email protected]> Wed, 20 May 2009 21:00:17 -0600
Newsgroups gmane.comp.python.db.pysqlite.user
Message-ID <[email protected]>
--===============2027175206==
Content-Type: multipart/alternative; boundary=001636ed6a1102fa62046a6358b5

--001636ed6a1102fa62046a6358b5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Gerhard,

Thanks for the workaround.  I will try it in the next few days.

Is it possible I am missing an environment variable to point to the locatio=
n
of the libraries?  Except for the OS versions and the Apple Developer
versions, my two machines are configured identically.

Thanks also to Roger.  I think his suggestion is a good one.  Gerhard maybe
you can consider adding it to your test suite.

Regards, Mel

On Wed, May 20, 2009 at 12:35 AM, Gerhard H=E4ring <[email protected]> wrote:

> Melton Low wrote:
> > Hi,
> >
> > I just installed Pysqlite 2.5.5 and the CheckOnConflictRollback test
> > failed.  I have attached the log of my build and install.  The error
> > message from my IDLE is as follows:
>
> OMG. This arises from time to time since years. And I thought we finally
> got rid of these problems ...
>
> > IDLE 2.6.2
> >>>> from pysqlite2 import test
> >>>> test.test()
> >
> .........................................................................=
...........................................................................=
............................................F..............
> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > FAIL: CheckOnConflictRollback (pysqlite2.test.regression.RegressionTest=
s)
>
> I don't know the real cause of the problem. But building statically
> should fix it:
>
> $ python setup.py build_static
>
> > [...] Any idea or suggestion as to what I have to do to clear this up?
> >
> > My environment is:
> > Mac OS X 10.5.7 Intel MacBook
> > Python 2.6.2
> > Sqlite 3.6.14.1
>
> I can't reproduce that here with a similar environment. MacOS on Intel
> is still 10.5.6 here (will update in a minute), Python 2.6.2 and SQLite
> 3.6.12 from Macports. And I don't get that problem.
>
> Anyway the issue you see here is nothing fatal, it's just that it's not
> the correct SQLite library that's loaded on runtime, but something
> different - most probably the Apple one.
>
> Here it does work as it should though.
>
> > ghaering@server-88~/src/gh/pysqlite/build/lib.macosx-10.5-i386-2.6$
> otool -L pysqlite2/_sqlite.so
> > pysqlite2/_sqlite.so:
> >       /opt/local/lib/libsqlite3.0.dylib (compatibility version 9.0.0,
> current version 9.6.0)
> >       /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current
> version 1.0.0)
> >       /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
> version 111.1.3)
>
> -- Gerhard
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>

--001636ed6a1102fa62046a6358b5
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Gerhard, <br><br>Thanks for the workaround.=A0 I will try it in the next=
 few days.<br><br>Is it possible I am missing an environment variable to po=
int to the location of the libraries?=A0 Except for the OS versions and the=
 Apple Developer versions, my two machines are configured identically.<br>
<br>Thanks also to Roger.=A0 I think his suggestion is a good one.=A0 Gerha=
rd maybe you can consider adding it to your test suite.<br><br>Regards, Mel=
<br><br><div class=3D"gmail_quote">On Wed, May 20, 2009 at 12:35 AM, Gerhar=
d H=E4ring <span dir=3D"ltr">&lt;<a href=3D"mailto:[email protected]">gh@ghaer=
ing.de</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class=3D"im"=
>Melton Low wrote:<br>
&gt; Hi,<br>
&gt;<br>
&gt; I just installed Pysqlite 2.5.5 and the CheckOnConflictRollback test<b=
r>
&gt; failed. =A0I have attached the log of my build and install. =A0The err=
or<br>
&gt; message from my IDLE is as follows:<br>
<br>
</div>OMG. This arises from time to time since years. And I thought we fina=
lly<br>
got rid of these problems ...<br>
<div class=3D"im"><br>
&gt; IDLE 2.6.2<br>
&gt;&gt;&gt;&gt; from pysqlite2 import test<br>
&gt;&gt;&gt;&gt; test.test()<br>
&gt; ......................................................................=
...........................................................................=
...............................................F..............<br>
&gt; =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br>
&gt; FAIL: CheckOnConflictRollback (pysqlite2.test.regression.RegressionTes=
ts)<br>
<br>
</div>I don&#39;t know the real cause of the problem. But building statical=
ly<br>
should fix it:<br>
<br>
$ python setup.py build_static<br>
<br>
&gt; [...] Any idea or suggestion as to what I have to do to clear this up?=
<br>
<div class=3D"im">&gt;<br>
&gt; My environment is:<br>
&gt; Mac OS X 10.5.7 Intel MacBook<br>
&gt; Python 2.6.2<br>
&gt; Sqlite 3.6.14.1<br>
<br>
</div>I can&#39;t reproduce that here with a similar environment. MacOS on =
Intel<br>
is still 10.5.6 here (will update in a minute), Python 2.6.2 and SQLite<br>
3.6.12 from Macports. And I don&#39;t get that problem.<br>
<br>
Anyway the issue you see here is nothing fatal, it&#39;s just that it&#39;s=
 not<br>
the correct SQLite library that&#39;s loaded on runtime, but something<br>
different - most probably the Apple one.<br>
<br>
Here it does work as it should though.<br>
<br>
&gt; ghaering@server-88~/src/gh/pysqlite/build/lib.macosx-10.5-i386-2.6$ ot=
ool -L pysqlite2/_sqlite.so<br>
&gt; pysqlite2/_sqlite.so:<br>
&gt; =A0 =A0 =A0 /opt/local/lib/libsqlite3.0.dylib (compatibility version 9=
.0.0, current version 9.6.0)<br>
&gt; =A0 =A0 =A0 /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, cu=
rrent version 1.0.0)<br>
&gt; =A0 =A0 =A0 /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, c=
urrent version 111.1.3)<br>
<br>
-- Gerhard<br>
_______________________________________________<br>
list-pysqlite mailing list<br>
<a href=3D"mailto:list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org">list-pysqlite=
@lists.itsystementwicklung.de</a><br>
<a href=3D"http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysq=
lite" target=3D"_blank">http://itsystementwicklung.de/cgi-bin/mailman/listi=
nfo/list-pysqlite</a><br>
</blockquote></div><br>

--001636ed6a1102fa62046a6358b5--

--===============2027175206==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
--===============2027175206==--