12:28:23 Started by user Simon Pruvost
12:28:23 Running as SYSTEM
12:28:23 Building in workspace /var/lib/jenkins/jobs/first/workspace
12:28:23 The recommended git tool is: NONE
12:28:23 using credential 8a11502e-f80d-4742-a451-704b40f19292
12:28:23 > git rev-parse --resolve-git-dir /var/lib/jenkins/jobs/first/workspace/.git # timeout=10
12:28:23 Fetching changes from the remote Git repository
12:28:23 > git config remote.origin.url https://framagit.org/pruvosim/store-prices-watchdog.git # timeout=10
12:28:23 Fetching upstream changes from https://framagit.org/pruvosim/store-prices-watchdog.git
12:28:23 > git --version # timeout=10
12:28:23 > git --version # 'git version 2.39.5'
12:28:23 using GIT_ASKPASS to set credentials
12:28:23 > git fetch --tags --force --progress -- https://framagit.org/pruvosim/store-prices-watchdog.git +refs/heads/*:refs/remotes/origin/* # timeout=10
12:28:24 > git rev-parse refs/remotes/origin/dev^{commit} # timeout=10
12:28:24 Checking out Revision 1752591dbe76905b8037da967cbd867dd946263a (refs/remotes/origin/dev)
12:28:24 > git config core.sparsecheckout # timeout=10
12:28:24 > git checkout -f 1752591dbe76905b8037da967cbd867dd946263a # timeout=10
12:28:24 Commit message: "Scraper edit to avoid using HTTP requests"
12:28:24 > git rev-list --no-walk 657fbed652a382b0b1ac29a8b550df7840d6fb85 # timeout=10
12:28:24 [workspace] $ /bin/sh -xe /tmp/jenkins14577908474060687229.sh
12:28:24 + python -m venv my-venv
12:28:26 + my-venv/bin/pip install -r config/requirements.txt
12:28:26 Requirement already satisfied: peewee==3.17.9 in ./my-venv/lib/python3.11/site-packages (from -r config/requirements.txt (line 1)) (3.17.9)
12:28:26 Requirement already satisfied: requests==2.32.3 in ./my-venv/lib/python3.11/site-packages (from -r config/requirements.txt (line 2)) (2.32.3)
12:28:26 Requirement already satisfied: discord-webhook==1.4.1 in ./my-venv/lib/python3.11/site-packages (from -r config/requirements.txt (line 3)) (1.4.1)
12:28:26 Requirement already satisfied: psycopg2==2.9.10 in ./my-venv/lib/python3.11/site-packages (from -r config/requirements.txt (line 4)) (2.9.10)
12:28:26 Requirement already satisfied: charset-normalizer<4,>=2 in ./my-venv/lib/python3.11/site-packages (from requests==2.32.3->-r config/requirements.txt (line 2)) (3.4.1)
12:28:26 Requirement already satisfied: idna<4,>=2.5 in ./my-venv/lib/python3.11/site-packages (from requests==2.32.3->-r config/requirements.txt (line 2)) (3.10)
12:28:26 Requirement already satisfied: urllib3<3,>=1.21.1 in ./my-venv/lib/python3.11/site-packages (from requests==2.32.3->-r config/requirements.txt (line 2)) (2.4.0)
12:28:26 Requirement already satisfied: certifi>=2017.4.17 in ./my-venv/lib/python3.11/site-packages (from requests==2.32.3->-r config/requirements.txt (line 2)) (2025.1.31)
12:28:26 + my-venv/bin/python Main.py
12:28:26 {"Accept": "application/json"}
12:28:26 Traceback (most recent call last):
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3322, in execute_sql
12:28:26 cursor.execute(sql, params or ())
12:28:26 psycopg2.errors.UndefinedColumn: column t1.discount_end_date does not exist
12:28:26 LINE 1: SELECT "t1"."id", "t1"."fs_id", "t1"."url", "t1"."discount_e...
12:28:26 ^
12:28:26
12:28:26
12:28:26 During handling of the above exception, another exception occurred:
12:28:26
12:28:26 Traceback (most recent call last):
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/Main.py", line 3, in <module>
12:28:26 from GamesOperations import updateDatasFromQueries
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/GamesOperations.py", line 69, in <module>
12:28:26 exportGamesInJson()
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/GamesOperations.py", line 63, in exportGamesInJson
12:28:26 gamesToExport = list(GameDbObject.select().where(GameDbObject.price_regular > 0).dicts())
12:28:26 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 7285, in __iter__
12:28:26 self.execute()
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2036, in inner
12:28:26 return method(self, database, *args, **kwargs)
12:28:26 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2107, in execute
12:28:26 return self._execute(database)
12:28:26 ^^^^^^^^^^^^^^^^^^^^^^^
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2280, in _execute
12:28:26 cursor = database.execute(self)
12:28:26 ^^^^^^^^^^^^^^^^^^^^^^
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3330, in execute
12:28:26 return self.execute_sql(sql, params)
12:28:26 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3320, in execute_sql
12:28:26 with __exception_wrapper__:
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3088, in __exit__
12:28:26 reraise(new_type, new_type(exc_value, *exc_args), traceback)
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 196, in reraise
12:28:26 raise value.with_traceback(tb)
12:28:26 File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3322, in execute_sql
12:28:26 cursor.execute(sql, params or ())
12:28:26 peewee.ProgrammingError: column t1.discount_end_date does not exist
12:28:26 LINE 1: SELECT "t1"."id", "t1"."fs_id", "t1"."url", "t1"."discount_e...
12:28:26 ^
12:28:26
12:28:26 Build step 'Execute shell' marked build as failure
12:28:26 Finished: FAILURE
![[Jenkins]](/jenkins/static/06086531/images/svgs/logo.svg){kind=logo}
