Hi all, We've been running Bacula on a couple of Debian 11 systems for a while now. We need to expand our backups, so I used the instructions for the community installation guide to do a clean install of bacula 13.0.3 on two of the systems and install it on a third system as a brand-new install. The backups seem to be working ok so far.
I decided to install the API on two of the servers and baculum on the third to centrally manage the backups using the info https://baculum.app/doc/brief/installation.html. The API is installed and configured with no errors on the two servers but when I try do an api request from the dashboard on either server, I get the below for any request { "output": "Internal error. TDbCommand failed to execute the query SQL \"\tSELECT conname, consrc, contype, indkey, indisclustered FROM (\n\t\t\tSELECT\n\t\t\t\t\tconname,\n\t\t\t\t\tpg_catalog.pg_get_constraintdef(oid) AS consrc,\n\t\t\t\t\tcontype,\n\t\t\t\t\tconrelid AS relid,\n\t\t\t\t\tNULL AS indkey,\n\t\t\t\t\tFALSE AS indisclustered\n\t\t\tFROM\n\t\t\t\t\tpg_catalog.pg_constraint\n\t\t\tWHERE\n\t\t\t\t\tcontype IN ('f', 'c')\n\t\t\tUNION ALL\n\t\t\tSELECT\n\t\t\t\t\tpc.relname,\n\t\t\t\t\tNULL,\n\t\t\t\t\tCASE WHEN indisprimary THEN\n\t\t\t\t\t\t\t'p'\n\t\t\t\t\tELSE\n\t\t\t\t\t\t\t'u'\n\t\t\t\t\tEND,\n\t\t\t\t\tpi.indrelid,\n\t\t\t\t\tindkey,\n\t\t\t\t\tpi.indisclustered\n\t\t\tFROM\n\t\t\t\t\tpg_catalog.pg_class pc,\n\t\t\t\t\tpg_catalog.pg_index pi\n\t\t\tWHERE\n\t\t\t\t\tpc.oid=pi.indexrelid\n\t\t\t\t\tAND EXISTS (\n\t\t\t\t\t\t\tSELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c\n\t\t\t\t\t\t\tON (d.refclassid = c.tableoid AND d.refobjid = c.oid)\n\t\t\t\t\t\t\tWHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')\n\t\t\t)\n\t) AS sub\n\tWHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table\n\t\t\t\t\tAND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace\n\t\t\t\t\tWHERE nspname=:schema))\n\tORDER BY\n\t\t\t1\": SQLSTATE[42804]: Datatype mismatch: 7 ERROR: UNION types \"char\" and text cannot be matched\nLINE 17: CASE WHEN indisprimary THEN\n ^", "error": 1000 } This is happening on both the API's and causes the baculum web to have a meltdown if I add the API in. I've checked the system logs and the bacula logs but can't see anything obvious! Can anyone give me a clue where I need to start digging on this? Thanks Andy
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users