search

Aircloak / aircloak

This repository contains the Aircloak Air frontend as well as the code for our Cloak query and anonymization platform
2 stars 0 forks source link

Long Term Support - fixes #1 #4891

Closed sebastian closed 3 years ago

sebastian commented 3 years ago

Closes #4893 Closes #4890

sebastian commented 3 years ago

Not at all ready for review... built fails miserably.

aircloak-robot commented 3 years ago

integration_tests_test job errored 😢

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:

..

 43) test connection tests error while running a shadow query via cursor (IntegrationTest.OdbcTest)
     test/odbc_test.exs:236
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 44) test connecting when client sslmode=`require`, server config %{"require_ssl" => true} (IntegrationTest.OdbcTest)
     test/odbc_test.exs:70
     match (=) failed
     code:  assert {:ok, _} = var!(connect_result)
     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`require`, server config %{\"require_ssl\" => true}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

 45) test connection tests select (IntegrationTest.OdbcTest)
     test/odbc_test.exs:141
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 46) test connection tests discard command (IntegrationTest.OdbcTest)
     test/odbc_test.exs:209
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 47) test connection tests parameterized query with a decimal (IntegrationTest.OdbcTest)
     test/odbc_test.exs:179
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 48) test connection tests show tables (IntegrationTest.OdbcTest)
     test/odbc_test.exs:115
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 49) test connection tests parameterized query with a char (IntegrationTest.OdbcTest)
     test/odbc_test.exs:197
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 50) test connection tests parameterized query with a small integer (IntegrationTest.OdbcTest)
     test/odbc_test.exs:153
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 51) test connection tests shadow db query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:229
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

...........

Finished in 61.4 seconds
144 tests, 51 failures

