subject:"\[ovirt\-users\] Re\: oVirt 4.1 ETL service sampling has encounterd an error"

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

2018-06-07 Thread Staniforth, Paul

Thanks Shirly,

   As we are not planning to move to 4.2 until next month I 
have applied this update, it's actually in


/usr/share/ovirt-engine-dwh/dbscripts/upgrade/


and it seems to working O.K. since yesterday.


Regards,

   Paul S.


From: Shirly Radco 
Sent: 06 June 2018 12:01
To: Staniforth, Paul
Cc: users@ovirt.org; Eli Mesika; Yedidyah Bar David
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error

In that case there is a workaround but I would recommend upgrading to 4.2 if 
you can.

I did not test the workaround:

You can add to /usr/share/ovirt-engine-dwh/packaging/dbscripts/upgrade/
a file called

04_01_0025__updated_vm_interface_history_id_to_bigint.sql

with the same content as in my patch:
_

-- Update vm_interface_* statistics table history_id to bigint

SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id', 
'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_hourly_history', 'history_id', 
'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_samples_history', 'history_id', 
'integer', 'bigint');

_

and run engine-setup

engine-setup drops all views, makes the updates to the db and recreates the 
views.


--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel<https://www.redhat.com/>

[https://www.redhat.com/files/brand/email/sig-redhat.png]<https://red.ht/sig>
TRIED. TESTED. TRUSTED.<https://redhat.com/trusted>


On Wed, Jun 6, 2018 at 1:04 PM, Staniforth, Paul 
mailto:p.stanifo...@leedsbeckett.ac.uk>> wrote:

Sorry was looking at the engine database, rather than  ovirt_engine_history 
database.


When running


SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id', 
'integer', 'bigint');


I get



ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view 
v4_1_statistics_vms_interfaces_resources_usage_daily depends on column 
"history_id"
CONTEXT:  SQL statement "ALTER TABLE vm_interface_daily_history ALTER COLUMN 
history_id TYPE bigint"
PL/pgSQL function fn_db_change_column_type(character varying,character 
varying,character varying,character varying) line 9 at EXECUTE statement


Thanks,

 Paul S.


From: Staniforth, Paul
Sent: 06 June 2018 09:57
To: Shirly Radco

Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error


Thanks Shirly,

  unfortunately Microsoft sent your reply to my Junk Email 
folder so I have only noticed it today.

Is there any instructions on how to run the script? I can't find any tables or 
views with the vm_interface_daily_history, etc  columns.


I'm not a database expert.


Regards,

   Paul S.



From: Shirly Radco mailto:sra...@redhat.com>>
Sent: 05 June 2018 14:52
To: Staniforth, Paul
Cc: users@ovirt.org<mailto:users@ovirt.org>
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error

Hi,

This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
in version 4.2.2.


I believe you can update manually the history_id field in tables  - 
vm_interface_daily_history, vm_interface_hourly_history, 
vm_interface_samples_history
from integer to bigint and it should fix the issue, but I did not test on 4.1.

like in:
https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql


Best,


--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel<https://www.redhat.com/>

[https://www.redhat.com/files/brand/email/sig-redhat.png]<https://red.ht/sig>
TRIED. TESTED. TRUSTED.<https://redhat.com/trusted>


On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul 
mailto:p.stanifo...@leedsbeckett.ac.uk>> wrote:

Hello,


our oVirt 4.1 system has had a DWH error since around 4am this morning,


It comes up with the error


ETL service sampling has encountered an error. Please consult the service log 
for more details


in the ovirt-engine-dwh.log


2018-06-05 
12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java 
Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_2Pro

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

2018-06-06 Thread Staniforth, Paul

Thanks Shirly,

  unfortunately Microsoft sent your reply to my Junk Email 
folder so I have only noticed it today.

Is there any instructions on how to run the script? I can't find any tables or 
views with the vm_interface_daily_history, etc  columns.


I'm not a database expert.


Regards,

   Paul S.



From: Shirly Radco 
Sent: 05 June 2018 14:52
To: Staniforth, Paul
Cc: users@ovirt.org
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error

Hi,

This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
in version 4.2.2.


I believe you can update manually the history_id field in tables  - 
vm_interface_daily_history, vm_interface_hourly_history, 
vm_interface_samples_history
from integer to bigint and it should fix the issue, but I did not test on 4.1.

like in:
https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql


Best,


--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel<https://www.redhat.com/>

[https://www.redhat.com/files/brand/email/sig-redhat.png]<https://red.ht/sig>
TRIED. TESTED. TRUSTED.<https://redhat.com/trusted>


On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul 
mailto:p.stanifo...@leedsbeckett.ac.uk>> wrote:

Hello,


our oVirt 4.1 system has had a DWH error since around 4am this morning,


It comes up with the error


ETL service sampling has encountered an error. Please consult the service log 
for more details


in the ovirt-engine-dwh.log


2018-06-05 
12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java 
Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4188)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3593)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2977)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2295)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11363)



