Home / user-251721

Marco Marsala's questions

Martin Hope
Marco Marsala
Asked: 2016-09-17 05:14:42 +0800 CST
  • 5

I'm trying to:

  1. run job A the first day of the month: 0 0 1 * *
  2. run job B the other days of the month: 0 0 2-31 * ?

Vixie cron on Ubuntu 14.02 LTS refuses the second syntax, though it seems valid according to Wikipedia and official specs:

"crontab", The Open Group Base Specifications Issue 7 — IEEE Std 1003.1, 2013 Edition, The Open Group, 2013, retrieved May 18, 2015

According to references above, the syntax 0 0 2-31 * * would run the job every day of the month as third and fifth fields are treated as OR clauses of the run condition.

ubuntu cron
Martin Hope
Marco Marsala
Asked: 2015-12-01 01:54:34 +0800 CST
  • 0

My server freezed. I restarted, and after running fsck manually, services restarted normally. I'm analyzing /var/log/messages around the time of the fault, and I found these entries:

Nov 29 22:24:27 cloud kernel: ata1: exception Emask 0x10 SAct 0x0 SErr 0x4090000 action 0xe frozen
Nov 29 22:24:27 cloud kernel: ata1: irq_stat 0x00400040, connection status changed
Nov 29 22:24:27 cloud kernel: ata1: SError: { PHYRdyChg 10B8B DevExch }
Nov 29 22:24:27 cloud kernel: ata1: hard resetting link
Nov 29 22:24:34 cloud kernel: ata1: SATA link up 3.0 Gbps (SStatus 123 SControl 300)
Nov 29 22:24:34 cloud kernel: ata1.00: configured for UDMA/133
Nov 29 22:24:34 cloud kernel: ata1: EH complete

This maybe indicating an HDD fault, but I did a SMART long test of the hard disk and this is the output:

smartctl 5.43 2012-06-30 r3573 [x86_64-linux-2.6.32-573.7.1.el6.x86_64] (local build)
Copyright (C) 2002-12 by Bruce Allen, http://smartmontools.sourceforge.net

=== START OF INFORMATION SECTION ===
Model Family:     Seagate Constellation ES (SATA 6Gb/s)
Device Model:     ST1000NM0011
Serial Number:    Z1N2D4JT
LU WWN Device Id: 5 000c50 04e008fb2
Firmware Version: PA07
User Capacity:    1,000,204,886,016 bytes [1.00 TB]
Sector Size:      512 bytes logical/physical
Device is:        In smartctl database [for details use: -P show]
ATA Version is:   8
ATA Standard is:  ATA-8-ACS revision 4
Local Time is:    Mon Nov 30 15:29:22 2015 CET
SMART support is: Available - device has SMART capability.
SMART support is: Enabled

=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED

General SMART Values:
Offline data collection status:  (0x82) Offline data collection activity
                                        was completed without error.
                                        Auto Offline Data Collection: Enabled.
Self-test execution status:      (   0) The previous self-test routine completed
                                        without error or no self-test has ever
                                        been run.
Total time to complete Offline
data collection:                (  609) seconds.
Offline data collection
capabilities:                    (0x7b) SMART execute Offline immediate.
                                        Auto Offline data collection on/off support.
                                        Suspend Offline collection upon new
                                        command.
                                        Offline surface scan supported.
                                        Self-test supported.
                                        Conveyance Self-test supported.
                                        Selective Self-test supported.
SMART capabilities:            (0x0003) Saves SMART data before entering
                                        power-saving mode.
                                        Supports SMART auto save timer.
Error logging capability:        (0x01) Error logging supported.
                                        General Purpose Logging supported.
Short self-test routine
recommended polling time:        (   2) minutes.
Extended self-test routine
recommended polling time:        ( 151) minutes.
Conveyance self-test routine
recommended polling time:        (   3) minutes.
SCT capabilities:              (0x10bd) SCT Status supported.
                                        SCT Error Recovery Control supported.
                                        SCT Feature Control supported.
                                        SCT Data Table supported.

