errors when moving from Win2003 to Linux

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Guest

errors when moving from Win2003 to Linux

Post by Guest » Thu 10 Nov 2005 05:53

Hi

We get the fowling exception when we move our Database from a Windows2003 (PostgreSQL 8.1beta4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)) server to a Ubuntu server 5.10 .

(PostgreSQL 8.1.0 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13))

We use pg_dump and pg_restore to do it.


This also happen on PostgreSQL version 8.0.4.

Any ideal what the problem may be?


Message...
timestamp out of range

Detail Message...

Hint...

Error Code...
22008

Procedure Name...
timestamp_recv

Position...
0

Line Number...
194

File Name...
timestamp.c

Target Site...
Int32 Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)

Call Stack...

Stack Trace...
at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table, DatabaseType DB)

at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table)

at HS.Definitive.BT.Dev.TrackerDD.UpdateIssue()

at HS.Definitive.PT.Dev.Tracker.IssueDlg.SaveRecord(Boolean Close)

at HS.Definitive.PT.Dev.Tracker.IssueDlg.Toolbars_ToolClick(Object sender, ToolClickEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)

at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()

at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)

at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)

at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)

at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)Message...

timestamp out of range



Source...

System.Data



Target Site...

Int32 Update(System.Data.DataRow[], System.Data.Common.DataTableMapping)



Stack Trace...

at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)

at System.Data.Common.DbDataAdapter.Update(DataTable dataTable)

at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table, DatabaseType DB)

at HS.Definitive.BT.DAL.DataAdapterUpdate(IDbConnection ICon, IDbTransaction ITrx, IDbCommand ICmdInsert, IDbCommand ICmdUpdate, IDbCommand ICmdDelete, DataTable Table)

at HS.Definitive.BT.Dev.TrackerDD.UpdateIssue()

at HS.Definitive.PT.Dev.Tracker.IssueDlg.SaveRecord(Boolean Close)

at HS.Definitive.PT.Dev.Tracker.IssueDlg.Toolbars_ToolClick(Object sender, ToolClickEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)

at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()

at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)

at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.OnMouseUp(MouseEventArgs e)

at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)

at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsDockArea.OnMouseUp(MouseEventArgs e)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

SecureGen
Devart Team
Posts: 133
Joined: Thu 08 Sep 2005 06:27

Post by SecureGen » Thu 10 Nov 2005 09:01

Since PostgreSQL 8.1beta4 is not a release version we only work on adding support for PostgreSQL 8.1 server into PostgreSQLDirect .NET. We plan to release version of our provider that supports PostgreSQL 8.1 server after it will be available. So it is the possible problem with the last version of provider since in the new version of PostgreSQL the format of few datetime types was changed.
For now you can use the standard backup/restore procedures available in pgAdmin.

Post Reply