Bug 10517

Summary: Не работает соединение через ODBC
Product: Sisyphus Reporter: Vitaly Lipatov <lav>
Component: openoffice.orgAssignee: Nobody's working on this, feel free to take it <nobody>
Status: CLOSED WORKSFORME QA Contact: qa-sisyphus
Severity: normal    
Priority: P2    
Version: unstable   
Hardware: all   
OS: Linux   
Attachments:
Description Flags
Лог падения при обращении к базе данных none

Description Vitaly Lipatov 2006-12-25 02:46:16 MSK
Пробую подключиться через ODBC. Настроил источник данных, выбрал.
В OpenOffice нажимаю "Таблицы", программа падает:
#
# An unexpected error has been detected by HotSpot Virtual Machine:
#
#  SIGSEGV (0xb) at pc=0x00000000, pid=23974, tid=3069494992
#
# Java VM: Java HotSpot(TM) Client VM (1.5.0_09-b01 mixed mode, sharing)
# Problematic frame:
# C  0x00000000
#
# An error report file with more information is saved as hs_err_pid23974.log
#
# If you would like to submit a bug report, please visit:
#   http://java.sun.com/webapps/bugreport/crash.jsp
Comment 1 Vitaly Lipatov 2006-12-25 02:49:24 MSK
Created attachment 1730 [details]
Лог падения при обращении к базе данных

Да, с ODBC вроде всё нормально:
$ rpm -q mysql-connector-odbc
mysql-connector-odbc-3.51-alt1
Comment 2 Vitaly Lipatov 2006-12-25 03:10:00 MSK
вот кусок strace до SegFault:
...
connect(35, {sa_family=AF_FILE, path="/var/lib/mysql/mysql.sock"}, 110) = 0
fcntl64(35, F_SETFL, O_RDWR)            = 0
setsockopt(35, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not 
supported)
setsockopt(35, SOL_SOCKET, SO_KEEPALIVE, [1], 4) = 0
poll([{fd=35, events=POLLIN, revents=POLLIN}], 1, 20000) = 1
setsockopt(35, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0", 8) = 0
read(35, "4\0\0\0\n5.0.27\0\v\0\0\0H_)K!`?[\0,\242\7\2\0\0\0"..., 16384) = 56
stat64("/usr/share/mysql/charsets/Index.xml", {st_mode=S_IFREG|0644, 
st_size=18221, ...}) = 0
open("/usr/share/mysql/charsets/Index.xml", O_RDONLY|O_LARGEFILE) = 37
read(37, "<?xml version=\'1.0\' encoding=\"ut"..., 18221) = 18221
close(37)                               = 0
setsockopt(35, SOL_SOCKET, SO_SNDTIMEO, "\2003\341\1\0\0\0\0", 8) = 0
write(35, "&\0\0\1E\242\2\0\0\0\0@\10\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 42) = 
42
setsockopt(35, SOL_SOCKET, SO_RCVTIMEO, "\2003\341\1\0\0\0\0", 8) = 0
read(35, "\7\0\0\2\0\0\0\2\0\0\0", 16384) = 11
gettimeofday({1167004826, 745960}, NULL) = 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 37
ioctl(37, SIOCGIFCONF, {64, {{"lo", {AF_INET, inet_addr("127.0.0.1")}}, 
{"eth0", {AF_INET, inet_addr("192.168.1.2")}}}}) = 0
close(37)                               = 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 37
ioctl(37, SIOCGIFFLAGS, {ifr_name="lo", ifr_flags=IFF_UP|IFF_LOOPBACK|
IFF_RUNNING}) = 0
close(37)                               = 0
socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 37
ioctl(37, SIOCGIFFLAGS, {ifr_name="eth0", ifr_flags=IFF_UP|IFF_BROADCAST|
IFF_RUNNING|IFF_MULTICAST}) = 0
ioctl(37, SIOCGIFHWADDR, {ifr_name="eth0", ifr_hwaddr=00:17:31:70:a9:0f}) = 0
close(37)                               = 0
mmap2(NULL, 65536, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xaea7a000
munmap(0xaea7a000, 65536)               = 0
mmap2(NULL, 65536, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 
0xaea7a000
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
Comment 3 Vitaly Lipatov 2006-12-25 03:15:54 MSK
/etc/odbcinst.ini:
[MySQL]
Description = ODBC for MySQL
Driver      = /usr/lib/libmyodbc3.so
#Setup      = /usr/lib/libodbcmyS.so
FileUsage   = 1
$ cat ~/.odbc.ini

[MySQL-test]
Description = MySQL test
Driver = MySQL
Server = localhost
Comment 4 Vitaly Lipatov 2007-01-16 23:14:22 MSK
После обновления из Сизифа заработало