SQLA 11 100% cpu on dbstop

We are running a SQLAnywhere 11.0.1.2376 engine on Windows as a service. 
Then from a separate machine, we do a "dbstop ..." trying to stop this 
database engine.

1 out of 4 times the dbstop cannot complete.  The engine goes into 100% CPU 
state and dbstop does not return.  The service status shows: "Stop pending" 
for the database engine.  The system event log shows:

    SQLANYs_Database: Normal shutdown of service SQLANYs_Database

Is this a known problem?

What we want to achieve is to swap the database file that is running on this 
engine.  I.e. we prepared another database file with updated data.  We want 
to stop the existing database and put the new database in.  Is there another 
way to do this?

Thanks.

-- Jiang Wu
   jwu@retrevo.com
 

0
Jiang
1/12/2011 6:38:36 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

2 Replies
697 Views

Similar Articles

[PageSpeed] 36

Hello Jiang,

On 12/01/2011 1:38 PM, Jiang Wu wrote:
> We are running a SQLAnywhere 11.0.1.2376 engine on Windows as a service.
> Then from a separate machine, we do a "dbstop ..." trying to stop this
> database engine.
>
> 1 out of 4 times the dbstop cannot complete. The engine goes into 100%
> CPU state and dbstop does not return. The service status shows: "Stop
> pending" for the database engine. The system event log shows:

There are a number of operations the database server must perform once a 
shut-down has been triggered - it is possible that these events are 
taking a 'long time'.

To start, any open transactions for open connections will need to be 
rolled back and the rollback log applied: 
http://dcx.sybase.com/index.html?r=1#1200en/dbadmin/da-backup-dbs-5662212.html

A checkpoint also needs to occur: 
http://dcx.sybase.com/index.html?r=1#1200en/dbadmin/da-backup-dbs-5657414.html

---

Do you have a console log (-z -o) from the time that the server is 
taking a 'long time' (how long do you normally wait?) and what it's 
actually doing once it has received a stop request?

> What we want to achieve is to swap the database file that is running on
> this engine. I.e. we prepared another database file with updated data.
> We want to stop the existing database and put the new database in. Is
> there another way to do this?

There are many ways to 'merge' new data; we would have to know more 
about your business case to better understand your requirements and the 
'best' way to achieve them.

Regards,

-- 
Jeff Albion, Sybase iAnywhere, an SAP Company

iAnywhere Developer Community : 
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs : 
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/
0
Jeff
1/14/2011 8:02:28 PM
"Jeff Albion [Sybase iAnywhere]" <firstname.lastname@sybase.com> wrote in 
message news:4d30abd4$1@forums-1-dub...
>
> Do you have a console log (-z -o) from the time that the server is taking 
> a 'long time' (how long do you normally wait?) and what it's actually 
> doing once it has received a stop request?
>

I don't have the log right now.  I will enable it for the next time.

For this database, we use -m.  At the time of the stop request, it is not 
doing much.  The transaction log file size is around 8k, indicating that 
checkpoint has finished.

When the database stops normally, it will take a few seconds. When it hits 
this loop condition, it will never stop.  We have this on a test system that 
schedules the stop.  It can be in the 100% cpu state for the entire weekend 
and still running on Monday.  We have to kill the engine process manually 
each time.

We are going to try using "STOP DATABASE ..." through a dbisql connection 
next to see if that works.

-- Jiang Wu
   jwu@retrevo.com

 

0
Jiang
1/15/2011 6:44:45 PM
Reply:

Similar Artilces:

Smoke [5.13.11] v5.13.11-100-g167630b FAIL(F) openbsd 4.8 (i386/1 cpu)
Automated smoke report for 5.13.11 patch 167630b6ab7e291cbd4f89943a3aec8d6a1ecbfc v5.13.11-100-g167630b p5openbsd: AMD Athlon(tm) Processor ("AuthenticAMD" 686-class, 256KB L2 cache) (909 MHz) (i386/1 cpu) on openbsd - 4.8 using cc version 4.2.1 20070719 smoketime 17 hours 40 minutes (average 2 hours 12 minutes) Summary: FAIL(F) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m =...

