On Tue, Dec 22, 2015 at 10:32 AM, Gianluca Cecchi <gianluca.cecchi@gmail.com> wrote:
Hello after updating from 3.6.0 to 3.6.1 my HE environment, I'm not able to import/activate the hosted_storage domain because it results anattached


Thanks for your report Gianluca,
adding Roy here.
 
Moreover I get the popup message

Uncaught exception occurred. Please try reloading the page. Details: (TypeError) __gwt$exception: <skipped>: c is null

when I select the line of hosted_storage domain in storage tab. See:

I don't find apparently ERROR messages wen I do this, so I don't know where to watch.

On engine, where the db lives, I have under /var/lib/pgsql/data/pg_log

[root@ractorshe pg_log]# ls -lrt
total 12
-rw-------. 1 postgres postgres    0 Dec 16 01:00 postgresql-Wed.log
-rw-------. 1 postgres postgres    0 Dec 17 01:00 postgresql-Thu.log
-rw-------. 1 postgres postgres    0 Dec 18 01:00 postgresql-Fri.log
-rw-------. 1 postgres postgres 7480 Dec 20 00:39 postgresql-Sat.log
-rw-------. 1 postgres postgres 3488 Dec 20 01:29 postgresql-Sun.log
-rw-------. 1 postgres postgres    0 Dec 21 01:00 postgresql-Mon.log
-rw-------. 1 postgres postgres    0 Dec 22 01:00 postgresql-Tue.log

On Sunday logs, when the engine was started I see 

LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 1/254C6710
LOG:  record with zero length at 1/254EB6B8
LOG:  redo done at 1/254EB688
LOG:  last completed transaction was at log time 2015-12-19 23:49:47.920147+00
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
ERROR:  insert or update on table "storage_domain_dynamic" violates foreign key constraint "fk_stora
ge_domain_dynamic_storage_domain_static"
DETAIL:  Key (id)=(00000000-0000-0000-0000-000000000000) is not present in table "storage_domain_static".
CONTEXT:  SQL statement "INSERT INTO storage_domain_dynamic(available_disk_size, id, used_disk_size)
                VALUES(v_available_disk_size, v_id, v_used_disk_size)"
        PL/pgSQL function insertstorage_domain_dynamic(integer,uuid,integer) line 3 at SQL statement
STATEMENT:  select * from insertstorage_domain_dynamic($1, $2, $3) as result

and then many lines of kind

LOG:  autovacuum: found orphan temp table "pg_temp_8"."tt_temp22" in database "engine"

so messages related to domains and could be the reason of the exception and of the inability of importing/attaching my HE storage domain.

Let me know if I can provide more logs or output of queries from the database.

Gianluca



_______________________________________________
Users mailing list
Users@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users