Chris Wiita wrote: > Alright, that makes sense. The first time I ran the script the error > was different, and in repeating the script, I never noticed it was way > off in the first place! I turned logging, dropped both BASE2 DBs and > recreated them, and ran initdb.sh. It was successful. Confirmed the > databases were present with myphpadmin, and made no login attempts > (didn't want to touch the db). I ran the migrate script, and this is > the error. It managed to get through the UserTransfers--this is log from > the last user transfer, before it moves onto the next part, where it fails. > > >>>>> > 11:54:39,164 INFO migration:77 - UserTransfer: Assigning role Share > With World to user : Yuhei > 11:54:39,237 INFO migration:77 - RoleTransfer: getRoleIds: 251658196 > 11:54:39,259 INFO migration:77 - UserTransfer: Assigning role Power > user to use r : Ezra > 11:54:39,265 INFO migration:77 - UserTransfer: Assigning role Plugin > Administra tor to user : Ezra > 11:54:39,280 INFO migration:77 - UserTransfer: Assigning role File > Formats Admi nistrator to user : Ezra > 11:54:39,287 INFO migration:77 - UserTransfer: Assigning role > Hybridizations Vi ewer to user : Ezra > 11:54:39,295 INFO migration:77 - UserTransfer: Assigning role > Biomaterials View er to user : Ezra > 11:54:39,301 INFO migration:77 - UserTransfer: Assigning role Share > With World to user : Ezra > 11:54:39 0 : 18 100% 4 00:00:00 > 11:54:39 ------------------------------------------------- > 11:54:39 Creating home directories > 11:54:39 Left Done Items/s ETE > 11:54:39 18 : 0 0% > 11:54:39 0 : 18 100% 18 00:00:00 > 11:54:39 ------------------------------------------------- > 11:54:39,915 INFO migration:77 - Migrater: startTransfer: Group > 11:54:39 Group > 11:54:40,060 INFO migration:68 - Free memory : 360 MByte > 11:54:40 Left Done Items/s ETE > 11:54:40 1 : 0 0% > 11:54:40,325 INFO migration:68 - Free memory : 382 MByte > 11:54:40 0 : 1 100% 1 00:00:00 > 11:54:40 ------------------------------------------------- > 11:54:40,329 INFO migration:77 - Migrater: startTransfer: Wizzzard > 11:54:40 Wizzzard > 11:54:40,463 INFO migration:68 - Free memory : 383 MByte > 11:54:40 Left Done Items/s ETE > 11:54:40 16 : 0 0% > 11:54:40,481 INFO migration:77 - WizzzardTransfer: setSharedItemData: 15 > setSharedItemData : 15 > [EMAIL PROTECTED] bin]# > >>>>> > > Any ideas what may be the cause here? This BASE1 was set up before I > started administering this system, but it was pristine as far as I > know. I upgraded a few times, and there was never any issue with the > database (or issues at all, for that matter). Thanks for any help!
I really don't know what is going on. But, it turns out that the migration program is really sensitive about the correctness of the Base1 database. What I suspect is that in your databases there are relations from one item to another that no longer exists. Can you help me verify this? First, check the 'Wizzzard' table for any entry which has gid=15. Then, check the 'UserGroup' table and look for an entry with id=15 and isAccount=0. If what I suspect is true, you will not be able to find that in the UserGroup table. /Nicklas ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]