When upgrading to 0.5.1 from 0.4 or higher, there is an important change in the location of the sqlite3-pcre library used. On Linux, the expected location of this library has changed from /usr/lib/sqlite3-pcre.so to /usr/lib/sqlite3/pcre.so. This is because the library is an extension specifically for sqlite3, not a general use shared library.
If you installed sqlite3-pcre manually, or are not using Ubuntu, you should
either modify the
ext_sqlite3_regex option in /etc/mosquitto.conf to point to
your library path, or move the library to the new location.
If you are using Ubuntu and have installed mosquitto from the launchpad ppa, this will largely be taken care of. However, due to a mistake in the packaging of sqlite3-pcre, you must first remove sqlite3-pcre with your package manager and then reinstall it before updating mosquitto. You will only ever need to do this once.
Sorry for the inconvenience caused by this change. If you have any problem or questions, feel free to get in touch on the mqtt users mailing list.