Arch Linux

alex3772

Member

Registered: 2013-10-18

Posts: 11

[solved] signal-desktop can not open encrypted data

Hey!

After an upgrade to the latest signal-desktop version today, it refuses to open the existing db with the following errors:

signal-desktop                                                                                                                                                                                                                                                                     ─╯
NODE_ENV production
NODE_CONFIG_DIR /usr/lib/signal-desktop/resources/app.asar/config
NODE_CONFIG {}
ALLOW_CONFIG_MUTATIONS undefined
HOSTNAME jake
NODE_APP_INSTANCE undefined
SUPPRESS_NO_CONFIG_WARNING undefined
SIGNAL_ENABLE_HTTP undefined
userData: /home/alex/.config/Signal
(node:7818) [DEP0180] DeprecationWarning: fs.Stats constructor is deprecated.
(Use `signal-desktop --trace-deprecation ...` to show where the warning was created)
2025-11-27 16:36:57.822: ERROR CORE sqlcipher_page_cipher: hmac check failed for pgno=1
2025-11-27 16:36:57.822: ERROR CORE sqlite3Codec: error decrypting page 1 data: 1
2025-11-27 16:36:57.822: ERROR CORE sqlcipher_codec_ctx_set_error 1
2025-11-27 16:36:57.832: ERROR CORE sqlcipher_page_cipher: hmac check failed for pgno=1
2025-11-27 16:36:57.832: ERROR CORE sqlite3Codec: error decrypting page 1 data: 1
2025-11-27 16:36:57.832: ERROR CORE sqlcipher_codec_ctx_set_error 1

Is anyone else having similar issues?

Last edited by alex3772 (Yesterday 10:52:51)

gromit

Administrator

From: Germany

Registered: 2024-02-10

Posts: 1,368

Website

Re: [solved] signal-desktop can not open encrypted data

Which signal-desktop version do you have installed?

alex3772

Member

Registered: 2013-10-18

Posts: 11

Re: [solved] signal-desktop can not open encrypted data

The  version with issues i have installed is 7.80.1-1.

Edit: typo

Last edited by alex3772 (2025-11-27 16:01:39)

alex3772

Member

Registered: 2013-10-18

Posts: 11

Re: [solved] signal-desktop can not open encrypted data

I now tried the upgrade on a different computer and there are no issues there with the same version (7.80.1-1)

So i am gonna have a look at what could be the issue in the package, but i guess the data must have been corrupted somehow, maybe not by signal itself.

alex3772

Member

Registered: 2013-10-18

Posts: 11

Re: [solved] signal-desktop can not open encrypted data

Looking at the differences between the versions i had installed(7.80.0-1 -> 7.80.1-1) it looks like there was a db migration.

sql/migrations/1541-cleanup-polls.std.ts
------------------------------------------------------------
// Copyright 2025 Signal Messenger, LLC
// SPDX-License-Identifier: AGPL-3.0-only

import type { LoggerType } from '../../types/Logging.std.js';
import type { WritableDB } from '../Interface.std.js';
import { sql } from '../util.std.js';

// This migration was backported to later branches as 1551 and 1561
export default function updateToSchemaVersion1541(
  db: WritableDB,
  logger: LoggerType
): void {
  const [query, params] = sql`
    UPDATE messages 
      SET 
        json = json_remove(json, '$.poll'),
        hasUnreadPollVotes = 0
      WHERE isErased = 1 AND (
        json->'poll' IS NOT NULL OR
        hasUnreadPollVotes IS NOT 0
      )
  `;
  const result = db.prepare(query).run(params);
  logger.info(`Updated ${result.changes} poll messages`);
}

I can only assume that i interrupted the migration/write to the db somehow.

I do not see a way to debug this further so i am just gonna reset signal and restore the messages from my phone.

alex3772

Member

Registered: 2013-10-18

Posts: 11

Re: [solved] signal-desktop can not open encrypted data

Just used the GUI to delete the DB and relink it.
Lost all messages from more than 45 days ago though.