I try to use mailsync to copy over some mailboxes, and most of the time, aox crashes shortly after starting mailsync (before the first mailbox has been synced). Aox is the target, the source is dbmail.
Did I mess up the privileges of the database accounts? Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Unexpected lock seen at startup. Table: "mailboxes_pkey" PID: 27958 Mode: "AccessShareLock" Granted: yes Query: "<insufficient privilege>" Lock age: (unknown; missing privileges?) Context for this log entry: Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Dequeueing query "select version() as version, revision from mailstore" on backend 1 (with 1 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/13 Sent parse/execute for "select m.id, m.name, m.deleted, m.owner, m.uidnext, m.nextmodseq, m.uidvalidity, v.nextmodseq as viewnms, v.selector, v.view, v.source from mailboxes m left join views v on (m.id=v.view) " on backend 1 Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/13 Dequeueing query "select m.id, m.name, m.deleted, m.owner, m.uidnext, m.nextmodseq, m.uidvalidity, v.nextmodseq as viewnms, v.selector, v.view, v.source from mailboxes m left join views v on (m.id=v.view) " on backend 1 (with 109 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/8 Sent parse/execute for "update deliveries set expires_at=current_timestamp+interval '900 s' where expires_at<current_timestamp+interval '900 s' and id in (select delivery from delivery_recipients where action=$1 or action=$2)" ($1='0',$2='2') on backend 1 Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 archiveopteryx: Server startup complete Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Dequeueing query "select relname::text,pid::int,mode,granted,current_query,extract(epoch from current_timestamp-a.query_start)::int as lock_age from pg_locks l join pg_database d on (d.oid=l.database) join pg_class c on (l.relation=c.oid) join pg_stat_activity a on (l.pid=a.procpid) where d.datname=$1 and not relname like 'pg_%'" ($1='aoxbulk') on backend 3 (with 9 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Unexpected lock seen at startup. Table: "mailboxes_pkey" PID: 27958 Mode: "AccessShareLock" Granted: yes Query: "<insufficient privilege>" Lock age: (unknown; missing privileges?) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Sent parse/execute for "select indexdef from pg_indexes where indexdef ilike '% USING gin (to_tsvector%'and tablename='bodyparts' and schemaname=$1" ($1='public') on backend 3 Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/8 Dequeueing query "update deliveries set expires_at=current_timestamp+interval '900 s' where expires_at<current_timestamp+interval '900 s' and id in (select delivery from delivery_recipients where action=$1 or action=$2)" ($1='0',$2='2') on backend 1 (with 0 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/18 Sent parse/execute for "select id, name from flag_names where id > $1" ($1='0') on backend 1 Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Dequeueing query "select not exists (select * from information_schema.table_privileges where privilege_type='DELETE' and table_name='messages' and grantee=$1) and not exists (select u.usename from pg_catalog.pg_class c left join pg_catalog.pg_user u on (u.usesysid=c.relowner) where c.relname='messages' and u.usename=$1) as allowed" ($1='aoxbulk') on backend 2 (with 1 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/18 Dequeueing query "select id, name from flag_names where id > $1" ($1='0') on backend 1 (with 5 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952 Dequeueing query "select indexdef from pg_indexes where indexdef ilike '% USING gin (to_tsvector%'and tablename='bodyparts' and schemaname=$1" ($1='public') on backend 3 (with 0 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/14 Starting queue run Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/14 Sent parse/execute for "select d.message, extract(epoch from min(coalesce(dr.last_attempt+interval '900 s', d.deliver_after, current_timestamp)))::bigint-extract(epoch from current_timestamp)::bigint as delay from deliveries d join delivery_recipients dr on (d.id=dr.delivery) where (dr.action=$1 or dr.action=$2) group by d.message order by delay" ($1='0',$2='2') on backend 3 Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/14 Dequeueing query "select d.message, extract(epoch from min(coalesce(dr.last_attempt+interval '900 s', d.deliver_after, current_timestamp)))::bigint-extract(epoch from current_timestamp)::bigint as delay from deliveries d join delivery_recipients dr on (d.id=dr.delivery) where (dr.action=$1 or dr.action=$2) group by d.message order by delay" ($1='0',$2='2') on backend 3 (with 0 rows) Apr 12 10:22:39 aoxbulk Archiveopteryx: 27952/14 Ending queue run -- Stephen.
