07:48 Kurt Jaeger (pi)  Author: Björn Lemke

databases/cego: update 2.47.3 -> 2.47.6 and devel/lfcbase: 1.16.1 -> 1.16.2

lfcbase:
- Added HashT::getRangePos and HashT::RemovePos for more efficient
  hash array manipulation

cego:
- Fix in CegoQueryCacheEntry::cleanCache, reset of all relevant
  variables. Furthermore, in CegoQueryCache methods, remove from
  hasharray is checked for return code true
- Usage of new HashT methods ( getRangePos and RemovePos ) for
  CegoQueryCache to remove entries from query cache array more efficient
- Fix in CegoFactor::evalFieldValue(), for case CegoFactor::QUERY,
  the fetched value must be saved to a local copy, otherwise the
  buffer could be overwritten by the subsequent nextTuple method call
  to complete the query for query cache. As a result, wrong values
  are returned in case of heavy buffer cache relocation.

    5aa5b64

19:13 pi 

databases/cego: upgrade 2.44.14 -> 2.45.0

- Added table alias feature to grammar definition. Table aliases
  allow alternate table name and attribute name definitions for a
  table ( create alias ... )
- Added classes CegoAliasObject and CegoAttrAlias for table alias handling
- Implemented base semantic actions for creating, listing and
  describe alias objects ( still no usage )
- In CegoDistManager::registerObjects, added registration for fkey,
  check, trigger and alias
- Added alias mapping for insert, update and delete queries (
  CegoQueryHelper::mapAliasPredicate still to implement )
- Basic alias mapping for select works, here's a sample SQL script
  drop if exists table t1;
  list alias;
  desc alias a1;
  drop if exists alias a1;
  create table t1 ( a int, b string(30));
  create alias a1 on t1 ( a as ax, b as bx );
  insert into a1 ( ax, bx ) values ( 1, 'XXX');
  insert into a1 ( ax, bx ) values ( 2, 'YYY');
  insert into a1 ( ax, bx ) values ( 3, 'ZZZ');
  select ax from a1;
- More work on table alias handling. Now works with more sophisticated
  select queries ( e.g. select ax from a1 aa where aa.ax = 1; ) For
  this, some fixes had to be done in CegoContentObject, since the the
  table alias attribute ( _tabAlias ) was not setup in constructor
  and other methods
- Added alias and trigger xml export and import feature ( trigger
  xport was still not implemented ) Fix in CegoDbThread::loadObjects
  for trigger reload, instead of triggerList.Next(), triggerList.First()
  was called, which result in an infinite loop in case of existing
  trigger objects
- Added trigger and alias object handling to CegoXPorter binary
  export and import

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

13:31 pi 

devel/lfcbase: update 1.11.9 -> 1.13.0
devel/lfcxml: update 1.2.6 -> 1.2.10
databases/cego: update 2.39.16 -> 2.44.1
databases/cegobridge: update 1.4.0 -> 1.5.0
databases/p5-DBD-cego: update 14.0 -> 1.5.0

- Warning: storage format has changed
  Export to xml format before upgrade and re-import after the upgrade
  See UPDATING
- recompile all applications linked to libcego
- Lots of changes, among them:
  o improved crash recovery
  o fixes to SQL expected behaviour
  o better CDATA handling
  o fixes primary key handling design issue
  o changes to serialisation for export/import, XML export/import is still
    possible

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Changelog:	http://www.lemke-it.com/litexec?request=pubnews&user=&lang=en&numlog=1000

 

18:53 pi 

databases/cego: update 2.38.20 -> 2.39.1

- Introduced table locking statements to set an explicit lock on a
  table ( e.g. for update synchronisation ). This feature replaces
  the "set update sync on/off" command
- Trigger implementation basically completed
- Fix in CegoQueryHelper::encodeFVL, for blob/clob values lists,
  the corresponding index variables ( blobidx/clobidx ) have not been
  increaed while encoding lob data. This might lead to invalid results
  and seg faults in case of multiple lobs values in one insert/update
  operation.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

18:06 pi 

devel/lfcbase: update 1.9.1 -> 1.9.2
databases/cego: update 2.32.14 -> 2.33.0

lfcbase:
- Added CommandExecuter::executeStream method to catch stdout for
  any forked process
- Added class OutStream to catch stdout from forked programs via popen

cego:
- Added database verify006 to check multidimensional btrees also in
  combination of null value handling.
- Fix in CegoObjectCursor::getNext, double method call for unlockData removed
- Small grammar correction to treat distinct flag for select-star statement
- Fix in CegoBTreeCursor::compValue, null values have not been handled
  correctly. For string values, string termination was not clean, which
  also might lead to wrong cursor results
- Introduced archive manager, which can be triggered, to perform
  an online backup. For now, online backups have to be triggered
  externally.
  The achive manager should make backup / restore handling more convenient
- Update to version 2.33.0 since the backup feature changes the product
  specification.
- Integration of newly introduced lfcbase OutStream class to catch output
  from backup manager. This allows to indicate a more detailed
  output from backup manager on the admin console.

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

15:59 pi 

devel/lfcbase: 1.7.0 -> 1.7.2
databases/cego: 2.28.3 -> 2.29.1
databases/cegobridge: 1.1.1 -> 1.1.2

Please note: Updating cego databases needs an export/import
             cycle for 2.28 -> 2.29

lfcbase:
- Fix in Datetime.cc, added include config.h, otherwiese the local
  implementation of strptime ist used. This should just be done, if
  the system API does not provide this call ( e.g. MINGW ) .
- Memory leak fixed in File::readLine

cego:
- Started with clob datatype implementation
- Fix in CegoSelect constructor, _cacheEnabled var was not initialized
  in the decoding constructor, which might lead to core dumps in case
  of recovery of complex with enabled querycache Fix in CegoAdminThread
  constructor, disableAuth method for TableManger called, otherwise
  tableset recovery might fail with auth error
- Required network protocol expansions done for clob handling
  (putclob, getclob, delclob)
- More work on clob handling. A fix was done for update operations
  on clob values in CegoTableManager::updateTuple method. Before
  updating the tuple, all clob references must be cloned, otherwise
  in case of untouched clobs, references are invalid. This approach
  is brute force, better would be, to stay on the untouched clob
  references. But in terms of transaction and recovery handling,
  this is not trivial
- Very long strings are handled now in CegoAction and CegoClient
  to also parse large clob values
- Modification in cgclt for raw mode, Now just plain data is listed,
  with the command line option --raw=X, a separator token can be setup
  as a column separator

cegobridge:
- fix build problem

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

09:28 pi 

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 <lemke@lemke-it.com>

 

06:19 pi 

databases/cego: 2.24.4 -> 2.25.0

- Added throw statement for stored procedures. This allows to throw
  exceptions on application level

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

08:37 pi 

databases/cego: 2.23.12 -> 2.24.3

- Implemented query cache
 
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en&section=cgdoc_cgadm.html#cgadm_querycache
- SQL keywords can now be used case-insensitive, with proper CSMODE
 
http://www.lemke-it.com/litexec?request=pubcegodoc&user=&lang=en&section=cgdoc_database_running.html#compatattr

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

 

20:48 pi 

databases/cego: 2.23.0 -> 2.23.1

Added some missing include files to be installed

Submitted by:	Bjorn Lemke <lemke@lemke-it.com>

 

06:01 pi 

databases/cego: 2.22.0 -> 2.23.0

- Introduced CegoDatabaseFormater.
  Since the API has changed (proagation of database formatting methods),
  this is 2.23.0

Submitted by:	Bjorn Lemke <lemke@lemke-it.com>

 

16:52 pi 

databases/cego: 2.20.19 -> 2.20.20