Randomized with seed 388172
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
[os_mon] memory supervisor port (memsup): Erlang has closed
=> 68 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_NCMPnTW9HK-jeYdEVWt_jg mix test`
aircloak_ci: result: `error`
aircloak_ci: finished in 2:06 min
aircloak-robot commented 3 years ago

cloak_compile job errored 😟

You can see the full build log by running: ci/production.sh build_log pr 4891 cloak_compile

You can restart the build by running: ci/production.sh force_build pr 4891 cloak_compile

You can start the remote console by running: ci/production.sh remote_console pr 4891 cloak

Log tail:

 ---> e1d77474c492
Step 2/3 : RUN apt-get install -y locales unzip
 ---> Using cache
 ---> 039ec227ad01
Step 3/3 : RUN . /tmp/build_config/proxies.sh && echo 'elixir 1.11.1-otp-23' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add elixir https://github.com/asdf-vm/asdf-elixir.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && bash -c ". ~/.asdf/asdf.sh && mix local.hex --force && mix local.rebar --force"
 ---> Using cache
 ---> 7fec2164128b
Successfully built 7fec2164128b
Successfully tagged aircloak/elixir:1.11.1-otp-23
[aircloak] building aircloak/phoenix
Sending build context to Docker daemon  4.096kB

Step 1/5 : FROM aircloak/elixir:1.11.1-otp-23
 ---> 7fec2164128b
Step 2/5 : RUN . /tmp/build_config/proxies.sh && echo 'nodejs 12.14.0' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add nodejs https://github.com/asdf-vm/asdf-nodejs.git" && bash -c "~/.asdf/plugins/nodejs/bin/import-release-team-keyring"
 ---> Using cache
 ---> d7a775861da9
Step 3/5 : RUN bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - && echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list && apt-get update && apt-get install python yarn -y
 ---> Using cache
 ---> df01e8696e75
Step 4/5 : RUN bash -c ". ~/.asdf/asdf.sh && yarn config set proxy http://acmirror.mpi-sws.org:3128/ && yarn config set https-proxy http://acmirror.mpi-sws.org:3128/"
 ---> Using cache
 ---> 818a771023bb
Step 5/5 : RUN bash -c ". ~/.bashrc && yarn global add brunch"
 ---> Using cache
 ---> 2af8fda79af1
Successfully built 2af8fda79af1
Successfully tagged aircloak/phoenix:12.14.0
[aircloak] building aircloak/base
Sending build context to Docker daemon  3.584kB

Step 1/5 : FROM debian:10.9
 ---> 4a7a1f401734
Step 2/5 : RUN mkdir -p /tmp/build_config && touch /tmp/build_config/proxies.sh
 ---> Using cache
 ---> 574623ae8b4b
Step 3/5 : RUN echo 20210616 > /dev/null
 ---> Using cache
 ---> e8d163ec209a
Step 4/5 : RUN apt-get update && apt-get upgrade -y && apt-get install -y locales wget curl git nano telnet gnupg2 && . /tmp/build_config/proxies.sh && locale-gen en_US.UTF-8 en_us && dpkg-reconfigure locales && locale-gen C.UTF-8 && /usr/sbin/update-locale LANG=C.UTF-8
 ---> Using cache
 ---> b65d4a6a1429
Step 5/5 : ENV LANG=C.UTF-8 LANGUAGE=C.UTF-8 LC_ALL=C.UTF-8
 ---> Using cache
 ---> 877f3ce73aa4
Successfully built 877f3ce73aa4
Successfully tagged aircloak/base:10.9
[aircloak] building aircloak/erlang
Sending build context to Docker daemon  3.072kB

Step 1/3 : FROM aircloak/base:10.9
 ---> 877f3ce73aa4
Step 2/3 : RUN apt-get install -y libz-dev autoconf procps libncurses5-dev libncurses-dev build-essential libssl-dev unixodbc-dev xsltproc fop
 ---> Using cache
 ---> ede5385abb2b
Step 3/3 : RUN . /tmp/build_config/proxies.sh && git clone https://github.com/asdf-vm/asdf.git ~/.asdf --branch v0.1.0 && echo '. ~/.asdf/asdf.sh' >> ~/.bashrc && echo 'erlang 23.1' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add erlang https://github.com/asdf-vm/asdf-erlang.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install"
 ---> Using cache
 ---> e1d77474c492
Successfully built e1d77474c492
Successfully tagged aircloak/erlang:23.1
[aircloak] building aircloak/elixir
Sending build context to Docker daemon  3.072kB

Step 1/3 : FROM aircloak/erlang:23.1
 ---> e1d77474c492
Step 2/3 : RUN apt-get install -y locales unzip
 ---> Using cache
 ---> 039ec227ad01
Step 3/3 : RUN . /tmp/build_config/proxies.sh && echo 'elixir 1.11.1-otp-23' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add elixir https://github.com/asdf-vm/asdf-elixir.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && bash -c ". ~/.asdf/asdf.sh && mix local.hex --force && mix local.rebar --force"
 ---> Using cache
 ---> 7fec2164128b
Successfully built 7fec2164128b
Successfully tagged aircloak/elixir:1.11.1-otp-23
[aircloak] building aircloak/rust
Sending build context to Docker daemon  3.072kB

Step 1/2 : FROM aircloak/elixir:1.11.1-otp-23
 ---> 7fec2164128b
Step 2/2 : RUN . /tmp/build_config/proxies.sh && echo 'rust 1.46.0' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add rust https://github.com/code-lever/asdf-rust.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install"
 ---> Using cache
 ---> af69764c5a58
Successfully built af69764c5a58
Successfully tagged aircloak/rust:1.46.0
[aircloak] building aircloak/ci_cloak
Sending build context to Docker daemon   5.12kB

Step 1/9 : FROM aircloak/rust:1.46.0
 ---> af69764c5a58
Step 2/9 : ENV CI=true
 ---> Running in 1b9cac4360f3
Removing intermediate container 1b9cac4360f3
 ---> bc44e30780b2
Step 3/9 : ENV DEPLOY_CONFIG=dockerized_ci
 ---> Running in 1118f9338842
Removing intermediate container 1118f9338842
 ---> 80b0f964f27a
Step 4/9 : RUN apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 && apt-get update && apt-get install -y unixodbc odbc-postgresql libaio1 inotify-tools
 ---> Running in 4dde4e364981
Warning: apt-key output should not be parsed (stdout is not a terminal)
Executing: /tmp/apt-key-gpghome.J1R6oz2umb/gpg.1.sh --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5
gpg: keyserver receive failed: No keyserver available
The command '/bin/sh -c apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 && apt-get update && apt-get install -y unixodbc odbc-postgresql libaio1 inotify-tools' returned a non-zero code: 2
aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh build_image`
aircloak_ci: result: `error`
aircloak_ci: finished in 26:37 min
aircloak-robot commented 3 years ago

