Database upgrade error

thomasxie
how to fix this problem

Database upgrade error

[Exception... "Component returned failure code: 0x80520010 (NS_ERROR_FILE_NO_DEVICE_SPACE) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80520010 (NS_ERROR_FILE_NO_DEVICE_SPACE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 149" data: no] [QUERY: INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes] [ERROR: database or disk is full]
  • adamsmith
    that usually means what it says, i.e. Zotero can't write to the disk because it's full or because something is behaving as if it's full.

    But I'm also confused by the "customItemTypeID" in there - which Zotero version are you using?
  • thomasxie
    zotero 4.0.19-beta.r2
  • dstillman
    adamsmith: That's legit. Just not used for what it sounds like.
  • adamsmith
    thanks Dan - what I said originally then: "Zotero can't write to the disk because it's full or because something is behaving as if it's full. "
  • thomasxie
    but I have enough disk space.
  • dstillman
    Then it's either security software or something else interfering.
  • AnSnarkista
    I use Zotero 4.0.20.2 with Firefox 29 (in 28th version does the same, so I think it is not a Firefox issue) Arch Linux, so I don't use security software.

    I have tried so many solutions, like remove zotero folder, and reinstall Zotero; go to Preferences>Advanced>Folders and Files And "Check the integrity of the DB",and it says there is no problem with them. I also did what I read in the forum about other DB problems, like rename the zotero.sqlite.X.bak to zotero.sqlite, and didn't work.

    Is there anything more than I can do? Thanks a lot!
  • adamsmith
    Start a new thread and provide the exact error message you're getting.
  • AnSnarkista
    Is exactly the same as thomasxie, this is why I haven't started a new thread.

    I have tried to install zotero standalone, but it gives the same error.
  • adamsmith
    still, please do paste the full error message to confirm.
    And you're confident you have enough disk space on the partition you're trying this?
  • dstillman
    Not sure if thomasxie is on Arch Linux as well — he's at least on some Linux, I believe, based on an error report in another thread — but we see a lot of weird errors coming from Arch Linux. It's unlikely we're going to be able to help you debug this, but if you figure out what the problem is, certainly let us know.

    I assume you've tried Zotero Standalone as well?

    Also note that security software can be built-in things like SELinux or AppArmor. I'd guess that this is just an incorrect manifestation of an access denied error. You should check your system logs if you haven't yet.
  • AnSnarkista
    Error de actualización de la base de datos

    [Exception... "Component returned failure code: 0x80520010 (NS_ERROR_FILE_NO_DEVICE_SPACE) [mozIStorageConnection.executeSimpleSQL]" nsresult: "0x80520010 (NS_ERROR_FILE_NO_DEVICE_SPACE)" location: "JS frame :: chrome://zotero/content/xpcom/db.js :: Zotero.DBConnection.prototype.query :: line 149" data: no] [QUERY: INSERT INTO itemTypesCombined SELECT itemTypeID, typeName, display, 0 AS custom FROM itemTypes UNION SELECT customItemTypeID + 10000 AS itemTypeID, typeName, display, 1 AS custom FROM customItemTypes] [ERROR: database or disk is full]

    I have enough space in my home (the partition of Zotero's data), but I have just checked that I don't have that much space in my root partition (it is supposed not to be a problem). I have just cleaned some caché, and I'll post the results.
  • AnSnarkista
    SOLVED!

    It was that. Pacman keeps in /var/cache/pacman/pkg a copy of every installed package, in my case, that folder was 14Gb....

    The problem is that, usually, people makes 2 partitions, / for the system, and /home for the Documents and settings of every program installed, that's why I was sure that we have enough space in that partition. But sometimes, some programs use /tmp, wich is in / partition, and there is no enough space.

    For Arch users, they can go to /var/cache/pacman/pkg, and remove some packages from there, or if they want to remove all, just use:

    sudo pacman -Sc

This is an old discussion that has not been active in a long time. Before commenting here, you should strongly consider starting a new discussion instead. If you think the content of this discussion is still relevant, you can link to it from your new discussion.

Sign In or Register to comment.