From owner-svn-ports-all@freebsd.org Thu Jun 23 05:20:42 2016 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 2BFFDB72732; Thu, 23 Jun 2016 05:20:42 +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 03F492A05; Thu, 23 Jun 2016 05:20:41 +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 u5N5Kf2q076283; Thu, 23 Jun 2016 05:20:41 GMT (envelope-from pi@FreeBSD.org) Received: (from pi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id u5N5KfLB076281; Thu, 23 Jun 2016 05:20:41 GMT (envelope-from pi@FreeBSD.org) Message-Id: <201606230520.u5N5KfLB076281@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: pi set sender to pi@FreeBSD.org using -f From: Kurt Jaeger Date: Thu, 23 Jun 2016 05:20:41 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r417343 - 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.22 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: Thu, 23 Jun 2016 05:20:42 -0000 Author: pi Date: Thu Jun 23 05:20:40 2016 New Revision: 417343 URL: https://svnweb.freebsd.org/changeset/ports/417343 Log: databases/cego: 2.30.7 -> 2.30.11 - Fix in CegoRecoveryManager::recoverTableSet, the lsn was incremented which lead to leaks in the transaction log. This could result in an incomplete recovery procedure - Improvements for tableset recovery, external log manage field is checked in CegoAdminThread::medRecover before restore procedure is started. - Fix in CegoLogManager::logAction, if online redo log is full, the current log entry has to be written anyway, otherwise a checkpoint is written and subsequent logAction call in CegoTableManager::logIt might lead to duplicate entries in case of a crash recovery - Fixes for query and table cache added (addEntry method was still not clean) - Added tableset runstate CHECKPOINT to be set during a tableset checkpoint is performed. Since this is a critical section in terms of data consistency, no system crash should occur while writing a checkpoint. If so, the tableset now is marked with status CHECKPOINT and cannot be used anymore ( tableset recovery from backup required ) - Patch in CegoDistManager::startTableSet, before starting redo log file recovery, the tableset state has to be set to RECOVERY Otherwise, occupied redo logs are not archived by the log manager. This problem might occur in case of a crash recovery with archive mode set to ON - Patch in CegoQueryCache and CegoTableCache ( for each method addEntry ) The usedSize calculation was not done correctly for replaces entries - Added table and cache used size information to show tableset admin command This indicates the amount of memory, which is already allocated for cached data - Added synrchonization for query and table cache handling. The lack of synchronization might lead to core dumps, if a cache entry is freed but also be used by a query So before cache cleanup, it has to be checked, if the corresponding cache entry is still in use If so, it has to be wait, until the cache is clean. For both caches ( query and table), the similar logic is used - Added improvement for query cache handling If a stored function, which are used in the cached query, was modified, the cache entry will be invalidated For this, the CegoSelect::getTableList method was changed to CegoSelect::getObjectList and also the used functions are evaluated and added to this list. - Adapted sysmtexp and sysmtimp X-port utilities for current schema definition - Cache cleanup in CegoQuery class is performed now AFTER the modifying action.Otherwise, it may appear, that a cache entry is made after cache cleanup but also before the modifying action. This may lead to wrong results retrieved from obsolete query cache Submitted by: Bjoern Lemke Modified: head/databases/cego/Makefile head/databases/cego/distinfo Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Thu Jun 23 05:12:44 2016 (r417342) +++ head/databases/cego/Makefile Thu Jun 23 05:20:40 2016 (r417343) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.30.7 +PORTVERSION= 2.30.11 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Thu Jun 23 05:12:44 2016 (r417342) +++ head/databases/cego/distinfo Thu Jun 23 05:20:40 2016 (r417343) @@ -1,3 +1,3 @@ -TIMESTAMP = 1465626730 -SHA256 (cego-2.30.7.tar.gz) = 13e143c7920e83d8e8f7c759c847832265dba84d8db47d547585aad95de033af -SIZE (cego-2.30.7.tar.gz) = 1396808 +TIMESTAMP = 1466621042 +SHA256 (cego-2.30.11.tar.gz) = 4cf0c1d7e7d65d1ef33f01b7ccd4df80bee78006699b38cf66a2d409dab071fe +SIZE (cego-2.30.11.tar.gz) = 1399013