0 Replies Latest reply: Dec 6, 2012 8:22 AM by krw
krw Level 2 Level 2 (175 points)

I recently upgraded from lion server to mountain lion server. Wikis did not automatically migrate. I saved old wiki data in ~/server.library.backup/Wiki/ and I tried using wikiadmin to migrate the data:

 

1. stop wiki service

2. sudo wikiadmin migrate -r server.library.backup/Wiki/

3. start wiki service

 

Now there was something moved to:

 

/Library/Server/Wiki/FileData

[root@truffula]FileData# ls -l

total 0

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 3d

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 50

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 c3

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 d1

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 e4

drwxr-x---+ 3 _teamsserver  _teamsserver  102 Dec  6 10:10 fb

 

However, it does not show up when I log into the wiki, and it is far too small

 

original files du -h

796M/Volumes/disk1/home1/kirkw/server.library.backup/Wiki/

 

new files du -h

96K.

 

Any advice on what to try next would be most appreciated. And by the way... I can create a new wiki, so I know that the sevice is working properly.

 

Here is a copy of the output form running wikiadmin migrate:

 

[kirkw@truffula]~$ sudo wikiadmin migrate -r server.library.backup/Wiki/

Password:

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [main.m:189 72665180 +0ms] Repository location appears to be a relative path (server.library.backup/Wiki), prepending --sourceRoot ()

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [main.m:192 72665180 +0ms] Repository location is server.library.backup/Wiki

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [CSConfig:54 72665180 +0ms] Reading plist at /Library/Server/Wiki/Config/collabd.plist

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:61 72665180 +4ms] -[PGCConnection connect] with [user=collab dbname=collab]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +5ms] Executing update [SET bytea_output TO escape]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [BEGIN]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +4ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:148 72665180 +0ms] Updating schema...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [SELECT * FROM entity_acls WHERE entity_uid_fk = '19A307C1-82BC-45C7-845A-21839FB222C7']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [SELECT true FROM pg_attribute WHERE attrelid='global_settings'::regclass AND attname='value_int']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [SELECT value_int FROM global_settings WHERE key = 'com.apple.setting.schema_version']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:442 72665180 +0ms] Schema updates completed.

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [COMMIT]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:770 72665180 +0ms] Migrating...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [SELECT uid FROM entity WHERE uid = $1::UUID OR tiny_id = $2 LIMIT 1] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb",

              m5v217

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [SELECT * FROM user_entity LEFT OUTER JOIN entity ON user_entity.entity_uid_fk = entity.uid WHERE external_id = $1] with params [(

              "FFFFEEEE-DDDD-CCCC-BBBB-AAAA00000000"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [UserMigrator:66 72665180 +0ms] found already migrated user 9762a4b8-713d-4336-a3a4-d24b84149828

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, long_name, ownedby_uid_fk, createdby_user_fk) VALUES ($1::UUID, $2, 'com.apple.entity.Migration', $3, $1::UUID, $4::UUID)] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb",

              m5v217,

              20121206T102050,

              "9762a4b8-713d-4336-a3a4-d24b84149828"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +5ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [INSERT INTO migration_entity (entity_uid_fk) VALUES ($1::UUID)] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE master_entity_scratch_20121206T102050 AS SELECT * FROM entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +4ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [ALTER TABLE master_entity_scratch_20121206T102050 ADD COLUMN original_location varchar]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE document_entity_scratch_20121206T102050 AS SELECT * FROM document_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE page_entity_scratch_20121206T102050 AS SELECT * FROM page_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE user_entity_scratch_20121206T102050 AS SELECT * FROM user_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE project_entity_scratch_20121206T102050 AS SELECT * FROM project_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE blog_entity_scratch_20121206T102050 AS SELECT * FROM blog_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE entity_attrs_scratch_20121206T102050 AS SELECT * FROM entity_attrs WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE entity_private_attrs_scratch_20121206T102050 AS SELECT * FROM entity_private_attrs WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE entity_acls_scratch_20121206T102050 AS SELECT * FROM entity_acls WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE file_entity_scratch_20121206T102050 AS SELECT * FROM file_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE file_data_entity_scratch_20121206T102050 AS SELECT * FROM filedata_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE entity_changesets_scratch_20121206T102050 AS SELECT * FROM entity_changesets WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE entity_comment_scratch_20121206T102050 AS SELECT * FROM entity_comment WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE saved_query_entity_scratch_20121206T102050 AS SELECT * FROM savedquery_entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE relationship_scratch_20121206T102050 AS SELECT * FROM relationship WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +2ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [CREATE TABLE subscription_scratch_20121206T102050 AS SELECT * FROM subscription WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:776 72665180 +0ms] Migrating known users

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Warning>: [UserMigrator:269 72665180 +0ms] No Users directory found. Skipping.

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:778 72665180 +0ms] Generating placeholders for all known pages and wikis

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Warning>: [ProjectMigrator:267 72665180 +0ms] No Groups directory found. Skipping.

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:780 72665180 +0ms] Found 0 pages belonging to 0 wikis and 1 users.

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:783 72665180 +0ms] Re-scanning 0 pages for pasted image/attachment URLs

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:536 72665180 +0ms] Copying content to real tables...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [BEGIN]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [SET maintenance_work_mem TO '1GB']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [DELETE FROM migrationplaceholder_entity WHERE entity_uid_fk IN (SELECT uid FROM entity WHERE ownedby_uid_fk = $1::UUID)] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:430 72665180 +0ms] Executing count query [DELETE FROM entity WHERE entity_type_fk = 'com.apple.entity.MigrationPlaceholder' AND ownedby_uid_fk = $1::UUID] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [UPDATE master_entity_scratch_20121206T102050 SET revision = 1 WHERE revision IS NULL]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [UPDATE master_entity_scratch_20121206T102050 SET is_hidden = false WHERE is_hidden IS NULL]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_blog_enabled) (SELECT uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_blog_enabled FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.Project')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, revision) (SELECT uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, revision FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.Blog')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO blog_entity (entity_uid_fk) (SELECT entity_uid_fk FROM blog_entity_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, revision) (SELECT uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, revision FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.Page')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO document_entity (entity_uid_fk, original_location) (SELECT uid, original_location FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.Page')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO page_entity (entity_uid_fk, is_detail_page, is_blogpost) (SELECT entity_uid_fk, is_detail_page, is_blogpost FROM page_entity_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO project_entity (entity_uid_fk, detail_page_fk) (SELECT entity_uid_fk, detail_page_fk FROM project_entity_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_hidden) (SELECT uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_hidden FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.FileData')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO filedata_entity(entity_uid_fk, size, uti, content_type, data_uri) (SELECT entity_uid_fk, size, uti, content_type, data_uri FROM file_data_entity_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity (uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_hidden) (SELECT uid, tiny_id, entity_type_fk, short_name, long_name, description, create_time, update_time, createdby_user_fk, updatedby_user_fk, ownedby_uid_fk, owner_entity_type_fk, is_hidden FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.File')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO document_entity (entity_uid_fk, original_location) (SELECT uid, original_location FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk='com.apple.entity.File')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +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_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_changesets (uid, entity_uid_fk, entity_revision, change_user_fk, change_action, change_type, change_time, change_comment, change_fields, change_data_bin) (SELECT uid, entity_uid_fk, entity_revision, change_user_fk, change_action, change_type, change_time, change_comment, change_fields, change_data_bin FROM entity_changesets_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_attrs (entity_uid_fk, attrs_bin) (SELECT entity_uid_fk, attrs_bin FROM entity_attrs_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_private_attrs (entity_uid_fk, attrs_bin) (SELECT entity_uid_fk, attrs_bin FROM entity_private_attrs_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DELETE FROM entity_acls WHERE entity_uid_fk IN (SELECT entity_uid_fk FROM entity_acls_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_acls (entity_uid_fk, eval_order, login, external_id, action, allow) (SELECT entity_uid_fk, eval_order, login, external_id, action, allow FROM entity_acls_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_comment (uid, parent_uids, entity_uid_fk, title, body, author_user_fk, is_approved, approvedby_user_fk, approval_time, create_time) (SELECT uid, parent_uids, entity_uid_fk, title, body, author_user_fk, is_approved, approvedby_user_fk, approval_time, create_time FROM entity_comment_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO savedquery_entity (entity_uid_fk, query_bin) (SELECT entity_uid_fk, query_bin FROM saved_query_entity_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO relationship (uid, source_uid_fk, target_uid_fk, reltype, create_time) (SELECT uid, source_uid_fk, target_uid_fk, reltype, create_time FROM relationship_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO subscription (user_uid_fk, entity_uid_fk, notification_type) (SELECT user_uid_fk, entity_uid_fk, notification_type FROM subscription_scratch_20121206T102050)]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [SELECT uid, avatar_uid_fk FROM master_entity_scratch_20121206T102050 WHERE entity_type_fk != 'com.apple.entity.User']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [COMMIT]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:641 72665180 +0ms] Destroying migration entity and scratch tables...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE master_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE document_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE page_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE user_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE project_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE entity_attrs_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE entity_private_attrs_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE entity_acls_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE file_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE file_data_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE blog_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE saved_query_entity_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE entity_changesets_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE entity_comment_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE relationship_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [DROP TABLE subscription_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [DELETE FROM migration_entity WHERE entity_uid_fk IN (SELECT uid FROM entity WHERE ownedby_uid_fk = $1::UUID)] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [DELETE FROM entity WHERE uid = $1::UUID] with params [(

              "595b8ea9-1a99-4df2-95d9-6eafac83aecb"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +7ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:669 72665180 +0ms] Done

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_attrs (entity_uid_fk) (SELECT uid FROM entity WHERE uid NOT IN (SELECT entity_uid_fk FROM entity_attrs))]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [INSERT INTO entity_private_attrs (entity_uid_fk) (SELECT uid FROM entity WHERE uid NOT IN (SELECT entity_uid_fk FROM entity_private_attrs))]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [UPDATE entity SET is_hidden = true WHERE entity_type_fk = 'com.apple.entity.User' AND is_hidden = false AND (short_name = 'unauthenticated' OR short_name = 'authenticated')]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:793 72665180 +0ms] Importing user preferences

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [CSWorkerPool:151 72665180 +5ms] All workers finished, continuing

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:702 72665180 +0ms] Rebuilding search index...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +0ms] Executing query [SELECT true FROM entity WHERE false]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [CSConnectionPool:95 72665180 +1ms] Opening DB connection

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:61 72665180 +0ms] -[PGCConnection connect] with [dbname=collab application_name=wikiadmin client_encoding=utf-8 options='-c bytea_output=escape' user=collab]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:233 72665180 +2ms] Executing query [SELECT oid FROM pg_type WHERE typname='hstore']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [SELECT array_agg(uid::varchar) FROM entity]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [CREATE TABLE search_index_scratch_20121206T102050 AS SELECT * FROM search_index LIMIT 0]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=0

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [CSWorkerPool:151 72665180 +177ms] All workers finished, continuing

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [BEGIN]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:456 72665180 +0ms] Executing count query [SELECT true FROM search_index_scratch_20121206T102050 LIMIT 1]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [TRUNCATE TABLE search_index]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [INSERT INTO search_index SELECT * FROM search_index_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +6ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=139

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [DROP TABLE search_index_scratch_20121206T102050]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [COMMIT]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +3ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [SET maintenance_work_mem TO '1GB']

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [VACUUM FULL ANALYZE search_index]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +29ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [CSConnectionPool:291 72665180 +0ms] Closing DB connection

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:469 72665180 +0ms] -[PGCConnection close]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:469 72665180 +0ms] -[PGCConnection close]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:728 72665180 +0ms] Done

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [MigrationController:799 72665180 +0ms] Migration complete

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [BEGIN]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:457 72665180 +0ms] Running post-migration updates...

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:106 72665180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/36.sql

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [/**

           * Copyright (c) 2010-2012, Apple Inc. All rights reserved.

           *

           * IMPORTANT NOTE: This file is licensed only for use on Apple-branded

           * computers and is subject to the terms and conditions of the Apple Software

           * License Agreement accompanying the package this file is a part of.

           * You may not port this file to another platform without Apple's written consent.

           *

           * IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature

           * of the Apple Software and is subject to the terms and conditions of the Apple

           * Software License Agreement accompanying the package this file is part of.

           **/

 

          UPDATE entity e

             SET blog_uid_fk=(SELECT uid FROM entity b WHERE b.ownedby_uid_fk=e.uid AND b.entity_type_fk='com.apple.entity.Blog' LIMIT 1)

           WHERE e.blog_uid_fk IS NULL

             AND (e.entity_type_fk='com.apple.entity.User' OR e.entity_type_fk='com.apple.entity.Project')

          ;

          ]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:106 72665180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/48.sql

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [/**

           * Copyright (c) 2010-2012, Apple Inc. All rights reserved.

           *

           * IMPORTANT NOTE: This file is licensed only for use on Apple-branded

           * computers and is subject to the terms and conditions of the Apple Software

           * License Agreement accompanying the package this file is a part of.

           * You may not port this file to another platform without Apple's written consent.

           *

           * IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature

           * of the Apple Software and is subject to the terms and conditions of the Apple

           * Software License Agreement accompanying the package this file is part of.

           **/

 

          INSERT INTO user_activity (user_uid_fk, action, entity_uid_fk, entity_revision, action_time, parent_uids, container_uid_fk)

              SELECT cs.change_user_fk AS user_uid_fk,

                     CASE cs.change_type

                       WHEN 'create' THEN 'com.apple.activity.EntityCreated'

                       WHEN 'edit' THEN 'com.apple.activity.EntityUpdated'

                     END AS action,

                     cs.entity_uid_fk,

                     cs.entity_revision,

                     cs.change_time AS action_time,

                     e.parent_uids::uuid[],

                     e.container_uid_fk

                FROM entity_changesets cs

                  LEFT OUTER JOIN entity e ON (e.uid=cs.entity_uid_fk)

               WHERE cs.change_type IN ('create', 'edit')

                 AND e.uid IS NOT NULL

                 AND cs.change_user_fk NOT IN (SELECT uid FROM entity WHERE entity_type_fk='com.apple.entity.User' and short_name='serverhomeu')

                 AND NOT (cs.entity_uid_fk IN (SELECT entity_uid_fk FROM page_entity WHERE is_detail_page) AND cs.change_type='create')

                 AND e.entity_type_fk IN ('com.apple.entity.Page', 'com.apple.entity.File', 'com.apple.entity.Project')

          ;

          ]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=3

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:118 72665180 +0ms] Executing migration block #58

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:205 72665180 +0ms] Executing query [INSERT INTO session (uid, user_uid_fk, auth_token) SELECT uuid_v4(), entity_uid_fk, $1 FROM user_entity WHERE external_id='unauthenticated' RETURNING uid] with params [(

              "2v1V8rG49lJPGyKedAXCRwJUX8KV0wUcVM4jO9P136Q="

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_TUPLES_OK] rows returned=1/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:289 72665180 +0ms] Executing update [INSERT INTO preview_queue (entity_uid_fk, session_uid_fk) SELECT entity_uid_fk, $1 FROM page_entity] with params [(

              "ce2c5184-4316-9868-0784-b78c2a54eaf1"

          )]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=6

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:106 72665180 +0ms] Executing migration SQL script /Applications/Server.app/Contents/ServerRoot/usr/share/collabd/server/sql/migra tions/68.sql

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:388 72665180 +0ms] Executing scalar query [/**

           * Copyright (c) 2010-2012, Apple Inc. All rights reserved.

           *

           * IMPORTANT NOTE: This file is licensed only for use on Apple-branded

           * computers and is subject to the terms and conditions of the Apple Software

           * License Agreement accompanying the package this file is a part of.

           * You may not port this file to another platform without Apple's written consent.

           *

           * IMPORTANT NOTE: This file is licensed only for use with the Wiki Server feature

           * of the Apple Software and is subject to the terms and conditions of the Apple

           * Software License Agreement accompanying the package this file is part of.

           **/

 

          UPDATE entity e

             SET blog_uid_fk=(SELECT uid FROM entity b WHERE b.ownedby_uid_fk=e.uid AND b.entity_type_fk='com.apple.entity.Blog' LIMIT 1)

           WHERE (e.blog_uid_fk IS NULL OR e.blog_uid_fk=e.uid)

             AND (e.entity_type_fk='com.apple.entity.User' OR e.entity_type_fk='com.apple.entity.Project')

          ;

          ]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +1ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=1

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:464 72665180 +0ms] Post-migration updates completed.

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [COMMIT]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +0ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Info>: [SchemaMigrator:469 72665180 +0ms] Performing a VACUUM FULL ANALYZE of user_activity

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:320 72665180 +0ms] Executing update [VACUUM FULL ANALYZE user_activity]

Dec  6 10:20:50 truffula.fr.umn.edu wikiadmin[26344] <Debug>: [PGCConnection:181 72665180 +8ms] Query result is [PGRES_COMMAND_OK] rows returned=0/updated=

[kirkw@truffula]~$