Python SQLite3 fails on Github Actions but not on local

Question

I'm setting up CI using Github Actions and SQLite3 it's failing to insert on Github Actions but not on a local machine.

The line that fails is:

conn.execute("INSERT INTO sessions VALUES (?, ?, FALSE, NULL, ?)", [new_auth_token, device_id, expire_date])

This line is executed a few times in diferent tests succesfully, but then it fails in the rest of the tests (Always the same tests fail) with the next error.

sqlite3.OperationalError: no such column: FALSE

I'm using python3.8 and I've tried it on my computer with a fresh install of python and clone of the repository, but it never fails locally, only on GithuActions.

Try using QueryBuilder.substitutions to generate booleans, that will probably fix it. — Yagiz Degirmenci
– Yagiz Degirmenci, Commented May 15, 2020 at 21:37
What does your workflow file look like? What does your test setup look like? — smac89
– smac89, Commented May 16, 2020 at 20:41

mcarans · Accepted Answer · 2021-03-04 02:50:56Z

2

What fixed the problem for me is in my YAML workflow, replacing

runs-on: ubuntu-latest

with

runs-on: ubuntu-20.04

ubuntu-latest uses Ubuntu 18.04 and the SQLite version seems to be old and have an issue.

answered Mar 4, 2021 at 2:50

mcarans

1,3529 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python SQLite3 fails on Github Actions but not on local

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related