View Issue Details

IDProjectCategoryView StatusLast Update
0001236bareos-coredirectorpublic2020-12-17 20:47
Reporterhostedpower Assigned Toarogge  
PrioritynormalSeverityminorReproducibilitysometimes
Status assignedResolutionopen 
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

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