> -----Original Message----- > From: Ivan Zhakov [mailto:i...@visualsvn.com] > Sent: woensdag 11 maart 2015 13:03 > To: Bert Huijben > Cc: dev@subversion.apache.org; phi...@apache.org > Subject: Re: svn commit: r1664523 - > /subversion/trunk/subversion/tests/cmdline/upgrade_tests.py > > On 11 March 2015 at 14:20, Bert Huijben <b...@qqmail.nl> wrote: > > > > > >> -----Original Message----- > >> From: Ivan Zhakov [mailto:i...@visualsvn.com] > >> Sent: woensdag 11 maart 2015 12:04 > >> To: dev@subversion.apache.org; phi...@apache.org; Bert Huijben > >> Subject: Re: svn commit: r1664523 - > >> /subversion/trunk/subversion/tests/cmdline/upgrade_tests.py > >> > >> On 6 March 2015 at 02:17, <phi...@apache.org> wrote: > >> > Author: philip > >> > Date: Thu Mar 5 23:17:26 2015 > >> > New Revision: 1664523 > >> > > >> > URL: http://svn.apache.org/r1664523 > >> > Log: > >> > * subversion/tests/cmdline/upgrade_tests.py > >> > (auto_analyze): Relocate without using the client. > >> > > >> > Modified: > >> > subversion/trunk/subversion/tests/cmdline/upgrade_tests.py > >> > > >> > Modified: subversion/trunk/subversion/tests/cmdline/upgrade_tests.py > >> > URL: > >> > http://svn.apache.org/viewvc/subversion/trunk/subversion/tests/cmdline/upgra > >> de_tests.py?rev=1664523&r1=1664522&r2=1664523&view=diff > >> > > >> > ================================================================ > >> ============== > >> > --- subversion/trunk/subversion/tests/cmdline/upgrade_tests.py (original) > >> > +++ subversion/trunk/subversion/tests/cmdline/upgrade_tests.py Thu Mar > 5 > >> 23:17:26 2015 > >> > @@ -1446,9 +1446,11 @@ def auto_analyze(sbox): > >> > replace_sbox_with_tarfile(sbox, 'wc-without-stat1.tar.bz2') > >> > svntest.main.run_svnadmin('setuuid', sbox.repo_dir, > >> > '52ec7e4b-e5f0-451d-829f-f05d5571b4ab') > >> > - svntest.actions.run_and_verify_svn(None, [], 'relocate', > >> > - 'file:///tmp/repos', sbox.repo_url, > >> > - sbox.wc_dir) > >> > + > >> > + # Don't use svn to do relocate as that will add the table. > >> > + val = svntest.wc.sqlite_stmt(sbox.wc_dir, > >> > + "update repository " > >> > + "set root ='" + sbox.repo_url + "'"); > >> > > >> The upgrade_tests.py#36 fails on Windows (sqlite 3.8.8.2), Python 2.6.7. > >> [[[ > >> Testing Debug configuration on local repository. > >> START: upgrade_tests.py > >> W: CWD: M:\svn\test_trunk\subversion\tests\cmdline > >> Traceback (most recent call last): > >> File "C:\Ivan\SVN\trunk\subversion\tests\cmdline\svntest\main.py", > >> line 1744, in run > >> rc = self.pred.run(sandbox) > >> File "C:\Ivan\SVN\trunk\subversion\tests\cmdline\svntest\testcase.py", > >> line 178, in run > >> result = self.func(sandbox) > >> File "C:\Ivan\SVN\trunk\subversion\tests\cmdline\upgrade_tests.py", > >> line 1453, in auto_analyze > >> "set root ='" + sbox.repo_url + "'"); > >> File "C:\Ivan\SVN\trunk\subversion\tests\cmdline\svntest\wc.py", > >> line 1044, in sqlite_exec > >> c.execute(stmt) > >> DatabaseError: malformed database schema > >> (nodes_update_checksum_trigger) - near "OLD": syntax error > >> FAIL: upgrade_tests.py 36: automatic SQLite ANALYZE > >> END: upgrade_tests.py > >> ELAPSED: upgrade_tests.py 0:00:00.758000 > >> ]]] > > > > This is caused by the Sqlite that is linked into your python version... > > (Unrelated to your separate sqlite version, which you quoted) > > > It's very likely that Python compiled to different version of sqlite. > But how it supposed to work? Is not sqlite compatible between > different versions? What is the minimum requirements? How packagers > should deal with such test failures?
My guess would be that you need Sqlite 3.6.18 (2009-09-11) or later. https://www.sqlite.org/changes.html#version_3_6_18 My Python on my primary test VM has Sqlite 3.6.21 builtin and has no problem running these tests. $ python ActivePython 2.7.2.5 (ActiveState Software Inc.) based on Python 2.7.2 (default, Jun 24 2011, 12:21:10) [MSC v.1500 32 bit (Intel)] on win 32 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3; >>> sqlite3.sqlite_version '3.6.21' Bert
