+ set -e
+ set -o pipefail
++ dirname ./run.sh
+ cd .
+ echo 29974
+ echo '1.69.1 839260fab'
1.69.1 839260fab
+ date
Fri Jul 23 22:27:43 CEST 2021
+ uptime
22:27:43 up 299 days, 6:33, 0 users, load average: 4.09, 4.63, 4.74
+ ff=default
+ image=yegor256/rultor-image
+ rebase=false
+ head_branch=master
+ pull_title='Sakilla restore fix'
+ author=rocket-3
+ directory=
+ head=git@github.com:databasegit/dbgit.git
+ pull_id=16
+ fork=git@github.com:databasegit/dbgit.git
+ fork_branch=sakilla-restore-fix
+ tests='*IntegrationTest*#*CustomTypes*'
+ squash=false
+ vars=('--env=MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g' '--env=head=git@github.com:databasegit/dbgit.git' '--env=pull_id=16' '--env=fork=git@github.com:databasegit/dbgit.git' '--env=fork_branch=sakilla-restore-fix' '--env=tests=*IntegrationTest*#*CustomTypes*' '--env=head_branch=master' '--env=pull_title=Sakilla restore fix' '--env=author=rocket-3' '--env=scripts=( '\''export '\''\'\'''\''MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''head=git@github.com:databasegit/dbgit.git'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''pull_id=16'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''fork=git@github.com:databasegit/dbgit.git'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''fork_branch=sakilla-restore-fix'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''tests=*IntegrationTest*#*CustomTypes*'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''head_branch=master'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''pull_title=Sakilla restore fix'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''author=rocket-3'\''\'\'''\'''\'' '\'';'\'' '\''java -version --batch-mode'\'' '\'';'\'' '\''mvn -version --batch-mode'\'' '\'';'\'' '\''mvn clean install package appassembler:assemble -D skipTests --batch-mode --quiet'\'' '\'';'\'' '\''chmod u+r+x target/dbgit/bin/dbgit'\'' '\'';'\'' '\''mvn test -Dtest=${tests:-'\''\'\'''\''*selfTest,*DbGitIntegrationTestBasic*'\''\'\'''\''} --batch-mode'\'' '\'';'\'' )')
+ scripts=('export '\''MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'\''' ';' 'export '\''head=git@github.com:databasegit/dbgit.git'\''' ';' 'export '\''pull_id=16'\''' ';' 'export '\''fork=git@github.com:databasegit/dbgit.git'\''' ';' 'export '\''fork_branch=sakilla-restore-fix'\''' ';' 'export '\''tests=*IntegrationTest*#*CustomTypes*'\''' ';' 'export '\''head_branch=master'\''' ';' 'export '\''pull_title=Sakilla restore fix'\''' ';' 'export '\''author=rocket-3'\''' ';' 'java -version --batch-mode' ';' 'mvn -version --batch-mode' ';' 'mvn clean install package appassembler:assemble -D skipTests --batch-mode --quiet' ';' 'chmod u+r+x target/dbgit/bin/dbgit' ';' 'mvn test -Dtest=${tests:-'\''*selfTest,*DbGitIntegrationTestBasic*'\''} --batch-mode' ';')
+ container=databasegit_dbgit_16
+ as_root=false
+ mkdir -p /home/rultor/.ssh
+ echo -e 'Host github.com\n\tStrictHostKeyChecking no\n'
+ chmod 600 /home/rultor/.ssh/config
+ git clone git@github.com:databasegit/dbgit.git repo
Cloning into 'repo'...
+ cd repo
+ git config user.email me@rultor.com
+ git config user.name rultor
+ '[' -z 'export '\''MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'\''' ']'
+ cd ..
+ cat
+ '[' false = true ']'
+ cat
+ chmod a+x entry.sh
+ cat
+ echo 'export '\''MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'\''' ';' 'export '\''head=git@github.com:databasegit/dbgit.git'\''' ';' 'export '\''pull_id=16'\''' ';' 'export '\''fork=git@github.com:databasegit/dbgit.git'\''' ';' 'export '\''fork_branch=sakilla-restore-fix'\''' ';' 'export '\''tests=*IntegrationTest*#*CustomTypes*'\''' ';' 'export '\''head_branch=master'\''' ';' 'export '\''pull_title=Sakilla restore fix'\''' ';' 'export '\''author=rocket-3'\''' ';' 'java -version --batch-mode' ';' 'mvn -version --batch-mode' ';' 'mvn clean install package appassembler:assemble -D skipTests --batch-mode --quiet' ';' 'chmod u+r+x target/dbgit/bin/dbgit' ';' 'mvn test -Dtest=${tests:-'\''*selfTest,*DbGitIntegrationTestBasic*'\''} --batch-mode' ';'
+ rm -rf .gpg
+ cd repo
+ git remote add fork git@github.com:databasegit/dbgit.git
+ git remote update
Fetching origin
Fetching fork
From github.com:databasegit/dbgit
* [new branch] backup-fix -> fork/backup-fix
* [new branch] backup-test -> fork/backup-test
* [new branch] custom-types -> fork/custom-types
* [new branch] dependabot/maven/org.yaml-snakeyaml-1.26 -> fork/dependabot/maven/org.yaml-snakeyaml-1.26
* [new branch] dependency-aware -> fork/dependency-aware
* [new branch] fix-restore-tabledata -> fork/fix-restore-tabledata
* [new branch] master -> fork/master
* [new branch] mssql -> fork/mssql
* [new branch] rultor-setup -> fork/rultor-setup
* [new branch] rultor-support -> fork/rultor-support
* [new branch] sakilla-restore-fix -> fork/sakilla-restore-fix
* [new branch] task-4515 -> fork/task-4515
* [new branch] task-4646 -> fork/task-4646
+ args=
+ '[' default == default ']'
+ args=' --ff'
+ '[' default == no ']'
+ '[' default == only ']'
+ export BRANCH=__rultor
+ BRANCH=__rultor
++ git show-branch __rultor
++ wc -l
+ '[' 0 -gt 0 ']'
+ git checkout -B __rultor fork/sakilla-restore-fix
Switched to a new branch '__rultor'
Branch __rultor set up to track remote branch sakilla-restore-fix from fork.
+ git checkout -B master origin/master
Switched to and reset branch 'master'
Branch master set up to track remote branch master from origin.
Your branch is up-to-date with 'origin/master'.
+ '[' false == true ']'
+ '[' false == true ']'
+ git merge --ff __rultor
Updating 33e48a5..ae70f55
Fast-forward
pom.xml | 5 +
.../ru/fusionsoft/dbgit/adapters/DBAdapter.java | 14 -
.../ru/fusionsoft/dbgit/command/CmdRestore.java | 74 ++++-
.../java/ru/fusionsoft/dbgit/config/TryCount.java | 19 ++
.../fusionsoft/dbgit/config/TryDelaySeconds.java | 18 ++
.../fusionsoft/dbgit/core/GitMetaDataManager.java | 2 +-
.../ru/fusionsoft/dbgit/core/SleepSeconds.java | 15 +
.../fusionsoft/dbgit/data_table/BooleanData.java | 3 +-
.../ru/fusionsoft/dbgit/data_table/DateData.java | 5 +-
.../ru/fusionsoft/dbgit/data_table/ICellData.java | 4 +-
.../ru/fusionsoft/dbgit/data_table/LongData.java | 3 +-
.../fusionsoft/dbgit/data_table/MapFileData.java | 6 +-
.../ru/fusionsoft/dbgit/data_table/RowData.java | 26 +-
.../ru/fusionsoft/dbgit/dbobjects/DBTableData.java | 4 +-
.../ru/fusionsoft/dbgit/meta/DBGitMetaType.java | 20 +-
.../dbgit/meta/DbObjectNameInSqlPresence.java | 20 ++
.../ru/fusionsoft/dbgit/meta/MetaTableData.java | 59 ++--
.../dbgit/meta/SortedListMetaObject.java | 70 +++--
.../dbgit/postgres/DBAdapterPostgres.java | 197 ++++++++------
.../dbgit/postgres/DBRestoreDomainPostgres.java | 4 +-
.../dbgit/postgres/DBRestoreFunctionPostgres.java | 17 +-
.../dbgit/postgres/DBRestoreProcedurePostgres.java | 13 +-
.../dbgit/postgres/DBRestoreTableDataPostgres.java | 64 +++--
.../dbgit/postgres/DBRestoreTablePostgres.java | 74 ++++-
.../dbgit/postgres/DBRestoreTriggerPostgres.java | 7 +-
.../ru/fusionsoft/dbgit/postgres/LargeBlobPg.java | 4 +-
src/main/resources/lang/eng.yaml | 6 +
.../integration/DbGitIntegrationTestBasic.java | 56 ++--
.../ru/fusionsoft/dbgit/integration/SelfTest.java | 5 +-
.../args/specific/ArgsDbGitLinkPgAuto.java | 4 +-
.../args/specific/ArgsDbGitLinkPgRemote.java | 11 +-
.../chars/specific/UrlOfPgTestDatabaseV11.java | 9 +
.../chars/specific/UrlOfPgTestDatabaseV9.java | 9 +
.../specific/dbgit/CharsDbIgnoreWithTypes.java | 24 ++
.../chars/specific/test/ReportOfTestGroupRun.java | 2 +-
.../chars/specific/test/ReportOfTestRun.java | 2 +-
.../primitives/connection/ConnectionEnvelope.java | 302 +++++++++++++++++++++
.../connection/ConnectionFromDbGitRepo.java | 9 +
.../connection/ConnectionFromFileDbLink.java | 20 ++
.../primitives/files/AutoDeletingPath.java | 18 ++
.../primitives/files/AutoDeletingTempFilePath.java | 33 ---
.../integration/primitives/files/TempFilePath.java | 27 ++
.../patch/ConnectionPatchExecutingStatement.java | 38 +++
.../patch/PathPatchRunningProcessFrom.java | 7 +-
.../patch/PathPatchUsingConnectionFromDbLink.java | 19 ++
.../patch/specific/PathPatchDbGitLinkAndAdd.java | 21 ++
.../specific/PathPatchDbGitRestoreFromDbToDb.java | 31 +++
.../dbgit/scenarios/PathAfterDbGitLinkAndAdd.java | 18 +-
.../scenarios/PathAfterDbGitRestoreFromDbToDb.java | 61 +++++
.../dbgit/meta/DbObjectNameInSqlPresenceTest.java | 82 ++++++
50 files changed, 1247 insertions(+), 314 deletions(-)
create mode 100644 src/main/java/ru/fusionsoft/dbgit/config/TryCount.java
create mode 100644 src/main/java/ru/fusionsoft/dbgit/config/TryDelaySeconds.java
create mode 100644 src/main/java/ru/fusionsoft/dbgit/core/SleepSeconds.java
create mode 100644 src/main/java/ru/fusionsoft/dbgit/meta/DbObjectNameInSqlPresence.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/chars/specific/UrlOfPgTestDatabaseV11.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/chars/specific/UrlOfPgTestDatabaseV9.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/chars/specific/dbgit/CharsDbIgnoreWithTypes.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/connection/ConnectionEnvelope.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/connection/ConnectionFromDbGitRepo.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/connection/ConnectionFromFileDbLink.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/files/AutoDeletingPath.java
delete mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/files/AutoDeletingTempFilePath.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/files/TempFilePath.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/patch/ConnectionPatchExecutingStatement.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/patch/PathPatchUsingConnectionFromDbLink.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/patch/specific/PathPatchDbGitLinkAndAdd.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/patch/specific/PathPatchDbGitRestoreFromDbToDb.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/integration/primitives/path/specific/dbgit/scenarios/PathAfterDbGitRestoreFromDbToDb.java
create mode 100644 src/test/java/ru/fusionsoft/dbgit/meta/DbObjectNameInSqlPresenceTest.java
+ docker_when_possible
+ true
++ uptime
++ tail -n 1
++ sed 's/ /\n/g'
+ load=4.73
++ echo 4.73 '>' 30
++ bc
+ '[' 0 -eq 1 ']'
+ echo 'load average is 4.73, low enough to run a new Docker container'
load average is 4.73, low enough to run a new Docker container
+ break
+ cd ..
+ '[' -n '' ']'
+ use_image=yegor256/rultor-image
+ docker pull yegor256/rultor-image
Using default tag: latest
latest: Pulling from yegor256/rultor-image
Digest: sha256:ae457d2438aa9a4989fb3a85705ab72db31f399c2ef11af2e520b03c1ccd2fe0
Status: Image is up to date for yegor256/rultor-image:latest
+ docker ps --filter=status=exited
+ grep --quiet '\sdatabasegit_dbgit_16\s*$'
+ ls -al .
total 724
drwx--x--x 3 rultor rultor 4096 Jul 23 22:27 .
drwxrwxrwt 11 root root 684032 Jul 23 22:27 ..
-rw-rw-r-- 1 rultor rultor 444 Jul 23 22:27 end.sh
-rwxrwxr-x 1 rultor rultor 363 Jul 23 22:27 entry.sh
-rw-rw-r-- 1 rultor rultor 26 Jul 23 22:27 gitSecret.txt
-rw-rw-r-- 1 rultor rultor 34 Jul 23 22:27 pgSecret.txt
-rw-rw-r-- 1 rultor rultor 6 Jul 23 22:27 pid
drwxrwxr-x 5 rultor rultor 4096 Jul 23 22:27 repo
-rwxrwxr-x 1 rultor rultor 6476 Jul 23 22:27 run.sh
-rw-rw-r-- 1 rultor rultor 749 Jul 23 22:27 script.sh
-rw-rw-r-- 1 rultor rultor 11527 Jul 23 22:27 stdout
++ pwd
++ pwd
+ docker run -t --rm -v /tmp/rultor-g9TX:/main '--env=MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g' --env=head=git@github.com:databasegit/dbgit.git --env=pull_id=16 --env=fork=git@github.com:databasegit/dbgit.git --env=fork_branch=sakilla-restore-fix '--env=tests=*IntegrationTest*#*CustomTypes*' --env=head_branch=master '--env=pull_title=Sakilla restore fix' --env=author=rocket-3 '--env=scripts=( '\''export '\''\'\'''\''MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''head=git@github.com:databasegit/dbgit.git'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''pull_id=16'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''fork=git@github.com:databasegit/dbgit.git'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''fork_branch=sakilla-restore-fix'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''tests=*IntegrationTest*#*CustomTypes*'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''head_branch=master'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''pull_title=Sakilla restore fix'\''\'\'''\'''\'' '\'';'\'' '\''export '\''\'\'''\''author=rocket-3'\''\'\'''\'''\'' '\'';'\'' '\''java -version --batch-mode'\'' '\'';'\'' '\''mvn -version --batch-mode'\'' '\'';'\'' '\''mvn clean install package appassembler:assemble -D skipTests --batch-mode --quiet'\'' '\'';'\'' '\''chmod u+r+x target/dbgit/bin/dbgit'\'' '\'';'\'' '\''mvn test -Dtest=${tests:-'\''\'\'''\''*selfTest,*DbGitIntegrationTestBasic*'\''\'\'''\''} --batch-mode'\'' '\'';'\'' )' --hostname=docker --privileged --memory=6g --memory-swap=16g --oom-kill-disable --cidfile=/tmp/rultor-g9TX/cid -w=/main -v /var/run/docker.sock:/var/run/docker.sock --name=databasegit_dbgit_16 yegor256/rultor-image /main/entry.sh
+ set -e
+ set -o pipefail
+ shopt -s dotglob
+ useradd -m -G sudo r
+ usermod -s /bin/bash r
+ echo '%sudo ALL=(ALL) NOPASSWD:ALL'
+ cp -R /root/.bashrc /root/.cache /root/.config /root/.gem /root/.gnupg /root/.m2 /root/.profile /root/texmf /home/r
+ cp -R ./cid ./end.sh ./entry.sh ./gitSecret.txt ./pgSecret.txt ./pid ./repo ./run.sh ./script.sh ./stdout /home/r
+ rm -rf repo
+ chown -R r:r /home/r
+ chmod a+x /home/r/script.sh
+ su --login r --command /home/r/script.sh
+ set -e
+ set -o pipefail
+ shopt -s expand_aliases
+ alias 'sudo=sudo -i'
+ export HOME=/home/r
+ HOME=/home/r
+ cd /home/r/repo
+ export 'MAVEN_OPTS=-XX:MaxPermSize=256m -Xmx1g'
+ MAVEN_OPTS='-XX:MaxPermSize=256m -Xmx1g'
+ export head=git@github.com:databasegit/dbgit.git
+ head=git@github.com:databasegit/dbgit.git
+ export pull_id=16
+ pull_id=16
+ export fork=git@github.com:databasegit/dbgit.git
+ fork=git@github.com:databasegit/dbgit.git
+ export fork_branch=sakilla-restore-fix
+ fork_branch=sakilla-restore-fix
+ export 'tests=*IntegrationTest*#*CustomTypes*'
+ tests='*IntegrationTest*#*CustomTypes*'
+ export head_branch=master
+ head_branch=master
+ export 'pull_title=Sakilla restore fix'
+ pull_title='Sakilla restore fix'
+ export author=rocket-3
+ author=rocket-3
+ java -version --batch-mode
openjdk version "11.0.11" 2021-04-20
OpenJDK Runtime Environment (build 11.0.11+9-Ubuntu-0ubuntu2.20.04)
OpenJDK 64-Bit Server VM (build 11.0.11+9-Ubuntu-0ubuntu2.20.04, mixed mode, sharing)
+ mvn -version --batch-mode
OpenJDK 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0
1mApache Maven 3.6.3m
Maven home: /usr/share/maven
Java version: 11.0.11, vendor: Ubuntu, runtime: /usr/lib/jvm/java-11-openjdk-amd64
Default locale: en_US, platform encoding: UTF-8
OS name: "linux", version: "4.4.0-78-generic", arch: "amd64", family: "unix"
+ mvn clean install package appassembler:assemble -D skipTests --batch-mode --quiet
OpenJDK 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/usr/share/maven/lib/guice.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
+ chmod u+r+x target/dbgit/bin/dbgit
+ mvn test '-Dtest=*IntegrationTest*#*CustomTypes*' --batch-mode
OpenJDK 64-Bit Server VM warning: Ignoring option MaxPermSize; support was removed in 8.0
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.google.inject.internal.cglib.core.$ReflectUtils$1 (file:/usr/share/maven/lib/guice.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int,java.security.ProtectionDomain)
WARNING: Please consider reporting this to the maintainers of com.google.inject.internal.cglib.core.$ReflectUtils$1
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------< ru.fusionsoft:dbgit >-------------------------
[INFO] Building dbgit 0.3.1
[INFO] --------------------------------[ jar ]---------------------------------
[WARNING] The artifact org.apache.commons:commons-io:jar:1.3.2 has been relocated to commons-io:commons-io:jar:1.3.2
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ dbgit ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 1 resource
[INFO] Copying 4 resources to /home/r/repo/target/dbgit
[INFO] Copying 4 resources to /home/r/repo/target/dbgit/bin
[INFO] Copying 2 resources to /home/r/repo/target/dbgit/lang
[INFO] Copying 1 resource to /home/r/repo/target/dbgit/example
[INFO] Copying 1 resource to /home/r/repo/target/dbgit/
[INFO]
[INFO] --- maven-compiler-plugin:3.7.0:compile (default-compile) @ dbgit ---
[INFO] Nothing to compile - all classes are up to date
[INFO]
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ dbgit ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 0 resource
[INFO]
[INFO] --- maven-compiler-plugin:3.7.0:testCompile (default-testCompile) @ dbgit ---
[INFO] Nothing to compile - all classes are up to date
[INFO]
[INFO] --- maven-surefire-plugin:2.22.2:test (default-test) @ dbgit ---
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-junit-platform/2.22.2/surefire-junit-platform-2.22.2.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-junit-platform/2.22.2/surefire-junit-platform-2.22.2.pom (7.0 kB at 21 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-providers/2.22.2/surefire-providers-2.22.2.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-providers/2.22.2/surefire-providers-2.22.2.pom (2.5 kB at 100 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-launcher/1.3.1/junit-platform-launcher-1.3.1.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-launcher/1.3.1/junit-platform-launcher-1.3.1.pom (2.2 kB at 85 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/apiguardian/apiguardian-api/1.0.0/apiguardian-api-1.0.0.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/apiguardian/apiguardian-api/1.0.0/apiguardian-api-1.0.0.pom (1.2 kB at 53 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-engine/1.3.1/junit-platform-engine-1.3.1.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-engine/1.3.1/junit-platform-engine-1.3.1.pom (2.4 kB at 104 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-commons/1.3.1/junit-platform-commons-1.3.1.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-commons/1.3.1/junit-platform-commons-1.3.1.pom (2.0 kB at 88 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/opentest4j/opentest4j/1.1.1/opentest4j-1.1.1.pom
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/opentest4j/opentest4j/1.1.1/opentest4j-1.1.1.pom (1.7 kB at 73 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-junit-platform/2.22.2/surefire-junit-platform-2.22.2.jar
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-engine/1.3.1/junit-platform-engine-1.3.1.jar
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/apiguardian/apiguardian-api/1.0.0/apiguardian-api-1.0.0.jar
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-launcher/1.3.1/junit-platform-launcher-1.3.1.jar
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-commons/1.3.1/junit-platform-commons-1.3.1.jar
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-commons/1.3.1/junit-platform-commons-1.3.1.jar (78 kB at 986 kB/s)
[INFO] Downloading from Maven: https://repo.maven.apache.org/maven2/org/opentest4j/opentest4j/1.1.1/opentest4j-1.1.1.jar
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/apiguardian/apiguardian-api/1.0.0/apiguardian-api-1.0.0.jar (2.2 kB at 17 kB/s)
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/opentest4j/opentest4j/1.1.1/opentest4j-1.1.1.jar (7.1 kB at 170 kB/s)
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-engine/1.3.1/junit-platform-engine-1.3.1.jar (135 kB at 877 kB/s)
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/apache/maven/surefire/surefire-junit-platform/2.22.2/surefire-junit-platform-2.22.2.jar (66 kB at 425 kB/s)
[INFO] Downloaded from Maven: https://repo.maven.apache.org/maven2/org/junit/platform/junit-platform-launcher/1.3.1/junit-platform-launcher-1.3.1.jar (95 kB at 595 kB/s)
[INFO]
[INFO] -------------------------------------------------------
[INFO] T E S T S
[INFO] -------------------------------------------------------
[INFO] Running ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic
[SUBJECT ACCESS ERROR] "Should not throw any exceptions"
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit init
| >
| > Repository created
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit link jdbc:postgresql://135.181.94.98:31107/test#databasegit user=postgres password=****
| >
| > Testing connection OK... Connection established
| jdbc:postgresql://135.181.94.98:31107/test#databasegit # DROP SCHEMA IF EXISTS public CASCADE;
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit rm "*" -idx -v
| >
| > Checking files
| > Loading files...
| > Deleting
| > Removing from index... OK
| > Can't find file "*" in index
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit link jdbc:postgresql://135.181.94.98:31107/pagilla user=postgres password=****
| >
| > Testing connection OK... Connection established
| /home/r/repo/target/itoutput/05 # writing file .dbgit/.dbignore with content:
| > *
| > !public/*.ts
| > !public/*.sch
| > !public/*.seq
| > !public/*.tbl
| > !public/*.pkg
| > !public/*.trg
| > !public/*.prc
| > !public/*.fnc
| > !public/*.vw
| > !public/*.blob
| > !public/*.udt
| > !public/*.enum
| > !public/*.domain
| > !public/*.csv
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit add -v "*"
| >
| > Processing object public/mpaa_rating.enum
| > Saving to file... OK
| > Adding to git... OK Time... 96 ms
| > Processing object public/year.domain
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/actor_actor_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Processing object public/address_address_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/category_category_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/city_city_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/country_country_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/customer_customer_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/customer_customer_id_seq1.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/film_film_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/inventory_inventory_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/language_language_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/payment_payment_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/rental_rental_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/staff_staff_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/store_store_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 20 ms
| > Loading portion index 0,
| > portion size 200
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/address.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 20 ms
| > Loading portion index 0,
| > portion size 603
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/category.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 13 ms
| > Loading portion index 0,
| > portion size 16
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/city.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 15 ms
| > Loading portion index 0,
| > portion size 600
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/country.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Loading portion index 0,
| > portion size 109
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/customer.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 14 ms
| > Loading portion index 0,
| > portion size 599
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 19 ms
| > Loading portion index 0,
| > portion size 1000
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film_actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 9 ms
| > Loading portion index 0,
| > portion size 5462
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film_category.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Loading portion index 0,
| > portion size 1000
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/inventory.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > portion size 4581
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/language.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Loading portion index 0,
| > portion size 6
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Loading portion index 0,
| > Table public/payment.csv has more than 10000 records. dbgit can't save this table data.
| > Processing object public/payment_p2020_01.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Loading portion index 0,
| > portion size 1157
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment_p2020_02.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > portion size 2312
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment_p2020_03.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 11 ms
| > Loading portion index 0,
| > portion size 5644
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment_p2020_04.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 13 ms
| > Loading portion index 0,
| > portion size 6754
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment_p2020_05.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 13 ms
| > Loading portion index 0,
| > portion size 182
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment_p2020_06.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/rental.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > Table public/rental.csv has more than 10000 records. dbgit can't save this table data.
| > Processing object public/staff.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > portion size 2
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Write file object public/staff/3464c9d77aa541f3bdc35067043e3cc33ed4176b2855ff5ea9bfea7a76ddc289.data
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/store.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Loading portion index 0,
| > portion size 2
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/_group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Processing object public/film_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/film_not_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/get_customer_balance.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/inventory_held_by_customer.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/last_day.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/last_updated.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/rewards_report.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/film_fulltext_trigger.trg
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Processing object public/last_updated.trg
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/actor_info.vw
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/customer_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/nicer_but_slower_film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/sales_by_film_category.vw
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Processing object public/sales_by_store.vw
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Processing object public/staff_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit link jdbc:postgresql://135.181.94.98:31107/test#databasegit user=postgres password=****
| >
| > Testing connection OK... Connection established
| /home/r/repo/target/itoutput/05 # writing file .dbgit/dbgitconfig with content:
| > [core]
| > MAX_ROW_COUNT_FETCH = 10000
| > LIMIT_FETCH = true
| > LOG_ROTATE = 31
| > LANG = ENG
| > SCRIPT_ROTATE = 31
| > TO_MAKE_BACKUP = true
| > BACKUP_TO_SCHEME = true
| > BACKUP_TABLEDATA = true
| > PORTION_SIZE = 50000
| > TRY_COUNT = 1000
| > TRY_DELAY = 10
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit restore -r -v
| >
| > Do restore...
| > Loading files...
| > Loading file public/_group_concat_text_text.fnc...
| > Loading file public/actor.csv... loaded 201 rows
| > Loading file public/actor.tbl...
| > Loading file public/actor_actor_id_seq.seq...
| > Loading file public/actor_info.vw...
| > Loading file public/address.csv... loaded 604 rows
| > Loading file public/address.tbl...
| > Loading file public/address_address_id_seq.seq...
| > Loading file public/category.csv... loaded 17 rows
| > Loading file public/category.tbl...
| > Loading file public/category_category_id_seq.seq...
| > Loading file public/city.csv... loaded 601 rows
| > Loading file public/city.tbl...
| > Loading file public/city_city_id_seq.seq...
| > Loading file public/country.csv... loaded 110 rows
| > Loading file public/country.tbl...
| > Loading file public/country_country_id_seq.seq...
| > Loading file public/customer.csv... loaded 600 rows
| > Loading file public/customer.tbl...
| > Loading file public/customer_customer_id_seq.seq...
| > Loading file public/customer_customer_id_seq1.seq...
| > Loading file public/customer_list.vw...
| > Loading file public/film.csv... loaded 1001 rows
| > Loading file public/film.tbl...
| > Loading file public/film_actor.csv... loaded 5463 rows
| > Loading file public/film_actor.tbl...
| > Loading file public/film_category.csv... loaded 1001 rows
| > Loading file public/film_category.tbl...
| > Loading file public/film_film_id_seq.seq...
| > Loading file public/film_fulltext_trigger.trg...
| > Loading file public/film_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/film_list.vw...
| > Loading file public/film_not_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/get_customer_balance_p_customer_id_integer_p_effective_date_timestamp_with_time_zone.fnc...
| > Loading file public/group_concat_text.fnc...
| > Loading file public/inventory.csv... loaded 4582 rows
| > Loading file public/inventory.tbl...
| > Loading file public/inventory_held_by_customer_p_inventory_id_integer.fnc...
| > Loading file public/inventory_in_stock_p_inventory_id_integer.fnc...
| > Loading file public/inventory_inventory_id_seq.seq...
| > Loading file public/language.csv... loaded 7 rows
| > Loading file public/language.tbl...
| > Loading file public/language_language_id_seq.seq...
| > Loading file public/last_day_timestamp_with_time_zone.fnc...
| > Loading file public/last_updated.fnc...
| > Loading file public/last_updated.trg...
| > Loading file public/mpaa_rating.enum...
| > Loading file public/nicer_but_slower_film_list.vw...
| > Loading file public/payment.csv... loaded 1 rows
| > Loading file public/payment.tbl...
| > Loading file public/payment_p2020_01.csv... loaded 1158 rows
| > Loading file public/payment_p2020_01.tbl...
| > Loading file public/payment_p2020_02.csv... loaded 2313 rows
| > Loading file public/payment_p2020_02.tbl...
| > Loading file public/payment_p2020_03.csv... loaded 5645 rows
| > Loading file public/payment_p2020_03.tbl...
| > Loading file public/payment_p2020_04.csv... loaded 6755 rows
| > Loading file public/payment_p2020_04.tbl...
| > Loading file public/payment_p2020_05.csv... loaded 183 rows
| > Loading file public/payment_p2020_05.tbl...
| > Loading file public/payment_p2020_06.csv... loaded 1 rows
| > Loading file public/payment_p2020_06.tbl...
| > Loading file public/payment_payment_id_seq.seq...
| > Loading file public/rental.csv... loaded 1 rows
| > Loading file public/rental.tbl...
| > Loading file public/rental_rental_id_seq.seq...
| > Loading file public/rewards_report_min_monthly_purchases_integer_min_dollar_amount_purchased_numeric.fnc...
| > Loading file public/sales_by_film_category.vw...
| > Loading file public/sales_by_store.vw...
| > Loading file public/staff.csv... loaded 3 rows
| > Loading file public/staff.tbl...
| > Loading file public/staff_list.vw...
| > Loading file public/staff_staff_id_seq.seq...
| > Loading file public/store.csv... loaded 3 rows
| > Loading file public/store.tbl...
| > Loading file public/store_store_id_seq.seq...
| > Loading file public/year.domain...
| > Backup option enabled, all objects will be backed up before making changes
| > Restore key specified, the operation will make changes to database
| > Seeking objects to remove...
| > No objects to remove
| > Seeking objects to restore...
| > public/mpaa_rating.enum
| > public/year.domain
| > public/actor_actor_id_seq.seq
| > public/address_address_id_seq.seq
| > public/category_category_id_seq.seq
| > public/city_city_id_seq.seq
| > public/country_country_id_seq.seq
| > public/customer_customer_id_seq.seq
| > public/customer_customer_id_seq1.seq
| > public/film_film_id_seq.seq
| > public/inventory_inventory_id_seq.seq
| > public/language_language_id_seq.seq
| > public/payment_payment_id_seq.seq
| > public/rental_rental_id_seq.seq
| > public/staff_staff_id_seq.seq
| > public/store_store_id_seq.seq
| > public/actor.tbl
| > public/address.tbl
| > public/category.tbl
| > public/city.tbl
| > public/country.tbl
| > public/customer.tbl
| > public/film.tbl
| > public/film_actor.tbl
| > public/film_category.tbl
| > public/inventory.tbl
| > public/language.tbl
| > public/payment.tbl
| > public/payment_p2020_01.tbl
| > public/payment_p2020_02.tbl
| > public/payment_p2020_03.tbl
| > public/payment_p2020_04.tbl
| > public/payment_p2020_05.tbl
| > public/payment_p2020_06.tbl
| > public/rental.tbl
| > public/staff.tbl
| > public/store.tbl
| > public/_group_concat.fnc
| > public/film_in_stock.fnc
| > public/film_not_in_stock.fnc
| > public/get_customer_balance.fnc
| > public/group_concat.fnc
| > public/inventory_held_by_customer.fnc
| > public/inventory_in_stock.fnc
| > public/last_day.fnc
| > public/last_updated.fnc
| > public/rewards_report.fnc
| > public/film_fulltext_trigger.trg
| > public/last_updated.trg
| > public/actor_info.vw
| > public/customer_list.vw
| > public/film_list.vw
| > public/nicer_but_slower_film_list.vw
| > public/sales_by_film_category.vw
| > public/sales_by_store.vw
| > public/staff_list.vw
| > public/actor.csv
| > public/address.csv
| > public/category.csv
| > public/city.csv
| > public/country.csv
| > public/customer.csv
| > public/film.csv
| > public/film_actor.csv
| > public/film_category.csv
| > public/inventory.csv
| > public/language.csv
| > public/payment.csv
| > public/payment_p2020_01.csv
| > public/payment_p2020_02.csv
| > public/payment_p2020_03.csv
| > public/payment_p2020_04.csv
| > public/payment_p2020_05.csv
| > public/payment_p2020_06.csv
| > public/rental.csv
| > public/staff.csv
| > public/store.csv
| > Seeking additional dependant objects to restore...
| > No additional objects to restore
| > Dropping sql objects...
| > Dropping constraints for all updating tables...
| > Try to backup 0 present of 77 restoring objects ...
| > Restoring...
| > Restoring enum public/mpaa_rating.enum ... OK
| > Restoring domain public/year.domain ... OK
| > Restoring sequence public/actor_actor_id_seq.seq ...
| > Restoring sequence public/address_address_id_seq.seq ...
| > Restoring sequence public/category_category_id_seq.seq ...
| > Restoring sequence public/city_city_id_seq.seq ...
| > Restoring sequence public/country_country_id_seq.seq ...
| > Restoring sequence public/customer_customer_id_seq.seq ...
| > Restoring sequence public/customer_customer_id_seq1.seq ...
| > Restoring sequence public/film_film_id_seq.seq ...
| > Restoring sequence public/inventory_inventory_id_seq.seq ...
| > Restoring sequence public/language_language_id_seq.seq ...
| > Restoring sequence public/payment_payment_id_seq.seq ...
| > Restoring sequence public/rental_rental_id_seq.seq ...
| > Restoring sequence public/staff_staff_id_seq.seq ...
| > Restoring sequence public/store_store_id_seq.seq ...
| > Restoring table public/actor.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/actor.tbl partitions ...
| > Restoring indexes for table public/actor.tbl ... OK
| > Restoring table public/category.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/category.tbl partitions ...
| > Restoring indexes for table public/category.tbl ... OK
| > Restoring table public/country.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/country.tbl partitions ...
| > Restoring indexes for table public/country.tbl ... OK
| > Restoring table public/language.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/language.tbl partitions ...
| > Restoring indexes for table public/language.tbl ... OK
| > Restoring table public/payment.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment.tbl partitions ...
| > Restoring indexes for table public/payment.tbl ... OK
| > Restoring table public/city.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/city.tbl partitions ...
| > Restoring indexes for table public/city.tbl ... OK
| > Restoring table public/film.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/film.tbl partitions ...
| > Restoring indexes for table public/film.tbl ... OK
| > Restoring table public/address.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/address.tbl partitions ...
| > Restoring indexes for table public/address.tbl ... OK
| > Restoring table public/film_actor.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/film_actor.tbl partitions ...
| > Restoring indexes for table public/film_actor.tbl ... OK
| > Restoring table public/film_category.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/film_category.tbl partitions ...
| > Restoring indexes for table public/film_category.tbl ... OK
| > Restoring table public/store.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/store.tbl partitions ...
| > Restoring indexes for table public/store.tbl ... OK
| > Restoring table public/customer.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/customer.tbl partitions ...
| > Restoring indexes for table public/customer.tbl ... OK
| > Restoring table public/inventory.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/inventory.tbl partitions ...
| > Restoring indexes for table public/inventory.tbl ... OK
| > Restoring table public/staff.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/staff.tbl partitions ...
| > Restoring indexes for table public/staff.tbl ... OK
| > Restoring table public/rental.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/rental.tbl partitions ...
| > Restoring indexes for table public/rental.tbl ... OK
| > Restoring table public/payment_p2020_01.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_01.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_01.tbl ... OK
| > Restoring table public/payment_p2020_02.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_02.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_02.tbl ... OK
| > Restoring table public/payment_p2020_03.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_03.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_03.tbl ... OK
| > Restoring table public/payment_p2020_04.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_04.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_04.tbl ... OK
| > Restoring table public/payment_p2020_05.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_05.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_05.tbl ... OK
| > Restoring table public/payment_p2020_06.tbl ...
| > Creating table... OK
| > Modifying columns... OK
| > Restoring table public/payment_p2020_06.tbl partitions ...
| > Restoring indexes for table public/payment_p2020_06.tbl ... OK
| > Restoring function public/_group_concat.fnc ... OK
| > Restoring function public/get_customer_balance.fnc ... OK
| > Restoring function public/inventory_held_by_customer.fnc ... OK
| > Restoring function public/inventory_in_stock.fnc ... OK
| > Restoring function public/last_day.fnc ... OK
| > Restoring function public/rewards_report.fnc ... OK
| > Restoring function public/film_in_stock.fnc ... OK
| > Restoring function public/film_not_in_stock.fnc ... OK
| > Restoring function public/group_concat.fnc ... OK
| > Restoring function public/last_updated.fnc ... OK
| > Restoring trigger public/film_fulltext_trigger.trg ... OK
| > Restoring trigger public/last_updated.trg ... OK
| > Restoring view public/customer_list.vw ... OK
| > Restoring view public/sales_by_film_category.vw ... OK
| > Restoring view public/sales_by_store.vw ... OK
| > Restoring view public/staff_list.vw ... OK
| > Restoring view public/actor_info.vw ... OK
| > Restoring view public/film_list.vw ... OK
| > Restoring view public/nicer_but_slower_film_list.vw ... OK
| > Restoring table data for public/actor.csv ...
| > Deleting constraints for table public/actor.tbl ... OK
| > Inserting...
| > OK Inserted 201 rows.
| > Restoring table data for public/address.csv ...
| > Deleting constraints for table public/address.tbl ... OK
| > Inserting...
| > OK Inserted 604 rows.
| > Restoring table data for public/category.csv ...
| > Deleting constraints for table public/category.tbl ... OK
| > Inserting...
| > OK Inserted 17 rows.
| > Restoring table data for public/city.csv ...
| > Deleting constraints for table public/city.tbl ... OK
| > Inserting...
| > OK Inserted 601 rows.
| > Restoring table data for public/country.csv ...
| > Deleting constraints for table public/country.tbl ... OK
| > Inserting...
| > OK Inserted 110 rows.
| > Restoring table data for public/customer.csv ...
| > Deleting constraints for table public/customer.tbl ... OK
| > Inserting...
| > OK Inserted 600 rows.
| > Restoring table data for public/film.csv ...
| > Deleting constraints for table public/film.tbl ... OK
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/film_actor.csv ...
| > Deleting constraints for table public/film_actor.tbl ... OK
| > Inserting...
| > OK Inserted 5463 rows.
| > Restoring table data for public/film_category.csv ...
| > Deleting constraints for table public/film_category.tbl ... OK
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/inventory.csv ...
| > Deleting constraints for table public/inventory.tbl ... OK
| > Inserting...
| > OK Inserted 4582 rows.
| > Restoring table data for public/language.csv ...
| > Deleting constraints for table public/language.tbl ... OK
| > Inserting...
| > OK Inserted 7 rows.
| > Restoring table data for public/payment.csv ...
| > Deleting constraints for table public/payment.tbl ... OK
| > Restoring table data for public/payment_p2020_01.csv ...
| > Deleting constraints for table public/payment_p2020_01.tbl ... OK
| > Inserting...
| > OK Inserted 1158 rows.
| > Restoring table data for public/payment_p2020_02.csv ...
| > Deleting constraints for table public/payment_p2020_02.tbl ... OK
| > Inserting...
| > OK Inserted 2313 rows.
| > Restoring table data for public/payment_p2020_03.csv ...
| > Deleting constraints for table public/payment_p2020_03.tbl ... OK
| > Inserting...
| > OK Inserted 5645 rows.
| > Restoring table data for public/payment_p2020_04.csv ...
| > Deleting constraints for table public/payment_p2020_04.tbl ... OK
| > Inserting...
| > OK Inserted 6755 rows.
| > Restoring table data for public/payment_p2020_05.csv ...
| > Deleting constraints for table public/payment_p2020_05.tbl ... OK
| > Inserting...
| > OK Inserted 183 rows.
| > Restoring table data for public/payment_p2020_06.csv ...
| > Deleting constraints for table public/payment_p2020_06.tbl ... OK
| > Restoring table data for public/rental.csv ...
| > Deleting constraints for table public/rental.tbl ... OK
| > Restoring table data for public/staff.csv ...
| > Deleting constraints for table public/staff.tbl ... OK
| > Inserting...
| > OK Inserted 3 rows.
| > Restoring table data for public/store.csv ...
| > Deleting constraints for table public/store.tbl ... OK
| > Inserting...
| > OK Inserted 3 rows.
| > Restoring constraints for all updated tables...
| > Restoring table public/actor.tbl constraints ... OK
| > Restoring table public/category.tbl constraints ... OK
| > Restoring table public/country.tbl constraints ... OK
| > Restoring table public/language.tbl constraints ... OK
| > Restoring table public/payment.tbl constraints ... OK
| > Restoring table public/city.tbl constraints ... OK
| > Restoring table public/film.tbl constraints ... OK
| > Restoring table public/address.tbl constraints ... OK
| > Restoring table public/film_actor.tbl constraints ... OK
| > Restoring table public/film_category.tbl constraints ... OK
| > Restoring table public/store.tbl constraints ... OK
| > Restoring table public/customer.tbl constraints ... OK
| > Restoring table public/inventory.tbl constraints ... OK
| > Restoring table public/staff.tbl constraints ... OK
| > Restoring table public/rental.tbl constraints ... OK
| > Restoring table public/payment_p2020_01.tbl constraints ... OK
| > Restoring table public/payment_p2020_02.tbl constraints ... OK
| > Restoring table public/payment_p2020_03.tbl constraints ... OK
| > Restoring table public/payment_p2020_04.tbl constraints ... OK
| > Restoring table public/payment_p2020_05.tbl constraints ... OK
| > Restoring table public/payment_p2020_06.tbl constraints ... OK
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit rm "*" -idx -v
| >
| > Checking files
| > Loading files...
| > Loading file public/_group_concat_text_text.fnc...
| > Loading file public/actor.csv... loaded 201 rows
| > Loading file public/actor.tbl...
| > Loading file public/actor_actor_id_seq.seq...
| > Loading file public/actor_info.vw...
| > Loading file public/address.csv... loaded 604 rows
| > Loading file public/address.tbl...
| > Loading file public/address_address_id_seq.seq...
| > Loading file public/category.csv... loaded 17 rows
| > Loading file public/category.tbl...
| > Loading file public/category_category_id_seq.seq...
| > Loading file public/city.csv... loaded 601 rows
| > Loading file public/city.tbl...
| > Loading file public/city_city_id_seq.seq...
| > Loading file public/country.csv... loaded 110 rows
| > Loading file public/country.tbl...
| > Loading file public/country_country_id_seq.seq...
| > Loading file public/customer.csv... loaded 600 rows
| > Loading file public/customer.tbl...
| > Loading file public/customer_customer_id_seq.seq...
| > Loading file public/customer_customer_id_seq1.seq...
| > Loading file public/customer_list.vw...
| > Loading file public/film.csv... loaded 1001 rows
| > Loading file public/film.tbl...
| > Loading file public/film_actor.csv... loaded 5463 rows
| > Loading file public/film_actor.tbl...
| > Loading file public/film_category.csv... loaded 1001 rows
| > Loading file public/film_category.tbl...
| > Loading file public/film_film_id_seq.seq...
| > Loading file public/film_fulltext_trigger.trg...
| > Loading file public/film_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/film_list.vw...
| > Loading file public/film_not_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/get_customer_balance_p_customer_id_integer_p_effective_date_timestamp_with_time_zone.fnc...
| > Loading file public/group_concat_text.fnc...
| > Loading file public/inventory.csv... loaded 4582 rows
| > Loading file public/inventory.tbl...
| > Loading file public/inventory_held_by_customer_p_inventory_id_integer.fnc...
| > Loading file public/inventory_in_stock_p_inventory_id_integer.fnc...
| > Loading file public/inventory_inventory_id_seq.seq...
| > Loading file public/language.csv... loaded 7 rows
| > Loading file public/language.tbl...
| > Loading file public/language_language_id_seq.seq...
| > Loading file public/last_day_timestamp_with_time_zone.fnc...
| > Loading file public/last_updated.fnc...
| > Loading file public/last_updated.trg...
| > Loading file public/mpaa_rating.enum...
| > Loading file public/nicer_but_slower_film_list.vw...
| > Loading file public/payment.csv... loaded 1 rows
| > Loading file public/payment.tbl...
| > Loading file public/payment_p2020_01.csv... loaded 1158 rows
| > Loading file public/payment_p2020_01.tbl...
| > Loading file public/payment_p2020_02.csv... loaded 2313 rows
| > Loading file public/payment_p2020_02.tbl...
| > Loading file public/payment_p2020_03.csv... loaded 5645 rows
| > Loading file public/payment_p2020_03.tbl...
| > Loading file public/payment_p2020_04.csv... loaded 6755 rows
| > Loading file public/payment_p2020_04.tbl...
| > Loading file public/payment_p2020_05.csv... loaded 183 rows
| > Loading file public/payment_p2020_05.tbl...
| > Loading file public/payment_p2020_06.csv... loaded 1 rows
| > Loading file public/payment_p2020_06.tbl...
| > Loading file public/payment_payment_id_seq.seq...
| > Loading file public/rental.csv... loaded 1 rows
| > Loading file public/rental.tbl...
| > Loading file public/rental_rental_id_seq.seq...
| > Loading file public/rewards_report_min_monthly_purchases_integer_min_dollar_amount_purchased_numeric.fnc...
| > Loading file public/sales_by_film_category.vw...
| > Loading file public/sales_by_store.vw...
| > Loading file public/staff.csv... loaded 3 rows
| > Loading file public/staff.tbl...
| > Loading file public/staff_list.vw...
| > Loading file public/staff_staff_id_seq.seq...
| > Loading file public/store.csv... loaded 3 rows
| > Loading file public/store.tbl...
| > Loading file public/store_store_id_seq.seq...
| > Loading file public/year.domain...
| > Deleting
| > Processing object public/mpaa_rating.enum
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 25 ms
| > Processing object public/year.domain
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 4 ms
| > Processing object public/actor_actor_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/address_address_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/category_category_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/city_city_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/country_country_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/customer_customer_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/customer_customer_id_seq1.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film_film_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/inventory_inventory_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/language_language_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/payment_payment_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/rental_rental_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/staff_staff_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/store_store_id_seq.seq
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/actor.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/address.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/category.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/city.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/country.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/customer.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film_actor.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film_category.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/inventory.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/language.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/payment.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment_p2020_01.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment_p2020_02.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/payment_p2020_03.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment_p2020_04.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/payment_p2020_05.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment_p2020_06.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/rental.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/staff.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/store.tbl
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/_group_concat.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film_in_stock.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/film_not_in_stock.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/get_customer_balance.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/group_concat.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/inventory_held_by_customer.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/inventory_in_stock.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/last_day.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/last_updated.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/rewards_report.fnc
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/film_fulltext_trigger.trg
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/last_updated.trg
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/actor_info.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/customer_list.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/film_list.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/nicer_but_slower_film_list.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/sales_by_film_category.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/sales_by_store.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/staff_list.vw
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/actor.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/address.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/category.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/city.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/country.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/customer.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 4 ms
| > Processing object public/film.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 5 ms
| > Processing object public/film_actor.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 8 ms
| > Processing object public/film_category.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/inventory.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 7 ms
| > Processing object public/language.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/payment_p2020_01.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 2 ms
| > Processing object public/payment_p2020_02.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 4 ms
| > Processing object public/payment_p2020_03.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 15 ms
| > Processing object public/payment_p2020_04.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 11 ms
| > Processing object public/payment_p2020_05.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/payment_p2020_06.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/rental.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Processing object public/staff.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 3 ms
| > Processing object public/store.csv
| > Removing from git... OK
| > Marking item as removing in index ... OK Time... 1 ms
| > Removing from index... OK
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit link jdbc:postgresql://135.181.94.98:31107/dvdrental user=postgres password=****
| >
| > Testing connection OK... Connection established
| /home/r/repo/target/itoutput/05 # writing file .dbgit/.dbignore with content:
| > *
| > !public/*.ts
| > !public/*.sch
| > !public/*.seq
| > !public/*.tbl
| > !public/*.pkg
| > !public/*.trg
| > !public/*.prc
| > !public/*.fnc
| > !public/*.vw
| > !public/*.blob
| > !public/*.udt
| > !public/*.enum
| > !public/*.domain
| > !public/*.csv
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit add -v "*"
| >
| > Processing object public/film_summary.udt
| > Saving to file... OK
| > Adding to git... OK Time... 100 ms
| > Processing object public/mpaa_rating.enum
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/year.domain
| > Saving to file... OK
| > Adding to git... OK Time... 9 ms
| > Processing object public/actor_actor_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 9 ms
| > Processing object public/address_address_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/category_category_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/city_city_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/country_country_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/customer_customer_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/film_film_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/inventory_inventory_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/language_language_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/payment_payment_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/rental_rental_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/staff_staff_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/store_store_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 22 ms
| > Loading portion index 0,
| > portion size 200
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/address.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 19 ms
| > Loading portion index 0,
| > portion size 603
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/category.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 9 ms
| > Loading portion index 0,
| > portion size 16
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/city.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 16 ms
| > Loading portion index 0,
| > portion size 600
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/country.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Loading portion index 0,
| > portion size 109
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/customer.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 17 ms
| > Loading portion index 0,
| > portion size 599
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 14 ms
| > Loading portion index 0,
| > portion size 1000
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film_actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 18 ms
| > Loading portion index 0,
| > portion size 5462
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/film_category.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 12 ms
| > Loading portion index 0,
| > portion size 1000
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/inventory.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Loading portion index 0,
| > portion size 4581
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/language.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 12 ms
| > Loading portion index 0,
| > portion size 6
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/payment.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 11 ms
| > Loading portion index 0,
| > Table public/payment.csv has more than 10000 records. dbgit can't save this table data.
| > Processing object public/rental.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 9 ms
| > Loading portion index 0,
| > Table public/rental.csv has more than 10000 records. dbgit can't save this table data.
| > Processing object public/staff.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Loading portion index 0,
| > portion size 2
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Write file object public/staff/3464c9d77aa541f3bdc35067043e3cc33ed4176b2855ff5ea9bfea7a76ddc289.data
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/store.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Loading portion index 0,
| > portion size 2
| > There is no parameter CURRENT_PORTION
| > Writing portion...
| > Loading portion index 1,
| > portion size 0
| > There is no parameter CURRENT_PORTION
| > Processing object public/_group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 10 ms
| > Processing object public/film_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Processing object public/film_not_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/get_customer_balance.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/inventory_held_by_customer.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/last_day.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/last_updated.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/rewards_report.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/film_fulltext_trigger.trg
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/last_updated.trg
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/actor_info.vw
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/customer_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/nicer_but_slower_film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/sales_by_film_category.vw
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/sales_by_store.vw
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/staff_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit link jdbc:postgresql://135.181.94.98:31107/test#databasegit user=postgres password=****
| >
| > Testing connection OK... Connection established
| /home/r/repo/target/itoutput/05 # writing file .dbgit/dbgitconfig with content:
| > [core]
| > MAX_ROW_COUNT_FETCH = 10000
| > LIMIT_FETCH = true
| > LOG_ROTATE = 31
| > LANG = ENG
| > SCRIPT_ROTATE = 31
| > TO_MAKE_BACKUP = true
| > BACKUP_TO_SCHEME = true
| > BACKUP_TABLEDATA = true
| > PORTION_SIZE = 50000
| > TRY_COUNT = 1000
| > TRY_DELAY = 10
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit restore -r -v
| >
| > Do restore...
| > Loading files...
| > Loading file public/_group_concat_text_text.fnc...
| > Loading file public/actor.csv... loaded 201 rows
| > Loading file public/actor.tbl...
| > Loading file public/actor_actor_id_seq.seq...
| > Loading file public/actor_info.vw...
| > Loading file public/address.csv... loaded 604 rows
| > Loading file public/address.tbl...
| > Loading file public/address_address_id_seq.seq...
| > Loading file public/category.csv... loaded 17 rows
| > Loading file public/category.tbl...
| > Loading file public/category_category_id_seq.seq...
| > Loading file public/city.csv... loaded 601 rows
| > Loading file public/city.tbl...
| > Loading file public/city_city_id_seq.seq...
| > Loading file public/country.csv... loaded 110 rows
| > Loading file public/country.tbl...
| > Loading file public/country_country_id_seq.seq...
| > Loading file public/customer.csv... loaded 600 rows
| > Loading file public/customer.tbl...
| > Loading file public/customer_customer_id_seq.seq...
| > Loading file public/customer_list.vw...
| > Loading file public/film.csv... loaded 1001 rows
| > Loading file public/film.tbl...
| > Loading file public/film_actor.csv... loaded 5463 rows
| > Loading file public/film_actor.tbl...
| > Loading file public/film_category.csv... loaded 1001 rows
| > Loading file public/film_category.tbl...
| > Loading file public/film_film_id_seq.seq...
| > Loading file public/film_fulltext_trigger.trg...
| > Loading file public/film_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/film_list.vw...
| > Loading file public/film_not_in_stock_p_film_id_integer_p_store_id_integer_OUT_p_film_count_integer.fnc...
| > Loading file public/film_summary.udt...
| > Loading file public/get_customer_balance_p_customer_id_integer_p_effective_date_timestamp_without_time_zone.fnc...
| > Loading file public/group_concat_text.fnc...
| > Loading file public/inventory.csv... loaded 4582 rows
| > Loading file public/inventory.tbl...
| > Loading file public/inventory_held_by_customer_p_inventory_id_integer.fnc...
| > Loading file public/inventory_in_stock_p_inventory_id_integer.fnc...
| > Loading file public/inventory_inventory_id_seq.seq...
| > Loading file public/language.csv... loaded 7 rows
| > Loading file public/language.tbl...
| > Loading file public/language_language_id_seq.seq...
| > Loading file public/last_day_timestamp_without_time_zone.fnc...
| > Loading file public/last_updated.fnc...
| > Loading file public/last_updated.trg...
| > Loading file public/mpaa_rating.enum...
| > Loading file public/nicer_but_slower_film_list.vw...
| > Loading file public/payment.csv... loaded 1 rows
| > Loading file public/payment.tbl...
| > Loading file public/payment_payment_id_seq.seq...
| > Loading file public/rental.csv... loaded 1 rows
| > Loading file public/rental.tbl...
| > Loading file public/rental_rental_id_seq.seq...
| > Loading file public/rewards_report_min_monthly_purchases_integer_min_dollar_amount_purchased_numeric.fnc...
| > Loading file public/sales_by_film_category.vw...
| > Loading file public/sales_by_store.vw...
| > Loading file public/staff.csv... loaded 3 rows
| > Loading file public/staff.tbl...
| > Loading file public/staff_list.vw...
| > Loading file public/staff_staff_id_seq.seq...
| > Loading file public/store.csv... loaded 3 rows
| > Loading file public/store.tbl...
| > Loading file public/store_store_id_seq.seq...
| > Loading file public/year.domain...
| > Backup option enabled, all objects will be backed up before making changes
| > Restore key specified, the operation will make changes to database
| > Seeking objects to remove...
| > No objects to remove
| > Seeking objects to restore...
| > public/film_summary.udt
| > public/actor.tbl
| > public/address.tbl
| > public/category.tbl
| > public/city.tbl
| > public/country.tbl
| > public/customer.tbl
| > public/film.tbl
| > public/film_actor.tbl
| > public/film_category.tbl
| > public/inventory.tbl
| > public/language.tbl
| > public/payment.tbl
| > public/rental.tbl
| > public/staff.tbl
| > public/store.tbl
| > public/get_customer_balance.fnc
| > public/last_day.fnc
| > public/last_updated.trg
| > public/actor_info.vw
| > public/customer_list.vw
| > public/film_list.vw
| > public/nicer_but_slower_film_list.vw
| > public/sales_by_store.vw
| > public/staff_list.vw
| > public/actor.csv
| > public/address.csv
| > public/category.csv
| > public/city.csv
| > public/country.csv
| > public/customer.csv
| > public/film.csv
| > public/film_actor.csv
| > public/film_category.csv
| > public/inventory.csv
| > public/language.csv
| > Table public/payment.csv has more than 10000 records. dbgit can't save this table data.
| > public/payment.csv
| > public/staff.csv
| > public/store.csv
| > Seeking additional dependant objects to restore...
| > public/payment_p2020_01.tbl
| > public/payment_p2020_02.tbl
| > public/payment_p2020_03.tbl
| > public/payment_p2020_04.tbl
| > public/payment_p2020_05.tbl
| > public/payment_p2020_06.tbl
| > Dropping sql objects...
| > Dropping sql object public/actor_info.vw...
| > Dropping sql object public/film_list.vw...
| > Dropping sql object public/nicer_but_slower_film_list.vw...
| > Dropping sql object public/customer_list.vw...
| > Dropping sql object public/sales_by_film_category.vw...
| > Dropping sql object public/sales_by_store.vw...
| > Dropping sql object public/staff_list.vw...
| > Dropping sql object public/last_updated.trg...
| > Dropping sql object public/film_fulltext_trigger.trg...
| > Dropping sql object public/film_in_stock.fnc...
| > Dropping sql object public/film_not_in_stock.fnc...
| > Dropping sql object public/group_concat.fnc...
| > Dropping sql object public/last_updated.fnc...
| > Dropping sql object public/_group_concat.fnc...
| > Dropping sql object public/get_customer_balance.fnc...
| > Dropping sql object public/inventory_held_by_customer.fnc...
| > Dropping sql object public/inventory_in_stock.fnc...
| > Dropping sql object public/last_day.fnc...
| > Dropping sql object public/rewards_report.fnc...
| > Dropping constraints for all updating tables...
| > public/rental.tbl ([public/inventory.tbl, public/customer.tbl, public/staff.tbl])
| > public/customer.tbl ([public/store.tbl, public/address.tbl])
| > public/inventory.tbl ([public/store.tbl, public/film.tbl])
| > public/staff.tbl ([public/store.tbl, public/address.tbl])
| > public/store.tbl ([public/address.tbl])
| > public/address.tbl ([public/city.tbl])
| > public/film_actor.tbl ([public/actor.tbl, public/film.tbl])
| > public/film_category.tbl ([public/category.tbl, public/film.tbl])
| > public/city.tbl ([public/country.tbl])
| > public/film.tbl ([public/language.tbl])
| > public/actor.tbl ([])
| > public/category.tbl ([])
| > public/country.tbl ([])
| > public/language.tbl ([])
| > public/payment.tbl ([])
| > Dropping constraints for table public/rental.tbl...
| > Dropping constraints for table public/customer.tbl...
| > Dropping constraints for table public/inventory.tbl...
| > Dropping constraints for table public/staff.tbl...
| > Dropping constraints for table public/store.tbl...
| > Dropping constraints for table public/address.tbl...
| > Dropping constraints for table public/film_actor.tbl...
| > Dropping constraints for table public/film_category.tbl...
| > Dropping constraints for table public/city.tbl...
| > Dropping constraints for table public/film.tbl...
| > Dropping constraints for table public/actor.tbl...
| > Dropping constraints for table public/category.tbl...
| > Dropping constraints for table public/country.tbl...
| > Dropping constraints for table public/language.tbl...
| > Dropping constraints for table public/payment.tbl...
| > Try to backup 21 present of 55 restoring objects ...
| > Creating 21 backups...
| > Creating schema BACKUP$public
| > Trying to copy actor to "BACKUP$public".actor... OK
| > Trying to copy address to "BACKUP$public".address... OK
| > Trying to copy category to "BACKUP$public".category... OK
| > Trying to copy city to "BACKUP$public".city... OK
| > Trying to copy country to "BACKUP$public".country... OK
| > Trying to copy customer to "BACKUP$public".customer... OK
| > Trying to copy film to "BACKUP$public".film... OK
| > Trying to copy film_actor to "BACKUP$public".film_actor... OK
| > Trying to copy film_category to "BACKUP$public".film_category... OK
| > Trying to copy inventory to "BACKUP$public".inventory... OK
| > Trying to copy language to "BACKUP$public"."language"... OK
| > Trying to copy payment to "BACKUP$public".payment... OK
| > Trying to copy rental to "BACKUP$public".rental... OK
| > Trying to copy staff to "BACKUP$public".staff... OK
| > Trying to copy store to "BACKUP$public".store... OK
| > Trying to copy payment_p2020_01 to "BACKUP$public".payment_p2020_01... OK
| > Trying to copy payment_p2020_02 to "BACKUP$public".payment_p2020_02... OK
| > Trying to copy payment_p2020_03 to "BACKUP$public".payment_p2020_03... OK
| > Trying to copy payment_p2020_04 to "BACKUP$public".payment_p2020_04... OK
| > Trying to copy payment_p2020_05 to "BACKUP$public".payment_p2020_05... OK
| > Trying to copy payment_p2020_06 to "BACKUP$public".payment_p2020_06... OK
| > Removing...
| > Restoring...
| > Restoring user defined type public/film_summary.udt ... OK
| > Restoring table public/actor.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/actor.tbl partitions ...
| > Restoring indexes for table public/actor.tbl ... OK
| > Restoring table public/category.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/category.tbl partitions ...
| > Restoring indexes for table public/category.tbl ... OK
| > Restoring table public/country.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/country.tbl partitions ...
| > Restoring indexes for table public/country.tbl ... OK
| > Restoring table public/language.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/language.tbl partitions ...
| > Restoring indexes for table public/language.tbl ... OK
| > Restoring table public/city.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/city.tbl partitions ...
| > Restoring indexes for table public/city.tbl ... OK
| > Restoring table public/film.tbl ... OK
| > Dropping columns... OK
| > Modifying columns... OK
| > Restoring table public/film.tbl partitions ...
| > Restoring indexes for table public/film.tbl ... OK
| > Restoring table public/address.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/address.tbl partitions ...
| > Restoring indexes for table public/address.tbl ... OK
| > Restoring table public/film_actor.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/film_actor.tbl partitions ...
| > Restoring indexes for table public/film_actor.tbl ... OK
| > Restoring table public/film_category.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/film_category.tbl partitions ...
| > Restoring indexes for table public/film_category.tbl ... OK
| > Restoring table public/inventory.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/inventory.tbl partitions ...
| > Restoring indexes for table public/inventory.tbl ... OK
| > Restoring table public/customer.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/customer.tbl partitions ...
| > Restoring indexes for table public/customer.tbl ... OK
| > Restoring table public/staff.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/staff.tbl partitions ...
| > Restoring indexes for table public/staff.tbl ... OK
| > Restoring table public/rental.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/rental.tbl partitions ...
| > Restoring indexes for table public/rental.tbl ... OK
| > Restoring table public/store.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/store.tbl partitions ...
| > Restoring indexes for table public/store.tbl ... OK
| > Restoring table public/payment.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/payment.tbl partitions ...
| > Restoring indexes for table public/payment.tbl ... OK
| > Restoring function public/_group_concat.fnc ... OK
| > Restoring function public/get_customer_balance.fnc ... OK
| > Restoring function public/inventory_held_by_customer.fnc ... OK
| > Restoring function public/inventory_in_stock.fnc ... OK
| > Restoring function public/last_day.fnc ... OK
| > Restoring function public/rewards_report.fnc ... OK
| > Restoring function public/film_in_stock.fnc ... OK
| > Restoring function public/film_not_in_stock.fnc ... OK
| > Restoring function public/group_concat.fnc ... OK
| > Restoring function public/last_updated.fnc ... OK
| > Restoring trigger public/film_fulltext_trigger.trg ... OK
| > Restoring trigger public/last_updated.trg ... OK
| > Restoring view public/customer_list.vw ... OK
| > Restoring view public/sales_by_film_category.vw ... OK
| > Restoring view public/sales_by_store.vw ... OK
| > Restoring view public/staff_list.vw ... OK
| > Restoring view public/actor_info.vw ... OK
| > Restoring view public/film_list.vw ... OK
| > Restoring view public/nicer_but_slower_film_list.vw ... OK
| > Restoring table data for public/actor.csv ...
| > Deleting constraints for table public/actor.tbl ... OK
| > Deleting...20:39 ERROR [App.java:41] : Error execute dbgit
| > ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Restore objects error
| > at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:146)
| > at ru.fusionsoft.dbgit.core.GitMetaDataManager.restoreDataBase(GitMetaDataManager.java:384)
| > at ru.fusionsoft.dbgit.command.CmdRestore.execute(CmdRestore.java:243)
| > at ru.fusionsoft.dbgit.App.executeDbGitCommand(App.java:57)
| > at ru.fusionsoft.dbgit.App.main(App.java:29)
| > Caused by: ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Error restore public.actor
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreTableDataPostgres(DBRestoreTableDataPostgres.java:301)
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreMetaObject(DBRestoreTableDataPostgres.java:110)
| > at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:131)
| > ... 4 common frames omitted
| > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
| > Position: 33
| > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
| > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
| > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
| > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
| > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
| > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
| > at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
| > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
| > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
| > at ru.fusionsoft.dbgit.statement.StatementLogging.execute(StatementLogging.java:178)
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreTableDataPostgres(DBRestoreTableDataPostgres.java:201)
| > ... 6 common frames omitted
| Process exited with error, code 1
| Errors:
| >
| > Error execute dbgit: ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Restore objects error
| > at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:146)
| > at ru.fusionsoft.dbgit.core.GitMetaDataManager.restoreDataBase(GitMetaDataManager.java:384)
| > at ru.fusionsoft.dbgit.command.CmdRestore.execute(CmdRestore.java:243)
| > at ru.fusionsoft.dbgit.App.executeDbGitCommand(App.java:57)
| > at ru.fusionsoft.dbgit.App.main(App.java:29)
| > Caused by: ru.fusionsoft.dbgit.core.ExceptionDBGitRestore: Error restore public.actor
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreTableDataPostgres(DBRestoreTableDataPostgres.java:301)
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreMetaObject(DBRestoreTableDataPostgres.java:110)
| > at ru.fusionsoft.dbgit.adapters.DBAdapter.restoreDataBase(DBAdapter.java:131)
| > ... 4 more
| > Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
| > Position: 33
| > at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
| > at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
| > at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
| > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
| > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
| > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:307)
| > at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:293)
| > at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:270)
| > at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:266)
| > at ru.fusionsoft.dbgit.statement.StatementLogging.execute(StatementLogging.java:178)
| > at ru.fusionsoft.dbgit.postgres.DBRestoreTableDataPostgres.restoreTableDataPostgres(DBRestoreTableDataPostgres.java:201)
| > ... 6 more
| >
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 666.791 s <<< FAILURE! - in ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic
[ERROR] dbToDbRestoreWorksWithCustomTypes Time elapsed: 666.786 s <<< FAILURE!
org.opentest4j.AssertionFailedError: expected: <true> but was: <false>
at ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic.dbToDbRestoreWorksWithCustomTypes(DbGitIntegrationTestBasic.java:372)
[INFO]
[INFO] Results:
[INFO]
[ERROR] Failures:
[ERROR] DbGitIntegrationTestBasic.dbToDbRestoreWorksWithCustomTypes:372 expected: <true> but was: <false>
[INFO]
[ERROR] Tests run: 1, Failures: 1, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 11:10 min
[INFO] Finished at: 2021-07-23T20:39:51Z
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.2:test (default-test) on project dbgit: There are test failures.
[ERROR]
[ERROR] Please refer to /home/r/repo/target/surefire-reports for the individual test results.
[ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
container 7fb0618210c4c23867d7a1c593cf7b3c179b539369682e13c56d5e24808f82fa is dead
Fri Jul 23 22:40:04 CEST 2021
This build log was produced by
rultor.com
for
databasegit/dbgit#16