Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Informix > Informix 11 Upg...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 14262 of 15119
Post > Topic >>

Informix 11 Upgrade with ER failed - help please - broken sysmaster

by "Jarrod Teale" <Jarrod.Teale@[EMAIL PROTECTED] > Jul 1, 2008 at 03:33 PM

This is a multi-part message in MIME format.

------_=_NextPart_001_01C8DB2B.3D99D751
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 sup****ted" which is really unhelpful
We are looking at reverting and trying again, but after a quick answer.
=20
Thanks
Jarrod Teale
MES Team Lead=20
Fonterra New Zealand.
=20
=20
....
....
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
=20
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
=20
....
....
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).
=20
=20

------_=_NextPart_001_01C8DB2B.3D99D751
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2975" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>We =
have a number of=20
supposedly identical systems running 10.00.UC3 on RedHat=20
Linux.</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>We are =
in the=20
process of upgrading these to 11.10.UC2W2 - and have hit a=20
roadblock.</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>7=20
servers&nbsp;upgraded fine - no problem</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>The =
eighth one has=20
the following error in the online log. It is a leaf node in the =
Enterprise=20
Replication set we have (and yes "cdr stop" was run before the upgrade=20
happened).</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>The =
server is online=20
and working - but ER can't connect (even with a delete server and define =
server)=20
- we get "This feature of Enterprise Replication is not yet sup****ted" =
which is=20
really unhelpful</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>We are =
looking at=20
reverting and trying again, but after a quick =
answer.</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>Jarrod =

Teale</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>MES =
Team Lead=20
</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2>Fonterra New=20
Zealand.</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2>11:38:23&nbsp; Error=20
building 'sysmaster' database.<BR>11:38:23&nbsp; See=20
'/tmp/buildsmi.26669'.</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2>Unfortunately, that=20
file does not exist</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2>11:38:31&nbsp;=20
'sysadmin' database built successfully.<BR>11:38:31&nbsp; SCHAPI: =
Started=20
dbScheduler thread.<BR>11:38:31&nbsp; SCHAPI: Started 2 dbWorker=20
threads.<BR>11:38:31&nbsp; Loading Module =
&lt;SPLNULL&gt;<BR>11:38:31&nbsp;=20
SCHAPI: Error -206 The specified table (sysmaster:sysactptnhdr) is not =
in the=20
database.<BR>11:38:31&nbsp; SCHAPI: Type: SENSOR, Name: =
mon_table_profile,=20
Location: NULL.<BR>11:38:31&nbsp; SCHAPI: Error -111 ISAM error:&nbsp; =
no record=20
found.<BR>11:38:31&nbsp; SCHAPI: Type: SENSOR, Name: mon_table_profile,=20
Location: NULL.<BR>11:38:31&nbsp; SCHAPI: Error -206 The specified table =

(sysmaster:syscheckpoint) is not in the database.<BR>11:38:31&nbsp; =
SCHAPI:=20
Type: SENSOR, Name: mon_checkpoint, Location: NULL.<BR>11:38:31&nbsp; =
SCHAPI:=20
Error -111 ISAM error:&nbsp; no record found.<BR>11:38:31&nbsp; SCHAPI: =
Type:=20
SENSOR, Name: mon_checkpoint, Location: NULL.<BR>11:38:31&nbsp; SCHAPI: =
Error=20
-1214 Value exceeds limit of SMALLINT precision<BR>11:38:31&nbsp; =
SCHAPI: Type:=20
SENSOR, Name: mon_vps, Location: NULL.<BR>11:38:31&nbsp; SCHAPI: Error =
-206 The=20
specified table (sysmaster:sysnetworkio) is not in the=20
database.<BR>11:38:31&nbsp; SCHAPI: Type: SENSOR, Name: mon_users, =
Location:=20
NULL.<BR>11:38:31&nbsp; SCHAPI: Error -111 ISAM error:&nbsp; no record=20
found.<BR>11:38:31&nbsp; SCHAPI: Type: SENSOR, Name: mon_users, =
Location:=20
NULL.<BR>&nbsp;...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...<BR>11:38:46&nbsp; (32) connection rejected - no calls =
allowed for=20
cdraccept<BR>11:38:52&nbsp; Logical Log 4284 Complete, timestamp:=20
0x4a862e48.<BR>11:38:54&nbsp; Checkpoint Completed:&nbsp; duration was 0 =

seconds.<BR>11:38:54&nbsp; Tue Jul&nbsp; 1 - loguniq 4285, logpos 0x18,=20
timestamp: 0x4a863133 Interval: 4<BR>&nbsp;<BR>11:38:54&nbsp; Maximum =
server=20
connections 2<BR>11:38:54&nbsp; Checkpoint Statistics - Avg. Txn Block =
Time=20
0.000, # Txns blocked 0, Plog used 5737, Llog used =
23633</FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial size=3D2>Tried =
"cdr start" at=20
this point.<BR>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2>...</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2><BR>11:39:07&nbsp;=20
CDR Initialization failed (sysmaster is not ready).</FONT></SPAN></DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial =
size=3D2>11:39:30&nbsp;=20
SCHAPI: Error -206 The specified table (sysmaster:sysenv) is not in the=20
database.<BR>11:39:30&nbsp; SCHAPI: Type: STARTUP SENSOR, Name: =
mon_sysenv,=20
Location: NULL.<BR>11:39:30&nbsp; SCHAPI: Error -111 ISAM error:&nbsp; =
no record=20
found.<BR>11:39:30&nbsp; SCHAPI: Type: STARTUP SENSOR, Name: mon_sysenv, =

Location: NULL.<BR>11:39:35&nbsp; CDR Initialization failed (sysmaster =
is not=20
ready).</FONT></SPAN></DIV>
<DIV>&nbsp;</DIV>
<DIV><SPAN class=3D818042703-01072008><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV></BODY></HTML>

------_=_NextPart_001_01C8DB2B.3D99D751--
 




 3 Posts in Topic:
Informix 11 Upgrade with ER failed - help please - broken sysmas
"Jarrod Teale"   2008-07-01 15:33:30 
Re: Informix 11 Upgrade with ER failed - help please - broken sy
Madison Pruet <mpruet1  2008-07-01 04:04:28 
Re: Informix 11 Upgrade with ER failed - help please - broken sy
Madison Pruet <mpruet1  2008-07-01 05:40:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:35:46 CST 2008.