COWegner

Q: Import wiki - foreign key constraint error

Hi there,

 

I have an urgent problem with importing wikis in Mountain Lion (10.8.2 / OS X Server 2.1).

 

What I did: under Lion did a "wikiadmin export", migrated a Lion Server to ML / OS X Server (10.8.2 / 2.1) and did a "wikiadmin export" again. Then I did a complete new installation of the server, erasing the disk, an installing ML 10.8.2 from scratch (copied it to an USB thumb drive before). Installed OS X Server 2.1. on top of it.

 

Now, after activationg Wikis in Server app, created a test wiki (OK) and the tried to reimport the old Wikis (from the ML export). But non succeeded. Every time the error goes like this:

 

ep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=3

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:233 75bb2180 +0ms] Executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_FATAL_ERROR] rows returned=0/updated=

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Error>: [PGCConnection:148 75bb2180 +0ms] Error in TXN: Error executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]: ERROR:  insert or update on table "file_entity" violates foreign key constraint "file_entity_data_uid_fk_fkey"

          DETAIL:  Key (data_uid_fk)=(caceea67-37ca-4cac-a1d3-160e129cb7f7) is not present in table "filedata_entity".

 

          (

                    0   CoreFoundation                      0x00007fff86b520a6 __exceptionPreprocess + 198

                    1   libobjc.A.dylib                     0x00007fff870ed3f0 objc_exception_throw + 43

                    2   PostgreSQLClient                    0x00000001086fc9ae -[PGCConnection checkResultOK:forSQL:] + 360

                    3   PostgreSQLClient                    0x00000001086fcec3 -[PGCConnection executeQuery:] + 223

                    4   wikiadmin                           0x000000010869e576 wikiadmin + 66934

                    5   PostgreSQLClient                    0x00000001086fc5f7 -[PGCConnection transactionInBlock:onError:] + 147

                    6   wikiadmin                           0x000000010869dc86 wikiadmin + 64646

                    7   wikiadmin                           0x00000001086ad6be wikiadmin + 128702

                    8   wikiadmin                           0x0000000108693fa3 wikiadmin + 24483

                    9   libdyld.dylib                       0x00007fff898e87e1 start + 0

                    10  ???                                 0x0000000000000004 0x0 + 4

          )

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:320 75bb2180 +0ms] Executing update [ROLLBACK]

Sep 26 21:10:28 server.foo.net wikiadmin[17249] <Debug>: [PGCConnection:181 75bb2180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

2012-09-26 21:10:28.413 wikiadmin[17249:707] *** Terminating app due to uncaught exception 'PGCQueryError', reason: 'Error executing query [INSERT INTO file_entity (entity_uid_fk, content_type, data_uid_fk) (SELECT entity_uid_fk, content_type, data_uid_fk FROM file_entity_scratch_20120924T174840)]: ERROR:  insert or update on table "file_entity" violates foreign key constraint "file_entity_data_uid_fk_fkey"

DETAIL:  Key (data_uid_fk)=(caceea67-37ca-4cac-a1d3-160e129cb7f7) is not present in table "filedata_entity".

'

*** First throw call stack:

(

          0   CoreFoundation                      0x00007fff86b520a6 __exceptionPreprocess + 198

          1   libobjc.A.dylib                     0x00007fff870ed3f0 objc_exception_throw + 43

          2   PostgreSQLClient                    0x00000001086fc9ae -[PGCConnection checkResultOK:forSQL:] + 360

          3   PostgreSQLClient                    0x00000001086fcec3 -[PGCConnection executeQuery:] + 223

          4   wikiadmin                           0x000000010869e576 wikiadmin + 66934

          5   PostgreSQLClient                    0x00000001086fc5f7 -[PGCConnection transactionInBlock:onError:] + 147

          6   wikiadmin                           0x000000010869dc86 wikiadmin + 64646

          7   wikiadmin                           0x00000001086ad6be wikiadmin + 128702

          8   wikiadmin                           0x0000000108693fa3 wikiadmin + 24483

          9   libdyld.dylib                       0x00007fff898e87e1 start + 0

          10  ???                                 0x0000000000000004 0x0 + 4

)

libc++abi.dylib: terminate called throwing an exception

Abort trap: 6

 

 

Please help!

 

Kind regards,

Carsten

OS X Server

Posted on Sep 26, 2012 12:24 PM

Close

Q: Import wiki - foreign key constraint error

  • All replies
  • Helpful answers