Article ID: 117049, created on Sep 1, 2013, last review on Sep 1, 2013

Symptoms

No server aliases shows in CP

In logs:

2013-09-01 22:35:28,132 [TP-Processor8] DEBUG psoft.hsphere.CP - Exception in Resource.get: 1121_3020   
java.lang.reflect.InvocationTargetException 
         at sun.reflect.GeneratedConstructorAccessor77.newInstance(Unknown Source) 
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 
         at java.lang.reflect.Constructor.newInstance(Constructor.java:525)  
         at psoft.hsphere.Resource.get(Resource.java:1499)  
         at psoft.hsphere.ResourceId.get(ResourceId.java:109)  
         at psoft.hsphere.ResourceId.get(ResourceId.java:230)  
         at freemarker.template.expression.Dot.getAsTemplateModel(Unknown Source)  
         at freemarker.template.instruction.AssignInstruction.process(Unknown Source)  
         at freemarker.template.compiler.TemplateArrayList.process(Unknown Source)  
         at freemarker.template.instruction.IfInstruction.process(Unknown Source)  
         at freemarker.template.compiler.TemplateArrayList.process(Unknown Source)  

Cause

Missing record in DB

Resolution

1) Use the following command to log psql query:
tcpdump -l -i lo -s0 -w - host 127.0.0.1 | strings

2)GoTo E.Manager-> Server Aliases

3) Note the latest query in log.

For example:

SELECT d.data, d.name, e.zone_id, d.type, d.ttl, d.pref, l.l_server_id  FROM e_dns_records e, dns_records d, l_server_aliases l  WHERE e.id = d.id AND e.id = 158789 AND l.e_dns_rec_id = e.id;

4) Run this query in DB manually to be sure that it returns nothing.

5) Check each tables from query (e_dns_records, dns_records, l_server_aliases) for missing record

hsphere=# select * from e_dns_records where id = 158789;
   id   | alias_id | zone_id | type_rec
--------+----------+---------+----------
 158789 |          |    1127 |        3
(1 row)

hsphere=# select * from l_server_aliases where e_dns_rec_id = 158789;
 e_dns_rec_id | l_server_id |       prefix        | e_zone_id
--------------+-------------+---------------------+-----------
       158789 |          73 | unix3.domain.tld |      1127
(1 row)

hsphere=# select * from dns_records where id = 158789;
 id | name | type | data | ttl | pref | zone_id
----+------+------+------+-----+------+---------
(0 rows)

6) Recreate missing record:

INSERT INTO dns_records VALUES (158789, 'ns1.domain.tld', 'A', '10.10.10.10', 86400, NULL, 1127);  

Search Words

I cant see server aliases

_3020

Exception in Resource.get

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387 2e39a5e5b1423cc126cf735bac076008

Email subscription for changes to this article
Save as PDF