Re: Informix 11 Upgrade with ER failed - help please - broken sysmaster database

Jarrod Teale wrote:
Hi,
We have a number of supposedly identical systems running 10.00.UC3 on RedHat Linux.
We are in the process of upgrading these to 11.10.UC2W2 - and have hit a roadblock.
7 servers upgraded fine - no problem
The eighth one has the following error in the online log. It is a leaf node in the Enterprise Replication set we have (and yes "cdr stop" was run before the upgrade happened).
The server is online and working - but ER can't connect (even with a delete server and define server) - we get "This feature of Enterprise Replication is not yet supported" which is really unhelpful
We are looking at reverting and trying again, but after a quick answer.
Thanks
Jarrod Teale
MES Team Lead
Fonterra New Zealand.

The problem is not with ER, the sysmaster database was not able to be built. I'd start by running $INFORMIXDIR/etc/buildsmi as user informix.

...
...
11:38:23 Error building 'sysmaster' database.
11:38:23 See '/tmp/buildsmi.26669'.
...
...
Unfortunately, that file does not exist
...
...
11:38:31 'sysadmin' database built successfully.
11:38:31 SCHAPI: Started dbScheduler thread.
11:38:31 SCHAPI: Started 2 dbWorker threads.
11:38:31 Loading Module <SPLNULL>
11:38:31 SCHAPI: Error -206 The specified table (sysmaster:sysactptnhdr) is not in the database.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_table_profile, Location: NULL.
11:38:31 SCHAPI: Error -111 ISAM error: no record found.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_table_profile, Location: NULL.
11:38:31 SCHAPI: Error -206 The specified table (sysmaster:syscheckpoint) is not in the database.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_checkpoint, Location: NULL.
11:38:31 SCHAPI: Error -111 ISAM error: no record found.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_checkpoint, Location: NULL.
11:38:31 SCHAPI: Error -1214 Value exceeds limit of SMALLINT precision
11:38:31 SCHAPI: Type: SENSOR, Name: mon_vps, Location: NULL.
11:38:31 SCHAPI: Error -206 The specified table (sysmaster:sysnetworkio) is not in the database.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_users, Location: NULL.
11:38:31 SCHAPI: Error -111 ISAM error: no record found.
11:38:31 SCHAPI: Type: SENSOR, Name: mon_users, Location: NULL.
...
...
11:38:46 (32) connection rejected - no calls allowed for cdraccept
11:38:52 Logical Log 4284 Complete, timestamp: 0x4a862e48.
11:38:54 Checkpoint Completed: duration was 0 seconds.
11:38:54 Tue Jul 1 - loguniq 4285, logpos 0x18, timestamp: 0x4a863133 Interval: 4
11:38:54 Maximum server connections 2
11:38:54 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 5737, Llog used 23633
...
...
Tried "cdr start" at this point.
...
...

11:39:07 CDR Initialization failed (sysmaster is not ready).
11:39:30 SCHAPI: Error -206 The specified table (sysmaster:sysenv) is not in the database.
11:39:30 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
11:39:30 SCHAPI: Error -111 ISAM error: no record found.
11:39:30 SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, Location: NULL.
11:39:35 CDR Initialization failed (sysmaster is not ready).
.

Relevant Pages

  • Re: Delayed Code Execution?
    ... such as SQL Server for your application? ... I've considered upgrading it to 2005 but always a little nervous about upgrading a production server. ... Each database has no more than, say, 6 tables, with maybe two of them related and the others just lookup tables. ... I've never used stored procedures until recently when I decided to make a few to give them a try, since I heard its the more secure way to go and better performance. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Informix 11 Upgrade with ER failed - help please - broken sysmaster database
    ... We are in the process of upgrading these to 11.10.UC2W2 - and have hit a roadblock. ... The server is online and working - but ER can't connect - we get "This feature of Enterprise Replication is not yet supported" which is really unhelpful ... The problem is not with ER, the sysmaster database was not able to be built. ... 11:38:31 SCHAPI: Started dbScheduler thread. ...
    (comp.databases.informix)
  • Re: Regarding Oracle version upgrading questions
    ... Current database runs on HP-UX 11.11, ... There exist debate on upgrading Oracle8.1.7 to higher version. ... We'd like hear from those who have upgrade their oracle server, ... did oracle 10g or oracle11g just mean to improve business report ...
    (comp.databases.oracle.server)
  • Access Back End Sometimes Freezes
    ... Back end database is located on a straight PC running Windows XP Professional. ... Occasionally, when opening a bound form, the system freezes, sometimes for up to a minute. ... It happens on all of the clients, including remote via LogMeIn, so I believe I have a server problem. ... Would upgrading the server to Windows Server 2003 have any affect, ...
    (comp.databases.ms-access)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)