Unable to load dynamic library 'pdo_pgsql'

[memo-567]

Support guidelines

• I've read the support guidelines

I've found a bug and checked that ...

• ... the documentation does not mention anything about my problem
• ... there are no open or closed issues that are related to my problem
• ... it's definitely a Firefly III issue, not me

Description

Since update to v6.2.16 cronjob artisan firefly-iii:cron doesn't seem to work anymore. Same error as cli php artisan migrate --seed

firefly-iii# php artisan migrate --seed

PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /usr/lib/php/20240924/pdo_pgsql (/usr/
lib/php/20240924/pdo_pgsql: cannot open shared object file: No such file or directory), /usr/lib/php/20240924/
pdo_pgsql.so (/usr/lib/php/20240924/pdo_pgsql.so: undefined symbol: pdo_dbh_ce)) in Unknown on line 0

Debug information

Debug information generated at 2025-05-30 11:38:10 for Firefly III version v6.2.16.

System information
Item	Value
Firefly III	v6.2.16 / #25 (expects #25)
PHP version	8.4.7 (64bits) / fpm-fcgi / Linux x86_64
BCscale	12
Error reporting	Display: Off, reporting: ALL errors
Max upload	2097152 (2 MB)
Database drivers	*mysql*, pgsql, sqlite,

Firefly III information
Item	Value
Timezone	Europe/Amsterdam + Atlantic/Reykjavik
App environment	local, debug: false
Layout	v1
Logging	notice, stack / (empty)
Cache driver, session driver	file, file
Default language and locale	de_DE + equal
Trusted proxies
Login provider & user guard	eloquent / web
Login headers	N/A + N/A
Stateful domains
Last cron job	2025-05-28 01:00:02 (2 days ago)
Mailer	smtp
Exchange rates	Disabled, downloads disabled
RB-column	Disabled

User-specific information
Item	Value
User	#1 of 1
User flags	🕜
Native currency	EUR
Convert to native currency?	Disabled
Session start	2025-05-01 00:00:00
Session end	2025-05-31 23:59:59
View range	1M
User language	de_DE
User locale	de_DE
Locale(s) supported	de_DE.utf8: ✅ de_DE.UTF-8: ✅
User agent	Mozilla/5.0 (X11; Linux x86_64; rv:139.0) Gecko/20100101 Firefox/139.0

Expected behaviour

No response

Steps to reproduce

No response

Additional info

No response

[JC5]

Hey, thanks for starting this discussion.

It looks like the library isn't installed (anymore). Could that be the cause?

Cheers,
James

[memo-567]

It's not only artisan, but php -v also. I keep looking.

[JC5]

Yes, it's a start up error, it's something generic in PHP's configuration. If the module isn't missing, does PHP have access to it?

[memo-567]

There was a PHP update on May the 9th. No recurring transaction from this time forward. If this error persists, I see no change, then adding the relevant transaction manually.

[memo-567]

Sorry for wrong addressing this issue. I first didn't realize that this is an PHP error only and doesn't depend on FF. So this may already exist for a long time, but I didn't notice.
However - if this doesn't take any effect to FF, I will live with that.

Sorry again and have a nice weekend 😀

[JC5]

Not a problem!

[memo-567]

Automatic transactions are, despite the error message still being displayed, executed ¯\_(ツ)_/¯

[JC5]

Thanks, I'll check it out!

[JC5]

Should be fixed in the next release :)