pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #17192: The csvlog is corrupted 2+ messages / 2 participants [nested] [flat]
* BUG #17192: The csvlog is corrupted @ 2021-09-14 09:47 PG Bug reporting form <noreply@postgresql.org> 2021-09-15 14:41 ` RE: BUG #17192: The csvlog is corrupted Jef Vervecken <jef.vervecken@ubench.com> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2021-09-14 09:47 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: jef.vervecken@ubench.com The following bug has been logged on the website: Bug reference: 17192 Logged by: Jef Vervecken Email address: jef.vervecken@ubench.com PostgreSQL version: 13.4 Operating system: Ubuntu 18.04 Description: The content of the csvlog file seems to be corrupted. Most lines are correct but some lines seems to be merged. I'll put 3 lines here, first and third lines are correct, but the second line is corrupted. This result ofcourse in errors when I try to import the logs into a table via the copy command: line 1: 2021-09-13 13:03:17.132 CEST,"postgres","ubenchdb",5361,"10.0.10.109:50726",613f2ff5.14f1,1,"idle",2021-09-13 13:03:17 CEST,3/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" Line 2: 2021-09-13 13:03:17.193 CEST,"postgres","ubenchdb",5362,"10.0.10.109:50728",613f2ff5.14f2,1,"idle",2021-09-13 13:03:17 CEST,3/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,t: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" Line 3: 2021-09-13 13:04:09.423 CEST,"postgres","ubenchdb",32291,"10.0.10.109:33276",613f3029.7e23,1,"idle",2021-09-13 13:04:09 CEST,79/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: BUG #17192: The csvlog is corrupted 2021-09-14 09:47 BUG #17192: The csvlog is corrupted PG Bug reporting form <noreply@postgresql.org> @ 2021-09-15 14:41 ` Jef Vervecken <jef.vervecken@ubench.com> 0 siblings, 0 replies; 2+ messages in thread From: Jef Vervecken @ 2021-09-15 14:41 UTC (permalink / raw) To: Jef Vervecken <jef.vervecken@ubench.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org> I found out the problem was that 2 db instances were logging to the same file. The file seems not to be locked when 1 system is logging so they were conflicting and combining lines. So this is not a bug. Sorry for the inconvenience. -----Original Message----- From: PG Bug reporting form <noreply@postgresql.org> Sent: Tuesday, 14 September 2021 11:47 To: pgsql-bugs@lists.postgresql.org Cc: Jef Vervecken <jef.vervecken@ubench.com> Subject: BUG #17192: The csvlog is corrupted The following bug has been logged on the website: Bug reference: 17192 Logged by: Jef Vervecken Email address: jef.vervecken@ubench.com PostgreSQL version: 13.4 Operating system: Ubuntu 18.04 Description: The content of the csvlog file seems to be corrupted. Most lines are correct but some lines seems to be merged. I'll put 3 lines here, first and third lines are correct, but the second line is corrupted. This result ofcourse in errors when I try to import the logs into a table via the copy command: line 1: 2021-09-13 13:03:17.132 CEST,"postgres","ubenchdb",5361,"10.0.10.109:50726",613f2ff5.14f1,1,"idle",2021-09-13 13:03:17 CEST,3/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" Line 2: 2021-09-13 13:03:17.193 CEST,"postgres","ubenchdb",5362,"10.0.10.109:50728",613f2ff5.14f2,1,"idle",2021-09-13 13:03:17 CEST,3/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,t: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" Line 3: 2021-09-13 13:04:09.423 CEST,"postgres","ubenchdb",32291,"10.0.10.109:33276",613f3029.7e23,1,"idle",2021-09-13 13:04:09 CEST,79/0,0,LOG,08006,"could not receive data from client: Connection reset by peer",,,,,,,,,"postgres_fdw","client backend" ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-09-15 14:41 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-09-14 09:47 BUG #17192: The csvlog is corrupted PG Bug reporting form <noreply@postgresql.org> 2021-09-15 14:41 ` Jef Vervecken <jef.vervecken@ubench.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox