Incorrect line and column numbering in validation errors

[hqdncw]

Bug Report

Description

The line and column numbering feature introduced in #6285 has a reliability problem, which can cause incorrect error messages to appear in certain cases.

Reproduce

1. Initialize DVC.

dvc init --no-scm

2. Create dvc.yaml

tee -a dvc.yaml << END
stages:
  train:
    cmd:
      - python train.py
    deps:
      - config.cfg
    outs:
      models/
END

3. List the contents of the repository

$ dvc ls .
'./dvc.yaml' validation failed.

expected a list, in stages -> train -> outs, line 3, column 5
  2   train:                                                                                                                                                              
  3 │   cmd:                                                                                                                                                              
  4 │     - python train.py

As you can see, DVC reports the error as occurring on line 3, column 5. However, the actual error is located on line 7, column 5. The reported line number is off by four lines, making it difficult to pinpoint the source of the error.

Expected

When validating a YAML file, DVC should provide accurate line and column numbers for any errors that occur. This ensures that users can quickly identify and fix problems in their YAML files.

Environment information

Output of dvc doctor:

$ dvc doctor
DVC version: 3.30.1
-------------------
Platform: Python 3.11.2 on <REDACTED>
Subprojects:
        dvc_data = 2.22.0
        dvc_objects = 1.1.0
        dvc_render = 0.6.0
        dvc_task = 0.3.0
        scmrepo = 1.4.1
Supports:
        azure (adlfs = 2023.10.0, knack = 0.11.0, azure-identity = 1.15.0),
        gdrive (pydrive2 = 1.17.0),
        gs (gcsfs = 2023.9.2),
        hdfs (fsspec = 2023.9.2, pyarrow = 14.0.1),
        http (aiohttp = 3.9.0, aiohttp-retry = 2.8.3),
        https (aiohttp = 3.9.0, aiohttp-retry = 2.8.3),
        oss (ossfs = 2021.8.0),
        s3 (s3fs = 2023.9.2, boto3 = 1.28.17),
        ssh (sshfs = 2023.10.0),
        webdav (webdav4 = 0.9.8),
        webdavs (webdav4 = 0.9.8),
        webhdfs (fsspec = 2023.9.2)
Config:
        Global: /home/sid/.config/dvc
        System: /etc/xdg/dvc
Cache types: hardlink, symlink
Cache directory: ext4 on /dev/sda9
Caches: local
Remotes: None
Workspace directory: ext4 on /dev/sda9
Repo: dvc (no_scm)
Repo.site_cache_dir: /var/tmp/dvc/repo/f3aaa8fd4f4e85f507ddd8996bd9016b

Additional Information (if any):

Related to #10102

[skshetry]

Closing, as we don't have capacity to work on this.