Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

fix windows CI build via conda #22

Closed
ltalirz opened this issue Feb 16, 2021 · 2 comments
Closed

fix windows CI build via conda #22

ltalirz opened this issue Feb 16, 2021 · 2 comments

Comments

@ltalirz
Copy link
Member

ltalirz commented Feb 16, 2021 •
edited
Loading

The windows CI build has started failing with the error
https://github.com/aiidateam/pgsu/runs/1914573646#step:7:69

psycopg2.OperationalError: FATAL:  role "postgres" does not exist

(while the MacOS build using otherwise identical instructions still succeeds)

This sounds like, for some reason, on windows there is no postgresql superuser.

However, on April 5th 2020 the tests still passed, and there hasn't been an update in the anaconda postgresql package for windows since then
https://anaconda.org/anaconda/postgresql/files

the only difference I can see between macos and windows is

MacOS

initdb: warning: enabling "trust" authentication for local connections
syncing data to disk ... ok
You can change this by editing pg_hba.conf or using the option -A, or

--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    pg_ctl -D test_db -l logfile start

waiting for server to start....2021-02-16 23:09:22.255 UTC [1487] LOG:  starting PostgreSQL 12.2 on x86_64-apple-darwin14.5.0, compiled by clang version 4.0.1 (tags/RELEASE_401/final), 64-bit
2021-02-16 23:09:22.259 UTC [1487] LOG:  listening on IPv6 address "::1", port 5432
2021-02-16 23:09:22.259 UTC [1487] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-02-16 23:09:22.271 UTC [1487] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-02-16 23:09:22.312 UTC [1488] LOG:  database system was shut down at 2021-02-16 23:09:22 UTC
2021-02-16 23:09:22.321 UTC [1487] LOG:  database system is ready to accept connections
 done
server started

Windows

initdb: warning: enabling "trust" authentication for local connections
syncing data to disk ... ok
You can change this by editing pg_hba.conf or using the option -A, or

--auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    C:/Miniconda/envs/test/Library/bin/pg_ctl -D test_db -l logfile start

waiting for server to start....2021-02-16 23:09:36.914 UTC [6712] LOG:  starting PostgreSQL 12.2, compiled by Visual C++ build 1916, 64-bit
2021-02-16 23:09:36.917 UTC [6712] LOG:  listening on IPv6 address "::1", port 5432
2021-02-16 23:09:36.917 UTC [6712] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-02-16 23:09:36.960 UTC [4936] LOG:  database system was shut down at 2021-02-16 23:09:35 UTC
2021-02-16 23:09:36.972 UTC [6712] LOG:  database system is ready to accept connections
 done
server started
@ltalirz
Copy link
Member Author

ltalirz commented Mar 1, 2021 •
edited
Loading

Note: even the MacOS build seems to be "flaky" and can error at the step that starts the postgres cluster.

In #25 it first got an error

Success. You can now start the database server using:

    pg_ctl -D test_db -l logfile start

waiting for server to start....2021-03-01 21:58:37.404 UTC [1396] LOG:  starting PostgreSQL 12.2 on x86_64-apple-darwin14.5.0, compiled by clang version 4.0.1 (tags/RELEASE_401/final), 64-bit
2021-03-01 21:58:37.406 UTC [1396] LOG:  listening on IPv6 address "::1", port 5432
2021-03-01 21:58:37.406 UTC [1396] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-03-01 21:58:37.407 UTC [1396] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-03-01 21:58:37.419 UTC [1397] LOG:  database system was shut down at 2021-03-01 21:58:37 UTC
2021-03-01 21:58:37.428 UTC [1396] LOG:  database system is ready to accept connections
 done
server started
Error: The operation was canceled.

and then, after enabling debug logging (which should not change anything) gave

Success. You can now start the database server using:

    pg_ctl -D test_db -l logfile start

waiting for server to start....2021-03-01 22:10:54.537 UTC [1397] DEBUG:  postgres: PostmasterMain: initial environment dump:
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  -----------------------------------------
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_JOB=multi-conda
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_EVENT_PATH=/Users/runner/work/_temp/_github_workflow/event.json
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_OS=macOS
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	XCODE_12_DEVELOPER_DIR=/Applications/Xcode_12.4.app/Contents/Developer
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_HOME=/Users/runner/Library/Android/sdk
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	NVM_CD_FLAGS=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_BASE_REF=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	SHELL=/bin/bash
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CHROMEWEBDRIVER=/usr/local/Caskroom/chromedriver/88.0.4324.96
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PIPX_BIN_DIR=/usr/local/opt/pipx_bin
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	TMPDIR=/var/folders/24/8k48jl6d249_n_qfxwsl6xvm0000gn/T/
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_REPOSITORY_OWNER=aiidateam
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ACTIONS=true
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_RUN_NUMBER=195
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_SHLVL=2
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PG_GRANDPARENT_PID=1345
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_PROMPT_MODIFIER=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_SDK_ROOT=/Users/runner/Library/Android/sdk
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RCT_NO_LAUNCH_PACKAGER=1
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME_8_X64=/Library/Java/JavaVirtualMachines/adoptopenjdk-8.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_WORKSPACE=/Users/runner/work/pgsu
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_PKGS_DIR=/Users/runner/conda_pkgs_dir
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_PERFLOG=/usr/local/opt/runner/perflog
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	NUNIT_BASE_PATH=/Library/Developer/nunit
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	NUNIT3_PATH=/Library/Developer/nunit/3.6.0
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_REF=refs/heads/issue_18_change_test
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_WORKFLOW=ci
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_TOOL_CACHE=/Users/runner/hostedtoolcache
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME_11_X64=/Library/Java/JavaVirtualMachines/adoptopenjdk-11.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME_14_X64=/Library/Java/JavaVirtualMachines/adoptopenjdk-14.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	USER=runner
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	NVM_DIR=/Users/runner/.nvm
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ACTION_REPOSITORY=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	XCODE_10_DEVELOPER_DIR=/Applications/Xcode_10.3.app/Contents/Developer
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_SHA=03060f0330dba473fe1f17f0ef53d5a6abce064c
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_EVENT_NAME=push
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_API_URL=https://api.github.com
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	pythonLocation=/Users/runner/hostedtoolcache/Python/3.8.8/x64
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_TEMP=/Users/runner/work/_temp
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_NDK_ROOT=/Users/runner/Library/Android/sdk/ndk-bundle
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_EXE=/usr/local/miniconda/bin/conda
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ImageVersion=20210220.1
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_NDK_LATEST_HOME=/Users/runner/Library/Android/sdk/ndk/22.0.7026061
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	SSH_AUTH_SOCK=/private/tmp/com.apple.launchd.PfHMA4Ifn2/Listeners
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	__CF_USER_TEXT_ENCODING=0x1F5:0:0
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	HOMEBREW_NO_AUTO_UPDATE=1
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_SERVER_URL=https://github.com
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	AGENT_TOOLSDIRECTORY=/Users/runner/hostedtoolcache
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_HEAD_REF=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_GRAPHQL_URL=https://api.github.com/graphql
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	_CE_CONDA=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_PREFIX_1=/usr/local/miniconda
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PATH=/usr/local/miniconda/envs/test/bin:/usr/local/miniconda/condabin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/Library/Apple/usr/bin:/Library/Frameworks/Mono.framework/Versions/Current/Commands:/usr/local/miniconda/condabin:/Users/runner/hostedtoolcache/Python/3.8.8/x64/bin:/Users/runner/hostedtoolcache/Python/3.8.8/x64:/usr/local/opt/pipx_bin:/Users/runner/.cargo/bin:/usr/local/lib/ruby/gems/2.7.0/bin:/usr/local/opt/[email protected]/bin:/usr/local/opt/curl/bin:/usr/local/sbin:/Users/runner/bin:/Users/runner/.yarn/bin:/usr/local/go/bin:/Users/runner/Library/Android/sdk/tools:/Users/runner/Library/Android/sdk/platform-tools:/Users/runner/Library/Android/sdk/ndk-bundle:/Users/runner/.dotnet/tools:/Users/runner/.ghcup/bin:/Users/runner/hostedtoolcache/stack/2.5.1/x64
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	_=/usr/local/miniconda/envs/test/bin/pg_ctl
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PERFLOG_LOCATION_SETTING=RUNNER_PERFLOG
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_RETENTION_DAYS=90
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_PREFIX=/usr/local/miniconda/envs/test
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	EDGEWEBDRIVER=/usr/local/share/edge_driver
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA=/usr/local/miniconda
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	DOTNET_ROOT=/Users/runner/.dotnet
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	***
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME=/Library/Java/JavaVirtualMachines/adoptopenjdk-8.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME_12_X64=/Library/Java/JavaVirtualMachines/adoptopenjdk-12.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	VCPKG_INSTALLATION_ROOT=/usr/local/share/vcpkg
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	LANG=en_US.UTF-8
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ImageOS=macos1015
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	XPC_FLAGS=0x0
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PGSYSCONFDIR=/usr/local/miniconda/envs/test/etc
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PIPX_HOME=/usr/local/opt/pipx
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	XPC_SERVICE_NAME=0
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GECKOWEBDRIVER=/usr/local/opt/geckodriver/bin
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ACTOR=ltalirz
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	_CE_M=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	HOME=/Users/runner
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	SHLVL=2
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	RUNNER_TRACKING_ID=github_15c03f7b-521a-4082-9db2-afa9c684cc52
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_NDK_18R_PATH=/Users/runner/Library/Android/sdk/ndk/18.1.5063045
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_WORKSPACE=/Users/runner/work/pgsu/pgsu
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CI=true
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ACTION_REF=
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_RUN_ID=612015427
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	LOGNAME=runner
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_PYTHON_EXE=/usr/local/miniconda/bin/python
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	LC_CTYPE=en_US.UTF-8
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ENV=/Users/runner/work/_temp/_runner_file_commands/set_env_b6e7d8f8-a0ab-46bc-9ddf-b09b2e3ce3bb
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	HOMEBREW_CLEANUP_PERIODIC_FULL_DAYS=3650
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	JAVA_HOME_13_X64=/Library/Java/JavaVirtualMachines/adoptopenjdk-13.jdk/Contents/Home
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	PGDATA=test_db
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	HOMEBREW_CASK_OPTS=--no-quarantine
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	CONDA_DEFAULT_ENV=test
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	POWERSHELL_DISTRIBUTION_CHANNEL=GitHub-Actions-macos1015
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	ANDROID_NDK_HOME=/Users/runner/Library/Android/sdk/ndk-bundle
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	BOOTSTRAP_HASKELL_NONINTERACTIVE=1
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	XCODE_11_DEVELOPER_DIR=/Applications/Xcode_11.7.app/Contents/Developer
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_REPOSITORY=aiidateam/pgsu
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_PATH=/Users/runner/work/_temp/_runner_file_commands/add_path_b6e7d8f8-a0ab-46bc-9ddf-b09b2e3ce3bb
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	GITHUB_ACTION=run1
2021-03-01 22:10:54.537 UTC [1397] DEBUG:  	DOTNET_MULTILEVEL_LOOKUP=0
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  	LC_COLLATE=en_US.UTF-8
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  	LC_MESSAGES=en_US.UTF-8
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  	LC_MONETARY=C
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  	LC_NUMERIC=C
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  	LC_TIME=C
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  -----------------------------------------
2021-03-01 22:10:54.538 UTC [1397] DEBUG:  registering background worker "logical replication launcher"
2021-03-01 22:10:54.538 UTC [1397] LOG:  starting PostgreSQL 12.2 on x86_64-apple-darwin14.5.0, compiled by clang version 4.0.1 (tags/RELEASE_401/final), 64-bit
2021-03-01 22:10:54.542 UTC [1397] LOG:  listening on IPv6 address "::1", port 5432
2021-03-01 22:10:54.542 UTC [1397] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2021-03-01 22:10:54.543 UTC [1397] LOG:  listening on Unix socket "/tmp/.s.PGSQL.5432"
2021-03-01 22:10:54.543 UTC [1397] DEBUG:  invoking IpcMemoryCreate(size=149086208)
2021-03-01 22:10:54.549 UTC [1397] DEBUG:  SlruScanDirectory invoking callback on pg_notify/0000
2021-03-01 22:10:54.549 UTC [1397] DEBUG:  removing file "pg_notify/0000"
2021-03-01 22:10:54.550 UTC [1397] DEBUG:  dynamic shared memory system will support 308 segments
2021-03-01 22:10:54.550 UTC [1397] DEBUG:  created dynamic shared memory control segment 394109714 (7408 bytes)
2021-03-01 22:10:54.551 UTC [1397] DEBUG:  max_safe_fds = 974, usable_fds = 1000, already_open = 16
2021-03-01 22:10:54.556 UTC [1398] LOG:  database system was shut down at 2021-03-01 22:10:54 UTC
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  checkpoint record is at 0/15EC940
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  redo record is at 0/15EC940; shutdown true
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  next transaction ID: 486; next OID: 12940
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  next MultiXactId: 1; next MultiXactOffset: 0
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  oldest unfrozen transaction ID: 479, in database 1
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  oldest MultiXactId: 1, in database 1
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  commit timestamp Xid oldest/newest: 0/0
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  transaction ID wrap limit is 2147484126, limited by database with OID 1
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID 1
2021-03-01 22:10:54.556 UTC [1398] DEBUG:  starting up replication slots
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  starting up replication origin progress state
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  MultiXactId wrap limit is 2147483648, limited by database with OID 1
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  MultiXact member stop limit is now 4294914944 based on MultiXact 1
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  shmem_exit(0): 1 before_shmem_exit callbacks to make
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  shmem_exit(0): 5 on_shmem_exit callbacks to make
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  proc_exit(0): 2 callbacks to make
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  exit(0)
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  shmem_exit(-1): 0 before_shmem_exit callbacks to make
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  shmem_exit(-1): 0 on_shmem_exit callbacks to make
2021-03-01 22:10:54.557 UTC [1398] DEBUG:  proc_exit(-1): 0 callbacks to make
2021-03-01 22:10:54.558 UTC [1397] DEBUG:  reaping dead processes
2021-03-01 22:10:54.560 UTC [1399] DEBUG:  checkpointer updated shared memory configuration values
2021-03-01 22:10:54.561 UTC [1397] DEBUG:  starting background worker process "logical replication launcher"
2021-03-01 22:10:54.561 UTC [1402] DEBUG:  autovacuum launcher started
2021-03-01 22:10:54.561 UTC [1402] DEBUG:  InitPostgres
2021-03-01 22:10:54.561 UTC [1402] DEBUG:  my backend ID is 1
2021-03-01 22:10:54.562 UTC [1402] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.562 UTC [1397] LOG:  database system is ready to accept connections
2021-03-01 22:10:54.562 UTC [1402] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.562 UTC [1403] DEBUG:  received inquiry for database 0
2021-03-01 22:10:54.562 UTC [1403] DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2021-03-01 22:10:54.562 UTC [1404] DEBUG:  logical replication launcher started
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  InitPostgres
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  my backend ID is 2
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.563 UTC [1404] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.605 UTC [1402] DEBUG:  StartTransaction(1) name: unnamed; blockState: DEFAULT; state: INPROGRESS, xid/subid/cid: 0/1/0
2021-03-01 22:10:54.605 UTC [1402] DEBUG:  CommitTransaction(1) name: unnamed; blockState: STARTED; state: INPROGRESS, xid/subid/cid: 0/1/0
 done
server started

and the tests passed.

@chrisjsewell chrisjsewell mentioned this issue Aug 30, 2021
Merged
@ltalirz ltalirz mentioned this issue Aug 31, 2021
Merged
ltalirz added a commit that referenced this issue Aug 31, 2021
@ltalirz
Change default user for Windows (#28)
2149c6f 
It seems that [somewhere between April 5th 2020 and February 17th 2021](#22), on the Github Action Windows runners the default superuser of postgresql databases changed.
The superuser created upon installation of the postgresql conda package used to be `postgres` like on UNIX systems, but then started to use the name of the OS user running the commands (here: `runneradmin`),  seemingly without updating the postgresql conda package.

This change switches the default database superuser for Windows from `postgres` to the OS user, fixing CI tests.
@ltalirz
Copy link
Member Author

ltalirz commented Aug 31, 2021

fixed by #28

@ltalirz ltalirz closed this as completed Aug 31, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@ltalirz