Hi @bayo99
I have a restart policy set to always in my docker-compose(file)/docker run(command) for a Docker container, the container will automatically restart if it stops or crashes. Since then I had just one restart of docker container.
But In order to find out why container is going down, I have taken error logs of the server before server gets restarted by running this command,
docker logs --until "2025-01-04T13:42:28.455325565Z" metabase | grep "ERROR"
which has given me the logs until container gets restarted.
Listing down few logs (10 mins prior logs before container crashed)
2025-01-04 13:29:49,046 ERROR middleware.catch-exceptions :: Error processing query: ERROR: operator does not exist: interval <= integer
"Error executing query: ERROR: operator does not exist: interval <= integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 514",
"ERROR: operator does not exist: interval <= integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 514",
2025-01-04 13:29:58,013 ERROR middleware.catch-exceptions :: Error processing query: ERROR: operator does not exist: interval * interval
"Error executing query: ERROR: operator does not exist: interval * interval\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 715",
"ERROR: operator does not exist: interval * interval\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 715",
2025-01-04 13:31:30,709 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:31:35,215 ERROR middleware.catch-exceptions :: Error processing query: ERROR: cannot cast type interval to integer
:error "Error executing query: ERROR: cannot cast type interval to integer\n Position: 963",
:error "ERROR: cannot cast type interval to integer\n Position: 963",
2025-01-04 13:32:52,264 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:33:30,991 ERROR middleware.catch-exceptions :: Error processing query: ERROR: aggregate function calls cannot be nested
:error "Error executing query: ERROR: aggregate function calls cannot be nested\n Position: 186",
:error "ERROR: aggregate function calls cannot be nested\n Position: 186",
2025-01-04 13:33:53,455 ERROR notification.send :: [Notification 365] Error sending notification!
2025-01-04 13:34:49,990 ERROR notification.send :: [Notification 365] Error sending notification!
2025-01-04 13:34:55,639 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:35:16,623 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:36:18,087 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:36:38,093 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:36:58,919 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:37:19,527 ERROR middleware.process-userland-query :: Error saving field usages
2025-01-04 13:37:22,929 ERROR middleware.catch-exceptions :: Error processing query: ERROR: operator does not exist: interval = integer
"Error executing query: ERROR: operator does not exist: interval = integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 854",
"ERROR: operator does not exist: interval = integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 854",
2025-01-04 13:38:05,010 ERROR middleware.catch-exceptions :: Error processing query: Cannot run the query: missing required parameters: #{"YEAR" "MONTH"}
2025-01-04 13:40:18,426 ERROR middleware.catch-exceptions :: Error processing query: ERROR: operator does not exist: interval = integer
"Error executing query: ERROR: operator does not exist: interval = integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 370",
"ERROR: operator does not exist: interval = integer\n Hint: No operator matches the given name and argument types. You might need to add explicit type casts.\n Position: 370",
2025-01-04 13:41:04,691 ERROR middleware.catch-exceptions :: Error processing query: Cannot run the query: missing required parameters: #{"P_Name"}
2025-01-04 13:41:10,225 ERROR middleware.catch-exceptions :: Error processing query: Cannot run the query: missing required parameters: #{"property_name"}