Thanks all for your help.
I have discovered another fact: When surrounding the execution of the failing
INSERT with a savepoint + rollback to savepoint, the problem disappears: The
DEALLOCATE commands do then succeed.
See attached trace...
Seb
________________________________
From: Tom Lane <[email protected]>
Sent: Monday, April 8, 2024 7:36 PM
To: Sebastien Flaesch <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: prepared statement "cu1" already exists (but it does not)
EXTERNAL: Do not click links or open attachments if you do not recognize the
sender.
Sebastien Flaesch <[email protected]> writes:
> I understand that the whole TX is aborted with PostgreSQL, and probably the
> deallocate is useless since stmt was prepared inside the TX?
As you can quickly discover with some manual experimentation,
both PREPARE and DEALLOCATE are nontransactional, in the sense
that if they succeed then the prepared statement will exist
(or not) even if the surrounding transaction block is later
rolled back. This is pretty weird, and undocumented I think,
in terms of their role as SQL statements.
It makes a little more sense if you think about the equivalent
wire-protocol-level operations, which are meant to be used
by low-level client code that may not be aware of whether
there is a transaction block in progress.
> Is it an issue if I use the same name for a prepared statement and the server
> cursor? I mean:
>From memory, I think those share the same "portal" namespace.
regards, tom lane
2024-04-08 19:39:22.679893 F 33 Query "set
intervalstyle='iso_8601'"
2024-04-08 19:39:22.679989 B 8 CommandComplete "SET"
2024-04-08 19:39:22.679993 B 27 ParameterStatus
"IntervalStyle" "iso_8601"
2024-04-08 19:39:22.679994 B 5 ReadyForQuery I
2024-04-08 19:39:22.680029 F 67 Query "update pg_settings
set setting=10000 where name='lock_timeout'"
2024-04-08 19:39:22.680939 B 35 RowDescription 1 "set_config"
0 0 25 65535 -1 0
2024-04-08 19:39:22.680945 B 13 DataRow 1 3 '10s'
2024-04-08 19:39:22.680947 B 13 CommandComplete "UPDATE 0"
2024-04-08 19:39:22.680948 B 5 ReadyForQuery I
2024-04-08 19:39:22.681035 F 10 Query "begin"
2024-04-08 19:39:22.681150 B 10 CommandComplete "BEGIN"
2024-04-08 19:39:22.681155 B 5 ReadyForQuery T
2024-04-08 19:39:22.681306 F 250 Parse "cu0" "declare srv_cu0
cursor for select udsi_table_name, udsi_last_mtime, udsi_temp_mtime,
udsi_can_insert, udsi_can_update, udsi_can_delete, udsi_where_part,
udsi_position from dbsync_udsinfo where udsi_user_id = $1 order by
udsi_position" 1 1043
2024-04-08 19:39:22.681308 F 4 Sync
2024-04-08 19:39:22.681739 B 4 ParseComplete
2024-04-08 19:39:22.681744 B 5 ReadyForQuery T
2024-04-08 19:39:22.681748 F 27 Bind "" "cu0" 1 0 1 4
'mike' 1 0
2024-04-08 19:39:22.681750 F 6 Describe P ""
2024-04-08 19:39:22.681751 F 9 Execute "" 0
2024-04-08 19:39:22.681752 F 4 Sync
2024-04-08 19:39:22.682027 B 4 BindComplete
2024-04-08 19:39:22.682033 B 4 NoData
2024-04-08 19:39:22.682034 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.682036 B 5 ReadyForQuery T
2024-04-08 19:39:22.682038 F 34 Query "fetch absolute 0 from
srv_cu0"
2024-04-08 19:39:22.682126 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.682131 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.682132 B 5 ReadyForQuery T
2024-04-08 19:39:22.682175 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.682277 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.682280 B 71 DataRow 8 6 'author' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '1'
2024-04-08 19:39:22.682282 B 69 DataRow 8 4 'book' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '2'
2024-04-08 19:39:22.682284 B 12 CommandComplete "FETCH 2"
2024-04-08 19:39:22.682285 B 5 ReadyForQuery T
2024-04-08 19:39:22.682386 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.682411 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.682414 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.682415 B 5 ReadyForQuery T
2024-04-08 19:39:22.682467 F 18 Query "close srv_cu0"
2024-04-08 19:39:22.682488 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.682490 B 5 ReadyForQuery T
2024-04-08 19:39:22.682557 F 104 Parse "" "update
dbsync_udsinfo SET udsi_user_id = udsi_user_id WHERE udsi_table_name IN
('author','book')" 0
2024-04-08 19:39:22.682559 F 14 Bind "" "" 0 0 1 0
2024-04-08 19:39:22.682560 F 6 Describe P ""
2024-04-08 19:39:22.682561 F 9 Execute "" 0
2024-04-08 19:39:22.682562 F 4 Sync
2024-04-08 19:39:22.682762 B 4 ParseComplete
2024-04-08 19:39:22.682763 B 4 BindComplete
2024-04-08 19:39:22.682764 B 4 NoData
2024-04-08 19:39:22.682765 B 13 CommandComplete "UPDATE 4"
2024-04-08 19:39:22.682766 B 5 ReadyForQuery T
2024-04-08 19:39:22.682821 F 137 Parse "" "select
udsi_last_mtime from dbsync_udsinfo where udsi_user_id = $1 AND
udsi_table_name = $2 AND udsi_temp_mtime IS NULL" 2 1043 1043
2024-04-08 19:39:22.682822 F 36 Bind "" "" 2 0 0 2 4 'mike'
6 'author' 1 0
2024-04-08 19:39:22.682824 F 6 Describe P ""
2024-04-08 19:39:22.682825 F 9 Execute "" 0
2024-04-08 19:39:22.682826 F 4 Sync
2024-04-08 19:39:22.682892 B 4 ParseComplete
2024-04-08 19:39:22.682893 B 4 BindComplete
2024-04-08 19:39:22.682895 B 40 RowDescription 1
"udsi_last_mtime" 25071 8 1114 8 3 0
2024-04-08 19:39:22.682896 B 33 DataRow 1 23 '2024-04-08
12:59:40.765'
2024-04-08 19:39:22.682897 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.682898 B 5 ReadyForQuery T
2024-04-08 19:39:22.682957 F 106 Parse "" "select
udsi_user_id from dbsync_udsinfo where udsi_user_id = $1 AND udsi_table_name
= $2" 2 1043 1043
2024-04-08 19:39:22.682958 F 36 Bind "" "" 2 0 0 2 4 'mike'
6 'author' 1 0
2024-04-08 19:39:22.682960 F 6 Describe P ""
2024-04-08 19:39:22.682961 F 9 Execute "" 0
2024-04-08 19:39:22.682962 F 4 Sync
2024-04-08 19:39:22.683009 B 4 ParseComplete
2024-04-08 19:39:22.683011 B 4 BindComplete
2024-04-08 19:39:22.683012 B 37 RowDescription 1
"udsi_user_id" 25071 1 1043 65535 24 0
2024-04-08 19:39:22.683013 B 14 DataRow 1 4 'mike'
2024-04-08 19:39:22.683014 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.683015 B 5 ReadyForQuery T
2024-04-08 19:39:22.683077 F 137 Parse "" "select
udsi_last_mtime from dbsync_udsinfo where udsi_user_id = $1 AND
udsi_table_name = $2 AND udsi_temp_mtime IS NULL" 2 1043 1043
2024-04-08 19:39:22.683078 F 34 Bind "" "" 2 0 0 2 4 'mike'
4 'book' 1 0
2024-04-08 19:39:22.683080 F 6 Describe P ""
2024-04-08 19:39:22.683081 F 9 Execute "" 0
2024-04-08 19:39:22.683082 F 4 Sync
2024-04-08 19:39:22.683127 B 4 ParseComplete
2024-04-08 19:39:22.683128 B 4 BindComplete
2024-04-08 19:39:22.683129 B 40 RowDescription 1
"udsi_last_mtime" 25071 8 1114 8 3 0
2024-04-08 19:39:22.683131 B 33 DataRow 1 23 '2024-04-08
12:59:40.765'
2024-04-08 19:39:22.683132 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.683133 B 5 ReadyForQuery T
2024-04-08 19:39:22.683187 F 106 Parse "" "select
udsi_user_id from dbsync_udsinfo where udsi_user_id = $1 AND udsi_table_name
= $2" 2 1043 1043
2024-04-08 19:39:22.683188 F 34 Bind "" "" 2 0 0 2 4 'mike'
4 'book' 1 0
2024-04-08 19:39:22.683190 F 6 Describe P ""
2024-04-08 19:39:22.683191 F 9 Execute "" 0
2024-04-08 19:39:22.683192 F 4 Sync
2024-04-08 19:39:22.683234 B 4 ParseComplete
2024-04-08 19:39:22.683235 B 4 BindComplete
2024-04-08 19:39:22.683237 B 37 RowDescription 1
"udsi_user_id" 25071 1 1043 65535 24 0
2024-04-08 19:39:22.683238 B 14 DataRow 1 4 'mike'
2024-04-08 19:39:22.683239 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.683240 B 5 ReadyForQuery T
2024-04-08 19:39:22.683328 F 18 Query "savepoint sp1"
2024-04-08 19:39:22.683349 B 14 CommandComplete "SAVEPOINT"
2024-04-08 19:39:22.683350 B 5 ReadyForQuery T
2024-04-08 19:39:22.683448 F 425 Query "select
ns.nspname||'.'||substring(pg_get_expr(a.adbin,0) from 'nextval.''([^'']*)')
seqname , c.attname from pg_class p join pg_attrdef a on (p.oid=a.adrelid)
join pg_attribute c on (p.oid=c.attrelid and a.adnum=c.attnum) join
pg_namespace ns on (p.relnamespace=ns.oid) where
upper(p.relname)=upper('book') and pg_get_expr(a.adbin,0) like 'nextval%' and
(ns.nspname=current_schema() or ns.oid=pg_my_temp_schema())"
2024-04-08 19:39:22.684440 B 58 RowDescription 2 "seqname" 0
0 25 65535 -1 0 "attname" 1249 2 19 64 -1 0
2024-04-08 19:39:22.684443 B 44 DataRow 2 23
'public.book_book_id_seq' 7 'book_id'
2024-04-08 19:39:22.684445 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.684446 B 5 ReadyForQuery T
2024-04-08 19:39:22.684622 F 370 Parse "cu1" "insert into
book (b_title, b_author, b_isbn, b_pub_date, b_price, b_plot, boo_mtime,
boo_muser, boo_mstat) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning
book.book_id, (select case when book.book_id>(select last_value from
public.book_book_id_seq) then
setval('public.book_book_id_seq',book.book_id,true) else 0 end)" 9 1043 23 1043
1082 1700 1043 1114 1043 1042
2024-04-08 19:39:22.684623 F 4 Sync
2024-04-08 19:39:22.684763 B 4 ParseComplete
2024-04-08 19:39:22.684765 B 5 ReadyForQuery T
2024-04-08 19:39:22.684766 F 123 Bind "" "cu1" 9 0 0 0 0 0 0
0 0 0 9 3 'EEE' 3 '100' 2 '44' 10 '2024-04-08' 4 '0.00' -1 26 '2024-04-08
17:39:22.681000' 4 'mike' -1 1 0
2024-04-08 19:39:22.684769 F 6 Describe P ""
2024-04-08 19:39:22.684770 F 9 Execute "" 0
2024-04-08 19:39:22.684771 F 4 Sync
2024-04-08 19:39:22.684956 B 4 BindComplete
2024-04-08 19:39:22.684958 B 55 RowDescription 2 "book_id"
25034 1 23 4 -1 0 "case" 0 0 20 8 -1 0
2024-04-08 19:39:22.684962 B 194 ErrorResponse S "ERROR" V
"ERROR" C "23505" M "duplicate key value violates unique constraint
"book_b_isbn_key"" D "Key (b_isbn)=(44) already exists." s "public" t "book" n
"book_b_isbn_key" F "nbtinsert.c" L "666" R "_bt_check_unique" \x00
2024-04-08 19:39:22.684974 B 5 ReadyForQuery E
2024-04-08 19:39:22.685061 F 30 Query "rollback to savepoint
sp1"
2024-04-08 19:39:22.685085 B 13 CommandComplete "ROLLBACK"
2024-04-08 19:39:22.685086 B 5 ReadyForQuery T
2024-04-08 19:39:22.685099 F 19 Query "deallocate cu1"
2024-04-08 19:39:22.685118 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.685119 B 5 ReadyForQuery T
2024-04-08 19:39:22.685159 F 19 Query "deallocate cu0"
2024-04-08 19:39:22.685177 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.685178 B 5 ReadyForQuery T
2024-04-08 19:39:22.685182 F 13 Query "rollback"
2024-04-08 19:39:22.685214 B 13 CommandComplete "ROLLBACK"
2024-04-08 19:39:22.685215 B 5 ReadyForQuery I
2024-04-08 19:39:22.685262 F 10 Query "begin"
2024-04-08 19:39:22.685281 B 10 CommandComplete "BEGIN"
2024-04-08 19:39:22.685282 B 5 ReadyForQuery T
2024-04-08 19:39:22.685378 F 250 Parse "cu0" "declare srv_cu0
cursor for select udsi_table_name, udsi_last_mtime, udsi_temp_mtime,
udsi_can_insert, udsi_can_update, udsi_can_delete, udsi_where_part,
udsi_position from dbsync_udsinfo where udsi_user_id = $1 order by
udsi_position" 1 1043
2024-04-08 19:39:22.685381 F 4 Sync
2024-04-08 19:39:22.685419 B 4 ParseComplete
2024-04-08 19:39:22.685420 B 5 ReadyForQuery T
2024-04-08 19:39:22.685422 F 27 Bind "" "cu0" 1 0 1 4
'mike' 1 0
2024-04-08 19:39:22.685423 F 6 Describe P ""
2024-04-08 19:39:22.685424 F 9 Execute "" 0
2024-04-08 19:39:22.685425 F 4 Sync
2024-04-08 19:39:22.685472 B 4 BindComplete
2024-04-08 19:39:22.685473 B 4 NoData
2024-04-08 19:39:22.685474 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.685475 B 5 ReadyForQuery T
2024-04-08 19:39:22.685477 F 34 Query "fetch absolute 0 from
srv_cu0"
2024-04-08 19:39:22.685500 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.685503 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.685504 B 5 ReadyForQuery T
2024-04-08 19:39:22.685531 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.685560 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.685563 B 71 DataRow 8 6 'author' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '1'
2024-04-08 19:39:22.685565 B 69 DataRow 8 4 'book' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '2'
2024-04-08 19:39:22.685566 B 12 CommandComplete "FETCH 2"
2024-04-08 19:39:22.685567 B 5 ReadyForQuery T
2024-04-08 19:39:22.685658 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.685678 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.685681 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.685682 B 5 ReadyForQuery T
2024-04-08 19:39:22.685731 F 18 Query "close srv_cu0"
2024-04-08 19:39:22.685751 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.685752 B 5 ReadyForQuery T
2024-04-08 19:39:22.685803 F 104 Parse "" "update
dbsync_udsinfo SET udsi_user_id = udsi_user_id WHERE udsi_table_name IN
('author','book')" 0
2024-04-08 19:39:22.685805 F 14 Bind "" "" 0 0 1 0
2024-04-08 19:39:22.685806 F 6 Describe P ""
2024-04-08 19:39:22.685807 F 9 Execute "" 0
2024-04-08 19:39:22.685808 F 4 Sync
2024-04-08 19:39:22.685873 B 4 ParseComplete
2024-04-08 19:39:22.685875 B 4 BindComplete
2024-04-08 19:39:22.685876 B 4 NoData
2024-04-08 19:39:22.685877 B 13 CommandComplete "UPDATE 4"
2024-04-08 19:39:22.685878 B 5 ReadyForQuery T
2024-04-08 19:39:22.685921 F 106 Parse "" "select
udsi_user_id from dbsync_udsinfo where udsi_user_id = $1 AND udsi_table_name
= $2" 2 1043 1043
2024-04-08 19:39:22.685922 F 36 Bind "" "" 2 0 0 2 4 'mike'
6 'author' 1 0
2024-04-08 19:39:22.685924 F 6 Describe P ""
2024-04-08 19:39:22.685925 F 9 Execute "" 0
2024-04-08 19:39:22.685926 F 4 Sync
2024-04-08 19:39:22.685977 B 4 ParseComplete
2024-04-08 19:39:22.685978 B 4 BindComplete
2024-04-08 19:39:22.685979 B 37 RowDescription 1
"udsi_user_id" 25071 1 1043 65535 24 0
2024-04-08 19:39:22.685981 B 14 DataRow 1 4 'mike'
2024-04-08 19:39:22.685982 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.685983 B 5 ReadyForQuery T
2024-04-08 19:39:22.686037 F 106 Parse "" "select
udsi_user_id from dbsync_udsinfo where udsi_user_id = $1 AND udsi_table_name
= $2" 2 1043 1043
2024-04-08 19:39:22.686039 F 34 Bind "" "" 2 0 0 2 4 'mike'
4 'book' 1 0
2024-04-08 19:39:22.686040 F 6 Describe P ""
2024-04-08 19:39:22.686041 F 9 Execute "" 0
2024-04-08 19:39:22.686042 F 4 Sync
2024-04-08 19:39:22.686087 B 4 ParseComplete
2024-04-08 19:39:22.686088 B 4 BindComplete
2024-04-08 19:39:22.686089 B 37 RowDescription 1
"udsi_user_id" 25071 1 1043 65535 24 0
2024-04-08 19:39:22.686091 B 14 DataRow 1 4 'mike'
2024-04-08 19:39:22.686092 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.686093 B 5 ReadyForQuery T
2024-04-08 19:39:22.686141 F 19 Query "deallocate cu0"
2024-04-08 19:39:22.686162 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.686163 B 5 ReadyForQuery T
2024-04-08 19:39:22.686227 F 250 Parse "cu0" "declare srv_cu0
cursor for select udsi_table_name, udsi_last_mtime, udsi_temp_mtime,
udsi_can_insert, udsi_can_update, udsi_can_delete, udsi_where_part,
udsi_position from dbsync_udsinfo where udsi_user_id = $1 order by
udsi_position" 1 1043
2024-04-08 19:39:22.686228 F 4 Sync
2024-04-08 19:39:22.686256 B 4 ParseComplete
2024-04-08 19:39:22.686258 B 5 ReadyForQuery T
2024-04-08 19:39:22.686259 F 27 Bind "" "cu0" 1 0 1 4
'mike' 1 0
2024-04-08 19:39:22.686260 F 6 Describe P ""
2024-04-08 19:39:22.686261 F 9 Execute "" 0
2024-04-08 19:39:22.686262 F 4 Sync
2024-04-08 19:39:22.686300 B 4 BindComplete
2024-04-08 19:39:22.686301 B 4 NoData
2024-04-08 19:39:22.686302 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.686303 B 5 ReadyForQuery T
2024-04-08 19:39:22.686305 F 34 Query "fetch absolute 0 from
srv_cu0"
2024-04-08 19:39:22.686325 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.686328 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.686329 B 5 ReadyForQuery T
2024-04-08 19:39:22.686353 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.686380 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.686383 B 71 DataRow 8 6 'author' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '1'
2024-04-08 19:39:22.686385 B 69 DataRow 8 4 'book' 23
'2024-04-08 12:59:40.765' -1 1 'Y' 1 'Y' 1 'Y' -1 1 '2'
2024-04-08 19:39:22.686386 B 12 CommandComplete "FETCH 2"
2024-04-08 19:39:22.686387 B 5 ReadyForQuery T
2024-04-08 19:39:22.686480 F 34 Query "fetch forward 50 from
srv_cu0"
2024-04-08 19:39:22.686499 B 276 RowDescription 8
"udsi_table_name" 25071 2 1043 65535 54 0 "udsi_last_mtime" 25071 8 1114 8 3 0
"udsi_temp_mtime" 25071 9 1114 8 3 0 "udsi_can_insert" 25071 4 1042 65535 5 0
"udsi_can_update" 25071 5 1042 65535 5 0 "udsi_can_delete" 25071 6 1042 65535 5
0 "udsi_where_part" 25071 7 1043 65535 2004 0 "udsi_position" 25071 3 23 4 -1 0
2024-04-08 19:39:22.686502 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.686503 B 5 ReadyForQuery T
2024-04-08 19:39:22.686548 F 18 Query "close srv_cu0"
2024-04-08 19:39:22.686566 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.686567 B 5 ReadyForQuery T
2024-04-08 19:39:22.686642 F 109 Parse "" "select
udsi_where_part from dbsync_udsinfo where udsi_user_id = $1 AND
udsi_table_name = $2" 2 1043 1043
2024-04-08 19:39:22.686644 F 36 Bind "" "" 2 0 0 2 4 'mike'
6 'author' 1 0
2024-04-08 19:39:22.686645 F 6 Describe P ""
2024-04-08 19:39:22.686646 F 9 Execute "" 0
2024-04-08 19:39:22.686647 F 4 Sync
2024-04-08 19:39:22.686692 B 4 ParseComplete
2024-04-08 19:39:22.686693 B 4 BindComplete
2024-04-08 19:39:22.686695 B 40 RowDescription 1
"udsi_where_part" 25071 7 1043 65535 2004 0
2024-04-08 19:39:22.686696 B 10 DataRow 1 -1
2024-04-08 19:39:22.686697 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.686698 B 5 ReadyForQuery T
2024-04-08 19:39:22.686771 F 109 Parse "" "select
udsi_where_part from dbsync_udsinfo where udsi_user_id = $1 AND
udsi_table_name = $2" 2 1043 1043
2024-04-08 19:39:22.686772 F 34 Bind "" "" 2 0 0 2 4 'mike'
4 'book' 1 0
2024-04-08 19:39:22.686774 F 6 Describe P ""
2024-04-08 19:39:22.686775 F 9 Execute "" 0
2024-04-08 19:39:22.686776 F 4 Sync
2024-04-08 19:39:22.686819 B 4 ParseComplete
2024-04-08 19:39:22.686820 B 4 BindComplete
2024-04-08 19:39:22.686822 B 40 RowDescription 1
"udsi_where_part" 25071 7 1043 65535 2004 0
2024-04-08 19:39:22.686823 B 10 DataRow 1 -1
2024-04-08 19:39:22.686824 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.686825 B 5 ReadyForQuery T
2024-04-08 19:39:22.686883 F 109 Parse "" "select
udsi_where_part from dbsync_udsinfo where udsi_user_id = $1 AND
udsi_table_name = $2" 2 1043 1043
2024-04-08 19:39:22.686885 F 36 Bind "" "" 2 0 0 2 4 'mike'
6 'author' 1 0
2024-04-08 19:39:22.686886 F 6 Describe P ""
2024-04-08 19:39:22.686887 F 9 Execute "" 0
2024-04-08 19:39:22.686888 F 4 Sync
2024-04-08 19:39:22.686929 B 4 ParseComplete
2024-04-08 19:39:22.686931 B 4 BindComplete
2024-04-08 19:39:22.686932 B 40 RowDescription 1
"udsi_where_part" 25071 7 1043 65535 2004 0
2024-04-08 19:39:22.686933 B 10 DataRow 1 -1
2024-04-08 19:39:22.686934 B 13 CommandComplete "SELECT 1"
2024-04-08 19:39:22.686935 B 5 ReadyForQuery T
2024-04-08 19:39:22.687030 F 61 Parse "cu1" "declare srv_cu1
cursor for select * from author " 0
2024-04-08 19:39:22.687032 F 4 Sync
2024-04-08 19:39:22.687081 B 4 ParseComplete
2024-04-08 19:39:22.687082 B 5 ReadyForQuery T
2024-04-08 19:39:22.687083 F 17 Bind "" "cu1" 0 0 1 0
2024-04-08 19:39:22.687085 F 6 Describe P ""
2024-04-08 19:39:22.687086 F 9 Execute "" 0
2024-04-08 19:39:22.687087 F 4 Sync
2024-04-08 19:39:22.687148 B 4 BindComplete
2024-04-08 19:39:22.687150 B 4 NoData
2024-04-08 19:39:22.687151 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.687152 B 5 ReadyForQuery T
2024-04-08 19:39:22.687153 F 34 Query "fetch absolute 0 from
srv_cu1"
2024-04-08 19:39:22.687177 B 141 RowDescription 5 "auth_id"
25027 1 23 4 -1 0 "a_name" 25027 2 1043 65535 54 0 "aut_muser" 25027 33 1043
65535 24 0 "aut_mtime" 25027 34 1114 8 3 0 "aut_mstat" 25027 35 1042 65535 5 0
2024-04-08 19:39:22.687179 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.687180 B 5 ReadyForQuery T
2024-04-08 19:39:22.687204 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.687226 B 141 RowDescription 5 "auth_id"
25027 1 23 4 -1 0 "a_name" 25027 2 1043 65535 54 0 "aut_muser" 25027 33 1043
65535 24 0 "aut_mtime" 25027 34 1114 8 3 0 "aut_mstat" 25027 35 1042 65535 5 0
2024-04-08 19:39:22.687229 B 45 DataRow 5 3 '100' 16 '<unknown
author>' -1 -1 -1
2024-04-08 19:39:22.687231 B 41 DataRow 5 3 '101' 12 'Stephen
KING' -1 -1 -1
2024-04-08 19:39:22.687232 B 44 DataRow 5 3 '102' 15 'James
Patterson' -1 -1 -1
2024-04-08 19:39:22.687233 B 38 DataRow 5 3 '103' 9 'Dan
Brown' -1 -1 -1
2024-04-08 19:39:22.687234 B 12 CommandComplete "FETCH 4"
2024-04-08 19:39:22.687235 B 5 ReadyForQuery T
2024-04-08 19:39:22.687430 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.687450 B 141 RowDescription 5 "auth_id"
25027 1 23 4 -1 0 "a_name" 25027 2 1043 65535 54 0 "aut_muser" 25027 33 1043
65535 24 0 "aut_mtime" 25027 34 1114 8 3 0 "aut_mstat" 25027 35 1042 65535 5 0
2024-04-08 19:39:22.687453 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.687454 B 5 ReadyForQuery T
2024-04-08 19:39:22.687492 F 18 Query "close srv_cu1"
2024-04-08 19:39:22.687509 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.687511 B 5 ReadyForQuery T
2024-04-08 19:39:22.687540 F 19 Query "deallocate cu1"
2024-04-08 19:39:22.687557 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.687559 B 5 ReadyForQuery T
2024-04-08 19:39:22.687611 F 59 Parse "cu1" "declare srv_cu1
cursor for select * from book " 0
2024-04-08 19:39:22.687612 F 4 Sync
2024-04-08 19:39:22.687637 B 4 ParseComplete
2024-04-08 19:39:22.687639 B 5 ReadyForQuery T
2024-04-08 19:39:22.687640 F 17 Bind "" "cu1" 0 0 1 0
2024-04-08 19:39:22.687641 F 6 Describe P ""
2024-04-08 19:39:22.687642 F 9 Execute "" 0
2024-04-08 19:39:22.687643 F 4 Sync
2024-04-08 19:39:22.687709 B 4 BindComplete
2024-04-08 19:39:22.687710 B 4 NoData
2024-04-08 19:39:22.687711 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.687712 B 5 ReadyForQuery T
2024-04-08 19:39:22.687714 F 34 Query "fetch absolute 0 from
srv_cu1"
2024-04-08 19:39:22.687734 B 274 RowDescription 10 "book_id"
25034 1 23 4 -1 0 "b_title" 25034 2 1043 65535 104 0 "b_author" 25034 3 23 4 -1
0 "b_isbn" 25034 4 1043 65535 24 0 "b_pub_date" 25034 5 1082 4 -1 0 "b_price"
25034 6 1700 65535 655366 0 "b_plot" 25034 7 1043 65535 504 0 "boo_muser" 25034
29 1043 65535 24 0 "boo_mtime" 25034 30 1114 8 3 0 "boo_mstat" 25034 31 1042
65535 5 0
2024-04-08 19:39:22.687737 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.687738 B 5 ReadyForQuery T
2024-04-08 19:39:22.687760 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.687798 B 274 RowDescription 10 "book_id"
25034 1 23 4 -1 0 "b_title" 25034 2 1043 65535 104 0 "b_author" 25034 3 23 4 -1
0 "b_isbn" 25034 4 1043 65535 24 0 "b_pub_date" 25034 5 1082 4 -1 0 "b_price"
25034 6 1700 65535 655366 0 "b_plot" 25034 7 1043 65535 504 0 "boo_muser" 25034
29 1043 65535 24 0 "boo_mtime" 25034 30 1114 8 3 0 "boo_mstat" 25034 31 1042
65535 5 0
2024-04-08 19:39:22.687801 B 295 DataRow 10 5 '10103' 13 'The
Long Walk' 3 '101' 17 '978-0-451-08754-6' 10 '1979-07-11' 5 '14.30' 196 'In a
dystopian America, a major source of entertainment is the Long Walk, in which
one hundred teenage boys walk without rest along U.S. Route 1. Each Walker must
stay above four miles per hour...' -1 -1 -1
2024-04-08 19:39:22.687803 B 352 DataRow 10 5 '10202' 14 'Kiss
the Girls' 3 '102' 13 '0-316-69370-7' 10 '1995-01-11' 5 '12.40' 256 'As a
teenage boy in 1975 Boca Raton, Florida, a future serial killer calling himself
Casanova kills his first four victims. Elsewhere in 1981 Chapel Hill, North
Carolina, another killer calling himself The Gentleman Caller kills a young
couple on a lake...' -1 -1 -1
2024-04-08 19:39:22.687805 B 389 DataRow 10 5 '10301' 16
'Digital Fortress' 3 '103' 13 '0-312-18087-X' 10 '1998-01-01' 5 '10.20' 291
'The story is set in the year of 1996. When the United States National Security
Agency's (NSA) code-breaking supercomputer TRANSLTR encounters a revolutionary
new code, Digital Fortress, that it cannot break, Commander Trevor Strathmore
calls in head cryptographer Susan Fletcher to crack it.' -1 -1 -1
2024-04-08 19:39:22.687807 B 562 DataRow 10 5 '10304' 15 'The
Lost Symbol' 3 '103' 18 '978-0-385-50422-5 ' 10 '2009-09-15' 5 '11.40' 460
'Renowned Harvard symbologist Robert Langdon is invited to give a lecture at
the United States Capitol, at the invitation apparently from his mentor, a 33rd
degree Mason named Peter Solomon, who is the head of the Smithsonian
Institution. Solomon has also asked him to bring a small, sealed package which
he had entrusted to Langdon years earlier. When Langdon arrives at the Capitol,
however, he learns that the invitation he received was not from Solomon, ...'
-1 -1 -1
2024-04-08 19:39:22.687809 B 150 DataRow 10 5 '10201' 19 'Along
Came a Spider' 3 '102' 13 '0-316-69364-2' 10 '1993-03-23' 6 '111.20' 21
'XXXXXXXXXXEEFFFFFFFFF' 4 'mike' 23 '2024-04-06 15:52:29.806' -1
2024-04-08 19:39:22.687811 B 541 DataRow 10 5 '10302' 15
'Angels & Demons' 3 '103' 14 '0-671-02735-2 ' 10 '2000-04-01' 5 '14.55' 417
'Leonardo Vetra, one of CERN's top physicists who have discovered how to create
antimatter, is murdered, his chest branded with an ambigram of the word
"Illuminati", an ancient anti-religious organization thought extinct. CERN
director Maximilian Kohler calls Vetra's adopted daughter, Vittoria, and Robert
Langdon, an expert on symbology and religious history, for help. After
determining the ambigram is authentic...' 3 'ted' 23 '2024-04-06 15:52:51.803'
-1
2024-04-08 19:39:22.687813 B 99 DataRow 10 5 '20057' 3 'EEE' 3
'100' 2 '44' 10 '2024-04-08' 4 '0.00' -1 3 'ted' 23 '2024-04-08 12:59:54.496' -1
2024-04-08 19:39:22.687815 B 397 DataRow 10 5 '10101' 12 'The
Talisman' 3 '101' 17 '978-0-670-69199-9' 10 '1984-11-08' 5 '15.60' 274 'Jack
Sawyer, twelve years old, sets out from Arcadia Beach, New Hampshire, in a bid
to save his mother Lily, who is dying from cancer, by finding a crystal called
"the Talisman". Jack's journey takes him simultaneously through the American
heartland and "the Territories"...' 3 'ted' 22 '2024-04-03 10:56:54.38' -1
2024-04-08 19:39:22.687817 B 438 DataRow 10 5 '10303' 17 'The
Da Vinci Code' 3 '103' 13 '0-385-50420-9' 10 '2003-03-18' 5 '11.00' 317 'Louvre
curator and Priory of Sion grand master Jacques Sauni\xffffffc3\xffffffa8re is
fatally shot one night at the museum by an albino Catholic monk named Silas,
who is working on behalf of someone he knows only as the Teacher, who wishes to
discover the location of the "keystone," an item crucial in the search for the
Holy Grail...' 3 'ted' 19 '2024-04-03 09:52:01' -1
2024-04-08 19:39:22.687819 B 460 DataRow 10 5 '10104' 11
'Firestarter' 3 '101' 14 '978-0670315413' 10 '1980-09-29' 5 '13.50' 340
'XXXXXXXXXEEEEEEEEEEEEEEEEEEEEEEEWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWW\x0a\x0aXXXEEEEEEEEEEEEEEEEEEEEEEEWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWW\x0a\x0aWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWW\x0a\x0aXXXEEEEEEEEEEEEEEEEEEEEEEEWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWW\x0a\x0aXXXEEEEEEEEEEEEEEEEEEEEEEEWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW\x0aWWWW'
3 'ted' 23 '2024-04-04 14:33:57.069' -1
2024-04-08 19:39:22.687826 B 358 DataRow 10 5 '10203' 16 'The
Big Bad Wolf' 3 '102' 17 '978-0-316-60290-7' 10 '2003-11-17' 5 '12.50' 230
'Cross is in the middle of his training at the FBI when he is assigned to work
on a kidnapping case. A federal judge's wife has been kidnapped, and Cross
discovers that her kidnapping fits the pattern of other recent kidnappings...'
3 'ted' 23 '2024-04-05 13:51:37.577' -1
2024-04-08 19:39:22.687828 B 141 DataRow 10 5 '10102' 12
'Doctor Sleep' 3 '101' 17 '978-1-4767-2765-3' 10 '2013-09-24' 5 '12.00' 16
'weeeeeeeeeeeeeee' 4 'mike' 23 '2024-04-05 15:12:47.079' -1
2024-04-08 19:39:22.687830 B 13 CommandComplete "FETCH 12"
2024-04-08 19:39:22.687831 B 5 ReadyForQuery T
2024-04-08 19:39:22.689023 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.689074 B 274 RowDescription 10 "book_id"
25034 1 23 4 -1 0 "b_title" 25034 2 1043 65535 104 0 "b_author" 25034 3 23 4 -1
0 "b_isbn" 25034 4 1043 65535 24 0 "b_pub_date" 25034 5 1082 4 -1 0 "b_price"
25034 6 1700 65535 655366 0 "b_plot" 25034 7 1043 65535 504 0 "boo_muser" 25034
29 1043 65535 24 0 "boo_mtime" 25034 30 1114 8 3 0 "boo_mstat" 25034 31 1042
65535 5 0
2024-04-08 19:39:22.689078 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.689079 B 5 ReadyForQuery T
2024-04-08 19:39:22.689134 F 18 Query "close srv_cu1"
2024-04-08 19:39:22.689152 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.689154 B 5 ReadyForQuery T
2024-04-08 19:39:22.689190 F 19 Query "deallocate cu1"
2024-04-08 19:39:22.689207 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.689209 B 5 ReadyForQuery T
2024-04-08 19:39:22.689265 F 64 Parse "cu1" "declare srv_cu1
cursor for select book_id from book" 0
2024-04-08 19:39:22.689266 F 4 Sync
2024-04-08 19:39:22.689290 B 4 ParseComplete
2024-04-08 19:39:22.689291 B 5 ReadyForQuery T
2024-04-08 19:39:22.689292 F 17 Bind "" "cu1" 0 0 1 0
2024-04-08 19:39:22.689294 F 6 Describe P ""
2024-04-08 19:39:22.689295 F 9 Execute "" 0
2024-04-08 19:39:22.689296 F 4 Sync
2024-04-08 19:39:22.689326 B 4 BindComplete
2024-04-08 19:39:22.689327 B 4 NoData
2024-04-08 19:39:22.689328 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.689329 B 5 ReadyForQuery T
2024-04-08 19:39:22.689330 F 34 Query "fetch absolute 0 from
srv_cu1"
2024-04-08 19:39:22.689349 B 32 RowDescription 1 "book_id"
25034 1 23 4 -1 0
2024-04-08 19:39:22.689351 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.689352 B 5 ReadyForQuery T
2024-04-08 19:39:22.689370 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.689392 B 32 RowDescription 1 "book_id"
25034 1 23 4 -1 0
2024-04-08 19:39:22.689394 B 15 DataRow 1 5 '10103'
2024-04-08 19:39:22.689395 B 15 DataRow 1 5 '10202'
2024-04-08 19:39:22.689396 B 15 DataRow 1 5 '10301'
2024-04-08 19:39:22.689397 B 15 DataRow 1 5 '10304'
2024-04-08 19:39:22.689398 B 15 DataRow 1 5 '10201'
2024-04-08 19:39:22.689399 B 15 DataRow 1 5 '10302'
2024-04-08 19:39:22.689400 B 15 DataRow 1 5 '20057'
2024-04-08 19:39:22.689401 B 15 DataRow 1 5 '10101'
2024-04-08 19:39:22.689402 B 15 DataRow 1 5 '10303'
2024-04-08 19:39:22.689403 B 15 DataRow 1 5 '10104'
2024-04-08 19:39:22.689404 B 15 DataRow 1 5 '10203'
2024-04-08 19:39:22.689405 B 15 DataRow 1 5 '10102'
2024-04-08 19:39:22.689406 B 13 CommandComplete "FETCH 12"
2024-04-08 19:39:22.689407 B 5 ReadyForQuery T
2024-04-08 19:39:22.689643 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.689661 B 32 RowDescription 1 "book_id"
25034 1 23 4 -1 0
2024-04-08 19:39:22.689663 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.689664 B 5 ReadyForQuery T
2024-04-08 19:39:22.689688 F 18 Query "close srv_cu1"
2024-04-08 19:39:22.689727 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.689729 B 5 ReadyForQuery T
2024-04-08 19:39:22.689769 F 19 Query "deallocate cu1"
2024-04-08 19:39:22.689786 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.689787 B 5 ReadyForQuery T
2024-04-08 19:39:22.689841 F 66 Parse "cu1" "declare srv_cu1
cursor for select auth_id from author" 0
2024-04-08 19:39:22.689842 F 4 Sync
2024-04-08 19:39:22.689864 B 4 ParseComplete
2024-04-08 19:39:22.689866 B 5 ReadyForQuery T
2024-04-08 19:39:22.689867 F 17 Bind "" "cu1" 0 0 1 0
2024-04-08 19:39:22.689868 F 6 Describe P ""
2024-04-08 19:39:22.689869 F 9 Execute "" 0
2024-04-08 19:39:22.689870 F 4 Sync
2024-04-08 19:39:22.689898 B 4 BindComplete
2024-04-08 19:39:22.689899 B 4 NoData
2024-04-08 19:39:22.689900 B 19 CommandComplete "DECLARE
CURSOR"
2024-04-08 19:39:22.689901 B 5 ReadyForQuery T
2024-04-08 19:39:22.689903 F 34 Query "fetch absolute 0 from
srv_cu1"
2024-04-08 19:39:22.689924 B 32 RowDescription 1 "auth_id"
25027 1 23 4 -1 0
2024-04-08 19:39:22.689926 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.689927 B 5 ReadyForQuery T
2024-04-08 19:39:22.689946 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.689965 B 32 RowDescription 1 "auth_id"
25027 1 23 4 -1 0
2024-04-08 19:39:22.689967 B 13 DataRow 1 3 '100'
2024-04-08 19:39:22.689968 B 13 DataRow 1 3 '101'
2024-04-08 19:39:22.689969 B 13 DataRow 1 3 '102'
2024-04-08 19:39:22.689970 B 13 DataRow 1 3 '103'
2024-04-08 19:39:22.689971 B 12 CommandComplete "FETCH 4"
2024-04-08 19:39:22.689972 B 5 ReadyForQuery T
2024-04-08 19:39:22.690054 F 34 Query "fetch forward 50 from
srv_cu1"
2024-04-08 19:39:22.690072 B 32 RowDescription 1 "auth_id"
25027 1 23 4 -1 0
2024-04-08 19:39:22.690073 B 12 CommandComplete "FETCH 0"
2024-04-08 19:39:22.690074 B 5 ReadyForQuery T
2024-04-08 19:39:22.690099 F 18 Query "close srv_cu1"
2024-04-08 19:39:22.690115 B 17 CommandComplete "CLOSE CURSOR"
2024-04-08 19:39:22.690116 B 5 ReadyForQuery T
2024-04-08 19:39:22.690139 F 19 Query "deallocate cu1"
2024-04-08 19:39:22.690158 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.690160 B 5 ReadyForQuery T
2024-04-08 19:39:22.690199 F 115 Parse "" "update
dbsync_udsinfo SET udsi_temp_mtime = $1 WHERE udsi_user_id = $2 AND
udsi_table_name = $3" 3 1114 1043 1043
2024-04-08 19:39:22.690201 F 68 Bind "" "" 3 0 0 0 3 26
'2024-04-08 17:39:22.685000' 4 'mike' 6 'author' 1 0
2024-04-08 19:39:22.690203 F 6 Describe P ""
2024-04-08 19:39:22.690204 F 9 Execute "" 0
2024-04-08 19:39:22.690205 F 4 Sync
2024-04-08 19:39:22.690371 B 4 ParseComplete
2024-04-08 19:39:22.690372 B 4 BindComplete
2024-04-08 19:39:22.690373 B 4 NoData
2024-04-08 19:39:22.690374 B 13 CommandComplete "UPDATE 1"
2024-04-08 19:39:22.690375 B 5 ReadyForQuery T
2024-04-08 19:39:22.690429 F 115 Parse "" "update
dbsync_udsinfo SET udsi_temp_mtime = $1 WHERE udsi_user_id = $2 AND
udsi_table_name = $3" 3 1114 1043 1043
2024-04-08 19:39:22.690431 F 66 Bind "" "" 3 0 0 0 3 26
'2024-04-08 17:39:22.685000' 4 'mike' 4 'book' 1 0
2024-04-08 19:39:22.690432 F 6 Describe P ""
2024-04-08 19:39:22.690433 F 9 Execute "" 0
2024-04-08 19:39:22.690434 F 4 Sync
2024-04-08 19:39:22.690517 B 4 ParseComplete
2024-04-08 19:39:22.690518 B 4 BindComplete
2024-04-08 19:39:22.690519 B 4 NoData
2024-04-08 19:39:22.690520 B 13 CommandComplete "UPDATE 1"
2024-04-08 19:39:22.690521 B 5 ReadyForQuery T
2024-04-08 19:39:22.690548 F 19 Query "deallocate cu0"
2024-04-08 19:39:22.690568 B 15 CommandComplete "DEALLOCATE"
2024-04-08 19:39:22.690570 B 5 ReadyForQuery T
2024-04-08 19:39:22.690574 F 11 Query "commit"
2024-04-08 19:39:22.692828 B 11 CommandComplete "COMMIT"
2024-04-08 19:39:22.692839 B 5 ReadyForQuery I
2024-04-08 19:39:22.692895 F 4 Terminate
