Cannot create database

Hi,

I am a beginner with ingres.
I can't create a new datbase with the following error:

[ingres-at-ce1] createdb testcgi -ucgi
Creating database 'testcgi' . . .

E_SC0206 An internal error prevents further processing of this query.
Associated error messages which provide more detailed information
about
the problem can be found in the error log, II_CONFIG:errlog.log
(Wed Dec 21 09:58:58 2005)


The errlog.log is:

CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:43 2005
E_CL0610_DI_DIR
NOTFOUND The directory pointed to path could not be found
Error encountered while calling opendir() with the following path
argument: (/u
sr/sgbd/ingres/dmp/default/testcgi/.). Check that directory exists and
that per
missions on all parts of path seem reasonable (ie. most programs run by
the dbm
s require that the %s user id be able to access the given file locations).
opendir() failed with operating system error 2 (No such file or directory)
CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:43 2005
E_DM91A8_DMM_LO
CV_DILISTDIR An unexpected error was encountered in the DIlistdir()
routine.
This error was encountered while trying to validate either the II_WORK,
II_DATA
BASE, and/or the auxiliary work location. The following pathname caused
the er
ror (/usr/sgbd/ingres/dmp/default/testcgi). Check that the path exists
and that
permissions on all parts of the path allow access to the %s user.
CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:43 2005
E_DM0080_BAD_LO
CATION_AREA Location area specified is not valid.
CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:44 2005
E_QE019B_DMM_CR
EATE_DB_ERROR An unexpected error was encountered while attempting to
create a
database.
CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:44 2005
E_SC0216_QEF_ER
ROR Error returned by QEF.
CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:44 2005
E_SC0206_CANNOT
_PROCESS An internal error prevents further processing of this
query.
Associated error messages which provide more detailed information about
the pro
blem can be found in the error log, II_CONFIG:errlog.log


I checked the permissions with no success
Can you help me ?

ingres 2.6

Thanks in advance

At 9:48 PM +0100 12/21/2005, astalavista wrote:
>Hi,
>
>I am a beginner with ingres.
>I can't create a new datbase with the following error:
>
>[ingres-at-ce1] createdb testcgi -ucgi
>Creating database 'testcgi' . . .
>
>E_SC0206 An internal error prevents further processing of this query.
> Associated error messages which provide more detailed information
>about
> the problem can be found in the error log, II_CONFIG:errlog.log
> (Wed Dec 21 09:58:58 2005)
>
>
>The errlog.log is:
>
>CE1 ::[60429 , 2076c040]: Wed Dec 21 22:07:43 2005
>E_CL0610_DI_DIR
>NOTFOUND The directory pointed to path could not be found
>Error encountered while calling opendir() with the following path
>argument: (/u
>sr/sgbd/ingres/dmp/default/testcgi/.).
....


I think that this can happen if directories for a database exist
before the Database is created. (manually created junk or a destroydb
that failed for some reason.)

Check xxx/ingres/yyy/default/testcgi by hand and make sure none of
them are there, if they are then rmdir them. Then try createdb again.

xxx: `ingprenv II_DATABASE` yyy: data
xxx: `ingprenv II_WORK` yyy: work
xxx: `ingprenv II_CHECKPOINT` yyy: ckp
xxx: `ingprenv II_JOURNAL` yyy: jnl
xxx: `ingprenv II_DUMP` yyy: dmp

the last one looks like the one you had trouble with, but check
them all.

Karl

PS also make sure that the directory structures are owned by user
ingres.

> I think that this can happen if directories for a database exist
> before the Database is created. (manually created junk or a destroydb
> that failed for some reason.)
>
> Check xxx/ingres/yyy/default/testcgi by hand and make sure none of
> them are there, if they are then rmdir them. Then try createdb again.
>
> xxx: `ingprenv II_DATABASE` yyy: data
> xxx: `ingprenv II_WORK` yyy: work
> xxx: `ingprenv II_CHECKPOINT` yyy: ckp
> xxx: `ingprenv II_JOURNAL` yyy: jnl
> xxx: `ingprenv II_DUMP` yyy: dmp
>
> the last one looks like the one you had trouble with, but check
> them all.
>
> Karl
>
> PS also make sure that the directory structures are owned by user
> ingres.

Thanks it was the variable II_WORK which wasn't set ...
thank you again ...