cloak_compile job errored 🔥

You can see the full build log by running: ci/production.sh build_log pr 4891 cloak_compile

You can restart the build by running: ci/production.sh force_build pr 4891 cloak_compile

You can start the remote console by running: ci/production.sh remote_console pr 4891 cloak

Log tail:

Step 1/3 : FROM aircloak/erlang:23.1
 ---> 5c658a5bc06f
Step 2/3 : RUN apt-get install -y locales unzip
 ---> Using cache
 ---> 6cd822edaa7e
Step 3/3 : RUN . /tmp/build_config/proxies.sh && echo 'elixir 1.11.1-otp-23' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add elixir https://github.com/asdf-vm/asdf-elixir.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && bash -c ". ~/.asdf/asdf.sh && mix local.hex --force && mix local.rebar --force"
 ---> Using cache
 ---> 08225b1c116a
Successfully built 08225b1c116a
Successfully tagged aircloak/elixir:1.11.1-otp-23
[aircloak] building aircloak/phoenix
Sending build context to Docker daemon  4.096kB

Step 1/5 : FROM aircloak/elixir:1.11.1-otp-23
 ---> 08225b1c116a
Step 2/5 : RUN . /tmp/build_config/proxies.sh && echo 'nodejs 12.14.0' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add nodejs https://github.com/asdf-vm/asdf-nodejs.git" && bash -c "~/.asdf/plugins/nodejs/bin/import-release-team-keyring"
 ---> Using cache
 ---> 7df05f124513
Step 3/5 : RUN bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add - && echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list && apt-get update && apt-get install python yarn -y
 ---> Using cache
 ---> b246075122a9
Step 4/5 : RUN bash -c ". ~/.asdf/asdf.sh && yarn config set proxy http://acmirror.mpi-sws.org:3128/ && yarn config set https-proxy http://acmirror.mpi-sws.org:3128/"
 ---> Using cache
 ---> eb667323dc5a
Step 5/5 : RUN bash -c ". ~/.bashrc && yarn global add brunch"
 ---> Using cache
 ---> b1e47e4a0ed6
Successfully built b1e47e4a0ed6
Successfully tagged aircloak/phoenix:12.14.0
[aircloak] building aircloak/base
Sending build context to Docker daemon  3.584kB

Step 1/5 : FROM debian:10.9
 ---> 4a7a1f401734
Step 2/5 : RUN mkdir -p /tmp/build_config && touch /tmp/build_config/proxies.sh
 ---> Using cache
 ---> 8e40523bda7a
Step 3/5 : RUN echo 20210616 > /dev/null
 ---> Using cache
 ---> c159581f3d09
Step 4/5 : RUN apt-get update && apt-get upgrade -y && apt-get install -y locales wget curl git nano telnet gnupg2 && . /tmp/build_config/proxies.sh && locale-gen en_US.UTF-8 en_us && dpkg-reconfigure locales && locale-gen C.UTF-8 && /usr/sbin/update-locale LANG=C.UTF-8
 ---> Using cache
 ---> fec35a4225f9
Step 5/5 : ENV LANG=C.UTF-8 LANGUAGE=C.UTF-8 LC_ALL=C.UTF-8
 ---> Using cache
 ---> 2357f1bc3b09
Successfully built 2357f1bc3b09
Successfully tagged aircloak/base:10.9
[aircloak] building aircloak/erlang
Sending build context to Docker daemon  3.072kB

Step 1/3 : FROM aircloak/base:10.9
 ---> 2357f1bc3b09
Step 2/3 : RUN apt-get install -y libz-dev autoconf procps libncurses5-dev libncurses-dev build-essential libssl-dev unixodbc-dev xsltproc fop
 ---> Using cache
 ---> dd0c98176a51
