Quantcast

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

hakan UNVER reported a new bug.

Summary
-------

MYSQL_OPT_RECONNECT option

Type             : Bug
Priority         : Medium
Gambas version   : Unknown
Product          : Unknown


Description
-----------

when lost mysql server connection no have any timeout And not work any timers or etc, not respond.Because endless loop
I think need update this option.. optional or break option or try time out limit.


System information
------------------

[System]
Gambas=3.9.2
OperatingSystem=Linux
Kernel=4.4.0-62-generic
Architecture=x86_64
Distribution=Linux Mint 18.1 Serena
Desktop=CINNAMON
Theme=Gtk
Language=en_US.UTF-8
Memory=5764M

[Libraries]
Cairo=libcairo.so.2.11502.0
Curl=libcurl.so.4.4.0
DBus=libdbus-1.so.3.14.6
GStreamer=libgstreamer-0.10.so.0.30.0
GStreamer=libgstreamer-1.0.so.0.802.0
GTK+2=libgtk-x11-2.0.so.0.2400.30
GTK+3=libgtk-3.so.0.1800.9
OpenGL=libGL.so.1.2.0
Poppler=libpoppler.so.58.0.0
QT4=libQtCore.so.4.8.7
QT5=libQt5Core.so.5.5.1
SDL=libSDL-1.2.so.0.11.4
SQLite=libsqlite3.so.0.8.6

[Environment]
CINNAMON_VERSION=3.2.6
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-B6EiNEkmBf,guid=78197f6f5f45ac633fdc7ead58cd61b3
DEFAULTS_PATH=/usr/share/gconf/cinnamon.default.path
DESKTOP_SESSION=cinnamon
DISPLAY=:0
GB_GUI=gb.qt4
GDMSESSION=cinnamon
GDM_XSERVER_LOCATION=local
GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
GIO_LAUNCHED_DESKTOP_FILE_PID=1721
GJS_DEBUG_OUTPUT=stderr
GJS_DEBUG_TOPICS=JS ERROR;JS LOG
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GTK_MODULES=gail:atk-bridge
GTK_OVERLAY_SCROLLING=1
HOME=<home>
LANG=en_US.UTF-8
LC_ADDRESS=tr_TR.UTF-8
LC_IDENTIFICATION=tr_TR.UTF-8
LC_MEASUREMENT=tr_TR.UTF-8
LC_MONETARY=tr_TR.UTF-8
LC_NAME=tr_TR.UTF-8
LC_NUMERIC=tr_TR.UTF-8
LC_PAPER=tr_TR.UTF-8
LC_TELEPHONE=tr_TR.UTF-8
LOGNAME=<user>
MANDATORY_PATH=/usr/share/gconf/cinnamon.mandatory.path
MDMSESSION=cinnamon
MDM_LANG=en_US.UTF-8
MDM_XSERVER_LOCATION=local
PATH=<home>/bin:<home>/.local/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games
PWD=<home>
QT_ACCESSIBILITY=1
QT_LINUX_ACCESSIBILITY_ALWAYS_ON=1
QT_QPA_PLATFORMTHEME=qgnomeplatform
QT_STYLE_OVERRIDE=gtk
SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1411,unix/<hostname>:/tmp/.ICE-unix/1411
SHELL=/bin/bash
SSH_AGENT_PID=1480
SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
TZ=:/etc/localtime
USER=<user>
USERNAME=<user>
WINDOWPATH=8
XAUTHORITY=<home>/.Xauthority
XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
XDG_CURRENT_DESKTOP=X-Cinnamon
XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:/usr/local/share/:/usr/share/:/usr/share/mdm/
XDG_RUNTIME_DIR=/run/user/1000
XDG_SEAT=seat0
XDG_SESSION_COOKIE=5ab3c275b7304ed3b8aeef9ffcc37eb4-1489854899.169491-1087647094
XDG_SESSION_DESKTOP=cinnamon
XDG_SESSION_ID=c1
XDG_VTNR=8



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #1 by PICCORO LENZ MCKAY:

if this happen in mysql, maybe odbc and postgres must! taking in consideration that odbc interacts with many other, the recconect ption could relly in the odbc driver, but in postgres case must be check too!



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: [Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

zxMarce
In reply to this post by bugtracker
(english below)

ODBC en realidad no es en sí un driver, sino un administrador de drivers. Lo que hace en la práctica es ofrecer a programas una interfase lo más unificada posible para que solamente cambiando el driver subyacente se pueda usar ese mismo programa con diversos motores de bases de datos. Con esto lo que quiero decir es que puede haber opciones de algunos motores que no existan en otros y por lo tanto pese a usar ODBC no se puedan hacer compatibles.

ODBC is not a DBdriver per se, but a driver manager; what it does is offer programs an interface as uniform as possible so by only changing the underlying driver a program can be used against different RDBMs.
What I mean with all this is that some options may exist in a particular RDBM that is not available in others and that this issue is not solved simply by using ODBC, yielding programs using those features incompatible with other RDBMs.

Regards,
zxMarce.

On Mar 18, 2017, 16:09, at 16:09, [hidden email] wrote:

>http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-
>
>Comment #1 by PICCORO LENZ MCKAY:
>
>if this happen in mysql, maybe odbc and postgres must! taking in
>consideration that odbc interacts with many other, the recconect ption
>could relly in the odbc driver, but in postgres case must be check too!
>
>
>
>------------------------------------------------------------------------------
>Check out the vibrant tech community on one of the world's most
>engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>_______________________________________________
>Gambas-user mailing list
>[hidden email]
>https://lists.sourceforge.net/lists/listinfo/gambas-user
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #2 by PICCORO LENZ MCKAY:

anwered to: 2017-03-18 16:28 GMT-04:00  <[hidden email]>: in mail list

> yes, ODBC is not a DBdriver per se, but a driver manager; what it does is offer programs an interface as uniform as possible so by only changing the underlying driver a program can be used against different RDBMs.
> What I mean with all this is that some options may exist in a particular RDBM that is not available in others and that this issue is not solved simply by using ODBC, yielding programs using those features incompatible with other RDBMs.

yes, i write bad, i must said: "relly in the background DBMS"..

and zxMarce. u must answer in the bugtraker, if the mail comes from the bugracker, the bugtraker will delivery to the mail list alter.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #3 by hakan UNVER:

I think anyway update MYSQL_OPT_RECONNECT option.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #4 by Benoît MINISINI:

Sorry, I don't understand what you are talking about. Can you try with a better english please? Thanks.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #5 by hakan UNVER:

Hii Benoit I mean;
when lost mysql server connection no have any timeout, And dont work any timers or process programm is  like frezee not respond.Because endless loop
I think need update this option.. optional or break option or try connection  time out limit..



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[Gambas Bug Tracker] Bug #1091: MYSQL_OPT_RECONNECT option

bugtracker
In reply to this post by bugtracker
http://gambaswiki.org/bugtracker/edit?object=BUG.1091&from=L21haW4-

Comment #6 by Benoît MINISINI:

I still do not understand your English. Try to find a friend that can help you for that

Anyway, the MYSQL_OPT_RECONNECT option is automatically set when you use the gb.db.mysql database driver. No idea why people are talking about ODBC...

And you have a Timeout property in the Connection object to define the MySQL connection timemout.



------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Gambas-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gambas-user
Loading...