deadlock.txt

text/plain

Download

nitinmotiani@nitinmotiani:~/vanila_postgres/postgresql$ ./crash-test-tables-order-reverse.sh test-data-dir-reverse-proper 2 2 5
/usr/local/pgsql/bin:/usr/local/pgsql/bin:/usr/local/pgsql/bin:/usr/lib/google-golang/bin:/usr/local/buildtools/java/jdk/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
[Wed Jul 10 07:50:10 AM UTC 2024] [1720597810] NUMTABLES=2  SLEEP=5  REFRESH=2
The files belonging to this database system will be owned by user "nitinmotiani".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory test-data-dir-reverse-proper/data-pub ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /usr/local/pgsql/bin/pg_ctl -D test-data-dir-reverse-proper/data-pub -l logfile start

The files belonging to this database system will be owned by user "nitinmotiani".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

creating directory test-data-dir-reverse-proper/data-sub ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.

Success. You can now start the database server using:

    /usr/local/pgsql/bin/pg_ctl -D test-data-dir-reverse-proper/data-sub -l logfile start

waiting for server to start.... done
server started
waiting for server to start.... done
server started
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
[Wed Jul 10 07:50:12 AM UTC 2024] [1720597812] creating publication
CREATE PUBLICATION
[Wed Jul 10 07:50:12 AM UTC 2024] [1720597812] sleeping
[Wed Jul 10 07:50:17 AM UTC 2024] [1720597817] creating subscription
NOTICE:  created replication slot "s" on publisher
CREATE SUBSCRIPTION
[Wed Jul 10 07:50:17 AM UTC 2024] [1720597817] sleeping
Printing bulk alter command
ALTER PUBLICATION p ADD TABLE test_2,test_1
ERROR:  deadlock detected
DETAIL:  Process 524333 waits for ShareRowExclusiveLock on relation 16386 of database 16384; blocked by process 524298.
Process 524298 waits for RowExclusiveLock on relation 16395 of database 16384; blocked by process 524333.
HINT:  See server log for query details.
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] adding table 2 to publication [0/3669BC0]
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] refreshing publication [0/366F9D8]
ALTER SUBSCRIPTION
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] adding table 1 to publication [0/36826A8]
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] refreshing publication [0/3688A98]
ALTER SUBSCRIPTION
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] waiting for subscription
[Wed Jul 10 07:50:23 AM UTC 2024] [1720597823] synced 0 tables out of 2
[Wed Jul 10 07:50:24 AM UTC 2024] [1720597824] waiting for subscription
[Wed Jul 10 07:50:24 AM UTC 2024] [1720597824] synced 0 tables out of 2
[Wed Jul 10 07:50:25 AM UTC 2024] [1720597825] waiting for subscription
[Wed Jul 10 07:50:25 AM UTC 2024] [1720597825] synced 0 tables out of 2
[Wed Jul 10 07:50:26 AM UTC 2024] [1720597826] waiting for subscription
[Wed Jul 10 07:50:26 AM UTC 2024] [1720597826] synced 0 tables out of 2
[Wed Jul 10 07:50:27 AM UTC 2024] [1720597827] waiting for subscription
[Wed Jul 10 07:50:27 AM UTC 2024] [1720597827] synced 0 tables out of 2
[Wed Jul 10 07:50:28 AM UTC 2024] [1720597828] waiting for subscription
[Wed Jul 10 07:50:28 AM UTC 2024] [1720597828] synced 0 tables out of 2
[Wed Jul 10 07:50:29 AM UTC 2024] [1720597829] waiting for subscription
[Wed Jul 10 07:50:29 AM UTC 2024] [1720597829] synced 0 tables out of 2
[Wed Jul 10 07:50:30 AM UTC 2024] [1720597830] waiting for subscription
[Wed Jul 10 07:50:30 AM UTC 2024] [1720597830] synced 0 tables out of 2
[Wed Jul 10 07:50:31 AM UTC 2024] [1720597831] waiting for subscription
[Wed Jul 10 07:50:31 AM UTC 2024] [1720597831] synced 0 tables out of 2
[Wed Jul 10 07:50:32 AM UTC 2024] [1720597832] waiting for subscription
[Wed Jul 10 07:50:32 AM UTC 2024] [1720597832] synced 0 tables out of 2
[Wed Jul 10 07:50:33 AM UTC 2024] [1720597833] waiting for subscription
[Wed Jul 10 07:50:33 AM UTC 2024] [1720597833] synced 0 tables out of 2
[Wed Jul 10 07:50:34 AM UTC 2024] [1720597834] waiting for subscription
[Wed Jul 10 07:50:34 AM UTC 2024] [1720597834] synced 0 tables out of 2
[Wed Jul 10 07:50:35 AM UTC 2024] [1720597835] waiting for subscription
[Wed Jul 10 07:50:35 AM UTC 2024] [1720597835] synced 0 tables out of 2
[Wed Jul 10 07:50:36 AM UTC 2024] [1720597836] waiting for subscription
[Wed Jul 10 07:50:36 AM UTC 2024] [1720597836] synced 0 tables out of 2
[Wed Jul 10 07:50:37 AM UTC 2024] [1720597837] waiting for subscription
[Wed Jul 10 07:50:37 AM UTC 2024] [1720597837] synced 0 tables out of 2
[Wed Jul 10 07:50:38 AM UTC 2024] [1720597838] waiting for subscription
[Wed Jul 10 07:50:38 AM UTC 2024] [1720597838] synced 0 tables out of 2
[Wed Jul 10 07:50:39 AM UTC 2024] [1720597839] waiting for subscription
[Wed Jul 10 07:50:39 AM UTC 2024] [1720597839] synced 0 tables out of 2
[Wed Jul 10 07:50:40 AM UTC 2024] [1720597840] waiting for subscription
[Wed Jul 10 07:50:40 AM UTC 2024] [1720597840] synced 0 tables out of 2
[Wed Jul 10 07:50:41 AM UTC 2024] [1720597841] waiting for subscription
[Wed Jul 10 07:50:41 AM UTC 2024] [1720597841] synced 0 tables out of 2
[Wed Jul 10 07:50:42 AM UTC 2024] [1720597842] waiting for subscription
[Wed Jul 10 07:50:42 AM UTC 2024] [1720597842] synced 0 tables out of 2