Step 3/3 : RUN . /tmp/build_config/proxies.sh && git clone https://github.com/asdf-vm/asdf.git ~/.asdf --branch v0.1.0 && echo '. ~/.asdf/asdf.sh' >> ~/.bashrc && echo 'erlang 23.1' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add erlang https://github.com/asdf-vm/asdf-erlang.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install"
 ---> Using cache
 ---> 5c658a5bc06f
Successfully built 5c658a5bc06f
Successfully tagged aircloak/erlang:23.1
[aircloak] building aircloak/elixir
Sending build context to Docker daemon  3.072kB

Step 1/3 : FROM aircloak/erlang:23.1
 ---> 5c658a5bc06f
Step 2/3 : RUN apt-get install -y locales unzip
 ---> Using cache
 ---> 6cd822edaa7e
Step 3/3 : RUN . /tmp/build_config/proxies.sh && echo 'elixir 1.11.1-otp-23' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add elixir https://github.com/asdf-vm/asdf-elixir.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install" && bash -c ". ~/.asdf/asdf.sh && mix local.hex --force && mix local.rebar --force"
 ---> Using cache
 ---> 08225b1c116a
Successfully built 08225b1c116a
Successfully tagged aircloak/elixir:1.11.1-otp-23
[aircloak] building aircloak/rust
Sending build context to Docker daemon  3.072kB

Step 1/2 : FROM aircloak/elixir:1.11.1-otp-23
 ---> 08225b1c116a
Step 2/2 : RUN . /tmp/build_config/proxies.sh && echo 'rust 1.46.0' >> ~/.tool-versions && bash -c ". ~/.asdf/asdf.sh && asdf plugin-add rust https://github.com/code-lever/asdf-rust.git" && bash -c ". ~/.asdf/asdf.sh && cd ~ && asdf install"
 ---> Using cache
 ---> 32bcac84bd40
Successfully built 32bcac84bd40
Successfully tagged aircloak/rust:1.46.0
[aircloak] building aircloak/ci_cloak
Sending build context to Docker daemon   5.12kB

Step 1/9 : FROM aircloak/rust:1.46.0
 ---> 32bcac84bd40
Step 2/9 : ENV CI=true
 ---> Running in aa0130e62cff
Removing intermediate container aa0130e62cff
 ---> 9d8e8ad2f36b
Step 3/9 : ENV DEPLOY_CONFIG=dockerized_ci
 ---> Running in b5c813034cc2
Removing intermediate container b5c813034cc2
 ---> 88b6c6224a7f
Step 4/9 : RUN apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 && apt-get update && apt-get install -y unixodbc odbc-postgresql libaio1 inotify-tools
 ---> Running in 5de62e034477
Warning: apt-key output should not be parsed (stdout is not a terminal)
Executing: /tmp/apt-key-gpghome.TmnCNxFtHI/gpg.1.sh --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5
gpg: keyserver receive failed: No keyserver available
The command '/bin/sh -c apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 && apt-get update && apt-get install -y unixodbc odbc-postgresql libaio1 inotify-tools' returned a non-zero code: 2
aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh build_image`
aircloak_ci: result: `error`
aircloak-robot commented 3 years ago

integration_tests_test job errored 😞

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:

       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

 44) test connection tests parameterized query with a decimal (IntegrationTest.OdbcTest)
     test/odbc_test.exs:179
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 45) test connection tests parameterized query with a small integer (IntegrationTest.OdbcTest)
     test/odbc_test.exs:153
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 46) test max_connections can accept up to max_connections connections (IntegrationTest.OdbcTest)
     test/odbc_test.exs:24
     Expected truthy, got false
     code: assert Enum.all?(Stream.take(Stream.repeatedly(fn -> connect(context.user) end), Air.PsqlServer.configuration().max_connections), &(match?({:ok, _pid}, &1)))
     arguments:

         # 1
         #Stream<[
           enum: #Function<52.104660160/2 in Stream.repeatedly/1>,
           funs: [#Function<57.104660160/1 in Stream.take_after_guards/2>]
         ]>

         # 2
         #Function<30.25845194/1 in IntegrationTest.OdbcTest."test max_connections can accept up to max_connections connections"/1>

     stacktrace:
       test/odbc_test.exs:28: (test)

 47) test connection tests extended query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:222
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

....

 48) test connection tests parameterized query with a varchar (IntegrationTest.OdbcTest)
     test/odbc_test.exs:191
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 49) test connection tests shadow db query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:229
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 50) test connection tests parameterized query with an integer (IntegrationTest.OdbcTest)
     test/odbc_test.exs:159
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 51) test connection tests show tables (IntegrationTest.OdbcTest)
     test/odbc_test.exs:115
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

...........

Finished in 59.8 seconds
144 tests, 51 failures

Randomized with seed 477366
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
[os_mon] memory supervisor port (memsup): Erlang has closed
=> 68 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_5WT2tRop5d2DAno27Wo8fA mix test`
aircloak_ci: result: `error`
aircloak_ci: finished in 2:39 min
aircloak-robot commented 3 years ago