and in the postgres log there is


ERROR:  integer out of range
STATEMENT:  INSERT INTO vm_interface_samples_history 
(history_datetime,vm_interface_id,receive_rate_percent,transmit_rate_percent,vm_interface_configuration_version,received_total_byte,transmitted_total_byte)
 VALUES ($1,$2,$3,$4,$5,$6,$7)
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block


Thanks,

 Paul S.

To view the terms under which this email is distributed, please go to:-
http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html

___
Users mailing list -- users@ovirt.org<mailto:users@ovirt.org>
To unsubscribe send an email to 
users-le...@ovirt.org<mailto:users-le...@ovirt.org>
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/


To view the terms under which this email is distributed, please go to:-
http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/VB36WDHZRYFLPDS4JJVJITXYCDLVG5UF/

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

2018-06-06 Thread Shirly Radco

In that case there is a workaround but I would recommend upgrading to 4.2
if you can.

I did not test the workaround:

You can add to /usr/share/ovirt-engine-dwh/packaging/dbscripts/upgrade/
a file called

04_01_0025__updated_vm_interface_history_id_to_bigint.sql

with the same content as in my patch:
_

-- Update vm_interface_* statistics table history_id to bigint

SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id',
'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_hourly_history',
'history_id', 'integer', 'bigint');
SELECT fn_db_change_column_type('vm_interface_samples_history',
'history_id', 'integer', 'bigint');

_

and run engine-setup

engine-setup drops all views, makes the updates to the db and recreates the
views.

--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel <https://www.redhat.com/>
<https://red.ht/sig>
TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>

On Wed, Jun 6, 2018 at 1:04 PM, Staniforth, Paul <
p.stanifo...@leedsbeckett.ac.uk> wrote:

> Sorry was looking at the engine database, rather than
> ovirt_engine_history database.
>
>
> When running
>
>
> SELECT fn_db_change_column_type('vm_interface_daily_history',
> 'history_id', 'integer', 'bigint');
>
>
> I get
>
>
>
> ERROR:  cannot alter type of a column used by a view or rule
> DETAIL:  rule _RETURN on view v4_1_statistics_vms_
> interfaces_resources_usage_daily depends on column "history_id"
> CONTEXT:  SQL statement "ALTER TABLE vm_interface_daily_history ALTER
> COLUMN history_id TYPE bigint"
> PL/pgSQL function fn_db_change_column_type(character varying,character
> varying,character varying,character varying) line 9 at EXECUTE statement
>
>
> Thanks,
>
>  Paul S.
> ----------
> *From:* Staniforth, Paul
> *Sent:* 06 June 2018 09:57
> *To:* Shirly Radco
>
> *Cc:* users@ovirt.org
> *Subject:* Re: [ovirt-users] oVirt 4.1 ETL service sampling has
> encounterd an error
>
>
> Thanks Shirly,
>
>   unfortunately Microsoft sent your reply to my Junk
> Email folder so I have only noticed it today.
>
> Is there any instructions on how to run the script? I can't find any
> tables or views with the vm_interface_daily_history, etc  columns.
>
>
> I'm not a database expert.
>
>
> Regards,
>
>            Paul S.
>
>
> ------
> *From:* Shirly Radco 
> *Sent:* 05 June 2018 14:52
> *To:* Staniforth, Paul
> *Cc:* users@ovirt.org
> *Subject:* Re: [ovirt-users] oVirt 4.1 ETL service sampling has
> encounterd an error
>
> Hi,
>
> This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
> in version 4.2.2.
>
>
> I believe you can update manually the history_id field in tables  -
> vm_interface_daily_history, vm_interface_hourly_history,
> vm_interface_samples_history
> from integer to bigint and it should fix the issue, but I did not test on
> 4.1.
>
> like in:
> https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/
> upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql
>
>
> Best,
>
> --
>
> SHIRLY RADCO
>
> BI SeNIOR SOFTWARE ENGINEER
>
> Red Hat Israel <https://www.redhat.com/>
> <https://red.ht/sig>
> TRIED. TESTED. TRUSTED. <https://redhat.com/trusted>
>
> On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul <
> p.stanifo...@leedsbeckett.ac.uk> wrote:
>
>> Hello,
>>
>>
>> our oVirt 4.1 system has had a DWH error since around 4am this morning,
>>
>>
>> It comes up with the error
>>
>>
>> ETL service sampling has encountered an error. Please consult the service
>> log for more details
>>
>>
>> in the ovirt-engine-dwh.log
>>
>>
>> 2018-06-05 
>> 12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
>> Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
>> Exception in component tRunJob_1
>> java.lang.RuntimeException: Child job running failed
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
>> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJ
>> ob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319)
>> at ovirt_engine_dwh.sampletimekee

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

