date:20110727

Schema list

2011-07-27 Thread Anupam Karmarkar

There is one database name 'XYZ' on linux system, some one has mistakenly 
created new
database name with 'xYZ', database is created when I use 'xYZ' database, there 
are no
tables with SHOW TABLES, but when i run SHOW PROCEDURE STATUS it show 
procedures from 
'XYZ' database.
My concern is that if i drop new database created 'xYZ' will it drop procedures 
also 
listed from 'XYZ' database

Re: Schema list

2011-07-27 Thread Ananda Kumar

Is this a production setup.
If not, take complete dump of the all databases.
Drop the xYZ database, see if you can  see all the objects under XYZ.

Since the xYZ database is created, its obvious, that names are case
sensitive, and it show not show object from XYZ, when u under xYZ.

Can you please paste the results that your seeing.

regards
anandkl



On Wed, Jul 27, 2011 at 3:09 PM, Anupam Karmarkar
sb_akarmar...@yahoo.comwrote:

 There is one database name 'XYZ' on linux system, some one has mistakenly
 created new
 database name with 'xYZ', database is created when I use 'xYZ' database,
 there are no
 tables with SHOW TABLES, but when i run SHOW PROCEDURE STATUS it show
 procedures from
 'XYZ' database.
 My concern is that if i drop new database created 'xYZ' will it drop
 procedures also
 listed from 'XYZ' database

NoSQL to MySQL with Memcached

2011-07-27 Thread Daevid Vincent

http://dev.mysql.com/tech-resources/articles/nosql-to-mysql-with-memcached.h
tml

System Reboot while mysqldump

2011-07-27 Thread Adarsh Sharma


Dear all,

Today I got stucked  around a strange problem.
Don't know why me linux reboot automatically.

*Server Info :
*Linux Server-5 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 
x86_64 x86_64 x86_64 GNU/Linux

Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r (\l).

Mysql version is  mysql  Ver 14.12 Distrib 5.0.45, for unknown-linux-gnu 
(x86_64) using readline 5.0


I researched a lot  try to find the reasons :

Last time Reboot :-
reboot   system boot  2.6.16.46-0.12-s Thu Jul 28 10:33  
(00:06)   


I read my /var/log/messages but not able to find any pointers for that.
I attached the file too.


Thanks



Jul 28 09:53:25 Server-5 nmbd[2609]:   *
Jul 28 09:58:44 Server-5 sshd[6938]: Accepted keyboard-interactive/pam for 
varsha from port 33193 ssh2
Jul 28 09:59:07 Server-5 sshd[6989]: Accepted keyboard-interactive/pam for 
isha.garg from port 50208 ssh2
Jul 28 10:01:08 Server-5 sshd[7086]: Accepted keyboard-interactive/pam for 
pankaj.kumari from 11.11.11.11 port 40576 ssh2
Jul 28 10:01:17 Server-5 sshd[7113]: Accepted keyboard-interactive/pam for 
pankaj.kumari from 11.11.11.11 port 40587 ssh2
Jul 28 10:01:44 Server-5 sshd[7142]: Accepted keyboard-interactive/pam for 
pankaj.kumari from 11.11.11.11 port 40602 ssh2
Jul 28 10:02:07 Server-5 sshd[7170]: Accepted keyboard-interactive/pam for 
pankaj.kumari from 11.11.11.11 port 40639 ssh2
Jul 28 10:02:50 Server-5 sshd[7245]: Accepted keyboard-interactive/pam for root 
from 11.11.11.11 port 53912 ssh2
Jul 28 10:25:36 Server-5 sshd[7439]: Accepted keyboard-interactive/pam for 
pankaj.kumari from 11.11.11.11 port 45834 ssh2
Jul 28 10:27:35 Server-5 kernel: ata4: CPB flags CMD err, flags=0x11
Jul 28 10:28:35 Server-5 kernel: ata4: EH in ADMA mode, notifier 0x0 
notifier_error 0x0 gen_ctl 0x1501000 status 0x400
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 0: ctl_flags 0x1f, resp_flags 0x0
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 1: ctl_flags 0x1f, resp_flags 0x11
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 2: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 3: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 4: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 5: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 6: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 7: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 8: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 9: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 10: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 11: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 12: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 13: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 14: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 15: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 16: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 17: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 18: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 19: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 20: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 21: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 22: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 23: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 24: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 25: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 26: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 27: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 28: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 29: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: CPB 30: ctl_flags 0x1f, resp_flags 0x1
Jul 28 10:28:35 Server-5 kernel: ata4: Resetting port
Jul 28 10:28:35 Server-5 kernel: ata4.00: exception Emask 0x0 SAct 0x3 SErr 0x0 
action 0x2 frozen
Jul 28 10:28:35 Server-5 kernel: ata4.00: cmd 
60/00:00:c7:22:5e/04:00:2e:00:00/40 tag 0 cdb 0x0 data 524288 in
Jul 28 10:28:35 Server-5 kernel:  res 
40/00:00:00:00:00/00:00:00:00:00/00 Emask 0x4 (timeout)
Jul 28 10:28:35 Server-5 kernel: ata4.00: cmd 
60/00:08:c7:1e:5e/04:00:2e:00:00/40 tag 1 cdb 0x0 data 524288 in
Jul 28 10:28:35 Server-5 kernel:  res 
41/00:08:c7:1e:5e/00:00:00:00:00/40 Emask 0x1 (device error)
Jul 28 10:28:35 Server-5 kernel: ata4: soft resetting port
Jul 28 10:28:35 Server-5 kernel: ata4: SATA link up 3.0 Gbps (SStatus 123 
SControl 300)
Jul 28 10:28:35