SMART Attributes Data Structure revision number: 10
Vendor Specific SMART Attributes with Thresholds:
ID# ATTRIBUTE_NAME          FLAG     VALUE WORST THRESH TYPE      UPDATED  WHEN_FAILED RAW_VALUE
  1 Raw_Read_Error_Rate     0x000f   069   063   044    Pre-fail  Always       -       8118850
  3 Spin_Up_Time            0x0003   095   095   000    Pre-fail  Always       -       0
  4 Start_Stop_Count        0x0032   100   100   020    Old_age   Always       -       15
  5 Reallocated_Sector_Ct   0x0033   100   100   036    Pre-fail  Always       -       0
  7 Seek_Error_Rate         0x000f   084   060   030    Pre-fail  Always       -       4627909443
  9 Power_On_Hours          0x0032   073   073   000    Old_age   Always       -       24302
 10 Spin_Retry_Count        0x0013   100   100   097    Pre-fail  Always       -       0
 12 Power_Cycle_Count       0x0032   100   100   020    Old_age   Always       -       21
184 End-to-End_Error        0x0032   100   100   099    Old_age   Always       -       0
187 Reported_Uncorrect      0x0032   100   100   000    Old_age   Always       -       0
188 Command_Timeout         0x0032   100   100   000    Old_age   Always       -       0
189 High_Fly_Writes         0x003a   100   100   000    Old_age   Always       -       0
190 Airflow_Temperature_Cel 0x0022   075   064   045    Old_age   Always       -       25 (Min/Max 23/25)
191 G-Sense_Error_Rate      0x0032   100   100   000    Old_age   Always       -       0
192 Power-Off_Retract_Count 0x0032   100   100   000    Old_age   Always       -       27
193 Load_Cycle_Count        0x0032   100   100   000    Old_age   Always       -       29
194 Temperature_Celsius     0x0022   025   040   000    Old_age   Always       -       25 (0 20 0 0 0)
195 Hardware_ECC_Recovered  0x001a   105   099   000    Old_age   Always       -       8118850
197 Current_Pending_Sector  0x0012   100   100   000    Old_age   Always       -       0
198 Offline_Uncorrectable   0x0010   100   100   000    Old_age   Offline      -       0
199 UDMA_CRC_Error_Count    0x003e   200   200   000    Old_age   Always       -       0
240 Head_Flying_Hours       0x0000   100   253   000    Old_age   Offline      -       169642618276709
241 Total_LBAs_Written      0x0000   100   253   000    Old_age   Offline      -       3860229105
242 Total_LBAs_Read         0x0000   100   253   000    Old_age   Offline      -       1373595990

SMART Error Log Version: 1
No Errors Logged

SMART Self-test log structure revision number 1
Num  Test_Description    Status                  Remaining  LifeTime(hours)  LBA_of_first_error
# 1  Extended offline    Completed without error       00%     24302         -
# 2  Short offline       Completed without error       00%     24299         -
# 3  Short offline       Completed without error       00%     24298         -
# 4  Short offline       Completed without error       00%         4         -
# 5  Extended offline    Completed without error       00%         4         -

SMART Selective self-test log data structure revision number 1
 SPAN  MIN_LBA  MAX_LBA  CURRENT_TEST_STATUS
    1        0        0  Not_testing
    2        0        0  Not_testing
    3        0        0  Not_testing
    4        0        0  Not_testing
    5        0        0  Not_testing
Selective self-test flags (0x0):
  After scanning selected spans, do NOT read-scan remainder of disk.
If Selective self-test is pending on power-up, resume after 0 minute delay.

HDD was already replaced recently. Kernel version is 2.6.32-573.7.1.el6.x86_64

hard-drive
Martin Hope
Marco Marsala
Asked: 2015-11-14 17:08:55 +0800 CST
  • -1

I want to do a Bare Metal Backup of my server but I'm concerned about opened files.

My server contains many SQLite databases, and SQLite daemons are active 24/7/365. As I know, you cannot backup a SQLite database, while the daemon is active, by simply copying files, otherwise the backup will be corrupted.

I know some Bare Metal backup tools offer specific agents for some types of files, but no one offer agents for SQLite.

How the Bare Metal backup deals with opened files and with write cache?

bare-metal
Martin Hope
Marco Marsala
Asked: 2015-10-14 12:35:34 +0800 CST
  • 0

I have two 3 TB disks in hardware RAID-1 (mirroring), controller DELL PERC H310 (it is a Dell PowerEdge R420 server).

I have three partitions on the same disk.

df and fdisk commands shows the third partition as /dev/sdb instead of /dev/sda3.

I cannot understand why works in this way.

[root@ru000397 ~]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1        91G  5.6G   81G   7% /
tmpfs           7.8G     0  7.8G   0% /dev/shm
/dev/sdb        2.6T   17G  2.5T   1% /usr/local/psa

[root@ru000397 ~]# fdisk -l

