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