Again on 100% cpu

Marco Martin notmart at gmail.com
Wed Nov 16 13:27:00 UTC 2011


Hi all,

this is another of those 100% cpu reports :/

this is what happens at the moment in plasma active, probably reproduceable 
elsewhere as well.

on the first run when .kde doesn't exists, virtuoso stays at 100% cpu for some 
minutes.
this could be almost expected, but randomly happens on subsequent startups as 
well: virtuoso at 100 for some minutes, then all starts to work well when the 
usage goes down again.

attached there is some status() from isql, one during the first run and the 
other two from a subsequent run, done in several seconds of distance, in the 
same run.

what seems strange is that there does not seem to be any query running and 
taking long time, so is not really clear what is doing during those minutes.

any idea? and any idea on how some more informations could be gathered?


Cheers,
Marco Martin
-------------- next part --------------
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso  Server
Version 06.01.3127-pthreads for Linux as of Nov  8 2011 
Started on: 2011/08/11 03:20 GMT-240
Lite Mode
 
Database Status:
  File size 10485760, 1280 pages, 830 free.
  2000 buffers, 414 used, 207 dirty 0 wired down, repl age 0 0 w. io 0 w/crsr.
  Disk Usage: 12 reads avg 0 msec, 0% r 0% w last  33 s, 309 writes,
    0 read ahead, batch = 0.  Autocompact 15 in 10 out, 31% saved.
Gate:  0 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. 
Log = /home/meego/.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx, 2012081 bytes
236 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 7 connects, max 2 concurrent
RPC: 38440 calls, -3 pending, 1 max until now, 0 queued, 64 burst reads (0%), 0 second brk=15458304
Checkpoint Remap 0 pages, 0 mapped back. 0 s atomic time.
    DB master 1280 total 830 free 0 remap 0 mapped back
   temp  256 total 251 free
 
Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
   Currently 2 threads running 0 threads waiting 0 threads in vdb.
Pending:
  99: IER 1:-2 
      2: IER 1:-2 
  1133: IER 1:-2 
      133: IER 1:-2 
  1134: IER 1:-2 
      184: IER 1:-2 
  1089: IER 1:-2 
      384: IER 1:-2 
 
Client 1112:7:  Account: dba, 200 bytes in, 253 bytes out, 1 stmts.
PID: 1035, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks: 
 
Client 1112:1:-2:  Account: dba, 5816189 bytes in, 3024544 bytes out, 1 stmts.
PID: 973, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
 
Running Statements:
 Time (msec) Text
           3 status()
 
 
Hash indexes
 

51 Rows. -- 14 msec.
SQL> 
-------------- next part --------------
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso  Server
Version 06.01.3127-pthreads for Linux as of Nov  8 2011 
Started on: 2011/08/11 03:26 GMT-240
Lite Mode
 
Database Status:
  File size 10485760, 1280 pages, 822 free.
  2000 buffers, 336 used, 71 dirty 0 wired down, repl age 0 0 w. io 0 w/crsr.
  Disk Usage: 185 reads avg 0 msec, 0% r 0% w last  22 s, 234 writes,
    8 read ahead, batch = 4.  Autocompact 163 in 119 out, 26% saved.
Gate:  8 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. 
Log = /home/meego/.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx, 569373 bytes
380 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 5 connects, max 2 concurrent
RPC: 31337 calls, -2 pending, 1 max until now, 0 queued, 28 burst reads (0%), 0 second brk=13565952
Checkpoint Remap 0 pages, 0 mapped back. 0 s atomic time.
    DB master 1280 total 822 free 0 remap 0 mapped back
   temp  256 total 251 free
 
Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
   Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:
 
Client 1112:5:  Account: dba, 200 bytes in, 253 bytes out, 1 stmts.
PID: 1306, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks: 
 
Client 1112:1:-2:  Account: dba, 4644658 bytes in, 3327259 bytes out, 0 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
 
Running Statements:
 Time (msec) Text
           1 status()
 
 
Hash indexes
 

43 Rows. -- 7 msec.
SQL> 
-------------- next part --------------
Connected to OpenLink Virtuoso
Driver: 06.01.3127 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> REPORT
VARCHAR
_______________________________________________________________________________

OpenLink Virtuoso  Server
Version 06.01.3127-pthreads for Linux as of Nov  8 2011 
Started on: 2011/08/11 03:26 GMT-240
Lite Mode
 
Database Status:
  File size 10485760, 1280 pages, 808 free.
  2000 buffers, 341 used, 85 dirty 1 wired down, repl age 0 0 w. io 0 w/crsr.
  Disk Usage: 185 reads avg 0 msec, 0% r 0% w last  98 s, 234 writes,
    8 read ahead, batch = 4.  Autocompact 163 in 119 out, 26% saved.
Gate:  8 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. 
Log = /home/meego/.kde/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx, 1281207 bytes
380 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 11 connects, max 6 concurrent
RPC: 70562 calls, -3 pending, 1 max until now, 0 queued, 40 burst reads (0%), 1 second brk=13565952
Checkpoint Remap 0 pages, 0 mapped back. 0 s atomic time.
    DB master 1280 total 808 free 0 remap 0 mapped back
   temp  256 total 251 free
 
Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
   Currently 1 threads running 0 threads waiting 0 threads in vdb.
Pending:
 
Client 1112:1:-6:  Account: dba, 10141 bytes in, 3878 bytes out, 1 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
Client 1112:1:-2:  Account: dba, 10589273 bytes in, 8304037 bytes out, 0 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
Client 1112:1:-8:  Account: dba, 11282 bytes in, 5549 bytes out, 1 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
Client 1112:7:  Account: dba, 200 bytes in, 253 bytes out, 1 stmts.
PID: 1334, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks: 
 
Client 1112:1:-11:  Account: dba, 568 bytes in, 475 bytes out, 0 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
Client 1112:1:-9:  Account: dba, 8081 bytes in, 14580 bytes out, 0 stmts.
PID: 1268, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 0 threads.
Locks: 
 
 
Running Statements:
 Time (msec) Text
         202 status()
           0  client not available, pending compile
           0  client not available, pending compile
 
 
Hash indexes
 

65 Rows. -- 279 msec.
SQL> 


More information about the Active mailing list