Comments (5)
Thanks for your test case. This fix will be included in the next version.
from wal2json.
Ping @eulerto (sorry for pinging you directly). We would like to solve this, but don't know where to start. Do you happen to have an idea what the problem could be?
from wal2json.
What's your Postgres version? What's your wal2json version? Could you provide a reproducible test case?
from wal2json.
Thank you for your response, @eulerto.
We are currently using the following versions locally:
-
Postgres version:
PostgreSQL 14.5 (Debian 14.5-1.pgdg110+1) on aarch64-unknown-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
-
wal2json version:
Package: postgresql-14-wal2json - Version: 2.5-1.pgdg110+1
(installed using apt)
I've created a small video recording. At the bottom, you can find the SQL statements for the reproducible test case.
wal2json-trimmed.mov
File 1:
-- Setup
SET search_path to "public";
DROP TABLE IF EXISTS "public"."outbox_messages";
CREATE SEQUENCE IF NOT EXISTS outbox_messages_id_seq;
CREATE TABLE "public"."outbox_messages" (
"id" int4 NOT NULL DEFAULT nextval('outbox_messages_id_seq'::regclass),
"payload" text NOT NULL,
PRIMARY KEY ("id")
);
-- Start
SELECT 'init' FROM pg_create_logical_replication_slot('test_1', 'wal2json');
SELECT pg_logical_emit_message(false, 'heartbeat', now()::varchar);
-- While the other transaction is busy, execute the following statement a couple times:
SELECT pg_logical_emit_message(false, 'heartbeat', now()::varchar);
SELECT data FROM pg_logical_slot_peek_changes('test_1', null, null);
SELECT 'stop' FROM pg_drop_replication_slot('test_1');
File 2:
SET search_path to "public";
BEGIN;
INSERT INTO outbox_messages (payload) VALUES ('test1');
SELECT pg_sleep(3);
INSERT INTO outbox_messages (payload) VALUES ('test1');
SELECT pg_sleep(2);
INSERT INTO outbox_messages (payload) VALUES ('test1');
COMMIT;
from wal2json.
@eulerto any idea on when the next version will be released?
from wal2json.
Related Issues (20)
- Getting table name in double Quotes HOT 2
- Segmentation fault HOT 1
- ERROR: could not load library "C:/Program Files/PostgreSQL/9.5/lib/wal2json.dll": The specified module could not be found. HOT 1
- START_REPLICATION command does not work with wal2json options HOT 1
- NaN values are received as "null" for NUMERIC type while capturing change data HOT 4
- WAL record received in different formats when the table name contains the single quote HOT 1
- Add support for update_replication_progress introduced in pg15
- Install failed on Alpine 15 HOT 2
- ProgramLimitExceeded plugin wal2json HOT 2
- include-pk can't work with identity full? HOT 2
- Official instructions to build from source for production use HOT 1
- Change data not captured HOT 3
- LSN not picking from "withStartPosition" in format version-2 HOT 2
- Building dll for windows HOT 4
- Build and Install In RDS
- wal2json_16 is not available in CentOS7 HOT 1
- Unable to compile wal2json on Mac M1 HOT 1
- Installcheck in a loop eventually fails
- Best practice to handle "no old tuple data for UPDATE in table"? HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from wal2json.