Trying to connect to postgres

[Gordon]

I’ve just tried to re-run the near 7000 image dataset as per the stoi error thread, but it crashed my computer, so I had to hit the physical off button. I then started the computer again and tried to start WebODM, but got the same error as above (in the thread from where this was moved).

Cannot launch WebODM
Exceeded max retries. If you have a firewall, make sure WebODM is allowed, then restart the application. If you still have troubles, get in touch here.

Here is the app log:

“Booting WebODM 1.9.7 build 32…”
“Trying to connect to NodeODM localhost:29301…”
“Attempt 0 failed, retrying…”
“nodeodm: info: Authentication using SimpleToken\r\n”
“nodeodm: info: Listening on 0.0.0.0:6367 UDP for progress updates\r\n”
“nodeodm: warn: Could not load task list. It looks like the data\tasks.json is corrupted (Unexpected token \u0000 in JSON at position 0).\r\n”
“nodeodm: info: Checking for orphaned directories to be removed…\r\n”
“nodeodm: info: Found orphaned directory: 512a9ea7-0913-4e08-9596-3218e2fe3e02, removing…\r\n”
“nodeodm: info: Found orphaned directory: 80948216-742d-4147-a565-214e9e4f5ff2, removing…\r\n”
“Trying to connect to NodeODM localhost:29301…”
“nodeodm: info: Server has started on port 29301\r\n”
“Connected to NodeODM 2.1.9”
“redis-server: . \n .-__ ''-._ \n _.- . . ‘’-._ Redis 3.2.100 (00000000/0) 64 bit\n .- .-```. ```\\/ _.,_ ''-._ \n ( ' , .-` | `, ) Running in standalone mode\n |`-._`-...-` __...-.-.|’_.-'| Port: 29379\n | -. ._ / _.-' | PID: 10860\n -._ -._ -./ .-’ .-’ \n |-._-. -.__.-' _.-'_.-'| \n | -.-._ _.-'_.-' | http://redis.io \n -._ -._-..-’.-’ .-’ \n |-._-. -.__.-' _.-'_.-'| \n | -.-._ _.-'_.-' | \n -._ -._-..-’_.-’ _.-’ \n -._ -..-’ _.-’ \n -._ _.-' \n -..-’ \n\n[10860] 20 Oct 14:49:44.517 # Server started, Redis version 3.2.100\n”
“redis-server: [10860] 20 Oct 14:49:44.580 * DB loaded from disk: 0.063 seconds\n[10860] 20 Oct 14:49:44.580 * The server is now ready to accept connections on port 29379\n”
“E:\WebODM\resources\app\apps\pgsql/bin/pg_ctl: pg_ctl: could not send stop signal (PID: 12560): No such process\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/pg_ctl: exited with code 1”
“Could not stop PGSQL, but pidfile found”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/pg_ctl: server starting\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/pg_ctl: exited with code 0”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 0 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 1 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 2 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 3 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 4 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 5 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 6 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 7 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 8 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“Attempt 9 failed, retrying…”
“Trying to connect to postgres localhost:29543…”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: psql: could not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (::1) and accepting\r\n\tTCP/IP connections on port 29543?\r\ncould not connect to server: Connection refused (0x0000274D/10061)\r\n\tIs the server running on host “localhost” (127.0.0.1) and accepting\r\n\tTCP/IP connections on port 29543?\r\n”
“E:\WebODM\resources\app\apps\pgsql/bin/psql: exited with code 2”
{}

---

The pgsql.log file is 322KB, probably too large to post here, but can put it on Google Drive if required.
There are no logs anywhere, just my images, and I’m currently unable to launch WebODM.

[Saijin_Naib]

Are there any pgsql.exe tasks running in Task Manager after you exit/cancel trying to launch WebODM?

[Gordon]

No.

Do I need to re-install WebODM?

EDIT - several restarts later, I’m still unable to launch WebODM due to the above error, so there must be a problem in the 1.9.7 build32 version.

[Gordon]

Hmm, something is seriously broken. I re-downloaded 1.9.0 build 8 and tried to install into the same directory, which apparently was successful, but when
I try to run WebODM, I get the same ‘Exceeded max retries error’.

[Saijin_Naib]

I don’t think there is a problem with v1.9.7 Build 32 since we’ve not recieved widespread reports of issues with pgsql when running native.

I think a full uninstall, removal of the installation directory, removal of the %AppData%/Roaming/WebODM directory, and a reset of your Windows Defender Firewall should do the trick.

[Gordon]

I fully uninstalled, removing all traces of WebODM, then installed 1.9.0, which I was able to start, then updated to 1.9.7 build 32, and I’m now attempting the 6894 image (resized X0.5) set again. I’ll report on how it goes!

[Gordon]

No luck, failed to process.
Back to the invalid stoi argument, but that’s no doubt due to not replacing the file as advised by Piero again after re-installing!