Subject Re: [firebird-support] Failure to create primary key - 2.5, 64 bit, Linux
Author Tim Ward
Post date 2016-07-12T11:52:03Z
There was plenty of space on the disk partition containing the database.

But there had at some point been a disk full on some other partition.

So, having run out of ideas, I've deleted the database and am recreating it from backup, in the hope that just maybe it got corrupted when the other partition filled up.

On 12/07/2016 12:50, liviuslivius liviuslivius@... [firebird-support] wrote:
 
 
 
W dniu 2016-07-12 11:54:52 użytkownik Tim Ward tdw@... [firebird-support] <firebird-support@yahoogroups.com> napisał:
 

==================================================================================
> CREATE TABLE TBLCSTAGASSETS
> (
> ELEMENTID BIGINT NOT NULL,
> USERID INTEGER NOT NULL,
> CONSTRAINT PK_TBLCSTAGASSETS PRIMARY KEY (ELEMENTID, USERID)
> )

> commit

< ERROR:

unsuccessful metadata update
cannot create index PK_TBLCSTAGASSETS

> script processed in 0.055 sec
==================================================================================

This works when run against a 32 bit 2.1 database but fails when run
against a 64 bit 2.5 database. What's going on please?

--
Tim Ward

 
What exact version of FB2.5
i tested this on WI-V2.5.3.26738 Firebird 2.5 
 
but on Windows not Linux and no problems.
Do you have free disc space? May be db try to expand?
 
 
regards,
Karol Bieniaszewski
 


-- 
Tim Ward