SelectEtoile : Base de connaissance SGBD

Posts Tagged 'linux'

Visualisation device sous Linux

Visualisation des rawdevices sous LINUX

 

Visualisation de la correspondance des rawdevices :

cat /etc/sysconfig/rawdevices

 

Visualisation du rawdevice raw19

1ère Méthode : Commande blockdev

blockdev --getsize /dev/raw/raw19

41943040

 

C’est en secteur (512 octets).

 

Ce qui donne en scriptant :

for RAW in `ls /dev/raw/*`

do

SIZE=`expr $(/sbin/blockdev --getsize ${RAW}) / 2048`

echo "Taille de ${RAW} : $SIZE Mo"

done

 

2ème Méthode : En utilisant le fichier /proc/partitions

 

Lancer la commande 'raw -q /dev/raw/raw19'

/dev/raw/raw19: bound to major 253, minor 34

 

Et chercher ensuite le device avec major 253 et minor 34 dans /proc/partitions :

253    34   20971520 dm-34

Exprimé en Ko…

 

3ème Méthode possible

raw -q /dev/raw/raw19   | awk ' system("cat /proc/partitions | grep " substr($5,1,length($5)-

Stack Trace et Engine exited with signal 11

Symptôme:

Le serveur démarre, tout semble normal. Mais dès que les premières connexions arrivent, le serveur tombe. Dans l'erreur log, on trouve ces petits mots doux.

