Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitba0f875

Browse files
committed
fdx patch applied
1 parent9da70ef commitba0f875

File tree

29 files changed

+2237
-47
lines changed

29 files changed

+2237
-47
lines changed

‎contrib/pg_tsdtm/Makefile

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
MODULE_big = pg_tsdtm
2+
OBJS = pg_tsdtm.o
3+
4+
EXTENSION = pg_tsdtm
5+
DATA = pg_tsdtm--1.0.sql
6+
7+
ifdefUSE_PGXS
8+
PG_CONFIG = pg_config
9+
PGXS :=$(shell$(PG_CONFIG) --pgxs)
10+
include$(PGXS)
11+
else
12+
subdir = contrib/pg_tsdtm
13+
top_builddir = ../..
14+
include$(top_builddir)/src/Makefile.global
15+
include$(top_srcdir)/contrib/contrib-global.mk
16+
endif
17+
18+
check:
19+
env DESTDIR='$(abs_top_builddir)'/tmp_install make install
20+
$(prove_check)
Lines changed: 129 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,129 @@
1+
#include<iostream>
2+
#include<string>
3+
#include<vector>
4+
#include<set>
5+
6+
#include<pqxx/connection>
7+
#include<pqxx/transaction>
8+
#include<pqxx/nontransaction>
9+
10+
usingnamespacestd;
11+
usingnamespacepqxx;
12+
13+
intmain (int argc,char* argv[])
14+
{
15+
if (argc ==1){
16+
printf("Use -h to show usage options\n");
17+
return1;
18+
}
19+
vector<string> connections;
20+
set<string> prepared_xacts;
21+
set<string> committed_xacts;
22+
bool verbose =false;
23+
for (int i =1; i < argc; i++) {
24+
if (argv[i][0] =='-') {
25+
switch (argv[i][1]) {
26+
case'C':
27+
case'c':
28+
connections.push_back(string(argv[++i]));
29+
continue;
30+
case'v':
31+
verbose =true;
32+
continue;
33+
}
34+
}
35+
printf("Perform recovery of pg_tsdtm cluster.\n"
36+
"Usage: dtm_recovery {options}\n"
37+
"Options:\n"
38+
"\t-c STR\tdatabase connection string\n"
39+
"\t-v\tverbose mode: print extra information while processing\n");
40+
return1;
41+
}
42+
if (verbose) {
43+
cout <<"Collecting information about prepared transactions...\n";
44+
}
45+
for (vector<string>::iterator ic = connections.begin(); ic != connections.end(); ++ic)
46+
{
47+
if (verbose) {
48+
cout <<"Connecting to" << *ic <<"...\n";
49+
}
50+
connectioncon(*ic);
51+
worktxn(con);
52+
result r = txn.exec("select gid from pg_prepared_xacts");
53+
for (result::const_iterator it = r.begin(); it != r.end(); ++it)
54+
{
55+
string gid = it.at("gid").as(string());
56+
prepared_xacts.insert(gid);
57+
}
58+
txn.commit();
59+
}
60+
if (verbose) {
61+
cout <<"Prepared transactions:";
62+
for (set<string>::iterator it = prepared_xacts.begin(); it != prepared_xacts.end(); ++it)
63+
{
64+
cout << *it <<",";
65+
}
66+
cout <<"\nChecking which of them are committed...\n";
67+
}
68+
for (vector<string>::iterator ic = connections.begin(); ic != connections.end(); ++ic)
69+
{
70+
if (verbose) {
71+
cout <<"Connecting to" << *ic <<"...\n";
72+
}
73+
connectioncon(*ic);
74+
worktxn(con);
75+
con.prepare("commit-check","select * from pg_committed_xacts where gid=$1");
76+
for (set<string>::iterator it = prepared_xacts.begin(); it != prepared_xacts.end(); ++it)
77+
{
78+
string gid = *it;
79+
result r = txn.prepared("commit-check")(gid).exec();
80+
if (!r.empty()) {
81+
committed_xacts.insert(gid);
82+
}
83+
}
84+
txn.commit();
85+
}
86+
if (verbose) {
87+
cout <<"Committed transactions:";
88+
for (set<string>::iterator it = committed_xacts.begin(); it != committed_xacts.end(); ++it)
89+
{
90+
cout << *it <<",";
91+
}
92+
cout <<"\nCommitting them at all nodes...\n";
93+
}
94+
for (vector<string>::iterator ic = connections.begin(); ic != connections.end(); ++ic)
95+
{
96+
if (verbose) {
97+
cout <<"Connecting to" << *ic <<"...\n";
98+
}
99+
connectioncon(*ic);
100+
worktxn(con);
101+
con.prepare("commit-check","select * from pg_committed_xacts where gid=$1");
102+
con.prepare("commit-prepared","commit prepared $1");
103+
con.prepare("rollback-prepared","rollback prepared $1");
104+
result r = txn.exec("select gid from pg_prepared_xacts");
105+
for (result::const_iterator it = r.begin(); it != r.end(); ++it)
106+
{
107+
string gid = it.at("gid").as(string());
108+
result rc = txn.prepared("commit-check")(gid).exec();
109+
if (rc.empty()) {
110+
if (committed_xacts.find(gid) != committed_xacts.end()) {
111+
if (verbose) {
112+
cout <<"Commit transaction" << gid <<"\n";
113+
}
114+
txn.prepared("commit-prepared")(gid);
115+
}else {
116+
if (verbose) {
117+
cout <<"Rollback transaction" << gid <<"\n";
118+
}
119+
txn.prepared("rollback-prepared")(gid);
120+
}
121+
}
122+
}
123+
txn.commit();
124+
}
125+
if (verbose) {
126+
cout <<"Recovery completed\n";
127+
}
128+
return0;
129+
}
Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
CXX=g++
2+
CXXFLAGS=-g -Wall -O0 -pthread
3+
4+
all: dtm_recovery
5+
6+
dtm_recovery: dtm_recovery.cpp
7+
$(CXX)$(CXXFLAGS) -o dtm_recovery dtm_recovery.cpp -lpqxx
8+
9+
clean:
10+
rm -f dtm_recovery

‎contrib/pg_tsdtm/pg_tsdtm--1.0.sql

Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,26 @@
1+
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
2+
\echo Use"CREATE EXTENSION pg_dtm" to load this file. \quit
3+
4+
CREATEFUNCTIONdtm_extend(gtid cstring defaultnull) RETURNSbigint
5+
AS'MODULE_PATHNAME','dtm_extend'
6+
LANGUAGE C;
7+
8+
CREATEFUNCTIONdtm_access(snapshotbigint, gtid cstring defaultnull) RETURNSbigint
9+
AS'MODULE_PATHNAME','dtm_access'
10+
LANGUAGE C;
11+
12+
CREATEFUNCTIONdtm_begin_prepare(gtid cstring) RETURNS void
13+
AS'MODULE_PATHNAME','dtm_begin_prepare'
14+
LANGUAGE C;
15+
16+
CREATEFUNCTIONdtm_prepare(gtid cstring, csnbigint) RETURNSbigint
17+
AS'MODULE_PATHNAME','dtm_prepare'
18+
LANGUAGE C;
19+
20+
CREATEFUNCTIONdtm_end_prepare(gtid cstring, csnbigint) RETURNS void
21+
AS'MODULE_PATHNAME','dtm_end_prepare'
22+
LANGUAGE C;
23+
24+
CREATEFUNCTIONdtm_get_csn(xidinteger) RETURNSbigint
25+
AS'MODULE_PATHNAME','dtm_get_csn'
26+
LANGUAGE C;

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp