ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name

[mohseniaref-InSAR]

Hi

What this error could be related?

tops2vrt.py -i ../update/merged/ -s coreg_stack -g geometry -c slcs -B -24.6 -24.2 -66 -65.3
´´´
number of SLCs discovered: 82
we assume that the SLCs and the vrt files are sorted in the same order
creating directory: slcs
write vrt file for each SLC ...
1 / 82: slcs/20141018.vrt
2 / 82: slcs/20141111.vrt
3 / 82: slcs/20141205.vrt
4 / 82: slcs/20141229.vrt
5 / 82: slcs/20150122.vrt
6 / 82: slcs/20150215.vrt
7 / 82: slcs/20150227.vrt
8 / 82: slcs/20150323.vrt
9 / 82: slcs/20150416.vrt
10 / 82: slcs/20150603.vrt
11 / 82: slcs/20150627.vrt
12 / 82: slcs/20150721.vrt
13 / 82: slcs/20150814.vrt
14 / 82: slcs/20150907.vrt
15 / 82: slcs/20151001.vrt
16 / 82: slcs/20160528.vrt
17 / 82: slcs/20160808.vrt
18 / 82: slcs/20160901.vrt
19 / 82: slcs/20161001.vrt
20 / 82: slcs/20161025.vrt
21 / 82: slcs/20161118.vrt
22 / 82: slcs/20161212.vrt
23 / 82: slcs/20170105.vrt
24 / 82: slcs/20170129.vrt
25 / 82: slcs/20170222.vrt
26 / 82: slcs/20170306.vrt
27 / 82: slcs/20170318.vrt
28 / 82: slcs/20170330.vrt
29 / 82: slcs/20170411.vrt
30 / 82: slcs/20170423.vrt
31 / 82: slcs/20170505.vrt
32 / 82: slcs/20170517.vrt
33 / 82: slcs/20170529.vrt
34 / 82: slcs/20170610.vrt
35 / 82: slcs/20170622.vrt
36 / 82: slcs/20170704.vrt
37 / 82: slcs/20170716.vrt
38 / 82: slcs/20170728.vrt
39 / 82: slcs/20170809.vrt
40 / 82: slcs/20170821.vrt
41 / 82: slcs/20170902.vrt
42 / 82: slcs/20170914.vrt
43 / 82: slcs/20170926.vrt
44 / 82: slcs/20171008.vrt
45 / 82: slcs/20171020.vrt
46 / 82: slcs/20171101.vrt
47 / 82: slcs/20171113.vrt
48 / 82: slcs/20171125.vrt
49 / 82: slcs/20171207.vrt
50 / 82: slcs/20180112.vrt
51 / 82: slcs/20180124.vrt
52 / 82: slcs/20180205.vrt
53 / 82: slcs/20180217.vrt
54 / 82: slcs/20180301.vrt
55 / 82: slcs/20180313.vrt
56 / 82: slcs/20180325.vrt
57 / 82: slcs/20180406.vrt
58 / 82: slcs/20180418.vrt
59 / 82: slcs/20180430.vrt
60 / 82: slcs/20180512.vrt
61 / 82: slcs/20180524.vrt
62 / 82: slcs/20180605.vrt
63 / 82: slcs/20180816.vrt
64 / 82: slcs/20180828.vrt
65 / 82: slcs/20180909.vrt
66 / 82: slcs/20181003.vrt
67 / 82: slcs/20181027.vrt
68 / 82: slcs/20181108.vrt
69 / 82: slcs/20181120.vrt
70 / 82: slcs/20181202.vrt
71 / 82: slcs/20181214.vrt
72 / 82: slcs/20181226.vrt
73 / 82: slcs/20190107.vrt
74 / 82: slcs/20190119.vrt
75 / 82: slcs/20190131.vrt
76 / 82: slcs/20190212.vrt
77 / 82: slcs/20190224.vrt
78 / 82: slcs/20190308.vrt
79 / 82: slcs/20190320.vrt
80 / 82: slcs/20190401.vrt
81 / 82: slcs/20190413.vrt
82 / 82: slcs/20190425.vrt
creating stack directory: coreg_stack
finding bbox based on geo coordinates of [-24.6, -24.2, -66.0, -65.3] ...
ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name
ERROR 1: PROJ: proj_create_from_database: SQLite error on SELECT name, type, coordinate_system_auth_name, coordinate_system_code, datum_auth_name, datum_code, area_of_use_auth_name, area_of_use_code, text_definition, deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such column: area_of_use_auth_name
x min-max: 25091 48113
y min-max: 5522 7268
write vrt file for stack directory
creating geometry directory: geometry
write vrt file for geometry dataset

´´´

[hardreddata]

It sounds like a proj version issue.

See https://community.rstudio.com/t/sf-installation-issues-on-r4-0-ubuntu18-04/93667/27 which speaks about the same area_of_use_auth_name error.

[mohseniaref-InSAR]

You might try
find conda info --base -name epsg
and set export PROJ_LIB=