0:00000:00000:2010/06/14 17:03:57.80 kernel  Task with kpid 3d003d running on failed engine
00:00000:00000:2010/06/14 17:03:57.80 kernel  Engine exited with signal 11
00:00000:00000:2010/06/14 17:03:57.81 kernel  kpenginedied: killed kpid 3997757 which was running on engine 4
00:00000:00000:2010/06/14 17:04:34.71 kernel  engine 5, os pid 8128  exited
00:00000:00000:2010/06/14 17:04:34.71 kernel  Process 8128 exited with status 0
00:00000:00000:2010/06/14 17:04:34.71 kernel  Task with kpid 400040 running on failed engine
00:00000:00000:2010/06/14 17:04:34.71 kernel  Engine exited with signal 11
00:00000:00000:2010/06/14 17:04:34.71 kernel  kpenginedied: killed kpid 4194368 which was running on engine 5
00:00000:00000:2010/06/14 17:27:51.02 kernel  engine 2, os pid 8107  exited
00:00000:00000:2010/06/14 17:27:51.03 kernel  Process 8107 exited with status 0
00:00000:00000:2010/06/14 17:27:51.03 kernel  Task with kpid 4c004c running on failed engine
00:00000:00000:2010/06/14 17:27:51.03 kernel  Engine exited with signal 11
01:00000:00000:2010/06/14 17:27:51.04 kernel  Current process (0x4d004d) infected with signal 11 (SIGSEGV)
01:00000:00000:2010/06/14 17:27:51.05 kernel  Address 0x0x00000000018a5520 (lock_address_verify+0x30), siginfo (code, address) = (1, 0x0x00000000000077e0)
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x0000000001673b95 pcstkwalk+0x30()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x0000000001673989 ucstkgentrace+0x199()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x000000000162cede ucbacktrace+0x40()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x000000000074aa0c terminate_process+0xa7c()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x0000000001654755 kisignal+0x255()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x00000000018a5520 lock_address_verify+0x30()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x00000000013343c7 astc_lastchance_taskcleanup+0x8e()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x000000000074a9ef terminate_process+0xa5f()
01:00000:00000:2010/06/14 17:27:51.05 kernel  pc: 0x00000000010da9ad terminator+0xb()
01:00000:00000:2010/06/14 17:27:51.05 kernel  end of stack trace, kernel service process: kpid 5046349
00:00000:00000:2010/06/14 17:27:51.05 kernel  kpenginedied: killed kpid 1900573 which was affinitied to engine 2
00:00000:00000:2010/06/14 17:27:51.06 kernel  kpenginedied: killed kpid 4980812 which was running on engine 2
03:00000:00000:2010/06/14 17:46:42.61 kernel  Engine 0 (os pid 8067) has died, server is performing emergency shutdown
07:00000:00000:2010/06/14 17:46:42.61 kernel  Engine 0 (os pid 8067) has died, server is performing emergency shutdown
03:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x0000000001673b95 pcstkwalk+0x30()
03:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x0000000001673989 ucstkgentrace+0x199()
03:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x000000000162cede ucbacktrace+0x40()
03:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x000000000163b9de keipanic+0xff()
03:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x00000000019645c0 kpsched+0x5e0()
03:00000:00000:2010/06/14 17:46:42.61 kernel  end of stack trace, kernel service process: kpid 2752554
03:00000:00000:2010/06/14 17:46:42.61 kernel  ueshutdown: exiting
03:00000:00000:2010/06/14 17:46:42.61 kernel  os_notify_process: kill failed.  pid 8067 No such process
03:00000:00000:2010/06/14 17:46:42.61 kernel  Abnormal exit detected - ASE process level execution bindings will be cleared on startup.
07:00000:00000:2010/06/14 17:46:42.61 kernel  pc: 0x0000000001673b95 pcstkwalk+0x30()
01:00000:00000:2010/06/14 17:46:42.61 kernel  Engine 0 (os pid 8067) has died, server is performing emergency shutdown
07:00000:00000:2010/06/14 17:46:42.62 kernel  pc: 0x0000000001673989 ucstkgentrace+0x199()
07:00000:00000:2010/06/14 17:46:42.62 kernel  pc: 0x000000000162cede ucbacktrace+0x40()
07:00000:00000:2010/06/14 17:46:42.62 kernel  pc: 0x000000000163b9de keipanic+0xff()
07:00000:00000:2010/06/14 17:46:42.62 kernel  pc: 0x00000000019645c0 kpsched+0x5e0()
07:00000:00000:2010/06/14 17:46:42.62 kernel  end of stack trace, kernel service process: kpid 3276850
01:00000:00000:2010/06/14 17:46:42.69 kernel  pc: 0x0000000001673b95 pcstkwalk+0x30()
01:00000:00000:2010/06/14 17:46:42.70 kernel  pc: 0x0000000001673989 ucstkgentrace+0x199()
01:00000:00000:2010/06/14 17:46:42.70 kernel  pc: 0x000000000162cede ucbacktrace+0x40()
01:00000:00000:2010/06/14 17:46:42.70 kernel  pc: 0x000000000163b9de keipanic+0xff()
01:00000:00000:2010/06/14 17:46:42.72 kernel  pc: 0x00000000019645c0 kpsched+0x5e0()
01:00000:00000:2010/06/14 17:46:42.72 kernel  end of stack trace, kernel service process: kpid 2490406

Platforme/Version

Linux RHEL5 / ASE 15.0

 Résolution:

 C'est un prés-requis d'installation.

Pour un Linux RHEL5

  export LD_POINTER_GUARD=0

Pour Suse10

 export LD_POINTER_GUARD=1

 

Sybase IQ dump cross paltform

Migration cross-platform IQ

 Lorsque l'on recharge une base IQ via une sauvegarde sur une instance installée sur un OS différent de la source. Il n'y a pas comme sous ASE de procédure ou de commande à utiliser pour valider l'opération après le rechargement.

 La seule condition est que les plateforme ai le même endian. Pour s'assurer que la migration est possible,il faut vérifier dans la documentation officielle de Sybase: Installation and Configuration Guilde, Chapitre 4 Migrating across hardware platforms.

Il y a deux groupes: big endian et little endian. Et bien évidement, si les deux plateforme sont dans le même groupe, la migration est possible. Si par malheur ce n'est pas le cas, il va falloir passer par des transfert, fichier plat... 

Il y a une particularité pour Linux 126 32 bits (cf à la doc).

 Les étapes de la migration sont décrites dans le guide de migration.