Re-Register BTS.3.10 fails
Hi All,
We have an issue with Re-registering the BTS.3.10 blade on Informix 12.10.FC4
under Solaris 10.
We do regular onunloads of our databases for baselining purposes. That
function is incompatible with the BTS blade. So before we onunload, we drop
the BTS index and unregister the blade. However, now that we upgraded to
12.10.FC4, we are running into an issue where the re-registration of the blade
fails.
The error, from 'show last log', is:
blade: bts.3.10
err expct: unexpected
SQL stmt: execute procedure bts_CreateStorage("bts_index", 11);
SQL state: XIX000:-9791 : User Defined Routine (bts_createstorage) execution
failed.
Interestingly, registering bts.2.00 works fine, and then upgrading to 3.10
works!
Here is a screen grab of a full test using blademgr.
Test 1 -- re-register bts.3.10 ==> FAIL
Test 2 -- register bts.2.00, unregister & re-register bts.2.00 ==> SUCCESS
Test 3 -- register bts.3.10 ==> SUCCESS
Test 4 -- unregister & re-register bts.3.10 ==> FAIL
Test 5 -- register bts.2.00, unregister & re-register bts.3.10 ==> FAIL
-----
foghornfp_tcp>register bts.3.10 fcpang
Register module bts.3.10 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database fcpang.
Use 'show last log' for details of failures in module's scripts.
foghornfp_tcp>register bts.2.00 fcpang
Register module bts.2.00 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
DataBlade bts.2.00 was successfully registered in database fcpang.
foghornfp_tcp>unregister bts.2.00 fcpang
Unregister module bts.2.00 out of database fcpang? [Y/n]y
DataBlade bts.2.00 was successfully unregistered from Database fcpang.
foghornfp_tcp>register bts.2.00 fcpang
Register module bts.2.00 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
DataBlade bts.2.00 was successfully registered in database fcpang.
foghornfp_tcp>register bts.3.10 fcpang
Register module bts.3.10 into database fcpang? [Y/n]y
DataBlade module(s) that will be replaced by bts.3.10:
bts.2.00
Are these changes ok? [Y/n]y
Registering DataBlade module... (may take a while).
DataBlade bts.3.10 was successfully registered in database fcpang.
foghornfp_tcp>unregister bts.3.10 fcpang
Unregister module bts.3.10 out of database fcpang? [Y/n]y
DataBlade bts.3.10 was successfully unregistered from Database fcpang.
foghornfp_tcp>register bts.3.10 fcpang
Register module bts.3.10 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database fcpang.
Use 'show last log' for details of failures in module's scripts.
foghornfp_tcp>register bts.2.00 fcpang
Register module bts.2.00 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
DataBlade bts.2.00 was successfully registered in database fcpang.
foghornfp_tcp>unregister bts.2.00 fcpang
Unregister module bts.2.00 out of database fcpang? [Y/n]y
DataBlade bts.2.00 was successfully unregistered from Database fcpang.
foghornfp_tcp>register bts.3.10 fcpang
Register module bts.3.10 into database fcpang? [Y/n]y
Registering DataBlade module... (may take a while).
blademgr: ERROR: DataBlade bts.3.10 could not be registered in database fcpang.
Use 'show last log' for details of failures in module's scripts.
--------------
Database parameters set correctly with bts VP, and sbspaces defined:
SBSPACETEMP bts_temp
SBSPACENAME bts_sbspace
VPCLASS bts,num=3,noyield
10fe86d48 26 0x48001 62 5 2048 N SBA informix bts_sbspace
10fe88028 27 0xa001 63 1 2048 N U A informix bts_temp
745 kaio 9bts* 04/18 10:05:04 0.1173 94 IO Idle
Thanks,
Michael Hoffman