Core dump due to db query

[xorander00]

Describe the bug
Application is able to create and show the main window, but then immediately core dumps. Used to work properly, but don't remember which version that was as it was a while ago. Updated to 0.9.0 and tried launching it again when it core dumped. I don't know Vala, but looking at the logs below it seems like a quoting issue with the db queries.

To Reproduce
Steps to reproduce the behavior:

1. Launch application.

Expected behavior
Application launches and functions as expected.

Screenshots
See stdout/stderr logs below.

System Information

• OS: FreeBSD 14-STABLE (1401501)
• Desktop environment: Hyperland or Niri (happens on both)
• Font Manager version: 0.9.0
• Font Manager installation method: FreeBSD port at x11-fonts/font-manager

Additional context

(font-manager:56782): [font-manager]-CRITICAL **: 19:10:05.444: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:56782): [font-manager]-WARNING **: 19:10:05.446: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:56782): [font-manager]-CRITICAL **: 19:10:05.449: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:56782): [font-manager]-WARNING **: 19:10:05.451: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/me/.local/share/fonts";) [1] - no such column: "/home/me/.local/share/fonts" - should this be a string literal in single-quotes?

(font-manager:56782): Gtk-WARNING **: 19:10:06.631: GtkGizmo 0x303ce08a8450 (progress) reported min width -2, but sizes must be >= 0

(font-manager:56782): [font-manager]-CRITICAL **: 19:10:06.927: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:56782): [font-manager]-WARNING **: 19:10:06.929: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:56782): [font-manager]-CRITICAL **: 19:10:06.931: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:56782): [font-manager]-WARNING **: 19:10:06.933: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/me/.local/share/fonts";) [1] - no such column: "/home/me/.local/share/fonts" - should this be a string literal in single-quotes?
fish: Job 1, 'font-manager' terminated by signal SIGABRT (Abort)

[JerryCasiano]

Can you attach a text file containing the complete output when run with --debug flag please.

I doubt there'll be anything helpful in there but you never know.

Also, since this doesn't appear to occur in most cases otherwise others would be complaining about it and I'd be able to duplicate it, we'll certainly need your assistance in trying to figure out why it's happening at all on your system. Is it a BSD specific thing maybe?

Hopefully we'll get others to come in on that.

[JerryCasiano]

Unable to duplicate.

Closing due to lack of response.

Feel free to reopen once you're ready to assist in resolving this issue.

[xorander00]

Sorry, time has been scarce. Output with --debug flag as follows:

Font Manager 0.9.0

(process:1621): [font-manager]-DEBUG: 17:13:16.132: Fontconfig version : 21500
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Freetype version (compile-time) : 2.13.3
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Freetype version (run-time) : 2.13.3
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Harfbuzz version (compile-time) : 10.0.1
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Harfbuzz version (run-time) : 10.0.1
(process:1621): [font-manager]-DEBUG: 17:13:16.132: JSON-GLib version : 1.8.0
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Pango version (compile-time) : 1.52.2
(process:1621): [font-manager]-DEBUG: 17:13:16.132: Pango version (run-time) : 15202
(process:1621): [font-manager]-DEBUG: 17:13:16.132: libxml2 version : 21109
(process:1621): [font-manager]-DEBUG: 17:13:16.132: SQLite version (compile-time) : 3.46.1
(process:1621): [font-manager]-DEBUG: 17:13:16.132: SQLite version (run-time) : 3.46.1
(process:1621): [font-manager]-DEBUG: 17:13:16.132: GLib version (compile-time) : 2.80.5
(process:1621): [font-manager]-DEBUG: 17:13:16.132: GLib version (run-time) : 2.80.5
(process:1621): [font-manager]-DEBUG: 17:13:16.132: GTK version (compile-time) : 4.16.2
(process:1621): [font-manager]-DEBUG: 17:13:16.132: GTK version (run-time) : 4.16.2
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.189: Using schema with id com.github.FontManager.FontManager from default source
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.208: Adding icons from resource path : /com/github/FontManager/FontManager/icons/
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.513: Loading custom css from resource path : /com/github/FontManager/FontManager/ui/FontManager.css

(font-manager:1621): Gtk-WARNING **: 17:13:16.710: No IM module matching GTK_IM_MODULE=fcitx,qt_im_module=fcitx found
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.750: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.812: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.814: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:1621): [font-manager]-CRITICAL **: 17:13:16.814: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:1621): [font-manager]-WARNING **: 17:13:16.816: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.817: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.819: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/psingh/.local/share/fonts";) [1] - no such column: "/home/psingh/.local/share/fonts" - should this be a string literal in single-quotes?

(font-manager:1621): [font-manager]-CRITICAL **: 17:13:16.819: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:1621): [font-manager]-WARNING **: 17:13:16.821: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/psingh/.local/share/fonts";) [1] - no such column: "/home/psingh/.local/share/fonts" - should this be a string literal in single-quotes?
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.822: Restoring state : Window size : 950 x 700
(font-manager:1621): [font-manager]-DEBUG: 17:13:16.822: Restoring state : Window is maximized : FALSE
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.328: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.501: Database version is current, skipping initialization

(font-manager:1621): Gtk-WARNING **: 17:13:17.592: GtkGizmo 0x86912297610 (progress) reported min width -2, but sizes must be >= 0
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.610: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.644: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.649: FontList.vala:343: FontManagerFontListView::selection_changed : 3270 Nerd Font
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.653: Using schema with id com.github.FontManager.FontManager from default source
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.655: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.659: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.694: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.695: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:1621): [font-manager]-CRITICAL **: 17:13:17.695: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:1621): [font-manager]-WARNING **: 17:13:17.697: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.697: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.699: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/psingh/.local/share/fonts";) [1] - no such column: "/home/psingh/.local/share/fonts" - should this be a string literal in single-quotes?

(font-manager:1621): [font-manager]-CRITICAL **: 17:13:17.699: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:1621): [font-manager]-WARNING **: 17:13:17.701: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/psingh/.local/share/fonts";) [1] - no such column: "/home/psingh/.local/share/fonts" - should this be a string literal in single-quotes?
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.703: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.736: Database version is current, skipping initialization
(font-manager:1621): [font-manager]-DEBUG: 17:13:17.743: Database version is current, skipping initialization
fish: Job 1, 'font-manager --debug' terminated by signal SIGABRT (Abort)

[rwivie]

I am having the same problem using FreeBSD-14.1-RELEASE-p5 and wm is bspwm. font-manager was installed using pkg. Here is output using font-manager --debug

Font Manager 0.9.0

(process:42102): [font-manager]-DEBUG: 11:07:44.149: Fontconfig version : 21500
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Freetype version (compile-time) : 2.13.3
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Freetype version (run-time) : 2.13.3
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Harfbuzz version (compile-time) : 10.0.1
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Harfbuzz version (run-time) : 10.0.1
(process:42102): [font-manager]-DEBUG: 11:07:44.149: JSON-GLib version : 1.10.0
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Pango version (compile-time) : 1.52.2
(process:42102): [font-manager]-DEBUG: 11:07:44.149: Pango version (run-time) : 15202
(process:42102): [font-manager]-DEBUG: 11:07:44.149: libxml2 version : 21109
(process:42102): [font-manager]-DEBUG: 11:07:44.149: SQLite version (compile-time) : 3.46.1
(process:42102): [font-manager]-DEBUG: 11:07:44.149: SQLite version (run-time) : 3.46.1
(process:42102): [font-manager]-DEBUG: 11:07:44.149: GLib version (compile-time) : 2.80.5
(process:42102): [font-manager]-DEBUG: 11:07:44.149: GLib version (run-time) : 2.80.5
(process:42102): [font-manager]-DEBUG: 11:07:44.149: GTK version (compile-time) : 4.16.3
(process:42102): [font-manager]-DEBUG: 11:07:44.149: GTK version (run-time) : 4.16.3
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.261: Using schema with id com.github.FontManager.FontManager from default source
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.271: Adding icons from resource path : /com/github/FontManager/FontManager/icons/
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.271: Loading custom css from resource path : /com/github/FontManager/FontManager/ui/FontManager.css
[font-manager]-Message: 11:07:44.277: ArchiveManager.vala:63: Install file-roller to enable archive support
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.317: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.332: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.332: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:42102): [font-manager]-CRITICAL **: 11:07:44.332: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:42102): [font-manager]-WARNING **: 11:07:44.332: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.333: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.334: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/ron/.local/share/fonts";) [1] - no such column: "/home/ron/.local/share/fonts" - should this be a string literal in single-quotes?

(font-manager:42102): [font-manager]-CRITICAL **: 11:07:44.334: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:42102): [font-manager]-WARNING **: 11:07:44.334: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/ron/.local/share/fonts";) [1] - no such column: "/home/ron/.local/share/fonts" - should this be a string literal in single-quotes?
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.335: Restoring state : Window size : 950 x 700
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.335: Restoring state : Window is maximized : FALSE
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.665: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:44.841: Database version is current, skipping initialization

(font-manager:42102): Gtk-WARNING **: 11:07:44.979: GtkGizmo 0x30923f9dee50 (slider) reported min width -1, but sizes must be >= 0

(font-manager:42102): Gtk-WARNING **: 11:07:44.991: GtkGizmo 0x30923f9dee50 (slider) reported min height -1, but sizes must be >= 0

(font-manager:42102): Gtk-WARNING **: 11:07:45.004: GtkGizmo 0x30923f9dee50 (slider) reported min width -1, but sizes must be >= 0

(font-manager:42102): Gtk-WARNING **: 11:07:45.005: GtkGizmo 0x30923f9dee50 (slider) reported min height -1, but sizes must be >= 0
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.032: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.289: FontList.vala:343: FontManagerFontListView::selection_changed : 3270 Nerd Font
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.289: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.294: Using schema with id com.github.FontManager.FontManager from default source
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.294: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.308: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.322: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.322: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"

(font-manager:42102): [font-manager]-CRITICAL **: 11:07:45.322: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:42102): [font-manager]-WARNING **: 11:07:45.323: Category.vala:56: Database Error : (SELECT DISTINCT Fonts.family, Fonts.description FROM Fonts JOIN Metadata USING (filepath, findex) WHERE owner!=0 AND filepath LIKE '/usr;) [1] - unrecognized token: "'/usr;"
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.324: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.324: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/ron/.local/share/fonts";) [1] - no such column: "/home/ron/.local/share/fonts" - should this be a string literal in single-quotes?

(font-manager:42102): [font-manager]-CRITICAL **: 11:07:45.324: font_manager_get_matching_families_and_fonts: assertion 'error == NULL || *error == NULL' failed

(font-manager:42102): [font-manager]-WARNING **: 11:07:45.324: Category.vala:56: Database Error : (SELECT DISTINCT family, description FROM Fonts WHERE filepath LIKE "/home/ron/.local/share/fonts";) [1] - no such column: "/home/ron/.local/share/fonts" - should this be a string literal in single-quotes?
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.327: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.341: Database version is current, skipping initialization
(font-manager:42102): [font-manager]-DEBUG: 11:07:45.459: Database version is current, skipping initialization
zsh: abort (core dumped)  font-manager --debug

[JerryCasiano]

@xorander00
@rwivie

Can you guys post the output of locale please.

[xorander00]

LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_ALL=en_US.UTF-8

[JerryCasiano]

Well, that's a bummer. Not sure why database queries are generated incorrectly on some systems but just fine on all others...

Thanks for posting it.

[rwivie]

@JerryCasiano My FreeBSD drive died on me and I am not sure when I will be able to get another one. The locale that xorander00 posted is the same that I had on my system.

[JerryCasiano]

@rwivie

Thanks. But it doesn't look like it's related to locale anyway.

@xorander00

If possible, it would be helpful if you were to build from master and see if the changes there make any difference on your system.

You'll probably need to also delete the cache folder.

~/.cache/font-manager

To get rid of the existing database files.

[xorander00]

@JerryCasiano I just rebuilt version 0.9.0 (the one that's available in FreeBSD ports). I tried it both with and without NLS (e.g. gettext). I also deleted ~/.cache/font-manager. Crashes after it's done indexing fonts. I'll build from master today and see if it still happens. Will also try a few different combinations of LC_* just to see if it changes anything.

[xorander00]

@JerryCasiano Just FYI, but help/ta/ta.po from master appears to have some typos that were causing build errors for me. There were two places where <app>...</app> was type-o'ed as <apa>...</app> or <pp>...</app>. I temporarily patched it so it would build. Going to test it shortly.