Skip navigation

Import wiki - foreign key constraint error

443 Views 4 Replies Latest reply: Dec 2, 2012 2:16 PM by shadown RSS
COWegner Level 1 Level 1 (0 points)
Currently Being Moderated
Sep 26, 2012 12:24 PM

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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.