Skip navigation

wikiadmin does not seem to migrate wiki data

364 Views 0 Replies Latest reply: Dec 6, 2012 8:22 AM by krw RSS
krw Level 2 Level 2 (175 points)
Currently Being Moderated
Dec 6, 2012 8:22 AM

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]~$

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

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.