[Info-ingres] E_DM0055_NONEXT during relocatedb

Roy Hann specially at processed.almost.meat
Fri Apr 3 10:10:40 UTC 2020


This is re Ingres SPARC SOLARIS Version II 11.0.0 (su9.us5/100).

I have a database with over 1,600 tables scattered over a dozen or
more locations. I need to create a couple of test databases containing
only about 20 of those tables. The required tables take up about 17Gb.

I started with a clone of the full database and ran a script to drop all
but the tables I require for testing. (That script ran into some issues
of its own but eventually it dropped them, leaving me with just the
ones I wanted.)

When I run
  
  relocatedb coredb -new_database=p2o

it goes for about 15 minutes and I can see the data files being created
in the p2o directories. But once it looks like it has finished (based on
the space used), I get

customer_host  ::[II_JSP            , 22499     ,  00000001012a4200, dmfjsf.c
:3642         ]: Fri Apr  3 10:15:08 2020 I_DM105D_JSP_INFO     A user is runnin
g relocdb coredb -new_database=p2o
customer_host  ::[II_JSP            , 22499     ,  00000001012a4200, dm1r.c:2
525           ]: Fri Apr  3 10:43:39 2020 E_DM0055_NONEXT       No more data sat
isfies request.
customer_host  ::[II_JSP            , 22499     ,  00000001012a4200, dmfreloc
.c:739        ]: Fri Apr  3 10:43:40 2020 E_DM1507_RELOC_ERR    Error occurred w
hile processing the DATABASE relocation request.

It then destroys the database it just created.

Have I done something foolish to cause this? (I can't think what is even
in my hands to get right or wrong here.)

Roy





More information about the Info-ingres mailing list