Re: System Reboot while mysqldump

2011-07-27 Thread Adarsh Sharma


Thanks Jon,

I couldn't locate my error.log.

But i found one clue :
My server reboots at :

reboot   system boot  2.6.16.46-0.12-s Thu Jul 28 10:32  (00:24)   
reboot   system boot  2.6.16.46-0.12-s Wed Jul 27 18:47  (16:10)   
reboot   system boot  2.6.16.46-0.12-s Wed Jul 27 17:40  (17:17)   
reboot   system boot  2.6.16.46-0.12-s Wed Jul 27 16:58  (17:59)   
reboot   system boot  2.6.16.46-0.12-s Wed Jul 27 16:41  (00:14)   
reboot   system boot  2.6.16.46-0.12-s Tue Jul 26 10:50 (1+06:05) 


And below shows that

Server-5:/var/log # grep CPU /var/log/messages | more

Jul 25 10:54:31 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 26 10:52:04 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 27 16:42:43 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 27 16:58:57 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 27 17:41:09 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 27 18:47:55 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.
Jul 28 10:33:49 Server-5 rcpowersaved: enter 'powernow_k8' into 
CPUFREQD_MODULE in /etc/powersave/cpufreq.


I tried to find its explaination.

jon.siebe...@gmail.com wrote:

anything in error log by chance?

On Jul 28, 2011 1:07am, Adarsh Sharma adarsh.sha...@orkash.com wrote:





 Dear all,



 Today I got stucked  around a strange problem.

 Don't know why me linux reboot automatically.



 Server Info :

 Linux Server-5 2.6.16.46-0.12-smp #1 SMP Thu May 17 14:00:09 UTC
 2007 x86_64 x86_64 x86_64 GNU/Linux

 Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r
 (\l).



 Mysql version is  mysql  Ver 14.12 Distrib 5.0.45, for
 unknown-linux-gnu (x86_64) using readline 5.0



 I researched a lot  try to find the reasons :



 Last time Reboot :-

  reboot   system boot  2.6.16.46-0.12-s Thu Jul 28 10:33 
 (00:06)   




 I read my /var/log/messages but not able to find any pointers for that.

 I attached the file too.





 Thanks








 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Schema list

Re: Schema list

NoSQL to MySQL with Memcached

System Reboot while mysqldump

Re: System Reboot while mysqldump

5 matches

Site Navigation

Mail list logo

Footer information