The entity_translation status does not get updated when the node status changes - This can lead to the main language translation not appearing - see http://technology.blue-bag.com/entity-translations-and-published-status-flag

Drupal-Node-status-vs-entity_translation-Status.sql

/**
 * Get a list of nodes where the entity_translation status is not in sync
 * Note we only get the unpublished translations as it is the node status we are concerned with
 * We are also only interested in the source translations
 **/
select node.status, et.status 
from entity_translation et
inner join .node on node.nid = et.entity_id and et.entity_type = 'node'
where node.status <> et.status  and et.status = 0 and et.source = ''

Drupal-Update-entity-Translation-Status.sql

/**
 * Update Entity_translations for node status
 * Only update the source records and then only those that are unpublished
 **/

UPDATE entity_translation et
inner join node n on n.nid = et.entity_id and et.entity_type = 'node'
SET et.status= 1 
where n.status <> et.status  and et.status = 0 and et.source = '';