用sqlite表在ubuntu18.04错误中安装qgis，不能再使用apt

Question

我得到了以下错误：

$ sudo apt-get install grass grass-dev qgis python-qgis qgis-plugin-grass
Reading package lists... Done
Building dependency tree       
Reading state information... Done
grass-dev is already the newest version (7.4.0-1).
python-qgis is already the newest version (1:3.4.2+28bionic).
The following additional packages will be installed:
  qgis-providers
Suggested packages:
  gpsbabel
The following NEW packages will be installed:
  grass qgis qgis-plugin-grass qgis-providers
0 upgraded, 4 newly installed, 0 to remove and 2 not upgraded.
Need to get 0 B/12.7 MB of archives.
After this operation, 22.8 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Selecting previously unselected package qgis-providers.
(Reading database ... 398057 files and directories currently installed.)
Preparing to unpack .../qgis-providers_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-providers (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis.
Preparing to unpack .../qgis_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis (1:3.4.2+28bionic) ...
Selecting previously unselected package qgis-plugin-grass.
Preparing to unpack .../qgis-plugin-grass_1%3a3.4.2+28bionic_amd64.deb ...
Unpacking qgis-plugin-grass (1:3.4.2+28bionic) ...
Selecting previously unselected package grass.
Preparing to unpack .../archives/grass_7.4.0-1_all.deb ...
Unpacking grass (7.4.0-1) ...
Setting up grass (7.4.0-1) ...
Setting up qgis-providers (1:3.4.2+28bionic) ...
/usr/lib/qgis/crssync: symbol lookup error: /usr/lib/libgdal.so.20: undefined symbol: sqlite3_column_table_name
dpkg: error processing package qgis-providers (--configure):
 installed qgis-providers package post-installation script subprocess returned error exit status 127
dpkg: dependency problems prevent configuration of qgis:
 qgis depends on qgis-providers (= 1:3.4.2+28bionic); however:
  Package qgis-providers is not configured yet.

dpkg: error processing package qgis (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processing triggers for mime-support (3.60ubuntu1) ...
Processing triggers for desktop-file-utils (0.23-1ubuntu3.18.04.2) ...
dpkg: dependency problems prevent configuration of qgis-plugin-grass:
 qgis-plugin-grass depends on qgis (= 1:3.4.2+28bionic); however:
  Package qgis is not configured yet.

dpkg: error processing package qgis-plugin-grass (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for shared-mime-info (1.9-2) ...
Processing triggers for gnome-menus (3.13.3-11ubuntu1.1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Errors were encountered while processing:
 qgis-providers
 qgis
 qgis-plugin-grass
E: Sub-process /usr/bin/dpkg returned an error code (1)

为什么它在与sqlite表有关的问题上失败了？

我跟踪了这个：安装插件时的依赖问题

并试图安装：

sudo apt install libmysqlclient-dev 

由于某些原因，会产生与qgis相同的错误。

这似乎永久地扰乱了我的系统。我试图安装的任何东西都会产生这个错误。

调试

的编辑

$ dpkg -S /usr/lib/libgdal.so.20
libgdal20: /usr/lib/libgdal.so.20

Answer 1

看起来您的libsqlite3是在没有开关的情况下构建的：

-DSQLITE_ENABLE_COLUMN_METADATA

这是libgda1.so.20所期望的。