[Bug 1208636] New: [Build 20230223] sqlite 3.41.0: openQA test fails in __sqlite3_run-tests_t
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 Bug ID: 1208636 Summary: [Build 20230223] sqlite 3.41.0: openQA test fails in __sqlite3_run-tests_t Classification: openSUSE Product: openSUSE Tumbleweed Version: Current Hardware: Other URL: https://openqa.opensuse.org/tests/3141458/modules/__sq lite3_run-tests_t/steps/1 OS: Other Status: NEW Severity: Normal Priority: P5 - None Component: Other Assignee: screening-team-bugs@suse.de Reporter: dimstar@opensuse.org QA Contact: qa-bugs@suse.de Found By: openQA Blocker: Yes ## Observation The test tries to run: sqlite3 --list --header /root/sqlite3/movies.db < /root/sqlite3/init-tables.sql init_tables.sql is the file as received from https://github.com/os-autoinst/os-autoinst-distri-opensuse/blob/master/data/... So essentially it does: CREATE TABLE directors (did integer primary key, name varchar(32)); CREATE TABLE movies (mid integer primary key, name varchar(64), year integer); --Rename tables here before adding FOREIGN KEYs. Older versions of sqlite3 --don't update the FKs when renaming tables ALTER TABLE movies RENAME TO movie; ALTER TABLE directors RENAME TO director; CREATE TABLE director_movie ( did integer, mid integer, FOREIGN KEY(did) REFERENCES director(did), FOREIGN KEY(mid) REFERENCES movie(mid) ); CREATE UNIQUE INDEX movie_dirx on director_movie(did,mid); INSERT INTO director (name) VALUES ("Jim Jarmusch"), ( "Tim Burton"); This test worked until sqlite 3.40, now with 3.41 it fails with: Parse error near line 17: no such column: Tim Burton T INTO director (name) VALUES ("Jim Jarmusch"), ( "Tim Burton"); error here ---^ openQA test in scenario opensuse-Tumbleweed-DVD-x86_64-extra_tests_webserver@64bit fails in [__sqlite3_run-tests_t](https://openqa.opensuse.org/tests/3141458/modules/__sqlite3_run-tests_t/step...) ## Test suite description ## Reproducible Fails since (at least) Build [20230223](https://openqa.opensuse.org/tests/3141458) (current job) ## Expected result Last good: [20230222](https://openqa.opensuse.org/tests/3139245) (or more recent) ## Further details Always latest result in this scenario: [latest](https://openqa.opensuse.org/tests/latest?arch=x86_64&distri=opensuse&flavor=DVD&machine=64bit&test=extra_tests_webserver&version=Tumbleweed) -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 Dominique Leuenberger <dimstar@opensuse.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Priority|P5 - None |P2 - High Assignee|screening-team-bugs@suse.de |max@suse.com -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c1 --- Comment #1 from Dominique Leuenberger <dimstar@opensuse.org> --- sqlite 3.41.0 also results in build failures of e.g. ibus-libpinyin, with similar errors: [ 69s] gawk -f ./english.awk ./wordlist | /usr/bin/sqlite3 english.db || \ [ 69s] ( rm -f english.db ; exit 1 ) [ 69s] Parse error near line 5: no such column: the [ 69s] INSERT INTO english (word, freq) VALUES ("the", 6.510891); [ 69s] error here ---^ [ 69s] Parse error near line 6: no such column: of [ 69s] INSERT INTO english (word, freq) VALUES ("of", 3.095330); [ 69s] error here ---^ [ 69s] Parse error near line 7: no such column: and [ 69s] INSERT INTO english (word, freq) VALUES ("and", 2.822903); [ 69s] error here ---^ I'm considering to revert sqlite to 3.40.x until this can be addressed -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 Dominique Leuenberger <dimstar@opensuse.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |amajer@suse.com, | |danilo.spinella@suse.com, | |kstreitova@suse.com, | |michal.hrusecky@opensuse.or | |g, mpluskal@suse.com -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c2 Andreas Stieger <Andreas.Stieger@gmx.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |CONFIRMED CC| |Andreas.Stieger@gmx.de Summary|[Build 20230223] sqlite |[Build 20230223] sqlite |3.41.0: openQA test fails |3.41.0: openQA test fails |in __sqlite3_run-tests_t |in __sqlite3_run-tests_t: | |Double-quoted String | |Literals --- Comment #2 from Andreas Stieger <Andreas.Stieger@gmx.de> --- https://sqlite.org/releaselog/3_41_0.html
6. Changes to the CLI: [...] f. The double-quoted string misfeature is now disabled by default for CLI builds. Legacy use cases can reenable the misfeature at run-time using the ".dbconfig dqs_dml on" and ".dbconfig dqs_ddl on" commands.
https://sqlite.org/quirks.html#dblquote I recommend that we update the test to that effect, and patch up build failures (because eventually upstream will have to do so). (-->weekend) -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c3 --- Comment #3 from Andreas Stieger <Andreas.Stieger@gmx.de> --- Building with...
-DSQLITE_DQS=3 \
restores previous behavior. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c5 --- Comment #5 from Andreas Stieger <Andreas.Stieger@gmx.de> --- Dominique is doing a revert in SR#1067527 So I think Reinhard you'll want to fix the openqa test, and get a list of package breaks and start patching/bugging them. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c7 --- Comment #7 from Dominique Leuenberger <dimstar@opensuse.org> --- (In reply to Andreas Stieger from comment #5)
Dominique is doing a revert in SR#1067527
So I think Reinhard you'll want to fix the openqa test, and get a list of package breaks and start patching/bugging them.
That was for consideration if we can't find a proper soltuon - if we can fix the tests, even better. currently, I'm running against some wall there though First diff needed on the openQA tests: https://github.com/DimStar77/os-autoinst-distri-opensuse/commit/62757a5c4a19... That makes the start pass (i.e create table) - but fails later in the test https://paste.opensuse.org/pastes/9bfed0b5c4e4 # Subtest: test_view # Command: 'echo "SELECT * FROM cinema ORDER BY year, name LIMIT 6;" | sqlite3 --list --header /home/dimstar/Documents/git-rw/os-autoinst-distri-opensuse/data/sqlite3/movies.db ' Parse error near line 1: no such column: + not ok 1 - select from cinema (view) # Failed test 'select from cinema (view)' # at run-tests.t line 65. # Structures begin differing at: # $got->[0] = Does not exist # $expected->[0] = 'name|year|directors' 1..1 # Looks like you failed 1 test of 1. not ok 3 - test_view -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c8 --- Comment #8 from Dominique Leuenberger <dimstar@opensuse.org> --- in case somebody wants to run that test locally: gh repo clone os-autoinst/os-autoinst-distri-opensuse cd os-autoinst-distri-opensuse/data/sqlite3 perl run_tests.t -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c9 --- Comment #9 from Dominique Leuenberger <dimstar@opensuse.org> --- https://github.com/DimStar77/os-autoinst-distri-opensuse/commit/aff01e5dad7d... with this it seems I get through the perl code. Will create a PR and let openQA test this directly. If anybody can throw an eye on it to confirm this looks sane, that'd be appreciated -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c10 --- Comment #10 from Adam Majer <amajer@suse.com> --- (In reply to Dominique Leuenberger from comment #9)
https://github.com/DimStar77/os-autoinst-distri-opensuse/commit/ aff01e5dad7da5c56b9e9cec00e7f920315cd606
with this it seems I get through the perl code.
It looks good. I don't see any errors in the changes. -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c11 --- Comment #11 from Dominique Leuenberger <dimstar@opensuse.org> --- (In reply to Dominique Leuenberger from comment #9)
https://github.com/DimStar77/os-autoinst-distri-opensuse/commit/ aff01e5dad7da5c56b9e9cec00e7f920315cd606
with this it seems I get through the perl code.
Will create a PR and let openQA test this directly. If anybody can throw an eye on it to confirm this looks sane, that'd be appreciated
https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/16465 Test run passed QA: https://openqa.opensuse.org/tests/3141813#step/sqlite3/13 -- You are receiving this mail because: You are on the CC list for the bug.
http://bugzilla.opensuse.org/show_bug.cgi?id=1208636 http://bugzilla.opensuse.org/show_bug.cgi?id=1208636#c12 Dominique Leuenberger <dimstar@opensuse.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #12 from Dominique Leuenberger <dimstar@opensuse.org> --- (In reply to Dominique Leuenberger from comment #11)
https://github.com/os-autoinst/os-autoinst-distri-opensuse/pull/16465
Has been merged - let's consider this issue resolved (technically it's a WORKSFORME - as there was no product bug but a QA issue) Thanks all involved to drive this ticket -- You are receiving this mail because: You are on the CC list for the bug.
participants (1)
-
bugzilla_noreply＠suse.com