[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Problems with McKoi

To: mckoidb@xxxxxxxxx
Subject: Problems with McKoi
From: "Jos van Roosmalen" <Jos@xxxxxxxxxxx>
Date: Mon, 5 Feb 2001 16:42:23 +0100
CC: tobias Downer <toby@xxxxxxxxx>
Delivered-To: mailing list mckoidb@mckoi.com
Mailing-List: contact mckoidb-help@mckoi.com; run by ezmlm
Organization: PosWare Group
Priority: normal
Reply-To: mckoidb@xxxxxxxxx
Sender: mckoidb@xxxxxxxxx
Hello Tobias,

We have a problem with McKoi we use a pretty large 
database(arround 45 MB), 43 MB is used by one file with moderate 
column size.

Starting up takes 16 seconds om PIII 800 MHz with 256 MB. If we 
immediately shutdown the database(by calling the server again 
with the shutdown flag),it takes more than 1 minute to close down.

We start and stop, we don't do any write-operations. 

QUESTION 1: Why is closing down taking that much time?

We have a pretty complex query running on our 43 MB Table(all 
indexes, some are VARCHAR, some are INTEGERs) which 
contains >162000 records<

SELECT FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD6,FIELD7 
FROM table WHERE FIELD1='            3'  ORDER BY FIELD5 
DESC, FIELD7 DESC, FIELD6 DESC, FIELD2 DESC, FIELD3

This query seems to lock up. CPU ussage and I/O activity increase 
but after some minutes decline, and read/write operations ends....

Why is CPU ussage declining? Can we enable any debugoption to 
get out where the query is?? (can't find in the source!?)  So that the 
database show what it's doing in the query? 

Do you have any debug-McKoi version which flood the screen with 
what it is doing?

Thanks!

Jos

 
*** Debug log started: Mon Feb 05 16:15:22 GMT+01:00 2001 ****
% Internal Data Cache size:          4194304
% Internal Data Cache max cell size: 16192
% Max worker threads set to: 4
% lookup_comparison_list = enabled
% read_only = disabled
% table_lock_check = disabled
% soft_index_storage = disabled
% dont_synch_filesystem = disabled
% transaction_error_on_dirty_select = enabled
% No regex library loaded.
% No 'function_factories' config property found.
% Starting Database Server: ../database
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 0sUSRPrivAdd took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 1sUSRPrivAlter took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 2sUSRPrivRead took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 3sUSRPassword took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 4sUSRUserPriv took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 5PRODUKT took 1320ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 6ACTOPTIE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 7ACTPRIORITEIT took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 8ACTSOORT took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 9AKTIVITEIT took 820ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 11ATITEL took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 12CATEGORIE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 13EPLUT took 50ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 14INFOCODE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 15PERSONEEL took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 16PRODONDCODE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 17PRODSERVICE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 18ACTBINNEN took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 19RELATIE took 60ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 20RELATIECODE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 21RELINFO took 3460ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 22TITEL took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 23UREN took 2630ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 24UURCODE took 0ms.
> com.mckoi.database.MasterTableDataSource ( lvl: 10 )
  Opening scan for 25AKTVOORTGANG took 4620ms.
% Polling frequency: 3ms.
> com.mckoi.database.jdbcserver.JDBCDatabaseInterface ( lvl: 10 )
  Authenticate User: admin
> com.mckoi.database.jdbcserver.JDBCDatabaseInterface ( lvl: 10 )
  Query From User (admin)
> com.mckoi.database.jdbcserver.JDBCDatabaseInterface ( lvl: 10 )
  Query: SHUTDOWN
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  Locked into ** EXCLUSIVE MODE **
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  Locked Tables
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  UnLocked from ** EXCLUSIVE MODE **
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  UnLocked Tables
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  Locked into ** EXCLUSIVE MODE **
> com.mckoi.database.LockingMechanism ( lvl: 10 )
  UnLocked from ** EXCLUSIVE MODE **
[ TIME: Mon Feb 05 16:16:04 GMT+01:00 2001 ]
% java.io.IOException: Stream closed.
	at java.net.PlainSocketImpl.available(Unknown Source)
	at java.net.SocketInputStream.available(Unknown Source)
	at
com.mckoi.util.LengthMarkedBufferedInputStream.pollForCommand
(LengthMarked
BufferedInputStream.java:192)
	at
com.mckoi.database.jdbcserver.StreamJDBCServerConnection.requ
estPending(St
reamJDBCServerConnection.java:108)
	at
com.mckoi.database.jdbcserver.StreamJDBCServerConnection.proc
essRequest(St
reamJDBCServerConnection.java:147)
	at
com.mckoi.database.jdbcserver.ConnectionPoolServer$1.run(Conne
ctionPoolSer
ver.java:216)
	at 
com.mckoi.database.WorkerThread.run(WorkerThread.java:175)
> 
com.mckoi.database.jdbcserver.ConnectionPoolServer$ServerFarm
er ( lvl: 20 )
  IOException generated while checking connections, removing 
provider.
[ TIME: Mon Feb 05 16:16:04 GMT+01:00 2001 ]
% java.io.IOException: Stream closed.
	at java.net.PlainSocketImpl.available(Unknown Source)
	at java.net.SocketInputStream.available(Unknown Source)
	at
com.mckoi.util.LengthMarkedBufferedInputStream.pollForCommand
(LengthMarked
BufferedInputStream.java:192)
	at
com.mckoi.database.jdbcserver.StreamJDBCServerConnection.requ
estPending(St
reamJDBCServerConnection.java:108)
	at
com.mckoi.database.jdbcserver.ConnectionPoolServer$ServerFarm
er.checkCurre
ntConnections(ConnectionPoolServer.java:199)
	at
com.mckoi.database.jdbcserver.ConnectionPoolServer$ServerFarm
er.run(Connec
tionPoolServer.java:358)
> com.mckoi.runtime.BootMain ( lvl: 10 )
  Shutting down database at: Mon Feb 05 16:16:05 GMT+01:00 
2001
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: sUSRPrivAdd
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 0sUSRPrivAdd
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: sUSRPrivAlter
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 1sUSRPrivAlter
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: sUSRPrivRead
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 2sUSRPrivRead
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: sUSRPassword
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 3sUSRPassword
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: sUSRUserPriv
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 4sUSRUserPriv
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: PRODUKT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 5PRODUKT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 22
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: ACTOPTIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 6ACTOPTIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: ACTPRIORITEIT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 7ACTPRIORITEIT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: ACTSOORT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 8ACTSOORT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: AKTIVITEIT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 9AKTIVITEIT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 27
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: ATITEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 11ATITEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: CATEGORIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 12CATEGORIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 8
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: EPLUT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 13EPLUT
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 76
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: INFOCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 14INFOCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: PERSONEEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 15PERSONEEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 24
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: PRODONDCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 16PRODONDCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: PRODSERVICE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 17PRODSERVICE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: ACTBINNEN
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 18ACTBINNEN
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: RELATIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 19RELATIE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 36
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: RELATIECODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 20RELATIECODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 6
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: RELINFO
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 21RELINFO
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 10
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: TITEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 22TITEL
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 5
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: UREN
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 23UREN
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 11
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: UURCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 24UURCODE
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 6
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchonize Index File: AKTVOORTGANG
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Synchronizing index header for: 25AKTVOORTGANG
> com.mckoi.database.MultiVersionTableIndices ( lvl: 10 )
  Deleting sectors in index file: 11
[ TIME: Mon Feb 05 16:17:10 GMT+01:00 2001 ]
% java.net.SocketException: socket closed
	at java.net.PlainSocketImpl.socketAccept(Native Method)
	at java.net.PlainSocketImpl.accept(Unknown Source)
	at java.net.ServerSocket.implAccept(Unknown Source)
	at java.net.ServerSocket.accept(Unknown Source)
	at 
com.mckoi.database.jdbcserver.TCPServer$1.run(TCPServer.java:1
31)
> com.mckoi.database.jdbcserver.TCPServer$1 ( lvl: 20 )
  Socket listen thread died.


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-unsubscribe@mckoi.com
Prev by Date: Re: The log of our huge query
Next by Date: Some errors in the parser
Prev by thread: Some errors in the parser
Next by thread: Error in documentation
Index(es):
- Date
- Thread