checkpoint was stalled
A user running IDS 9.40.UC1 on Red Hat saw the server blocked in CKPT REQ with the warning that the checkpoint appeared stalled; clients stopped until a restart. Art Kagel asked for onstat -l, -p, -R and -F output next time and advised upgrading to 11.70+. JJ asked about hardware age (3 years). Floyd Bortz suggested checking whether all logical logs were full and needed backing up. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
OS : redhat
ids : 9.40uc1
We run this system for 10 years without any problem.
But It got worse recently.
It had occured several time and show messages like this :
$ onstat -
Informix Dynamic Server Version 9.40.UC1 -- On-Line (CKPT REQ) Blocked:CKPT
All the clients can not work on the database .
It will be ok after I rebound the server.
And display :
Warning: checkpoint appears to be stalled and is not complete.
What happened with this ?
What should I do with it ?
Not enough information. The next time this happens, post the output from:
onstat -l
onstat -p
onstat -R
onstat -F
Also, you really should upgrade to version 11.70+
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. 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, Mar 20, 2013 at 8:21 AM, <joeclhua@gmail.com> wrote:
> OS : redhat
> ids : 9.40uc1
> We run this system for 10 years without any problem.
> But It got worse recently.
> It had occured several time and show messages like this :
> $ onstat -
> Informix Dynamic Server Version 9.40.UC1 -- On-Line (CKPT REQ)> Blocked:CKPT
>
> All the clients can not work on the database .
> It will be ok after I rebound the server.
> And display :
> Warning: checkpoint appears to be stalled and is not complete.
>
> What happened with this ?
> What should I do with it ?
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
On Wednesday, March 20, 2013 12:21:07 PM UTC, joec...@gmail.com wrote:
> OS : redhat
>
> ids : 9.40uc1
>
> We run this system for 10 years without any problem.
>
> But It got worse recently.
>
> It had occured several time and show messages like this :
>
> $ onstat ->
> Informix Dynamic Server Version 9.40.UC1 -- On-Line (CKPT REQ) Blocked:CKPT
>
>
>
> All the clients can not work on the database .
>
> It will be ok after I rebound the server.
>
> And display :
>
> Warning: checkpoint appears to be stalled and is not complete.
>
>
>
> What happened with this ?
>
> What should I do with it ?
Is the hardware also 10 years old?
JJ於 2013年3月24日星期日UTC+8上午5時44分03秒寫道： Is the hardware also 10 years old? hardware is 3 years .
Did you check to see if perhaps all of your logs are full and need backing up. It's one of the things that will prevent your checkpoint from completing.
Thanks,
Floyd Bortz
Database Analyst
Enterprise Data Management
Ocotillo Corporate Center | 2600 S. Price Rd., 4th floor | Chandler, AZ 85286
MAC S3929-047
Tel 480-724-6854 | Cell 602-541-1189
bortzf@wellsfargo.com
-----Original Message-----
From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of JJ
Sent: Saturday, March 23, 2013 2:44 PM
To: informix-list@iiug.org
Subject: Re: checkpoint was stalled
On Wednesday, March 20, 2013 12:21:07 PM UTC, joec...@gmail.com wrote:
> OS : redhat
>
> ids : 9.40uc1
>
> We run this system for 10 years without any problem.
>
> But It got worse recently.
>
> It had occured several time and show messages like this :
>
> $ onstat ->
> Informix Dynamic Server Version 9.40.UC1 -- On-Line (CKPT REQ) Blocked:CKPT
>
>
>
> All the clients can not work on the database .
>
> It will be ok after I rebound the server.
>
> And display :
>
> Warning: checkpoint appears to be stalled and is not complete.
>
>
>
> What happened with this ?
>
> What should I do with it ?
Is the hardware also 10 years old?
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list