2018-06-06 Thread Staniforth, Paul

Sorry was looking at the engine database, rather than  ovirt_engine_history 
database.


When running


SELECT fn_db_change_column_type('vm_interface_daily_history', 'history_id', 
'integer', 'bigint');


I get



ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view 
v4_1_statistics_vms_interfaces_resources_usage_daily depends on column 
"history_id"
CONTEXT:  SQL statement "ALTER TABLE vm_interface_daily_history ALTER COLUMN 
history_id TYPE bigint"
PL/pgSQL function fn_db_change_column_type(character varying,character 
varying,character varying,character varying) line 9 at EXECUTE statement


Thanks,

 Paul S.


From: Staniforth, Paul
Sent: 06 June 2018 09:57
To: Shirly Radco
Cc: users@ovirt.org
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error


Thanks Shirly,

  unfortunately Microsoft sent your reply to my Junk Email 
folder so I have only noticed it today.

Is there any instructions on how to run the script? I can't find any tables or 
views with the vm_interface_daily_history, etc  columns.


I'm not a database expert.


Regards,

   Paul S.



From: Shirly Radco 
Sent: 05 June 2018 14:52
To: Staniforth, Paul
Cc: users@ovirt.org
Subject: Re: [ovirt-users] oVirt 4.1 ETL service sampling has encounterd an 
error

Hi,

This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
in version 4.2.2.


I believe you can update manually the history_id field in tables  - 
vm_interface_daily_history, vm_interface_hourly_history, 
vm_interface_samples_history
from integer to bigint and it should fix the issue, but I did not test on 4.1.

like in:
https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql


Best,


--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel<https://www.redhat.com/>

[https://www.redhat.com/files/brand/email/sig-redhat.png]<https://red.ht/sig>
TRIED. TESTED. TRUSTED.<https://redhat.com/trusted>


On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul 
mailto:p.stanifo...@leedsbeckett.ac.uk>> wrote:

Hello,


our oVirt 4.1 system has had a DWH error since around 4am this morning,


It comes up with the error


ETL service sampling has encountered an error. Please consult the service log 
for more details


in the ovirt-engine-dwh.log


2018-06-05 
12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java 
Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
Exception in component tRunJob_1
java.lang.RuntimeException: Child job running failed
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tRowGenerator_2Process(SampleTimeKeepingJob.java:4188)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_3Process(SampleTimeKeepingJob.java:3593)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_5Process(SampleTimeKeepingJob.java:2977)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCInput_4Process(SampleTimeKeepingJob.java:2295)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649)
at 
ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11363)



and in the postgres log there is


ERROR:  integer out of range
STATEMENT:  INSERT INTO vm_interface_samples_history 
(history_datetime,vm_interface_id,receive_rate_percent,transmit_rate_percent,vm_interface_configuration_version,received_total_byte,transmitted_total_byte)
 VALUES ($1,$2,$3,$4,$5,$6,$7)
