11-03-2017
Server closed the connection unexpectedly
Hi,
I have a bash script which connects HP Vertica DB and executes few sql files in sequential manner. One sql file has commands related to one table(stage , base schema tables)and contains 7-8 commands such as creating temp table, inserting data into tables etc.
For few tables, which have high volume of data, I'm facing a weird issue.
For those tables, the sql file execution happens partially and returns the below error :
"server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. connection to server was lost "
However, in database there are no errorful transactions. Even the query(during which error was returned) completed normally in database side.
Also, the next sql file in the sequence is picked up for the execution normally.
If i execute the same sql file directly inside DB, no issue comes.
Anyone can help identifying the issue?
Thanks in advance
10 More Discussions You Might Find Interesting
1. Cybersecurity
"421 service not available, remote server has closed connection."
I tried to do ftp to one of the unix server .
ftp hostname
password
It get connects when i do any command it throws error
ftp> ls
"421 service not available, remote server has closed connection." (1 Reply)
Discussion started by: vishaldsh
1 Replies
2. UNIX for Advanced & Expert Users
Hey when trying to connect to a server using a key I get
sftp -o 'Port=22' -o'IdentityFile=/home/datatel/.ssh/id_dsa_xei' becker_xei@host Connecting to host...
ANGEL SFTP ServerConnection closed by host
Connection closed
Any ideas? (1 Reply)
Discussion started by: ed.browne
1 Replies
3. UNIX for Dummies Questions & Answers
Hi Everyone,
Good day.
Scenario:
2 unix servers -- A (SunOS) and B (AIX)
I have an ftp script to sftp 30 files from A to B which happen almost instantaneously i.e 30 sftp's happen at the same time.
Some of these sftp's fail with the following error:
ssh_exchange_identification: Connection... (1 Reply)
Discussion started by: jeevan_fimare
1 Replies
4. Solaris
Hi ,
when i try to passwordless connection login in ssh through putty, i am getting the "Server unexpectedly closed network connection" error.i have already finished the public and private key settings for the particular user.
thanks
MaroV (1 Reply)
Discussion started by: vr_mari
1 Replies
5. HP-UX
Hi,
Have anyone seen this problem, there is one remote side where their ftp connection to our server will always fail with connection closed by remote host and the second connection will be working.
is this an OS issue or network issue?
Thanks
Robert (4 Replies)
Discussion started by: robertngo
4 Replies
6. UNIX for Advanced & Expert Users
Hi
how can do why a process closed a connection?
# lsof -i tcp:8080
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
java 5851 tomcat 29u IPv6 73216185 TCP *:webcache (LISTEN)
# telnet localhost 8080
Trying 127.0.0.1...
Connected to localhost.localdomain (127.0.0.1).... (0 Replies)
Discussion started by: lain
0 Replies
7. UNIX for Advanced & Expert Users
Hi
i am running a rsync between two remote servers but it errors.
The rsync command is a follows
rsync -aWv -e rsh --stats progress --delete --ignore-errors --exclude .DS_Store --exclude .HSancillary --exclude .HSxmap --exclude .HSResource /raid1/PRODUCTION/ ... (0 Replies)
Discussion started by: treds
0 Replies
8. AIX
Hi i am trying to do ssh without password between 2 aix servers.
before i generate the keys, i am able to do the ssh & it is asking for password & i am able to login.
========================
# ssh 172.29.150.77
root@172.29.150.77's password:
========================
but when i generate rsa... (1 Reply)
Discussion started by: makarand.bhatka
1 Replies
9. UNIX for Advanced & Expert Users
Solaris 10 Server refuse to connect :wall:
fork: Resource temporarily unavailable , server unexpectedly unavailable network connection , refuse error, disconnect message, fatal error type2, (protocol error type2)
Issue has been resolved after taken few steps :b:
First of all need to check... (1 Reply)
Discussion started by: taherahmed
1 Replies
10. UNIX for Advanced & Expert Users
Hi everybody,
I am running a program on a supercomputer via my personal computer through a ssh connection. My program take more than a day to run, so when I left work with my PC I stop the connection with the supercomputer and the program stop.
I am wondering if someone know how I can manage... (2 Replies)
Discussion started by: TomTomGre
2 Replies
LEARN ABOUT DEBIAN
sqlobject-admin
SQLOBJECT-ADMIN(1) General Commands Manual SQLOBJECT-ADMIN(1)
NAME
sqlobject-admin - manage your database as defined with SQLObject classes
SYNOPSIS
sqlobject-admin [options] command
DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes.
Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the
database to match the version of the schema in your code.
COMMANDS
The following commands are recognized:
help
Show the help text.
create
Find the tables and create them. Existing tables are simply skipped.
sql
Show the SQL to create all the tables.
drop
Drop tables. Missing tables are skipped.
execute
Execute an arbitrary SQL expression.
list
List out all the found classes.
status
Show if tables are present in the database.
record
Record historical information about the database status
upgrade
Update the database to a new version (as created by record)
OPTIONS
-c CONNECTION, --connection=CONNECTION
Connection string for the database .
-f FILENAME, --config-file=FILENAME
Configuration file from which to get the connection to the database.
-m MODULE, --module=MODULE
A module to look in for classes.
-p PACKAGE, --package=PACKAGE
A package to look in.
--class=CLASSMATCH
Restricting the found classes to the matching classes.
--egg=EGG_SPEC
Egg description that should be loaded.
AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>.
LICENSE
This package is licensed under the GNU Lesser General Public License. You can
find the full text of the LGPL in /usr/share/common-licenses/LGPL in your
Debian system.
06/03/2010 SQLOBJECT-ADMIN(1)