Started by user Simon Pruvost
Running as SYSTEM
Building in workspace /var/lib/jenkins/jobs/first/workspace
The recommended git tool is: NONE
using credential 8a11502e-f80d-4742-a451-704b40f19292
 > git rev-parse --resolve-git-dir /var/lib/jenkins/jobs/first/workspace/.git # timeout=10
Fetching changes from the remote Git repository
 > git config remote.origin.url https://framagit.org/pruvosim/store-prices-watchdog.git # timeout=10
Fetching upstream changes from https://framagit.org/pruvosim/store-prices-watchdog.git
 > git --version # timeout=10
 > git --version # 'git version 2.39.5'
using GIT_ASKPASS to set credentials 
 > git fetch --tags --force --progress -- https://framagit.org/pruvosim/store-prices-watchdog.git +refs/heads/*:refs/remotes/origin/* # timeout=10
 > git rev-parse refs/remotes/origin/dev^{commit} # timeout=10
Checking out Revision 1752591dbe76905b8037da967cbd867dd946263a (refs/remotes/origin/dev)
 > git config core.sparsecheckout # timeout=10
 > git checkout -f 1752591dbe76905b8037da967cbd867dd946263a # timeout=10
Commit message: "Scraper edit to avoid using HTTP requests"
 > git rev-list --no-walk 657fbed652a382b0b1ac29a8b550df7840d6fb85 # timeout=10
[workspace] $ /bin/sh -xe /tmp/jenkins14577908474060687229.sh
+ python -m venv my-venv
+ my-venv/bin/pip install -r config/requirements.txt
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)
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)
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)
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)
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)
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)
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)
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)
+ my-venv/bin/python Main.py
{"Accept": "application/json"}
Traceback (most recent call last):
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3322, in execute_sql
    cursor.execute(sql, params or ())
psycopg2.errors.UndefinedColumn: column t1.discount_end_date does not exist
LINE 1: SELECT "t1"."id", "t1"."fs_id", "t1"."url", "t1"."discount_e...
                                                    ^


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/var/lib/jenkins/jobs/first/workspace/Main.py", line 3, in <module>
    from GamesOperations import updateDatasFromQueries
  File "/var/lib/jenkins/jobs/first/workspace/GamesOperations.py", line 69, in <module>
    exportGamesInJson()
  File "/var/lib/jenkins/jobs/first/workspace/GamesOperations.py", line 63, in exportGamesInJson
    gamesToExport = list(GameDbObject.select().where(GameDbObject.price_regular > 0).dicts())
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 7285, in __iter__
    self.execute()
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2036, in inner
    return method(self, database, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2107, in execute
    return self._execute(database)
           ^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 2280, in _execute
    cursor = database.execute(self)
             ^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3330, in execute
    return self.execute_sql(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3320, in execute_sql
    with __exception_wrapper__:
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3088, in __exit__
    reraise(new_type, new_type(exc_value, *exc_args), traceback)
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 196, in reraise
    raise value.with_traceback(tb)
  File "/var/lib/jenkins/jobs/first/workspace/my-venv/lib/python3.11/site-packages/peewee.py", line 3322, in execute_sql
    cursor.execute(sql, params or ())
peewee.ProgrammingError: column t1.discount_end_date does not exist
LINE 1: SELECT "t1"."id", "t1"."fs_id", "t1"."url", "t1"."discount_e...
                                                    ^

Build step 'Execute shell' marked build as failure
Finished: FAILURE