Bug 75052

Summary: Queries not always returning any data
Product: LibreOffice Reporter: tim
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: normal CC: iplaw67, tim
Priority: medium    
Version: 4.2.0.4 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description tim 2014-02-16 12:54:25 UTC 
I have a Base application that I've been using for 2 or more years.  It has a number of dialogues that allow me to enter search data that selects data in queries to be returned in forms.

Recently the queries appear to be randomly returning no data at all for the first few attempts, and then working again using the same search criteria. This has never happened before.   I think it is somewhat worse when I use shorter abbreviations (to which * is appended). 

I'm on ubuntu 13.10, 64 bit, MariaDB 10.0.8.  Using MySql(Native) and MySql(JDBC) (I have tried both - the Native version seems a bit worse if anything).

It looks like some for of timeout or caching problem, but I can't reproduce the problem consistently enough to be sure where the problem is.  I have failed to get any errors querying using phpMyAdmin, but can't be entirely sure the problem is in Base.

I am not even sure when the problem first started, since I hadn't use the application for a few weeks.  It may be related to the recent LO version, or to a MariaDB update.

I'm reporting this in the hope someone else is having similar query problems with this version of Base.  It may be a wild goose chase....
Comment 1 tim 2014-03-10 20:24:21 UTC 
I have tried many things to resolve this issue.  It seems to be unstable.  With MySql(JDBC) and (now) MariaDB 5.6 it rarely happens, but I still seem to get it occasionally.  With MySQL(Native) it was occurring more frequently.  I'm now on LO 4.2.2.1 and it seems better.

Given that I'm using the Ubuntu PPA, if the problem is anywhere it's probably in the build of the MySql Connector, which as I understand it is not strictly part of LibreOffice, so I've closed this bug.
Comment 2 Alex Thurgood 2014-03-11 09:08:38 UTC 
@Tim : I've not noticed this on my own built versions from master connecting to a local mysql instance. My builds are also on Ubuntu-derived OS (Linux Mint 15 and 16, 64bit).

There was a problem with the native connector and MariaDB (libmariadb library) at one point, perhaps this is reflected in the PPA provided packages ?


Alex
Comment 3 Alex Thurgood 2014-03-11 09:10:04 UTC 
Note that I do not use MariaDB, my last attempts at doing so hosed my dbs, so I moved back to mysql.


Alex