Errors found on postgresql log

gandalf · March 19, 2023, 5:54pm

Hello.

I found the next in the postgresql log, I researched online but not find anything that helped me identify what the problem is.

Best regards

2023-03-18 19:30:58.980 CST [18312] ERROR: resolution must be greater than 2
2023-03-18 19:30:58.980 CST [18312] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:30:58.994 CST [18312] ERROR: resolution must be greater than 2
2023-03-18 19:30:58.994 CST [18312] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.377 CST [20171] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.377 CST [20171] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.377 CST [18312] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.377 CST [18312] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.395 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.395 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.493 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.493 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.527 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.527 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.536 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.536 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.537 CST [18312] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.537 CST [18312] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.543 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.543 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:00.547 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:31:00.547 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:08.687 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:31:08.687 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:08.736 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:31:08.736 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:31:08.788 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:31:08.788 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:34.174 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:33:34.174 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:34.175 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:33:34.175 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:34.200 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:33:34.200 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:40.787 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:33:40.787 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:40.791 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:33:40.791 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:43.069 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:33:43.069 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:43.077 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:33:43.077 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:44.888 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:33:44.888 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:33:44.892 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:33:44.892 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:38:42.131 CST [178] LOG: could not receive data from client: Connection timed out
2023-03-18 19:38:42.131 CST [79] LOG: could not receive data from client: Connection timed out
2023-03-18 19:38:42.135 CST [142] LOG: could not receive data from client: Connection timed out
2023-03-18 19:38:42.135 CST [140] LOG: could not receive data from client: Connection timed out
2023-03-18 19:51:32.275 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.275 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:32.360 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.360 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:32.448 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.448 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:32.680 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.680 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:32.682 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.682 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:32.727 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:32.727 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:34.783 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:51:34.783 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:34.784 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:34.784 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:34.795 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:34.795 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.060 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.060 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.128 CST [20197] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.128 CST [20197] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.169 CST [20171] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.169 CST [20171] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.172 CST [20151] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.172 CST [20151] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.185 CST [23341] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.185 CST [23341] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:39.187 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:39.187 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:43.449 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:43.449 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:43.450 CST [20171] ERROR: resolution must be greater than 2
2023-03-18 19:51:43.450 CST [20171] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:43.453 CST [20151] ERROR: resolution must be greater than 2
2023-03-18 19:51:43.453 CST [20151] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:50.813 CST [20171] ERROR: resolution must be greater than 2
2023-03-18 19:51:50.813 CST [20171] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:50.818 CST [20097] ERROR: resolution must be greater than 2
2023-03-18 19:51:50.818 CST [20097] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 19:51:50.819 CST [20151] ERROR: resolution must be greater than 2
2023-03-18 19:51:50.819 CST [20151] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:09:22.468 CST [25101] ERROR: resolution must be greater than 2
2023-03-18 20:09:22.468 CST [25101] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:09:22.493 CST [25101] ERROR: resolution must be greater than 2
2023-03-18 20:09:22.493 CST [25101] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:09:22.551 CST [25101] ERROR: resolution must be greater than 2
2023-03-18 20:09:22.551 CST [25101] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:20:30.561 CST [25076] ERROR: resolution must be greater than 2
2023-03-18 20:20:30.561 CST [25076] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:20:30.584 CST [25101] ERROR: resolution must be greater than 2
2023-03-18 20:20:30.584 CST [25101] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:20:30.912 CST [25101] ERROR: resolution must be greater than 2
2023-03-18 20:20:30.912 CST [25101] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:28:27.240 CST [30930] FATAL: password authentication failed for user “postgres”
2023-03-18 20:28:27.240 CST [30930] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
2023-03-18 20:43:13.460 CST [30061] ERROR: resolution must be greater than 2
2023-03-18 20:43:13.460 CST [30061] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:43:13.547 CST [30061] ERROR: resolution must be greater than 2
2023-03-18 20:43:13.547 CST [30061] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:43:13.631 CST [30061] ERROR: resolution must be greater than 2
2023-03-18 20:43:13.631 CST [30061] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:58:42.352 CST [33315] ERROR: resolution must be greater than 2
2023-03-18 20:58:42.352 CST [33315] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:58:42.441 CST [33315] ERROR: resolution must be greater than 2
2023-03-18 20:58:42.441 CST [33315] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 20:58:42.453 CST [35076] ERROR: resolution must be greater than 2
2023-03-18 20:58:42.453 CST [35076] STATEMENT: select * from public.unnest((select public.lttb(timestamp::timestamptz, value::double precision, $1) from asset_datapoint where ENTITY_ID = $2 and ATTRIBUTE_NAME = $3 and TIMESTAMP >= $4 and TIMESTAMP <= $5))
2023-03-18 21:46:03.247 CST [43999] LOG: the “timescaledb” extension is not up-to-date
2023-03-18 21:46:03.247 CST [43999] HINT: The most up-to-date version is 2.10.1, the installed version is 2.9.1.
2023-03-18 21:53:36.067 CST [45253] LOG: invalid length of startup packet
2023-03-18 21:53:36.222 CST [45272] LOG: invalid length of startup packet
2023-03-18 21:53:36.379 CST [45273] FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
2023-03-18 22:18:17.225 CST [49469] LOG: the “timescaledb” extension is not up-to-date
2023-03-18 22:18:17.225 CST [49469] HINT: The most up-to-date version is 2.10.1, the installed version is 2.9.1.
2023-03-18 22:54:39.605 CST [55606] FATAL: password authentication failed for user “postgres”
2023-03-18 22:54:39.605 CST [55606] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
2023-03-19 01:20:29.432 CST [80173] FATAL: password authentication failed for user “postgres”
2023-03-19 01:20:29.432 CST [80173] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
2023-03-19 02:52:24.656 CST [95679] LOG: invalid length of startup packet
2023-03-19 03:45:54.154 CST [104683] FATAL: password authentication failed for user “postgres”
2023-03-19 03:45:54.154 CST [104683] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
2023-03-19 06:04:22.375 CST [127981] FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
2023-03-19 06:04:22.522 CST [127982] FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
2023-03-19 06:04:22.677 CST [127983] FATAL: no PostgreSQL user name specified in startup packet
2023-03-19 06:11:56.514 CST [129266] FATAL: password authentication failed for user “postgres”
2023-03-19 06:11:56.514 CST [129266] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
2023-03-19 08:36:07.958 CST [153474] FATAL: password authentication failed for user “postgres”
2023-03-19 08:36:07.958 CST [153474] DETAIL: Connection matched pg_hba.conf line 100: “host all all all scram-sha-256”
^C
or@debian-s-2vcpu-4gb-intel-nyc1-01-limpio-v2:~$