ERROR:  current transaction is aborted, commands ignored until end of 
transaction block


Thanks,

 Paul S.

To view the terms under which this email is distributed, please go to:-
http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html

___
Users mailing list -- users@ovirt.org<mailto:users@ovirt.org>
To unsubscribe send an email to 
users-le...@ovirt.org<mailto:users-le...@ovirt.org>
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/C6MLPVLJDKQ7AQLSPJ7Q

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

2018-06-05 Thread Shirly Radco

Hi,

This was fixed in https://bugzilla.redhat.com/show_bug.cgi?id=1541924
in version 4.2.2.


I believe you can update manually the history_id field in tables  -
vm_interface_daily_history, vm_interface_hourly_history,
vm_interface_samples_history
from integer to bigint and it should fix the issue, but I did not test on
4.1.

like in:
https://gerrit.ovirt.org/#/c/87139/4/packaging/dbscripts/upgrade/04_02_0020__updated_vm_interface_history_id_to_bigint.sql


Best,

--

SHIRLY RADCO

BI SeNIOR SOFTWARE ENGINEER

Red Hat Israel 

TRIED. TESTED. TRUSTED. 

On Tue, Jun 5, 2018 at 2:28 PM, Staniforth, Paul <
p.stanifo...@leedsbeckett.ac.uk> wrote:

> Hello,
>
>
> our oVirt 4.1 system has had a DWH error since around 4am this morning,
>
>
> It comes up with the error
>
>
> ETL service sampling has encountered an error. Please consult the service
> log for more details
>
>
> in the ovirt-engine-dwh.log
>
>
> 2018-06-05 
> 12:00:18|QXiOTi|gAp8Q4|Cz1F21|OVIRT_ENGINE_DWH|SampleRunJobs|Default|6|Java
> Exception|tRunJob_5|java.lang.RuntimeException:Child job running failed|1
> Exception in component tRunJob_1
> java.lang.RuntimeException: Child job running failed
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.
> SampleTimeKeepingJob.tRunJob_1Process(SampleTimeKeepingJob.java:6067)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCInput_2Process(SampleTimeKeepingJob.java:5809)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCConnection_1Process(SampleTimeKeepingJob.java:)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCConnection_2Process(SampleTimeKeepingJob.java:4319)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tRowGenerator_2Process(SampleTimeKeepingJob.java:4188)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCInput_3Process(SampleTimeKeepingJob.java:3593)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCInput_5Process(SampleTimeKeepingJob.java:2977)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCInput_4Process(SampleTimeKeepingJob.java:2295)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.SampleTimeKeepingJob.
> tJDBCConnection_3Process(SampleTimeKeepingJob.java:1649)
> at ovirt_engine_dwh.sampletimekeepingjob_4_1.
> SampleTimeKeepingJob$2.run(SampleTimeKeepingJob.java:11363)
>
>
> and in the postgres log there is
>
>
> ERROR:  integer out of range
> STATEMENT:  INSERT INTO vm_interface_samples_history (history_datetime,vm_
> interface_id,receive_rate_percent,transmit_rate_percent,
> vm_interface_configuration_version,received_total_byte,transmitted_total_byte)
> VALUES ($1,$2,$3,$4,$5,$6,$7)
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block
>
>
> Thanks,
>
>  Paul S.
> To view the terms under which this email is distributed, please go to:-
> http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html
>
>
> ___
> Users mailing list -- users@ovirt.org
> To unsubscribe send an email to users-le...@ovirt.org
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct: https://www.ovirt.org/community/about/community-
> guidelines/
> List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/
> message/C6MLPVLJDKQ7AQLSPJ7Q3QVDAAFDZWUA/
>
>
___
Users mailing list -- users@ovirt.org
To unsubscribe send an email to users-le...@ovirt.org
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct: 
https://www.ovirt.org/community/about/community-guidelines/
List Archives: 
https://lists.ovirt.org/archives/list/users@ovirt.org/message/RJDTXECMC6NWYMK7LWGL3CV4T2QGKKDU/

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

[ovirt-users] Re: oVirt 4.1 ETL service sampling has encounterd an error

5 matches

Site Navigation

Mail list logo

Footer information