# Release app can not open connection to DB

**URL:** <https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262>\
**Category:** ionic-v3\
**Created:** [May 15, 2017, 3:43am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262 "2017-05-15T03:43:03Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![libyapages](https://avatars.discourse-cdn.com/v4/letter/l/a698b9/32.png) [@libyapages](https://forum.ionicframework.com/u/libyapages)\
**Post date:** [May 15, 2017, 3:43am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/1 "2017-05-15T03:43:03Z")

</div>

Hello Everyone.  
Recently, I have developed an app using Ionic 2, the app creates Sqlite DB and feed it using web API. Everything working great through IonicView and unsigned .apk app version. But the release version of the app does NOT able to open a connection to DB, I have checked the whole functions of this version, everything working as in the unsigned version except opening the DB.

Any Ideas. Thanks

---

<div class="post-metadata">

**Author:** ![Sujan12](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/sujan12/32/108395_2.png) [@Sujan12](https://forum.ionicframework.com/u/Sujan12)\
**Post date:** [May 15, 2017, 7:52am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/2 "2017-05-15T07:52:56Z")

</div>

How are you building your dev version?  
How are you building your release version?  
What is your `ionic info` and content of `package.json`?

---

<div class="post-metadata">

**Author:** ![libyapages](https://avatars.discourse-cdn.com/v4/letter/l/a698b9/32.png) [@libyapages](https://forum.ionicframework.com/u/libyapages)\
**Post date:** [May 15, 2017, 9:39am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/3 "2017-05-15T09:39:03Z")

</div>

## I have used: ionic build and ionic package build, to get unsigned and release version of the app.

## Cordova CLI: 6.4.0 Ionic Framework Version: 2.0.0-rc.4 Ionic CLI Version: 2.1.17 Ionic App Lib Version: 2.1.7 Ionic App Scripts Version: 0.0.47 ios-deploy version: 1.9.0 ios-sim version: 5.0.13 OS: macOS Sierra Node Version: v6.9.2 Xcode version: Xcode 8.3.2 Build version 8E2002

```auto
 "dependencies": {
    "@angular/common": "2.2.1",
    "@angular/compiler": "2.2.1",
    "@angular/compiler-cli": "2.2.1",
    "@angular/core": "2.2.1",
    "@angular/forms": "2.2.1",
    "@angular/http": "2.2.1",
    "@angular/platform-browser": "2.2.1",
    "@angular/platform-browser-dynamic": "2.2.1",
    "@angular/platform-server": "2.2.1",
    "@ionic/storage": "1.1.7",
    "ionic-angular": "2.0.0-rc.4",
    "ionic-native": "2.2.11",
    "ionicons": "3.0.0",
    "rxjs": "5.0.0-beta.12",
    "zone.js": "0.6.26"
  },
  "devDependencies": {
    "@ionic/app-scripts": "0.0.47",
    "typescript": "2.0.9"
  },
  "cordovaPlugins": [
    "cordova-plugin-whitelist",
    "cordova-plugin-console",
    "cordova-plugin-statusbar",
    "cordova-plugin-device",
    "cordova-plugin-splashscreen",
    "ionic-plugin-keyboard"
  ],
  "cordovaPlatforms": [
    "ios",
    {
      "platform": "ios",
      "version": "",
      "locator": "ios"
    }
  ],

```

---

<div class="post-metadata">

**Author:** ![Sujan12](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/sujan12/32/108395_2.png) [@Sujan12](https://forum.ionicframework.com/u/Sujan12)\
**Post date:** [May 15, 2017, 9:42am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/4 "2017-05-15T09:42:56Z")

</div>

> [@libyapages](#):
>
> I have used: ionic build and ionic package build, to get unsigned and release version of the app.

Yeah but what are the exact commands you used?

---

<div class="post-metadata">

**Author:** ![Sujan12](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/sujan12/32/108395_2.png) [@Sujan12](https://forum.ionicframework.com/u/Sujan12)\
**Post date:** [May 15, 2017, 9:45am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/5 "2017-05-15T09:45:09Z")

</div>

My first advice would be to upgrade all the things. ionic-angular, app-scripts, angular itself, ionic-native… Can only get better and shouldn’t cause too many problems.

---

<div class="post-metadata">

**Author:** ![libyapages](https://avatars.discourse-cdn.com/v4/letter/l/a698b9/32.png) [@libyapages](https://forum.ionicframework.com/u/libyapages)\
**Post date:** [May 17, 2017, 2:31pm UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/6 "2017-05-17T14:31:27Z")

</div>

I did updated everything as you advice, I still have the same issue, any suggestions!!

---

<div class="post-metadata">

**Author:** ![Sujan12](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/sujan12/32/108395_2.png) [@Sujan12](https://forum.ionicframework.com/u/Sujan12)\
**Post date:** [May 17, 2017, 3:11pm UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/7 "2017-05-17T15:11:22Z")

</div>

First step: Post your new `ionic info` and `packages.json`.

---

<div class="post-metadata">

**Author:** ![rapropos](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/rapropos/32/100227_2.png) [@rapropos](https://forum.ionicframework.com/u/rapropos)\
**Post date:** [May 17, 2017, 10:28pm UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/8 "2017-05-17T22:28:21Z")

</div>

Any chance you’re attempting to access SQLite before the platform is ready?

---

<div class="post-metadata">

**Author:** ![libyapages](https://avatars.discourse-cdn.com/v4/letter/l/a698b9/32.png) [@libyapages](https://forum.ionicframework.com/u/libyapages)\
**Post date:** [May 18, 2017, 2:35am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/9 "2017-05-18T02:35:18Z")

</div>

No, I do check if the platform is ready.

platform.ready().then(() =\> {  
… my code here…  
}

---

<div class="post-metadata">

**Author:** ![IAKIEK](https://avatars.discourse-cdn.com/v4/letter/i/c77e96/32.png) [@IAKIEK](https://forum.ionicframework.com/u/IAKIEK)\
**Post date:** [July 30, 2019, 6:28pm UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/10 "2019-07-30T18:28:20Z")

</div>

Hi I have the almost same question.

Ionic storage  
Could not open database

1.When running:

Ionic cordova run android --device -l --debug --verbose

2.Got console log:

OPEN database: \_ionicstorage  
SQLitePlugin.js:106 new transaction is queued, waiting for open operation to finish  
SQLitePlugin.js:197 OPEN database: \_ionicstorage FAILED, aborting any pending transactions  
SQLitePlugin.js:83 Could not open database

3.Good / Bad situation

Good: Ionic serve  
Good: Ionic serve --devapp (debug on device)  
Bad: release .apk (installed on device)  
Bad: Ionic cordova run android --device -l --debug --verbose (debug on device)

4.package.json

“dependencies”: {  
“@angular/animations”: “^8.1.2”,  
“@angular/cdk”: “^8.1.1”,  
“@angular/common”: “^8.1.2”,  
“@angular/core”: “^8.1.2”,  
“@angular/forms”: “^8.1.2”,  
“@angular/http”: “^7.2.2”,  
“@angular/material”: “^8.1.1”,  
“@angular/platform-browser”: “^8.1.2”,  
“@angular/platform-browser-dynamic”: “^8.1.2”,  
“@angular/router”: “^8.1.2”,  
“@ionic-native/core”: “^5.0.0”,  
“@ionic-native/splash-screen”: “^5.0.0”,  
“@ionic-native/status-bar”: “^5.0.0”,  
“@ionic/angular”: “^4.7.1”,  
“@ionic/storage”: “^2.2.0”,  
“bootstrap”: “^4.3.1”,  
“cordova-android”: “8.0.0”,  
“cordova-plugin-sqlite”: “^1.0.3”,  
“cordova-plugin-sqlite-2”: “^1.0.6”,  
“core-js”: “^2.5.4”,  
“rxjs”: “~6.5.1”,  
“save-dev”: “^2.0.0”,  
“tslib”: “^1.9.0”,  
“zone.js”: “~0.9.1”  
},

5.have try

a.Edit: storage.ready().then(  
storage.get() // \<= where came thr error  
)

b.Add: IonicStorageModule.forRoot({name: ‘\_\_mydb’, driverOrder: [‘indexeddb’, ‘sqlite’, ‘websql’]}

c.Delete one or all cordova-plugin-sqlite package

Any ideas?

=\> Solved by change the root options. 2019/07/31

Before NG  
IonicStorageModule.forRoot({name: ‘\_\_mydb’, driverOrder: [‘sqlite’, ‘websql’, ‘indexeddb’,]}

After OK  
IonicStorageModule.forRoot({name: ‘\_\_mydb’, driverOrder: [‘websql’, ‘indexeddb’, ‘sqlite’,]}

=\> USE websql rather than sqlite seems works

---

<div class="post-metadata">

**Author:** ![rapropos](https://sea1.discourse-cdn.com/ionicframework/user_avatar/forum.ionicframework.com/rapropos/32/100227_2.png) [@rapropos](https://forum.ionicframework.com/u/rapropos)\
**Post date:** [July 31, 2019, 12:05am UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/11 "2019-07-31T00:05:46Z")

</div>

> [@IAKIEK](#):
>
> “cordova-plugin-sqlite”: “^1.0.3”,  
> “cordova-plugin-sqlite-2”: “^1.0.6”,

This looks suspicious. What happens if you lose one or the other of these?

---

<div class="post-metadata">

**Author:** ![IAKIEK](https://avatars.discourse-cdn.com/v4/letter/i/c77e96/32.png) [@IAKIEK](https://forum.ionicframework.com/u/IAKIEK)\
**Post date:** [August 1, 2019, 2:02pm UTC](https://forum.ionicframework.com/t/release-app-can-not-open-connection-to-db/90262/12 "2019-08-01T14:02:18Z")

</div>

Actually nothing, but the problem have been solved, refer to my previous answer.