integration_tests_test job errored 😢

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:

     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`require`, server config %{\"require_ssl\" => true}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

 45) test connecting when client sslmode=`allow`, server config %{"require_ssl" => true} (IntegrationTest.OdbcTest)
     test/odbc_test.exs:70
     match (=) failed
     code:  assert {:ok, _} = var!(connect_result)
     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`allow`, server config %{\"require_ssl\" => true}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

...

 46) test connecting when client sslmode=`prefer`, server config %{"require_ssl" => true} (IntegrationTest.OdbcTest)
     test/odbc_test.exs:70
     match (=) failed
     code:  assert {:ok, _} = var!(connect_result)
     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\nFATAL:  Only SSL connections are allowed!\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`prefer`, server config %{\"require_ssl\" => true}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

.

 47) test connecting when client sslmode=`require`, server config %{"require_ssl" => false} (IntegrationTest.OdbcTest)
     test/odbc_test.exs:70
     match (=) failed
     code:  assert {:ok, _} = var!(connect_result)
     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`require`, server config %{\"require_ssl\" => false}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

 48) test connection tests parameterized query with a double (IntegrationTest.OdbcTest)
     test/odbc_test.exs:173
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 49) test connection tests closing a cursor (IntegrationTest.OdbcTest)
     test/odbc_test.exs:203
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 50) test connection tests shadow db query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:229
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

..

 51) test connection tests discard command (IntegrationTest.OdbcTest)
     test/odbc_test.exs:209
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

...........

Finished in 60.1 seconds
144 tests, 51 failures

Randomized with seed 326696
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
[os_mon] memory supervisor port (memsup): Erlang has closed
=> 67 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_byvTUplll2o1wLa5IZTNVg mix test`
aircloak_ci: finished in 2:16 min
aircloak_ci: result: `error`
aircloak-robot commented 3 years ago

integration_tests_test job errored 😞

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:


 43) test connection tests parameterized query with a tiny integer (IntegrationTest.OdbcTest)
     test/odbc_test.exs:147
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 44) test connection tests parameterized query with a decimal (IntegrationTest.OdbcTest)
     test/odbc_test.exs:179
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 45) test connection tests discard command (IntegrationTest.OdbcTest)
     test/odbc_test.exs:209
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 46) test connection tests parameterized query with a float (IntegrationTest.OdbcTest)
     test/odbc_test.exs:167
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 47) test invalid connect params (IntegrationTest.OdbcTest)
     test/odbc_test.exs:12
     Assertion with =~ failed
     code:  assert to_string(msg) =~ ~r"Authentication failed"
     left:  "SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed."
     right: ~r/Authentication failed/
     stacktrace:
       test/odbc_test.exs:14: (test)

 48) test connection tests extended query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:222
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 49) test connection tests disconnecting (IntegrationTest.OdbcTest)
     test/odbc_test.exs:106
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 50) test max_connections after max connections are established, subsequent connections are not accepted (IntegrationTest.OdbcTest)
     test/odbc_test.exs:31
     Assertion with =~ failed
     code:  assert to_string(error) =~ ~r"server closed the connection"
     left:  "SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed."
     right: ~r/server closed the connection/
     stacktrace:
       test/odbc_test.exs:38: (test)

 51) test connection tests error while running a shadow query via cursor (IntegrationTest.OdbcTest)
     test/odbc_test.exs:236
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

............

Finished in 62.2 seconds
144 tests, 51 failures

Randomized with seed 551480
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
[os_mon] memory supervisor port (memsup): Erlang has closed
=> 69 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_0J-g98IH5aXdAfpMuoVNsA mix test`
aircloak_ci: result: `error`
aircloak_ci: finished in 2:04 min
aircloak-robot commented 3 years ago

