{"action":"created","issue":{"url":"https://api.github.com/repos/irods/irods/issues/3052","repository_url":"https://api.github.com/repos/irods/irods","labels_url":"https://api.github.com/repos/irods/irods/issues/3052/labels{/name}","comments_url":"https://api.github.com/repos/irods/irods/issues/3052/comments","events_url":"https://api.github.com/repos/irods/irods/issues/3052/events","html_url":"https://github.com/irods/irods/issues/3052","id":134315127,"number":3052,"title":"Number of children resources limited by database schema","user":{"login":"nono-gdv","id":3807669,"avatar_url":"https://avatars.githubusercontent.com/u/3807669?v=3","gravatar_id":"","url":"https://api.github.com/users/nono-gdv","html_url":"https://github.com/nono-gdv","followers_url":"https://api.github.com/users/nono-gdv/followers","following_url":"https://api.github.com/users/nono-gdv/following{/other_user}","gists_url":"https://api.github.com/users/nono-gdv/gists{/gist_id}","starred_url":"https://api.github.com/users/nono-gdv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nono-gdv/subscriptions","organizations_url":"https://api.github.com/users/nono-gdv/orgs","repos_url":"https://api.github.com/users/nono-gdv/repos","events_url":"https://api.github.com/users/nono-gdv/events{/privacy}","received_events_url":"https://api.github.com/users/nono-gdv/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/irods/irods/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"jasoncoposky","id":1790140,"avatar_url":"https://avatars.githubusercontent.com/u/1790140?v=3","gravatar_id":"","url":"https://api.github.com/users/jasoncoposky","html_url":"https://github.com/jasoncoposky","followers_url":"https://api.github.com/users/jasoncoposky/followers","following_url":"https://api.github.com/users/jasoncoposky/following{/other_user}","gists_url":"https://api.github.com/users/jasoncoposky/gists{/gist_id}","starred_url":"https://api.github.com/users/jasoncoposky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jasoncoposky/subscriptions","organizations_url":"https://api.github.com/users/jasoncoposky/orgs","repos_url":"https://api.github.com/users/jasoncoposky/repos","events_url":"https://api.github.com/users/jasoncoposky/events{/privacy}","received_events_url":"https://api.github.com/users/jasoncoposky/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/irods/irods/milestones/12","html_url":"https://github.com/irods/irods/milestones/4.2.0","labels_url":"https://api.github.com/repos/irods/irods/milestones/12/labels","id":925749,"number":12,"title":"4.2.0","description":"","creator":{"login":"trel","id":55238,"avatar_url":"https://avatars.githubusercontent.com/u/55238?v=3","gravatar_id":"","url":"https://api.github.com/users/trel","html_url":"https://github.com/trel","followers_url":"https://api.github.com/users/trel/followers","following_url":"https://api.github.com/users/trel/following{/other_user}","gists_url":"https://api.github.com/users/trel/gists{/gist_id}","starred_url":"https://api.github.com/users/trel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trel/subscriptions","organizations_url":"https://api.github.com/users/trel/orgs","repos_url":"https://api.github.com/users/trel/repos","events_url":"https://api.github.com/users/trel/events{/privacy}","received_events_url":"https://api.github.com/users/trel/received_events","type":"User","site_admin":false},"open_issues":108,"closed_issues":74,"state":"open","created_at":"2015-01-07T16:14:58Z","updated_at":"2016-02-19T13:46:43Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2016-02-17T15:41:04Z","updated_at":"2016-02-19T20:03:08Z","closed_at":null,"body":"Hello,\r\n\r\nI would like to use a deferred resource as a front-end for \"a lot\" of storage resources (think one resource per storage node, and I would like to be able to scale to a few hundred nodes). So I wrote a small script to batch-create resources:\r\n\r\n```bash\r\nfor i in $(seq 1 1000)\r\ndo\r\n  mkdir /mnt/vdb/rscs/unix${i}b\r\n  iadmin mkresc unix${i}b unixfilesystem $(hostname):/mnt/vdb/rscs/unix${i}b\r\n  iadmin mkresc passthru${i}b passthru\r\n  iadmin addchildtoresc passthru${i}b unix${i}b\r\n  iadmin addchildtoresc defer1 passthru${i}b\r\ndone\r\n```\r\nAfter about 70 resources, the last _iadmin_ command starts to fail:\r\n```\r\nERROR: rcGeneralAdmin failed with error -806000 CAT_SQL_ERR\r\n```\r\nThe SQL logs give me a more detailed explanation:\r\n```\r\n[2016-02-17 15:51:37.314 CET] ::1(60166) (irods/ICAT) [0][4/17681] ERROR:  value too long for type character varying(1000)\r\n[2016-02-17 15:51:37.314 CET] ::1(60166) (irods/ICAT) [0][4/17681] STATEMENT:  update R_RESC_MAIN set resc_children='passthru1c{};passthru1b{};passthru2b{};passthru3b{};passthru4b{};passthru5b{};passthru6b{};passthru7b{};passthru8b{};passthru9b{};passthru10b{};passthru11b{};passthru12b{};passthru13b{};passthru14b{};passthru15b{};passthru16b{};passthru17b{};passthru18b{};passthru19b{};passthru20b{};passthru21b{};passthru22b{};passthru23b{};passthru24b{};passthru25b{};passthru26b{};passthru27b{};passthru28b{};passthru29b{};passthru30b{};passthru31b{};passthru32b{};passthru33b{};passthru34b{};passthru35b{};passthru36b{};passthru37b{};passthru38b{};passthru39b{};passthru40b{};passthru41b{};passthru42b{};passthru43b{};passthru44b{};passthru45b{};passthru46b{};passthru47b{};passthru48b{};passthru49b{};passthru50b{};passthru51b{};passthru52b{};passthru53b{};passthru54b{};passthru55b{};passthru56b{};passthru57b{};passthru58b{};passthru59b{};passthru60b{};passthru61b{};passthru62b{};passthru63b{};passthru64b{};passthru65b{};passthru66b{};passthru67b{};passthru68b{};passthru69b{};passthru70b{};passthru71b{};passthru161b{}', modify_ts='01455720697' where resc_id='10588'\r\n```\r\nThis is with an iRODS server built last friday from branch 4-1-stable.\r\n"},"comment":{"url":"https://api.github.com/repos/irods/irods/issues/comments/186381856","html_url":"https://github.com/irods/irods/issues/3052#issuecomment-186381856","issue_url":"https://api.github.com/repos/irods/irods/issues/3052","id":186381856,"user":{"login":"kellerb","id":7625444,"avatar_url":"https://avatars.githubusercontent.com/u/7625444?v=3","gravatar_id":"","url":"https://api.github.com/users/kellerb","html_url":"https://github.com/kellerb","followers_url":"https://api.github.com/users/kellerb/followers","following_url":"https://api.github.com/users/kellerb/following{/other_user}","gists_url":"https://api.github.com/users/kellerb/gists{/gist_id}","starred_url":"https://api.github.com/users/kellerb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kellerb/subscriptions","organizations_url":"https://api.github.com/users/kellerb/orgs","repos_url":"https://api.github.com/users/kellerb/repos","events_url":"https://api.github.com/users/kellerb/events{/privacy}","received_events_url":"https://api.github.com/users/kellerb/received_events","type":"User","site_admin":false},"created_at":"2016-02-19T20:03:08Z","updated_at":"2016-02-19T20:03:08Z","body":"@kript, nono-gdv is correct, the child resource name lengths affect the maximum number of children a resource can have. E.g. 10 character resource names limits you to 76 children, 20 character names limits you to 43 children. (Not quite linear because of the `{};` inserted between child resource names). Wrt. future expansion, even if you originally had all the leaf resources in a single replication resource, you can always update the hierarchy to add a new parent replication resource and add your current maxed-out replication resource to it."}}