Some Subdomains are not working after update!

[sparkxp]

Hi,

part 1 of my problem:
Since the Update from Plesk 9 to 10 some subdomains are not reachable anymore.
When I call one of these domain, I get the "Server not found" page (in Firebug its network status "Aborted").
In the logfiles of the subdomain are no new entries.
I tried to delet the subdomain and add it again, but then I get the message "Unable to create the subdomain my.domain.com. because there is already a DNS record pointing to host my.domain.com..". Uhm, what?!
Okay, I took a look at /var/www/vhosts/ but there is no directory called "my.domain.com".
Then I switched to /var/www/vhosts/domain.com/subdomains/ there was a directory "my". I deleted it, but this didn't fix the problem.
After that I checked the database "psa", searched the subdomain name and found entries in the the following tables:

- log_components
- exp_event
- dns_zone
- dns_recs

All these tables have entries with my deleted subdomain! Why? And how can I cleanup safely?

Part 2 of my problem:
After all these, I tried to add a new (never used) subdomain to the same domain (another.domain.com).
While adding the subdomain, the /var/log/sw-cp-server/error_log got a new line: "2012-04-13T08:31:57+02:00 ERR (3): DNS Connector: error during commit (PleskDNSDuplicateCNAMERecord): Unable to restore the DNS zone: an error occurred while adding the webmail.domain.com. IN A xxx.xxx.xxx.xxx record: Such CNAME DNS record already exists."
Okay, why this error? I didn't add a webmail subdomain.
As expected, the subdomain "another.domain.com" doesn't work!

I think there went something very wrong on my update to Plesk 10!

Igor, please help!

 

[IgorG]

Following KB articles can be useful for you:

http://kb.parallels.com/en/112966
http://kb.parallels.com/en/113118
http://kb.parallels.com/en/113310

 

[sparkxp]

Following KB articles can be useful for you:

http://kb.parallels.com/en/112966
http://kb.parallels.com/en/113118
http://kb.parallels.com/en/113310

http://kb.parallels.com/en/112966
What is the best solution for me? Own or parent?
My Database says subdomain_own_zones = false.
But will all Domains work after changing? I added Domains and Subdomains before and after the updates.

http://kb.parallels.com/en/113118
I executed

select * from dns_recs_t where type='CNAME' and host in ('domain.com.','ns.domain.com.','mail.domain.com.','ipv4.domain.com.','ipv6.domain.com.','webmail.domain.com.')

but nothing was found. Is that good?

http://kb.parallels.com/en/113310
Executing

select dns_zone_id, type, host, val, opt from dns_recs where host in (select concat(s.name,'.', d.name,'.') from subdomains s, domains d where s.dom_id = d.id)

was empty too. Is that good?



I don't know what to do...

 

[sparkxp]

Igor, please help!

 

[IgorG]

For fixing this issue detailed investigation directly on your server is required. Therefore I suggest you contact Support Team.