Mysqlds can be stopped by issuing the command “mysqladmin -u root -h 127. The rest of the Cluster can be stopped with “ndb_mgm -e shutdown”. 1 -P3306 shutdown” and can be started with “mysqld –defaults-file=xxxxx”. You can safely start ndb_mgmds with the –initial option every time but if you do that for data nodes then all of your data will be deleted.
2) lsof doesn’t work from zone (More on zones in solaris 10 coming soon), You have to install lsof on global zone. If you run lsof and get error message like “lsof: can’t stat(/devices): No such file or directory” probably you are running lsof with in solaris 10 Zone.
Now i am facing new issue wherein when i run bin/mysql -h 10. 173 -P 3306 i am getting following error :
ERROR 1130 (HY000): Host ‘10. Thank you sir, the error has been resolved. Please help me with this. 173’ is not allowed to connect to this MySQL server.
Bit of a needle and haystack thing, but maybe it’ll help someone. It’s not ideal, but if you use sysinternals Process Explorer you can go to specific processes’ properties and look at the TCP tab to see if they’re using the port you’re interested in.
Lsof -i :25 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME exim4 2799 Debian-exim 3u IPv4 6645 0t0 TCP localhost:smtp (LISTEN) . On Linux, you must be root or the other user to get process information for processes running as other users, so prepending sudo is most of what you need.
He has been using Linux from last 5 years. Raghu is working as Linux Server Administrator in Acknown Technologies Pvt. He completed his RHCE certification in 2009. He likes to read about Linux and other Open Source Technologies and write articles on these.
120816 7:27:51 InnoDB: Initializing buffer pool, size = 8. Please run mysql_upgrade to create it. InnoDB: Reading tablespace information from the. [[email protected]_mgr1 7_0_31]$ 120816 7:27:51 [Warning] No argument was provided to –log-bin, and –log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed. 120816 7:27:52 [ERROR] Fatal error: Can’t open and lock privilege tables: Table ‘mysql. Plugin’ doesn’t exist
120816 7:27:51 [ERROR] Can’t open the mysql. Ibd files
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: Doing recovery: scanned up to log sequence number 0 44233
120816 7:27:51 InnoDB: Starting an apply batch of log records to the database
InnoDB: Progress in percents: 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
120816 7:27:52 InnoDB: Started; log sequence number 0 44233
120816 7:27:52 [Note] NDB: NodeID is 55, management server ‘192. 0M
120816 7:27:51 InnoDB: Completed initialization of buffer pool
InnoDB: Log scan progressed past the checkpoint lsn 0 37356
120816 7:27:51 InnoDB: Database was not shut down normally. 7:1186’
120816 7:27:52 [Note] NDB: NodeID: 55, all storage nodes connected
120816 7:27:52 [Note] Starting Cluster Binlog Thread
120816 7:27:52 [Note] Recovering after a crash using ndb_mgr1-bin
120816 7:27:52 [Note] Starting crash recovery
120816 7:27:52 [Note] Crash recovery finished. 120816 7:27:51 [Note] Plugin ‘FEDERATED’ is disabled. Please use ‘–log-bin=ndb_mgr1-bin’ to avoid this problem. InnoDB: Starting crash recovery.
In this case the executable name is in  at the bottom, on top is the component it called, and so forth until TCP/IP was reached. In some cases well-known executables host multiple independent components, and in these cases the sequence of components involved in creating the connection or listening port is displayed. Note that this option can be time-consuming and will fail unless you have sufficient permissions. -b Displays the executable involved in creating each connection or listening port.
The first partition on the first drive is referred to as hda1, the second as hda2, the third as hda3 etc. IDE uses separate ribbon cables for primary and secondary drives. IDE drives are referred to as hda for the first drive, hdb for the second etc. The partitions on each drive are referred numerically.
Once you’ve edited your config. Then restart each of your data nodes in turn (wait for the 1st data node to come back up before restarting the next one to avoid an outage) – do *not* use the –initial option when starting the data nodes unless you want to remove all of your data. Ini file, shut down the ndb_mgmd process and then start it again with the –initial option.
Installing a new package with up2date: up2date package-name
The package name is given without the version number. If the package is not currently installed, it will be downloaded and installed, along with any dependencies that package requires.
Sh, opmnctl, lsnrctl) and get message like “unable to bind port ” (Most probably this port is in use by other process), fix is to either start your service on different port or terminate process listening on that particular port using kill -9 . If you are trying to run any apps service (adapcctl.