2025-02-17 06:43:53.838 CET [5796] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 06:43:53.838 CET [5796] 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-02-17 06:44:37.209 CET [3496] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 06:44:37.209 CET [3496] 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-02-17 06:48:04.530 CET [2744] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 06:48:04.530 CET [2744] 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-02-17 06:48:44.140 CET [3572] LOG: checkpoint starting: time 2025-02-17 06:48:44.440 CET [3572] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.222 s, sync=0.020 s, total=0.300 s; sync files=2, longest=0.015 s, average=0.010 s; distance=8 kB, estimate=291209 kB; lsn=7/959D2FD8, redo lsn=7/959D2F80 2025-02-17 07:25:14.184 CET [5048] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 07:25:14.184 CET [5048] 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-02-17 07:28:44.481 CET [3572] LOG: checkpoint starting: time 2025-02-17 07:33:14.495 CET [3572] LOG: checkpoint complete: wrote 5824 buffers (35.5%); 0 WAL file(s) added, 3 removed, 0 recycled; write=269.570 s, sync=0.317 s, total=270.014 s; sync files=62, longest=0.018 s, average=0.006 s; distance=44191 kB, estimate=266507 kB; lsn=7/984FAE60, redo lsn=7/984FADD0 2025-02-17 07:58:44.547 CET [3572] LOG: checkpoint starting: time 2025-02-17 07:59:18.937 CET [3572] LOG: checkpoint complete: wrote 316 buffers (1.9%); 0 WAL file(s) added, 0 removed, 0 recycled; write=34.170 s, sync=0.176 s, total=34.391 s; sync files=34, longest=0.010 s, average=0.006 s; distance=626 kB, estimate=239919 kB; lsn=7/98597778, redo lsn=7/985976E8 2025-02-17 09:25:24.374 CET [5048] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-02-17 09:25:41.522 CET [2744] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-02-17 09:31:42.654 CET [2824] ERROR: null value in column "name" of relation "products" violates not-null constraint 2025-02-17 09:31:42.654 CET [2824] DETAIL: Failing row contains (604758, null, null, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null, null). 2025-02-17 09:31:42.654 CET [2824] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = EXCLUDED.DESCRIPTION, WAVE_TYPE = EXCLUDED.WAVE_TYPE, VOLUME = EXCLUDED.VOLUME, WEIGHT = EXCLUDED.WEIGHT, HEIGHT = EXCLUDED.HEIGHT, WIDTH = EXCLUDED.WIDTH, LENGTH = EXCLUDED.LENGTH, BOX_HEIGHT = EXCLUDED.BOX_HEIGHT, BOX_WIDTH = EXCLUDED.BOX_WIDTH, BOX_LENGTH = EXCLUDED.BOX_LENGTH, IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = EXCLUDED.PARTS_COUNT, CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:32:35.383 CET [5696] ERROR: null value in column "description" of relation "products" violates not-null constraint 2025-02-17 09:32:35.383 CET [5696] DETAIL: Failing row contains (604758, $OUD MUTS GEBREID MET BONTRAND 4 ASSORTI ACRYL 50% 2014, null, null, null, null, null, null, null, null, null, null, null, null, 0, null, null, null, null). 2025-02-17 09:32:35.383 CET [5696] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = EXCLUDED.DESCRIPTION, WAVE_TYPE = EXCLUDED.WAVE_TYPE, VOLUME = EXCLUDED.VOLUME, WEIGHT = EXCLUDED.WEIGHT, HEIGHT = EXCLUDED.HEIGHT, WIDTH = EXCLUDED.WIDTH, LENGTH = EXCLUDED.LENGTH, BOX_HEIGHT = EXCLUDED.BOX_HEIGHT, BOX_WIDTH = EXCLUDED.BOX_WIDTH, BOX_LENGTH = EXCLUDED.BOX_LENGTH, IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = EXCLUDED.PARTS_COUNT, CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:33:38.025 CET [352] ERROR: new row for relation "products" violates check constraint "products_parts_count_check" 2025-02-17 09:33:38.025 CET [352] DETAIL: Failing row contains (604758, $OUD MUTS GEBREID MET BONTRAND 4 ASSORTI ACRYL 50% 2014, , , null, null, null, null, null, null, null, null, null, null, 0, , , , ). 2025-02-17 09:33:38.025 CET [352] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = EXCLUDED.DESCRIPTION, WAVE_TYPE = EXCLUDED.WAVE_TYPE, VOLUME = EXCLUDED.VOLUME, WEIGHT = EXCLUDED.WEIGHT, HEIGHT = EXCLUDED.HEIGHT, WIDTH = EXCLUDED.WIDTH, LENGTH = EXCLUDED.LENGTH, BOX_HEIGHT = EXCLUDED.BOX_HEIGHT, BOX_WIDTH = EXCLUDED.BOX_WIDTH, BOX_LENGTH = EXCLUDED.BOX_LENGTH, IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = EXCLUDED.PARTS_COUNT, CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:35:01.948 CET [5924] ERROR: new row for relation "products" violates check constraint "products_parts_count_check" 2025-02-17 09:35:01.948 CET [5924] DETAIL: Failing row contains (604758, $OUD MUTS GEBREID MET BONTRAND 4 ASSORTI ACRYL 50% 2014, , , null, null, null, null, null, null, null, null, null, null, 0, , , , ). 2025-02-17 09:35:01.948 CET [5924] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = EXCLUDED.DESCRIPTION, WAVE_TYPE = EXCLUDED.WAVE_TYPE, VOLUME = EXCLUDED.VOLUME, WEIGHT = EXCLUDED.WEIGHT, HEIGHT = EXCLUDED.HEIGHT, WIDTH = EXCLUDED.WIDTH, LENGTH = EXCLUDED.LENGTH, BOX_HEIGHT = EXCLUDED.BOX_HEIGHT, BOX_WIDTH = EXCLUDED.BOX_WIDTH, BOX_LENGTH = EXCLUDED.BOX_LENGTH, IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = EXCLUDED.PARTS_COUNT, CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:37:29.707 CET [4332] ERROR: column "descr" does not exist at character 300 2025-02-17 09:37:29.707 CET [4332] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, @DESCR, COALESCE($3, 'BASIC'), COALESCE($4, 0), COALESCE($5, 0), COALESCE($6, 0), COALESCE($7, 0), COALESCE($8, 0), COALESCE($9, 0), COALESCE($10, 0), COALESCE($11, 0), $12, $13, COALESCE($14, 1), $15, $16, $17, $18 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = EXCLUDED.DESCRIPTION, WAVE_TYPE = COALESCE(EXCLUDED.WAVE_TYPE, 'BASIC'), VOLUME = COALESCE(EXCLUDED.VOLUME, 0), WEIGHT = COALESCE(EXCLUDED.WEIGHT, 0), HEIGHT = COALESCE(EXCLUDED.HEIGHT, 0), WIDTH = COALESCE(EXCLUDED.WIDTH, 0), LENGTH = COALESCE(EXCLUDED.LENGTH, 0), BOX_HEIGHT = COALESCE(EXCLUDED.BOX_HEIGHT, 0), BOX_WIDTH = COALESCE(EXCLUDED.BOX_WIDTH, 0), BOX_LENGTH = COALESCE(EXCLUDED.BOX_LENGTH, 0), IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = COALESCE(EXCLUDED.PARTS_COUNT, 1), CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:42:09.435 CET [1652] ERROR: new row for relation "products" violates check constraint "products_parts_count_check" 2025-02-17 09:42:09.435 CET [1652] DETAIL: Failing row contains (604758, $OUD MUTS GEBREID MET BONTRAND 4 ASSORTI ACRYL 50% 2014, , , 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, null, null, 0, , , , ). 2025-02-17 09:42:09.435 CET [1652] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, COALESCE($3, ''), COALESCE($4, 'BASIC'), COALESCE($5, 0), COALESCE($6, 0), COALESCE($7, 0), COALESCE($8, 0), COALESCE($9, 0), COALESCE($10, 0), COALESCE($11, 0), COALESCE($12, 0), $13, $14, COALESCE($15, 1), $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = COALESCE(EXCLUDED.DESCRIPTION, ''), WAVE_TYPE = COALESCE(EXCLUDED.WAVE_TYPE, 'BASIC'), VOLUME = COALESCE(EXCLUDED.VOLUME, 0), WEIGHT = COALESCE(EXCLUDED.WEIGHT, 0), HEIGHT = COALESCE(EXCLUDED.HEIGHT, 0), WIDTH = COALESCE(EXCLUDED.WIDTH, 0), LENGTH = COALESCE(EXCLUDED.LENGTH, 0), BOX_HEIGHT = COALESCE(EXCLUDED.BOX_HEIGHT, 0), BOX_WIDTH = COALESCE(EXCLUDED.BOX_WIDTH, 0), BOX_LENGTH = COALESCE(EXCLUDED.BOX_LENGTH, 0), IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = COALESCE(EXCLUDED.PARTS_COUNT, 1), CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:43:33.505 CET [1588] ERROR: null value in column "name" of relation "products" violates not-null constraint 2025-02-17 09:43:33.505 CET [1588] DETAIL: Failing row contains (ZOMER-MAANDAG, null, , , 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, null, null, 1, , , , ). 2025-02-17 09:43:33.505 CET [1588] STATEMENT: INSERT INTO products ( ARTNR, NAME, DESCRIPTION, WAVE_TYPE, VOLUME, WEIGHT, HEIGHT, WIDTH, LENGTH, BOX_HEIGHT, BOX_WIDTH, BOX_LENGTH, IRREGULAR_SHAPE, PACKED_IN_BOX, PARTS_COUNT, CATEGORY_PATH, LAST_PRODUCT_CATEGORY, URL_KEY, COLOR ) VALUES ( $1, $2, COALESCE($3, ''), COALESCE($4, 'BASIC'), COALESCE($5, 0), COALESCE($6, 0), COALESCE($7, 0), COALESCE($8, 0), COALESCE($9, 0), COALESCE($10, 0), COALESCE($11, 0), COALESCE($12, 0), $13, $14, GREATEST(COALESCE($15, 1), 1), $16, $17, $18, $19 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, DESCRIPTION = COALESCE(EXCLUDED.DESCRIPTION, ''), WAVE_TYPE = COALESCE(EXCLUDED.WAVE_TYPE, 'BASIC'), VOLUME = COALESCE(EXCLUDED.VOLUME, 0), WEIGHT = COALESCE(EXCLUDED.WEIGHT, 0), HEIGHT = COALESCE(EXCLUDED.HEIGHT, 0), WIDTH = COALESCE(EXCLUDED.WIDTH, 0), LENGTH = COALESCE(EXCLUDED.LENGTH, 0), BOX_HEIGHT = COALESCE(EXCLUDED.BOX_HEIGHT, 0), BOX_WIDTH = COALESCE(EXCLUDED.BOX_WIDTH, 0), BOX_LENGTH = COALESCE(EXCLUDED.BOX_LENGTH, 0), IRREGULAR_SHAPE = EXCLUDED.IRREGULAR_SHAPE, PACKED_IN_BOX = EXCLUDED.PACKED_IN_BOX, PARTS_COUNT = GREATEST(COALESCE(EXCLUDED.PARTS_COUNT, 1), 1), CATEGORY_PATH = EXCLUDED.CATEGORY_PATH, LAST_PRODUCT_CATEGORY = EXCLUDED.LAST_PRODUCT_CATEGORY, URL_KEY = EXCLUDED.URL_KEY, COLOR = EXCLUDED.COLOR 2025-02-17 09:43:45.025 CET [3572] LOG: checkpoint starting: time 2025-02-17 09:43:54.677 CET [3572] LOG: checkpoint complete: wrote 91 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.537 s, sync=0.064 s, total=9.653 s; sync files=12, longest=0.011 s, average=0.006 s; distance=1378 kB, estimate=216065 kB; lsn=7/986F7F28, redo lsn=7/986F01C8 2025-02-17 09:46:39.361 CET [5680] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 09:46:39.361 CET [5680] 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-02-17 09:46:40.005 CET [3560] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 09:46:40.005 CET [3560] 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-02-17 09:48:45.679 CET [3572] LOG: checkpoint starting: time 2025-02-17 09:51:34.242 CET [3572] LOG: checkpoint complete: wrote 1575 buffers (9.6%); 0 WAL file(s) added, 2 removed, 0 recycled; write=168.298 s, sync=0.134 s, total=168.564 s; sync files=19, longest=0.012 s, average=0.008 s; distance=29507 kB, estimate=197409 kB; lsn=7/9B9D4028, redo lsn=7/9A3C1098 2025-02-17 09:53:45.248 CET [3572] LOG: checkpoint starting: time 2025-02-17 09:57:33.174 CET [3572] LOG: checkpoint complete: wrote 2110 buffers (12.9%); 0 WAL file(s) added, 2 removed, 0 recycled; write=227.758 s, sync=0.083 s, total=227.927 s; sync files=15, longest=0.010 s, average=0.006 s; distance=31750 kB, estimate=180843 kB; lsn=7/9C2CE238, redo lsn=7/9C2C2A90 2025-02-17 10:10:06.937 CET [2844] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 10:10:06.937 CET [2844] 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-02-17 10:13:45.194 CET [3572] LOG: checkpoint starting: time 2025-02-17 10:13:53.888 CET [3572] LOG: checkpoint complete: wrote 78 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.397 s, sync=0.250 s, total=8.695 s; sync files=49, longest=0.014 s, average=0.006 s; distance=444 kB, estimate=162803 kB; lsn=7/9C331EC8, redo lsn=7/9C331E38 2025-02-17 11:10:38.732 CET [5548] ERROR: column "locus_su_volume" of relation "products" does not exist at character 222 2025-02-17 11:10:38.732 CET [5548] STATEMENT: INSERT INTO products ( ARTNR, NAME, LOCUS_SU_QUANTITY, LOCUS_SU_WEIGHT_GROSS, LOCUS_SU_WEIGHT_NET, LOCUS_SU_LENGTH, LOCUS_SU_HEIGHT, LOCUS_SU_WIDTH, LOCUS_SU_VOLUME, LOCUS_PU_QUANTITY, LOCUS_PU_WEIGHT_GROSS, LOCUS_PU_WEIGHT_NET, LOCUS_PU_LENGTH, LOCUS_PU_HEIGHT, LOCUS_PU_WIDTH, LOCUS_PU_VOLUME, LOCUS_HN_QUANTITY, LOCUS_HN_WEIGHT_GROSS, LOCUS_HN_WEIGHT_NET, LOCUS_HN_LENGTH, LOCUS_HN_HEIGHT, LOCUS_HN_WIDTH, LOCUS_HN_VOLUME ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, LOCUS_SU_QUANTITY = EXCLUDED.LOCUS_SU_QUANTITY, LOCUS_SU_WEIGHT_GROSS = EXCLUDED.LOCUS_SU_WEIGHT_GROSS, LOCUS_SU_WEIGHT_NET = EXCLUDED.LOCUS_SU_WEIGHT_NET, LOCUS_SU_LENGTH = EXCLUDED.LOCUS_SU_LENGTH, LOCUS_SU_HEIGHT = EXCLUDED.LOCUS_SU_HEIGHT, LOCUS_SU_WIDTH = EXCLUDED.LOCUS_SU_WIDTH, LOCUS_SU_VOLUME = EXCLUDED.LOCUS_SU_VOLUME, LOCUS_PU_QUANTITY = EXCLUDED.LOCUS_PU_QUANTITY, LOCUS_PU_WEIGHT_GROSS = EXCLUDED.LOCUS_PU_WEIGHT_GROSS, LOCUS_PU_WEIGHT_NET = EXCLUDED.LOCUS_PU_WEIGHT_NET, LOCUS_PU_LENGTH = EXCLUDED.LOCUS_PU_LENGTH, LOCUS_PU_HEIGHT = EXCLUDED.LOCUS_PU_HEIGHT, LOCUS_PU_WIDTH = EXCLUDED.LOCUS_PU_WIDTH, LOCUS_PU_VOLUME = EXCLUDED.LOCUS_PU_VOLUME, LOCUS_HN_QUANTITY = EXCLUDED.LOCUS_HN_QUANTITY, LOCUS_HN_WEIGHT_GROSS = EXCLUDED.LOCUS_HN_WEIGHT_GROSS, LOCUS_HN_WEIGHT_NET = EXCLUDED.LOCUS_HN_WEIGHT_NET, LOCUS_HN_LENGTH = EXCLUDED.LOCUS_HN_LENGTH, LOCUS_HN_HEIGHT = EXCLUDED.LOCUS_HN_HEIGHT, LOCUS_HN_WIDTH = EXCLUDED.LOCUS_HN_WIDTH, LOCUS_HN_VOLUME = EXCLUDED.LOCUS_HN_VOLUME 2025-02-17 11:48:28.889 CET [3208] ERROR: syntax error at end of input at character 2192 2025-02-17 11:48:28.889 CET [3208] STATEMENT: INSERT INTO products ( ARTNR, NAME, LOCUS_SU_QUANTITY, LOCUS_SU_WEIGHT_GROSS, LOCUS_SU_WEIGHT_NET, LOCUS_SU_LENGTH, LOCUS_SU_HEIGHT, LOCUS_SU_WIDTH, LOCUS_PU_QUANTITY, LOCUS_PU_WEIGHT_GROSS, LOCUS_PU_WEIGHT_NET, LOCUS_PU_LENGTH, LOCUS_PU_HEIGHT, LOCUS_PU_WIDTH, LOCUS_HN_QUANTITY, LOCUS_HN_WEIGHT_GROSS, LOCUS_HN_WEIGHT_NET, LOCUS_HN_LENGTH, LOCUS_HN_HEIGHT, LOCUS_HN_WIDTH ) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20 ) ON CONFLICT (ARTNR) DO UPDATE SET NAME = EXCLUDED.NAME, LOCUS_SU_QUANTITY = EXCLUDED.LOCUS_SU_QUANTITY, LOCUS_SU_WEIGHT_GROSS = EXCLUDED.LOCUS_SU_WEIGHT_GROSS, LOCUS_SU_WEIGHT_NET = EXCLUDED.LOCUS_SU_WEIGHT_NET, LOCUS_SU_LENGTH = EXCLUDED.LOCUS_SU_LENGTH, LOCUS_SU_HEIGHT = EXCLUDED.LOCUS_SU_HEIGHT, LOCUS_SU_WIDTH = EXCLUDED.LOCUS_SU_WIDTH, LOCUS_PU_QUANTITY = EXCLUDED.LOCUS_PU_QUANTITY, LOCUS_PU_WEIGHT_GROSS = EXCLUDED.LOCUS_PU_WEIGHT_GROSS, LOCUS_PU_WEIGHT_NET = EXCLUDED.LOCUS_PU_WEIGHT_NET, LOCUS_PU_LENGTH = EXCLUDED.LOCUS_PU_LENGTH, LOCUS_PU_HEIGHT = EXCLUDED.LOCUS_PU_HEIGHT, LOCUS_PU_WIDTH = EXCLUDED.LOCUS_PU_WIDTH, LOCUS_HN_QUANTITY = EXCLUDED.LOCUS_HN_QUANTITY, LOCUS_HN_WEIGHT_GROSS = EXCLUDED.LOCUS_HN_WEIGHT_GROSS, LOCUS_HN_WEIGHT_NET = EXCLUDED.LOCUS_HN_WEIGHT_NET, LOCUS_HN_LENGTH = EXCLUDED.LOCUS_HN_LENGTH, LOCUS_HN_HEIGHT = EXCLUDED.LOCUS_HN_HEIGHT, LOCUS_HN_WIDTH = EXCLUDED.LOCUS_HN_WIDTH, 2025-02-17 12:53:37.833 CET [2736] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-02-17 12:53:37.833 CET [2736] 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-02-17 13:22:50.515 CET [5680] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-02-17 13:22:55.141 CET [3560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-02-17 14:53:47.969 CET [2736] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.