Page MenuHomeDevCentral
Create Task
Maniphest T1888

Add XML support on db-A PostgreSQL
Closed, ResolvedPublic
Actions

Description

Orbeon Forms requires XML feature with PostgreSQL.

That means we need to build PostgreSQL with libxml support.

When saving a form on Orbeon:

2023-05-25T04:17:27,661 ERROR PageFlowControllerProcessor - error caught {controller: "oxf:/apps/fr/page-flow.xml", method: "PUT", path: "/fr/service/postgresql/crud/orbeon/builder/data/.../data.xml"}
2023-05-25T04:17:27,668 ERROR PageFlowControllerProcessor -
+----------------------------------------------------------------------------------------------------------------------+
|An Error has Occurred                                                                                                 |
|----------------------------------------------------------------------------------------------------------------------|
|ERROR: unsupported XML feature                                                                                        |
|  Detail: This functionality requires the server to be built with libxml support.                                     |
|----------------------------------------------------------------------------------------------------------------------|
|Application Call Stack                                                                                                |                                                                                                    |----------------------------------------------------------------------------------------------------------------------|
|oxf:/apps/fr/page-flow.xml                                                        |reading page model data output|  42|                                                                                                    |······················································································································|
|element=<service path="/fr/service/(oracle|mysql|postgresql|db2|sqlserver)/crud/([^/]+/[^/]+/(form/[^/]+|(data|draft)/|                                                                                                    |model  =persistence/relational/crud.xpl                                                                               |
|----------------------------------------------------------------------------------------------------------------------|                                                                                                    |oxf:/apps/fr/persistence/relational/crud.xpl                                      |executing processor           |  17|
|······················································································································|
|element=<p:processor name="fr:relational-crud"/>                                                                      |
|name   ={http://orbeon.org/oxf/xml/form-runner}relational-crud                                                        |
|----------------------------------------------------------------------------------------------------------------------|
|----------------------------------------------------------------------------------------------------------------------|
|Exception: org.postgresql.util.PSQLException                                                                          |
|----------------------------------------------------------------------------------------------------------------------|

Revisions and Commits

rOPS Nasqueron Operations
D3290rOPSc680b42ecc99 Ensure PostgreSQL port is still up-to-date on FreeBSD
D3287rOPS5db68870099b Fix PostgreSQL 15 build instructions
D3132rOPS7406ef91eb10 Handle the odd case no package is needed in roles/dbserver-pgsql/server
D3130rOPSe79d77e83a85 Build PostgreSQL with XML support on FreeBSD

Related Objects
Search...

Event Timeline

dereckson triaged this task as High priority.May 25 2023, 04:21
dereckson created this task.
dereckson moved this task from Backlog to Servers on the DBA board.
dereckson added a project: upstream.May 25 2023, 04:26

upstream https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269115

dereckson added a comment.May 25 2023, 04:35

Packages required to build it ourselves:

postgresql_dependencies_build:
  pkg.installed:
    - pkgs:
      - dialog4ports
      - gmake
      - pkgconf
      - gettext

Option to enable: XML

dereckson added a revision: D3130: Build PostgreSQL with XML support on FreeBSD.May 25 2023, 04:52
dereckson closed this task as Resolved by committing rOPSe79d77e83a85: Build PostgreSQL with XML support on FreeBSD.May 25 2023, 04:54
dereckson added a commit: rOPSe79d77e83a85: Build PostgreSQL with XML support on FreeBSD.
dereckson added a revision: D3132: Handle the odd case no package is needed in roles/dbserver-pgsql/server.May 25 2023, 15:42
dereckson added a commit: rOPS7406ef91eb10: Handle the odd case no package is needed in roles/dbserver-pgsql/server.May 25 2023, 15:43
dereckson reopened this task as Open.Jan 14 2024, 23:18

When upgraded to FreeBSD 14, we lost this.

dereckson mentioned this in T1943: Orbeon Forms trigger an error after application is submit.Jan 14 2024, 23:19
dereckson added a parent task: T1943: Orbeon Forms trigger an error after application is submit.
dereckson added a comment.EditedJan 15 2024, 00:16

I've added documentation to https://agora.nasqueron.org/Operations_grimoire/FreeBSD#PostgreSQL without real conviction.

A better solution would be to create a cluster of 3 servers and create new servers:

  • we start by creating db-A-002, db-A-003, so we've a cluster of 3 servers
  • upgrade to FreeBSD 15 or major library bump consists of the following rolling upgrade steps:
    • create db-A-004
    • destroy db-A-001
    • create db-A-005
    • destroy db-A-002
    • create db-A-006
    • destroy db-A-003

On the new machines, roles/dbserver-pgsql/server/build will work like a charm.

dereckson added a revision: D3287: Fix PostgreSQL 15 build instructions.Jan 15 2024, 00:19
dereckson added a commit: rOPS5db68870099b: Fix PostgreSQL 15 build instructions.Jan 15 2024, 00:20
dereckson closed this task as Resolved.Jan 15 2024, 00:21
dereckson added a revision: D3290: Ensure PostgreSQL port is still up-to-date on FreeBSD.Jan 15 2024, 21:37
dereckson added a commit: rOPSc680b42ecc99: Ensure PostgreSQL port is still up-to-date on FreeBSD.Jan 16 2024, 00:53
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator