[OpenSER-Devel] [ openser-Bugs-1836601 ] db_berkeley don't work

Thu Nov 29 16:36:56 UTC 2007

Bugs item #1836601, was opened at 2007-11-22 12:18
Message generated for change (Comment added) made by will_quan
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1836601&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Henning Westerholt (henningw)
Assigned to: Will Quan (will_quan)
Summary: db_berkeley don't work

Initial Comment:
Hi,

db_berkeley don't work in trunk at the moment. 

Steps to reproduce:

$openser-trunk:/ cd test && ./18.sh 

causes:

Nov 22 19:13:57 ca ../openser[29559]: core:main: version: openser 1.3.0-pre1-notls (i386/linux)
Nov 22 19:13:57 ca ../openser[29559]: db_berkeley:bdblib_get_db: _cachedb is not initialized!
Nov 22 19:13:57 ca ../openser[29559]: db_berkeley:bdb_init: cannot get the link to database
Nov 22 19:13:57 ca ../openser[29559]: dispatcher:init_ds_db: unable to connect to the database
Nov 22 19:13:57 ca ../openser[29559]: dispatcher:mod_init: could not initiate a connect to the database
Nov 22 19:13:57 ca ../openser[29559]: core:init_mod: failed to initialize module dispatcher
Nov 22 19:13:57 ca ../openser[29559]: core:main: error while initializing modules
Nov 22 19:13:57 ca ../openser[29559]: core:qm_free: bad pointer (nil) (out of memory block!) - aborting

This is probably related to some missing/ wrong cache pointer initialization. One potential candiate could be line 59 in bdb_lib.c.

Will, could you please take a look?

Output from openser -V:

version: openser 1.3.0-pre1-notls (i386/linux)
flags: STATS: Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, SHM_MEM, SHM_MMAP, PKG_MALLOC, DBG_QM_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
poll method support: poll, epoll_lt, epoll_et, sigio_rt, select.
svnrevision: 2:3197M
@(#) $Id: main.c 3189 2007-11-22 10:43:25Z henningw $
main.c compiled on 18:28:44 Nov 22 2007 with gcc 4.1.3

Thank you,

Henning

----------------------------------------------------------------------

>Comment By: Will Quan (will_quan)
Date: 2007-11-29 10:36

Message:
Logged In: YES 
user_id=1850067
Originator: NO

Problem:
The issue was that the tables dispatcher and dialog were not created as
part of the openserdbctl create operation. The driver would try to create
the table when it did not find it in DB_PATH.

NOTE: The db_berkeley tables are not plain text and must be created before
first use, similar to mysql or postgres.

Solution (rev #3227):
1. Added the tables dialog and dispatcher to the STANDARD_TABLES list. So
now all the necessary tables are created in the DB_PATH directory.
2. Modifed the db_berkeley driver to exit if the tables are not already
created.
--will

----------------------------------------------------------------------

Comment By: Bogdan-Andrei Iancu (bogdan_iancu)
Date: 2007-11-29 02:44

Message:
Logged In: YES 
user_id=1275325
Originator: NO

Hi Will,

was your commit (rev #3227) fixing completly the bug? Can we close it
now?

Thanks and regards,
Bogdan

----------------------------------------------------------------------

Comment By: Henning Westerholt (henningw)
Date: 2007-11-26 07:31

Message:
Logged In: YES 
user_id=337916
Originator: YES

Yes, you're are right. I've fixed the test, but now i get a new error:

Nov 26 14:16:13 ca ../openser[8842]: core:main: version: openser
1.3.0-pre1-notls (i386/linux)
Nov 26 14:16:13 ca ../openser[8842]: db_berkeley:bdblib_create_table: bdb
open: Invalid argument.
Nov 26 14:16:13 ca ../openser[8842]: db_berkeley:bdblib_get_table: failed
to create table.
Nov 26 14:16:13 ca ../openser[8842]: db_berkeley:bdb_query: table does not
exist!
Nov 26 14:16:13 ca ../openser[8842]: core:table_version: error in
db_query
Nov 26 14:16:13 ca ../openser[8842]: dispatcher:init_ds_db: failed to
query table version
Nov 26 14:16:13 ca ../openser[8842]: dispatcher:mod_init: could not
initiate a connect to the database
Nov 26 14:16:13 ca ../openser[8842]: core:init_mod: failed to initialize
module dispatcher
Nov 26 14:16:13 ca ../openser[8842]: core:main: error while initializing
modules
Nov 26 14:16:13 ca ../openser[8842]: core:qm_free: bad pointer (nil) (out
of memory block!) - aborting

Cheers,

Henning

----------------------------------------------------------------------

Comment By: Daniel-Constantin Mierla (miconda)
Date: 2007-11-26 07:02

Message:
Logged In: YES 
user_id=1246013
Originator: NO

I assume it is more or less same issue as for dbtext, as this module has
kind of similar internal architecture.

----------------------------------------------------------------------

Comment By: Henning Westerholt (henningw)
Date: 2007-11-22 12:21

Message:
Logged In: YES 
user_id=337916
Originator: YES

The correct test is '17.sh'.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1836601&group_id=139143