integration_tests_test job errored 😞

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:

 43) test connection tests extended query error (IntegrationTest.OdbcTest)
     test/odbc_test.exs:222
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 44) test connection tests closing a cursor (IntegrationTest.OdbcTest)
     test/odbc_test.exs:203
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

...

 45) test connection tests parameterized query with a small integer (IntegrationTest.OdbcTest)
     test/odbc_test.exs:153
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 46) test connection tests parameterized query with a varchar (IntegrationTest.OdbcTest)
     test/odbc_test.exs:191
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 47) test connection tests parameterized query with a float (IntegrationTest.OdbcTest)
     test/odbc_test.exs:167
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

.

 48) test invalid connect params (IntegrationTest.OdbcTest)
     test/odbc_test.exs:12
     Assertion with =~ failed
     code:  assert to_string(msg) =~ ~r"Authentication failed"
     left:  "SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed."
     right: ~r/Authentication failed/
     stacktrace:
       test/odbc_test.exs:14: (test)

 49) test connection tests parameterized query with a real (IntegrationTest.OdbcTest)
     test/odbc_test.exs:185
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

 50) test connecting when client sslmode=`prefer`, server config %{"require_ssl" => true} (IntegrationTest.OdbcTest)
     test/odbc_test.exs:70
     match (=) failed
     code:  assert {:ok, _} = var!(connect_result)
     left:  {:ok, _}
     right: {:error,
             'SSL SYSCALL error: Success\nFATAL:  Only SSL connections are allowed!\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       anonymous fn/1 in IntegrationTest.OdbcTest."test connecting when client sslmode=`prefer`, server config %{\"require_ssl\" => true}"/1
       (ex_unit 1.11.1) lib/ex_unit/capture_log.ex:74: ExUnit.CaptureLog.capture_log/2
       test/odbc_test.exs:72: (test)

..

 51) test connection tests query context is properly set (IntegrationTest.OdbcTest)
     test/odbc_test.exs:108
     ** (MatchError) no match of right hand side value: {:error, 'SSL SYSCALL error: Success\n SQLSTATE IS: 08001 Connection to database failed.'}
     stacktrace:
       test/odbc_test.exs:102: IntegrationTest.OdbcTest.__ex_unit_setup_1/1
       test/odbc_test.exs:1: IntegrationTest.OdbcTest.__ex_unit__/2

..............

Finished in 61.9 seconds
144 tests, 51 failures