- Added fork+setsid system calls to daemon mode
- rc.d script is now part of the distribution

Submitted by:	lemke@lemke-it.com (author)

 

10:41 bapt 

Cleanup plist

 

20:14 pi 

databases/cego: 2.20.9 -> 2.20.10, USES libtool, strip libs

Submitted by:	lemke@lemke-it.com

 

04:55 danilo 

- Update from 2.19.6 to 2.19.7 [1]
- Add stage support [1]
- Convert LIB_DEPENDS to new syntax

PR:		ports/183128
Submitted by:	Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1]

 

09:31 zeising 

Move devel/lfc to devel/lfcbase, to avoid conflicts with other software using
liblfc as name. [1]
Update devel/lfcbase to 1.5.4: [1]
  Several shared lib issues were addressed
  The license was changed from GPLv2 to GPLv3.

Update devel/lfcxml to 1.1.3 and chase the move of devel/lfc [2]

Update devel/dragon to 1.3.10 and chase the move of devel/lfc [3]

Update databases/cego to 2.18.6 and chase the move of devel/lfc [4]
  Several shared lib issues were addressed.
  The license was changed from GPLv2 to GPLv3.

Update databases/my2cego to 1.1.3 and chase the move of devel/lfc [5]
  Updated the autoconf setup
  Changed License from GPLv2 to GPLv3

PR:		ports/178745 [1]
		ports/178746 [2]
		ports/178747 [3]
		ports/178752 [4]
		ports/178754 [5]
Submitted by:	Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer) [1-5]

 

06:48 culot 

- Update to 2.13.2 [1]
- Fix plist

PR:             ports/169589 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)

19:20 culot 

- Update to 2.13.0

Changes:        http://www.lemke-it.com/cego_blog.html
PR:             ports/167838
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)

12:57 culot 

- Update to 2.10.10 [1]
- Add missing entries to pkg-plist (cgbackup, cgmkdb and cgrecover)

PR:             ports/159054 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)

22:42 pav 

- Fix typo

Reported by:    pointyhat
Pointy hat to:  bapt (for committing without testing)

13:01 bapt 

fix plist

Reported by:    pointyhat (pav and erwin)

09:54 bapt 

- update to 2.8.3
- use of USERS/GROUPS macros
- add rc script

PR:             ports/155405
Submitted by:   Kurt Jaeger <fbsd-ports _at_ opsec.eu> (maintainer)

23:15 makc 

Update to 2.6.14

PR:             ports/150677
Submitted by:   Kurt Jaeger (maintainer)

22:41 lwhsu 

- Update to 2.6.8

PR:             ports/149779
Submitted by:   Kurt Jaeger <fbsd-ports AT opsec.eu> (maintainer)

16:27 sahil 

- Update to 2.6.4 [1]
- Remove redundant DISTNAME assignment
- Remove license files from pkg-plist

PR:             ports/148518 [1]
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)

13:31 sylvio 

- Update to 2.6.3

PR:             ports/148298
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe:   yes

14:40 sylvio 

- Update to 2.6.2

PR:             ports/148298
Submitted by:   Kurt Jaeger <fbsd-ports@opsec.eu> (maintainer)
Feature safe:   yes

05:49 miwi 

Cego is a Relational Database Management System (RDBMS). Cego
supports transactional SQL query requests in a multithreaded
architecture. For high availablility requirements, Cego supports a
database shadowing feature. Several compute nodes can be defined in
a Cego database configuration, where each node is able to manage a
number of so called table sets. For each tableset, a backup node
can be defined, which runs is recover mode for the corresponding
tableset. If required, the tableset can be switched to the backup
node and this node gets the active node for the tableset.

Many more details are available at:

WWW: http://www.lemke-it.com/

PR:             ports/147822
Submitted by:   Kurt Jaeger <fbsd-ports at opsec.eu>
Feature safe:   yes