715963 - IndexedDB: Cannot create ObjectStores

Status: RESOLVED INCOMPLETE

(Core :: Storage: IndexedDB, defect)

Description

[lcid-fire]

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/535.8 (KHTML, like Gecko) Ubuntu/11.10 Chromium/17.0.942.0 Chrome/17.0.942.0 Safari/535.8

Steps to reproduce:

On a site with url "localhost:8080/test.html"

var request = indexedDB.open("_test_", 1);
request.onsuccess = function() {
  var os = request.result.createObjectStore("somestore");
};


Actual results:

When it executes createObject I get the exception with the dumb message: "A mutation operation was attempted on a database that did not allow mutations".
This isn't helpfull at all.


Expected results:

It should have created the object store.

Comment 1

[lcid-fire]

Even when I move the  createObjectStore  call to  onupgradeneeded  , it still does not work since it never calls onupgradeneeded.

Comment 2

[Maxime RETY]

Attachment: Test case that shows 715963 is not a bug

IMHO it's not a bug. See attached test case.

Comment 3

[Maxime RETY]

Hi !

"onupgradeneeded" is called only the first time the database is opened, or when the database version has changed.
 
You may have to delete the database before testing again, or change the database version to trigger another "onupgradeneeded" call.

See attached example page (https://bugzilla.mozilla.org/attachment.cgi?id=604395), or following code :


// indexedDB = window.indexedDB || window.mozIndexedDB
//
// either delete database first
indexedDB.deleteDatabase("_test_");
//
// or change database version
request = indexedDB.open("_test_", 2);


// then execute that test function:
var testDB = function () {
   
   var request = indexedDB.open("_test_"),
       connectionToDB; // var to keep the opened connection to the database
   
   request.onupgradeneeded = function () {
      log("onupgradeneed: creating somestore");
      request.result.createObjectStore("somestore");
   };
   
   request.onsuccess = function (e) {
      
      connectionToDB = request.result;
      
      log("onsuccess: somestore exists ? => " + connectionToDB.objectStoreNames.contains("somestore")); // => true
      
      // close connection when not needed anymore
      connectionToDB.close();
   };
   
   request.onerror = function (e) {
      log('onerror: opening _test_ failed with e.target.errorCode = ' + e.target.errorCode);
   };
};

testDB();



Also, I recommend you have a look at https://developer.mozilla.org/en/IndexedDB/Using_IndexedDB .
Unfortunately, there are very few good examples of indexedDB usage out there...

I hope that helps !

Comment 4

[Maxime RETY]

Icid-fire, can you please test again and confirm the issue is resolved ?

Thanks.

Comment 6

[Kyle Huey (Exited; not receiving bugmail, old account, do not use)]

I answered your question in bug 736948.  Please don't post on multiple bugs.

Comment 7

[David Baron :dbaron: (⌚️UTC-5, no longer working on Mozilla)]

comment 5 was linkspam