Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] upgrade db from 28 to 29 seems to hang

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] upgrade db from 28 to 29 seems to hang


Chronological Thread 
  • From: Jim Fox <>
  • To: "Hyzer, Chris" <>
  • Cc: "Redman, Chad" <>, "" <>
  • Subject: RE: [grouper-users] upgrade db from 28 to 29 seems to hang
  • Date: Mon, 16 Jul 2018 11:01:01 -0700 (PDT)
  • Ironport-phdr: 9a23:YjEiMxIZiklmOZLH5tmcpTZWNBhigK39O0sv0rFitYgRIvTxwZ3uMQTl6Ol3ixeRBMOHs6wC07KempujcFRI2YyGvnEGfc4EfD4+ouJSoTYdBtWYA1bwNv/gYn9yNs1DUFh44yPzahANS47xaFLIv3K98yMZFAnhOgppPOT1HZPZg9iq2+yo9JDffwRFiCChbb9uMR67sRjfus4KjIV4N60/0AHJonxGe+RXwWNnO1eelAvi68mz4ZBu7T1et+ou+MBcX6r6eb84TaFDAzQ9L281/szrugLdQgaJ+3ART38ZkhtMAwjC8RH6QpL8uTb0u+ZhxCWXO9D9QKsqUjq+8ahkVB7oiD8GNzEn9mHXltdwh79frB64uhBz35LYbISTOfFjfK3SYMkaSHJPUMhRSSJPH4GzYYgBD+UPMulXs5Lwp0cSoRakGQWgGPnixiFOi3Tr3aM6yeMhEQTe0QIkHtIOtWnfotXyNKYdTOu4y6fIzTLMbv5N1zby8pPIchAgofGKUrJwbc3RyU81Gwzbk1qQtJXoMjWI3eoOq2iW9/dsWO2zh2I9tg18rSajyt0ih4XXnI4Z11/J+TlhzIs0IdC0Ukp2bcO+HJdOuCyXN5F6T8ckTmp1oig10KcGtoS+fCUSyJQo2Rrfa/uffoiN7RPjU/uRIStmiH9rYr6wmwy9/lS6xuzyTMa0y1ZKritDktnDqnAN0BrT5tKZRfRg40etwTeP1wbN5eFYOU04iKXWJ4I7zrItmZcfr17PEyHolEnskaObeVko9vCt6+v9Y7XmopGcN5VzigH7KqkulMu/AOsjPwkARWeb4uS81Lzl/U32XLVKifs2nrPHv5/HOMQXvrS5DBNN0oY/9xa/CC+r0NsCnXkAMVJFYAyIj5LwN1HTO/D3E+2/g0+3nTdvxvDGJaHhAo7TInTZkbfhe6p95FBGyAo1099f+4xYBqsfL/3uR0+i/ODfW1UZIh652aKvI9Vn15hUETaKCa+IIq7ImV6T7aQyO+SKYskYtCureNY/4Pu7r3480XEabeH905wHQG+xBfRnJUqFZnyqj9scRzRZ9jEiRfDn3QXRGQVYYGy/Cudlvmk2



Weve switched the grouper built in daemon queries to select all the data that
needs updating, then do the updates for ~200 rows at a time (since 200 is max
bind var limit in some DBs). We haven't done this for the DDL upgrades but
maybe we should discuss it. So you could use a procedural block to do this,
do you need our help to code this?


I can delete the update from the ddl script, but if you could point me to the '200 row at a time' solution that's be great.

Jim



Archive powered by MHonArc 2.6.19.

Top of Page