Started by timer
Obtained Jenkinsfile from git https://github.com/DrPersico/postgresql.git
[Pipeline] Start of Pipeline
[Pipeline] node
Running on Jenkins in /var/jenkins_home/workspace/postgres-deploy
[Pipeline] {
[Pipeline] stage
[Pipeline] { (Declarative: Checkout SCM)
[Pipeline] checkout
Selected Git installation does not exist. Using Default
The recommended git tool is: NONE
using credential f048d47c-1ea1-4dc6-b81c-f1ec032f0d77
> git rev-parse --resolve-git-dir /var/jenkins_home/workspace/postgres-deploy/.git # timeout=10
Fetching changes from the remote Git repository
> git config remote.origin.url https://github.com/DrPersico/postgresql.git # timeout=10
Fetching upstream changes from https://github.com/DrPersico/postgresql.git
> git --version # timeout=10
> git --version # 'git version 2.47.3'
using GIT_ASKPASS to set credentials Github
> git fetch --tags --force --progress -- https://github.com/DrPersico/postgresql.git +refs/heads/*:refs/remotes/origin/* # timeout=10
> git rev-parse refs/remotes/origin/main^{commit} # timeout=10
Checking out Revision ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da (refs/remotes/origin/main)
> git config core.sparsecheckout # timeout=10
> git checkout -f ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da # timeout=10
Commit message: "Fix backup container restart loop - add command separators"
> git rev-list --no-walk ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da # timeout=10
[Pipeline] }
[Pipeline] // stage
[Pipeline] withEnv
[Pipeline] {
[Pipeline] withEnv
[Pipeline] {
[Pipeline] timeout
Timeout set to expire in 20 min
[Pipeline] {
[Pipeline] timestamps
[Pipeline] {
[Pipeline] stage
[Pipeline] { (Checkout)
[Pipeline] script
[Pipeline] {
[Pipeline] cleanWs
02:45:13 [2025-12-01T02:45:13.263Z] [WS-CLEANUP] Deleting project workspace...
02:45:13 [2025-12-01T02:45:13.263Z] [WS-CLEANUP] Deferred wipeout is used...
02:45:13 [2025-12-01T02:45:13.319Z] [WS-CLEANUP] done
[Pipeline] checkout
02:45:13 [2025-12-01T02:45:13.657Z] Selected Git installation does not exist. Using Default
02:45:13 [2025-12-01T02:45:13.660Z] The recommended git tool is: NONE
02:45:13 [2025-12-01T02:45:13.661Z] using credential f048d47c-1ea1-4dc6-b81c-f1ec032f0d77
02:45:13 [2025-12-01T02:45:13.683Z] Cloning the remote Git repository
02:45:13 [2025-12-01T02:45:13.684Z] Cloning repository https://github.com/DrPersico/postgresql.git
02:45:13 [2025-12-01T02:45:13.684Z] > git init /var/jenkins_home/workspace/postgres-deploy # timeout=10
02:45:13 [2025-12-01T02:45:13.722Z] Fetching upstream changes from https://github.com/DrPersico/postgresql.git
02:45:13 [2025-12-01T02:45:13.722Z] > git --version # timeout=10
02:45:13 [2025-12-01T02:45:13.740Z] > git --version # 'git version 2.47.3'
02:45:13 [2025-12-01T02:45:13.740Z] using GIT_ASKPASS to set credentials Github
02:45:13 [2025-12-01T02:45:13.781Z] > git fetch --tags --force --progress -- https://github.com/DrPersico/postgresql.git +refs/heads/*:refs/remotes/origin/* # timeout=10
02:45:14 [2025-12-01T02:45:14.986Z] > git config remote.origin.url https://github.com/DrPersico/postgresql.git # timeout=10
02:45:14 [2025-12-01T02:45:14.997Z] > git config --add remote.origin.fetch +refs/heads/*:refs/remotes/origin/* # timeout=10
02:45:15 [2025-12-01T02:45:15.016Z] Avoid second fetch
02:45:15 [2025-12-01T02:45:15.016Z] > git rev-parse refs/remotes/origin/main^{commit} # timeout=10
02:45:15 [2025-12-01T02:45:15.031Z] Checking out Revision ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da (refs/remotes/origin/main)
02:45:15 [2025-12-01T02:45:15.031Z] > git config core.sparsecheckout # timeout=10
02:45:15 [2025-12-01T02:45:15.044Z] > git checkout -f ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da # timeout=10
02:45:15 [2025-12-01T02:45:15.068Z] Commit message: "Fix backup container restart loop - add command separators"
[Pipeline] echo
02:45:15 [2025-12-01T02:45:15.226Z] โ
Code checked out successfully
[Pipeline] pwd
[Pipeline] echo
02:45:15 [2025-12-01T02:45:15.323Z] ๐ Working directory: /var/jenkins_home/workspace/postgres-deploy
[Pipeline] echo
02:45:15 [2025-12-01T02:45:15.422Z] ๐ฟ Git branch: null
[Pipeline] echo
02:45:15 [2025-12-01T02:45:15.482Z] ๐ท๏ธ Git commit: ade1f21be3ea31e81a6f387d5d2dfb8a955ff3da
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Validate Configuration)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:45:16 [2025-12-01T02:45:16.578Z] ๐ Validating configuration files...
[Pipeline] fileExists
[Pipeline] echo
02:45:16 [2025-12-01T02:45:16.814Z] โ
Found: docker-compose.yml
[Pipeline] fileExists
[Pipeline] echo
02:45:17 [2025-12-01T02:45:17.044Z] โ
Found: postgresql/conf/postgresql.conf
[Pipeline] fileExists
[Pipeline] echo
02:45:17 [2025-12-01T02:45:17.300Z] โ
Found: postgresql/conf/pg_hba.conf
[Pipeline] fileExists
[Pipeline] echo
02:45:17 [2025-12-01T02:45:17.498Z] โ
Found: postgresql/init/01-init-database.sh
[Pipeline] fileExists
[Pipeline] echo
02:45:17 [2025-12-01T02:45:17.698Z] โ
Found: .env.example
[Pipeline] sh
02:45:18 [2025-12-01T02:45:18.031Z] + echo ๐ณ Validating Docker Compose files...
02:45:18 [2025-12-01T02:45:18.031Z] ๐ณ Validating Docker Compose files...
02:45:18 [2025-12-01T02:45:18.031Z] + docker-compose -f docker-compose.yml config --quiet
02:45:18 [2025-12-01T02:45:18.031Z] time="2025-12-01T02:45:17Z" level=warning msg="The \"POSTGRES_PASSWORD\" variable is not set. Defaulting to a blank string."
02:45:18 [2025-12-01T02:45:18.031Z] time="2025-12-01T02:45:17Z" level=warning msg="The \"POSTGRES_PASSWORD\" variable is not set. Defaulting to a blank string."
[Pipeline] sh
02:45:18 [2025-12-01T02:45:18.617Z] + echo ๐๏ธ Validating PostgreSQL configuration...
02:45:18 [2025-12-01T02:45:18.617Z] ๐๏ธ Validating PostgreSQL configuration...
02:45:18 [2025-12-01T02:45:18.617Z] + grep -E ^(shared_buffers|effective_cache_size|work_mem) postgresql/conf/postgresql.conf
02:45:18 [2025-12-01T02:45:18.617Z] shared_buffers = 512MB # 25% of RAM
02:45:18 [2025-12-01T02:45:18.617Z] effective_cache_size = 2GB # 50% of RAM
02:45:18 [2025-12-01T02:45:18.617Z] work_mem = 8MB # Per connection
[Pipeline] sh
02:45:21 [2025-12-01T02:45:21.019Z] + echo ๐ Checking Jenkins credentials configuration...
02:45:21 [2025-12-01T02:45:21.019Z] ๐ Checking Jenkins credentials configuration...
02:45:21 [2025-12-01T02:45:21.019Z] + echo โน๏ธ Note: Make sure you have configured these Jenkins credentials:
02:45:21 [2025-12-01T02:45:21.019Z] โน๏ธ Note: Make sure you have configured these Jenkins credentials:
02:45:21 [2025-12-01T02:45:21.019Z] + echo - postgres-password (Secret Text): Your PostgreSQL password
02:45:21 [2025-12-01T02:45:21.019Z] - postgres-password (Secret Text): Your PostgreSQL password
02:45:21 [2025-12-01T02:45:21.019Z] + echo - postgres-db (String, optional): Database name (default: postgres)
02:45:21 [2025-12-01T02:45:21.019Z] - postgres-db (String, optional): Database name (default: postgres)
02:45:21 [2025-12-01T02:45:21.019Z] + echo - postgres-user (String, optional): Database user (default: postgres)
02:45:21 [2025-12-01T02:45:21.019Z] - postgres-user (String, optional): Database user (default: postgres)
02:45:21 [2025-12-01T02:45:21.019Z] + echo ๐ Configure in: Jenkins โ Manage Jenkins โ Manage Credentials โ (global)
02:45:21 [2025-12-01T02:45:21.019Z] ๐ Configure in: Jenkins โ Manage Jenkins โ Manage Credentials โ (global)
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (System Health Check)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:45:21 [2025-12-01T02:45:21.800Z] ๐ Checking system resources...
[Pipeline] sh
02:45:22 [2025-12-01T02:45:22.121Z] + docker info
02:45:22 [2025-12-01T02:45:22.372Z] + echo โ
Docker is running
02:45:22 [2025-12-01T02:45:22.372Z] โ
Docker is running
02:45:22 [2025-12-01T02:45:22.372Z] + echo ๐พ Memory information:
02:45:22 [2025-12-01T02:45:22.372Z] ๐พ Memory information:
02:45:22 [2025-12-01T02:45:22.372Z] + free -h
02:45:22 [2025-12-01T02:45:22.372Z] total used free shared buff/cache available
02:45:22 [2025-12-01T02:45:22.372Z] Mem: 7.6Gi 3.5Gi 597Mi 198Mi 4.0Gi 4.1Gi
02:45:22 [2025-12-01T02:45:22.372Z] Swap: 0B 0B 0B
02:45:22 [2025-12-01T02:45:22.372Z] + echo ๐ฟ Disk space:
02:45:22 [2025-12-01T02:45:22.372Z] ๐ฟ Disk space:
02:45:22 [2025-12-01T02:45:22.372Z] + df -h .
02:45:22 [2025-12-01T02:45:22.372Z] Filesystem Size Used Avail Use% Mounted on
02:45:22 [2025-12-01T02:45:22.372Z] /dev/mmcblk0p2 29G 27G 1.3G 96% /var/jenkins_home
02:45:22 [2025-12-01T02:45:22.372Z] + echo ๐ฅ๏ธ CPU information:
02:45:22 [2025-12-01T02:45:22.372Z] ๐ฅ๏ธ CPU information:
02:45:22 [2025-12-01T02:45:22.372Z] + nproc
02:45:22 [2025-12-01T02:45:22.372Z] 4
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Deploy PostgreSQL)
[Pipeline] echo
02:45:23 [2025-12-01T02:45:23.352Z] Warning, empty changelog. Have you run checkout?
[Pipeline] echo
02:45:23 [2025-12-01T02:45:23.445Z] Warning, empty changelog. Have you run checkout?
[Pipeline] echo
02:45:23 [2025-12-01T02:45:23.530Z] Warning, empty changelog. Have you run checkout?
[Pipeline] echo
02:45:23 [2025-12-01T02:45:23.638Z] Warning, empty changelog. Have you run checkout?
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:45:24 [2025-12-01T02:45:24.066Z] ๐ Deploying PostgreSQL...
[Pipeline] sh
02:45:24 [2025-12-01T02:45:24.450Z] + chmod +x postgresql/scripts/backup.sh postgresql/scripts/backup_check.sh postgresql/scripts/deploy.sh
[Pipeline] withCredentials
02:45:24 [2025-12-01T02:45:24.621Z] Masking supported pattern matches of $POSTGRES_PASSWORD or $POSTGRES_DB or $POSTGRES_USER
[Pipeline] {
[Pipeline] sh
02:45:25 [2025-12-01T02:45:25.014Z] + echo ๐ง Using Jenkins credentials for deployment...
02:45:25 [2025-12-01T02:45:25.015Z] ๐ง Using Jenkins credentials for deployment...
02:45:25 [2025-12-01T02:45:25.015Z] + export POSTGRES_DB=****
02:45:25 [2025-12-01T02:45:25.015Z] + export POSTGRES_USER=****
02:45:25 [2025-12-01T02:45:25.015Z] + export POSTGRES_PASSWORD=****
02:45:25 [2025-12-01T02:45:25.015Z] + export PROJECT_NAME=Generic PostgreSQL
02:45:25 [2025-12-01T02:45:25.015Z] + export PROJECT_SCHEMA=none
02:45:25 [2025-12-01T02:45:25.015Z] + export JENKINS_WORKSPACE=/home/geeplo/services/jenkins_home/workspace/****-deploy/****ql
02:45:25 [2025-12-01T02:45:25.015Z] + echo ๐ Deployment configuration:
02:45:25 [2025-12-01T02:45:25.015Z] ๐ Deployment configuration:
02:45:25 [2025-12-01T02:45:25.015Z] + echo Database: ****
02:45:25 [2025-12-01T02:45:25.015Z] Database: ****
02:45:25 [2025-12-01T02:45:25.015Z] + echo User: ****
02:45:25 [2025-12-01T02:45:25.015Z] User: ****
02:45:25 [2025-12-01T02:45:25.015Z] + echo Project: Generic PostgreSQL
02:45:25 [2025-12-01T02:45:25.016Z] Project: Generic PostgreSQL
02:45:25 [2025-12-01T02:45:25.016Z] + echo Schema: none
02:45:25 [2025-12-01T02:45:25.016Z] Schema: none
02:45:25 [2025-12-01T02:45:25.016Z] + echo Workspace: /home/geeplo/services/jenkins_home/workspace/****-deploy/****ql
02:45:25 [2025-12-01T02:45:25.016Z] Workspace: /home/geeplo/services/jenkins_home/workspace/****-deploy/****ql
02:45:25 [2025-12-01T02:45:25.016Z] + echo Password: [REDACTED]
02:45:25 [2025-12-01T02:45:25.016Z] Password: [REDACTED]
02:45:25 [2025-12-01T02:45:25.016Z] + docker-compose -f docker-compose.yml down
02:45:25 [2025-12-01T02:45:25.016Z] Container datashield-backup Stopping
02:45:37 [2025-12-01T02:45:37.120Z] Container datashield-backup Stopped
02:45:37 [2025-12-01T02:45:37.121Z] Container datashield-backup Removing
02:45:37 [2025-12-01T02:45:37.121Z] Container datashield-backup Removed
02:45:37 [2025-12-01T02:45:37.121Z] Container ****-**** Stopping
02:45:39 [2025-12-01T02:45:39.609Z] Container ****-**** Stopped
02:45:39 [2025-12-01T02:45:39.609Z] Container ****-**** Removing
02:45:39 [2025-12-01T02:45:39.610Z] Container ****-**** Removed
02:45:39 [2025-12-01T02:45:39.610Z] Network ****-deploy_datashield-network Removing
02:45:39 [2025-12-01T02:45:39.610Z] Network ****-deploy_datashield-network Resource is still in use
02:45:39 [2025-12-01T02:45:39.610Z] + sed s/\${POSTGRES_DB}/****/g docker-compose.yml
02:45:39 [2025-12-01T02:45:39.610Z] + sed -i s/\${POSTGRES_USER}/****/g docker-compose.tmp.yml
02:45:39 [2025-12-01T02:45:39.610Z] + sed -i s/\${POSTGRES_PASSWORD}/****/g docker-compose.tmp.yml
02:45:39 [2025-12-01T02:45:39.610Z] + sed -i s/\${PROJECT_NAME}/Generic PostgreSQL/g docker-compose.tmp.yml
02:45:39 [2025-12-01T02:45:39.611Z] + sed -i s/\${PROJECT_SCHEMA}/none/g docker-compose.tmp.yml
02:45:39 [2025-12-01T02:45:39.611Z] + sed -i s|\${JENKINS_WORKSPACE:-./****ql}|/home/geeplo/services/jenkins_home/workspace/****-deploy/****ql|g docker-compose.tmp.yml
02:45:39 [2025-12-01T02:45:39.611Z] + docker-compose -f docker-compose.tmp.yml up -d ****
02:45:39 [2025-12-01T02:45:39.863Z] Container ****-**** Creating
02:45:46 [2025-12-01T02:45:46.352Z] **** Your kernel does not support memory limit capabilities or the cgroup is not mounted. Limitation discarded.
02:45:46 [2025-12-01T02:45:46.352Z] **** Your kernel does not support memory soft limit capabilities or the cgroup is not mounted. Limitation discarded.
02:45:46 [2025-12-01T02:45:46.352Z] Container ****-**** Created
02:45:46 [2025-12-01T02:45:46.353Z] Container ****-**** Starting
02:45:46 [2025-12-01T02:45:46.353Z] Container ****-**** Started
02:45:46 [2025-12-01T02:45:46.353Z] + echo โณ Waiting for PostgreSQL to be ready...
02:45:46 [2025-12-01T02:45:46.353Z] โณ Waiting for PostgreSQL to be ready...
02:45:46 [2025-12-01T02:45:46.353Z] + docker exec ****-**** pg_isready -U **** -d ****
02:45:46 [2025-12-01T02:45:46.353Z] + echo โณ Waiting for PostgreSQL (attempt {1..60}/60)...
02:45:46 [2025-12-01T02:45:46.353Z] โณ Waiting for PostgreSQL (attempt {1..60}/60)...
02:45:46 [2025-12-01T02:45:46.353Z] + sleep 2
02:45:48 [2025-12-01T02:45:48.219Z] + docker exec ****-**** pg_isready -U **** -d ****
02:45:48 [2025-12-01T02:45:48.472Z] /var/run/****ql:5432 - accepting connections
02:45:48 [2025-12-01T02:45:48.724Z] + docker-compose -f docker-compose.tmp.yml up -d ****-backup
02:45:48 [2025-12-01T02:45:48.724Z] Container ****-**** Running
02:45:48 [2025-12-01T02:45:48.724Z] Container datashield-backup Creating
02:45:55 [2025-12-01T02:45:55.831Z] Container datashield-backup Created
02:45:55 [2025-12-01T02:45:55.831Z] Container ****-**** Waiting
02:45:55 [2025-12-01T02:45:55.831Z] Container ****-**** Healthy
02:45:55 [2025-12-01T02:45:55.831Z] Container datashield-backup Starting
02:45:56 [2025-12-01T02:45:56.090Z] Container datashield-backup Started
02:45:56 [2025-12-01T02:45:56.090Z] + rm docker-compose.tmp.yml
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] echo
02:45:56 [2025-12-01T02:45:56.772Z] โ
PostgreSQL deployed successfully
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Verify Deployment)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:45:57 [2025-12-01T02:45:57.489Z] ๐ Verifying deployment...
[Pipeline] withCredentials
02:45:57 [2025-12-01T02:45:57.616Z] Masking supported pattern matches of $POSTGRES_PASSWORD or $POSTGRES_DB or $POSTGRES_USER
[Pipeline] {
[Pipeline] sh
02:45:58 [2025-12-01T02:45:58.045Z] + export POSTGRES_DB=****
02:45:58 [2025-12-01T02:45:58.046Z] + export POSTGRES_USER=****
02:45:58 [2025-12-01T02:45:58.046Z] + export PGPASSWORD=****
02:45:58 [2025-12-01T02:45:58.046Z] + echo ๐ณ Container status:
02:45:58 [2025-12-01T02:45:58.046Z] ๐ณ Container status:
02:45:58 [2025-12-01T02:45:58.046Z] + docker ps
02:45:58 [2025-12-01T02:45:58.046Z] + grep ****
02:45:58 [2025-12-01T02:45:58.046Z] bcfd6d031217 ****:18-alpine "docker-entrypoint.sโฆ" 9 seconds ago Up 2 seconds 5432/tcp datashield-backup
02:45:58 [2025-12-01T02:45:58.049Z] 11a88d31e57d ****:18-alpine "docker-entrypoint.sโฆ" 18 seconds ago Up 12 seconds (healthy) 0.0.0.0:5432->5432/tcp, [::]:5432->5432/tcp ****-****
02:45:58 [2025-12-01T02:45:58.049Z] + echo ๐ Testing database connection...
02:45:58 [2025-12-01T02:45:58.049Z] ๐ Testing database connection...
02:45:58 [2025-12-01T02:45:58.050Z] + docker exec -e PGPASSWORD=**** ****-**** psql -h localhost -U **** -d **** -c SELECT 1 as connection_test;
02:45:58 [2025-12-01T02:45:58.301Z] connection_test
02:45:58 [2025-12-01T02:45:58.301Z] -----------------
02:45:58 [2025-12-01T02:45:58.301Z] 1
02:45:58 [2025-12-01T02:45:58.301Z] (1 row)
02:45:58 [2025-12-01T02:45:58.301Z]
02:45:58 [2025-12-01T02:45:58.301Z] + echo ๐ Database statistics:
02:45:58 [2025-12-01T02:45:58.301Z] ๐ Database statistics:
02:45:58 [2025-12-01T02:45:58.302Z] + docker exec -e PGPASSWORD=**** ****-**** psql -h localhost -U **** -d **** -c
02:45:58 [2025-12-01T02:45:58.302Z] SELECT
02:45:58 [2025-12-01T02:45:58.302Z] 'total schemas' as check,
02:45:58 [2025-12-01T02:45:58.302Z] COUNT(*)::text as result
02:45:58 [2025-12-01T02:45:58.302Z] FROM information_schema.schemata
02:45:58 [2025-12-01T02:45:58.302Z] WHERE schema_name NOT IN ('information_schema', 'pg_catalog');
02:45:58 [2025-12-01T02:45:58.302Z]
02:45:58 [2025-12-01T02:45:58.553Z] check | result
02:45:58 [2025-12-01T02:45:58.553Z] ---------------+--------
02:45:58 [2025-12-01T02:45:58.553Z] total schemas | 2
02:45:58 [2025-12-01T02:45:58.553Z] (1 row)
02:45:58 [2025-12-01T02:45:58.553Z]
02:45:58 [2025-12-01T02:45:58.553Z] + echo ๐พ Testing backup system...
02:45:58 [2025-12-01T02:45:58.553Z] ๐พ Testing backup system...
02:45:58 [2025-12-01T02:45:58.554Z] + docker exec ****-backup /scripts/backup_check.sh
02:45:58 [2025-12-01T02:45:58.554Z] Error response from daemon: No such container: ****-backup
02:45:58 [2025-12-01T02:45:58.554Z] + echo โ ๏ธ Backup check not available (container might be starting)
02:45:58 [2025-12-01T02:45:58.554Z] โ ๏ธ Backup check not available (container might be starting)
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] echo
02:45:58 [2025-12-01T02:45:58.863Z] โ
Deployment verification completed
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Performance Test)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:45:59 [2025-12-01T02:45:59.595Z] โก Running performance tests...
[Pipeline] withCredentials
02:45:59 [2025-12-01T02:45:59.686Z] Masking supported pattern matches of $POSTGRES_PASSWORD or $POSTGRES_DB or $POSTGRES_USER
[Pipeline] {
[Pipeline] sh
02:46:00 [2025-12-01T02:46:00.173Z] + export POSTGRES_DB=****
02:46:00 [2025-12-01T02:46:00.173Z] + export POSTGRES_USER=****
02:46:00 [2025-12-01T02:46:00.173Z] + export PGPASSWORD=****
02:46:00 [2025-12-01T02:46:00.173Z] + echo ๐ Running basic performance queries...
02:46:00 [2025-12-01T02:46:00.173Z] ๐ Running basic performance queries...
02:46:00 [2025-12-01T02:46:00.173Z] + docker exec -e PGPASSWORD=**** ****-**** psql -h localhost -U **** -d **** -c
02:46:00 [2025-12-01T02:46:00.173Z] -- Test basic query performance
02:46:00 [2025-12-01T02:46:00.174Z] EXPLAIN ANALYZE SELECT 1 as test_query;
02:46:00 [2025-12-01T02:46:00.174Z]
02:46:00 [2025-12-01T02:46:00.174Z] -- Test system catalog performance
02:46:00 [2025-12-01T02:46:00.174Z] EXPLAIN ANALYZE SELECT COUNT(*) FROM information_schema.tables;
02:46:00 [2025-12-01T02:46:00.174Z]
02:46:00 [2025-12-01T02:46:00.174Z] -- Test connection info
02:46:00 [2025-12-01T02:46:00.174Z] SELECT database_name, process_count FROM (
02:46:00 [2025-12-01T02:46:00.174Z] SELECT datname as database_name, COUNT(*) as process_count
02:46:00 [2025-12-01T02:46:00.174Z] FROM pg_stat_activity
02:46:00 [2025-12-01T02:46:00.174Z] GROUP BY datname
02:46:00 [2025-12-01T02:46:00.174Z] ) as activity_stats;
02:46:00 [2025-12-01T02:46:00.174Z]
02:46:00 [2025-12-01T02:46:00.426Z] QUERY PLAN
02:46:00 [2025-12-01T02:46:00.426Z] ---------------------------------------------------------------------------------------
02:46:00 [2025-12-01T02:46:00.426Z] Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.005..0.009 rows=1.00 loops=1)
02:46:00 [2025-12-01T02:46:00.426Z] Planning:
02:46:00 [2025-12-01T02:46:00.426Z] Buffers: shared hit=3
02:46:00 [2025-12-01T02:46:00.426Z] Planning Time: 0.214 ms
02:46:00 [2025-12-01T02:46:00.426Z] Execution Time: 0.131 ms
02:46:00 [2025-12-01T02:46:00.426Z] (5 rows)
02:46:00 [2025-12-01T02:46:00.426Z]
02:46:00 [2025-12-01T02:46:00.426Z] QUERY PLAN
02:46:00 [2025-12-01T02:46:00.426Z] --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
02:46:00 [2025-12-01T02:46:00.427Z] Aggregate (cost=71.97..71.98 rows=1 width=8) (actual time=8.503..8.541 rows=1.00 loops=1)
02:46:00 [2025-12-01T02:46:00.427Z] Buffers: shared hit=28 read=12
02:46:00 [2025-12-01T02:46:00.427Z] -> Hash Left Join (cost=36.66..71.69 rows=112 width=0) (actual time=5.855..8.173 rows=215.00 loops=1)
02:46:00 [2025-12-01T02:46:00.427Z] Hash Cond: (c.reloftype = t.oid)
02:46:00 [2025-12-01T02:46:00.427Z] Buffers: shared hit=28 read=12
02:46:00 [2025-12-01T02:46:00.427Z] -> Hash Join (cost=1.09..34.58 rows=112 width=4) (actual time=0.491..2.109 rows=215.00 loops=1)
02:46:00 [2025-12-01T02:46:00.427Z] Hash Cond: (c.relnamespace = nc.oid)
02:46:00 [2025-12-01T02:46:00.427Z] Buffers: shared hit=22 read=1
02:46:00 [2025-12-01T02:46:00.427Z] -> Seq Scan on pg_class c (cost=0.00..32.67 rows=150 width=8) (actual time=0.080..0.936 rows=215.00 loops=1)
02:46:00 [2025-12-01T02:46:00.427Z] Filter: ((relkind = ANY ('{r,v,f,p}'::"char"[])) AND (pg_has_role(relowner, 'USAGE'::text) OR has_table_privilege(oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER'::text) OR has_any_column_privilege(oid, 'SELECT, INSERT, UPDATE, REFERENCES'::text)))
02:46:00 [2025-12-01T02:46:00.427Z] Rows Removed by Filter: 202
02:46:00 [2025-12-01T02:46:00.427Z] Buffers: shared hit=13 read=1
02:46:00 [2025-12-01T02:46:00.427Z] -> Hash (cost=1.05..1.05 rows=3 width=4) (actual time=0.337..0.343 rows=4.00 loops=1)
02:46:00 [2025-12-01T02:46:00.428Z] Buckets: 1024 Batches: 1 Memory Usage: 9kB
02:46:00 [2025-12-01T02:46:00.428Z] Buffers: shared hit=9
02:46:00 [2025-12-01T02:46:00.428Z] -> Seq Scan on pg_namespace nc (cost=0.00..1.05 rows=3 width=4) (actual time=0.126..0.297 rows=4.00 loops=1)
02:46:00 [2025-12-01T02:46:00.428Z] Filter: (NOT pg_is_other_temp_schema(oid))
02:46:00 [2025-12-01T02:46:00.428Z] Buffers: shared hit=9
02:46:00 [2025-12-01T02:46:00.428Z] -> Hash (cost=27.29..27.29 rows=662 width=4) (actual time=5.290..5.305 rows=639.00 loops=1)
02:46:00 [2025-12-01T02:46:00.428Z] Buckets: 1024 Batches: 1 Memory Usage: 31kB
02:46:00 [2025-12-01T02:46:00.428Z] Buffers: shared hit=6 read=11
02:46:00 [2025-12-01T02:46:00.428Z] -> Hash Join (cost=1.09..27.29 rows=662 width=4) (actual time=0.186..4.017 rows=639.00 loops=1)
02:46:00 [2025-12-01T02:46:00.428Z] Hash Cond: (t.typnamespace = nt.oid)
02:46:00 [2025-12-01T02:46:00.428Z] Buffers: shared hit=6 read=11
02:46:00 [2025-12-01T02:46:00.428Z] -> Seq Scan on pg_type t (cost=0.00..22.62 rows=662 width=8) (actual time=0.044..1.307 rows=639.00 loops=1)
02:46:00 [2025-12-01T02:46:00.428Z] Buffers: shared hit=5 read=11
02:46:00 [2025-12-01T02:46:00.428Z] -> Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.105..0.111 rows=4.00 loops=1)
02:46:00 [2025-12-01T02:46:00.429Z] Buckets: 1024 Batches: 1 Memory Usage: 9kB
02:46:00 [2025-12-01T02:46:00.429Z] Buffers: shared hit=1
02:46:00 [2025-12-01T02:46:00.429Z] -> Seq Scan on pg_namespace nt (cost=0.00..1.04 rows=4 width=4) (actual time=0.065..0.075 rows=4.00 loops=1)
02:46:00 [2025-12-01T02:46:00.429Z] Buffers: shared hit=1
02:46:00 [2025-12-01T02:46:00.429Z] Planning:
02:46:00 [2025-12-01T02:46:00.429Z] Buffers: shared hit=332 read=14
02:46:00 [2025-12-01T02:46:00.429Z] Planning Time: 10.595 ms
02:46:00 [2025-12-01T02:46:00.429Z] Execution Time: 9.749 ms
02:46:00 [2025-12-01T02:46:00.429Z] (35 rows)
02:46:00 [2025-12-01T02:46:00.429Z]
02:46:00 [2025-12-01T02:46:00.429Z] database_name | process_count
02:46:00 [2025-12-01T02:46:00.429Z] ---------------+---------------
02:46:00 [2025-12-01T02:46:00.429Z] | 8
02:46:00 [2025-12-01T02:46:00.429Z] **** | 1
02:46:00 [2025-12-01T02:46:00.429Z] authentik | 6
02:46:00 [2025-12-01T02:46:00.429Z] (3 rows)
02:46:00 [2025-12-01T02:46:00.429Z]
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] echo
02:46:00 [2025-12-01T02:46:00.693Z] โ
Performance tests completed
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Create Backup)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:46:01 [2025-12-01T02:46:01.472Z] ๐พ Creating deployment backup: jenkins_backup_20251201_024601.sql
[Pipeline] withCredentials
02:46:01 [2025-12-01T02:46:01.591Z] Masking supported pattern matches of $POSTGRES_PASSWORD or $POSTGRES_DB or $POSTGRES_USER
[Pipeline] {
[Pipeline] sh
02:46:01 [2025-12-01T02:46:01.708Z] Warning: A secret was passed to "sh" using Groovy String interpolation, which is insecure.
02:46:01 [2025-12-01T02:46:01.708Z] Affected argument(s) used the following variable(s): [POSTGRES_DB]
02:46:01 [2025-12-01T02:46:01.708Z] See https://jenkins.io/redirect/groovy-string-interpolation for details.
02:46:01 [2025-12-01T02:46:01.970Z] + export POSTGRES_DB=****
02:46:01 [2025-12-01T02:46:01.970Z] + export POSTGRES_USER=****
02:46:01 [2025-12-01T02:46:01.970Z] + export PGPASSWORD=****
02:46:01 [2025-12-01T02:46:01.970Z] + mkdir -p jenkins_backups
02:46:01 [2025-12-01T02:46:01.970Z] + docker exec -e PGPASSWORD=**** ****-**** pg_dump -h localhost -U **** -d **** --format=custom --compress=9 --file=/tmp/jenkins_backup_20251201_024601.sql
02:46:02 [2025-12-01T02:46:02.883Z] + docker cp ****-****:/tmp/jenkins_backup_20251201_024601.sql jenkins_backups/
02:46:02 [2025-12-01T02:46:02.883Z] + cd jenkins_backups
02:46:02 [2025-12-01T02:46:02.883Z] + sha256sum jenkins_backup_20251201_024601.sql
02:46:02 [2025-12-01T02:46:02.883Z] + echo โ
Backup created: jenkins_backup_20251201_024601.sql
02:46:02 [2025-12-01T02:46:02.883Z] โ
Backup created: jenkins_backup_20251201_024601.sql
02:46:02 [2025-12-01T02:46:02.883Z] + ls -lh jenkins_backup_20251201_024601.sql
02:46:02 [2025-12-01T02:46:02.883Z] -rw-r--r-- 1 root root 6.9K Dec 1 02:46 jenkins_backup_20251201_024601.sql
[Pipeline] }
[Pipeline] // withCredentials
[Pipeline] archiveArtifacts
02:46:03 [2025-12-01T02:46:03.156Z] Archiving artifacts
02:46:03 [2025-12-01T02:46:03.162Z] Recording fingerprints
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] stage
[Pipeline] { (Declarative: Post Actions)
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:46:05 [2025-12-01T02:46:05.001Z] ๐ Pipeline completed with status: SUCCESS
[Pipeline] echo
02:46:05 [2025-12-01T02:46:05.378Z]
02:46:05 [2025-12-01T02:46:05.378Z] ๐ฏ PostgreSQL Deployment Pipeline
02:46:05 [2025-12-01T02:46:05.378Z] ๐
Build: 37
02:46:05 [2025-12-01T02:46:05.378Z] ๐ฟ Branch: null
02:46:05 [2025-12-01T02:46:05.378Z] ๐ท๏ธ Commit: ade1f21b
02:46:05 [2025-12-01T02:46:05.378Z] โฑ๏ธ Duration: 1 min 4 sec and counting
02:46:05 [2025-12-01T02:46:05.378Z] โ
Status: SUCCESS
02:46:05 [2025-12-01T02:46:05.378Z]
[Pipeline] sh
02:46:05 [2025-12-01T02:46:05.678Z] + find jenkins_backups -name *.sql -type f
02:46:05 [2025-12-01T02:46:05.679Z] + sort -r
02:46:05 [2025-12-01T02:46:05.679Z] + + tailxargs -n rm +6 -f
02:46:05 [2025-12-01T02:46:05.679Z]
[Pipeline] }
[Pipeline] // script
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:46:06 [2025-12-01T02:46:06.061Z] ๐ PostgreSQL deployment successful!
[Pipeline] }
[Pipeline] // script
[Pipeline] script
[Pipeline] {
[Pipeline] echo
02:46:06 [2025-12-01T02:46:06.448Z] ๐งน Cleaning up workspace...
[Pipeline] sh
02:46:06 [2025-12-01T02:46:06.766Z] + rm -f *.tmp
[Pipeline] echo
02:46:06 [2025-12-01T02:46:06.876Z] โ
Keeping containers running for automated backups (main branch or production)
[Pipeline] }
[Pipeline] // script
[Pipeline] }
[Pipeline] // stage
[Pipeline] }
[Pipeline] // timestamps
[Pipeline] }
[Pipeline] // timeout
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // withEnv
[Pipeline] }
[Pipeline] // node
[Pipeline] End of Pipeline
Finished: SUCCESS
