Release migration only
A DBA wanted to roll an instance back from IDS 11.50.FC4 to 11.50.FC3, but the older engine refused to start ("Cannot bring server up from a higher version server"), and onmode -b appeared to offer only older major versions. Replies noted onmode -b 11.50.xC3 does work (one user did it, though with sysadmin/AUS errors afterwards), that compression must be removed before reverting, and that onmode -b to 11.10 would also allow FC3 to boot. In the end the poster skipped the downgrade: the real issue was one slow, lock-prone database, fixed by returning its dbspace to a 2KB page size, with Art Kagel explaining that larger pages help indexes and wide/high-locality tables but can hurt delete-heavy OLTP tables.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello!
We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
but when trying to start the FC3 engine, the server returns a message:
"Cannot bring server up from a higher version server"
Is there anything missing, because the "onmode -b" application only
brings the previous versions, not 11.50...
If someone did this, and could help us, would be great!
Regards.
--
Alexandre Marini
Analista de Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
That is wierd...
I already test successfully here on development environment the downgrade from
11.50 UC4 to 11.50 UC3 , and works fine , except some errors on sysadmin what
I don't try to resolve yet... but the database is online and accessible.
$ onmode -b 11.50.xC3This will make all necessary modifications to disk structures
so that the IBM Informix Dynamic Server space will be compatible with
INFORMIX-OnLine Version 11.50.xC3
Do you wish to continue (y/n)? y
REVERSION: No reversion needed to 11.50.xC3.
Install 11.50.xC3 before reinitializing OnLine.
log on the UC4
Message Log File: /dados/IBM/ids1150uc4de/tmp/online.log
14:23:35 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 0,
Plog used 2, Llog used 2
14:28:09 SCHAPI: thread dbWorker1 task mon_config_startup(3-18) shutting down
14:28:09 SCHAPI: thread dbWorker2 task mon_sysenv(4-18) shutting down
14:28:09 SCHAPI: thread dbScheduler task mon_checkpoint(0-32) shutting down
14:28:11 Shutdown Mode
14:28:12 Quiescent Mode
14:28:12 Checkpoint Completed: duration was 0 seconds.
14:28:12 Tue Jun 16 - loguniq 38, logpos 0x99c018, timestamp: 0x414226
Interval: 214
14:28:12 Maximum server connections 0
14:28:12 Checkpoint Statistics - Avg. Txn Block Time 0.001, # Txns blocked 0,
Plog used 0, Llog used 2
14:28:13 Reversion to version 11.50.xC3 Started
14:28:13 Reverting Partition Header Pages Started
14:28:13 Reverting Partition Header Pages Succeeded
14:28:13 REVERSION: No reversion needed to 11.50.xC3.
Install 11.50.xC3 before reinitializing OnLine.
14:28:15 IBM Informix Dynamic Server Stopped.
11.50 UC3 online.. with errors on sysadmin
14:31:18 On-Line Mode
14:31:18 SCHAPI: Started dbScheduler thread.
14:31:18 Booting Language <spl> from module <>
14:31:18 Loading Module <SPLNULL>
14:31:18 SCHAPI: Warning!!! Required indexes on table AUS are missing.
14:31:18 SCHAPI: Table sysadmin:AUS is not installed correctly.
14:31:18 SCHAPI: Started 2 dbWorker threads.
14:31:18 SCHAPI: Error -640 QPlan sanity failure (3778.109).
14:31:18 SCHAPI: Type: STARTUP SENSOR, Name: mon_config_startup, Location:
NULL.
14:31:18 SCHAPI: Type: STARTUP SENSOR, Name: mon_config_startup, Error
Message: Unable to execute function [ onconfig_save_diffs(integer,integer) ] .
14:36:48 Checkpoint Completed: duration was 1 seconds.
14:36:48 Tue Jun 16 - loguniq 38, logpos 0x9aa018, timestamp: 0x4144ed
Interval: 216
--- Em ter, 16/6/09, Alexandre Marini <amarini@fazenda.ms.gov.br> escreveu:
De: Alexandre Marini <amarini@fazenda.ms.gov.br>
Assunto: Release migration only [16045]
Para: ids@iiug.org
Data: Terça-feira, 16 de Junho de 2009, 10:29
Hello!
We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
but when trying to start the FC3 engine, the server returns a message:
"Cannot bring server up from a higher version server"
Is there anything missing, because the "onmode -b" application only
brings the previous versions, not 11.50...
If someone did this, and could help us, would be great!
Regards.
--
Alexandre Marini
Analista de Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
On Tue, Jun 16, 2009 at 06:29, Alexandre Marini
<amarini@fazenda.ms.gov.br>wrote:
> We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
> but when trying to start the FC3 engine, the server returns a message:
> "Cannot bring server up from a higher version server"
>
> Is there anything missing, because the "onmode -b" application only
> brings the previous versions, not 11.50...
>
> If someone did this, and could help us, would be great!
>
Did you experiment with compression while you were using 11.50.FC4?
If so, you must manually remove all the compression before reverting.
Check the release notes very carefully.
> Alexandre Marini
> Analista de Tecnologia da Informação - DBA
> msn: alexandre_marini@hotmail.com
> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
>
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
W. C. Fields <http://www.brainyquote.com/quotes/authors/w/w_c_fields.html>;
- "If I had to live my life over, I'd live over a saloon."
--0015174c42ba3d615b046c806932
No, we didn´t implement any new feature of FC4, but I´ll try to run the
reversion utility passing the 11.50.xC3 argument,
on our test machine.
In case of any new scoop, I´ll post it here.
Thanks a lot for your attention.
Regards.
Alexandre Marini
Analista de Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
Jonathan Leffler escreveu:
> On Tue, Jun 16, 2009 at 06:29, Alexandre Marini
> <amarini@fazenda.ms.gov.br>wrote:
>
>
>> We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
>> but when trying to start the FC3 engine, the server returns a message:
>> "Cannot bring server up from a higher version server"
>>
>> Is there anything missing, because the "onmode -b" application only
>> brings the previous versions, not 11.50...
>>
>> If someone did this, and could help us, would be great!
>>
>>
>
> Did you experiment with compression while you were using 11.50.FC4?
>
> If so, you must manually remove all the compression before reverting.
>
> Check the release notes very carefully.
>
>
>> Alexandre Marini
>> Analista de Tecnologia da Informação - DBA
>> msn: alexandre_marini@hotmail.com
>> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
>>
>>
>
>
Use onmode -b to revert to 11.10 then you will be able to bring up the
11.50FC3.
What problems have you had with the .FC4 release? I'm sure all of us would
like to know.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Tue, Jun 16, 2009 at 9:29 AM, Alexandre Marini <amarini@fazenda.ms.gov.br
> wrote:
> Hello!
> We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
> but when trying to start the FC3 engine, the server returns a message:
> "Cannot bring server up from a higher version server"
>
> Is there anything missing, because the "onmode -b" application only
> brings the previous versions, not 11.50...
>
> If someone did this, and could help us, would be great!
> Regards.
>
> --
>
> Alexandre Marini
>
> Analista de Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5b184e35442046c8b50c4
Mr Art, actually we convinced the managers not to reverse our version,
because there was only one database with speed troubles, and tables locked.
We´ve made a reversion on it´s dbspace page size (returning it to the
old 2Kb size),
and now the app is running smooth, according to its manager.
His app is java-made, using JDBC to connect on a pool-conexion basis.
I´ve already found some transactional errors, but I still don´t know if
he made the corrections for the topics I suggested.
We´re extremely happy now, because the app is running smooth, according
to him.
But I´ll control his querys mainly on the transaction systems, to know
if there´s any app error still, as usual.
Thanks a lot for your interest and help.
Regards!
Alexandre Marini
Analista de Tecnologia da Informação - DBA
msn: alexandre_marini@hotmail.com
SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
Art Kagel escreveu:
> Use onmode -b to revert to 11.10 then you will be able to bring up the
> 11.50FC3.
>
> What problems have you had with the .FC4 release? I'm sure all of us would
> like to know.
>
> Art
>
> Art S. Kagel
> Oninit (www.oninit.com)
> IIUG Board of Directors (art@iiug.org)
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Oninit, the IIUG, nor any other organization
> with which I am associated either explicitly or implicitly. Neither do
> those opinions reflect those of other individuals affiliated with any entity
> with which I am affiliated nor those of the entities themselves.
>
> On Tue, Jun 16, 2009 at 9:29 AM, Alexandre Marini <amarini@fazenda.ms.gov.br
>
>> wrote:
>>
>
>
>> Hello!
>> We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
>> but when trying to start the FC3 engine, the server returns a message:
>> "Cannot bring server up from a higher version server"
>>
>> Is there anything missing, because the "onmode -b" application only
>> brings the previous versions, not 11.50...
>>
>> If someone did this, and could help us, would be great!
>> Regards.
>>
>> --
>>
>> Alexandre Marini
>>
>> Analista de Tecnologia da Informação - DBA
>>
>> msn: alexandre_marini@hotmail.com
>>
>> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
>>
>>
>>
>>
>>
>
*******************************************************************************
>
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
> --001636c5b184e35442046c8b50c4
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
>
Alexandre,
Thanks for the update. Wider pages are almost a win for indexes but for
table data it's a mixed bag that has to be carefully thought through and
planned. For tables with good locality (many active rows reside on each
page) and for tables with rows wider than a page larger pages are usually a
win. Many transactional systems do many deletes which reduces locality and
for those tables, performance is adversely affected by larger pages.
Art
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.
On Wed, Jun 17, 2009 at 11:02 AM, Alexandre Marini <
amarini@fazenda.ms.gov.br> wrote:
> Mr Art, actually we convinced the managers not to reverse our version,
> because there was only one database with speed troubles, and tables locked.
>
> We´ve made a reversion on it´s dbspace page size (returning it to the
> old 2Kb size),
> and now the app is running smooth, according to its manager.
>
> His app is java-made, using JDBC to connect on a pool-conexion basis.
>
> I´ve already found some transactional errors, but I still don´t know if
> he made the corrections for the topics I suggested.
>
> We´re extremely happy now, because the app is running smooth, according
> to him.
> But I´ll control his querys mainly on the transaction systems, to know
> if there´s any app error still, as usual.
>
> Thanks a lot for your interest and help.
> Regards!
>
> Alexandre Marini
>
> Analista de Tecnologia da Informação - DBA
>
> msn: alexandre_marini@hotmail.com
>
> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
>
> Art Kagel escreveu:
> > Use onmode -b to revert to 11.10 then you will be able to bring up the
> > 11.50FC3.
> >
> > What problems have you had with the .FC4 release? I'm sure all of us
> would
> > like to know.
> >
> > Art
> >
> > Art S. Kagel
> > Oninit (www.oninit.com)
> > IIUG Board of Directors (art@iiug.org)
> >
> > Disclaimer: Please keep in mind that my own opinions are my own opinions
> and
> > do not reflect on my employer, Oninit, the IIUG, nor any other
> organization
> > with which I am associated either explicitly or implicitly. Neither do
> > those opinions reflect those of other individuals affiliated with any
> entity
> > with which I am affiliated nor those of the entities themselves.
> >
> > On Tue, Jun 16, 2009 at 9:29 AM, Alexandre Marini <
> amarini@fazenda.ms.gov.br
> >
> >> wrote:
> >>
> >
> >
> >> Hello!
> >> We´re trying to revert an 11.50.FC4 instance to 11.50.FC3 release,
> >> but when trying to start the FC3 engine, the server returns a message:
> >> "Cannot bring server up from a higher version server"
> >>
> >> Is there anything missing, because the "onmode -b" application only
> >> brings the previous versions, not 11.50...
> >>
> >> If someone did this, and could help us, would be great!
> >> Regards.
> >>
> >> --
> >>
> >> Alexandre Marini
> >>
> >> Analista de Tecnologia da Informação - DBA
> >>
> >> msn: alexandre_marini@hotmail.com
> >>
> >> SEFAZ-MS / UIMP / Sistemas: Fronteiras e SIG-DW
> >>
> >>
> >>
> >>
> >>
> >
>
>
*******************************************************************************
> >
> >> Forum Note: Use "Reply" to post a response in the discussion forum.
> >>
> >>
> >>
> >
> > --001636c5b184e35442046c8b50c4
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
> >
> >
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001636c5a736b3f936046c8caeff