View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
20680Bug reportsComfortUpdatepublic2026-09-10 12:322026-09-13 22:29
Reportercbm.it Assigned Top_teichmann  
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Summary20680: Upgrade from 6.17.19+260832 to latest 7.x fails with DB (Postgres) transaction error
Description

I'm upgrading Limesurvey from latest 6.x to latest 7.x. I'm using Postgres as database.
I'm doing updates using ComfortUpdate and right now I'm stuck with an intermediate database version 705 because the updater is asking me to update to database version 711 but it fails with this error:

A non-recoverable error occurred during the database update. Error details:
CDbCommand failed to execute the SQL statement: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block

File updatedb_helper.php, line 2910.

Steps To Reproduce

Steps to reproduce

Upgrade to latest Limesurvey 6.x. Use ComfortUpdate to upgrade to 7.x

Expected result

Upgrade works.

Actual result

Upgrade fails with errors during the db upgrade.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)7.0.14+260904 (db update not complete?)
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgres 17.7
Server OS (if known)Debian 13 (stable/trixie)
Webserver software & version (if known)Apache 2.4.66
PHP Version8.4.11
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

tibor.pacalat

tibor.pacalat

2026-09-10 13:00

administrator   ~85629

I managed to successfully upgrade using Comfort Update from version 6.17.19+260832 to 7.0.14+260904. Not quite sure what is the issue on your side, I will try to find someone to investigate.
cbm.it

cbm.it

2026-09-10 13:36

reporter   ~85630

Did you upgrade an installation which was using Postgres? The error points to a db upgrade error and it wouldn't be the first time I have issues with this specific kind of database while doing upgrades.

Thanks!
p_teichmann

p_teichmann

2026-09-10 13:53

administrator   ~85632

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=40278
tibor.pacalat

tibor.pacalat

2026-09-10 13:55

administrator   ~85633

@cbm.it yes I did upgrade an installation which used Postgres. The issue appears to be if the index is missing. Why this happens however, I am not sure.

Related Changesets

LimeSurvey: master f5733d92

2026-09-10 13:53

p_teichmann

Committer: GitHub


Details Diff		 Fixed issue 20680: Update 706 fails on pgsql if index is missing (05289) Affected Issues
20680
mod - application/helpers/update/updates/Update_706.php Diff File

Issue History

Date Modified Username Field Change
2026-09-10 12:32 cbm.it New Issue
2026-09-10 13:00 tibor.pacalat Note Added: 85629
2026-09-10 13:00 tibor.pacalat Bug heat 0 => 2
2026-09-10 13:00 tibor.pacalat Assigned To => tibor.pacalat
2026-09-10 13:00 tibor.pacalat Status new => assigned
2026-09-10 13:36 cbm.it Note Added: 85630
2026-09-10 13:36 cbm.it Bug heat 2 => 4
2026-09-10 13:53 p_teichmann Changeset attached => LimeSurvey master f5733d92
2026-09-10 13:53 p_teichmann Note Added: 85632
2026-09-10 13:53 p_teichmann Assigned To tibor.pacalat => p_teichmann
2026-09-10 13:53 p_teichmann Status assigned => resolved
2026-09-10 13:53 p_teichmann Resolution open => fixed
2026-09-10 13:53 p_teichmann Bug heat 4 => 6
2026-09-10 13:55 tibor.pacalat Note Added: 85633
2026-09-13 22:29 c_schmitz Status resolved => closed