Randomized with seed 567888
[os_mon] memory supervisor port (memsup): Erlang has closed
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
=> 68 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci__apRCzSFAhiLobySbtahlQ mix test`
aircloak_ci: finished in 2:07 min
aircloak_ci: result: `error`
aircloak-robot commented 3 years ago

compliance job errored 😢

You can see the full build log by running: ci/production.sh build_log pr 4891 compliance

You can restart the build by running: ci/production.sh force_build pr 4891 compliance

Log tail:

aircloak_ci: entering queue `compliance`
aircloak_ci: entered queue `compliance`
aircloak_ci: `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh start_container aircloak_ci_SHNUMrX1yv4F95yqEK54xA`
aircloak_ci: `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh prepare_for_compliance aircloak_ci_SHNUMrX1yv4F95yqEK54xA`
starting container oracle-db12ee
Unable to find image 'quay.io/aircloak/oracle-database:12.2.0.1-ee' locally
12.2.0.1-ee: Pulling from aircloak/oracle-database
822ace0353cb: Pulling fs layer
3a34eb425b70: Pulling fs layer
4b87065704e2: Pulling fs layer
03624a03e11e: Pulling fs layer
70e16317451d: Pulling fs layer
55d1616df4cc: Pulling fs layer
03624a03e11e: Waiting
70e16317451d: Waiting
55d1616df4cc: Waiting
4b87065704e2: Verifying Checksum
4b87065704e2: Download complete
3a34eb425b70: Verifying Checksum
3a34eb425b70: Download complete
822ace0353cb: Verifying Checksum
822ace0353cb: Download complete
55d1616df4cc: Download complete
03624a03e11e: Verifying Checksum
03624a03e11e: Download complete
822ace0353cb: Pull complete
3a34eb425b70: Pull complete
4b87065704e2: Pull complete
03624a03e11e: Pull complete
70e16317451d: Verifying Checksum
70e16317451d: Download complete
70e16317451d: Pull complete
55d1616df4cc: Pull complete
Digest: sha256:767af80157da7ec58c7134f3d59f7236a84a83aef499e9cddcfda7bbded8ad86
Status: Downloaded newer image for quay.io/aircloak/oracle-database:12.2.0.1-ee
starting container postgres9.6
starting container quickstart.cloudera
Unable to find image 'quay.io/aircloak/cloudera-quickstart-vm-5.13.0-0-beta:latest' locally
docker: Error response from daemon: Get https://quay.io/v2/: net/http: TLS handshake timeout.
See 'docker run --help'.
aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh prepare_for_compliance aircloak_ci_SHNUMrX1yv4F95yqEK54xA`
aircloak_ci: result: `error`
aircloak_ci: finished in 4:13 min
aircloak-robot commented 3 years ago

compliance job errored 👿

You can see the full build log by running: ci/production.sh build_log pr 4891 compliance

You can restart the build by running: ci/production.sh force_build pr 4891 compliance

Log tail:

