Error while creating database and indexes

Post Reply
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

Error while creating database and indexes

Post by gaurav.shetti »

Hi,
I am getting the following error mess while creating a new database and creating indexes onto it.

error while creating database :
176 2010-01-04 12:46:47 [mount_creation]:107: Table files1_10_0 already exists in data dictionary in the function createdbtbl
000 2010-01-04 12:46:47 [mount_creation]:107: SQLPrepare() failed with -1 in the function prepntexis

what I understand from this is that the name of that file already exists. but I dont have such a table created.

Error while creating index:
100 2010-01-04 12:46:52 [mount_creation]:114: BTREE Index /libraries/mnt/searchfiler/db/ldblive_10/xfilecounter_files1_10_0 already exists on files1_10_0(id) in the function createindex
000 2010-01-04 12:46:52 [mount_creation]:114: SQLPrepare() failed with -1 in the function prepntexis

Can you please explain where these index and table have been created.

Regards,
Jitish
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

Error while creating database and indexes

Post by gaurav.shetti »

How can I check which all tables are present in the data dictionary?
How do I delete the entries in the data dictionary?

Are these error mess just warnings and can be ignored?
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Error while creating database and indexes

Post by mark »

They are errors in the sense that the requested table or index was not created because one by that name already exists.
Post Reply