2025-11-16 00:23:30.985 CET [6960] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 00:24:55.156 CET [5340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 00:30:16.508 CET [2732] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 01:14:45.158 CET [7136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 01:14:45.303 CET [6468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 02:11:06.093 CET [3796] ERROR: column "jobid" does not exist at character 48 2025-11-16 02:11:06.093 CET [3796] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.job_id". 2025-11-16 02:11:06.093 CET [3796] STATEMENT: SELECT * FROM sonex.shipbk_print_jobs ORDER BY jobid ASC, seq ASC 2025-11-16 02:12:01.154 CET [5716] LOG: checkpoint starting: time 2025-11-16 02:12:02.787 CET [5716] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.533 s, sync=0.050 s, total=1.633 s; sync files=6, longest=0.015 s, average=0.009 s; distance=71 kB, estimate=189 kB; lsn=7/A95D2D18, redo lsn=7/A95D2CC0 2025-11-16 02:12:22.911 CET [5696] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 02:12:22.911 CET [5696] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 02:12:22.925 CET [3956] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 02:12:22.925 CET [3956] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 02:12:24.520 CET [3980] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 02:12:24.520 CET [3980] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 02:17:01.795 CET [5716] LOG: checkpoint starting: time 2025-11-16 02:17:02.849 CET [5716] LOG: checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.974 s, sync=0.029 s, total=1.054 s; sync files=4, longest=0.015 s, average=0.008 s; distance=6 kB, estimate=170 kB; lsn=7/A95D47A8, redo lsn=7/A95D4750 2025-11-16 04:12:34.745 CET [3956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 04:12:34.916 CET [3980] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 13:49:15.205 CET [4576] ERROR: column "jobid" does not exist at character 48 2025-11-16 13:49:15.205 CET [4576] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.job_id". 2025-11-16 13:49:15.205 CET [4576] STATEMENT: SELECT * FROM sonex.shipbk_print_jobs ORDER BY jobid ASC, seq ASC 2025-11-16 13:49:31.768 CET [4576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 13:49:31.769 CET [3660] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 13:52:13.504 CET [6364] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 13:52:13.504 CET [6364] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 13:52:15.312 CET [5488] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 13:52:15.312 CET [5488] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 13:52:56.428 CET [3324] ERROR: column "jobid" does not exist at character 48 2025-11-16 13:52:56.428 CET [3324] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.job_id". 2025-11-16 13:52:56.428 CET [3324] STATEMENT: SELECT * FROM sonex.shipbk_print_jobs ORDER BY jobid ASC, seq ASC 2025-11-16 13:55:07.070 CET [3324] ERROR: column "jobid" does not exist at character 48 2025-11-16 13:55:07.070 CET [3324] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.job_id". 2025-11-16 13:55:07.070 CET [3324] STATEMENT: SELECT * FROM sonex.shipbk_print_jobs ORDER BY jobid ASC, seq ASC 2025-11-16 13:56:06.670 CET [3324] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 13:56:06.670 CET [5192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 14:01:22.707 CET [7092] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 14:01:22.708 CET [3736] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 14:02:02.436 CET [5716] LOG: checkpoint starting: time 2025-11-16 14:02:03.284 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.758 s, sync=0.036 s, total=0.848 s; sync files=5, longest=0.017 s, average=0.008 s; distance=13 kB, estimate=155 kB; lsn=7/A95D7F90, redo lsn=7/A95D7F00 2025-11-16 14:55:42.680 CET [5044] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 14:56:17.524 CET [1056] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 14:56:17.524 CET [1056] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 14:56:17.547 CET [2584] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 14:56:17.547 CET [2584] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:32:59.897 CET [1980] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:32:59.897 CET [1980] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:35:55.497 CET [1980] ERROR: relation "recip" does not exist at character 24 2025-11-16 15:35:55.497 CET [1980] STATEMENT: Select email, tel from recip where code LIKE replace('BK817520673R1', 'BK', '') 2025-11-16 15:37:52.844 CET [3584] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:37:52.844 CET [3584] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:37:53.298 CET [6916] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:37:53.298 CET [6916] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:37:53.410 CET [6916] ERROR: relation "shipbk_package_size" already exists 2025-11-16 15:37:53.410 CET [6916] STATEMENT: CREATE TABLE sonex.shipbk_package_size ( article_number TEXT NOT NULL, part_number INTEGER NOT NULL, width INTEGER, height INTEGER, length INTEGER, weight INTEGER, part_name TEXT, PRIMARY KEY (article_number, part_number) ); -- dodatkowy index niepotrzebny, PK już tworzy indeks 2025-11-16 15:38:05.041 CET [2980] WARNING: PID 2732 is not a PostgreSQL backend process 2025-11-16 15:38:10.273 CET [7024] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:38:10.273 CET [7024] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:40:24.484 CET [2864] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:40:24.484 CET [2864] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:40:52.124 CET [6792] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 15:40:52.124 CET [6792] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 15:42:02.357 CET [5716] LOG: checkpoint starting: time 2025-11-16 15:42:09.683 CET [5716] LOG: checkpoint complete: wrote 66 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.098 s, sync=0.176 s, total=7.326 s; sync files=31, longest=0.014 s, average=0.006 s; distance=371 kB, estimate=371 kB; lsn=7/A9634CC8, redo lsn=7/A9634C70 2025-11-16 15:47:02.693 CET [5716] LOG: checkpoint starting: time 2025-11-16 15:47:03.888 CET [5716] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.088 s, sync=0.058 s, total=1.195 s; sync files=10, longest=0.008 s, average=0.006 s; distance=31 kB, estimate=337 kB; lsn=7/A963C958, redo lsn=7/A963C900 2025-11-16 15:52:02.874 CET [5716] LOG: checkpoint starting: time 2025-11-16 15:52:04.109 CET [5716] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.111 s, sync=0.078 s, total=1.235 s; sync files=9, longest=0.018 s, average=0.009 s; distance=43 kB, estimate=307 kB; lsn=7/A9647640, redo lsn=7/A96475E8 2025-11-16 15:52:25.509 CET [6364] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 15:52:25.667 CET [5488] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 15:53:30.647 CET [584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 16:28:24.413 CET [404] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 16:43:52.282 CET [460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 16:59:46.384 CET [2576] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 16:59:46.384 CET [2576] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 17:00:19.283 CET [6504] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 17:00:19.283 CET [6504] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 17:00:38.920 CET [420] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 17:00:38.920 CET [420] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 17:02:02.169 CET [5716] LOG: checkpoint starting: time 2025-11-16 17:02:11.215 CET [5716] LOG: checkpoint complete: wrote 82 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.830 s, sync=0.172 s, total=9.047 s; sync files=35, longest=0.007 s, average=0.005 s; distance=476 kB, estimate=476 kB; lsn=7/A96BE828, redo lsn=7/A96BE798 2025-11-16 17:29:49.930 CET [2904] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:29:49.931 CET [6540] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:32:02.238 CET [5716] LOG: checkpoint starting: time 2025-11-16 17:32:03.727 CET [5716] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.421 s, sync=0.023 s, total=1.490 s; sync files=2, longest=0.018 s, average=0.012 s; distance=52 kB, estimate=433 kB; lsn=7/A96CB8A8, redo lsn=7/A96CB850 2025-11-16 17:32:57.908 CET [5192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:32:57.909 CET [576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:41:05.190 CET [6792] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:42:03.798 CET [3584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:47:58.825 CET [2864] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 17:52:02.742 CET [5716] LOG: checkpoint starting: time 2025-11-16 17:52:03.485 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.042 s, total=0.743 s; sync files=6, longest=0.010 s, average=0.007 s; distance=29 kB, estimate=393 kB; lsn=7/A96D3088, redo lsn=7/A96D3030 2025-11-16 17:56:46.721 CET [2584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:00:31.291 CET [2928] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:02:02.481 CET [5716] LOG: checkpoint starting: time 2025-11-16 18:02:05.640 CET [5716] LOG: checkpoint complete: wrote 29 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.053 s, sync=0.062 s, total=3.159 s; sync files=11, longest=0.012 s, average=0.006 s; distance=147 kB, estimate=368 kB; lsn=7/A96F7E30, redo lsn=7/A96F7DA0 2025-11-16 18:17:01.553 CET [5188] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:17:01.553 CET [5188] FATAL: connection to client lost 2025-11-16 18:17:02.655 CET [5716] LOG: checkpoint starting: time 2025-11-16 18:17:05.170 CET [5716] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.402 s, sync=0.064 s, total=2.515 s; sync files=8, longest=0.014 s, average=0.008 s; distance=87 kB, estimate=340 kB; lsn=7/A970DC58, redo lsn=7/A970DBC8 2025-11-16 18:17:59.756 CET [1020] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 18:17:59.756 CET [1020] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 18:18:26.858 CET [5848] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:18:26.859 CET [6996] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:22:02.154 CET [5716] LOG: checkpoint starting: time 2025-11-16 18:22:03.010 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.776 s, sync=0.036 s, total=0.857 s; sync files=5, longest=0.012 s, average=0.008 s; distance=27 kB, estimate=309 kB; lsn=7/A9714A40, redo lsn=7/A97149E8 2025-11-16 18:31:17.445 CET [3108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:31:17.446 CET [5192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 18:32:02.012 CET [5716] LOG: checkpoint starting: time 2025-11-16 18:32:07.531 CET [5716] LOG: checkpoint complete: wrote 48 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.103 s, sync=0.107 s, total=5.519 s; sync files=16, longest=0.020 s, average=0.007 s; distance=283 kB, estimate=306 kB; lsn=7/A975BA20, redo lsn=7/A975B990 2025-11-16 18:36:10.986 CET [4396] ERROR: function sonex.app_import_shipbk_print_jobs_from_locus() does not exist at character 8 2025-11-16 18:36:10.986 CET [4396] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2025-11-16 18:36:10.986 CET [4396] STATEMENT: SELECT sonex.app_import_shipbk_print_jobs_from_locus() 2025-11-16 18:37:02.541 CET [5716] LOG: checkpoint starting: time 2025-11-16 18:37:04.467 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.853 s, sync=0.029 s, total=1.927 s; sync files=4, longest=0.009 s, average=0.008 s; distance=43 kB, estimate=280 kB; lsn=7/A9766690, redo lsn=7/A9766638 2025-11-16 19:00:49.075 CET [420] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 19:05:02.493 CET [5868] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:02:10.598 CET [3672] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:08:04.788 CET [6488] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 20:08:04.788 CET [6488] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 20:19:54.790 CET [2244] ERROR: column "conumber" does not exist at character 395 2025-11-16 20:19:54.790 CET [2244] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.co_number". 2025-11-16 20:19:54.790 CET [2244] STATEMENT: UPDATE sonex.shipbk_print_jobs SET recipient_name = $1, recipient_street = $2, recipient_house_nr = $3, recipient_town = $4, recipient_zip_code = $5, recipient_country = $6, recipient_att = $7, recipient_tel = $8, recipient_email = $9, load_time = $10, un_load_time = $11, notes = $12 WHERE conumber = $13 2025-11-16 20:20:36.876 CET [7156] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 20:20:36.876 CET [7156] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 20:22:07.070 CET [6880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:23:03.446 CET [5956] ERROR: column "conumber" does not exist at character 227 2025-11-16 20:23:03.446 CET [5956] HINT: Perhaps you meant to reference the column "shipbk_print_jobs.co_number". 2025-11-16 20:23:03.446 CET [5956] STATEMENT: UPDATE sonex.shipbk_print_jobs SET height = $1, width = $2, length = $3, weight = $4, volume = $5, description = $6, status = $7 WHERE job_id = $8 AND conumber = $9 2025-11-16 20:23:38.668 CET [6364] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:23:38.669 CET [5956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:25:54.224 CET [5612] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:25:54.225 CET [5516] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:27:02.546 CET [5716] LOG: checkpoint starting: time 2025-11-16 20:27:02.828 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.216 s, sync=0.016 s, total=0.282 s; sync files=3, longest=0.008 s, average=0.006 s; distance=7 kB, estimate=253 kB; lsn=7/A9768330, redo lsn=7/A97682D8 2025-11-16 20:27:49.174 CET [2576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:30:16.084 CET [6504] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:32:02.832 CET [5716] LOG: checkpoint starting: time 2025-11-16 20:32:03.686 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.761 s, sync=0.038 s, total=0.854 s; sync files=6, longest=0.009 s, average=0.007 s; distance=45 kB, estimate=232 kB; lsn=7/A97737B0, redo lsn=7/A9773758 2025-11-16 20:33:47.056 CET [5948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:48:26.083 CET [1020] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 20:51:49.521 CET [6444] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 20:51:49.521 CET [6444] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 20:52:02.690 CET [5716] LOG: checkpoint starting: time 2025-11-16 20:52:02.966 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.212 s, sync=0.018 s, total=0.276 s; sync files=2, longest=0.011 s, average=0.009 s; distance=11 kB, estimate=210 kB; lsn=7/A9776658, redo lsn=7/A9776600 2025-11-16 20:57:20.583 CET [1572] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 20:57:20.583 CET [1572] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 20:59:53.227 CET [5188] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 20:59:53.227 CET [5188] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 20:59:58.466 CET [3988] WARNING: PID 1020 is not a PostgreSQL backend process 2025-11-16 21:02:02.964 CET [5716] LOG: checkpoint starting: time 2025-11-16 21:02:07.595 CET [5716] LOG: checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.474 s, sync=0.110 s, total=4.632 s; sync files=16, longest=0.013 s, average=0.007 s; distance=181 kB, estimate=207 kB; lsn=7/A97A3DE0, redo lsn=7/A97A3D88 2025-11-16 21:07:02.594 CET [5716] LOG: checkpoint starting: time 2025-11-16 21:07:05.091 CET [5716] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.392 s, sync=0.052 s, total=2.498 s; sync files=7, longest=0.014 s, average=0.008 s; distance=67 kB, estimate=193 kB; lsn=7/A97B4D98, redo lsn=7/A97B4D40 2025-11-16 21:55:57.991 CET [2792] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-16 21:55:57.991 CET [2792] FATAL: connection to client lost 2025-11-16 22:00:32.132 CET [5064] ERROR: column "articlenumber" does not exist at character 56 2025-11-16 22:00:32.132 CET [5064] HINT: Perhaps you meant to reference the column "shipbk_package_size.article_number". 2025-11-16 22:00:32.132 CET [5064] STATEMENT: SELECT * FROM sonex.sonex.shipbk_package_size ORDER BY ArticleNumber ASC, PartNumber ASC 2025-11-16 22:00:41.011 CET [5064] ERROR: column "articlenumber" does not exist at character 56 2025-11-16 22:00:41.011 CET [5064] HINT: Perhaps you meant to reference the column "shipbk_package_size.article_number". 2025-11-16 22:00:41.011 CET [5064] STATEMENT: SELECT * FROM sonex.sonex.shipbk_package_size ORDER BY ArticleNumber ASC, PartNumber ASC 2025-11-16 22:01:30.810 CET [5064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:01:30.811 CET [5632] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:07:02.129 CET [5716] LOG: checkpoint starting: time 2025-11-16 22:07:02.875 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.648 s, sync=0.045 s, total=0.746 s; sync files=6, longest=0.012 s, average=0.008 s; distance=24 kB, estimate=176 kB; lsn=7/A97BADE8, redo lsn=7/A97BAD90 2025-11-16 22:07:26.234 CET [5164] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:10:57.083 CET [3988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:10:57.084 CET [5248] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:12:02.861 CET [5716] LOG: checkpoint starting: time 2025-11-16 22:12:03.133 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.009 s, total=0.273 s; sync files=1, longest=0.009 s, average=0.009 s; distance=8 kB, estimate=159 kB; lsn=7/A97BCF00, redo lsn=7/A97BCEA8 2025-11-16 22:13:16.654 CET [1100] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 22:13:16.654 CET [1100] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 22:13:42.618 CET [5856] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 22:13:42.618 CET [5856] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 22:30:22.467 CET [1220] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:47:02.147 CET [5716] LOG: checkpoint starting: time 2025-11-16 22:47:02.913 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.650 s, sync=0.069 s, total=0.766 s; sync files=7, longest=0.019 s, average=0.010 s; distance=15 kB, estimate=145 kB; lsn=7/A97C0E48, redo lsn=7/A97C0DF0 2025-11-16 22:47:24.616 CET [696] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:47:24.617 CET [1028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:52:02.908 CET [5716] LOG: checkpoint starting: time 2025-11-16 22:52:03.630 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.640 s, sync=0.029 s, total=0.723 s; sync files=5, longest=0.009 s, average=0.006 s; distance=24 kB, estimate=133 kB; lsn=7/A97C70D8, redo lsn=7/A97C7080 2025-11-16 22:52:18.973 CET [4016] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:54:23.688 CET [7036] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-16 22:54:23.688 CET [7036] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-16 22:55:42.106 CET [7036] ERROR: cannot drop table sonex.shipbk_package_size because other objects depend on it 2025-11-16 22:55:42.106 CET [7036] DETAIL: view sonex.v_shipbk_source depends on table sonex.shipbk_package_size 2025-11-16 22:55:42.106 CET [7036] HINT: Use DROP ... CASCADE to drop the dependent objects too. 2025-11-16 22:55:42.106 CET [7036] STATEMENT: -- Table: sonex.shipbk_package_size DROP TABLE IF EXISTS sonex.shipbk_package_size; CREATE TABLE sonex.shipbk_package_size ( id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY, article_number text NOT NULL, part_number integer NOT NULL, width integer, height integer, length integer, weight integer, part_name text, CONSTRAINT shipbk_package_size_uq UNIQUE (article_number, part_number) ) TABLESPACE pg_default; ALTER TABLE sonex.shipbk_package_size OWNER TO postgres; REVOKE ALL ON TABLE sonex.shipbk_package_size FROM sonex; GRANT ALL ON TABLE sonex.shipbk_package_size TO postgres; GRANT INSERT, DELETE, SELECT, UPDATE ON TABLE sonex.shipbk_package_size TO sonex; 2025-11-16 22:57:02.616 CET [5716] LOG: checkpoint starting: time 2025-11-16 22:57:03.601 CET [5716] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.879 s, sync=0.055 s, total=0.985 s; sync files=9, longest=0.012 s, average=0.007 s; distance=20 kB, estimate=121 kB; lsn=7/A97CC128, redo lsn=7/A97CC0D0 2025-11-16 22:59:20.236 CET [6444] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 22:59:50.745 CET [1572] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:00:03.362 CET [5188] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:00:13.256 CET [6488] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:00:18.444 CET [7156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:02:02.601 CET [5716] LOG: checkpoint starting: time 2025-11-16 23:02:08.406 CET [5716] LOG: checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.557 s, sync=0.202 s, total=5.806 s; sync files=38, longest=0.012 s, average=0.006 s; distance=222 kB, estimate=222 kB; lsn=7/A9803CA8, redo lsn=7/A9803C18 2025-11-16 23:03:03.235 CET [4692] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:03:03.995 CET [2472] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:03:03.995 CET [2472] FATAL: connection to client lost 2025-11-16 23:07:02.397 CET [5716] LOG: checkpoint starting: time 2025-11-16 23:07:02.681 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.209 s, sync=0.026 s, total=0.284 s; sync files=3, longest=0.011 s, average=0.009 s; distance=1 kB, estimate=200 kB; lsn=7/A9804138, redo lsn=7/A98040E0 2025-11-16 23:07:59.803 CET [5516] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:07:59.804 CET [6832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-16 23:09:02.388 CET [3308] ERROR: duplicate key value violates unique constraint "shipbk_package_size_article_part_uq" 2025-11-16 23:09:02.388 CET [3308] DETAIL: Key (article_number, part_number)=(123123, 1) already exists. 2025-11-16 23:09:02.388 CET [3308] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number, part_number, width, height, length, weight, part_name) VALUES ($1, $2, $3, $4, $5, $6, $7) 2025-11-16 23:09:38.500 CET [3308] ERROR: duplicate key value violates unique constraint "shipbk_package_size_article_part_uq" 2025-11-16 23:09:38.500 CET [3308] DETAIL: Key (article_number, part_number)=(213, 1) already exists. 2025-11-16 23:09:38.500 CET [3308] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number, part_number, width, height, length, weight, part_name) VALUES ($1, $2, $3, $4, $5, $6, $7) 2025-11-16 23:12:02.680 CET [5716] LOG: checkpoint starting: time 2025-11-16 23:12:03.191 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.435 s, sync=0.031 s, total=0.512 s; sync files=5, longest=0.009 s, average=0.007 s; distance=3 kB, estimate=180 kB; lsn=7/A98050C0, redo lsn=7/A9805068 2025-11-16 23:24:19.986 CET [5432] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.