Smoke [5.13.11] v5.13.11-100-g167630b FAIL(XF) freebsd 8.1-RELEASE (i386/1 cpu)
Automated smoke report for 5.13.11 patch 167630b6ab7e291cbd4f89943a3aec8d6a1ecbfc v5.13.11-100-g167630b qemu386freebsd8-1.bandsman.co.uk: QEMU Virtual CPU version 0.14.50 (i386/1 cpu) on freebsd - 8.1-RELEASE using cc version 4.2.1 20070719 [FreeBSD] smoketime 1 hour 8 minutes (average 1 hour 8 minutes) Summary: FAIL(XF) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (...

Smoke [5.22.0] v5.21.11-100-gb1fc79b FAIL(c) linux 3.18.11-v7+ [debian] (armv7l/4 cpu)
Automated smoke report for 5.22.0 patch b1fc79bc3a6f2a33f65f540b7bc05288fced5eae v5.21.11-100-gb1fc79b pi2.bandsman.co.uk: ARMv7 Processor rev 5 (v7l) ( 0MHz) (armv7l/4 cpu) on linux - 3.18.11-v7+ [debian] using ? unknown cc version smoketime 9 seconds (average 4.500 seconds) Summary: FAIL(c) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t = make tes...

11.1 CPU 100% when PC is idle
I've searched for what I'm experiencing but can't find any hits. I did a clean install from the GNOME Live CD. When my PC sits idle for a few minutes (about 5) the CPU goes to 100% and stays there still I touch a key, mouse etc... Every time it's 3 processes in this order and approximate CPU utilization beagled - about 35% dbus-deamon - about 30% hald - 13% the next processes are gnome-system-monitor (5%) and then X (4%)....but they always consume about this much. The moment I touch a key those top three fall off the charts. -- z06steve ----------...

openSuSE-11.1 100% CPU Usage
Hi folks. I'm running openSuSE-11.1 under VMware Fusion on Mac OS X 10.5.6. After the install and things having settled, the X process seems to steadily run at 100% CPU utilization, occasionally dipping to 98% but then goes back up to 100% (and in some cases, 103%). This is causing my laptop's fan to work double time, as well as creating much more heat. I've looked at and tried everything under the sun to get CPU down to idle, but no joy. I've also looked at: 'CPU usage 11.1 KDE 4.1 - openSUSE Forums' (http://tinyurl.com/9apoaz) but still no luck...

sqla 8 to sqla 11
Hi. I will soon be moving a database from sqla 8 to sqla 11. The customer wants me to send evidence that all the data elements in the sqla 8 db are in the sqla 11 db. Any ideas/thoughts/suggestions are appreciated. Thanks, Doug There are some deprecations that occurred between 8 and 11. The bridge is mostly between version 9 and 10. Version 9 was capable of running an earlier database, where version 10 introduced a number of changes and version 10+ will not run 9 or earlier databases until they are upgraded. A key note is that we do provide compatibility with older data ...

100% CPU + 100%RAM
ASA 6.03.3008 on NT4 We prepared some reports that like to consume all of the server resources. Some of them are invoked from PB, some are in stored procedures. Is there any way to set the resource limits for a user? Anything like a profile in Oracle? pb_with_hope_for_help (kb) Hi, There are some asa server switches to turn off the dynamic cache resize and specify a max cache size. Try this. Cheers, Hartmut Branz Sybase Product Support Engineering Adaptive Server Anywhere Krzysztof Bobran wrote: > ASA 6.03.3008 on NT4 > We prepared some reports tha...

100% CPU with y2base after KDE4.4 on 11.1
I just upgraded to KDE4.4 on my 11.1 system today. I did it the same way I upgraded to KDE 4.2 and 4.3 (adding the repositories, selecting the repositories in Yast, then upgrading installed packages). Didn't have any real issues with that (aside from font colors being messed up with the new dark theme, making everything hard to read), but there was a program that seemed to be converting/checking compatibility/something that went away as I was trying to read what it was displaying. Seemed like there could've been a warning or something, but as I said, colors were off and ev...

Page causes Opera 7.11 to use 100% of CPU
If I go to this link which Don provided in the post below, Opera 7.11 on W2K uses 100% of the free CPU cycles, even after the page is finished loading. As far as I can tell nothing at all is happening. If I switch to another page in another tab in Opera, the CPU goes back to normal. When I switch back, it's back to 100%. If I bring another program up in front of Opera, the CPU stays at 100%. I rebooted and it's the same thing. In Opera 7.10 on XP on another computer it's no problem. I'm using the same version of Proxomitron with the same filter set on both compu...

X process 100% CPU usage at 11.1 KDE4
Hallo all... I have a problem mith the X process. When I dont use my computer for a few minutes the X process go to 100% of my CPU on all Computers with the same OS. What is wrong? I have OpenSuse 11.1 and KDE 4.1 top.... [image: http://www.tux-welt.de/bilder/top.jpg] ps aux .... [image: http://www.tux-welt.de/bilder/ps.jpg] Sorry for my bad English. -- atreju65 ------------------------------------------------------------------------ I came here in order to find support for the same issue. Seems like it's this problem between X.org and KDE's pow...

process exe(nobody), turns on cpu load at 100% (11.2 M7)
I have problems with process exe�? in milestone 7, this process turns on the cpu load at 100%. After kill exe, cpu load is normal. Does anyone know what does the process exe? [image: http://www.imagengratis.org/images/exenobody.jpg] -- magtec ------------------------------------------------------------------------ magtec wrote: > I have problems with process exe�? in milestone 7, this process turns on > the cpu load at 100%. After kill exe, cpu load is normal. > > Does anyone know what does the process exe? > > [image: http://www.imagengratis....

Migration from SQLAnywhere 10 to SQLAnywhere 11
Do I need to migrate the database file if i want to migrate my application from SQLAnywhere 10 to SQLAnywhere 11? or a databse file created by SQLAnywhere10 will run fine under SQLAnywhere 11? Jorge, From: http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1100en%2Fsachanges_en11%2Fv10upgrade-up-sql-any-123456.html ======== Upgrading version 10.0.0 and later databases If you are upgrading from version 10.0.0 or later, you can either use the Upgrade utility or rebuild your database. Upgrading or rebuilding is an optional step because the version 11 software ...

100% CPU usage spikes
Hi there I'm running ASE 11.9.2.6 with 3 engines on a 2x2 way (2 CPU's with hyperthreading) Fedora Core 3 i386 box. Until today I was under the impression that it was a true 4 way system(!), hence the 3 engines running on 2 physical cpu's. And yes, I'm in the process of upgrading to 12.5, but budgets need to be approved etc.... One of the problem I'm experiencing is that all 3 engine processes jump to 100% CPU usage for period of up to 15 minutes for no apparent reason. Then everything is normal for hours or sometimes days. It's not due to heavy usage. S...

ASE 11.0.3 kernel 2.6.16 stuck at 100% CPU usage.
Hello, I know 11.0.3 is unsupported for quite some time, so I won't be surprised if there is no solution for my problem, but it's still peculiar. I have an 11.0.3 server that was running glibc-2.2.5 with kernel 2.6.12.6 without problems. Upgrading the kernel to 2.6.16.62 worked quite as expected, but now, every 5 or so days sybase engines take up 100% CPU continuously. The server is still responsive, works normally - apart from the odd query that takes a little longer to complete, but the load average is constantly 4+. This is obviously a rather large waste of resources (n...

Web resources about - SQLA 11 100% cpu on dbstop - sybase.sqlanywhere.general

MATLAB Documentation - MathWorks Deutschland
MATLAB is a high-level language and interactive environment for numerical computation, visualization, and programming.

GNU Octave: Function Index
GNU Octave: Function Index

Resources last updated: 12/28/2015 9:34:41 PM