Re: problem with 4.0.18

2004-03-01 Thread Sasha Pachev
Andrea Riela wrote:
Andrea Riela wrote:

Could you help me?


well, I've tryed with ktrace, see my kdump:

http://www.nesys.it/kdump
Andrea:

Could you ktrace mysqld itself rather than mysqld_safe ?

--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


RE: problem with 4.0.18

2004-02-28 Thread Andrea Riela
Andrea Riela wrote:
 Could you help me?

well, I've tryed with ktrace, see my kdump:

http://www.nesys.it/kdump

It's possible, a pid file problem?
thanks for your support
Regards
Andrea


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: problem with 4.0.18

2004-02-27 Thread Andrea Riela
well,

I've reinstall from pkg.
My sys: openbsd 3.3
Mysql: 4.0.18

When I try to start the server:

mysqld_safe --user=_mysqld 

I receive that:

observe# mysqld_safe --user=_mysql 
[1] 6694
observe# Abort 
Abort 
Starting mysqld daemon with databases from /var/mysql
040227 17:38:56  mysqld ended

I've checked my error log:

040227 17:12:44  mysqld started
Abort
040227 17:12:45  mysqld ended

Well, where is my mistake?

I've tryed as --user=root, the same.
I've tryed to set the shlib dir too in my rc.conf:

shlib_dirs=$shlib_dirs /usr/local/lib/mysql

Nothing.
Could you help me?
thanks for support
Regards
Andrea


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: problem with 4.0.18

2004-02-26 Thread Sasha Pachev
Andrea Riela wrote:
Hi folks,

my system: openbsd 3.3
mysql ver: 4.0.18
Well, I was working on phpBB conf, when I've seen errors from mysql:

mysql use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'columns_priv'
Didn't find any fields in table 'db'
Didn't find any fields in table 'func'
Didn't find any fields in table 'host'
Didn't find any fields in table 'tables_priv'
Didn't find any fields in table 'user'
Database changed
mysql select * from user;
ERROR 1105: File './mysql/user.MYD' not found (Errcode: 9)
But I've all as before:

/usr/local/mysql/var:
observe# ls
cacti   ib_logfile1 newsys
observe.nesys.it.pid
ib_arch_log_00  ibdata1 observe.log
training
ib_logfile0 mysql   observe.nesys.it.err
Error 9 is a bad file descriptor. The most probable cause of this is a bad 
build, or library incompatibility. If you built your own binary, try using the 
one provided by MySQL AB. If you were using theirs, try building your own.

--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]