Installing qgis in ubuntu 18.04 error with sqlite tables, can no longer use apt

up vote
0
down vote

favorite

I'm getting the following error:

$ 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)

Why is it failing on something to do with sqlite tables?

I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass

And trying to install:

sudo apt install libmysqlclient-dev

Produces the same error about qgis for some reason.

This seems to have permanently messed up my system. Anything I try to install produces this error.

Edit for debug

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

libgdal20: /usr/lib/libgdal.so.20

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37

Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20

Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

add a comment |

up vote
0
down vote

favorite

I'm getting the following error:

$ 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)

Why is it failing on something to do with sqlite tables?

I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass

And trying to install:

sudo apt install libmysqlclient-dev

Produces the same error about qgis for some reason.

This seems to have permanently messed up my system. Anything I try to install produces this error.

Edit for debug

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

libgdal20: /usr/lib/libgdal.so.20

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37

Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20

Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

add a comment |

up vote
0
down vote

favorite

I'm getting the following error:

$ 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)

Why is it failing on something to do with sqlite tables?

I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass

And trying to install:

sudo apt install libmysqlclient-dev

Produces the same error about qgis for some reason.

This seems to have permanently messed up my system. Anything I try to install produces this error.

Edit for debug

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

libgdal20: /usr/lib/libgdal.so.20

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

I'm getting the following error:

$ 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)

Why is it failing on something to do with sqlite tables?

I followed this:
Dependency issues when trying to install qgis python-qgis qgis-plugin-grass

And trying to install:

sudo apt install libmysqlclient-dev

Produces the same error about qgis for some reason.

This seems to have permanently messed up my system. Anything I try to install produces this error.

Edit for debug

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

libgdal20: /usr/lib/libgdal.so.20

package-management dependencies sqlite3 qgis

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

edited Nov 29 at 19:20

asked Nov 29 at 16:55

Mittenchops

71441534

asked Nov 29 at 16:55

Mittenchops

71441534

asked Nov 29 at 16:55

Mittenchops

71441534

Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37

Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20

Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

add a comment |

Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37

Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20

Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

Please add output of dpkg -S /usr/lib/libgdal.so.20 and ldd /usr/lib/libgdal.so.20 to the question. Also note that your install command end with success on clean Ubuntu 18.04.1 LTS VM without PPAs. It opens qgis and reports that it has 2.18 version. Do you have any PPAs added to the system?
– N0rbert
Nov 29 at 18:37

Thanks, @N0rbert. ldd seems to have a lot of output but ldd /usr/lib/libgdal.so.20 grep | gdal returns nothing
– Mittenchops
Nov 29 at 19:20

Please share full output of ldd /usr/lib/libgdal.so.20 and apt-cache policy libgdal20.
– N0rbert
Nov 29 at 19:22

add a comment |

active

oldest

votes

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1097177%2finstalling-qgis-in-ubuntu-18-04-error-with-sqlite-tables-can-no-longer-use-apt%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

active

oldest

votes

draft saved

draft discarded

Thanks for contributing an answer to Ask Ubuntu!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Krdytkyu

Installing qgis in ubuntu 18.04 error with sqlite tables, can no longer use apt

Edit for debug

Edit for debug

Edit for debug

Edit for debug

Your Answer

Post as a guest

Post as a guest

Popular posts from this blog

Quarter-circle Tiles

build a pushdown automaton that recognizes the reverse language of a given pushdown automaton?

Mont Emei