View Issue Details

IDProjectCategoryView StatusLast Update
0001236bareos-core[All Projects] directorpublic2020-04-28 16:24
ReporterhostedpowerAssigned Toarogge 
PrioritynormalSeverityminorReproducibilitysometimes
Status assignedResolutionopen 
PlatformLinuxOSDebianOS Version10
Product Version19.2.7 
Fixed in Version 
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.
bareos-master: impact
bareos-master: action
bareos-19.2: impact
bareos-19.2: action
bareos-18.2: impact
bareos-18.2: action
bareos-17.2: impact
bareos-17.2: action
bareos-16.2: impact
bareos-16.2: action
bareos-15.2: impact
bareos-15.2: action
bareos-14.2: impact
bareos-14.2: action
bareos-13.2: impact
bareos-13.2: action
bareos-12.4: impact
bareos-12.4: action

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

developer   ~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 :)

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