Skip to content

NFSrods stuck in SQL error when postgresql server restarts #223

Description

@technics3

We had a couple of issues with NFSrods lately where we could not access our share. When watching our logs, it just shows the following :

irods-client-nfsrods  | 2026-03-31 07:33:44.820 ERROR Thread-28 [ReadWriteAclAllowlist] - Catalog SQL error
irods-client-nfsrods  | 2026-03-31 07:33:54.819 ERROR Thread-28 [ReadWriteAclAllowlist] - Catalog SQL error
irods-client-nfsrods  | 2026-03-31 07:34:04.819 ERROR Thread-28 [ReadWriteAclAllowlist] - Catalog SQL error

This error appears every 10 seconds and is never seems to recover, even if iRods works perfectly fine.
This morning i finally understood that this behaviour happens when i restart my PostgreSQL database, which iRods has no problem with.

I'm using v2.3.1.
My server.json config :

{
    "nfs_server": {
        "port": 2049,
        "irods_mount_point": "/devZone",

        "user_information_refresh_time_in_milliseconds": 1000,
        "file_information_refresh_time_in_milliseconds": 1000,
        "user_access_refresh_time_in_milliseconds": 1000,
        "object_type_refresh_time_in_milliseconds": 1000,
        "user_permissions_refresh_time_in_milliseconds": 1000,
        "user_type_refresh_time_in_milliseconds": 1000,
        "list_operation_query_results_refresh_time_in_milliseconds": 1000,
        "allow_overwrite_of_existing_files": true,

        "using_oracle_database": false
    },
    "irods_client": {
        "zone": "devZone",
        "host": "<REDACTED>",
        "port": 1247,
        "default_resource": "<REDACTED>",
        "ssl_negotiation_policy": "CS_NEG_REFUSE",
        "connection_timeout_in_seconds": 600,
        "proxy_admin_account": {
            "username": "rods",
            "password": "<REDACTED>"
        }
    }
}

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions