2012-10-02 16:58:16 |
Dmitriy Alexandrov |
bug |
|
|
added bug |
2012-10-02 16:58:16 |
Dmitriy Alexandrov |
attachment added |
|
16_fix_mysql_load_data.patch https://bugs.launchpad.net/bugs/1060320/+attachment/3365603/+files/16_fix_mysql_load_data.patch |
|
2012-10-02 16:59:52 |
Dmitriy Alexandrov |
netams (Ubuntu): status |
New |
Fix Released |
|
2012-10-02 16:59:52 |
Dmitriy Alexandrov |
netams (Ubuntu): assignee |
|
Dmitriy Alexandrov (d06alexandrov) |
|
2012-10-02 17:06:20 |
Dmitriy Alexandrov |
description |
I'm using MySQL database as "service storage".
But netams does not save information to database and writes to log:
02.10.2012 20:22:33.8491 storage:1 [WARN]: mysql DB:1 connection to database net
02.10.2012 20:22:33.8497 storage:1 [WARN]: SQL Load data: Malformed packet
02.10.2012 20:22:33.8497 storage:1 [WARN]: mysql show command failed: Lost conne
02.10.2012 20:22:33.8498 storage:1 [WARN]: mysql show command failed: MySQL serv
02.10.2012 20:22:33.8498 storage:1 [WARN]: Failed load data into sql for raw try
At the same time, MySQL writes to log:
121002 20:22:33 99 Connect netams@localhost on netams
99 Query show tables like 'raw'
99 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.raw' INTO TABLE raw FIELDS TERMINATED BY ','
100 Connect netams@localhost on netams
100 Query show tables like 'summary'
100 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.sum' REPLACE INTO TABLE summary FIELDS TERMINATED BY ','
And according to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html), this bug can be fixed by setting in program "MYSQL_OPT_LOCAL_INFILE" option to "true".
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: netams 3.4.5-2ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic 3.2.28
Uname: Linux 3.2.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Tue Oct 2 20:37:17 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: netams
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.netams: [modified]
mtime.conffile..etc.default.netams: 2012-10-02T20:07:05 |
I'm using MySQL database as "service storage".
But netams does not save information to database and writes to log:
02.10.2012 20:22:33.8491 storage:1 [WARN]: mysql DB:1 connection to database net
02.10.2012 20:22:33.8497 storage:1 [WARN]: SQL Load data: Malformed packet
02.10.2012 20:22:33.8497 storage:1 [WARN]: mysql show command failed: Lost conne
02.10.2012 20:22:33.8498 storage:1 [WARN]: mysql show command failed: MySQL serv
02.10.2012 20:22:33.8498 storage:1 [WARN]: Failed load data into sql for raw try
At the same time, MySQL writes to log:
121002 20:22:33 99 Connect netams@localhost on netams
99 Query show tables like 'raw'
99 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.raw' INTO TABLE raw FIELDS TERMINATED BY ','
100 Connect netams@localhost on netams
100 Query show tables like 'summary'
100 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.sum' REPLACE INTO TABLE summary FIELDS TERMINATED BY ','
And according to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html), this bug can be fixed by setting in program "MYSQL_OPT_LOCAL_INFILE" option to "true".
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: netams 3.4.5-2ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic 3.2.28
Uname: Linux 3.2.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Tue Oct 2 20:37:17 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: netams
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.netams: [modified]
mtime.conffile..etc.default.netams: 2012-10-02T20:07:05 |
|
2012-10-02 17:11:34 |
Dmitriy Alexandrov |
description |
I'm using MySQL database as "service storage".
But netams does not save information to database and writes to log:
02.10.2012 20:22:33.8491 storage:1 [WARN]: mysql DB:1 connection to database net
02.10.2012 20:22:33.8497 storage:1 [WARN]: SQL Load data: Malformed packet
02.10.2012 20:22:33.8497 storage:1 [WARN]: mysql show command failed: Lost conne
02.10.2012 20:22:33.8498 storage:1 [WARN]: mysql show command failed: MySQL serv
02.10.2012 20:22:33.8498 storage:1 [WARN]: Failed load data into sql for raw try
At the same time, MySQL writes to log:
121002 20:22:33 99 Connect netams@localhost on netams
99 Query show tables like 'raw'
99 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.raw' INTO TABLE raw FIELDS TERMINATED BY ','
100 Connect netams@localhost on netams
100 Query show tables like 'summary'
100 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.sum' REPLACE INTO TABLE summary FIELDS TERMINATED BY ','
And according to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html), this bug can be fixed by setting in program "MYSQL_OPT_LOCAL_INFILE" option to "true".
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: netams 3.4.5-2ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic 3.2.28
Uname: Linux 3.2.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Tue Oct 2 20:37:17 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: netams
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.netams: [modified]
mtime.conffile..etc.default.netams: 2012-10-02T20:07:05 |
[IMPACT]
I'm using MySQL database as "service storage".
But netams does not save information to database and writes to log:
02.10.2012 20:22:33.8491 storage:1 [WARN]: mysql DB:1 connection to database net
02.10.2012 20:22:33.8497 storage:1 [WARN]: SQL Load data: Malformed packet
02.10.2012 20:22:33.8497 storage:1 [WARN]: mysql show command failed: Lost conne
02.10.2012 20:22:33.8498 storage:1 [WARN]: mysql show command failed: MySQL serv
02.10.2012 20:22:33.8498 storage:1 [WARN]: Failed load data into sql for raw try
At the same time, MySQL writes to log:
121002 20:22:33 99 Connect netams@localhost on netams
99 Query show tables like 'raw'
99 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.raw' INTO TABLE raw FIELDS TERMINATED BY ','
100 Connect netams@localhost on netams
100 Query show tables like 'summary'
100 Query LOAD DATA CONCURRENT LOCAL INFILE 'storage.1.sum' REPLACE INTO TABLE summary FIELDS TERMINATED BY ','
And according to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/load-data-local.html), this bug can be fixed by setting in program "MYSQL_OPT_LOCAL_INFILE" option to "true".
[TESTCASE]
Using of MySQL database as "service storage", for example "service storage" config in file /etc/netams/netams.conf:
service storage 1
type mysql
host "localhost"
user "netams"
password "password"
dbname "netams"
socket "/var/run/mysqld/mysqld.sock"
[Other Info]
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: netams 3.4.5-2ubuntu2
ProcVersionSignature: Ubuntu 3.2.0-31.50-generic 3.2.28
Uname: Linux 3.2.0-31-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu13
Architecture: amd64
Date: Tue Oct 2 20:37:17 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
ProcEnviron:
TERM=xterm
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: netams
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.netams: [modified]
mtime.conffile..etc.default.netams: 2012-10-02T20:07:05 |
|
2012-10-02 18:29:36 |
Julian Taylor |
nominated for series |
|
Ubuntu Precise |
|
2012-10-02 18:29:36 |
Julian Taylor |
bug task added |
|
netams (Ubuntu Precise) |
|
2012-10-02 19:04:09 |
Dmitriy Alexandrov |
netams (Ubuntu Precise): status |
New |
Fix Released |
|
2012-10-02 19:04:45 |
Dmitriy Alexandrov |
netams (Ubuntu): status |
Fix Released |
New |
|
2012-10-02 19:05:47 |
Dmitriy Alexandrov |
attachment added |
|
netams.debdiff https://bugs.launchpad.net/ubuntu/+source/netams/+bug/1060320/+attachment/3366112/+files/netams.debdiff |
|
2012-10-02 19:06:59 |
Dmitriy Alexandrov |
bug |
|
|
added subscriber Ubuntu Sponsors Team |
2012-10-02 19:07:18 |
Dmitriy Alexandrov |
bug |
|
|
added subscriber Ubuntu Stable Release Updates Team |
2012-10-02 19:08:23 |
Dmitriy Alexandrov |
bug |
|
|
added subscriber Iain Lane |
2012-10-03 09:22:24 |
Dimitri John Ledkov |
nominated for series |
|
Ubuntu Quantal |
|
2012-10-03 09:22:24 |
Dimitri John Ledkov |
bug task added |
|
netams (Ubuntu Quantal) |
|
2012-10-03 09:22:31 |
Dimitri John Ledkov |
netams (Ubuntu Quantal): status |
New |
Invalid |
|
2012-10-03 09:22:34 |
Dimitri John Ledkov |
netams (Ubuntu Precise): status |
Fix Released |
Confirmed |
|
2012-10-03 09:22:49 |
Dimitri John Ledkov |
netams (Ubuntu Precise): importance |
Undecided |
High |
|
2012-10-08 13:10:26 |
Martin Pitt |
netams (Ubuntu Precise): status |
Confirmed |
In Progress |
|
2012-10-08 13:10:47 |
Martin Pitt |
removed subscriber Ubuntu Sponsors Team |
|
|
|
2012-11-07 23:02:58 |
Clint Byrum |
netams (Ubuntu Precise): status |
In Progress |
Fix Committed |
|
2012-11-07 23:03:02 |
Clint Byrum |
bug |
|
|
added subscriber SRU Verification |
2012-11-07 23:03:06 |
Clint Byrum |
tags |
amd64 apport-bug precise running-unity |
amd64 apport-bug precise running-unity verification-needed |
|
2012-11-08 00:30:17 |
Launchpad Janitor |
branch linked |
|
lp:ubuntu/precise-proposed/netams |
|
2012-11-10 17:20:14 |
Dmitriy Alexandrov |
tags |
amd64 apport-bug precise running-unity verification-needed |
amd64 apport-bug precise running-unity verification-done |
|
2012-11-15 01:05:18 |
Clint Byrum |
removed subscriber Ubuntu Stable Release Updates Team |
|
|
|
2012-11-15 01:06:11 |
Launchpad Janitor |
netams (Ubuntu Precise): status |
Fix Committed |
Fix Released |
|