desktop-packages team mailing list archive

Thread
Date
[Bug 1493219] [NEW] ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: dino99 <1493219@xxxxxxxxxxxxxxxxxx>
Date: Tue, 08 Sep 2015 06:47:49 -0000
Reply-to: Bug 1493219 <1493219@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

As chromium-browser is my default browser, when i use Apport to send a
report, the terminal is displaying:

*****************
ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
[21497:21553:0908/080923:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
[21497:21497:0908/080923:ERROR:background_mode_manager_aura.cc(14)] Not implemented reached in virtual void BackgroundModeManager::EnableLaunchOnStartup(bool)
[21497:21497:0908/080924:ERROR:desktop_window_tree_host_x11.cc(833)] Not implemented reached in virtual void views::DesktopWindowTreeHostX11::InitModalType(ui::ModalType)
[21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=32
[21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: SELECT COUNT(*) FROM sqlite_master
[21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
[21497:21539:0908/080924:ERROR:web_database_backend.cc(54)] Cannot initialize the web database: 1
[21497:21553:0908/080924:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=1000
[21497:21552:0908/080924:ERROR:sandbox_origin_database.cc(195)] SandboxOriginDatabase failed at: Init@../../storage/browser/fileapi/sandbox_origin_database.cc:94 with error: IO error: /home/oem/.config/chromium/Default/File System/Origins/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
[21497:21535:0908/080924:ERROR:gcm_store_impl.cc(291)] Failed to open database /home/oem/.config/chromium/Default/GCM Store: IO error: /home/oem/.config/chromium/Default/GCM Store/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
[21497:21553:0908/080925:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
[21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
[21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: CREATE TABLE omni_box_shortcuts (id VARCHAR PRIMARY KEY, text VARCHAR, fill_into_edit VARCHAR, url VARCHAR, contents VARCHAR, contents_class VARCHAR, description VARCHAR, description_class VARCHAR, transition INTEGER, type INTEGER, keyword VARCHAR, last_access_time INTEGER, number_of_hits INTEGER)
[21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: SELECT id, text, fill_into_edit, url, contents, contents_class, description, description_class, transition, type, keyword, last_access_time, number_of_hits FROM omni_box_shortcuts
[21497:21539:0908/080925:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
[21497:21554:0908/080925:ERROR:gcm_store_impl.cc(381)] Destroy failed: IO error: /home/oem/.config/chromium/Default/GCM Store/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
[21497:21544:0908/080925:ERROR:gcm_client_impl.cc(696)] Failed to reset GCM store
[21497:21552:0908/080926:ERROR:sandbox_origin_database.cc(195)] SandboxOriginDatabase failed at: Init@../../storage/browser/fileapi/sandbox_origin_database.cc:94 with error: IO error: /home/oem/.config/chromium/Default/File System/Origins/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
[21497:21539:0908/080926:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=32
[21497:21539:0908/080926:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
[21497:21539:0908/080926:ERROR:password_store_default.cc(42)] Could not create/open login database.
[21497:21540:0908/081010:ERROR:value_store_frontend.cc(62)] Error while writing gjieilkfnnjoihjjonajndjldjoagffm.browser_action to /home/oem/.config/chromium/Default/Extension State

*******************

Trying to find a thread talking about that issue, i've found that old report still alive, concerning system using nvidia driver (which i have: nvidia-355 on gtx 750):
https://code.google.com/p/chromium/issues/detail?id=86948

*******
The problem only occurs with NVidia's binary drivers and has to do with Chrome's use of tcmalloc on Linux. When building Chromium with "-Dlinux_use_tcmalloc=0", then the problem goes away.
***********

ProblemType: Bug
DistroRelease: Ubuntu 15.10
Package: chromium-browser 44.0.2403.89-0ubuntu1.1195
ProcVersionSignature: Ubuntu 4.2.0-7.7-generic 4.2.0
Uname: Linux 4.2.0-7-generic i686
NonfreeKernelModules: nvidia
ApportVersion: 2.18-0ubuntu9
Architecture: i386
CurrentDesktop: GNOME
Date: Tue Sep  8 08:30:31 2015
Desktop-Session:
 'gnome'
 '/etc/xdg/xdg-gnome:/usr/share/upstart/xdg:/etc/xdg'
 '/usr/share/gnome:/usr/local/share/:/usr/share/'
Env:
 'None'
 'None'
Load-Avg-1min: 2.59
Load-Processes-Running-Percent:   0.4%
Lsusb:
 Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub
 Bus 003 Device 002: ID 046d:c062 Logitech, Inc. M-UAS144 [LS1 Laser Mouse]
 Bus 003 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
 Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
MachineType: ASUSTEK COMPUTER INC P5W DH Deluxe
ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.2.0-7-generic root=UUID=7b1f4a51-558f-468f-85e0-f815d2f791e1 ro intel_iommu=on
SourcePackage: chromium-browser
UpgradeStatus: No upgrade log present (probably fresh install)
dmi.bios.date: 07/22/2010
dmi.bios.vendor: American Megatrends Inc.
dmi.bios.version: 3002
dmi.board.asset.tag: To Be Filled By O.E.M.
dmi.board.name: P5W DH Deluxe
dmi.board.vendor: ASUSTeK Computer INC.
dmi.board.version: Rev 1.xx
dmi.chassis.asset.tag: Asset-1234567890
dmi.chassis.type: 3
dmi.chassis.vendor: Chassis Manufacture
dmi.chassis.version: Chassis Version
dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvr3002:bd07/22/2010:svnASUSTEKCOMPUTERINC:pnP5WDHDeluxe:pvrSystemVersion:rvnASUSTeKComputerINC.:rnP5WDHDeluxe:rvrRev1.xx:cvnChassisManufacture:ct3:cvrChassisVersion:
dmi.product.name: P5W DH Deluxe
dmi.product.version: System Version
dmi.sys.vendor: ASUSTEK COMPUTER INC
gconf-keys: /desktop/gnome/applications/browser/exec = b'/usr/bin/chromium-browser\n'/desktop/gnome/url-handlers/https/command = b'/usr/bin/chromium-browser %s\n'/desktop/gnome/url-handlers/https/enabled = b'true\n'/desktop/gnome/url-handlers/http/command = b'/usr/bin/chromium-browser %s\n'/desktop/gnome/url-handlers/http/enabled = b'true\n'/desktop/gnome/session/required_components/windowmanager = b''/apps/metacity/general/compositing_manager = b''/desktop/gnome/interface/icon_theme = b'gnome\n'/desktop/gnome/interface/gtk_theme = b'Clearlooks\n'
modified.conffile..etc.chromium.browser.default: [modified]
modified.conffile..etc.default.chromium.browser: [deleted]
mtime.conffile..etc.chromium.browser.default: 2014-09-14T15:14:59.882580

** Affects: chromium-browser (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 wily

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to chromium-browser in Ubuntu.
https://bugs.launchpad.net/bugs/1493219

Title:
  ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is
  locked, sql: PRAGMA journal_mode = PERSIST

Status in chromium-browser package in Ubuntu:
  New

Bug description:
  As chromium-browser is my default browser, when i use Apport to send a
  report, the terminal is displaying:

  *****************
  ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
  [21497:21553:0908/080923:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
  [21497:21497:0908/080923:ERROR:background_mode_manager_aura.cc(14)] Not implemented reached in virtual void BackgroundModeManager::EnableLaunchOnStartup(bool)
  [21497:21497:0908/080924:ERROR:desktop_window_tree_host_x11.cc(833)] Not implemented reached in virtual void views::DesktopWindowTreeHostX11::InitModalType(ui::ModalType)
  [21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=32
  [21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: SELECT COUNT(*) FROM sqlite_master
  [21497:21539:0908/080924:ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
  [21497:21539:0908/080924:ERROR:web_database_backend.cc(54)] Cannot initialize the web database: 1
  [21497:21553:0908/080924:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=1000
  [21497:21552:0908/080924:ERROR:sandbox_origin_database.cc(195)] SandboxOriginDatabase failed at: Init@../../storage/browser/fileapi/sandbox_origin_database.cc:94 with error: IO error: /home/oem/.config/chromium/Default/File System/Origins/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
  [21497:21535:0908/080924:ERROR:gcm_store_impl.cc(291)] Failed to open database /home/oem/.config/chromium/Default/GCM Store: IO error: /home/oem/.config/chromium/Default/GCM Store/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
  [21497:21553:0908/080925:ERROR:connection.cc(1075)] History sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
  [21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
  [21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: CREATE TABLE omni_box_shortcuts (id VARCHAR PRIMARY KEY, text VARCHAR, fill_into_edit VARCHAR, url VARCHAR, contents VARCHAR, contents_class VARCHAR, description VARCHAR, description_class VARCHAR, transition INTEGER, type INTEGER, keyword VARCHAR, last_access_time INTEGER, number_of_hits INTEGER)
  [21497:21539:0908/080925:ERROR:connection.cc(1075)] Shortcuts sqlite error 5, errno 0: database is locked, sql: SELECT id, text, fill_into_edit, url, contents, contents_class, description, description_class, transition, type, keyword, last_access_time, number_of_hits FROM omni_box_shortcuts
  [21497:21539:0908/080925:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
  [21497:21554:0908/080925:ERROR:gcm_store_impl.cc(381)] Destroy failed: IO error: /home/oem/.config/chromium/Default/GCM Store/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
  [21497:21544:0908/080925:ERROR:gcm_client_impl.cc(696)] Failed to reset GCM store
  [21497:21552:0908/080926:ERROR:sandbox_origin_database.cc(195)] SandboxOriginDatabase failed at: Init@../../storage/browser/fileapi/sandbox_origin_database.cc:94 with error: IO error: /home/oem/.config/chromium/Default/File System/Origins/LOCK: No further details. (ChromeMethodBFE: 15::LockFile::1)
  [21497:21539:0908/080926:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: PRAGMA cache_size=32
  [21497:21539:0908/080926:ERROR:connection.cc(1075)]  sqlite error 5, errno 0: database is locked, sql: CREATE TABLE meta(key LONGVARCHAR NOT NULL UNIQUE PRIMARY KEY, value LONGVARCHAR)
  [21497:21539:0908/080926:ERROR:password_store_default.cc(42)] Could not create/open login database.
  [21497:21540:0908/081010:ERROR:value_store_frontend.cc(62)] Error while writing gjieilkfnnjoihjjonajndjldjoagffm.browser_action to /home/oem/.config/chromium/Default/Extension State

  *******************

  Trying to find a thread talking about that issue, i've found that old report still alive, concerning system using nvidia driver (which i have: nvidia-355 on gtx 750):
  https://code.google.com/p/chromium/issues/detail?id=86948

  *******
  The problem only occurs with NVidia's binary drivers and has to do with Chrome's use of tcmalloc on Linux. When building Chromium with "-Dlinux_use_tcmalloc=0", then the problem goes away.
  ***********

  ProblemType: Bug
  DistroRelease: Ubuntu 15.10
  Package: chromium-browser 44.0.2403.89-0ubuntu1.1195
  ProcVersionSignature: Ubuntu 4.2.0-7.7-generic 4.2.0
  Uname: Linux 4.2.0-7-generic i686
  NonfreeKernelModules: nvidia
  ApportVersion: 2.18-0ubuntu9
  Architecture: i386
  CurrentDesktop: GNOME
  Date: Tue Sep  8 08:30:31 2015
  Desktop-Session:
   'gnome'
   '/etc/xdg/xdg-gnome:/usr/share/upstart/xdg:/etc/xdg'
   '/usr/share/gnome:/usr/local/share/:/usr/share/'
  Env:
   'None'
   'None'
  Load-Avg-1min: 2.59
  Load-Processes-Running-Percent:   0.4%
  Lsusb:
   Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub
   Bus 003 Device 002: ID 046d:c062 Logitech, Inc. M-UAS144 [LS1 Laser Mouse]
   Bus 003 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
   Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
  MachineType: ASUSTEK COMPUTER INC P5W DH Deluxe
  ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.2.0-7-generic root=UUID=7b1f4a51-558f-468f-85e0-f815d2f791e1 ro intel_iommu=on
  SourcePackage: chromium-browser
  UpgradeStatus: No upgrade log present (probably fresh install)
  dmi.bios.date: 07/22/2010
  dmi.bios.vendor: American Megatrends Inc.
  dmi.bios.version: 3002
  dmi.board.asset.tag: To Be Filled By O.E.M.
  dmi.board.name: P5W DH Deluxe
  dmi.board.vendor: ASUSTeK Computer INC.
  dmi.board.version: Rev 1.xx
  dmi.chassis.asset.tag: Asset-1234567890
  dmi.chassis.type: 3
  dmi.chassis.vendor: Chassis Manufacture
  dmi.chassis.version: Chassis Version
  dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvr3002:bd07/22/2010:svnASUSTEKCOMPUTERINC:pnP5WDHDeluxe:pvrSystemVersion:rvnASUSTeKComputerINC.:rnP5WDHDeluxe:rvrRev1.xx:cvnChassisManufacture:ct3:cvrChassisVersion:
  dmi.product.name: P5W DH Deluxe
  dmi.product.version: System Version
  dmi.sys.vendor: ASUSTEK COMPUTER INC
  gconf-keys: /desktop/gnome/applications/browser/exec = b'/usr/bin/chromium-browser\n'/desktop/gnome/url-handlers/https/command = b'/usr/bin/chromium-browser %s\n'/desktop/gnome/url-handlers/https/enabled = b'true\n'/desktop/gnome/url-handlers/http/command = b'/usr/bin/chromium-browser %s\n'/desktop/gnome/url-handlers/http/enabled = b'true\n'/desktop/gnome/session/required_components/windowmanager = b''/apps/metacity/general/compositing_manager = b''/desktop/gnome/interface/icon_theme = b'gnome\n'/desktop/gnome/interface/gtk_theme = b'Clearlooks\n'
  modified.conffile..etc.chromium.browser.default: [modified]
  modified.conffile..etc.default.chromium.browser: [deleted]
  mtime.conffile..etc.chromium.browser.default: 2014-09-14T15:14:59.882580

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/chromium-browser/+bug/1493219/+subscriptions
Follow ups

[Bug 1493219] Re: ERROR:connection.cc(1075)] Web sqlite error 5, errno 0: database is locked, sql: PRAGMA journal_mode = PERSIST
From: dino99, 2015-12-22