Open iamdoubz opened 3 years ago
First of all, I'm an idiot.
Got it working. Now, just have to slowly verify data.
postgres@computer:~/pgloader$ ./build/bin/pgloader mysql://username:password@localhost/diaspora_production pgsql:///diaspora_production
2021-02-11T21:45:29.015000-06:00 LOG pgloader version "3.6.3047c9a"
2021-02-11T21:45:29.047000-06:00 LOG Migrating from #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006FA8943}>
2021-02-11T21:45:29.047000-06:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10070F93E3}>
2021-02-11T21:45:44.078000-06:00 WARNING PostgreSQL warning: identifier "idx_50997_index_likes_on_target_id_and_author_id_and_target_type" will be truncated to "idx_50997_index_likes_on_target_id_and_author_id_and_target_typ"
2021-02-11T21:45:52.048000-06:00 WARNING PostgreSQL warning: identifier "idx_51298_index_taggings_on_taggable_id_and_taggable_type_and_context" will be truncated to "idx_51298_index_taggings_on_taggable_id_and_taggable_type_and_c"
2021-02-11T21:46:07.389000-06:00 WARNING PostgreSQL warning: identifier "idx_51107_index_participations_on_target_id_and_target_type_and_author_id" will be truncated to "idx_51107_index_participations_on_target_id_and_target_type_and"
2021-02-11T21:46:52.701000-06:00 WARNING PostgreSQL warning: identifier "idx_50891_index_aspect_visibilities_on_shareable_id_and_shareable_type" will be truncated to "idx_50891_index_aspect_visibilities_on_shareable_id_and_shareab"
2021-02-11T21:46:58.167000-06:00 WARNING PostgreSQL warning: identifier "idx_51050_index_notification_actors_on_notification_id_and_person_id" will be truncated to "idx_51050_index_notification_actors_on_notification_id_and_pers"
2021-02-11T21:46:58.559000-06:00 WARNING PostgreSQL warning: identifier "idx_50864_index_account_migrations_on_old_person_id_and_new_person_id" will be truncated to "idx_50864_index_account_migrations_on_old_person_id_and_new_per"
2021-02-11T21:46:58.641000-06:00 WARNING PostgreSQL warning: identifier "idx_51184_index_poll_participation_signatures_on_poll_participation_id" will be trunc
First go around, DB size is 2.3GB and raw mysqldump is 2.7GB.
table name errors rows bytes total time
------------------------------------------------- --------- --------- --------- --------------
fetch meta data 0 242 0.107s
Create Schemas 0 0 0.000s
Create SQL Types 0 0 0.006s
Create tables 0 104 0.255s
Set Table OIDs 0 52 0.006s
------------------------------------------------- --------- --------- --------- --------------
diaspora_production.taggings 0 4157249 224.5 MB 21.754s
diaspora_production.likes 0 2260661 217.4 MB 13.780s
diaspora_production.participations 0 1800688 171.9 MB 15.717s
diaspora_production.posts 0 1625877 839.4 MB 50.789s
diaspora_production.open_graph_caches 0 879078 426.0 MB 26.839s
diaspora_production.tags 0 352432 7.2 MB 3.961s
diaspora_production.o_embed_caches 0 188897 196.7 MB 15.281s
diaspora_production.comments 0 698317 200.7 MB 17.548s
diaspora_production.people 0 37672 33.3 MB 10.478s
diaspora_production.share_visibilities 0 22112 501.2 kB 9.533s
diaspora_production.notifications 0 12005 1.0 MB 9.586s
diaspora_production.like_signatures 0 6235 4.1 MB 9.963s
diaspora_production.aspect_memberships 0 3182 168.3 kB 9.903s
diaspora_production.aspect_visibilities 0 2323 48.3 kB 9.909s
diaspora_production.comment_signatures 0 1580 1.1 MB 9.957s
diaspora_production.poll_answers 0 1098 70.0 kB 9.955s
diaspora_production."references" 0 749 22.2 kB 9.974s
diaspora_production.locations 0 307 35.2 kB 9.985s
diaspora_production.user_preferences 0 187 11.3 kB 9.989s
diaspora_production.messages 0 102 28.2 kB 9.999s
diaspora_production.blocks 0 70 0.8 kB 10.004s
diaspora_production.conversations 0 25 2.3 kB 10.021s
diaspora_production.signature_orders 0 9 0.4 kB 10.031s
diaspora_production.simple_captcha_data 0 2 0.2 kB 10.043s
diaspora_production.ar_internal_metadata 0 1 0.1 kB 10.052s
diaspora_production.chat_contacts 0 0 10.054s
diaspora_production.chat_offline_messages 0 0 10.061s
diaspora_production.o_auth_applications 0 0 10.064s
diaspora_production.ppid 0 0 10.068s
diaspora_production.mentions 0 165427 4.2 MB 0.504s
diaspora_production.photos 0 153578 30.6 MB 1.923s
diaspora_production.profiles 0 37672 9.9 MB 0.656s
diaspora_production.notification_actors 0 15761 852.0 kB 0.144s
diaspora_production.aspects 0 10026 627.0 kB 0.166s
diaspora_production.contacts 0 3370 184.2 kB 0.096s
diaspora_production.poll_participations 0 3101 272.7 kB 0.133s
diaspora_production.users 0 2531 8.7 MB 0.521s
diaspora_production.pods 0 1310 271.3 kB 0.090s
diaspora_production.tag_followings 0 959 49.9 kB 0.079s
diaspora_production.invitation_codes 0 310 19.3 kB 0.075s
diaspora_production.polls 0 296 37.9 kB 0.093s
diaspora_production.account_deletions 0 151 4.3 kB 0.091s
diaspora_production.schema_migrations 0 98 1.4 kB 0.090s
diaspora_production.conversation_visibilities 0 53 2.7 kB 0.106s
diaspora_production.services 0 11 2.0 kB 0.099s
diaspora_production.roles 0 3 0.2 kB 0.100s
diaspora_production.account_migrations 0 0 0.107s
diaspora_production.authorizations 0 0 0.109s
diaspora_production.chat_fragments 0 0 0.107s
diaspora_production.o_auth_access_tokens 0 0 0.110s
diaspora_production.poll_participation_signatures 0 0 0.110s
diaspora_production.reports 0 1 0.1 kB 0.115s
------------------------------------------------- --------- --------- --------- --------------
COPY Threads Completion 0 4 1m28.369s
Create Indexes 0 159 1m54.452s
Index Build Completion 0 159 0.037s
Reset Sequences 0 47 0.033s
Primary Keys 0 48 0.016s
Create Foreign Keys 0 31 1.086s
Create Triggers 0 0 0.000s
Install Comments 0 0 0.000s
------------------------------------------------- --------- --------- --------- --------------
Total import time ✓ 12445516 2.3 GB 3m23.993s
So, pgloader claims to have done all the above, but when I check the database, nothing is there. Nothing appears to get committed?
Command I run (under sudo -iu postgres):
./pgloader/build/bin/pgloader --debug mysql://<username>:<password>@localhost/diaspora_production pgsql:///diaspora_production
Contents of /tmp/pgloader/pgloader.log:
2021-02-12T09:57:47.008000-06:00 NOTICE Starting pgloader, log system is ready.
2021-02-12T09:57:47.014000-06:00 INFO Starting monitor
2021-02-12T09:57:47.017000-06:00 LOG pgloader version "3.6.3047c9a"
2021-02-12T09:57:47.017000-06:00 INFO SOURCE: "mysql://<username>:<password>@localhost/diaspora_production"
2021-02-12T09:57:47.017000-06:00 INFO SOURCE URI: #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006FA85A3}>
2021-02-12T09:57:47.017000-06:00 INFO TARGET: "pgsql:///diaspora_production"
2021-02-12T09:57:47.017000-06:00 INFO TARGET URI: #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10070F95A3}>
2021-02-12T09:57:47.017000-06:00 DEBUG LOAD DATA FROM #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006FA85A3}>
2021-02-12T09:57:47.031000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10070F95A3}>
2021-02-12T09:57:47.031000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:57:47.031000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:57:47.041000-06:00 LOG Migrating from #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006FA85A3}>
2021-02-12T09:57:47.041000-06:00 LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10070F95A3}>
2021-02-12T09:57:47.082000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006FA85A3}>
2021-02-12T09:57:47.087000-06:00 SQL MySQL: sending query: -- params: db-name
-- table-type-name
-- only-tables
-- only-tables
-- including
-- filter-list-to-where-clause incuding
-- excluding
-- filter-list-to-where-clause excluding
select c.table_name, t.table_comment,
c.column_name, c.column_comment,
c.data_type, c.column_type, c.column_default,
c.is_nullable, c.extra
from information_schema.columns c
join information_schema.tables t using(table_schema, table_name)
where c.table_schema = 'diaspora_production' and t.table_type = 'BASE TABLE'
order by table_name, ordinal_position;
2021-02-12T09:57:47.116000-06:00 SQL MySQL: sending query: -- params: db-name
-- including
-- filter-list-to-where-clause incuding
-- excluding
-- filter-list-to-where-clause excluding
SELECT table_name,
coalesce(cast(data_length/avg_row_length as unsigned), 0)
FROM information_schema.tables
WHERE table_schema = 'diaspora_production'
and table_type = 'BASE TABLE'
;
2021-02-12T09:57:47.121000-06:00 SQL MySQL: sending query: -- params: db-name
-- table-type-name
-- only-tables
-- only-tables
-- including
-- filter-list-to-where-clause incuding
-- excluding
-- filter-list-to-where-clause excluding
SELECT s.table_name, s.constraint_name, s.ft, s.cols, s.fcols,
rc.update_rule, rc.delete_rule
FROM
(
SELECT tc.table_schema, tc.table_name,
tc.constraint_name, k.referenced_table_name ft,
group_concat( k.column_name
order by k.ordinal_position) as cols,
group_concat( k.referenced_column_name
order by k.position_in_unique_constraint) as fcols
FROM information_schema.table_constraints tc
LEFT JOIN information_schema.key_column_usage k
ON k.table_schema = tc.table_schema
AND k.table_name = tc.table_name
AND k.constraint_name = tc.constraint_name
WHERE tc.table_schema = 'diaspora_production'
AND k.referenced_table_schema = 'diaspora_production'
AND tc.constraint_type = 'FOREIGN KEY'
GROUP BY tc.table_schema, tc.table_name, tc.constraint_name, ft
) s
JOIN information_schema.referential_constraints rc
ON rc.constraint_schema = s.table_schema
AND rc.constraint_name = s.constraint_name
AND rc.table_name = s.table_name;
2021-02-12T09:57:47.136000-06:00 SQL MySQL: sending query: -- params: db-name
-- table-type-name
-- only-tables
-- only-tables
-- including
-- filter-list-to-where-clause incuding
-- excluding
-- filter-list-to-where-clause excluding
SELECT table_name, index_name, index_type,
sum(non_unique),
cast(GROUP_CONCAT(column_name order by seq_in_index) as char)
FROM information_schema.statistics
WHERE table_schema = 'diaspora_production'
GROUP BY table_name, index_name, index_type;
2021-02-12T09:57:47.157000-06:00 INFO Processing source catalogs
2021-02-12T09:57:47.506000-06:00 NOTICE Prepare PostgreSQL database.
2021-02-12T09:57:47.508000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10070F95A3}>
2021-02-12T09:57:47.509000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:57:47.509000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:57:47.511000-06:00 DEBUG BEGIN
2021-02-12T09:57:47.523000-06:00 SQL CREATE SCHEMA diaspora_production;
2021-02-12T09:57:47.549000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.account_deletions CASCADE;
2021-02-12T09:57:47.549000-06:00 SQL CREATE TABLE diaspora_production.account_deletions
(
id bigserial not null,
person_id bigint default NULL,
completed_at timestamptz default NULL
);
2021-02-12T09:57:47.551000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.account_migrations CASCADE;
2021-02-12T09:57:47.551000-06:00 SQL CREATE TABLE diaspora_production.account_migrations
(
id bigserial not null,
old_person_id bigint not null,
new_person_id bigint not null,
completed_at timestamptz default NULL
);
2021-02-12T09:57:47.552000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.ar_internal_metadata CASCADE;
2021-02-12T09:57:47.552000-06:00 SQL CREATE TABLE diaspora_production.ar_internal_metadata
(
key varchar(255) not null,
value varchar(255) default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.566000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.aspects CASCADE;
2021-02-12T09:57:47.566000-06:00 SQL CREATE TABLE diaspora_production.aspects
(
id bigserial not null,
name varchar(255) not null,
user_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null,
order_id bigint default NULL,
chat_enabled boolean default 'f',
post_default boolean default 't'
);
2021-02-12T09:57:47.568000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.aspect_memberships CASCADE;
2021-02-12T09:57:47.568000-06:00 SQL CREATE TABLE diaspora_production.aspect_memberships
(
id bigserial not null,
aspect_id bigint not null,
contact_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.569000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.aspect_visibilities CASCADE;
2021-02-12T09:57:47.570000-06:00 SQL CREATE TABLE diaspora_production.aspect_visibilities
(
id bigserial not null,
shareable_id bigint not null,
aspect_id bigint not null,
shareable_type varchar(255) not null default 'Post'
);
2021-02-12T09:57:47.571000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.authorizations CASCADE;
2021-02-12T09:57:47.571000-06:00 SQL CREATE TABLE diaspora_production.authorizations
(
id bigserial not null,
user_id bigint default NULL,
o_auth_application_id bigint default NULL,
refresh_token varchar(255) default NULL,
code varchar(255) default NULL,
redirect_uri varchar(255) default NULL,
nonce varchar(255) default NULL,
scopes varchar(255) default NULL,
code_used boolean default 'f',
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.579000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.blocks CASCADE;
2021-02-12T09:57:47.579000-06:00 SQL CREATE TABLE diaspora_production.blocks
(
id bigserial not null,
user_id bigint default NULL,
person_id bigint default NULL
);
2021-02-12T09:57:47.580000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.chat_contacts CASCADE;
2021-02-12T09:57:47.580000-06:00 SQL CREATE TABLE diaspora_production.chat_contacts
(
id bigserial not null,
user_id bigint not null,
jid varchar(255) not null,
name varchar(255) default NULL,
ask varchar(128) default NULL,
subscription varchar(128) not null
);
2021-02-12T09:57:47.588000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.chat_fragments CASCADE;
2021-02-12T09:57:47.588000-06:00 SQL CREATE TABLE diaspora_production.chat_fragments
(
id bigserial not null,
user_id bigint not null,
root varchar(256) not null,
namespace varchar(256) not null,
xml text not null
);
2021-02-12T09:57:47.595000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.chat_offline_messages CASCADE;
2021-02-12T09:57:47.595000-06:00 SQL CREATE TABLE diaspora_production.chat_offline_messages
(
id bigserial not null,
"from" varchar(255) not null,
"to" varchar(255) not null,
message text not null,
created_at timestamptz not null
);
2021-02-12T09:57:47.603000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.comments CASCADE;
2021-02-12T09:57:47.603000-06:00 SQL CREATE TABLE diaspora_production.comments
(
id bigserial not null,
text text not null,
commentable_id bigint not null,
author_id bigint not null,
guid varchar(255) not null,
created_at timestamptz not null,
updated_at timestamptz not null,
likes_count bigint not null default '0',
commentable_type varchar(60) not null default 'Post'
);
2021-02-12T09:57:47.610000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.comment_signatures CASCADE;
2021-02-12T09:57:47.611000-06:00 SQL CREATE TABLE diaspora_production.comment_signatures
(
comment_id bigint not null,
author_signature text not null,
signature_order_id bigint not null,
additional_data text default NULL
);
2021-02-12T09:57:47.617000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.contacts CASCADE;
2021-02-12T09:57:47.618000-06:00 SQL CREATE TABLE diaspora_production.contacts
(
id bigserial not null,
user_id bigint not null,
person_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null,
sharing boolean not null default 'f',
receiving boolean not null default 'f'
);
2021-02-12T09:57:47.619000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.conversations CASCADE;
2021-02-12T09:57:47.619000-06:00 SQL CREATE TABLE diaspora_production.conversations
(
id bigserial not null,
subject varchar(255) default NULL,
guid varchar(255) not null,
author_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.626000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.conversation_visibilities CASCADE;
2021-02-12T09:57:47.626000-06:00 SQL CREATE TABLE diaspora_production.conversation_visibilities
(
id bigserial not null,
conversation_id bigint not null,
person_id bigint not null,
unread bigint not null default '0',
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.627000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.invitation_codes CASCADE;
2021-02-12T09:57:47.627000-06:00 SQL CREATE TABLE diaspora_production.invitation_codes
(
id bigserial not null,
token varchar(255) default NULL,
user_id bigint default NULL,
count bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.628000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.likes CASCADE;
2021-02-12T09:57:47.629000-06:00 SQL CREATE TABLE diaspora_production.likes
(
id bigserial not null,
positive boolean default 't',
target_id bigint default NULL,
author_id bigint default NULL,
guid varchar(255) default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
target_type varchar(60) not null
);
2021-02-12T09:57:47.630000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.like_signatures CASCADE;
2021-02-12T09:57:47.630000-06:00 SQL CREATE TABLE diaspora_production.like_signatures
(
like_id bigint not null,
author_signature text not null,
signature_order_id bigint not null,
additional_data text default NULL
);
2021-02-12T09:57:47.636000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.locations CASCADE;
2021-02-12T09:57:47.636000-06:00 SQL CREATE TABLE diaspora_production.locations
(
id bigserial not null,
address varchar(255) default NULL,
lat varchar(255) default NULL,
lng varchar(255) default NULL,
status_message_id bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.643000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.mentions CASCADE;
2021-02-12T09:57:47.644000-06:00 SQL CREATE TABLE diaspora_production.mentions
(
id bigserial not null,
mentions_container_id bigint not null,
person_id bigint not null,
mentions_container_type varchar(255) not null
);
2021-02-12T09:57:47.645000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.messages CASCADE;
2021-02-12T09:57:47.645000-06:00 SQL CREATE TABLE diaspora_production.messages
(
id bigserial not null,
conversation_id bigint not null,
author_id bigint not null,
guid varchar(255) not null,
text text not null,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.652000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.notifications CASCADE;
2021-02-12T09:57:47.652000-06:00 SQL CREATE TABLE diaspora_production.notifications
(
id bigserial not null,
target_type varchar(255) default NULL,
target_id bigint default NULL,
recipient_id bigint not null,
unread boolean not null default 't',
created_at timestamptz not null,
updated_at timestamptz not null,
type varchar(255) default NULL
);
2021-02-12T09:57:47.657000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.notification_actors CASCADE;
2021-02-12T09:57:47.657000-06:00 SQL CREATE TABLE diaspora_production.notification_actors
(
id bigserial not null,
notification_id bigint default NULL,
person_id bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.658000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.open_graph_caches CASCADE;
2021-02-12T09:57:47.658000-06:00 SQL CREATE TABLE diaspora_production.open_graph_caches
(
id bigserial not null,
title varchar(255) default NULL,
ob_type varchar(255) default NULL,
image text default NULL,
url text default NULL,
description text default NULL,
video_url text default NULL
);
2021-02-12T09:57:47.663000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.o_auth_access_tokens CASCADE;
2021-02-12T09:57:47.663000-06:00 SQL CREATE TABLE diaspora_production.o_auth_access_tokens
(
id bigserial not null,
authorization_id bigint default NULL,
token varchar(255) default NULL,
expires_at timestamptz default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.664000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.o_auth_applications CASCADE;
2021-02-12T09:57:47.664000-06:00 SQL CREATE TABLE diaspora_production.o_auth_applications
(
id bigserial not null,
user_id bigint default NULL,
client_id varchar(255) default NULL,
client_secret varchar(255) default NULL,
client_name varchar(255) default NULL,
redirect_uris text default NULL,
response_types varchar(255) default NULL,
grant_types varchar(255) default NULL,
application_type varchar(255) default 'web',
contacts varchar(255) default NULL,
logo_uri varchar(255) default NULL,
client_uri varchar(255) default NULL,
policy_uri varchar(255) default NULL,
tos_uri varchar(255) default NULL,
sector_identifier_uri varchar(255) default NULL,
token_endpoint_auth_method varchar(255) default NULL,
jwks text default NULL,
jwks_uri varchar(255) default NULL,
ppid boolean default 'f',
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.670000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.o_embed_caches CASCADE;
2021-02-12T09:57:47.670000-06:00 SQL CREATE TABLE diaspora_production.o_embed_caches
(
id bigserial not null,
url varchar(1024) not null,
data text not null
);
2021-02-12T09:57:47.675000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.participations CASCADE;
2021-02-12T09:57:47.675000-06:00 SQL CREATE TABLE diaspora_production.participations
(
id bigserial not null,
guid varchar(255) default NULL,
target_id bigint default NULL,
target_type varchar(60) not null,
author_id bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
count bigint not null default '1'
);
2021-02-12T09:57:47.676000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.people CASCADE;
2021-02-12T09:57:47.676000-06:00 SQL CREATE TABLE diaspora_production.people
(
id bigserial not null,
guid varchar(255) not null,
diaspora_handle varchar(255) not null,
serialized_public_key text not null,
owner_id bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
closed_account boolean default 'f',
fetch_status bigint default '0',
pod_id bigint default NULL
);
2021-02-12T09:57:47.681000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.photos CASCADE;
2021-02-12T09:57:47.681000-06:00 SQL CREATE TABLE diaspora_production.photos
(
id bigserial not null,
author_id bigint not null,
public boolean not null default 'f',
guid varchar(255) not null,
pending boolean not null default 'f',
text text default NULL,
remote_photo_path text default NULL,
remote_photo_name varchar(255) default NULL,
random_string varchar(255) default NULL,
processed_image varchar(255) default NULL,
created_at timestamptz default NULL,
updated_at timestamptz default NULL,
unprocessed_image varchar(255) default NULL,
status_message_guid varchar(255) default NULL,
comments_count bigint default NULL,
height bigint default NULL,
width bigint default NULL
);
2021-02-12T09:57:47.687000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.pods CASCADE;
2021-02-12T09:57:47.688000-06:00 SQL CREATE TABLE diaspora_production.pods
(
id bigserial not null,
host varchar(255) not null,
ssl boolean default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
status bigint default '0',
checked_at timestamptz default '1970-01-01 00:00:00',
offline_since timestamptz default NULL,
response_time bigint default '-1',
software varchar(255) default NULL,
error varchar(255) default NULL,
port bigint default NULL,
blocked boolean default 'f',
scheduled_check boolean not null default 'f'
);
2021-02-12T09:57:47.693000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.polls CASCADE;
2021-02-12T09:57:47.693000-06:00 SQL CREATE TABLE diaspora_production.polls
(
id bigserial not null,
question varchar(255) not null,
status_message_id bigint not null,
status boolean default NULL,
guid varchar(255) default NULL,
created_at timestamptz default NULL,
updated_at timestamptz default NULL
);
2021-02-12T09:57:47.698000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.poll_answers CASCADE;
2021-02-12T09:57:47.698000-06:00 SQL CREATE TABLE diaspora_production.poll_answers
(
id bigserial not null,
answer varchar(255) not null,
poll_id bigint not null,
guid varchar(255) default NULL,
vote_count bigint default '0'
);
2021-02-12T09:57:47.702000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.poll_participations CASCADE;
2021-02-12T09:57:47.702000-06:00 SQL CREATE TABLE diaspora_production.poll_participations
(
id bigserial not null,
poll_answer_id bigint not null,
author_id bigint not null,
poll_id bigint not null,
guid varchar(255) default NULL,
created_at timestamptz default NULL,
updated_at timestamptz default NULL
);
2021-02-12T09:57:47.703000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.poll_participation_signatures CASCADE;
2021-02-12T09:57:47.703000-06:00 SQL CREATE TABLE diaspora_production.poll_participation_signatures
(
poll_participation_id bigint not null,
author_signature text not null,
signature_order_id bigint not null,
additional_data text default NULL
);
2021-02-12T09:57:47.707000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.posts CASCADE;
2021-02-12T09:57:47.707000-06:00 SQL CREATE TABLE diaspora_production.posts
(
id bigserial not null,
author_id bigint not null,
public boolean not null default 'f',
guid varchar(255) not null,
type varchar(40) not null,
text text default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
provider_display_name varchar(255) default NULL,
root_guid varchar(255) default NULL,
likes_count bigint default '0',
comments_count bigint default '0',
o_embed_cache_id bigint default NULL,
reshares_count bigint default '0',
interacted_at timestamptz default NULL,
tweet_id varchar(255) default NULL,
open_graph_cache_id bigint default NULL,
tumblr_ids text default NULL
);
2021-02-12T09:57:47.714000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.ppid CASCADE;
2021-02-12T09:57:47.714000-06:00 SQL CREATE TABLE diaspora_production.ppid
(
id bigserial not null,
o_auth_application_id bigint default NULL,
user_id bigint default NULL,
guid varchar(32) default NULL,
identifier varchar(255) default NULL
);
2021-02-12T09:57:47.716000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.profiles CASCADE;
2021-02-12T09:57:47.716000-06:00 SQL CREATE TABLE diaspora_production.profiles
(
id bigserial not null,
diaspora_handle varchar(255) default NULL,
first_name varchar(127) default NULL,
last_name varchar(127) default NULL,
image_url varchar(255) default NULL,
image_url_small varchar(255) default NULL,
image_url_medium varchar(255) default NULL,
birthday date default NULL,
gender varchar(255) default NULL,
bio text default NULL,
searchable boolean not null default 't',
person_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null,
location varchar(255) default NULL,
full_name varchar(70) default NULL,
nsfw boolean default 'f',
public_details boolean default 'f'
);
2021-02-12T09:57:47.721000-06:00 SQL DROP TABLE IF EXISTS diaspora_production."references" CASCADE;
2021-02-12T09:57:47.722000-06:00 SQL CREATE TABLE diaspora_production."references"
(
id bigserial not null,
source_id bigint not null,
source_type varchar(60) not null,
target_id bigint not null,
target_type varchar(60) not null
);
2021-02-12T09:57:47.723000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.reports CASCADE;
2021-02-12T09:57:47.723000-06:00 SQL CREATE TABLE diaspora_production.reports
(
id bigserial not null,
item_id bigint not null,
item_type varchar(255) not null,
reviewed boolean default 'f',
text text default NULL,
created_at timestamptz default NULL,
updated_at timestamptz default NULL,
user_id bigint not null
);
2021-02-12T09:57:47.727000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.roles CASCADE;
2021-02-12T09:57:47.728000-06:00 SQL CREATE TABLE diaspora_production.roles
(
id bigserial not null,
person_id bigint default NULL,
name varchar(255) default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.729000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.schema_migrations CASCADE;
2021-02-12T09:57:47.729000-06:00 SQL CREATE TABLE diaspora_production.schema_migrations
(
version varchar(191) not null
);
2021-02-12T09:57:47.729000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.services CASCADE;
2021-02-12T09:57:47.729000-06:00 SQL CREATE TABLE diaspora_production.services
(
id bigserial not null,
type varchar(127) not null,
user_id bigint not null,
uid varchar(127) default NULL,
access_token varchar(255) default NULL,
access_secret varchar(255) default NULL,
nickname varchar(255) default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.733000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.share_visibilities CASCADE;
2021-02-12T09:57:47.734000-06:00 SQL CREATE TABLE diaspora_production.share_visibilities
(
id bigserial not null,
shareable_id bigint not null,
hidden boolean not null default 'f',
shareable_type varchar(60) not null default 'Post',
user_id bigint not null
);
2021-02-12T09:57:47.735000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.signature_orders CASCADE;
2021-02-12T09:57:47.736000-06:00 SQL CREATE TABLE diaspora_production.signature_orders
(
id bigserial not null,
"order" varchar(255) not null
);
2021-02-12T09:57:47.737000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.simple_captcha_data CASCADE;
2021-02-12T09:57:47.737000-06:00 SQL CREATE TABLE diaspora_production.simple_captcha_data
(
id bigserial not null,
key varchar(40) default NULL,
value varchar(12) default NULL,
created_at timestamptz default NULL,
updated_at timestamptz default NULL
);
2021-02-12T09:57:47.738000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.taggings CASCADE;
2021-02-12T09:57:47.738000-06:00 SQL CREATE TABLE diaspora_production.taggings
(
id bigserial not null,
tag_id bigint default NULL,
taggable_id bigint default NULL,
taggable_type varchar(127) default NULL,
tagger_id bigint default NULL,
tagger_type varchar(127) default NULL,
context varchar(127) default NULL,
created_at timestamptz default NULL
);
2021-02-12T09:57:47.739000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.tags CASCADE;
2021-02-12T09:57:47.739000-06:00 SQL CREATE TABLE diaspora_production.tags
(
id bigserial not null,
name varchar(255) default NULL,
taggings_count bigint default '0'
);
2021-02-12T09:57:47.740000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.tag_followings CASCADE;
2021-02-12T09:57:47.740000-06:00 SQL CREATE TABLE diaspora_production.tag_followings
(
id bigserial not null,
tag_id bigint not null,
user_id bigint not null,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.741000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.users CASCADE;
2021-02-12T09:57:47.741000-06:00 SQL CREATE TABLE diaspora_production.users
(
id bigserial not null,
username varchar(255) not null,
serialized_private_key text default NULL,
getting_started boolean not null default 't',
disable_mail boolean not null default 'f',
language varchar(255) default NULL,
email varchar(255) not null default '',
encrypted_password varchar(255) not null default '',
reset_password_token varchar(255) default NULL,
remember_created_at timestamptz default NULL,
sign_in_count bigint default '0',
current_sign_in_at timestamptz default NULL,
last_sign_in_at timestamptz default NULL,
current_sign_in_ip varchar(255) default NULL,
last_sign_in_ip varchar(255) default NULL,
created_at timestamptz not null,
updated_at timestamptz not null,
invited_by_id bigint default NULL,
authentication_token varchar(30) default NULL,
unconfirmed_email varchar(255) default NULL,
confirm_email_token varchar(30) default NULL,
locked_at timestamptz default NULL,
show_community_spotlight_in_stream boolean not null default 't',
auto_follow_back boolean default 'f',
auto_follow_back_aspect_id bigint default NULL,
hidden_shareables text default NULL,
reset_password_sent_at timestamptz default NULL,
last_seen timestamptz default NULL,
remove_after timestamptz default NULL,
export varchar(255) default NULL,
exported_at timestamptz default NULL,
exporting boolean default 'f',
strip_exif boolean default 't',
exported_photos_file varchar(255) default NULL,
exported_photos_at timestamptz default NULL,
exporting_photos boolean default 'f',
color_theme varchar(255) default NULL,
post_default_public boolean default 'f',
consumed_timestep bigint default NULL,
otp_required_for_login boolean default NULL,
otp_backup_codes text default NULL,
plain_otp_secret varchar(255) default NULL
);
2021-02-12T09:57:47.747000-06:00 SQL DROP TABLE IF EXISTS diaspora_production.user_preferences CASCADE;
2021-02-12T09:57:47.747000-06:00 SQL CREATE TABLE diaspora_production.user_preferences
(
id bigserial not null,
email_type varchar(255) default NULL,
user_id bigint default NULL,
created_at timestamptz not null,
updated_at timestamptz not null
);
2021-02-12T09:57:47.755000-06:00 SQL -- params: table-names
select n, n::regclass::oid
from (values ('diaspora_production.account_deletions'),('diaspora_production.account_migrations'),('diaspora_production.ar_internal_metadata'),('diaspora_production.aspects'),('diaspora_production.aspect_memberships'),('diaspora_production.aspect_visibilities'),('diaspora_production.authorizations'),('diaspora_production.blocks'),('diaspora_production.chat_contacts'),('diaspora_production.chat_fragments'),('diaspora_production.chat_offline_messages'),('diaspora_production.comments'),('diaspora_production.comment_signatures'),('diaspora_production.contacts'),('diaspora_production.conversations'),('diaspora_production.conversation_visibilities'),('diaspora_production.invitation_codes'),('diaspora_production.likes'),('diaspora_production.like_signatures'),('diaspora_production.locations'),('diaspora_production.mentions'),('diaspora_production.messages'),('diaspora_production.notifications'),('diaspora_production.notification_actors'),('diaspora_production.open_graph_caches'),('diaspora_production.o_auth_access_tokens'),('diaspora_production.o_auth_applications'),('diaspora_production.o_embed_caches'),('diaspora_production.participations'),('diaspora_production.people'),('diaspora_production.photos'),('diaspora_production.pods'),('diaspora_production.polls'),('diaspora_production.poll_answers'),('diaspora_production.poll_participations'),('diaspora_production.poll_participation_signatures'),('diaspora_production.posts'),('diaspora_production.ppid'),('diaspora_production.profiles'),('diaspora_production."references"'),('diaspora_production.reports'),('diaspora_production.roles'),('diaspora_production.schema_migrations'),('diaspora_production.services'),('diaspora_production.share_visibilities'),('diaspora_production.signature_orders'),('diaspora_production.simple_captcha_data'),('diaspora_production.taggings'),('diaspora_production.tags'),('diaspora_production.tag_followings'),('diaspora_production.users'),('diaspora_production.user_preferences')) as t(n);
2021-02-12T09:57:47.767000-06:00 NOTICE Processing tables in this order: diaspora_production.account_deletions: 152 rows, diaspora_production.messages: 102 rows, diaspora_production.schema_migrations: 98 rows, diaspora_production.blocks: 70 rows, diaspora_production.conversation_visibilities: 53 rows, diaspora_production.conversations: 25 rows, diaspora_production.services: 11 rows, diaspora_production.signature_orders: 9 rows, diaspora_production.roles: 3 rows, diaspora_production.simple_captcha_data: 3 rows, diaspora_production.account_migrations: 0 rows, diaspora_production.ar_internal_metadata: 0 rows, diaspora_production.authorizations: 0 rows, diaspora_production.chat_contacts: 0 rows, diaspora_production.chat_fragments: 0 rows, diaspora_production.chat_offline_messages: 0 rows, diaspora_production.o_auth_access_tokens: 0 rows, diaspora_production.o_auth_applications: 0 rows, diaspora_production.poll_participation_signatures: 0 rows, diaspora_production.ppid: 0 rows, diaspora_production.reports: 0 rows
2021-02-12T09:57:47.778000-06:00 NOTICE COPY diaspora_production.taggings with 4167107 rows estimated [3/4]
2021-02-12T09:57:47.778000-06:00 DEBUG Reader started for diaspora_production.taggings
2021-02-12T09:57:47.791000-06:00 DEBUG start diaspora_production.taggings 781
2021-02-12T09:57:47.791000-06:00 NOTICE COPY diaspora_production.likes with 2129175 rows estimated [0/4]
2021-02-12T09:57:47.791000-06:00 DEBUG Reader started for diaspora_production.likes
2021-02-12T09:57:47.792000-06:00 DEBUG start diaspora_production.likes 782
2021-02-12T09:57:47.792000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:57:47.792000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10134C9523}>
2021-02-12T09:57:47.792000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:57:47.792000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:57:47.792000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:57:47.792000-06:00 INFO pgsql:copy-rows-from-queue[1]: diaspora_production.taggings (id tag_id
taggable_id
taggable_type
tagger_id
tagger_type
context created_at)
2021-02-12T09:57:47.792000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:57:47.792000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10134BD213}>
2021-02-12T09:57:47.792000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:57:47.793000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:57:47.793000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:57:47.793000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.likes (id positive target_id
author_id guid
created_at updated_at
target_type)
2021-02-12T09:57:47.793000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1013382263}>
2021-02-12T09:57:47.793000-06:00 SQL MySQL: sending query: SELECT `id`, `positive`, `target_id`, `author_id`, `guid`, `created_at`, `updated_at`, `target_type` FROM `likes`
2021-02-12T09:57:47.794000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {10130777E3}>
2021-02-12T09:57:47.794000-06:00 SQL MySQL: sending query: SELECT `id`, `tag_id`, `taggable_id`, `taggable_type`, `tagger_id`, `tagger_type`, `context`, `created_at` FROM `taggings`
2021-02-12T09:58:01.551000-06:00 DEBUG Reader for diaspora_production.likes is done in 13.772000s
2021-02-12T09:58:01.551000-06:00 DEBUG Finished processing READER for "diaspora_production.likes" 13.772000s
2021-02-12T09:58:01.551000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:01.553000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101D597D13}>
2021-02-12T09:58:01.553000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.554000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.554000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:01.554000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.posts (id author_id public
guid type text
created_at updated_at
provider_display_name
root_guid likes_count
comments_count
o_embed_cache_id
reshares_count
interacted_at
tweet_id
open_graph_cache_id
tumblr_ids)
2021-02-12T09:58:01.573000-06:00 DEBUG stop diaspora_production.likes | 782 .. 14577 = 13.795d0
2021-02-12T09:58:01.573000-06:00 DEBUG Writer[2] for diaspora_production.likes is done in 11.877000s
2021-02-12T09:58:01.573000-06:00 DEBUG Finished processing WRITER for "diaspora_production.likes" 11.877000s
2021-02-12T09:58:01.573000-06:00 DEBUG writers-counts[diaspora_production.likes] = 0
2021-02-12T09:58:01.575000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:01.575000-06:00 NOTICE DONE copying diaspora_production.likes in 11.877s
2021-02-12T09:58:01.579000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101D5838A3}>
2021-02-12T09:58:01.579000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.579000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E101AD3}>
2021-02-12T09:58:01.579000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.579000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.579000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.580000-06:00 NOTICE CREATE UNIQUE INDEX idx_259714_index_likes_on_guid ON diaspora_production.likes (guid);
2021-02-12T09:58:01.580000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:01.581000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.participations (id guid
target_id
target_type
author_id
created_at
updated_at
count)
2021-02-12T09:58:01.581000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E1035B3}>
2021-02-12T09:58:01.581000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.581000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.581000-06:00 NOTICE CREATE INDEX idx_259714_index_likes_on_post_id ON diaspora_production.likes (target_id);
2021-02-12T09:58:01.584000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E1211A3}>
2021-02-12T09:58:01.584000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.584000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E106303}>
2021-02-12T09:58:01.584000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.584000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.584000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.586000-06:00 NOTICE CREATE UNIQUE INDEX idx_259714_index_likes_on_target_id_and_author_id_and_target_type ON diaspora_production.likes (target_id, author_id, target_type);
2021-02-12T09:58:01.586000-06:00 NOTICE CREATE UNIQUE INDEX idx_259714_primary ON diaspora_production.likes (id);
2021-02-12T09:58:01.586000-06:00 WARNING PostgreSQL warning: identifier "idx_259714_index_likes_on_target_id_and_author_id_and_target_type" will be truncated to "idx_259714_index_likes_on_target_id_and_author_id_and_target_ty"
2021-02-12T09:58:01.592000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E107B33}>
2021-02-12T09:58:01.592000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:01.592000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:01.592000-06:00 NOTICE CREATE INDEX idx_259714_likes_author_id_fk ON diaspora_production.likes (author_id);
2021-02-12T09:58:07.400000-06:00 DEBUG Reader for diaspora_production.taggings is done in 19.623000s
2021-02-12T09:58:07.400000-06:00 NOTICE COPY diaspora_production.participations with 1747687 rows estimated [3/4]
2021-02-12T09:58:07.400000-06:00 DEBUG Reader started for diaspora_production.participations
2021-02-12T09:58:07.401000-06:00 DEBUG start diaspora_production.participations 20404
2021-02-12T09:58:07.401000-06:00 DEBUG Finished processing READER for "diaspora_production.taggings" 19.623000s
2021-02-12T09:58:07.401000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {100740EA03}>
2021-02-12T09:58:07.401000-06:00 SQL MySQL: sending query: SELECT `id`, `guid`, `target_id`, `target_type`, `author_id`, `created_at`, `updated_at`, `count` FROM `participations`
2021-02-12T09:58:07.838000-06:00 DEBUG stop diaspora_production.taggings | 781 .. 20842 = 20.061d0
2021-02-12T09:58:07.838000-06:00 DEBUG Writer[1] for diaspora_production.taggings is done in 14.239000s
2021-02-12T09:58:07.839000-06:00 DEBUG Finished processing WRITER for "diaspora_production.taggings" 14.239000s
2021-02-12T09:58:07.839000-06:00 NOTICE COPY diaspora_production.posts with 1266862 rows estimated [1/4]
2021-02-12T09:58:07.839000-06:00 DEBUG writers-counts[diaspora_production.taggings] = 0
2021-02-12T09:58:07.839000-06:00 DEBUG Reader started for diaspora_production.posts
2021-02-12T09:58:07.840000-06:00 DEBUG start diaspora_production.posts 20842
2021-02-12T09:58:07.840000-06:00 NOTICE DONE copying diaspora_production.taggings in 14.239s
2021-02-12T09:58:07.840000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {100740F653}>
2021-02-12T09:58:07.840000-06:00 SQL MySQL: sending query: SELECT `id`, `author_id`, `public`, `guid`, `type`, `text`, `created_at`, `updated_at`, `provider_display_name`, `root_guid`, `likes_count`, `comments_count`, `o_embed_cache_id`, `reshares_count`, `interacted_at`, `tweet_id`, `open_graph_cache_id`, `tumblr_ids` FROM `posts`
2021-02-12T09:58:07.847000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1034798973}>
2021-02-12T09:58:07.847000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:07.847000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:07.848000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10286DF0B3}>
2021-02-12T09:58:07.848000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:07.848000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:07.852000-06:00 NOTICE CREATE INDEX idx_260015_index_taggings_on_tag_id ON diaspora_production.taggings (tag_id);
2021-02-12T09:58:07.855000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10286DAAD3}>
2021-02-12T09:58:07.855000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:07.855000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:07.855000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1034799F13}>
2021-02-12T09:58:07.855000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:07.855000-06:00 NOTICE CREATE UNIQUE INDEX idx_260015_index_taggings_uniquely ON diaspora_production.taggings (taggable_id, taggable_type, tag_id);
2021-02-12T09:58:07.855000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10286DD5C3}>
2021-02-12T09:58:07.855000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:07.855000-06:00 NOTICE CREATE INDEX idx_260015_index_taggings_on_created_at ON diaspora_production.taggings (created_at);
2021-02-12T09:58:07.855000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:07.856000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:07.857000-06:00 NOTICE CREATE INDEX idx_260015_index_taggings_on_taggable_id_and_taggable_type_and_context ON diaspora_production.taggings (taggable_id, taggable_type, context);
2021-02-12T09:58:07.858000-06:00 WARNING PostgreSQL warning: identifier "idx_260015_index_taggings_on_taggable_id_and_taggable_type_and_context" will be truncated to "idx_260015_index_taggings_on_taggable_id_and_taggable_type_and_"
2021-02-12T09:58:07.858000-06:00 NOTICE CREATE UNIQUE INDEX idx_260015_primary ON diaspora_production.taggings (id);
2021-02-12T09:58:23.203000-06:00 DEBUG Reader for diaspora_production.participations is done in 15.803000s
2021-02-12T09:58:23.203000-06:00 NOTICE COPY diaspora_production.open_graph_caches with 844573 rows estimated [3/4]
2021-02-12T09:58:23.203000-06:00 DEBUG Reader started for diaspora_production.open_graph_caches
2021-02-12T09:58:23.203000-06:00 DEBUG start diaspora_production.open_graph_caches 36207
2021-02-12T09:58:23.203000-06:00 DEBUG Finished processing READER for "diaspora_production.participations" 15.803000s
2021-02-12T09:58:23.204000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {101FA890F3}>
2021-02-12T09:58:23.204000-06:00 SQL MySQL: sending query: SELECT `id`, `title`, `ob_type`, `image`, `url`, `description`, `video_url` FROM `open_graph_caches`
2021-02-12T09:58:23.298000-06:00 DEBUG stop diaspora_production.participations | 20404 .. 36302 = 15.898d0
2021-02-12T09:58:23.298000-06:00 DEBUG Writer[2] for diaspora_production.participations is done in 13.099000s
2021-02-12T09:58:23.298000-06:00 DEBUG Finished processing WRITER for "diaspora_production.participations" 13.099000s
2021-02-12T09:58:23.298000-06:00 DEBUG writers-counts[diaspora_production.participations] = 0
2021-02-12T09:58:23.298000-06:00 NOTICE DONE copying diaspora_production.participations in 13.099s
2021-02-12T09:58:23.299000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:23.301000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1042D2DBF3}>
2021-02-12T09:58:23.302000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:23.302000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1042D57293}>
2021-02-12T09:58:23.302000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:23.302000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:23.302000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:23.302000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:23.302000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.open_graph_caches (id title
ob_type
image url
description
video_url)
2021-02-12T09:58:23.304000-06:00 NOTICE CREATE UNIQUE INDEX idx_259824_index_participations_on_target_id_and_target_type_and_author_id ON diaspora_production.participations (target_id, target_type, author_id);
2021-02-12T09:58:23.304000-06:00 WARNING PostgreSQL warning: identifier "idx_259824_index_participations_on_target_id_and_target_type_and_author_id" will be truncated to "idx_259824_index_participations_on_target_id_and_target_type_an"
2021-02-12T09:58:23.305000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1042D52B93}>
2021-02-12T09:58:23.305000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:23.305000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:23.305000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1042D54473}>
2021-02-12T09:58:23.305000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:23.305000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:23.305000-06:00 NOTICE CREATE INDEX idx_259824_index_participations_on_author_id ON diaspora_production.participations (author_id);
2021-02-12T09:58:23.305000-06:00 NOTICE CREATE INDEX idx_259824_index_participations_on_guid ON diaspora_production.participations (guid);
2021-02-12T09:58:23.305000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1043647DD3}>
2021-02-12T09:58:23.305000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:23.308000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:23.322000-06:00 NOTICE CREATE UNIQUE INDEX idx_259824_primary ON diaspora_production.participations (id);
2021-02-12T09:58:47.185000-06:00 DEBUG Reader for diaspora_production.open_graph_caches is done in 23.982000s
2021-02-12T09:58:47.185000-06:00 NOTICE COPY diaspora_production.tags with 353681 rows estimated [3/4]
2021-02-12T09:58:47.185000-06:00 DEBUG Reader started for diaspora_production.tags
2021-02-12T09:58:47.186000-06:00 DEBUG start diaspora_production.tags 60189
2021-02-12T09:58:47.186000-06:00 DEBUG Finished processing READER for "diaspora_production.open_graph_caches" 23.982000s
2021-02-12T09:58:47.186000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67B8B3}>
2021-02-12T09:58:47.186000-06:00 SQL MySQL: sending query: SELECT `id`, `name`, `taggings_count` FROM `tags`
2021-02-12T09:58:49.588000-06:00 DEBUG stop diaspora_production.open_graph_caches | 36207 .. 62592 = 26.385d0
2021-02-12T09:58:49.588000-06:00 DEBUG Writer[2] for diaspora_production.open_graph_caches is done in 25.139000s
2021-02-12T09:58:49.588000-06:00 DEBUG Finished processing WRITER for "diaspora_production.open_graph_caches" 25.139000s
2021-02-12T09:58:49.588000-06:00 DEBUG writers-counts[diaspora_production.open_graph_caches] = 0
2021-02-12T09:58:49.588000-06:00 NOTICE DONE copying diaspora_production.open_graph_caches in 25.139s
2021-02-12T09:58:49.588000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:49.591000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101DDD2313}>
2021-02-12T09:58:49.591000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:49.591000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101D9847E3}>
2021-02-12T09:58:49.591000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:49.591000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:49.591000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:49.591000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:49.591000-06:00 NOTICE CREATE UNIQUE INDEX idx_259773_primary ON diaspora_production.open_graph_caches (id);
2021-02-12T09:58:49.592000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.tags (id name taggings_count)
2021-02-12T09:58:50.389000-06:00 DEBUG Reader for diaspora_production.tags is done in 3.204000s
2021-02-12T09:58:50.389000-06:00 NOTICE COPY diaspora_production.o_embed_caches with 165567 rows estimated [3/4]
2021-02-12T09:58:50.390000-06:00 DEBUG Reader started for diaspora_production.o_embed_caches
2021-02-12T09:58:50.390000-06:00 DEBUG start diaspora_production.o_embed_caches 63393
2021-02-12T09:58:50.390000-06:00 DEBUG Finished processing READER for "diaspora_production.tags" 3.204000s
2021-02-12T09:58:50.390000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67B903}>
2021-02-12T09:58:50.390000-06:00 SQL MySQL: sending query: SELECT `id`, `url`, `data` FROM `o_embed_caches`
2021-02-12T09:58:51.004000-06:00 DEBUG stop diaspora_production.tags | 60189 .. 64008 = 3.819d0
2021-02-12T09:58:51.005000-06:00 DEBUG Writer[2] for diaspora_production.tags is done in 0.689000s
2021-02-12T09:58:51.005000-06:00 DEBUG Finished processing WRITER for "diaspora_production.tags" 0.689000s
2021-02-12T09:58:51.005000-06:00 DEBUG writers-counts[diaspora_production.tags] = 0
2021-02-12T09:58:51.005000-06:00 NOTICE DONE copying diaspora_production.tags in 0.689s
2021-02-12T09:58:51.005000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:51.009000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CAB88E3}>
2021-02-12T09:58:51.009000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:51.009000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DFC3AF3}>
2021-02-12T09:58:51.009000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:51.009000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:51.009000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:51.010000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DFC2563}>
2021-02-12T09:58:51.010000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:51.010000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:51.010000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:51.010000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.o_embed_caches (id url data)
2021-02-12T09:58:51.010000-06:00 NOTICE CREATE UNIQUE INDEX idx_260024_primary ON diaspora_production.tags (id);
2021-02-12T09:58:51.010000-06:00 NOTICE CREATE UNIQUE INDEX idx_260024_index_tags_on_name ON diaspora_production.tags (name);
2021-02-12T09:58:55.814000-06:00 DEBUG Reader for diaspora_production.posts is done in 47.976000s
2021-02-12T09:58:55.814000-06:00 NOTICE COPY diaspora_production.comments with 730660 rows estimated [1/4]
2021-02-12T09:58:55.814000-06:00 DEBUG Reader started for diaspora_production.comments
2021-02-12T09:58:55.814000-06:00 DEBUG start diaspora_production.comments 68818
2021-02-12T09:58:55.814000-06:00 DEBUG Finished processing READER for "diaspora_production.posts" 47.976000s
2021-02-12T09:58:55.814000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C3D3}>
2021-02-12T09:58:55.814000-06:00 SQL MySQL: sending query: SELECT `id`, `text`, `commentable_id`, `author_id`, `guid`, `created_at`, `updated_at`, `likes_count`, `commentable_type` FROM `comments`
2021-02-12T09:58:56.457000-06:00 DEBUG Reader for diaspora_production.o_embed_caches is done in 6.068000s
2021-02-12T09:58:56.457000-06:00 NOTICE COPY diaspora_production.people with 35388 rows estimated [3/4]
2021-02-12T09:58:56.457000-06:00 DEBUG Reader started for diaspora_production.people
2021-02-12T09:58:56.457000-06:00 DEBUG start diaspora_production.people 69461
2021-02-12T09:58:56.458000-06:00 DEBUG Finished processing READER for "diaspora_production.o_embed_caches" 6.068000s
2021-02-12T09:58:56.458000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67B953}>
2021-02-12T09:58:56.458000-06:00 SQL MySQL: sending query: SELECT `id`, `guid`, `diaspora_handle`, `serialized_public_key`, `owner_id`, `created_at`, `updated_at`, `closed_account`, `fetch_status`, `pod_id` FROM `people`
2021-02-12T09:58:57.251000-06:00 DEBUG Reader for diaspora_production.people is done in 0.794000s
2021-02-12T09:58:57.251000-06:00 NOTICE COPY diaspora_production.share_visibilities with 19254 rows estimated [3/4]
2021-02-12T09:58:57.251000-06:00 DEBUG Reader started for diaspora_production.share_visibilities
2021-02-12T09:58:57.252000-06:00 DEBUG start diaspora_production.share_visibilities 70255
2021-02-12T09:58:57.252000-06:00 DEBUG Finished processing READER for "diaspora_production.people" 0.794000s
2021-02-12T09:58:57.252000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BA13}>
2021-02-12T09:58:57.252000-06:00 SQL MySQL: sending query: SELECT `id`, `shareable_id`, `hidden`, `shareable_type`, `user_id` FROM `share_visibilities`
2021-02-12T09:58:57.305000-06:00 DEBUG Reader for diaspora_production.share_visibilities is done in 0.054000s
2021-02-12T09:58:57.305000-06:00 NOTICE COPY diaspora_production.notifications with 11772 rows estimated [3/4]
2021-02-12T09:58:57.305000-06:00 DEBUG Reader started for diaspora_production.notifications
2021-02-12T09:58:57.305000-06:00 DEBUG start diaspora_production.notifications 70309
2021-02-12T09:58:57.305000-06:00 DEBUG Finished processing READER for "diaspora_production.share_visibilities" 0.054000s
2021-02-12T09:58:57.306000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BA83}>
2021-02-12T09:58:57.306000-06:00 SQL MySQL: sending query: SELECT `id`, `target_type`, `target_id`, `recipient_id`, `unread`, `created_at`, `updated_at`, `type` FROM `notifications`
2021-02-12T09:58:57.358000-06:00 DEBUG Reader for diaspora_production.notifications is done in 0.053000s
2021-02-12T09:58:57.359000-06:00 NOTICE COPY diaspora_production.like_signatures with 5944 rows estimated [3/4]
2021-02-12T09:58:57.359000-06:00 DEBUG Reader started for diaspora_production.like_signatures
2021-02-12T09:58:57.359000-06:00 DEBUG start diaspora_production.like_signatures 70362
2021-02-12T09:58:57.359000-06:00 DEBUG Finished processing READER for "diaspora_production.notifications" 0.053000s
2021-02-12T09:58:57.359000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BB23}>
2021-02-12T09:58:57.359000-06:00 SQL MySQL: sending query: SELECT `like_id`, `author_signature`, `signature_order_id`, `additional_data` FROM `like_signatures`
2021-02-12T09:58:57.431000-06:00 DEBUG Reader for diaspora_production.like_signatures is done in 0.073000s
2021-02-12T09:58:57.431000-06:00 NOTICE COPY diaspora_production.aspect_memberships with 3213 rows estimated [3/4]
2021-02-12T09:58:57.431000-06:00 DEBUG Reader started for diaspora_production.aspect_memberships
2021-02-12T09:58:57.432000-06:00 DEBUG start diaspora_production.aspect_memberships 70435
2021-02-12T09:58:57.432000-06:00 DEBUG Finished processing READER for "diaspora_production.like_signatures" 0.073000s
2021-02-12T09:58:57.432000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BB83}>
2021-02-12T09:58:57.432000-06:00 SQL MySQL: sending query: SELECT `id`, `aspect_id`, `contact_id`, `created_at`, `updated_at` FROM `aspect_memberships`
2021-02-12T09:58:57.439000-06:00 DEBUG Reader for diaspora_production.aspect_memberships is done in 0.008000s
2021-02-12T09:58:57.439000-06:00 NOTICE COPY diaspora_production.aspect_visibilities with 2341 rows estimated [3/4]
2021-02-12T09:58:57.439000-06:00 DEBUG Reader started for diaspora_production.aspect_visibilities
2021-02-12T09:58:57.440000-06:00 DEBUG start diaspora_production.aspect_visibilities 70443
2021-02-12T09:58:57.440000-06:00 DEBUG Finished processing READER for "diaspora_production.aspect_memberships" 0.008000s
2021-02-12T09:58:57.440000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BBF3}>
2021-02-12T09:58:57.440000-06:00 SQL MySQL: sending query: SELECT `id`, `shareable_id`, `aspect_id`, `shareable_type` FROM `aspect_visibilities`
2021-02-12T09:58:57.444000-06:00 DEBUG Reader for diaspora_production.aspect_visibilities is done in 0.005000s
2021-02-12T09:58:57.444000-06:00 NOTICE COPY diaspora_production.comment_signatures with 1521 rows estimated [3/4]
2021-02-12T09:58:57.444000-06:00 DEBUG Reader started for diaspora_production.comment_signatures
2021-02-12T09:58:57.444000-06:00 DEBUG start diaspora_production.comment_signatures 70448
2021-02-12T09:58:57.444000-06:00 DEBUG Finished processing READER for "diaspora_production.aspect_visibilities" 0.005000s
2021-02-12T09:58:57.444000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BC53}>
2021-02-12T09:58:57.444000-06:00 SQL MySQL: sending query: SELECT `comment_id`, `author_signature`, `signature_order_id`, `additional_data` FROM `comment_signatures`
2021-02-12T09:58:57.464000-06:00 DEBUG Reader for diaspora_production.comment_signatures is done in 0.020000s
2021-02-12T09:58:57.464000-06:00 NOTICE COPY diaspora_production.poll_answers with 1101 rows estimated [3/4]
2021-02-12T09:58:57.464000-06:00 DEBUG Reader started for diaspora_production.poll_answers
2021-02-12T09:58:57.464000-06:00 DEBUG start diaspora_production.poll_answers 70468
2021-02-12T09:58:57.464000-06:00 DEBUG Finished processing READER for "diaspora_production.comment_signatures" 0.020000s
2021-02-12T09:58:57.464000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BCB3}>
2021-02-12T09:58:57.464000-06:00 SQL MySQL: sending query: SELECT `id`, `answer`, `poll_id`, `guid`, `vote_count` FROM `poll_answers`
2021-02-12T09:58:57.468000-06:00 DEBUG Reader for diaspora_production.poll_answers is done in 0.004000s
2021-02-12T09:58:57.468000-06:00 NOTICE COPY diaspora_production."references" with 753 rows estimated [3/4]
2021-02-12T09:58:57.468000-06:00 DEBUG Reader started for diaspora_production."references"
2021-02-12T09:58:57.469000-06:00 DEBUG start diaspora_production."references" 70472
2021-02-12T09:58:57.469000-06:00 DEBUG Finished processing READER for "diaspora_production.poll_answers" 0.004000s
2021-02-12T09:58:57.469000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BD23}>
2021-02-12T09:58:57.469000-06:00 SQL MySQL: sending query: SELECT `id`, `source_id`, `source_type`, `target_id`, `target_type` FROM `references`
2021-02-12T09:58:57.471000-06:00 DEBUG Reader for diaspora_production."references" is done in 0.003000s
2021-02-12T09:58:57.471000-06:00 NOTICE COPY diaspora_production.locations with 308 rows estimated [3/4]
2021-02-12T09:58:57.471000-06:00 DEBUG Reader started for diaspora_production.locations
2021-02-12T09:58:57.471000-06:00 DEBUG start diaspora_production.locations 70475
2021-02-12T09:58:57.471000-06:00 DEBUG Finished processing READER for "diaspora_production.\"references\"" 0.003000s
2021-02-12T09:58:57.471000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BD93}>
2021-02-12T09:58:57.471000-06:00 SQL MySQL: sending query: SELECT `id`, `address`, `lat`, `lng`, `status_message_id`, `created_at`, `updated_at` FROM `locations`
2021-02-12T09:58:57.474000-06:00 DEBUG Reader for diaspora_production.locations is done in 0.003000s
2021-02-12T09:58:57.474000-06:00 NOTICE COPY diaspora_production.user_preferences with 188 rows estimated [3/4]
2021-02-12T09:58:57.474000-06:00 DEBUG Reader started for diaspora_production.user_preferences
2021-02-12T09:58:57.474000-06:00 DEBUG start diaspora_production.user_preferences 70478
2021-02-12T09:58:57.474000-06:00 DEBUG Finished processing READER for "diaspora_production.locations" 0.003000s
2021-02-12T09:58:57.474000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BE23}>
2021-02-12T09:58:57.474000-06:00 SQL MySQL: sending query: SELECT `id`, `email_type`, `user_id`, `created_at`, `updated_at` FROM `user_preferences`
2021-02-12T09:58:57.475000-06:00 DEBUG Reader for diaspora_production.user_preferences is done in 0.001000s
2021-02-12T09:58:57.475000-06:00 NOTICE COPY diaspora_production.messages with 102 rows estimated [3/4]
2021-02-12T09:58:57.475000-06:00 DEBUG Reader started for diaspora_production.messages
2021-02-12T09:58:57.475000-06:00 DEBUG start diaspora_production.messages 70479
2021-02-12T09:58:57.475000-06:00 DEBUG Finished processing READER for "diaspora_production.user_preferences" 0.001000s
2021-02-12T09:58:57.475000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BE93}>
2021-02-12T09:58:57.475000-06:00 SQL MySQL: sending query: SELECT `id`, `conversation_id`, `author_id`, `guid`, `text`, `created_at`, `updated_at` FROM `messages`
2021-02-12T09:58:57.477000-06:00 DEBUG Reader for diaspora_production.messages is done in 0.002000s
2021-02-12T09:58:57.477000-06:00 NOTICE COPY diaspora_production.blocks with 70 rows estimated [3/4]
2021-02-12T09:58:57.477000-06:00 DEBUG Reader started for diaspora_production.blocks
2021-02-12T09:58:57.477000-06:00 DEBUG start diaspora_production.blocks 70481
2021-02-12T09:58:57.477000-06:00 DEBUG Finished processing READER for "diaspora_production.messages" 0.002000s
2021-02-12T09:58:57.477000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BF23}>
2021-02-12T09:58:57.477000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `person_id` FROM `blocks`
2021-02-12T09:58:57.477000-06:00 DEBUG Reader for diaspora_production.blocks is done in 0.000000s
2021-02-12T09:58:57.477000-06:00 NOTICE COPY diaspora_production.conversations with 25 rows estimated [3/4]
2021-02-12T09:58:57.477000-06:00 DEBUG Reader started for diaspora_production.conversations
2021-02-12T09:58:57.478000-06:00 DEBUG start diaspora_production.conversations 70481
2021-02-12T09:58:57.478000-06:00 DEBUG Finished processing READER for "diaspora_production.blocks" 0.000000s
2021-02-12T09:58:57.478000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BF73}>
2021-02-12T09:58:57.478000-06:00 SQL MySQL: sending query: SELECT `id`, `subject`, `guid`, `author_id`, `created_at`, `updated_at` FROM `conversations`
2021-02-12T09:58:57.478000-06:00 DEBUG Reader for diaspora_production.conversations is done in 0.001000s
2021-02-12T09:58:57.478000-06:00 NOTICE COPY diaspora_production.signature_orders with 9 rows estimated [3/4]
2021-02-12T09:58:57.478000-06:00 DEBUG Reader started for diaspora_production.signature_orders
2021-02-12T09:58:57.478000-06:00 DEBUG start diaspora_production.signature_orders 70482
2021-02-12T09:58:57.478000-06:00 DEBUG Finished processing READER for "diaspora_production.conversations" 0.001000s
2021-02-12T09:58:57.478000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67BFF3}>
2021-02-12T09:58:57.478000-06:00 SQL MySQL: sending query: SELECT `id`, `order` FROM `signature_orders`
2021-02-12T09:58:57.478000-06:00 DEBUG Reader for diaspora_production.signature_orders is done in 0.000000s
2021-02-12T09:58:57.478000-06:00 NOTICE COPY diaspora_production.simple_captcha_data with 3 rows estimated [3/4]
2021-02-12T09:58:57.478000-06:00 DEBUG Reader started for diaspora_production.simple_captcha_data
2021-02-12T09:58:57.479000-06:00 DEBUG start diaspora_production.simple_captcha_data 70482
2021-02-12T09:58:57.479000-06:00 DEBUG Finished processing READER for "diaspora_production.signature_orders" 0.000000s
2021-02-12T09:58:57.479000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C033}>
2021-02-12T09:58:57.479000-06:00 SQL MySQL: sending query: SELECT `id`, `key`, `value`, `created_at`, `updated_at` FROM `simple_captcha_data`
2021-02-12T09:58:57.479000-06:00 DEBUG Reader for diaspora_production.simple_captcha_data is done in 0.001000s
2021-02-12T09:58:57.479000-06:00 NOTICE COPY diaspora_production.ar_internal_metadata with 0 rows estimated [3/4]
2021-02-12T09:58:57.479000-06:00 DEBUG Reader started for diaspora_production.ar_internal_metadata
2021-02-12T09:58:57.479000-06:00 DEBUG start diaspora_production.ar_internal_metadata 70483
2021-02-12T09:58:57.479000-06:00 DEBUG Finished processing READER for "diaspora_production.simple_captcha_data" 0.001000s
2021-02-12T09:58:57.479000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C0A3}>
2021-02-12T09:58:57.479000-06:00 SQL MySQL: sending query: SELECT `key`, `value`, `created_at`, `updated_at` FROM `ar_internal_metadata`
2021-02-12T09:58:57.479000-06:00 DEBUG Reader for diaspora_production.ar_internal_metadata is done in 0.000000s
2021-02-12T09:58:57.479000-06:00 NOTICE COPY diaspora_production.chat_contacts with 0 rows estimated [3/4]
2021-02-12T09:58:57.479000-06:00 DEBUG Reader started for diaspora_production.chat_contacts
2021-02-12T09:58:57.480000-06:00 DEBUG start diaspora_production.chat_contacts 70483
2021-02-12T09:58:57.480000-06:00 DEBUG Finished processing READER for "diaspora_production.ar_internal_metadata" 0.000000s
2021-02-12T09:58:57.480000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C103}>
2021-02-12T09:58:57.480000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `jid`, `name`, `ask`, `subscription` FROM `chat_contacts`
2021-02-12T09:58:57.480000-06:00 DEBUG Reader for diaspora_production.chat_contacts is done in 0.001000s
2021-02-12T09:58:57.480000-06:00 NOTICE COPY diaspora_production.chat_offline_messages with 0 rows estimated [3/4]
2021-02-12T09:58:57.480000-06:00 DEBUG Reader started for diaspora_production.chat_offline_messages
2021-02-12T09:58:57.480000-06:00 DEBUG start diaspora_production.chat_offline_messages 70484
2021-02-12T09:58:57.480000-06:00 DEBUG Finished processing READER for "diaspora_production.chat_contacts" 0.001000s
2021-02-12T09:58:57.480000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C183}>
2021-02-12T09:58:57.480000-06:00 SQL MySQL: sending query: SELECT `id`, `from`, `to`, `message`, `created_at` FROM `chat_offline_messages`
2021-02-12T09:58:57.480000-06:00 DEBUG Reader for diaspora_production.chat_offline_messages is done in 0.000000s
2021-02-12T09:58:57.480000-06:00 NOTICE COPY diaspora_production.o_auth_applications with 0 rows estimated [3/4]
2021-02-12T09:58:57.480000-06:00 DEBUG Reader started for diaspora_production.o_auth_applications
2021-02-12T09:58:57.480000-06:00 DEBUG start diaspora_production.o_auth_applications 70484
2021-02-12T09:58:57.481000-06:00 DEBUG Finished processing READER for "diaspora_production.chat_offline_messages" 0.000000s
2021-02-12T09:58:57.481000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C1F3}>
2021-02-12T09:58:57.481000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `client_id`, `client_secret`, `client_name`, `redirect_uris`, `response_types`, `grant_types`, `application_type`, `contacts`, `logo_uri`, `client_uri`, `policy_uri`, `tos_uri`, `sector_identifier_uri`, `token_endpoint_auth_method`, `jwks`, `jwks_uri`, `ppid`, `created_at`, `updated_at` FROM `o_auth_applications`
2021-02-12T09:58:57.481000-06:00 DEBUG Reader for diaspora_production.o_auth_applications is done in 0.001000s
2021-02-12T09:58:57.481000-06:00 NOTICE COPY diaspora_production.ppid with 0 rows estimated [3/4]
2021-02-12T09:58:57.481000-06:00 DEBUG Reader started for diaspora_production.ppid
2021-02-12T09:58:57.481000-06:00 DEBUG start diaspora_production.ppid 70485
2021-02-12T09:58:57.481000-06:00 DEBUG Finished processing READER for "diaspora_production.o_auth_applications" 0.001000s
2021-02-12T09:58:57.481000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C363}>
2021-02-12T09:58:57.481000-06:00 SQL MySQL: sending query: SELECT `id`, `o_auth_application_id`, `user_id`, `guid`, `identifier` FROM `ppid`
2021-02-12T09:58:57.481000-06:00 DEBUG Reader for diaspora_production.ppid is done in 0.000000s
2021-02-12T09:58:57.481000-06:00 DEBUG Finished processing READER for "diaspora_production.ppid" 0.000000s
2021-02-12T09:58:57.481000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:57.483000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10701B73F3}>
2021-02-12T09:58:57.483000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:57.484000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:57.484000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:57.484000-06:00 INFO pgsql:copy-rows-from-queue[3]: diaspora_production.comments (id text
commentable_id
author_id guid
created_at
updated_at
likes_count
commentable_type)
2021-02-12T09:58:59.582000-06:00 DEBUG stop diaspora_production.posts | 20842 .. 72586 = 51.744d0
2021-02-12T09:58:59.582000-06:00 DEBUG Writer[0] for diaspora_production.posts is done in 49.601000s
2021-02-12T09:58:59.582000-06:00 DEBUG Finished processing WRITER for "diaspora_production.posts" 49.601000s
2021-02-12T09:58:59.583000-06:00 DEBUG writers-counts[diaspora_production.posts] = 0
2021-02-12T09:58:59.583000-06:00 NOTICE DONE copying diaspora_production.posts in 49.601s
2021-02-12T09:58:59.583000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:58:59.586000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F5F68C3}>
2021-02-12T09:58:59.586000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.586000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104EE973}>
2021-02-12T09:58:59.586000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.587000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104F52B3}>
2021-02-12T09:58:59.587000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.587000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.588000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104F3D23}>
2021-02-12T09:58:59.588000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.588000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.588000-06:00 NOTICE CREATE UNIQUE INDEX idx_259909_primary ON diaspora_production.posts (id);
2021-02-12T09:58:59.589000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104ED123}>
2021-02-12T09:58:59.589000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.589000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.589000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104F0743}>
2021-02-12T09:58:59.589000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.589000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.590000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.590000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.590000-06:00 NOTICE CREATE UNIQUE INDEX idx_259909_index_posts_on_guid ON diaspora_production.posts (guid);
2021-02-12T09:58:59.590000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:58:59.590000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.mentions (id
mentions_container_id
person_id
mentions_container_type)
2021-02-12T09:58:59.591000-06:00 NOTICE CREATE INDEX idx_259909_index_posts_on_id_and_type ON diaspora_production.posts (id, type);
2021-02-12T09:58:59.591000-06:00 NOTICE CREATE INDEX idx_259909_index_posts_on_created_at_and_id ON diaspora_production.posts (created_at, id);
2021-02-12T09:58:59.593000-06:00 NOTICE CREATE INDEX idx_259909_index_posts_on_root_guid ON diaspora_production.posts (root_guid);
2021-02-12T09:58:59.596000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104EB0E3}>
2021-02-12T09:58:59.596000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.597000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10104F2233}>
2021-02-12T09:58:59.597000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:58:59.597000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.602000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:58:59.605000-06:00 NOTICE CREATE INDEX idx_259909_index_posts_on_person_id ON diaspora_production.posts (author_id);
2021-02-12T09:58:59.612000-06:00 NOTICE CREATE UNIQUE INDEX idx_259909_index_posts_on_author_id_and_root_guid ON diaspora_production.posts (author_id, root_guid);
2021-02-12T09:59:03.777000-06:00 DEBUG stop diaspora_production.o_embed_caches | 63393 .. 76781 = 13.388d0
2021-02-12T09:59:03.777000-06:00 DEBUG Writer[2] for diaspora_production.o_embed_caches is done in 12.493000s
2021-02-12T09:59:03.777000-06:00 DEBUG Finished processing WRITER for "diaspora_production.o_embed_caches" 12.493000s
2021-02-12T09:59:03.777000-06:00 DEBUG writers-counts[diaspora_production.o_embed_caches] = 0
2021-02-12T09:59:03.777000-06:00 NOTICE DONE copying diaspora_production.o_embed_caches in 12.493s
2021-02-12T09:59:03.777000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:03.780000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B42C0D3}>
2021-02-12T09:59:03.780000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:03.780000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A2F44E3}>
2021-02-12T09:59:03.780000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:03.780000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:03.780000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:03.780000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:03.781000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.people (id guid
diaspora_handle
serialized_public_key
owner_id created_at
updated_at
closed_account
fetch_status pod_id)
2021-02-12T09:59:03.781000-06:00 NOTICE CREATE UNIQUE INDEX idx_259815_primary ON diaspora_production.o_embed_caches (id);
2021-02-12T09:59:03.789000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B42AAF3}>
2021-02-12T09:59:03.789000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:03.789000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:03.790000-06:00 NOTICE CREATE INDEX idx_259815_index_o_embed_caches_on_url ON diaspora_production.o_embed_caches (url);
2021-02-12T09:59:05.685000-06:00 DEBUG stop diaspora_production.people | 69461 .. 78689 = 9.228d0
2021-02-12T09:59:05.685000-06:00 DEBUG Writer[2] for diaspora_production.people is done in 1.820000s
2021-02-12T09:59:05.685000-06:00 DEBUG Finished processing WRITER for "diaspora_production.people" 1.820000s
2021-02-12T09:59:05.685000-06:00 DEBUG writers-counts[diaspora_production.people] = 0
2021-02-12T09:59:05.685000-06:00 NOTICE DONE copying diaspora_production.people in 1.820s
2021-02-12T09:59:05.685000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:05.698000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B8E74C3}>
2021-02-12T09:59:05.698000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.698000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.699000-06:00 NOTICE CREATE UNIQUE INDEX idx_259832_index_people_on_owner_id ON diaspora_production.people (owner_id);
2021-02-12T09:59:05.705000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {104FE0DFE3}>
2021-02-12T09:59:05.705000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.706000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.707000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B79FF13}>
2021-02-12T09:59:05.707000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.708000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B9E7E13}>
2021-02-12T09:59:05.708000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.708000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100BA47523}>
2021-02-12T09:59:05.708000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.708000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.708000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.708000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.709000-06:00 NOTICE CREATE INDEX idx_259832_people_pod_id_fk ON diaspora_production.people (pod_id);
2021-02-12T09:59:05.709000-06:00 NOTICE CREATE UNIQUE INDEX idx_259832_primary ON diaspora_production.people (id);
2021-02-12T09:59:05.710000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:05.710000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.share_visibilities (id
shareable_id
hidden
shareable_type
user_id)
2021-02-12T09:59:05.713000-06:00 NOTICE CREATE UNIQUE INDEX idx_259832_index_people_on_guid ON diaspora_production.people (guid);
2021-02-12T09:59:05.740000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100B42EB93}>
2021-02-12T09:59:05.740000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.744000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.764000-06:00 NOTICE CREATE UNIQUE INDEX idx_259832_index_people_on_diaspora_handle ON diaspora_production.people (diaspora_handle);
2021-02-12T09:59:05.792000-06:00 DEBUG stop diaspora_production.share_visibilities | 70255 .. 78796 = 8.541d0
2021-02-12T09:59:05.792000-06:00 DEBUG Writer[2] for diaspora_production.share_visibilities is done in 0.059000s
2021-02-12T09:59:05.792000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:05.793000-06:00 DEBUG Finished processing WRITER for "diaspora_production.share_visibilities" 0.059000s
2021-02-12T09:59:05.793000-06:00 DEBUG writers-counts[diaspora_production.share_visibilities] = 0
2021-02-12T09:59:05.793000-06:00 NOTICE DONE copying diaspora_production.share_visibilities in 0.059s
2021-02-12T09:59:05.800000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100D97FBF3}>
2021-02-12T09:59:05.800000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.800000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.800000-06:00 NOTICE CREATE UNIQUE INDEX idx_259993_shareable_and_user_id ON diaspora_production.share_visibilities (shareable_id, shareable_type, user_id);
2021-02-12T09:59:05.809000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100D70FA63}>
2021-02-12T09:59:05.809000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.811000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1052993D23}>
2021-02-12T09:59:05.811000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.811000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.811000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.811000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100D867A93}>
2021-02-12T09:59:05.811000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.812000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:05.819000-06:00 NOTICE CREATE INDEX idx_259993_index_share_visibilities_on_user_id ON diaspora_production.share_visibilities (user_id);
2021-02-12T09:59:05.819000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.820000-06:00 NOTICE CREATE INDEX idx_259993_shareable_and_hidden_and_user_id ON diaspora_production.share_visibilities (shareable_id, shareable_type, hidden, user_id);
2021-02-12T09:59:05.820000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.notifications (id
target_type
target_id
recipient_id
unread
created_at
updated_at
type)
2021-02-12T09:59:05.820000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100D5E7B43}>
2021-02-12T09:59:05.820000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.828000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.856000-06:00 NOTICE CREATE INDEX idx_259993_index_post_visibilities_on_post_id ON diaspora_production.share_visibilities (shareable_id);
2021-02-12T09:59:05.868000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100D7FE543}>
2021-02-12T09:59:05.868000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.868000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.892000-06:00 NOTICE CREATE UNIQUE INDEX idx_259993_primary ON diaspora_production.share_visibilities (id);
2021-02-12T09:59:05.959000-06:00 DEBUG stop diaspora_production.notifications | 70309 .. 78963 = 8.654d0
2021-02-12T09:59:05.959000-06:00 DEBUG Writer[2] for diaspora_production.notifications is done in 0.106000s
2021-02-12T09:59:05.959000-06:00 DEBUG Finished processing WRITER for "diaspora_production.notifications" 0.106000s
2021-02-12T09:59:05.959000-06:00 DEBUG writers-counts[diaspora_production.notifications] = 0
2021-02-12T09:59:05.959000-06:00 NOTICE DONE copying diaspora_production.notifications in 0.106s
2021-02-12T09:59:05.959000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:05.962000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1013A37FD3}>
2021-02-12T09:59:05.962000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.963000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.963000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1054E75EA3}>
2021-02-12T09:59:05.963000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.963000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.963000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:05.963000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.like_signatures (like_id
author_signature
signature_order_id
additional_data)
2021-02-12T09:59:05.964000-06:00 NOTICE CREATE INDEX idx_259755_index_notifications_on_target_type_and_target_id ON diaspora_production.notifications (target_type, target_id);
2021-02-12T09:59:05.964000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1012F2FF03}>
2021-02-12T09:59:05.964000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.964000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101293F763}>
2021-02-12T09:59:05.964000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.967000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.967000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.967000-06:00 NOTICE CREATE INDEX idx_259755_index_notifications_on_target_id ON diaspora_production.notifications (target_id);
2021-02-12T09:59:05.967000-06:00 NOTICE CREATE INDEX idx_259755_index_notifications_on_recipient_id ON diaspora_production.notifications (recipient_id);
2021-02-12T09:59:05.967000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1013B0FD93}>
2021-02-12T09:59:05.967000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:05.967000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:05.967000-06:00 NOTICE CREATE UNIQUE INDEX idx_259755_primary ON diaspora_production.notifications (id);
2021-02-12T09:59:06.513000-06:00 DEBUG stop diaspora_production.like_signatures | 70362 .. 79517 = 9.155d0
2021-02-12T09:59:06.513000-06:00 DEBUG Writer[2] for diaspora_production.like_signatures is done in 0.208000s
2021-02-12T09:59:06.513000-06:00 DEBUG Finished processing WRITER for "diaspora_production.like_signatures" 0.208000s
2021-02-12T09:59:06.513000-06:00 DEBUG writers-counts[diaspora_production.like_signatures] = 0
2021-02-12T09:59:06.514000-06:00 NOTICE DONE copying diaspora_production.like_signatures in 0.208s
2021-02-12T09:59:06.514000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.516000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1006CE49C3}>
2021-02-12T09:59:06.516000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.516000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1006C51B53}>
2021-02-12T09:59:06.516000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.516000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1006CE2B53}>
2021-02-12T09:59:06.516000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.516000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.516000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.516000-06:00 NOTICE CREATE INDEX idx_259720_like_signatures_signature_orders_id_fk ON diaspora_production.like_signatures (signature_order_id);
2021-02-12T09:59:06.516000-06:00 NOTICE CREATE UNIQUE INDEX idx_259720_index_like_signatures_on_like_id ON diaspora_production.like_signatures (like_id);
2021-02-12T09:59:06.517000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.517000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.517000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.aspect_memberships (id
aspect_id
contact_id
created_at
updated_at)
2021-02-12T09:59:06.619000-06:00 DEBUG stop diaspora_production.aspect_memberships | 70435 .. 79623 = 9.188d0
2021-02-12T09:59:06.620000-06:00 DEBUG Writer[2] for diaspora_production.aspect_memberships is done in 0.009000s
2021-02-12T09:59:06.620000-06:00 DEBUG Finished processing WRITER for "diaspora_production.aspect_memberships" 0.009000s
2021-02-12T09:59:06.620000-06:00 DEBUG writers-counts[diaspora_production.aspect_memberships] = 0
2021-02-12T09:59:06.620000-06:00 NOTICE DONE copying diaspora_production.aspect_memberships in 0.009s
2021-02-12T09:59:06.620000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.622000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100799A933}>
2021-02-12T09:59:06.622000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.622000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1007737DB3}>
2021-02-12T09:59:06.622000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.623000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.623000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.623000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.623000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1007AE72A3}>
2021-02-12T09:59:06.623000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.624000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.aspect_visibilities (id
shareable_id
aspect_id
shareable_type)
2021-02-12T09:59:06.624000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.624000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1006CE78E3}>
2021-02-12T09:59:06.624000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.624000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.624000-06:00 NOTICE CREATE UNIQUE INDEX idx_259602_primary ON diaspora_production.aspect_memberships (id);
2021-02-12T09:59:06.624000-06:00 NOTICE CREATE UNIQUE INDEX idx_259602_index_aspect_memberships_on_aspect_id_and_contact_id ON diaspora_production.aspect_memberships (aspect_id, contact_id);
2021-02-12T09:59:06.624000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1007A5FC53}>
2021-02-12T09:59:06.624000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.624000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.625000-06:00 NOTICE CREATE INDEX idx_259602_index_aspect_memberships_on_contact_id ON diaspora_production.aspect_memberships (contact_id);
2021-02-12T09:59:06.627000-06:00 NOTICE CREATE INDEX idx_259602_index_aspect_memberships_on_aspect_id ON diaspora_production.aspect_memberships (aspect_id);
2021-02-12T09:59:06.645000-06:00 DEBUG stop diaspora_production.aspect_visibilities | 70443 .. 79649 = 9.206d0
2021-02-12T09:59:06.645000-06:00 DEBUG Writer[2] for diaspora_production.aspect_visibilities is done in 0.002000s
2021-02-12T09:59:06.645000-06:00 DEBUG Finished processing WRITER for "diaspora_production.aspect_visibilities" 0.002000s
2021-02-12T09:59:06.645000-06:00 DEBUG writers-counts[diaspora_production.aspect_visibilities] = 0
2021-02-12T09:59:06.645000-06:00 NOTICE DONE copying diaspora_production.aspect_visibilities in 0.002s
2021-02-12T09:59:06.645000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.648000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1008033E43}>
2021-02-12T09:59:06.648000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.648000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.649000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10080779C3}>
2021-02-12T09:59:06.649000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.649000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.649000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.649000-06:00 NOTICE CREATE UNIQUE INDEX idx_259608_index_aspect_visibilities_on_shareable_and_aspect_id ON diaspora_production.aspect_visibilities (shareable_id, shareable_type, aspect_id);
2021-02-12T09:59:06.652000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1007F8F873}>
2021-02-12T09:59:06.652000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.652000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.652000-06:00 NOTICE CREATE INDEX idx_259608_index_aspect_visibilities_on_aspect_id ON diaspora_production.aspect_visibilities (aspect_id);
2021-02-12T09:59:06.658000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.comment_signatures (comment_id
author_signature
signature_order_id
additional_data)
2021-02-12T09:59:06.658000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1008336F33}>
2021-02-12T09:59:06.658000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.668000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100831F063}>
2021-02-12T09:59:06.668000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.668000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.669000-06:00 NOTICE CREATE INDEX idx_259608_index_aspect_visibilities_on_shareable_id_and_shareable_type ON diaspora_production.aspect_visibilities (shareable_id, shareable_type);
2021-02-12T09:59:06.669000-06:00 WARNING PostgreSQL warning: identifier "idx_259608_index_aspect_visibilities_on_shareable_id_and_shareable_type" will be truncated to "idx_259608_index_aspect_visibilities_on_shareable_id_and_sharea"
2021-02-12T09:59:06.673000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.673000-06:00 NOTICE CREATE UNIQUE INDEX idx_259608_primary ON diaspora_production.aspect_visibilities (id);
2021-02-12T09:59:06.722000-06:00 DEBUG stop diaspora_production.comment_signatures | 70448 .. 79726 = 9.278d0
2021-02-12T09:59:06.722000-06:00 DEBUG Writer[2] for diaspora_production.comment_signatures is done in 0.050000s
2021-02-12T09:59:06.722000-06:00 DEBUG Finished processing WRITER for "diaspora_production.comment_signatures" 0.050000s
2021-02-12T09:59:06.722000-06:00 DEBUG writers-counts[diaspora_production.comment_signatures] = 0
2021-02-12T09:59:06.722000-06:00 NOTICE DONE copying diaspora_production.comment_signatures in 0.050s
2021-02-12T09:59:06.722000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.724000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A0E89F3}>
2021-02-12T09:59:06.725000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.725000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1009DD4B83}>
2021-02-12T09:59:06.725000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.725000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.725000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1008ECFFD3}>
2021-02-12T09:59:06.725000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.725000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.725000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.725000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.725000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.poll_answers (id answer
poll_id guid
vote_count)
2021-02-12T09:59:06.725000-06:00 NOTICE CREATE UNIQUE INDEX idx_259674_index_comment_signatures_on_comment_id ON diaspora_production.comment_signatures (comment_id);
2021-02-12T09:59:06.725000-06:00 NOTICE CREATE INDEX idx_259674_comment_signatures_signature_orders_id_fk ON diaspora_production.comment_signatures (signature_order_id);
2021-02-12T09:59:06.745000-06:00 DEBUG stop diaspora_production.poll_answers | 70468 .. 79749 = 9.281d0
2021-02-12T09:59:06.745000-06:00 DEBUG Writer[2] for diaspora_production.poll_answers is done in 0.005000s
2021-02-12T09:59:06.745000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.748000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A35B573}>
2021-02-12T09:59:06.748000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.749000-06:00 DEBUG Finished processing WRITER for "diaspora_production.poll_answers" 0.005000s
2021-02-12T09:59:06.749000-06:00 DEBUG writers-counts[diaspora_production.poll_answers] = 0
2021-02-12T09:59:06.749000-06:00 NOTICE DONE copying diaspora_production.poll_answers in 0.005s
2021-02-12T09:59:06.749000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.749000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.749000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production."references" (id source_id
source_type
target_id
target_type)
2021-02-12T09:59:06.753000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A0EB623}>
2021-02-12T09:59:06.753000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.753000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A0EE9F3}>
2021-02-12T09:59:06.753000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.754000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.754000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.756000-06:00 NOTICE CREATE UNIQUE INDEX idx_259885_index_poll_answers_on_guid ON diaspora_production.poll_answers (guid);
2021-02-12T09:59:06.756000-06:00 NOTICE CREATE UNIQUE INDEX idx_259885_primary ON diaspora_production.poll_answers (id);
2021-02-12T09:59:06.756000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100A0ED413}>
2021-02-12T09:59:06.756000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.760000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.760000-06:00 NOTICE CREATE INDEX idx_259885_index_poll_answers_on_poll_id ON diaspora_production.poll_answers (poll_id);
2021-02-12T09:59:06.764000-06:00 DEBUG stop diaspora_production."references" | 70472 .. 79766 = 9.294d0
2021-02-12T09:59:06.764000-06:00 DEBUG Writer[2] for diaspora_production."references" is done in 0.002000s
2021-02-12T09:59:06.764000-06:00 DEBUG Finished processing WRITER for "diaspora_production.\"references\"" 0.002000s
2021-02-12T09:59:06.764000-06:00 DEBUG writers-counts[diaspora_production."references"] = 0
2021-02-12T09:59:06.764000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.764000-06:00 NOTICE DONE copying diaspora_production."references" in 0.002s
2021-02-12T09:59:06.767000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AB476A3}>
2021-02-12T09:59:06.767000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.767000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.768000-06:00 NOTICE CREATE UNIQUE INDEX idx_259954_index_references_on_source_and_target ON diaspora_production."references" (source_id, source_type, target_id, target_type);
2021-02-12T09:59:06.768000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AB5D063}>
2021-02-12T09:59:06.769000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.769000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AA37F73}>
2021-02-12T09:59:06.769000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.769000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.769000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.769000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.770000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.locations (id address lat
lng
status_message_id
created_at
updated_at)
2021-02-12T09:59:06.770000-06:00 NOTICE CREATE INDEX idx_259954_index_references_on_source_id_and_source_type ON diaspora_production."references" (source_id, source_type);
2021-02-12T09:59:06.771000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AB5E643}>
2021-02-12T09:59:06.771000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.771000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.772000-06:00 NOTICE CREATE UNIQUE INDEX idx_259954_primary ON diaspora_production."references" (id);
2021-02-12T09:59:06.807000-06:00 DEBUG stop diaspora_production.locations | 70475 .. 79808 = 9.333d0
2021-02-12T09:59:06.807000-06:00 DEBUG Writer[2] for diaspora_production.locations is done in 0.002000s
2021-02-12T09:59:06.807000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.807000-06:00 DEBUG Finished processing WRITER for "diaspora_production.locations" 0.002000s
2021-02-12T09:59:06.807000-06:00 DEBUG writers-counts[diaspora_production.locations] = 0
2021-02-12T09:59:06.807000-06:00 NOTICE DONE copying diaspora_production.locations in 0.002s
2021-02-12T09:59:06.810000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100ACFFE23}>
2021-02-12T09:59:06.810000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.810000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.810000-06:00 NOTICE CREATE UNIQUE INDEX idx_259728_primary ON diaspora_production.locations (id);
2021-02-12T09:59:06.811000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AC7FFB3}>
2021-02-12T09:59:06.812000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.812000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100AC6A433}>
2021-02-12T09:59:06.812000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.812000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.812000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.812000-06:00 NOTICE CREATE INDEX idx_259728_index_locations_on_status_message_id ON diaspora_production.locations (status_message_id);
2021-02-12T09:59:06.812000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.812000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.user_preferences (id
email_type
user_id
created_at
updated_at)
2021-02-12T09:59:06.848000-06:00 DEBUG stop diaspora_production.user_preferences | 70478 .. 79852 = 9.374d0
2021-02-12T09:59:06.848000-06:00 DEBUG Writer[2] for diaspora_production.user_preferences is done in 0.001000s
2021-02-12T09:59:06.848000-06:00 DEBUG Finished processing WRITER for "diaspora_production.user_preferences" 0.001000s
2021-02-12T09:59:06.848000-06:00 DEBUG writers-counts[diaspora_production.user_preferences] = 0
2021-02-12T09:59:06.849000-06:00 NOTICE DONE copying diaspora_production.user_preferences in 0.001s
2021-02-12T09:59:06.849000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.852000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100BC57FD3}>
2021-02-12T09:59:06.852000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.852000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.852000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100BCAFDC3}>
2021-02-12T09:59:06.853000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.853000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.853000-06:00 NOTICE CREATE UNIQUE INDEX idx_260069_primary ON diaspora_production.user_preferences (id);
2021-02-12T09:59:06.853000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100BA570C3}>
2021-02-12T09:59:06.853000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.853000-06:00 NOTICE CREATE INDEX idx_260069_index_user_preferences_on_user_id_and_email_type ON diaspora_production.user_preferences (user_id, email_type);
2021-02-12T09:59:06.854000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.857000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.857000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.messages (id conversation_id
author_id guid
text created_at
updated_at)
2021-02-12T09:59:06.869000-06:00 DEBUG stop diaspora_production.messages | 70479 .. 79873 = 9.394d0
2021-02-12T09:59:06.869000-06:00 DEBUG Writer[2] for diaspora_production.messages is done in 0.002000s
2021-02-12T09:59:06.869000-06:00 DEBUG Finished processing WRITER for "diaspora_production.messages" 0.002000s
2021-02-12T09:59:06.869000-06:00 DEBUG writers-counts[diaspora_production.messages] = 0
2021-02-12T09:59:06.869000-06:00 NOTICE DONE copying diaspora_production.messages in 0.002s
2021-02-12T09:59:06.869000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.874000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100C64DD93}>
2021-02-12T09:59:06.874000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.875000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100C82E863}>
2021-02-12T09:59:06.875000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.875000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.876000-06:00 NOTICE CREATE UNIQUE INDEX idx_259746_primary ON diaspora_production.messages (id);
2021-02-12T09:59:06.878000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.878000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100C5B9A23}>
2021-02-12T09:59:06.878000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.878000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100C7BFE93}>
2021-02-12T09:59:06.878000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.878000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.878000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.878000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.878000-06:00 NOTICE CREATE INDEX idx_259746_index_messages_on_author_id ON diaspora_production.messages (author_id);
2021-02-12T09:59:06.878000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.blocks (id user_id person_id)
2021-02-12T09:59:06.880000-06:00 NOTICE CREATE INDEX idx_259746_messages_conversation_id_fk ON diaspora_production.messages (conversation_id);
2021-02-12T09:59:06.881000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100C64F623}>
2021-02-12T09:59:06.881000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.882000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.883000-06:00 NOTICE CREATE UNIQUE INDEX idx_259746_index_messages_on_guid ON diaspora_production.messages (guid);
2021-02-12T09:59:06.890000-06:00 DEBUG stop diaspora_production.blocks | 70481 .. 79894 = 9.413d0
2021-02-12T09:59:06.890000-06:00 DEBUG Writer[2] for diaspora_production.blocks is done in 0.000000s
2021-02-12T09:59:06.890000-06:00 DEBUG Finished processing WRITER for "diaspora_production.blocks" 0.000000s
2021-02-12T09:59:06.890000-06:00 DEBUG writers-counts[diaspora_production.blocks] = 0
2021-02-12T09:59:06.890000-06:00 NOTICE DONE copying diaspora_production.blocks in 0.000s
2021-02-12T09:59:06.891000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.894000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CDD8773}>
2021-02-12T09:59:06.894000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.894000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CDD9D03}>
2021-02-12T09:59:06.894000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.894000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.894000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.895000-06:00 NOTICE CREATE UNIQUE INDEX idx_259630_primary ON diaspora_production.blocks (id);
2021-02-12T09:59:06.897000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CAD2443}>
2021-02-12T09:59:06.897000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.898000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.899000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.899000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.conversations (id subject
guid
author_id
created_at
updated_at)
2021-02-12T09:59:06.904000-06:00 NOTICE CREATE UNIQUE INDEX idx_259630_index_blocks_on_user_id_and_person_id ON diaspora_production.blocks (user_id, person_id);
2021-02-12T09:59:06.936000-06:00 DEBUG stop diaspora_production.conversations | 70481 .. 79938 = 9.457d0
2021-02-12T09:59:06.936000-06:00 DEBUG Writer[2] for diaspora_production.conversations is done in 0.001000s
2021-02-12T09:59:06.936000-06:00 DEBUG Finished processing WRITER for "diaspora_production.conversations" 0.001000s
2021-02-12T09:59:06.936000-06:00 DEBUG writers-counts[diaspora_production.conversations] = 0
2021-02-12T09:59:06.936000-06:00 NOTICE DONE copying diaspora_production.conversations in 0.001s
2021-02-12T09:59:06.936000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.937000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CFFC643}>
2021-02-12T09:59:06.937000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.939000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CDDF833}>
2021-02-12T09:59:06.939000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.939000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CDDC963}>
2021-02-12T09:59:06.939000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.939000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.939000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.940000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.940000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.signature_orders (id "order")
2021-02-12T09:59:06.940000-06:00 NOTICE CREATE INDEX idx_259690_conversations_author_id_fk ON diaspora_production.conversations (author_id);
2021-02-12T09:59:06.940000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.941000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100CDDE253}>
2021-02-12T09:59:06.941000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.942000-06:00 NOTICE CREATE UNIQUE INDEX idx_259690_primary ON diaspora_production.conversations (id);
2021-02-12T09:59:06.942000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.943000-06:00 NOTICE CREATE UNIQUE INDEX idx_259690_index_conversations_on_guid ON diaspora_production.conversations (guid);
2021-02-12T09:59:06.954000-06:00 DEBUG stop diaspora_production.signature_orders | 70482 .. 79955 = 9.473d0
2021-02-12T09:59:06.954000-06:00 DEBUG Writer[2] for diaspora_production.signature_orders is done in 0.000000s
2021-02-12T09:59:06.954000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.954000-06:00 DEBUG Finished processing WRITER for "diaspora_production.signature_orders" 0.000000s
2021-02-12T09:59:06.954000-06:00 DEBUG writers-counts[diaspora_production.signature_orders] = 0
2021-02-12T09:59:06.954000-06:00 NOTICE DONE copying diaspora_production.signature_orders in 0.000s
2021-02-12T09:59:06.955000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DF990F3}>
2021-02-12T09:59:06.955000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.955000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.955000-06:00 NOTICE CREATE UNIQUE INDEX idx_260001_primary ON diaspora_production.signature_orders (id);
2021-02-12T09:59:06.956000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DF4FB23}>
2021-02-12T09:59:06.956000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.956000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.957000-06:00 NOTICE CREATE UNIQUE INDEX idx_260001_index_signature_orders_on_order ON diaspora_production.signature_orders ("order");
2021-02-12T09:59:06.957000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DADF203}>
2021-02-12T09:59:06.957000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.957000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.958000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.958000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.simple_captcha_data (id key
value
created_at
updated_at)
2021-02-12T09:59:06.977000-06:00 DEBUG stop diaspora_production.simple_captcha_data | 70482 .. 79979 = 9.497d0
2021-02-12T09:59:06.977000-06:00 DEBUG Writer[2] for diaspora_production.simple_captcha_data is done in 0.000000s
2021-02-12T09:59:06.977000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.977000-06:00 DEBUG Finished processing WRITER for "diaspora_production.simple_captcha_data" 0.000000s
2021-02-12T09:59:06.977000-06:00 DEBUG writers-counts[diaspora_production.simple_captcha_data] = 0
2021-02-12T09:59:06.977000-06:00 NOTICE DONE copying diaspora_production.simple_captcha_data in 0.000s
2021-02-12T09:59:06.978000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100E13CD03}>
2021-02-12T09:59:06.978000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.980000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.980000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.980000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.ar_internal_metadata (key
value
created_at
updated_at)
2021-02-12T09:59:06.980000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DF9B2B3}>
2021-02-12T09:59:06.980000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.980000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DF9C893}>
2021-02-12T09:59:06.980000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.980000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.981000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.981000-06:00 NOTICE CREATE INDEX idx_260007_idx_key ON diaspora_production.simple_captcha_data (key);
2021-02-12T09:59:06.981000-06:00 NOTICE CREATE UNIQUE INDEX idx_260007_primary ON diaspora_production.simple_captcha_data (id);
2021-02-12T09:59:06.994000-06:00 DEBUG stop diaspora_production.ar_internal_metadata | 70483 .. 79998 = 9.515d0
2021-02-12T09:59:06.994000-06:00 DEBUG Writer[2] for diaspora_production.ar_internal_metadata is done in 0.000000s
2021-02-12T09:59:06.994000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:06.996000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100E79F963}>
2021-02-12T09:59:06.996000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.996000-06:00 DEBUG Finished processing WRITER for "diaspora_production.ar_internal_metadata" 0.000000s
2021-02-12T09:59:06.996000-06:00 DEBUG writers-counts[diaspora_production.ar_internal_metadata] = 0
2021-02-12T09:59:06.996000-06:00 NOTICE DONE copying diaspora_production.ar_internal_metadata in 0.000s
2021-02-12T09:59:06.997000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.997000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:06.997000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.chat_contacts (id user_id
jid name ask
subscription)
2021-02-12T09:59:06.999000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100DF9EDA3}>
2021-02-12T09:59:06.999000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:06.999000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:06.999000-06:00 DEBUG stop diaspora_production.chat_contacts | 70483 .. 80003 = 9.52d0
2021-02-12T09:59:06.999000-06:00 DEBUG Writer[2] for diaspora_production.chat_contacts is done in 0.000000s
2021-02-12T09:59:06.999000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:07.000000-06:00 DEBUG Finished processing WRITER for "diaspora_production.chat_contacts" 0.000000s
2021-02-12T09:59:07.000000-06:00 DEBUG writers-counts[diaspora_production.chat_contacts] = 0
2021-02-12T09:59:07.001000-06:00 NOTICE DONE copying diaspora_production.chat_contacts in 0.000s
2021-02-12T09:59:07.001000-06:00 NOTICE CREATE UNIQUE INDEX idx_259585_primary ON diaspora_production.ar_internal_metadata (key);
2021-02-12T09:59:07.004000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100EE01D33}>
2021-02-12T09:59:07.004000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.004000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.004000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100ED4A3A3}>
2021-02-12T09:59:07.004000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.005000-06:00 NOTICE CREATE UNIQUE INDEX idx_259636_index_chat_contacts_on_user_id_and_jid ON diaspora_production.chat_contacts (user_id, jid);
2021-02-12T09:59:07.007000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.008000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:07.008000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.chat_offline_messages (id
"from"
"to"
message
created_at)
2021-02-12T09:59:07.008000-06:00 DEBUG stop diaspora_production.chat_offline_messages | 70484 .. 80012 = 9.528d0
2021-02-12T09:59:07.008000-06:00 DEBUG Writer[2] for diaspora_production.chat_offline_messages is done in 0.000000s
2021-02-12T09:59:07.008000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:07.008000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100EE03313}>
2021-02-12T09:59:07.008000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.009000-06:00 DEBUG Finished processing WRITER for "diaspora_production.chat_offline_messages" 0.000000s
2021-02-12T09:59:07.009000-06:00 DEBUG writers-counts[diaspora_production.chat_offline_messages] = 0
2021-02-12T09:59:07.009000-06:00 NOTICE DONE copying diaspora_production.chat_offline_messages in 0.000s
2021-02-12T09:59:07.010000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.011000-06:00 NOTICE CREATE UNIQUE INDEX idx_259636_primary ON diaspora_production.chat_contacts (id);
2021-02-12T09:59:07.012000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F0663B3}>
2021-02-12T09:59:07.013000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100EE05703}>
2021-02-12T09:59:07.013000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.013000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.013000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.013000-06:00 NOTICE CREATE UNIQUE INDEX idx_259656_primary ON diaspora_production.chat_offline_messages (id);
2021-02-12T09:59:07.017000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.017000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:07.017000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.o_auth_applications (id
user_id
client_id
client_secret
client_name
redirect_uris
response_types
grant_types
application_type
contacts
logo_uri
client_uri
policy_uri
tos_uri
sector_identifier_uri
token_endpoint_auth_method
jwks
jwks_uri
ppid
created_at
updated_at)
2021-02-12T09:59:07.018000-06:00 DEBUG stop diaspora_production.o_auth_applications | 70484 .. 80022 = 9.538d0
2021-02-12T09:59:07.018000-06:00 DEBUG Writer[2] for diaspora_production.o_auth_applications is done in 0.000000s
2021-02-12T09:59:07.018000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:07.018000-06:00 DEBUG Finished processing WRITER for "diaspora_production.o_auth_applications" 0.000000s
2021-02-12T09:59:07.018000-06:00 DEBUG writers-counts[diaspora_production.o_auth_applications] = 0
2021-02-12T09:59:07.018000-06:00 NOTICE DONE copying diaspora_production.o_auth_applications in 0.000s
2021-02-12T09:59:07.021000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F0A7E43}>
2021-02-12T09:59:07.021000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.021000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.021000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F287FD3}>
2021-02-12T09:59:07.022000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:07.022000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.022000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F2A9803}>
2021-02-12T09:59:07.022000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.022000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.022000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.022000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.ppid (id
o_auth_application_id
user_id guid
identifier)
2021-02-12T09:59:07.022000-06:00 NOTICE CREATE INDEX idx_259791_index_o_auth_applications_on_user_id ON diaspora_production.o_auth_applications (user_id);
2021-02-12T09:59:07.023000-06:00 NOTICE CREATE UNIQUE INDEX idx_259791_index_o_auth_applications_on_client_id ON diaspora_production.o_auth_applications (client_id);
2021-02-12T09:59:07.024000-06:00 DEBUG stop diaspora_production.ppid | 70485 .. 80028 = 9.543d0
2021-02-12T09:59:07.029000-06:00 DEBUG Writer[2] for diaspora_production.ppid is done in 0.000000s
2021-02-12T09:59:07.029000-06:00 DEBUG Finished processing WRITER for "diaspora_production.ppid" 0.000000s
2021-02-12T09:59:07.029000-06:00 DEBUG writers-counts[diaspora_production.ppid] = 0
2021-02-12T09:59:07.029000-06:00 NOTICE DONE copying diaspora_production.ppid in 0.000s
2021-02-12T09:59:07.029000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:07.029000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F38FCF3}>
2021-02-12T09:59:07.029000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.029000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.029000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:07.029000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.photos (id author_id public
guid pending text
remote_photo_path
remote_photo_name
random_string
processed_image
created_at
updated_at
unprocessed_image
status_message_guid
comments_count
height width)
2021-02-12T09:59:07.043000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F457FF3}>
2021-02-12T09:59:07.044000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.044000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.044000-06:00 NOTICE CREATE UNIQUE INDEX idx_259925_primary ON diaspora_production.ppid (id);
2021-02-12T09:59:07.058000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F2AF763}>
2021-02-12T09:59:07.058000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.059000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.059000-06:00 NOTICE CREATE INDEX idx_259925_index_ppid_on_user_id ON diaspora_production.ppid (user_id);
2021-02-12T09:59:07.072000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F2ADC83}>
2021-02-12T09:59:07.072000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.072000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {100F2AADE3}>
2021-02-12T09:59:07.072000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:07.073000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.073000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:07.073000-06:00 NOTICE CREATE UNIQUE INDEX idx_259791_primary ON diaspora_production.o_auth_applications (id);
2021-02-12T09:59:07.073000-06:00 NOTICE CREATE INDEX idx_259925_index_ppid_on_o_auth_application_id ON diaspora_production.ppid (o_auth_application_id);
2021-02-12T09:59:09.384000-06:00 DEBUG Reader for diaspora_production.comments is done in 13.570000s
2021-02-12T09:59:09.385000-06:00 NOTICE COPY diaspora_production.mentions with 166637 rows estimated [1/4]
2021-02-12T09:59:09.385000-06:00 DEBUG Reader started for diaspora_production.mentions
2021-02-12T09:59:09.385000-06:00 DEBUG start diaspora_production.mentions 82388
2021-02-12T09:59:09.385000-06:00 DEBUG Finished processing READER for "diaspora_production.comments" 13.570000s
2021-02-12T09:59:09.385000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C483}>
2021-02-12T09:59:09.385000-06:00 SQL MySQL: sending query: SELECT `id`, `mentions_container_id`, `person_id`, `mentions_container_type` FROM `mentions`
2021-02-12T09:59:09.932000-06:00 DEBUG Reader for diaspora_production.mentions is done in 0.548000s
2021-02-12T09:59:09.932000-06:00 NOTICE COPY diaspora_production.photos with 152030 rows estimated [1/4]
2021-02-12T09:59:09.932000-06:00 DEBUG Reader started for diaspora_production.photos
2021-02-12T09:59:09.932000-06:00 DEBUG start diaspora_production.photos 82936
2021-02-12T09:59:09.932000-06:00 DEBUG Finished processing READER for "diaspora_production.mentions" 0.548000s
2021-02-12T09:59:09.932000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C4E3}>
2021-02-12T09:59:09.933000-06:00 SQL MySQL: sending query: SELECT `id`, `author_id`, `public`, `guid`, `pending`, `text`, `remote_photo_path`, `remote_photo_name`, `random_string`, `processed_image`, `created_at`, `updated_at`, `unprocessed_image`, `status_message_guid`, `comments_count`, `height`, `width` FROM `photos`
2021-02-12T09:59:09.979000-06:00 DEBUG stop diaspora_production.mentions | 82388 .. 82983 = 0.595d0
2021-02-12T09:59:09.979000-06:00 DEBUG Writer[0] for diaspora_production.mentions is done in 0.319000s
2021-02-12T09:59:09.980000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:09.984000-06:00 DEBUG Finished processing WRITER for "diaspora_production.mentions" 0.319000s
2021-02-12T09:59:09.984000-06:00 DEBUG writers-counts[diaspora_production.mentions] = 0
2021-02-12T09:59:09.985000-06:00 NOTICE DONE copying diaspora_production.mentions in 0.319s
2021-02-12T09:59:09.985000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1018343713}>
2021-02-12T09:59:09.985000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:09.985000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1044555543}>
2021-02-12T09:59:09.985000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:09.986000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:09.986000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:09.986000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:09.986000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.profiles (id diaspora_handle
first_name
last_name
image_url
image_url_small
image_url_medium
birthday gender
bio searchable
person_id
created_at
updated_at
location full_name
nsfw
public_details)
2021-02-12T09:59:09.987000-06:00 NOTICE CREATE INDEX idx_259740_index_mentions_on_mc_id_and_mc_type ON diaspora_production.mentions (mentions_container_id, mentions_container_type);
2021-02-12T09:59:09.987000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1018347E13}>
2021-02-12T09:59:09.987000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:09.987000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1019DB7D43}>
2021-02-12T09:59:09.987000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:09.987000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:09.987000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:09.988000-06:00 NOTICE CREATE UNIQUE INDEX idx_259740_primary ON diaspora_production.mentions (id);
2021-02-12T09:59:09.988000-06:00 NOTICE CREATE INDEX idx_259740_index_mentions_on_person_id ON diaspora_production.mentions (person_id);
2021-02-12T09:59:09.989000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10183462E3}>
2021-02-12T09:59:09.989000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:09.990000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:09.990000-06:00 NOTICE CREATE UNIQUE INDEX idx_259740_index_mentions_on_person_and_mc_id_and_mc_type ON diaspora_production.mentions (person_id, mentions_container_id, mentions_container_type);
2021-02-12T09:59:10.749000-06:00 DEBUG stop diaspora_production.comments | 68818 .. 83753 = 14.935d0
2021-02-12T09:59:10.749000-06:00 DEBUG Writer[3] for diaspora_production.comments is done in 12.372000s
2021-02-12T09:59:10.749000-06:00 DEBUG Finished processing WRITER for "diaspora_production.comments" 12.372000s
2021-02-12T09:59:10.749000-06:00 DEBUG writers-counts[diaspora_production.comments] = 0
2021-02-12T09:59:10.749000-06:00 NOTICE DONE copying diaspora_production.comments in 12.372s
2021-02-12T09:59:10.749000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:10.935000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E2A7FF3}>
2021-02-12T09:59:10.935000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:10.935000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E2FF583}>
2021-02-12T09:59:10.936000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E69FD63}>
2021-02-12T09:59:10.936000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {105A205FE3}>
2021-02-12T09:59:10.936000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:10.936000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:10.936000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:10.936000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {101E2FDA53}>
2021-02-12T09:59:10.936000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:10.936000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:10.936000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:10.937000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:10.937000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:10.937000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:10.937000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:10.937000-06:00 INFO pgsql:copy-rows-from-queue[3]: diaspora_production.notification_actors (id
notification_id
person_id
created_at
updated_at)
2021-02-12T09:59:10.937000-06:00 NOTICE CREATE INDEX idx_259665_index_comments_on_person_id ON diaspora_production.comments (author_id);
2021-02-12T09:59:10.937000-06:00 NOTICE CREATE UNIQUE INDEX idx_259665_primary ON diaspora_production.comments (id);
2021-02-12T09:59:10.937000-06:00 NOTICE CREATE UNIQUE INDEX idx_259665_index_comments_on_guid ON diaspora_production.comments (guid);
2021-02-12T09:59:10.937000-06:00 NOTICE CREATE INDEX idx_259665_index_comments_on_commentable_id_and_commentable_type ON diaspora_production.comments (commentable_id, commentable_type);
2021-02-12T09:59:10.937000-06:00 WARNING PostgreSQL warning: identifier "idx_259665_index_comments_on_commentable_id_and_commentable_type" will be truncated to "idx_259665_index_comments_on_commentable_id_and_commentable_typ"
2021-02-12T09:59:11.822000-06:00 DEBUG Reader for diaspora_production.photos is done in 1.890000s
2021-02-12T09:59:11.822000-06:00 NOTICE COPY diaspora_production.profiles with 35204 rows estimated [1/4]
2021-02-12T09:59:11.822000-06:00 DEBUG Reader started for diaspora_production.profiles
2021-02-12T09:59:11.823000-06:00 DEBUG start diaspora_production.profiles 84826
2021-02-12T09:59:11.823000-06:00 DEBUG Finished processing READER for "diaspora_production.photos" 1.890000s
2021-02-12T09:59:11.823000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C613}>
2021-02-12T09:59:11.823000-06:00 SQL MySQL: sending query: SELECT `id`, `diaspora_handle`, `first_name`, `last_name`, `image_url`, `image_url_small`, `image_url_medium`, `birthday`, `gender`, `bio`, `searchable`, `person_id`, `created_at`, `updated_at`, `location`, `full_name`, `nsfw`, `public_details` FROM `profiles`
2021-02-12T09:59:12.078000-06:00 DEBUG stop diaspora_production.photos | 82936 .. 85082 = 2.146d0
2021-02-12T09:59:12.078000-06:00 DEBUG Writer[2] for diaspora_production.photos is done in 1.998000s
2021-02-12T09:59:12.079000-06:00 DEBUG Finished processing WRITER for "diaspora_production.photos" 1.998000s
2021-02-12T09:59:12.079000-06:00 DEBUG writers-counts[diaspora_production.photos] = 0
2021-02-12T09:59:12.079000-06:00 NOTICE DONE copying diaspora_production.photos in 1.998s
2021-02-12T09:59:12.079000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.084000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {108A76FF73}>
2021-02-12T09:59:12.085000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.085000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.085000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1059F22AB3}>
2021-02-12T09:59:12.085000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.085000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.086000-06:00 NOTICE CREATE INDEX idx_259843_index_photos_on_author_id ON diaspora_production.photos (author_id);
2021-02-12T09:59:12.092000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1059F26133}>
2021-02-12T09:59:12.092000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.093000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.093000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.093000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.aspects (id name user_id
created_at
updated_at order_id
chat_enabled
post_default)
2021-02-12T09:59:12.093000-06:00 NOTICE CREATE INDEX idx_259843_index_photos_on_status_message_guid ON diaspora_production.photos (status_message_guid);
2021-02-12T09:59:12.093000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1059F24303}>
2021-02-12T09:59:12.093000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.093000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.093000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {1059F276C3}>
2021-02-12T09:59:12.093000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.093000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.093000-06:00 NOTICE CREATE UNIQUE INDEX idx_259843_index_photos_on_guid ON diaspora_production.photos (guid);
2021-02-12T09:59:12.098000-06:00 NOTICE CREATE UNIQUE INDEX idx_259843_primary ON diaspora_production.photos (id);
2021-02-12T09:59:12.260000-06:00 DEBUG Reader for diaspora_production.profiles is done in 0.438000s
2021-02-12T09:59:12.260000-06:00 NOTICE COPY diaspora_production.notification_actors with 15735 rows estimated [1/4]
2021-02-12T09:59:12.260000-06:00 DEBUG Reader started for diaspora_production.notification_actors
2021-02-12T09:59:12.261000-06:00 DEBUG start diaspora_production.notification_actors 85264
2021-02-12T09:59:12.261000-06:00 DEBUG Finished processing READER for "diaspora_production.profiles" 0.438000s
2021-02-12T09:59:12.261000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C753}>
2021-02-12T09:59:12.261000-06:00 SQL MySQL: sending query: SELECT `id`, `notification_id`, `person_id`, `created_at`, `updated_at` FROM `notification_actors`
2021-02-12T09:59:12.352000-06:00 DEBUG Reader for diaspora_production.notification_actors is done in 0.092000s
2021-02-12T09:59:12.352000-06:00 NOTICE COPY diaspora_production.aspects with 9933 rows estimated [1/4]
2021-02-12T09:59:12.352000-06:00 DEBUG Reader started for diaspora_production.aspects
2021-02-12T09:59:12.353000-06:00 DEBUG start diaspora_production.aspects 85356
2021-02-12T09:59:12.353000-06:00 DEBUG Finished processing READER for "diaspora_production.notification_actors" 0.092000s
2021-02-12T09:59:12.353000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C7C3}>
2021-02-12T09:59:12.353000-06:00 SQL MySQL: sending query: SELECT `id`, `name`, `user_id`, `created_at`, `updated_at`, `order_id`, `chat_enabled`, `post_default` FROM `aspects`
2021-02-12T09:59:12.424000-06:00 DEBUG stop diaspora_production.notification_actors | 85264 .. 85428 = 0.164d0
2021-02-12T09:59:12.424000-06:00 DEBUG Writer[3] for diaspora_production.notification_actors is done in 0.058000s
2021-02-12T09:59:12.424000-06:00 DEBUG Finished processing WRITER for "diaspora_production.notification_actors" 0.058000s
2021-02-12T09:59:12.424000-06:00 DEBUG writers-counts[diaspora_production.notification_actors] = 0
2021-02-12T09:59:12.424000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.424000-06:00 NOTICE DONE copying diaspora_production.notification_actors in 0.058s
2021-02-12T09:59:12.436000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A526EB03}>
2021-02-12T09:59:12.436000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.440000-06:00 DEBUG Reader for diaspora_production.aspects is done in 0.088000s
2021-02-12T09:59:12.440000-06:00 NOTICE COPY diaspora_production.contacts with 3400 rows estimated [1/4]
2021-02-12T09:59:12.440000-06:00 DEBUG Reader started for diaspora_production.contacts
2021-02-12T09:59:12.440000-06:00 DEBUG start diaspora_production.contacts 85444
2021-02-12T09:59:12.440000-06:00 DEBUG Finished processing READER for "diaspora_production.aspects" 0.088000s
2021-02-12T09:59:12.440000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.440000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A488D583}>
2021-02-12T09:59:12.440000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.441000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A526B6B3}>
2021-02-12T09:59:12.441000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.442000-06:00 NOTICE CREATE UNIQUE INDEX idx_259767_primary ON diaspora_production.notification_actors (id);
2021-02-12T09:59:12.444000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A5268DD3}>
2021-02-12T09:59:12.444000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.444000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.444000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A526D523}>
2021-02-12T09:59:12.444000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.444000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C863}>
2021-02-12T09:59:12.444000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `person_id`, `created_at`, `updated_at`, `sharing`, `receiving` FROM `contacts`
2021-02-12T09:59:12.446000-06:00 NOTICE CREATE UNIQUE INDEX idx_259767_index_notification_actors_on_notification_id_and_person_id ON diaspora_production.notification_actors (notification_id, person_id);
2021-02-12T09:59:12.446000-06:00 WARNING PostgreSQL warning: identifier "idx_259767_index_notification_actors_on_notification_id_and_person_id" will be truncated to "idx_259767_index_notification_actors_on_notification_id_and_per"
2021-02-12T09:59:12.452000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.452000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.452000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.456000-06:00 NOTICE CREATE INDEX idx_259767_index_notification_actors_on_person_id ON diaspora_production.notification_actors (person_id);
2021-02-12T09:59:12.464000-06:00 DEBUG stop diaspora_production.aspects | 85356 .. 85466 = 0.11d0
2021-02-12T09:59:12.464000-06:00 DEBUG Writer[2] for diaspora_production.aspects is done in 0.048000s
2021-02-12T09:59:12.464000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.465000-06:00 DEBUG Finished processing WRITER for "diaspora_production.aspects" 0.048000s
2021-02-12T09:59:12.465000-06:00 DEBUG writers-counts[diaspora_production.aspects] = 0
2021-02-12T09:59:12.465000-06:00 NOTICE DONE copying diaspora_production.aspects in 0.048s
2021-02-12T09:59:12.465000-06:00 DEBUG Reader for diaspora_production.contacts is done in 0.024000s
2021-02-12T09:59:12.465000-06:00 NOTICE COPY diaspora_production.poll_participations with 3104 rows estimated [1/4]
2021-02-12T09:59:12.465000-06:00 DEBUG Reader started for diaspora_production.poll_participations
2021-02-12T09:59:12.465000-06:00 DEBUG start diaspora_production.poll_participations 85468
2021-02-12T09:59:12.465000-06:00 DEBUG Finished processing READER for "diaspora_production.contacts" 0.024000s
2021-02-12T09:59:12.465000-06:00 NOTICE CREATE INDEX idx_259767_index_notification_actors_on_notification_id ON diaspora_production.notification_actors (notification_id);
2021-02-12T09:59:12.465000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C8F3}>
2021-02-12T09:59:12.465000-06:00 SQL MySQL: sending query: SELECT `id`, `poll_answer_id`, `author_id`, `poll_id`, `guid`, `created_at`, `updated_at` FROM `poll_participations`
2021-02-12T09:59:12.467000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.472000-06:00 INFO pgsql:copy-rows-from-queue[3]: diaspora_production.contacts (id user_id
person_id
created_at
updated_at sharing
receiving)
2021-02-12T09:59:12.473000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A55B6C53}>
2021-02-12T09:59:12.473000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.473000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.473000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.473000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.poll_participations (id
poll_answer_id
author_id
poll_id
guid
created_at
updated_at)
2021-02-12T09:59:12.495000-06:00 DEBUG Reader for diaspora_production.poll_participations is done in 0.031000s
2021-02-12T09:59:12.495000-06:00 NOTICE COPY diaspora_production.users with 1902 rows estimated [1/4]
2021-02-12T09:59:12.496000-06:00 DEBUG Reader started for diaspora_production.users
2021-02-12T09:59:12.496000-06:00 DEBUG start diaspora_production.users 85499
2021-02-12T09:59:12.496000-06:00 DEBUG Finished processing READER for "diaspora_production.poll_participations" 0.031000s
2021-02-12T09:59:12.496000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67C983}>
2021-02-12T09:59:12.496000-06:00 SQL MySQL: sending query: SELECT `id`, `username`, `serialized_private_key`, `getting_started`, `disable_mail`, `language`, `email`, `encrypted_password`, `reset_password_token`, `remember_created_at`, `sign_in_count`, `current_sign_in_at`, `last_sign_in_at`, `current_sign_in_ip`, `last_sign_in_ip`, `created_at`, `updated_at`, `invited_by_id`, `authentication_token`, `unconfirmed_email`, `confirm_email_token`, `locked_at`, `show_community_spotlight_in_stream`, `auto_follow_back`, `auto_follow_back_aspect_id`, `hidden_shareables`, `reset_password_sent_at`, `last_seen`, `remove_after`, `export`, `exported_at`, `exporting`, `strip_exif`, `exported_photos_file`, `exported_photos_at`, `exporting_photos`, `color_theme`, `post_default_public`, `consumed_timestep`, `otp_required_for_login`, `otp_backup_codes`, `plain_otp_secret` FROM `users`
2021-02-12T09:59:12.498000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A5BE4DF3}>
2021-02-12T09:59:12.498000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.501000-06:00 DEBUG stop diaspora_production.poll_participations | 85468 .. 85505 = 0.037d0
2021-02-12T09:59:12.501000-06:00 DEBUG Writer[2] for diaspora_production.poll_participations is done in 0.015000s
2021-02-12T09:59:12.501000-06:00 DEBUG Finished processing WRITER for "diaspora_production.poll_participations" 0.015000s
2021-02-12T09:59:12.501000-06:00 DEBUG writers-counts[diaspora_production.poll_participations] = 0
2021-02-12T09:59:12.501000-06:00 NOTICE DONE copying diaspora_production.poll_participations in 0.015s
2021-02-12T09:59:12.501000-06:00 DEBUG stop diaspora_production.contacts | 85444 .. 85505 = 0.061d0
2021-02-12T09:59:12.502000-06:00 DEBUG Writer[3] for diaspora_production.contacts is done in 0.013000s
2021-02-12T09:59:12.502000-06:00 DEBUG Finished processing WRITER for "diaspora_production.contacts" 0.013000s
2021-02-12T09:59:12.502000-06:00 DEBUG writers-counts[diaspora_production.contacts] = 0
2021-02-12T09:59:12.502000-06:00 NOTICE DONE copying diaspora_production.contacts in 0.013s
2021-02-12T09:59:12.502000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.504000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.505000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A5BE3863}>
2021-02-12T09:59:12.505000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.507000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.507000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.507000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65E4873}>
2021-02-12T09:59:12.507000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.509000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.509000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.509000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A64B70E3}>
2021-02-12T09:59:12.509000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.509000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.509000-06:00 NOTICE CREATE UNIQUE INDEX idx_259594_index_aspects_on_user_id_and_name ON diaspora_production.aspects (user_id, name);
2021-02-12T09:59:12.509000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.510000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.pods (id host ssl created_at
updated_at status
checked_at
offline_since
response_time software
error port blocked
scheduled_check)
2021-02-12T09:59:12.511000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65B81A3}>
2021-02-12T09:59:12.511000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.511000-06:00 INFO pgsql:copy-rows-from-queue[3]: diaspora_production.users (id username
serialized_private_key
getting_started
disable_mail language
email
encrypted_password
reset_password_token
remember_created_at
sign_in_count
current_sign_in_at
last_sign_in_at
current_sign_in_ip
last_sign_in_ip
created_at updated_at
invited_by_id
authentication_token
unconfirmed_email
confirm_email_token
locked_at
show_community_spotlight_in_stream
auto_follow_back
auto_follow_back_aspect_id
hidden_shareables
reset_password_sent_at
last_seen
remove_after export
exported_at exporting
strip_exif
exported_photos_file
exported_photos_at
exporting_photos
color_theme
post_default_public
consumed_timestep
otp_required_for_login
otp_backup_codes
plain_otp_secret)
2021-02-12T09:59:12.511000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.511000-06:00 NOTICE CREATE UNIQUE INDEX idx_259896_primary ON diaspora_production.poll_participations (id);
2021-02-12T09:59:12.525000-06:00 NOTICE CREATE UNIQUE INDEX idx_259594_primary ON diaspora_production.aspects (id);
2021-02-12T09:59:12.532000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A5BE17D3}>
2021-02-12T09:59:12.532000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.534000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.535000-06:00 NOTICE CREATE INDEX idx_259594_index_aspects_on_user_id ON diaspora_production.aspects (user_id);
2021-02-12T09:59:12.558000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A6157FC3}>
2021-02-12T09:59:12.558000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.558000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65A6B53}>
2021-02-12T09:59:12.558000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.558000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.559000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.559000-06:00 NOTICE CREATE UNIQUE INDEX idx_259896_index_poll_participations_on_poll_id_and_author_id ON diaspora_production.poll_participations (poll_id, author_id);
2021-02-12T09:59:12.563000-06:00 NOTICE CREATE UNIQUE INDEX idx_259896_index_poll_participations_on_guid ON diaspora_production.poll_participations (guid);
2021-02-12T09:59:12.571000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65BE773}>
2021-02-12T09:59:12.571000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.576000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65BAE03}>
2021-02-12T09:59:12.576000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.576000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.576000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.577000-06:00 NOTICE CREATE INDEX idx_259682_index_contacts_on_person_id ON diaspora_production.contacts (person_id);
2021-02-12T09:59:12.589000-06:00 NOTICE CREATE UNIQUE INDEX idx_259682_primary ON diaspora_production.contacts (id);
2021-02-12T09:59:12.598000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A65BD1D3}>
2021-02-12T09:59:12.600000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.600000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.600000-06:00 NOTICE CREATE UNIQUE INDEX idx_259682_index_contacts_on_user_id_and_person_id ON diaspora_production.contacts (user_id, person_id);
2021-02-12T09:59:12.641000-06:00 DEBUG stop diaspora_production.profiles | 84826 .. 85645 = 0.819d0
2021-02-12T09:59:12.641000-06:00 DEBUG Writer[0] for diaspora_production.profiles is done in 0.763000s
2021-02-12T09:59:12.642000-06:00 DEBUG Finished processing WRITER for "diaspora_production.profiles" 0.763000s
2021-02-12T09:59:12.642000-06:00 DEBUG writers-counts[diaspora_production.profiles] = 0
2021-02-12T09:59:12.642000-06:00 NOTICE DONE copying diaspora_production.profiles in 0.763s
2021-02-12T09:59:12.642000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.646000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A750FB33}>
2021-02-12T09:59:12.646000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.648000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A74FEAE3}>
2021-02-12T09:59:12.648000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.650000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A7517643}>
2021-02-12T09:59:12.650000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.650000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A7507103}>
2021-02-12T09:59:12.650000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.651000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.651000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.651000-06:00 NOTICE CREATE UNIQUE INDEX idx_259933_primary ON diaspora_production.profiles (id);
2021-02-12T09:59:12.651000-06:00 NOTICE CREATE INDEX idx_259933_index_profiles_on_full_name_and_searchable ON diaspora_production.profiles (full_name, searchable);
2021-02-12T09:59:12.652000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.652000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.656000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8CCFB33}>
2021-02-12T09:59:12.656000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.664000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.667000-06:00 NOTICE CREATE INDEX idx_259933_index_profiles_on_full_name ON diaspora_production.profiles (full_name);
2021-02-12T09:59:12.680000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.692000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.tag_followings (id tag_id
user_id
created_at
updated_at)
2021-02-12T09:59:12.712000-06:00 NOTICE CREATE INDEX idx_259933_index_profiles_on_person_id ON diaspora_production.profiles (person_id);
2021-02-12T09:59:12.782000-06:00 DEBUG Reader for diaspora_production.users is done in 0.287000s
2021-02-12T09:59:12.782000-06:00 NOTICE COPY diaspora_production.pods with 1314 rows estimated [1/4]
2021-02-12T09:59:12.782000-06:00 DEBUG Reader started for diaspora_production.pods
2021-02-12T09:59:12.782000-06:00 DEBUG start diaspora_production.pods 85786
2021-02-12T09:59:12.782000-06:00 DEBUG Finished processing READER for "diaspora_production.users" 0.287000s
2021-02-12T09:59:12.782000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CC43}>
2021-02-12T09:59:12.782000-06:00 SQL MySQL: sending query: SELECT `id`, `host`, `ssl`, `created_at`, `updated_at`, `status`, `checked_at`, `offline_since`, `response_time`, `software`, `error`, `port`, `blocked`, `scheduled_check` FROM `pods`
2021-02-12T09:59:12.800000-06:00 DEBUG Reader for diaspora_production.pods is done in 0.018000s
2021-02-12T09:59:12.800000-06:00 NOTICE COPY diaspora_production.tag_followings with 964 rows estimated [1/4]
2021-02-12T09:59:12.800000-06:00 DEBUG Reader started for diaspora_production.tag_followings
2021-02-12T09:59:12.801000-06:00 DEBUG start diaspora_production.tag_followings 85804
2021-02-12T09:59:12.801000-06:00 DEBUG Finished processing READER for "diaspora_production.pods" 0.018000s
2021-02-12T09:59:12.801000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CD43}>
2021-02-12T09:59:12.801000-06:00 SQL MySQL: sending query: SELECT `id`, `tag_id`, `user_id`, `created_at`, `updated_at` FROM `tag_followings`
2021-02-12T09:59:12.806000-06:00 DEBUG Reader for diaspora_production.tag_followings is done in 0.006000s
2021-02-12T09:59:12.807000-06:00 DEBUG Finished processing READER for "diaspora_production.tag_followings" 0.006000s
2021-02-12T09:59:12.807000-06:00 NOTICE COPY diaspora_production.invitation_codes with 311 rows estimated [1/4]
2021-02-12T09:59:12.807000-06:00 DEBUG Reader started for diaspora_production.invitation_codes
2021-02-12T09:59:12.807000-06:00 DEBUG start diaspora_production.invitation_codes 85811
2021-02-12T09:59:12.808000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CDB3}>
2021-02-12T09:59:12.808000-06:00 SQL MySQL: sending query: SELECT `id`, `token`, `user_id`, `count`, `created_at`, `updated_at` FROM `invitation_codes`
2021-02-12T09:59:12.810000-06:00 DEBUG Reader for diaspora_production.invitation_codes is done in 0.003000s
2021-02-12T09:59:12.810000-06:00 DEBUG Finished processing READER for "diaspora_production.invitation_codes" 0.003000s
2021-02-12T09:59:12.810000-06:00 NOTICE COPY diaspora_production.polls with 297 rows estimated [1/4]
2021-02-12T09:59:12.810000-06:00 DEBUG Reader started for diaspora_production.polls
2021-02-12T09:59:12.811000-06:00 DEBUG start diaspora_production.polls 85814
2021-02-12T09:59:12.811000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CE33}>
2021-02-12T09:59:12.812000-06:00 SQL MySQL: sending query: SELECT `id`, `question`, `status_message_id`, `status`, `guid`, `created_at`, `updated_at` FROM `polls`
2021-02-12T09:59:12.814000-06:00 DEBUG Reader for diaspora_production.polls is done in 0.004000s
2021-02-12T09:59:12.816000-06:00 DEBUG Finished processing READER for "diaspora_production.polls" 0.004000s
2021-02-12T09:59:12.816000-06:00 NOTICE COPY diaspora_production.account_deletions with 152 rows estimated [1/4]
2021-02-12T09:59:12.816000-06:00 DEBUG Reader started for diaspora_production.account_deletions
2021-02-12T09:59:12.817000-06:00 DEBUG start diaspora_production.account_deletions 85819
2021-02-12T09:59:12.817000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CEC3}>
2021-02-12T09:59:12.817000-06:00 SQL MySQL: sending query: SELECT `id`, `person_id`, `completed_at` FROM `account_deletions`
2021-02-12T09:59:12.817000-06:00 DEBUG Reader for diaspora_production.account_deletions is done in 0.002000s
2021-02-12T09:59:12.818000-06:00 NOTICE COPY diaspora_production.schema_migrations with 98 rows estimated [1/4]
2021-02-12T09:59:12.818000-06:00 DEBUG Reader started for diaspora_production.schema_migrations
2021-02-12T09:59:12.818000-06:00 DEBUG start diaspora_production.schema_migrations 85821
2021-02-12T09:59:12.818000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CF13}>
2021-02-12T09:59:12.818000-06:00 SQL MySQL: sending query: SELECT `version` FROM `schema_migrations`
2021-02-12T09:59:12.818000-06:00 DEBUG Reader for diaspora_production.schema_migrations is done in 0.001000s
2021-02-12T09:59:12.819000-06:00 NOTICE COPY diaspora_production.conversation_visibilities with 53 rows estimated [1/4]
2021-02-12T09:59:12.819000-06:00 DEBUG Reader started for diaspora_production.conversation_visibilities
2021-02-12T09:59:12.819000-06:00 DEBUG start diaspora_production.conversation_visibilities 85822
2021-02-12T09:59:12.819000-06:00 DEBUG stop diaspora_production.tag_followings | 85804 .. 85823 = 0.019d0
2021-02-12T09:59:12.819000-06:00 DEBUG Writer[0] for diaspora_production.tag_followings is done in 0.001000s
2021-02-12T09:59:12.819000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.820000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CF43}>
2021-02-12T09:59:12.820000-06:00 SQL MySQL: sending query: SELECT `id`, `conversation_id`, `person_id`, `unread`, `created_at`, `updated_at` FROM `conversation_visibilities`
2021-02-12T09:59:12.820000-06:00 DEBUG Reader for diaspora_production.conversation_visibilities is done in 0.002000s
2021-02-12T09:59:12.820000-06:00 NOTICE COPY diaspora_production.services with 11 rows estimated [1/4]
2021-02-12T09:59:12.820000-06:00 DEBUG Reader started for diaspora_production.services
2021-02-12T09:59:12.821000-06:00 DEBUG start diaspora_production.services 85824
2021-02-12T09:59:12.821000-06:00 DEBUG Finished processing READER for "diaspora_production.account_deletions" 0.002000s
2021-02-12T09:59:12.821000-06:00 DEBUG Finished processing READER for "diaspora_production.schema_migrations" 0.001000s
2021-02-12T09:59:12.821000-06:00 DEBUG Finished processing WRITER for "diaspora_production.tag_followings" 0.001000s
2021-02-12T09:59:12.821000-06:00 DEBUG writers-counts[diaspora_production.tag_followings] = 0
2021-02-12T09:59:12.821000-06:00 NOTICE DONE copying diaspora_production.tag_followings in 0.001s
2021-02-12T09:59:12.821000-06:00 DEBUG Finished processing READER for "diaspora_production.conversation_visibilities" 0.002000s
2021-02-12T09:59:12.823000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67CFC3}>
2021-02-12T09:59:12.823000-06:00 SQL MySQL: sending query: SELECT `id`, `type`, `user_id`, `uid`, `access_token`, `access_secret`, `nickname`, `created_at`, `updated_at` FROM `services`
2021-02-12T09:59:12.823000-06:00 DEBUG Reader for diaspora_production.services is done in 0.003000s
2021-02-12T09:59:12.823000-06:00 NOTICE COPY diaspora_production.roles with 3 rows estimated [1/4]
2021-02-12T09:59:12.823000-06:00 DEBUG Reader started for diaspora_production.roles
2021-02-12T09:59:12.823000-06:00 DEBUG start diaspora_production.roles 85827
2021-02-12T09:59:12.824000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D073}>
2021-02-12T09:59:12.824000-06:00 SQL MySQL: sending query: SELECT `id`, `person_id`, `name`, `created_at`, `updated_at` FROM `roles`
2021-02-12T09:59:12.824000-06:00 DEBUG Reader for diaspora_production.roles is done in 0.001000s
2021-02-12T09:59:12.824000-06:00 NOTICE COPY diaspora_production.account_migrations with 0 rows estimated [1/4]
2021-02-12T09:59:12.824000-06:00 DEBUG Reader started for diaspora_production.account_migrations
2021-02-12T09:59:12.825000-06:00 DEBUG start diaspora_production.account_migrations 85828
2021-02-12T09:59:12.826000-06:00 DEBUG Finished processing READER for "diaspora_production.services" 0.003000s
2021-02-12T09:59:12.826000-06:00 DEBUG Finished processing READER for "diaspora_production.roles" 0.001000s
2021-02-12T09:59:12.826000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A879EFD3}>
2021-02-12T09:59:12.826000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.826000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A878F653}>
2021-02-12T09:59:12.826000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.826000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.828000-06:00 NOTICE CREATE UNIQUE INDEX idx_260032_primary ON diaspora_production.tag_followings (id);
2021-02-12T09:59:12.828000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D0E3}>
2021-02-12T09:59:12.828000-06:00 SQL MySQL: sending query: SELECT `id`, `old_person_id`, `new_person_id`, `completed_at` FROM `account_migrations`
2021-02-12T09:59:12.828000-06:00 DEBUG Reader for diaspora_production.account_migrations is done in 0.004000s
2021-02-12T09:59:12.828000-06:00 NOTICE COPY diaspora_production.authorizations with 0 rows estimated [1/4]
2021-02-12T09:59:12.828000-06:00 DEBUG Reader started for diaspora_production.authorizations
2021-02-12T09:59:12.829000-06:00 DEBUG start diaspora_production.authorizations 85832
2021-02-12T09:59:12.829000-06:00 DEBUG Finished processing READER for "diaspora_production.account_migrations" 0.004000s
2021-02-12T09:59:12.829000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D143}>
2021-02-12T09:59:12.829000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `o_auth_application_id`, `refresh_token`, `code`, `redirect_uri`, `nonce`, `scopes`, `code_used`, `created_at`, `updated_at` FROM `authorizations`
2021-02-12T09:59:12.830000-06:00 DEBUG Reader for diaspora_production.authorizations is done in 0.001000s
2021-02-12T09:59:12.830000-06:00 NOTICE COPY diaspora_production.chat_fragments with 0 rows estimated [1/4]
2021-02-12T09:59:12.830000-06:00 DEBUG Reader started for diaspora_production.chat_fragments
2021-02-12T09:59:12.831000-06:00 DEBUG start diaspora_production.chat_fragments 85833
2021-02-12T09:59:12.831000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D213}>
2021-02-12T09:59:12.831000-06:00 SQL MySQL: sending query: SELECT `id`, `user_id`, `root`, `namespace`, `xml` FROM `chat_fragments`
2021-02-12T09:59:12.831000-06:00 DEBUG Reader for diaspora_production.chat_fragments is done in 0.001000s
2021-02-12T09:59:12.831000-06:00 NOTICE COPY diaspora_production.o_auth_access_tokens with 0 rows estimated [1/4]
2021-02-12T09:59:12.831000-06:00 DEBUG Reader started for diaspora_production.o_auth_access_tokens
2021-02-12T09:59:12.831000-06:00 DEBUG start diaspora_production.o_auth_access_tokens 85834
2021-02-12T09:59:12.831000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D283}>
2021-02-12T09:59:12.831000-06:00 SQL MySQL: sending query: SELECT `id`, `authorization_id`, `token`, `expires_at`, `created_at`, `updated_at` FROM `o_auth_access_tokens`
2021-02-12T09:59:12.831000-06:00 DEBUG Reader for diaspora_production.o_auth_access_tokens is done in 0.000000s
2021-02-12T09:59:12.831000-06:00 NOTICE COPY diaspora_production.poll_participation_signatures with 0 rows estimated [1/4]
2021-02-12T09:59:12.831000-06:00 DEBUG Reader started for diaspora_production.poll_participation_signatures
2021-02-12T09:59:12.831000-06:00 DEBUG start diaspora_production.poll_participation_signatures 85834
2021-02-12T09:59:12.832000-06:00 DEBUG Finished processing READER for "diaspora_production.authorizations" 0.001000s
2021-02-12T09:59:12.832000-06:00 DEBUG Finished processing READER for "diaspora_production.chat_fragments" 0.001000s
2021-02-12T09:59:12.832000-06:00 DEBUG Finished processing READER for "diaspora_production.o_auth_access_tokens" 0.000000s
2021-02-12T09:59:12.832000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {103E67D303}>
2021-02-12T09:59:12.832000-06:00 SQL MySQL: sending query: SELECT `poll_participation_id`, `author_signature`, `signature_order_id`, `additional_data` FROM `poll_participation_signatures`
2021-02-12T09:59:12.832000-06:00 DEBUG Reader for diaspora_production.poll_participation_signatures is done in 0.001000s
2021-02-12T09:59:12.832000-06:00 NOTICE COPY diaspora_production.reports with 0 rows estimated [1/4]
2021-02-12T09:59:12.832000-06:00 DEBUG Reader started for diaspora_production.reports
2021-02-12T09:59:12.832000-06:00 DEBUG start diaspora_production.reports 85835
2021-02-12T09:59:12.832000-06:00 DEBUG Finished processing READER for "diaspora_production.poll_participation_signatures" 0.001000s
2021-02-12T09:59:12.832000-06:00 DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://pg@localhost:3306/diaspora_production {1006CD2EF3}>
2021-02-12T09:59:12.832000-06:00 SQL MySQL: sending query: SELECT `id`, `item_id`, `item_type`, `reviewed`, `text`, `created_at`, `updated_at`, `user_id` FROM `reports`
2021-02-12T09:59:12.832000-06:00 DEBUG Reader for diaspora_production.reports is done in 0.001000s
2021-02-12T09:59:12.833000-06:00 DEBUG Finished processing READER for "diaspora_production.reports" 0.001000s
2021-02-12T09:59:12.833000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.835000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8776D03}>
2021-02-12T09:59:12.835000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.835000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.835000-06:00 NOTICE CREATE INDEX idx_260032_index_tag_followings_on_tag_id ON diaspora_production.tag_followings (tag_id);
2021-02-12T09:59:12.836000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8797753}>
2021-02-12T09:59:12.836000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.836000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.838000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8D8E793}>
2021-02-12T09:59:12.838000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.838000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.838000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.839000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.invitation_codes (id token
user_id
count
created_at
updated_at)
2021-02-12T09:59:12.839000-06:00 DEBUG stop diaspora_production.pods | 85786 .. 85843 = 0.057d0
2021-02-12T09:59:12.839000-06:00 DEBUG Writer[2] for diaspora_production.pods is done in 0.035000s
2021-02-12T09:59:12.839000-06:00 DEBUG Finished processing WRITER for "diaspora_production.pods" 0.035000s
2021-02-12T09:59:12.839000-06:00 DEBUG writers-counts[diaspora_production.pods] = 0
2021-02-12T09:59:12.839000-06:00 NOTICE DONE copying diaspora_production.pods in 0.035s
2021-02-12T09:59:12.839000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.840000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.844000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8EEF103}>
2021-02-12T09:59:12.844000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.844000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.845000-06:00 NOTICE CREATE INDEX idx_260032_index_tag_followings_on_user_id ON diaspora_production.tag_followings (user_id);
2021-02-12T09:59:12.845000-06:00 NOTICE CREATE UNIQUE INDEX idx_260032_index_tag_followings_on_tag_id_and_user_id ON diaspora_production.tag_followings (tag_id, user_id);
2021-02-12T09:59:12.845000-06:00 NOTICE CREATE INDEX idx_259859_index_pods_on_offline_since ON diaspora_production.pods (offline_since);
2021-02-12T09:59:12.850000-06:00 DEBUG stop diaspora_production.invitation_codes | 85811 .. 85853 = 0.042d0
2021-02-12T09:59:12.850000-06:00 DEBUG Writer[0] for diaspora_production.invitation_codes is done in 0.001000s
2021-02-12T09:59:12.850000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.850000-06:00 DEBUG Finished processing WRITER for "diaspora_production.invitation_codes" 0.001000s
2021-02-12T09:59:12.850000-06:00 DEBUG writers-counts[diaspora_production.invitation_codes] = 0
2021-02-12T09:59:12.850000-06:00 NOTICE DONE copying diaspora_production.invitation_codes in 0.001s
2021-02-12T09:59:12.852000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AD092E43}>
2021-02-12T09:59:12.853000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A86BF5E3}>
2021-02-12T09:59:12.853000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.853000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.853000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.853000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.856000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.856000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.account_deletions (id
person_id
completed_at)
2021-02-12T09:59:12.856000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8F77083}>
2021-02-12T09:59:12.856000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.856000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.856000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.857000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.schema_migrations (version)
2021-02-12T09:59:12.859000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.859000-06:00 INFO pgsql:copy-rows-from-queue[1]: diaspora_production.polls (id question
status_message_id
status guid
created_at updated_at)
2021-02-12T09:59:12.862000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8EDF313}>
2021-02-12T09:59:12.862000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.862000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.863000-06:00 NOTICE CREATE UNIQUE INDEX idx_259859_index_pods_on_host_and_port ON diaspora_production.pods (host, port);
2021-02-12T09:59:12.890000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8EFEB83}>
2021-02-12T09:59:12.890000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.890000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.890000-06:00 NOTICE CREATE INDEX idx_259859_index_pods_on_status ON diaspora_production.pods (status);
2021-02-12T09:59:12.943000-06:00 DEBUG stop diaspora_production.polls | 85814 .. 85946 = 0.132d0
2021-02-12T09:59:12.943000-06:00 DEBUG Writer[1] for diaspora_production.polls is done in 0.001000s
2021-02-12T09:59:12.943000-06:00 DEBUG stop diaspora_production.schema_migrations | 85821 .. 85947 = 0.126d0
2021-02-12T09:59:12.943000-06:00 DEBUG Writer[0] for diaspora_production.schema_migrations is done in 0.000000s
2021-02-12T09:59:12.943000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.943000-06:00 DEBUG stop diaspora_production.account_deletions | 85819 .. 85947 = 0.128d0
2021-02-12T09:59:12.943000-06:00 DEBUG Writer[2] for diaspora_production.account_deletions is done in 0.000000s
2021-02-12T09:59:12.943000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.944000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.946000-06:00 DEBUG Finished processing WRITER for "diaspora_production.polls" 0.001000s
2021-02-12T09:59:12.946000-06:00 DEBUG writers-counts[diaspora_production.polls] = 0
2021-02-12T09:59:12.946000-06:00 NOTICE DONE copying diaspora_production.polls in 0.001s
2021-02-12T09:59:12.946000-06:00 DEBUG Finished processing WRITER for "diaspora_production.schema_migrations" 0.000000s
2021-02-12T09:59:12.946000-06:00 DEBUG writers-counts[diaspora_production.schema_migrations] = 0
2021-02-12T09:59:12.946000-06:00 NOTICE DONE copying diaspora_production.schema_migrations in 0.000s
2021-02-12T09:59:12.946000-06:00 DEBUG Finished processing WRITER for "diaspora_production.account_deletions" 0.000000s
2021-02-12T09:59:12.946000-06:00 DEBUG writers-counts[diaspora_production.account_deletions] = 0
2021-02-12T09:59:12.947000-06:00 NOTICE DONE copying diaspora_production.account_deletions in 0.000s
2021-02-12T09:59:12.950000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A91568F3}>
2021-02-12T09:59:12.951000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.951000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AD1BFC03}>
2021-02-12T09:59:12.951000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.951000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.951000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.951000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9166A13}>
2021-02-12T09:59:12.952000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.952000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8FE6A33}>
2021-02-12T09:59:12.952000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.952000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8ED7323}>
2021-02-12T09:59:12.952000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.952000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.952000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.952000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.952000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A91DF583}>
2021-02-12T09:59:12.952000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.952000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.952000-06:00 INFO pgsql:copy-rows-from-queue[1]: diaspora_production.conversation_visibilities (id
conversation_id
person_id
unread
created_at
updated_at)
2021-02-12T09:59:12.952000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.services (id type user_id
uid access_token
access_secret
nickname
created_at
updated_at)
2021-02-12T09:59:12.952000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.952000-06:00 NOTICE CREATE UNIQUE INDEX idx_259707_primary ON diaspora_production.invitation_codes (id);
2021-02-12T09:59:12.953000-06:00 NOTICE CREATE INDEX idx_259859_index_pods_on_checked_at ON diaspora_production.pods (checked_at);
2021-02-12T09:59:12.953000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.953000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:12.953000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.roles (id person_id name
created_at updated_at)
2021-02-12T09:59:12.954000-06:00 NOTICE CREATE UNIQUE INDEX idx_259875_index_polls_on_guid ON diaspora_production.polls (guid);
2021-02-12T09:59:12.976000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A91EFB63}>
2021-02-12T09:59:12.976000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:12.976000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:12.976000-06:00 NOTICE CREATE UNIQUE INDEX idx_259875_primary ON diaspora_production.polls (id);
2021-02-12T09:59:12.999000-06:00 DEBUG stop diaspora_production.services | 85824 .. 86003 = 0.179d0
2021-02-12T09:59:12.999000-06:00 DEBUG Writer[0] for diaspora_production.services is done in 0.000000s
2021-02-12T09:59:12.999000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:12.999000-06:00 DEBUG stop diaspora_production.conversation_visibilities | 85822 .. 86003 = 0.181d0
2021-02-12T09:59:12.999000-06:00 DEBUG Writer[1] for diaspora_production.conversation_visibilities is done in 0.000000s
2021-02-12T09:59:12.999000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:13.000000-06:00 DEBUG Finished processing WRITER for "diaspora_production.services" 0.000000s
2021-02-12T09:59:13.000000-06:00 DEBUG writers-counts[diaspora_production.services] = 0
2021-02-12T09:59:13.000000-06:00 NOTICE DONE copying diaspora_production.services in 0.000s
2021-02-12T09:59:13.000000-06:00 DEBUG Finished processing WRITER for "diaspora_production.conversation_visibilities" 0.000000s
2021-02-12T09:59:13.000000-06:00 DEBUG writers-counts[diaspora_production.conversation_visibilities] = 0
2021-02-12T09:59:13.000000-06:00 NOTICE DONE copying diaspora_production.conversation_visibilities in 0.000s
2021-02-12T09:59:13.001000-06:00 DEBUG stop diaspora_production.roles | 85827 .. 86004 = 0.177d0
2021-02-12T09:59:13.001000-06:00 DEBUG Writer[2] for diaspora_production.roles is done in 0.000000s
2021-02-12T09:59:13.001000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:13.001000-06:00 DEBUG Finished processing WRITER for "diaspora_production.roles" 0.000000s
2021-02-12T09:59:13.001000-06:00 DEBUG writers-counts[diaspora_production.roles] = 0
2021-02-12T09:59:13.002000-06:00 NOTICE DONE copying diaspora_production.roles in 0.000s
2021-02-12T09:59:13.006000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A948F103}>
2021-02-12T09:59:13.006000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.006000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.007000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9217A13}>
2021-02-12T09:59:13.007000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.007000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.007000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AD21F383}>
2021-02-12T09:59:13.007000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.007000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.008000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A8F0E3B3}>
2021-02-12T09:59:13.008000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.008000-06:00 NOTICE CREATE UNIQUE INDEX idx_259575_index_account_deletions_on_person_id ON diaspora_production.account_deletions (person_id);
2021-02-12T09:59:13.008000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.008000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A93D7763}>
2021-02-12T09:59:13.008000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.008000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.008000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.008000-06:00 NOTICE CREATE UNIQUE INDEX idx_259859_primary ON diaspora_production.pods (id);
2021-02-12T09:59:13.008000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.chat_fragments (id user_id
root
namespace
xml)
2021-02-12T09:59:13.009000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.009000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.009000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.account_migrations (id
old_person_id
new_person_id
completed_at)
2021-02-12T09:59:13.010000-06:00 DEBUG stop diaspora_production.chat_fragments | 85833 .. 86013 = 0.18d0
2021-02-12T09:59:13.010000-06:00 DEBUG Writer[2] for diaspora_production.chat_fragments is done in 0.000000s
2021-02-12T09:59:13.010000-06:00 DEBUG Finished processing WRITER for "diaspora_production.chat_fragments" 0.000000s
2021-02-12T09:59:13.010000-06:00 DEBUG writers-counts[diaspora_production.chat_fragments] = 0
2021-02-12T09:59:13.010000-06:00 INFO pgsql:copy-rows-from-queue[1]: diaspora_production.authorizations (id user_id
o_auth_application_id
refresh_token
code
redirect_uri
nonce scopes
code_used
created_at
updated_at)
2021-02-12T09:59:13.010000-06:00 NOTICE DONE copying diaspora_production.chat_fragments in 0.000s
2021-02-12T09:59:13.010000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:13.010000-06:00 DEBUG stop diaspora_production.authorizations | 85832 .. 86014 = 0.182d0
2021-02-12T09:59:13.010000-06:00 DEBUG Writer[1] for diaspora_production.authorizations is done in 0.000000s
2021-02-12T09:59:13.010000-06:00 DEBUG Finished processing WRITER for "diaspora_production.authorizations" 0.000000s
2021-02-12T09:59:13.010000-06:00 DEBUG writers-counts[diaspora_production.authorizations] = 0
2021-02-12T09:59:13.010000-06:00 NOTICE DONE copying diaspora_production.authorizations in 0.000s
2021-02-12T09:59:13.010000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:13.012000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A95DFD63}>
2021-02-12T09:59:13.012000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.012000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.013000-06:00 DEBUG stop diaspora_production.account_migrations | 85828 .. 86017 = 0.189d0
2021-02-12T09:59:13.013000-06:00 DEBUG Writer[0] for diaspora_production.account_migrations is done in 0.000000s
2021-02-12T09:59:13.013000-06:00 INFO COPY ON ERROR STOP
2021-02-12T09:59:13.013000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.013000-06:00 DEBUG Finished processing WRITER for "diaspora_production.account_migrations" 0.000000s
2021-02-12T09:59:13.013000-06:00 DEBUG writers-counts[diaspora_production.account_migrations] = 0
2021-02-12T09:59:13.013000-06:00 NOTICE DONE copying diaspora_production.account_migrations in 0.000s
2021-02-12T09:59:13.016000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A96DED03}>
2021-02-12T09:59:13.016000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.016000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.016000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AD267733}>
2021-02-12T09:59:13.016000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.016000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.017000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.017000-06:00 INFO pgsql:copy-rows-from-queue[1]: diaspora_production.poll_participation_signatures (poll_participation_id
author_signature
signature_order_id
additional_data)
2021-02-12T09:59:13.017000-06:00 SQL SET search_path TO diaspora_production;
2021-02-12T09:59:13.017000-06:00 INFO pgsql:copy-rows-from-queue[0]: diaspora_production.reports (id item_id
item_type reviewed
text created_at
updated_at user_id)
2021-02-12T09:59:13.018000-06:00 INFO pgsql:copy-rows-from-queue[2]: diaspora_production.o_auth_access_tokens (id
authorization_id
token
expires_at
created_at
updated_at)
2021-02-12T09:59:13.018000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A94267B3}>
2021-02-12T09:59:13.018000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.019000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.019000-06:00 DEBUG stop diaspora_production.o_auth_access_tokens | 85834 .. 86023 = 0.189d0
2021-02-12T09:59:13.019000-06:00 DEBUG Writer[2] for diaspora_production.o_auth_access_tokens is done in 0.000000s
2021-02-12T09:59:13.019000-06:00 DEBUG Finished processing WRITER for "diaspora_production.o_auth_access_tokens" 0.000000s
2021-02-12T09:59:13.019000-06:00 DEBUG writers-counts[diaspora_production.o_auth_access_tokens] = 0
2021-02-12T09:59:13.019000-06:00 NOTICE DONE copying diaspora_production.o_auth_access_tokens in 0.000s
2021-02-12T09:59:13.019000-06:00 NOTICE CREATE INDEX idx_259980_index_services_on_type_and_uid ON diaspora_production.services (type, uid);
2021-02-12T09:59:13.020000-06:00 DEBUG stop diaspora_production.poll_participation_signatures | 85834 .. 86023 = 0.189d0
2021-02-12T09:59:13.020000-06:00 DEBUG Writer[1] for diaspora_production.poll_participation_signatures is done in 0.000000s
2021-02-12T09:59:13.020000-06:00 DEBUG Finished processing WRITER for "diaspora_production.poll_participation_signatures" 0.000000s
2021-02-12T09:59:13.020000-06:00 DEBUG writers-counts[diaspora_production.poll_participation_signatures] = 0
2021-02-12T09:59:13.020000-06:00 NOTICE DONE copying diaspora_production.poll_participation_signatures in 0.000s
2021-02-12T09:59:13.033000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9437243}>
2021-02-12T09:59:13.033000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.033000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9457043}>
2021-02-12T09:59:13.033000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.033000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.033000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.033000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A920E803}>
2021-02-12T09:59:13.033000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.033000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.033000-06:00 NOTICE CREATE INDEX idx_259700_index_conversation_visibilities_on_conversation_id ON diaspora_production.conversation_visibilities (conversation_id);
2021-02-12T09:59:13.034000-06:00 NOTICE CREATE INDEX idx_259980_index_services_on_user_id ON diaspora_production.services (user_id);
2021-02-12T09:59:13.034000-06:00 NOTICE CREATE UNIQUE INDEX idx_259975_unique_schema_migrations ON diaspora_production.schema_migrations (version);
2021-02-12T09:59:13.040000-06:00 DEBUG stop diaspora_production.reports | 85835 .. 86043 = 0.208d0
2021-02-12T09:59:13.040000-06:00 DEBUG Writer[0] for diaspora_production.reports is done in 0.000000s
2021-02-12T09:59:13.040000-06:00 DEBUG Finished processing WRITER for "diaspora_production.reports" 0.000000s
2021-02-12T09:59:13.040000-06:00 DEBUG writers-counts[diaspora_production.reports] = 0
2021-02-12T09:59:13.040000-06:00 NOTICE DONE copying diaspora_production.reports in 0.000s
2021-02-12T09:59:13.042000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9467193}>
2021-02-12T09:59:13.042000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.042000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9227233}>
2021-02-12T09:59:13.042000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.042000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.043000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.043000-06:00 NOTICE CREATE UNIQUE INDEX idx_259575_primary ON diaspora_production.account_deletions (id);
2021-02-12T09:59:13.043000-06:00 NOTICE CREATE UNIQUE INDEX idx_259700_index_conversation_visibilities_usefully ON diaspora_production.conversation_visibilities (conversation_id, person_id);
2021-02-12T09:59:13.048000-06:00 DEBUG stop diaspora_production.users | 85499 .. 86052 = 0.553d0
2021-02-12T09:59:13.051000-06:00 DEBUG Writer[3] for diaspora_production.users is done in 0.523000s
2021-02-12T09:59:13.051000-06:00 DEBUG Finished processing WRITER for "diaspora_production.users" 0.523000s
2021-02-12T09:59:13.051000-06:00 DEBUG writers-counts[diaspora_production.users] = 0
2021-02-12T09:59:13.051000-06:00 NOTICE DONE copying diaspora_production.users in 0.523s
2021-02-12T09:59:13.051000-06:00 INFO Done with COPYing data, waiting for indexes
2021-02-12T09:59:13.058000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A94AFAB3}>
2021-02-12T09:59:13.060000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.060000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.060000-06:00 NOTICE CREATE UNIQUE INDEX idx_259970_index_roles_on_person_id_and_name ON diaspora_production.roles (person_id, name);
2021-02-12T09:59:13.067000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A945F423}>
2021-02-12T09:59:13.067000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.067000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A94B74E3}>
2021-02-12T09:59:13.067000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.067000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.067000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.068000-06:00 NOTICE CREATE UNIQUE INDEX idx_259970_primary ON diaspora_production.roles (id);
2021-02-12T09:59:13.068000-06:00 NOTICE CREATE INDEX idx_259700_index_conversation_visibilities_on_person_id ON diaspora_production.conversation_visibilities (person_id);
2021-02-12T09:59:13.071000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9606C83}>
2021-02-12T09:59:13.072000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.072000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.072000-06:00 NOTICE CREATE UNIQUE INDEX idx_259647_primary ON diaspora_production.chat_fragments (id);
2021-02-12T09:59:13.084000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A96564C3}>
2021-02-12T09:59:13.084000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.084000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.085000-06:00 NOTICE CREATE INDEX idx_259615_index_authorizations_on_user_id ON diaspora_production.authorizations (user_id);
2021-02-12T09:59:13.085000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A94776B3}>
2021-02-12T09:59:13.085000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.085000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.085000-06:00 NOTICE CREATE UNIQUE INDEX idx_259700_primary ON diaspora_production.conversation_visibilities (id);
2021-02-12T09:59:13.105000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A970E793}>
2021-02-12T09:59:13.105000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.105000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.106000-06:00 NOTICE CREATE INDEX idx_259581_fk_rails_610fe19943 ON diaspora_production.account_migrations (new_person_id);
2021-02-12T09:59:13.116000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9646543}>
2021-02-12T09:59:13.117000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.117000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.117000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9716D03}>
2021-02-12T09:59:13.117000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.117000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.117000-06:00 NOTICE CREATE INDEX idx_259615_index_authorizations_on_o_auth_application_id ON diaspora_production.authorizations (o_auth_application_id);
2021-02-12T09:59:13.117000-06:00 NOTICE CREATE UNIQUE INDEX idx_259581_index_account_migrations_on_old_person_id ON diaspora_production.account_migrations (old_person_id);
2021-02-12T09:59:13.123000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9727733}>
2021-02-12T09:59:13.125000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.125000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.125000-06:00 NOTICE CREATE UNIQUE INDEX idx_259581_primary ON diaspora_production.account_migrations (id);
2021-02-12T09:59:13.130000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A984F013}>
2021-02-12T09:59:13.131000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.131000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9657AA3}>
2021-02-12T09:59:13.131000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.131000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.131000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.131000-06:00 NOTICE CREATE UNIQUE INDEX idx_259784_index_o_auth_access_tokens_on_token ON diaspora_production.o_auth_access_tokens (token);
2021-02-12T09:59:13.131000-06:00 NOTICE CREATE UNIQUE INDEX idx_259615_primary ON diaspora_production.authorizations (id);
2021-02-12T09:59:13.135000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A98765D3}>
2021-02-12T09:59:13.135000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.135000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.135000-06:00 NOTICE CREATE UNIQUE INDEX idx_259901_index_poll_participation_signatures_on_poll_participation_id ON diaspora_production.poll_participation_signatures (poll_participation_id);
2021-02-12T09:59:13.135000-06:00 WARNING PostgreSQL warning: identifier "idx_259901_index_poll_participation_signatures_on_poll_participation_id" will be truncated to "idx_259901_index_poll_participation_signatures_on_poll_particip"
2021-02-12T09:59:13.138000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9837C33}>
2021-02-12T09:59:13.138000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A987F773}>
2021-02-12T09:59:13.138000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.139000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.139000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.139000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.139000-06:00 NOTICE CREATE INDEX idx_259784_index_o_auth_access_tokens_on_authorization_id ON diaspora_production.o_auth_access_tokens (authorization_id);
2021-02-12T09:59:13.139000-06:00 NOTICE CREATE INDEX idx_259901_poll_participation_signatures_signature_orders_id_fk ON diaspora_production.poll_participation_signatures (signature_order_id);
2021-02-12T09:59:13.144000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A999ECD3}>
2021-02-12T09:59:13.144000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.144000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.145000-06:00 NOTICE CREATE UNIQUE INDEX idx_259960_primary ON diaspora_production.reports (id);
2021-02-12T09:59:13.149000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9A4E573}>
2021-02-12T09:59:13.158000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.159000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.159000-06:00 NOTICE CREATE UNIQUE INDEX idx_260038_index_users_on_email ON diaspora_production.users (email);
2021-02-12T09:59:13.173000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9856983}>
2021-02-12T09:59:13.173000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.173000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.173000-06:00 NOTICE CREATE UNIQUE INDEX idx_259784_primary ON diaspora_production.o_auth_access_tokens (id);
2021-02-12T09:59:13.254000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9A3FAB3}>
2021-02-12T09:59:13.254000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.254000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9A4FE03}>
2021-02-12T09:59:13.254000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.254000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A9A576B3}>
2021-02-12T09:59:13.254000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.254000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.255000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.255000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.255000-06:00 NOTICE CREATE UNIQUE INDEX idx_260038_index_users_on_username ON diaspora_production.users (username);
2021-02-12T09:59:13.255000-06:00 NOTICE CREATE UNIQUE INDEX idx_260038_primary ON diaspora_production.users (id);
2021-02-12T09:59:13.255000-06:00 NOTICE CREATE UNIQUE INDEX idx_260038_index_users_on_authentication_token ON diaspora_production.users (authentication_token);
2021-02-12T09:59:13.260000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A91EE5D3}>
2021-02-12T09:59:13.260000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.260000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.261000-06:00 NOTICE CREATE INDEX idx_259875_index_polls_on_status_message_id ON diaspora_production.polls (status_message_id);
2021-02-12T09:59:13.277000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A95F7333}>
2021-02-12T09:59:13.278000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.278000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A943EC13}>
2021-02-12T09:59:13.278000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.278000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.278000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.278000-06:00 NOTICE CREATE UNIQUE INDEX idx_259647_index_chat_fragments_on_user_id ON diaspora_production.chat_fragments (user_id);
2021-02-12T09:59:13.278000-06:00 NOTICE CREATE UNIQUE INDEX idx_259980_primary ON diaspora_production.services (id);
2021-02-12T09:59:13.290000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A971FE13}>
2021-02-12T09:59:13.290000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.290000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.290000-06:00 NOTICE CREATE UNIQUE INDEX idx_259581_index_account_migrations_on_old_person_id_and_new_person_id ON diaspora_production.account_migrations (old_person_id, new_person_id);
2021-02-12T09:59:13.290000-06:00 WARNING PostgreSQL warning: identifier "idx_259581_index_account_migrations_on_old_person_id_and_new_person_id" will be truncated to "idx_259581_index_account_migrations_on_old_person_id_and_new_pe"
2021-02-12T09:59:13.325000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10A99873E3}>
2021-02-12T09:59:13.325000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.325000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.326000-06:00 NOTICE CREATE INDEX idx_259960_index_reports_on_item_id ON diaspora_production.reports (item_id);
2021-02-12T09:59:13.473000-06:00 INFO Done waiting for indexes
2021-02-12T09:59:13.483000-06:00 NOTICE Completing PostgreSQL database.
2021-02-12T09:59:13.483000-06:00 NOTICE Reset sequences
2021-02-12T09:59:13.486000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AB36EF63}>
2021-02-12T09:59:13.486000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.486000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.486000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.487000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.565000-06:00 DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@UNIX:5432/diaspora_production {10AB41E483}>
2021-02-12T09:59:13.565000-06:00 DEBUG SET client_encoding TO 'utf8'
2021-02-12T09:59:13.565000-06:00 DEBUG SET application_name TO 'pgloader'
2021-02-12T09:59:13.566000-06:00 DEBUG BEGIN
2021-02-12T09:59:13.566000-06:00 NOTICE ALTER TABLE diaspora_production.likes ADD PRIMARY KEY USING INDEX idx_259714_primary;
2021-02-12T09:59:14.570000-06:00 NOTICE ALTER TABLE diaspora_production.taggings ADD PRIMARY KEY USING INDEX idx_260015_primary;
2021-02-12T09:59:14.571000-06:00 NOTICE ALTER TABLE diaspora_production.participations ADD PRIMARY KEY USING INDEX idx_259824_primary;
2021-02-12T09:59:14.572000-06:00 NOTICE ALTER TABLE diaspora_production.open_graph_caches ADD PRIMARY KEY USING INDEX idx_259773_primary;
2021-02-12T09:59:14.572000-06:00 NOTICE ALTER TABLE diaspora_production.tags ADD PRIMARY KEY USING INDEX idx_260024_primary;
2021-02-12T09:59:14.573000-06:00 NOTICE ALTER TABLE diaspora_production.posts ADD PRIMARY KEY USING INDEX idx_259909_primary;
2021-02-12T09:59:14.573000-06:00 NOTICE ALTER TABLE diaspora_production.o_embed_caches ADD PRIMARY KEY USING INDEX idx_259815_primary;
2021-02-12T09:59:14.574000-06:00 NOTICE ALTER TABLE diaspora_production.people ADD PRIMARY KEY USING INDEX idx_259832_primary;
2021-02-12T09:59:14.574000-06:00 NOTICE ALTER TABLE diaspora_production.share_visibilities ADD PRIMARY KEY USING INDEX idx_259993_primary;
2021-02-12T09:59:14.575000-06:00 NOTICE ALTER TABLE diaspora_production.notifications ADD PRIMARY KEY USING INDEX idx_259755_primary;
2021-02-12T09:59:14.575000-06:00 NOTICE ALTER TABLE diaspora_production.aspect_memberships ADD PRIMARY KEY USING INDEX idx_259602_primary;
2021-02-12T09:59:14.575000-06:00 NOTICE ALTER TABLE diaspora_production.aspect_visibilities ADD PRIMARY KEY USING INDEX idx_259608_primary;
2021-02-12T09:59:14.576000-06:00 NOTICE ALTER TABLE diaspora_production.poll_answers ADD PRIMARY KEY USING INDEX idx_259885_primary;
2021-02-12T09:59:14.576000-06:00 NOTICE ALTER TABLE diaspora_production."references" ADD PRIMARY KEY USING INDEX idx_259954_primary;
2021-02-12T09:59:14.577000-06:00 NOTICE ALTER TABLE diaspora_production.locations ADD PRIMARY KEY USING INDEX idx_259728_primary;
2021-02-12T09:59:14.577000-06:00 NOTICE ALTER TABLE diaspora_production.user_preferences ADD PRIMARY KEY USING INDEX idx_260069_primary;
2021-02-12T09:59:14.578000-06:00 NOTICE ALTER TABLE diaspora_production.messages ADD PRIMARY KEY USING INDEX idx_259746_primary;
2021-02-12T09:59:14.578000-06:00 NOTICE ALTER TABLE diaspora_production.blocks ADD PRIMARY KEY USING INDEX idx_259630_primary;
2021-02-12T09:59:14.579000-06:00 NOTICE ALTER TABLE diaspora_production.conversations ADD PRIMARY KEY USING INDEX idx_259690_primary;
2021-02-12T09:59:14.579000-06:00 NOTICE ALTER TABLE diaspora_production.signature_orders ADD PRIMARY KEY USING INDEX idx_260001_primary;
2021-02-12T09:59:14.579000-06:00 NOTICE ALTER TABLE diaspora_production.simple_captcha_data ADD PRIMARY KEY USING INDEX idx_260007_primary;
2021-02-12T09:59:14.580000-06:00 NOTICE ALTER TABLE diaspora_production.ar_internal_metadata ADD PRIMARY KEY USING INDEX idx_259585_primary;
2021-02-12T09:59:14.580000-06:00 NOTICE ALTER TABLE diaspora_production.chat_contacts ADD PRIMARY KEY USING INDEX idx_259636_primary;
2021-02-12T09:59:14.581000-06:00 NOTICE ALTER TABLE diaspora_production.chat_offline_messages ADD PRIMARY KEY USING INDEX idx_259656_primary;
2021-02-12T09:59:14.581000-06:00 NOTICE ALTER TABLE diaspora_production.o_auth_applications ADD PRIMARY KEY USING INDEX idx_259791_primary;
2021-02-12T09:59:14.582000-06:00 NOTICE ALTER TABLE diaspora_production.ppid ADD PRIMARY KEY USING INDEX idx_259925_primary;
2021-02-12T09:59:14.582000-06:00 NOTICE ALTER TABLE diaspora_production.mentions ADD PRIMARY KEY USING INDEX idx_259740_primary;
2021-02-12T09:59:14.583000-06:00 NOTICE ALTER TABLE diaspora_production.comments ADD PRIMARY KEY USING INDEX idx_259665_primary;
2021-02-12T09:59:14.584000-06:00 NOTICE ALTER TABLE diaspora_production.photos ADD PRIMARY KEY USING INDEX idx_259843_primary;
2021-02-12T09:59:14.585000-06:00 NOTICE ALTER TABLE diaspora_production.notification_actors ADD PRIMARY KEY USING INDEX idx_259767_primary;
2021-02-12T09:59:14.585000-06:00 NOTICE ALTER TABLE diaspora_production.aspects ADD PRIMARY KEY USING INDEX idx_259594_primary;
2021-02-12T09:59:14.585000-06:00 NOTICE ALTER TABLE diaspora_production.poll_participations ADD PRIMARY KEY USING INDEX idx_259896_primary;
2021-02-12T09:59:14.586000-06:00 NOTICE ALTER TABLE diaspora_production.contacts ADD PRIMARY KEY USING INDEX idx_259682_primary;
2021-02-12T09:59:14.586000-06:00 NOTICE ALTER TABLE diaspora_production.profiles ADD PRIMARY KEY USING INDEX idx_259933_primary;
2021-02-12T09:59:14.586000-06:00 NOTICE ALTER TABLE diaspora_production.tag_followings ADD PRIMARY KEY USING INDEX idx_260032_primary;
2021-02-12T09:59:14.586000-06:00 NOTICE ALTER TABLE diaspora_production.pods ADD PRIMARY KEY USING INDEX idx_259859_primary;
2021-02-12T09:59:14.587000-06:00 NOTICE ALTER TABLE diaspora_production.invitation_codes ADD PRIMARY KEY USING INDEX idx_259707_primary;
2021-02-12T09:59:14.587000-06:00 NOTICE ALTER TABLE diaspora_production.polls ADD PRIMARY KEY USING INDEX idx_259875_primary;
2021-02-12T09:59:14.587000-06:00 NOTICE ALTER TABLE diaspora_production.account_deletions ADD PRIMARY KEY USING INDEX idx_259575_primary;
2021-02-12T09:59:14.588000-06:00 NOTICE ALTER TABLE diaspora_production.services ADD PRIMARY KEY USING INDEX idx_259980_primary;
2021-02-12T09:59:14.588000-06:00 NOTICE ALTER TABLE diaspora_production.conversation_visibilities ADD PRIMARY KEY USING INDEX idx_259700_primary;
2021-02-12T09:59:14.588000-06:00 NOTICE ALTER TABLE diaspora_production.roles ADD PRIMARY KEY USING INDEX idx_259970_primary;
2021-02-12T09:59:14.589000-06:00 NOTICE ALTER TABLE diaspora_production.chat_fragments ADD PRIMARY KEY USING INDEX idx_259647_primary;
2021-02-12T09:59:14.589000-06:00 NOTICE ALTER TABLE diaspora_production.authorizations ADD PRIMARY KEY USING INDEX idx_259615_primary;
2021-02-12T09:59:14.589000-06:00 NOTICE ALTER TABLE diaspora_production.account_migrations ADD PRIMARY KEY USING INDEX idx_259581_primary;
2021-02-12T09:59:14.589000-06:00 NOTICE ALTER TABLE diaspora_production.o_auth_access_tokens ADD PRIMARY KEY USING INDEX idx_259784_primary;
2021-02-12T09:59:14.590000-06:00 NOTICE ALTER TABLE diaspora_production.reports ADD PRIMARY KEY USING INDEX idx_259960_primary;
2021-02-12T09:59:14.590000-06:00 NOTICE ALTER TABLE diaspora_production.users ADD PRIMARY KEY USING INDEX idx_260038_primary;
2021-02-12T09:59:14.591000-06:00 NOTICE ALTER TABLE diaspora_production.account_migrations ADD CONSTRAINT fk_rails_610fe19943 FOREIGN KEY(new_person_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:14.592000-06:00 NOTICE ALTER TABLE diaspora_production.account_migrations ADD CONSTRAINT fk_rails_ddbe553eee FOREIGN KEY(old_person_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:14.593000-06:00 NOTICE ALTER TABLE diaspora_production.aspect_memberships ADD CONSTRAINT aspect_memberships_aspect_id_fk FOREIGN KEY(aspect_id) REFERENCES diaspora_production.aspects(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.596000-06:00 NOTICE ALTER TABLE diaspora_production.aspect_memberships ADD CONSTRAINT aspect_memberships_contact_id_fk FOREIGN KEY(contact_id) REFERENCES diaspora_production.contacts(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.598000-06:00 NOTICE ALTER TABLE diaspora_production.aspect_visibilities ADD CONSTRAINT aspect_visibilities_aspect_id_fk FOREIGN KEY(aspect_id) REFERENCES diaspora_production.aspects(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.600000-06:00 NOTICE ALTER TABLE diaspora_production.authorizations ADD CONSTRAINT fk_rails_4ecef5b8c5 FOREIGN KEY(user_id) REFERENCES diaspora_production.users(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:14.602000-06:00 NOTICE ALTER TABLE diaspora_production.authorizations ADD CONSTRAINT fk_rails_e166644de5 FOREIGN KEY(o_auth_application_id) REFERENCES diaspora_production.o_auth_applications(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:14.603000-06:00 NOTICE ALTER TABLE diaspora_production.comments ADD CONSTRAINT comments_author_id_fk FOREIGN KEY(author_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.802000-06:00 NOTICE ALTER TABLE diaspora_production.comment_signatures ADD CONSTRAINT comment_signatures_comment_id_fk FOREIGN KEY(comment_id) REFERENCES diaspora_production.comments(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.811000-06:00 NOTICE ALTER TABLE diaspora_production.comment_signatures ADD CONSTRAINT comment_signatures_signature_orders_id_fk FOREIGN KEY(signature_order_id) REFERENCES diaspora_production.signature_orders(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:14.812000-06:00 NOTICE ALTER TABLE diaspora_production.contacts ADD CONSTRAINT contacts_person_id_fk FOREIGN KEY(person_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.817000-06:00 NOTICE ALTER TABLE diaspora_production.conversations ADD CONSTRAINT conversations_author_id_fk FOREIGN KEY(author_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.818000-06:00 NOTICE ALTER TABLE diaspora_production.conversation_visibilities ADD CONSTRAINT conversation_visibilities_conversation_id_fk FOREIGN KEY(conversation_id) REFERENCES diaspora_production.conversations(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.819000-06:00 NOTICE ALTER TABLE diaspora_production.conversation_visibilities ADD CONSTRAINT conversation_visibilities_person_id_fk FOREIGN KEY(person_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:14.819000-06:00 NOTICE ALTER TABLE diaspora_production.likes ADD CONSTRAINT likes_author_id_fk FOREIGN KEY(author_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.226000-06:00 NOTICE ALTER TABLE diaspora_production.like_signatures ADD CONSTRAINT like_signatures_like_id_fk FOREIGN KEY(like_id) REFERENCES diaspora_production.likes(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.250000-06:00 NOTICE ALTER TABLE diaspora_production.like_signatures ADD CONSTRAINT like_signatures_signature_orders_id_fk FOREIGN KEY(signature_order_id) REFERENCES diaspora_production.signature_orders(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.252000-06:00 NOTICE ALTER TABLE diaspora_production.messages ADD CONSTRAINT messages_author_id_fk FOREIGN KEY(author_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.253000-06:00 NOTICE ALTER TABLE diaspora_production.messages ADD CONSTRAINT messages_conversation_id_fk FOREIGN KEY(conversation_id) REFERENCES diaspora_production.conversations(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.254000-06:00 NOTICE ALTER TABLE diaspora_production.notification_actors ADD CONSTRAINT notification_actors_notification_id_fk FOREIGN KEY(notification_id) REFERENCES diaspora_production.notifications(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.260000-06:00 NOTICE ALTER TABLE diaspora_production.o_auth_access_tokens ADD CONSTRAINT fk_rails_5debabcff3 FOREIGN KEY(authorization_id) REFERENCES diaspora_production.authorizations(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.260000-06:00 NOTICE ALTER TABLE diaspora_production.o_auth_applications ADD CONSTRAINT fk_rails_ad75323da2 FOREIGN KEY(user_id) REFERENCES diaspora_production.users(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.261000-06:00 NOTICE ALTER TABLE diaspora_production.people ADD CONSTRAINT people_pod_id_fk FOREIGN KEY(pod_id) REFERENCES diaspora_production.pods(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.275000-06:00 NOTICE ALTER TABLE diaspora_production.poll_participation_signatures ADD CONSTRAINT poll_participation_signatures_poll_participation_id_fk FOREIGN KEY(poll_participation_id) REFERENCES diaspora_production.poll_participations(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.276000-06:00 NOTICE ALTER TABLE diaspora_production.poll_participation_signatures ADD CONSTRAINT poll_participation_signatures_signature_orders_id_fk FOREIGN KEY(signature_order_id) REFERENCES diaspora_production.signature_orders(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.277000-06:00 NOTICE ALTER TABLE diaspora_production.posts ADD CONSTRAINT posts_author_id_fk FOREIGN KEY(author_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.658000-06:00 NOTICE ALTER TABLE diaspora_production.ppid ADD CONSTRAINT fk_rails_150457f962 FOREIGN KEY(o_auth_application_id) REFERENCES diaspora_production.o_auth_applications(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.659000-06:00 NOTICE ALTER TABLE diaspora_production.ppid ADD CONSTRAINT fk_rails_e6b8e5264f FOREIGN KEY(user_id) REFERENCES diaspora_production.users(id) ON UPDATE RESTRICT ON DELETE RESTRICT
2021-02-12T09:59:15.660000-06:00 NOTICE ALTER TABLE diaspora_production.profiles ADD CONSTRAINT profiles_person_id_fk FOREIGN KEY(person_id) REFERENCES diaspora_production.people(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.683000-06:00 NOTICE ALTER TABLE diaspora_production.services ADD CONSTRAINT services_user_id_fk FOREIGN KEY(user_id) REFERENCES diaspora_production.users(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.684000-06:00 NOTICE ALTER TABLE diaspora_production.share_visibilities ADD CONSTRAINT share_visibilities_user_id_fk FOREIGN KEY(user_id) REFERENCES diaspora_production.users(id) ON UPDATE RESTRICT ON DELETE CASCADE
2021-02-12T09:59:15.690000-06:00 NOTICE ALTER DATABASE "diaspora_production" SET search_path TO public, diaspora_production;
2021-02-12T09:59:15.697000-06:00 LOG report summary reset
2021-02-12T09:59:15.723000-06:00 INFO Stopping monitor
I then check the postgresql database like:
sudo -u postgres psql
\c diaspora_production;
select count(*) form users;
I get 0 rows.
What am I doing wrong?
I am having the same issue pgloader claims migration is successfully. But when i check my database there are only tables got created but there is not data inside the tables
2021-02-20T09:36:23.080794Z LOG report summary reset
table name errors rows bytes total time
-------------------------------------- --------- --------- --------- --------------
fetch meta data 0 54 9.880s
Create Schemas 0 0 0.001s
Create SQL Types 0 0 0.005s
Create tables 0 50 0.163s
Set Table OIDs 0 25 0.008s
-------------------------------------- --------- --------- --------- --------------
burnsidelaw_godb.acl_cap_metas 0 0 0.030s
burnsidelaw_godb.acl_caps 0 0 0.026s
burnsidelaw_godb.acl_roles 0 0 0.045s
burnsidelaw_godb.cases 0 8 3.5 kB 0.052s
burnsidelaw_godb.case_statuses 0 3 0.2 kB 0.071s
burnsidelaw_godb.caches 0 1 0.1 kB 0.039s
burnsidelaw_godb.client_actions 0 1 0.1 kB 0.077s
burnsidelaw_godb.case_follow_ups 0 3 0.3 kB 0.045s
burnsidelaw_godb.filter_templates 0 3 0.9 kB 0.098s
burnsidelaw_godb.claim_types 0 26 1.1 kB 0.063s
burnsidelaw_godb.insurance_companies 0 57 2.8 kB 0.105s
burnsidelaw_godb.file_locations 0 566 25.1 kB 0.073s
burnsidelaw_godb.martial_statuses 0 6 0.4 kB 0.126s
burnsidelaw_godb.media_file_mappings 0 2 0.0 kB 0.136s
burnsidelaw_godb.filter_template_types 0 2 0.0 kB 0.086s
burnsidelaw_godb.people 0 8 0.5 kB 0.156s
burnsidelaw_godb.jurisdictions 0 116 5.8 kB 0.100s
burnsidelaw_godb.potential_clients 0 2 0.3 kB 0.172s
burnsidelaw_godb.sources 0 23 1.0 kB 0.192s
burnsidelaw_godb.media_files 0 3 0.8 kB 0.117s
burnsidelaw_godb.options 0 0 0.129s
burnsidelaw_godb.users 0 2 0.4 kB 0.198s
burnsidelaw_godb.phone_actions 0 15 0.8 kB 0.148s
burnsidelaw_godb.referrers 0 5 0.3 kB 0.162s
burnsidelaw_godb.states 0 4 0.3 kB 0.182s
-------------------------------------- --------- --------- --------- --------------
COPY Threads Completion 0 4 0.313s
Create Indexes 0 29 0.096s
Index Build Completion 0 29 0.362s
Reset Sequences 0 25 0.055s
Primary Keys 0 25 0.022s
Create Foreign Keys 0 0 0.000s
Create Triggers 0 0 0.000s
Install Comments 0 0 0.000s
-------------------------------------- --------- --------- --------- --------------
Total import time ✓ 856 44.8 kB 0.848s
Thanks for contributing to pgloader by reporting an issue! Reporting an issue is the only way we can solve problems, fix bugs, and improve both the software and its user experience in general.
The best bug reports follow those 3 simple steps:
In the case of pgloader, here's the information I will need to read in your bug report. Having all of this is a big help, and often means the bug you reported can be fixed very efficiently as soon as I get to it.
Please provide the following information:
[x] pgloader --version
[x] did you test a fresh compile from the source tree?
Compiling pgloader from sources is documented in the README, it's easy to do, and if patches are to be made to fix your bug, you're going to have to build from sources to get the fix anyway…
[x] did you search for other similar issues?
Yes.
[ ] how can I reproduce the bug?
Incude a self-contained pgloader command file.
If you're loading from a database, consider attaching a database dump to your issue. For MySQL, use
mysqldump
. For SQLite, just send over your source file, that's easy. Maybe be the one with your production data, of course, the one with just the sample of data that allows me to reproduce your bug.When using a proprietary database system as a source, consider creating a sample database on some Cloud service or somewhere you can then give me access to, and see my email address on my GitHub profile to send me the credentials. Still open a public issue for tracking and as documentation for other users.
Built using
make DYNSIZE=16384 pgloader
My story
I want to migrate diaspora from MySQL to PostgreSQL. My MySQL root user runs on sock only, and my diaspora user has a special character in it so I can't pass the username into the mysql:// call. My regular user (iamdoubz) does not have access to postgres. I can only access running
sudo -u postgres psql
and then I am in. So, I am running this command as the postgres user: