>Description:
In testing a script that I want to put in a cron, the mysqld keeps crashing eachtime I
run the script to test it. I've tried substituting in raw numbers for the variables
in the script, but to no avail. In attempting to troubleshoot, I logged onto the
monitor and could duplicate the problem with simple entries.
I can provide any information required. :)
Offending Lines in Script:
$setdate = $pingsdb->query("insert into sla(date) values('$date')");
$input = $pingsdb->query("update sla set avail1='$availability{1}' and
packet1='$packetloss{1}' and resp1='$response{1}' where date='$date'");
Script Output:
DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172.
MYSQL Logs:
/usr/libexec/ld-elf.so.1:
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld:
Undefined symbol "strtoll"
010614 20:32:21 mysqld restarted
010614 20:32:21 Warning: setrlimit returned ok, but didn't change limits. Max open
files is 1640
010614 20:32:21 Warning: Changed limits: max_connections: 500 table_cache: 565
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld: ready
for connections
>How-To-Repeat:
Offending Lines in Script:
$setdate = $pingsdb->query("insert into sla(date) values('$date')");
$input = $pingsdb->query("update sla set avail1='$availability{1}' and
packet1='$packetloss{1}' and resp1='$response{1}'");
MYSQL Logs:
/usr/libexec/ld-elf.so.1:
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld:
Undefined symbol "strt
oll"
010614 20:32:21 mysqld restarted
010614 20:32:21 Warning: setrlimit returned ok, but didn't change limits. Max open
files is 1640
010614 20:32:21 Warning: Changed limits: max_connections: 500 table_cache: 565
/usr/local/bin/new_mysql/mysql-3.23.38-unknown-freebsdelf4.3-i386/bin/mysqld: ready
for connections
mysql> describe sla;
+---------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------+------+-----+---------+-------+
| date | date | YES | | NULL | |
| avail0 | float(6,2) | YES | | NULL | |
| packet0 | float(6,2) | YES | | NULL | |
| resp0 | float(6,2) | YES | | NULL | |
| avail1 | float(6,2) | YES | | NULL | |
| packet1 | float(6,2) | YES | | NULL | |
| resp1 | float(6,2) | YES | | NULL | |
| avail2 | float(6,2) | YES | | NULL | |
| packet2 | float(6,2) | YES | | NULL | |
| resp2 | float(6,2) | YES | | NULL | |
| avail3 | float(6,2) | YES | | NULL | |
| packet3 | float(6,2) | YES | | NULL | |
| resp3 | float(6,2) | YES | | NULL | |
| avail4 | float(6,2) | YES | | NULL | |
| packet4 | float(6,2) | YES | | NULL | |
| resp4 | float(6,2) | YES | | NULL | |
+---------+------------+------+-----+---------+-------+
16 rows in set (0.00 sec)
mysql> insert into sla(avail0,packet0,resp0) values('99.9965','100','38.090643');
Query OK, 1 row affected (0.01 sec)
mysql> update sla set avail1='99.9965' and packet1='100' and resp1='38.090643';
ERROR 2013: Lost connection to MySQL server during query
>Fix:
>Submitter-Id: <submitter ID>
>Originator: James Mackenzie
>Organization:
>MySQL support: none
>Synopsis: MySQLd crashes when perl script attempts to update table
>Severity: critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.32 (Source distribution)
>Environment:
I'm using the standard build of mysql and perl.
System: FreeBSD tactoo.dco.psi.ca 4.2-RELEASE FreeBSD 4.2-RELEASE #0: Wed Jan 24
16:14:54 EST 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/TACTOO i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock
--with-low-memory --with-mit-threads=yes
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