aircloak_ci: entering queue `compliance`
aircloak_ci: entered queue `compliance`
aircloak_ci: `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh start_container aircloak_ci_1THjHt1ptNjkZZhf3W33ug`
aircloak_ci: `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh prepare_for_compliance aircloak_ci_1THjHt1ptNjkZZhf3W33ug`
starting container quickstart.cloudera
Unable to find image 'quay.io/aircloak/cloudera-quickstart-vm-5.13.0-0-beta:latest' locally
docker: Error response from daemon: unauthorized: access to the requested resource is not authorized.
See 'docker run --help'.
aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/cloak/ci/container.sh prepare_for_compliance aircloak_ci_1THjHt1ptNjkZZhf3W33ug`
aircloak_ci: result: `error`
aircloak-robot commented 3 years ago

integration_tests_test job errored 😞

You can see the full build log by running: ci/production.sh build_log pr 4891 integration_tests_test

You can restart the build by running: ci/production.sh force_build pr 4891 integration_tests_test

You can start the remote console by running: ci/production.sh remote_console pr 4891 integration_tests

Log tail:


20:31:55.702 [info]  drop table cloaks

20:31:55.705 [info]  drop table usage_info

20:31:55.707 [info]  drop table airs

20:31:55.709 [info]  == Migrated 20180216112239 in 0.0s

20:31:55.715 [info]  == Running 20180302151358 Central.Repo.Migrations.CreateLicenses.change/0 forward

20:31:55.715 [info]  create table licenses

20:31:55.718 [info]  == Migrated 20180302151358 in 0.0s

20:31:55.722 [info]  == Running 20180305121014 Central.Repo.Migrations.AddRenewalToLicenses.change/0 forward

20:31:55.722 [info]  alter table licenses

20:31:55.723 [info]  == Migrated 20180305121014 in 0.0s

20:31:55.727 [info]  == Running 20180307123951 Central.Repo.Migrations.AddRevokedToLicenses.change/0 forward

20:31:55.727 [info]  alter table licenses

20:31:55.728 [info]  == Migrated 20180307123951 in 0.0s

20:31:55.731 [info]  == Running 20180423153920 Central.Repo.Migrations.CascadeDeleteLicenses.up/0 forward

20:31:55.732 [info]  execute "ALTER TABLE licenses DROP CONSTRAINT licenses_customer_id_fkey"

20:31:55.733 [info]  alter table licenses

20:31:55.735 [info]  == Migrated 20180423153920 in 0.0s

20:31:55.738 [info]  == Running 20180508143800 Central.Repo.Migrations.DeleteQueriesTable.up/0 forward

20:31:55.738 [info]  drop table queries

20:31:55.741 [info]  == Migrated 20180508143800 in 0.0s

20:31:55.745 [info]  == Running 20180820131126 Central.Repo.Migrations.AddFeaturesToLicenses.change/0 forward

20:31:55.745 [info]  alter table licenses

20:31:55.749 [info]  == Migrated 20180820131126 in 0.0s

20:31:55.753 [info]  == Running 20190423124742 Central.Repo.Migrations.MakeLoginCaseInsensitive.up/0 forward

20:31:55.753 [info]  drop index users_email_index

20:31:55.754 [info]  execute "CREATE UNIQUE INDEX users_email_index ON users (lower(email))"

20:31:55.755 [info]  == Migrated 20190423124742 in 0.0s

20:31:55.759 [info]  == Running 20200108134139 Central.Repo.Migrations.RemoveAirpcsAndCustomerExports.up/0 forward

20:31:55.759 [info]  drop table air_rpcs

20:31:55.761 [info]  drop table customer_exports

20:31:55.763 [info]  == Migrated 20200108134139 in 0.0s
=> 6 sec

aircloak_ci: `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_jtMZo0MZXtVT4upqRcknOA mix test`

20:31:58.981 [info]  Compiling auto-completions
..............................................................................................

  1) test max_connections can accept up to max_connections connections (IntegrationTest.OdbcTest)
     test/odbc_test.exs:24
     Expected truthy, got false
     code: assert Enum.all?(Stream.take(Stream.repeatedly(fn -> connect(context.user) end), Air.PsqlServer.configuration().max_connections), &(match?({:ok, _pid}, &1)))
     arguments:

         # 1
         #Stream<[
           enum: #Function<52.104660160/2 in Stream.repeatedly/1>,
           funs: [#Function<57.104660160/1 in Stream.take_after_guards/2>]
         ]>

         # 2
         #Function<30.25845194/1 in IntegrationTest.OdbcTest."test max_connections can accept up to max_connections connections"/1>

     stacktrace:
       test/odbc_test.exs:28: (test)

.................................................

Finished in 66.5 seconds
144 tests, 1 failure

Randomized with seed 312441
[os_mon] cpu supervisor port (cpu_sup): Erlang has closed
[os_mon] memory supervisor port (memsup): Erlang has closed
=> 73 sec

aircloak_ci: error: error running `/home/ci/.aircloak_ci/data/cache/builds/pr-4891/src/integration_tests/ci/container.sh run_in_container aircloak_ci_jtMZo0MZXtVT4upqRcknOA mix test`
aircloak_ci: result: `error`
aircloak-robot commented 3 years ago

Standard tests have passed ❤️

edongashi commented 3 years ago

After the most painful debug session of my life I managed to figure out the cause.

I kept thinking that some APT module is missing or ODBC is somehow misconfigured and spent considerable time experimenting with different installations.

After investigating the containers and their logs, I found out that actually our own Ranch server was crashing during connection init. This happens even on master and semi-recent deployments. The :ssl module suddenly decided to throw a vague error about some missing ciphers. I tried installing erlang crypto packages / OpenSSL dev packages, registering RSA key exchanges which were removed in OPT21+, upgrading Erlang, forcing specific versions of TLS, and even looking at raw binary messages without success.

Turns out newer OTP versions of Erlang decided to f*** our PSQL server by silently dropping RSA signature algorithms at or below 1024 bits during SSL handshake. Added a newer dummy certificate at 4096 bits signature and that did the trick...

sebastian commented 3 years ago

@cristianberneanu please review (@edongashi: assigning Cristian as we both have added code here). These changes will subsequently make it possible to merge in all the other pull-requests we have open too!

aircloak-robot commented 3 years ago

Standard tests have passed 🎉

aircloak-robot commented 3 years ago

Pull request can be merged ❤️