View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001236bareos-coredirectorpublic2020-04-27 09:402024-05-15 15:44
Reporterhostedpower Assigned Toarogge  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionsuspended 
PlatformLinuxOSDebianOS Version10
Product Version19.2.7 
Summary0001236: COPY from stdin failed: COPY terminated by new PQexec
DescriptionThis query seems to take several minutes sometimes: COPY batch FROM STDIN

We get alerts in our monitoring about this long running query. Now we checked the logs and also see related errors: COPY from stdin failed: COPY terminated by new PQexec

Is this a bug , something that needs finetuning or can it safely be ignored?
TagsNo tags attached.

Activities

hostedpower

hostedpower

2020-04-28 10:13

reporter   ~0003967

We see even values like over 38min atm for this query: longest query: 2311s (38 minutes 31 seconds)
arogge

arogge

2020-04-28 11:32

manager   ~0003968

This happens when your PostgreSQL installation is slow on inserting. Did you tune your PostgreSQL installation? Take a look at https://pgtune.leopard.in.ua/ with "Data warehouse" for a good starting point.
The PostgreSQL default configuration (just like with MySQL) is not optimized to work with production workloads.
hostedpower

hostedpower

2020-04-28 16:24

reporter   ~0003970

we used that and configured quite some settings already :)
hostedpower

hostedpower

2020-12-17 20:47

reporter   ~0004072

This seems to happen still
arogge

arogge

2024-05-15 15:44

manager   ~0005940

This was reported for an end-of-life (EOL) version of Bareos.

If you can reproduce this bug against a currently maintained version of
Bareos please feel free to open a new issue against that version at
https://github.com/bareos/bareos/issues

Thank you for reporting this bug and we are sorry it could not be fixed.

Issue History

Date Modified Username Field Change
2020-04-27 09:40 hostedpower New Issue
2020-04-28 10:13 hostedpower Note Added: 0003967
2020-04-28 11:32 arogge Note Added: 0003968
2020-04-28 11:33 arogge Assigned To => arogge
2020-04-28 11:33 arogge Status new => feedback
2020-04-28 16:24 hostedpower Note Added: 0003970
2020-04-28 16:24 hostedpower Status feedback => assigned
2020-12-17 20:47 hostedpower Note Added: 0004072
2024-05-15 15:44 arogge Status assigned => closed
2024-05-15 15:44 arogge Resolution open => suspended
2024-05-15 15:44 arogge Note Added: 0005940