Testing Firbird BLOB support. Although MOV files are listed as acceptable input data streams in the dialog (using a form with an image control bound to a BLOB defined field), these files are not inserted, but LO attempts nonetheless to do so, and when these files are large, say more than a couple of Mb, causes LO Base to stop responding. I'm not sure how this could be resolved, perhaps by excluding video formats from the list of supported file types for that particular dialog ? Alex
The hang appears to last for as long as it takes LO to completely parse the file stream then reject it. If you have a large MOV file this will cause the app hang mechanism to kick in, killing the app.
How to reproduce : 1) Create a new embedded Firebird db with the wizard 2) Create a table with two fields : ID : integer, primary key IMG : blob 3) Create a form based on the table 4) Double-click on the saved form to open it and double-click on the image control to choose a media. Note that in the media choice dialog, MOV files are allowed. 5) Choose a large MOV file. 6) Wait, wait some more, listen to disk activity whirring while LO attempts to process the file - during this time LO is unresponsive. Alex
Console output : warn:legacy.tools:29208:1:vcl/source/gdi/bmpacc.cxx:58: Forbidden Access to empty bitmap! warn:legacy.tools:29208:1:vcl/source/gdi/bmpacc.cxx:58: Forbidden Access to empty bitmap! warn:sfx.control:29208:1:sfx2/source/control/dispatch.cxx:1530: Childwindow slot missing: 10365 warn:sfx.control:29208:1:sfx2/source/control/dispatch.cxx:1530: Childwindow slot missing: 10365 warn:legacy.tools:29208:1:vcl/source/gdi/bmpacc.cxx:58: Forbidden Access to empty bitmap! warn:legacy.tools:29208:1:vcl/source/gdi/bmpacc.cxx:58: Forbidden Access to empty bitmap! warn:legacy.osl:29208:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:29208:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:29208:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:29208:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.GroupShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.GroupShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.GroupShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.GroupShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape warn:xmloff:29208:1:xmloff/source/draw/shapeexport.cxx:556: com.sun.star.drawing.ControlShape
We should probably use some async interface for BLOB/CLOB... Or maybe offload the loading work to another thread.
As an example, I tested insertion of a 39.8 Mb MOV video file. I started timing from the moment I clicked on the "Previous Record" arrow in the toolbar at the bottom of the form. It took LO 1 minute 50 s to respond and display the previous record. Alex
Hmm, are there two separate things here then : - incorrect recognition of MOV video files as image media types for the BLOB stream ? - performance of writing BLOBs to disk ? Alex
With an 81 Mb MOV file, it takes 3 min 48 s to switch to the previous record. Alex
After insertion of such a file, attempting to display the table view from the form via the bottom data navigation toolbar caused LO to crash and trash both the new table and form I had created in an existing FDB embedded ODB file. terminate called after throwing an instance of 'com::sun::star::sdbc::SQLException' sh: 1: /home/Development/libo/core/instdir/program/../program/crashrep: not found will investigate further. Alex
Hi Alex, In the list of formats that can be imported into a BLOB field, there is no video format except MOV, there are only image formats. The presence of the MOV format in the list seems incongruous and might be an error? I tried to import MOV video, but nothing appears in the control associated in my form. I verified in my Firebird SQL Server 2.5, the video formats accepted are only AVI and MPEG. Bernard
With gdb running, I see : warn:legacy.tools:25906:1:vcl/source/gdi/bmpacc.cxx:58: Forbidden Access to empty bitmap! but the blob data still gets inserted into the db (just nothing is shown in the UI on the form). In turn, this makes the db very unresponsive. Alex
Tried swapping the MOV file for a 59 Mb TIFF file - same performance hit. I've also noticed this warning crops up regularly in the console: warn:sfx.control:25906:1:sfx2/source/control/dispatch.cxx:1518: Childwindow slot missing: 10365 The TIFF file at least displays what seems to be a preview in the form when LO finally comes to its senses, but during the time it takes to move from one record to the next, load the stream and display it, you may as well go and have a game of chess ;-) Alex
So I inserted two TIFF files into my db, one was 59 Mb, and the second 39 Mb. Both are displayed in the form, after navigating backwards and forwards again with the record navigation toolbar. If I close the form, the save the state of the ODB file, and then close down LO, I see this output in gdb : warn:sfx.control:25906:1:sfx2/source/control/dispatch.cxx:1518: Childwindow slot missing: 10365 [New Thread 0x7fff7462e700 (LWP 26324)] warn:sfx.control:25906:1:sfx2/source/control/dispatch.cxx:1518: Childwindow slot missing: 10365 [Thread 0x7fff7462e700 (LWP 26324) exited] [Thread 0x7fffa5b45700 (LWP 26323) exited] warn:sfx.control:25906:1:sfx2/source/control/dispatch.cxx:1518: Childwindow slot missing: 10365 [New Thread 0x7fffa5b45700 (LWP 26341)] [Thread 0x7fffa5b45700 (LWP 26341) exited] [New Thread 0x7fffa5b45700 (LWP 26342)] [Thread 0x7fffa5b45700 (LWP 26342) exited] [New Thread 0x7fffa5b45700 (LWP 26344)] [Thread 0x7fffa5b45700 (LWP 26344) exited] warn:legacy.osl:25906:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:25906:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:25906:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:legacy.osl:25906:1:xmloff/source/forms/propertyexport.cxx:595: OPropertyExport::implConvertAny: unsupported value type! warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.GroupShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.GroupShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.GroupShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.GroupShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape warn:xmloff:25906:1:xmloff/source/draw/shapeexport.cxx:555: com.sun.star.drawing.ControlShape [New Thread 0x7fffa5b45700 (LWP 26345)] [Thread 0x7fffa5b45700 (LWP 26345) exited] warn:sfx.control:25906:1:sfx2/source/control/dispatch.cxx:1518: Childwindow slot missing: 10365 [New Thread 0x7fffa5b45700 (LWP 26365)] [Thread 0x7fffa5b45700 (LWP 26365) exited] warn:legacy.osl:25906:1:unotools/source/config/moduleoptions.cxx:635: unknown factory [New Thread 0x7fffa5b45700 (LWP 26367)] [Thread 0x7fffa5b45700 (LWP 26367) exited] [New Thread 0x7fffa5b45700 (LWP 26368)] [Thread 0x7fffa5b45700 (LWP 26368) exited] [New Thread 0x7fffa5b45700 (LWP 26369)] [Thread 0x7fffa5b45700 (LWP 26369) exited] [Thread 0x7fff8ffff700 (LWP 25970) exited] [New Thread 0x7fff8ffff700 (LWP 26370)] [Thread 0x7fffd282b700 (LWP 25943) exited] [New Thread 0x7fffd282b700 (LWP 26371)] [Thread 0x7fffd1dee700 (LWP 25931) exited] warn:legacy.osl:25906:1:package/source/zippackage/ZipPackageStream.cxx:486: Exception is thrown during stream wrapping! warn:legacy.osl:25906:1:package/source/zippackage/ZipPackageFolder.cxx:392: ZipPackageStream didn't have a stream associated with it, skipping! warn:legacy.osl:25906:1:dbaccess/source/core/dataaccess/ModelImpl.cxx:895: caught an exception! in function:static bool dbaccess::ODatabaseModelImpl::commitStorageIfWriteable_ignoreErrors(const com::sun::star::uno::Reference<com::sun::star::embed::XStorage>&) type: com.sun.star.embed.StorageWrappedTargetException message: /opt/Development/libo/core/package/source/xstor/xstorage.cxx:4044: Problems on commit! context: 8OStorage warn:legacy.osl:25906:1:dbaccess/source/core/dataaccess/ModelImpl.cxx:804: ODatabaseModelImpl::commitRootStorage: could commit the storage! warn:legacy.osl:25906:1:dbaccess/source/core/dataaccess/databasecontext.cxx:495: ODatabaseContext::storeTransientProperties: a non-empty data source which I do not know?! [Thread 0x7fffd3fff700 (LWP 25917) exited] [Thread 0x7fff8ffff700 (LWP 26370) exited] [New Thread 0x7fff8ffff700 (LWP 26372)] [Thread 0x7fff8ffff700 (LWP 26372) exited] warn:tools.debug:25906:1:tools/source/debug/debug.cxx:1121: no DbgTestSolarMutex function set warn:tools.debug:25906:1:tools/source/debug/debug.cxx:1121: no DbgTestSolarMutex function set warn:tools.debug:25906:1:tools/source/debug/debug.cxx:1121: no DbgTestSolarMutex function set warn:tools.debug:25906:1:tools/source/debug/debug.cxx:1121: no DbgTestSolarMutex function set [Thread 0x7fff8cff9700 (LWP 26261) exited] [Thread 0x7fffdb7c3700 (LWP 25915) exited] [Thread 0x7fffd302c700 (LWP 25920) exited] [Thread 0x7fffba151700 (LWP 25942) exited] Program received signal SIGABRT, Aborted. 0x00007ffff74bdf77 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 56 ../nptl/sysdeps/unix/sysv/linux/raise.c: Aucun fichier ou dossier de ce type. I've opened bug 76179 for the DbgTestSolarMutex message. However, I don't like the look of the SIGABRT and the failed storage commit.
(gdb) bt full #0 0x00007ffff74bdf77 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 resultvar = 0 pid = 25906 selftid = 25906 #1 0x00007ffff74c15e8 in __GI_abort () at abort.c:90 save_stage = 2 act = {__sigaction_handler = {sa_handler = 0x0, sa_sigaction = 0x0}, sa_mask = {__val = {0, 140737488345520, 140737351945333, 5, 0, 140737332566208, 140737342135528, 0, 140737488345520, 1, 140737351972645, 335544382, 27530000, 0, 140737488345360, 27529952}}, sa_flags = -10416, sa_restorer = 0x7ffff75d0000 <__memcpy_ssse3+6784>} sigs = {__val = {32, 0 <repeats 15 times>}} #2 0x00007fffb2ad8e58 in (anonymous namespace)::cleanError (e=0x1a412e0) at ../src/common/classes/init.cpp:50 status = {1, 335544382, 2, 140736818580664, 0, 0, 140736197224416, 140737332566208, 0, 140737488345568, 1, 140737351972645, 27529920, 140737488345528, 1, 140736191107416, 27529920, 140737488344912, 140737332869900, 140737332869433} #3 0x00007fffb2ad917e in Firebird::InstanceControl::InstanceList::destructors () at ../src/common/classes/init.cpp:201 e = @0x1a412e0: {_vptr.Exception = 0x7fffb2fe86b0 <vtable for Firebird::status_exception+16>} i = 0x7fffd8141ce8 currentPriority = Firebird::InstanceControl::PRIORITY_REGULAR nextPriority = Firebird::InstanceControl::PRIORITY_REGULAR #4 0x00007fffb2ad9025 in Firebird::InstanceControl::destructors () at ../src/common/classes/init.cpp:178 No locals. #5 0x00007fffb2ad8e61 in (anonymous namespace)::allClean () at ../src/common/classes/init.cpp:61 No locals. #6 0x00007fffb2ad8eb1 in (anonymous namespace)::Cleanup::~Cleanup ( this=0x7fffb30ae7a9 <(anonymous namespace)::global>, __in_chrg=<optimized out>) at ../src/common/classes/init.cpp:89 No locals. #7 0x00007ffff74c3071 in __run_exit_handlers (status=0, listp=0x7ffff78486a8 <__exit_funcs>, run_list_atexit=run_list_atexit@entry=true) at exit.c:77 atfct = <optimized out> onfct = <optimized out> cxafct = <optimized out> f = <optimized out> #8 0x00007ffff74c30f5 in __GI_exit (status=<optimized out>) at exit.c:99 No locals. #9 0x00007ffff74a8dec in __libc_start_main (main=0x400925 <main>, argc=1, ubp_av=0x7fffffffdb58, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>, stack_end=0x7fffffffdb48) at libc-start.c:294 result = <optimized out> unwind_buf = {cancel_jmp_buf = {{jmp_buf = {0, -158779015703497496, 4196352, 140737488345936, 0, 0, 158779014519256296, 158762635155666152}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x400980 <__libc_csu_init>, 0x7fffffffdb58}, data = { prev = 0x0, cleanup = 0x0, canceltype = 4196736}}} not_first_call = <optimized out> #10 0x0000000000400829 in _start () No symbol table info available.
Adding self to CC if not already on
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT: - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
(In reply to ribotb from comment #9) > Hi Alex, > > In the list of formats that can be imported into a BLOB field, there is no > video format except MOV, there are only image formats. The presence of the > MOV format in the list seems incongruous and might be an error? > > I tried to import MOV video, but nothing appears in the control associated > in my form. > > I verified in my Firebird SQL Server 2.5, the video formats accepted are > only AVI and MPEG. > > Bernard Same thing with : Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 2; OS Version: Windows 6.1; UI Render: default; Locale : fr-FR (fr_FR) on Win7/x86 I agree with Alex : "... excluding video formats from the list of supported file types for that particular dialog ?" This format is not in Firebird SQL Server 2.5 and it is the only video format in the list in this Base dialog. Bernard
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Testing with Version: 6.2.0.0.alpha0+ Build ID: 7f3c2ee6c135773c98ded063bdf10ec8900bf00f CPU threads: 4; OS: Mac OS X 10.13.4; UI render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: group threaded still allows MOV files to be considered as an image and inserted into the database in a BLOB(Image) field, although nothing is displayed via the form control. Other video formats are greyed out and can not be inserted via the Finder/File Manager in this way. At least LO doesn't hang anymore, but the MOV mimetype can still be inserted, which is clearly wrong with regard to other video formats.
Dear Alex Thurgood, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
With the change to the BLOB management code, this now WFM
By WFM, I mean that I don't see any noticeable slowdown in navigating from one record to the next, and video file format inserts are permitted and stored in the database (although not visible or playable, but that wasn't the object of the original report)