135 finish_sync_worker(
void)
152 (
errmsg(
"logical replication table synchronization worker for subscription \"%s\", table \"%s\" has finished",
190 if (
state == SUBREL_STATE_UNKNOWN)
193 if (
state == expected_state)
247 if (worker && worker->
proc)
329 sizeof(syncslotname));
381 finish_sync_worker();
411 struct tablesync_start_time_mapping
418 bool started_tx =
false;
419 bool should_exit =
false;
436 ctl.
entrysize =
sizeof(
struct tablesync_start_time_mapping);
458 if (rstate->
state == SUBREL_STATE_SYNCDONE)
465 if (current_lsn >= rstate->
lsn)
469 rstate->
state = SUBREL_STATE_READY;
470 rstate->
lsn = current_lsn;
512 rstate->
relid,
false);
520 if (rstate->
state == SUBREL_STATE_SYNCWAIT)
526 syncworker->
relstate = SUBREL_STATE_CATCHUP;
533 if (rstate->
state == SUBREL_STATE_SYNCWAIT)
536 if (syncworker->
proc)
553 SUBREL_STATE_SYNCDONE);
578 struct tablesync_start_time_mapping *hentry;
594 hentry->last_start_time =
now;
621 (
errmsg(
"logical replication apply worker for subscription \"%s\" will restart so that two_phase can be enabled",
674 attnamelist =
lappend(attnamelist,
704 while (maxread > 0 && bytesread < minread)
732 outbuf = (
void *) ((
char *) outbuf + avail);
738 if (maxread <= 0 || bytesread >= minread)
769 Oid tableRow[] = {OIDOID, CHAROID, CHAROID};
770 Oid attrRow[] = {INT2OID, TEXTOID, OIDOID, BOOLOID};
771 Oid qualRow[] = {TEXTOID};
783 " FROM pg_catalog.pg_class c"
784 " INNER JOIN pg_catalog.pg_namespace n"
785 " ON (c.relnamespace = n.oid)"
786 " WHERE n.nspname = %s"
787 " AND c.relname = %s",
795 (
errcode(ERRCODE_CONNECTION_FAILURE),
796 errmsg(
"could not fetch table info for table \"%s.%s\" from publisher: %s",
802 (
errcode(ERRCODE_UNDEFINED_OBJECT),
803 errmsg(
"table \"%s.%s\" not found on publisher",
827 Oid attrsRow[] = {INT2VECTOROID};
845 " (CASE WHEN (array_length(gpt.attrs, 1) = c.relnatts)"
846 " THEN NULL ELSE gpt.attrs END)"
847 " FROM pg_publication p,"
848 " LATERAL pg_get_publication_tables(p.pubname) gpt,"
850 " WHERE gpt.relid = %u AND c.oid = gpt.relid"
851 " AND p.pubname IN ( %s )",
860 (
errcode(ERRCODE_CONNECTION_FAILURE),
861 errmsg(
"could not fetch column list info for table \"%s.%s\" from publisher: %s",
874 errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
875 errmsg(
"cannot use different column lists for table \"%s.%s\" in different publications",
899 for (natt = 0; natt < nelems; natt++)
920 " a.attnum = ANY(i.indkey)"
921 " FROM pg_catalog.pg_attribute a"
922 " LEFT JOIN pg_catalog.pg_index i"
923 " ON (i.indexrelid = pg_get_replica_identity_index(%u))"
924 " WHERE a.attnum > 0::pg_catalog.int2"
925 " AND NOT a.attisdropped %s"
926 " AND a.attrelid = %u"
927 " ORDER BY a.attnum",
930 "AND a.attgenerated = ''" :
""),
937 (
errcode(ERRCODE_CONNECTION_FAILURE),
938 errmsg(
"could not fetch table info for table \"%s.%s\" from publisher: %s",
979 elog(
ERROR,
"too many columns in remote table \"%s.%s\"",
1028 "SELECT DISTINCT pg_get_expr(gpt.qual, gpt.relid)"
1029 " FROM pg_publication p,"
1030 " LATERAL pg_get_publication_tables(p.pubname) gpt"
1031 " WHERE gpt.relid = %u"
1032 " AND p.pubname IN ( %s )",
1040 (
errmsg(
"could not fetch table WHERE clause info for table \"%s.%s\" from publisher: %s",
1111 if (lrel.
relkind == RELKIND_RELATION && qual ==
NIL)
1120 for (
int i = 0;
i < lrel.
natts;
i++)
1139 for (
int i = 0;
i < lrel.
natts;
i++)
1152 if (lrel.
relkind == RELKIND_RELATION)
1190 (
errcode(ERRCODE_CONNECTION_FAILURE),
1191 errmsg(
"could not start initial contents copy for table \"%s.%s\": %s",
1199 NULL,
false,
false);
1229 char *syncslotname,
Size szslot)
1274 case SUBREL_STATE_SYNCDONE:
1275 case SUBREL_STATE_READY:
1276 case SUBREL_STATE_UNKNOWN:
1277 finish_sync_worker();
1296 (
errcode(ERRCODE_CONNECTION_FAILURE),
1297 errmsg(
"could not connect to the publisher: %s",
err)));
1307 sizeof(originname));
1343 goto copy_table_done;
1390 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
1391 errmsg(
"user \"%s\" cannot replicate into relation with row-level security enabled: \"%s\"",
1401 "BEGIN READ ONLY ISOLATION LEVEL REPEATABLE READ",
1405 (
errcode(ERRCODE_CONNECTION_FAILURE),
1406 errmsg(
"table copy could not start transaction on publisher: %s",
1416 slotname,
false ,
false ,
1448 errmsg(
"replication origin \"%s\" already exists",
1460 (
errcode(ERRCODE_CONNECTION_FAILURE),
1461 errmsg(
"table copy could not finish transaction on publisher: %s",
1476 SUBREL_STATE_FINISHEDCOPY,
1484 "LogicalRepSyncTableStart: '%s' origin_startpos lsn %X/%X",
1514 static bool has_subrels =
false;
1516 *started_tx =
false;
1540 foreach(lc, rstates)
1575 bool started_tx =
false;
1576 bool has_subrels =
false;
1602 bool nulls[Natts_pg_subscription];
1603 bool replaces[Natts_pg_subscription];
1614 "cache lookup failed for subscription oid %u",
1619 memset(nulls,
false,
sizeof(nulls));
1620 memset(replaces,
false,
sizeof(replaces));
1624 replaces[Anum_pg_subscription_subtwophasestate - 1] =
true;
1627 values, nulls, replaces);
void aclcheck_error(AclResult aclerr, ObjectType objtype, const char *objectname)
AclResult pg_class_aclcheck(Oid table_oid, Oid roleid, AclMode mode)
#define DatumGetArrayTypeP(X)
void ReplicationOriginNameForLogicalRep(Oid suboid, Oid relid, char *originname, Size szoriginname)
WalReceiverConn * LogRepWorkerWalRcvConn
Subscription * MySubscription
bool TimestampDifferenceExceeds(TimestampTz start_time, TimestampTz stop_time, int msec)
TimestampTz GetCurrentTimestamp(void)
Datum now(PG_FUNCTION_ARGS)
bool bms_is_member(int x, const Bitmapset *a)
Bitmapset * bms_add_member(Bitmapset *a, int x)
static Datum values[MAXATTR]
#define TextDatumGetCString(d)
#define OidIsValid(objectId)
CopyFromState BeginCopyFrom(ParseState *pstate, Relation rel, Node *whereClause, const char *filename, bool is_program, copy_data_source_cb data_source_cb, List *attnamelist, List *options)
uint64 CopyFrom(CopyFromState cstate)
static void PGresult * res
elog(ERROR, "%s: %s", p2, msg)
#define DSM_HANDLE_INVALID
void hash_destroy(HTAB *hashp)
void * hash_search(HTAB *hashp, const void *keyPtr, HASHACTION action, bool *foundPtr)
HTAB * hash_create(const char *tabname, long nelem, const HASHCTL *info, int flags)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
void err(int eval, const char *fmt,...)
void ExecDropSingleTupleTableSlot(TupleTableSlot *slot)
const TupleTableSlotOps TTSOpsMinimalTuple
TupleTableSlot * MakeSingleTupleTableSlot(TupleDesc tupdesc, const TupleTableSlotOps *tts_ops)
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
void heap_freetuple(HeapTuple htup)
#define HeapTupleIsValid(tuple)
#define MaxTupleAttributeNumber
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
int WaitLatchOrSocket(Latch *latch, int wakeEvents, pgsocket sock, long timeout, uint32 wait_event_info)
void ResetLatch(Latch *latch)
int WaitLatch(Latch *latch, int wakeEvents, long timeout, uint32 wait_event_info)
#define WL_SOCKET_READABLE
#define WL_EXIT_ON_PM_DEATH
LogicalRepWorker * logicalrep_worker_find(Oid subid, Oid relid, bool only_running)
void logicalrep_worker_wakeup_ptr(LogicalRepWorker *worker)
bool logicalrep_worker_launch(Oid dbid, Oid subid, const char *subname, Oid userid, Oid relid, dsm_handle subworker_dsm)
void logicalrep_worker_wakeup(Oid subid, Oid relid)
static dshash_table * last_start_times
LogicalRepWorker * MyLogicalRepWorker
int max_sync_workers_per_subscription
int logicalrep_sync_worker_count(Oid subid)
void ApplyLauncherForgetWorkerStartTime(Oid subid)
Assert(fmt[strlen(fmt) - 1] !='\n')
List * lappend(List *list, void *datum)
void list_free_deep(List *list)
void UnlockRelationOid(Oid relid, LOCKMODE lockmode)
void LockRelationOid(Oid relid, LOCKMODE lockmode)
char * get_namespace_name(Oid nspid)
char * get_rel_name(Oid relid)
bool LWLockAcquire(LWLock *lock, LWLockMode mode)
void LWLockRelease(LWLock *lock)
DefElem * makeDefElem(char *name, Node *arg, int location)
void pfree(void *pointer)
void * palloc0(Size size)
MemoryContext CacheMemoryContext
#define CHECK_FOR_INTERRUPTS()
char * GetUserNameFromId(Oid roleid, bool noerr)
ObjectType get_relkind_objtype(char relkind)
TimestampTz replorigin_session_origin_timestamp
RepOriginId replorigin_by_name(const char *roname, bool missing_ok)
RepOriginId replorigin_create(const char *roname)
void replorigin_session_reset(void)
void replorigin_drop_by_name(const char *name, bool missing_ok, bool nowait)
RepOriginId replorigin_session_origin
void replorigin_advance(RepOriginId node, XLogRecPtr remote_commit, XLogRecPtr local_commit, bool go_backward, bool wal_log)
void replorigin_session_setup(RepOriginId node, int acquired_by)
XLogRecPtr replorigin_session_get_progress(bool flush)
XLogRecPtr replorigin_session_origin_lsn
#define InvalidRepOriginId
static MemoryContext MemoryContextSwitchTo(MemoryContext context)
ParseState * make_parsestate(ParseState *parentParseState)
ParseNamespaceItem * addRangeTableEntryForRelation(ParseState *pstate, Relation rel, int lockmode, Alias *alias, bool inh, bool inFromCl)
#define for_each_from(cell, lst, N)
#define foreach_current_index(cell)
List * GetSubscriptionRelations(Oid subid, bool not_ready)
char GetSubscriptionRelState(Oid subid, Oid relid, XLogRecPtr *sublsn)
void UpdateSubscriptionRelState(Oid subid, Oid relid, char state, XLogRecPtr sublsn)
bool HasSubscriptionRelations(Oid subid)
#define LOGICALREP_TWOPHASE_STATE_DISABLED
#define LOGICALREP_TWOPHASE_STATE_PENDING
#define LOGICALREP_TWOPHASE_STATE_ENABLED
long pgstat_report_stat(bool force)
static bool DatumGetBool(Datum X)
static Oid DatumGetObjectId(Datum X)
static Datum ObjectIdGetDatum(Oid X)
static char DatumGetChar(Datum X)
static int16 DatumGetInt16(Datum X)
static Datum CharGetDatum(char X)
static int fd(const char *x, int i)
char * quote_literal_cstr(const char *rawstr)
#define RelationGetRelid(relation)
#define RelationGetDescr(relation)
#define RelationGetRelationName(relation)
#define RelationGetNamespace(relation)
int check_enable_rls(Oid relid, Oid checkAsUser, bool noError)
const char * quote_identifier(const char *ident)
char * quote_qualified_identifier(const char *qualifier, const char *ident)
Snapshot GetTransactionSnapshot(void)
void PushActiveSnapshot(Snapshot snapshot)
void PopActiveSnapshot(void)
void InvalidateCatalogSnapshot(void)
#define SpinLockRelease(lock)
#define SpinLockAcquire(lock)
void logicalrep_relmap_update(LogicalRepRelation *remoterel)
LogicalRepRelMapEntry * logicalrep_rel_open(LogicalRepRelId remoteid, LOCKMODE lockmode)
void logicalrep_rel_close(LogicalRepRelMapEntry *rel, LOCKMODE lockmode)
#define ERRCODE_DUPLICATE_OBJECT
StringInfo makeStringInfo(void)
void resetStringInfo(StringInfo str)
void appendStringInfo(StringInfo str, const char *fmt,...)
void appendStringInfoString(StringInfo str, const char *s)
void initStringInfo(StringInfo str)
LogicalRepRelation remoterel
Tuplestorestate * tuplestore
void ReplicationSlotDropAtPubNode(WalReceiverConn *wrconn, char *slotname, bool missing_ok)
#define SearchSysCacheCopy1(cacheId, key1)
void table_close(Relation relation, LOCKMODE lockmode)
Relation table_open(Oid relationId, LOCKMODE lockmode)
static List * table_states_not_ready
bool AllTablesyncsReady(void)
static bool wait_for_worker_state_change(char expected_state)
static bool table_states_valid
void invalidate_syncing_table_states(Datum arg, int cacheid, uint32 hashvalue)
static void pg_attribute_noreturn() finish_sync_worker(void)
static void process_syncing_tables_for_apply(XLogRecPtr current_lsn)
static void process_syncing_tables_for_sync(XLogRecPtr current_lsn)
void ReplicationSlotNameForTablesync(Oid suboid, Oid relid, char *syncslotname, Size szslot)
static int copy_read_data(void *outbuf, int minread, int maxread)
void process_syncing_tables(XLogRecPtr current_lsn)
char * LogicalRepSyncTableStart(XLogRecPtr *origin_startpos)
static void copy_table(Relation rel)
static bool wait_for_relation_state_change(Oid relid, char expected_state)
static StringInfo copybuf
static bool FetchTableStates(bool *started_tx)
static void fetch_remote_table_info(char *nspname, char *relname, LogicalRepRelation *lrel, List **qual)
static List * make_copy_attnamelist(LogicalRepRelMapEntry *rel)
void UpdateTwoPhaseState(Oid suboid, char new_state)
bool tuplestore_gettupleslot(Tuplestorestate *state, bool forward, bool copy, TupleTableSlot *slot)
int64 tuplestore_tuple_count(Tuplestorestate *state)
static TupleTableSlot * ExecClearTuple(TupleTableSlot *slot)
static Datum slot_getattr(TupleTableSlot *slot, int attnum, bool *isnull)
String * makeString(char *str)
@ WAIT_EVENT_LOGICAL_SYNC_STATE_CHANGE
@ WAIT_EVENT_LOGICAL_SYNC_DATA
#define walrcv_create_slot(conn, slotname, temporary, two_phase, snapshot_action, lsn)
#define walrcv_connect(conninfo, logical, appname, err)
static void walrcv_clear_result(WalRcvExecResult *walres)
#define walrcv_server_version(conn)
#define walrcv_endstreaming(conn, next_tli)
#define walrcv_exec(conn, exec, nRetTypes, retTypes)
#define walrcv_receive(conn, buffer, wait_fd)
static bool am_parallel_apply_worker(void)
static bool am_tablesync_worker(void)
bool IsTransactionState(void)
void CommandCounterIncrement(void)
void StartTransactionCommand(void)
void CommitTransactionCommand(void)
uint64 GetSystemIdentifier(void)
XLogRecPtr GetXLogWriteRecPtr(void)
int wal_retrieve_retry_interval
void XLogFlush(XLogRecPtr record)
#define LSN_FORMAT_ARGS(lsn)
#define InvalidXLogRecPtr