+ set -e
+ set -o pipefail
++ dirname ./run.sh
+ cd .
+ echo 19273
+ echo '1.69.1 839260fab'
1.69.1 839260fab
+ date
Fri Jul 23 21:43:43 CEST 2021
+ uptime
21:43:43 up 299 days, 5:49, 0 users, load average: 5.05, 4.81, 4.84
+ 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..fa21cf1
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 | 29 ++
.../dbgit/scenarios/PathAfterDbGitLinkAndAdd.java | 18 +-
.../scenarios/PathAfterDbGitRestoreFromDbToDb.java | 61 +++++
.../dbgit/meta/DbObjectNameInSqlPresenceTest.java | 82 ++++++
50 files changed, 1245 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
++ sed 's/ /\n/g'
++ tail -n 1
+ load=4.84
++ echo 4.84 '>' 30
++ bc
+ '[' 0 -eq 1 ']'
+ echo 'load average is 4.84, low enough to run a new Docker container'
load average is 4.84, 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 21:43 .
drwxrwxrwt 11 root root 684032 Jul 23 21:43 ..
-rw-rw-r-- 1 rultor rultor 444 Jul 23 21:43 end.sh
-rwxrwxr-x 1 rultor rultor 363 Jul 23 21:43 entry.sh
-rw-rw-r-- 1 rultor rultor 26 Jul 23 21:43 gitSecret.txt
-rw-rw-r-- 1 rultor rultor 34 Jul 23 21:43 pgSecret.txt
-rw-rw-r-- 1 rultor rultor 6 Jul 23 21:43 pid
drwxrwxr-x 5 rultor rultor 4096 Jul 23 21:43 repo
-rwxrwxr-x 1 rultor rultor 6476 Jul 23 21:43 run.sh
-rw-rw-r-- 1 rultor rultor 749 Jul 23 21:43 script.sh
-rw-rw-r-- 1 rultor rultor 11526 Jul 23 21:43 stdout
++ pwd
++ pwd
+ docker run -t --rm -v /tmp/rultor-hZM7:/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-hZM7/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 23 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 83 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 76 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 78 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 80 kB/s)
[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/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-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-engine/1.3.1/junit-platform-engine-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/apiguardian/apiguardian-api/1.0.0/apiguardian-api-1.0.0.jar (2.2 kB at 94 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/opentest4j/opentest4j/1.1.1/opentest4j-1.1.1.jar (7.1 kB at 297 kB/s)
[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 556 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 951 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 448 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 648 kB/s)
[INFO]
[INFO] -------------------------------------------------------
[INFO] T E S T S
[INFO] -------------------------------------------------------
[INFO] Running ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic
[TEST OK] Hardest sakilla_database sequential add and restore with table data, custom types and partitions works "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
| >
| > Loading files...
| > 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... 113 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... 9 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... 4 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... 7 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... 5 ms
| > Processing object public/language_language_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 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... 6 ms
| > Processing object public/actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 19 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... 10 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... 18 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... 11 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... 21 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... 15 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... 11 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... 12 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... 11 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... 6 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... 9 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... 11 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... 7 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... 10 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... 12 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... 10 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... 9 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... 5 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... 9 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... 6 ms
| > Processing object public/get_customer_balance.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 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... 4 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 3 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... 3 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... 5 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... 4 ms
| > Processing object public/sales_by_store.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 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 # /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 DISABLED, no 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...
| > 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
| >
| > Loading files...
| > 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... 101 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... 7 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... 6 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... 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... 5 ms
| > Processing object public/rental_rental_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/staff_staff_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 21 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... 21 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... 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... 11 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... 16 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... 8 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... 11 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... 11 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... 10 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... 9 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... 5 ms
| > Processing object public/film_not_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/get_customer_balance.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/inventory_held_by_customer.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/last_day.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 7 ms
| > Processing object public/film_fulltext_trigger.trg
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 7 ms
| > Processing object public/customer_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 6 ms
| > Processing object public/sales_by_store.vw
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/staff_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 7 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 # /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 DISABLED, no 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...
| > 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... OK Deleted 200 rows.
| > Inserting...
| > OK Inserted 201 rows.
| > Restoring table data for public/address.csv ...
| > Deleting constraints for table public/address.tbl ... OK
| > Deleting... OK Deleted 603 rows.
| > Inserting...
| > OK Inserted 604 rows.
| > Restoring table data for public/category.csv ...
| > Deleting constraints for table public/category.tbl ... OK
| > Deleting... OK Deleted 16 rows.
| > Inserting...
| > OK Inserted 17 rows.
| > Restoring table data for public/city.csv ...
| > Deleting constraints for table public/city.tbl ... OK
| > Deleting... OK Deleted 600 rows.
| > Inserting...
| > OK Inserted 601 rows.
| > Restoring table data for public/country.csv ...
| > Deleting constraints for table public/country.tbl ... OK
| > Deleting... OK Deleted 109 rows.
| > Inserting...
| > OK Inserted 110 rows.
| > Restoring table data for public/customer.csv ...
| > Deleting constraints for table public/customer.tbl ... OK
| > Deleting... OK Deleted 599 rows.
| > Inserting...
| > OK Inserted 600 rows.
| > Restoring table data for public/film.csv ...
| > Deleting constraints for table public/film.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/film_actor.csv ...
| > Deleting constraints for table public/film_actor.tbl ... OK
| > Deleting... OK Deleted 5462 rows.
| > Inserting...
| > OK Inserted 5463 rows.
| > Restoring table data for public/film_category.csv ...
| > Deleting constraints for table public/film_category.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/inventory.csv ...
| > Deleting constraints for table public/inventory.tbl ... OK
| > Deleting... OK Deleted 4581 rows.
| > Inserting...
| > OK Inserted 4582 rows.
| > Restoring table data for public/language.csv ...
| > Deleting constraints for table public/language.tbl ... OK
| > Deleting... OK Deleted 6 rows.
| > 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/staff.csv ...
| > Deleting constraints for table public/staff.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > Inserting...
| > OK Inserted 3 rows.
| > Restoring table data for public/store.csv ...
| > Deleting constraints for table public/store.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > 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/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/inventory.tbl constraints ... OK
| > Restoring table public/customer.tbl constraints ... OK
| > Restoring table public/staff.tbl constraints ... OK
| > Restoring table public/rental.tbl constraints ... OK
| > Restoring table public/store.tbl constraints ... OK
| > Restoring table public/payment.tbl constraints ... OK
| > Done!
| /home/r/repo/target/itoutput/05 # /home/r/repo/target/dbgit/bin/dbgit rm "*" -idx
| >
| > Loading files...
| > 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... 102 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... 9 ms
| > Processing object public/address_address_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 7 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... 5 ms
| > Processing object public/customer_customer_id_seq1.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/film_film_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 5 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... 8 ms
| > Processing object public/actor.tbl
| > Saving to file... OK
| > Adding to git... OK Time... 19 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... 14 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... 14 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... 11 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... 7 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... 10 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... 16 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... 34 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... 7 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... 11 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... 9 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... 9 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... 7 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... 14 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... 14 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... 9 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... 6 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... 12 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... 7 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... 5 ms
| > Processing object public/film_not_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 6 ms
| > Processing object public/get_customer_balance.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/group_concat.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/inventory_held_by_customer.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/last_day.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/last_updated.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 2 ms
| > Processing object public/actor_info.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 3 ms
| > Processing object public/nicer_but_slower_film_list.vw
| > Saving to file... OK
| > Adding to git... OK Time... 3 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... 7 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 # /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/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_with_time_zone.fnc...
| > 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_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 DISABLED, no 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/customer_customer_id_seq1.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/get_customer_balance.fnc
| > public/last_day.fnc
| > 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
| > 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/staff.csv
| > public/store.csv
| > Seeking additional dependant objects to restore...
| > No additional objects to restore
| > 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/payment.tbl ([public/rental.tbl, public/customer.tbl, public/staff.tbl])
| > public/rental.tbl ([public/inventory.tbl, public/customer.tbl, public/staff.tbl])
| > public/store.tbl ([public/address.tbl, public/staff.tbl])
| > public/customer.tbl ([public/address.tbl])
| > public/staff.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/inventory.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 ([])
| > Dropping constraints for table public/payment.tbl...
| > Dropping constraints for table public/rental.tbl...
| > Dropping constraints for table public/store.tbl...
| > Dropping constraints for table public/customer.tbl...
| > Dropping constraints for table public/staff.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/inventory.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...
| > Restoring...
| > Restoring sequence public/customer_customer_id_seq1.seq ... 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/payment.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/payment.tbl partitions ...
| > Restoring indexes for table public/payment.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
| > Adding 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/store.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/store.tbl partitions ...
| > Restoring indexes for table public/store.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/inventory.tbl ... OK
| > Modifying columns... OK
| > Restoring table public/inventory.tbl partitions ...
| > Restoring indexes for table public/inventory.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/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
| > Deleting... OK Deleted 200 rows.
| > Inserting...
| > OK Inserted 201 rows.
| > Restoring table data for public/address.csv ...
| > Deleting constraints for table public/address.tbl ... OK
| > Deleting... OK Deleted 603 rows.
| > Inserting...
| > OK Inserted 604 rows.
| > Restoring table data for public/category.csv ...
| > Deleting constraints for table public/category.tbl ... OK
| > Deleting... OK Deleted 16 rows.
| > Inserting...
| > OK Inserted 17 rows.
| > Restoring table data for public/city.csv ...
| > Deleting constraints for table public/city.tbl ... OK
| > Deleting... OK Deleted 600 rows.
| > Inserting...
| > OK Inserted 601 rows.
| > Restoring table data for public/country.csv ...
| > Deleting constraints for table public/country.tbl ... OK
| > Deleting... OK Deleted 109 rows.
| > Inserting...
| > OK Inserted 110 rows.
| > Restoring table data for public/customer.csv ...
| > Deleting constraints for table public/customer.tbl ... OK
| > Deleting... OK Deleted 599 rows.
| > Inserting...
| > OK Inserted 600 rows.
| > Restoring table data for public/film.csv ...
| > Deleting constraints for table public/film.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/film_actor.csv ...
| > Deleting constraints for table public/film_actor.tbl ... OK
| > Deleting... OK Deleted 5462 rows.
| > Inserting...
| > OK Inserted 5463 rows.
| > Restoring table data for public/film_category.csv ...
| > Deleting constraints for table public/film_category.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/inventory.csv ...
| > Deleting constraints for table public/inventory.tbl ... OK
| > Deleting... OK Deleted 4581 rows.
| > Inserting...
| > OK Inserted 4582 rows.
| > Restoring table data for public/language.csv ...
| > Deleting constraints for table public/language.tbl ... OK
| > Deleting... OK Deleted 6 rows.
| > Inserting...
| > OK Inserted 7 rows.
| > 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/staff.csv ...
| > Deleting constraints for table public/staff.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > Inserting...
| > OK Inserted 3 rows.
| > Restoring table data for public/store.csv ...
| > Deleting constraints for table public/store.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > 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
| >
| > Loading files...
| > 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... 103 ms
| > Processing object public/mpaa_rating.enum
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/year.domain
| > Saving to file... OK
| > Adding to git... OK Time... 7 ms
| > Processing object public/actor_actor_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 8 ms
| > Processing object public/address_address_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 5 ms
| > Processing object public/film_film_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/inventory_inventory_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/language_language_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/payment_payment_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 ms
| > Processing object public/rental_rental_id_seq.seq
| > Saving to file... OK
| > Adding to git... OK Time... 5 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... 8 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... 21 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... 8 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... 13 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... 16 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... 15 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... 11 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... 9 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... 10 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... 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... 7 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... 6 ms
| > Processing object public/film_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 5 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... 3 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... 4 ms
| > Processing object public/inventory_in_stock.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 ms
| > Processing object public/last_day.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Processing object public/last_updated.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 3 ms
| > Processing object public/rewards_report.fnc
| > Saving to file... OK
| > Adding to git... OK Time... 4 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... 4 ms
| > Processing object public/actor_info.vw
| > Saving to file... OK
| > Adding to git... OK Time... 6 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... 4 ms
| > Processing object public/sales_by_store.vw
| > Saving to file... OK
| > Adding to git... OK Time... 4 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 # /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 DISABLED, no 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...
| > 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... OK Deleted 200 rows.
| > Inserting...
| > OK Inserted 201 rows.
| > Restoring table data for public/address.csv ...
| > Deleting constraints for table public/address.tbl ... OK
| > Deleting... OK Deleted 603 rows.
| > Inserting...
| > OK Inserted 604 rows.
| > Restoring table data for public/category.csv ...
| > Deleting constraints for table public/category.tbl ... OK
| > Deleting... OK Deleted 16 rows.
| > Inserting...
| > OK Inserted 17 rows.
| > Restoring table data for public/city.csv ...
| > Deleting constraints for table public/city.tbl ... OK
| > Deleting... OK Deleted 600 rows.
| > Inserting...
| > OK Inserted 601 rows.
| > Restoring table data for public/country.csv ...
| > Deleting constraints for table public/country.tbl ... OK
| > Deleting... OK Deleted 109 rows.
| > Inserting...
| > OK Inserted 110 rows.
| > Restoring table data for public/customer.csv ...
| > Deleting constraints for table public/customer.tbl ... OK
| > Deleting... OK Deleted 599 rows.
| > Inserting...
| > OK Inserted 600 rows.
| > Restoring table data for public/film.csv ...
| > Deleting constraints for table public/film.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/film_actor.csv ...
| > Deleting constraints for table public/film_actor.tbl ... OK
| > Deleting... OK Deleted 5462 rows.
| > Inserting...
| > OK Inserted 5463 rows.
| > Restoring table data for public/film_category.csv ...
| > Deleting constraints for table public/film_category.tbl ... OK
| > Deleting... OK Deleted 1000 rows.
| > Inserting...
| > OK Inserted 1001 rows.
| > Restoring table data for public/inventory.csv ...
| > Deleting constraints for table public/inventory.tbl ... OK
| > Deleting... OK Deleted 4581 rows.
| > Inserting...
| > OK Inserted 4582 rows.
| > Restoring table data for public/language.csv ...
| > Deleting constraints for table public/language.tbl ... OK
| > Deleting... OK Deleted 6 rows.
| > 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/staff.csv ...
| > Deleting constraints for table public/staff.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > Inserting...
| > OK Inserted 3 rows.
| > Restoring table data for public/store.csv ...
| > Deleting constraints for table public/store.tbl ... OK
| > Deleting... OK Deleted 2 rows.
| > 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/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/inventory.tbl constraints ... OK
| > Restoring table public/customer.tbl constraints ... OK
| > Restoring table public/staff.tbl constraints ... OK
| > Restoring table public/rental.tbl constraints ... OK
| > Restoring table public/store.tbl constraints ... OK
| > Restoring table public/payment.tbl constraints ... OK
| > Done!
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 1,367.364 s - in ru.fusionsoft.dbgit.integration.DbGitIntegrationTestBasic
[INFO]
[INFO] Results:
[INFO]
[INFO] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 22:50 min
[INFO] Finished at: 2021-07-23T20:07:06Z
[INFO] ------------------------------------------------------------------------
+ mv /home/r/repo .
++ whoami
+ chown -R root repo
+ '[' -n '' ']'
++ whoami
+ sudo chown -R rultor repo
+ cd repo
+ git push origin master
ERROR: Permission to databasegit/dbgit.git denied to rultor.
fatal: Could not read from remote repository.
Please make sure you have the correct access rights
and the repository exists.
container c660deb7e4ac6e6a2d3aaa3bfcd7f6347273dfa53be8be9cfed39950f09a96b6 is dead
Fri Jul 23 22:08:17 CEST 2021
This build log was produced by
rultor.com
for
databasegit/dbgit#16