Unknown column 'event.referent_uuid'

[dahorn98]

Hello there,
i recently installed the icinga daemon on kubernetes via yaml files. In Icinga Web 2 an error occurs every time i want show "Events" or go into detail in Objects like "Pods"
`SQLSTATE[42S22]: Column not found: 1054 Unknown column 'event.referent_uuid' in 'SELECT'

#0 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(401): PDO->prepare()
#1 /usr/share/icinga-php/ipl/vendor/ipl/sql/src/Connection.php(418): ipl\Sql\Connection->prepexec()
#2 /usr/share/icinga-php/ipl/vendor/ipl/orm/src/Query.php(710): ipl\Sql\Connection->select()
#3 /usr/share/icinga-php/ipl/vendor/ipl/orm/src/ResultSet.php(139): ipl\Orm\Query->yieldResults()
#4 [internal function]: ipl\Orm\ResultSet->yieldTraversable()
#5 /usr/share/icinga-php/ipl/vendor/ipl/orm/src/ResultSet.php(122): Generator->valid()
#6 /usr/share/icinga-php/ipl/vendor/ipl/orm/src/ResultSet.php(114): ipl\Orm\ResultSet->advance()
#7 /usr/share/icingaweb2/modules/kubernetes/library/Kubernetes/Common/BaseItemList.php(51): ipl\Orm\ResultSet->rewind()
#8 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(344): Icinga\Module\Kubernetes\Common\BaseItemList->assemble()
#9 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(566): ipl\Html\HtmlDocument->ensureAssembled()
#10 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(390): ipl\Html\HtmlDocument->render()
#11 /usr/share/icinga-php/ipl/vendor/ipl/html/src/BaseHtmlElement.php(297): ipl\Html\HtmlDocument->renderUnwrapped()
#12 /usr/share/icinga-php/ipl/vendor/ipl/html/src/BaseHtmlElement.php(365): ipl\Html\BaseHtmlElement->renderContent()
#13 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(568): ipl\Html\BaseHtmlElement->renderUnwrapped()
#14 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(390): ipl\Html\HtmlDocument->render()
#15 /usr/share/icinga-php/ipl/vendor/ipl/html/src/HtmlDocument.php(568): ipl\Html\HtmlDocument->renderUnwrapped()
#16 /usr/share/icinga-php/ipl/vendor/ipl/web/src/Compat/ViewRenderer.php(62): ipl\Html\HtmlDocument->render()
#17 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Action/Helper/ViewRenderer.php(970): ipl\Web\Compat\ViewRenderer->render()
#18 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Action/HelperBroker.php(277): Zend_Controller_Action_Helper_ViewRenderer->postDispatch()
#19 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Action.php(527): Zend_Controller_Action_HelperBroker->notifyPostDispatch()
#20 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch()
#21 /usr/share/icinga-php/vendor/vendor/shardj/zf1-future/library/Zend/Controller/Front.php(954): Icinga\Web\Controller\Dispatcher->dispatch()
#22 /usr/share/php/Icinga/Application/Web.php(294): Zend_Controller_Front->dispatch()
#23 /usr/share/php/Icinga/Application/webrouter.php(105): Icinga\Application\Web->dispatch()
#24 /usr/share/icingaweb2/public/index.php(4): require_once(String)
#25 {main}`

We have no Pometheus active at the moment. I hope this is not the reason for this.
In the database this table is filled but the column doesnt exist.

Kind regards
Daniel

[jrauh01]

Hi Daniel,

could you please let me know which version of Icinga for Kubernetes and Icinga for Kubernetes Web you're using? Additionally could you please check if the column in your database is named 'reference_uuid' or 'referent_uuid'.

Best regards,
Johannes

[dahorn98]

Hi @jrauh01,

Icinga Web 2 2.12.4
Icinga Web 2 Kubernetes Module 0.2.0
As Image icinga/icinga-kubernetes:edge (in Logs says 0.2.0)

In the Database is a column "reference_uuid".

Kind regards
Daniel

[jrauh01]

The column was originally named referent_uuid and was renamed to reference_uuid in PR #95. Since you’re using the edge-tagged Docker image, your backend includes this change (It’s based on version 0.2.0 plus additional updates made after that release.)

However, your web module is still running on version 0.2.0 and doesn’t yet include the column rename. As a result, it’s looking for the old column and fails to find it.

To resolve this mismatch, you can switch to the icinga/icinga-kubernetes:latest image, which points to the latest stable release of Icinga for Kubernetes.

Best regards,
Johannes

[dahorn98]

Now it works after resetting the database.
Thank you for the resolution. You should probably update your documentation at https://icinga.com/docs/icinga-for-kubernetes/latest/icinga-kubernetes.example.yml to use "latest"

Kind regards
Daniel

[jrauh01]

Thanks for pointing this out!

[DemonPenguin]

This change does not appear to have made it into the ubuntu repository.

icinga-kubernetes 0.4.0-1+ubuntu22.04
icinga-kubernetes-web 0.2.0-1+ubuntu22.04

These are the versions installed after an apt update.