Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [errors]

For questions about specific error codes or messages, including troubleshooting.

0
votes
1answer
8 views

How to get useful error information from mysql command?

I'm trying to script the creation of a database with tables. I'm encountering errors but the error messages are not helpful to me because I'm a novice. I'm finding the mysql tool is providing mostly ...
0
votes
0answers
19 views

A transport-level error has occurred when receiving results from the server. Error 10054

I have been using SQL Server & Azure for almost two years with Zero problems. Now for some reason I am getting the following error when I try to connect to my Azure database from SSMS. I have ...
0
votes
1answer
72 views

Why do I receive the error message “'<column name>' must appear in the GROUP BY clause or be used in an aggregate function”?

Where am I going wrong? Why am I getting that message when I add the MAX function? The query involved: WITH references_cve AS ( SELECT vulnerability_id, reference FROM ...
0
votes
0answers
9 views

do tmpdir is cleaned up automatically

While testing a 3 node percona cluster we often get: Errcode: 28 - No space left on device After login to the servers and checking the defined tmpdir I notice that is empty and clients can connect ...
1
vote
1answer
138 views

This installation of MySQL is already upgraded to 5.7.25?

I used sudo apt upgrade and got this: E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem. So I did it and I see this for more than an hour. Setting up ...
0
votes
1answer
146 views

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

In mysqld.log I have thousands of lines like: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade So, according to virtually every post on the ...
0
votes
1answer
36 views

A AFTER INSERT trigger error for security context

A trigger has stopped working since we have changed our SQL Server to a new server. Trigger is now being corrected to point to the new location of the table on the new server. When updating fields on ...
0
votes
0answers
31 views

ERROR InnoDB: Trying to access page number .. in space .., space name…, which is outside the tablespace bounds

I am running a mysql database server (5.7) on a virtual ubuntu 16.04 host. This host collects syslog messages from my other network hosts, adds the values to a pipe and creates mysql records for each ...
1
vote
1answer
49 views

Oracle - Can't login with “/ as sysdba”, but can with “sys as sysdba”

I've been working on setting up a docker container running Oracle DB XE 18.4.0. I have the container built from Oracle's dockerfiles and it is working fine, except that I cannot login using connect / ...
0
votes
1answer
20 views

Getting error on a particular query on a table in Postgres

I am getting the following error on one query in Postgres: select * from sampletable where sample_id = 1234; Error is : ERROR: could not access status of transaction <some-id> Detail: CLOG ...
0
votes
1answer
21 views

Syntax error when trying to add columns to table in DBeaver (postgresql)

I've tried this a few different ways but every time I get a syntax error when trying to add columns to a table. I'm new to databases so it's probably something basic that I'm doing wrong, but I just ...
0
votes
1answer
42 views

Oracle 12c EM error on login

I'm trying to access an Oracle 12c EM and when I try to login it shows me a load error box with the errors that I expose below, which could be happening? Is there a possibility to reconfigure EM ...
0
votes
0answers
60 views

SQL Server Error 14013 - This database is not enabled for publication

I am trying to configure a database publication with T-SQL. use master exec sp_replicationdboption @dbname='anun', @optname=N'publish', @value = N'true'; It runs successfully and I see ...
0
votes
1answer
46 views

Oracle Internal Error [closed]

Getting oracle Internal error in oracle database 11gr2: ORA 600 [kkpogppi1] It shows everyday in incidents but whenever i check oracle logs it shows nothing and when i open problem details it ...
2
votes
0answers
100 views

The prelogin packet used to open the connection is structurally invalid

I'm getting the below error across multiple servers (SQL Server 2005, 2008, 2008r2, 2012). The SQL Servers are up to date with service packs as is the OS. These are all SQL Server Standard edition. ...
1
vote
2answers
246 views

Can't change authentication mode from Windows to both SQL Server and Windows

As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to ...
0
votes
1answer
289 views

sudo service mongod start returns error 100

I'm encountering the following error upon executing sudo service mongod start in terminal. mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; disabled;...
2
votes
2answers
168 views

Cannot connect to <instance>. A severe error occurred on the current command

Recently, and on more than one occasion now, we have attempted to connect from one of our SQL Server instances to another using SSMS only to be greeted with the following error: A severe error ...
0
votes
2answers
58 views

GROUP BY clause / Aggregate function error [closed]

I am having a problem creating a Table View: DROP VIEW IF EXISTS product_variation_stock_view; CREATE VIEW product_variation_stock_view AS SELECT product_variations.product_id AS ...
1
vote
1answer
102 views

What will happen with MySQL transaction if one of the queries fails?

I have 500 independent insert queries. I put them in a transaction to run faster. I am runing queries with PHP. What will happen if one of queries fails? Will the transaction be rolled back ...
0
votes
0answers
94 views

SQL Server logs “blob data”, viewable with journalctl

What does it mean when I run journalctl -u mssql-server.service and it says B blob data, Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine... Sep 06 17:34:44 x230 ...
1
vote
1answer
50 views

SQL Batches and the GO command: which parts of my script failed?

I executed a script that had multiple sections, separated by the GO command, something like this: Use DB1 GO ALTER TABLE foo ADD bar VARCHAR(10) NULL UPDATE foo SET bar = 'nananana' ALTER TABLE foo ...
-3
votes
2answers
511 views

Conversion failed when converting the varchar value to data type int [closed]

declare @targetnumber int declare @numberfield varchar(20) = 'stepnum' declare @sourcetable varchar(20) = 'tblsteps' declare @idfield varchar(20) = 'stepid' declare @recid int = 3 set @...
0
votes
2answers
246 views

raise an error in sql server severity higher than 18

I can easily raise user defined errors where severity is not higher than 18. When is higher, I get this error Error severity levels greater than 18 can only be specified by members of the ...
0
votes
1answer
69 views

With PostgreSQL getting ERROR: COPY format “CSV” not recognized

Whever I try to copy from test=# \COPY table FROM 'file.csv' WITH ( FORMAT 'CSV', HEADER true ); ERROR: COPY format "CSV" not recognized What's the reason for this? I know I've used this before.
2
votes
0answers
291 views

Very Sporadic Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server

OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 19 Cannot ...
0
votes
1answer
113 views

SSMS 17.8.1 Error: Accessing SQL Server logs

I am experiencing an error when I am trying to access the SQL Server Logs through SSMS 17.8.1 for SQL 2017. I click to expand the SQL Server Log folder in SSMS and I get the following error. How can ...
0
votes
1answer
83 views

Oracle 9i import error IMP-00017: following statement failed with ORACLE error 3113

I try to import a schema in my database 9i of copy which is a clone of the original from where I made the export 9i also and when trying to import the schema after many hours gives the following error:...
0
votes
2answers
211 views

mySQL - Cannot add Foreign Key Constraint [closed]

I'm trying to add a foreign key constraint but, mySQL is not taking it. No detailed error, just Cannot add foreign key constraint Here is my code from an export dump... thanks for any assistance -- ...
-2
votes
1answer
468 views

Varchar Overflowed an Int Column [closed]

I am having an error with the following query: SELECT scp.phone, scp.extension, scf.fax, sce.email FROM supplier_contacts AS sc LEFT OUTER JOIN supplier_contact_phone AS scp ON sc....
2
votes
2answers
1k views

Error 1242: Sub query returns more than 1 row and problem with repeating an if statement for all rows

So I've just started learning MySQL with a few exercises and I'm currently stuck at these 2 problems. Since this is technically an exercise I'd really appreciate hints instead of full solutions. Here ...
1
vote
1answer
75 views

Mysql 5.7 cannot start again

For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04. I installed MySQL 5.7, it worked great for a couple of days ...
2
votes
1answer
62 views

SQL Server: Failed to monitor external signals

This program has encountered a fatal error and cannot continue running. The following diagnostic information is available: Reason: 0x00000007 Message: Failed to monitor external signals ...
1
vote
1answer
443 views

Getting generate_series(date, date) does not exist

When I run commands like this, SELECT * FROM generate_series('YESTERDAY'::date, 'TODAY'::date); SELECT * FROM generate_series('YESTERDAY'::timestamp without time zone, 'TODAY'::timestamp without time ...
0
votes
0answers
160 views

Error authenticating proxy

I'm trying to schedule an SSIS packages through SQL Server Agent and am aware that a proxy account may need to be created to simulate an AD user with the relevant permissions to access any given file. ...
-1
votes
1answer
119 views

'INTERVAL' is not a recognized ODBC date/time extension option

According to this docs on Interval Literals, this should be a valid INTERVAL, SELECT {INTERVAL '326' YEAR(4)}; But when I try that on dbfiddle, I get, Msg 155 Level 15 State 1 Line 1 'INTERVAL' is ...
2
votes
1answer
419 views

How can I track down what's filling my 'tempdb' transaction log?

We have a large and fairly well tuned SQL Server 2016 Enterprise Edition. Given the number of cores we have, our tempdb is currently comprised of 16 2,950 MB files running on a ram disk with a 16 GB ...
0
votes
1answer
140 views

Error code is 0x80131500 when applying SP4 to SQL Server 2012

This is an open request for any thoughts, advice or guidance about an issue I have while attempting to apply SP4 to a SQL Server 2012 installation. The server is currently the secondary node of a two-...
2
votes
0answers
93 views

understanding mysqlslap concurrency

I have a RDS instance running in AWS. By default max_connections=45 so I used mysqlslap to see how it works. I ran: mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds....
2
votes
1answer
572 views

What is the HY number (HY000) in MySQL Error messages?

When I get an error some of them have an HY code, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") What is HY000 ...
0
votes
0answers
34 views

Send mail with error message returned from stored procedure

In this code, the proc2 will generate an error. How can I send an email with the error message using sp_send_dbmail if any of the stored procedure fails? -- procedures to test with create proc ...
1
vote
1answer
317 views

What does [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'WIN-443PT0LULQU\Administrator', error code 0x534

I'm going slightly nuts. I'm a programmer by trade - and I only dabble in NT security and DB setup issues. However, we had a server fail to reboot after a MS Update. I've restored the entire ...
-1
votes
1answer
322 views

postgres ERROR: target lists can have at most 1664 entries SQL state: 54000

In my query, I want to have more than 1700 columns but I got this error: "ERROR: target lists can have at most 1664 entries SQL state: 54000" I'm using postgres10 on Windows. Has anyone come ...
1
vote
1answer
124 views

Mariadb Galera cluster empty set

I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand. [mysqld] bind-address=0.0.0.0 [galera] wsrep_on=ON wsrep_provider=/usr/lib64/galera/...
0
votes
0answers
15 views

Conversion Failed From nvarchar to int even when all values in result set are int [duplicate]

Take the following SQL sample: Declare @Table Table (Value int) Insert Into @Table Select intValueAsVarcharType From OtherTable Where Category = 'Type1' The OtherTable.intValueAsVarcharType ...
1
vote
1answer
1k views

Timeout expired error. Is it because of a query or server settings?

I am getting SQL Server timeout error in my production server, every hour (~ for 5 minutes or more) during night time. This SQL server database is supporting a .NET application. I have scheduled an ...
0
votes
0answers
41 views

Network ACL - Which log to check what CN is the DB blocking

Pulling my hair on this issue. Getting ACL error (ORA-24247: network access denied by access control list (ACL)). Followed Oracle advised steps and also listed on many helpful blogs to add the ...
0
votes
1answer
105 views

RMAN restore error;. expected sequence# 211287 doesn't match 211311 during recover

Oracle version = Oracle 8i (817_312) //Yes I know this is old. Database id = LED OS = Solaris 8 Oracle USERID = oraled Oracle DBA group = dba I an mot a DBA, but a UNIX/Linux System Administrator ...
0
votes
0answers
27 views

SQL Server: catch every error within a database into error table

I wonder how do I hook a certain database in SQL Server in a way that every error that is being thrown, and no one catches, will be caught and saved into an error_table in my database. Thanks.
1
vote
2answers
59 views

Cleanup Error Messages in SQL Server ERRORLOG

The SQL Server's ERRORLOG file has a lot of messages like the following in AG in publisher (primary) as you know that distributor is out of AG Server. Subscriber is in another AG setup. Logon ...