fix a query relying on id to guess chronological order and remove some atomikos logs inside integration tests