[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added CC||kexi-b...@kde.org -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Status|RESOLVED|CLOSED --- Comment #14 from Jarosław Staniek --- Super cool. Thanks. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #13 from Simeon Kuran --- I tested the master branch with Kexi. Now it works ! :) -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Version Fixed In||3.0.1 -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #12 from Jarosław Staniek --- OK Simeon, are you able to test the 3.0 and/or master branch? Thanks. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Resolution|--- |FIXED Latest Commit||http://commits.kde.org/kdb/ ||8f1a6ce31b7d12199669bff0eff ||b5925115663a4 Status|ASSIGNED|RESOLVED --- Comment #11 from Jarosław Staniek --- Git commit 8f1a6ce31b7d12199669bff0effb5925115663a4 by Jaroslaw Staniek. Committed on 25/10/2016 at 18:01. Pushed by staniek into branch 'master'. Fix database cursors for PostgreSQL: remove use of uninitialized variable M +0-2src/KDbCursor.h M +1-1src/drivers/postgresql/PostgresqlCursor.cpp http://commits.kde.org/kdb/8f1a6ce31b7d12199669bff0effb5925115663a4 -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #10 from Simeon Kuran --- Wow, I'm glad to hear that! Good work! Thanks for your engagement :) -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Target Milestone|--- |3.0.1 -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Resolution|WAITINGFORINFO |--- Ever confirmed|0 |1 Status|NEEDSINFO |ASSIGNED --- Comment #9 from Jarosław Staniek --- Good news. We had uninitialized variable just for the PostgreSQL driver. Will be fixed today in master and 3.0 git branch so you can get it immediately. And it will go to the 3.0.1 release. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #8 from Simeon Kuran --- I tried Kexi with SQLite and MySQL now and they both worked! The error happens only with the PostgreSQL plugin! Also I tried using KEXI_COMPATIBLE = true in my app, but that didn't change anything. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #7 from Jarosław Staniek --- Thanks for the report. Binaries are not needed, at least I don't use them. Before we find solution could you please try: 1. to use the SQLite db type for your work 2. to use the MySQL db type for your work And tell me if you encounter any issues. Please also try in you app KEXI_COMPATIBLE == true at https://bitbucket.org/simeonKuran/kdb-test/src/5098cbad5d0a95694102fda03ab734cc6298fd7b/connection_widget.cpp?at=master&fileviewer=file-view-default -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331
--- Comment #6 from Simeon Kuran ---
No, I don't think so!
Most of the time, the error occurs far before executing the SQL SELECT
statement!
I have to admit, that it's hard to debug, because sometimes all works as it
should. I needed several attempts too, but then I got the following error on
console:
"using database failed: KDbResult: OK"
When executing the following piece of code:
bool cancelled;
bool ok = m_connection->useDatabase(database, KEXI_COMPATIBLE, &cancelled);
if (ok)
{
qDebug() << "using DB '" << database << "'." << endl;
emit databaseAvailable(database);
}
else
{
qDebug() << "using database failed: " << m_connection->result();
}
In Kexi the situation is much worse: Opening a project only works by a chance
of 1 to 5 or so... (the other 4 times it fails with different error messages).
I am quite sure this is because Kexi of course fires much more PostgreSql / DB
commands and one or the other just fails.
Shall I add my Kexi binaries to the git repo too? Maybe it would be interesting
whether you can see the described effects too with it? Though I know that
I didn't set up KReport correctly, but at the moment I don't need it and I am
sure it doesn't affect this error. In Kexi such DB errors show up quite
frequently when I create a new project, add some simple tables, store the
project and then try to reopen it.
I know this comment sounds a bit like if my incomplete setup of Kexi causes the
error, but I am quite sure that's not the case. I am very convinced, that the
error happens in KDb (at least in my self compiled KDb version. I don't want to
blame KDb for it though. I can not / and don't want to exclude, that I simply
did something wrong! )
Thanks for your efforts!
--
You are receiving this mail because:
You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #5 from Jarosław Staniek --- > sometimes one or the other DB calls seem to fail. Is this KDbConnection::executeQuery() maybe? On failure I recommend to use qDebug() << m_connection->result() so we know what happens. Similarly, KDbCursor also has result() method. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #4 from Simeon Kuran --- I just finished cleaning up my project and uploaded it to my bitbucket account. I also added a zip archive (kdb-test-binary) which contains the compiled executable with all necessary dll files (except msvc runtime dlls). (size of the zip archive is probably to big for email...) to get it: git clone g...@bitbucket.org:simeonKuran/kdb-test.git IMPORTANT: I need to point out once more, that sometimes everything works as expected! But sometimes one or the other DB calls seem to fail. Kind of non-deterministic it seems to me... Of course to try it out, you will need a postgresql DB. I think I installed version 9.5.4 - 64bit from this link: http://www.enterprisedb.com/products-services-training/pgdownload#windows -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #3 from Jarosław Staniek --- Simeon, you can also quickly email me zipped files, no problem. -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 --- Comment #2 from Simeon Kuran --- I thought so... I will upload it to some git repo, but I will need some time! Hopefully I can do it on the weekend... -- You are receiving this mail because: You are watching all bug changes.
[KDb] [Bug 371331] database calls randomly fail on Windows 10 (postgresql)
https://bugs.kde.org/show_bug.cgi?id=371331 Jarosław Staniek changed: What|Removed |Added Status|UNCONFIRMED |NEEDSINFO Resolution|--- |WAITINGFORINFO --- Comment #1 from Jarosław Staniek --- Thanks Simeon. It would help if you link to your test app's code and place where it fails. Having more public test apps is always a good idea. -- You are receiving this mail because: You are watching all bug changes.
