Aio don't start. returning a postgresql restart on the database

ℹ️ Support 📦 Appliances (Docker, Snappy, VM, NCP, AIO)
, ,
1

Hello Everyone!

I am using Ubuntu OS. The AIO don’t working. all container is working but only database (postgresql) returned error log:

Setting postgres values...
chmod: /var/run/postgresql: Operation not permitted

PostgreSQL Database directory appears to contain a database; Skipping initialization

2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 1, near end of line
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 2, near token "devcgroup_css_alloc"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 3, near token "__pfx_propagate_exception"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 4, near token "propagate_exception"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 5, near token "__pfx_devcgroup_update_access"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 6, near token "devcgroup_update_access"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 7, near token "__pfx_devcgroup_access_write"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 8, near token "devcgroup_access_write"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 9, near token "__pfx_devcgroup_seq_show"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 10, near token "devcgroup_seq_show"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 11, near token "__pfx_fop_dummy_read"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 12, near token "fop_dummy_read"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 13, near token "__pfx_fop_ruleset_release"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 14, near token "fop_ruleset_release"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 15, near token "__pfx_get_path_from_fd"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 16, near token "get_path_from_fd"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 17, near token "__pfx___ia32_sys_landlock_create_ruleset"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 18, near token "__ia32_sys_landlock_create_ruleset"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 19, near token "__pfx_fop_dummy_write"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 20, near token "fop_dummy_write"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 21, near token "__pfx_get_ruleset_from_fd"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 22, near token "get_ruleset_from_fd"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 23, near token "__pfx___ia32_sys_landlock_add_rule"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 24, near token "__ia32_sys_landlock_add_rule"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 25, near token "__pfx___ia32_sys_landlock_restrict_self"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 26, near token "__ia32_sys_landlock_restrict_self"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 27, near token "__pfx___x64_sys_landlock_add_rule"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 28, near token "__x64_sys_landlock_add_rule"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 29, near token "__pfx___x64_sys_landlock_create_ruleset"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 30, near token "__x64_sys_landlock_create_ruleset"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 31, near token "__pfx___x64_sys_landlock_restrict_self"
2024-05-17 09:26:01.984 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 32, near token "__x64_sys_landlock_restrict_self"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 33, near token "__pfx_landlock_create_object"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 34, near token "landlock_create_object"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 35, near token "__pfx_landlock_put_object"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 36, near token "landlock_put_object"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 37, near token "__pfx_free_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 38, near token "free_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 39, near token "__pfx_free_ruleset_work"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 40, near token "free_ruleset_work"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 41, near token "__pfx_create_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 42, near token "create_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 43, near token "__pfx_insert_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 44, near token "insert_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 45, near token "__pfx_merge_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 46, near token "merge_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 47, near token "__pfx_inherit_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 48, near token "inherit_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 49, near token "__pfx_landlock_create_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 50, near token "landlock_create_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 51, near token "__pfx_landlock_insert_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 52, near token "landlock_insert_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 53, near token "__pfx_landlock_put_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 54, near token "landlock_put_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 55, near token "__pfx_landlock_put_ruleset_deferred"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 56, near token "landlock_put_ruleset_deferred"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 57, near token "__pfx_landlock_merge_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 58, near token "landlock_merge_ruleset"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 59, near token "__pfx_landlock_find_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 60, near token "landlock_find_rule"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 61, near token "__pfx_hook_cred_free"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 62, near token "hook_cred_free"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 63, near token "__pfx_hook_cred_prepare"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 64, near token "hook_cred_prepare"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 65, near token "__pfx_task_ptrace"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 66, near token "task_ptrace"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 67, near token "__pfx_hook_ptrace_traceme"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 68, near token "hook_ptrace_traceme"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 69, near token "__pfx_hook_ptrace_access_check"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 70, near token "hook_ptrace_access_check"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 71, near token "__pfx_hook_sb_mount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 72, near token "hook_sb_mount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 73, near token "__pfx_hook_move_mount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 74, near token "hook_move_mount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 75, near token "__pfx_hook_sb_umount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 76, near token "hook_sb_umount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 77, near token "__pfx_hook_file_alloc_security"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 78, near token "hook_file_alloc_security"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 79, near token "__pfx_hook_file_truncate"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 80, near token "hook_file_truncate"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 81, near token "__pfx_hook_inode_free_security"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 82, near token "hook_inode_free_security"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 83, near token "__pfx_release_inode"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 84, near token "release_inode"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 85, near token "__pfx_hook_sb_delete.part.0"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 86, near token "hook_sb_delete.part.0"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 87, near token "__pfx_hook_sb_delete"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 88, near token "hook_sb_delete"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 89, near token "__pfx_hook_sb_remount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 90, near token "hook_sb_remount"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 91, near token "__pfx_hook_sb_pivotroot"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 92, near token "hook_sb_pivotroot"
2024-05-17 09:26:01.985 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 93, near token "__pfx_collect_domain_accesses"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 94, near token "collect_domain_accesses"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 95, near token "__pfx_is_access_to_paths_allowed"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 96, near token "is_access_to_paths_allowed"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 97, near token "__pfx_hook_path_mknod"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 98, near token "hook_path_mknod"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 99, near token "__pfx_hook_file_open"
2024-05-17 09:26:01.986 GMT [14] LOG:  syntax error in file "/var/lib/postgresql/data/postgresql.conf" line 100, near token "hook_file_open"
2024-05-17 09:26:01.986 GMT [14] LOG:  too many syntax errors found, abandoning file "/var/lib/postgresql/data/postgresql.conf"
2024-05-17 09:26:01.986 GMT [14] FATAL:  configuration file "/var/lib/postgresql/data/postgresql.conf" contains errors
2

Looks like this is your issue. I wonder how this happened

4

in /var/lib folder don’t have postgresql. Do you have any idea how can I solve that problem?. Thanks

5

/var/lib/postgresql/data inside the container is stored in the docker volume nextcloud_aio_database on the host: all-in-one/php/containers.json at de5aeb64d41b3163ad5b1905a397b1bea91700ed · nextcloud/all-in-one · GitHub
So you should be able to edit the file on the host. By default somewhere in /var/lib/docker/volumes/nextcloud_aio_database/_data/

6

Those look a bit like kernel crashes. I suspect something is going on with the underlying host or, at a minimum, the Docker installation.

No idea how they’d end up in a config file, but crashes/kernel bugs could lead to just about anything.

Check your host’s kernel log.

1 Like