martin.peeters · March 21, 2023, 2:33pm

Thanks for sharing! Just had the same issue on my local machine.

Apparently the manager UI has a bug where it tries to downsample the queried datapoints to 0.
Other than the console showing errors I did not discover any weird behavior in the UI though.
Will look into it!

gandalf · March 22, 2023, 6:21pm

Hello Martin, thanks for your answer.

In order to provide a better problem description I follow the next steps.

11:24 a.m. reboot the VPS.

11:25 a.m. clean the logs for postgresql and manager containers.

11:26 a.m. check logs for postgresql and manager containers are empty.

11:27 a.m. Open a browser window to access openremote as regular user.

11:36 a.m. OR began to restart every one or two minutes.

To document the problem, I attached the postgresql and manager containers logs files from 11:42 a.m. and an screenshot from the Android app. I have a video from the browser screen buy is not accepted to upload.

Best regards.

manager_1.log (13.9 KB)
postgresql_1.log (33.3 KB)

martin.peeters · March 23, 2023, 12:24pm

Thank you for the detailed description!

The origin from the errors is the Manager UI itself, causing the database to get confused.
In your case it even manages to crash the database connection for some reason.
Fixing that frontend issue will probably solve it.

I’ll let you know when a fix is available

Rich · March 23, 2023, 3:00pm

Think you have your manager and postgres log file names mixed up but looking at those it looks like something is killing the postgres process which could be due to lack of system resources.

What type of machine is your docker engine running on?

gandalf · March 23, 2023, 5:02pm

Hello Rich.

Thanks for your response.

I am using a DigitalOcean Droplet 2 CPS’s 4GB ram Debian 11, is a host just for Openremote only.

I attached a screenshot of top command taken just few minutes ago. The last reboot of this VPS was yesterday at 11:24 a.m.

Any information you and the team need to address this issue, just tell me.

Best regards.

gandalf · March 24, 2023, 4:37pm

Hello.

The issue could have been caused by malware.

Ref : OR platform DB backup and restore

Let’s see how my new installation will work

Kind regards.