From owner-svn-ports-all@freebsd.org Sat Nov 7 09:28:23 2015 Return-Path: Delivered-To: svn-ports-all@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 5180BA26B1C; Sat, 7 Nov 2015 09:28:23 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 2281C1D36; Sat, 7 Nov 2015 09:28:23 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id tA79SMnu076502; Sat, 7 Nov 2015 09:28:22 GMT (envelope-from pi@FreeBSD.org) Received: (from pi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id tA79SMg9076499; Sat, 7 Nov 2015 09:28:22 GMT (envelope-from pi@FreeBSD.org) Message-Id: <201511070928.tA79SMg9076499@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: pi set sender to pi@FreeBSD.org using -f From: Kurt Jaeger Date: Sat, 7 Nov 2015 09:28:22 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r400974 - head/databases/cego X-SVN-Group: ports-head MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 07 Nov 2015 09:28:23 -0000 Author: pi Date: Sat Nov 7 09:28:21 2015 New Revision: 400974 URL: https://svnweb.freebsd.org/changeset/ports/400974 Log: databases/cego: 2.26.7 -> 2.26.9 - Version passed concurrent load test with 10 million concurrent operations ( random insert, update and delete on one table with 2 processes ) - Fix in CegoFileHandler::allocatePage, In case of page exceed with appendMode = true, a second try is done with appendMode = false - Small fix in CegoObjectManager::reorgObject, ref page id information for append mode is set to new last page id - Small fix in CegoSelect::filterRefs, allow expressions with constant values ( getAttrRefList= 0 ) in aggregation - Locking improvements for delete and update operations. All delete operations are done now via transactions ( introduced CegoTableManager::deleteDataTableAtomic ). This allows to use a shared lock as the table lock for using the table (CegoDistManager::deleteLocalDataTable and CegoDistManager::updateLocalDataTable ) As a result, a table can be accessed in parallel during a ( long running ) delete operation on the table( e.g. delete from table). E.g. select count(*) from table will not block anymore, rather indicates the remaining number of tuples in the table. This modification is still under investigation and must verfied ( also in combination with btree/index objects on the table ) - Fix in CegoBTreeManager::deleteBTree, the relevance value was not calculated correctly Fix in CegoQuery, cache invalidation is done before query operations. Otherwise, if the query is aborted, an exception is thrown and the cache is not cleaned - Small modifications on cgblow load simulation client - Changed locking for delete an update operations to exclusive due to concurrency prpblems with btree operations - Added page locking to AVLIndexManager and AVLIndexCursor - Improvements for locking done. Since locking is done on page level, Insert and delete operations can be done now in parallel . For this locking had to be introduced in CegoBtreeManager::insertBTree and CegoBTreeManager::deleteBTree Further performance path for grouping queries in CegoGroupSpace. Since the current grouping key is stored now in the class variable _groupSchema, some expensive list copy operations could be avoided. This improves performance for about 4%. Submitted by: Bjoern Lemke Modified: head/databases/cego/Makefile head/databases/cego/distinfo head/databases/cego/pkg-plist Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/Makefile Sat Nov 7 09:28:21 2015 (r400974) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.26.7 +PORTVERSION= 2.26.9 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/distinfo Sat Nov 7 09:28:21 2015 (r400974) @@ -1,2 +1,2 @@ -SHA256 (cego-2.26.7.tar.gz) = 9843a5f00cdc0b806a1e2fc65b8124b36b88d6a2a9cdb3fcc405603d5dcf272b -SIZE (cego-2.26.7.tar.gz) = 1226686 +SHA256 (cego-2.26.9.tar.gz) = 31f38e21226ff20cd5fc81db7568297a6e8364f652e0c6276c19931aaeab7ef7 +SIZE (cego-2.26.9.tar.gz) = 1227953 Modified: head/databases/cego/pkg-plist ============================================================================== --- head/databases/cego/pkg-plist Sat Nov 7 07:35:37 2015 (r400973) +++ head/databases/cego/pkg-plist Sat Nov 7 09:28:21 2015 (r400974) @@ -137,5 +137,6 @@ lib/libcgwrap.so.2.0.0 %%DATADIR%%/cgbackup %%DATADIR%%/cgmkdb %%DATADIR%%/cgrecover +%%DATADIR%%/cgsimload %%DATADIR%%/startdb %%DATADIR%%/stopdb