Disk /dev/sda: 107.4 GB, 107374182400 bytes
255 heads, 63 sectors/track, 13054 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x0b14c924

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1       12035    96664576   83  Linux
/dev/sda2           12035       13055     8190976   82  Linux swap / Solaris

Disk /dev/sdb: 2892.7 GB, 2892660473856 bytes
255 heads, 63 sectors/track, 351679 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000
fdisk
Martin Hope
Marco Marsala
Asked: 2015-10-09 10:43:33 +0800 CST
  • -1

I'm trying to convert a VM to a physical dedicated server.

I have access to the VM OS only (CentOS 6.7). I have no access to hypervisor.

I would like to use the dd command to dump the VM disk, and then write that image with dd onto the HD of the dedicated server. To do this I will probably need to boot the server from a Live CD.

My question is: this will work? It would be better to copy all files and directories in / from one server to another with rsync?

migration
Martin Hope
Marco Marsala
Asked: 2015-09-17 02:04:48 +0800 CST
  • 2

I'm getting the error above when issuing

 isql 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;' username password -v

as root on my Linux CentOS 6.7.

The following bcp command works, so the driver should be working correctly:

bcp master.INFORMATION_SCHEMA.TABLES out OutFile.dat -S <redacted> -U user -P password

Also this command works:

sqlcmd -Sg<redacted> -Uuser -Ppassword

Also this PHP script, if run from command line as root, will return an error:

<?php
$connStr = 'odbc:Driver={ODBC Driver 11 for SQL Server};SERVER=<redacted>;DATABASE=<redacted>;';
$dbUser = '<redacted>';
$dbPass = '<redacted>';

$db = new PDO($connStr, $dbUser, $dbPass);
?>

[root@ru000397 ~]# php prova.php
PHP Fatal error:  Uncaught exception 'PDOException' with message 'could not find driver' in /root/prova.php:6
Stack trace:
#0 /root/prova.php(6): PDO->__construct('odbc:Driver={OD...', '<redacted>', '<redacted>')
#1 /root/prova.php(10): db_connect()
#2 {main}
  thrown in /root/prova.php on line 6

I already installed Microsoft ODBC Driver 11 for SQL Server for Linux (https://msdn.microsoft.com/library/hh568451(SQL.110).aspx) and unixODBC 2.3.0 without issues.

My main goal is to be able to connect to MS SQL instance via PHP PDO using ODBC.

sql-server
Martin Hope
Marco Marsala
Asked: 2015-07-06 22:46:21 +0800 CST
  • 0

I'm running the Postfix mail server ru000397.widhost.net. I'm getting some of these messages in [email protected].

The mail service is working and, obviously, there is much free space on all drivers.

Transcript of session follows.

 Out: 220 ru000397.widhost.net ESMTP Postfix
 In:  EHLO m145.gem.godaddy.com
 Out: 250-ru000397.widhost.net
 Out: 250-PIPELINING
 Out: 250-SIZE 52428800
 Out: 250-ETRN
 Out: 250-STARTTLS
 Out: 250-AUTH CRAM-MD5 DIGEST-MD5 LOGIN PLAIN
 Out: 250-ENHANCEDSTATUSCODES
 Out: 250-8BITMIME
 Out: 250 DSN
 In:  MAIL FROM:<[email protected]> BODY=8BITMIME
 Out: 452 4.3.1 Insufficient system storage
 In:  RCPT TO:<[email protected]>
 Out: 503 5.5.1 Error: need MAIL command
 In:  DATA
 Out: 503 5.5.1 Error: need RCPT command
 In:  QUIT
 Out: 221 2.0.0 Bye


For other details, see the local mail logfile

main.cf: http://pastebin.com/RCBx891e master.cf: http://pastebin.com/1HMyXzuT

Here is my df outputs:

[root@ru000397 ~]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda2        22G   20G  1.5G  94% /
tmpfs           7.8G   12K  7.8G   1% /dev/shm
/dev/sdb        2.7T  1.7T  867G  67% /usr/local/psa

[root@ru000397 ~]# df -i
Filesystem        Inodes    IUsed     IFree IUse% Mounted on
/dev/sda2        1455328   242748   1212580   17% /
tmpfs            2035051        2   2035049    1% /dev/shm
/dev/sdb       181141504 11000662 170140842    7% /usr/local/psa

Here is my message_size_limit:

[root@ru000397 ~]# postconf -n|grep message_size_limit
message_size_limit = 52428800
postfix